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 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 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 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 site_recommendget()
{
global $_MooClass, $dbTablePre;
$ispost = MooGetGPC('ispost', 'integer', 'G');
if ($ispost == '1') {
$str = $_SERVER['REQUEST_URI'];
preg_match_all('/uidlist=(\\d*)/i', $str, $uid);
$uidarr = $uid[1];
$uidlist = implode(',', $uidarr);
// echo $uidlist;
$diamond_filename = "../data/cache/diamond_intro.php";
if (!file_exists($diamond_filename)) {
echo "钻石会员推荐列表没有生成！";
exit;
} else {
if (!file_put_contents($diamond_filename, $uidlist)) {
echo "写入不成功";
exit;
}
}
//添加操作日志
serverlog(4, $GLOBALS['dbTablePre'] . "members_backinfo", "钻石会员推荐成功", $GLOBALS['adminid'], $GLOBALS['adminid']);
salert("钻石会员推荐成功！", "index.php?action=site_recommend_diamond&h=list");
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 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 system_admingroup_edit()
{
global $menu_nav_arr;
$groupid = MooGetGPC('groupid', 'integer');
if (MooGetGPC('ispost', 'integer')) {
$groupname = MooGetGPC('groupname', 'string', 'P');
$groupdesc = MooGetGPC('groupdesc', 'string', 'P');
$action_code = MooGetGPC('action_code', 'string', 'P');
$admin_nav = MooGetGPC('adminnav', 'string', 'P');
$login_type = MooGetGPC('login_type', 'string', 'P');
//$type = MooGetGPC('type','integer','P');
if (empty($groupname) || empty($groupdesc) || empty($action_code)) {
MooMessageAdmin('请将信息填写完整', 'index.php?action=system_admingroup&h=add', 1);
}
$action = implode(",", $action_code);
$admin_nav = @implode(",", $admin_nav);
$sql = "UPDATE {$GLOBALS['dbTablePre']}admin_group SET groupname='{$groupname}', groupdesc='{$groupdesc}',nav='{$admin_nav}',action='{$action}' WHERE groupid='{$groupid}'";
$result = $GLOBALS['_MooClass']['MooMySQL']->query($sql);
//note 插入日志
serverlog(3, $GLOBALS['dbTablePre'] . 'admin_group', $GLOBALS['username'] . "编辑{$groupname}权限", $GLOBALS['adminid']);
if ($result) {
salert('编辑成功');
} else {
salert('编辑失败');
}
}
foreach ($menu_nav_arr as $key => $navcode) {
$sql = "SELECT * FROM {$GLOBALS['dbTablePre']}admin_action WHERE navcode = '{$key}'";
$var = "action_list_{$key}";
${$var} = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql);
}
$sql = "SELECT * FROM {$GLOBALS['dbTablePre']}admin_group WHERE groupid='{$groupid}'";
$group = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql);
$action = explode(",", $group['action']);
$nav = explode(",", $group['nav']);
$sql = "SELECT * FROM {$GLOBALS['dbTablePre']}admin_group ORDER BY groupid ASC";
$group_list = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql);
require_once adminTemplate('admingroup_edit');
}
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 system_adminuser_password()
{
$ispost = MooGetGPC('ispost', 'integer', 'P');
if ($ispost) {
$pw = trim(MooGetGPC('pw', 'string', 'P'));
$newpw = trim(MooGetGPC('newpw', 'string', 'P'));
$uid = trim(MooGetGPC('uid', 'integer', 'P'));
$sql = "SELECT password FROM {$GLOBALS['dbTablePre']}admin_user WHERE uid='{$uid}'";
$adminuser = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql);
if (md5($pw) != $adminuser['password']) {
salert('原密码不正确');
} else {
$newpw = md5($newpw);
$sql = "UPDATE {$GLOBALS['dbTablePre']}admin_user SET password = '******' WHERE uid='{$uid}'";
$GLOBALS['_MooClass']['MooMySQL']->query($sql);
salert('密码修改成功');
}
}
require_once adminTemplate('adminuser_password');
}
function vipuser_upgrade()
{
$pid = MooGetGPC('pid', 'string', 'G');
$uid = MooGetGPC('uid', 'string', 'G');
$sql = "SELECT uid,username , nickname, gender, birthyear, s_cid, bgtime, endtime,telphone FROM {$GLOBALS['dbTablePre']}members_search WHERE uid = '{$uid}'";
$user = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql, true);
if (empty($user)) {
salert('无此会员,请确认');
exit;
}
$sql = "SELECT * FROM {$GLOBALS['dbTablePre']}payment WHERE pid = '{$pid}' AND uid = '{$uid}' LIMIT 1";
$pay = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql, true);
if (empty($pay) || $pay['staus'] != 1) {
echo '操作失败!订单不存在或已经处理过了.';
exit;
}
$bgtime = time();
if ($pay['payfor'] == -1) {
// 升级为钻石会员
if ($user['s_cid'] == 10 && $user['endtime'] > $bgtime) {
$bgtime = $user['bgtime'];
$endtime = strtotime("+6 month", $user['endtime']);
} else {
$endtime = strtotime("+6 month");
}
$s_cid = 10;
$content = "ID：{$user['uid']}的会员，您好，恭喜您已成功升级为铂金会员。";
} elseif ($pay['payfor'] == 0) {
// 升级为钻石会员
if ($user['s_cid'] == 20 && $user['endtime'] > $bgtime) {
$bgtime = $user['bgtime'];
$endtime = strtotime("+6 month", $user['endtime']);
} else {
$endtime = strtotime("+6 month");
}
$s_cid = 20;
$content = "ID：{$user['uid']}的会员，您好，恭喜您已成功升级为钻石会员。";
} elseif ($pay['payfor'] == 1) {
//高级会员
$endtime = strtotime("+1 month");
$s_cid = 30;
$content = "ID：{$user['uid']}的会员，您好，恭喜您已成功升级为高级会员。";
} elseif ($pay['payfor'] == 2) {
//城市之星
$endtime = strtotime("+1 month");
$content = "ID：{$user['uid']}的会员，您好，恭喜您已成功升级为城市之星。";
} elseif ($pay['payfor'] == 5) {
$endtime = strtotime("+3 month", $user['endtime']);
$content = "ID：{$user['uid']}的会员，您好，恭喜您已成功升级为钻石会员。";
} else {
echo "操作失败!payment表pid={$pid} 记录的 字段 payfor = {$pay['payfor']} 数据错误,请联系管理员";
exit;
}
//修改 members 表
if ($pay['payfor'] == 2) {
//城市之星
$time = time();
$sql = " update {$GLOBALS['dbTablePre']}members_search set bgtime='{$bgtime}',endtime='{$endtime}',city_star='{$time}' where uid={$uid}";
$value['city_star'] = $time;
$str_arr = array($uid => array($bgtime, $endtime, $time));
$field = array('bgtime', 'endtime', 'city_star');
} elseif ($pay['payfor'] == 5) {
// 高级会员升钻石
$sql = "update {$GLOBALS['dbTablePre']}members_search s left join {$GLOBALS['dbTablePre']}members_base b on s.uid=b.uid set s.s_cid='20',b.grade=5,s.bgtime='{$bgtime}',s.endtime='{$endtime}' where s.uid = {$uid}";
$value['s_cid'] = 20;
$value['grade'] = 5;
$str_arr = array($uid => array(20, $bgtime, $endtime));
$field = array('s_cid', 'bgtime', 'endtime');
} else {
//高级会员或钻石会员或铂金
if ($pay['payfor'] == -1) {
$pay['payfor'] = 10;
} elseif ($pay['payfor'] == 0) {
$pay['payfor'] = 20;
} elseif ($pay['payfor'] == 1) {
$pay['payfor'] = 30;
}
$sql = " update {$GLOBALS['dbTablePre']}members_search s left join {$GLOBALS['dbTablePre']}members_base b on s.uid=b.uid set s.s_cid={$pay['payfor']},b.grade=5,s.bgtime='{$bgtime}',s.endtime='{$endtime}' where s.uid={$uid}";
$value['s_cid'] = $pay['payfor'];
$value['grade'] = 5;
$str_arr = array($uid => array($pay['payfor'], $bgtime, $endtime));
$field = array(array('s_cid', 'bgtime', 'endtime'));
}
searchApi('members_man members_women')->updateAttr($field, $str_arr);
if (MOOPHP_ALLOW_FASTDB) {
$value['bgtime'] = $bgtime;
$value['endtime'] = $endtime;
MooFastdbUpdate('members_search', 'uid', $uid, $value);
}
if (!$GLOBALS['_MooClass']['MooMySQL']->query($sql)) {
echo "操作失败!无法修改用户信息.请联系管理员...";
exit;
}
//短信提醒
//$content .='【真爱一生网】';
if (!empty($content) && !empty($user['telphone'])) {
if (SendMsg($user['telphone'], $content)) {
$GLOBALS['_MooClass']['MooMySQL']->query("INSERT INTO {$GLOBALS['dbTablePre']}smslog(sid,uid,content,sendtime) VALUES('{$GLOBALS['adminid']}','{$uid}','{$content}','{$GLOBALS['timestamp']}')");
}
}
//if(MOOPHP_ALLOW_FASTDB){
//MooFastdbUpdate('members','uid',$uid,'');
//}
serverlog(3, $GLOBALS['dbTablePre'] . "members_search", "{$GLOBALS['username']}改变用户{$uid}的等级", $GLOBALS['adminid'], $uid);
//修改支付信息
$sql = "update {$GLOBALS['dbTablePre']}payment set staus=2 where pid='{$pid}'";
if (!$GLOBALS['_MooClass']['MooMySQL']->query($sql)) {
echo "操作失败!无法修改订单状态.请联系管理员...";
exit;
}
serverlog(3, $GLOBALS['dbTablePre'] . "payment", "{$GLOBALS['username']}改变{$uid}支付状态", $GLOBALS['adminid']);
//插入数据 web_diamond 表(钻石会员)
if ($s_cid == 20) {
//d. = m.nickname,d. = m.gender,d. = m.birthyear,d.=m.bgtime,d.=m.endtime
if ($user['endtime'] > $bgtime) {
//钻石会员续费
$status = 1;
} else {
$status = 1;
}
$sql = "REPLACE INTO {$GLOBALS['dbTablePre']}diamond (uid ,username ,skin ,status, nickname, gender, birthyear,bgtime,endtime)\n VALUES ( '{$uid}', '{$user['username']}', '" . ($user['gender'] == 0 ? 'cyan' : 'red') . "', '{$status}', '{$user['nickname']}','{$user['gender']}','{$user['birthyear']}','{$bgtime}','{$endtime}')";
if (!$GLOBALS['_MooClass']['MooMySQL']->query($sql)) {
echo "操作失败!无法添加钻石会员数据.请联系管理员...";
exit;
}
}
//统计系统的接口begin
//$payKey = 'geoinbvcp';//单独接口验证
$uidmd5 = md5($uid . MOOPHP_AUTHKEY);
//$uidmd5 = md5($uid.$payKey);
$apiurl = "http://tg.zhenaiyisheng.cc/hongniang/hongniang_super_import.php?uid=" . $uid . "&md5=" . $uidmd5;
@file_get_contents($apiurl);
//统计系统的接口end
//htotal
//@file_get_contents("http://222.73.4.240/tj/index/reg?act=pay&w=1&u=".$uid);
$sql = "INSERT INTO web_test VALUES('pay1'," . $uid . ")";
$GLOBALS['_MooClass']['MooMySQL']->query($sql);
echo "ok";
exit;
}
function check_introduce()
{
$uidlist = MooGetGPC('uidlist', 'string', 'G');
if (empty($uidlist)) {
salert('请选择审核的会员ID', 'index.php?action=check&h=monolog');
}
$uid_arr = explode(',', $uidlist);
foreach ($uid_arr as $v) {
$sql = "UPDATE {$GLOBALS['dbTablePre']}choice SET `introduce`=`introduce_check`,`introduce_check`='',`introduce_pass`='1' WHERE `uid`='{$v}'";
$GLOBALS['_MooClass']['MooMySQL']->query($sql);
if (MOOPHP_ALLOW_FASTDB) {
$old_introduce = MooFastdbGet("choice", 'uid', $v);
$value['introduce'] = $old_introduce['introduce_check'];
$value['introduce_chack'] = '';
$value['introduce_pass'] = 1;
MooFastdbUpdate("choice", 'uid', $uid, $value);
}
sendusermessage($uid, "尊敬的红娘会员，您的内心独白已经过红娘的审核", "内心独白审核");
$alert = '内心独白审核通过';
serverlog(3, $dbTablePre . "choice", $GLOBALS['username'] . "批量审核会员" . $uid . "的内心独白", $GLOBALS['adminid'], $v['uid']);
}
salert('审核成功', 'index.php?action=check&h=monolog');
}
$kefe_inf_arr = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql);
foreach ($kefe_inf_arr as $key => $kefu_info) {
$sql = "SELECT count(1) num FROM {$GLOBALS['dbTablePre']}admin_deluser b where sid='{$kefu_info['uid']}' and " . $time_between;
$del_user_num_arr = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql);
$del_user_num[$key] = $del_user_num_arr['num'];
}
}
}
require_once adminTemplate("financial_deluser_count");
}
/***********************************************控制层(C)*****************************************/
$h = MooGetGPC('h', 'string', 'G') == '' ? 'list' : MooGetGPC('h', 'string', 'G');
//note 动作列表
$hlist = array('list', 'delcount');
//note 判断页面是否存在
if (!in_array($h, $hlist)) {
salert('您要打开的页面不存在');
}
//note 判断是否有权限
if (!checkGroup('financial_tele_info', $h)) {
salert('您没有此操作的权限');
}
switch ($h) {
//note 委托列表
case 'list':
financial_tele_info_list();
break;
case 'delcount':
financial_deluser_count();
break;
}
function refresh_comment()
{
include "include/function_comment.php";
$status = comment_list();
if ($status == 'ok') {
salert("缓存文件生成成功,请返回继续操作！", 'index.php?action=site_diamond&h=comment');
}
}
function site_del_recommend_member(){
$uid = MooGetGPC('uid','integer','G');
$sql = "SELECT * FROM {$GLOBALS['dbTablePre']}members_recommend WHERE uid = {$uid}";
$ret = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql);
//note 删除缓存文件
// $sql = "SELECT * FROM {$GLOBALS['dbTablePre']}index_cachefile WHERE province='{$ret['province']}' OR province=''"; // original file
$sql = "SELECT provincestarfile, citystarfile, provinceotherfile FROM {$GLOBALS['dbTablePre']}index_cachefile WHERE province='{$ret['province']}' OR province=''"; // updated file
$cache_file = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql);
if(file_exists('../data/block/'.$cache_file['provincestarfile'])){
@unlink('../data/block/'.$cache_file['provincestarfile']);
}
if(file_exists('../data/block/'.$cache_file['citystarfile'])){
@unlink('../data/block/'.$cache_file['citystarfile']);
}
if(file_exists('../data/block/'.$cache_file['provinceotherfile'])){
@unlink('../data/block/'.$cache_file['provinceotherfile']);
}
$sql = "DELETE FROM {$GLOBALS['dbTablePre']}members_recommend WHERE uid = {$uid}";
$GLOBALS['_MooClass']['MooMySQL']->query($sql);
//note 插入日志
serverlog(4,$GLOBALS['dbTablePre'].'members_recommend','删除首页推荐会员uid='.$uid, $GLOBALS['adminid'],$uid);
salert('删除成功','index.php?action=site&h=index');
}
function allmember_foo()
{
global $dbTablePre;
$condition = '';
/*$keyword = trim(MooGetGPC('keyword','string','P'));
$choose = MooGetGPC('choose','string','P');
if(!empty($choose) && !empty($keyword)){
$condition = " $choose = '$keyword'";
}*/
$telephone = MooGetGPC('telephone', 'integer', 'P');
$memberid = MooGetGPC('memberid', 'integer', 'P') == 0 ? '' : MooGetGPC('memberid', 'integer', 'P');
$qq = MooGetGPC('qq', 'integer', 'P');
$callno = MooGetGPC('callno', 'integer', 'P');
$SearchType = MooGetGPC('SearchType', 'string', 'P');
if ($SearchType == 'tel') {
//手机
$condition = " where m.telphone={$telephone}";
} elseif ($SearchType == 'memberid') {
$condition = " where m.uid={$memberid}";
} elseif ($SearchType == 'qq') {
$condition = " where mf.qq={$qq}";
} elseif ($SearchType == 'callno') {
$condition = " where mf.callno={$callno}";
}
$uid = $sid = $flag = $province = $city = 0;
$nickname = $username = $regdate = $allotdate = $content = '';
if (MooGetGPC('submit', 'string', 'P')) {
$uid = MooGetGPC('uid', 'integer', 'P');
$sid = MooGetGPC('sid', 'integer', 'P');
$content = MooGetGPC('content', 'string', 'P');
$flag = MooGetGPC('type', 'integer', 'P');
//提醒所属客服
$timestamp = time();
$date = date('Y-m-d H:i:s', $timestamp);
$title = "会员 {$uid} 回电！";
$content = $uid . "于{$date}：" . $content;
//$awoketime = $timestamp+3600;
$sql_remark = "insert into {$GLOBALS['dbTablePre']}admin_remark set sid='{$sid}',title='{$title}',content='{$content}',awoketime='',dateline='{$timestamp}',flag={$flag},send_id={$GLOBALS['adminid']}";
$res = $GLOBALS['_MooClass']['MooMySQL']->query($sql_remark);
serverlog(4, $dbTablePre . "admin_remark", "会员" . $uid . "回电发送", $GLOBALS['adminid']);
$currenturl = "index.php?action=allmember&h=foo";
salert("发送成功！", $currenturl);
}
if (MooGetGPC('searchSubmit', 'string', 'P') && !empty($condition)) {
$sql = "select m.uid as uid,m.nickname as nickname,m.province as province,m.city as city,mf.allotdate as allotdate,m.regdate as regdate,m.sid as sid from web_members_search m left join web_members_base mf on m.uid=mf.uid {$condition} limit 1";
$result = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql, true);
$uid = $result['uid'];
$nickname = $result['nickname'];
$sid = $result['sid'];
$regdate = $result['regdate'];
$allotdate = $result['allotdate'];
$province = $result['province'];
$city = $result['city'];
if (!empty($sid)) {
$sql = "select username from web_admin_user where uid={$sid}";
$adminUser = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql, true);
$username = $adminUser['username'];
}
}
$currenturl = "index.php?action=allmember&h=foo";
$title = '400查询';
require_once adminTemplate('allmember_foo');
}
function sendmsm_batch()
{
global $dbTablePre;
$uid_list = MooGetGPC('uid_list', 'string', 'P');
$title = MooGetGPC('msg_title', 'string', 'P');
$content = MooGetGPC('msg_content', 'string', 'P');
$array = explode(',', $uid_list);
$arr = array();
foreach ($array as $k => $v) {
if (empty($v)) {
continue;
}
$arr[$k]['uid'] = $v;
}
$sum = 0;
foreach ($arr as $v) {
$uid = $v['uid'];
$GLOBALS['_MooClass']['MooMySQL']->query("insert into {$dbTablePre}services (s_cid,s_uid,s_fromid,s_title,s_content,s_time,sid,flag) values ('3','{$uid}','0','{$title}','{$content}'," . time() . ",'0','1')");
$sum++;
}
salert("群发送邮件成功！共发出 【 {$sum} 】 封邮件", "index.php?action=other&h=sendmail_batch");
header("Location: index.php?action=activity");
}
function site_loveclinic_edit()
{
$ispost = MooGetGPC('ispost', 'integer', 'P');
if ($ispost) {
$id = MooGetGPC('id', 'integer', 'P');
$uid = MooGetGPC('uid', 'integer', 'P');
$title = MooGetGPC('title', 'string', 'P');
$type = MooGetGPC('type', 'integer', 'P');
$question = MooGetGPC('question', 'string', 'P');
$answer = MooGetGPC('answer', 'string', 'P');
$sql = "UPDATE {$GLOBALS['dbTablePre']}love_clinic SET sid='{$GLOBALS['adminid']}', type = '{$type}', title = '{$title}', question = '{$question}', answer = '{$answer}' WHERE id = {$id}";
$GLOBALS['_MooClass']['MooMySQL']->query($sql);
//note 插入日志
serverlog(2, $GLOBALS['dbTablePre'] . 'love_clinic', '编辑情感诊所问题', $GLOBALS['adminid'], $uid);
salert("编辑成功", "index.php?action=site_loveclinic&h=edit&id=" . $id);
}
$isedit = 1;
$id = MooGetGPC('id', 'integer', 'G');
$sql = "SELECT * FROM {$GLOBALS['dbTablePre']}love_clinic WHERE id = {$id}";
$question = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql);
require adminTemplate('site_loveclinic_add');
}
function vipuser_upgrade_remark()
{
$t = 'remark';
$uid = MooGetGPC('uid', 'integer', 'G');
$payments = MooGetGPC('payments', 'integer', 'G');
if (isset($_POST['ispost']) ? $_POST['ispost'] : '') {
$time = time();
$data['sid'] = $GLOBALS['adminid'];
$data['uid'] = MooGetGPC('uid', 'integer', 'P');
$data['servicetime'] = MooGetGPC('servicetime', 'integer', 'P');
$data['payments'] = MooGetGPC('payments', 'integer', 'P');
// $data['pay_type'] = MooGetGPC('pay_type','integer','P');
$data['otheruid'] = MooGetGPC('otheruid', 'integer', 'P');
$data['chatnotes'] = MooGetGPC('chatnotes', 'string', 'P');
$data['intro'] = MooGetGPC('intro', 'string', 'P');
$data['otherintro'] = MooGetGPC('otherintro', 'string', 'P');
$data['lastcom'] = MooGetGPC('lastcom', 'string', 'P');
$data['remark'] = MooGetGPC('remark', 'string', 'P');
$data['dateline'] = $time;
inserttable('members_transfer', $data);
salert('交接信息填写成功！', 'index.php?action=vipuser&h=upgrade_apply&t=remark');
exit;
}
require adminTemplate('vipuser_upgrade_apply');
}
function ajax_change_public_members()
{
global $dbTablePre;
$uid = MooGetGPC('uid', 'integer', 'G');
$puid = MooGetGPC('puid', 'integer', 'G');
$photo = MooGetGPC('photo', 'integer', 'G');
$age2 = 24;
$tmp_end = gmdate('Y', time()) - $age2;
$age_condition = " birthyear>='{$tmp_end}'";
$sql = "update {$dbTablePre}members_search set sid='{$uid}' where sid='{$puid}' and" . $age_condition . " and gender='1'";
$sql2 = "select uid from {$dbTablePre}members_search where sid='{$puid}' and" . $age_condition . " and gender=1";
if ($photo == '1') {
$sql .= "and images_ischeck='1'";
$sql2 .= "and images_ischeck='1'";
} else {
$sql .= "and images_ischeck!='1'";
$sql2 .= "and images_ischeck!='1'";
}
$res = $GLOBALS['_MooClass']['MooMySQL']->query($sql);
$res2 = $GLOBALS['_MooClass']['MooMySQL']->query($sql2);
if (is_array($res2) && !empty($res2)) {
$str_arr = array();
foreach ($res2 as $k => $v) {
$str_arr[$v['uid']] = array($uid);
}
!empty($str_arr) && searchApi("members_man members_women")->updateAttr(array('sid'), $str_arr);
}
serverlog(3, $dbTablePre . 'members_search', $GLOBALS['adminid'] . "号客服一键将公海会员库的24岁以下女会员转到252名下", $GLOBALS['adminid']);
salert("转换成功", 'index.php?action=allmember&h=advancesearch');
exit;
}
function site_skin_del()
{
global $dbTablePre, $_MooClass;
$uid = MooGetGPC('uid', 'string', 'G');
$del_img = $_MooClass['MooMySQL']->getOne("select * from {$dbTablePre}members_skin where uid='{$uid}'");
$sql = "delete from {$dbTablePre}members_skin where uid={$uid}";
if ($_MooClass['MooMySQL']->query($sql) && unlink("../" . $del_img['image'])) {
//note 插入日志
serverlog(1, $GLOBALS['dbTablePre'] . 'members_skin', '删除皮肤成功', $GLOBALS['adminid']);
salert("删除皮肤成功", "index.php?action=site_skin&h=list");
}
}
function myuser_delmyuser()
{
global $h;
$currenturl = 'http://' . $_SERVER['SERVER_NAME'] . ':' . $_SERVER["SERVER_PORT"] . $_SERVER["REQUEST_URI"];
//所管理的客服id列表
$myservice_idlist = get_myservice_idlist();
$uid = MooGetGPC('uid', 'integer', 'G');
$sql = "SELECT sid FROM {$GLOBALS['dbTablePre']}members_search WHERE uid='{$uid}'";
$sid = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql, true);
if ($sid['sid'] == $GLOBALS['adminid'] || $myservice_idlist == 'all' || in_array($sid['sid'], $myservice_idlist)) {
//members表sid清0
$sql = "UPDATE {$GLOBALS['dbTablePre']}members_search SET sid='0' WHERE uid='{$uid}' ";
$GLOBALS['_MooClass']['MooMySQL']->query($sql);
searchApi('members_man members_women')->updateAttr(array('sid'), array($uid => array(0)));
if (MOOPHP_ALLOW_FASTDB) {
$arr = array();
$arr['sid'] = 0;
MooFastdbUpdate('members_search', 'uid', $uid, $arr);
}
//对应的维护会员总数减1
$sql = "UPDATE {$GLOBALS['dbTablePre']}admin_user SET member_count=member_count-1 WHERE uid='{$sid['sid']}'";
$GLOBALS['_MooClass']['MooMySQL']->query($sql);
//后台扩展表标记为删除状态
$sql = "UPDATE {$GLOBALS['dbTablePre']}member_admininfo SET is_delete=1 WHERE uid='{$uid}'";
$GLOBALS['_MooClass']['MooMySQL']->query($sql);
//写日志
serverlog(3, $GLOBALS['dbTablePre'] . 'members_search', "{$GLOBALS['username']}客服将自己的会员{$uid}删除放弃", $GLOBALS['adminid'], $uid);
salert('删除成功');
} else {
salert('操作不合法');
}
}
// echo $currenturl;
$pages = multipage($total, $page_per, $page, $currenturl);
//加载模板
require adminTemplate('financial_classStatistics');
}
/***********************************************控制层(C)*****************************************/
$h = MooGetGPC('h', 'string');
//note 动作列表
$hlist = array('msm_grade_count', 'feedback_fraction', 'member_grade_count', 'delstatistics', 'showreason', 'classStatistics', 'NewClassStat');
//note 判断页面是否存在
if (!in_array($h, $hlist)) {
salert('您要打开的页面不存在');
}
//note 判断是否有权限
if (!checkGroup('financial', $h)) {
salert('您没有修改此操作的权限');
}
switch ($h) {
//note 来自网站对红娘的评分
case 'feedback_fraction':
financial_feedback_fraction();
break;
//note 短信评分统计
//note 短信评分统计
case 'msm_grade_count':
financial_msm_grade_count();
break;
//会员跟进步骤统计
//会员跟进步骤统计
case 'member_grade_count':
financial_member_grade_count();
function other_add_sendinfo()
{
global $timestamp;
if (MooGetGPC('ispost', 'integer')) {
$content = trim(mysql_real_escape_string(MooGetGPC('content', 'string', 'P')));
$type = trim(MooGetGPC('type', 'string', 'P'));
$isShow = trim(MooGetGPC('isShow', 'string', 'P'));
/*if(empty($content)){
salert('请填写内容！');
}*/
$currenturl = "index.php?action=other&h=add_sendinfo";
$sid = $GLOBALS['adminid'];
$sql = " insert into web_members_sendinfo set content='{$content}',sid='{$sid}',isShow='{$isShow}',type='{$type}'";
$bool = $GLOBALS['_MooClass']['MooMySQL']->query($sql);
if ($bool) {
salert('添加成功！', $currenturl);
}
}
require_once adminTemplate('other_sendinfo_add');
}
function system_adminmanage_set_leader()
{
$id = MooGetGPC('groupid', 'integer', 'G');
$uid = MooGetGPC('uid', 'integer', 'G');
$sql = "SELECT username FROM {$GLOBALS['dbTablePre']}admin_user WHERE uid='{$uid}'";
$user = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql);
$arr['leader_uid'] = $uid;
$arr['leader_username'] = $user['username'];
updatetable('admin_manage', $arr, array('id' => $id));
salert('设置成功', 'index.php?action=system_adminmanage&h=groupmember&id=' . $id);
}
function site_story_del()
{
global $_MooClass, $dbTablePre, $memcached;
$delpost = MooGetGPC('delpost', 'integer', 'P');
if ($delpost == '1') {
$imgUrl = MooGetGPC('imgUrl', 'string', 'P');
$sid = MooGetGPC('sid', 'integer', 'P');
$sql = "DELETE FROM {$GLOBALS['dbTablePre']}story_pic WHERE img='{$imgUrl}'";
$res = $GLOBALS['_MooClass']['MooMySQL']->query($sql);
chmod(IMG_ROOT . $imgUrl, 0777);
if (unlink(IMG_ROOT . $imgUrl)) {
echo $sid;
}
die;
}
$sid = MooGetGPC('id', 'integer', 'G');
$sid = intval($sid);
$state = MooGetGPC('state', 'integer', 'G');
$state = intval($state);
$sql1 = "DELETE FROM {$GLOBALS['dbTablePre']}story WHERE `sid` = '{$sid}'";
$sql2 = "DELETE FROM {$GLOBALS['dbTablePre']}story_pic WHERE `sid` = '{$sid}'";
//note 获得大图图片信息
$sql_get = "SELECT * FROM {$GLOBALS['dbTablePre']}story_pic WHERE `sid` = '{$sid}'";
$res_get = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql_get);
//note 获得小图图片名
$story_picname = $res_get[0]['img'];
$filetype = explode('.', $story_picname);
$filetype = array_pop($filetype);
$sidmd5 = $sid * 3;
$bigName = $sidmd5 . '_' . 'big' . '.' . $filetype;
//393_big.jpg
$mediumName = $sidmd5 . '_' . 'medium' . '.' . $filetype;
//393_medium.jpg
$smallName = $sidmd5 . '_' . 'small' . '.' . $filetype;
//393_small.jpg
$res1 = $GLOBALS['_MooClass']['MooMySQL']->query($sql1);
$res2 = $GLOBALS['_MooClass']['MooMySQL']->query($sql2);
//note 删除大图和小图
$c = 0;
foreach ($res_get as $k => $v) {
chmod(IMG_ROOT . $v['img'], 0777);
unlink(IMG_ROOT . $v['img']);
$c++;
}
if ($c == count($res_get)) {
if (file_exists(TO_IMG_CHANGE_ROOT . $bigName) && file_exists(TO_IMG_CHANGE_ROOT . $mediumName) && file_exists(TO_IMG_CHANGE_ROOT . $smallName)) {
chmod(TO_IMG_CHANGE_ROOT . $bigName, 0777);
chmod(TO_IMG_CHANGE_ROOT . $mediumName, 0777);
chmod(TO_IMG_CHANGE_ROOT . $smallName, 0777);
unlink(TO_IMG_CHANGE_ROOT . $bigName);
unlink(TO_IMG_CHANGE_ROOT . $mediumName);
unlink(TO_IMG_CHANGE_ROOT . $smallName);
}
//note 更新缓存
$param = "type=query/name=story/sql=select s.sid,s.uid,s.title,s.content,s.name1,s.name2,s.story_date,sp.img from `{$dbTablePre}story` as s left join `{$dbTablePre}story_pic` as sp on s.is_index=sp.mid where sp.syscheck=1 and s.syscheck=1 and s.recommand= '1' order by s.story_date desc,sp.img desc limit 6/cachetime=86400";
$cachekey = md5($param);
// $file = MOOPHP_DATA_DIR.'/block/story_'.$cachekey.'.data';
if ($memcached->get('story_' . $cachekey)) {
$memcached->delete('story_' . $cachekey);
}
$_MooClass['MooCache']->getBlock($param);
$story = $GLOBALS['_MooBlock']['story'];
//note 插入日志
serverlog(1, $GLOBALS['dbTablePre'] . 'story', '删除成功故事', $GLOBALS['adminid']);
salert("删除故事成功", "index.php?action=site_story&h=list&state={$state}");
}
}