Introducing ArmorySync

Sync Blizzards' Armory data with WoWRoster (addon depreciated no longer works see ApiSync)

Moderators: Ulminia, poetter

Introducing ArmorySync

Postby Aross » Tue Jun 19, 2007 2:13 am

I didnt get and red flags when i loooked... all normal crap that is see all the time:(

http://guild-nightfall.com/roster/

That is the link to it ... and i am still working on it a lil event calender and such but i kinda gave up on the supied armory until i can find out what is going on:( wanted to get it working b4 the guild started actually listening to me and dling the installer(uniuploader)

But i would appreciate anything at all to get this going:)
Aross
WR.net Apprentice
WR.net Apprentice
 
Posts: 10
Joined: Sat Jun 16, 2007 2:14 am

Re: Introducing ArmorySync

Postby Danta » Thu Jun 21, 2007 12:33 pm

Here is the error that I receive when I try to update the roster. It is the same when I do it for the entire guild, but with all of the guild member names instead of just this one.

I changed the php.ini to increase my load time, but I only get the white page with no update and no mysql error.

Any help would be appreciated. www.silvermoonodyssey.com/roster

2013: Lost connection to MySQL server during query
SQL:
SELECT * FROM `roster_guild` WHERE `guild_name` = 'Odyssey' AND `server` = 'Silvermoon'
File: wowdb.php
Function: get_guild_info
Line: 1840
Backtrace (most recent call last):

* File: /home/content/w/o/w/wowodyssey/html/roster/lib/commonfunctions.lib.php
o line 248
o function called: backtrace
* File: /home/content/w/o/w/wowodyssey/html/roster/lib/wowdb.php
o line 1840
o function called: die_quietly
o args: 2013: Lost connection to MySQL server during query, WowDB Error, wowdb.php
Function: get_guild_info, 1840, SELECT * FROM `roster_guild` WHERE `guild_name` = 'Odyssey' AND `server` = 'Silvermoon'
* File: /home/content/w/o/w/wowodyssey/html/roster/addons/ArmorySynch/functions.synch.php
o line 67
o function called: get_guild_info
o args: Silvermoon, Odyssey
* File: /home/content/w/o/w/wowodyssey/html/roster/addons/ArmorySynch/index.php
o line 12
o function called: synchplayer
o args: , Syrenity
* File: /home/content/w/o/w/wowodyssey/html/roster/addon.php
o line 77
o function called: include_once
o args: /home/content/w/o/w/wowodyssey/html/roster/addons/ArmorySynch/index.php
Danta
WR.net Apprentice
WR.net Apprentice
 
Posts: 2
Joined: Wed Jun 20, 2007 2:49 pm

Introducing ArmorySync

Postby gamergirl484 » Sat Jun 23, 2007 6:59 am

Okay, I recently installed ArmorySynch and when I typed in my password I got this error:

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: 37
gamergirl484
WR.net Apprentice
WR.net Apprentice
 
Posts: 2
Joined: Sun Jun 03, 2007 1:31 pm

Re: Introducing ArmorySync

Postby xpaladinx45 » Sat Jun 30, 2007 9:22 pm

i've been working on setting this up on my website and have been adjusting things as needed, including updating the php.ini.

I managed to get a few members to update, and then it jumps to a "BAD GATEWAY: Web server received an invalid response while acting as a gateway or proxy server" message.

After at one point getting those few members updated, it no longer updates anyone any further. Any Ideas?

http://www.warcraft-legacy.com/index.ph ... oWRosterDF
xpaladinx45
WR.net Apprentice
WR.net Apprentice
 
Posts: 1
Joined: Sat Jun 30, 2007 2:08 am

Re: Introducing ArmorySync

Postby wwickens » Sun Jul 15, 2007 12:14 am

Hi Guys I'm getting the following error when I sync

Cannot update Character Data
1264: Out of range value adjusted for column 'stat_def' at row 1

any Ideas


PHP 5.1.4
MySQL 5.0.22
IIS 6.0
User avatar
wwickens
WR.net Apprentice
WR.net Apprentice
 
Posts: 25
Joined: Wed Jul 05, 2006 6:57 am
Location: Melbourne

Introducing ArmorySync

Postby foxpur » Sun Jul 15, 2007 6:27 pm

Getting a few:

Code: Select all
CRITICAL ERROR - no root XML node found: armory.wow-europe.com page
Retried 2times for: item-tooltip.xml?i=17759&r=Aggramar&n=Hiphiphooray
Hiphiphooray synched: 26 seconds. Total runtime: 177 seconds.
Mamontii synched: 7 seconds. Total runtime: 184 seconds.
CRITICAL ERROR - no root XML node found: armory.wow-europe.com page
Retried 2times for: item-tooltip.xml?i=24962&r=Aggramar&n=Ozboz


during the update process, but works fine overall.
User avatar
foxpur
WR.net Apprentice
WR.net Apprentice
 
Posts: 49
Joined: Wed Jul 26, 2006 8:18 pm

Re: Introducing ArmorySync

Postby prommetheus » Wed Jul 18, 2007 3:00 am

I seen to have the same error. But I dont see an solution? What can it be?

Check http://www.asmodayguild.com/roster/

Danta wrote:SELECT * FROM `roster_guild` WHERE `guild_name` = 'Asmoday' AND `server` = 'Doomhammer'
File: wowdb.php
Function: get_guild_info
Line: 1840
Backtrace (most recent call last):

* File: /home/content/V/i/n/Vincent75/html/sites/asmodayguild_com/www/roster/lib/commonfunctions.lib.php
o line 248
o function called: backtrace
* File: /home/content/V/i/n/Vincent75/html/sites/asmodayguild_com/www/roster/lib/wowdb.php
o line 1840
o function called: die_quietly
o args: 2013: Lost connection to MySQL server during query, WowDB Error, wowdb.php
Function: get_guild_info, 1840, SELECT * FROM `roster_guild` WHERE `guild_name` = 'Asmoday' AND `server` = 'Doomhammer'
* File: /home/content/V/i/n/Vincent75/html/sites/asmodayguild_com/www/roster/addons/ArmorySynch/functions.synch.php
o line 67
o function called: get_guild_info
o args: Doomhammer, Asmoday
* File: /home/content/V/i/n/Vincent75/html/sites/asmodayguild_com/www/roster/addons/ArmorySynch/functions.synch.php
o line 98
o function called: synchplayer
o args: , Shamoll,
* File: /home/content/V/i/n/Vincent75/html/sites/asmodayguild_com/www/roster/addons/ArmorySynch/index.php
o line 53
o function called: synchplayers
o args: , Syrenity
* File: /home/content/V/i/n/Vincent75/html/sites/asmodayguild_com/www/roster/addon.php
o line 77
o function called: include_once
o args: /home/content/V/i/n/Vincent75/html/sites/asmodayguild_com/www/roster/addons/ArmorySynch/index.php
prommetheus
WR.net Apprentice
WR.net Apprentice
 
Posts: 4
Joined: Tue Jul 17, 2007 5:41 pm

Introducing ArmorySync

Postby littleaton » Wed Jul 18, 2007 5:52 am

Anyone able to get this to run as a cron job yet? or to at least run on a schedial?
User avatar
littleaton
WR.net Apprentice
WR.net Apprentice
 
Posts: 21
Joined: Tue Jul 17, 2007 10:17 pm

Re: Introducing ArmorySync

Postby Hurt » Thu Jul 19, 2007 7:19 pm

gamergirl484 wrote:Okay, I recently installed ArmorySynch and when I typed in my password I got this error:

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: 37


i get the same error
we have an old mysql version on our servers

there was a workaround for WitchHunt to avoid this problem but i don't know how to do it for ArmorySync

here is the workaroud for WitchHunt
can anyone do this for ArmorySync???

Guntak wrote:For those of you stuck on 4.0.x (like I am) try this...

Change
Code: Select all
SELECT STR_TO_DATE(p.dateupdatedutc, '%m/%d/%Y %H:%i:%s') as MyDate


To
Code: Select all
SELECT p.dateupdatedutc as MyDate


...

Then Change
Code: Select all
$dat2 = explode('-',$dat1[0]);
$newDate= $dat2[2].'/'.$dat2[1].'/'.$dat2[0].' '.$dat1[1];


To
Code: Select all
$dat2 = explode('/',$dat1[0]);
$dat3 = date("m/d/Y", mktime(0,0,0,$dat2[0],$dat2[1],$dat2[2]));
$newDate= $dat3.' '.$dat1[1];
Hurt
WR.net Apprentice
WR.net Apprentice
 
Posts: 1
Joined: Sun Jul 01, 2007 1:05 am

Re: Introducing ArmorySync

Postby Elerinna » Fri Jul 20, 2007 5:04 pm

Hy,

I have always a blank page and no sync .... I make my sync with IE and Firefox but isn't change....

I can't change my timeout in php.ini ... a don't find where is the file ....

Can you help me please :D

Sorry for my english :(
Elerinna
WR.net Apprentice
WR.net Apprentice
 
Posts: 9
Joined: Sun Jan 14, 2007 12:55 pm

Introducing ArmorySync

Postby Kristoff22 » Tue Jul 24, 2007 8:26 pm

This thread is now closed. Please do NOT use this thread for anything other than archival purposes.
Kristoff22
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 103
Joined: Mon Nov 13, 2006 5:54 am

Previous

Return to ArmorySync - Depreciated

Who is online

Users browsing this forum: No registered users and 0 guests

cron