vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   New plugin questions (https://vborg.vbsupport.ru/showthread.php?t=93820)

sifuhall 08-07-2005 11:06 PM
New plugin questions
 
Hello. I am trying to understand the new plugin system and any help will be greatly appreciated.

For my first plugin I wanted to take something I had in the php_start template.

The only purpose of this is to query the db and return the first username where field9 in the userfield table is 'Yes', and then do the same for field10.

In my php_start my code was:

PHP Code:
// MMOTM
$memotmq = $DB_site->query("SELECT u.username, u.userid FROM user u INNER JOIN userfield f ON f.userid = u.userid    AND f.field9='Yes' LIMIT 1");
$memberotm = $DB_site->fetch_array($memotmq);
$modotmq = $DB_site->query("SELECT u.username, u.userid FROM user u INNER JOIN userfield f ON f.userid = u.userid    AND f.field10='Yes' LIMIT 1");
$moderatorotm = $DB_site->fetch_array($modotmq);

unset($memotmq, $modotmq); 
With the old method I just set the vars $mmberotm and $moderatorotm to the values and then reference these vars in the template forum_home.

So to change this to a plugin I would need to make this something like:

PHP Code:
<?xml version="1.0" encoding="ISO-8859-1"?>

<plugins>
    <plugin active="1" devkey="Name" product="vbulletin">
        <title>MMOTM</title>
        <hookname>global_start</hookname>
        <phpcode><![CDATA[//
// START PHP CODE

// MMOTM
$memotmq = $DB_site->query("SELECT u.username, u.userid FROM user u INNER JOIN userfield f ON f.userid = u.userid    AND f.field9='Yes' LIMIT 1");
$memberotm = $DB_site->fetch_array($memotmq);
$modotmq = $DB_site->query("SELECT u.username, u.userid FROM user u INNER JOIN userfield f ON f.userid = u.userid    AND f.field10='Yes' LIMIT 1");
$moderatorotm = $DB_site->fetch_array($modotmq);

unset($memotmq, $modotmq); 

// END PHP CODE
//]]></phpcode>
    </plugin>
</plugins>
Should I use the global_start hook since this will only be displayed on the forum home?

Is $DB_site->query still valid?

Also, will this method of setting the vars then referencing them in the templates still work?

Andreas 08-07-2005 11:20 PM
No, you should not use global_start when this is only being used on Forumhome.

Use forumhome_complete (this Hook gets called just before the FORUMHOME Template gets eval()ed):
PHP Code:
$memberotm = $db->query_first("
    SELECT user.username, user.userid FROM " . TABLE_PREFIX . "user
    LEFT JOIN " . TABLE_PREFIX . "userfield AS userfield ON (userfield.userid=user.userid AND userfield.field9='Yes')
    LIMIT 1
");
$moderatorotm = $db->query_first("
    SELECT user.username, user.userid FROM " . TABLE_PREFIX ." user AS user
    LEFT JOIN " . TABLE_PREFIX . "userfield AS userfield ON (userfield.userid=user.userid AND userfield.field10='Yes')
    LIMIT 1
"); 

sifuhall 08-08-2005 04:14 AM
A million thanks to you KirbyDE!


All times are GMT. The time now is 01:36 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.04104 seconds
  • Memory Usage 1,729KB
  • 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
  • (3)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (3)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