function getlatestvisitor() { global $_MooClass, $dbTablePre, $userid, $timestamp, $user_arr; $pagesize = 4; //note 获取删除提交的变量 $delvisitor = MooGetGPC('delvisitor', 'string'); $delvisitorid = MooGetGPC('delvisitorid', 'array'); //note 删除提交的数据 if ($delvisitor && count($delvisitorid)) { for ($i = 0; $i < count($delvisitorid); $i++) { $result = $_MooClass['MooMySQL']->getOne("SELECT `who_del` FROM `" . $dbTablePre . "service_visitor` WHERE `vid`=" . $delvisitorid[$i], true); if ($result['who_del'] != 0) { $_MooClass['MooMySQL']->query("DELETE FROM {$dbTablePre}service_visitor WHERE vid = '{$delvisitorid[$i]}'"); } else { $_MooClass['MooMySQL']->query("UPDATE `" . $dbTablePre . "service_visitor` SET `who_del`=2 WHERE `vid`=" . $delvisitorid[$i]); } } MooMessage("删除成功", 'index.php?n=service&h=mindme', '05'); } //note 如果提交的数据不存在,或者是提交的时候没有选中 if ($delvisitor && !count($delvisitorid)) { MooMessage('请选择要删除选项', 'index.php?n=service&h=mindme', '01'); exit; } //note 获得当前url $currenturl = 'http://' . $_SERVER['SERVER_NAME'] . ':' . $_SERVER["SERVER_PORT"] . $_SERVER["REQUEST_URI"]; $currenturl2 = preg_replace("/(&page=\\d+)/", "", $currenturl); //note 获得第几页 $page = empty($_GET['page']) ? '1' : $_GET['page']; //note limit查询开始位置 $start = ($page - 1) * $pagesize; //note 多少个人访问统计总数 $ret_c = $_MooClass['MooMySQL']->getOne("SELECT count(*) as c FROM {$dbTablePre}service_visitor WHERE uid >0 and visitorid = '{$userid}' AND who_del !=2"); $total = $ret_c['c']; if ($total > 200) { $total = 200; } //更改最近留意我的人最我显示200个 $tomeArr = $_MooClass['MooMySQL']->getOne("SELECT count(*) FROM {$dbTablePre}service_visitor WHERE uid = '{$userid}' AND who_del !=1"); $tome = $tomeArr['count(*)']; //note 查询出谁访问过我相关信息 if ($total) { $results = $_MooClass['MooMySQL']->getAll("SELECT * FROM {$dbTablePre}service_visitor WHERE uid >0 and visitorid = '{$userid}' AND who_del !=2 order by visitortime desc LIMIT {$start},{$pagesize}"); $visitors = array(); foreach ($results as $k => $v) { $send_user1 = array(); $send_user2 = array(); $vistor = array(); $send_user1 = leer_send_user1($v['uid']); $send_user2 = leer_send_user2($v['uid']); $vistor['l'] = $v; $vistor['l']['visitortime'] = $vistor['l']['visitortime'] ? $vistor['l']['visitortime'] : time(); $vistor['s'] = $send_user1; $vistor['t'] = $send_user2; $visitors[$k] = $vistor; } } require MooTemplate('public/service_visitor_latestvisitor', 'module'); }
function getmyleers() { global $_MooClass, $dbTablePre, $userid, $pagesize, $user_arr; //note 处理回复秋波 $repeatleer = MooGetGPC('repeatleer', 'string'); $repeatleerid = MooGetGPC('repeatleerid', 'integer'); if ($repeatleer && $repeatleerid) { $_MooClass['MooMySQL']->query("UPDATE {$dbTablePre}service_leer SET stat = '{$repeatleer}' WHERE senduid = '{$repeatleerid}' AND receiveuid = '{$userid}' "); header("location:index.php?n=service&h=leer"); } //note 处理委婉拒绝秋波 $refuseleer = MooGetGPC('refuseleer', 'string'); $refuseleerid = MooGetGPC('refuseleerid', 'integer'); if ($refuseleer && $refuseleerid) { $_MooClass['MooMySQL']->query("UPDATE {$dbTablePre}service_leer SET stat = '2' WHERE senduid = '{$refuseleerid}' AND receiveuid = '{$userid}' "); header("location:index.php?n=service&h=leer"); } //note 获取删除提交的变量 $delleer = MooGetGPC('delleer', 'string'); $delleerid = MooGetGPC('delleerid', 'array'); //note 删除提交的数据 if ($delleer && count($delleerid)) { $time = time(); foreach ($delleerid as $v) { //$_MooClass['MooMySQL']->query("DELETE FROM {$dbTablePre}service_leer WHERE lid = '$v'"); $_MooClass['MooMySQL']->query("UPDATE {$dbTablePre}service_leer SET receive_del=1,receive_deltime='{$time}',receivenum = '0' WHERE lid = '{$v}'"); } MooMessage("秋波删除成功", 'index.php?n=service&h=leer'); } //note 如果提交的数据不存在,或者是提交的时候没有选中 if ($delleer && !count($delleerid)) { MooMessage('请选择要删除的秋波', 'index.php?n=service&h=leer', '01'); exit; } //分页 $page_per = 4; $page_url = 'http://' . $_SERVER['SERVER_NAME'] . ':' . $_SERVER["SERVER_PORT"] . $_SERVER["REQUEST_URI"]; $page_url = preg_replace("/(&page=\\d+)/", "", $page_url); $page_now = MooGetGPC('page', 'integer', 'G'); $temp = $_MooClass['MooMySQL']->getOne("select count(1) as num FROM {$dbTablePre}service_leer WHERE receiveuid = '{$userid}' and receive_del=0"); $item_num = $temp['num']; $page_num = ceil($item_num / $page_per); if ($page_now > $page_num) { $page_now = $page_num; } if ($page_now < 1) { $page_now = 1; } //读数据 $start = ($page_now - 1) * $page_per; $results = $_MooClass['MooMySQL']->getAll("SELECT * FROM {$dbTablePre}service_leer WHERE receiveuid = '{$userid}' and receive_del=0 ORDER BY receivetime desc LIMIT {$start},{$page_per}"); $leers = array(); foreach ($results as $k => $v) { $send_user1 = array(); $send_user2 = array(); $send_user1 = leer_send_user1($v['senduid']); $send_user2 = leer_send_user2($v['senduid']); $leers[$k]['l'] = $v; $leers[$k]['s'] = $send_user1; $leers[$k]['t'] = $send_user2; } //note 已收到的总数 $temp = $_MooClass['MooMySQL']->getOne("SELECT sum(case when receivenum>=1 then 1 else 0 end) as num FROM {$dbTablePre}service_leer WHERE receiveuid = '{$userid}' and receive_del=0"); $receive_num = empty($temp['num']) ? 0 : $temp['num']; //note 已发送的总数 $temp = $_MooClass['MooMySQL']->getOne("SELECT sum(case when num>=1 then 1 else 0 end) as num FROM {$dbTablePre}service_leer WHERE senduid = '{$userid}' and send_del=0 "); //AND send_del = 0 AND is_server=0 $send_num = empty($temp['num']) ? 0 : $temp['num']; require MooTemplate('public/service_leer_getmyleers', 'module'); }
function whoaddme() { global $_MooClass, $dbTablePre, $userid, $pagesize, $user_arr; //note 获取删除提交的变量 $delfriend = MooGetGPC('delfriend', 'string', 'P'); $delfriendid = MooGetGPC('delfriendid', 'array', 'P'); //note 删除提交的数据 if ($delfriend) { $ids = implode(',', $delfriendid); //foreach($delfriendid as $v) { $_MooClass['MooMySQL']->query("DELETE FROM {$dbTablePre}service_friend WHERE fid in ({$ids})"); //} MooMessage("删除意中人成功", 'index.php?n=service&h=liker', '05'); } $pagesize = 4; //note 获得当前url $currenturl = 'http://' . $_SERVER['SERVER_NAME'] . ':' . $_SERVER["SERVER_PORT"] . $_SERVER["REQUEST_URI"]; $currenturl2 = preg_replace("/(&page=\\d+)/", "", $currenturl); //note 获得第几页 $page = empty($_GET['page']) ? 1 : $_GET['page']; //note limit查询开始位置 $start = ($page - 1) * $pagesize; //note 查出谁加我为意中人的总数 $ret_count = $_MooClass['MooMySQL']->getOne("SELECT count(*) as c FROM {$dbTablePre}service_friend WHERE friendid = '{$userid}'"); $total = $ret_count['c']; $total2Arr = $_MooClass['MooMySQL']->getOne("SELECT count(*) FROM {$dbTablePre}service_friend WHERE uid = '{$userid}'"); $total2 = $total2Arr['count(*)']; //note if ($total) { $results = $_MooClass['MooMySQL']->getAll("SELECT * FROM {$dbTablePre}service_friend WHERE friendid = '{$userid}' order by sendtime desc LIMIT {$start},{$pagesize}"); $friends = array(); foreach ($results as $k => $v) { $send_user1 = array(); $send_user2 = array(); $friend = array(); $send_user1 = leer_send_user1($v['uid']); $send_user2 = leer_send_user2($v['uid']); $friend['l'] = $v; $friend['s'] = $send_user1; $friend['t'] = $send_user2; $friends[$k] = $friend; } } require MooTemplate('public/service_friend_whoaddmylist', 'module'); }
function get_receive_rose() { global $_MooClass, $dbTablePre, $userid, $pagesize, $user_arr; //note 获取删除提交的变量 $delrose = MooGetGPC('delrose', 'string', 'POST'); $delroseid = MooGetGPC('delroseid', 'string', 'POST'); //note 删除提交的数据 if ($delrose && count($delroseid)) { $ids = "'" . implode("','", $delroseid) . "'"; $time = time(); $_MooClass['MooMySQL']->query("UPDATE {$dbTablePre}service_rose SET receive_del=1,receive_deltime='{$time}', receivenum = 0 WHERE rid IN ( {$ids} )"); MooMessage("鲜花删除成功", 'index.php?n=service&h=gift&t=igetrose', '05'); } //note 如果提交的数据不存在,或者是提交的时候没有选中 if ($delrose && !count($delroseid)) { MooMessage('请选择要删除的鲜花', 'index.php?n=service&h=gift&t=igetrose', '01'); exit; } //分页 $page_per = 4; $page_url = 'http://' . $_SERVER['SERVER_NAME'] . ':' . $_SERVER["SERVER_PORT"] . $_SERVER["REQUEST_URI"]; $page_url = preg_replace("/(&page=\\d+)/", "", $page_url); $page_now = MooGetGPC('page', 'integer', 'G'); $temp = $_MooClass['MooMySQL']->getOne("select count(1) as num FROM {$dbTablePre}service_rose WHERE receiveuid = '{$userid}' and send_del=0", true); $item_num = $temp['num']; $page_num = ceil($item_num / $page_per); if ($page_now > $page_num) { $page_now = $page_num; } if ($page_now < 1) { $page_now = 1; } $start = ($page_now - 1) * $page_per; $results = $_MooClass['MooMySQL']->getAll("SELECT * FROM {$dbTablePre}service_rose WHERE receiveuid = '{$userid}' and receive_del=0 ORDER BY receivetime desc LIMIT {$start},{$page_per}"); $roses = array(); foreach ($results as $k => $v) { $send_user1 = array(); $send_user2 = array(); $rose = array(); $send_user1 = leer_send_user1($v['senduid']); $send_user2 = leer_send_user2($v['senduid']); $rose['l'] = $v; $rose['s'] = $send_user1; $rose['t'] = $send_user2; $roses[$k] = $rose; } //note 已收到的玫瑰总数 $temp = $_MooClass['MooMySQL']->getOne("SELECT sum(case when receivenum>=1 then 1 else 0 end) as num FROM {$dbTablePre}service_rose WHERE receiveuid = '{$userid}' and receive_del=0"); $receive_num = empty($temp['num']) ? 0 : $temp['num']; //note 已发送的玫瑰总数 $temp = $_MooClass['MooMySQL']->getOne("SELECT sum(case when num>=1 then 1 else 0 end) as num FROM {$dbTablePre}service_rose WHERE senduid = '{$userid}' and send_del=0"); $send_num = empty($temp['num']) ? 0 : $temp['num']; require MooTemplate('public/service_rose_getreceiverose', 'module'); }
<?php if ($total2 == 0) { ?> <div class="norequest"> 您现在还没有发送任何查看身份证请求 <p>立即 <a href="?n=search">搜索TA</a>,发送自己的查看请求吧</p> </div> <?php } else { ?> <?php foreach ((array) $request_list as $request) { ?> <?php $send_user1 = leer_send_user1($request['uid']); $send_user2 = leer_send_user2($request['uid']); ?> <ul class="service-liker-list"> <li><input type="checkbox" name="delsms[]" value="<?php echo $request['id']; ?> "/></li> <li> <div class="r-service-img"> <?php if (!empty($send_user1['city_star'])) { ?> <a class="citystar2"><img src="module/service/templates/default/images/citystar.gif" /></a> <?php } ?>
function getcontactme() { global $_MooClass, $dbTablePre, $userid, $pagesize, $user_arr; $pagesize = 4; //note 获得当前url $currenturl = 'http://' . $_SERVER['SERVER_NAME'] . ':' . $_SERVER["SERVER_PORT"] . $_SERVER["REQUEST_URI"]; $currenturl2 = preg_replace("/(&page=\\d+)/", "", $currenturl); $currenturl2 = preg_replace("/(&page2=\\d+)/", "", $currenturl2); $currenturl2 = preg_replace("/(&page3=\\d+)/", "", $currenturl2); //note ---------------------等待回应的请求 //note 获得第几页 $page = empty($_GET['page']) ? 1 : $_GET['page']; //note limit查询开始位置 $start = ($page - 1) * $pagesize; $ret = $_MooClass['MooMySQL']->getAll("SELECT stat,count(*) as c FROM {$dbTablePre}service_contact WHERE you_contact_other = '{$userid}' and receive_del=0 and send_del=0 group by stat"); $total = 0; $total2 = 0; $total3 = 0; foreach ($ret as $v) { switch ($v['stat']) { case 1: $total = $v['c']; break; case 2: $total2 = $v['c']; break; case 3: $total3 = $v['c']; break; } } //note 查询等待回应的请求 if ($total) { $results = $_MooClass['MooMySQL']->getAll("SELECT * FROM {$dbTablePre}service_contact WHERE you_contact_other = '{$userid}' AND stat = 1 and receive_del=0 and send_del=0 order by sendtime desc LIMIT {$start},{$pagesize}"); foreach ($results as $k => $v) { $send_user1 = array(); $send_user2 = array(); $contact = array(); $send_user1 = leer_send_user1($v['other_contact_you']); $send_user2 = leer_send_user2($v['other_contact_you']); $contact['l'] = $v; $contact['s'] = $send_user1; $contact['t'] = $send_user2; $contact['t']['introduce'] = trim($contact['t']['introduce']) ? MooCutstr($contact['t']['introduce'], 148, $dot = ' ...') : '无内心独白内容'; $contacts[$k] = $contact; } } $page2 = empty($_GET['page2']) ? 1 : $_GET['page2']; $start2 = ($page2 - 1) * $pagesize; if ($total2) { $results2 = $_MooClass['MooMySQL']->getAll("SELECT * FROM {$dbTablePre}service_contact WHERE you_contact_other = '{$userid}' AND stat = 2 and receive_del=0 and send_del=0 order by sendtime desc LIMIT {$start2},{$pagesize}"); foreach ($results2 as $k => $v) { $send_user1 = array(); $send_user2 = array(); $contact = array(); $send_user1 = leer_send_user1($v['other_contact_you']); $send_user2 = leer_send_user2($v['other_contact_you']); $contact['l'] = $v; $contact['s'] = $send_user1; $contact['t'] = $send_user2; $contact['t']['introduce'] = trim($contact['t']['introduce']) ? MooCutstr($contact['t']['introduce'], 148, $dot = ' ...') : '无内心独白内容'; $contacts2[$k] = $contact; } } $page3 = empty($_GET['page3']) ? 1 : $_GET['page3']; $start3 = ($page3 - 1) * $pagesize; if ($total3) { $results3 = $_MooClass['MooMySQL']->getAll("SELECT * FROM {$dbTablePre}service_contact WHERE you_contact_other = '{$userid}' AND stat = 3 and receive_del=0 and send_del=0 order by sendtime desc LIMIT {$start3},{$pagesize}"); foreach ($results3 as $k => $v) { $send_user1 = array(); $send_user2 = array(); $contact = array(); $send_user1 = leer_send_user1($v['other_contact_you']); $send_user2 = leer_send_user2($v['other_contact_you']); $contact['l'] = $v; $contact['s'] = $send_user1; $contact['t'] = $send_user2; $contact['t']['introduce'] = trim($contact['t']['introduce']) ? MooCutstr($contact['t']['introduce'], 148, $dot = ' ...') : '无内心独白内容'; $contacts3[$k] = $contact; } } require MooTemplate('public/service_contact_getcontactme', 'module'); }