vb.org Archive - Question about description

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

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

- - Question about description (https://vborg.vbsupport.ru/showthread.php?t=170375)

Greenwoodi

02-13-2008 10:13 AM

Question about description

Kind all time of day, the guru vBullein's! help to adapt this code
http://www.vbulletin.com/forum/showthread.php?t=103536

in 3.6.8, tried through a plug-in global_start and through parse_templates, but, mistakes fell down.

Thanks!

Opserty

02-13-2008 01:15 PM

Try this in global_start it should work I think:

PHP Code:


		
			
if (THIS_SCRIPT == 'showthread')
{
    $thread_description = $db->query_first("SELECT pagetext
        FROM " . TABLE_PREFIX . "post
        WHERE threadid = $threadid
        ORDER BY postid
        ASC
        LIMIT 1");

    $thread_description['pagetext'] = htmlspecialchars_uni($thread_description['pagetext']);
}

Bearing in mind your running an extra query on every showthread page.

Greenwoodi

02-15-2008 03:26 PM

Works, but, on mail mistakes come:
Invalid SQL:
SELECT pagetext
FROM post
WHERE threadid =
ORDER BY postid
ASC
LIMIT 1;

Error MySQL : 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
'ORDER BY postid
ASC
LIMIT 1' at line 4
Number error : 1064
Date : Wednesday, February 13th 2008 @ 06:39:20 PM

Ideas will be?

Opserty

02-15-2008 03:30 PM

PHP Code:


		
			
if (THIS_SCRIPT == 'showthread')
{
    if(isset($_GET['t']) && (intval($_GET['t']) != 0))
    {
            $thread_description = $db->query_first("SELECT pagetext FROM " . TABLE_PREFIX . "post WHERE threadid = ". intval($_GET['t']) ." ORDER BY postid ASC LIMIT 1");

            $thread_description['pagetext'] = htmlspecialchars_uni($thread_description['pagetext']);    
    }
}

All times are GMT. The time now is 02:17 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.00991 seconds Memory Usage 1,722KB 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_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (4)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 bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: