gWoWRoster - World of Warcraft Guild Roster

[Gryphon]

What is it?
-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 (https://vborg.vbsupport.ru/vborg_miscactions.php?do=installhack&threadid=170605), 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!

https://vborg.vbsupport.ru/external/2008/02/14.png Follow me on twitter! (http://www.twitter.com/ghryphen)

Support
valueI 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
-
Links to either US or EU WoW Armorys.
Multiple guild support
Usergroup access to roster
Unified profilefield compatible with gWoWEvents (https://vborg.vbsupport.ru/showthread.php?t=170592) and gWoWChar (https://vborg.vbsupport.ru/showthread.php?t=141455)
Currently requires cURL


Installation
-
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: 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
-
http://www.alliedtribalforces.com/gwowroster.php
http://www.google.com/search?q=allinurl:gwowroster.php+-loc


Changes
-
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
-gXboxLive, Copyright ? Ghryphen (https://github.com/ghryphen)
Please maintain copyrights in derivative works, thank you.

[Gryphon]

Notes: Userfield data not yet implemented.

[CoryHawk]

Been testing and Using this for Gryphon for a while.. awesome work Gryphon! Glad you finally let the public use this awesome mod!

Installed!

[SwollenCranium]

People still play WoW ? Jeeeez.

[Gryphon]

Been testing and Using this for Gryphon for a while.. awesome work Gryphon! Glad you finally let the public use this awesome mod!

Installed!

Thanks, still want to do more and fix some quirks, but figured it was about time to release something :D

People still play WoW ? Jeeeez.

Only about 10 million :D

[SwollenCranium]

Only about 10 million :D


Ehh .. I guess I'm just an old school nerd ... My original D&D DM guide, an ACTUAL book, still sits proudly on the mantle.

Some day I hope to have my first date as well. :)

[Dsru123]

Well, installed fine but getting this error message when linked clicked on:
Warning: Division by zero in /includes/functions_gwowroster.php on line 31

And then below that from vB:
Unable to add cookies, header already sent.
File: /www/www.jettcommunity.com/includes/class_core.php
Line: 3177

CMPS v3.0.0
vB 3.7.0 Beta 5

[Wayne Luke]

Run the scheduled task in the Scheduled Task Manager to prime your roster. Should eliminate the divide by 0 error.

[Gryphon]

Thanks Wayne, I will look into fixing that error.

[Caerydd]

Okies, just tested this out on 3.6.8 RL2 and come up with a blank page (and I mean totally blank, even on view source) after the following the instructions above (already had gWoWChar for 3.6.x installed) and running the cron job.

No biggy, I'm using an iframe for the normal armory page atm, and my site isn't live, I can wait until 3.7, just thought someone else would like to know :)

Edit the first: I had entered 'field5' in the appropriate box, but that wasn't saving. I put '5' and it saved.

I re-ran the cron, and got this erro

gWoWRoster Guild Info Update
No delete, a parse failed.

Done


I then ran the cron again, and it WORKS!

Except it didn't pull talents.

Lastly, I guess there is a setting in the php somewhere to sort by rank by default,instead of by name :)

[Wayne Luke]

Thanks Wayne, I will look into fixing that error.
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.

[Dsru123]

Run the scheduled task in the Scheduled Task Manager to prime your roster. Should eliminate the divide by 0 error.

worked like a charm, thank you sir.

[Caerydd]

Thanks Wayne.

So, officially working on 3.6.8 RL2, for anyone who is interested :)

[Foghorn Deadhor]

Is there a way to associate rank names with the rank numbers? I understand armory only gives you a number, but perhaps a forum-side place to enter what each rank number is?

[Wayne Luke]

Is there a way to associate rank names with the rank numbers? I understand armory only gives you a number, but perhaps a forum-side place to enter what each rank number is?
That is a cool idea. I am going to have to look into that myself.

[Foghorn Deadhor]

None of the images are working and they are all uploaded. For gWoWChar too.

Also, would like to have it sort by level then rank. How can I do this?

[Edit] Hurr hurr, this was a style issue.

[Foghorn Deadhor]

All right, a couple of options I'd like to see added:

1) Option to only show max-level characters

2) (I'd imagine this would be harder) Some way to signify, based on the WoWChar info on your boards, that a character is someone else's alt, perhaps a "related characters" column. I have no idea how hard it would be to code, but if the alts could even be omitted from having their own row, possibly by only showing the first char listed by a boards user on a given realm, that would be *awesome.*

3) I'm pretty sure you're already working on board usernames on the roster, but putting that out there

4) The ability to leave "guild notes" :D

PS: I've added a "|" between the Reputation and Skills because our style does not underline links and therefore it was not obvious that they were separate links. You might want to add this to the main product.

[Edit]

My roster is still lacking talents for the overwhelming majority of characters. I have a 198 character roster, of which 103 are level 70. I'm trying to spam the chron to make it populate this shizzle but it isn't working (keeps getting info for the same character). I do not feel comfortable doing things like "removing limits" and "setting timeout to 20 hours" because I am a clueless noob (you will note the lack of "Coder" under my username >.>). Perhaps a more aggressively timed cron which is not scheduled to run but just runs manually could be included so someone like me could basically shut the boards down in the middle of the night for 30 minutes and populate the roster =\

Or something.

[Edit II] Just wanted to update that after about an hour and a half of persistence, the talents are finally populated. After doing the same guy over and over again, it finally broke through and started doing them in ones and twos...again, including a function to do a more persistent build attempt would be good. Looks much better now though :D

[Kinneas]

Always a pleasure to use one of your Mods Gryphon. Always very well thought out and simple to use :)

Keep up the great work!

Edit: Only problem I can see (Aside from the divide by 0 thingy) is it doesn't seem to like nonstandard characters, eg ?

Edit 2: Oh yeah, and the talent thing like Foghorn mentioned. I'm sure this mod'll only get better though :)

[Dsru123]

Well, was working great and then I broke something. \Here is the message when I run a schedule task:

gWoWRoster Guild Info Update
No delete, a parse failed.
Done

[Gryphon]

Thanks for the suggestions and error reports. I am making notes but a little swamped with real work at the moment so I will catch up on these as soon as I can.

[Foghorn Deadhor]

Thanks for the suggestions and error reports. I am making notes but a little swamped with real work at the moment so I will catch up on these as soon as I can.

Wha? Clearly only five minutes of work or so to get all of these things fixed and implemented :P

[Wayne Luke]

Wha? Clearly only five minutes of work or so to get all of these things fixed and implemented :P
Please never assume how little time it takes to find, code and debug scripts. I spent well over an hour getting this thing to work yesterday and I haven't even encountered some of the problems that you and others have.

Even trickier with the Armory being as stable as a slab of butter in a hot frying pan.

[Kinneas]

Please never assume how little time it takes to find, code and debug scripts. I spent well over an hour getting this thing to work yesterday and I haven't even encountered some of the problems that you and others have.

Even trickier with the Armory being as stable as a slab of butter in a hot frying pan.
Aint that the truth, lost count of the amount of times Armoury takes well over 30 minutes to load, either freezing my browser or hanging on "loading" in the process.

[Caerydd]

I've found since downloading the latest version of Flash, the problem is not so severe anymore.

[Foghorn Deadhor]

Please never assume how little time it takes to find, code and debug scripts. I spent well over an hour getting this thing to work yesterday and I haven't even encountered some of the problems that you and others have.

Even trickier with the Armory being as stable as a slab of butter in a hot frying pan.

'twas a joke sir, I thought it was preposterous enough of a statement to be obvious :D

[StEaLtH666]

have tried to install this after installing gwowchar, and it installed ok.

however in settings i couldnt write field5 in the Userfield ID box so put 5 in instead, as thats the field name i used for gwowchar.

have tried to put my server in and it looks like this EU|Thunderhorn|Allied PotUK . that went in fine

then i went to maintenence and ran the two scripts manually lots of time in no particular order lots but still i have a blank roster with no guild listed and no characters.

am using 3.6.8.

any ideass greatly apreciated

[Caerydd]

Check that you entered a comma delineated list of the usergroups that can access the script (1,2,3,4,5,6,9,10 is what I use) , and that you uploaded gwowroster.php to the correct location.

Run the main cron task. Post the message it gives you here (e.g. it told me it failed to parse originally, when it went through successfully it gave me a list of what it updated.) Ignore the talent parser bit, you want to fill the roster.

[StEaLtH666]

give no message at all.. not even a done one

takes a few seconds then the blue page with

gWoWRoster Guild Info Update

but no done message under

also having the same issue with the events addon.. it just doesnt seem to like grabbing the data from eu armory.

maybe ive done something wrong, or i have somehting installed or not installed on server that it needs.

i can post my phpinfo if that would help?

[StEaLtH666]

it appears i didnt have php error reporting on.. now ive enabled it in my php.ini file i get this error when running hte script manually

Fatal error: Call to undefined function: curl_init() in /home/potukne/public_html/forum/includes/class_gwowarmory.php on line 170


------------
UPDATE
________

my fault it seems... i didnt have curl compiled with php and apache.

rebuilt apache and all seems fine now :)

i think :)

[Caerydd]

Let us know how it goes :) I've had gWoWRoster up for a good 5 days now, and most of my user's talent information has updated :)

[Kinneas]

Same, although I have been noticing some odd anomalies.

This may have been in part due to me moving servers (I had my hosts move me to a "better" Shared server as the one I was one had such a short MySQL query timeout I was getting repeated DB errors when running the gWoW cron tasks), but it now seems that the nonstandard characters (eg ?) have corrected themselves (Yay!), but random people seem to lose their talant stats, people who had them showing before revert to untalanted (Boo!).

But this is still a great mod, and I'm sure it can only get better :)

[Gryphon]

Yeah, the talent's disappear randomly, it is a bug I have yet to track down. And special characters I have such a hard time understanding how to work with them in any of my projects, if they are working for you, it is a bonus lol

[Kinneas]

They are at the moment, not sure if they'll revert again though. I'll let you know :)

[gmrstudios]

Is it possible to only display certain ranks?

[jim6763nva]

Just to let everyone know, I've also gotten this to work on vb 3.6.8 pl2 with one issue though. When the scheduled events run it doesn't seem to pull all the data. All the members in the guild are showing up, but the talents are showing as "untalented" and alot of the spec fields are blank showing "//" in the column.
Other than that it seems ok.

Good job on this mod guys! Thanks :)

Jim

[StEaLtH666]

Let us know how it goes :) I've had gWoWRoster up for a good 5 days now, and most of my user's talent information has updated :)

going fine m8.. all updated :) and seeming fine.

[StEaLtH666]

Just to let everyone know, I've also gotten this to work on vb 3.6.8 pl2 with one issue though. When the scheduled events run it doesn't seem to pull all the data. All the members in the guild are showing up, but the talents are showing as "untalented" and alot of the spec fields are blank showing "//" in the column.
Other than that it seems ok.

Good job on this mod guys! Thanks :)

Jim

it only updates 1 or two at a time m8.. so will take a good few days to fill in :) just leave it, or alternatively keep running the task manually in hseduled tasks till your happy :)

[Noxious]

just curious as to why i have a gwowroster_charinfo_prof table thats empty in my database, is this planned for furture use?

[boxerman]

can i set this so only WOW players can view this etc..?? but for everyone eles it is a normal

[Gooner]

Fantastic mod, just like your others and im strongly thinking about giving you a donation for your awesome work :) keep it up

[Caerydd]

boxerman - yes, just make a public group that wow players can join, and only allow that usergroup access to the page.

[Kinneas]

Just to let everyone know, I've also gotten this to work on vb 3.6.8 pl2 with one issue though. When the scheduled events run it doesn't seem to pull all the data. All the members in the guild are showing up, but the talents are showing as "untalented" and alot of the spec fields are blank showing "//" in the column.
Other than that it seems ok.

Good job on this mod guys! Thanks :)

Jim
Most people have said they need to run the update cron several times before it populates the info for everyone. Or you can let the cron run automatically, it'll just take a bit longer.

[Noxious]

i just duplicated the task so it ran twice as often.

[sweede]

Could we have the default templates navbar templates changed to use $vboptions[bburl] ?

gwr_vbnav_navbarlink:

<td class="vbmenu_control"><a href="$vboptions[bburl]/gwowroster.php$session[sessionurl_q]">$vbphrase[gwr_vbnav]</a></td>

gwr_vbnav_quicklink:
<tr><td class="vbmenu_option"><a href="$vboptions[bburl]/gwowroster.php$session[sessionurl_q]">$vbphrase[gwr_vbnav]</a></td></tr>

[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 ?

[Mother_Dee]

Looks nice, if I wasn't so in love with WoWRoster 2.0 right now I'd probably give it a go. It's nice to see you pull your hacks together in functionality.

Props!

[Gryphon]

Could we have the default templates navbar templates changed to use $vboptions[bburl] ?

gwr_vbnav_navbarlink:

<td class="vbmenu_control"><a href="$vboptions[bburl]/gwowroster.php$session[sessionurl_q]">$vbphrase[gwr_vbnav]</a></td>

gwr_vbnav_quicklink:
<tr><td class="vbmenu_option"><a href="$vboptions[bburl]/gwowroster.php$session[sessionurl_q]">$vbphrase[gwr_vbnav]</a></td></tr>

Hmm, this is the second product I have seen something like this request. The default vBulletin template does not include the bburl, which is what I modeled mine after. I also avoid absolute urls in my coding practice. However, I understand this can be a problem for sites that use subdomains, in that regard the template is easily editable by the user.

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 ?

That can be done.

[Tolas]

Quick question.

I have a grey background on our forums and it is very hard to read classes & specs. I attached a screenshot.

Any suggestions on how to get around that without changing my board to a dark/black style?

I actually have the same issue with the gWoWevents and the wowhead item code I use. A lot of my members don't care for the dark styles that are popular with gaming sites.

Maybe even something that would change highlight those text fields black, so the colors show?

[Gryphon]

Yes, edit the gwr_header template and change the class colors at the start of the template to what you would like them to be.

[Tolas]

Yes, edit the gwr_header template and change the class colors at the start of the template to what you would like them to be.

Awesome! Thank you. :up:

[DDolphins]

So here's a question this might not be able to be done easily or it can as simple as a click of a button.

I like how at the bottom of the roster it has the breakdown information. Is there anyway to take the class breakdown block and copy it over into say a VBadvanced module to be shown on the front page?

[Gryphon]

So here's a question this might not be able to be done easily or it can as simple as a click of a button.

I like how at the bottom of the roster it has the breakdown information. Is there anyway to take the class breakdown block and copy it over into say a VBadvanced module to be shown on the front page?

Not currently, but I recently did similar functionality for gXboxLive. I will see about doing the same for this mod.

[quedex]

I was thinking about the "bug" that the roster is dropping info on chars randomly.
Can it have something to do with the armory timing out? i mean if the armory times out
it doesnt return any info but the script on "our" side still fills the table but with blanks.

[Caerydd]

I've recently found that some characters are being dropped out of our roster entirely, even though they're well above level 10, are active daily, their specs don't change, and they definitely have not left the guild. I'm sure they'll be back, as the armory is a sketchy beast ^^

[trustice]

thanks for this great addon :)

only names with special characters lead to untalented and // at talents.
it would be nice to fix this because many guildmates of our guild use them.
http://www.trustice.de/forum/gwowroster.php

options to show only specific levels or ranks would be a great improvement :D

[Gryphon]

I was thinking about the "bug" that the roster is dropping info on chars randomly.
Can it have something to do with the armory timing out? i mean if the armory times out
it doesnt return any info but the script on "our" side still fills the table but with blanks.

By design it "should" not do anything unless there is positive data returned by the Armory. I probably missed something, but plan on reevaluating the way caching of characters is handled.

Those pesky special characters are a sore spot for me, I am still trying to resolve this on a couple of my addons.

[Mother_Dee]

The Guild Info Cron runs and is giving me the following error (just installed):

Database error in vBulletin 3.6.8:

Invalid SQL:
DELETE FROM gwowroster_rosterinfo WHERE NOT (
locale IN('US') AND
realm IN('Kael\'thas') 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
Date : Saturday, March 8th 2008 @ 11:13:54 AM
Script : http://XXX/XXX/XXX/cronadmin.php?do=runcron&cronid=26
Referrer : http://XXX/fXXX/XXX/cronadmin.php?do=modify

[Zaeolos]

Did you ever figure out that error MD, I am getting the same thing.

Edit: Nevermind, I think the Armory might be causing the issue.

[Mother_Dee]

I've gotten it to populate (finally!), still testing it while I have WoWRoster active.

I'd ideally like to see the correlation used between the names and the input userfield information, I'm sure that's in the works.

Also a primary and secondary sortability, ie: I like to sort my rosters by class then by rank.

A way to manually input the guild rank titles in Admincp to correlate with numbers would also be wonderful, as would the ability to correlate alts with mains, etcetera.

For now I'm keeping my WoWRoster, though I have this installed (just not viewable to anyone but admins) so I can implement changes as you make them and improve the mod. Eventually I hope to get to the point where using this mod far outweighs having WoWRoster (since there's no vB bridge) and I can nix it... though I might mis SigGen and default sigs for my raiders...

Cheers on a great mod, keep up the good work!

[Zaeolos]

I have let this run for 24 hours and none of my members have any talents showing. Are there any tricks out there to get this part of it to work?

When I run the Cron job manually, this is what I get:

gWoWRoster Character Info Update

Zurianne
Array
(
[globalSearch] => 1
[lang] => en_us
[errorhtml] =>
[characterInfo] => Array
(
[talentTab] => Array
(
[talentTree] =>
)

)

)
--------------------------------------------------------------------------------
Zurianne, Done

[burn420]

I`am getting the following error when trying to install and i have no clue how to fix.
Any help ?


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]

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

[burn420]

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:
$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]

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

[LT Mote]

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]

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]

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..


$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

if($character['level'] == 70)
{


before the block and add a single } after the block.

It will look like

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]

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]

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]

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

[Zhin Jio]

I'm sure you know this already, but the "gwowroster" directory that you have pathed to "upload/images/misc" should actually be "upload/images/wow/misc" in order to work with where you code points. Ran both scripts once to prime, worked right away. Should the "field" be "field5" or just "5" in the config? Doesn't seem to do anything either way. And further, is it even necessary?

Actually, it seems like the icons and such were needed in both directories for everything to work. Not sure which is which, but I just copied the directories and now all the images are showing up.

[Gryphon]

I'm sure you know this already, but the "gwowroster" directory that you have pathed to "upload/images/misc" should actually be "upload/images/wow/misc" in order to work with where you code points. Ran both scripts once to prime, worked right away. Should the "field" be "field5" or just "5" in the config? Doesn't seem to do anything either way. And further, is it even necessary?

Actually, it seems like the icons and such were needed in both directories for everything to work. Not sure which is which, but I just copied the directories and now all the images are showing up.

The images upload to your styles directory as it is packaged. The config option is not in use, I keep forgetting to remove it.

[Ulkesh]

Have updated to vB 3.7.0, installed gWoWroster (already have gWoWchar installed). installed without a hitch. Set userfield to the same as gWoWchar and gWOWevent use (5), and go to scheduled tasks to run the import. Get the following:

gWoWRoster Character Info Update

Parse error: syntax error, unexpected T_STRING in /home/capdom/public_html/forums/includes/functions_gwowroster.php on line 1

[Ulkesh]

Beuller? Beuller? Anyone?

[jeryp]

Hi I have it installed and it works fine with the US guild you supply as an example but when i put in

EU|Sunstrider|Old School

It just comes up blank.
Any ideas Why?
The Character postbit and Raid Calander work Fine.

Great Mods All of them thanks.

Just need to fix the roster listing.

http://www.battlefield-command.com/forums/gwowroster.php


Sorry if im doing something silly im not into WoW but a lot of my community are so i am providing it for them.

Cheers
Jery

[TCooper]

installed and keep getting page cant be displayed as I installed vb then that right away...
also in vb options area notice template hook thing in the image.

[LT Mote]

Warning: Division by zero in /includes/functions_gwowroster.php on line 31

Warning: Division by zero in /includes/functions_gwowroster.php on line 31

Warning: Division by zero in /includes/functions_gwowroster.php on line 31

Warning: Division by zero in /includes/functions_gwowroster.php on line 31

Warning: Division by zero in /includes/functions_gwowroster.php on line 31

Warning: Division by zero in /includes/functions_gwowroster.php on line 31

Warning: Division by zero in /includes/functions_gwowroster.php on line 31

Warning: Division by zero in /includes/functions_gwowroster.php on line 31

Warning: Division by zero in /includes/functions_gwowroster.php on line 31

It is also not pulling any data from the field set...
Any ideas?

[TCooper]

after I kept on messing with it i noticed i could get the page to work if i left the perm settings to 0 for usergroups and if i edited it and put a 6 for usergroup six the page show it could not be displayed.

[jeryp]

Checked it this morning and it was working. So ignore previous post.

Thanks Again
jery

[KrU$ty]

I'd like to confirm the errors:

(after running the cron job)

Fatal error: Cannot use string offset as an array in /home/knightso/public_html/includes/cron/cron.gwowroster.guildinfo.php on line 62

and

(displaying the gwowroster.php file)

Warning: Division by zero in /includes/functions_gwowroster.php on line 31

vb 3.7

[Tazz_1962]

I'd like to confirm the errors:

(after running the cron job)

Fatal error: Cannot use string offset as an array in /home/knightso/public_html/includes/cron/cron.gwowroster.guildinfo.php on line 62



I'm having this same issue, has anyone figured it out.

Thx in advance

edit: I've figured out that if I put a known single or multiple word guild name in, it works fine. Our guild name unfortunately contains non standard letters in it, that must be the problem.

[KrU$ty]

I'm having this same issue, has anyone figured it out.

Thx in advance

edit: I've figured out that if I put a know single or multiple word guild name in, it works fine. Our guild name unfortunately contains non standard letters in it, that must be the problem.

Perhaps, but my guild name is normal, aside from spaces between the words.

[Tazz_1962]

Fatal error: Cannot use string offset as an array in /home/knightso/public_html/includes/cron/cron.gwowroster.guildinfo.php on line 62


I'm having this same issue, has anyone figured it out.

Thx in advance

edit: I've figured out that if I put a known single or multiple word guild name in, it works fine. Our guild name unfortunately contains non standard letters in it, that must be the problem.

Not sure if this will help anyone else out, but thought I would close the loop on my issue. I am by no means good at any of this so take it with a grain of salt. It is more through persistence that I accomplish anything. Any way our guild name F?de to Bl?ck was causing the issue. I had that figured out by trial and error as seen in the post above.

I figured the non standard characters were not being converted correctly in the transfer. When viewing the content of address bar, when on our guild page in the armory it had F%C3%A5de+to+Bl%C3%A5ck as the name. In my mind I needed to find the code the when translated would look for this string in the armory to find our guild.

After many trial and error attempts to get it right, I typed F?de to Bl?ck into my text editor UltraEdit and then used the conversion tool ?UNICODE/ASCII/UTF-8 to UTF-8 (ASCII EDITING)? this converted F?de to Bl?ck to Fåde to Blåck. I copied this into the gWoWRoster setup page where you input your guild name. :) it all works now.

Maybe someone that actually understands what I did, might be able to use the info to help those with the same problem.

Thanks

Tazz

[atomhead]

It is also not pulling any data from the field set...
Any ideas?

Same problem.

"Warning: Division by zero in [path]/includes/functions_gwowroster.php on line 31"

[istvan]

in your version http://www.alliedtribalforces.com/gwowroster.php i see links to be.imba.hu etc how can you get them to show?

[slabuda]

Resolved from previous post in these forums ...



I recieved the following error, when trying to install today --

Database error in vBulletin 3.7.1:

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
Request Date : Wednesday, June 4th 2008 @ 12:36:41 PM
Error Date : Wednesday, June 4th 2008 @ 12:36:41 PM
Script : http://www.consilioetarmis.net/home/forums//admincp/plugin.php?do=productimport
Referrer : http://www.consilioetarmis.net/home/forums//admincp/plugin.php?do=productadd
IP Address : 65.240.129.62
Username : Kiko
Classname : vB_Database
MySQL Version : 5.0.45-community

[quarum]

I am getting the following error as well. Please advise.

Warning: Division by zero in [path]/includes/functions_gwowroster.php on line 31

Warning: Division by zero in [path]/includes/functions_gwowroster.php on line 31

Warning: Division by zero in [path]/includes/functions_gwowroster.php on line 31

Warning: Division by zero in [path]/includes/functions_gwowroster.php on line 31

Warning: Division by zero in [path]/includes/functions_gwowroster.php on line 31

Warning: Division by zero in [path]/includes/functions_gwowroster.php on line 31

Warning: Division by zero in [path]/includes/functions_gwowroster.php on line 31

Warning: Division by zero in [path]/includes/functions_gwowroster.php on line 31

Warning: Division by zero in [path]/includes/functions_gwowroster.php on line 31

[ColossusCH]

Hi to all, i like this Add-On, but i still have one question.
is it possible, to get Armory-Data's in german?

i dont find any Phrase, so it must be a direct import from Armory-Site.

Thank you for your Help.

[twitch]

pretty darn cool, thanks

[istvan]

in your version http://www.alliedtribalforces.com/gwowroster.php i see links to be.imba.hu etc how can you get them to show?


/bump

[Sanctorum]

This looks great, I'm going to install this at lunch along with the event one I installed yesterday. Thanks :)

*update*

I installed at lunch with no problems, included the user field that was setup for your gWoWevents, populated the server info and defined what users can view it, but it's not being populated. I'm guessing it's because of the Armory? I'll check it later tonight and see if it's populated, and yes I have cURL compiled into PHP.

[Souli]

Nice Idea, thanks for the Product.

Any News about the special characters ?

[Danoxth]

Installed, however have come up against a problem.

I can view the roster however it stats that I don't have permission to view it. Changing the settings to allow certain usergroups to access it only ends up in an error message:

The page you are trying to view cannot be shown because it uses an invalid or unsupported form of compression.

The page you are trying to view cannot be shown because it uses an invalid or unsupported form of compression.

* Please contact the web site owners to inform them of this problem.

If I take away the usergroup id's I can see the roster again, but with the "You don't have the required permissions" message.

Any ideas?

[Souli]

@Gryphon

"Special Characters"

I don´t understand the system, but i tested the wowroster.net Script and many of the plugins. This Roster has a Plugin = "WoWArmorySync" - and it is working with "Special Characters" - maybe you can take a look how they did sync "special characters" ?

[Gryphon]

istvan, These are custom edits I have made so far. I will make them available in a future update.

Danoxth, I have no idea what would cause that error. It is not a message that I have heard of before.

Souli, I will take a look and see if there are any hints as to how to handle this. I believe part of the problem exists when vBulletin is set to ISO-8859-1 instead of UTF-8. But honestly I have no idea really, I am pretty lost on the caveats of character encoding heh.

[Souli]

I have done it - it works now with special characters.



1 Step - open "cron.gwowroster.charinfo.php"
-=> Change the Charname to utf8 before the function sends to wowarmory

search:

$x->SetCharName($char['charname']);


and add before:

$char['charname'] = utf8_encode($char['charname']);




2 Step
-=> After the xml job is done you must change the Charname back to iso......

search:

$charinfo_query = "
locale = '" . $char['locale'] . "' ,
realm = '" . addslashes($char['realm']) . "' ,
name = '" . addslashes($char['name']) . "' ,
charname = '" . $char['charname'] . "' ,
";



and add before:

$char['charname'] = utf8_decode($char['charname']);


End!

[Renny]

Ive just installed your mod and when trying it out i get the following error

"Warning: Division by zero in [path]/includes/functions_gwowroster.php on line 31"

How do i fix it?

[Kinneas]

Believe you just need to wait for the Guild Info cron to run once. It shows that because it's empty to begin with.

[KURTZ]

Hi I have it installed and it works fine with the US guild you supply as an example but when i put in

EU|Sunstrider|Old School

It just comes up blank.
Any ideas Why?
The Character postbit and Raid Calander work Fine.

Great Mods All of them thanks.

Just need to fix the roster listing.

http://www.battlefield-command.com/forums/gwowroster.php


Sorry if im doing something silly im not into WoW but a lot of my community are so i am providing it for them.

Cheers
Jery

i've the same issue with EU|Crushridge|Fremen ... and also with the Guild that Gryp as used like an example ...

[thefansview]

Hi I have installed this but all the members show as untalented and their specs do not show. Any idea's? Thanks in advance.

[adairen]

Got my gwowroster installed and working finally. Here were my steps.

- properly installed and configured gwowroster through product/plugin manager & vbulletin options
- made the utf encoding changes in 'cron.gwowroster.charinfo.php' as stated in Souli's post above
- went to admincp -> Scheduled Task Manager
- manually ran 'gWoWRoster Guild Info Update' first (grabs data about your guild like whos in it)
- then manually ran 'gWoWRoster Guild Info Update'

Some of you may notice that through the 'gWoWRoster Guild Info Update', it is only updating maybe 1 or 2 characters per run. This is because the query limit is too sensitive. (Reason probably due to prevent bogging down systems). To fix this, locate the following line in 'cron.gwowroster.charinfo.php':

$limit = ceil($count['count'] / 70);

and change the '70' to something like:

$limit = ceil($count['count'] / 10);

I had 100 people in my guild that needed talent updating, so I just ran that cron job manually about 10 times to update everything after initial install.

[Gryphon]

It is set to update the roster over the course of a day, which varies per run depending on how many people are in the guild, there is no sense in increasing the rate really. The fake vBulletin cron does not handle large processes well on it's own. Manual works because you wait for it, but on it's own it doesn't do as well.

Just have patience, wait a day for it to populate, you lived this long without a roster on your site another day doesn't hurt. I wouldn't recommend others change the code.

[Irion]

Hello Gryphon,

at first nice job u have done.

Do u plan to make a release in other languages?! specially german perhaps :-)

regards
Irion

[Heretiko]

Hi all, first thanks for this astonishing mod ;) u rock dude!!! anyway, i'm getting this error:

Fatal error: Call to undefined function: curl_init() in /home/potukne/public_html/forum/includes/class_gwowarmory.php on line 170

do i need to have implemented the curl function?? or i can avoid this with a workaround??? cs my hosting service is windows and i cannot switch to unix :( so is there any way to get this up&running without the curl??

thanks in advance, i'm looking forward to a solution please :P

[Gryphon]

@Irion, the addon is pretty much all phrased, you can edit the gWoWRoster phrases.

@Heretiko, there is no workaround at the moment. curl is not limited to unix afaik. I understand some hosts may not want to put in the work to enable it however, it is on my list of things to do, but at the moment the list isn't getting any smaller.

[Heretiko]

@Irion, the addon is pretty much all phrased, you can edit the gWoWRoster phrases.

@Heretiko, there is no workaround at the moment. curl is not limited to unix afaik. I understand some hosts may not want to put in the work to enable it however, it is on my list of things to do, but at the moment the list isn't getting any smaller.

thanksssss! 4 your response!!! u're kind!!! i've been asking to my ISP to implement this feature but they don't wanna do that on the windows hosting service i've got :( so... i've to wait for your new version.... thanks 4 the moment!!! and many compliments!!!!

[hunteds911]

I am having an issue where Gwowroster isn't updating the talents? Is this still a known issue?

[Gryphon]

I am having an issue where Gwowroster isn't updating the talents? Is this still a known issue?

It takes a while to update each characters talents, just wait.

[LordDG]

Thanks for the great addon. However, I am having some issues. It seems it can no longer parse the results from Armory properly. When I run the cron job manually, I get these results:

Array
(
[globalSearch] => 1
[lang] => en_us
[errorhtml] =>
[characterInfo] => Array
(
[talentTab] => Array
(
[talentTree] =>
)

)

)

As you can see, no actual information is shown.

[Gryphon]

[errorhtml] is only when a page returns an error. Sometimes there is an error returned on valid characters, just wait it out a bit. What led you to find that the character profiles weren't updating?

[LordDG]

I installed the mod a few days ago and the roster had a few characters populated after a few manual scheduled tasks run. Updating has been slow/stopped so I decided to run a few manual scheduled tasks run again and discovered what I posted instead of the usual big arrays of stats.

[afkae]

I'm having the same problem here, everything else updates just not the talents and spec columns.

[z4media]

Hello

Pleae tell me where in the code i must change for GERMAN Charinfos like Warlock = Hexenmeister.

I think it is the xml what you use for the data.

When update run, you can see

Lang = en_us

where can i change this for German words

THX

[mrwuss]

I have done it - it works now with special characters.



1 Step - open "cron.gwowroster.charinfo.php"
-=> Change the Charname to utf8 before the function sends to wowarmory

search:

$x->SetCharName($char['charname']);


and add before:

$char['charname'] = utf8_encode($char['charname']);




2 Step
-=> After the xml job is done you must change the Charname back to iso......

search:

$charinfo_query = "
locale = '" . $char['locale'] . "' ,
realm = '" . addslashes($char['realm']) . "' ,
name = '" . addslashes($char['name']) . "' ,
charname = '" . $char['charname'] . "' ,
";



and add before:

$char['charname'] = utf8_decode($char['charname']);


End!

I made these changes and character names with special letters are being printed in odd ways.

[apokphp]

Same as everyone else. This mod is bugged it seems.

Talent and specs won't update. Anyone have a fix for this? Not sure if this is still being supported by the author.

[Tolas]

Still working fine for me, All the Talents & Specs seem fine, I spot checked a bunch of them and they all matched the armory. I don't know how long it takes to update that info, but I don't see any problems.

I do have a question though. I want to create a second roster for our Horde guild, so I have one for each faction. What would be the best way of doing this? Do I need to modify some things and import it again so vbulletin sees it as a different mod?

Any help would be appreciated, thanks.

[GabbaGandalf198]

i have a problem, when i install this mod, i recieve an error, saying me that there is an division by zero, now i have looked up the data in the database and it is saying me that we have 0 guildmembers?? I am using the EU armory

[Gryphon]

Same as everyone else. This mod is bugged it seems.

Talent and specs won't update. Anyone have a fix for this? Not sure if this is still being supported by the author.

I posted just a couple weeks ago. I still support it and use it daily on my own boards, it is working as intended, the entire guild is imported and then the individual talents are updated over the course of the day.

@Tolas just add a new line containing the horde guild to the guild name option. The guild title at the top of the roster will turn into a drop menu letting you switch between the two guilds. See ATF (http://www.alliedtribalforces.com/gwowroster.php) for example.

@GabbaGandalf198, it would help if I knew the specifics of the error, such as line number and file.

[Tolas]

@Tolas just add a new line containing the horde guild to the guild name option. The guild title at the top of the roster will turn into a drop menu letting you switch between the two guilds. See ATF (http://www.alliedtribalforces.com/gwowroster.php) for example.


Ok that rocks!

I am however getting:
Warning: Division by zero in [path]/includes/functions_gwowroster.php on line 31

line 31 is: $number = ($number / $members) * 100; from what I can see

This error only shows on the second guild (Horde Side) that I just added minutes ago. My original guild roster works perfectly.

Gonna check back on it later and see if anything changes?

[Gryphon]

Uploaded a fix for the divide by zero error.

[Danoxth]

Just installed the latest version and seem to be getting this error when I run the scheduled task to scan the armoury for the main roster:

"Fatal error: Call to undefined function curl_init() in xxxxxxxxxxxxxxx\class_gwowarmory.php on line 174"

Edit: My bad, presume I need to get curl installed on server then?

[Tolas]

Latest version is working like a Champ!

Thanks Gryphon.

[GabbaGandalf198]

i have still a problem, when updating users with special characters like ^ oder `, i tries the solution on the page before but it isn't working for me ;(

[poninja]

Two requests. First, it looks like the country isn't getting passed to the armory-lite link. You're linking to http://www.armory-light.com//Fenris/Vathek/ instead of http://www.armory-light.com/us/Fenris/Vathek/

Second, I don't know if there would be an easy way to exclude members from the roster page by name, but we have several members on the armory that haven't actually been in our guild in over a year and it would be nice to be able to filter them on our website.

[Gryphon]

Two requests. First, it looks like the country isn't getting passed to the armory-lite link. You're linking to http://www.armory-light.com//Fenris/Vathek/ instead of http://www.armory-light.com/us/Fenris/Vathek/

Released 1.0.5 to fix this issue.

Second, I don't know if there would be an easy way to exclude members from the roster page by name, but we have several members on the armory that haven't actually been in our guild in over a year and it would be nice to be able to filter them on our website.

I can look into this, however, I can't promise I can implement it anytime soon as I am stretched thin on both my public and private projects.

[Warion]

could this roster be set up for other games. Ones without updates fromthe games themselves. Just a roster that users could manually add mains and alts to the roster. I run a forum for multiple games, so would need to be able to run atleast for different rosters. Any help would be great.

[Gryphon]

I am afraid not.

[gusfune]

I got this error:

Database error in vBulletin 3.7.2:

Invalid SQL:

CREATE TABLE IF NOT EXISTS vb_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
Request Date : Monday, October 6th 2008 @ 02:14:18 PM
Error Date : Monday, October 6th 2008 @ 02:14:18 PM
Script : http://x.com/admincp/plugin.php?do=productimport
Referrer : http://x.com/admincp/plugin.php?do=productadd
IP Address : x9.x6.x4.x0
Username : admin
Classname : vB_Database
MySQL Version : 5.0.67-log

Can't add product

[hunteds911]

I created a new guild the other night and then changed out the guild name in gwowroster options to reflect a new guild. Now when I run the gwowroster guild info update from the scheduled tasks I get the following. It worked before I changed the guild name btw.


Database error in vBulletin 3.7.3:

Invalid SQL:
DELETE FROM gwowroster_rosterinfo WHERE NOT (
locale IN('US') AND
realm IN('Blackhand') 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
Request Date : Friday, October 10th 2008 @ 09:52:10 AM
Error Date : Friday, October 10th 2008 @ 09:52:15 AM
Script : http://realmgfx.com/forum/admin_cp/cronadmin.php?do=runcron&cronid=30
Referrer : http://realmgfx.com/forum/admin_cp/index.php
IP Address : 24.219.216.156
Username : Hunted
Classname : vb_database
MySQL Version : 5.0.51a-log

[civy]

getting the following error

gWoWRoster Guild Info Update

Fatal error: Cannot use string offset as an array in /home/waruser/public_html/forum/includes/cron/cron.gwowroster.guildinfo.php on line 62

guild info is

EU|skullcrusher|knight of the temple

any idea?

[Sarvoth]

Hi!

I love this mod. It works great.

I am wondering if there is anyway to pull the guild rank from the roster and display it? If not, might be a good idea to include if you update this.:up:

Ok I am an idiot. It does do this, but for some reason I thought it was PVP rank. LOL anyways... I notice when I sort it, some rank 2's appear at the top of the list, then it goes 1s, then finally to 0. Doesn't seem to be sorting right.

[slick368]

I tried installing this mod on my site and received the following database error:

Database error in vBulletin 3.7.3:

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
Classname : vB_Database_MySQLi
MySQL Version : 5.0.51a-community


I have tried installing this on my live site and a test site that has no other plug-ins installed. I have successfully installed the other gWoW add-ons and have experienced no problems.

I would like to find a way to resolve this problem since this add-on is something I really want to have for my guild's site. Any help would be appreciated!

[slick368]

I had the same problem with when I tried to install. Go to your forum's database in phpMyAdmin or whatever you use to manage your database and make sure the database collation is set to latin1_generalci. All of my databases default to utf8_unicode_ci and that is what caused the problem.

If you are using phpMyAdmin, you can find the setting by selecting your forum's database, then clicking the Operations tabe. The collation setting is near the bottom.

Once the change was made, the add-on installed for me without a hitch. Hope this helps!

I got this error:

Database error in vBulletin 3.7.2:

Invalid SQL:

CREATE TABLE IF NOT EXISTS vb_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
Request Date : Monday, October 6th 2008 @ 02:14:18 PM
Error Date : Monday, October 6th 2008 @ 02:14:18 PM
Script : http://x.com/admincp/plugin.php?do=productimport
Referrer : http://x.com/admincp/plugin.php?do=productadd
IP Address : x9.x6.x4.x0
Username : admin
Classname : vB_Database
MySQL Version : 5.0.67-log

Can't add product

[forumrunt]

can this be used for more than one Guild on a single site?

[Gryphon]

can this be used for more than one Guild on a single site?

Yes, see this site (http://www.alliedtribalforces.com/gwowroster.php) click "Alleria: Allied Tribal Forces" for a drop down of other guilds and servers.

[forumrunt]

awesome thanks

[forumrunt]

not updating for some reason

[forumrunt]

<a href="http://www.worldofwarcraftkids.com/forum/gwowroster.php?loc=US&realm=Rexxar&name=Hardcore+Horde" target="_blank">http://www.worldofwarcraftkids.com/f...Hardcore+Horde</a>

Can you see what I have going on here and how I can fix it?

[WNxWakko]

Two issues.

1. The spec section isnt updaing. The icon just spins as it seems to not be gathering the data.
2. I have a batch of level 80 avatars, I uploaded the directory matching what level 70 would be but not sure how to configure it to use them.

[Gryphon]

1. There are two processes that happen, 1 it fetches the guild roster and populates that data, and 2 over the course of 24 hours it fetches each character for their talent data, so it can take a little time to get the talents. It's also possible if you have a huge roster that the vBulletin mock cron job is just not powerful enough to process the armory data, I run my vB cron via true cron to ensure that it runs completely. The Armory was wiped of character data a couple week ago or so, anyone who has not logged in since then will not have talent data until they login.

2. There shouldn't be anything to do, it will use the avatars when a character turns 80 just like the other level avatars. It is just in two zips here because vB.org won't allow one large zip.

[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]

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]

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? :D

[Bukusami]

No matter, blonde moment all working now :)

Just need to run update a few hundred times :D

[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.

[slick368]

I had the same problem with when I tried to install. Go to your forum's database in phpMyAdmin or whatever you use to manage your database and make sure the database collation is set to latin1_generalci. All of my databases default to utf8_unicode_ci and that is what caused the problem.

If you are using phpMyAdmin, you can find the setting by selecting your forum's database, then clicking the Operations tabe. The collation setting is near the bottom.

Once the change was made, the add-on installed for me without a hitch. Hope this helps!




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.

[theorigin]

Hmmm...I just tried that, but it's still giving me the same error. I upgraded to 3.7.4 to see if that'd fix it, but it didn't. Looks like I just have to wait on godaddy's response and go from there. Thanks for the help though.

[NeroObsedian]

I'm having some issues with this.

Database error in vBulletin 3.7.2:

Invalid SQL:
DELETE FROM forumsgwowroster_rosterinfo WHERE NOT (
locale IN('US') AND
realm IN('Eredar') 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

Array
(
[globalSearch] => 1
[lang] => en_us
[errorhtml] =>
[guildKey] => Array
(
[locale] => US
[faction] => Horde
)

[guildInfo] => Array
(
[guild] => Array
(
[count00] => 0
)

)

)


I don't know much about SQL, not sure why its not updating. I ran the character update first and that works fine. I have noticed that the userfield ID in the options will only allow the #. My field is 7 and it will only allow me to enter "7" instead of "field7" not sure if that's part of the issue or not.

I've double checked with my host and cURL is good, so I don't think that is the issue.

Same issue as Creme from the previous page it seems.

[Bl00dRoyal]

Is there a way to make it default sort by guild rank ascending from 0 (GM) and up? I think I see the code in the php file but I am a noob and don't want to mess up and do something wrong. Would be a nice feature to have the option within the control panel to switch how it is sorted.

[Finger78]

I have been trying to get this working for over a week, my vb skills are beginner at best, you can see the site here and it appear that the images arent working but I have uploaded everything 4 times both into the forums folders and the root folder for the site and nothing seems to help

http://www.angry-mob.org/forums/gwowroster.php

Also, on the armory links the link it gives is:
http://ushttp//www.wowarmory.com/character-sheet.xml?r=Archimonde&n=<name>

When it should read like:
http://us.wowarmory.com/character-sheet.xml?r=Archimonde&n=<name>

And I cant seem to locate where I would change something to fix this.

[Bl00dRoyal]

the images need to be copied into each style. I had that same problem at first.

[Finger78]

the images need to be copied into each style. I had that same problem at first.

Ok, I finally figured out what the issue was, not sure why its like this but here it is.

The avatars worked fine once I upped them to the style directory, but to get the icons to work I had to make a new directory within the gwowroster folder labeled with my style name and drop the icons into that.

My only remaining issue is one I already mentioned - The links provided to link to the US armory appear like this:
http://ushttp//www.wowarmory.com/character-sheet.xml?r=Archimonde&n=<name>

When it should read like:
http://us.wowarmory.com/character-sheet.xml?r=Archimonde&n=<name>

Any ideas?

[Vareyah]

Hi, I just installed this as well as your other mods. I got the wow character mod working, no problem, thanks alot. This was my second step. I don't know what went wrong, but it seems I can not view http://xraided-guild.net/forums/gwowroster.php even as a super administrator. Is there something I missed? If anyone can help me out, I'd appreciate it.

I basically followed all the instructions listed. Is there something I have to do in addition to this with the cron files? It says something about configuring the files, but I'm not sure which files need configuring.

[Finger78]

I have found a fix for my issue above but I would like to know if their is a proper fix for it

I fixed it by editing the gwr_roster_bit template and removed all lines that had

http://$armory

and changed it to

http://us.wowarmory.com

I'm sure this is not a proper way of changing this and would like to know a way to change it that would leave the original system intact

Also, the "Skills" link is non functional, I can only assume this is due to Blizzard changing their site, I changed mine to Achievements in the above mentioned template from:

http://$armory/character-skills.xml?

to

http://us.wowarmory.com/character-achievements.xml?$player[charurl]" target="_blank">Achievements</a>

[Gryphon]

@theorigin, there is no easy solution at the moment. The multiple keys are currently used to facilitate REPLACE queries. I will look into it, though I cannot say with certainty when or if it will ever be addressed.

@NeroObsedian, the Armory is returning an error page for whatever guild is trying to be fetched. The mysql error is due to no legitimate guild information retrieved in the first place. I am not sure what the issue could be however. It may be improper guild name entry in the options, special characters in the guild name, or armory is down. I am unsure exactly.

@Bl00dRoyal, you could try changing the default sort on line 238 in gwowroster.php from $sort_query = "r.level DESC"; to $sort_query = "r.rank ASC";.

@Finger78, I can not view your roster as a guest, though the images need to be uploaded per style, this is how my mods work to allow separate images per style. I am unsure why you had issue with your style needing folders to be created/renamed. I see you have several styles which, admittedly, can be a pain having to upload this mods images for each style. All I can guess is it was just a simple mistake in the upload process, they should all have the same structure.

Regarding the armory url, you may have a replacement variable that is modifying the output. I double checked my code and as far as I can see, it is not my code causing the odd urls.

With the Skills tab being dropped from the Armory, I will change the link to Achievements for future versions.

[Finger78]

@Finger78, I can not view your roster as a guest, though the images need to be uploaded per style, this is how my mods work to allow separate images per style. I am unsure why you had issue with your style needing folders to be created/renamed. I see you have several styles which, admittedly, can be a pain having to upload this mods images for each style. All I can guess is it was just a simple mistake in the upload process, they should all have the same structure.

Regarding the armory url, you may have a replacement variable that is modifying the output. I double checked my code and as far as I can see, it is not my code causing the odd urls.

With the Skills tab being dropped from the Armory, I will change the link to Achievements for future versions.

Not sure why, yes I do have several style and I uploaded the roster images to whatever random spot for each style (viewed it in IE and just looked at the broken images to see where it was looking then uploaded to there)

As for the url, not sure myself why the problem exsists, I couldnt find any other variable that would change it but its fixed now.

Glad I could help with the skills link.

Thanks for this great mod, my guild members are raving about it daily for ease of info about themselves and others in the guild A++ mod

[theorigin]

@theorigin, there is no easy solution at the moment. The multiple keys are currently used to facilitate REPLACE queries. I will look into it, though I cannot say with certainty when or if it will ever be addressed.



Do you think this is something that could be fixed by upgrading to MySQL 5?

[Gryphon]

Do you think this is something that could be fixed by upgrading to MySQL 5?

I am not sure. I am currently running MySQL 5, though I am pretty sure that ran this when I was using MySQL 4, it may be some other setting.

[theorigin]

I am not sure. I am currently running MySQL 5, though I am pretty sure that ran this when I was using MySQL 4, it may be some other setting.

This is the common error I'm getting every time I try it..

MySQL Error : Specified key was too long; max key length is 1000 bytes

Is there any way to extend the max key length?

[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...

[Rigar]

Really nice addon, lots of possibilities here. I've kinda gotten myself involved in trying to get the special characters to work. From a previous post people linked to WoWRoster as an example of a prog that seems to be able to do this. I went to their forums and found a nice thread on this subject.

So as it is we have special characters in the DB stored as ISO-8859-1? Is there a way to use utf8_decode and utf8_encode so that these names are displayed correctly?

[jlew24asu]

Only about 10 million :D

wow 10 million? I had no idea it was so popular.

[jlew24asu]

how many WoW boards are out there?

[Dragonsys]

how many WoW boards are out there?

tons of them.

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]

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]

tons of them.



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


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]

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]

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]

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]

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. :D

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]

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.

[y2krazy]

exactly. Here's a little info, as an example
Ok. I won't worry about it too much until it goes live. Thanks for the help. :)

I sent a meassge to Gryphon about my changes.
Awesome. <3

~ Sean

[N00BIE]

Hi =] i have have the roster all working fine apart from a slight problem with the names column some of our players have long name and that over laps their talent spec how to i make the name column wider i gather it's in the gwowroster template section some where =] ??
complete VB noobie =]
many thanx

[y2krazy]

Hi =] i have have the roster all working fine apart from a slight problem with the names column some of our players have long name and that over laps their talent spec how to i make the name column wider i gather it's in the gwowroster template section some where =] ??
complete VB noobie =]
many thanx
In the template, "gwr_roster":

Find:

<td class="thead" nowrap="nowrap" width="100%"><a href="gwowroster.php?$guild[url]&page=$pagenumber&amp;sortfield=name&amp;sortorder=$opposit esort">Name</a> <if condition="$sortfield == name"><a href="gwowroster.php?$guild[url]&page=$pagenumber&amp;sortfield=name&amp;sortorder=$opposit esort"><img class="inlineimg" src="$stylevar[imgdir_button]/sort$oppositesort.gif" alt="$vbphrase[reverse_sort_order]" border="0" /></a></if></td>


Change:

<td class="thead" nowrap="nowrap" width="100%"><a href="gwowroster.php?$guild[url]&page=$pagenumber&amp;sortfield=name&amp;sortorder=$opposit esort">Name</a> <if condition="$sortfield == name"><a href="gwowroster.php?$guild[url]&page=$pagenumber&amp;sortfield=name&amp;sortorder=$opposit esort"><img class="inlineimg" src="$stylevar[imgdir_button]/sort$oppositesort.gif" alt="$vbphrase[reverse_sort_order]" border="0" /></a></if></td>


Instead of "100%", change it to a numeric value, such as "300" and see if that changes anything. It may cause your other sections to stretch out a bit, depending on your resolution. If you need it bigger, increase the number, if you need it smaller, decrese the number. Let me know how that works!

~ Sean

[Dragonsys]

Hi =] i have have the roster all working fine apart from a slight problem with the names column some of our players have long name and that over laps their talent spec how to i make the name column wider i gather it's in the gwowroster template section some where =] ??
complete VB noobie =]
many thanx

the field size is dynamic. it will grow and shrink as needed. If you have information which is overlapping, then you have 1 or 2 problems with your forum style.

1. Your style is probably fixed width, and therefore does not allow the table to "grow"
2. Your screen display size is low

You can set the cell size as y2krazy suggested, just be aware that this will limit the size of the other fields in the table.

[Gryphon]

About how many characters it updates at a time;

It actually updates the roster count divided by 70 and rounded up. If you have more than 70 people on the roster, it will do 2 at a time, if more than 140 it will do 3 at a time. It picks the oldest updated characters to fetch each run and it is scheduled to run about 140 times a day.

This can be improved a little bit, but for the most part, if you try and gather too many at once it just won't run on vBulletin's mock cron.

I have many mods I have created that do external data fetches like this mod, so I also run the vB Scheduled Tasks via try cron to ensure that it runs once a minute regardless of forum traffic. But I mainly do this because external data fetches are often slow and/or intensive so even if you had 1000 hits a minute on your site, vBulletin's mock cron just isn't powerful enough to execute properly.

[MiskaTorn]

Will this function properly in 3.8.1? Sorry if this has already been addressed, I did a search and did not find anything.

[Gryphon]

Will this function properly in 3.8.1? Sorry if this has already been addressed, I did a search and did not find anything.

It should be pretty independent of vBulletin version, there would have to be significant changes in vBulletin for this to not work.

[Dragonsys]

About how many characters it updates at a time;

It actually updates the roster count divided by 70 and rounded up. If you have more than 70 people on the roster, it will do 2 at a time, if more than 140 it will do 3 at a time. It picks the oldest updated characters to fetch each run and it is scheduled to run about 140 times a day.

This can be improved a little bit, but for the most part, if you try and gather too many at once it just won't run on vBulletin's mock cron.

I have many mods I have created that do external data fetches like this mod, so I also run the vB Scheduled Tasks via try cron to ensure that it runs once a minute regardless of forum traffic. But I mainly do this because external data fetches are often slow and/or intensive so even if you had 1000 hits a minute on your site, vBulletin's mock cron just isn't powerful enough to execute properly.

Ahhh ok, I only have 10 members, so I have only seen 1 character at a time. I agree about VB's sudo-cron. It's kind of clunky and slow, plus I would imgine it can get overloaded easily. This is why I use the cron mod I posted earlier as well.

Will this function properly in 3.8.1? Sorry if this has already been addressed, I did a search and did not find anything.

yes, it functions perfectly fine in 3.8.1

[y2krazy]

Will this function properly in 3.8.1? Sorry if this has already been addressed, I did a search and did not find anything.
Yes. Working well on my dev board. Only issue I'm having is a lack of scheduled tasks being run when they're supposed to; but, it's a dev board, so there's little to no activity on it, so I'm not worried about that.

If your board is active, you should have no issues.

By the way, Gryphon, you had a chance to look over Dragonsys's PM? :)

~ Sean

[MiskaTorn]

This is the common error I'm getting every time I try it..

MySQL Error : Specified key was too long; max key length is 1000 bytes

Is there any way to extend the max key length?
I am getting the same error.

[MiskaTorn]

Nevermind, doesn't seem to be working

[MiskaTorn]

Change the creation of the table in the xml file for this
// Character Professions
$vbulletin->db->query("
CREATE TABLE IF NOT EXISTS " . TABLE_PREFIX . "gwowroster_charinfo_prof (
`locale` VARCHAR( 2 ) NOT NULL ,
`realm` VARCHAR( 50 ) NOT NULL ,
`name` VARCHAR( 50 ) NOT NULL ,
`charname` VARCHAR( 50 ) NOT NULL ,
`key` VARCHAR( 50 ) NOT NULL ,
`updated` INT( 150 ) NOT NULL ,
`primary` INT( 1 ) NOT NULL ,
`profname` VARCHAR( 50 ) NOT NULL ,
`max` INT( 10 ) NOT NULL ,
`value` INT( 10 ) NOT NULL ,
PRIMARY KEY ( `locale`, `realm`, `name`, `charname`, `key` )
)
");
This mght help until the developer can address this issue. When using UTF there are just too many characters being specified, so I shortened them up.

[Dragonsys]

Change the creation of the table in the xml file for this
This mght help until the developer can address this issue. When using UTF there are just too many characters being specified, so I shortened them up.

What exactly did you change? I have not been able to reproduce this error...

By the way, Gryphon, you had a chance to look over Dragonsys's PM? :)

~ Sean

He did, and he has asked me not to release my changes. I have sent them all to him, and he said he would look into including them in a future release; however, he did say that it might take him some time to do so, due to his time being taken up a lot with another ptoject and RL.
I also added Character Prefix & Suffix titles


EDIT: I am cleaning up my code and resending the changes. Looks like my first submission got "eaten" by my ISP up/down issues.

[y2krazy]

He did, and he has asked me not to release my changes. I have sent them all to him, and he said he would look into including them in a future release; however, he did say that it might take him some time to do so, due to his time being taken up a lot with another ptoject and RL.
Sounds good. I check daily. Lol. :D

~ Sean

[Bukusami]

I have it installed on a empty forum i am building.
the scheduled tasks do not seem to be running, i have been manually running the tasks at the moment and turned logging on to make sure there working and no logs have been made and no details have been fetched for members.

the log does show digest daily and weekly have run so i know scheduled tasks is working, albeit slowly.

Any ideas?

[Bukusami]

I think i fixed it, as my board is inactive the cron command is not being run in the footer.

Although it updated in scheduled tasks it didnt write anything to the log so still not 100% sure it working.

Also i forgot i done it before but where do i edit to change the gwowroster text that shows on the navigation?

[Dragonsys]

I think i fixed it, as my board is inactive the cron command is not being run in the footer.

Although it updated in scheduled tasks it didnt write anything to the log so still not 100% sure it working.

Also i forgot i done it before but where do i edit to change the gwowroster text that shows on the navigation?

look for the following phrases:
gwr_title
gwr_vbnav

[SlompOchomp]

What exactly did you change? I have not been able to reproduce this error...



He did, and he has asked me not to release my changes. I have sent them all to him, and he said he would look into including them in a future release; however, he did say that it might take him some time to do so, due to his time being taken up a lot with another ptoject and RL.
I also added Character Prefix & Suffix titles


EDIT: I am cleaning up my code and resending the changes. Looks like my first submission got "eaten" by my ISP up/down issues.

Looking forward to the changes you had done, any news as of yet ?

[Gryphon]

Dragonsys I have not received an email yet.

[y2krazy]

Dragonsys I have not received an email yet.
Let's hope he hasn't gone missing! :(

~ Sean

[Forage]

I have read every post for this mod and have seen the question come across once or twice and it was answered for level which still did not really help me any.

What I would like to do is set up the Roster to only show specific ranks so I can trim down the raoster from including alts and friends and everything else.

So far I have tried a few different options in the cron.gwowroster.guildinfo but nothing that is filtering the showing options.

Any advice would be appreciated.

[Dragonsys]

Dragonsys I have not received an email yet.

DOH! sorry. I was having some problems with my email server, and I guess the emails I sent you were some of the ones which got eaten.

I will try to resend this weekend.

[y2krazy]

DOH! sorry. I was having some problems with my email server, and I guess the emails I sent you were some of the ones which got eaten.

I will try to resend this weekend.
https://vborg.vbsupport.ru/












Thanks. <3

~ Sean

[SlompOchomp]

http://gators.invisionzone.com/style_emoticons/default/shakefist.gif
Thanks. <3

~ Sean
Should we see an update soon? :D

[washingtonboise]

I am impressed with how slick this looks.
I am establishing a vbulletin community which will help people buy and sell game accounts without getting scammed. (Other forums are poorly organized and aren't educating their users.)

I would like a lightly modified version of this. Are you taking jobs at the moment?

[Dragonsys]

I sent my files. Please let me know if you get them.
Looks like I need to install a couple of updates...

[Dragonsys]

I am impressed with how slick this looks.
I am establishing a vbulletin community which will help people buy and sell game accounts without getting scammed. (Other forums are poorly organized and aren't educating their users.)

I would like a lightly modified version of this. Are you taking jobs at the moment?

You do realize that it is against Blizz's ToS to buy/sell acounts right?

[Gryphon]

I have received the files I will take a look at them when I get time.

washingtonboise, I don't support anything against Blizzards terms.

[Xennor]

Everything had been working fine up until a day or so ago. Now we are getting the following error from the cron job:

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


Anyone have any ideas?

[ColossusCH]

Same problem here,

ohhhh Blizzard, what did you change ?????

[SlompOchomp]

I have received the files I will take a look at them when I get time. Can't wait to see the changes https://vborg.vbsupport.ru/external/2011/02/1.gif

[Dragonsys]

Everything had been working fine up until a day or so ago. Now we are getting the following error from the cron job:

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


Anyone have any ideas?

Probably due to all the changed Blizz made to the Armory for the 3.1 Patch

[Gryphon]

Yeah, the Armory changes most likely broke it. I will have to look into it.

[Xennor]

Yeah, the Armory changes most likely broke it. I will have to look into it.

Not getting the error anymore with the new version, but now the Race "text" is wrong for everyone. The Race "icon" is right, just the "text" itself is wrong.

[Juravieal]

Im getting this error with a new install:

Warning: require_once(./global.php) [function.require-once]: failed to open stream: No such file or directory in /home/eidolon1/public_html/gwowroster.php on line 46

Fatal error: require_once() [function.require]: Failed opening required './global.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/eidolon1/public_html/gwowroster.php on line 46

[AK47 Nemesis]

Is there an option to set permissions or something? Cause i can't access it after i installed it. I used it before fine, but just updated it to the newest version.

EDIT: Nvm, stupid mistake by me :P.

[quinnie]

I'm getting this error on a new install:

Database error in vBulletin 3.8.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
Request Date : Tuesday, April 21st 2009 @ 05:26:10 AM
Error Date : Tuesday, April 21st 2009 @ 05:26:10 AM
Script : /admincp/plugin.php?do=productimport
Referrer : /admincp/plugin.php?do=productadd
Classname : vb_database
MySQL Version : 5.0.58-log

Just wondering if this is anything I'm doing wrong? MySQL version not supported?

[kemical]

I am getting the same error on a new installation:
Database error in vBulletin 3.8.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
Request Date : Thursday, April 23rd 2009 @ 12:10:14 PM
Error Date : Thursday, April 23rd 2009 @ 12:10:15 PM
Script : /admincp/plugin.php?do=productimport
Referrer : /admincp/plugin.php?do=productadd
Classname : vB_Database_MySQLi
MySQL Version : 5.1.30

[imported_sasavtec]

Same issue as the last 2 posts :(

[imported_sasavtec]

Anyone know a solution to fix this and get it working?

[imported_sasavtec]

Anyone? Anything?

[Dragonsys]

try changing this line:

PRIMARY KEY ( `locale`, `realm`, `name`, `charname`, `key` )

to

PRIMARY KEY ( `realm`, `charname`, `key` )

[kemical]

try changing this line:

PRIMARY KEY ( `locale`, `realm`, `name`, `charname`, `key` )

to

PRIMARY KEY ( `realm`, `charname`, `key` )

That change allowed me to install it without error. I now have 2 additional problems

1) The Userfield ID (field 5 in my case) change I made does not appear to be saving
2) When I try to browse to mywebsite.com/forums/gwowroster.php I get this error:

you do not have permission to access this page. This could be due to one of several reasons:

1. Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
2. If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.

This error occurs with both a normal user and admin user. Are there additional permissions that I need to set? Thanks in advance :D

[Dragonsys]

That change allowed me to install it without error. I now have 2 additional problems

1) The Userfield ID (field 5 in my case) change I made does not appear to be saving
2) When I try to browse to mywebsite.com/forums/gwowroster.php I get this error:

you do not have permission to access this page. This could be due to one of several reasons:

1. Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
2. If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.

This error occurs with both a normal user and admin user. Are there additional permissions that I need to set? Thanks in advance :D

1. Not saving in the roster settings or in VB?
2. You need to give permissions to your usergroups to view the Roster

[kemical]

1. Not saving in the roster settings or in VB?
2. You need to give permissions to your usergroups to view the Roster

I have searched high and low before responding, but I cannot find anywhere in the AdminCP that allows me to add permissions to usergroups to view the roster. I do not see it listed in Forum Manager or Forum Permissions. Is there another section of the AdminCP where this is tucked away and I am just not finding it?

[BaCkBuRn]

I have searched high and low before responding, but I cannot find anywhere in the AdminCP that allows me to add permissions to usergroups to view the roster. I do not see it listed in Forum Manager or Forum Permissions. Is there another section of the AdminCP where this is tucked away and I am just not finding it?

Go to your Usergroup list in admincp. Write down the usergroup id #'s for each of the user groups you want to have access.

Go to the config page for gWoWRoster. Find the access box and add all those numbers separated by commas.

[kemical]

Go to your Usergroup list in admincp. Write down the usergroup id #'s for each of the user groups you want to have access.

Go to the config page for gWoWRoster. Find the access box and add all those numbers separated by commas.

Thank you so much! Everything is working now. And thank you for being so kind to this nub vBulletin admin.

[imported_sasavtec]

I have gotten past all the errors and crap, but how long does it take for the roster content to actually show up? or did I do something wrong?, one more thing images that are in the folder would I upload folder gwroster into /images/misc or somewhere else?

[BaCkBuRn]

I have gotten past all the errors and crap, but how long does it take for the roster content to actually show up? or did I do something wrong?, one more thing images that are in the folder would I upload folder gwroster into /images/misc or somewhere else?

the gwowroster folder should be in ~/www/forum/images/<style name>/misc

The cron job (scheduled tasks) should populate the list every 10min. HOWEVER, Its not working for me either. I believe the addon is currently broken until they can update it for the new Armory changes that came out with 3.1.1. So you basicly have to wait for them to update it...

[Gryphon]

try changing this line:

PRIMARY KEY ( `locale`, `realm`, `name`, `charname`, `key` )

to

PRIMARY KEY ( `realm`, `charname`, `key` )

I am pretty sure that will break the replace queries used in the cron.

HOWEVER, Its not working for me either. I believe the addon is currently broken until they can update it for the new Armory changes that came out with 3.1.1. So you basicly have to wait for them to update it...

I released an update on the day the changes were made, the roster is working as intended for me.

[BaCkBuRn]

I believe ive installed everything properly but the roster is still not being populated. There are 5 toons over 3 accounts entered at this point and the gWoWchar addon is working perfectly; showing the accounts in the postbit.

No cron logs either and I've manually run it to no effect. Should the job be producing log entries? Or is that intended as it runs quite frequently?



http://www.malusdeiguild.com/forum/gwowroster.php

I must be doing something wrong, but no clue as to what that something is. XD

[Gryphon]

I believe I turned off log entries. If you run the cron manually, you should see the names of the guilds / characters that it attempted to update.

[BaCkBuRn]

I believe I turned off log entries. If you run the cron manually, you should see the names of the guilds / characters that it attempted to update.

Darn, I ran it manually several times (clicking the button in the entry list) and no log entries :(

Any ideas?

[imported_sasavtec]

One of my problems right now is the specs all it says is untelanted and keeps refreshing

[imported_sasavtec]

Also does anyone know of a possible way to filter out ranks shown on roster to like show rank 1, 2, 3, 4, 5 etc...

[quinnie]

One of my problems right now is the specs all it says is untelanted and keeps refreshing


I'm currently having this same problem.

View here:

http://premonitionwow.com/site/index.php/forums

EDIT: If I manually run the cron job for the character update it goes out and finds a new character. So essentially every 10 mins it would find a new one and take about 35 hours to complete the initial 'download' of all the characters in my guild. I would assume that isn't how this should work?

[RustyDogma]

I'm not sure if I'm doing this right. I have a site that people from all sorts of guilds are involved in. I'm using gWoWChar for each of them to list their characters.

What I had hoped for was that the roster would display the people from that field, but it is empty.

Do I have to manually add every guild for every person on my site, and if so, is there a way to get the information for just the people with a gWoWChar field inputted, not the entire roster of that guild?

[Gryphon]

This is for whole guild rosters, not a roster of individuals on the site. Something quite different would have to be developed to use just the gWoWChar profiles as a roster.

[RustyDogma]

Ahh, that's what I supected. Hmm... could I use fields from WoWChar in my member's list perhaps?

[Gryphon]

I am not sure what you are asking.

[imported_sasavtec]

I am not sure what you are asking.

Is it possible to filter the ranks shown for example right now all ranks in guild show even the lvl 3 alts, now would be nice to show only certain ranks from the guild. Also my spec part of the roster isnt changing it just keeps refreshing not showing any numbers.

[quinnie]

I'm currently having this same problem.

View here:

http://premonitionwow.com/site/index.php/forums

EDIT: If I manually run the cron job for the character update it goes out and finds a new character. So essentially every 10 mins it would find a new one and take about 35 hours to complete the initial 'download' of all the characters in my guild. I would assume that isn't how this should work?

So I'm guessing by the lack of response that this is intended to work this way? I still have characters that have not updated since this original post.

[Gryphon]

How many it updates at a time is determined by how big the roster is. With 200 members it should be doing 2 or 3 per update. When it reaches the end, which should be within 12 hours if the cron is run on schedule, it starts with the oldest updated member and starts all over again.

If you look at the ones that are Untalented, the characters probably have no points spent since the last refund.

[blake247]

try changing this line:

PRIMARY KEY ( `locale`, `realm`, `name`, `charname`, `key` )

to

PRIMARY KEY ( `realm`, `charname`, `key` )

Sorry I'm a noob, where do you change this at?

[acidpr]

How do you rename the navbar link?

[Repec]

In your admincp go to "Languages & Phrases" --> "Search phrases" and search for "gWoWRoster".
Then change the phrase "gwr_vbnav" to whatever you want it to be.

[acidpr]

Got it Thanks!

[CFodder]

Trying to install v1.0.14 on VB 3.8.1 PL1, getting the following error:

Database error in vBulletin 3.8.1:

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
Request Date : Monday, June 1st 2009 @ 04:16:39 AM
Error Date : Monday, June 1st 2009 @ 04:16:39 AM
Classname : vB_Database
MySQL Version : 5.1.30

Have tried the fix suggested but am now getting this error:


Database error in vBulletin 3.8.1:

Invalid SQL:

CREATE TABLE IF NOT EXISTS 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 ( `realm`, `charname`, `key` )
);

MySQL Error : Key column 'key' doesn't exist in table
Error Number : 1072
Classname : vB_Database
MySQL Version : 5.1.30


Is there any fix for the first error?

[Replicators]

Gryphon, it's quite obvious your a wow fan, but may i suggest you should of made them more, universal to all mmorpg's, or atleast easy to switch them to suit other mmo's?

[Pen411]

Got this installed and it seems to be working fine, however I read that the high-ascii char issue was fixed, yet I am still seeing jumbled name for toons that have them, and for the most part, it is those names who remain displayed as untalented : http://forums.amazonsguild.com/gwowroster.php

Other than that issue, very nice addon, tyvm!

Also, would it be possible to add another sort field for spec (not talent point allocation, just the text label of that spec, protection/restoration, etc)?