public function getWarListByStatusAndLimt($status = NULL, $limit = NULL) { $sql = 'SELECT SQL_CALC_FOUND_ROWS w.id as war_id,w.enemy,w.group,w.time,w.maps,w.server,w.password,w.xonx,w.game,w.matchtype,w.report,w.status,g.name as group_name,g.tag as group_tag,g.id as group_id,e.name as enemy_name,e.tag as enemy_tag,e.id as enemy_id FROM `[prefix]_war` as w LEFT JOIN [prefix]_war_groups as g ON w.group = g.id LEFT JOIN [prefix]_war_enemy as e ON w.enemy = e.id WHERE status = "' . $status . '" ORDER by w.id DESC LIMIT ' . $limit; $warArray = $this->db()->queryArray($sql); if (empty($warArray)) { return null; } $entry = array(); foreach ($warArray as $entries) { $entryModel = new WarModel(); $entryModel->setId($entries['war_id']); $entryModel->setWarEnemy($entries['enemy_name']); $entryModel->setWarEnemyTag($entries['enemy_tag']); $entryModel->setWarGroup($entries['group_name']); $entryModel->setWarGroupTag($entries['group_tag']); $entryModel->setWarTime($entries['time']); $entryModel->setWarMaps($entries['maps']); $entryModel->setWarServer($entries['server']); $entryModel->setWarPassword($entries['password']); $entryModel->setWarXonx($entries['xonx']); $entryModel->setWarGame($entries['game']); $entryModel->setWarMatchtype($entries['matchtype']); $entryModel->setWarReport($entries['report']); $entryModel->setWarStatus($entries['status']); $entry[] = $entryModel; } return $entry; }