vb.org Archive

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 01:42 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.01015 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