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.

[Dragonsys]

Originally Posted by DR AUTONAMUS

Not possible.

$char['charname'] = utf8_decode(urlencode($char['charname']));

is not found, what is found is.

$char['charname'] = utf8_encode($char['charname']);

and why replace it with a piece of code that is commented out with //?


In no place in the file cron.gwowroster.charinfo.php is the text

found.

ok so I remembered the original line wrong.
Replace that line you found. If you look the replace code is 2 lines, the commented out one was just the original code, you don't have to keep it

[DR AUTONAMUS]

But, the word urlencode does not exist anywhere in that file...

[Dragonsys]

Originally Posted by DR AUTONAMUS

But, the word urlencode does not exist anywhere in that file...

just replace this line:

$char['charname'] = utf8_encode($char['charname']);

[DataHero]

EDIT: alright, I've found a fix to the issue with the database error when trying to install the product.

Go to your PHPMyAdmin, and execute the following command:

ALTER DATABASE yourdbname CHARACTER SET latin1 COLLATE latin1_swedish_ci;

That should change the database's character set you're currently using to latin1_swedish_ci (ISO-8859-1). It installed without any issue now. The only possible issue I could imagine happening would be names that are absolutely multi-byte - such as Japanese; I don't think that is used in WoW, though.


Thanks for the add-on, by the way! Very nice, and much appreciated. Installed.

[DataHero]

Pardon for the double post.

It seems that the guild roster does not contain any data regarding the Goblins and their class, and the same goes for the Worgen. I realize this, as the release of Cataclysm was obviously later than the latest build of this modification.

So, does anybody know what I should do as to add these races to it? And even then, what raceid's would these have?

I also have a second problem oddly enough; the roster only shows about 5 people with spec, and the rest of them are all the time "in progress" (the .gif), and also appear as untalented.

Any help would be greatly appreciated.

[Dragonsys]

Originally Posted by DataHero

Pardon for the double post.

It seems that the guild roster does not contain any data regarding the Goblins and their class, and the same goes for the Worgen. I realize this, as the release of Cataclysm was obviously later than the latest build of this modification.

So, does anybody know what I should do as to add these races to it? And even then, what raceid's would these have?

I also have a second problem oddly enough; the roster only shows about 5 people with spec, and the rest of them are all the time "in progress" (the .gif), and also appear as untalented.

Any help would be greatly appreciated.

Yeah, this mod needs work for Cata data to show up properly. I have done some pretty extensive work on it, but have not yet had a chance to send it to the Author.

Worgen = 22
Goblin = 9

as for the Specs, give it time. It takes awhile for Cron script to get all of your toons data updated.

[DataHero]

Hey there Dragonsys,

Thanks for the quick response. Much appreciated.

I've also, however, encountered another issue. Apparently, when I try to re-install this modification, it gives me the following error:

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 : Tuesday, January 11th 2011 @ 04:38:39 AM
Error Date : Tuesday, January 11th 2011 @ 04:38:40 AM
Script : http://mydomain.com/forum/acp/plugin...=productimport
Referrer : http://mydomain.com/forum/acp/plugin.php?do=productadd
IP Address : **.***.***.***
Username : ****
Classname : vB_Database
MySQL Version : 5.1.51-log

The reason I reinstalled this is because I changed the character set from utf8 to latin1. It installed fine then, but then character names - such as K?ri? - appeared oddly with copyright symbols and whatnot, as latin1 isn't multi-byte supportive.

From my understanding, the reason this occurs is because these values are occurring:

(2 + 100 + 100 + 100 + 100 + 100) * 3 = 1506 bytes

Any way to have a workaround to either the 1000bytes error, or the characters whilst using another character set than utf8 (should the former not be fixable ATM)?


Cheers,
DataHero

[Dragonsys]

the table gwowroster_charinfo_prof is not actually used by this mod and should be removed.

[jimfries]

I opened the gwowroster file, but do not see any SQL command to add that table at all. I manually added the table just to see if it would skip that step (given it asks "if table does not exist", but still receive the error.

[Dragonsys]

Originally Posted by jimfries

I opened the gwowroster file, but do not see any SQL command to add that table at all. I manually added the table just to see if it would skip that step (given it asks "if table does not exist", but still receive the error.

the xml file has the command to create the table