1st Attachment of thread shown on Forum Summary Page.

[Aceman]

I am attempting to code a hack that will do the following:

Basic (version 1 hopes)
1. Post the first attachment (graphic) of a thread ON the forum summary page. A more advanced example of what I hope to accomplish is found at cgtalk (here) but I am unable to get in contact with their web admin to find out how they did it. So I am attempting to do it myself.

At present I have added the following code (NOT WORKING) to my forumdisplay.php file.

// Aceman Thumbnail of attachment on forumdisplay page

if ($forumid==102) { 
    $checkquery=$DB_site->query("SELECT postid FROM post WHERE threadid=$thread[threadid] and username='$thread[postusername]' ORDER BY dateline ASC"); 
    $avurl="http://www.scifi-meshes.com/forums/attachment.php?postid=" . $checkquery['postid']; 
    $sizes = getimagesize($avurl); 
    if ($sizes) { 
        $newwidth=$sizes[0]; 
        $newheight=$sizes[1]; 
        if ($sizes[0] > 100) { 
            $newwidth=100; 
            $diff=$sizes[0]-100; 
            $rat=100/$sizes[0]; 
            $newheight=$sizes[1]*$rat; 
        } 
        $imagethumb="<img src=\"./attachment.php?postid=" . $checkquery['postid'] . "\" width=" . $newwidth . " height=" . $newheight . "><br>"; 
    } 
} 
// END Aceman Hack

FORUMID 102 is because I ONLY want this to show for THIS FORUM.. no where else on my site.

However this code returns the following mysql error message:
Invalid SQL: SELECT postid FROM post WHERE threadid = LIMIT 1
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 1' at line 1

In threadbit TEMPLATE I put in the following code:

	<if condition=" forumid == 102 ">
	<!-- ACEMAN HACK -->
	<td class="alt1Active" align="$categoryalign" nowrap="nowrap">$imagethumb</td>
	<!-- END ACEMAN HACK -->
	</if>

I think it is important to NOTE that I pull ALOT of this code from several VERY OLD threads which you can read here.

https://vborg.vbsupport.ru/archive/i...p/t-70628.html

AND

http://www.vbulletin.com/forum/showthread.php?t=118083

IF you can help me I would GREATLY APPRECIATE IT!

Aceman