You need to add the following in the PHP part of the template:

dbconnect();

$query = DBQuery(“SELECT page_text from esselbach_st_pages WHERE page_id = ‘1’”);

list($page) = mysql_fetch_row($query);

The HTML of page 1 is now in $page

dbconnect();

$query = DBQuery(“SELECT page_text from esselbach_st_pages WHERE page_id = ‘1’”);

list($page) = mysql_fetch_row($query);

Try turning the cache on. This should help a little.

Unfortunately, Windows is not the perfect platform for PHP applications. You could also enhance the overall PHP performance with an accelerator such as eAccelerator.

A Windows port of eAccelerator is available here:
 http://www.future-tense.org/eaccelerator/

Originally posted by Rushian:
Lastly, how can I insert an already-created static HTML page into a template? I have a standalone HTML page with release dates in it that I want inserted into the site footer (which will actually be in the 'right menu'.) How is that done as well?


Here the code:

<?php
global $insert;

$htmlfile = "myfile.html";
$htmlopen = fopen($htmlfile,"r");
$myhtmlfile = fread($htmlopen, filesize($htmlfile));
fclose($htmlopen);


This will copy the content of your HTML page to the variable $myhtmlfile. You need to replace myfile.html with the file name of your HTML page.

How do I get more whitespace between by left menu and the news items (or the rest of the modules I guess) on the page? It looks about 8 pixels now, and I'd like 20-30 pixels.

I'm hoping I can do it in the site header template, and not have to edit each module template individually!

                      <td>& nbsp;</td>

                  <td valign="top" width="85%">

                   $insert[login_header]

Also, I need a way to get a new bottom block of HTML (ie, not a link list) on only the newspage, so I can't use the site footer.. Can this be done?

<?php

global $insert;



if (preg_match("/index/", $_SERVER[PHP_SELF]))

{

$myhtml = "Some HTML code here";

}



$EST_TEMPLATE = <<<TEMPLATE



<!-- Template site_footer -->

Lastly, how can I insert an already-created static HTML page into a template? I have a standalone HTML page with release dates in it that I want inserted into the site footer (which will actually be in the 'right menu'.) How is that done as well?

<?php

global $insert;



$htmlfile = "myfile.html";

$htmlopen = fopen($htmlfile,"r");

$myhtmlfile = fread($htmlopen, filesize($htmlfile));

fclose($htmlopen);