und ich hab da nen fehler gefunden
viel spass beim lesen ...
Error in Query [SELECT town.town_id AS town_id, town.name AS town_name, town.points AS town_points, town.island_x AS town_x, town.island_y AS town_y, player.player_id AS player_id, player.name AS player_name, player.inactivitytime AS player_inactivity, ally.alliance_id AS ally_id, ally.name AS ally_name , (pow(CAST(town.island_x AS SIGNED)-?,2)+pow(CAST(town.island_y AS SIGNED)-?,2)) AS distance FROM (tonda_polissuche_towns AS town LEFT JOIN tonda_polissuche_players AS player ON (town.world_id=player.world_id)AND(town.player_id=player.player_id)) LEFT JOIN tonda_polissuche_allys AS ally ON (player.world_id = ally.world_id) AND (player.alliance_id=ally.alliance_id) WHERE (town.world_id = ?)AND((ally.name LIKE ?)) ORDER BY distance ASC LIMIT 0, 30]
Message [3]: Error writing file '/tmp/MY88IvEm' (Errcode: 28)
Location:
Database->drawError(string(756; "Error in Query [SELECT town.town_id AS town_id, town.name AS town_name, town.points AS town_points, town.island_x AS town_x, town.island_y AS town_y, player.player_id AS player_id, player.name AS player_name, player.inactivitytime AS player_inactivity, ally.alliance_id AS ally_id, ally.name AS ally_name , (pow(CAST(town.island_x AS SIGNED)-?,2)+pow(CAST(town.island_y AS SIGNED)-?,2)) AS distance FROM (tonda_polissuche_towns AS town LEFT JOIN tonda_polissuche_players AS player ON (town.world_id=player.world_id)AND(town.player_id=player.player_id)) LEFT JOIN tonda_polissuche_allys AS ally ON (player.world_id = ally.world_id) AND (player.alliance_id=ally.alliance_id) WHERE (town.world_id = ?)AND((ally.name LIKE ?)) ORDER BY distance ASC LIMIT 0, 30]")) at /var/www/clients/client7/web6/web/faarksPhpLib/php_database.php, line 330
Database->query(string(739; "SELECT town.town_id AS town_id, town.name AS town_name, town.points AS town_points, town.island_x AS town_x, town.island_y AS town_y, player.player_id AS player_id, player.name AS player_name, player.inactivitytime AS player_inactivity, ally.alliance_id AS ally_id, ally.name AS ally_name , (pow(CAST(town.island_x AS SIGNED)-?,2)+pow(CAST(town.island_y AS SIGNED)-?,2)) AS distance FROM (tonda_polissuche_towns AS town LEFT JOIN tonda_polissuche_players AS player ON (town.world_id=player.world_id)AND(town.player_id=player.player_id)) LEFT JOIN tonda_polissuche_allys AS ally ON (player.world_id = ally.world_id) AND (player.alliance_id=ally.alliance_id) WHERE (town.world_id = ?)AND((ally.name LIKE ?)) ORDER BY distance ASC LIMIT 0, 30"), array(4), string(4; "iiss")) at /var/www/clients/client7/web6/web/tondasPolisSuche/code/lib_data_source_description.php, line 60
direct_query(string(382; "SELECT town.town_id AS town_id, town.name AS town_name, town.points AS town_points, town.island_x AS town_x, town.island_y AS town_y, player.player_id AS player_id, player.name AS player_name, player.inactivitytime AS player_inactivity, ally.alliance_id AS ally_id, ally.name AS ally_name , (pow(CAST(town.island_x AS SIGNED)-?,2)+pow(CAST(town.island_y AS SIGNED)-?,2)) AS distance"), string(4; "join"), array(3), string(33; "ORDER BY distance ASC LIMIT 0, 30")) at /var/www/clients/client7/web6/web/tondasPolisSuche/code/page_worldpage.php, line 405
require_once(string(74; "/var/www/clients/client7/web6/web/tondasPolisSuche/code/page_worldpage.php")) at /var/www/clients/client7/web6/web/tondasPolisSuche/townSearch.php, line 83