$retid = mysql_query($SQL) or die(mysql_error());
$nr_totalrecords = mysql_num_rows($retid);
$i = 0;
if ($row = mysql_fetch_array($retid)) {
do {
$id[$i] = $row["id"];
$description[$i] = $row["description"];
$name[$i] = $row["name"];
$value[$i] = $row["value"];
$comment[$i] = $row["comment"];
$type[$i] = $row["type"];
$i++;
} while ($row = mysql_fetch_array($retid));
}
$nr = $i;
$ft->setPattern(array("LANG_", "CONF_"));
$ft->define_dynamic("conf_list", "content");
for ($i = 0; $i < $nr; $i++) {
switch ($type[$i]) {
case 1:
// textField
$value_str = "<input size=40 type=text name='" . "CNF_" . $name[$i] . "' value='" . $value[$i] . "'>";
break;
case 2:
// textArea
$value_str = "<textarea cols=50 rows=5 name='" . "CNF_" . $name[$i] . "'>" . $value[$i] . "</textarea>";
break;
case 3:
// select Menu
$value_str = "<select name='" . "CNF_" . $name[$i] . "'>";
$options = explode("|", $comment[$i]);
/**
*
* @author - Elteto Zoltan
* @desc - get the sidebar from table
* @vers - 1.0
*/
public function getSideBar()
{
$ft = new FastTemplate(ADMIN_TEMPLATE_CONTENT_PATH);
$ft->define(array("main" => "sidebar.html"));
$template = $ft->get_template("sidebar.html");
$var_array = $ft->getPrefPatternVariables("IS_", $template);
// only show if is available
$SQL = "SELECT * FROM `" . DB_PREFIX . $this->table_name . "` WHERE availability=1 ORDER BY `position` ASC";
$retid = mysql_query($SQL);
if (!$retid) {
echo mysql_error();
}
$i = 0;
if ($row = mysql_fetch_array($retid)) {
do {
$module_id[$i] = $row["module_id"];
$module_name[$i] = $row["module_name"];
$availability[$i] = $row["availability"];
$filename[$i] = $row["filename"];
$extra_menu[$i] = $row["extra_menu"];
$restriction_name[$i] = $row["restriction_name"];
$i++;
} while ($row = mysql_fetch_array($retid));
}
$nrmodules = $i;
if ($nrmodules == 0) {
$ft->assign("SIDEBAR_EXIST", 0);
} else {
$ft->assign("SIDEBAR_EXIST", 1);
$ft->setPattern(array("LANG_", "CONF_"));
$ft->define_dynamic("sideex", "main");
for ($i = 0; $i < $nrmodules; $i++) {
$ft->assign("MODULE_NAME", constant($module_name[$i]));
$ft->assign("FILENAME", $filename[$i]);
//restriction
if (!empty($restriction_name[$i])) {
$tmp = array($restriction_name[$i]);
foreach ($var_array as $value) {
$ft->assign("{$value}", in_array($value, $tmp) ? 0 : 1);
}
} else {
foreach ($var_array as $value) {
$ft->assign("{$value}", 1);
}
}
// could be extra details what admin want to show. This is in extra_menu field.
if (!empty($extra_menu[$i])) {
$var_lang_array = $ft->getPrefPatternVariables("LANG_", $extra_menu[$i]);
foreach ($var_lang_array as $language) {
$extra_menu[$i] = str_replace("{" . $language . "}", constant($language), $extra_menu[$i]);
}
$ft->assign("ISEXTRA_MENU", 1);
$ft->assign("EXTRA_MENU", $extra_menu[$i]);
} else {
$ft->assign("ISEXTRA_MENU", 0);
}
$ft->parse("SIDEEX", ".sideex");
}
}
$ft->multiple_assign_define("LANG_");
$ft->multiple_assign_define("CONF_");
$ft->parse("mainContent", "main");
return $ft->fetch("mainContent");
}