www.gusucode.com > ShopEx481 & PHPWind 整合版码程序 > bbs/admin/unituser.php
<?php !function_exists('adminmsg') && exit('Forbidden'); $basename="$admin_file?adminjob=unituser"; require_once(R_P.'require/credit.php'); if (!$action) { require_once PrintEot('unituser'); } elseif ($_POST['action'] == "unit") { InitGP(array('uids','newuid'),'P'); if (!$uids) { adminmsg('unituser_username_empty'); } if (!$newuid) { adminmsg('unituser_newname_empty'); } $touser = $db->get_one("SELECT username FROM pw_members WHERE uid='$newuid'"); Add_S($touser); if (!$touser['username']) { adminmsg('unituser_newname_error'); } $oldinfo = array(); $uids = explode(',',$uids); foreach ($uids as $key => $val) { if (is_numeric($val)) { if ($val == $newuid) { adminmsg('unituser_samename'); } $rt = $db->get_one("SELECT m.uid,m.username,md.postnum,md.digests,md.rvrc,md.money,md.credit,md.currency,mi.deposit,mi.ddeposit FROM pw_members m LEFT JOIN pw_memberdata md ON m.uid=md.uid LEFT JOIN pw_memberinfo mi ON m.uid=mi.uid WHERE m.uid='$val'"); if (!$rt['uid']) { adminmsg('unituser_username_error'); } else { $oldinfo[] = $rt; } } } $ptable_a = array('pw_posts'); if ($db_plist) { $p_list = explode(',',$db_plist); foreach ($p_list as $val) { $ptable_a[] = 'pw_posts'.$val; } } $postnum = $digests = $rvrc = $money = $credit = $currency = $deposit = $ddeposit = 0; foreach ($oldinfo as $key => $value) { $postnum += $value['postnum']; $digests += $value['digests']; $rvrc += $value['rvrc']; $money += $value['money']; $credit += $value['credit']; $currency += $value['currency']; $deposit += $value['deposit']; $ddeposit += $value['ddeposit']; $creditdb = GetCredit($value['uid']); foreach ($creditdb as $k => $val) { $db->pw_update( "SELECT uid FROM pw_membercredit WHERE uid='$newuid' AND cid='$k'", "UPDATE pw_membercredit SET value=value+'$val[1]' WHERE uid='$newuid' AND cid='$k'", "INSERT INTO pw_membercredit SET uid='$newuid',cid='$k',value='$val[1]'" ); } $db->update("UPDATE pw_threads SET author='$touser[username]',authorid='$newuid' WHERE authorid='$value[uid]'"); foreach ($ptable_a as $val) { $db->update("UPDATE $val SET author='$touser[username]',authorid='$newuid' WHERE authorid='$value[uid]'"); } $db->update("UPDATE pw_attachs SET uid='$newuid' WHERE uid='$value[uid]'"); $db->update("DELETE FROM pw_members WHERE uid='$value[uid]'"); $db->update("DELETE FROM pw_memberdata WHERE uid='$value[uid]'"); $db->update("DELETE FROM pw_memberinfo WHERE uid='$value[uid]'"); $db->update("DELETE FROM pw_msg WHERE type='rebox' AND touid='$value[uid]' OR type='sebox' AND fromuid='$value[uid]'"); $db->update("DELETE FROM pw_msglog WHERE uid='$value[uid]'"); } $db->update("UPDATE pw_memberdata SET postnum=postnum+'$postnum',digests=digests+'$digests',rvrc=rvrc+'$rvrc',money=money+'$money',credit=credit+'$credit',currency=currency+'$currency' WHERE uid='$newuid'"); $db->update("UPDATE pw_memberinfo SET deposit=deposit+'$deposit',ddeposit=ddeposit+'$ddeposit' WHERE uid='$newuid'"); adminmsg('operate_success'); } ?>