DOH!
I feel so cheap and used!

Thank you, works great.

Well, no I see the Event Attendabce option, but underneath it says
"Add characters to your profile to singup for this event. "

I have and the WoW Character and WoW rooster all see me, but not here?

Is the event server and the server your chars are on the same?

wow, twice I am a fool............ good catch!

A little swamped at work this week, my usual place I slack off and code, I am reading the thread and making notes.

Ok there is an issue I am running across on my boards. It seems to be a display issue only, if you have multiple events on the same day it spans the sign up across all the events on that day. if however you look at the events individually the sign ups are correct. This only happens if you look at the view for the entire day.

Been working with this for a while and it suffers from one of the major failings of the previous version by Elricstorm. It doesn't cache the character data so that it can be reused across all events. All the information about race, gender, class, stats, professions and such does not belong in this table. It should be in the gwowroster_charinfo table or a gwowcharinfo table.

Then you can use a charid field to join that table with the event table. This means that every single page load of the different events can pull the information from the local database if it exists and not have to try and access the armory. Normalizing the database like this would lessen the impact on the armory and the local site while providing faster screen draws and access to the information.

I know you meant for the two addons to be completely separate but that doesn't mean data and resource management can't be smart. Aside from this one issue, it is a good upgrade to the other one. It gives me a better base to do what I want. I am currently rewriting the tables, character caching cron and retrieval plugins to manage data easier. I am also going code to handle non-guild members signing up for events and to have their information cached via cron as well. Once done, I can send you all the changes if you would like.

When my brain recovers from the shift to 3rd shift working, i planned on making some type of API to access and cache character data for my mod, https://vborg.vbsupport.ru/showthread.php?t=169389

Thanks Wayne, I understand what you are saying. I wouldn't mind taking a look. I have a half cocked plan for why it is done this way as I wanted historical data per event so that 6 months after a deadmines event doesn't show level 70 attendees. I wanted to display the stats they were at the time of the event for a later addition to this mod. I realize now this can be done a little differently.

Well my goal is a little more involved. I am going to use this as a base to recreate most functionality of WoWRoster (not to be confused with your addon of a similar name). My guild wants stuff similar to that including the signature generator. However I want it cached locally so I can update from the Armory in off-peak periods.