vb.org Archive - Newbie question returning a var to the postbit template

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

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

- - Newbie question returning a var to the postbit template (https://vborg.vbsupport.ru/showthread.php?t=48133)

moosey

01-25-2003 05:36 PM

Newbie question returning a var to the postbit template

bare with me here guys I've never used PHP strictly perl by trade and I've never hacked VBulletin ether so I'm not sure where to start what I'm trying to do should be simple

Code:

my @types = qw/lscripts presets plugins models/;

my %typeset;



foreach $type (@types) {



        my $sth = $dbh->prepare("SELECT COUNT(*) FROM $type\_download WHERE $type\_author_id=?");

                $sth->execute("$user{'userid'}");

        

    $typeset{"$type"} = $sth->fetchrow;

}

Sorry for the perl i can translate the above into PHP but all I'm looking to do is return the typeset hash so it can be used with in the postbit template

As i say my PHP is limited and my knowledge of VBulletin is basically non existent, can someone point me in the right direction.

Thanks guys.

Xenon

01-26-2003 10:20 AM

you have to edit admin/functions.php and add the code into the getpostbit section.

but i wouldn't do it, because one query per post extra isn't a good hack...

All times are GMT. The time now is 12:37 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01009 seconds Memory Usage 1,707KB 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 (1)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (2)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: