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.

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.

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.

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.

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.

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!

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

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

Thanks, I'll have a look at this

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

Zip is attached to the first post in this thread.

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

I just tried to do a parse and it always timeout .. I cut the minimum lvl to 60 and still timeout

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

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

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