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;
}
