//if this is a friendly transfer
$city->setValue('unit_' . $transaction['unit_id'], $transaction['unit_count'], true);
} else {
//battle
$unit_data = mysql_query("SELECT function FROM units WHERE unit_id=" . $transaction['unit_id'], $db) or die(mysql_error());
$unit_data = mysql_fetch_assoc($unit_data);
unit_functions::$unit_data['function']($transaction, $city, $db);
}
//end if-else user == user
}
//end while transaction
mysql_query("DELETE FROM server_unit_transaction WHERE eta < {$time}") or die(mysql_error());
$transactions = mysql_query("SELECT city_id,building_id FROM server_building_transaction WHERE eta < {$time}") or die(mysql_error());
while ($transaction = mysql_fetch_assoc($transactions)) {
$city = new city($transaction['city_id']);
$city->finish_build($transaction['building_id']);
}
//end while transaction
mysql_query("DELETE FROM server_building_transaction WHERE eta < {$time}") or die(mysql_error());
mysql_query("DELETE FROM messages WHERE time < " . ceil($time - 60 * 3)) or die(mysql_error());
//delete all messages more than 3 minutes old
/* TWITTER */
$xml = get_tweets();
$first = true;
foreach ($xml->xpath('//direct_message') as $message) {
// if($first) file_put_contents('last_twitter', $message->id.'');
$first = false;
$user = mysql_query("SELECT user_id, last_server FROM users WHERE twitter='{$message->sender_screen_name}' LIMIT 1", $db) or die(mysql_error());
$user = mysql_fetch_assoc($user);
if (!$user || !$user['user_id']) {
continue;