足球游戏_中国足彩网￥体育资讯$

这个是通用的整合其它的cms都可以用到的代码。

DEDE 5.5 的注册部分拿来用，可以用来对接其他系统和 DEDE整合

<?php

/*

只需要准备好 $userinfo = array (

"username" => "XXXX",

"password" =>"YYYYY",

"email"=> "KKKKKK",

"mtype" => "企业" ,

);

*/

$charset2 = "gbk";

$link2 = mysql_connect("host","user","password");

mysql_query("set names $charset2,$link2);

$dedeuser = array(

"mtype"=>$userinfo["mtype"],

"userid"=> $userinfo[username],

"userpwd" => $userinfo[password],

"uname" => $userinfo[username],

"sex" => "0",

"email"=>$userinfo[email],

"safequestion"=>0,

"safeanswer" => '',

);

extract($dedeuser,EXTR_PREFIX_ALL,'DEDE');

//会员的默认金币

$dfscores = 0;

$dfmoney = 0;

$dfrank = mysql_fetch_assoc(mysql_query("Select money,scores From i_linkmall_cn.dede_arcrank where rank='10' ",$link2));

if(is_array($dfrank))

{

$dfmoney = $dfrank['money'];

$dfscores = $dfrank['scores'];

}

$jointime = time();

$logintime = time();

$joinip = $_SERVER["REMOTE_ADDR";

$loginip =$_SERVER["REMOTE_ADDR";

$pwd = $DEDE_userpwd;

$spaceSta = ($cfg_mb_spacesta < 0 ? $cfg_mb_spacesta : 0);

$inQuery = "INSERT INTO i_linkmall_cn.dede_member (`mtype` ,`userid` ,`pwd` ,`uname` ,`sex` ,`rank` ,`money` ,`email` ,`scores` ,

`matt`, `spacesta` ,`face`,`safequestion`,`safeanswer` ,`jointime` ,`joinip` ,`logintime` ,`loginip` )

VALUES ('$DEDE_mtype','$DEDE_userid','$pwd','$DEDE_uname','$DEDE_sex','10','$dfmoney','$DEDE_email','$dfscores',

'0','$spaceSta','','$DEDE_safequestion','$DEDE_safeanswer','$jointime','$joinip','$logintime','$loginip'); ";

//print $inQuery;

if(mysql_query($inQuery,$link2) or die(mysql_error()))

{

$mid = mysql_insert_id();

//写入默认会员详细资料

if($DEDE_mtype=='个人')

{

$infosquery = "INSERT INTO i_linkmall_cn.dede_member_person (`mid` , `onlynet` , `sex` , `uname` , `qq` , `msn` , `tel` , `mobile` , `place` , `oldplace` ,

`birthday` , `star` , `income` , `education` , `height` , `bodytype` , `blood` , `vocation` , `smoke` , `marital` , `house` ,

`drink` , `datingtype` , `language` , `nature` , `lovemsg` , `address`,`uptime`)

VALUES ('$mid', '1', '{$DEDE_sex}', '{$DEDE_uname}', '', '', '', '', '0', '0',

'1980-01-01', '1', '0', '0', '160', '0', '0', '0', '0', '0', '0','0', '0', '', '', '', '','0'); ";

$space='person';

}

else if($DEDE_mtype=='企业')

{

$infosquery = "INSERT INTO i_linkmall_cn.dede_member_company(`mid`,`company`,`product`,`place`,`vocation`,`cosize`,`tel`,`fax`,`linkman`,`address`,`mobile`,`email`,`url`,`uptime`,`checked`,`introduce`)

VALUES ('{$mid}','{$DEDE_uname}','product','0','0','0','','','','','','{$DEDE_email}','','0','0',''); ";

$space='company';

}

else

{

$infosquery = '';

$space='person';

}

/** 此处增加不同类别会员的特殊数据处理sql语句 **/

// echo $infosquery;

mysql_query($infosquery,$link2);

//写入默认统计数据

$membertjquery = "INSERT INTO i_linkmall_cn.`dede_member_tj` (`mid`,`article`,`album`,`archives`,`homecount`,`pagecount`,`feedback`,`friend`,`stow`)

VALUES ('$mid','0','0','0','0','0','0','0','0'); ";

mysql_query($membertjquery,$link2);

//写入默认空间配置数据

$spacequery = "Insert Into i_linkmall_cn.`dede_member_space`(`mid` ,`pagesize` ,`matt` ,`spacename` ,`spacelogo` ,`spacestyle`, `sign` ,`spacenews`)

Values('{$mid}','10','0','{$DEDE_uname}的空间','','$space','',''); ";

mysql_query($spacequery,$link2);

}