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.

[Finger78]

I have found a fix for my issue above but I would like to know if their is a proper fix for it

I fixed it by editing the gwr_roster_bit template and removed all lines that had

http://$armory

and changed it to

http://us.wowarmory.com

I'm sure this is not a proper way of changing this and would like to know a way to change it that would leave the original system intact

Also, the "Skills" link is non functional, I can only assume this is due to Blizzard changing their site, I changed mine to Achievements in the above mentioned template from:

http://$armory/character-skills.xml?

to

http://us.wowarmory.com/character-achievements.xml?$player[charurl]" target="_blank">Achievements</a>

[Gryphon]

@theorigin, there is no easy solution at the moment. The multiple keys are currently used to facilitate REPLACE queries. I will look into it, though I cannot say with certainty when or if it will ever be addressed.

@NeroObsedian, the Armory is returning an error page for whatever guild is trying to be fetched. The mysql error is due to no legitimate guild information retrieved in the first place. I am not sure what the issue could be however. It may be improper guild name entry in the options, special characters in the guild name, or armory is down. I am unsure exactly.

@Bl00dRoyal, you could try changing the default sort on line 238 in gwowroster.php from $sort_query = "r.level DESC"; to $sort_query = "r.rank ASC";.

@Finger78, I can not view your roster as a guest, though the images need to be uploaded per style, this is how my mods work to allow separate images per style. I am unsure why you had issue with your style needing folders to be created/renamed. I see you have several styles which, admittedly, can be a pain having to upload this mods images for each style. All I can guess is it was just a simple mistake in the upload process, they should all have the same structure.

Regarding the armory url, you may have a replacement variable that is modifying the output. I double checked my code and as far as I can see, it is not my code causing the odd urls.

With the Skills tab being dropped from the Armory, I will change the link to Achievements for future versions.

[Finger78]

Originally Posted by Gryphon

@Finger78, I can not view your roster as a guest, though the images need to be uploaded per style, this is how my mods work to allow separate images per style. I am unsure why you had issue with your style needing folders to be created/renamed. I see you have several styles which, admittedly, can be a pain having to upload this mods images for each style. All I can guess is it was just a simple mistake in the upload process, they should all have the same structure.

Regarding the armory url, you may have a replacement variable that is modifying the output. I double checked my code and as far as I can see, it is not my code causing the odd urls.

With the Skills tab being dropped from the Armory, I will change the link to Achievements for future versions.

Not sure why, yes I do have several style and I uploaded the roster images to whatever random spot for each style (viewed it in IE and just looked at the broken images to see where it was looking then uploaded to there)

As for the url, not sure myself why the problem exsists, I couldnt find any other variable that would change it but its fixed now.

Glad I could help with the skills link.

Thanks for this great mod, my guild members are raving about it daily for ease of info about themselves and others in the guild A++ mod

[theorigin]

Originally Posted by Gryphon

@theorigin, there is no easy solution at the moment. The multiple keys are currently used to facilitate REPLACE queries. I will look into it, though I cannot say with certainty when or if it will ever be addressed.

Do you think this is something that could be fixed by upgrading to MySQL 5?

[Gryphon]

Originally Posted by theorigin

Do you think this is something that could be fixed by upgrading to MySQL 5?

I am not sure. I am currently running MySQL 5, though I am pretty sure that ran this when I was using MySQL 4, it may be some other setting.

[theorigin]

Originally Posted by Gryphon

I am not sure. I am currently running MySQL 5, though I am pretty sure that ran this when I was using MySQL 4, it may be some other setting.

This is the common error I'm getting every time I try it..

MySQL Error   : Specified key was too long; max key length is 1000 bytes

Is there any way to extend the max key length?

[Dragonsys]

I would like to see about adding Profession and Achievement information

and possibly adding an Admin section for Guild Ranks, so you can add the names of the Rank, instead of just seeing the Rank Number...

[Rigar]

Really nice addon, lots of possibilities here. I've kinda gotten myself involved in trying to get the special characters to work. From a previous post people linked to WoWRoster as an example of a prog that seems to be able to do this. I went to their forums and found a nice thread on this subject.

So as it is we have special characters in the DB stored as ISO-8859-1? Is there a way to use utf8_decode and utf8_encode so that these names are displayed correctly?

[jlew24asu]

Originally Posted by Gryphon

Only about 10 million

wow 10 million? I had no idea it was so popular.

[jlew24asu]

how many WoW boards are out there?