function update_setting($id, $value) { \SKS\LIB\Session::isSuperAdmin(); $db = new DB(); $sql = "UPDATE setting SET value = \"" . $value . "\" WHERE id = {$id} "; $db->executeUpdateQuery($sql); $this->view->message = "Record updated."; $this->view->render("message/message", false); }
function pagination($url = null) { $sql = "SELECT p.id AS id, p.title AS title, c.type AS type , c.name AS category_name, NULL AS comments, \n p.posted_at AS posted_at, p.publish AS publish, u.first_name AS posted_by,\n img.thumb_small as thumb_small, img.original as original \n FROM post p \n LEFT JOIN post_category c ON p.post_category_id = c.id\n LEFT JOIN user u ON p.user_id = u.id\n LEFT JOIN image img ON img.id = p.banner_image"; if (!\SKS\LIB\Session::isSuperAdmin()) { $sql .= " WHERE u.id = " . \SKS\LIB\Session::getLoggedInUser()->getId(); } $table_page = PATH_ADMIN_VIEWS . "publish/paginator/row.php"; $paginator = new \Paginator(); $paginator->execute($sql, $table_page, $url); }
</div> </div> <a href="<?php echo URL . 'publish/managePost'; ?> "> <div class="panel-footer pb"> <span class="pull-left">View Details</span> <span class="pull-right"><i class="fa fa-arrow-circle-right"></i></span> <div class="clearfix"></div> </div> </a> </div> </div> <?php if (\SKS\LIB\Session::isSuperAdmin()) { ?> <div class="col-lg-3 col-md-6"> <div class="panel panel-yellow"> <div class="panel-heading"> <div class="row"> <div class="col-xs-3"> <i class="fa fa-users fa-5x"></i> </div> <div class="col-xs-9 text-right"> <div class="huge"><?php echo $this->user_count; ?> </div> <div>Users !</div> </div>