Go Back   vb.org Archive > vBulletin Modifications > vBulletin 3.8 Modifications > vBulletin 3.8 Add-ons
Reload this Page Add-On Releases - gWoWRoster - World of Warcraft Guild Roster
FAQ Community Calendar Today's Posts Search

Reply
Page 7 of 31 « First 56 7 8917 Last »
 
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
  #62  
Old 03-28-2008, 02:14 AM
burn420 burn420 is offline
 
Join Date: Mar 2008
Posts: 3
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
I`am getting the following error when trying to install and i have no clue how to fix.
Any help ?

Code:
Invalid SQL:

	CREATE TABLE IF NOT EXISTS vbb_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
Reply With Quote
  #63  
Old 03-29-2008, 03:42 PM
neo88's Avatar
neo88 neo88 is offline
 
Join Date: Mar 2002
Posts: 23
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
I am also having the same error as Burn.. Any suggestions?
Reply With Quote
  #64  
Old 04-01-2008, 02:57 AM
burn420 burn420 is offline
 
Join Date: Mar 2008
Posts: 3
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by neo88 View Post
I am also having the same error as Burn.. Any suggestions?
I have solved the problem on my end.

The problem for me was MySQL server default character set is UTF-8.
You can change the tables character set by adding the following line.

ENGINE=MyISAM DEFAULT CHARSET=latin1;

To do this open the product-gWoWRoster.xml find the CREATE TABLE statements, add ENGINE=MyISAM DEFAULT CHARSET=latin1; to the end of the statement or you can just copy and paste what i have.

Example:
Code:
$vbulletin->db->query("
	CREATE TABLE IF NOT EXISTS " . TABLE_PREFIX . "gwowroster_charinfo (
		`locale` VARCHAR( 2 ) NOT NULL ,
		`realm` VARCHAR( 100 ) NOT NULL ,
		`name` VARCHAR( 100 ) NOT NULL ,
		`updated` INT( 255 ) NOT NULL ,
		`charname` VARCHAR( 100 ) NOT NULL ,
		`talentspec` VARCHAR( 10 ) NOT NULL ,
		`talenttree` VARCHAR( 255 ) NOT NULL ,
		PRIMARY KEY ( `locale`, `realm`, `name`, `charname` )
	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
");

// Character Professions
$vbulletin->db->query("
	CREATE TABLE IF NOT EXISTS " . TABLE_PREFIX . "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` )
	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
");
Save the xml file and try again should fix the problem.
Reply With Quote
  #65  
Old 04-01-2008, 05:31 AM
neo88's Avatar
neo88 neo88 is offline
 
Join Date: Mar 2002
Posts: 23
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Yeah Burn, thanks a lot, that saved me pain and a headache.
Reply With Quote
  #66  
Old 04-05-2008, 09:20 AM
LT Mote's Avatar
LT Mote LT Mote is offline
 
Join Date: Jul 2006
Posts: 59
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
gWoWRoster Guild Info Update

Fatal error: Cannot use string offset as an array in /home/heavens/domains/hb.officialgamingnetwork.com/public_html/includes/cron/cron.gwowroster.guildinfo.php on line 62
Reply With Quote
  #67  
Old 04-05-2008, 08:40 PM
Action-N's Avatar
Action-N Action-N is offline
 
Join Date: Jan 2002
Location: Pasco, WA
Posts: 225
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by sweede View Post
Also, would it be possible to have the roster filter out those characters not meeting certail requirements such as filtering out characters lvl 69 and less, or only include characters that are ranks 0,1,2,3 and 4 ?

I see you figured it out. Is it a simple edit you can share? Thanks
Reply With Quote
  #68  
Old 04-06-2008, 10:37 AM
sweede's Avatar
sweede sweede is offline
 
Join Date: Jan 2007
Posts: 391
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by Action-N View Post
I see you figured it out. Is it a simple edit you can share? Thanks
umm..

open up includes/cron/cron.gwowrocster.guildinfo.php and fine the lines..

PHP Code:
                    $rosterinfo_query = "
                        locale = '" . $guild_info['guildKey']['locale'] . "' ,
                        realm = '" . addslashes($guild_info['guildKey']['realm']) . "' ,
                        name = '" . addslashes($guild_info['guildKey']['name']) . "' ,
                        charname = '" . addslashes($character['name']) . "' ,
                        level = '" . $character['level'] . "' ,
                        class = '" . $character['class'] . "' ,
                        classid = '" . $character['classId'] . "' ,
                        gender = '" . $character['gender'] . "' ,
                        genderid = '" . $character['genderId'] . "' ,
                        race = '" . $character['race'] . "' ,
                        raceid = '" . $character['raceId'] . "' ,
                        rank = '" . $character['rank'] . "' ,
                        charurl = '" . $character['url'] . "' ,
                    ";

                    // INSERT GUILD ROSTER
                    if(trim($guild_info['guildKey']['realm']) != '' && trim($guild_info['guildKey']['name']) != '' && trim($guild_info['guildKey']['locale']) != '')
                    {
                        $vbulletin->db->query("REPLACE INTO " . TABLE_PREFIX . "gwowroster_rosterinfo SET " . $rosterinfo_query . " updated = '" . TIMENOW . "'");

                        // INSERT HISTORICAL ENTRY
                        if($vbulletin->options['gwr_guildhistory'])
                        {
                            $vbulletin->db->query("REPLACE INTO " . TABLE_PREFIX . "gwowroster_hist_rosterinfo SET " . $rosterinfo_query . " date = '" . $histdate . "'");
                        }

                        $delete['charname'] .= "'" . addslashes($character['name']) . "',";
                    } 
(around line 83)

Add
PHP Code:
                    if($character['level'] == 70)
                    { 
before the block and add a single } after the block.

It will look like
PHP Code:
if($character['level'] == 70)
                    {
                        $rosterinfo_query = "
                            locale = '" . $guild_info['guildKey']['locale'] . "' ,
                            realm = '" . addslashes($guild_info['guildKey']['realm']) . "' ,
                            name = '" . addslashes($guild_info['guildKey']['name']) . "' ,
                            charname = '" . addslashes($character['name']) . "' ,
                            level = '" . $character['level'] . "' ,
                            class = '" . $character['class'] . "' ,
                            classid = '" . $character['classId'] . "' ,
                            gender = '" . $character['gender'] . "' ,
                            genderid = '" . $character['genderId'] . "' ,
                            race = '" . $character['race'] . "' ,
                            raceid = '" . $character['raceId'] . "' ,
                            rank = '" . $character['rank'] . "' ,
                            charurl = '" . $character['url'] . "' ,
                        ";

                        // INSERT GUILD ROSTER
                        if(trim($guild_info['guildKey']['realm']) != '' && trim($guild_info['guildKey']['name']) != '' && trim($guild_info['guildKey']['locale']) != '')
                        {
                            $vbulletin->db->query("REPLACE INTO " . TABLE_PREFIX . "gwowroster_rosterinfo SET " . $rosterinfo_query . " updated = '" . TIMENOW . "'");
    
                            // INSERT HISTORICAL ENTRY
                            if($vbulletin->options['gwr_guildhistory'])
                            {
                                $vbulletin->db->query("REPLACE INTO " . TABLE_PREFIX . "gwowroster_hist_rosterinfo SET " . $rosterinfo_query . " date = '" . $histdate . "'");
                            }
    
                            $delete['charname'] .= "'" . addslashes($character['name']) . "',";
                        }
                    } 
Reply With Quote
  #69  
Old 05-06-2008, 04:14 PM
tuaguild's Avatar
tuaguild tuaguild is offline
 
Join Date: Dec 2007
Location: Memphis TN
Posts: 155
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
getting a database error upon install. I am using vb 3.6.8 pl2 i know this is for 3.7 but i run a wow guild website and would like to use this mod for my site
Reply With Quote
  #70  
Old 05-06-2008, 04:28 PM
Gryphon's Avatar
Gryphon Gryphon is offline
 
Join Date: Oct 2001
Location: Seattle, WA
Posts: 617
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
It should work fine for pretty much any version of vBulletin. The only thing that would be an issue is the auto navbar link addition.

Need more info about the error, I can't just guess what it could be.
Reply With Quote
  #71  
Old 05-06-2008, 05:14 PM
tuaguild's Avatar
tuaguild tuaguild is offline
 
Join Date: Dec 2007
Location: Memphis TN
Posts: 155
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
well i fixed the database error but now the only faction i am seeing in the statistics section is horde races and my character is not showing up in the roster also it seems that certain config settings are not saving at all any idea y this is the first 3 config options in the admincp is not saving
Reply With Quote
Reply
Page 7 of 31 « First 56 7 8917 Last »

« Previous Thread | Next Thread »

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:14 AM.

Contact Us - Archive - Top

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.08995 seconds
  • Memory Usage 2,406KB
  • 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
  • (3)bbcode_code
  • (3)bbcode_php
  • (3)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
  • (1)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