Here is my implementation:
1. insert a column named uid_r into xoops_bb_posts to backup the poster's uid
le="color: #000000"><?php ALTER TABLE `xoops_bb_posts` ADD `uid_r` INT UNSIGNED DEFAULT '0' NOT NULL AFTER `uid` ;
2. modify xoops/modules/newbb/post.php -> record id in uid_r whenever the anonymous option checked
le="color: #000000"><?php --- post.php.orig 2006-08-15 20:13:58.000000000 +0800 +++ post.php 2006-08-15 20:15:59.000000000 +0800 @@ -173,9 +173,11 @@ $isnew = 1; if ( is_object($xoopsUser) && empty($_POST['noname']) ) { $uid = $xoopsUser->getVar("uid"); + $uid_r = 0; } else { $uid = 0; + $uid_r = $xoopsUser->getVar("uid"); } if (isset($pid) && $pid != "") { $forumpost->setVar('pid', $pid); @@ -187,6 +189,7 @@ //$post_ip = (isset($_SERVER['HTTP_X_FORWARDED_FOR']))?$_SERVER['HTTP_X_FORWARDED_FOR']:$_SERVER['REMOTE_ADDR']; $forumpost->setVar('poster_ip', newbb_getIP()); $forumpost->setVar('uid', $uid); + $forumpost->setVar('uid_r', $uid_r); } if($topic_handler->getPermission($forum, $topic_status, 'noapprove')) $approved = 1; @@ -453,4 +456,4 @@ include XOOPS_ROOT_PATH.'/footer.php'; -?> No newline at end of file +?>
3. modify xoops/modules/newbb/class/post.php -> write uid_r into database
le="color: #000000"><?php --- post.php.orig 2006-08-15 20:14:08.000000000 +0800 +++ post.php 2006-08-15 20:18:14.000000000 +0800 @@ -44,6 +44,7 @@ $this->initVar('dosmiley', XOBJ_DTYPE_INT, 1); $this->initVar('doxcode', XOBJ_DTYPE_INT, 1); $this->initVar('uid', XOBJ_DTYPE_INT, 1); + $this->initVar('uid_r', XOBJ_DTYPE_INT, 1); $this->initVar('icon', XOBJ_DTYPE_TXTBOX); $this->initVar('attachsig', XOBJ_DTYPE_INT); $this->initVar('approved', XOBJ_DTYPE_INT, 1); @@ -633,9 +634,9 @@ $post_id = $this->db->genId($this->db->prefix("bb_posts") . "_post_id_seq"); $sql = "INSERT INTO " . $this->db->prefix("bb_posts") . " - ( post_id, pid, topic_id, forum_id, post_time, uid, poster_ip, poster_name, subject, dohtml, dosmiley, doxcode, doimage, dobr, icon, attachsig, attachment, approved, post_karma, require_reply) VALUES - ($post_id, $pid, $topic_id, $forum_id, $post_time, $uid, $poster_ip, $poster_name, $subject, $dohtml, $dosmiley, $doxcode, $doimage, $dobr, $icon, $attachsig, $attachment, $approved, $post_karma, $require_reply)"; + ($post_id, $pid, $topic_id, $forum_id, $post_time, $uid, $uid_r, $poster_ip, $poster_name, $subject, $dohtml, $dosmiley, $doxcode, $doimage, $dobr, $icon, $attachsig, $attachment, $approved, $post_karma, $require_reply)"; if (!$result = $this->db->queryF($sql)) { newbb_message("Insert post error:" . $sql); @@ -897,4 +898,4 @@ } } -?> No newline at end of file +?>
so that only admin with right reading database would know who the original poster is
