[mtha]

04-11-03 at 11:10 PM Erwin said this in Post #57
Try this code:

Find:

PHP Code:

  $url = str_replace("\"", "", $url); 


Above, add:

PHP Code:

$modforum="xx";
    $DB_site->query("INSERT INTO thread (threadid,title,lastpost,forumid,open,replycount,postusername,postuserid,lastposter,dateline,iconid,visible,attach) VALUES (NULL,'".addslashes(htmlspecialchars($subject))."','".time()."','$modforum','1','0','".addslashes($bbuserinfo[username])."','$bbuserinfo[userid]','".addslashes($bbuserinfo[username])."','".time()."','$iconid','1','0')");
    $threadid=$DB_site->insert_id();
    $DB_site->query("INSERT INTO post (postid,threadid,title,username,userid,dateline,pagetext,allowsmilie,showsignature,ipaddress,iconid,visible) VALUES (NULL,'$threadid','".addslashes(htmlspecialchars($subject))."','$bbuserinfo[username]','$bbuserinfo[userid]','".time()."','".addslashes(parseurl($message))."','$allowsmilie','$signature','$ipaddress','$iconid','1')");
    $DB_site->query("UPDATE forum SET replycount=replycount+1,lastpost='".time()."',lastposter='".addslashes($bbuserinfo[username])."' WHERE forumid='$modforum'"); 


Replace xx with your mod forum.

This is the code I am using.

If you have the LAST TITLE ON FORUM HOME hack, use this code instead (which updates the forum title too).

PHP Code:

$modforum="xx";
    $DB_site->query("INSERT INTO thread (threadid,title,lastpost,forumid,open,replycount,postusername,postuserid,lastposter,dateline,iconid,visible,attach) VALUES (NULL,'".addslashes(htmlspecialchars($subject))."','".time()."','$modforum','1','0','".addslashes($bbuserinfo[username])."','$bbuserinfo[userid]','".addslashes($bbuserinfo[username])."','".time()."','$iconid','1','0')");
    $threadid=$DB_site->insert_id();
    $DB_site->query("INSERT INTO post (postid,threadid,title,username,userid,dateline,pagetext,allowsmilie,showsignature,ipaddress,iconid,visible) VALUES (NULL,'$threadid','".addslashes(htmlspecialchars($subject))."','$bbuserinfo[username]','$bbuserinfo[userid]','".time()."','".addslashes(parseurl($message))."','$allowsmilie','$signature','$ipaddress','$iconid','1')");
    $DB_site->query("UPDATE forum SET replycount=replycount+1,lastpost='".time()."',lastposter='".addslashes($bbuserinfo[username])."',lasttitle='".addslashes(htmlspecialchars($subject))."' WHERE forumid='$modforum'"); 


Again, replace xx with your mod forum.

somehow, the code has a bunch of extra "))"

couldnt get this to work in report.php.
if I remove those extra ), it give me

mysql error number: 1062
mysql error: Duplicate entry '68995' for key 1

where '68995' should be the new postid (which doesnt exist yet)