Introducing ArmorySync

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

Moderators: Ulminia, poetter

Introducing ArmorySync

Postby titus » Thu Mar 29, 2007 7:18 am

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
titus
WR.net Apprentice
WR.net Apprentice
 
Posts: 1
Joined: Thu Mar 29, 2007 6:01 am

Re: Introducing ArmorySync

Postby olgren » Thu Mar 29, 2007 7:49 am

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.
olgren
WR.net Apprentice
WR.net Apprentice
 
Posts: 5
Joined: Sun Jul 09, 2006 7:03 am

Re: Introducing ArmorySync

Postby Vexitor » Thu Mar 29, 2007 11:05 am

olgren wrote: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.


No idea what that means? Can you provide the code, or should I just push to my server upgraded?

Thanks, at least I know I didn't do something wrong :)
Image
User avatar
Vexitor
WR.net Apprentice
WR.net Apprentice
 
Posts: 5
Joined: Sun Jul 09, 2006 7:59 pm

Re: Introducing ArmorySync

Postby Ulminia » Thu Mar 29, 2007 12:42 pm

heres a new error


Fatal error: Call to undefined function curl_init() in D:\web_page\tfs\addons\ArmorySynch\functions.general.php on line 22


any one have any ideas?

or never mond had to enable the curl dll lyb lol
Last edited by Ulminia on Thu Mar 29, 2007 12:43 pm, edited 1 time in total.
Ulminia of Zangarmarsh
Zonous of Zangarmarsh
Author of Roster Gallery
WoWRoster-Profiler Redesigner
User avatar
Ulminia
WoWRoster.net Dev Team
WoWRoster.net Dev Team
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 1223
Joined: Tue Jul 04, 2006 4:41 pm
Location: New Brunswick, Canada
Realm: Zangarmarsh (PvE) - US
gmail/gtalk: ulminia@gmail.com

Re: Introducing ArmorySync

Postby Wyren » Thu Mar 29, 2007 4:07 pm

Kristoff22 wrote:It seems like there are major problems with Europe's Armory. I'll have to look into it a little more later.

In the meantime, can someone give me a realm/guild I can test from a European server? I just need one please :) Thanks.


Feel free to test with Treehugging Hippies on Runetotem :)
Wyren
WR.net Journeyman
WR.net Journeyman
 
Posts: 81
Joined: Wed Jul 26, 2006 3:07 pm

Re: Introducing ArmorySync

Postby jungzandvliet » Thu Mar 29, 2007 9:26 pm

Wyren wrote:
Kristoff22 wrote:It seems like there are major problems with Europe's Armory. I'll have to look into it a little more later.

In the meantime, can someone give me a realm/guild I can test from a European server? I just need one please :) Thanks.


Feel free to test with Treehugging Hippies on Runetotem :)

Same goes for me :thumright:

PM'd you kristoff with everything you need :)
Last edited by jungzandvliet on Thu Mar 29, 2007 9:31 pm, edited 1 time in total.
jungzandvliet
WR.net Apprentice
WR.net Apprentice
 
Posts: 10
Joined: Sat Aug 05, 2006 8:17 pm

Re: Introducing ArmorySync

Postby fewyn » Thu Mar 29, 2007 11:32 pm

Warning: Call-time pass-by-reference has been deprecated; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. in /home/.jeoffrey/fewyn/<removed>/roster/addons/ArmorySynch/functions.parsing.php on line 144

My current error... any idea?
User avatar
fewyn
WR.net Apprentice
WR.net Apprentice
 
Posts: 25
Joined: Wed Jul 05, 2006 8:38 am

Introducing ArmorySync

Postby Kristoff22 » Fri Mar 30, 2007 2:17 am

Updated code

1. Fixed minor bug with skills. Default to 1 if the max skill is 0.
Kristoff22
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 103
Joined: Mon Nov 13, 2006 5:54 am

Re: Introducing ArmorySync

Postby olgren » Fri Mar 30, 2007 6:08 am

Vexitor wrote:
I am running the following versions...

MySQL Version 4.0.25
PHP Version 4.3.2
Server Software Apache/2.0.46


Yes I would push whoever is hosting your site to upgrade to MySQL 4.1.x or higher as wow roster itself isn't supported on previous versions. I'm actually surprised your not having other problems. I guess Zanix is just that good.
olgren
WR.net Apprentice
WR.net Apprentice
 
Posts: 5
Joined: Sun Jul 09, 2006 7:03 am

Re: Introducing ArmorySync

Postby edse » Fri Mar 30, 2007 8:48 am

When reading all in this toppic, some are talking about the functionality to select the players you want to update.
I cant find out how to do this.
Can anyone give me some explanation on this.

Greetings
edse
WR.net Apprentice
WR.net Apprentice
 
Posts: 4
Joined: Tue Jan 02, 2007 5:00 am

Re: Introducing ArmorySync

Postby Kristoff22 » Fri Mar 30, 2007 4:56 pm

edse wrote:When reading all in this toppic, some are talking about the functionality to select the players you want to update.
I cant find out how to do this.
Can anyone give me some explanation on this.

Greetings


It has not been implmented yet.
Kristoff22
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 103
Joined: Mon Nov 13, 2006 5:54 am

Re: Introducing ArmorySync

Postby Wyren » Fri Mar 30, 2007 4:59 pm

I've now tried just synching a couple of players (and I've checked that atleast one of them has armory data). Still, I get this:
Code: Select all
Non-Critical Error: Incomplete Data for Busterthor. Player has probably not updated in awhile.
Busterthor synched: 1 seconds. Total runtime: 1 seconds.

Warning: fsockopen() [function.fsockopen]: unable to connect to armory.wow-europe.com:80 in /usr/share/www-data/thh/roster/addons/ArmorySynch/functions.general.php on line 37
CRITICAL ERROR - socket not connectedCRITICAL ERROR - no root XML node found: armory.wow-europe.com page
Non-Critical Error: Empty Content for Anu. Player has probably not updated in awhile.
Anu synched: 30 seconds. Total runtime: 31 seconds.
Non-Critical Error: Incomplete Data for Slim. Player has probably not updated in awhile.
Slim synched: 0 seconds. Total runtime: 31 seconds.


This is my index.php:
Code: Select all
<?php

if (!defined('ROSTER_INSTALLED')) {
        exit(
'Detected invalid access to this file!');
}

//Configuration
$addon_conf['ArmorySync']['Host'] = "armory.wow-europe.com"//European players use: armory.wow-europe.com
$addon_conf['ArmorySync']['MinLevel'] = 70//The minimum level to be updated
$addon_conf['ArmorySync']['SynchCutoffTime'] = 504//Time, in hours.  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.

?>


Any ideas? Is it just the European Armory being shite?
Wyren
WR.net Journeyman
WR.net Journeyman
 
Posts: 81
Joined: Wed Jul 26, 2006 3:07 pm

Introducing ArmorySync

Postby titan99 » Fri Mar 30, 2007 5:49 pm

Wyren i have this bug me to
User avatar
titan99
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 129
Joined: Sat Jan 13, 2007 8:11 am
Location: Montpellier - France

Re: Introducing ArmorySync

Postby jungzandvliet » Fri Mar 30, 2007 9:39 pm

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 :)
jungzandvliet
WR.net Apprentice
WR.net Apprentice
 
Posts: 10
Joined: Sat Aug 05, 2006 8:17 pm

Re: Introducing ArmorySync

Postby Edonis » Fri Mar 30, 2007 10:00 pm

Just to say that in French, the import works well but all informations are in... english. :D
I have nothing against the Shakespeare's language but it could be better to could change the language...
A roster with 50% of french and 50% of english, it is really awfull...
Argh....

Please help a little frenchy. :D
Merci pour tout.
Edonis
WR.net Apprentice
WR.net Apprentice
 
Posts: 7
Joined: Thu Aug 17, 2006 9:43 pm

PreviousNext

Return to ArmorySync - Depreciated

Who is online

Users browsing this forum: No registered users and 0 guests

cron