Roster:ChangeLog

From WoWRosterWiKi

(Difference between revisions)

Jump to: navigation, search

Revision as of 05:49, 13 November 2008

Important note: When you edit this page, you agree to release your contribution into the public domain.
If you do not want this or can not do this because of license restrictions, please do not edit.

Languages:

English

v2.1.0

Alpha
Updated 23:49, 12 November 2008 (CST)
Changes as of SVN-1902

This can and will change at any moment
This is to just inform about upcoming fixes/changes/enhancements

General Fixes and Enhancements

Removed trim on realm/character/guild name for upload rules
- Apparently you can have spaces at the beginning and end of the realm/character/guild name
Updated class icons to 64px, up from 50px
Changed $_GET[] search to s_term then changed the order of the $_GET[] in the makelink()
New Quest Data (see other sections for additional info)
- All quest links use quest_id now
- Changes for lib/quest.php functions
  - quest_get_many() updated for new tables
  - quest_get_one($quest_name)
  - quest_get_one_id($quest_id, $locale)
Fixed error in lib/dbal/mysql.php
Changed behavior of db::error_die, will now just die() and not use die_quietly()
- Roster starts with this enabled, then settings.php sets to false when framework initialization is done
- We set db::error_die to false now, so db errors can be caught, instead of the db layer just dying
Some fixes to the item parser
Item and Profession search, changed Lv to localized Level name

LUA Update (update.lib.php)

Added additional checks for missing data
- Mail['Coin'], Mail['CoinIcon'], Spellbook['Rank']
- Including more not listed
Pet talents data importing
Glyph data importing
Added processTime var for use with enforceRules()

SQL/DB

New tables: quest_data, pet_talents, pet_talenttree
Renamed tables: spellbook_pet -> pet_spellbook
Changed tables: quests
Dropped: pets.usedtp (not available in WoW 3.0), pets.loyalty (not available in WoW 3.0)
New Quest data
- daily, group, reward_money, quest_id, description, objective, difficulty
- Description and Objective are only available via an option in CP /cp questsfull on -- scan full info for quests (Description & Objective)

Locales

Quest links updated to use quest id
- frFR: WoWDBU FR seems to be in maintenance mode and Judgehype FR does't seem to support quest id links
- Added WoWHead to all locales since it seems their site has data for them

Template System

Fixed a bug where iterating only the first element of an array resulted in the entire array being printed
Added new instruction
- Looks up the 'string' key in the current active localization table
- Check templates/default/memberslist/memberslist.html for usage examples
Moved locale assignments to template to calls in the template
- Replaced many tpl variables with instruction in templates
- Leftover {L_*} keys are not strictly locale keys, mainly tooltips or other php set values
- Some core addons may have not been updated yet

Addon Framework

Install::add_menu_button() added 5th parameter - $active
- Default true
- Set to false to prevent button from being automatically added to the menu
- Useful for "optional" buttons

Core AddOns

Quest data changes
- Quest List, Quest List Search, and Char-Info->Quests updated to not break and use some of the new data, not all though

CharacterInfo

Fix to spellbook sql
Char-Info->Quests new template data:
- ID - int, INDEX - int, DIFFICULTY - int, DESCRIPTION - text, REWARD_MONEY_C - int, REWARD_MONEY_S - int, REWARD_MONEY_G - int, OBJECTIVE - text, DAILY - int, GROUP - int
Changed quest icon to look more like the game icon
Updated menu tooltips

Keys

Patched for the memberslist changes
Patched for new quest data format

PvPLog

Updated frFR
Fixed SQL error
Changed win/loss text to image in PvPLog

MembersList

Simplified name_value()
Stripped out client sort
Fixed pagination
Alt grouping/ungrouping now clientside
Lots of code cleanup
Removed template keys:
- members_row.OPEN (use S_GROUP_ALTS eq 2)
- members_row.alts.DISPLAY (actually the opposite. Use S_GROUP_ALTS neq 2)
- S_TOOLBAR (used to include direction, but removed that usage yesterday. Use S_GROUP_ALTS ge 0)
Added HREF patching
- When using the openAlts(), closeAlts(), or unGroupAlts() javascript functions, all <a> elements with the 'internal' class will have their link target patched, giving the 'alts=' parameter (if set) the appropriate value.
Mainless alts are not shown at the bottom in ungrouped mode
Reformatted all memberlist pages to align the FIELD definitions
Updated with multisort
Removed the separate makeToolBar call
Main/Alt matching
- If the regex results in a member name with quotes, these are now properly escaped. thanks Athan.
Added inactive buttons for memberslist to all yet unlinked pages
Reformed $memberslist->prepareData() paramters
Added filter support by adding the GET string, with a GUI
Added ability to disable filtering for a column, hiding the box (set 'filter'=false)
Added ability to set an explicit mysql column definition for the default filter
Cleaned up javascript sort/filter specifications, since these are no longer used
Enabled filtering on stat-totals
Fixed HTML syntax
Added filter settings (disabled on key columns)

Vault

Added Guild Vault search
Fixed missing 'requires_level' data in VaultItem class

v2.0.1

Released - November 15, 2008

General Fixes and Enhancements

Maintenance release for WotLK for compatibility issues

Fixed notice error in installer
Updated EU realmstatus URL
Realmstatus fix for XML change for US feed
Talent import fixes
Fix style for file input fields in FF3
- Now the style will have a white background with grey text and a grey border
Added Death Knight class icon
Added Death Knight class color
- Updated other colors to standard Blizz colors (http://www.wowwiki.com/Class_colors)
Added class id for Death Knight = 6
Changed ROSTER_MAXCHARLEVEL to 80
Changed ROSTER_MAXSKILLLEVEL to 450
install.sh had the wrong path

Locales

frFR fix for Warrior
New strings 'tag', 'daily'
Added locales for 'Runeforging' and 'Inscription'
Added Inscription icon
Added 'Death Knight' locale strings
Updated class colors

Addon Framework

Fixed incorrect $addon variables
- 'tpl_image_url' and 'tpl_image_path'

CharacterInfo

New talent tiers for WotLK (WoW 3.0) will now show on talents page
Fixed talent export link for character talents

v2.0.0

Released - June 20, 2008

Important Notes

Roster has changed drastically, there is so much new and different from the last version (1.7.3)
We did our best to keep a log of every change, but there is so much that has been changed, that we could not list everything
The license has been modified, you must agree to the license before using WoWRoster!
- The changes are nothing big, mostly a reformat of the layout
- Also added a web viewable license ?p=license (SEO: license.html)
ROSTER 2.0 BRINGS MASSIVE CHANGES
- There is no upgrade path to 2.0, you must make a clean install
THE INTERFACE IMAGE PACK MUST BE DELETED AND RE-DOWNLOADED
Roster now converts all the image names to lowercase and removes spaces
'Interface/Icons/' is no longer being stored with the icon name in the database
Many Roster pages have been converted to addons (zeryl,zanix,pleegwat)
- It is now possible to overwrite these addons with different/improved versions written by addon devs
Big changes to addon framework, please read the updated AddOn SDK
- Addon folder names can only contain a-z 0-9 _
- Access to addons are now like this > index.php?p=SCOPE-ADDONNAME-FILE (SEO: SCOPE/ADDONNAME/FILE.html)
  - SCOPE is the addons scope (realm,guild,guildless,char,util)
  - ADDONNAME is the addons name
  - FILE is a file in the addons scope folder, FILE is optional
- Make use of the functions makelink() and linkform()
- AddOn triggers have been completely redesigned (pleegwat,zanix)
  - Please read the AddOn SDK for details
Changed detection of ROSTER_INSTALLED to IN_ROSTER, so the installer can include some of the roster files
- Please use IN_ROSTER from now on, ROSTER_INSTALLED is for installation purposes only
- define('IN_ROSTER',true); needs to be added to files that are accessed directly before including settings.php
Roster now supports 3 auth levels (guild, officer, admin)
- The auth fields were moved to the `roster_account` table
Many Database changes, see the rest of the change log
- UTF-8 conversion
  - Roster's database tables are now set to the utf-8 collation
- Many tables cahnged quite a bit from 1.7.3, here are a few of those changes
- guild table
  - Removed `guild_dateupdatedutc` `update_time` is exactly the same
  `faction` changed from char(8) to char(32)
  Added `factionEn`
- players table
  Added `raceEn`, `classEn`, `sexid`, `raceid`, `classid`
  Added 109 fields to the players table with all the new character data
  Deleted or changed the meaning of 6 old fields. These mappings apply:
  melee_rating -> melee_mhand_skill, melee_ohand_skill
  melee_range -> melee_mhand_mindam, melee_mhand_maxdam, melee_ohand_mindam, melee_ohand_maxdam
  melee_power -> melee_power_c
  ranged_rating -> ranged_skill
  ranged_range -> ranged_mindam, ranged_maxdam
  ranged_power-> ranged_power_c
- members table
  Removed `update_time`
- items table
  Added `locale`
- pet table
  Completely changed
- pet spellbook, addon table, addon trigger, addon config, menu, menu_button, upload, gems
  All new for 2.0

Fixes

Many locale changes/fixes
Edited the lua parser to read the lines directly from the file rather than caching it into memory (pleegwat)
- This is about 5% faster, and saves about 2400k of memory with a 675k CP.lua
Duplicate keys error with quests on CharacterProfiler uploads (zeryl)
function escape_array($array) now uses addslashes(), not $wowdb->escape() (zanix)
set_magic_quotes_runtime is now set off in settings.php (zanix)
tradeskills fix > http://www.wowroster.net/Forums/viewtopic/p=15858.html#15858 (zanix)
Missing $wowdb->escape() when testing the number of alts (pleegwat)
Last Updated fix -> http://www.wowroster.net/ProjectsPro/report/report_id=47.html (zanix)
Character removal, set inactive process improved (pleegwat,zanix)
message_die() has been changed to roster_die() (zanix)
- This is because phpbb uses message_die()
Memberlog is now updated with the guild updated time (zanix)
So very many notice errors removed (zeryl)
Fixed a possible problem with array based tooltips (zanix)
Fixed weird multi lined text in UU update log (zanix)
Unspent talent icons are now transparent in Opera (zanix)
Added level check in rogue portion of keys.php (zeryl)
Item (and bag) class now gets the clientLocale itself instead of having to pass it (zanix)
c.php now uses Roster's link constant (zanix)
Config does not query the db when data is processed for saving (zanix)
- Instead, it looks in the config array and dynamically updates it
- This means the menu reflects the changes after the first load, you do not need to reload to see the change
Mail alternate row coloring fixed (zanix)
Settings aren't stored in DB with an extra set of slashes (pleegwat)
overlib.js reverted to default, we pass the settings to it in roster_header.tpl now (zanix)
DB link was getting terminated twice on most pages. Removing the one in footer (pleegwat)
Lua parser should now detect invalid SV files (pleewat)
Install should now fail when the db information is wrong (zanix)
setTooltip() now checks if the passed key is already set, if it is, it does not set a new tooltip (zanix)
Fixed extra wide die_quietly() messages (zanix)
Removed configurable hide/show for hslist and pvplist, they are now hidden by default (zainx)
Fixed transparent 'banding' in messageboxes (zanix)
Realms with an apostrophe in them will no longer cause upload errors (zanix,pleegwat)
luaparser fixed for magic_quotes_runtime (pleegwat)
Method do_buffs(). Remove stale buff data even if no new buff data is available (ds)
Method make_mail(). Would produce Undefined Index Errors if the mail did not have an Item attached (ds)
Tooltip parser converted tab characters wrong (zanix)
Fixed a caption coloring error in tooltips creation when there is a tab character in the first line (zanix)
Locale inclusion for button in menu is local to only the menu, this is to prevent addons overwriting other addons' locales (zanix)
Added stripslashes to $update.lib->tooltip (zanix)
- Seems tooltips we being entered double escaped
added some data checking in do_pets() inupdate.lib.php. Would produce Undefined Indexes for pets that have not been scanned fully. (ds)
Character equipped item bonuses code has been re-vamped, it should be much easier to handle changes in blizz's data (ds)
Equipment bonuses are finally fixed, hopefully (ds)
minCPver and minGPver now use the actual CP and GP version numbers and not the dbversion number (zanix)
Guild motd will not show if it is empty (zanix)
Adjusted arc buttons to move standard buttons an additional 1000px off screen (zanix)

Changes

Major re-vamp of the character pages
- Way too much to list here
Roster Config is now the Roster Control Panel (RosterCP)
- Addon config can now use a library to generate a config page accessible from RosterCP
The Roster member list is now an addon called memberslist (pleegwat)
- AltMonitor functionality is now part of this addon
- SortMembers is now part of this addon
- Member log is part of memberslist
Converted all of Roster to run everything through index.php (zanix)
- Supports extra lower levels on the p= parameter. They're in $roster_pages (array), or in ROSTER_PAGE_NAME (string) (pleegwat)
- There is now a default page selection in Roster Config -> Main Settings
- Addons can be set as the default page (pleegwat)
- cmslink.lib.php contains defines and functions that can easily be changed for integration to other CMS's
All core WoWRoster pages have been moved out of the root directory (zanix)
$HTTP_GET_VARS, $HTTP_POST_VARS, $HTTP_COOKIE_VARS are now destroyed (zanix)
Moved the check for guild info into settings.php and out of every page (zanix)
Removed char.php compatibility mode setting (zanix)
Messages in update.php to use messagebox() functions (zanix)
WoWRoster is now XHTML 1.0 Transitional compliant (zeryl,zanix,pleegwat,anaxent)
char.php is now called like so ?p=char-info&a=c:## or or ?p=char-info&a=c:Name or ?p=char-info&a=c:Name@RC-Server (zanix)
- SEO links /char/info/a=c:##.html or /char/info/a=c:Name.html or /char/info/a=c:Name@RC-Server.html
- RC is the region code US, EU, etc...
- All of Roster has been converted to link to members with the ID number
Merged both guildbanks into one addon (zanix)
- The guildbank setting changes the default view
Roster menu is now included on char pages and error pages (zanix)
Changed Itemlinks, when you click on an item, a pop-up comes up with a list of available item link locations (zanix)
- Updated all of roster to use new item linking
Moved the addon scanner makeAddonList() and DateDataUpdated() to commomfunctions.lib.php (zanix)
Moved around the keys in locale files (zanix)
"This page was generated.." message to just "time | queries" (zanix)
Quests sorting change -> http://www.wowroster.net/Forums/viewtopic/t=3016.html (zanix)
Locales have been changed (zanix,pleegwat)
- All locale files are now included via a function add_locale_file()
  This prevents one locale form overwriting the other
- All strings in the locale files are now just $lang['key'] = 'String';
  The new locale include function handles parsing the correct locale to the correct array
- Locale works like so: $roster->locale->wordings['enUS']['some_key']
New locale access $roster->locale->act
- $roster->locale->act['some_key']
- This holds the locale array for the current locale
- All of Roster has been converted to use this variable (where applicable)
Removed printing of every sql string in html comments, we have a sql message box for that (zanix)
Changed tab detection and conversion in colorTooltip() and cleanTooltip() to use div and span, not tables (zanix)
Removed SigGen sig and avatar display on character page (zanix,pleegwat)
SigGen is an addon and should not be on this page
Moved character bonuses out to addons/info/inc/charbonus.lib.php (zanix)
Renamed lib/commonfunctions.lib.php to lib/functions.lib.php (zanix)
Changed img.php to work like c.php (zeryl)
- Use img.php?CHARNAME now
Removed config settings for all js and css (zanix)
- If users need to change these, they should edit the header file
Roster Config variable changes
- Removed the config 'roster_dir' (zanix)
  - It has been replaced with ROSTER_PATH
- Removed 'server_name' and 'server_type'
- Roster config variable 'roster_lang' is now 'locale' (zanix)
- Roster config variables 'guild_name' and 'guild_desc' are now 'default_name' and 'default_desc'
Moved SVN remote url to constants.php, for easy updating (zanix)

Item quantity text css has been changed (zanix)

Old

<div class="item"><img class="icon" /><span class="quant_shadow">6</span><span class="quant">6</span></div>

New

<div class="item"><img class="icon" /><b>6</b><span>6</span></div>

hslist and pvplist have the hide/show default variable in their files, so they could be included elsewhere easily if needed (zanix)
Localization files now use sprintf() rather than variable inclusion (zeryl)
Comment code at the top of every file to phpdoc standards (zanix)
Renamed css/styles.css to css/style.css, to stay in line with addon css styles now being named style.css (zanix)
Removed $script_filename for addons, use the constant ROSTER_PAGE (zanix)
Realmstatus Changes
- Added quite a few new config options (zanix)
- Now saves all realms that are accessed
- Can now be accessed "realmstatus.php?r=RC-REALMNAME"
  - If "r=" isn't set, it tries to get the default guildname from config
- You can now use the url parameter 'd' to set the output mode
  - d=1 for image, d=0 for text
Many Roster global variables are now part of the $roster class
- $act_words becomes $roster->locale->act
- $wordings becomes $roster->locale->wordings
- $roster_conf becomes $roster->config
- $wowdb->fetch_* becomes $roster->db->fetch()
- any other $wowdb becomes $roster->db->
- $header_title becomes $roster->output['title']
- $html_head becomes $roster->output['html_head']
- $more_css becomes $roster->output['html_head']
- $roster_show_(header, footer, menu) becomes $roster->output['show_(header, footer, menu)']
- $body becomes $roster->output['body_onload'] and $roster->output['body_attr']
Changed function DateDataUpdated() to function readbleDate() (zanix)
- Takes datetime field data from the db and makes a friendly time
Mass removal of DB table defines and renamed them to $roster->db->table('name') (zanix)
wowdb.php is no longer used
- sql functions have been moved to lib/dbal/mysql.php
  - Use $roster->db-> for SQL functions
  - Lua updating is now handled by update.lib.php
die_quietly() file name passed should now be __FILE__, not basename(__FILE__) (zanix)
- die_quietly() replaces the full path with a relative one
lib/hslist.php is now a function generateHsList() (zanix)
addons/pvplog/inc/pvplist.php is now a function generatePvpList() (zanix)
Changed the look of the back trace a bit (zanix)
- Arguments are now a bullet list
Changed wiki links for when 2.0 is released (zanix)
- From www.wowroster.net/wiki or www.wowroster.net/wiki/index.php/SOMEPAGE
- To www.wowroster.net/wiki.html or www.wowroster.net/wiki/SOMEPAGE
Using version_compare() now on CPversion and GPversion version checking and now checks the actual CP/GPversion and not the DBversion (zanix)
Added DBversion to `roster_players` and `roster_guild` tables (zanix)
- DBversion is the CP and GP data DBversion
- CPversion and GPversion are now CP/GPversion
Border images are now css styles (adric)
- This improves the loading time of most of the roster pages
MOTD text mode changed to look more like image version (adric)
Added add_ifvalue() to allow for checking of the value before insert in update.lib.php (zeryl)
function border() now accepts an optional 4th parameter, width (zanix)
Removed old tab selection in favor of the one used in RosterCP (zanix)
- It allows the use of multiple tab groups on one page, and persistence on page re-loads
Installer changes (zanix)
- You no longer need to go to install.php, just go to index.php
Upgraded tabcontent.js to v2.0 (zanix)
- Tabs are initialized differently
  OLD: initializetabcontent('id');
  NEW: var id=new tabcontent('id');
  id.init();
- Tab Content Documentation: http://www.dynamicdrive.com/dynamicindex17/tabcontent_suppliment.htm

Enhancements

A hearty welcome to our new developers, DS and Adric!
Roster is now Multi Guild and/or public compatible (pleegwat,zanix)
- Set guild and character upload rules in RosterCP
New page linking and SEO compatible links
- SEO is disabled by default since IIS servers cannot use this feature
- ?p=SCOPE-ADDON | /SCOPE/ADDON.html
- You can also link to certain files in the addon folder
  - ?p=SCOPE-ADDON-FILE | /SCOPE/ADDON/FILE.html
Added a template engine that addons can use (zanix)
- Templates are coded very similar to phpbb, eqdkp, and dragonfly templates
- (In fact, they all use basically the same template engine)
Made a new linking functions to help in CMS porting (zanix)
- lib/cmslink.lib.php
- function makelink( string $url="" , bool $full=false )
  - ALL roster links run through this function to generate links
  - This can easily be edited for integration into other CMS's
  - Login functions expect a NON-makelink()'ed link
    - login.php will convert the link for you
- function linkform(array $array)
  - This inserts the correct GET variables for html forms
  - Pass an array of additional GET vars if you need them array('name'=>'value')
Item parsing (ds)
- The items class has been enhanced to parse the tooltip to its separate elements
- There is alot more data now that is available for an item
- Check the wiki for more info
Gems support (ds)
Massively improved search system (anaxent)
- Features include
  - Able to search any installed, active addon that have a search.inc file within there inc directory
  - Ability to search only with in a particular addon
  - Advanced Search options per addon
  - Addons can create their own search results display using the $item['html'] = variable in the search class
Roster now uses an error handler (zanix)
- All php errors are saved and stored and displayed in the Roster footer if $roster->config['debug_mode'] is enabled
- The footer MUST be enabled to display the php errors
- You can get the current list of php errors at anytime with array() = $roster->error->report
- E_USER_ERROR level will halt Roster with an error message
Added addon_active($addon_basename) (zanix)
- Returns bool, true if the addon is active, false if it is not active or not even available
- Use this if your addon requires another addon to function
Remote version checking for Roster and addons in Roster CP (zanix)
Brand new Roster Menu (adric,pleegwat)
- Buttons can be added, removed, hidden, moved, etc...
- Locale selector (zanix)
  - You can also set the locale using url "locale=coDE"
  - The local set is session based, and traverses to every page without the need for the url setting
- Scope based id selector (zanix)
  - Change the current id for the scope
  - realm/guildless - List shows all realms
  - guild - List shows all guilds
  - char - List of uploaded characters in the guild (or realm if guildless)
  - util - The list is not available
- Menu title shows the 'default_name' and 'default_dec' when not in the guild scope
- Possible to set an icon for buttons
Character page has been completely overhauled (pleegwat,zanix)
- Way too many changes to list here
Added Pet Spellbooks (zanix)
Made tooltips transparent (85% opacity) (zanix)
Added SQL output for installer and upgrader (zanix)
Added ability to collapse or show recipe tables by default for characters (zanix)
Added last_online_value function for memberlist (zanix)
- It shows last online in terms of hours/days/weeks/years ago
Added $wowdb->add_timestamp() function to wowdb to handle timestamp conversion to mysql datetime (zanix)
Guild and character update will reject uploads if the timestamp is lower that what is in the DB (zanix)
Converted luaparser to a class (zanix,pleegwat)
- Added lua writer method
Added minixml library (zanix)
Added constant ROSTER_LOCALE_DIR, which is the location of the localization folder (zanix)
Added constant 'ROSTER_MAXQUESTS' (zanix)
Basic ajax framework that is available to addons as well (pleegwat)
- Read the Roster AddOn SDK for more info
c.php can now accept a member id (zanix)
New define CAN_INI_SET, true if we can configure php ini settings via ini_set() (zanix)
Added urlgrabber() function for global usage that gets a url file contents as a string (zeryl)
- This uses curl then file_get_contents() if curl fails
New scope system for Roster (pleegwat)
- These load specific data for each scope
- realm/guildless - url: ?p=realm-ADDON (SEO: realm/ADDON.html) | ?p=guildless-ADDON (SEO: guildless/ADDON.html)
  - Set the realm with the a=r: parameter ?p=realm-ADDON&a=r:RC-RNAME (SEO: realm/ADDON/a=r:RC-RNAME.html)
- guild - url: ?p=guild-ADDON (SEO: guild/ADDON.html)
  - Set the guild with the a=g: parameter ?p=guild-ADDON&a=g:GID (SEO: guild/ADDON/a=g:GID.html) | ?p=guild-ADDON&a=g:GNAME@RC-RNAME (SEO: guild/ADDON/a=g:GNAME@RC-RNAME.html)
  - RC is the region code
- char - url: ?p=char-ADDON (SEO: char/ADDON.html)
  - Set the member with the a=c: parameter ?p=char-ADDON&a=c:MID (SEO: char/ADDON/a=c:MID.html) | ?p=char-ADDON&a=c:NAME@RC-RNAME (SEO: char/ADDON/a=c:NAME@RC-RNAME.html)
  - RC is the region code
Tradeskill icons are now clickable in memberslist (zanix)
New header logo (adric)
Eye of the Storm summary added to pvplog (zanix)
Added lua upload access control (zanix)
- GP, CP, and other LUA data all have separate level restrictions
Added a news addon (pleegwat)
Added guild vault addon (zanix)
Added a shell-based install script. Tested on linux. Will probably work on anything that has bash. (pleegwat)

v1.7.3

Released - February 14, 2007

Fixes

Updated lua code and parsing for WoW 2.0.3 (pleegwat)
Many locale updates (zanix)
MOTD now converts html characters properly (zanix)
PvPLog now detects realm along with names for data insertion (zanix)
Reverted spellbook fix for Opera browsers, it breaks IE 6 (zanix)
Setting header logo or background image in Roster Config to nothing will remove the header logo and background correctly (zanix)
Bank bags will now show 7x4 instead of 4x7 (pleegwat)
Added support for Jewelcrafting, Blood Elf, and Draenei (zanix)
Raised level cap to 70 (zanix)
Fixed shaman class coloring (zanix)
Talent Points should insert properly now (zanix)
Removed Current PvP Ranking from Roster, the WoW API no longer provides this information anyway (zanix)
Added EU ES url for realmstatus (zanix)
Added primary keys to the spellbooktree, spellbook, talenttree, and talent tables (pleegwat)
Fixed update triggers where there are addons with no triggers (zanix)
Fixed rare notice in menu.php with update time (zeryl)
Fixed tradeskills.php to accept an arbitrary number of different tradeskills (pleegwat)
Added a result validity check for the tradeskill icon query in the main members list (pleegwat)
Many fixes to rosterdiag (zanix)
- Added addons folder to ignore list
- Fixed valid html errors
- On file compare, longer lines do not have to be scrolled individually
- Changed php highlighting to return string and removed output buffering
- Changed/fixed some stuff in the remote file checker code
- Hopefully fixed "endless loop" when wowroster.net is down
Modified the update trigger lib to global the $addon_conf and only load addon configuration once (pleegwat)
Changed realmstatus to accept new xml status page for EU realms (zanix)
Set all 'old' instance keys that are not pickable with 300 lockpicking to need 1000 lockpicking (pleegwat)
Fixed memberlog last page button to start at a multiple of 30 (pleegwat)
Fixed memberlog previous page button to not produce a negative start number (pleegwat)
Changed messageboxtoggle() and scrollboxtoggle() to use the JS showHide() which results in less html code printed (zanix)
Added a check for empty members list on update (pleegwat)
Fix to tradeskills.php noted here - http://www.wowroster.net/Forums/viewtopic/t=2637.html (zanix)
Moved setting of header() to roster_header.tpl (zanix)
Bag code and css cleanup (zanix)
- Combined many css defines between bag and bank
- Made corners transparent :)
- Removed redundant code
Fixed a preg_replace() in function colorTooltip() for color strings that might have UPPERCASE codes (zanix)
Moved to explicitly including each of the language file in a new file in the languages folder (pleegwat)
- This means 1 extra operation when adding a language, namely adding it to the array in localization/languages.php
- This also fixes the inclusion of back-up locale files
Made a small change in the key page to cut the number of sql queries down by almost half (zeryl)

Enhancements

esES locale May not be complete!
Changes to the upgrader, we now have a common function for upgrading (zanix)
Added 2 constants (zanix)
- ROSTER_MAXCHARLEVEL
- ROSTER_MAXSKILLLEVEL
- Updated Roster to use these
Added 4 new update trigger hooks (pleegwat)
- char_pre is run before character updates
- char_post is run after character updates
- guild_pre is run before guild updates
- guild_post is run after guild updates
Added some code, js, css to change the look of text boxes, radio buttons, and check boxes (zanix)
- For checkboxes and radio buttons, some js has to be used to dynamically replace the buttons
  - Set $body_action before you include roster_header.tpl
  - example 'onLoad="initARC(\'config\',\'radioOn\',\'radioOff\',\'checkboxOn\',\'checkboxOff\');"'
  - initARC('formID','radiOnClass','radioOffClass','checkboxOnClass','checkboxOffClass')
- For text boxes, it's just some css magic, class="wowinput"
  - The only bug is that the size is fixed, so I provided additional css defines wowinput, wowinput192, wowinput128, wowinput64

v1.7.2

Released - December 29, 2006

Fixes

IMPORTANT
- There are no longer any Roster AddOns included with Roster
- To get addons like SigGen, MadeBy, and Reputation...you must download them separately!
register_globals destroyer added to remove any problems with this setting (zanix)
Installer now checks if a locale file exists before displaying it as an option (zanix)
Riding Icons should now function in all locales [Thanks Romish] (zanix)
Offset in keys page for horde guilds (zanix)
Plus/minus boxes not showing for collapsible messageboxes [Thanks Snykx] (zanix)
realmstatus.php not showing text with accented characters (zanix)
Division by zero errors in index.php and char.php (zanix)
Character page on systems with magic quotes off (slashes are added by settings if it's off, but not stripped here) (pleegwat)
Server names entered with an apostrophe in the name not being entered into the database correctly (zanix)
Fixed Horde Onyxia Quest Chain in keys page (zanix)
Added actual MOTD in alt tage for image mode (pleegwat)
Debug Improved (pleegwat)
- Renamed 'show process time/db queries' to 'debug mode', also updated tooltip for this option
- Added query reporting for trunk if debug mode is on
- Now printing full debug trace when dieing if debug mode is on
Slight change to quest tag rendering (zanix)
Fixed mail tooltips (pleegwat)
Fixed char.php so it can be called without server parameter again (pleegwat)
Guildbank for frFR locale with Bind on Equip (zanix)
Removed is_numeric check in wowdb as it is safe to insert quoted numbers (zanix)
Guild motd is now hidden when there is no motd (zanix)
php time format for enUS (zanix)
Moved mrmuskrat to retired devs (zanix)
Added bsmorgan to pvplog dev (zanix)
Mail inserts items when there is actually an item sent (zanix)
Hopefully update.php will spit out a better error then an empty update log (zanix,pleegwat)
'no item equipped' is now localized (pleegwat)
item_id length fix, apparently blizz has longer item id's now (zanix)
Hopefully fixed a notice with some addons in menu.php (zanix)
Changed Rankexp to a float in DB (zanix)
Dirty mysql-only hack to fix the double entries in recipe. If it works for 1.7.2 it's fine with me (pleegwat)
Split up the reputation value column into a curr_value and a max_value column (pleegwat)
Removed extra space after ?> in some files (zanix)
Sorting error in member log (zanix)
update.php will now tell you that uploading is disabled, instead of just showing the fields and acting like it might let you (zanix)
- UniUploader users will also get the same error upon uploding files
Reformatted character update process a little, made it more streamlined (takes less vertical space) (zanix)
Maybe fixed the member update time error (zanix)
The Roster menu should now be able to get locale strings form addons correctly (zanix)
Added more header() calls in settings.php dealing with cache control (zanix)
- Set $no_roster_headers = true before including settings.php if you don't want header() to be set at all

Enhancements

CP 2.0 and GP 2.0 compatibility added, no new features (zanix,pleegwat)
- Roster 1.8 will get most of the CP 2.0 changes
- Character page changed to reflect some of the changes
- Honor tab changed to PvP, for new look
- Changed honor column to hide by default, both on new and on current installations
- Removed honor progress bar in index page
- DK's removed from PvP tab, CP inserted to replace them
- Removed rank percentage bar
- Removed rankname from character name in char page
- ThisWeek and LastWeek Honor Removed
- "HonorRank" of the "Faction" removed from player notes
- hslist.php is now basically useless
- SQL updated again to removed outdated fields
- indexhonor.php updated for less honor stuff as well
Added PvPLog realm support
Poisons added to tradeskills (zanix)
Added a file 'c.php' that can create extremely short links to characters, and in the future other parts of roster (pleegwat)
- Example of use http://www.yoursite.com/roster/c.php?Treyce
- Can be moved to a location outside the main roster by setting the relative url variable in the top of the file
Added parsing messages to the log. There should now always be meaningful log messages on upload (pleegwat)
Added level overview for levels 61-70 (pleegwat)
Added felgard pet icon (zanix)
Added 'item_level' to items and recipe tables (zanix)
Added function message_die() (zanix)
- This is similar to messagebox() except that Roster dies after printing the message
- Changed a few places in Roster to use this
Added a character buffs table, why? ...I was board and wanted this for some strange reason (zanix)
New global array $guild_info (zanix)
- This array contains all the data from the guild table

v1.7.1

Released - October 21, 2006

Fixes

Multiple deDE translation fixes (Sphinx)
Reputation addon fix for apostrophe in faction names (mattm)
SQL parser for install.php and upgrade.php (zanix)
JS error on character pages [Thanks Fangorn] (mathos)
chmod usage & path of conf.php in install.txt (peperone)
Typo in index.php and upgrade.php (zanix)
Roster should validate html 4.01 again (zanix)
Localization-related problem in lib/reputation.php [Thanks Gorgar] (zanix)
Double slashes in interface images causing some servers to not allow access to these images (zanix)
- This requires re-uploading of data to the DB
- wowdb.php now processes the interface images instead of the display pages
\n appearing in Guild Info. CP changed how this was stored (zanix)
Hopefully fixed errors where people can't reach config.php (zanix)
- Access to config.php has been changed to "roster/admin.php"
Talent Tabs, the first one will now show correct formatting (zanix)
Points spent in talents now uses a css style .talspent, like it was supposed to (zanix)
Color of talent ranks swapped to match game (zanix)
install.php and upgrade.php should now detect it's full server path and hopefully get rid of those nasty "cannot include template.php" errors (zanix)
Upgrading from 1.6.0-1.7.0 has been improved by now detecting the correct url path instead of using the old conf.php variables (zanix)
Possible security flaws in commonfunctions.lib.php, login.php, menu.php, and rosterdiag.lib.php (zanix)
Small fix to install/template.php to include the template files with full path (zanix)
$addonDir variable is now in menu.php so addon locale/config files possibly using this var will have it (zanix)
Time display for deDE locales (zanix)
Item- and questlink for blasc.de for deDE locales (sphinx)
Couple of localization issues with indexpvp (zanix)
Character PvPLog pages (zanix)
- Fixed blank row weirdness when there is no data to display
- Fixed class icons for deDE
- Added class icons for battleground summaries
Realmstatus revamped with reg_ex html parsing and new fonts/graphics (pleegwat,zanix)
Added checking for character info in the tradeskill icon function for the main pages (zanix)
- If there is none, then no query is made
- This reduces the amount of queries on the main pages
Spellbook fixes with ' apostrophes in the names (zanix)
Removed SQL coloring on update screen, in same cases this causes errors (zanix)
"Required Level" for recipe fix for locales other than enUS (zanix)
- Added "Required Level" for standard items as well
- http://www.wowroster.net/Forums/viewtopic/t=1008.html
CP changed how quests show as (Completed) or (Failed) and fixed accordingly (zanix)
roster_quests.quest_index is now being set correctly (zanix)
Made melee_range and ranged_range fields longer since CP seems to be picking up color info for those (zanix)
- Fixed lib/char.php to display the color info correctly
Fixed last online times for last_online < 1 hour (zanix)
wowdb.php fix for empty bags (pleegwat)
New riding/mount skills recognized (pleegwat)
Added handling just in case die_quietly() tries to die quietly. (pleegwat)
Added global slashing for global arrays (zanix)
lib/menu.php now temporarily holds the current $wordings array, then replaces it so addons cannot overwrite it (zanix)

Changes

Search page changed to use sgray bordering (zanix)
MOTD and realmstatus are using full paths for images and fonts (zanix)
Moved the guild update summary to just below "Updating Guild [GUILDNAME]" for easier viewing (zanix)
Moved 'header logo' to the display section of roster config (zanix)
Access to update.php has been changed to "roster/update.php" (zanix)
Activated remote latest version detection in install.php (zanix)
Bordering images (the corners) are now transparent [Thanks Sahasrahla] (zanix)
Massive cleaning of styles.css (zanix)
- A lot of things are going to look different
- Basically a lot of base level defines, like h1, h2, span, etc... were removed or replaced
Quest search now opens a blank window instead of using JS to open a window (zanix)
Font in MOTD image generator should be more readable, and removed 1px wide black space at the end (zanix)
Moved main credits to enUS.php (zanix)
Some date parsing functions changed to use sscanf() instead of substr() (zanix)
UU detection for update.php, it's a little less picky about the User Agent now (case in-sensative!) (zanix)
New version of dynamic menu javascript code from dynamicdrive.com (zanix)
- It's easier to use and uses less code
Removed the "By Class" menu link (zanix)
menu.php now uses only 1 query in member level distribution (pleegwat)
Class coloring should be more locale independent (zanix)
Moved stats from the indexalt.php (Alternate) to indexstat.php (Stats) so we have a single "Stats" list, money is completely removed (anthonyb)
Changed rep addon, indexpvp.php to auto change page when an option is picked in the select box (zanix)
Changed pagination for PvPLog stats on character pages (zanix)
Credits have been changed drastically and now include more contributors to the roster code (pleegwat, mattm, zanix)
Changed motd.php to get the motd when nothing is passed via motd.php?motd= (zanix)
Re-organized instance keys layout in localization files (zanix)
Changed code to use vgjunkie's new js function (zanix)
- Changed tradeskills.php with vgjunkie's edits
- Added vgjunkie's name to the 3rd party credits
Removed searing gorge key for horde (zanix)

Enhancements

frFR localization [Thanks wowodo, lesablier, Exerladan, and Ansgar] (zanix)
Keyring support (zanix)
Added memberlog, based on the addon created by Averen (zanix)
phpBB auth has been removed, this is casing too much trouble (zanix)
- Stay tuned for Roster 1.8 for a better solution
Added question mark bubbles where needed to indicate presence of a tooltip (zanix)
Confirm dialogs for Roster Config (pleegwat)
Added mail item colors since CP 1.6.0 gets this info now (zanix)
New defined constants (zanix)
- 'ROSTER_LIB' - Points to roster/lib/
- 'ROSTER_ADMIN' - Points to roster/admin/
- 'ROSTER_ADDONS' - Points to roster/addons/
Addition of a class Anchor in the memberslist.php file - http://www.wowroster.net/ProjectsPro/task/task_id=29.html (zanix)
Added affected_rows() to wowdb.php (zanix)
Added support for a customizable background image (zanix)
Merged profile-script.js with main.js (zanix)
Added new config option "alt_image_ext" with default of GIF
- PvPRank badge icons now use alt_image_ext (Transparent GIF images look much better) (anthonyb)
Added level to recipes on character pages (zanix)
Added (optional for addon dev) addon credits for main roster credit page (zanix)
- Look at the AddonSDK for more info
Added roster rendering times and # of SQL queries (zanix)
- This displays at the bottom of every roster page
- You can turn this off in Roster Config
Added messagebox functions
- See the AddOn SDK for more info
Added roster_header hooks for addons
- See the AddOn SDK for more info
Added "Most Killed" and "Most Killed by" in pvplog display for duels (zanix)
Added dodge, crit, parry, and block to indexalt.php (zanix)
Added common tooltip colorer to commonfunctions.lib.php (zanix)
Added $script_filename to addon.php (zanix)
- $script_filename = 'addon.php?roster_addon_name='.$_REQUEST['roster_addon_name'];
Update.php will show upload boxes for the following addons if they are present [thanks to polodude] (zanix)
- RaidTracker
- EventCalendar
- Bookworm
RosterLogin Class (zanix)
- Mainly built for addons needing a quick way to put a login box on the page and to check for roster admin access
- settings.php includes this for every page that includes settings.php
- Roster Config and Roster Diag updated to use this new class
- THIS IS NOT AUTH FOR ROSTER. It is only to authenticate the roster admin
- Look at the AddonSDK for more info
Moved most of the overlib calls to a php function that returns 'onmouseover="return overlib(overlib_id);" onmouseout="return nd();"'
- Overlib strings called this way are printed in the footer of roster
- This reduces the amount of text outputted in the html of the page which make rendering slightly faster
- function makeOverlib( $tooltip , $caption , $caption_color , $mode , $locale , $extra_parameters )
  - See commonfunctions.lib.php for more info on these functions
- function cleanTooltip()
  - This is called from makeOverlib() when $mode=1
  - This just converts the wow color strings and brackets ( < > ) to html
- function colorTooltip()
  - This is called from makeOverlib() when $mode=2 or is not set
  - This converts the wow color strings and brackets ( < > ) to html as well as does the famous color parsing the used to be in item.php

v1.7.0

Released - June 17, 2006

Fixes

Update Profile
- Switched to lua parser from roster2 (Parser Code By Airor/Chris), seems to run better/faster (By zanix)
- gzip uploads do not make temp files anymore, roster should be able to unzip gzip files on the fly (By zanix)
- Removed "Update Triggers" checkbox from update.php(By zanix)
- Update.php now uses "password" to update the roster memberlist. NOT "roster_update_password" (By zanix)
  Make sure to set up UniUploader accordingly
- Cleaned up output when using UniUploader to upload lua files
- Update.php now supports UniUploader's "Send Password Securely" option (By zanix)
- Roster addon links will now show up on the update page
- Better checking and notification on update for data, notifies if quests, inventory, bank, or equip are not found (By zanix)
- Changed $updGuildOutput = $wowdb->update_guild() to use less arguments and accepts $guild[] array, wowdb now handles the rest (By *zanix)
- Update will only update from the realm specified in config (By zanix)
  This fixes the same named guild on a different server issue
- Changing your guild/server name, then updating, will now cause update.php to remove ALL members and their info that do not match the new guild id
- Changed to kick back to the input fields when a user hits the upload button and no file is selected
- Added guild update summary

Character Pages
- Moved js functions defined in lib/char.php to css/js/profile-script.js (By zanix)
- When a character has no talents, "No Talents for CharName" will display (By zanix)
- Changed quest links, using arrays now, much easier to add more links if needed (By zanix)
- Cleaned up how character pages dies when a character isn't found
  Will show "character not found" instead of displaying weird mysql error
- Profile-script.js now accepts img_url as a parameter (By zanix)
- Changed sorting for "Item" column in recipes page to by name (By zanix)
- Separated item bonuses table from character frame, this fixes the bonuses from moving the character frame (By zanix)
- Clicking anywhere on the tabs (not just the text) will go to that tab (By zanix)
- Fixed a bug in item bonuses that caused the tooltip not to show (By zanix)
- Fixed when honor is not shown, left a float command in by mistake. (By mordon)
- Fixed bug in item bonuses table where right border was using wrong class [Thanks Fyredrake] (By anthonyb)
- Fixed long bag names breaking in FF [Thanks Thorus] - http://www.wowroster.net/viewtopic.php?t=1675 (By zanix)
- Added "Spell Damage" fix for item bonuses [Thanks Micah] - http://wowroster.net/viewtopic.php?t=3230 (By zanix)
- Disabled the display of the Item Bonuses table when that character has no item bonuses (By zanix)
- Item bonuses table will always stay the same width, and text will wrap properly (By zanix)
- Changed talent rank icons, they look prettier now (By zanix)

HTML/XHML/CSS
- Numerous xhtml/html compliance fixes (By nerk01, zanix)
- Removed the mass of tables in roster_header.tpl and char.php, replaced with div tags (By zanix)
- The character pages should now validate against xhtml 1.0 Transitional (By zanix)
  Still doesn't mean they'll display ok in every situation
- Tried again to fix "Mysterious Gap" in IE on character page (By zanix)
- Removed styles2.css and default.css, merged both with styles.css (By zanix)
  Yes! We have only one css file now!
- Replaced overlib.js, with overlib_mini.js, saves 20kb! and is exactly the same (By zanix)
- Overlib styling moved to the css styles (By zanix)
- Tooltips should display fine over <select> boxes in Internet Explorer (By zanix)

Misc Display
- Moved upload instructions url anchor to membersList so it won't show on "Guild Not found" error (By zanix)
- Fixed tradeskill icons in memberList (By zanix)
  Skill order has been corrected, Professions first, secondary skills next
  Riding skill icons will now display
  Removed img/trade/ folder as it is no longer needed
- Class icons are defined in the locale files, like the tradeskill icons (By zanix)
  Removed class images in img/ directory, they are no longer needed
- On Professions page (tradeskills.php) changed default char name link destination from the char page to the recipes page for that character. (By anthonyb)
- Realmstatus text output mode is now a <div> container, not a table anymore (By zanix)
- Updated valid html logo. Now in new, smaller size (By zanix)
- A new config value, 'interface_url' is for all images that reside in the Interface directory (By zanix)
  Now you can have your roster images and the Interface images in different locations!
- Most of the main pages now use the memberList.php code
  - indexAlt.php
  - indexStat.php
  - indexHonor.php
  - Removed the following files since they are not used
    - membersList2.php
    - membersStat.php
    - membersHonor.php
- Changed the look of quantity number on items (By zanix)
- Fixed gap between header and contents on bags in IE (By zanix)
- Bag names now use css overflow:hidden; instead of substr'ing it to 25 characters (By zanix)
- Made the Honor and PvP lists collapseable, default display is configurable in Roster Config (By zanix)

DB Fixes
- Updated wowdb to use newer CP fields instead of depreciated ones. (By nerk01, zanix)
  - [char]["Honor"] = LifetimeHK, LifetimeHighestRank, RankInfo, YesterdayContribution, YesterdayHK, LifetimeDK, RankName, SessionDK, SessionHK, LastWeekRank, YesterdayDK, LifetimeRankName, LastWeekContribution, LastWeekHK, RankIcon, LastWeekDK
  - [char][Guild][GuildName] > Name
  - [char][DateUpdated] > Date/DateUTC
  - [char][Experience] > XP
  - [char][Armor] > [Stats][Armor]
  - [char][Defense] > [Stats][Defense]
  - [guild][MemberName][Group] > [guild]->[MemberName][Status]
- Resistance and stat fields are now stored in the DB as int() values (By zanix)
  - The new fields are named as follows (type = 'res_' or 'stat_')
    - type_name = Base Value
    - type_name_c = Current Value
    - type_name_b = Buff Value
    - type_name_d = Debuff Value
- Every SQL $string that is passed to $wowdb->query($string) will be stored in the array $wowdb->sqlstrings
  You can then access this array at any point and don't have to worry about saving/printing each SQL string

Code Fixes
- Removal of extract($GLOBALS) (By zanix)
- Most of the files have been renamed to lower case to ease roster hardships with server OS's that care about filename case (By zanix)
  - The only files that MUST include uppercase letters are the localization files, and files in the Interface directory
- addon.php now uses an html css style link to the css file instead of opening the file and spitting out the contents into the output (By zanix)
- Most submit buttons use JS that keeps people from hitting the submit buttons more than once (By zanix)
- Fixed array based tooltip parsing in wowdb.php. Handles <br> tags correctly now (By zanix)
- Added a lot of "deny access" strings to files that are not directly accessed (By zanix)
- Added links to config and upload when "Guild Not found" error occurs (By zanix)
- Fixed error when all addons are removed from /addons directory (By anthonyb)
- "No guild" die() message changed to use the value in localization files (By zanix)
- Fixes to realmstatus, it will still take 30 seconds to time out but it shouldn't break the page anymore (By zanix, mordon)
- Replaced guildbank2's icon maker with lib/item.php, cuts down on duped code (By zanix)
- Edited links to original coders as 2 were going to 404 pages (By zanix)
- Item Tooltips will show tabs A LOT better now (By zanix)
- Changed download paths in conf from wowprofilers to wowroster (By zanix)
- Multiple PvP fixes (By Nostrademous, anthonyb, mordon)
- Some corrections of the german translation and encodings... (By sphinx)
- Hopefully fixed some issues using MySQL 5 with "Strict_Tables" on (By zanix)
- Fixed up image pathing to use $roster_conf['img_url'] [Thanks pbutler] (By zanix)
- Added multiple checks for empty tooltips and put the item name in, the idea is to fix them before they enter the db (By zanix)
- File inclusion is handled better with the use of a new constant 'ROSTER_BASE'
  This is the absolute directory path to the root of roster
- All localization files in the localization folder are now included
  You can get a list of included locale files (minus the extenstion) from the $roster_conf['multilanguages'] array
- Mass changing of using "mysql_" to use wowdb functions, including inside wowdb itself (By zanix)
  - Addon devs are expected to use $wowdb functions as well
  - If something is missing, let us know
- Made the line numbers match each other in the locale files (By zanix)
  - This makes it easier to find matching strings

Enhancements

RosterDiag - A Roster Diagnostics tool, displays important config options, gd info, file integrity, etc... (By anthonyb, zanix, mathos)
- You can use rosterdiag.php?printconf=1 to get a printed array of the current Roster configuration
AUTO-INSTALLER! - Roster now comes with a database table installer, it will also upgrade a current database (upgrades from 1.6.0 only) [Thanks Moondrake] (By zanix)
Web based config! - Now point your browser at roster/admin/config.php to change the options in roster. [Thanks Zeryl] (By zanix)
New roster menu, isn't it pretty? (By zanix)
Character pages display is now set on a per character basis (By zanix)
- Use Roster Config to change the settings
Guild Info page - See your guild info text. [Thanks Zeryl] (By zanix)
Revamped the credits page (By zanix)
PvPLog display has been greatly enhanced (By zanix)
New header logo! (By mathos)
- There is a psd (PhotoShop) template image that you can edit
Catagorized GuildBank AddOn is now packaged with Roster
Added Colorization to Class Names (By nostrademous)
- Option via config for those that find it a bit hard on the eyes, default is class names are in color (By anthonyb)
Added border($style,$mode,$header_text) function. This is for wrapping something in the nice bordering [Thanks Mathos] (By zanix)
- Accepts 'rank' (the original bordering) or 'scolor' (new slimmer styled borders) for $style for different bordering styles
  - There are many colors including sblue, sgreen, sgray, sred, spurple, syellow, and sorange
- Accepts 'start' or 'end' for $mode to start or end bordering
- Converted alot of the tables to use this, the display is much more consistant in IE vs FF
Added fancy bordering to guildbanks
Added allakhazam search on the "Find Teams" page (By zanix)
Edited look of quests, recipes (By zanix)
Added a SQL string colorizer function sql_highlight($sqlstring) (By zanix)
Returns the sql string, colorized for display
Added a function to handle die()'s or exit()'s (By zanix)
- die_quietly($text,$title,$file,$line,$sql)
  $text - What text to display
  $title - Title of the error box
  $file - File name, best to use basename(__FILE__) as the argument
  $line - Line number, best to use (__LINE__) as the argument
  $sql - SQL text to display, die_quietly will pass this through a SQL colorizer
Many changes to the look of update.php (By zanix)
- Added the "Cleaner Update Page" Mod [Thanks OverloadUT2]- http://www.wowroster.net/viewtopic.php?t=2705
- Update info will now display inside a scrollable box
- Added alot more info on updating
- Update trigger lib won't notify if it is trying to run triggers anymore
- There is now a "Save Update Log" button, hitting this will give a downloadable text file of the log messages and all sql strings
Colorization on removed/added members on update (By zanix)
Added image based MOTD, configurable in conf.php [Thanks PoloDude] (By zanix)
The image will size dynamically based on how long the text is
motd.php will take an argument ?motd=Text where Text will show on the image
A character limit of (145) has been imposed to keep the image size manageable and to prevent malicious use
Added honor rank icon tooltip on main member list to include Rank and % (By anthonyb)
Added many more mysql functions to lib/wowdb.php (By zanix)

$wowdb->error() = mysql_error()
$wowdb->fetch_assoc = mysql_fetch_assoc()
$wowdb->fetch_array = mysql_fetch_array()
$wowdb->fetch_row = mysql_fetch_row()
$wowdb->num_rows = mysql_num_rows()
$wowdb->free_result = mysql_free_result()
$wowdb->data_seek = mysql_data_seek()

Added Various Item Icon Colorizations in CSS styles: for the various item qualities (rare, uncommon, epic, common, trash). (By nostrademous)
- iconblue
- icongreen
- iconpurple
- iconwhite
- icongrey
Added mailbox extraction and display [Thanks ThePrimaryDave] (By zanix)
Added spellbook display in character page (By zanix)
Added level bars mod with eXp tooltip [Thanks mutilator, Zeryl] - http://wowroster.net/viewtopic.php?t=2543 (By zanix)
Added recipe item color/rarity (By zanix)
- Added 'difficulty' column to recipe page colored based on difficulty
- Item names in recipe page are now colored based on item rareity
- Fixed made-by addon to show item names/rarity correctly
Added the ability to turn off the update instructions on the main page (By zanix)
Added "Max XP" output on IndexAlt (By zanix)
Added tooltips for pet icons(shows their name) (By zanix)
Added Damage Reduction in armor tooltip - http://www.wowroster.net/viewtopic.php?t=3384 [Thanks aktlingit] (By zanix)

Important Changes

Roster Password is now a md5 hash
AddOn Devs, change your addons if it uses this password
Addon.php does not write the contents of the addon's css file to the output
Instead it will add a style link to the <head> section of the output
Changes to conf.php
Roster Configuration has been moved to the db
- All config values now exist in the array $roster_conf[]
  AddOn Devs, you'll need to update your AddOns to use this new array
AddOns Framework
- Changed "update_triggers" to automatically include the config file for each addon
- AddOn Creation Docs have been updated
Changes to Database
- Added Tables
  - roster_mailbox
    Holds mail for characters
  - roster_config
    Holds roster configuration/settings
- Altered Tables
  - roster_players
  - roster_members
  - roster_recipies
  - roster_items
  - roster_guild
  - roster_spellbook
  - roster_talents
  - roster_talenttree

v1.6.0

Released - February 04, 2006

Fixes

Basic support for PvPLog 0.4.8
- More fixes, enhancements comming soon!
update.php and updateMembers.php have merged
- use update.php for guild AND member updating
The usual... major code cleanup, html fixes, css issues
- Index pages conformance to W3C HTML 4.0 Transitional
- Fixed multiple gap issues, hopefully
Fixed "headers already sent". Roster now checks to see if headers were sent and sets them if they aren't
Cleanup of old files no longer in use: index2.php, altindex.php, indexupdate.php, membersInst2.php, indexProf.php, ProfList.php, and ProfList2.php
Changed realmstatus to use the database to store values instead of "wowss/wowss.txt"
- Deleted wowss-folder: fonts moved to /fonts and images to /img/realmstatus
- cURL will now be used if fopen()/file_get_contents() fails, Thanks to Jerry for the fix
- To use fopen()/file_get_contents(), allow_url_open must be on in php.ini, to use cURL, it must be compiled into your PHP
Fixed guildbank2 not showing the correct stack heights
- Fix for first item of query getting "eaten" in guildbank2
- Added money totals and per character money in guildbanks
- Added character last updated to guildbank2
Header and Footer files added, now it is easier to adjust the header and footer for each page
- Character pages DO NOT use the header/footer files because this would break it's functionality
Improvements to localization
Tooltip and overlib adjustments
Fixed docs link in memberslist.php - was just docs/ which assumes a default file is loaded - changed to docs/index.html
Fixed a bug where some servers will not display character info, or "Character Not Found"
Replaced all instances of <? with <?php to ensure compatibility with systems where PHP configuration has short_open_tag = Off
Replaced multiple insatances of hard-coded '/' with the DIRECTORY_SEPERATOR value to fix incorrect slash on certain systems
Re-added "img/default.png" for legacy signature generator (img.php)
Character pages
- Changed how reputation values display, looks more like in game
- Fixed exp bar at around 97% to 99%, the bar would be larger than the container
- "Unused Talent Points" will no longer display "Unused Talent Points: 0" it will now only display if there are actually unused talent points
- Fix to recipies, when a character had only one type of recipie, the table breaks
- Recipes pages with wrong icon placement + quicklinks
Fix for images having a space and generating errors on some systems when referencing images with spaces in the name, in one case "First Aid.gif" on the recipes page
Removed the thottbot option in conf.php as they no longer let you link to their images
Fixed unescaped server name when doing an update to the database. ' in server name would break it before
Now you can choose between two external itemlink-urls for each language-setting. (thx @ Merella for the hint)
Fixes for sqldebug. Eeverything should now properly recognize sql debug statements only when necessary
pvp update now modifies the levels: if < 1 then make it equal to itself multiplied by negative one
Pet bugs and bag bugs fixed by mortencb
Fix for ' in server names when displaying character stats for a warlock / hunter with a pet
When updating a character, wowdb will update the level of in the members table, as well as players table

Enhancements

Roster Addons support
Full DB prefix support, default DB prefix is 'roster_'
New 1.9 icons from rpgoutfitter.com
CharacterProfiler, GuildProfiler, and PvPLog version detection
- Prevents old versions of CP, GP, or PvP from uploading data
Basic support for PvPLog 0.4.8
- More fixes, enhancements comming soon!
Included addons
- "SigGen" by Zanix, see the SigGen docs for more info
- "Made by Recipe" by Cybrey
- "Faction Filter" by Cybrey
- "Dummy Addon" template. This is for making your own addons
Added a stripped down version of menu to use in phpbb if you want to show the roster menu with links in your website portal
- (It's in the "addons/pmenu" folder)
Added Spellbook to database backend, there is NO front end (no display in roster)
Index page
- Added profession icons, class icons, and pvp icons to index.php, switchable via conf.php
- Added column "Last Update" to main page, switchable via conf.php
- Added displaying of Guild MOTD on main index page
Added hot links/ancors to search "indexSearch.php"
Added credits page
Added link to wowprofilers.com in the Credits section. No need for us to hide anymore!
Added more info when doing a guild member update, will show members a being "Updated", "Added", or "Removed"
Added removal for members not assigned to the current guild id
Updated all the files to show the revisions numbers in all the files for CVS changes for future use and troubleshooting
Added localized item tooltip coloring
Character pages
- Added Advanced Stats & Bonuses, Thanks to cybrey (original author) and dehoskins (for additional output formatting)
- Added Max Exp to exp bar
- Added Time Played and Time Level Played
- Added Honor EXP bar to the honor tab
- Added "Points Spent" to talents
- Added Pet icons

Known Bugs With 1.6.0

Bags with long names are not displayed correctly, they appear to be moved into the bag
- This is a css issue, no known fix at this time
Servernames with non-english characters, or mis-matched names may cause serverstatus to not work correctly
- Fix: Open "realmstatus.php" in a text editor and edit the variable "$server" to match exact name from the WoW realmstatus page
Random gaps on the character page
- This is a css issue, we have done our best to resolve this but it still happens sometimes

v1.5.1

Released - October 20, 2005

Fixes

Character pane blank for any tabs other than Skill when DB doesn't contain any Pet data [337-338]
"Headers already sent" issue with update.php for some people fixed [330-331]
PvP data page will now retain custom column sort across pages when using Previous/Next links [334]
Bag names being being truncated at 17 characters fixed [335]

Enhancements

$lang variable replaced with $roster_lang to resolve compatibility issues with phpBB [329]

v1.5.0

Released - October 17, 2005

Fixes

Missing Poison profession icon added
Large amounts of display inconsistencies between IE6 and Firefox 1.0.6 fixed
Large numbers of formatting inconsistencies fixed
Removed incessantly repeating and redundant guild name variable usage from PvP and Honor stats tables on main page to make them less cluttered and smaller for guilds with long names
Remove a lot of mixed case variables to reduce issues on Unix system that are overly pedantic about case...
Fixed annoying yellow border on image headers in recipes with IE6
Replaced hard-coded Thottbot variable on column header link with $itemlink variable defined in conf.php same as item links on Keys page
Added _target to column header link so links open in new page on Keys page
Re-added unlink command which had gone missing somewhere along the way and was causing temp to be left behind in webserver %temp% directories when data was uploaded with UniUploader using GZip
Fix for quest title containing quest level caused by multiple 'quest' related addons overloading the function in WoW post 1.7 patch. This will strip the offending data out prior to committing to the DB
Inserted logic to account for Horde not getting a Searing Gorge key so it won't be displayed on Keys page
Fixed US server status page and implemented XML parser
Modified query to return character level as whichever is higher between members.level (data from GP) or players.level (data from CP) to solve problem of main view character level often being lower than the character pane level due to guild admins not doing GP updates frequently. Also modified the various display sort queries to suit change.
Untold amount of code clean-up and optimization
One less stylesheet, removed "css\styles3.css"
Update page now supports post 1.7.0 patch use of seperate data files for each addon
Data upload will now only upload chars whose guild matches the one defined in the conf.php

Enhancements

Localization completely re-done and almost the entire roster now supports localization. Current language support is English (enUS) and German (deDE) but will be easy to now include other languages
Reputation tab added to character panel
Pet tab added to character panel (only visible for Hunters and Warlocks)
All icon images converted to jpg for easier updating
Recipe list columns now sortable
Class and Profession icons all re-made - much better quality now
Added Quest count (like in game, eg. 16/20) to the quest list page
Money display on main backpack now configurable (global only) via $show_money variable in conf.php
Added $char_bodyalign to control the characters’ data display either left center or right
Keys page now includes Rogue Thieves' tools and partial quest completion gauges
Character page now has a 'Date Updated' tag which reports the date/time, as recorded by CharacterProfiler value 'DateUTC', the data was saved in-game. This date/time is stored in the database in UTC and then displayed with whatever time display offset is configured in the $localtimeoffset variable in conf.php. The date/time format is configurable by the $phptimeformat variable.
Implemented local time display for data GuildProfiler data is updated based on new GuildProfiler value 'DateUTC'. Uses same function and local time display offset var as character date - $phptimeformat
New Guildbank feature added
Updated icons to include the 55 new items/abilities/etc. from WoW 1.7.0 patch
New signature generator (sig.php) Use of this is the same as img.php. See /docs/sig.php(new_signature_generator)-readme.txt for more information
All new Talents tab with in-game layout!
Implemented Overlib tooltip engine - tooltips are now MUCH faster and don't disappear off-screen!
Update page now supports post 1.7.0 patch use of seperate data files for each addon
Honor support updated to include current features
Realm Status now supports new Blizzard XML based page
All new setup documentation in HTML format! OMG!!!
Ammot slot contents now displayed on Character screen!

v1.04

Released - July 30, 2005

Fixes

Updated the $blizstatuspage variable in conf.php to fix issues since WoW 1.6.0 patch
Renamed "roster\CSS FILES" directory to "roster\css" to reduce issues with UNIX based web servers caused by spaces in the directory name.
Renamed "roster\CSS FILES\JV Scripts" directory to "roster\css\js" to reduce issues with UNIX based web servers caused by spaces in the directory name.
Deleted \roster\lib\wowdb.zip from distribution package - don't know why it's there in the first place...
Changed default UniUploader link in conf.php - existing link is broken
Changed default CharacterProfiler link in conf.php - existing link is to old non-working version
Cleaned up all files for spaces at end of files after PHP closing tag (can cause problems)
Fixed character link being invalid on the query return page of the "Find Team" page
Fixed "Find Team" queries returning no results (incorrectly) when the quest name contained an apostrophe
Included a MySQL 3.x compatible roster.sql called roster104_MySQL3.sql for creating database during installation (untested as I don't have a MySQL 3.x installation nor will I. This version is SO old there's no excuse for people to still be running it)
Main roster page version number use $version variable in conf.php rather than hard coded value in index.php page
Added slot_Waist.gif (missing) to /roster/img

Enhancements

Percentage value shown on the XP bar on the character page
Character gender now captured and displayed on the character page
Equipment slots not containing an item now show the same "greyed" icon as in-game rather than an empty slot on the character page
Smaller tab image used on bottom of character panel so they all fit on one row. This also creates room for more tabs... ;-)
Recipes now colour coded to reflect difficulty on recipes page
Generic Horde image now included for signatures
Additional quest lookup links now available on Quests page - Allakhazam and WWN Data added to existing Thottbot links
Quest lookup links now fully configurable via conf.php - show as many or as few as you like and add your own custom ones
Menu bar on top of most pages tidied up, dividers added, and now honors the individual On/Off flags in conf.php for whether they are displayed or not.
Added GZip support to updatemembers.php page for consistency with update.php - UniUploader users rejoice!
Included gd_info.php file to help troubleshooting issues with Signatures and the Server Status image. gd_info.php only shows the GD support info so is able to be safely link to publicly unlike phpinfo which gives away information which *could* be potentially be used maliciously.
Server Status image now able to be disabled via conf.php for those that do not want it displayed at all.
Various miscellaneous minor changes to main menu "box", including the guild character level breakdown info, and menu names.
Change variable declarations to be enclosed in ' rather than " if they don't contain variables (performance improvement - 'x' gets treated as a string and is assumed to not contain any variables and therefore doesn't get parsed which improves performance)
General code formatting cleanup, eg. remove large numbers of line spaces, correct formatting, replace multiple spaces with tabs, etc. on some files (there's still a LONG way to go!)

v1.03 [maintainance]

Released - July 11, 2005

Just a package maintenance update to prevent issues with old addons and links - no functionality changes.
Removed GuildProfiler addon from package - must now download saperately
Removed CharacterProfiler addon from package - must now download separately
Update config.php.bak to remove old CharacterProfiler URL (www.cethinchimera.com) and replace with current dev source (http://www.rpgoutfitter.com/CharacterProfiler)

v1.03

Released - May 05, 2005

Updated lib/wowdb.php to except Angarth' Wow Profiler 1.0.3
Updated lib/wowdb.php for Recipe and Bank Fix
Updated lib/char.php with new graphics and updated honor format
Updated code to configure everything from the config.php
Updated update.php
Updated newer PvP support and added in PvPLog 0.4.6
Added Server Status, it parses the realm status of Blizzard's website
Added support in conf.php to turn off or on the Quest's, recipes, PvP, and duel data from displaying
Added new info to the menu
Upload profile now available on the menu

@@ Line 12: / Line 12: @@
 ----
-Last Edit: [[User:Zanix|Zanix]] 21:49, 11 November 2008 (CST)
+Last Edit: [[User:Zanix|Zanix]] 23:49, 12 November 2008 (CST)
 ==v2.1.0==
 <span style="color:red;font-weight:bold;">Alpha</span><br>
-<span style="color:red;font-weight:bold;">Updated 21:07, 11 November 2008 (CST)</span><br>
+<span style="color:red;font-weight:bold;">Updated 23:49, 12 November 2008 (CST)</span><br>
 <span style="color:red;font-weight:bold;">Changes as of [http://www.wowroster.net/websvn/log.php?repname=roster SVN-1902]</span>
@@ Line 82: / Line 82: @@
 ** Default true
 ** Set to false to prevent button from being automatically added to the menu
-** Nice for "optional" buttons
+** Useful for "optional" buttons
@@ Line 91: / Line 91: @@
 ====CharacterInfo====
-* Fixed talent export link for character talents
 * Fix to spellbook sql
 * Char-Info->Quests new template data:
@@ Line 149: / Line 148: @@
 Released - November 15, 2008
 ===General Fixes and Enhancements===
-* Maintenance release for WotLK for compatibility issues
+'''Maintenance release for WotLK for compatibility issues'''
 * Fixed notice error in installer
 * Updated EU realmstatus URL
 * Realmstatus fix for XML change for US feed
 * Talent import fixes
-* New talent tiers for WotLK (WoW 3.0) will now show on talents page
 * Fix style for file input fields in FF3
 ** Now the style will have a white background with grey text and a grey border
@@ Line 178: / Line 176: @@
 * Fixed incorrect $addon variables
 ** 'tpl_image_url' and 'tpl_image_path'
+====CharacterInfo====
+* New talent tiers for WotLK (WoW 3.0) will now show on talents page
+* Fixed talent export link for character talents

Roster:ChangeLog

Revision as of 05:49, 13 November 2008

Main Page

Contents

v2.1.0

General Fixes and Enhancements

LUA Update (update.lib.php)

SQL/DB

Locales

Template System

Addon Framework

Core AddOns

CharacterInfo

Keys

PvPLog

MembersList

Vault

v2.0.1

General Fixes and Enhancements

Locales

Addon Framework

CharacterInfo

v2.0.0

Important Notes

Fixes

Changes

Enhancements

v1.7.3

Fixes

Enhancements

v1.7.2

Fixes

Enhancements

v1.7.1

Fixes

Changes

Enhancements

v1.7.0

Fixes

Enhancements

Important Changes

v1.6.0

Fixes

Enhancements

Known Bugs With 1.6.0

v1.5.1

Fixes

Enhancements

v1.5.0

Fixes

Enhancements

v1.04

Fixes

Enhancements

v1.03 [maintainance]

v1.03

Personal tools

Namespaces

Variants

Views

Actions

Search

WoWRoster

Navigation

Toolbox