I've just updated everything and now whenever someone posts a thread or reply to the bot, they are getting this at the top of the page when it redirects them back to the thread after posting, any clues?
irst("SELECT threadid FROM post WHERE postid=$newpost[postid]"); $threadinfo[threadid] = $tinfo[threadid]; } $pinfo = $DB_site->query_first("SELECT max(postid) as pid FROM post WHERE threadid={$threadinfo[threadid]}"); $parentid = $pinfo[pid]; $btitle = strlen($newpost['title'])>1 ? addslashes("RE: " . $newpost['title']) : ""; // from functions_newpost.php // ### POST NEW POST ### $DB_site->query(" INSERT INTO " . TABLE_PREFIX . "post (threadid, parentid, title, username, userid, dateline, pagetext, allowsmilie, showsignature, ipaddress, iconid, visible, attach) VALUES ($threadinfo[threadid], $parentid, '" . $btitle . "', '" . addslashes($botname) . "', $botuserid, " . BOTTIME . ", '" . addslashes($botoutput) . "', 1, 1, '" . addslashes("127.0.0.1") . "', $newpost[iconid], 1, 0) "); $botpostid = $DB_site->insert_id(); $DB_site->query(" UPDATE " . TABLE_PREFIX . "forum SET replycount = replycount + 1, lastpost = " . BOTTIME . ", lastposter = '" . addslashes($botname) . "', lastthread = '" . addslashes($threadinfo['title']) . "', lastthreadid = $threadinfo[threadid] WHERE forumid = $foruminfo[forumid] "); $DB_site->query(" UPDATE " . TABLE_PREFIX . "user SET $postsquery lastpost = " . BOTTIME . " WHERE userid = $botuserid "); $DB_site->query("UPDATE " . TABLE_PREFIX . "thread SET replycount=replycount+1, lastpost = " . BOTTIME . ", lastposter = '" . addslashes($botname) . "' WHERE threadid = $threadinfo[threadid] LIMIT 1"); }//end randomcheck } else { //This is the start of the adding when not using the chance of post or if its a threadid in the id list // #### INSERT NEW POST INTO DATABASE ##################################### define("BOTTIME", time()+1); if (!isset($threadinfo["threadid"])) { $tinfo = $DB_site->query_first("SELECT threadid FROM post WHERE postid=$newpost[postid]"); $threadinfo[threadid] = $tinfo[threadid]; } $pinfo = $DB_site->query_first("SELECT max(postid) as pid FROM post WHERE threadid={$threadinfo[threadid]}"); $parentid = $pinfo[pid]; $btitle = strlen($newpost['title'])>1 ? addslashes("RE: " . $newpost['title']) : ""; // from functions_newpost.php // ### POST NEW POST ### $DB_site->query(" INSERT INTO " . TABLE_PREFIX . "post (threadid, parentid, title, username, userid, dateline, pagetext, allowsmilie, showsignature, ipaddress, iconid, visible, attach) VALUES ($threadinfo[threadid], $parentid, '" . $btitle . "', '" . addslashes($botname) . "', $botuserid, " . BOTTIME . ", '" . addslashes($botoutput) . "', 1, 1, '" . addslashes("127.0.0.1") . "', $newpost[iconid], 1, 0) "); $botpostid = $DB_site->insert_id(); $DB_site->query(" UPDATE " . TABLE_PREFIX . "forum SET replycount = replycount + 1, lastpost = " . BOTTIME . ", lastposter = '" . addslashes($botname) . "', lastthread = '" . addslashes($threadinfo['title']) . "', lastthreadid = $threadinfo[threadid] WHERE forumid = $foruminfo[forumid] "); $DB_site->query(" UPDATE " . TABLE_PREFIX . "user SET $postsquery lastpost = " . BOTTIME . " WHERE userid = $botuserid "); $DB_site->query("UPDATE " . TABLE_PREFIX . "thread SET replycount=replycount+1, lastpost = " . BOTTIME . ", lastposter = '" . addslashes($botname) . "' WHERE threadid = $threadinfo[threadid] LIMIT 1"); } } } ?>
EDIT: may not be a complete grab, as i had to get it during the redirect
|