The Arcive of Official vBulletin Modifications Site.

gWoWRoster - World of Warcraft Guild Roster · **Released**: 02-14-2008

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]

Download the latest version and upload all files.
Install the product.
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.
Fill in the gWoWRoster configuration options.
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.

burn420 · #62 03-28-2008, 02:14 AM

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

neo88 · #63 03-29-2008, 03:42 PM

I am also having the same error as Burn.. Any suggestions?

burn420 · #64 04-01-2008, 02:57 AM

Quote:

Originally Posted by neo88

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.

neo88 · #65 04-01-2008, 05:31 AM

Yeah Burn, thanks a lot, that saved me pain and a headache.

LT Mote · #66 04-05-2008, 09:20 AM

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

Action-N · #67 04-05-2008, 08:40 PM

Quote:

Originally Posted by sweede

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

sweede · #68 04-06-2008, 10:37 AM

Quote:

Originally Posted by Action-N

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']) . "',";

                        }

                    }

tuaguild · #69 05-06-2008, 04:14 PM

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

Gryphon · #70 05-06-2008, 04:28 PM

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.

tuaguild · #71 05-06-2008, 05:14 PM

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.08862 seconds Memory Usage 2,402KB 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
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!