Introducing ArmorySync

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

Moderators: Ulminia, poetter

Re: Introducing ArmorySync

Postby Kristoff22 » Sat Apr 28, 2007 1:27 am

berrant,

That looks ok, but sometimes the script takes so long it times out on the server. Can you double check to make sure that none of the profiles have been updated? It may just be that you have to run the script a few times for it to complete for all players.
Kristoff22
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 103
Joined: Mon Nov 13, 2006 5:54 am

Introducing ArmorySync

Postby berrant » Sat Apr 28, 2007 1:54 am

Yup, I've run teh script about 50 times now... And there are several that have updated. But obow its stuck on the same 4 profiles... over & over...

www.nvguild.net (link to roster in top left)

roster password in your PM. Take a look please, ane lemme know.
Last edited by berrant on Sat Apr 28, 2007 2:44 am, edited 1 time in total.
Image
User avatar
berrant
WR.net Apprentice
WR.net Apprentice
 
Posts: 8
Joined: Wed Aug 16, 2006 12:42 am

Re: Introducing ArmorySync

Postby neslepax » Sat Apr 28, 2007 7:08 pm

After updating to the newest version i still get 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(),

Used the fix posted earlier in the thread and it seems to fix things.

System runs Debian Sarge with mysql version 4.0.24-10sarge2 if that is of any consequence.
neslepax
WR.net Apprentice
WR.net Apprentice
 
Posts: 4
Joined: Wed Jan 17, 2007 10:23 am

Re: Introducing ArmorySync

Postby SirDester » Sun Apr 29, 2007 10:15 pm

Kristoff22 wrote: I'm having major problems getting this to work correctly with UseCurl set to false, which uses the getContentFileSocket function. If anyone has gotten this to work correctly, please let me know (assuming you have modified the function). If not, I'm going to hold off on fixing that code until I find someone is actually using it - so if you are please let me know.


Hi Kristoff22, I discovered part of the problem... but I'm still having some.

First of all, the page that arrives from wow armory is encoded in "chunked" format. You can see it in the Transfer-Encoding field of the http response.
So, I did a simple function that decode the body from the chunked format to a normal one.

Code: Select all
function SplitHeaderBody($response) {
    $crlf = "\r\n";
    $page = array();

    $pos = strpos($response, $crlf . $crlf);
    if($pos === false) {
      $page["Header"]="";
      $body["Body"]="";
   }
   else {
      $page["Header"] = substr($response, 0, $pos);
       $page["Body"] = substr($response, $pos + 2 * strlen($crlf));
   }
   
   return $page;
}

function DecodeChunked($body) {
    $crlf = "\r\n";

    // $chunks[0] = chunk length (hex string, ends with $crlf)
    // $chunks[1] = chunk data
    $chunks = explode($crlf, $body, 2);
    $chunk_len = hexdec($chunks[0]);

    while($chunk_len!=0){
       $decodedPage .= substr($chunks[1],0,$chunk_len);

   $chunks = explode($crlf, $chunks[1], 2);
   $chunk_len = hexdec($chunks[0]);
    }
    return $decodedPage;
}

// calls to the functions
$page = SplitHeaderBody($content);
$decodedPage = DecodeChunked($page["Body"]);


In that way you'll have the same xml page you'll get with the curl libraries... and you can elaborate it.

Now the problem... the SLOWNESS of the socket functions comparted to the curl ones. The script always goes in timeout after 90 seconds, because it takes too much time to retrieve the pages.

I'm still trying to unterstand why... if someone has some hints... please tell me.
Last edited by SirDester on Sun Apr 29, 2007 10:40 pm, edited 2 times in total.
SirDester
WR.net Apprentice
WR.net Apprentice
 
Posts: 1
Joined: Thu Feb 08, 2007 4:11 am

Re: Introducing ArmorySync

Postby Loly19 » Thu May 03, 2007 2:58 pm

I am getting the following

CRITICAL ERROR: Incomplete Data for Guild.
Total Players to Update: 88
Noxtenebrae
Non-Critical Error: Incomplete Data for Noxtenebrae. Player has probably not updated in awhile.
Abraham

Fatal error: Maximum execution time of 30 seconds exceeded in D:\WebSites\equestrianlifestyles.com\2.0\roster\addons\ArmorySynch\functions.general.php on line 78

And no profiles are being updated. I have a fresh install of wow roster, so its just my char with a profile, tried to run it a number of times.
Loly19
WR.net Apprentice
WR.net Apprentice
 
Posts: 1
Joined: Tue Jul 18, 2006 9:56 pm

Re: Introducing ArmorySync

Postby Edonis » Thu May 03, 2007 7:47 pm

Just one thing.
When you use another language than english, you could have some problems with the update date.

The function strtotime works well only for date in english format.
So, in the file functions.general.php, in the function called convertDate, the date is badly converted (the result of the function is "01-01-1970 00:00:00").

For french people, for example, I have corrected this problem like that:
In the file functions.general.php, before the line:
Code: Select all
return date("Y-m-d 00:00:00", strtotime($armoryDate));

I have translated the month from french to english:
Code: Select all
$localmonth = array("janvier","février","mars","avril","mai","juin","juillet","août","septembre","octobre","novembre","décembre");
$englishmonth = array("January","February","March","April","May","June","July","August","September","October","November","December");
$armoryDate = str_replace($localmonth,$englishmonth,$armoryDate);


Like that, the update date is correct even if use of others languages.

Anyway, the Add-on works very well in french and thank you for this great job!
Edonis
WR.net Apprentice
WR.net Apprentice
 
Posts: 7
Joined: Thu Aug 17, 2006 9:43 pm

Introducing ArmorySync

Postby spy0012 » Mon May 07, 2007 12:32 pm

I am currently using the config setting

Code: Select all
$addon_conf['ArmorySync']['UseCurl'] = false; //Set this to false if you want to use the original FileSocket function.


Set to false as other option does not work as the host doesn't allow it but using filesocket i always get the following

Total Players to Update: 0
Updated 0 players in 0 out of 1000 seconds.
Non-Critical Error: Incomplete Data for Craventine. Player has probably not updated in awhile.

testing on updating just one player to see if it works which it does not, guild is an EU one and config has been updated to reflect that.

any update on what / why that message is being shown even on guild update it shows the same message for all roster members regardless.

Thanks
Last edited by spy0012 on Mon May 07, 2007 12:33 pm, edited 1 time in total.
spy0012
WR.net Apprentice
WR.net Apprentice
 
Posts: 3
Joined: Mon Dec 04, 2006 3:42 am

Re: Introducing ArmorySync

Postby Raichu » Mon May 07, 2007 4:53 pm

Where is the files located? Dont see it in the download section
Raichu
WR.net Apprentice
WR.net Apprentice
 
Posts: 18
Joined: Mon Jan 29, 2007 11:51 pm

Re: Introducing ArmorySync

Postby OxiMoron » Mon May 07, 2007 4:53 pm

Thanks, I'll have a look at this :D
Last edited by OxiMoron on Mon May 07, 2007 4:54 pm, edited 1 time in total.
OxiMoron
WR.net Apprentice
WR.net Apprentice
 
Posts: 1
Joined: Tue Jul 18, 2006 11:32 am

Re: Introducing ArmorySync

Postby bsmorgan » Tue May 08, 2007 12:43 am

Raichu wrote:Where is the files located? Dont see it in the download section


Zip is attached to the first post in this thread.
User avatar
bsmorgan
WoW Interface Developer
WoW Interface Developer
 
Posts: 160
Joined: Tue Nov 28, 2006 10:17 pm
Location: Colorado Springs, Colorado

Introducing ArmorySync

Postby benv666 » Wed May 09, 2007 5:51 pm

Great addon, just synched our roster data. Got a bunch of messages about retries and XML root nodes missing, but it seems like all information is there.
Thanks for the great work :)
benv666
WR.net Apprentice
WR.net Apprentice
 
Posts: 42
Joined: Wed May 09, 2007 5:04 pm
Location: The Netherlands

Introducing ArmorySync

Postby Raichu » Thu May 10, 2007 7:21 pm

I just tried to do a parse and it always timeout .. I cut the minimum lvl to 60 and still timeout
Raichu
WR.net Apprentice
WR.net Apprentice
 
Posts: 18
Joined: Mon Jan 29, 2007 11:51 pm

Re: Introducing ArmorySync

Postby tarius » Fri May 11, 2007 2:53 pm

Code: Select all
SELECT members.name FROM `roster_members` members LEFT JOIN `roster_players` players ON members.name = players.name WHERE members.level >= 60 AND ( ISNULL(players.name) OR STR_TO_DATE(players.dateupdatedutc,'%m/%d/%y %H:%i:%s') <= DATE_SUB(NOW(), INTERVAL 504 HOUR) ) ORDER BY members.last_online DESC
Found 22 players.
GetContentFileSocket: /character-sheet.xml?r=Die+Nachtwache&n=Galladriel, 1, User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de-DE; rv:1.8.1.2) Gecko/20070219 Firefox/2.0.0.2
GET /character-sheet.xml?r=Die+Nachtwache&n=Galladriel HTTP/1.1 Host: armory.wow-europe.com User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de-DE; rv:1.8.1.2) Gecko/20070219 Firefox/2.0.0.2Connection: close Cookie: cookieLangId=de_de;
HTTP/1.1 200 OK Date: Fri, 11 May 2007 06:48:49 GMT Server: Apache Content-Language: de-DE Transfer-Encoding: chunked Content-Type: text/xml;charset=UTF-8 1ff8


This is the Debug information that i get, when i run the ArmotySync. It found 22 Players to update as far as i can see, but none is updated. Any suggestion what to do?

Tarius
tarius
WR.net Apprentice
WR.net Apprentice
 
Posts: 3
Joined: Wed Jul 26, 2006 10:50 am

Introducing ArmorySync

Postby spy0012 » Mon May 14, 2007 9:19 am

Anyone shed some light on why this mod won't update the roster using the EU armory url and get the following error.

CRITICAL ERROR: Incomplete Data for Guild.

trying to fetch EU data from the armory

Thanks
Last edited by spy0012 on Mon May 14, 2007 9:19 am, edited 1 time in total.
spy0012
WR.net Apprentice
WR.net Apprentice
 
Posts: 3
Joined: Mon Dec 04, 2006 3:42 am

Introducing ArmorySync

Postby Rahtak » Mon May 14, 2007 2:22 pm

Item tooltip have extra space between line when imported from Armory. Anyone else seeing this ?

Updated from armory
http://www.shadow-prophecy.com/index.ph ... inebreaker

Updated from CharacterProfiler.lua
http://www.shadow-prophecy.com/index.ph ... inebreaker
Rahtak
WR.net Journeyman
WR.net Journeyman
 
Posts: 78
Joined: Fri Jul 14, 2006 11:54 am

PreviousNext

Return to ArmorySync - Depreciated

Who is online

Users browsing this forum: No registered users and 0 guests

cron