function active_rightbottom_sitemail()
{
if ($_POST) {
$sid = MooGetGPC('msg_sid', 'integer', 'P');
if (empty($_POST['msg_sid']) && !empty($_POST['msg_username'])) {
$username = MooGetGPC('msg_username', 'string', 'P');
$sql = "SELECT uid FROM {$GLOBALS['dbTablePre']}admin_user WHERE username='******'";
$admin_user = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql);
if (empty($admin_user)) {
salert('此用户不存在');
exit;
}
$sid = $admin_user['uid'];
}
$data['sid'] = $sid;
$data['title'] = "{$GLOBALS['adminid']}号客服:" . MooGetGPC('msg_title', 'string', 'P');
$data['content'] = MooGetGPC('msg_content', 'string', 'P');
$data['awoketime'] = time() + 120;
$data['dateline'] = time();
$data['send_id'] = $GLOBALS['adminid'];
inserttable('admin_remark', $data);
salert('发送成功');
exit;
}
$group_list = get_group_type();
require adminTemplate('other_rightbottom_sitemail');
}
function system_adminaction_edit()
{
global $menu_nav_arr, $dbTablePre;
$actionid = MooGetGPC('actionid', 'integer');
$ispost = MooGetGPC('ispost', 'integer');
if (empty($actionid)) {
MooMessageAdmin('参数错误', 'index.php?action=adminaction&h=list', 1);
}
if ($ispost) {
$actiondesc = MooGetGPC('actiondesc', 'string');
$actioncode = MooGetGPC('actioncode', 'string');
$navcode = MooGetGPC('navcode', 'string');
$navname = MooGetGPC('navname', 'string');
if (empty($actiondesc) || empty($actioncode) || empty($navcode) || empty($navname)) {
$admin->showMessage('请将信息填写完整', 'index.php?action=adminaction&h=add', 1);
}
$sql = "UPDATE {$GLOBALS['dbTablePre']}admin_action SET navname='{$navname}',navcode='{$navcode}',actioncode='{$actioncode}',actiondesc='{$actiondesc}' WHERE id='{$actionid}'";
$result = $GLOBALS['_MooClass']['MooMySQL']->query($sql);
if ($result) {
//note 插入日志
serverlog(2, $GLOBALS['dbTablePre'] . 'admin_action', "{$GLOBALS['username']}修改操作{$actionid}", $GLOBALS['adminid']);
salert('修改成功', 'index.php?action=system_adminaction&h=list');
//MooMessageAdmin('修改成功','index.php?action=system_adminaction&h=list',1);
} else {
salert('修改失败', 'index.php?action=system_adminaction&h=list');
//MooMessageAdmin('修改失败','index.php?action=system_adminaction&h=list',1);
}
}
$sql = "SELECT * FROM {$GLOBALS['dbTablePre']}admin_action WHERE id='{$actionid}'";
$adminaction = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql);
require_once adminTemplate('adminaction_edit');
}
function transfer_del()
{
$id = MooGetGPC('id', 'integer', 'G');
$sql = "DELETE FROM {$GLOBALS['dbTablePre']}members_transfer WHERE `id`=" . $id;
$GLOBALS['_MooClass']['MooMySQL']->query($sql);
salert("删除成功", "index.php?action=other_members_transfer&h=list");
}
function site_media_edit()
{
$ispost = MooGetGPC('ispost', 'integer', 'P');
if ($ispost) {
$id = MooGetGPC('id', 'integer', 'P');
$title = MooGetGPC('title', 'string', 'P');
$type = MooGetGPC('type', 'string', 'P');
$addtime = strtotime(MooGetGPC('addtime', 'string', 'P'));
$source = MooGetGPC('source', 'string', 'P');
$content = MooGetGPC('content', 'string', 'P');
if (empty($content)) {
salert("内容不能为空");
}
$sql = "UPDATE {$GLOBALS['dbTablePre']}media SET sid = {$GLOBALS['adminid']},type = '{$type}', title = '{$title}', content = '{$content}', addtime = '{$addtime}', source = '{$source}' WHERE id={$id}";
$GLOBALS['_MooClass']['MooMySQL']->query($sql);
//note 插入日志
serverlog(2, $GLOBALS['dbTablePre'] . 'media', "{$GLOBALS['username']}编辑媒体报道", $GLOBALS['adminid']);
salert("编辑成功", "index.php?action=site_media&h=edit&id=" . $id);
}
$isedit = 1;
$id = MooGetGPC('id', 'integer', 'G');
$sql = "SELECT * FROM {$GLOBALS['dbTablePre']}media WHERE id = {$id}";
$news = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql);
require adminTemplate('site_media_add');
}
function getone()
{
global $_MooClass, $dbTablePre, $userid, $memcached;
$sendid = MooGetGPC('sendid', 'integer', 'G');
//$sendid = '21691205';
$user = MooMembersData($sendid);
if ($user['uid'] != $sendid || $sendid == '') {
$error = '查无此人';
echo return_data($error, false);
exit;
}
if (MooGetphoto($user['uid'], 'com')) {
$mainimg = MooGetphoto($userid, 'com');
$user['mainimg'] = $mainimg;
}
$user['password'] = '';
$user['regip'] = '';
$user['qq'] = '';
$user['msn'] = '';
$user['telphone'] = '';
$user['username'] = '';
//print_r($user);
echo return_data($user, true);
exit;
}
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 whoismyfriend()
{
global $_MooClass, $dbTablePre, $userid, $pagesize, $user_arr, $memcached;
$userid = $memcached->get('uid');
//验证登录
$and_uuid = $_GET['uuid'];
$checkuuid = check_uuid($and_uuid);
if (!$checkuuid) {
$error = "uuid_error";
echo return_data($error, false);
exit;
}
$pagesize = 12;
//note 获取删除提交的变量
$delfriend = MooGetGPC('delfriend', 'string');
$delfriendid = MooGetGPC('delfriendid', 'array');
//note 删除提交的数据
if ($delfriend && count($delfriendid)) {
foreach ($delfriendid as $v) {
$_MooClass['MooMySQL']->query("DELETE FROM {$dbTablePre}service_friend WHERE fid = '{$v}'");
}
$return = "删除意中人成功";
echo return_data($return);
exit;
}
//note 如果提交的数据不存在，或者是提交的时候没有选中
if ($delfriend && !count($delfriendid)) {
$error = "请选择要删除的意中人";
echo return_data($error, false);
exit;
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 已收到的统计总数
$query = $_MooClass['MooMySQL']->getOne("select count(1) as num FROM {$dbTablePre}service_friend WHERE uid = '{$userid}'");
$total = $query['num'];
$total2Arr = $_MooClass['MooMySQL']->getOne("SELECT count(*) FROM {$dbTablePre}service_friend WHERE friendid = '{$userid}'");
$total2 = $total2Arr['count(*)'];
//note 查询出意中人相关信息
if ($total) {
$friend = $_MooClass['MooMySQL']->getAll("SELECT * FROM {$dbTablePre}service_friend WHERE uid = '{$userid}' order by sendtime desc LIMIT {$start},{$pagesize}");
}
$friendid = array();
foreach ($friend as $k => $f) {
$friendid[] = $f['friendid'];
}
$frienduid = implode(',', $friendid);
$frienduser = $_MooClass['MooMySQL']->getAll("select s.uid,s.nickname,s.birthyear,s.height,s.salary,s.province,s.city,b.mainimg,s.gender from {$dbTablePre}members_search s left join {$dbTablePre}members_base b on s.uid=b.uid where s.uid=b.uid and s.uid in({$frienduid})");
echo return_data($frienduser);
exit;
}
function site_lovequestion_del()
{
$tid = MooGetGPC('tid', 'integer', 'G');
$sql = "DELETE FROM {$GLOBALS['dbTablePre']}love_question WHERE lid = {$tid}";
$GLOBALS['_MooClass']['MooMySQL']->query($sql);
//note 插入日志
serverlog(4, $GLOBALS['dbTablePre'] . 'love_question', '删除爱情测试题目', $GLOBALS['adminid']);
salert("删除成功", 'index.php?action=site_lovequestion&h=list');
}
function site_lovetype_del()
{
$id = MooGetGPC('id', 'integer', 'G');
$sql = "DELETE FROM {$GLOBALS['dbTablePre']}love_type WHERE id = {$id}";
$GLOBALS['_MooClass']['MooMySQL']->query($sql);
//note 插入日志
serverlog(4, $GLOBALS['dbTablePre'] . 'love_type', '删除测试评分结果', $GLOBALS['adminid']);
salert("删除成功", 'index.php?action=site_lovetype&h=list');
}
function getComment($type, $id)
{
global $dbTablePre, $user_arr;
$page_per = 15;
$page_now = MooGetGPC('page', 'integer', 'G');
$page_url = preg_replace('/&page=[^&]*/', '', $_SERVER['REQUEST_URI']);
$uid = empty($user_arr['uid']) ? 0 : $user_arr['uid'];
$from_where = "FROM {prefix}comment WHERE type = '{$type}' AND id= '{$id}' AND ( ischeck = 1 OR uid = '{$uid}' ) ";
return readTable($page_now, $page_per, $page_url, $from_where, $order_by = 'ORDER BY cid DESC', $fd_list = '*');
}
function getlatestvisitor()
{
global $_MooClass, $dbTablePre, $userid, $timestamp, $user_arr;
$pagesize = 4;
//note 获取删除提交的变量
$delvisitor = MooGetGPC('delvisitor', 'string');
$delvisitorid = MooGetGPC('delvisitorid', 'array');
//取得会员的认证信息
//$in_ask=$_MooClass['MooMySQL']->getOne("select count(*)as c from {$dbTablePre}certification where uid='$userid' and email!='' and telphone!='' ");
//echo "select count(*)as c from {$dbTablePre}certification where uid='$userid' and email!='' and telphone!='' ";
//$certificate=$in_ask[c];
//echo $certificate;
//note 删除提交的数据
if ($delvisitor && count($delvisitorid)) {
/*
foreach($delvisitorid as $v) {
$_MooClass['MooMySQL']->query("DELETE FROM {$dbTablePre}service_visitor WHERE vid = '$v'");
}*/
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 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) {
$visitor = $_MooClass['MooMySQL']->getAll("SELECT * FROM {$dbTablePre}service_visitor WHERE visitorid = '{$userid}' AND who_del !=2 order by visitortime desc LIMIT {$start},{$pagesize}");
}
require MooTemplate('public/service_visitor_latestvisitor', 'module');
}
/**
* 删除白名单
*/
function other_del_white()
{
$id = MooGetGPC('id', 'integer', 'P');
if (empty($id)) {
exit(json_encode(array('flag' => 0, 'msg' => '数据不完整')));
}
if ($GLOBALS['_MooClass']['MooMySQL']->query('DELETE FROM ' . $GLOBALS['dbTablePre'] . 'white_list WHERE id=' . $id)) {
exit(json_encode(array('flag' => 1, 'msg' => '白名单删除成功')));
} else {
exit(json_encode(array('flag' => 0, 'msg' => '删除失败')));
}
}
function login_login()
{
global $_MooClass, $dbTablePre, $memcached;
/*
$seccode1 = strtolower(MooGetGPC('vertify_code','string','P'));
$seccode2 = MooGetGPC('seccode','string','C');
$session_seccode = $memcached->get($seccode2);
if($seccode1 != $session_seccode){
MooMessageAdmin("验证码填写不正确，请确认。", "index.php?action=login",'','',3);
}
*/
$username = MooGetGPC('username', 'string', 'P');
$password = MooGetGPC('password', 'string', 'P');
$password = md5($password);
//判断用户名和密码是否为空
if ($username == '' || $password == '') {
MooMessageAdmin('用户名或密码不能为空', 'index.php?n=login', 1);
}
$userinfo = $_MooClass['MooMySQL']->getOne("SELECT * FROM {$dbTablePre}admin_user WHERE `username`='{$username}' LIMIT 1 ", true);
if ($userinfo['uid'] && $userinfo['password'] == $password) {
MooSetCookie('admin', MooAuthCode("{$userinfo['uid']}\t{$userinfo['password']}", 'ENCODE'), 86400);
//note 写入session表需要的字段值
$online_ip = GetIP();
$lastactive = $GLOBALS['timestamp'];
//note 提取快到期的高级用户并加入备注中
$nowtime = time();
$endtime = $nowtime + 8 * 24 * 60 * 60;
$_MooClass['MooMySQL']->query("DELETE FROM {$dbTablePre}custom_remark WHERE `keyword`='会员到期' AND `cid`='{$userinfo['uid']}'");
$remark = $_MooClass['MooMySQL']->getAll("SELECT `uid`,`endtime` FROM {$dbTablePre}members_search WHERE `sid`={$userinfo['uid']} AND `s_cid`=30 AND `endtime`<{$endtime}", 0, 0, 0, true);
for ($i = 0; $i < count($remark); $i++) {
$content = "尊敬的客服，您的红娘号为" . $remark[$i]['uid'] . "的会员将于" . date('Y-m-d', $remark[$i]['endtime']) . "到期，请尽快与该会员联系";
$_MooClass['MooMySQL']->query("INSERT INTO {$dbTablePre}custom_remark SET `cid`={$userinfo['uid']},`keyword`='会员到期',`content`='{$content}',`awoketime`='{$remark[$i]['endtime']}'");
}
//更新最后登录相关记录
$sql = "UPDATE {$dbTablePre}admin_user SET lastlogin='******',lastip='{$online_ip}' WHERE uid='{$userinfo['uid']}'";
$GLOBALS['_MooClass']['MooMySQL']->query($sql);
$sid_list = '';
//得到我所管理的客服id列表
$sid_list = get_mymanage_serviceid_list($userinfo['uid'], $userinfo['groupid']);
$time = time();
$sql = "REPLACE INTO {$GLOBALS['dbTablePre']}admin_usersession SET uid='{$userinfo['uid']}',groupid='{$userinfo['groupid']}',dateline='{$time}',sid_list='{$sid_list}'";
$GLOBALS['_MooClass']['MooMySQL']->query($sql);
//添加操作日志
serverlog(3, $dbTablePre . "admin_usersession", "{$userinfo['uid']}成功登陆后台", $userinfo['uid']);
MooMessageAdmin('登陆成功', 'index.php?n=main', 1);
} else {
MooMessageAdmin('用户名或密码错误', 'index.php?n=login', 1);
}
}
/**
*来源获取（网站来源访问和推荐用户ID）
*@返回COOKIE值在注册的时候写入
*PHPYOU
*/
function MooGetFromwhere(){
global $_MooCookie;
$puid=$_MooCookie['puid'] ?$_MooCookie['puid'] :MooGetGPC('puid','integer','G');
if($puid){
MooSetCookie('puid', $puid, 24*3600);
}
$website=$_MooCookie['website']?$_MooCookie['website']:MooGetGPC('website','string','G');
if($website){
MooSetCookie('website', $puid, 24*3600);
}
if( isset($_GET['wf']) && isset($_GET['st']) ){
MooSetCookie('where_from', "http://www.7651.com/virtual/?".$_SERVER['QUERY_STRING'], 24*3600);
return;
}
if( preg_match("/\/virtual\//",$_MooCookie['where_from']) ) return;
$rf_url = $_SERVER['HTTP_REFERER'];
// 判断是否有外来页
if (empty($rf_url)) {
//error_log("rf error", 0);
return false;
}
$rf_arr = parse_url($rf_url);
$rf_hostname = $rf_arr["host"];
$rf_path = $rf_ar["path"];
//print_r($rf_arr);
// 判断外来是否是本站
if ($rf_hostname == $_SERVER["HTTP_HOST"] && strstr($rf_url, "/pop/") === false && strstr($rf_url, "/reg/") === false) {
//error_log("rf error1", 0);
$where_from = $_MooCookie['where_from'];
$where_from_arr = parse_url($where_from);
if ($where_from_arr["host"] == $_SERVER["HTTP_HOST"]) {
MooSetCookie('where_from', "", -24*3600);
}
return false;
}
$where_from = $_MooCookie['where_from'];
// 判断外来与cookie中记录是否一致
if ($where_from == $rf_url) {
return false;
}
MooSetCookie('where_from', $_SERVER['HTTP_REFERER'], 24*3600);
return true;
}
function system_adminlog_search()
{
$condition = array();
//客服sid搜索
if ($_GET['sid']) {
$sid = MooGetGPC('sid', 'integer', 'G');
$condition[] = " a.sid='{$sid}'";
}
if ($_GET['sid2']) {
$sid = MooGetGPC('sid2', 'integer', 'G');
$condition[] = " a.sid='{$sid}'";
}
//会员id搜索
if ($_GET['uid']) {
$uid = MooGetGPC('uid', 'integer', 'G');
$condition[] = " a.uid='{$uid}'";
}
if ($_GET['date1']) {
$date1 = strtotime(MooGetGPC('date1', 'string', 'G'));
$condition[] = " a.time>='{$date1}'";
}
if ($_GET['date2']) {
$date2 = strtotime(MooGetGPC('date2', 'string', 'G'));
$condition[] = " a.time<='{$date2}'";
}
$sql_where = '';
if (!empty($condition)) {
$sql_where = 'AND ' . implode('AND', $condition);
}
$page = max(1, MooGetGPC('page', 'integer'));
$limit = 15;
$offset = ($page - 1) * $limit;
$page_per = 15;
//note 得出总数
$sql = "SELECT count(1) as count FROM {$GLOBALS['dbTablePre']}server_log a JOIN {$GLOBALS['dbTablePre']}admin_user as b \n \t\tWHERE a.sid=b.uid {$sql_where}";
$query = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql);
$total = $query['count'];
$sql = "SELECT a.*,b.username FROM {$GLOBALS['dbTablePre']}server_log as a \n \t\tJOIN {$GLOBALS['dbTablePre']}admin_user as b \n \t\tWHERE a.sid=b.uid {$sql_where} ORDER BY a.slid DESC LIMIT {$offset},{$limit}";
$adminlogin_list = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql);
$currenturl = 'http://' . $_SERVER['SERVER_NAME'] . ':' . $_SERVER["SERVER_PORT"] . $_SERVER["REQUEST_URI"];
$currenturl = preg_replace("/www./", "", $currenturl);
$currenturl = preg_replace("/(&page=\\d+)/", "", $currenturl);
$page_links = multipage($total, $page_per, $page, $currenturl);
// $page_links=str_replace('7651','7652',$page_links);
$sql = "SELECT uid,username FROM {$GLOBALS['dbTablePre']}admin_user";
$user_list = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql);
require_once adminTemplate('adminlog_list');
}
function financial_ordertotal_list()
{
//note 处理搜索会员聊天
if ($_GET['action'] == 'financial_ordertotal') {
$bgtime = MooGetGPC('bgtime', 'string');
$endtime = MooGetGPC('endtime', 'string');
$where = ' WHERE 1=1 ';
if (!empty($bgtime) && !empty($endtime)) {
$bgtime_arr = explode("-", $bgtime);
$bgtime_mk = mktime(0, 0, 0, $bgtime_arr[1], $bgtime_arr[2], $bgtime_arr[0]);
$endtime_arr = explode("-", $endtime);
$endtime_mk = mktime(0, 0, 0, $endtime_arr[1], $endtime_arr[2], $endtime_arr[0]);
if ($endtime < $bgtime) {
echo "<script>alert('结束日期不能小于开始日期');window.location.href='index.php?action=financial_ordertotal&h=list'</script>";
exit;
}
$where .= " AND dateline >= '{$bgtime_mk}' AND dateline <= '{$endtime_mk}'";
}
}
//note 处理导出功能
$export = MooGetGPC('export', 'string', 'G');
//if($_GET['export']) {
if ($export) {
ob_clean();
if (empty($user_arr)) {
echo '没有找到符合条件的财务报表';
exit;
}
$today = date("Y-m-d");
header("Content-type:application/vnd.ms-excel; charset=gbk");
header("Content-Disposition:attachment; filename={$today}.xls");
echo iconv('utf-8', 'gbk', '成功订单总数') . "\t";
echo iconv('utf-8', 'gbk', '日期') . "\t\n";
foreach ($user_arr as $k => $v) {
echo iconv('utf-8', 'gbk', $v['name']) . "\t";
echo iconv('utf-8', 'gbk', date("Y-m-d", $v['dateline'])) . "\t\n";
}
exit;
}
//note 数据库查询
$sql = "SELECT COUNT(*) num FROM {$GLOBALS['dbTablePre']}financial_orderok {$where}";
$total = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql);
//note 插入日志
serverlog(1, $GLOBALS['dbTablePre'] . 'financial_orderok', "{$GLOBALS['username']}查看成功订单总数记录列表", $GLOBALS['adminid']);
//note 调用模板
require adminTemplate('financial_ordertotal_list');
}
function searchuid()
{
$uid = MooGetGPC('uid', 'integer', 'G');
$sql = "SELECT s.uid,s.nickname,s.birthyear,s.marriage,s.s_cid,b.mainimg FROM {$GLOBALS['dbTablePre']}members_search as s left join {$GLOBALS['dbTablePre']}members_base as b on s.uid=b.uid WHERE s.uid='{$uid}'";
$res = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql);
if ($res) {
$img = MooGetphotoAdmin($res['uid'], 'small');
if ($img) {
array_push($res, $img);
} else {
array_push($res, '无');
}
echo json_encode(array(0 => $res));
} else {
echo json_encode(array(0 => 'no'));
}
}
function active_chat_list()
{
//note 处理搜索会员聊天
if ($_GET['action'] == 'active_chat') {
$choose = MooGetGPC('choose', 'string');
$keyword = MooGetGPC('keyword', 'string');
$where = '';
if (!empty($choose) && !empty($keyword)) {
if ($choose == 's_content') {
$where = " WHERE {$choose} like '%{$keyword}%'";
} else {
$where = " WHERE {$choose} = '{$keyword}'";
}
}
}
//note 登陆系统后客服显示自己范围内的， 主管显示全部
$return_arr = active_chat_loginlist($where, $keyword);
$where = $return_arr['where'];
$member_arr = $return_arr['members'];
//note 分页处理
$page = max(1, MooGetGPC('page', 'integer'));
$limit = 15;
$offset = ($page - 1) * $limit;
//note 查询语句
if ($where != '1') {
//note 只查询属于该客服下的用户
//note 数据库查询
$sql = "SELECT COUNT(*) num FROM {$GLOBALS['dbTablePre']}service_chat {$where}";
$total = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql);
$sql = "SELECT * FROM {$GLOBALS['dbTablePre']}service_chat {$where} ORDER BY s_id DESC LIMIT {$offset},{$limit}";
$user_arr = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql);
}
//note 搜索分页处理
if (!empty($choose) && !empty($keyword)) {
$currenturl = "index.php?action=active_chat&h=list&choose={$choose}&keyword=" . urlencode($keyword);
} else {
$currenturl = "index.php?action=active_chat&h=list";
}
$pages = multipage($total['num'], $limit, $page, $currenturl);
//note 跳转到某一页
$page_num = ceil($total['num'] / $limit);
//note 插入日志
serverlog(1, $GLOBALS['dbTablePre'] . 'service_chat', "{$GLOBALS['username']}查看聊天记录列表", $GLOBALS['adminid']);
//note 调用模板
require adminTemplate('active_chat_list');
}
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');
}
/**
@param （忘记密码）通过地址栏用户名和新密码登陆
@param return null
*/
function find_pwd()
{
global $_MooClass, $dbTablePre, $userid, $_MooCookie;
// if($userid){
// return;
// }
$uid = MooGetGPC('uid', 'string', G);
$pwd = MooGetGPC('upwd', 'string', G);
/* echo md5($uid).'<br>';
echo md5($pwd);
print_r($_COOKIE);
exit;
*/
if ($_MooCookie['findpwd'] == md5($pwd) && md5($uid) == $_MooCookie['finduser']) {
$newpwd = md5(base64_decode($pwd));
//note 修改密码
//$_MooClass['MooMySQL']->query("update {$dbTablePre}members set password = '******' where uid = '{$uid}'");
//if(MOOPHP_ALLOW_FASTDB){
// MooFastdbUpdate('members','uid',$uid);
// }
MooSetCookie('auth', MooAuthCode("{$uid}\t{$newpwd}", 'ENCODE'), 86400);
//note 写入session表需要的字段值
$online_ip = GetIP();
$lastactive = $GLOBALS['timestamp'];
//$uid = $user['uid'];
//note 更新用户的最近登录ip和最近登录时间
$updatesqlarr = array('lastip' => $online_ip, 'lastvisit' => $lastactive, 'password' => $newpwd);
$wheresqlarr = array('uid' => $uid);
updatetable("members_search", $updatesqlarr, $wheresqlarr);
if (MOOPHP_ALLOW_FASTDB) {
$val = array();
$val['lastip'] = $online_ip;
$val['lastvisit'] = $lastactive;
$val['password'] = $newpwd;
MooFastdbUpdate('members_search', 'uid', $uid, $val);
//!!
}
//note 先删除表里面已存在对应用户的session
//$_MooClass['MooMySQL']->query("DELETE FROM `{$dbTablePre}membersession` WHERE `uid` ='$uid'");
//$_MooClass['MooMySQL']->query("REPLACE INTO `{$dbTablePre}membersession` SET `username`= '$user[username]',`password`='$user[password]',`ip` = '$online_ip',`lastactive` = '$lastactive',`uid` = '$uid'");
return 1;
}
return 0;
}
function active_email()
{
global $_MooClass;
$uid = $u['uid'] = MooGetGPC('uid', 'string');
$verifycode = MooGetGPC('verifycode', 'string');
$username = $u['username'] = MooGetGPC('p', 'string');
if ($verifycode == strtoupper(md5('hongniangwang' . $u['uid'] . $u['username']))) {
$online_ip = GetIP();
$t = time();
$pass = md5('123456');
$r = $_MooClass['MooMySQL']->getOne("select * from web_activelog where uid={$uid} limit 1", true);
if ($r['username'] == $username) {
MooMessage("您已经激活过了", "index.php", "05");
} else {
//$_MooClass['MooMySQL']->query("update web_members_search,web_members_login set password='******',usertype=1,regdate='$t',last_login_time = '$t',login_meb = login_meb+1,lastip='$online_ip',lastvisit='$t' where uid='$uid'");
$_MooClass['MooMySQL']->query("update web_members_search as s,web_members_login as l set s.password='******',s.usertype=1,s.regdate='{$t}',l.last_login_time = '{$t}',l.lastip='{$online_ip}',l.lastvisit='{$t}' where s.uid='{$uid}' and l.uid='{$uid}'");
searchApi('members_man members_women')->updateAttr(array('usertype', 'regdate'), array($uid => array(1, $t)));
$_MooClass['MooMySQL']->query("insert into web_activelog(uid,username,activetime) values('{$uid}','{$username}','{$t}')");
}
MooSetCookie('auth', MooAuthCode("{$uid}\t{$pass}", 'ENCODE'), 86400);
MooSetCookie('username', $u['username'], time() + 3600);
if (MOOPHP_ALLOW_FASTDB) {
$user11 = MooFastdbGet('members_search', 'uid', $uid);
$meb = $user11['login_meb'];
$val_s = $val_l = array();
$val_s['password'] = $pass;
$val_s['usertype'] = 1;
$val_s['regdate'] = $t;
$val_l['last_login_time'] = $t;
$val_l['login_meb'] = $meb + 1;
$val_l['lMooFastdbUpdateastip'] = $online_ip;
$val_l['lastvisit'] = $t;
MooFastdbUpdate('members_search', 'uid', $uid, $val_s);
//!!
MooFastdbUpdate('members_login', 'uid', $uid, $val_l);
}
//$_MooClass['MooMySQL']->query("INSERT INTO `web_membersession` SET `username`= '$u[username]',`password`='$pass',`ip` = '$online_ip',`lastactive` = '$t',`uid` = '$uid'");
MooMessage("验证激活成功", "index.php", "05");
} else {
MooMessage("参数有误！请注册", "index.php", "02");
}
}
function get_class_children()
{
$parent = MooGetGPC('parent', 'integer', 'G');
$select = MooGetGPC('select', 'integer', 'G');
$sql = "SELECT * FROM {$GLOBALS['dbTablePre']}test_class WHERE `parent`='{$parent}' ";
$temp = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql);
if (empty($temp)) {
echo 'no';
exit;
}
$str = "<option value=''>请选择</option>";
foreach ($temp as $v) {
$sel = '';
if ($v['tc_id'] == $select) {
$sel = ' selected="selected"';
}
$str .= "<option value='{$v['tc_id']}'{$sel}>{$v['test_name']}</option>";
}
echo $str;
}
function system_adminmembers_move()
{
global $dbTablePre, $_MooClass;
$kefu_list = get_kefulist();
$is_post = MooGetGPC('ispost', 'integer', 'G');
$fromuser = MooGetGPC('fromuser', 'integer', 'G');
if ($is_post && $fromuser) {
$grade = MooGetGPC('grade', 'integer', 'G');
$getuser = MooGetGPC('getuser', 'integer', 'G');
$move_num = MooGetGPC('move_num', 'integer', 'G');
if ($move_num) {
$limit = "limit {$move_num}";
}
if ($grade) {
$sql = "update {$dbTablePre}members_search m left join {$dbTablePre}member_admininfo a on m.uid=a.uid set m.sid={$getuser} where m.sid={$fromuser} and a.effect_grade={$grade} {$limit}";
$sql2 = "select m.uid as uid from {$dbTablePre}members_search m left join {$dbTablePre}member_admininfo a on m.uid=a.uid where m.sid={$fromuser} and a.effect_grade={$grade} {$limit}";
} else {
$sql = "update {$dbTablePre}members_search set sid={$getuser} where sid={$fromuser} {$limit}";
$sql2 = "select uid from {$dbTablePre}members_search where sid={$fromuser} {$limit}";
}
$rs = $_MooClass['MooMySQL']->getAll($sql2);
if (isset($rs) && $rs) {
foreach ($rs as $k => $v) {
$str_arr[$v] = array($getuser);
}
searchApi('members_man members_women')->updateAttr(array('sid'), $str_arr);
}
$_MooClass['MooMySQL']->query($sql);
$num = $_MooClass['MooMySQL']->affectedRows();
if ($num) {
$sql = "update {$dbTablePre}admin_user set member_count=member_count-'{$num}' where uid={$fromuser}";
$_MooClass['MooMySQL']->query($sql);
$sql = "update {$dbTablePre}admin_user set member_count=member_count+'{$num}' where uid={$getuser}";
$_MooClass['MooMySQL']->query($sql);
serverlog(4, $GLOBALS['dbTablePre'] . "members_search", "{$GLOBALS['username']}将{$fromuser}号客服的{$num}个会员转出", $GLOBALS['adminid'], $uid);
}
salert("成功转移" . $num . "名会员", "index.php?action=system_adminmembers&h=move");
}
require_once adminTemplate('system_adminmembers_move');
}
function index_index()
{
global $_MooClass, $dbTablePre, $userid, $memcached;
$uid = MooGetGPC('uid', 'integer');
$puid = MooGetGPC('puid', 'integer');
if (!$uid) {
if (!$userid) {
MooMessage('没有找到此会员', 'register.html');
} else {
MooMessage('没有找到此会员', 'index.php?n=search');
}
}
if (MOOPHP_ALLOW_FASTDB) {
$user = MooFastdbGet('members', 'uid', $uid);
$user = array_merge($user, MooFastdbGet('memberfield', 'uid', $uid));
$c = MooFastdbGet('choice', 'uid', $uid);
} else {
$user = $_MooClass['MooMySQL']->getOne("SELECT * FROM {$dbTablePre}members where uid='{$uid}'");
$user2 = $_MooClass['MooMySQL']->getOne("SELECT * FROM {$dbTablePre}memberfield where uid='{$uid}'");
$user = array_merge($user, $user2);
unset($user2);
$c = $_MooClass['MooMySQL']->getOne("SELECT * FROM {$dbTablePre}choice as mf WHERE uid='{$uid}'");
}
//$tuijian=$_MooClass['MooMySQL']->getAll("select * from {$dbTablePre}members where gender='$user[gender]' and is_vote='1' order by uid limit 7");
$en_year = $user['birthyear'];
$st_year = $en_year - 2;
$en_year += 2;
$sql_new = "SELECT uid,nickname,gender,birthyear,mainimg,images_ischeck FROM {$dbTablePre}members where birthyear between {$st_year} and {$en_year} and gender='{$user['gender']}' and images_ischeck=1 and is_lock=1 order by regdate desc limit 6";
$tuijian = $_MooClass['MooMySQL']->getAll($sql_new);
if (!$user) {
if (!$userid) {
MooMessage('没有您查看的会员', 'register.html');
} else {
MooMessage('没有您查看的会员', 'index.php?n=search');
}
} else {
MooSetCookie('puid', $puid, time() + 3600, '');
include MooTemplate('public/recommend_index', 'module');
}
}
function music_add()
{
//note 指定会员POST
$post_old_uid = !empty($_POST['old_uid']) ? $_POST['old_uid'] : '';
$post_uid = !empty($_POST['uid']) ? $_POST['uid'] : '';
$old_uid = $post_old_uid ? MooGetGPC('old_uid', 'integer', 'P') : MooGetGPC('uid', 'integer', 'G');
$uid = $post_uid ? MooGetGPC('uid', 'integer', 'P') : $old_uid;
if (isset($_POST['ispost']) && !empty($uid)) {
$ps = '信息不全';
//是否MP3
if (preg_match('/\\.mp3$/i', $_FILES['mp3']['name'])) {
//限制大小6兆
if ($_FILES['mp3']['size'] < 6 * 1024 * 1024) {
MooMakeDir(MP3_DIR . '/' . substr($uid, -2));
$file = str_replace('\\\\', '\\', $_FILES['mp3']['tmp_name']);
$path = substr($uid, -2) . '/' . $uid . '_' . time() . '.mp3';
if (move_uploaded_file($file, MP3_DIR . $path)) {
$title = MooGetGPC('title', 'string', 'P');
$path = $path;
$note = MooGetGPC('note', 'string', 'P');
$dateline = time();
$sql = "INSERT INTO {$GLOBALS['dbTablePre']}art_music (uid,path,title,note,dateline) VALUES ('{$uid}','{$path}','{$title}','{$note}','{$dateline}')";
$insert = $GLOBALS['_MooClass']['MooMySQL']->query($sql);
$ps = '添加音频成功...';
} else {
$ps = '文件保存失败...';
}
} else {
$ps = 'MP3大小不能超过6KB...';
}
} else {
$ps = '请上传MP3格式...';
}
salert($ps, 'index.php?action=diamond_music&h=list');
//echo "<script>window.history.go(-1);</script>";
}
require adminTemplate('diamond_music_add');
}
function check_memberinfo_detail()
{
$id = MooGetGPC('id', 'integer', 'G');
$sql = "SELECT * FROM {$GLOBALS['dbTablePre']}admin_editmembersinfo_sql WHERE id='{$id}'";
$res = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql, true);
$uid = $res['uid'];
//审核通过
if ($_GET['status'] == 1) {
$sql = base64_decode($res['exec_members_sql']);
$GLOBALS['_MooClass']['MooMySQL']->query($sql);
//var_dump($sql);
$sql = base64_decode($res['exec_memberfield_sql']);
$GLOBALS['_MooClass']['MooMySQL']->query($sql);
//var_dump($sql);
$sql = "UPDATE {$GLOBALS['dbTablePre']}admin_editmembersinfo_sql SET status=1 WHERE id='{$id}'";
$GLOBALS['_MooClass']['MooMySQL']->query($sql);
//note 更新用户数据
//fastsearch_update($uid,1);
//fastsearch_update($uid,2);
salert('操作成功');
exit;
}
//审核不通过
if ($_GET['status'] == 2) {
$sql = "UPDATE {$GLOBALS['dbTablePre']}admin_editmembersinfo_sql SET status=2 WHERE id='{$id}'";
$GLOBALS['_MooClass']['MooMySQL']->query($sql);
salert('操作成功，您已拒绝此次对会员资料的修改');
exit;
}
$userinfo = $GLOBALS['_MooClass']['MooMySQL']->getOne("SELECT * FROM {$GLOBALS['dbTablePre']}members WHERE uid='{$uid}'", true);
$userfield = $GLOBALS['_MooClass']['MooMySQL']->getOne("SELECT * FROM {$GLOBALS['dbTablePre']}memberfield WHERE uid='{$uid}'", true);
//修改过的
$userinfo_new = $GLOBALS['_MooClass']['MooMySQL']->getOne("SELECT * FROM {$GLOBALS['dbTablePre']}members_edithistory WHERE uid='{$uid}'", true);
$userfield_new = $GLOBALS['_MooClass']['MooMySQL']->getOne("SELECT * FROM {$GLOBALS['dbTablePre']}memberfield_edithistory WHERE uid='{$uid}'", true);
require adminTemplate("check_memberinfo_detail");
}
function bind_list()
{
$bindArr = array(0 => '未联系', 1 => '<span style="color:#0FF">已绑定</span>', 2 => '<span style="color:#F00">绑定过期</span>');
$page = max(1, MooGetGPC('page', 'integer', 'G'));
$pagesize = 16;
$start = ($page - 1) * $pagesize;
$choose = '';
$uid = '';
if (isset($_GET['choose'])) {
$choose = $_GET['choose'];
}
if (isset($_GET['uid'])) {
$uid = (int) $_GET['uid'];
}
//所管理的客服id列表
$myservice_idlist = get_myservice_idlist();
$sql_where = '';
if (empty($myservice_idlist)) {
$sql_where = " WHERE ms.sid = {$GLOBALS['adminid']} ";
} elseif ($myservice_idlist == 'all') {
//all为客服主管能查看所有的
} else {
$sql_where = " WHERE ms.sid IN({$myservice_idlist})";
}
if ($uid) {
$str = empty($sql_where) ? ' WHERE' : ' AND';
$sql_where .= $str . " mb." . $choose . "='{$uid}'";
}
$sql = "SELECT COUNT(1) c FROM {$GLOBALS['dbTablePre']}members_bind mb \n\t\tLEFT JOIN {$GLOBALS['dbTablePre']}members_search ms ON mb.a_uid = ms.uid \n\t\t{$sql_where} ";
$total = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql);
$sql = "SELECT mb.* \n\t\t\t\tFROM {$GLOBALS['dbTablePre']}members_bind mb \n\t\t\t\tLEFT JOIN {$GLOBALS['dbTablePre']}members_search ms ON mb.a_uid = ms.uid \n\t\t\t\t{$sql_where} \n\t\t\t\tORDER BY bind,id desc \n\t\t\t\tLIMIT {$start},{$pagesize}";
$bindrs = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql);
$currenturl = 'index.php?action=active_bind&h=list';
$pages = multipage($total['c'], $pagesize, $page, $currenturl);
require adminTemplate('active_bind_list');
}
exit;
} else {
$sql = "select mid from web_activity_img where `href` = '{$href}' or `address` = '{$address}' or (`group` = '{$group}' and `sort` = '{$sort}')";
if ($db->getOne($sql)) {
MooMessageAdmin('信息有错误', 'activity_img.php?act=add', 2);
exit;
} else {
$sql = "insert into web_activity_img (`group`,`address`,`href`,`sort`) values ('{$group}','{$address}','{$href}','{$sort}')";
$db->query($sql);
MooMessageAdmin('添加成功', 'activity_img.php', 2);
exit;
}
}
}
$h = MooGetGPC('h', 'string', 'R') == '' ? 'list' : MooGetGPC('h', 'string', 'R');
$act = MooGetGPC('act', 'string', 'R') == '' ? 'list' : MooGetGPC('act', 'string', 'R');
switch ($act) {
case 'sub':
activite_sub();
break;
case 'delect':
activite_delect();
break;
case 'edit':
activite_edit();
break;
case 'add':
activite_add();
break;
default:
activite_list();
function active_activity_edit()
{
$id = MooGetGPC('id', 'integer', 'G');
$id = empty($id) ? MooGetGPC('id', 'integer', 'P') : $id;
$data = array();
if ($_POST) {
$where['id'] = $id;
$data['title'] = trim(MooGetGPC('title', 'string', 'P'));
if (empty($data['title'])) {
MooMessageAdmin('请活动主题', 'index.php?action=active_activity&h=add');
exit;
}
$data['type'] = MooGetGPC('type', 'integer', 'P');
$data['price'] = MooGetGPC('price', 'integer', 'P');
$data['price_online'] = MooGetGPC('price_online', 'integer', 'P');
$data['starttime'] = MooGetGPC('starttime', 'string', 'P');
if (empty($data['starttime'])) {
MooMessageAdmin('请填写活动的报名开始时间', 'index.php?action=active_activity&h=add');
exit;
}
$data['starttime'] = strtotime($data['starttime'] . ' 0:0:0');
$data['endtime'] = MooGetGPC('endtime', 'string', 'P');
if (empty($data['endtime'])) {
MooMessageAdmin('请填写活动的报名结束时间', 'index.php?action=active_activity&h=add');
exit;
}
$data['endtime'] = strtotime($data['endtime'] . ' 23:59:59');
$data['opentime'] = MooGetGPC('opentime', 'array', 'P');
if (empty($data['opentime']['day'])) {
$data['opentime'] = 0;
} else {
$data['opentime'] = strtotime($data['opentime']['day'] . ' ' . $data['opentime']['hour'] . ':' . $data['opentime']['mintue'] . ':0');
}
$data['closetime'] = MooGetGPC('closetime', 'array', 'P');
if (empty($data['closetime']['day'])) {
$data['closetime'] = 0;
} else {
$data['closetime'] = strtotime($data['closetime']['day'] . ' ' . $data['closetime']['hour'] . ':' . $data['closetime']['mintue'] . ':0');
}
$data['issex'] = MooGetGPC('issex', 'string', 'P');
$data['issex'] = $data['issex'] < 1 ? 100 : ($data['issex'] > 100 ? 100 : $data['issex']);
$data['province'] = MooGetGPC('province', 'integer', 'P');
$data['activity_img'] = 'module/activity/templates/default/images/activity_new/' . MooGetGPC('img', 'string', 'P');
$data['href'] = 'index.php?n=activity&h=' . MooGetGPC('href', 'string', 'P');
$data['city'] = MooGetGPC('city', 'integer', 'P');
$data['place'] = htmlspecialchars(trim(MooGetGPC('place', 'string', 'P')));
$data['profile'] = htmlspecialchars(trim(MooGetGPC('profile', 'string', 'P')));
$data['introduction'] = htmlspecialchars(trim(MooGetGPC('introduction', 'string', 'P')));
updatetable('activity', $data, $where);
MooMessageAdmin('活动修改成功', 'index.php?action=active_activity&h=edit&id=' . $id);
}
$sql = 'SELECT `type`,`title`,`price`,`price_online`,`starttime`,`endtime`,`opentime`,`closetime`,`issex`,`province`,`city`,`place`,`profile`,`introduction` from `' . $GLOBALS['dbTablePre'] . 'activity` where `id`=' . $id;
$data = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql);
require adminTemplate('active_activity_detail');
}
function reg_modifytel()
{
global $userid, $dbTablePre, $_MooClass;
$tel_val = MooGetGPC('tel_val', 'string', 'G');
$sql = "update {$dbTablePre}members_search set telphone='{$tel_val}' where uid='{$userid}'";
if ($_MooClass['MooMySQL']->query($sql)) {
$tel['telphone'] = $tel_val;
if (MooFastdbUpdate('members_search', 'uid', $userid, $tel)) {
echo 'ok';
}
}
}
