vb.org Archive

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)

Aceman 12-11-2004 10:11 PM

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

AN-net 12-11-2004 11:13 PM

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 12-12-2004 01:03 AM

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 12-12-2004 01:56 AM

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 12-12-2004 11:56 AM

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 12-13-2004 10:32 AM

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 12-13-2004 04:44 PM

change $avurl to this
PHP Code:

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


Aceman 12-13-2004 05:55 PM

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 12-13-2004 10:19 PM

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

AN-net 12-14-2004 12:05 AM

oh woops, it should be this:)
PHP Code:

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



All times are GMT. The time now is 01:41 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01081 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