EverQuest Roster - History
Author: Michaël Schoonbrood
Version: 4.4.2


This page contains the history for the EverQuest roster, newest updates are on top.

16-06-2010 (Michaël Schoonbrood, Version: 4.4.2)

  • Added an AutoImport flag to the batch imports (Magelo and EQPlayers).

14-06-2010 (Michaël Schoonbrood, Version: 4.4.1)

  • Updated the Magelo import to support the current Magelo format.
    This includes GLPs, Endurance, TradeSkills, Keys and some flags.
    Note: Most flags remain non-working for now, as the magelo format has changed so drastically, that I can't tell which magelo flag goes with what roster flag anymore.
  • Fixed the guild tool import (public note was moved forward, it's now before the guild tribute columns).

07-06-2010 (Michaël Schoonbrood, Version: 4.4.0)

  • Fixed a bug where HP, Mana and Endurance where cut of at 32767.
  • Widened the HP, Mana and Endurance edit fields on the Modify Character form.

22-07-2008 (Michaël Schoonbrood, Version: 4.3.3)

  • Fixed a bug where Cookies where written to late (causing errors/warnings).

05-05-2008 (Michaël Schoonbrood, Version: 4.3.2)

  • Added EQPlayersID to the character modify page (only for administrators).
  • Fixed alignment issues on the character modify page.
  • Fixed and optimised the ExtractNameMainFromString() function.

23-01-2008 (Michaël Schoonbrood, Version: 4.3.1)

  • Fixed the Sort Order bug on the Character Statistics page.
  • Fixed a bug where the PreviousForm setting wasn't handled correctly.
  • An empty magelo last name will no longer be imported over a filled in roster last name.
  • Removed some redundant information from a couple of forms.
  • The footer frame should now load before the header frame.

02-12-2007 (Michaël Schoonbrood, Version: 4.3.0)

  • Updated magelo import, to support magelo's new way of connecting the last name to the first name.

28-11-2007 (Michaël Schoonbrood, Version: 4.3.0)

  • Upgraded all roster pages to include session variables.
  • Renamed all roster pages so they end in .php.
  • Updated all PHP code (stylewise).
  • Fixed a bug on the User Modify page, you no longer have to re-login after changing your Password.
  • The body frame should now always be loaded after the header and footer frame.

21-06-2007 (Michaël Schoonbrood, Version: 4.2.3)

  • Updated Magelo import to be able to import the changed magelo profiles.

16-05-2007 (Michaël Schoonbrood, Version: 4.2.2)

  • Fixed a bug where EQPlayers import didn't work from character modify form.

22-11-2006 (Michaël Schoonbrood, Version: 4.2.1)

  • Enhanced the EQPlayers import detection for profiles that have never been updated.
  • Fixed a bug where Magelo import didn't work for characters without a lastname.
  • Fixed a bug in the tradeskill record update where values could be empty instead of 0.
  • Changing the class filter will now remember the sort column and order (again).

16-11-2006 (Michaël Schoonbrood, Version: 4.2.0)

  • Added Magelo 3.0 support.
  • Added the Dreadspire Keep overview.
  • Added the Demi-Plane of Blood overview.
  • Added the Theatre of Blood overview.
  • Added pop-up descriptions to some checkboxes on the Character Modify page.
  • Added the Breakdown in Communication quest overview.
  • Added the Discord Skin Samples (Tongue) quest overview.

02-10-2006 (Michaël Schoonbrood, Version: 4.1.0)

  • Fixed sorting on the Users overview.
  • Fixed a bug in the footer, in regards to switching overviews while sorting on a column.
  • The level nr imported from an EQPlayers profile will now be stored.
  • Added the new Drakkin player race (database update).

21-08-2006 (Michaël Schoonbrood, Version: 4.0.3)

  • The users list can now be sorted on nr. of characters.

27-04-2006 (Michaël Schoonbrood, Version: 4.0.2)

  • The guild dump import does now report the correct nr of deleted members.
  • The guild dump import will now show the CharID for created characters (instead of -1).

26-04-2006 (Michaël Schoonbrood, Version: 4.0.1)

  • Renamed the DoD_Spells table to DoD_Flags.
  • Added the remaining missions for the Depths of Darkhollow quest.
  • The Update Tables form has been totally rewritten (class based).
  • Fixed a bug where EQPlayers import didn't raise certain values.

20-04-2006 (Michaël Schoonbrood, Version: 4.0.0)

  • Fixed Magelo import on Character Modify page and Batch Import. They were just 2 minor bugs, but effectively holding back full Magelo importing :)
  • EQPlayers import will now only import values that are not empty strings or bigger then 0.
  • The Guild Tool Update form has been totally rewritten (class based).
  • The Character class now has functionality to load any table into it's member variables.

14-04-2006 (Michaël Schoonbrood, Version: 4.0.0)

  • The roster now supports full and easier skinning (using the skins dir).
  • The character modify form has been totally rewritten (class based).
  • The character_modify.php file has been renamed to form_character_modify.php.
  • The guildtool_update.php file has been renamed to form_guildtool_update.php.
  • Added the character class, which handles all character data storage/retrieval (Database/EQPlayers/Magelo).

13-04-2006 (Michaël Schoonbrood, Version: 3.6.0)

  • Added EQPlayers batch import.
  • Added all the recently added tables to the Character Delete code.
  • Updated the tables script for a fresh install.
  • Updated the update_tables script to the latest table version (Endurance and EQPlayersCharID).
  • Added real skin support (with seperate subfolders for each skin).

07-04-2006 (Michaël Schoonbrood, Version: 3.6.0)

  • Added EQPlayers support (this requires a database update).
  • Fixed magelo import, no stats where ever lowered (which is definately possible with different gear).
  • Added Endurance to the Character Statistics.

27-03-2006 (Michaël Schoonbrood, Version: 3.5.3)

  • Added the file type to an error in the guild dump import (for better error handling).

25-03-2006 (Michaël Schoonbrood, Version: 3.5.2)

  • Changed the default DoN progression back to good.
  • The progression of the page you clicked edit on, should now show on the edit page.
  • The list of overviews in the footer is now sorted alphabetically.

26-02-2006 (Michaël Schoonbrood, Version: 3.5.1)

  • Fixed the transparancy in the private email icon.

23-02-2006 (Michaël Schoonbrood, Version: 3.5.0)

  • Updated the Guild Tool Update to the Prophecy of Ro release (new Banker and Alt columns).
  • Added info icons to most of the overviews.

14-02-2006 (Michaël Schoonbrood, Version: 3.5.0)

  • Added quest info to the Depths of Darkhollow Spell Missions (this might come to more pages).
  • Fixed the Magelo Batch Import in regard to GoD Flags (it was missing the 3 recently added fields).
  • The Magelo Import now imports the Omens of War Flags/Signets.
  • The Magelo Import now never turns off flags that were turned on in the roster.
  • Updated the modify_others icon (changed the colorisation somewhat).
  • The highest values on the statistics overview will now show in yellow.
    Of course, the highest roster values still show in green.

09-02-2006 (Michaël Schoonbrood, Version: 3.5.0)

  • Updated most of the icons.
  • Fixed a bug in the new footer.

08-02-2006 (Michaël Schoonbrood, Version: 3.5.0)

  • Redesigned the footer, all overviews are now in a dropdown box.

07-02-2006 (Michaël Schoonbrood, Version: 3.4.0)

  • Added the Seal: Mastery of All to the Omens of War overview.
  • Fixed the sort orders "Access" and "Immune" on the Omens of War overview.

18-01-2006 (Michaël Schoonbrood, Version: 3.4.0)

  • Re-designed the Character Modify page (more labels, most default hidden).
  • Added the Omens of War - Citadel of Anguish overview.
  • Changed the Gates of Discord layout, and added Keeper of the Altar, Ixt Hsek Syat and High Priest Nkosi Bakari.

17-01-2006 (Michaël Schoonbrood, Version: 3.4.0)

  • Fixed a bug in the magelo import, where AAs above a 1000 weren't imported correctly.

12-12-2005 (Michaël Schoonbrood, Version: 3.3.1)

  • Fixed a bug that got introduced with the tooltips, where the Class Filter always shows "All".
  • Fixed a bug on the character statistics page, where sorting on "Int" didn't work.

30-11-2005 (Michaël Schoonbrood, Version: 3.3.0)

  • Added ToolTips all through the roster.

29-11-2005 (Michaël Schoonbrood, Version: 3.2.0)

  • Added the DoD Spell progression (database upgrade).
  • The magelo import will now overwrite the Character's Level (if magelo lvl is higher then roster lvl).
  • Re-aligned the submit/cancel buttons on the character modify page.

19-11-2005 (Michaël Schoonbrood, Version: 3.1.2)

  • The magelo batch import icon is now no longer visible when not logged in.
  • The Alt Time flag will no longer be reset for users that don't show their inventory in their magelo.

14-11-2005 (Michaël Schoonbrood, Version: 3.1.1)

  • Administrators are now marked with a little star icon (on the Characters page).
  • A user will now always see all of his/her characters, even when "Show Alts" is not toggled.
  • Users can now import magelos for their characters from a link in the footer.
  • Fixed two bugs in the GLP magelo import.

02-11-2005 (Michaël Schoonbrood, Version: 3.1.0)

  • The class filter has been moved to the footer and works on all pages.

02-11-2005 (Michaël Schoonbrood, Version: 3.0.7)

  • Added the Carprin Event to the PoP Tier2 Flags.
  • Rows with an empty CharName no longer show up on overviews.
  • Added a Class filter to the Character Statistics page.

01-11-2005 (Michaël Schoonbrood, Version: 3.0.7)

  • Fixed the missing E-Mail address in the User Created message.
  • When sending an E-Mail fails, the roster now displays a link to mail the Admin for manual verification.
  • When the GuildTool_Update can't move the uploaded file, it will now import from the unmoved file.

26-10-2005 (Michaël Schoonbrood, Version: 3.0.6)

  • Users can now edit their characters on the Character Statistics page (woops?).
  • Fixed all the magelo imports that had a [DONE] tag in the magelo profile (and that's a lot!).

23-10-2005 (Michaël Schoonbrood, Version: 3.0.5)

  • Fixed the magelo Xanamech import, there was an error in the search string.
  • Fixed the magelo Keys import, the magelo tags had changed.
  • Fixed the magelo Atk value import, it was reporting the wrong field.
  • Fixed a bug in the GetCheckboxValue() function, it didn't correctly catch boolean values.
  • Raised the width of the AA field from 3 to 4 positions (database upgrade).

19-10-2005 (Michaël Schoonbrood, Version: 3.0.5)

  • Fixed the Magelo GLP Import, Magelo code had changed.
  • Fixed a bug on the Character Modify page, where it didn't remember the view settings of the Keys/PoP/DoN tables.
  • Changed the way the Character Modify page performs a Magelo Import, resulting in no more loss of data.

16-10-2005 (Michaël Schoonbrood, Version: 3.0.4)

  • Fixed a bug in the Magelo Import on the Character Modify page, this would corrupt some settings since v3.0.2.

15-10-2005 (Michaël Schoonbrood, Version: 3.0.3)

  • IMPORTANT: The ExtractNameFromString() has been moved from the functions.inc to the config.php file, and renamed to ExtractNameMainFromString(). This was done because the function can be different for each roster, and therefore belongs to the configuration.
  • The function was also totally rewritten to easier support different Main/Alt tag usage. Check the examples at the top of the function, to modify the 4 settings according to your guild.

12-10-2005 (Michaël Schoonbrood, Version: 3.0.2)

  • Fixed a bug in the Batch Magelo Import, in regards to lastnames containing a quote.
  • Fixed a bug in the Batch Magelo Import, where IE didn't update the progress correctly.

11-10-2005 (Michaël Schoonbrood, Version: 3.0.2)

  • The Import Magelo icon now appears as soon as a number is entered in the MageloNr box (character modify page).
  • Failed Magelo imports now generate an error message.
  • Added a toggle for Keepers (good) / Dark Reign (evil) DoN progression on the character modify page.
  • Added toggles to display/hide Keys/PoP/DoN progression on the character modify page.

10-10-2005 (Michaël Schoonbrood, Version: 3.0.2)

  • Replaced all the handling of SELECT queries with the array index counter instead of hardcoded values.
  • The highest column values on the character statistics page now have a different color (green).
  • The highest AA and GLP values on the characters page now have a different color (also green).
  • Admins only: Fixed a bug where tradeskills appeared in green for (to be) deleted characters.
  • Centered the Lvl, AA and GLP column on the characters page, to make them conform to the other pages.

09-10-2005 (Michaël Schoonbrood, Version: 3.0.2)

  • Added the magelo icon to the Character Statistics page.

09-10-2005 (Michaël Schoonbrood, Version: 3.0.1)

  • Added an error message to the character_modify page (on an error it just showed a black page before).
  • Fixed the magelo import of keys, some keys didn't automatically update all the substeps.
  • Fixed the magelo import of the PoD Grimror Quest, PoI Xanamech, PoV Grenic Quest flag and PoS Wembly Quest flags.

07-10-2005 (Michaël Schoonbrood, Version: 3.0.0)

  • The header and body of overviews now always display a vertical scrollbar to fix alignment problems.

06-10-2005 (Michaël Schoonbrood, Version: 3.0.0)

  • Added a Batch Magelo import (with a delay of 2 minutes between each import).
  • Fixed the Magelo import (the Atk value wasn't comming in).
  • Cleaned up the character_modify.php file, and moved the standard functions in it to the new functions_database.inc file in the includes dir.

05-10-2005 (Michaël Schoonbrood, Version: 3.0.0)

  • DoN progression is now imported from Magelo.
  • Fixed numerous bugs in the Magelo import code, in relation to PoP/GoD flags.
  • Added a PoTime Alt. Access and PoTime Access column to the PoP Tier 4 Flags overview.
  • Alternate access to the Plane of Time is now imported from the Magelo (inv. item "Time Phased Quintessence").
  • Rewrote the update_tables.php script (much easier to maintain now).
  • Added a Character Statistics overview. (major update)

03-10-2005 (Michaël Schoonbrood, Version: 3.0.0)

  • DoN progression added. (major update)
  • Fixed a bug in the header code, that made the logo appear super tiny in certain browsers.

21-09-2005 (Michaël Schoonbrood, Version: 2.2.5)

  • Fixed a bug in the Magelo import code, that prevented Shadow Knights from importing their magelo.
  • Fixed some more Compatibility issues when running on a PHP5 install (the Modify User page).

06-09-2005 (Michaël Schoonbrood, Version: 2.2.4)

  • Fixed a bug in the user verification, the EMail Address can now be 100 characters long.
  • Fixed some Compatibility issues when running on a PHP5 install (aka, it now works under PHP5).

15-11-2004 (Michaël Schoonbrood, Version: 2.2.3)

  • Fixed the bug where the Loading image didn't show on Firefox browsers.

10-11-2004 (Michaël Schoonbrood, Version: 2.2.2)

  • Added the delete characters page, for quick deletion of multiple characters.

04-11-2004 (Michaël Schoonbrood, Version: 2.2.1)

  • Added a cancel button to the GuildTool import page (where you select the guild dump file).
  • A guild tool update will automatically mark Member and Alt characters as inactive, if they have not logged on for a set period of time (default 60 days).
  • Inactive characters will be automatically marked as Member or Alt, after they have logged on again.
  • Inactive members are only shown when "Show Alts" is active.

03-11-2004 (Michaël Schoonbrood, Version: 2.2.0)

  • Added the statistics page.

02-11-2004 (Michaël Schoonbrood, Version: 2.1.8)

  • Fixed a bug in the GuildTool update.
    The Rank and NameMain where not correctly set for alts that where marked with the ALT tag.

28-10-2004 (Michaël Schoonbrood, Version: 2.1.7)

  • Fixed a bug on the VexThal overview, where the sort order of Raf and Set was reversed

13-10-2004 (Michaël Schoonbrood, Version: 2.1.6)

  • Fixed the guild tool import, adjusting it to the tab between the last tribute date and the public note

01-10-2004 (Michaël Schoonbrood, Version: 2.1.5)

  • Fixed the guild tool import to work around the current bug in the dump.
    Characters with a tribute amount > 0, have a date in front of their public note in the dump.

28-09-2004 (Michaël Schoonbrood, Version: 2.1.4)

  • Fixed the footer, so that users can modify their settings again.

24-09-2004 (Michaël Schoonbrood, Version: 2.1.3)

  • Fixed the magelo import, to read AAs and GLPs correctly again.

23-09-2004 (Michaël Schoonbrood, Version: 2.1.2)

  • Administrators can now mark any user as Verified on the Users screen.
  • Administrators can now edit any user on the Users screen.
  • Administrators can now delete any user on the Users screen.

22-09-2004 (Michaël Schoonbrood, Version: 2.1.2)

  • Initialised all numeric database fields with 0, to prevent possible errors during updates.
  • Changed all the Update functions in the Character Modify, to check wether to delete, insert or update the record.

15-09-2004 (Michaël Schoonbrood, Version: 2.1.1)

  • Updated the guild tool update, so it imports the correct fields.

09-09-2004 (Michaël Schoonbrood, Version: 2.1.0)

  • Added Research and Tinkering to the TradeSkills.
    (This change required a database update, so upgrading to v2.1.0 will require one as well).

07-09-2004 (Michaël Schoonbrood, Version: 2.1.0)

  • Replaced the user create files by the new User_Create class.
  • Replaced the user verify files by the new User_Verify class.
  • Replaced the user modify files by the new User_Modify class.
  • Moved the Show- and HideImage() funtions from the Form_Body.php to the ShowBody funtions of the classes that use them.
  • Added the functionality to Delete old characters.
    Only administrators can use this feature, on members marked as old (red in overview).

03-09-2004 (Michaël Schoonbrood, Version: 2.0.3)

  • Renamed functions.php to functions.inc and moved it to the includes dir.
  • Replaced the user login files by the new User_Login class.

23-07-2004 (Michaël Schoonbrood, Version: 2.0.2)

  • Moved all classes into the (new) "includes" directory.
  • Added a default password for the roster user (safer).
  • Some minor updates to the "update_tables.php" script (regarding user rights).

22-07-2004 (Michaël Schoonbrood, Version: 2.0.1)

  • Added the Users list to the roster, for Admins only.
  • Added the Statistics page to the roster.

22-07-2004 (Michaël Schoonbrood, Version: 2.0.0)

  • Changed update_table script, so it:
    - imports the old flags (BoT_Flag, PoJ_Trial_Flag and PoT_Flag) into the new tables
    - drops the old flag fields (BoT_Flag, PoJ_Trial_Flag and PoT_Flag) from the "KeysAndFlags" table
    - renames the "KeysAndFlags" table to "Keys"
    - renames the "BoT_Flag" table to "PoS_Askr_Quest"
  • Added all the PoP and GoD flags to the magelo import.

21-07-2004 (Michaël Schoonbrood, Version: 2.0.0)

  • PoP and GoD progression has been added (major update).
  • Footer has been enhanced with Copyright line (this line MUST be left intact).
    Leaving this line there, allows you to use the roster.

20-07-2004 (Michaël Schoonbrood, Version: 1.4.1)

  • Added the version number to the roster.
    It should always be displayed in your browsers caption bar.

19-07-2004 (Michaël Schoonbrood, Version: 1.4.0)

  • Total redesign of the code... I created a list.php, list_header.php and list_body.php file.
    These files handle the creation of a list, using a class that contains the list data.

    The following classes have been added:
    - class.bot_flags.inc (replaces: bot_flags.php, bot_flags_body.php and bot_flags_header.php)
    - class.characters.inc (replaces: characters.php, characters_body.php and characters_header.php)
    - class.keys_flags.inc (replaces: keys_flags.php, keys_flags_body.php and keys_flags_header.php)
    - class.ssra_keys.inc (replaces: ssra_keys.php, ssra_keys_body.php and ssra_keys_header.php)
    - class.tradeskills.inc (replaces: tradeskills.php, tradeskills_body.php and tradeskills_header.php)
    - class.veeshans_peak_keys.inc (replaces: vp_keys.php, vp_keys_body.php and vp_keys_header.php)
    - class.vex_thal_keys.inc (replaces: vt_keys.php, vt_keys_body.php and vt_keys_header.php)

    This redesign will allow me to add new lists to the roster, with almost no impact on the current code.
    All I have to do, is create a new class for the list, and add a link in the footer.

29-06-2004 (Michaël Schoonbrood, Version: 1.3.1)

  • Removed the "PreviousSortOrder" from the code, and replaced it everywhere by SortDirection.
    This was done to make the code behave the same everywhere, and to fix some sorting bugs.
  • Fixed the saving of the SortDirection to the cookie.
    (ASC wasn't saved correctly, because the empty SortDirection string would be skipped).

28-06-2004 (Michaël Schoonbrood, Version: 1.3.0)

  • Fixed the Cancel/Modify buttons on the character modify page.
  • Made the Character Modify screen wider (from 90% to 98% of browser width).
  • Fixed the update_tables.php. It will now perform all the upgrades since the original roster release.

27-06-2004 (Michaël Schoonbrood, Version: 1.3.0)

  • Added a Cancel button to the character modify page.
  • You can now Import your magelo values on the character modify page.

25-06-2004 (Michaël Schoonbrood, Version: 1.3.0)

  • Added the Magelo import functionality.
  • Added Flowing Thought to the roster.
  • Added Epic to the roster.
  • Fixed the bug where modifying a user would set Race to "Barbarian" and Sex to "Female".

21-06-2004 (Michaël Schoonbrood, Version: 1.2.2)

  • Members who left the guild will now only show up for administrators (in red).
  • Administrators can now edit any character on all the overviews (no longer just on the character one).
  • Fixed the bug where editing your character on any of the overviews (except the characters one) caused an empty overview to appear.
  • Fixed all overviews, so they only show old members for administrators.
  • Fixed the last few errors in the new non-frames version of the roster.
  • Added the FormatDate() function to config.php.
    You can change the output of this function to the date format you would like to see in the roster.

18-06-2004 (Michaël Schoonbrood, Version: 1.2.1)

  • Fixed the index.html, it was no longer creating a scrollbar for the guildtool_update.php.
  • Rebuild the whole roster using a stylesheet and no frames (this update is not live yet).

17-06-2004 (Michaël Schoonbrood, Version: 1.2.0)

  • Created this history page.
  • Replaced all <br> tags by the xhtml compliant <br /> tags.
  • Made all <img> tags xhtml compliant.
  • Changed all frame tags, to be xhtml compliant.
  • Removed the <hr> tags and replaced them by frame borders.

09-06-2004 (Michaël Schoonbrood, Version: 1.1.1)

  • Enhanced the Guild dump import big time.
    The page is now only accesible for administrators (bottom left icon) and will ask for a local file.
    So no more need to upload anything manually to the server.
    Just go to the page, click browse and select the file on your hard drive. Click Import and you're done
  • The administrators have also received the possibility to Edit the NameMain field of a Character.
    This makes the roster much easier in use for those who don't use the public note to store the NameMain as the first word.
  • Users using Netscape/Mozilla and Opera should now be able to do everything the IE users can, including creating/modifying users and modifying characters (javascript was missing "document." before the form/fieldnames).
  • Fixed a bug in the guild tool update that removed the link between a user and his/her characters, instead of create it (/doh)!
  • Moved all the body tags to the css file.
  • Added url styles for header/body/footer, giving the roster builder more possibilities to define the look.
  • All guild specific code is now in the config.php (previously this file was called database_config.php).
    The config.php and the roster.css are now the only 2 files a user might need to change (and backup).

01-06-2004 (Michaël Schoonbrood, Version: 1.1.0)

  • Fixed a lot of bugs in the GuildTool Update, plus added some more "smartness" to it.
  • Moved a lot of guild specific code/settings to the config file.

02-04-2004 (Michaël Schoonbrood, Version: 1.0.0)

  • Initial version

To Do

  • Add a "sorted_column" style, and use it to indicate which column is currently being sorted on.
  • Add a cookie class, and move all cookie related functions to said class.
  • Add import code for the new magelo keys/flags style.
  • Fix images in default_light skin (Loading, Male/Female, Trashcan).
  • Add a way to set a flag for a list of people.
  • Add an options table, to store user settings (last sort order, modify page settings, etc.).
  • Fix the GuildTool_Update bug, where a character with the same name as a deleted character does not update correctly.
  • Update the installation manual to the new GamePlayHeaven style.