public static function setScore(Dolumar_Underworld_Models_Mission $mission, Dolumar_Underworld_Models_Side $side, $score) { $db = Neuron_DB_Database::getInstance(); $chk = $db->query("\n\t\t\tSELECT\n\t\t\t\tus_id\n\t\t\tFROM\n\t\t\t\tunderworld_score\n\t\t\tWHERE\n\t\t\t\tum_id = {$mission->getId()} AND\n\t\t\t\tus_side = {$side->getId()}\n\t\t"); if (count($chk) === 0) { $db->query("\n\t\t\t\tINSERT INTO\n\t\t\t\t\tunderworld_score\n\t\t\t\tSET\n\t\t\t\t\tum_id = {$mission->getId()},\n\t\t\t\t\tus_side = {$side->getId()},\n\t\t\t\t\tus_score = '{$db->escape($score)}'\n\t\t\t"); } else { $db->query("\n\t\t\t\tUPDATE\n\t\t\t\t\tunderworld_score\n\t\t\t\tSET\n\t\t\t\t\tus_score = '{$db->escape($score)}'\n\t\t\t\tWHERE\n\t\t\t\t\tum_id = {$mission->getId()} AND\n\t\t\t\t\tus_side = {$side->getId()}\n\t\t\t"); } }
public static function addClan(Dolumar_Underworld_Models_Mission $mission, Dolumar_Players_Clan $clan, Dolumar_Underworld_Models_Side $side) { if (!self::hasClan($mission, $clan)) { $db = Neuron_DB_Database::getInstance(); $db->query("\n\t\t\t\tINSERT INTO\n\t\t\t\t\tunderworld_missions_clans\n\t\t\t\tSET\n\t\t\t\t\tum_id = {$mission->getId()},\n\t\t\t\t\tc_id = {$clan->getId()},\n\t\t\t\t\tumc_side = {$side->getId()}\n\t\t\t"); } }
public function isSide(Dolumar_Underworld_Models_Side $side) { if ($side->getId() == $this->group->getId()) { return true; } return false; }
public static function getFromArmy(Dolumar_Underworld_Models_Mission $mission, Dolumar_Underworld_Models_Side $side, Dolumar_Underworld_Models_Army $army) { $db = Neuron_DB_Database::getInstance(); $data = $db->query("\n\t\t\tSELECT\n\t\t\t\tuat_id,\n\t\t\t\tuat_attacker,\n\t\t\t\tuat_defender,\n\t\t\t\tUNIX_TIMESTAMP(uat_startdate) AS startdate,\n\t\t\t\tUNIX_TIMESTAMP(uat_enddate) AS enddate,\n\t\t\t\tuat_fightlog,\n\t\t\t\tuat_from_x,\n\t\t\t\tuat_from_y,\n\t\t\t\tuat_to_x,\n\t\t\t\tuat_to_y,\n\t\t\t\tuat_attacker_side,\n\t\t\t\tuat_defender_side\n\t\t\tFROM \n\t\t\t\tunderworld_log_battles\n\t\t\tWHERE\n\t\t\t\tum_id = {$mission->getId()} AND\n\t\t\t\t(\n\t\t\t\t\tuat_attacker = {$side->getId()} OR\n\t\t\t\t\tuat_defender = {$side->getId()}\n\t\t\t\t) AND\n\t\t\t\t(\n\t\t\t\t\tuat_attacker_side = {$side->getId()} OR\n\t\t\t\t\tuat_defender_side = {$side->getId()}\n\t\t\t\t)\n\t\t\tORDER BY\n\t\t\t\tuat_startdate DESC\n\t\t"); return self::getModelsFromReader($data); }
public static function win(Dolumar_Underworld_Models_Mission $mission, Dolumar_Underworld_Models_Side $side) { $db = Neuron_DB_Database::getInstance(); $missionId = self::getMissionId($mission); $sql = "\n\t\t\tINSERT INTO\n\t\t\t\tunderworld_log_event\n\t\t\tSET\n\t\t\t\tul_m_id = '{$missionId}',\n\t\t\t\tul_e_action = 'WIN',\n\t\t\t\tul_e_date = NOW(),\n\t\t\t\tul_side = {$side->getId()}\n\t\t"; $db->query($sql); }