vb.org Archive - How to create your own vBulletin-powered page! (uses vB templates)

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

- vBulletin 3 Articles (https://vborg.vbsupport.ru/forumdisplay.php?f=187)

- - How to create your own vBulletin-powered page! (uses vB templates) (https://vborg.vbsupport.ru/showthread.php?t=62164)

Quote:

Originally Posted by Lynne (Post 1692069)

Get rid of the ending slash:

PHP Code:


		
			
chdir('/var/www/html/forum');

Got rid of the trailing slash but still no cigar. (I had actually tried this previously as well) :(

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

Quote:

Originally Posted by supergper (Post 1692184)

Got rid of the trailing slash but still no cigar. (I had actually tried this previously as well) :(

OK, I figured out a workaround, however I don't like the workaround. It's trying to add the additional directory to the filepath of the images. So instead of being forum/images/styles/mystyle/misc/header.png for the header, it's looking at forum/directory/images/styles/mystyle/misc/header.png. My workaround is to copy my forum/images directory into the forum/directory/ directory (I know, that's not confusing right :D).

Is there a way to include that images directory some how?

Quote:

Originally Posted by supergper (Post 1692184)

Got rid of the trailing slash but still no cigar. (I had actually tried this previously as well) :(

--------------- Added 23 Dec 2008 at 14:42 ---------------

OK, I figured out a workaround, however I don't like the workaround. It's trying to add the additional directory to the filepath of the images. So instead of being forum/images/styles/mystyle/misc/header.png for the header, it's looking at forum/directory/images/styles/mystyle/misc/header.png. My workaround is to copy my forum/images directory into the forum/directory/ directory (I know, that's not confusing right :D).

Is there a way to include that images directory some how?

Maybe try putting the full path to your images in the stylvars rather then the relative path. vB files are usually not in a subdirectory, so ordinarily the relative path would do.

Quote:

Originally Posted by Digital Jedi (Post 1692473)

Maybe try putting the full path to your images in the stylvars rather then the relative path. vB files are usually not in a subdirectory, so ordinarily the relative path would do.

That makes sense...but where are the stylevars? Is that in the style manager in the Admin Cp, under "All Style Options"? I tired changing all the relative paths to the absolute paths and it quit working for the whole forum :D

Are you putting the literal URL for the paths or the directory path? You would only put the URL complete with the http://

it would be easier to create a symlink

Code:

cd directory

ln -s /home/whatever/www/forum/images

Quote:

Originally Posted by Digital Jedi (Post 1692580)

Are you putting the literal URL for the paths or the directory path? You would only put the URL complete with the http://

Perfect, that worked.

Hello everyone,

I'm a novice PHP and MySQL but have some understanding of how programming languages are supposed to work so based on about 3 days worth of effort, I have built a table in MySQL called 'sales'. This table contains sales data on cars. Now, I'm trying to display this tabular data and picture on a vBulletin powered page as a table but to no avail... I'm getting memory errors... It goes without saying that I copied most of this code from others on this website so have a very limited understanding of many of the concepts. Following is the memory error:

Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 129237044 bytes) in /home/xxxxxxx/public_html/ref.php(64) : eval()'d code on line 18

So, here's my PHP code:

<?php

error_reporting(E_ALL & ~E_NOTICE);

define('NO_REGISTER_GLOBALS', 1);
define('THIS_SCRIPT', 'ref'); // change this depending on your filename

// get special phrase groups
$phrasegroups = array();

// get special data templates from the datastore
$specialtemplates = array();

// pre-cache templates used by all actions
$globaltemplates = array(
'REF',
'REFBODY'
);

$actiontemplates = array();

require_once('./global.php');

if ($vbulletin->userinfo['userid'] == 0)
{
$show['permission_error'] = 1;
eval('print_output("' . fetch_template('STANDARD_ERROR') . '");');
}
elseif (isset($_REQUEST['do']))
// Being passed from a web page
$ref_req = $_GET['mdl'] ;

include("dbinfo.php");

mysql_connect(localhost,$user,$pass);
@mysql_select_db($db) or die( "Unable to select database");

$showlistbits = '';
$altclass = 'alt1';

$query="SELECT * FROM sales WHERE model LIKE '%$ref_req%' ";
$result=mysql_query($query);
$omega = mysql_fetch_array($result);
$num=mysql_numrows($result);
mysql_close();

$i=0;
while ($i < $num)
{
$altclass = ($altclass=='alt1') ? 'alt2' : alt1;
eval('$showlistbits .= "' .fetch_template('REFBODY') . '";');
}

$navbits = array();
$navbits[$parent] = "Sales Table";
$navbits = construct_navbits($navbits);
eval('$navbar = "' . fetch_template('navbar') . '");');
eval('print_output("' . fetch_template('REF') . '");');

?>

Here's the REF template:
$stylevar[htmldoctype]
<html dir="$stylevar[textdirection]" lang="$stylevar[languagecode]">
<head>
$headinclude
<title>$vboptions[bbtitle] - $pagetitle</title>
</head>
<body>
$header
$navbar

<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="1" border="0" width="100%" align="center">
<tr>
<td class="tcat" align="center" colspan="6">Sales Table</td>
</tr>
<tr align="center" bgcolor="#336699">
<th style="width: 81px">Venue</th>
<th style="width: 77px">Cylinders</th>
<th style="width: 77px">Color</th>
<th style="width: 90px">Wheels</th>
<th style="width: 90px">Year</th>
<th style="width: 50px">Pic 1</th>
</tr>
$showlistbits
</table>

$footer
</body>
</html>

Here's the REFBODY template:
<tr>
<td class=$altclass">
$omega[venue]
</td>
<td class=$altclass">
$omega[cyl]
</td>
<td class=$altclass">
$omega[color]
</td>
<td class=$altclass">
$omega[wheel]
</td>
<td class=$altclass">
$omega[year]
</td>
<td class=$altclass">
$omega[pic_1]
</td>
</tr>

Two more things. I have a thumbnail pic and a full-size pic. When the table displays, I want the thumbnail to show but when you click on the thumbnail, I want the full-size pic to display in a new window. BTW, both the thumbnail and the full-size pics are stored on the server directory and not in MySQL. Also, I've noticed some people using conventions like $DB->... These conventions don't work on my server, however, I have verified that PEAR is installed on the server. Any advice in this area will also be greatly appreciated.

BTW, I posted the same information in the regular discussion forum but haven't received any feedback yet.... :(

Thanks in advance for your help.

Shoolace

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

Never mind... figured it out by myself. :) Here's the PHP code that was missing...

$i++;

Thanks

Quote:

Never mind... figured it out by myself. Here's the PHP code that was missing...

$i++;

Thanks

and now it works perfectly? amazing.

Well... :) the table display does work but I had to tweak the two templates. The only big issue for me now is that page navigation doesn't function and/or display on the vBulletin powered page :( I've been working on it all day without *any* success.... :(

amcd,

Your forum is cool and has the navigation setup for custom pages. Would it be possible for you to share your code on how to setup navigation for custom pages? I would really really appreciate it. :)

Thanks,

Shoolace

------------------------------------------------
Never mind... Figured it out again. :)

Shoolace

for the Who's Online modification

Code:

    case 'bugs.php':

        $userinfo['activity'] = 'bugs';

        break;

doesnt seem to exist in my functions_online.php

X vBulletin 3.8.12 by vBS Debug 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_code_printable (1)bbcode_php_printable (6)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (3)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03747 seconds Memory Usage 1,766KB 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_code_printable (1)bbcode_php_printable (6)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (3)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: