织梦dedeCMS系统整合discuz论坛后会员注册后不用激活

if(!defined('IN_UC'))
{
error_reporting(0);
set_magic_quotes_runtime(0);
defined('MAGIC_QUOTES_GPC') || define('MAGIC_QUOTES_GPC', get_magic_quotes_gpc());
$_DCACHE = $get = $post = array();
$code = @$_GET['code'];
parse_str(_authcode($code, 'DECODE', UC_KEY), $get);
if(MAGIC_QUOTES_GPC)
{
   $get = _stripslashes($get);
}
$timestamp = time();
if($timestamp - $get['time'] > 3600) {
   exit('Authracation has expiried');
}
if(empty($get)) {
   exit('Invalid Request');
}
$action = $get['action'];
require_once UC_CLIENT_ROOT.'/lib/xml.class.php';
$post = xml_unserialize(file_get_contents('php://input'));
if(in_array($get['action'], array('test', 'deleteuser', 'renameuser', 'gettag', 'synlogin', 'synlogout', 'updatepw', 'updatebadwords', 'updatehosts', 'updateapps', 'updateclient', 'updatecredit', 'getcreditsettings', 'updatecreditsettings')))
{
   $uc_note = new uc_note();
   exit($uc_note->$get['action']($get, $post));
}else{
   exit(API_RETURN_FAILED);
}
//note include 通知方式
} else {
exit('Invalid Request');
}
class uc_note
{
var $dbconfig = '';
var $db = '';
var $appdir = '';
var $tablepre = 'dede_';
function _serialize($arr, $htmlon = 0)
{
   if(!function_exists('xml_serialize'))
   {
    include_once UC_CLIENT_ROOT.'/lib/xml.class.php';
   }
   return xml_serialize($arr, $htmlon);
}
function uc_note()
{
   $this->appdir = DEDEROOT;
   $this->dbconfig = DEDEINC.'/common.inc.php';
   $this->db = $GLOBALS['dsql'];
   $this->tablepre = $GLOBALS['cfg_dbprefix'];
}
function get_uids($uids)
{
   include UC_CLIENT_ROOT.'/client.php';
  
   $members = explode(",", $uids);
   empty($members) && exit(API_RETURN_FORBIDDEN);
  
   /*$members_username = array();
  
   foreach($members as $id)
   {
    $row = uc_get_user($id,1);
    $members_username[] = $row[1];  
   }
  
   $comma_temps = implode(",", $members_username);
  
   empty($comma_temps) && exit(API_RETURN_FORBIDDEN);
  
   $comma_uids = array();*/
  
   //$row = $this->db->SetQuery("SELECT mid FROM `dede_member` WHERE userid IN ($comma_temps)");
  
   $this->db->SetQuery("SELECT mid FROM `dede_member` WHERE mid IN ($uids)");
   $this->db->Execute();  
   while($row = $this->db->GetArray())
   {
    $comma_uids[] = $row['mid'];
   }
  
   empty($comma_uids) && exit(API_RETURN_FORBIDDEN);
  
   return implode(",", $comma_uids);
}
function test($get, $post)
{
   return API_RETURN_SUCCEED;
}
function deleteuser($get, $post)
{
   $uids = $this->get_uids($get['ids']);
   !API_DELETEUSER && exit(API_RETURN_FORBIDDEN);
   //note 用户删除 API 接口
   $rs = $this->db->ExecuteNoneQuery2("DELETE FROM `dede_member` WHERE mid IN ($uids) AND matt<>10 limit 1");
   if($rs > 0)
   {
    $this->db->ExecuteNoneQuery("DELETE FROM `dede_member_tj` WHERE mid IN ($uids) limit 1");
    $this->db->ExecuteNoneQuery("DELETE FROM `dede_member_space` WHERE mid IN ($uids) limit 1");
    $this->db->ExecuteNoneQuery("DELETE FROM `dede_member_company` WHERE mid IN ($uids) limit 1");
    $this->db->ExecuteNoneQuery("DELETE FROM `dede_member_person` WHERE mid IN ($uids) limit 1");
  
    //删除用户相关数据
    $this->db->ExecuteNoneQuery("DELETE FROM `dede_member_stow` WHERE mid IN ($uids) ");
    $this->db->ExecuteNoneQuery("DELETE FROM `dede_member_flink` WHERE mid IN ($uids) ");
    $this->db->ExecuteNoneQuery("DELETE FROM `dede_member_guestbook` WHERE mid IN ($uids) ");
    $this->db->ExecuteNoneQuery("DELETE FROM `dede_member_operation` WHERE mid IN ($uids) ");
    $this->db->ExecuteNoneQuery("DELETE FROM `dede_member_pms` WHERE toid IN ($uids) OR fromid IN ($uids) ");
    $this->db->ExecuteNoneQuery("DELETE FROM `dede_member_friends` WHERE mid IN ($uids) OR fid IN ($uids) ");
    $this->db->ExecuteNoneQuery("DELETE FROM `dede_member_vhistory` WHERE mid IN ($uids) OR vid IN ($uids) ");
    $this->db->ExecuteNoneQuery("DELETE FROM `dede_feedback` WHERE mid IN ($uids) ");
    $this->db->ExecuteNoneQuery("UPDATE `dede_archives` SET mid='0' WHERE mid IN ($uids)");
   }
   else
   {
    exit(API_RETURN_FORBIDDEN);
   }
   return API_RETURN_SUCCEED;
}
function renameuser($get, $post)
{
   $uids = $this->get_uids($get['ids']);
  
  
   $usernameold = $get['oldusername'];
   $usernamenew = $get['newusername'];
   if(!API_RENAMEUSER)
   {
    return API_RETURN_FORBIDDEN;
   }
   //note 获取标签 API 接口
   $rs = $this->db->ExecuteNoneQuery2("UPDATE `dede_member` SET userid='$usernamenew' WHERE userid='$usernamenew' AND matt<>10 limit 1");
   if($rs > 0)
   {
    $this->db->ExecuteNoneQuery("UPDATE `dede_archives` SET writer='$usernamenew' WHERE writer='$usernamenew'");
    $this->db->ExecuteNoneQuery("UPDATE `dede_member_pms` SET floginid=REPLACE(floginid, 't$usernameold', 't$usernamenew'),tologinid=REPLACE(tologinid, 't$usernameold', 't$usernamenew')");
   
   
    $row = $this->db->GetOne("SHOW TABLE STATUS");
    $db_tables = $row['Name']; unset($row);
   
    if(in_array($this->tablepre.'guestbook',$db_tables))
    {
     $this->db->ExecuteNoneQuery("UPDATE `dede_guestbook` SET uname='$usernamenew' WHERE uname='$usernamenew'");
    }
   
    if(in_array($this->tablepre.'story_books',$db_tables))
    {
     $this->db->ExecuteNoneQuery("UPDATE `dede_story_books` SET author='$usernamenew' WHERE author='$usernamenew'");
    }
   
    if(in_array($this->tablepre.'groups',$db_tables))
    {
     $this->db->ExecuteNoneQuery("UPDATE `dede_groups` SET creater='$usernamenew' WHERE creater='$usernamenew'");
     $this->db->ExecuteNoneQuery("UPDATE `dede_group_threads` SET author='$usernamenew' WHERE author='$usernamenew'");
     $this->db->ExecuteNoneQuery("UPDATE `dede_group_user` SET username='$usernamenew' WHERE username='$usernamenew'");
     $this->db->ExecuteNoneQuery("UPDATE `dede_group_posts` SET author='$usernamenew' WHERE author='$usernamenew'");
     $this->db->ExecuteNoneQuery("UPDATE `dede_group_guestbook` SET uname='$usernamenew' WHERE uname='$usernamenew'");
     $this->db->ExecuteNoneQuery("UPDATE `dede_groups` SET ismaster=REPLACE(ismaster, 't$usernameold', 't$usernamenew')");
    }
   
    return API_RETURN_SUCCEED;
   }
   else
   {
    return API_RETURN_FORBIDDEN;
   }
}
function gettag($get, $post)
{
   $name = $get['id'];
   if(!API_GETTAG)
   {
    return API_RETURN_FORBIDDEN;
   }
   //note 获取标签 API 接口
   $name = trim($name);
   if(empty($name) || !preg_match('/^([x7f-xff_-]|w|s)+$/', $name) || strlen($name) > 20)
   {
    return API_RETURN_FAILED;
   }
   $row = $this->db->GetOne("SELECT `total`,`id` FROM `dede_tagindex` WHERE `tag`='$name'");
   if(!is_array($row))
   {
    return API_RETURN_FAILED;
   }
  
   $tpp = $row['total'] > 10 ? 10 : $row['total'];  
  
   $ids = array();
  
   $this->db->SetQuery("SELECT aid FROM `dede_taglist` WHERE `tid`='$row[id]' AND arcrank>-1");
   $this->db->Execute();
   while($row = $this->db->GetArray())
   {
    $ids[] = $row['aid'];   
   }
  
   if(empty($ids))
   {
    return API_RETURN_FAILED;
   }
  
   $aids = implode(",", $ids);
  
   include_once DEDEINC.'/channelunit.func.php';
  
   $archives_list = array();  
   $this->db->SetQuery("SELECT arc.*,tp.typedir,tp.typename,tp.isdefault,tp.defaultname,tp.namerule,tp.namerule2,tp.ispart,tp.moresite,tp.siteurl,tp.sitepath
FROM `dede_archives` arc LEFT JOIN `dede_arctype` tp ON arc.typeid=tp.id WHERE arc.id IN($aids) ORDER BY id DESC LIMIT $tpp");
   $this->db->Execute();
   while($row = $this->db->GetArray())
   {
    $row['url'] = GetFileUrl($row['id'],$row['typeid'],$row['senddate'],$row['title'],$row['ismake'],$row['arcrank'],$row['namerule'],$row['typedir'],$row['money'],$row['filename'],$row['moresite'],$row['siteurl'],$row['sitepath']);
    $row['url'] = !ereg('http:',$row['url']) ? $GLOBALS['cfg_basehost'].$row['url'] : $row['url'];
   
    if(!empty($row['url']))
    {
     $archives_list[] = array('title' => $row['title'],'writer' => $row['writer'],'pubdate' => $row['pubdate'],'url' => $row['url']);
    }
   }
   $return = array($name, $archives_list);
   return $this->_serialize($return, 1);
}
function synlogin($get, $post)
{
   $uid = $get['uid'];
   $username = $get['username'];
   if(!API_SYNLOGIN)
   {
    return API_RETURN_FORBIDDEN;
   }
   //note 同步登录 API 接口
   header('P3P: CP="CURa ADMa DEVa PSAo PSDo OUR BUS UNI PUR INT DEM STA PRE COM NAV OTC NOI DSP COR"');
   $result = $this->db->GetOne("SELECT mid,pwd FROM `dede_member` WHERE `userid` like '$username' AND matt<>10");
   if(is_array($result))
   {
    include_once DEDEINC.'/memberlogin.class.php';
    $cfg_ml = new MemberLogin(86400);
    $cfg_ml->PutLoginInfo($result['mid']);
   }
   else
   {   
    //如果没有激活，则自动添加该用户到数据库，并设置已激活状态的cookie
    //会员的默认金币
    $dfscores = 0;
    $dfmoney = 0;
    $dfrank = $this->db->GetOne("Select money,scores From `dede_arcrank` where rank='10' ");
    if(is_array($dfrank))
    {
     $dfmoney = $dfrank['money'];
     $dfscores = $dfrank['scores'];
    }
    $jointime = time();
    $logintime = time();
    $joinip = $get['regip'];
    $loginip = $get['regip'];
    $pwd = $get['password'];
   
    $spaceSta = ($cfg_mb_spacesta < 0 ? $cfg_mb_spacesta : 0);
    $mtype='个人';
    $email=$get['email'];
   
    $inQuery = "INSERT INTO `dede_member` (`mtype` ,`userid` ,`pwd` ,`uname` ,`sex` ,`rank` ,`money` ,`email` ,`scores` ,
    `matt`, `spacesta` ,`face`,`safequestion`,`safeanswer` ,`jointime` ,`joinip` ,`logintime` ,`loginip` )
     VALUES ('$mtype','$username','$pwd','$username','保密','10','$dfmoney','$email','$dfscores',
     '0','$spaceSta','','','','$jointime','$joinip','$logintime','$loginip'); ";
   
    if($this->db->ExecuteNoneQuery($inQuery))
    {    
     $mid = $this->db->GetLastID();
  
     //写入默认会员详细资料
     $space='person';
  
     //写入默认统计数据
     $membertjquery = "INSERT INTO `dede_member_tj` (`mid`,`article`,`album`,`archives`,`homecount`,`pagecount`,`feedback`,`friend`,`stow`)
                 VALUES ('$mid','0','0','0','0','0','0','0','0'); ";
     $this->db->ExecuteNoneQuery($membertjquery);
  
     //写入默认空间配置数据
     $spacequery = "Insert Into `dede_member_space`(`mid` ,`pagesize` ,`matt` ,`spacename` ,`spacelogo` ,`spacestyle`, `sign` ,`spacenews`)
               Values('$mid','10','0','$username的空间','','$space','',''); ";
     $this->db->ExecuteNoneQuery($spacequery);
  
     //写入其它默认数据
     $this->db->ExecuteNoneQuery("INSERT INTO `dede_member_flink`(mid,title,url) VALUES('$mid','织梦内容管理系统','http://www.dedecms.com'); ");
    
     include_once DEDEINC.'/membermodel.cls.php';
    
     $membermodel = new membermodel($mtype);
    
     $modid=$membermodel->modid;
     
     $modelform = $this->db->getOne("select * from dede_member_model where id='$modid' ");
    
     $this->db->ExecuteNoneQuery("INSERT INTO `{$membermodel->table}` (`mid`) VALUES ('$mid');");
        
     //----------------------------------------------
     //模拟登录
     //---------------------------
     include_once DEDEINC.'/memberlogin.class.php';
     $cfg_ml = new MemberLogin(7*3600);
     $cfg_ml->PutLoginInfo($mid);    
    
    }
   
   }
}
function synlogout($get, $post)
{
   if(!API_SYNLOGOUT)
   {
    return API_RETURN_FORBIDDEN;
   }
   //note 同步登出 API 接口
   header('P3P: CP="CURa ADMa DEVa PSAo PSDo OUR BUS UNI PUR INT DEM STA PRE COM NAV OTC NOI DSP COR"');
   include_once DEDEINC.'/memberlogin.class.php';
   $cfg_ml = new MemberLogin();
   $cfg_ml->ExitCookie();
}
function updatepw($get, $post)
{
   if(!API_UPDATEPW)
   {
    return API_RETURN_FORBIDDEN;
   }
   $username = $get['username'];
   $password = $get['password'];
  
   //note 修改密码 API 接口
   $newpw = md5($password);
   $this->db->ExecuteNoneQuery("UPDATE `dede_member` SET `pwd`='$newpw' WHERE `userid`='$username'");
   return API_RETURN_SUCCEED;
}
function updatebadwords($get, $post)
{
   if(!API_UPDATEBADWORDS)
   {
    return API_RETURN_FORBIDDEN;
   }
   $row = $this->db->GetOne("SELECT `value` FROM `dede_sysconfig` WHERE `varname`='cfg_replacestr'");
  
   $badwords = isset($row['value']) ? explode(",", $row['value']) : array();
  
   if(is_array($post))
   {
    foreach($post as $k => $v)
    {
     if(in_array($v['find'],$badwords)) continue;
     $badwords[] = $v['find'];
    }
   }
   $badwords_comma = !empty($badwords) ? implode(",", $badwords) : '';
  
   $this->db->ExecuteNoneQuery("UPDATE `dede_sysconfig` SET `value`='$badwords_comma' WHERE `varname`='cfg_replacestr'");
  
   $cachefile = DEDEDATA.'/config.cache.inc.php';
  
   if(!is_writeable($cachefile))
   {
    return API_RETURN_FORBIDDEN;
   }
   $fp = fopen($cachefile, 'w');
   $this->db->SetQuery("SELECT `varname`,`type`,`value`,`groupid` From `dede_sysconfig` order by aid asc ");
   $this->db->Execute();
   $s = '<?php'."rn";
   while($row = $this->db->GetArray())
   {
    $s .= '$'.$row['varname'].' = '.($row['type']=='number' ? $row['value'] : "'".str_replace("'",'',$row['value'])."'").";rn";
   }
   $s .= '?>';
   fwrite($fp, $s);
   fclose($fp);
   return API_RETURN_SUCCEED;
}
function updatehosts($get, $post)
{
   if(!API_UPDATEHOSTS)
   {
    return API_RETURN_FORBIDDEN;
   }
   //note 理新HOST缓存 API 接口
   $cachefile = UC_CLIENT_ROOT.'/data/cache/hosts.php';
   $fp = fopen($cachefile, 'w');
   $s = "<?phprn";
   $s .= '$_CACHE['hosts'] = '.var_export($post, TRUE).";rn";
   fwrite($fp, $s);
   fclose($fp);
   return API_RETURN_SUCCEED;
}
function updateapps($get, $post)
{
   if(!API_UPDATEAPPS)
   {
    return API_RETURN_FORBIDDEN;
   }
   $UC_API = $post['UC_API'];
   //note 写 app 缓存文件
   $cachefile = UC_CLIENT_ROOT.'/data/cache/apps.php';
   $fp = fopen($cachefile, 'w');
   $s = "<?phprn";
   $s .= '$_CACHE['apps'] = '.var_export($post, TRUE).";rn";
   fwrite($fp, $s);
   fclose($fp);
   return API_RETURN_SUCCEED;
}
function updateclient($get, $post)
{
   if(!API_UPDATECLIENT)
   {
    return API_RETURN_FORBIDDEN;
   }
   $cachefile = UC_CLIENT_ROOT.'/data/cache/settings.php';
   $fp = fopen($cachefile, 'w');
   $s = '<?php'."rn";
   $s .= '$_CACHE['settings'] = '.var_export($post, TRUE).";rn";
   fwrite($fp, $s);
   fclose($fp);
  
   return API_RETURN_SUCCEED;
}
function updatecredit($get, $post)
{
   if(!API_UPDATECREDIT)
   {
    return API_RETURN_FORBIDDEN;
   }
   /*
   note 更新积分
   discuz 默认8个积分表达,而DedeCMS只有一个积分字段,scores.注意money不能做积分来用.
   extcredits1 extcredits2 extcredits3 extcredits4 extcredits5 extcredits6 extcredits7 extcredits8
   */
    
   $credit = intval($get['credit']);
   $fileds = $credit > 1 ? 'money' : 'scores';
   $amount = $get['amount'];
   $uid = $get['uid'];
   include UC_CLIENT_ROOT.'/client.php';
   $data = uc_get_user($uid,1);
   $username = $data[1];
  
   $result = $this->db->GetOne("SELECT mid FROM `dede_member` WHERE userid='$username'");
   if(is_array($result))
   {
    $this->db->ExecuteNoneQuery("UPDATE `dede_member` SET `$fileds`=`$fileds`+'$amount' WHERE mid='$result[mid]'");
   }
  
   return API_RETURN_SUCCEED;
}
function getcredit($get, $post)
{
   if(!API_GETCREDIT)
   {
    return API_RETURN_FORBIDDEN;
   }
  
   include UC_CLIENT_ROOT.'/client.php';
   $data = uc_get_user($uid,1);
   $username = $data[1];
   $credit = intval($get['credit']);
   $fileds = $credit > 1 ? 'money' : 'scores';
   $result = $this->db->GetOne("SELECT `$fileds` AS credit FROM `dede_member` WHERE userid='$username'");
  
   echo is_array($result) ? $result['credit'] : 0;  
}
function getcreditsettings($get, $post)
{
   if(!API_GETCREDITSETTINGS)
   {
    return API_RETURN_FORBIDDEN;
   }
  
   //这里支持DedeCMS积分,金币设置
   $credits[1] = array(strip_tags('积分'), '分');
   $credits[2] = array(strip_tags('金币'), '枚');
   return $this->_serialize($credits);
}
function updatecreditsettings($get, $post)
{
   if(!API_UPDATECREDITSETTINGS)
   {
    return API_RETURN_FORBIDDEN;
   }
   $credit = $get['credit'];
   $outextcredits = array();
   if($credit && is_array($credit)) {
    foreach($credit as $appid => $credititems) {
     foreach($credititems as $value) {
      if($value['appiddesc']!=UC_APPID) continue;
      $outextcredits[$appid][] = array(
       'appiddesc' => $value['appiddesc'],
       'creditdesc' => $value['creditdesc'],
       'creditsrc' => $value['creditsrc'],
       'title' => $value['title'],
       'unit' => $value['unit'],
       'ratiosrc' => $value['ratiosrc'],
       'ratiodesc' => $value['ratiodesc'],
       'ratio' => $value['ratio']
      );
     }
    }
   }
   $_CACHE = "<?php !defined('UC_API') && exit("403 Forbidden!");n".'$_CACHE['credit'] = unserialize("'.addslashes(serialize($outextcredits)).'");'."rn".'?>';
   $fp = @fopen(DEDEDATA.'/credits.inc.php', 'w');
   @fwrite($fp, $_CACHE);
   @fclose($fp);
   return API_RETURN_SUCCEED;
}
}
function _authcode($string, $operation = 'DECODE', $key = '', $expiry = 0) {
$ckey_length = 4;
$key = md5($key ? $key : UC_KEY);
$keya = md5(substr($key, 0, 16));
$keyb = md5(substr($key, 16, 16));
$keyc = $ckey_length ? ($operation == 'DECODE' ? substr($string, 0, $ckey_length): substr(md5(microtime()), -$ckey_length)) : '';
$cryptkey = $keya.md5($keya.$keyc);
$key_length = strlen($cryptkey);
$string = $operation == 'DECODE' ? base64_decode(substr($string, $ckey_length)) : sprintf('%010d', $expiry ? $expiry + time() : 0).substr(md5($string.$keyb), 0, 16).$string;
$string_length = strlen($string);
$result = '';
$box = range(0, 255);
$rndkey = array();
for($i = 0; $i <= 255; $i++) {
   $rndkey[$i] = ord($cryptkey[$i % $key_length]);
}
for($j = $i = 0; $i < 256; $i++) {
   $j = ($j + $box[$i] + $rndkey[$i]) % 256;
   $tmp = $box[$i];
   $box[$i] = $box[$j];
   $box[$j] = $tmp;
}
for($a = $j = $i = 0; $i < $string_length; $i++) {
   $a = ($a + 1) % 256;
   $j = ($j + $box[$a]) % 256;
   $tmp = $box[$a];
   $box[$a] = $box[$j];
   $box[$j] = $tmp;
   $result .= chr(ord($string[$i]) ^ ($box[($box[$a] + $box[$j]) % 256]));
}
if($operation == 'DECODE') {
   if((substr($result, 0, 10) == 0 || substr($result, 0, 10) - time() > 0) && substr($result, 10, 16) == substr(md5(substr($result, 26).$keyb), 0, 16)) {
    return substr($result, 26);
   } else {
     return '';
    }
} else {
   return $keyc.str_replace('=', '', base64_encode($result));
}
}
function _stripslashes($string) {
if(is_array($string)) {
   foreach($string as $key => $val) {
    $string[$key] = _stripslashes($val);
   }
} else {
   $string = stripslashes($string);
}
return $string;
}
?>