$type_name = $type_info['name']; $viewhelper->setTitle($type_name); $viewhelper->setPosition($type_name, "brand/list.php?catid=" . $typeid); $rs = $pdb->GetArray("SELECT id,name FROM {$tb_prefix}brandtypes WHERE parent_id='" . $typeid . "'"); } if (empty($rs)) { $rs = $pdb->GetArray("SELECT id,name FROM {$tb_prefix}brandtypes WHERE parent_id=0"); } if (isset($_GET['do'])) { $do = trim($_GET['do']); if ($do == "search") { if (isset($_GET['q'])) { $searchkeywords = urldecode($_GET['q']); $conditions[] = "name like '%" . $searchkeywords . "%'"; } if (isset($_GET['letter'])) { $viewhelper->setTitle(L("brands_with_letter", "tpl", $_GET['letter'])); $viewhelper->setPosition(L("brands_with_letter", "tpl", $_GET['letter'])); $conditions[] = "letter='" . trim($_GET['letter']) . "'"; } } } $brand->setCondition($conditions); $amount = $brand->findCount(null, $conditions); $sql = "SELECT * FROM {$tb_prefix}brands" . $brand->getCondition() . " LIMIT " . $pos . "," . $limit; $result = $pdb->GetArray($sql); $result = $brand->formatResult($result); setvar('items', $result); setvar('Types', $rs); setvar("paging", array('total' => $amount)); render("brand/list");