Add-On Releases - gWoWRoster - World of Warcraft Guild Roster

What is it?
[hr]-[/hr]gWoWRoster is a modification for vBulletin which allows you to display multiple guild rosters for World of Warcraft.

If you use this mod, please Mark as Installed, and if you really enjoy this mod, please Nominate for MOTM, and if you really really enjoy this mod, feel free to Support Developer! Thank you!

Follow me on twitter!

Support
[hr]value[/hr]I use my released mods daily, if I find an issue with them or add features for myself I will release updates. If there are significant bugs or simple feature requests I will do my best to release fixes. Some of my mods rely on fetching data from 3rd party websites, due to the unreliable results, my mods will require users to troubleshoot for themselves if they find the addon is not working for them specifically. I am offering my personal mods that work ok for me for you to use, I am sorry I do not have time to troubleshoot many user specific issues. Thank you for your understanding.

Features
[hr]-[/hr]

• Links to either US or EU WoW Armorys.
• Multiple guild support
• Usergroup access to roster
• Unified profilefield compatible with gWoWEvents and gWoWChar
• Currently requires cURL

Installation
[hr]-[/hr]

1. Download the latest version and upload all files.
2. Install the product.
3. Create a Multiple-Line Text Box User Profile Field.
   • /admincp/?loc=profilefield.php%3Fdo%3Dadd
   • Multiple-Line Text Box
   • Continue
   • Title: World of Warcraft Characters
   • Description:

     Enter one character per line.<br /><br />Format: US/EU|Realm|Faction|Name<br /><br />Example: US|Mal'Ganis|Alliance|Gryphen

   • Default Value: Leave Blank
   • Max length of allowed user input: 1000
   • Field Length: 50
   • Text Area Height: 6
   • Field Editable by User: Yes
   • Other options are optional.
   • Save
   • Look and see what the field name is for World of Warcraft Characters, example field25.
4. Fill in the gWoWRoster configuration options.
5. That is all.

Examples
[hr]-[/hr]

• http://www.alliedtribalforces.com/gwowroster.php
• http://www.google.com/search?q=allin...oster.php+-loc

Changes
[hr]-[/hr]
v1.0.14a - upload class_gwowarmory.php

• Quick fix for Armory import.

v1.0.14 - upload cron.gwowroster.guildinfo.php, import product with overwrite enabled.

• Fix race designation.

v1.0.13 - upload class_gwowarmory.php, cron.gwowroster.charinfo.php, cron.gwowroster.guildinfo.php, import product with overwrite enabled.

• Quick fix for 3.1 armory changes.

v1.0.12 - upload gwowroster.php, cron.gwowroster.charinfo.php, import product with overwrite enabled.

• Fixed special characters in player names. Thanks Bumpaneer.

v1.0.11 - upload gwowroster.php, external icons, import product with overwrite enabled.

• Fixed level 80 avatars
• Fixed scheduled task database error
• Added wow-achievements.com link per user

v1.0.9 - import product with overwrite enabled.

• Update for be.imba and wowheroes, new options to specify levels the links are active.

v1.0.8 - Upload all files, import product with overwrite enabled.

• Update for WotLK

v1.0.5 - import product with overwrite enabled.

• Fix for armory light link.

v1.0.4 - Upload functions_gwowroster.php, import product with overwrite enabled.

• Fix for divide by zero error.
• Display throbber for talents scheduled to be imported.

v1.0.3 - Upload all files, import product with overwrite enabled.

• Fixed some urls to external sites
• Added options to display external liks to wowjutsu and wowprogress.
• Updated WoW Juju's icon to their current favicon
• Should* now be able to use kr/cn/tw armorys in addition to us and eu.

v1.0.2 - Upload all files, import product with overwrite enabled.

• Some style tweaks
• Added options to display external links to sites like be.imba.hu, wowjuju.com and more.

v1.0.1 - Upload all files import product.

• Initial Release

Copyright
[hr]-[/hr]gXboxLive, Copyright ? Ghryphen (https://github.com/ghryphen)
Please maintain copyrights in derivative works, thank you.

[imported_sasavtec]

Originally Posted by Gryphon

I am not sure what you are asking.

Is it possible to filter the ranks shown for example right now all ranks in guild show even the lvl 3 alts, now would be nice to show only certain ranks from the guild. Also my spec part of the roster isnt changing it just keeps refreshing not showing any numbers.

[quinnie]

Originally Posted by quinnie

I'm currently having this same problem.

View here:

http://premonitionwow.com/site/index.php/forums

EDIT: If I manually run the cron job for the character update it goes out and finds a new character. So essentially every 10 mins it would find a new one and take about 35 hours to complete the initial 'download' of all the characters in my guild. I would assume that isn't how this should work?

So I'm guessing by the lack of response that this is intended to work this way? I still have characters that have not updated since this original post.

[Gryphon]

How many it updates at a time is determined by how big the roster is. With 200 members it should be doing 2 or 3 per update. When it reaches the end, which should be within 12 hours if the cron is run on schedule, it starts with the oldest updated member and starts all over again.

If you look at the ones that are Untalented, the characters probably have no points spent since the last refund.

[blake247]

Originally Posted by Dragonsys

try changing this line:

PRIMARY KEY ( `locale`, `realm`, `name`, `charname`, `key` )

to

PRIMARY KEY ( `realm`, `charname`, `key` )

Sorry I'm a noob, where do you change this at?

[acidpr]

How do you rename the navbar link?

[Repec]

In your admincp go to "Languages & Phrases" --> "Search phrases" and search for "gWoWRoster".
Then change the phrase "gwr_vbnav" to whatever you want it to be.

[acidpr]

Got it Thanks!

[CFodder]

Trying to install v1.0.14 on VB 3.8.1 PL1, getting the following error:

Database error in vBulletin 3.8.1:

Invalid SQL:

CREATE TABLE IF NOT EXISTS gwowroster_charinfo_prof (
`locale` VARCHAR( 2 ) NOT NULL ,
`realm` VARCHAR( 100 ) NOT NULL ,
`name` VARCHAR( 100 ) NOT NULL ,
`charname` VARCHAR( 100 ) NOT NULL ,
`key` VARCHAR( 100 ) NOT NULL ,
`updated` INT( 255 ) NOT NULL ,
`primary` INT( 1 ) NOT NULL ,
`profname` VARCHAR( 100 ) NOT NULL ,
`max` INT( 10 ) NOT NULL ,
`value` INT( 10 ) NOT NULL ,
PRIMARY KEY ( `locale`, `realm`, `name`, `charname`, `key` )
);

MySQL Error : Specified key was too long; max key length is 1000 bytes
Error Number : 1071
Request Date : Monday, June 1st 2009 @ 04:16:39 AM
Error Date : Monday, June 1st 2009 @ 04:16:39 AM
Classname : vB_Database
MySQL Version : 5.1.30

Have tried the fix suggested but am now getting this error:

Database error in vBulletin 3.8.1:

Invalid SQL:

CREATE TABLE IF NOT EXISTS gwowroster_charinfo (
`locale` VARCHAR( 2 ) NOT NULL ,
`realm` VARCHAR( 100 ) NOT NULL ,
`name` VARCHAR( 100 ) NOT NULL ,
`updated` INT( 255 ) NOT NULL ,
`charname` VARCHAR( 100 ) NOT NULL ,
`talentspec` VARCHAR( 10 ) NOT NULL ,
`talenttree` VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY ( `realm`, `charname`, `key` )
);

MySQL Error : Key column 'key' doesn't exist in table
Error Number : 1072
Classname : vB_Database
MySQL Version : 5.1.30

Is there any fix for the first error?

[Replicators]

Gryphon, it's quite obvious your a wow fan, but may i suggest you should of made them more, universal to all mmorpg's, or atleast easy to switch them to suit other mmo's?

[Pen411]

Got this installed and it seems to be working fine, however I read that the high-ascii char issue was fixed, yet I am still seeing jumbled name for toons that have them, and for the most part, it is those names who remain displayed as untalented : http://forums.amazonsguild.com/gwowroster.php

Other than that issue, very nice addon, tyvm!

Also, would it be possible to add another sort field for spec (not talent point allocation, just the text label of that spec, protection/restoration, etc)?