Im working on a new hack, take a look.

[Slynderdale]

I'm working on a new hack, if people like it, ill release it when its done, the attachment is self explanatory.

[Slynderdale]

So far heres my current admin options for it.

[Slynderdale]

Heres when you post.

[Slynderdale]

Heres the error screen when one of the attachments gets an error.

[Slynderdale]

Heres a screen shot of multiple attachments on multiple posts.

[Smoothie]

I'm liking it....

[Slynderdale]

On average it only adds one or two extra queries to the showthread page and the others so it isnt querie extensive.

[Smoothie]

Looks awesome. Would like to see the final query count.

[Slynderdale]

So far from the pictures you saw, i only added one extra query to show thread

PHP Code:

$posts=$DB_site->query("
SELECT
post.*,post.username AS postusername,post.attachmentid AS postattachmentid,post.ipaddress AS ip,user.*,userfield.*,".iif($forum[allowicons],'icon.title as icontitle,icon.iconpath,','')."
attachment.attachmentid,attachment.filename,attachment.visible AS attachmentvisible,attachment.counter
".iif($avatarenabled,",avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline","")."
FROM post
".iif($forum[allowicons],'LEFT JOIN icon ON icon.iconid=post.iconid','')."
LEFT JOIN user ON user.userid=post.userid
LEFT JOIN userfield ON userfield.userid=user.userid
".iif ($avatarenabled,"LEFT JOIN avatar ON avatar.avatarid=user.avatarid
                       LEFT JOIN customavatar ON customavatar.userid=user.userid","")."
LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
WHERE $postids
ORDER BY dateline $postorder
");
                   
if (!$getperms['cangetattachment']) {
    $viewattachedimages=0;
}

$postbits = '';
$counter=0;
$postdone = array();
$sigcache = array();
$attachmentid=$DB_site->query("SELECT attachmentid,filename,visible,counter FROM attachment");
 while ($attachmentbit=$DB_site->fetch_array($attachmentid)) {
   $attach_id[$attachmentbit['attachmentid']] = $attachmentbit['attachmentid'];
   $attach_filename[$attachmentbit['attachmentid']] =  $attachmentbit['filename'];
   $attach_visible[$attachmentbit['attachmentid']] =  $attachmentbit['visible'];
   $attach_counter[$attachmentbit['attachmentid']] =  $attachmentbit['counter']; 
} 


[Slynderdale]

This query

PHP Code:

$postbits = '';
$counter=0;
$postdone = array();
$sigcache = array();
$attachmentid=$DB_site->query("SELECT attachmentid,filename,visible,counter FROM attachment");
 while ($attachmentbit=$DB_site->fetch_array($attachmentid)) {
   $attach_id[$attachmentbit['attachmentid']] = $attachmentbit['attachmentid'];
   $attach_filename[$attachmentbit['attachmentid']] =  $attachmentbit['filename'];
   $attach_visible[$attachmentbit['attachmentid']] =  $attachmentbit['visible'];
   $attach_counter[$attachmentbit['attachmentid']] =  $attachmentbit['counter']; 
} 


the rest is php script, i havnt noticed any speed change when the forum loads even when the page has 100 posts.