rendered paste body /*$select_troops = mysql_query("SELECT * FROM server1_troops WHERE troop_target_stad = ".$A_troop['troop_target_stad']."")or die(mysql_error()); while($troop = mysql_fetch_assoc($select_troops)){ $troop_player = mysql_fetch_assoc(mysql_query("SELECT * FROM server1_generals WHERE general_id = ".$troop['troop_general']."")); if($troop_player['general_team'] != $A_player['general_team']){ $afgelegd = time() - $troop['troop_time']; $speed = troop_speed($troop['troop_id'])/120; echo "Speed: ".$speed; $distance = troop_distance($troop['troop_id']); $seconds = ($distance/$speed)-$afgelegd; $time = time() - $seconds; mysql_query("UPDATE server1_troops SET troop_target_stad = ".$troop['troop_from_stad']." , troop_from_stad = ".$troop['troop_target_stad']." , troop_time = ".$time." WHERE troop_id = ".$troop['troop_id'].""); } }*/