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.

[Dragonsys]

Originally Posted by jlew24asu

how many WoW boards are out there?

tons of them.

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

Ok, I added all of this myself...
http://www.dragons-server.com/forums/gwowroster.php

[y2krazy]

Originally Posted by Dragonsys

Ok, I added all of this myself...
http://www.dragons-server.com/forums/gwowroster.php

How did you get those added? Would you mind sharing? Thanks. <3

~ Sean

[Tolas]

Originally Posted by Dragonsys

tons of them.



Ok, I added all of this myself...
http://www.dragons-server.com/forums/gwowroster.php

Originally Posted by y2krazy

How did you get those added? Would you mind sharing? Thanks. <3

~ Sean

Would love to see these changes also, your roster looks great!

[y2krazy]

Also, just a question for curiosity's sake:

Does the Armory update only look up 1 person every 10 minutes? I suppose after a day 120-ish would be looked up, but what if I am trying to update several guild rosters, totalling 500+ chars? I'll just have to wait 3-4 days for them to all update?

At the time when they are all updated, does the armory update start again? Ie - every 3-4 days, everyone should be updated?

Thanks.

~ Sean

[shadowedsoul]

First off, great mod, I've been able to make a few small content changes without any issue at all. The biggest problem I'm having at the moment though, I'm trying to convert this to a php page for vbadvanced and running into nothing but trouble. The formatting goes completely away.

Has anyone been able to pull this off?

[robster1225]

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.

I'm having this same problem, is there any fix?

[Dragonsys]

Originally Posted by y2krazy

How did you get those added? Would you mind sharing? Thanks. <3

~ Sean

a lot of changes in the templates and files, plus a few template replacement vars & SQL structure changes.
I can share my changes, if Gryphon OKs it.

[Dragonsys]

Originally Posted by y2krazy

Also, just a question for curiosity's sake:

Does the Armory update only look up 1 person every 10 minutes? I suppose after a day 120-ish would be looked up, but what if I am trying to update several guild rosters, totalling 500+ chars? I'll just have to wait 3-4 days for them to all update?

At the time when they are all updated, does the armory update start again? Ie - every 3-4 days, everyone should be updated?

Thanks.

~ Sean

yeah, it only updates 1 toon each time it runs. Now the problem is that the Scheduled Tasks in VB only run, when someone visits the site. So they could very well build up and be WAY behind, causing the Roster to only update once a day (which is what was happening with mine, I have a rather "slow" site). I found a mod which changes this to run on the server's cron instead, so things actually run when they are supposed to.

If you can add tasks to your crontab, this is the mod I use - https://vborg.vbsupport.ru/showthread.php?t=164477 (works fine on vb 3.8.x). I have it run every minute, and now my tasks are never behind. Of course it took a few minutes to get caught up, because VB will only run 1 command at each execution.

[y2krazy]

Originally Posted by Dragonsys

a lot of changes in the templates and files, plus a few template replacement vars.
I can share my changes, if Gryphon OKs it.

Sounds like a plan. Thanks.

Originally Posted by Dragonsys

yeah, it only updates 1 toon each time it runs. Now the problem is that the Scheduled Tasks in VB only run, when someone visits the site. So they could very well build up and be WAY behind, causing the Roster to only update once a day (which is what was happening with mine, I have a rather "slow" site). I found a mod which changes this to run on the server's cron instead, so things actually run when they are supposed to.

If you can add tasks to your crontab, this is the mod I use - https://vborg.vbsupport.ru/showthread.php?t=164477 (works fine on vb 3.8.x). I have it run every minute, and now my tasks are never behind. Of course it took a few minutes to get caught up, because VB will only run 1 command at each execution.

Maybe I'm not familiar enough with Scheduled Tasks. In order for their "Next Time" to be updated, someone has to actually visit a page with $cronimage to perform the update? It's on a development board at this time, so there's little to no activity. Could this be why things are updating so slow or not at all? Thanks.

~ Sean

[Dragonsys]

Originally Posted by y2krazy

Maybe I'm not familiar enough with Scheduled Tasks. In order for their "Next Time" to be updated, someone has to actually visit a page with $cronimage to perform the update? It's on a development board at this time, so there's little to no activity. Could this be why things are updating so slow or not at all? Thanks.

~ Sean

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

vBulletins schedule tasks only run when a user is browsing your forum. With the release of 3.6 and RSS imports this has caused problems for slow moving forums importing fast moving RSS feeds (If a news item passes fully through the RSS feed before a visitor browses your forums causing the import to be processed then content could be lost)

I sent a meassge to Gryphon about my changes.