//
// +----------------------------------------------------------------------+
// | MoleCMS |
// +----------------------------------------------------------------------+
// | Copyright (c) 2000-2002 MoleManMedia Tim Franz |
// +----------------------------------------------------------------------+
// | Authors: Tim Franz <*****@*****.**> |
// +----------------------------------------------------------------------+
//
// $Id: search.php,v 1.1 2002/08/07 09:25:43 moleman Exp $
//phpinfo();
include_once 'sqlquery.inc';
$fields = array("name", "ort", "land");
$map_cols = array("name" => $lang->translate('company_name'), "ort" => $lang->translate('city'), "land" => $lang->translate('country'));
if (!isset($sql)) {
$sql = new Sql_Query();
$sql->conditions = 1;
$sql->method = 'get';
$sql->translate = "on";
$sql->container = "on";
$sql->variable = "on";
$sql->module = 'company';
$sql->action = 'search';
$sql->lang = LC_LANG;
}
if (isset($x)) {
$abfrage = $sql->where("x", 1);
$from = 0;
}
$tpl->setVariable("UEBERSCHRIFT", $GLOBALS['str_companysearch']);
$content["ABFRAGEBOX"] = $sql->form("x", $map_cols, "searchbox", url(array('module' => 'company', 'action' => 'search')));
// +----------------------------------------------------------------------+
// | MoleCMS |
// +----------------------------------------------------------------------+
// | Copyright (c) 2000-2002 MoleManMedia Tim Franz |
// +----------------------------------------------------------------------+
// | Authors: Tim Franz <*****@*****.**> |
// +----------------------------------------------------------------------+
//
// $Id: search.php,v 1.1 2002/08/07 09:25:47 moleman Exp $
//phpinfo();
include_once 'sqlquery.inc';
$fields = array("produktname", "herstellername", "name_" . LC_LANG);
$map_cols = array("produktname" => $lang->translate('productname'), "herstellername" => $lang->translate('manufacturer'), "name_" . LC_LANG => $lang->translate('category'));
$searchable_fields = array($cfg['table']['product'] . ".name" => $lang->translate('productname'), "t_manufacturer.name" => $lang->translate('manufacturer'), "name_" . LC_LANG => $lang->translate('category'));
if (!isset($sql)) {
$sql = new Sql_Query();
$sql->conditions = 1;
$sql->method = 'get';
$sql->translate = "on";
$sql->container = "on";
$sql->variable = "on";
$sql->module = 'product';
$sql->action = 'search';
$sql->lang = LC_LANG;
}
if (isset($x)) {
$abfrage = $sql->where("x", 1);
$from = 0;
}
$tpl->setVariable("UEBERSCHRIFT", $lang->translate('productsearch'));
$content["ABFRAGEBOX"] = $sql->form("x", $searchable_fields, "searchbox", url(array('module' => 'product', 'action' => 'search')));
"produktname" => $GLOBALS['str_productname'],
# "vertriebname" => $GLOBALS['str_reseller'],
"herstellername" => $GLOBALS['str_manufacturer'],
"name_".LC_LANG => $GLOBALS['str_category'],
);
$searchable_fields=array(
$table['produkt'].".name" => $GLOBALS['str_productname'],
"t_manufacturer.name" => $GLOBALS['str_manufacturer'],
# "t_reseller.name" => $GLOBALS['str_reseller'],
"name_".LC_LANG => $GLOBALS['str_category'],
);
*/
$searchable_fields = array("m100" => "M100", "m300" => "M300", "ts" => "TS", "eab" => "EAB", "rebound" => "Rebound", "shore_a" => "Shore A", "sg" => "SG");
if (!isset($sql)) {
$sql = new Sql_Query();
$sql->conditions = 1;
$sql->translate = "on";
$sql->container = "on";
$sql->variable = "on";
$sql->lang = LC_LANG;
$sess->register("sql");
}
if (isset($x)) {
$abfrage = $sql->where("x", 1);
}
$tpl->setvariable("UEBERSCHRIFT", $GLOBALS['str_productsearch']);
$tpl->setvariable("ABFRAGEBOX", $sql->form("x", $searchable_fields, "searchbox"));
if ($abfrage) {
/*$db->query("
SELECT *,$table[produkt].name as produktname, t_reseller.name as vertriebname, t_manufacturer.name as herstellername