[Delphy]

Okay I've been working on the problem of displaying images regardless of whether the first attachment is an image or not.

The solution I came up with is as follows:

- Keeping the existing $threads SQL query, add the following into it: thread.firstpostid
- Add the following:

        $displaythumbs = false;
        $forumids = array(41, 42, 43, 44, 45, 46, 47, 48, 49, 69, 70, 40, 50, 51, 52, 97, 98);
        if (in_array($forumid, $forumids)) {
                $displaythumbs = true;
        }

The numbers indicate which forums you want the attachments to be displayed in - as you can see, multiple forums are ok.

- I have to add 1 extra query per forumdisplay page, which is:

                // Added by Delphy to add proper thumbnails
               if ($displaythumbs == true) {
                        while ($thread = $DB_site->fetch_array($threads))
                        { // AND $counter++<$perpage)
                                $imageposts .= $thread['firstpostid'].",";
                        }

                        if ($imageposts != "") {
                                $imageposts = substr($imageposts, 0, strlen($imageposts) - 1);
                                $sql_images = "SELECT DISTINCT postid,attachmentid FROM attachment WHERE postid IN (0$imageposts) AND thumbnail_dateline > 0";
                                $images = $DB_site->query($sql_images);
                                while ($image = $DB_site->fetch_array($images)) {
                                        $thumbnails[$image[postid]] = $image[attachmentid];
                                }
                                $DB_site->free_result($images);
                                unset($imageposts, $image);
                        }
                }

- Since we've already used a DB_site query, we need to reset the $threads resultset:
Find:

                while ($thread = $DB_site->fetch_array($threads))

Insert in the line above:

                $threads = $DB_site->query($sql_threads);

- Within the main while $thread loop that processes the threadbits, add the following:

                        $thread['attachmentid'] = $thumbnails[$thread['firstpostid']];

The resulting hack can be seen in http://forums.modthesims2.com/forumdisplay.php?f=69

Hope this helps somebody,

Regards
Delphy