The Arcive of Official vBulletin Modifications Site.

Logician · #11 02-18-2003, 12:59 PM

2 alternatives:
1- use this in phpinclude template:

PHP Code:


			
$file4=include("/home/virtual/powwows.com/var/www/html/ssi/shop.php");

and use $file4 in any template you want
BUT
in this case you must hack your shop.php too and make sure it RETURNs its output like a function (otherwise you'll get value "1" from the script instead of code itself)

2- Add your

PHP Code:


			
include("/home/virtual/powwows.com/var/www/html/ssi/shop.php");

to another template and change its parsing inside vb with this line:

PHP Code:


			
eval(gettemplate('templatename',0,0));

Well you'll still have problems pasting the content in the location you like via this method because this line might immediately start HTML output so I suggest go with first solution..

Alternatively you can dump your shop.php script and create a in-vb code which will randomly get an item from database which is certainly the best solution if your shop.php is not performing other complicated tasks..

pgowder · #12 02-18-2003, 01:37 PM

Quote:

Originally posted by Logician

Alternatively you can dump your shop.php script and create a in-vb code which will randomly get an item from database which is certainly the best solution if your shop.php is not performing other complicated tasks..

No, it just selects a record at random.

How do you create this script in vb code?

Dominick · #13 02-19-2003, 07:54 PM

the real basics

global php in forum root is where you would call all globally available functions.

function.php would call functions specific to a template

IE the eval statements that usually have a gettemplate command attached

pgowder · #14 02-19-2003, 07:59 PM

Ok, so here's one of the places I get confused.

What goes in the template and what goes in a seperate php file.

Here is the source of the php that I'm trying to use in vb.

PHP Code:


			
<table width="95%" border="0" cellpadding="0" cellspacing="0" align="center">

  <tr>

    <td width="14"><img src="http://www.powwows.com/images/tables/blue/sTable_TopLeft.gif" width="14" height="10" alt=""></td>

    <td background="http://www.powwows.com/images/tables/blue/sTable_Top.gif"><img src="http://www.powwows.com/images/tables/blue/sTable_Top.gif" width="20" height="10" alt=""></td>

    <td width="14"><img src="http://www.powwows.com/images/tables/blue/sTable_TopRight.gif" width="14" height="10" alt=""></td>

  </tr>



<tr>

    <td width="14" background="http://www.powwows.com/images/tables/blue/sTable_Left.gif" bgcolor="#000066"><img src="http://www.powwows.com/images/tables/blue/sTable_Left.gif" width="14" height="20" alt=""></td>

    <td valign="top" align="center" bgcolor="#000066"><a href="http://www.powwows.com/shop"><font face=Verdana size="-1" color="#ffff00"><b>Pow Wow Shop</b></font></font></td>

    <td width="14" background="http://www.powwows.com/images/tables/blue/sTable_Right.gif" bgcolor="#000066"><img src="http://www.powwows.com/images/tables/blue/sTable_Right.gif" width="14" height="20" alt=""></td>

  </tr>



<tr>

    <td width="14" background="http://www.powwows.com/images/tables/white/sTable_Left.gif"><img src="http://www.powwows.com/images/tables/white/sTable_Left.gif" width="14" height="20" alt=""></td>

    <td bgcolor="#FFFFFF" algin="center">

<center>

<br>



<?php



$db_server = "localhost"; //database server

$db_user = ""; //database user

$db_pass = ""; //database password

$db_name = ""; //database name

$domain_name = "www.powwows.com"; 

$catalog_folder_name = "shop"; 

$site_title = "PowWows.com"; 

$image_width = "100"; 

$image_height = "100";

$num_products = "18"; 

$prod_col = "3"; 

$table_width = "95";

$table_align = "center";

$table_cspace = "0"; 

$table_cpadd = "0"; 

$product_price_show = "0"; 

$product_image_show = "1"; 

$product_info_link_show = "1";

$product_buy_link_show = "1"; 

$product_name_show = "1";



?>



<?php



// create connection

$connection = mysql_connect("$db_server","$db_user","$db_pass")

    or die("Couldn't make connection.");



// select database

$db = mysql_select_db("$db_name", $connection)

    or die("Couldn't select database.");



// create SQL statement

$sql = 'SELECT * FROM `products` WHERE products_status = \'1\' AND products_image != \'ARRAY\' ORDER BY RAND( ) LIMIT 1';

// execute SQL query and get result

$sql_result = mysql_query($sql,$connection)

    or die("Couldn't execute quasery.");



// format results by row

$row = mysql_fetch_array($sql_result);



$products_id = $row["products_id"];

$products_price = $row["products_price"];

$products_model = $row["products_model"];

$products_image = $row["products_image"];



$sql2 = "SELECT `products_name` FROM `products_description` WHERE products_id = '$products_id' LIMIT 1";

$sql2_result = mysql_query($sql2,$connection)

    or die("Couldn't execute query.");

$row2 = mysql_fetch_array($sql2_result);



$products_name = $row2["products_name"];

$products_image_replace = str_replace("./", "/", $products_image);

$products_price_replace = str_replace(".0000", "", $products_price);



if ($product_info_link_show == "1") {

echo "<a href=\"http://$domain_name/$catalog_folder_name/product_info.php?products_id=$products_id\" style=\"text-decoration: none\">";

}

if ($product_image_show == "1") {

echo "<img src=\"http://$domain_name/$catalog_folder_name/images/$products_image_replace\" width=\"$image_width\" border=\"0\"><br>";

}

echo "<font face=\"Verdana\" size=\"-2\" color=\"#000066\"><b>";

if ($product_name_show == "1") {

echo "$products_name";

}

if ($product_price_show == "1") {

echo "&nbsp; \$$products_price_replace";

}

echo "</b></font>";

if ($product_info_link_show == "1") {

echo "</a>";

}

//if ($product_buy_link_show == "1") {

//echo "<br><a href=\"http://$domain_name/$catalog_folder_name/product_info.php?products_id=$products_id\"><font face=\"Verdana, Tahoma\" size=\"-1\" color=\"#000000\"><b>Buy Now</b></font></a></td>";

//}

?>

</td>

<td width="14" background="http://www.powwows.com/images/tables/white/sTable_Right.gif" bgcolor="#ffffff"><img src="http://www.powwows.com/images/tables/white/sTable_Right.gif" width="14" height="20" alt=""></td>

</tr>





<tr>

    <td width="14" background="http://www.powwows.com/images/tables/blue/sTable_Left.gif" bgcolor="#000066"><img src="http://www.powwows.com/images/tables/blue/sTable_Left.gif" width="14" height="20" alt=""></td>

    <td valign="top" align="center" bgcolor="#000066">

    <?

    if ($product_buy_link_show == "1") {

    echo "<a href=\"http://$domain_name/$catalog_folder_name/product_info.php?products_id=$products_id\"><font face=\"Verdana, Tahoma\" size=\"-1\" color=\"#ffff00\"><b>Buy Now</b></font></a></td>";

    }

    ?>

    </td>

    <td width="14" background="http://www.powwows.com/images/tables/blue/sTable_Right.gif" bgcolor="#000066"><img src="http://www.powwows.com/images/tables/blue/sTable_Right.gif" width="14" height="20" alt=""></td>

  </tr>







<?

// free resources and close connection

mysql_free_result($sql_result);

mysql_close($connection);

?>

</center>







<tr>

    <td width="14"><img src="http://www.powwows.com/images/tables/blue/sTable_BottomLeft.gif" width="14" height="10" alt=""></td>

    <td background="http://www.powwows.com/images/tables/blue/sTable_Bottom.gif"><img src="http://www.powwows.com/images/tables/blue/sTable_Bottom.gif" width="20" height="10" alt=""></td>

    <td width="14"><img src="http://www.powwows.com/images/tables/blue/sTable_BottomRight.gif" width="14" height="10" alt=""></td>

  </tr>

</table>

</center>

Dean C · #15 02-20-2003, 08:30 AM

Instead of having html called by the php file. Create a template in the admin cp and call it by using this function:

PHP Code:


			
eval("dooutput(\"".gettemplate('templatename')."\");");

Use templates in all sorts of places where you have if statements and replace the html in the if statements with a template call. Then place the html in the template.

Then any html you want outputted on one page call the template right at the end of the php file. And you can use the variable you assigned earlier in the script to put it on the page.

E.g.

PHP Code:


			
<?



if ($bbuserinfo[posts]>10) {

eval("\$minposts = \"".gettemplate('minposts')."\";");

}



eval("dooutput(\"".gettemplate('mainhtml')."\");");



?>

Your main template:

PHP Code:


			
<!-- this will be the mainhtml template as it will be called straight away -->

<b>Hello User</b><br />

<!-- Min posts bit -->

$minposts

Now minposts has been called before the final template so you can use the variable to call the minposts template. If the user has less than 80 posts it will output the template 'minposts'. Else it won't.

Just as the script does

- miSt

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04039 seconds Memory Usage 2,246KB Queries Executed 11 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)ad_showthread_firstpost (1)ad_showthread_firstpost_sig (1)ad_showthread_firstpost_start (7)bbcode_php (1)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (5)post_thanks_box (5)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (5)post_thanks_postbit_info (5)postbit (5)postbit_onlinestatus (5)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.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 showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!