New thread on Reg ... hilfe gesucht

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:

Neuer Beitrag für Neuen User 
        $row=$db->query_first("SELECT * FROM bb".$n."_newthread_reg where id='1'");
        $user_info_thread=$db->query_first("SELECT * FROM bb".$n."_users WHERE userid='".$result['userid']."'");
        $newthread_auslesung_TBL=$db->query_first("SELECT * FROM bb".$n."_newthread_reg");
        $query1="SELECT * from bb".$n."_newthread_reg";
        $result1=mysql_query($query1);
        while($row1=mysql_fetch_array($result1)){
          $message_newthread=$row1[text];
          $message_newthread=str_replace("{username}","$user_info_thread[username]",$message_newthread);
          $message_newthread=str_replace("{boardname}","$master_board_name",$message_newthread);
          $message_newthread=str_replace(" ","",$message_newthread);
        }
        $subject_newthread=$newthread_auslesung_TBL[title];
        $subject_newthread=str_replace("{username}","$user_info_thread[username]",$subject_newthread);
        $subject_newthread=str_replace("{boardname}","$master_board_name",$subject_newthread);
        $subject_newthread=str_replace("'","",$subject_newthread);
        $thread_Sende_ID=$newthread_auslesung_TBL[sendnickid];
        $sendnickn=$db->query_first("SELECT * FROM bb".$n."_users WHERE userid='$thread_Sende_ID'");
        $thread_Sende_Nick=$sendnickn[username];
        $Icon_ID=$newthread_auslesung_TBL[iconid];
        $board_ID_thread=$newthread_auslesung_TBL[boardid];
        $row=$db->query_first("SELECT * FROM bb".$n."_boards WHERE boardid='$board_ID_thread'");
        $db->unbuffered_query("INSERT INTO bb".$n."_threads (threadid,boardid,prefix,topic,iconid,starttime,starterid,starter,lastposttime,lastposterid,lastposter,views,closed,voted,votepoints,attachments,pollid,important,visible) VALUES (NULL,'$board_ID_thread','','$subject_newthread','$Icon_ID','".time()."','$thread_Sende_ID','$thread_Sende_Nick','".time()."','$thread_Sende_ID','$thread_Sende_Nick','0','0','0','0','0','0','0','1')");
        $threadid=$db->insert_id();
        $db->unbuffered_query("INSERT INTO bb".$n."_posts (postid,parentpostid,threadid,userid,username,iconid,posttopic, posttime,message,attachmentid,edittime,editorid,editor,editcount,allowsmilies,showsignature,ipaddress,visible,reindex) VALUES (NULL,'0','$threadid','$thread_Sende_ID','".addslashes($thread_Sende_Nick)."','$Icon_ID','$subject_newthread','".time()."','".addslashes($message_newthread)."','0','0','0','','0','1','1','127.0.0.1','1','0')");
        $Aktuelle_UNIX_Zeit=time();
        $db->unbuffered_query("UPDATE bb".$n."_boards SET threadcount=threadcount+1, postcount=postcount+1, lastthreadid='$threadid', lastposttime='$Aktuelle_UNIX_Zeit', lastposterid='$thread_Sende_ID', lastposter='$thread_Sende_Nick' WHERE boardid IN ($row[parentlist],$board_ID_thread)",1);
        $db->unbuffered_query("UPDATE bb".$n."_newthread_geb SET datum='$date'");
        list($threadcount)=$db->query_first("SELECT COUNT(*) FROM bb".$n."_threads WHERE closed<>3 AND visible=1");
        list($postcount)=$db->query_first("SELECT COUNT(*) FROM bb".$n."_posts WHERE visible=1");
        $db->unbuffered_query("UPDATE bb".$n."_stats SET threadcount='".$threadcount."', postcount='".$postcount."'",1);
        if($row['countuserposts']==1){
          list($rankid)=$db->query_first("SELECT rankid FROM bb".$n."_ranks WHERE groupid IN ('0','$sendnickn[rankgroupid]') AND needposts<='$sendnickn[userposts]' AND gender IN ('0','$sendnickn[gender]') ORDER BY needposts DESC, gender DESC",1);
          $db->unbuffered_query("UPDATE bb".$n."_users SET userposts=userposts+1".(($rankid!=$sendnickn['rankid']) ? (", rankid='$rankid'") : (""))." WHERE userid = '$thread_Sende_ID'",1);
          $pm_aktiv_or_not=$db->query_first("SELECT pm FROM bb".$n."_newthread_geb");
          if($pm_aktiv_or_not['pm']=="1"){
            $db->unbuffered_query("INSERT INTO bb".$n."_privatemessage (senderid,recipientid,subject,message,sendtime,allowsmilies,allowhtml,allowbbcode,allowimages,showsignature,iconid,deletepm,tracking) VALUES ('$thread_Sende_ID','$user_info_thread[userid]','".addslashes($subject_newthread)."','".addslashes($message_newthread)."','$Aktuelle_UNIX_Zeit','1','0','1','1','1','$Icon_ID','0','0')",1);
            if($user_info_thread['pmpopup']==1) $db->unbuffered_query("UPDATE bb".$n."_users SET pmpopup=2 WHERE userid='$user_info_thread[userid]'",1);
            if($user_info_thread['emailonpm']==1){
              $lang->load("MAIL");
              $master_board_name_email = getlangvar($o_master_board_name, $lang, 0);
              eval ("\$mail_text = \"".$lang->get4eval("LANG_MAIL_NEWPM_TEXT")."\";");
              eval ("\$mail_subject = \"".$lang->get4eval("LANG_MAIL_NEWPM_SUBJECT")."\";");
              mailer($user_info_thread['email'],$mail_subject,$mail_text);
            }
          }
        }