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

[AN-net]

try changing it to:

PHP Code:

// Aceman Thumbnail of attachment on forumdisplay page

if ($forumid==102) { 
    $checkquery=$DB_site->query_first("SELECT postid FROM post WHERE threadid=".intval($thread['threadid'])." AND username='".addslashes($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 


[Sadie Frost]

I get two errors using this code:

Warning: getimagesize(): stream does not support seeking in /path/to/forums

(the line it refers to is $sizes = getimagesize($avurl); )

and

Unable to add cookies, header already sent.

[Aceman]

I no longer get the error message by using the code you indicated above.. (BTW! THANK YOU!) and the forum shows fine.. however no attachments show in the few test threads that I've made by adding..

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

To the threadbit Template.

[Aceman]

I slept on it.. and well as my knowledge of calling variables is alittle lacking when it comes to VBulletin.. I'm currently "stumped".

Anyone have a suggestion? And too be honest.. the forumdisplay.php code (above) doesn't return any errors for me.. but I'm not sure if even that is working properly.

I have considered adding a field to the POST creation page what will allow a member to upload a 80x80 thumbnail they created, and if they don't the server will make one..but I'm not sure which system is best.. I'm going to research using a forum to submit a thread.

Aceman

[Aceman]

I'm going to make a movie.. "Desperately seeking Solution.. "

Do any of you coders out there have a clue why this would not work.. I'm beginning to think the code from forumdisplay.php is not correct.. because when I run a MySQL query : SELECT postid FROM post WHERE threadid="20624" AND username='".addslashes($thread['postusername'])."' ORDER BY dateline ASC

I get an error message.. so I do not think the query has all the threadids..etc..

Aceman

[AN-net]

change $avurl to this

PHP Code:

$avurl="http://www.scifi-meshes.com/forums/attachment.php?postid=" . $checkquery['postid']."; 


[Aceman]

AN-net - The code you indicated seems to be wrong as all the continuing code turns red. Is it possible that their is a " missing or something.. I"m plugging my way through php books at the moment.

Aceman

[Nordinho]

I would be really interested in this one as well...

[AN-net]

oh woops, it should be this

PHP Code:

$avurl="http://www.scifi-meshes.com/forums/attachment.php?postid=" . $checkquery['postid']."";