vb.org Archive - 1st Attachment of thread shown on Forum Summary Page.

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - 1st Attachment of thread shown on Forum Summary Page. (https://vborg.vbsupport.ru/showthread.php?t=72780)

1st Attachment of thread shown on Forum Summary Page.

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.

Code:

// 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:

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

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

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.

:(

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 ">

<td class="alt1Active" align="$categoryalign" nowrap="nowrap">$imagethumb</td>

</if>

To the threadbit Template.

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

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

change $avurl to this

PHP Code:


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

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

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

oh woops, it should be this:)

PHP Code:


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

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (3)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01000 seconds Memory Usage 1,756KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (3)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: