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.

[atomhead]

Armory light links aren't working. Statistics page has some errors. Other than that, seems to be working ok. Wish there was a way to tag alts and mains on the armory!

http://www.tsbguild.com/forums/gwowroster.php

[hunteds911]

After updating to 1.09 when trying to run the scheduled task for gWoWRoster Guild Info Update.

I get this error below. Any Ideas?

Database error in vBulletin 3.7.4:

Invalid SQL:
REPLACE INTO gwowroster_hist_guildinfo SET 
				locale = 'US' ,
				realm = 'Blackhand' ,
				name = 'Reapers of Souls' ,
				faction = 'Horde' ,
				membercount = '36' ,
				count80 = '1' ,
				count70 = '11' ,
				count60 = '8' ,
				count50 = '6' ,
				count40 = '1' ,
				count30 = '2' ,
				count20 = '4' ,
				count10 = '3' ,
				count00 = '0' ,
				class1 = '2' ,
				class2 = '4' ,
				class3 = '4' ,
				class4 = '6' ,
				class5 = '3' ,
				class6 = '10' ,
				class7 = '' ,
				class8 = '3' ,
				class9 = '2' ,
				class11 = '2' ,
				race1 = '' ,
				race2 = '5' ,
				race3 = '' ,
				race4 = '' ,
				race5 = '5' ,
				race6 = '2' ,
				race7 = '' ,
				race8 = '' ,
				race10 = '24' ,
				race11 = '' ,
				racegen11 = '' ,
				racegen10 = '' ,
				racegen21 = '' ,
				racegen20 = '5' ,
				racegen31 = '' ,
				racegen30 = '' ,
				racegen41 = '' ,
				racegen40 = '' ,
				racegen51 = '' ,
				racegen50 = '5' ,
				racegen61 = '' ,
				racegen60 = '2' ,
				racegen71 = '' ,
				racegen70 = '' ,
				racegen81 = '' ,
				racegen80 = '' ,
				racegen101 = '15' ,
				racegen100 = '9' ,
				racegen111 = '' ,
				racegen110 = '' ,
			 date = '1228194000';

MySQL Error   : Unknown column 'count80' in 'field list'
Error Number  : 1054
Request Date  : Tuesday, December 2nd 2008 @ 09:10:16 AM
Error Date    : Tuesday, December 2nd 2008 @ 09:10:21 AM
Script        : http://realmgfx.com/forum/admin_cp/cronadmin.php?do=runcron&cronid=34
Referrer      : http://realmgfx.com/forum/admin_cp/index.php
IP Address    : 173.45.198.113
Username      : Hunted
Classname     : vb_database
MySQL Version : 5.0.51a-log

[atomhead]

Originally Posted by hunteds911

After updating to 1.09 when trying to run the scheduled task for gWoWRoster Guild Info Update.

I get this error below. Any Ideas?

Database error in vBulletin 3.7.4:

Invalid SQL:
REPLACE INTO gwowroster_hist_guildinfo SET 
				locale = 'US' ,
				realm = 'Blackhand' ,
				name = 'Reapers of Souls' ,
				faction = 'Horde' ,
				membercount = '36' ,
				count80 = '1' ,
				count70 = '11' ,
				count60 = '8' ,
				count50 = '6' ,
				count40 = '1' ,
				count30 = '2' ,
				count20 = '4' ,
				count10 = '3' ,
				count00 = '0' ,
				class1 = '2' ,
				class2 = '4' ,
				class3 = '4' ,
				class4 = '6' ,
				class5 = '3' ,
				class6 = '10' ,
				class7 = '' ,
				class8 = '3' ,
				class9 = '2' ,
				class11 = '2' ,
				race1 = '' ,
				race2 = '5' ,
				race3 = '' ,
				race4 = '' ,
				race5 = '5' ,
				race6 = '2' ,
				race7 = '' ,
				race8 = '' ,
				race10 = '24' ,
				race11 = '' ,
				racegen11 = '' ,
				racegen10 = '' ,
				racegen21 = '' ,
				racegen20 = '5' ,
				racegen31 = '' ,
				racegen30 = '' ,
				racegen41 = '' ,
				racegen40 = '' ,
				racegen51 = '' ,
				racegen50 = '5' ,
				racegen61 = '' ,
				racegen60 = '2' ,
				racegen71 = '' ,
				racegen70 = '' ,
				racegen81 = '' ,
				racegen80 = '' ,
				racegen101 = '15' ,
				racegen100 = '9' ,
				racegen111 = '' ,
				racegen110 = '' ,
			 date = '1228194000';

MySQL Error   : Unknown column 'count80' in 'field list'
Error Number  : 1054
Request Date  : Tuesday, December 2nd 2008 @ 09:10:16 AM
Error Date    : Tuesday, December 2nd 2008 @ 09:10:21 AM
Script        : http://realmgfx.com/forum/admin_cp/cronadmin.php?do=runcron&cronid=34
Referrer      : http://realmgfx.com/forum/admin_cp/index.php
IP Address    : 173.45.198.113
Username      : Hunted
Classname     : vb_database
MySQL Version : 5.0.51a-log

same problem for me

[atomhead]

Originally Posted by Wayne Luke

Here is the fix for the divide by zero error:

 function gwr_percent_members($number, $members)
 {
  $members > 0 ? $number = ($number / $members) * 100: $number = 0;
  return number_format($number, 2);
 }
?>

---------------------------
For pulling the talents, you have to run the gWoWRoster Character Info Update cron as well. It only pulls a couple characters each time you run it so if you have a lot of characters then you will have to run it quite a few times. However it will automatically run every 10 minutes as people use your board and slowly pull all the characters. I was impatient and running it on my local machine so removed the limit and set the PHP timeouts to 20 hours and ran it. Only took about 20 minutes to pull all 103 characters from the armory.

There now that I have this installed, tweaked and working on my development installation, time to go look at your event mod.

I think my PHP is timing out on the cron job. How would I fix that?

Invalid SQL:
REPLACE INTO vb_gwowroster_charinfo SET
locale = 'US' ,
realm = 'Altar of Storms' ,
name = 'The Sunshine Bunch' ,
charname = 'Thex' ,
talentspec = '17,0,54' ,
talenttree = '2305020500000000000000000000000000000000000000000 000000230200335023105203100203133151' ,
updated = '1228835992';

MySQL Error : MySQL server has gone away
Error Number : 2006

[CremeEgg]

I have a couple of quick questions, now most of this is probably down to the Armory being about as stable as a chocolate fireguard.

I'm finding more often than not that the characters talents are blank. Even in cases where less than 24 hours ago they were talented.

Could we have some kind of caching added here? I mean once level 80 and raiding spec isn't going to change all that often.

Also if there is a talent build in the database already that is less than say 14 days old, exclude it from the cron update.

I've probably not explained this all that well, but I just don't see the point in going to the armory for data all the time when it's probably not changed and also if you don't get a decent answer from the armory then the spec will disappear.

[CremeEgg]

I am getting the following error repeatedly mailed to me:

Database error in vBulletin 3.7.4:

Invalid SQL:
DELETE FROM vb_gwowroster_rosterinfo WHERE NOT (
locale IN('EU') AND
realm IN('Ravencrest') 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

Any help with this would be appreciated.

[mozik]

Mine will not update, How long does it take?

[phreak9i6]

(correct me if im wrong people)

The task that populates and updates the data runs when pages on the site are loaded. This isn't guaranteed on every page load, just when the page load co-insides with the job schedule. We have 119 guildies, so if the job runs every 15 min like default it would take quite some time to run.

What I did was copy the cron.sh file to grosterupdate.php

Find this section

        if ($vbulletin->options['crontab'] AND SAPI_NAME == 'cli')
        {
                $cronid = intval($_SERVER['argv'][1]);
                // if its a negative number or 0 set it to NULL so it just grabs the next task
                if ($cronid < 1)
                {
                        $cronid = NULL;
                }
        }

        exec_cron($cronid);

change the line I bolded above to match the schedule id of your "gWoWRoster Character Info Update" scheduled task. For me it was "18".

change the line:

exec_cron($cronid);

to:

exec_cron(actual_job_id);

substitute actual_job_id for the schedule id number.


then you can call this from crontab or run it manually a bunch of times.

add something like this to your unix crontab:

* * * * * php /usr/local/www/path/to/forums/grosterupdate.php >& /dev/null

this will run it every minutes. Its not the best way to do it, I would set it to like say every 10-15 min or so. refer to the crontab documentation for details on that.

Or just run it like this from the command line: php /usr/local/www/path/to/forums/grosterupdate.php

Remember that it only updates 1 member at a time so if you guild has 100 users, it needs to run 100 times.

-ken

[Gryphon]

You don't have to load a page at the scheduled time, if you load a page after 20 minutes it will run all scheduled tasks that are due.

I don't recommend editing any files.

You can just run path/to/forums/cron.php every minute and all scheduled tasks will run when scheduled, this is the method I use.

[Bukusami]

Silly question, how do i find out the userfield id to input in the options?