Attachment-Mod

1:
2:

$db->unbuffered_query("UPDATE bb".$n."_threads SET attachments='$row[attachments]', starttime='$row[starttime]', lastposttime='$row[lastposttime]', starterid='$start[userid]', lastposterid='$lastpost[userid]', starter='".addslashes($starter)."', lastposter='".addslashes($lastposter)."', replycount='$row[posts]' WHERE threadid='$row[threadid]'",1);
  }

1:
2:
3:
4:
5:
6:
7:
8:
9:

/* Recount Replycount for Attachment Hack */  
$threadresult=$db->query("SELECT threadid FROM bb".$n."_threads ORDER BY threadid");
while($threadfound=$db->fetch_array($threadresult))
{
    $postcounting=$db->query_first("SELECT COUNT(postid) FROM bb".$n."_posts WHERE threadid = '$threadfound[threadid]'");
    $postcounting=$postcounting[0];
    if($postcounting!=$threadfound['replycount']) $db->unbuffered_query("UPDATE bb".$n."_threads SET replycount='$postcounting' WHERE threadid='$threadfound[threadid]'");
}
/* Recount Replycount for Attachment Hack */

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:

SQL-DATABASE ERROR

Database error in WoltLab Burning Board (2.1.3): Invalid SQL: SELECT attachmentid FROM bb1_posts WHERE threadid IN (0,719,723,841,4275) AND attachmentid>0 
mysql error: Unknown column 'attachmentid' in 'field list' 
mysql error number: 1054 
mysql version: 3.23.55-Max-log 
php version: 4.3.1 
Date: 24.05.2004 @ 14:23 
Script: /wbb2/acp/threads.php 
Referer: [URL]http://dustman.info/wbb2/acp/threads.php[/URL]

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:

SQL-DATABASE ERROR

Database error in WoltLab Burning Board (2.1.3): Invalid SQL: INSERT INTO bb1_posts (postid,parentpostid,threadid,userid,username,iconid,posttopic, posttime,message,attachmentid,edittime,editorid,editor,editcount,allowsmilies,showsignature,ipaddress,visible,reindex) VALUES (NULL,'0','1469','24','Eintrag-Bot','1','Happy Birthday raynwolff !','1085997965','Hallo raynwolff ! Wir wünschen dir alles Liebe zu Deinem heutigen 28ten Geburtstag. Alles alles Gute und einen schönen Tag wünscht Dir das Forum Team von Unix-Support-Board ! :birthday:','0','0','0','','0','1','1','127.0.0.1','1','0') 
mysql error: Unknown column 'attachmentid' in 'field list' 
mysql error number: 1054 
mysql version: 3.23.55-Max-log 
php version: 4.3.1 
Date: 31.05.2004 @ 12:06 
Script: /wbb213/hmportal.php?sid= 
Referer: