/**
* Gets the guestbook entries.
*
* @param array $where
* @param \Ilch\Pagination|null $pagination
* @return GuestbookModel[]|array
*/
public function getEntries($where = array(), $pagination = null)
{
$select = $this->db()->select('*')->from('gbook')->where($where)->order(array('id' => 'DESC'));
if ($pagination !== null) {
$select->limit($pagination->getLimit())->useFoundRows();
$result = $select->execute();
$pagination->setRows($result->getFoundRows());
} else {
$result = $select->execute();
}
$entryArray = $result->fetchRows();
$entry = array();
foreach ($entryArray as $entries) {
$entryModel = new GuestbookModel();
$entryModel->setId($entries['id']);
$entryModel->setEmail($entries['email']);
$entryModel->setText($entries['text']);
$entryModel->setDatetime($entries['datetime']);
$entryModel->setHomepage($entries['homepage']);
$entryModel->setName($entries['name']);
$entryModel->setFree($entries['setfree']);
$entry[] = $entryModel;
}
return $entry;
}
/**
* Gets the Next Wars.
*
* @param array $where
* @param \Ilch\Pagination|null $pagination
* @return WarModel[]|array
*/
public function getNextWars($where = array(), $pagination = null)
{
$select = $this->db()->select('*')->from('war')->where($where)->order(array('id' => 'DESC'));
if ($pagination !== null) {
$select->limit($pagination->getLimit())->useFoundRows();
$result = $select->execute();
$pagination->setRows($result->getFoundRows());
} else {
$result = $select->execute();
}
$entryArray = $result->fetchRows();
$entry = array();
foreach ($entryArray as $entries) {
$entryModel = new WarModel();
$entryModel->setId($entries['id']);
$entryModel->setWarEnemy($entries['enemy']);
$entryModel->setWarGroup($entries['group']);
$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;
}
/**
* Gets the Enemy List
*
* @param \Ilch\Pagination|null $pagination
* @return EnemyModel[]|array
*/
public function getEnemyList($pagination = null)
{
$sql = 'SELECT SQL_CALC_FOUND_ROWS e.id, e.name, e.tag, e.image, e.homepage, e.contact_name, e.contact_email, m.url, m.url_thumb
FROM `[prefix]_war_enemy` as e
LEFT JOIN [prefix]_media m ON e.image = m.url
ORDER by e.id DESC
LIMIT ' . implode(',', $pagination->getLimit());
$enemyArray = $this->db()->queryArray($sql);
$pagination->setRows($this->db()->querycell('SELECT FOUND_ROWS()'));
if (empty($enemyArray)) {
return null;
}
$entry = array();
foreach ($enemyArray as $entries) {
$entryModel = new EnemyModel();
$entryModel->setId($entries['id']);
$entryModel->setEnemyName($entries['name']);
$entryModel->setEnemyTag($entries['tag']);
$entryModel->setEnemyImage($entries['url_thumb']);
$entryModel->setEnemyHomepage($entries['homepage']);
$entryModel->setEnemyContactName($entries['contact_name']);
$entryModel->setEnemyContactEmail($entries['contact_email']);
$entry[] = $entryModel;
}
return $entry;
}
/**
* Gets the Media Lists by ending.
*
* @param string $ending
* @param \Ilch\Pagination|null $pagination
* @return MediaModel[]|array
*/
public function getMediaListByEnding($userId, $ending = NULL, $pagination = NULL)
{
$sql = 'SELECT SQL_CALC_FOUND_ROWS *
FROM `[prefix]_users_media`
WHERE user_id = ' . $userId . ' AND ending IN ("' . implode(',', array(str_replace(' ', '","', $ending))) . '")
ORDER by id DESC
LIMIT ' . implode(',', $pagination->getLimit());
$mediaArray = $this->db()->queryArray($sql);
$pagination->setRows($this->db()->querycell('SELECT FOUND_ROWS()'));
if (empty($mediaArray)) {
return null;
}
$media = array();
foreach ($mediaArray as $medias) {
$entryModel = new MediaModel();
$entryModel->setId($medias['id']);
$entryModel->setUrl($medias['url']);
$entryModel->setUrlThumb($medias['url_thumb']);
$entryModel->setName($medias['name']);
$entryModel->setDatetime($medias['datetime']);
$entryModel->setEnding($medias['ending']);
$media[] = $entryModel;
}
return $media;
}
/**
* Gets the Group List
*
* @param \Ilch\Pagination|null $pagination
* @return GroupModel[]|array
*/
public function getGroupList($pagination = null)
{
$sql = 'SELECT SQL_CALC_FOUND_ROWS g.id, g.name, g.tag, g.image, g.member, m.url, m.url_thumb
FROM `[prefix]_war_groups` as g
LEFT JOIN [prefix]_media m ON g.image = m.url
ORDER by g.id DESC
LIMIT ' . implode(',', $pagination->getLimit());
$groupArray = $this->db()->queryArray($sql);
$pagination->setRows($this->db()->querycell('SELECT FOUND_ROWS()'));
if (empty($groupArray)) {
return null;
}
$entry = array();
foreach ($groupArray as $entries) {
$entryModel = new GroupModel();
$entryModel->setId($entries['id']);
$entryModel->setGroupName($entries['name']);
$entryModel->setGroupTag($entries['tag']);
$entryModel->setGroupImage($entries['url_thumb']);
$entryModel->setGroupMember($entries['member']);
$entry[] = $entryModel;
}
return $entry;
}
/**
* Gets the Media Lists by ending.
*
* @param string $ending
* @param \Ilch\Pagination|null $pagination
* @return MediaModel[]|array
*/
public function getMediaListByEnding($ending = NULL, $pagination = NULL)
{
$sql = 'SELECT SQL_CALC_FOUND_ROWS m.id,m.url,m.url_thumb,m.name,m.datetime,m.ending,m.cat,c.cat_name
FROM `[prefix]_media` as m
LEFT JOIN [prefix]_media_cats as c ON m.cat = c.id
WHERE m.ending IN ("' . implode(',', array(str_replace(' ', '","', $ending))) . '")
ORDER by m.id DESC
LIMIT ' . implode(',', $pagination->getLimit());
$mediaArray = $this->db()->queryArray($sql);
$pagination->setRows($this->db()->querycell('SELECT FOUND_ROWS()'));
if (empty($mediaArray)) {
return null;
}
$media = array();
foreach ($mediaArray as $medias) {
$entryModel = new MediaModel();
$entryModel->setId($medias['id']);
$entryModel->setUrl($medias['url']);
$entryModel->setUrlThumb($medias['url_thumb']);
$entryModel->setName($medias['name']);
$entryModel->setDatetime($medias['datetime']);
$entryModel->setEnding($medias['ending']);
$entryModel->setCatName($medias['cat_name']);
$entryModel->setCatId($medias['cat']);
$media[] = $entryModel;
}
return $media;
}
