getRow("SELECT * FROM `{$db_mymps}member` WHERE userid = '{$s_uid}'"); $row[prelogo] = $row[prelogo] && !strstr($row[prelogo], 'http') ? $mymps_global[SiteUrl] . $row[prelogo] : $row[prelogo]; $total['info'] = mymps_count('information', "WHERE userid = '{$s_uid}'"); $total['shoucang'] = mymps_count('shoucang', "WHERE userid = '{$s_uid}'"); if ($row['if_corp'] == 1) { $total['docu'] = mymps_count('member_docu', "WHERE userid = '{$s_uid}'"); $total['goods'] = mymps_count('goods', "WHERE userid = '{$s_uid}'"); } include mymps_tpl('member'); exit; } if ($dopost == 1) { switch ($action) { case 'levelup': $forward = read_static_cache('member_' . $forwardlevel); if ($forward === false) { $forward = $db->getRow("SELECT * FROM `{$db_mymps}member_level` WHERE id = '{$forwardlevel}'"); } $forwardlevelname = $forward['levelname']; if (empty($forwardlevelname)) { redirectmsg('您要升级的会员组不存在!', 'index.php?mod=member&action=levelup'); } $moneysettings = $charset == 'utf-8' ? utf8_unserialize($forward['moneysettings']) : unserialize($forward['moneysettings']); $forwardlevelmoney = $moneysettings['money']; $money_cost = $forwardlevelmoney[$leveluptime]; $money_own = $db->getOne("SELECT money_own FROM `{$db_mymps}member` WHERE userid = '{$s_uid}'"); $timearray = array('halfyear' => '183', 'year' => '365', 'month' => '30', 'forever' => '0'); $levelup_time = $timearray[$leveluptime] != 0 ? $timearray[$leveluptime] * 3600 * 24 + $timestamp : 0; if ($money_cost > $money_own) { redirectmsg('余额不足,请先充值 ^_^', 'index.php?mod=member&action=pay&money=' . ($money_cost - $money_own)); } $db->query("UPDATE `{$db_mymps}member` SET levelid = '{$forwardlevel}',levelup_time = '{$levelup_time}',money_own = money_own - '{$money_cost}' WHERE userid = '{$s_uid}'"); $day = $timearray[$leveluptime] == 0 ? '永久' : '' . $timearray[$leveluptime] . '天'; write_money_use('升级会员级别为 ' . $forwardlevelname . ',期限为' . $day, '扣除金币 ' . $money_cost . ' ', $do_type); unset($day); redirectmsg('会员升级成功!', 'index.php?mod=member'); break; case 'upface': require_once MYMPS_INC . '/upfile.fun.php'; $name_file = 'mymps_member_logo'; if ($_FILES[$name_file]['name']) { check_upimage($name_file); $destination = '/face/' . date('Ym') . '/'; $mymps_image = start_upload($name_file, $destination, 0, $mymps_mymps['cfg_memberlogo_limit']['width'], $mymps_mymps['cfg_memberlogo_limit']['height']); @unlink(MYMPS_ROOT . $face); @unlink(MYMPS_ROOT . $normalface); $db->query("UPDATE `{$db_mymps}member` SET logo='{$mymps_image[0]}',prelogo='{$mymps_image[1]}' WHERE userid = '{$s_uid}'"); unset($mymps_mymps, $destination, $name_file, $mymps_image); redirectmsg('图片上传成功!', 'index.php?mod=member'); } else { errormsg('图片上传失败,请换一张图片试试!'); } break; case 'editbase': if ($if_corp == 1) { empty($tname) && errormsg('请填写机构名称'); empty($address) && errormsg('请填写联系地址'); if (is_array($catid)) { mymps_delete('member_category', "WHERE userid = '{$s_uid}'"); foreach ($catid as $kids => $vids) { $db->query("INSERT `{$db_mymps}member_category` (userid,catid)VALUES('{$s_uid}','{$vids}')"); } $catids = implode(',', $catid); } else { errormsg('请选择所属分类'); } $introduce = textarea_post_change($introduce); $tname = $com_certify != 1 && $tname ? ",tname='{$tname}'" : ""; $cname = $cname ? ",cname='{$cname}'" : ""; $hourstime1 = $hourstime1 ? intval($hourstime1) : ''; $hourstime2 = $hourstime2 ? intval($hourstime2) : ''; $hourstime3 = $hourstime3 ? intval($hourstime3) : ''; $hourstime4 = $hourstime4 ? intval($hourstime4) : ''; $hourstime = $hourstime1 . ':' . $hourstime2 . '-' . $hourstime3 . ':' . $hourstime4; $db->query("UPDATE `{$db_mymps}member` SET keywords='{$keywords}',introduce='{$introduce}',hourstime='{$hourstime}',mobile='{$mobile}',email='{$email}',qq='{$qq}',tel='{$tel}',address='{$address}',catid='{$catids}',areaid='{$areaid}'{$tname}{$cname} WHERE userid = '{$s_uid}'"); if ($type == 'reg') { redirectmsg('机构资料提交成功!', 'index.php?mod=member'); exit; } } else { empty($mobile) && errormsg('请填写手机号码'); $cname = $per_certify != 1 && $cname ? ",cname='{$cname}'" : ""; $db->query("UPDATE `{$db_mymps}member` SET mobile='{$mobile}',email='{$email}',qq='{$qq}'{$cname} WHERE userid = '{$s_uid}'"); } redirectmsg('资料更新成功!', 'index.php?mod=member&action=editbase'); break; case 'editpwd': empty($userpwd) && redirectmsg('请输入新密码!', 'index.php?mod=member&action=editpwd'); if (strlen($userpwd) < 6 || strlen($userpwd) > 15) { redirectmsg('密码不能小于6位或超过15位!', 'index.php?mod=member&action=editpwd'); } if ($reuserpwd != $userpwd) { redirectmsg('两次密码输入不相同!', 'index.php?mod=member&action=editpwd'); } if (PASSPORT_TYPE == 'phpwind') { require MYMPS_ROOT . '/pw_client/uc_client.php'; $pw_user = uc_user_get($s_uid); $result = uc_user_edit($pw_user['uid'], $pw_user['username'], '', md5($userpwd), ''); } elseif (PASSPORT_TYPE == 'ucenter') { require MYMPS_ROOT . '/uc_client/client.php'; $result = uc_user_edit($s_uid, $userpwd, $userpwd, $email, 1); } $db->query("UPDATE `{$db_mymps}member` SET userpwd = '" . md5($userpwd) . "' WHERE userid = '{$s_uid}'"); redirectmsg('密码修改成功,请用新密码重新登录!', 'index.php?mod=member'); break; case 'pay': include MYMPS_INC . '/pay.fun.php'; if ($money) { $money = (double) $money; $money = ceil($money / $mymps_global['cfg_coin_fee']); if ($money < 1) { redirectmsg('充值的数量不能小于1', 'javascript:history.back();'); } $payid = (int) $payid; if (!$payid) { redirectmsg('请选择支付接口', 'javascript:history.back();'); } $payr = $db->getRow("SELECT * FROM {$db_mymps}payapi WHERE payid='{$payid}' AND isclose=0"); if (!$payr['payid']) { redirectmsg('该支付接口未开启', 'javascript:history.back();'); } $ddno = $timestamp; $pay_type = 'PayToMoney'; $productname = '金币充值'; msetcookie('pay_type', $pay_type); $PayReturnUrlQz = $mymps_global['SiteUrl']; include MYMPS_INC . '/payment/' . $payr['paytype'] . '/to_pay.php'; } break; case 'mypost': $row = $db->getRow("SELECT money_own FROM `{$db_mymps}member` WHERE userid = '{$s_uid}'"); if ($act == 'refreshid') { if (!$id) { echo '该信息不存在!'; } else { if (mgetcookie('refreshed' . $id) == 1) { echo '该信息已经刷新过了,请不要重复刷新'; exit; } $delmoney = $mymps_global['cfg_member_info_refresh']; if ($delmoney > $row['money_own']) { echo '余额不足'; exit; } $activetime = $db->getOne("SELECT activetime FROM `{$db_mymps}information` WHERE id = '{$id}'"); $endtime = $activetime == 0 ? 0 : $activetime * 3600 * 24 + $timestamp; $db->query("UPDATE `{$db_mymps}information` SET begintime = '{$timestamp}',endtime='{$endtime}' WHERE id ='{$id}'"); msetcookie('refreshed' . $id, 1, 3600 * 24); if ($delmoney) { $db->query("UPDATE `{$db_mymps}member` SET money_own = money_own - '{$delmoney}' WHERE userid = '{$s_uid}'"); } write_money_use("编号为 {$id} 的信息主题被执行 刷新 操作", '扣除金币 ' . $delmoney . ' '); echo 'success'; } } elseif ($act == 'boldid') { if (!$id) { echo '该信息不存在!'; } else { $delmoney = $mymps_global['cfg_member_info_bold']; if ($delmoney > $row['money_own']) { echo '余额不足'; exit; } $ifbold = $db->getOne("SELECT ifbold FROM `{$db_mymps}information` WHERE id = '{$id}'"); if ($ifbold == 1) { echo '操作失败,该信息标题已是加粗状态了'; exit; } $db->query("UPDATE `{$db_mymps}information` SET ifbold = '1' WHERE id ='{$id}'"); if ($delmoney) { $db->query("UPDATE `{$db_mymps}member` SET money_own = money_own - '{$delmoney}' WHERE userid = '{$s_uid}'"); } write_money_use("编号为 {$id} 的信息主题被执行 加粗 操作", '扣除金币 ' . $delmoney . ' '); echo 'success'; } } elseif ($act == 'redid') { if (!$id) { echo '该信息不存在!'; } else { $delmoney = $mymps_global['cfg_member_info_red']; if ($delmoney > $row['money_own']) { echo '余额不足'; exit; } $ifred = $db->getOne("SELECT ifred FROM `{$db_mymps}information` WHERE id = '{$id}'"); if ($ifred == 1) { echo '操作失败,该信息标题已是套红状态了'; exit; } $db->query("UPDATE `{$db_mymps}information` SET ifred = '1' WHERE id ='{$id}'"); if ($delmoney) { $db->query("UPDATE `{$db_mymps}member` SET money_own = money_own - '{$delmoney}' WHERE userid = '{$s_uid}'"); } write_money_use("编号为 {$id} 的信息主题被执行 套红 操作", '扣除金币 ' . $delmoney . ' '); echo 'success'; } } elseif ($act == 'deleteid') { if (!$id) { echo '该信息不存在!'; } else { $r = $db->getRow("SELECT a.*,b.modid FROM `{$db_mymps}information` AS a LEFT JOIN `{$db_mymps}category` AS b ON a.catid = b.catid {$wherea} AND a.id =" . $id); if (!empty($r['img_path'])) { $del = $db->getAll("SELECT path,prepath FROM `{$db_mymps}info_img` WHERE infoid='{$id}'"); foreach ($del as $k => $v) { if ($v['path']) { @unlink(MYMPS_ROOT . $v['path']); } if ($v['prepath']) { @unlink(MYMPS_ROOT . $v['prepath']); } } mymps_delete('info_img', "WHERE infoid = '{$id}'"); } mymps_delete('comment', "WHERE type = 'information' AND typeid = '{$id}'"); if ($r[modid] > 1) { mymps_delete('information_' . $r[modid], "WHERE id = '{$id}'"); } $db->query("DELETE FROM `{$db_mymps}information` WHERE id = " . $id); echo 'success'; } } elseif ($act == 'upgrade') { if (!$id) { echo '请先指定需要置顶的信息主题!'; exit; } if (!($info = $db->getRow("SELECT title,id,upgrade_type,upgrade_type_list,upgrade_type_index FROM `{$db_mymps}information` WHERE id = '{$id}' AND userid = '{$s_uid}'"))) { echo '该主题不存在或者不是您发布的!'; exit; } $need = $mymps_global[$upgrade_type] * $upgrade_time; if ($row['money_own'] < $need) { $money = $need - $row['money_own']; $money = (double) $money; redirectmsg('金币余额不足,请先充值', 'index.php?mod=member&action=pay&money=' . $money); } else { $upgrade_time = $upgrade_time * 3600 * 24 + $timestamp; if ($upgrade_type == 'cfg_member_upgrade_top') { $actionstr = '大类置顶'; if ($info['upgrade_type'] == 2) { redirectmsg('操作失败!该信息主题已处于大类置顶状态!', 'index.php?mod=member&action=mypost&act=upgrade&id=' . $id); } $db->query("UPDATE `{$db_mymps}information` SET upgrade_type = '2' , upgrade_time = '{$upgrade_time}' WHERE id = '{$id}'"); } elseif ($upgrade_type == 'cfg_member_upgrade_list_top') { $actionstr = '小类置顶'; if ($info['upgrade_type_list'] == 2) { redirectmsg('操作失败!该信息主题已处于小类置顶状态!', 'index.php?mod=member&action=mypost&act=upgrade&id=' . $id); } $db->query("UPDATE `{$db_mymps}information` SET upgrade_type_list = '2' , upgrade_time_list = '{$upgrade_time}' WHERE id = '{$id}'"); } elseif ($upgrade_type == 'cfg_member_upgrade_index_top') { $actionstr = '首页置顶'; if ($info['upgrade_type_index'] == 2) { redirectmsg('操作失败!该信息主题已处于首页置顶状态!', 'index.php?mod=member&action=mypost&act=upgrade&id=' . $id); } $db->query("UPDATE `{$db_mymps}information` SET upgrade_type_index = '2' , upgrade_time_index = '{$upgrade_time}' WHERE id = '{$id}'"); } $db->query("UPDATE `{$db_mymps}member` SET money_own = money_own - '{$need}' WHERE userid = '{$s_uid}'"); $caozuo = $upgrade_type == 'cfg_member_upgrade_index_top' ? '首页置顶' : ($upgrade_type == 'cfg_member_upgrade_top' ? '大类置顶' : '小类置顶'); write_money_use("编号为 {$id} 的信息主题被执行 " . $caozuo . ' 操作', '扣除金币 ' . $need . ' '); redirectmsg('操作成功!该信息主题已被' . $actionstr . '!', 'index.php?mod=member&action=mypost'); } } break; case 'sjrz': if (!$mobile) { errormsg('请输入您的手机号码!'); } if (!is_mobile($mobile)) { errormsg('手机号格式不正确!'); } if (!mymps_chk_smsrandcode($smscheckcode, $mobile)) { errormsg('手机验证码输入不正确或与手机号不匹配!'); } $db->query("UPDATE `{$db_mymps}member` SET sj_certify = '1',mobile='{$mobile}' WHERE userid = '{$s_uid}'"); redirectmsg('恭喜!手机认证成功!', 'index.php?mod=member'); break; } exit; } else { if (in_array($action, array('upface', 'editbase', 'editpwd', 'qiandao', 'upgrade_type', 'upface', 'sjrz'))) { $row = $db->getRow("SELECT * FROM `{$db_mymps}member` WHERE userid = '{$s_uid}'"); } switch ($action) { case 'levelup': $row = $db->getRow("SELECT * FROM `{$db_mymps}member` WHERE userid = '{$s_uid}'"); $levelid = $row['levelid']; $levelup_notice = $db->getOne("SELECT value FROM `{$db_mymps}config` WHERE description = 'levelup_notice'"); $data = $levelname = ''; $levelname = $db->getOne("SELECT levelname FROM `{$db_mymps}member_level` WHERE id = '{$levelid}'"); unset($data); include mymps_tpl('member_levelup'); break; case 'upface': $row[prelogo] = $row[prelogo] && !strstr($row[prelogo], 'http') ? $mymps_global[SiteUrl] . $row[prelogo] : $row[prelogo]; include mymps_tpl('member_upface'); break; case 'editbase': $row[prelogo] = $row[prelogo] && !strstr($row[prelogo], 'http') ? $mymps_global[SiteUrl] . $row[prelogo] : $row[prelogo]; $q = explode('-', $row[hourstime]); $w = explode(':', $q[0]); $e = explode(':', $q[1]); $row[hourstime1] = $w[0]; $row[hourstime2] = $w[1]; $row[hourstime3] = $e[0]; $row[hourstime4] = $e[1]; include mymps_tpl('member_editbase'); break; case 'editpwd': include mymps_tpl('member_editpwd'); break; case 'pay': $uid = $db->getOne("SELECT id FROM `{$db_mymps}member` WHERE userid = '{$s_uid}'"); if (strpos($_SERVER['HTTP_USER_AGENT'], 'MicroMessenger') !== false) { $pother = ' paytype=\'wxpay\' '; } else { $pother = ' paytype=\'wxh5\' '; } $mobilepay = $db->getAll("SELECT * FROM `{$db_mymps}payapi` WHERE isclose='0' AND (paytype='alipay_h5' OR {$pother} )"); include mymps_tpl('member_pay'); break; case 'mypost': require_once MYMPS_DATA . '/info.level.inc.php'; unset($information_level, $news_level); if ($act == 'upgrade') { if (empty($id)) { redirectmsg('请选择需要置顶的信息主题'); } $info = $db->getRow("SELECT * FROM `{$db_mymps}information` WHERE id = '{$id}' AND userid = '{$s_uid}'"); if (!$info) { redirectmsg('该信息不是您发布的,不能置顶!'); exit; } $info[gname] = $db->getOne("SELECT catname FROM `{$db_mymps}category` WHERE catid = '{$info['gid']}'"); include mymps_tpl('member_mypost_upgrade'); } else { $where = " WHERE userid = '{$s_uid}' AND (info_level = 1 OR info_level = 2)"; $perpage = $mayimobile['mobiletopicperpage'] ? $mayimobile['mobiletopicperpage'] : 10; $param = setparams(array('mod', 'userid', 'action')); $rows_num = $db->getOne("SELECT COUNT(id) FROM `{$db_mymps}information` {$where}"); $totalpage = ceil($rows_num / $perpage); $num = intval($page - 1) * $perpage; $info_list = page1("SELECT * FROM `{$db_mymps}information` {$where} ORDER BY begintime DESC", $perpage); $pageview = pager(); include mymps_tpl('member_mypost'); } break; case 'shoucang': $perpage = $mayimobile['mobiletopicperpage'] ? $mayimobile['mobiletopicperpage'] : 10; $param = setparams(array('mod', 'action')); $rows_num = $db->getOne("SELECT COUNT(id) FROM `{$db_mymps}shoucang` WHERE userid = '{$s_uid}'"); $totalpage = ceil($rows_num / $perpage); $num = intval($page - 1) * $perpage; $sql = "SELECT a.*,b.id,b.catname,b.dir_typename FROM {$db_mymps}shoucang AS a LEFT JOIN {$db_mymps}information AS b ON a.infoid = b.id WHERE a.userid = '{$s_uid}' ORDER BY a.id DESC"; $lis = page1($sql, $perpage); foreach ($lis as $k => $row) { $arr['id'] = $row['id']; $arr['catname'] = $row['catname']; $arr['infoid'] = $row['infoid']; $arr['title'] = SpHtml2Text($row['title']); $arr['intime'] = get_format_time($row['intime']); $arr['url'] = mRewrite('info', array('id' => $row['infoid'], 'dir_typename' => $row['dir_typename'])); $list[] = $arr; } $pageview = pager(); include mymps_tpl('member_shoucang'); break; case 'docu': $row = $db->getRow("SELECT id FROM `{$db_mymps}member` WHERE userid = '{$s_uid}'"); $where = " WHERE userid = '{$s_uid}'"; $perpage = $mayimobile['mobiletopicperpage'] ? $mayimobile['mobiletopicperpage'] : 10; $param = setparams(array('mod', 'userid', 'action')); $rows_num = $db->getOne("SELECT COUNT(id) FROM `{$db_mymps}member_docu` {$where}"); $totalpage = ceil($rows_num / $perpage); $num = intval($page - 1) * $perpage; $list = page1("SELECT * FROM `{$db_mymps}member_docu` {$where} ORDER BY id DESC", $perpage); $pageview = pager(); include mymps_tpl('member_docu'); break; case 'goods': $where = " WHERE userid = '{$s_uid}'"; $perpage = $mayimobile['mobiletopicperpage'] ? $mayimobile['mobiletopicperpage'] : 10; $param = setparams(array('mod', 'userid', 'action')); $rows_num = $db->getOne("SELECT COUNT(goodsid) FROM `{$db_mymps}goods` {$where}"); $totalpage = ceil($rows_num / $perpage); $num = intval($page - 1) * $perpage; $list = page1("SELECT * FROM `{$db_mymps}goods` {$where} ORDER BY goodsid DESC", $perpage); $pageview = pager(); include mymps_tpl('member_goods'); break; case 'qiandao': $score_change = get_credit_score(); $score_changer = $score_change['score']['rank']['login']; if (!empty($score_changer)) { $qdtime = GetTime($row['qdtime'], 'ymd'); $nowtime = GetTime($timestamp, 'ymd'); if ($qdtime != $nowtime) { if (!empty($score_changer)) { $db->query("UPDATE `{$db_mymps}member` SET score = score" . $score_changer . ",qdtime='{$timestamp}' WHERE userid = '{$s_uid}'"); } echo '签到成功!您的积分值已' . $score_changer; } else { echo '今天您已经签到过了,明天再来吧!'; } } break; case 'upgradecorp': if ($row['if_corp'] == 1) { redirectmsg('您已经是机构会员了', 'index.php?mod=member&action=editbase'); } else { $db->query("UPDATE `{$db_mymps}member` SET if_corp = '1',status = '0' WHERE userid = '{$s_uid}'"); redirectmsg('您已成为机构会员,请完善机构信息以通过审核', 'index.php?mod=member&action=editbase'); } break; case 'sjrz': include mymps_tpl('member_sjrz'); break; } exit; } function get_memberlevel_array($_var_0 = '') { global $db, $db_mymps; $_var_1 = $db->query("SELECT levelname,id FROM `{$db_mymps}member_level` WHERE id > '{$_var_0}'"); while ($_var_2 = $db->fetchRow($_var_1)) { $_var_3[$_var_2['id']]['levelid'] = $_var_2['id']; $_var_3[$_var_2['id']]['levelname'] = $_var_2['levelname']; $_var_3[$_var_2['id']]['levelmoney'] = $_var_2['levelmoney']; } if ($_var_0 != '') { unset($_var_3[$_var_0]); } return $_var_3; } function GetUplevelTime($_var_4 = 'upleveltime', $_var_5 = '') { global $db, $db_mymps, $charset; $_var_6 = array('halfyear' => '半年', 'forever' => '永久', 'month' => '一个月', 'year' => '一年'); $_var_7 = ''; @(include MYMPS_DATA . '/caches/member_' . $_var_5 . '.php'); if ($_var_7 == '') { $_var_2 = $db->getRow("SELECT * FROM `{$db_mymps}member_level` WHERE id = '{$_var_5}'"); } else { $_var_2 = $_var_7; } unset($_var_7); $_var_8 = $charset == 'utf-8' ? utf8_unserialize($_var_2['moneysettings']) : unserialize($_var_2['moneysettings']); $_var_9 = array(); foreach ($_var_8['ifopen'] as $_var_10 => $_var_11) { $_var_9[$_var_10] = $_var_6[$_var_10]; } unset($_var_6); $_var_12 = " '; return $_var_12; }