The amfphp site seems to be down, and I need a copy of amfPHP 1.0…
1/100 times data is being corrupted as it’s sent from amfPHP 1.9, and either my php installation has issues… Or amfPHP has issues. Not sure whats going on.
Heres the php service code if your interested… I confirmed that the Gid is being sent correctly every time. Maybe there is enough packet loss to cause corruption of returned data 1/100 loads? Or maybe my php install is screwed up… Not even the userdata is returned properly for some people sometimes.
function loadFarm($Gid){
$dataArray = array();
$dataArray['userData'] = mysql_fetch_array(mysql_query("SELECT id, sid, name, money, credits, visits, invited FROM users WHERE id=$Gid;"), MYSQL_ASSOC);
$gameData = mysql_fetch_array(mysql_query("SELECT * FROM gameControl WHERE id=1;"), MYSQL_ASSOC);
$gameTime = $gameData['value'];
$tileArray = array();
$Data = mysql_query("SELECT * FROM game_tiles WHERE uid=$Gid;");
while ($Row = mysql_fetch_array($Data, MYSQL_ASSOC)){
$tileArray[$Row['position']] = $Row;
}
$dataArray['tileArray'] = $tileArray;
$objectArray = array();
$Data = mysql_query("SELECT * FROM game_objects WHERE uid=$Gid ORDER BY y_pos ASC;");
while ($Row = mysql_fetch_array($Data, MYSQL_ASSOC)){
array_push($objectArray, $Row);
}
$dataArray['objectArray'] = $objectArray;
return $dataArray;
}