At first the page was timing out, so I figured it might be because it's trying to grab over 100 people from the armory. So I edited the config to get people lvl 60 and up and to turn on debugging. I ran it and it actually loaded the page but I got this error:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/r/m/a/****/html/roster/lib/wowdb.php on line 199

It also said it found the members, but it didn't update anything.

I changed the config again to pull only lvl 65 so it would load faster and higher and now it's timing out again. Not sure what's going on.

I'm not sure if I'm doing something wrong, or if the script is just buggy and I need to tweak a few things.

Thanks for any help.

*Edit

I ran it again for players 69 and up. It gave me the same error and said it found 14 players. But the players didn't get updated in the roster. This is what the page shows:

Code: Select all

SELECT members.name , ISNULL(players.name) AS playerExists , STR_TO_DATE(players.dateupdatedutc,'%m/%d/%y %H:%i:%s') AS playerLastUpdated FROM `roster_members` members LEFT JOIN `roster_players` players ON members.name = players.name WHERE members.level >= 69 AND ( ISNULL(players.name) OR STR_TO_DATE(players.dateupdatedutc,'%m/%d/%y %H:%i:%s') <= DATE_SUB(NOW(), INTERVAL 24 HOUR) OR STR_TO_DATE(players.dateupdatedutc,'%m/%d/%y %H:%i:%s') >= DATE_ADD(NOW(), INTERVAL 1 YEAR) ) ORDER BY members.last_online DESC
Dogan   0   2007-08-11 03:07:09
Mekaochan   1   
Pellerin   0   2007-09-23 16:10:16
Palnud   0   2007-09-24 03:12:31
Michator   1   
Drgonzo   1   
Alily   1   
Cottonswab   1   
Iwoow   0   2007-08-18 01:19:06
Killerai   1   
Delaena   1   
Clevilly   1   
Gimblozzo   1   
Stleathkillz   1   
Found 14 players.
GetContentCurl: armory.worldofwarcraft.com/character-sheet.xml?r=Shadowsong&n=Dogan, 1, User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.2) Gecko/20070219 Firefox/2.0.0.2, cookieLangId=en_us;
Non-Critical Error: Incomplete Data for Dogan. Player has probably not updated in awhile.
Dogan synched: 3 seconds. Total runtime: 3 seconds.
GetContentCurl: armory.worldofwarcraft.com/character-sheet.xml?r=Shadowsong&n=Mekaochan, 1, User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.2) Gecko/20070219 Firefox/2.0.0.2, cookieLangId=en_us;
Non-Critical Error: Incomplete Data for Mekaochan. Player has probably not updated in awhile.
Mekaochan synched: 0 seconds. Total runtime: 3 seconds.
GetContentCurl: armory.worldofwarcraft.com/character-sheet.xml?r=Shadowsong&n=Pellerin, 1, User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.2) Gecko/20070219 Firefox/2.0.0.2, cookieLangId=en_us;
Non-Critical Error: Incomplete Data for Pellerin. Player has probably not updated in awhile.
Pellerin synched: 8 seconds. Total runtime: 11 seconds.
GetContentCurl: armory.worldofwarcraft.com/character-sheet.xml?r=Shadowsong&n=Palnud, 1, User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.2) Gecko/20070219 Firefox/2.0.0.2, cookieLangId=en_us;
Non-Critical Error: Incomplete Data for Palnud. Player has probably not updated in awhile.
Palnud synched: 5 seconds. Total runtime: 16 seconds.
GetContentCurl: armory.worldofwarcraft.com/character-sheet.xml?r=Shadowsong&n=Michator, 1, User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.2) Gecko/20070219 Firefox/2.0.0.2, cookieLangId=en_us;
Non-Critical Error: Incomplete Data for Michator. Player has probably not updated in awhile.
Michator synched: 1 seconds. Total runtime: 17 seconds.
GetContentCurl: armory.worldofwarcraft.com/character-sheet.xml?r=Shadowsong&n=Drgonzo, 1, User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.2) Gecko/20070219 Firefox/2.0.0.2, cookieLangId=en_us;
Non-Critical Error: Incomplete Data for Drgonzo. Player has probably not updated in awhile.
Drgonzo synched: 5 seconds. Total runtime: 22 seconds.
GetContentCurl: armory.worldofwarcraft.com/character-sheet.xml?r=Shadowsong&n=Alily, 1, User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.2) Gecko/20070219 Firefox/2.0.0.2, cookieLangId=en_us;
Non-Critical Error: Incomplete Data for Alily. Player has probably not updated in awhile.
Alily synched: 3 seconds. Total runtime: 25 seconds.
GetContentCurl: armory.worldofwarcraft.com/character-sheet.xml?r=Shadowsong&n=Cottonswab, 1, User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.2) Gecko/20070219 Firefox/2.0.0.2, cookieLangId=en_us;
Non-Critical Error: Incomplete Data for Cottonswab. Player has probably not updated in awhile.
Cottonswab synched: 5 seconds. Total runtime: 30 seconds.
GetContentCurl: armory.worldofwarcraft.com/character-sheet.xml?r=Shadowsong&n=Iwoow, 1, User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.2) Gecko/20070219 Firefox/2.0.0.2, cookieLangId=en_us;
Non-Critical Error: Incomplete Data for Iwoow. Player has probably not updated in awhile.
Iwoow synched: 0 seconds. Total runtime: 30 seconds.
GetContentCurl: armory.worldofwarcraft.com/character-sheet.xml?r=Shadowsong&n=Killerai, 1, User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.2) Gecko/20070219 Firefox/2.0.0.2, cookieLangId=en_us;
Non-Critical Error: Incomplete Data for Killerai. Player has probably not updated in awhile.
Killerai synched: 0 seconds. Total runtime: 30 seconds.
GetContentCurl: armory.worldofwarcraft.com/character-sheet.xml?r=Shadowsong&n=Delaena, 1, User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.2) Gecko/20070219 Firefox/2.0.0.2, cookieLangId=en_us;
Non-Critical Error: Incomplete Data for Delaena. Player has probably not updated in awhile.
Delaena synched: 5 seconds. Total runtime: 35 seconds.
GetContentCurl: armory.worldofwarcraft.com/character-sheet.xml?r=Shadowsong&n=Clevilly, 1, User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.2) Gecko/20070219 Firefox/2.0.0.2, cookieLangId=en_us;
Non-Critical Error: Incomplete Data for Clevilly. Player has probably not updated in awhile.
Clevilly synched: 4 seconds. Total runtime: 39 seconds.
GetContentCurl: armory.worldofwarcraft.com/character-sheet.xml?r=Shadowsong&n=Gimblozzo, 1, User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.2) Gecko/20070219 Firefox/2.0.0.2, cookieLangId=en_us;
Non-Critical Error: Incomplete Data for Gimblozzo. Player has probably not updated in awhile.
Gimblozzo synched: 4 seconds. Total runtime: 43 seconds.
GetContentCurl: armory.worldofwarcraft.com/character-sheet.xml?r=Shadowsong&n=Stleathkillz, 1, User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.2) Gecko/20070219 Firefox/2.0.0.2, cookieLangId=en_us;
Non-Critical Error: Incomplete Data for Stleathkillz. Player has probably not updated in awhile.
Stleathkillz synched: 6 seconds. Total runtime: 49 seconds.

Which version are you using?

poetter wrote:Which version are you using?

WoWRoster v1.7.3

I think he wants to know which version of armorysync too

Yes indeed ;-)

I can't find a version anywhere in the script, and there is no readme or anything with it, but I downloaded it from this page:

http://www.wowroster.net/Downloads/details/id=112.html

Ahh, i see. Try this one: Link

poetter wrote:Ahh, i see. Try this one: Link

Ok, I installed that one and it's timing out on me every time. It just goes to a blank white page and says done.

My config:

Code: Select all

$addon_conf['ArmorySync']['Host'] = "www.wowarmory.com"; //Americans use "www.wowarmory.com", European players use: "eu.wowarmory.com"
$addon_conf['ArmorySync']['MinLevel'] = 69; //The minimum level to be updated
$addon_conf['ArmorySync']['SynchCutoffTime'] = 60; //Time, in minutes.  All players who have not updated in the last (24) hours will be updated.
$addon_conf['ArmorySync']['UseCurl'] = false; //Set this to false if you want to use the original FileSocket function.
$addon_conf['ArmorySync']['DebugLevel'] = 2; //0 = no debug messages, 1 = some debug messages, 2 = verbose debug messages
$addon_conf['ArmorySync']['UpdateRoster'] = true; //Wether or not to update Roster.  Useful if you're just debugging.
$addon_conf['ArmorySync']['Locale'] = $roster_conf['roster_lang']; //The language used, but default it is the language that roster is configured to.
$addon_conf['ArmorySync']['ArmoryLocale'] = strtolower(substr($addon_conf['ArmorySync']['Locale'], 0, 2)) . "_" . strtolower(substr($addon_conf['ArmorySync']['Locale'], 2, 2)); //The Locale that armory is expecting, in the format of lowercase_lowercase (ie en_us or de_de).
$addon_conf['ArmorySync']['MemberSorting'] = "members.last_online DESC"; //alternatives are "members.update_time DESC" to use the last time the member was updated
$addon_conf['ArmorySync']['ServerMonth'] = array("January","February","March","April","May","June","July","August","September","October","November","December"); //just a list of the month names for the server.  Change this to whatever language necessary.
$addon_conf['ArmorySync']['DateUpdatedFormat'] = "%m/%d/%y %H:%i:%s"; //Don't touch this!!! As i can see the time format is always set as it is set here
$addon_conf['ArmorySync']['IsWoWRosterDF'] = 0; //DragonFly Users with WoWRosterDF want this to be 1
$addon_conf['ArmorySync']['IsMySQLLower411'] = 0; //Users of MySQL Version lower than 4.1.1 want thi sto be 1

A blank white screen normaly happen if the url reloaded is incorrect. Do you have WoWRoster or Dragonfly with WoWRosterDF?

BTW: How can a blank white screen say "done" ? ;-)

poetter wrote:A blank white screen normaly happen if the url reloaded is incorrect. Do you have WoWRoster or Dragonfly with WoWRosterDF?

BTW: How can a blank white screen say "done" ? ;-)

It says done at the bottom in the status bar. I'm using wowroster, no dragonfly. I just tried it again and got this error:

Code: Select all

2013: Lost connection to MySQL server during query
SQL:
SELECT * FROM `roster_guild` WHERE `guild_name` = 'Coin Operated Army' AND `server` = 'Shadowsong'
File: wowdb.php
Function: get_guild_info
Line: 1840

You are on a shared host with a small web presents?

This error is a host thing. You have to check your my.cnf, but i think you can't. Try another hoster!

Well thanks anyway for trying to help. I'm not going to switch hosts because one mod doesn't work and everything else on my site works fine.

Guess I'll just keep reminding everyone to update their roster profile manually.

Shenandoah wrote:Guess I'll just keep reminding everyone to update their roster profile manually.

That's a last bottom line solution.

Most Guildies bought these horrible things named "PC's" to run their favourite game.... They spend hours, if not days to set it up correctly to run their WoW Add On's etc.....
They 'could' spend 30 seconds to install UniUpLoader (prepare one for them for your Guild - and offer to your Guildies on your site).

Roster updating : no more problems,
Add On updates : no more hassle.

A nearly perfect solution…. For those who care ;-)

Think about it : it just works.

Yeah, it sounds great but for some reason most of the people in my guild don't want to do much of anything but get on and play the game. Getting them to even sign up on our forums seems to be too much of a hassle for them :/ I personally don't understand it, but oh well...