[kvnband]

For all those wanting moderation, I've got it for ya! The following code places the THREAD into moderation que. It appears to work flawlessly.

in form.php, find

                $DB_site->query("
                                UPDATE " . TABLE_PREFIX . "forum
                                SET replycount = replycount +  1,
                                threadcount = threadcount + 1,
                                lastpost = " . TIMENOW . ",
                                lastposter = '" . addslashes($bbuserinfo['username']) . "',
                                lastthread = '".addslashes(htmlspecialchars($bbuserinfo[username]))." $formtitle',
                                lastthreadid = $thread[threadid]
                                WHERE forumid = $formforumid
                        ");

and delete it. Then find

                $post['postid'] = $DB_site->insert_id();
                $DB_site->query("
                                UPDATE " . TABLE_PREFIX . "thread
                                SET firstpostid = $post[postid]
                                WHERE threadid = $thread[threadid]
                        ");

AFTER, ADD

//Added By Kevin
//Add Thread To Moderation Que

				$DB_site->query("
                        INSERT INTO " . TABLE_PREFIX . "moderation(threadid, postid, type)
                        VALUES
                                ($thread[threadid], $post[postid], 'thread')
                ");
                
//End Added By Kevin

Now, if the thread is in moderation que, you don't want it to show up as visible in your forums, do you? So, in

$DB_site->query("
                        INSERT INTO " . TABLE_PREFIX . "post
                                (threadid, title, username, userid, dateline, pagetext, allowsmilie,
                                 showsignature, iconid, visible)
                        VALUES......addslashes($bbuserinfo['username']) . "', $bbuserinfo[userid], " . TIMENOW . ",
                                 '" . addslashes($formsend) . "', 1, 1,
                                 0, 1)
                ");

at the end there, instead of it being 1, 1, 0, 1, make it 1, 1, 0, 0. Then, right above there, change the numbers at the end of

$DB_site->query("
                                INSERT INTO " . TABLE_PREFIX . "thread(title, lastpost, forumid, open, replycount,
                                postusername, postuserid, lastposter, dateline, iconid, visible, attach)
                                VALUES
                                        (.... " . TIMENOW . ", $formforumid,
                                         0, 0, '" . addslashes($bbuserinfo['username']) . "', $bbuserinfo[userid],
                                         '" . addslashes($bbuserinfo['username']) . "', " . TIMENOW . ", 0, 1, 0)
                        ");

to 0, 0, 0.

I'm sorry if this is confusing...It probably is. But Just wanted to give everyone else a chance to add threads to the moderation que.

Kevin