tommyxv
07-19-2006, 04:19 AM
How can I get a PHP Script to run either on a vBavanced or WebTemplate page?
This is the script
<?php
include(dirname(__FILE__)."/language.php");
include(dirname(__FILE__)."/lib.php");
include(dirname(__FILE__)."/engine_dml.php");
$x = new DataList;
if($HTTP_POST_VARS["Filter_x"] != "" || $HTTP_POST_VARS['CSV_x'] != "")
{
// Query used in filters page and CSV output
$x->Query = "select engine.id as 'Part Number', engine.name as 'Part Name', engine.description as 'Description' from engine";
}
else
{
// Query used in table view
$x->Query = "select engine.id as 'Part Number', engine.name as 'Part Name', engine.description as 'Description' from engine";
}
// handle date sorting correctly
// end of date sorting handler
$x->DataHeight = 150;
$x->AllowSelection = 0;
$x->AllowDelete = 1;
$x->AllowInsert = 1;
$x->AllowUpdate = 1;
$x->AllowFilters = 0;
$x->AllowSavingFilters = 0;
$x->AllowSorting = 1;
$x->AllowNavigation = 1;
$x->AllowPrinting = 1;
$x->AllowCSV = 0;
$x->HideTableView = 0;
$x->RecordsPerPage = 10;
$x->QuickSearch = 3;
$x->QuickSearchText = $Translation["quick search"];
$x->ScriptFileName = "engine_view.php";
$x->TableTitle = "Partnumber";
$x->PrimaryKey = "engine.id";
$x->ColWidth[] = 150;
$x->ColWidth[] = 150;
$x->ColWidth[] = 150;
$x->Template = 'engine_templateTV.html';
$x->SelectedTemplate = 'engine_templateTVS.html';
$x->ShowTableHeader = 1;
$x->ShowRecordSlots = 1;
$x->HighlightColor = '#FFE4E1';
$x->Render();
include(dirname(__FILE__)."/header.php");
echo $x->HTML;
include(dirname(__FILE__)."/footer.php");
?>
This is the script
<?php
include(dirname(__FILE__)."/language.php");
include(dirname(__FILE__)."/lib.php");
include(dirname(__FILE__)."/engine_dml.php");
$x = new DataList;
if($HTTP_POST_VARS["Filter_x"] != "" || $HTTP_POST_VARS['CSV_x'] != "")
{
// Query used in filters page and CSV output
$x->Query = "select engine.id as 'Part Number', engine.name as 'Part Name', engine.description as 'Description' from engine";
}
else
{
// Query used in table view
$x->Query = "select engine.id as 'Part Number', engine.name as 'Part Name', engine.description as 'Description' from engine";
}
// handle date sorting correctly
// end of date sorting handler
$x->DataHeight = 150;
$x->AllowSelection = 0;
$x->AllowDelete = 1;
$x->AllowInsert = 1;
$x->AllowUpdate = 1;
$x->AllowFilters = 0;
$x->AllowSavingFilters = 0;
$x->AllowSorting = 1;
$x->AllowNavigation = 1;
$x->AllowPrinting = 1;
$x->AllowCSV = 0;
$x->HideTableView = 0;
$x->RecordsPerPage = 10;
$x->QuickSearch = 3;
$x->QuickSearchText = $Translation["quick search"];
$x->ScriptFileName = "engine_view.php";
$x->TableTitle = "Partnumber";
$x->PrimaryKey = "engine.id";
$x->ColWidth[] = 150;
$x->ColWidth[] = 150;
$x->ColWidth[] = 150;
$x->Template = 'engine_templateTV.html';
$x->SelectedTemplate = 'engine_templateTVS.html';
$x->ShowTableHeader = 1;
$x->ShowRecordSlots = 1;
$x->HighlightColor = '#FFE4E1';
$x->Render();
include(dirname(__FILE__)."/header.php");
echo $x->HTML;
include(dirname(__FILE__)."/footer.php");
?>