$parameter = 'action=photo&doing=view_photo&photo_id=7&'; $pagebar = pagebar(get_self(), $parameter, $page_current, $page_size, $count); $smarty = new smarty(); smarty_header(); $smarty->assign('pagebar', $pagebar); $smarty->assign('photo', $rows); $smarty->display('admin_photo_list.html'); } if ($doing == 'manage_photo') { check_browser(); check_user(); $format = "SELECT * FROM `{$db_prefix}photo`"; $query = $db->query($format); $page_size = 10; $page_current = isset($_GET['page']) && is_numeric($_GET['page']) ? intval($_GET['page']) : 1; $count = $db->getCount($format); $res = $db->getAll($format . " LIMIT " . ($page_current - 1) * $page_size . "," . $page_size); $rows = array(); if ($count > 1) { foreach ($res as $value) { $rows[] = $value; } } $parameter = 'action=photo&doing=manage_photo&'; $pagebar = pagebar(get_self(), $parameter, $page_current, $page_size, $count); $smarty = new smarty(); smarty_header(); $smarty->assign('pagebar', $pagebar); $smarty->assign('photo', $rows); $smarty->display('admin_manage_photo.html'); }
function search_cityinline() { global $_MooClass, $dbTablePre, $user_arr, $userid, $last_login_time; if (isset($user_arr['province'])) { $province = $user_arr['province']; } if (isset($user_arr['city'])) { $city = $user_arr['city']; } //页码 $page = 1; if (isset($_GET['page'])) { $page = intval(max(1, $_GET['page'])); } $pagesize = 4; $offset = ($page - 1) * $pagesize; //note sql语句 $sql_gender = ''; if (isset($user_arr['gender']) && $user_arr['gender'] == '0') { //$gender = '1'; //$sql_gender = " and m.gender='1'"; $index = 'members_women'; } else { //$gender = '0'; //$sql_gender = " and m.gender='0'"; $index = 'members_man'; } $cl = searchApi($index); //note 地区sql语句 // $sql_area = ''; // if($province == -1) $province = 0; // if($city == -1) $city = 0; // if($province != 0 && $city != 0){ // $sql_area = " and m.province='$province' and m.city='$city' "; // }elseif($province == 0 && $city != 0){ // $sql_area = " and m.province='$province'"; // }elseif($province != 0 && $city == 0){ // $sql_area = " and m.city='$city'"; // }elseif($province == 0 && $city == 0){ // $sql_area = ''; // }else{ // $sql_area = ''; // } $cond = array(); $cond[] = array('usertype', '1', false); //获得在线用户数据 if (is_array($province) || is_array($city)) { $lastvisit = array(); } else { $lastvisit = MooUserOnlineArea($province, $city); } //$lastvisit = array($province => array('1098212','1215687','1743145','1744119','1744358','1096623','1097401','1097732','1216122','1216529')); if (!is_array($lastvisit) || empty($lastvisit)) { MooMessage("对不起,当前没有在线的会员", "index.php?n=search"); } else { $lastvisit_str = ''; if (isset($lastvisit[$province]) && !empty($lastvisit[$province])) { $lastvisit_str = implode('|', $lastvisit[$province]); } if (isset($lastvisit[$city]) && !empty($lastvisit[$city])) { if ($lastvisit_str) { $lastvisit_str .= '|' . implode('|', $lastvisit[$city]); } else { $lastvisit_str = implode('|', $lastvisit[$city]); } } $cond[] = array('@id', $lastvisit_str, false); } if ($province) { $cond[] = array('province', $province, false); } if ($city) { $cond[] = array('city', $city, false); } //note 照片显示 //$sql_photo = " and m.images_ischeck='1' and is_lock='1'"; $cond[] = array('is_lock', '1', false); $cond[] = array('images_ischeck', '1', false); $sort_str = '@weight desc,s_cid desc,city_star desc,images_ischeck desc'; // $timestamp = time(); // $expiretime2 = $timestamp - 300;//过期时间 //note 当前在线时间 // $time = time(); // $timemark = $time - 300; // $sql_time = ''; // $sql_time = "m.lastvisit>'$timemark' "; // $sql = " and usertype='1'".$sql_area.$sql_photo.$sql_gender; // echo $sql;die; // $sql_md5 = md5($sql); //md5保存sql // $sql_search = "select id from `{$dbTablePre}member_tmp` where `condition_md5`='{$sql_md5}' and expiretime > '$expiretime2'"; // $ret_search = $_MooClass['MooMySQL']->getOne($sql_search); // if($ret_search){ // $search_id = $ret_search['id']; // cityinline_index($search_id); // }else{ $limit = array($offset, $pagesize); $rs = $cl->getResultOfReset($cond, $limit, $sort_str); if (isset($rs['total_found']) && $rs['total_found']) { //有数据 $total = $rs['total_found']; $total_pages = ceil($total / $pagesize); $ids = $cl->getIds(); } else { //没有数据降低条件 $cond = array(); $cond[] = array('usertype', '1', false); $cond[] = array('is_lock', '1'); $cond[] = array('images_ischeck', '1'); $cond[] = array('@id', $lastvisit_str, false); $rs = $cl->getResult($cond, $limit, $sort_str); if (isset($rs['total_found']) && $rs['total_found']) { $total = $rs['total_found']; $total_pages = ceil($total / $pagesize); $ids = $cl->getIds(); } } //note 找不到匹配的结果返回单独提示页面 if (!isset($ids) || empty($ids)) { include MooTemplate('public/search_error', 'module'); exit; } $user_list = is_array($ids) && !empty($ids) ? implode(",", $ids) : ''; if ($user_list) { $page = min($page, $total_pages); $order_by = "order by s_cid desc ,city_star desc, pic_num desc,images_ischeck desc "; $user = $_MooClass['MooMySQL']->getAll("select s.*,b.mainimg from `{$dbTablePre}members_search` s left join `{$dbTablePre}members_base` b on s.uid=b.uid where s.uid in ({$user_list}) {$order_by}"); } if (!isset($html)) { $html = ''; } if ($total > 4) { $url = 'index.php?n=search&h=cityinline'; $pagebar = pagebar($page, $total_pages, $url, $html); } include MooTemplate('public/search_cityinline', 'module'); exit; // $total_count = $_MooClass['MooMySQL']->getOne("select count(*) as count from `{$dbTablePre}members` m where "."m.lastvisit>'$timemark'".$sql); // $total = $total_count["count"]; // //echo $total;die; // if($total>=1){ // if($total>=4){ // $user = $_MooClass['MooMySQL']->getAll("select m.uid from `{$dbTablePre}members` m where "."m.lastvisit>'$timemark'".$sql); // }else{ // $sql_province = " and usertype='1'"." and m.province='{$province}'".$sql_photo.$sql_gender; // $user = $_MooClass['MooMySQL']->getAll("select m.uid from `{$dbTablePre}members` m where "."m.lastvisit>'$timemark'".$sql); // } // }else{ // $sql1 = " and usertype='1'".$sql_photo.$sql_gender; // $total1 = $_MooClass['MooMySQL']->getOne("select count(*) as count from `{$dbTablePre}members` m where "."m.lastvisit>'$timemark'".$sql1); // if($total1<1){ // MooMessage("对不起,当前没有在线的会员", "index.php?n=search"); // } // $user1 = $_MooClass['MooMySQL']->getAll("select m.uid from `{$dbTablePre}members` m where "."m.lastvisit>'$timemark'".$sql1); // } // $user_list = ""; // if(!empty($user)){ // foreach ($user as $v) { // $user_uid .= $v['uid'].','; // } // if(!empty($user_uid)) // $user_uid = substr($user_uid,0,-1); // $user_list .= $user_uid; // } // // if(!empty($user1)){ // foreach ($user1 as $v){ // $user_uid2 .= $v['uid'].','; // } // if(!empty($user_uid2)) // $user_uid2 = substr($user_uid2,0,-1); // $user_list .= '|'.$user_uid2; // } //echo $user_list;die; // $addtime = time(); // $expiretime = $addtime; // $sql = "select id from `{$dbTablePre}member_tmp` where condition_md5 = '$sql_md5'"; // $ret = $_MooClass['MooMySQL']->getOne($sql); // if (isset($ret['id']) && $ret['id']) { //有则更新 // $search_id = $ret['id']; // $_MooClass['MooMySQL']->query("update `{$dbTablePre}member_tmp` set search_uid='$userid' , uid_list='$user_list', addtime='$addtime',expiretime='$expiretime' where id='$search_id'"); // } else { //无则插入 // $sql = "insert into `{$dbTablePre}member_tmp` set search_uid='$userid',condition_md5='$sql_md5',uid_list='$user_list',addtime='$addtime',expiretime='$expiretime'"; // $_MooClass['MooMySQL']->query($sql); // $search_id = $_MooClass['MooMySQL']->insertId(); // } // cityinline_index($search_id); // } }