Myths on Maps

So far, here's what's important to remember/problems I've encountered:
Searches are done with: %Creon%
Default Place is "a cave in Cyllene", no "blank" option
When I go to add an event, there's a space already entered; it's not a big deal, but it's weird.
It would be really useful to have a way to associate characters and groups with events. Especially in battles, where The Thebans fight The Athenians, and you can't cross-reference who was in what group to associate them with that event.
Has the option of adding a generic oracle as a character been discussed? Often "an oracle predicts" something, and it's important, but it's a random floosy in a cave, so we don't have her as a character. Is this an option?
Just a note, with character-character, if the entry is Sally Suzie Mother, it means Suzie is a mother to Sally.
I can't add citations to the Event/Character/Citation or Group/Character/Citation tables, but I can for the Character/Character/Citation table nor can I manipulate the Event/Place table. Don't know why. Greg fixed it!

I'm finding that the garish colour scheme of the maps-for-free tiles are a bit much for this application. Points, in any colour combination tend to get lost in the intense range. So, I've been fiddling with some setting in the GIMP, and I have a more subdued scheme to try out.
I need a script (imagemagick?) that will adjust the tiles thusly:
In the GIMP > Colours > Hue-Saturation dialog, I made the following adjustments:
Master: sat=-25, hue=15
R: sat=-45, light=20, hue=1-
Y: sat=-35, light=45
G: sat=-50(-80 light=18)
C: sat=-45 (overlap=40)
B: sat=25, light=-10
and I think it looks better at least.

Now, I need to script something that will troll through all 17 million images and adjust each one with these settings...

The basic search page is at a point where you can search for something arbitrary and get back a count (e.g. 4 characters, 1 place, 0 events and so forth). Clicking the counts does another query and brings back the details.

Next up is to add functionality to either build a kml file from individual items in the results or add each clicked item instantly to the map using the symbol code in openlayers. More work needed there.

I have a buggy details search going now, but no time to finish it.
The file I'm working on is test_search.php and it should have enough pointers in it to get me going when I get back.
I'm part way through characters and places, and although the php generates functional sql (I can copy/paste the sql in to phpmyadmin and it runs) I get garbage echo'd to html.
I'm on the right track, though.

I now have a very basic search page that will allow you to do a count on search terms.
Running a search will only produce a count of how many characters, places and so forth are in the DB.

I can't decide whether I should leave it at that or try to make something that returns actual values.
If not, I need to adjust the SQL in search.php to check for different GET values and run either a COUNT or a regular query.

Argument for keeping this page a count only is that some results are not immediately plotable on a map, and I should only allow maps where there are locations involved. Therefore, when users click on a link (like "3 locations") they'll get a map.

I can see that this might get messy, though, so I need to think about this a bit before barging in to the code.

I've got the bigger bugs ironed out of the query code and the map is happily running its ajax queries, and no more bizarre problems.

Thought:
When two locations overlap, how to allow each of them to be clickable? We *could* just move one over a bit, but the likely case is that a city like Ilissus is inside of a region (like the Thriasian plain).

I've got a rudimentary (and buggy) map here: http://hcmc.uvic.ca/grs/map/

With Martin's help I got some ajax features working, but inexplicably, certain places "don't work". e.g. If you click on Troy you'll get the list of options. Click on Citations and you'll see a long list. Click on Tenedos - same thing. Now, click on most other places. Nothing. I run the query manually and it works. This way - nothing.

Can't complain. I've made some good progress in the last couple days.

I have Martin's ADB set up with all data now accessible and editable. I made a couple of changes to his code though.

in js/gui.js I changed the style info:

function highlightRow(sender){
  if (lastHighlightedRow != null){
    lastHighlightedRow.style.backgroundColor = '';
  }
  sender.style.backgroundColor = '#e0e0ff';
  lastHighlightedRow = sender;
}

to:

function highlightRow(sender){
  if (lastHighlightedRow != null){
    lastHighlightedRow.style.backgroundColor = '';
  }
  sender.style.backgroundColor = '#8894AA';
  sender.style.color = '#FFFFFF';
  sender.style.fontWeight = 'bold';
  lastHighlightedRow = sender;
}

and in db/db_recordlist.php I adjusted how the "Action" table cell was formatted by moving the
from after the first button to after the word "Action"

The stylesheet has also been modified.

I'm going to try to make it easy on editors by offering two "views" of certain data such that, say, viewing the Event/Character data only shows one instance of an event, with a list of associated characters. To add a citation, editors will need to go to a different tab and add citations to each event-character relationship. In the latter case, each event will show up once for each character associated with it, along with a citation.

I am trying to come up with a sample list of composite events that equal a journey (like Hercules killing the Nemean Lion), and that then combine to form an uber-journey (his Twelve Labours). I have included side trips as well that are part of the uber-journey.
I also checked through the character-character table, and the character-group table, and saw no huge programmatic errors.