if (isset($_GET['from']) && $_GET['from'] != '') {
$where .= "AND `date` >= '{$_GET['from']}' ";
$qpage .= "&from={$_GET['from']}";
}
if (isset($_GET['to']) && $_GET['to'] != '') {
$where .= "AND `date` <= '{$_GET['to']}' ";
$qpage .= "&to={$_GET['to']}";
}
if (isset($_GET['status']) && $_GET['status'] != '') {
$status = Typo::int($_GET['status']);
$where .= "AND `status` LIKE '%%{$status}%%' ";
$qpage .= "&status={$status}";
}
$max = "15";
if (isset($_GET['paging'])) {
$paging = Typo::int($_GET['paging']);
$offset = ($paging - 1) * $max;
} else {
$paging = 1;
$offset = 0;
}
$data['posts'] = Db::result("SELECT * FROM `posts` \n WHERE `type` = 'page' {$where} \n ORDER BY `date` DESC \n LIMIT {$offset},{$max}");
$data['num'] = Db::$num_rows;
Theme::admin('header', $data);
System::inc('pages', $data);
Theme::admin('footer');
$page = array('paging' => $paging, 'table' => 'posts', 'where' => "`type` = 'page'" . $where, 'max' => $max, 'url' => 'index.php?page=pages' . $qpage, 'type' => 'pager');
echo Paging::create($page);
break;
}
/* End of file pages.control.php */
public static function delete($id)
{
$id = Typo::int($id);
try {
$vars1 = array('table' => 'posts', 'where' => array('id' => $id));
$d = Db::delete($vars1);
$vars2 = array('table' => 'posts_param', 'where' => array('post_id' => $id));
$d = Db::delete($vars2);
Hooks::run('post_sqldel_action', $id);
return true;
} catch (Exception $e) {
return $e->getMessage();
}
}
switch ($submit) {
case true:
if (!isset($_POST['token']) || !Token::isExist($_POST['token'])) {
// VALIDATE ALL
$alertred[] = TOKEN_NOT_EXIST;
}
if (!isset($_POST['name']) || $_POST['name'] == '') {
$alertred[] = MENU_NAME_CANNOT_EMPTY;
}
if (!isset($_POST['type']) || $_POST['type'] == '') {
$alertred[] = MENU_TYPE_CANNOT_EMPTY;
}
if (isset($alertred)) {
$data['alertred'] = $alertred;
} else {
$vars = array('parent' => Typo::int($_POST['parent']), 'menuid' => Typo::strip($_POST['id']), 'name' => Typo::cleanX($_POST['name']), 'class' => Typo::cleanX($_POST['class']), 'type' => Typo::strip($_POST['type']), 'value' => Typo::cleanX($_POST[$_POST['type']]));
Menus::insert($vars);
$data['alertgreen'][] = 'Menu Item Added';
Token::remove($_POST['token']);
}
break;
default:
# code...
break;
}
// ADD MENU ITEM END
// CHANGE ORDER START
if (isset($_POST['changeorder'])) {
$submit = true;
} else {
$submit = false;
public static function deactivate($id)
{
$act = Db::query(sprintf("UPDATE `user` SET `status` = '0' WHERE `id` = '%d'", Typo::int($id)));
if ($act) {
return true;
} else {
return false;
}
}
# code...
break;
}
switch (isset($_POST['updatecat'])) {
case true:
# code...
// cleanup first
$cat = Typo::cleanX($_POST['cat']);
if (!isset($_POST['token']) || !Token::isExist($_POST['token'])) {
// VALIDATE ALL
$alertred[] = TOKEN_NOT_EXIST;
}
if (isset($alertred)) {
$data['alertred'] = $alertred;
} else {
$vars = array('table' => 'cat', 'id' => Typo::int($_POST['id']), 'key' => array('name' => $cat));
$cat = Db::update($vars);
$data['alertgreen'][] = MSG_CATEGORY_UPDATED . " " . $_POST['cat'];
}
if (isset($_POST['token'])) {
Token::remove($_POST['token']);
}
break;
default:
# code...
break;
}
if (isset($_GET['act']) == 'del') {
if (!isset($_GET['token']) || !Token::isExist($_GET['token'])) {
// VALIDATE ALL
$alertred[] = TOKEN_NOT_EXIST;
public static function updateMenuOrder($vars)
{
foreach ($vars as $k => $v) {
# code...
// print_r($v);
$sql = array('table' => 'menus', 'id' => Typo::int($k), 'key' => $v);
Db::update($sql);
}
}
