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