Introducing ArmorySync

by **blackice** » Sat Mar 31, 2007 1:05 pm

Okay this is odd, Just got the new version and here is what happening

I am getting a white page with the following info (remove the names and replace with playerx)

player1 synched: 5 seconds. Total runtime: 5 seconds.
player2 synched: 6 seconds. Total runtime: 11 seconds.
player3 synched: 5 seconds. Total runtime: 16 seconds.
player4 synched: 6 seconds. Total runtime: 22 seconds.
player5 synched: 5 seconds. Total runtime: 27 seconds.

Looks like it work but I don't see anything new in the database.

Any ideas?

by **DopeFish** » Sat Mar 31, 2007 8:09 pm

jungzandvliet wrote:
titan99 wrote:Wyren i have this bug me to

For you guys to let you know, Kristoff is gonna look this weekend on the armorsynch for wow-europe

the blizzard servers for the european armory are pretty much fubar right now. I'm not surprised the scripts are having problems fetching the xml files, heck using the page "normally" with a browser hasn't worked for days.

by **blackice** » Sat Mar 31, 2007 10:15 pm

Wyren wrote:Just a small thing in localization.php:
Code: Select all
<? $wordings['enUS']['title_addon'] = 'Armory Synch'; $wordings['addoncredits']['GuildBank v1.26'] = array( array( "name"=> "Mathos", "info"=> "Synch your guild with WoW Armory"), ); ?>
Copy & Paste from GuildBank's localization.php?

Going to test the addon now, changed the "not updated the last 24 hours" to 504 (3 weeks) tho

That is what it looks like, I would guess it should be something like this.

Code: Select all: <?php $wordings['enUS']['title_addon'] = 'Armory Synch'; $wordings['addoncredits']['Armory Synch'] = array( array( "name"=> "Kristoff22", "info"=> "Synch your guild with WoW Armory"), ); ?>

by **IdiotBox** » Sun Apr 01, 2007 6:43 pm

I'm getting

Code: Select all: 1064: 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 'AND ( ISNULL(players.name) OR STR_TO_DATE(players.dateupdatedutc,'%m/%d/%y %H:%i' at line 1 SQL: SELECT members.name FROM `roster_members` members LEFT JOIN `roster_players` players ON members.name = players.name WHERE members.level >= AND ( ISNULL(players.name) OR STR_TO_DATE(players.dateupdatedutc,'%m/%d/%y %H:%i:%s') <= DATE_SUB(NOW(), INTERVAL HOUR) ) ORDER BY members.last_online DESC File: index.php Line: 32

Server Is:

Apache 2.2.4
PHP 5.2.1
MySQL Client / Server 5.0.33 / 5.0.33

by **bsmorgan** » Mon Apr 02, 2007 7:34 am

I'm getting the same error as IdiotBox. Roster 1.7.3 if that makes any difference.

Brad

by **orcade** » Mon Apr 02, 2007 3:13 pm

titus wrote:For French players, you must add :

Code: Select all
curl_setopt ($ch, CURLOPT_HTTPHEADER, array("Content-Type: text/xml; charset=UTF-8","Accept-Language: fr-fr"));

in your getContentCurl() function

for files ? or mysql ?

by **Wyren** » Mon Apr 02, 2007 6:40 pm

IdiotBox wrote:I'm getting

Code: Select all
1064: 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 'AND ( ISNULL(players.name) OR STR_TO_DATE(players.dateupdatedutc,'%m/%d/%y %H:%i' at line 1 SQL: SELECT members.name FROM `roster_members` members LEFT JOIN `roster_players` players ON members.name = players.name WHERE members.level >= AND ( ISNULL(players.name) OR STR_TO_DATE(players.dateupdatedutc,'%m/%d/%y %H:%i:%s') <= DATE_SUB(NOW(), INTERVAL HOUR) ) ORDER BY members.last_online DESC File: index.php Line: 32

Server Is:

Apache 2.2.4
PHP 5.2.1
MySQL Client / Server 5.0.33 / 5.0.33

There must be something wrong with your index.php, as between INTERVAL and HOUR there should be a number (24 unless you've changed the value in config.php). This is how that part of the index.php should be:

Code: Select all: "OR STR_TO_DATE(players.dateupdatedutc,'%m/%d/%y %H:%i:%s') <= DATE_SUB(NOW(), INTERVAL " . $addon_conf['ArmorySync']['SynchCutoffTime'] . " HOUR) ) " .

The

Code: Select all: $addon_conf['ArmorySync']['SynchCutoffTime']

value seems to be missing from your output.

by **bsmorgan** » Mon Apr 02, 2007 10:34 pm

There must be something wrong with your index.php, as between INTERVAL and HOUR there should be a number (24 unless you've changed the value in config.php). This is how that part of the index.php should be:
Code: Select all
"OR STR_TO_DATE(players.dateupdatedutc,'%m/%d/%y %H:%i:%s') <= DATE_SUB(NOW(), INTERVAL " . $addon_conf['ArmorySync']['SynchCutoffTime'] . " HOUR) ) " .

The
Code: Select all
$addon_conf['ArmorySync']['SynchCutoffTime']
value seems to be missing from your output.

In my case (and I suspect IdiotBox as well), there's nothing wrong with index.php or config.php. For some reason, the $addon_conf variables are being interpreted as null (note that the level value is missing as well). They are, therefore, "missing from our output".

I've stared at the code and I don't see how that is possible, but I'm not a PHP guru by any means. I'd like to find a way to add a debugger to my configuration so I can learn more about this problem and PHP in general.

Brad

by **datnewf** » Tue Apr 03, 2007 5:21 am

Code: Select all: 1064: 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 '(players.dateupdatedutc,'%m/%d/%y %H:%i:%s') <= DATE_SUB(NOW(), SQL: SELECT members.name FROM `roster_members` members LEFT JOIN `roster_players` players ON members.name = players.name WHERE members.level >= 10 AND ( ISNULL(players.name) OR STR_TO_DATE(players.dateupdatedutc,'%m/%d/%y %H:%i:%s') <= DATE_SUB(NOW(), INTERVAL 24 HOUR) ) ORDER BY members.last_online DESC File: index.php Line: 32

is the error im getting as well, roster 1.7.3 running smoothly - let me know of any config settings you want or anything else i can do to track it down

the site passes the roster diag test, i can link you a phpinfo if that would help as well.

edit:
i just read through the topic again and noticed this post that i missed the first time.

olgren wrote:
Vexitor wrote:
olgren wrote:
Vexitor wrote:I am getting a SQL error, any ideas?

Code: Select all
1064: 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 '(players.dateupdatedutc,'%m/%d/%y %H:%i:%s')<= DATE_SUB(NOW(), SQL: SELECT members.name FROM `roster_members` members LEFT JOIN `roster_players` players ON members.name = players.name WHERE members.level >= 1 AND ( ISNULL(players.name) OR STR_TO_DATE(players.dateupdatedutc,'%m/%d/%y %H:%i:%s') <= DATE_SUB(NOW(), INTERVAL 24 HOUR) ) ORDER BY members.last_online DESC File: index.php Line: 32

Do you know what version of MySQL you are running on?

I am running the following versions...

MySQL Version 4.0.25
PHP Version 4.3.2
Server Software Apache/2.0.46

Ahhh.. the STR_TO_DATE function wasn't available till MySQL 4.1. There is another option here and that is to do the conversion in php code.

it turns out i have 4.0.23 (i think) installed, i'm on the phone with my host now, if they don't have a newer version is there anything else i can do?

by **Pytte** » Tue Apr 03, 2007 11:02 pm

regarding the mysql error with str_to_date ..

Im to lazy but you need to get players.dateupdatedutc first.. and convert that to proper database date/time ..

someone code it ?

by **PleegWat** » Wed Apr 04, 2007 12:25 am

In roster 1.8 that field has been changed to datetime, so the problem should disappear there (after the addon has been made compatible)

by **Crillo** » Thu Apr 05, 2007 6:46 am

Westa synched: 1 seconds. Total runtime: 14 seconds.
CRITICAL ERROR - no root XML node found: armory.worldofwarcraft.com table
Retried 2times for: item-tooltip.xml?i=3748&r=Blackrock&n=Lilmenace=enUS
CRITICAL ERROR - no root XML node found: armory.worldofwarcraft.com table
Retried 2times for: item-tooltip.xml?i=6097&r=Blackrock&n=Lilmenace=enUS
CRITICAL ERROR - no root XML node found: armory.worldofwarcraft.com page
Retried 2times for: item-tooltip.xml?i=6392&r=Blackrock&n=Lilmenace=enUS
CRITICAL ERROR - no root XML node found: armory.worldofwarcraft.com table
Retried 2times for: item-tooltip.xml?i=2982&r=Blackrock&n=Lilmenace=enUS
CRITICAL ERROR - no root XML node found: armory.worldofwarcraft.com page
Retried 2times for: item-tooltip.xml?i=7355&r=Blackrock&n=Lilmenace=enUS
CRITICAL ERROR - no root XML node found: armory.worldofwarcraft.com page
Retried 2times for: item-tooltip.xml?i=11969&r=Blackrock&n=Lilmenace=enUS
CRITICAL ERROR - no root XML node found: armory.worldofwarcraft.com page
Retried 2times for: item-tooltip.xml?i=14400&r=Blackrock&n=Lilmenace=enUS

Im getting a handfull of that. seems like it can't read the tooltips? or the page isn't loading properly hence half loaded tooltops and whatever.

Other than that its working fine, I have about 10-15 players with most of the stats. :thumleft:

http://intoxicationguild.jumbahost.com/index.php?page=8

by **Weeladdie** » Thu Apr 05, 2007 4:42 pm

Has anyone managed to get this working on the European Armory site yet?

At the moment mine runs for 10 - 15 mins and puts up an Error 500 message and doesn't do any updates.

Kristoff, do you still need a European Server example guild....pm me and I will let you have the details.

by **jungzandvliet** » Thu Apr 05, 2007 6:34 pm

Weeladdie wrote:Has anyone managed to get this working on the European Armory site yet?

At the moment mine runs for 10 - 15 mins and puts up an Error 500 message and doesn't do any updates.

Kristoff, do you still need a European Server example guild....pm me and I will let you have the details.

he said to me he will have a look @ weekend. but didnt spook him :S. Or saw any changes. Have new info + link now though. (Did that yesterday) becouse i got a new guild...

by **Kristoff22** » Fri Apr 06, 2007 3:38 am

Sorry guys, some personal stuff came up last weekend, and I wasn't able to spend the time I wanted on ArmorySync. Getting a Euro guild up and runniing is still at the top of my list.