Go Back   vb.org Archive > vBulletin Modifications > vBulletin 3.8 Modifications > vBulletin 3.8 Add-ons
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
gWoWRoster - World of Warcraft Guild Roster Details »»
gWoWRoster - World of Warcraft Guild Roster
Version: 1.0.14, by Gryphon Gryphon is offline
Developer Last Online: Sep 2023 Show Printable Version Email this Page

Category: Add-On Releases - Version: 3.8.x Rating:
Released: 02-14-2008 Last Update: 01-31-2010 Installs: 193
Supported DB Changes Uses Plugins Auto-Templates
Re-useable Code Additional Files  

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!


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:
      Code:
      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]
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.

Download Now

File Type: zip gWoWRoster_v1.0.9_avatars.zip (597.5 KB, 511 views)
File Type: zip gWoWRoster_v1.0.14a.zip (1.63 MB, 194 views)

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #142  
Old 11-27-2008, 05:20 PM
atomhead atomhead is offline
 
Join Date: Nov 2007
Posts: 26
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #143  
Old 12-02-2008, 12:12 PM
hunteds911 hunteds911 is offline
 
Join Date: Mar 2007
Posts: 18
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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

I get this error below. Any Ideas?

Code:
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
Reply With Quote
  #144  
Old 12-02-2008, 01:46 PM
atomhead atomhead is offline
 
Join Date: Nov 2007
Posts: 26
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by hunteds911 View Post
After updating to 1.09 when trying to run the scheduled task for gWoWRoster Guild Info Update.

I get this error below. Any Ideas?

Code:
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
Reply With Quote
  #145  
Old 12-09-2008, 01:26 PM
atomhead atomhead is offline
 
Join Date: Nov 2007
Posts: 26
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Wayne Luke View Post
Here is the fix for the divide by zero error:
Code:
 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
Reply With Quote
  #146  
Old 12-10-2008, 03:47 PM
CremeEgg CremeEgg is offline
 
Join Date: Mar 2006
Location: Bradford, UK
Posts: 30
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #147  
Old 12-12-2008, 10:20 AM
CremeEgg CremeEgg is offline
 
Join Date: Mar 2006
Location: Bradford, UK
Posts: 30
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I am getting the following error repeatedly mailed to me:

Code:
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.
Reply With Quote
  #148  
Old 12-14-2008, 06:04 PM
mozik mozik is offline
 
Join Date: Sep 2008
Posts: 38
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Mine will not update, How long does it take?
Reply With Quote
  #149  
Old 12-19-2008, 10:24 PM
phreak9i6 phreak9i6 is offline
 
Join Date: Sep 2006
Posts: 2
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

(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
Code:
        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:
Code:
exec_cron($cronid);
to:
Code:
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:

Code:
* * * * * 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
Reply With Quote
  #150  
Old 12-19-2008, 10:36 PM
Gryphon's Avatar
Gryphon Gryphon is offline
 
Join Date: Oct 2001
Location: Seattle, WA
Posts: 617
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #151  
Old 12-21-2008, 03:33 PM
Bukusami Bukusami is offline
 
Join Date: Mar 2006
Posts: 41
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 01:00 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05841 seconds
  • Memory Usage 2,360KB
  • Queries Executed 26 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (9)bbcode_code
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (4)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (2)postbit_attachment
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_attachment
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete