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.

[y2krazy]

Originally Posted by Dragonsys

exactly. Here's a little info, as an example

Ok. I won't worry about it too much until it goes live. Thanks for the help.

Originally Posted by Dragonsys

I sent a meassge to Gryphon about my changes.

Awesome. <3

~ Sean

[N00BIE]

Hi =] i have have the roster all working fine apart from a slight problem with the names column some of our players have long name and that over laps their talent spec how to i make the name column wider i gather it's in the gwowroster template section some where =] ??
complete VB noobie =]
many thanx

[y2krazy]

Originally Posted by N00BIE

Hi =] i have have the roster all working fine apart from a slight problem with the names column some of our players have long name and that over laps their talent spec how to i make the name column wider i gather it's in the gwowroster template section some where =] ??
complete VB noobie =]
many thanx

In the template, "gwr_roster":

Find:

<td class="thead" nowrap="nowrap" width="100%"><a href="gwowroster.php?$guild[url]&page=$pagenumber&amp;sortfield=name&amp;sortorder=$oppositesort">Name</a> <if condition="$sortfield == name"><a href="gwowroster.php?$guild[url]&page=$pagenumber&amp;sortfield=name&amp;sortorder=$oppositesort"><img class="inlineimg" src="$stylevar[imgdir_button]/sort$oppositesort.gif" alt="$vbphrase[reverse_sort_order]" border="0" /></a></if></td>

Change:

<td class="thead" nowrap="nowrap" width="100%"><a href="gwowroster.php?$guild[url]&page=$pagenumber&amp;sortfield=name&amp;sortorder=$oppositesort">Name</a> <if condition="$sortfield == name"><a href="gwowroster.php?$guild[url]&page=$pagenumber&amp;sortfield=name&amp;sortorder=$oppositesort"><img class="inlineimg" src="$stylevar[imgdir_button]/sort$oppositesort.gif" alt="$vbphrase[reverse_sort_order]" border="0" /></a></if></td>

Instead of "100%", change it to a numeric value, such as "300" and see if that changes anything. It may cause your other sections to stretch out a bit, depending on your resolution. If you need it bigger, increase the number, if you need it smaller, decrese the number. Let me know how that works!

~ Sean

[Dragonsys]

Originally Posted by N00BIE

Hi =] i have have the roster all working fine apart from a slight problem with the names column some of our players have long name and that over laps their talent spec how to i make the name column wider i gather it's in the gwowroster template section some where =] ??
complete VB noobie =]
many thanx

the field size is dynamic. it will grow and shrink as needed. If you have information which is overlapping, then you have 1 or 2 problems with your forum style.

1. Your style is probably fixed width, and therefore does not allow the table to "grow"
2. Your screen display size is low

You can set the cell size as y2krazy suggested, just be aware that this will limit the size of the other fields in the table.

[Gryphon]

About how many characters it updates at a time;

It actually updates the roster count divided by 70 and rounded up. If you have more than 70 people on the roster, it will do 2 at a time, if more than 140 it will do 3 at a time. It picks the oldest updated characters to fetch each run and it is scheduled to run about 140 times a day.

This can be improved a little bit, but for the most part, if you try and gather too many at once it just won't run on vBulletin's mock cron.

I have many mods I have created that do external data fetches like this mod, so I also run the vB Scheduled Tasks via try cron to ensure that it runs once a minute regardless of forum traffic. But I mainly do this because external data fetches are often slow and/or intensive so even if you had 1000 hits a minute on your site, vBulletin's mock cron just isn't powerful enough to execute properly.

[MiskaTorn]

Will this function properly in 3.8.1? Sorry if this has already been addressed, I did a search and did not find anything.

[Gryphon]

Originally Posted by MiskaTorn

Will this function properly in 3.8.1? Sorry if this has already been addressed, I did a search and did not find anything.

It should be pretty independent of vBulletin version, there would have to be significant changes in vBulletin for this to not work.

[Dragonsys]

Originally Posted by Gryphon

About how many characters it updates at a time;

It actually updates the roster count divided by 70 and rounded up. If you have more than 70 people on the roster, it will do 2 at a time, if more than 140 it will do 3 at a time. It picks the oldest updated characters to fetch each run and it is scheduled to run about 140 times a day.

This can be improved a little bit, but for the most part, if you try and gather too many at once it just won't run on vBulletin's mock cron.

I have many mods I have created that do external data fetches like this mod, so I also run the vB Scheduled Tasks via try cron to ensure that it runs once a minute regardless of forum traffic. But I mainly do this because external data fetches are often slow and/or intensive so even if you had 1000 hits a minute on your site, vBulletin's mock cron just isn't powerful enough to execute properly.

Ahhh ok, I only have 10 members, so I have only seen 1 character at a time. I agree about VB's sudo-cron. It's kind of clunky and slow, plus I would imgine it can get overloaded easily. This is why I use the cron mod I posted earlier as well.

Originally Posted by MiskaTorn

Will this function properly in 3.8.1? Sorry if this has already been addressed, I did a search and did not find anything.

yes, it functions perfectly fine in 3.8.1

[y2krazy]

Originally Posted by MiskaTorn

Will this function properly in 3.8.1? Sorry if this has already been addressed, I did a search and did not find anything.

Yes. Working well on my dev board. Only issue I'm having is a lack of scheduled tasks being run when they're supposed to; but, it's a dev board, so there's little to no activity on it, so I'm not worried about that.

If your board is active, you should have no issues.

By the way, Gryphon, you had a chance to look over Dragonsys's PM?

~ Sean

[MiskaTorn]

Originally Posted by theorigin

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?

I am getting the same error.