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.

[Danoxth]

Just installed the latest version and seem to be getting this error when I run the scheduled task to scan the armoury for the main roster:

"Fatal error: Call to undefined function curl_init() in xxxxxxxxxxxxxxx\class_gwowarmory.php on line 174"

Edit: My bad, presume I need to get curl installed on server then?

[Tolas]

Latest version is working like a Champ!

Thanks Gryphon.

[GabbaGandalf198]

i have still a problem, when updating users with special characters like ^ oder `, i tries the solution on the page before but it isn't working for me ;(

[poninja]

Two requests. First, it looks like the country isn't getting passed to the armory-lite link. You're linking to http://www.armory-light.com//Fenris/Vathek/ instead of http://www.armory-light.com/us/Fenris/Vathek/

Second, I don't know if there would be an easy way to exclude members from the roster page by name, but we have several members on the armory that haven't actually been in our guild in over a year and it would be nice to be able to filter them on our website.

[Gryphon]

Originally Posted by poninja

Two requests. First, it looks like the country isn't getting passed to the armory-lite link. You're linking to http://www.armory-light.com//Fenris/Vathek/ instead of http://www.armory-light.com/us/Fenris/Vathek/

Released 1.0.5 to fix this issue.

Originally Posted by poninja

Second, I don't know if there would be an easy way to exclude members from the roster page by name, but we have several members on the armory that haven't actually been in our guild in over a year and it would be nice to be able to filter them on our website.

I can look into this, however, I can't promise I can implement it anytime soon as I am stretched thin on both my public and private projects.

[Warion]

could this roster be set up for other games. Ones without updates fromthe games themselves. Just a roster that users could manually add mains and alts to the roster. I run a forum for multiple games, so would need to be able to run atleast for different rosters. Any help would be great.

[Gryphon]

I am afraid not.

[gusfune]

I got this error:

Database error in vBulletin 3.7.2:

Invalid SQL:

    CREATE TABLE IF NOT EXISTS vb_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, October 6th 2008 @ 02:14:18 PM
Error Date    : Monday, October 6th 2008 @ 02:14:18 PM
Script        : http://x.com/admincp/plugin.php?do=productimport
Referrer      : http://x.com/admincp/plugin.php?do=productadd
IP Address    : x9.x6.x4.x0
Username      : admin
Classname     : vB_Database
MySQL Version : 5.0.67-log

Can't add product

[hunteds911]

I created a new guild the other night and then changed out the guild name in gwowroster options to reflect a new guild. Now when I run the gwowroster guild info update from the scheduled tasks I get the following. It worked before I changed the guild name btw.

Database error in vBulletin 3.7.3:

Invalid SQL:
DELETE FROM gwowroster_rosterinfo WHERE NOT (
			locale IN('US') AND
			realm IN('Blackhand') AND
			charname IN()
		);

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
		)' at line 4
Error Number  : 1064
Request Date  : Friday, October 10th 2008 @ 09:52:10 AM
Error Date    : Friday, October 10th 2008 @ 09:52:15 AM
Script        : http://realmgfx.com/forum/admin_cp/cronadmin.php?do=runcron&cronid=30
Referrer      : http://realmgfx.com/forum/admin_cp/index.php
IP Address    : 24.219.216.156
Username      : Hunted
Classname     : vb_database
MySQL Version : 5.0.51a-log

[civy]

getting the following error

gWoWRoster Guild Info Update

Fatal error: Cannot use string offset as an array in /home/waruser/public_html/forum/includes/cron/cron.gwowroster.guildinfo.php on line 62

guild info is

EU|skullcrusher|knight of the temple

any idea?