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.

[SlompOchomp]

Originally Posted by Gryphon

I have received the files I will take a look at them when I get time.

Can't wait to see the changes

[Dragonsys]

Originally Posted by Xennor

Everything had been working fine up until a day or so ago. Now we are getting the following error from the cron job:

Invalid SQL:
DELETE FROM vb_gwowroster_rosterinfo WHERE NOT (
			locale IN('US') AND
			realm IN('Doomhammer') 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

Anyone have any ideas?

Probably due to all the changed Blizz made to the Armory for the 3.1 Patch

[Gryphon]

Yeah, the Armory changes most likely broke it. I will have to look into it.

[Xennor]

Originally Posted by Gryphon

Yeah, the Armory changes most likely broke it. I will have to look into it.

Not getting the error anymore with the new version, but now the Race "text" is wrong for everyone. The Race "icon" is right, just the "text" itself is wrong.

[Juravieal]

Im getting this error with a new install:

Warning: require_once(./global.php) [function.require-once]: failed to open stream: No such file or directory in /home/eidolon1/public_html/gwowroster.php on line 46

Fatal error: require_once() [function.require]: Failed opening required './global.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/eidolon1/public_html/gwowroster.php on line 46

[AK47 Nemesis]

Is there an option to set permissions or something? Cause i can't access it after i installed it. I used it before fine, but just updated it to the newest version.

EDIT: Nvm, stupid mistake by me :P.

[quinnie]

I'm getting this error on a new install:

Database error in vBulletin 3.8.2:

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  : Tuesday, April 21st 2009 @ 05:26:10 AM
Error Date    : Tuesday, April 21st 2009 @ 05:26:10 AM
Script        : /admincp/plugin.php?do=productimport
Referrer      : /admincp/plugin.php?do=productadd
Classname     : vb_database
MySQL Version : 5.0.58-log

Just wondering if this is anything I'm doing wrong? MySQL version not supported?

[kemical]

I am getting the same error on a new installation:

Database error in vBulletin 3.8.2:

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  : Thursday, April 23rd 2009 @ 12:10:14 PM
Error Date    : Thursday, April 23rd 2009 @ 12:10:15 PM
Script        : /admincp/plugin.php?do=productimport
Referrer      : /admincp/plugin.php?do=productadd
Classname     : vB_Database_MySQLi
MySQL Version : 5.1.30

[imported_sasavtec]

Same issue as the last 2 posts

[imported_sasavtec]

Anyone know a solution to fix this and get it working?