Nice feature, well done

I launch you a feature request : -)

What "should" be done...
From what I understood, you insert the entries as lines with an ID.
This ID can be used, but its merely an index [0..100] for the IG line entries.
Forget about these ID’s, or add them to the lines that are the most recent ones, like that, they correspond with the IG values.

What about this approach, in pseudo code:
Get the table (the 100 or less lines) from CP.lua
Find the last (from time point of view) line in your SQL table
Find the next, more recent line, in the CP.lua array – that isn’t in the SQL table.
Add all new values from CP.lua to SQL table from there.

Like this, the GuildHistory table will grow in time, and becomes a persistent Guild History log.

Better add an admin section that enables stripping for the last xx days (months) or xx max entries in the GuildHistory SQL table (or even both option for busy Guilds).
Or: let the table grow, but retrieve only the last XX lines at max for showing purposes.
This should be done because many shared web serves only offer 32 Mb of memory, and I already have a player with more then 6000 PvP logs => the server explodes when SELECTing that one ^^

Hey tuigii,

nice ideas

At the moment the guildhistory is limited to 100 entries (the 100 from cp.lua) but the idea, to add these lines and get a big history log is good. I will do a recode (at the moment the update hook can´t handle it) and add more configuration options in roster configuration panel (like default sorting, max lines to display). And possible a search function.

Maybe i write this addon as a calendar (like the frontend from our event management system @ http://events.wowroster.de).

When i used a calendar application, i can fetch only the records from the month who´s displayed.

Nefuh

And possible a search function.

This can be built right into the an addon search class which will auto load with roster and allow searching with in the main roster search function.
When building the class you will need to create a file {roster_dir}/addons/{addon_name}/inc/search.inc.php and if you need to get an idea on how to build this class you are welcome to take a look at the news, memberslist, or questlist search files which not only include a addon search but also have and allow advanced searches to narrow the search down along with custom formatting. The only thing that is currently missing from our search ability's is auth which is being worked on or atleast being thought out.