vb.org Archive - Is it possible to write some PHP inside forum templates?

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

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

- - Is it possible to write some PHP inside forum templates? (https://vborg.vbsupport.ru/showthread.php?t=184643)

ArbuZz

07-07-2008 05:47 PM

Is it possible to write some PHP inside forum templates?

I need to add some extra coding in a custom header that I made for the forum. I need to insert some conditional scripting, which I usually accomplish with PHP. Now is it possible to add some PHP in templates? :confused:

veenuisthebest

07-07-2008 05:53 PM

You cannot use php in the templates. You need to include the php by creating a plugin at the appropriate hook location.

Refer this
http://www.vbulletin.com/docs/html/m..._externalfiles

ArbuZz

07-08-2008 11:03 AM

Ouch...

--------------- Added [DATE]1215518983[/DATE] at [TIME]1215518983[/TIME] ---------------

Not bad. Looks bearable. Thanks for the tip.

ArbuZz

07-10-2008 12:52 PM

I was able to insert some pure PHP things in the header. However I cannot connect to a database, because as soon as I do vBulletin says:

Quote:

Fatal error: Call to a member function query_read_slave() on a non-object in .../forum/index.php on line 413

Although I use my one connection resource :( Isn't it possible to make a separate mysql connection to a different database and still make everything work?

Dismounted

07-10-2008 02:22 PM

As long the MySQL user for vBulletin can access your other database (ie. is on the same server and has SELECT/INSERT/etc. permissions), you can use the "database.table.field" syntax.

PHP Code:


		
			
$vbulletin->db->query_read("
    SELECT *
    FROM database2.table1.fieldA AS fieldA
    WHERE fieldA = $someid
    LIMIT 1
");

ArbuZz

07-11-2008 06:46 AM

Thank you. And is there a place where all db functions of vBulletin are listed?

For example what's wrong with this code:

Quote:

...
require_once('./includes/init.php'); // includes class_core.php
require_once('./includes/class_dm.php'); // for class_dm_user.php
require_once('./includes/class_dm_user.php'); // for user functions
require_once('./includes/functions.php'); // vbsetcookie etc.
require_once('./includes/functions_login.php'); // process login/logout
...
global $vbulletin;
$useridq = $vbulletin->db->query_read("SELECT userid FROM "
. TABLE_PREFIX . "user WHERE username='{$username}'");
if (!$useridq) return $useridq;
$userid = $useridq['userid'];

DB query just returns nothing :( originally $vbulletin->db->query_read was $vbulletin->db->query_first_slave. But it doesn't work either. How can one print out the error if it happened upon query?

Dismounted

07-11-2008 07:01 AM

Just include global.php...In your case, you should use query_first() or query_first_slave(), either will work.

Marco van Herwaarden

07-11-2008 07:03 AM

With a query_read() you will need to use fetch_array() to actually retrieve rows (usually in a loop). If you need a single row, then you can use query_first() or query_first_slave(), these functions will also read the first (and only) row.

ArbuZz

07-11-2008 10:24 AM

Thank you very much for your notes. Actually everything was alright with the query call. It was a Class that I've used that caused the trouble with some ambiguous code. I've turned it off.

All times are GMT. The time now is 09:13 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01032 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 (1)bbcode_php_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (9)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: