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.

[Sarvoth]

Hi!

I love this mod. It works great.

[s]I am wondering if there is anyway to pull the guild rank from the roster and display it? If not, might be a good idea to include if you update this.[/s]:up:

Ok I am an idiot. It does do this, but for some reason I thought it was PVP rank. LOL anyways... I notice when I sort it, some rank 2's appear at the top of the list, then it goes 1s, then finally to 0. Doesn't seem to be sorting right.

[slick368]

I tried installing this mod on my site and received the following database error:

Database error in vBulletin 3.7.3:

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
Classname     : vB_Database_MySQLi
MySQL Version : 5.0.51a-community

I have tried installing this on my live site and a test site that has no other plug-ins installed. I have successfully installed the other gWoW add-ons and have experienced no problems.

I would like to find a way to resolve this problem since this add-on is something I really want to have for my guild's site. Any help would be appreciated!

[slick368]

I had the same problem with when I tried to install. Go to your forum's database in phpMyAdmin or whatever you use to manage your database and make sure the database collation is set to latin1_generalci. All of my databases default to utf8_unicode_ci and that is what caused the problem.

If you are using phpMyAdmin, you can find the setting by selecting your forum's database, then clicking the Operations tabe. The collation setting is near the bottom.

Once the change was made, the add-on installed for me without a hitch. Hope this helps!

Originally Posted by 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

[forumrunt]

can this be used for more than one Guild on a single site?

[Gryphon]

Originally Posted by forumrunt

can this be used for more than one Guild on a single site?

Yes, see this site click "Alleria: Allied Tribal Forces" for a drop down of other guilds and servers.

[forumrunt]

awesome thanks

[forumrunt]

not updating for some reason

[forumrunt]

<a href="http://www.worldofwarcraftkids.com/forum/gwowroster.php?loc=US&realm=Rexxar&name=Hardcore+H orde" target="_blank">http://www.worldofwarcraftkids.com/f...Hardcore+Horde</a>

Can you see what I have going on here and how I can fix it?

[WNxWakko]

Two issues.

1. The spec section isnt updaing. The icon just spins as it seems to not be gathering the data.
2. I have a batch of level 80 avatars, I uploaded the directory matching what level 70 would be but not sure how to configure it to use them.

[Gryphon]

1. There are two processes that happen, 1 it fetches the guild roster and populates that data, and 2 over the course of 24 hours it fetches each character for their talent data, so it can take a little time to get the talents. It's also possible if you have a huge roster that the vBulletin mock cron job is just not powerful enough to process the armory data, I run my vB cron via true cron to ensure that it runs completely. The Armory was wiped of character data a couple week ago or so, anyone who has not logged in since then will not have talent data until they login.

2. There shouldn't be anything to do, it will use the avatars when a character turns 80 just like the other level avatars. It is just in two zips here because vB.org won't allow one large zip.