function index() { $this->getView()->addStylesheetURL('assets/stylesheets/sorting.css'); $customer_id = \Yoda\Request::getInt('customer_id'); $destination = \Yoda\Request::getString('destination'); $source = \Yoda\Request::getString('source'); $success = \Yoda\Request::getString('success', ''); $from_date = \Yoda\Request::getString('from_date'); $to_date = \Yoda\Request::getString('to_date'); $order = \Yoda\Request::getString('order', 'destination'); $direction = \Yoda\Request::getString('direction', 'ASC'); $pagination = new Pagination(); $pagination->setLimit(10); $pagination->setPage(\Yoda\Request::getInt('page', 1)); $pagination->setLink('index.php?controller=sms&customer_id=' . $customer_id . '&destination=' . $destination . '&source=' . $source . '&success=' . $success . '&from_date=' . $from_date . '&to_date=' . $to_date); $sms = new Didww\API2\SMSCollection(); $sms->setCustomerId($customer_id); $sms->setDestination($destination); $sms->setSource($source); if ($success !== '') { $sms->setSuccess($success); } $sms->setFromDate($from_date); $sms->setToDate($to_date); $sms->setOrderBy($order); $sms->setOrderDir(strtoupper($direction)); $sms->setLimit($pagination->getLimit()); $sms->setOffset($pagination->getOffset()); $sms_log = $sms->getList(); $total = $sms->getTotal(); $pagination->setTotal($total); $this->getView()->setProperties(['view' => $this->getView(), 'sms_log' => $sms_log, 'customer_id' => $customer_id, 'destination' => $destination, 'source' => $source, 'success' => $success, 'from_date' => $from_date, 'to_date' => $to_date, 'pagination' => $pagination, 'order' => $order, 'direction' => $direction, 'total' => $total])->display(); }
function index() { $this->getView()->addStylesheetURL('assets/stylesheets/sorting.css'); $customer_id = \Yoda\Request::getInt('customer_id'); $did_number = \Yoda\Request::getString('did_number'); $from_date = \Yoda\Request::getString('from_date'); $to_date = \Yoda\Request::getString('to_date'); $order = \Yoda\Request::getString('order', 'duration'); $direction = \Yoda\Request::getString('direction', 'ASC'); $pagination = new Pagination(); $pagination->setLimit(10); $pagination->setPage(\Yoda\Request::getInt('page', 1)); $pagination->setLink('index.php?controller=call_history&did_number=' . $did_number . '&customer_id=' . $customer_id . '&from_date=' . $from_date . '&to_date=' . $to_date); $cdr = new Didww\API2\CDRCollection(); $cdr->setCustomerId($customer_id); $cdr->setDidNumber($did_number); $cdr->setFromDate($from_date); $cdr->setToDate($to_date); $cdr->setOrderBy($order); $cdr->setOrderDir(strtoupper($direction)); $cdr->setLimit($pagination->getLimit()); $cdr->setOffset($pagination->getOffset()); $cdrs = $cdr->getList(); $total = $cdr->getTotal(); $pagination->setTotal($total); $this->getView()->setProperties(['view' => $this->getView(), 'cdrs' => $cdrs, 'customer_id' => $customer_id, 'did_number' => $did_number, 'from_date' => $from_date, 'to_date' => $to_date, 'pagination' => $pagination, 'order' => $order, 'direction' => $direction, 'total' => $total])->display(); }
$rsc = $conn->execute($sql); $total_related = $rsc->fields['total_games']; if ($total_related > 50) { $total_related = 50; } $pagination = new Pagination(10, 'p_related_games_' . $game['GID'] . '_'); $limit = $pagination->getLimit($total_related); $sql = "SELECT GID, title, addtime, rate, total_plays, type FROM game\n WHERE status = '1' AND category = '" . $game['category'] . "' AND GID != " . $gid . "\n AND ( title LIKE '%" . mysql_real_escape_string($game['title']) . "%' " . $sql_add . ")\n ORDER BY addtime DESC LIMIT " . $limit; $rs = $conn->execute($sql); $games = $rs->getrows(); $page_link = $pagination->getPagination('game'); $sql = "SELECT COUNT(CID) AS total_comments FROM game_comments WHERE GID = " . $gid . " AND status = '1'"; $rsc = $conn->execute($sql); $total_comments = $rsc->fields['total_comments']; $pagination = new Pagination(10); $limit = $pagination->getLimit($total_comments); $sql = "SELECT c.CID, c.UID, c.comment, c.addtime, s.username, s.photo, s.gender\n FROM game_comments AS c, signup AS s \n WHERE c.GID = " . $gid . " AND c.status = '1' AND c.UID = s.UID \n ORDER BY c.addtime DESC LIMIT " . $limit; $rs = $conn->execute($sql); $comments = $rs->getrows(); $page_link_c = $pagination->getPagination('game', 'p_game_comments_' . $game['GID'] . '_'); $page_link_cb = $pagination->getPagination('game', 'pp_game_comments_' . $game['GID'] . '_'); $start_num = $pagination->getStartItem(); $end_num = $pagination->getEndItem(); $self_title = $game['title'] . $seo['game_title']; $self_description = $game['title'] . $seo['game_desc']; $self_keywords = implode(', ', $game['tags']) . $seo['game_keywords']; $smarty->assign('errors', $errors); $smarty->assign('messages', $messages); $smarty->assign('menu', 'games'); $smarty->assign('submenu', ''); $smarty->assign('play', true);
<?php require_once "../../klassen/authentication.class.php"; require_once "../../config.php"; require_once "../../klassen/datenbank.class.php"; require_once "../../libs/smarty/Smarty.class.php"; require_once "../../klassen/bewohner.class.php"; require_once "../../klassen/geld.class.php"; require_once "../../klassen/pagination.class.php"; $datenbank = new Datenbank(); $sql = Geld::SQL_SELECT_COUNT; $anzahl = $datenbank->queryDirektSingle($sql)["anzahl"]; $pagination = new Pagination($anzahl); $sql = GELD::SQL_SELECT_ALL_JOIN_BEWOHNER . $pagination->getLimit(); $buchungen = $datenbank->queryArray($sql, array(), new BewohnerGeldFactory()); if (count($buchungen) > 0) { $sql = Geld::SQL_SELECT_KASSENSTAND_BIS; $kassenstand = $datenbank->queryDirektSingle($sql, array("datum" => $buchungen[0]->datum))["kassenstand"]; } else { $kassenstand = 0; } $smarty = new Smarty(); $smarty->assign("flurName", $config["flurName"]); $smarty->assign("rootDir", $config["rootDir"]); $smarty->assign("pagination", $pagination); $smarty->assign("buchungen", $buchungen); $smarty->assign("filename", "/c4/geld/buchungen/index.php"); $smarty->assign("kassenstand", $kassenstand); //$smarty->assign("", $); $smarty->setTemplateDir("../../seiten/templates/geld/buchungen/"); $smarty->display("index.tpl");
if ($conn->Affected_Rows() === 1) { $messages[] = 'Text advertise was successfuly ' . $action . 'ed!'; } else { $errors[] = 'Failed to ' . $action . ' advertise! Are you sure this advertise exists?!'; } $remove = '&a=' . $action . '&AID=' . $AID; break; default: $errors[] = 'Invalid action! Allowed actions: delete, activate and suspend!'; } } $query = constructQuery(); $rs = $conn->execute($query['count']); $total_advs = $rs->fields['total_advs']; $pagination = new Pagination($query['items']); $limit = $pagination->getLimit($total_advs); $paging = $pagination->getAdminPagination($remove); $sql = $query['select'] . " LIMIT " . $limit; $rs = $conn->execute($sql); $advs = $rs->getrows(); function constructQuery() { global $smarty; $query = array(); $query_count = "SELECT COUNT(adv_id) AS total_advs FROM adv_text"; $query_select = "SELECT * FROM adv_text"; $query_add = NULL; $option = array('sort' => 'adv_id', 'order' => 'DESC', 'display' => 20); $option = isset($_SESSION['search_text_advertise']) ? $_SESSION['search_text_advertise'] : $option; if (isset($_POST['search_text'])) { $option['sort'] = trim($_POST['sort']);
$conn->execute($sql); $_SESSION['message'] = 'Duration regenerated successfuly!'; $remove = '&=duration&VID=' . $VID; VRedirect::go('videos.php?m=' . $module_keep . '&page=' . $page); break; } } else { $err = 'Invalid video id. Video does not exist!?'; } } $query = constructQuery($module_keep); $sql = $query['count']; $rs = $conn->execute($sql); $total_videos = $rs->fields['total_videos']; $pagination = new Pagination($query['page_items']); $limit = $pagination->getLimit($total_videos); $paging = $pagination->getAdminPagination($remove); $sql = $query['select'] . " LIMIT " . $limit; $rs = $conn->execute($sql); $videos = $rs->getrows(); function constructQuery($module) { global $smarty; $query_module = ''; if ($module == 'private' or $module == 'public') { $query_module = " AND v.type = '" . $module . "'"; } $query = array(); $query_select = "SELECT v.*,s.username FROM video AS v, signup AS s WHERE v.UID = s.UID" . $query_module; $query_count = "SELECT count(v.VID) AS total_videos FROM video AS v WHERE v.VID != ''" . $query_module; $query_add = $query_module != '' ? " AND" : " WHERE";
<?php require_once "../../klassen/authentication.class.php"; $loginErforderlich = false; require_once "../../config.php"; require_once "../../klassen/datenbank.class.php"; require_once "../../libs/smarty/Smarty.class.php"; require_once "../../klassen/bewohner.class.php"; require_once "../../klassen/pagination.class.php"; $datenbank = new Datenbank(); $sql = Bewohner::SQL_SELECT_COUNT; $res = $datenbank->queryDirektSingle($sql); $anzahl = $res["COUNT(*)"]; $pagination = new Pagination($anzahl); $sql = Bewohner::SQL_SELECT_ALL_JOIN . $pagination->getLimit(); $bewohner = $datenbank->queryArray($sql, array(), new BewohnerFactory()); $smarty = new Smarty(); $smarty->assign("flurName", $config["flurName"]); $smarty->assign("rootDir", $config["rootDir"]); $smarty->setTemplateDir("../../seiten/templates/bewohner/alle"); $smarty->assign("zimmerAnzahl", $config["zimmerAnzahl"]); $smarty->assign("bewohner", $bewohner); $smarty->assign("pagination", $pagination); $smarty->assign("filename", "/flur/bewohner/alle/index.php"); $smarty->display("index.tpl");
break; case 'mv': $sql_add .= " ORDER BY s.profile_viewed DESC"; break; case 'on': $sql_add .= " ORDER BY s.logintime DESC"; break; case 'ma': $sql_add .= " ORDER BY s.video_viewed+s.profile_viewed+s.watched_video DESC"; break; } $sql = "SELECT COUNT(s.UID) AS total_users FROM signup AS s, users_online AS o\n WHERE s.account_status = 'Active' AND s.UID = o.UID" . $sql_add_count; $rsc = $conn->execute($sql); $total_users = $rsc->fields['total_users']; $pagination = new Pagination($config['users_per_page']); $limit = $pagination->getLimit($total_users); $sql = "SELECT s.UID, s.username, s.photo, s.gender FROM signup AS s, users_online AS o\n WHERE s.account_status = 'Active' AND s.UID = o.UID" . $sql_add . " LIMIT " . $limit; $rs = $conn->execute($sql); $users = $rs->getrows(); $page_link = $pagination->getPagination('search'); $start_num = $pagination->getStartItem(); $end_num = $pagination->getEndItem(); $smarty->assign('users', $users); $smarty->assign('users_total', $total_users); $smarty->assign('page_link', $page_link); $smarty->assign('start_num', $start_num); $smarty->assign('end_num', $end_num); $smarty->assign('order', $order); $smarty->assign('gender', $gender); $smarty->assign('interest', $interest); $smarty->assign('avatar', $avatar);
case 'activate': case 'suspend': $status = $action == 'activate' ? 1 : 0; $sql = "UPDATE notice SET status = '" . $status . "' WHERE NID = " . $NID . " LIMIT 1"; $conn->execute($sql); $messages[] = 'Successfully ' . $action . 'ed notice!'; $remove = '&a=' . $action . '&NID=' . $NID; break; } } $query = constructQuery(); $sql = $query['count']; $rsc = $conn->execute($sql); $total_notices = $rsc->fields['total_notices']; $pagination = new Pagination($query['page_items']); $limit = $pagination->getLimit($total_notices); $paging = $pagination->getAdminPagination($remove); $sql = $query['select'] . " LIMIT " . $limit; $rs = $conn->execute($sql); $notices = $rs->getrows(); function constructQuery() { global $smarty; $query = array(); $query_select = "SELECT * FROM notice"; $query_count = "SELECT COUNT(NID) AS total_notices FROM notice"; $query_add = " WHERE"; $query_option = array(); $option_orig = array('username' => '', 'title' => '', 'content' => '', 'sort' => 'UID', 'order' => 'DESC', 'display' => 10); $all = isset($_GET['all']) ? intval($_GET['all']) : 0; if ($all == 1) {
if ($wall_public == '1') { $show_wall = true; } else { if ($is_friend) { $show_wall = true; } elseif (isset($_SESSION['uid']) && $_SESSION['uid'] == $uid) { $show_wall = true; } } if ($show_wall) { require 'classes/pagination.class.php'; $sql = "SELECT COUNT(wall_id) AS total_walls FROM wall WHERE OID = " . $uid . " AND status = '1'"; $rsc = $conn->execute($sql); $walls_total = $rsc->fields['total_walls']; $pagination = new Pagination(10); $limit = $pagination->getLimit($walls_total); $sql = "SELECT w.wall_id, w.UID, w.message, w.addtime, u.username, u.photo, u.gender\n FROM wall AS w, signup AS u WHERE w.OID = " . $uid . " AND w.status = '1' AND w.UID = u.UID \n ORDER BY w.addtime DESC LIMIT 10"; $rs = $conn->execute($sql); $walls = $rs->getrows(); $page_link = $pagination->getPagination('user/' . $username, 'p_wall_comments_' . $uid . '_'); $smarty->assign('page_link', $page_link); } $blog = array(); $sql = "SELECT BID, UID, title, content, total_views, total_comments, addtime\n FROM blog WHERE UID = " . $uid . " AND status = '1'\n ORDER BY addtime DESC LIMIT 1"; $rs = $conn->execute($sql); if ($conn->Affected_Rows() == 1) { $blog = $rs->getrows(); $blog = $blog['0']; } $sql = "UPDATE signup SET profile_viewed = profile_viewed+1, popularity = popularity+0.1 WHERE UID = " . $uid . " LIMIT 1"; $conn->execute($sql);
if ($action == 'activate') { send_album_approve_email($AID); } $messages[] = 'Album was successfully ' . $action . 'ed!'; break; } } else { $errors[] = 'Invalid album identifier. Are you sure this album exists!?'; } } $query = constructQuery($module_keep); $sql = $query['count']; $rs = $conn->execute($sql); $total_albums = $rs->fields['total_albums']; $pagination = new Pagination($query['page_items']); $limit = $pagination->getLimit($total_albums); $paging = $pagination->getAdminPagination($remove); $sql = $query['select'] . " LIMIT " . $limit; $rs = $conn->execute($sql); $albums = $rs->getrows(); function constructQuery($module) { global $smarty; $query_module = ''; if ($module == 'private' or $module == 'public') { $query_module = " AND a.type = '" . $module . "'"; } $query = array(); $query_select = "SELECT a.*, s.username FROM albums AS a, signup AS s WHERE a.UID = s.UID" . $query_module; $query_count = "SELECT count(a.AID) AS total_albums FROM albums AS a WHERE a.AID != ''" . $query_module; $query_add = $query_module != '' ? " AND" : " WHERE";
} if ($table == 'all') { function compare_time($a, $b) { $a_time = intval($a['time']); $b_time = intval($b['time']); if ($a_time === $b_time) { return 0; } return $a_time < $b_time ? 1 : -1; } usort($feeds, 'compare_time'); } if ($subscriptions) { $pagination = new Pagination(40); $limit = $pagination->getLimit($total_feeds); $page_link = $pagination->getPagination('feeds'); } $self_title = $config['site_title']; $self_meta_description = $config['meta_description']; $self_meta_keywords = $config['meta_keywords']; $smarty->assign('subscriptions', $subscriptions); $smarty->assign('username', $username); $smarty->assign('table', $table); $smarty->assign('feeds', $feeds); $smarty->assign('page_link', $page_link); $smarty->assign('self_title', $self_title); $smarty->assign('self_meta_description', $self_meta_description); $smarty->assign('self_meta_keywords', $self_meta_keywords); $smarty->display('header.tpl'); $smarty->display('errors.tpl');
$messages[] = 'Successfully ' . $perform . ' game!'; } else { $errors[] = 'Failed to ' . $action . ' game! Are you sure this game exists?!'; } $remove = '&a=' . $action . '&GID=' . $GID; break; default: $errors[] = 'Invalid action. Allowed actions: delete, activate, suspend and unflag!'; } } $query = constructQuery(); $sql = $query['count']; $rs = $conn->execute($sql); $total_games = $rs->fields['total_games']; $pagination = new Pagination($query['page_items']); $limit = $pagination->getLimit($total_games); $paging = $pagination->getAdminPagination($remove); $sql = $query['select'] . " LIMIT " . $limit; $rs = $conn->execute($sql); $games = $rs->getrows(); function constructQuery() { global $smarty; $query = array(); $query_select = "SELECT g.*, s.username, f.UID AS SUID, f.FID, f.add_date, f.reason, f.message\n FROM game AS g, signup AS s, game_flags AS f\n WHERE g.GID = f.GID AND g.UID = s.UID"; $query_count = "SELECT COUNT(g.GID) AS total_games FROM game AS g, signup AS s, game_flags AS f\n WHERE g.GID = f.GID AND g.UID = s.UID"; $query_option = array(); $option = array('username' => '', 'title' => '', 'flagger' => '', 'sort' => 'g.GID', 'order' => 'DESC', 'display' => 10); if (isset($_POST['search_games'])) { $option['username'] = trim($_POST['username']); $option['title'] = trim($_POST['title']);
<?php require_once "../../klassen/authentication.class.php"; $loginErforderlich = false; require_once "../../config.php"; require_once "../../klassen/datenbank.class.php"; require_once "../../libs/smarty/Smarty.class.php"; require_once "../../klassen/bewohner.class.php"; require_once "../../klassen/belegung.class.php"; require_once "../../klassen/pagination.class.php"; $datenbank = new Datenbank(); $sql = Belegung::SQL_SELECT_COUNT; $res = $datenbank->queryDirektSingle($sql); $anzahl = $res["COUNT(*)"]; $pagination = new Pagination($anzahl); $sql = Belegung::SQL_SELECT_ALLE_JOIN_BEWOHNER_SORTIERT . $pagination->getLimit(); $belegungen = $datenbank->queryArray($sql, array(), new BewohnerBelegungFactory()); $smarty = new Smarty(); $smarty->assign("flurName", $config["flurName"]); $smarty->assign("rootDir", $config["rootDir"]); $smarty->setTemplateDir("../../seiten/templates/belegung/alle"); $smarty->assign("zimmerAnzahl", $config["zimmerAnzahl"]); $smarty->assign("belegungen", $belegungen); $smarty->assign("pagination", $pagination); $smarty->assign("filename", "/flur/belegung/alle/index.php"); $smarty->display("index.tpl");
if ($conn->Affected_Rows() == 1) { $sql = "DELETE FROM spam WHERE type = 'video' AND comment_id = " . $CID; $conn->execute($sql); $messages[] = 'Successfully deleted comment!'; } else { $errors[] = 'Failed to delete comment! Are you sure this comment exists?!'; } break; case 'unspam': $sql = "DELETE FROM spam WHERE type = 'video' AND spam_id = " . $SID; $conn->execute($sql); if ($conn->Affected_Rows() > 0) { $messages[] = 'Successfully unspamed this comment!'; } else { $errors[] = 'Failed to unspam comment! Are you sure this spam flag exists?!'; } break; } } $sql = "SELECT COUNT(spam_id) AS total_spam FROM spam WHERE type = 'video'"; $rs = $conn->execute($sql); $total_spam = $rs->fields['total_spam']; $pagination = new Pagination(20); $limit = $pagination->getLimit($total_spam); $paging = $pagination->getAdminPagination($remove); $sql = "SELECT s.spam_id, s.UID AS RID, s.addtime AS add_time, c.*, u.username\n FROM spam AS s, video_comments AS c, signup AS u\n WHERE s.comment_id = c.CID AND s.parent_id = c.VID AND c.UID = u.UID\n LIMIT " . $limit; $rs = $conn->execute($sql); $comments = $rs->getrows(); $smarty->assign('comments', $comments); $smarty->assign('total_spam', $total_spam); $smarty->assign('paging', $paging);
$sql_add .= " ORDER BY b.addtime DESC"; break; case 'mv': $title_o = ' ' . $lang['global.most_viewed']; $sql_add .= " ORDER BY b.total_views DESC"; break; case 'md': $title_o = ' ' . $lang['global.most_commented']; $sql_add .= " ORDER BY b.total_comments DESC"; break; } $sql = "SELECT COUNT(BID) AS total_blogs FROM blog WHERE status = '1'" . $sql_add_count; $rsc = $conn->execute($sql); $total_blogs = $rsc->fields['total_blogs']; $pagination = new Pagination($config['blogs_per_page']); $limit = $pagination->getLimit($total_blogs); $sql = "SELECT b.BID, b.UID, b.title, b.content, b.total_views, b.total_comments, b.addtime,\n s.username, s.photo\n FROM blog AS b, signup AS s\n WHERE b.status = '1' AND b.UID = s.UID" . $sql_add . " LIMIT " . $limit; $rs = $conn->execute($sql); $blogs = $rs->getrows(); $page_link = $pagination->getPagination('blogs'); $start_num = $pagination->getStartItem(); $end_num = $pagination->getEndItem(); $title = $title_t . $title_o; $self_title = $title . $seo['blogs_title']; $self_description = $title . $seo['blogs_desc']; $self_keywords = $title . $seo['blogs_keywords']; $smarty->assign('errors', $errors); $smarty->assign('messages', $messages); $smarty->assign('menu', 'blogs'); $smarty->assign('blogs', $blogs); $smarty->assign('blogs_total', $total_blogs);
$messages[] = 'Successfully ' . $perform . ' photo!'; } else { $errors[] = 'Failed to ' . $action . ' photo! Are you sure this photo exists?!'; } $remove = '&a=' . $action . '&PID=' . $PID; break; default: $errors[] = 'Invalid action. Allowed actions: delete, activate, suspend and unflag!'; } } $query = constructQuery(); $sql = $query['count']; $rs = $conn->execute($sql); $total_photos = $rs->fields['total_photos']; $pagination = new Pagination($query['page_items']); $limit = $pagination->getLimit($total_photos); $paging = $pagination->getAdminPagination($remove); $sql = $query['select'] . " LIMIT " . $limit; $rs = $conn->execute($sql); $photos = $rs->getrows(); function constructQuery() { global $smarty; $query = array(); $query_select = "SELECT p.*, s.username, f.*\n FROM photos AS p, signup AS s, photo_flags AS f\n WHERE p.PID = f.PID AND f.UID = s.UID"; $query_count = "SELECT COUNT(f.PID) AS total_photos\n FROM photos AS p, signup AS s, photo_flags AS f\n WHERE p.PID = f.PID AND f.UID = s.UID"; $query_option = array(); $option = array('flagger' => '', 'sort' => 'p.PID', 'order' => 'DESC', 'display' => 10); if (isset($_POST['search_flags'])) { $option['flagger'] = trim($_POST['flagger']); $option['sort'] = trim($_POST['sort']);
$action = trim($_GET['a']); $id = isset($_GET['CID']) && is_numeric($_GET['CID']) ? (int) $_GET['CID'] : 0; if ($id) { switch ($action) { case 'delete': $sql = "DELETE FROM notice_images WHERE image_id = " . $id . " LIMIT 1"; $conn->execute($sql); @unlink($config['BASE_DIR'] . '/images/notice_images/' . $id . '.jpg'); @unlink($config['BASE_DIR'] . '/images/notice_images/thumbs/' . $id . '.jpg'); $messages[] = 'Image was successfuly delete!'; break; default: $errors[] = 'Invalid action!'; break; } } else { $errors[] = 'Invalid image id! Are you sure this image exists!?'; } } $sql = "SELECT COUNT(image_id) AS total_images FROM notice_images"; $rs = $conn->execute($sql); $images_total = $rs->fields['total_images']; $pagination = new Pagination(20); $limit = $pagination->getLimit($images_total); $paging = $pagination->getAdminPagination(); $sql = "SELECT * FROM notice_images ORDER BY addtime DESC LIMIT " . $limit; $rs = $conn->execute($sql); $images = $rs->getrows(); $smarty->assign('images', $images); $smarty->assign('images_total', $images_total); $smarty->assign('paging', $paging);
require $config['BASE_DIR'] . '/classes/pagination.class.php'; require $config['BASE_DIR'] . '/include/dbconn.php'; $code = array(); if (isset($_POST['user_id']) && isset($_POST['page'])) { $filter = new VFilter(); $oid = $filter->get('user_id', 'INTEGER'); $page = $filter->get('page', 'INTEGER'); $uid = isset($_SESSION['uid']) ? intval($_SESSION['uid']) : NULL; $sql = "SELECT username FROM signup WHERE UID = " . $oid . " LIMIT 1"; $rs = $conn->execute($sql); $username = $rs->fields['username']; $sql = "SELECT COUNT(wall_id) AS total_walls FROM wall WHERE OID = " . $oid; $rsc = $conn->execute($sql); $total = $rsc->fields['total_walls']; $pagination = new Pagination(10, $page); $limit = $pagination->getLimit($total); $sql = "SELECT w.wall_id, w.UID, w.message, w.addtime, u.username, u.photo, u.gender\n FROM wall AS w, signup AS u WHERE w.OID = " . $oid . " AND w.status = '1' AND w.UID = u.UID \n ORDER BY w.addtime DESC LIMIT " . $limit; $rs = $conn->execute($sql); $comments = $rs->getrows(); $page_link = $pagination->getPagination('user/' . $username . '/wall', 'p_wall_comments_' . $oid . '_'); $page_link_b = $pagination->getPagination('user/' . $username . '/wall', 'pp_wall_comments_' . $oid . '_'); $start_num = $pagination->getStartItem(); $end_num = $pagination->getEndItem(); $code[] = $lang['global.showing'] . ' <span class="text-white">' . $start_num . '</span> ' . $lang['global.to'] . ' <span id="end_num" class="text-white">' . $end_num . '</span> ' . $lang['global.of'] . ' <span id="total_comments" class="text-white">' . $total . '</span> ' . $lang['global.comments'] . '.'; $code[] = '<div id="wall_response" class="wall_posting" style="display: none;">' . $lang['global.posting'] . '</div>'; if ($comments) { $code[] = '<div id="comments_delimiter" style="display:none;"></div>'; foreach ($comments as $comment) { $photo = $comment['photo'] == '' ? 'nopic-' . $comment['gender'] . '.gif' : $comment['photo']; $username = $comment['username']; $code[] = '<div id="wall_comment_' . $comment['wall_id'] . '" class="col-xs-12 m-t-15">';
function action(&$c) { set_menu($c); /** *********************************************************************** * 表示のページネーション、クエリの準備 * * pn_sizeを変えると、一頁当たりの表示が変わる。 * ***************************************************************************/ //pagenation setting $pagination = new Pagination(); $pn_size = $c->admin->getListNum(); $pn_page = isset($_GET['pn_page']) ? $_GET['pn_page'] : 1; $order_tmp = '<a href="list.php?%QUERY%=%VALUE%&order=%ORDER%&sort=%SORT%">%TITLE%</a>'; $order_que = ''; //表示用のパラメータをセット $c->set('cols', $c->admin->getListCols()); //query のテンプレを作る $order_link = array(); $skey = array('/%ORDER%/', '/%SORT%/', '/%TITLE%/'); $rkey = array('created', 'desc', '新しい順'); $o1 = preg_replace($skey, $rkey, $order_tmp); $rkey = array('created', 'asc', '古い順'); $o2 = preg_replace($skey, $rkey, $order_tmp); $order_link['更新日'] = array($o1, $o2); $rkey = array('size', 'desc', '大きい'); $o1 = preg_replace($skey, $rkey, $order_tmp); $rkey = array('size', 'asc', '小さい'); $o2 = preg_replace($skey, $rkey, $order_tmp); $order_link['サイズ'] = array($o1, $o2); $rkey = array('name', 'asc', '昇順'); $o1 = preg_replace($skey, $rkey, $order_tmp); $rkey = array('size', 'desc', '降順'); $o2 = preg_replace($skey, $rkey, $order_tmp); $order_link['名前'] = array($o1, $o2); /** *********************************************************************** * セッションから、ページ名を作成、並び替えのクエリをセット * * * ***************************************************************************/ //ページ名設定 if (isset($_SESSION['swfu']['page_name'])) { $page = $_SESSION['swfu']['page_name']; $c->set('page_name', $page); $images = $c->image->find('$page_name=="' . $page . '"', 'created desc'); $c->set('images', $images); } //並び替えクエリ if (isset($_GET['order']) && isset($_GET['sort'])) { $order_que = '&order=' . $_GET['order'] . '&sort=' . $_GET['sort']; } /** *********************************************************************** * ページ名の変更 * ***************************************************************************/ if (isset($_POST['change_page_name'])) { $old_page = $_POST['old_page']; $new_page = $_POST['new_page']; $rs = $c->image->find('$page_name=="' . $old_page . '"'); foreach ($rs as $r) { $r['page_name'] = $new_page; $c->image->update($r); } $c->redirect('list.php?page=' . rawurlencode($new_page)); } /** *********************************************************************** * ページ名の設定 * ***************************************************************************/ if (isset($_POST['set_page_name'])) { if ($_POST['new_page'] == '') { $c->redirect('index.php'); } else { $_SESSION['swfu']['page_name'] = $_POST['new_page']; $c->redirect('list.php?page=' . rawurlencode($_POST['new_page'])); } } /** *********************************************************************** * pageをもとに、リストを表示 * * * ***************************************************************************/ if (isset($_GET['page'])) { $page = $_GET['page']; $cond = '$page_name=="' . $page . '"'; $order = $order_que == '' ? 'created desc' : $_GET['order'] . ' ' . $_GET['sort']; $total_cnt = $c->image->getCount($cond); $pagination->setLink('list.php?page=' . rawurlencode($page) . '&pn_page=##PN_PAGE##' . $order_que); $pagination->setPage($pn_page); $pagination->setSize($pn_size); $pagination->setTotalRecords($total_cnt); $limit = $pagination->getLimit(); $images = $c->image->find($cond, $order, $limit); $c->set('images', $images); $c->set('pagination_link', $pagination->create_links()); $disp_pagename = $page == '' ? '未分類' : $page; $c->set('h2title', '「' . $disp_pagename . '」のファイル一覧'); $skey = array('/%QUERY%/', '/%VALUE%/'); $rkey = array('page', rawurlencode($page)); $str = ''; foreach ($order_link as $key => $val) { $str .= $key . '['; foreach ($val as $k => $v) { $order_link[$key][$k] = preg_replace($skey, $rkey, $v); } $str .= implode(' , ', $order_link[$key]); $str .= '] '; } $page_form = ' <form class="style_form" action="' . $_SERVER['PHP_SELF'] . '" method="post" style="text-align:right"> <input id="change_page_name" type="text" name="new_page" size="14" value="' . $page . '" /> <input type="submit" value="変更" name="change_page_name" onclick="return confirm_page_chg(\'' . $page . '\');" /> <input type="hidden" name="old_page" value="' . $page . '" /> </form>'; $page_form_set = ' <form class="style_form" action="' . $_SERVER['PHP_SELF'] . '" method="post" style="float:left;"> <input id="new_page" type="hidden" name="new_page" value="' . $page . '" /> <input type="submit" value="セット" name="set_page_name" onclick="return confirm_page_set();" /> <input type="hidden" name="old_page" value="' . $page . '" /> </form>'; $c->set('page_form', $page_form); $c->set('page_form_set', $page_form_set); $c->set('order_link', $str); return; } /** *********************************************************************** * labelをもとに、リストを表示 * * * ***************************************************************************/ if (isset($_GET['label'])) { $label = $_GET['label']; $cond = 'array_key_exists( "' . $label . '", array_flip(explode(",",$label)) )'; $order = $order_que == '' ? 'created desc' : $_GET['order'] . ' ' . $_GET['sort']; $total_cnt = $c->image->getCount($cond); $pagination->setLink('list.php?label=' . rawurlencode($label) . '&pn_page=##PN_PAGE##' . $order_que); $pagination->setPage($pn_page); $pagination->setSize($pn_size); $pagination->setTotalRecords($total_cnt); $limit = $pagination->getLimit(); $images = $c->image->find($cond, $order, $limit); $c->set('images', $images); $c->set('pagination_link', $pagination->create_links()); $label = $label == '' ? 'ラベルなし' : $label; $c->set('h2title', '「' . $label . '」ラベルのファイル一覧'); $skey = array('/%QUERY%/', '/%VALUE%/'); $rkey = array('label', rawurlencode($label)); $str = ''; foreach ($order_link as $key => $val) { $str .= $key . '['; foreach ($val as $k => $v) { $order_link[$key][$k] = preg_replace($skey, $rkey, $v); } $str .= implode(' , ', $order_link[$key]); $str .= '] '; } $c->set('order_link', $str); return; } /** *********************************************************************** * searchをもとに、リストを表示 * * * ***************************************************************************/ if (isset($_GET['search'])) { $search = $_GET['search']; $search_arr = explode(' ', $_GET['search']); //name , description , page_name , label を検索 $tmparr = array(); foreach (array('name', 'description', 'page_name', 'label') as $key) { //OR $arr = array(); foreach ($search_arr as $s) { //AND $arr[] = '(strpos(strtoupper($' . $key . '),"' . strtoupper($s) . '")!==false)'; } $tmparr[] = '(' . implode(' && ', $arr) . ')'; } $cond = implode(' || ', $tmparr); $order = $order_que == '' ? 'created desc' : $_GET['order'] . ' ' . $_GET['sort']; $total_cnt = $c->image->getCount($cond); $pagination->setLink('list.php?search=' . rawurlencode($search) . '&pn_page=##PN_PAGE##' . $order_que); $pagination->setPage($pn_page); $pagination->setSize($pn_size); $pagination->setTotalRecords($total_cnt); $limit = $pagination->getLimit(); $images = $c->image->find($cond, $order, $limit); $c->set('images', $images); $c->set('pagination_link', $pagination->create_links()); $c->set('h2title', '「' . $search . '」検索一覧'); $skey = array('/%QUERY%/', '/%VALUE%/'); $rkey = array('search', rawurlencode($search)); $str = ''; foreach ($order_link as $key => $val) { $str .= $key . '['; foreach ($val as $k => $v) { $order_link[$key][$k] = preg_replace($skey, $rkey, $v); } $str .= implode(' , ', $order_link[$key]); $str .= '] '; } $c->set('order_link', $str); return; } //削除 if (isset($_GET['delete'])) { $fname = $_GET['delete']; $img = $c->image->findone('$name=="' . $fname . '"'); $c->image->del('$id=="' . $img['id'] . '"'); if (file_exists(SWFU_DATA_DIR . $fname)) { unlink(SWFU_DATA_DIR . $fname); } $c->redirect('index.php'); } //ダウンロード if (isset($_GET['dl'])) { $fname = $_GET['dl']; $fp = fopen(SWFU_DATA_DIR . $fname, "rb"); header("Cache-Control: public"); header("Pragma: public"); header("Accept-Ranges: none"); header("Content-Transfer-Encoding: binary"); header("Content-Disposition: attachment; filename={$fname}"); header("Content-Type: application/octet-stream; name={$fname}"); fpassthru($fp); fclose($fp); exit; } }