function doquery($query, $table, $fetch = false)
{
/*
* Throw notices on doquery() calls.
*/
if (defined(DEPRECATION)) {
$backtrace = debug_backtrace();
$message = "Function doquery() called from file '%s', line %d.";
trigger_error(sprintf($message, $backtrace[0]['file'], $backtrace[0]['line']), $fetch ? E_USER_NOTICE : E_USER_WARNING);
}
/**
* @var Zend_Db_Adapter_Abstract
*/
$instance = Legacies_Database::getInstance();
$sql = str_replace('{{table}}', Legacies_Database::getDeprecatedTable($table), $query);
if ($fetch) {
try {
/**
* @var Zend_Db_Statement_Abstract
*/
$statement = $instance->query($sql);
} catch (Zend_Db_Exception $e) {
trigger_error($e->getMessage() . PHP_EOL . "<br /><pre></code>{$sql}<code></pre><br />" . PHP_EOL, E_USER_WARNING);
}
return $statement->fetch(Zend_Db::FETCH_BOTH);
} else {
if (($statement = mysql_query($sql, $instance->getConnection())) === false) {
trigger_error(mysql_error($instance->getConnection()) . PHP_EOL . "<br /><pre></code>{$sql}<code></pre><br />" . PHP_EOL, E_USER_WARNING);
}
return $statement;
}
}
/**
* @var array List of defense on the target planet.
*/
foreach ($reslist[Legacies_Empire::TYPE_DEFENSE] as $id) {
$targetDef[$id] = $targetPlanet[$resource[$id]];
}
/**
* @see raketenangriff (includes/raketenangriff.php)
*/
$irak = raketenangriff($defenderTech, $attackerTech, $missile['anzahl'], $targetDef, (int) $missile['primaer']);
$message = '';
foreach ($irak['destroyDefense'] as $id => $quantity) {
if ($quantity != 0) {
$message .= $lang['info'][$id]['name'] . " : {$quantity} <br>";
}
}
$stayingDefense = array();
foreach ($irak['stayingDefense'] as $id => $quantity) {
$stayingDefense[$resource[$id]] = $quantity;
}
Legacies_Database::getInstance()->update(Legacies_Database::getTable('deprecated/planets'), $stayingDefense, array('id=?' => $targetPlanet['id']));
$reciepient = array('zielid', 'owner');
foreach ($reciepient as $name) {
$data = array('message_owner' => $missile[$name], 'message_sender' => '', 'message_time' => new Zend_Db_Expr('UNIX_TIMESTAMP()'), 'message_type' => '0', 'message_from' => $lang['Missile_MessageFrom'], 'message_subject' => $lang['Missile_Attack'], 'message_text' => $lang['Missile_AttackMessage'][$name] . $message);
Legacies_Database::getInstance()->insert(Legacies_Database::getTable('deprecated/messages'), $data);
}
Legacies_Database::getInstance()->update(Legacies_Database::getTable('deprecated/users'), array('new_message' => 'new_message + 1'), array('id=?' => $missile['zielid']));
Legacies_Database::getInstance()->update(Legacies_Database::getTable('deprecated/users'), array('new_message' => 'new_message + 1'), array('id=?' => $missile['owner']));
Legacies_Database::getInstance()->delete(Legacies_Database::getTable('deprecated/iraks'), array('id=?' => $missile['id']));
}
}
$RankQry = $db->select()->from(Legacies_Database::getTable('deprecated/statpoints'))->where('stat_type=?', '1')->where('stat_code=?', '1')->order('fleet_points DESC')->query();
$statement = $db->fetchAssoc($sql);
foreach ($statement as $TheRank) {
$db->update(Legacies_Database::getTable('deprecated/statpoints'), array('fleet_rank' => $Rank), array('stat_type =?' => '1', 'stat_code =?' => '1', 'id_owner =?' => $TheRank['id_owner']));
$Rank++;
}
$Rank = 1;
$RankQry = $db->select()->from(Legacies_Database::getTable('deprecated/statpoints'))->where('stat_type=?', '1')->where('stat_code=?', '1')->order('total_points DESC')->query();
$statement = $db->fetchAssoc($sql);
foreach ($statement as $TheRank) {
$db->update(Legacies_Database::getTable('deprecated/statpoints'), array('total_rank' => $Rank), array('stat_type =?' => '1', 'stat_code =?' => '1', 'id_owner =?' => $TheRank['id_owner']));
$Rank++;
}
// Statistiques des alliances ...
$GameAllys = $db->select()->from(Legacies_Database::getTable('deprecated/alliance'))->query();
$statement = Legacies_Database::getInstance()->fetchAssoc($sql);
foreach ($statement as $CurAlly) {
// Recuperation des anciennes statistiques
$OldStatRecord = $db->select()->from(Legacies_Database::getTable('deprecated/statpoints'))->where('stat_type=?', '2')->where('id_owner=?', $CurAlly['id'])->query()->fetch();
if ($OldStatRecord) {
$OldTotalRank = $OldStatRecord['total_rank'];
$OldTechRank = $OldStatRecord['tech_rank'];
$OldBuildRank = $OldStatRecord['build_rank'];
$OldDefsRank = $OldStatRecord['defs_rank'];
$OldFleetRank = $OldStatRecord['fleet_rank'];
// Suppression de l'ancien enregistrement
$db->delete(Legacies_Database::getTable('deprecated/statpoints'), array('stat_code =?' => '2', 'id_owner =?' => $CurAlly['id']));
} else {
$OldTotalRank = 0;
$OldTechRank = 0;
$OldBuildRank = 0;
