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.

[Bukusami]

No matter, blonde moment all working now

Just need to run update a few hundred times

[theorigin]

This is the error I've been getting since I tried to install it:

Database error in vBulletin 3.7.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

I posted in the Programming Discussion section and was told that there were too many Primary Keys in it and I should take out all except the 'locale' one. I tried that and it went through, but now every time I try and update the profile ID field, it reverts back to the "0" that it started with. I'm guessing this is because I updated the xml file itself? Help would be greatly 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 theorigin

This is the error I've been getting since I tried to install it:

Database error in vBulletin 3.7.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

I posted in the Programming Discussion section and was told that there were too many Primary Keys in it and I should take out all except the 'locale' one. I tried that and it went through, but now every time I try and update the profile ID field, it reverts back to the "0" that it started with. I'm guessing this is because I updated the xml file itself? Help would be greatly appreciated.

[theorigin]

Hmmm...I just tried that, but it's still giving me the same error. I upgraded to 3.7.4 to see if that'd fix it, but it didn't. Looks like I just have to wait on godaddy's response and go from there. Thanks for the help though.

[NeroObsedian]

I'm having some issues with this.

Database error in vBulletin 3.7.2:

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

Array
(
    [globalSearch] => 1
    [lang] => en_us
    [errorhtml] => 
    [guildKey] => Array
        (
            [locale] => US
            [faction] => Horde
        )

    [guildInfo] => Array
        (
            [guild] => Array
                (
                    [count00] => 0
                )

        )

)

I don't know much about SQL, not sure why its not updating. I ran the character update first and that works fine. I have noticed that the userfield ID in the options will only allow the #. My field is 7 and it will only allow me to enter "7" instead of "field7" not sure if that's part of the issue or not.

I've double checked with my host and cURL is good, so I don't think that is the issue.

Same issue as Creme from the previous page it seems.

[Bl00dRoyal]

Is there a way to make it default sort by guild rank ascending from 0 (GM) and up? I think I see the code in the php file but I am a noob and don't want to mess up and do something wrong. Would be a nice feature to have the option within the control panel to switch how it is sorted.

[Finger78]

I have been trying to get this working for over a week, my vb skills are beginner at best, you can see the site here and it appear that the images arent working but I have uploaded everything 4 times both into the forums folders and the root folder for the site and nothing seems to help

http://www.angry-mob.org/forums/gwowroster.php

Also, on the armory links the link it gives is:
http://ushttp//www.wowarmory.com/character-sheet.xml?r=Archimonde&n=<name>

When it should read like:
http://us.wowarmory.com/character-sheet.xml?r=Archimonde&n=<name>

And I cant seem to locate where I would change something to fix this.

[Bl00dRoyal]

the images need to be copied into each style. I had that same problem at first.

[Finger78]

Originally Posted by Bl00dRoyal

the images need to be copied into each style. I had that same problem at first.

Ok, I finally figured out what the issue was, not sure why its like this but here it is.

The avatars worked fine once I upped them to the style directory, but to get the icons to work I had to make a new directory within the gwowroster folder labeled with my style name and drop the icons into that.

My only remaining issue is one I already mentioned - The links provided to link to the US armory appear like this:
http://ushttp//www.wowarmory.com/character-sheet.xml?r=Archimonde&n=<name>

When it should read like:
http://us.wowarmory.com/character-sheet.xml?r=Archimonde&n=<name>

Any ideas?

[Vareyah]

Hi, I just installed this as well as your other mods. I got the wow character mod working, no problem, thanks alot. This was my second step. I don't know what went wrong, but it seems I can not view http://xraided-guild.net/forums/gwowroster.php even as a super administrator. Is there something I missed? If anyone can help me out, I'd appreciate it.

I basically followed all the instructions listed. Is there something I have to do in addition to this with the cron files? It says something about configuring the files, but I'm not sure which files need configuring.