最近的一次应用是基本完成了业务系统，需要整合Discuz进去作为交流版块使用。于是，涉及到用户系统的整合和版面的增删操作。UCenter提供了API进行用户的增删管理，自然可以用，但为了保证用户id的统一性，暴力地绕过了UCenter API，而采用直接操作数据库的方式来完成用户增删，当然版面的增删也是操作数据库来完成。
1、增加用户到Discuz和UCenter的代码- $uid = 100; // 用户编号
- $username = "maple"; // 用户名
- $password = "mypassword"; // 用户密码
- $salt = md5((string)rand()); // 随机字符用于加密
- $password = md5(md5($pwd) . $salt); // 加密后的密码
- $groupid = 10; // 用户组编号
- $timestamp = time(); // 时间戳
- $bbsemail = "i@witmax.cn"; // 注册邮箱，不能重复
- execute_sql("INSERT INTO cdb_members (uid, username, password, secques, gender, adminid, groupid, regip, regdate, lastvisit, lastactivity, posts, credits, email, bday, sigstatus, tpp, ppp, styleid, dateformat, timeformat, showemail, newsletter, invisible, timeoffset) VALUES ('$uid', '$username', '$salt', '$password', '0', '0', '$groupid', 'Manual Acting', '$timestamp', '$timestamp', '$timestamp', '0', '0', '$bbsemail', '0000-00-00', '0', '0', '0', '0', '0', 'H:i', '1', '1', '0', '8')");
- execute_sql("INSERT INTO cdb_memberfields (uid) VALUES ('$uid')");
- execute_sql("INSERT INTO `cdb_uc_members` SET uid='$uid', username='$username', password='$password', email='$bbsemail', regip='Manual Acting', regdate='$timestamp', salt='$salt'");
- $uid = 100; // 要删除的用户编号
- execute_sql("DELETE FROM `cdb_members` WHERE uid=$uid");
- execute_sql("DELETE FROM `cdb_memberfields` WHERE uid=$uid");
- execute_sql("DELETE FROM `cdb_uc_members` WHERE uid=$uid");
- execute_sql("DELETE FROM `cdb_uc_memberfields` WHERE uid=$uid");
- $uid = 100; // 版主用户编号
- $fid = 100; // 版面编号，需要保证不与现有版面编号重复
- $forum_name = "Test Forum"; // 版面名称
- execute_sql("INSERT INTO `cdb_forums` (`fid`, `fup`, `type`, `name`, `status`, `displayorder`, `styleid`, `threads`, `posts`, `todayposts`, `lastpost`, `allowsmilies`, `allowhtml`, `allowbbcode`, `allowimgcode`, `allowmediacode`, `allowanonymous`, `allowshare`, `allowpostspecial`, `allowspecialonly`, `alloweditrules`, `allowfeed`, `recyclebin`, `modnewposts`, `jammer`, `disablewatermark`, `inheritedmod`, `autoclose`, `forumcolumns`, `threadcaches`, `alloweditpost`, `simple`, `modworks`, `allowTAG`, `allowglobalstick`) VALUES
- ('$fid', 3, 'forum', '$forum_name', 1, 0, 0, 0, 0, 0, '', 1, 0, 1, 1, 1, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1);");
- execute_sql("INSERT INTO `cdb_forumfields` (`fid`, `description`, `password`, `icon`, `postcredits`, `replycredits`, `getattachcredits`, `postattachcredits`, `digestcredits`, `redirect`, `attachextensions`, `formulaperm`, `moderators`, `rules`, `threadtypes`, `threadsorts`, `viewperm`, `postperm`, `replyperm`, `getattachperm`, `postattachperm`, `keywords`, `supe_pushsetting`, `modrecommend`, `tradetypes`, `typemodels`, `threadplugin`, `extra`) VALUES ('$fid', '', '', '', '', '', '', '', '', '', '', 'a:5:{i:0;s:0:"";i:1;s:0:"";s:5:"medal";N;s:7:"message";s:0:"";s:5:"users";s:0:"";}', '', '', '', '', ' 9 10 11 12 13 14 15 20 21 16 17 18 19 1 2 3 4 5 6 7 8 ', ' 20 21 1 2 3 ', ' 20 21 1 2 3 ', ' 20 21 1 2 3 ', ' 20 21 1 2 3 ', '', '', 'a:8:{s:4:"open";s:1:"0";s:3:"num";i:10;s:8:"imagenum";i:5;s:10:"imagewidth";i:200;s:11:"imageheight";i:150;s:9:"maxlength";i:0;s:9:"cachelife";i:900;s:8:"dateline";i:0;}', '', '', 'N;', 'a:1:{s:9:"namecolor";s:0:"";}');");
- execute_sql("UPDATE cdb_members SET adminid='3' WHERE uid='$uid'");
- execute_sql("INSERT INTO cdb_moderators (uid, fid, inherited) VALUES ('$uid', '$fid', '1')");
- $uid = 100; // 要删除版面的版主用户编号
- $fid = 100; // 要删除的版面编号
- execute_sql("DELETE FROM cdb_forums WHERE fid='$fid'");
- execute_sql("DELETE FROM cdb_forumfields WHERE fid='$fid'");
- execute_sql("DELETE FROM cdb_moderators WHERE fid='$fid'");
- execute_sql("UPDATE cdb_members SET adminid='0' WHERE uid='$uid'");
|
37700
0
©2015-2022 www.tuyuanma.com 版权所有 Sitemap.xml
提升卡
置顶卡
沉默卡
变色卡
千斤顶
赣公网安备36112102000036号
赣ICP备17001544号-10