".$menu[getLang()][$i]." "; } return $result; } /* function genCities(&$db) { $result = ""; $pf = getLang(); $cts = $db->runQuery("SELECT * FROM city ORDER BY region_$pf,muni_$pf,name_$pf"); foreach ($cts as $ct) { $result .= "".$ct["region_$pf"]." / ".$ct["muni_$pf"]." / ".niceCity($ct["name_$pf"]).""; } return $result; } */ $tpl = new Template("./templates/index.php"); $db = new Database(); $vars = array( "l_title" => $lang["title"], "l_home" => $lang["home"], "l_sitemap" => $lang["sitemap"], "l_latest" => $lang["addmnmnt"], "alpha" => alphabetBar(), "menu" => "", "entries" => "", "l_search" => $lang["search"], "news" => "", "charset" => $lang["charset"] ); if (getLang() == "bg") { $vars["l_l"] = "English"; $vars["l_nl"] = "en"; } else { $vars["l_l"] = "Български"; $vars["l_nl"] = "bg"; } $mnu = new Template("./templates/menu.php"); generateMenu($mnu, $vars); $in = new Template(); if (isset($_POST["add"])) { // do database stuff //var_dump($_POST,$_FILES);die(); $db->runQuery("INSERT INTO `monument_u` (`id`, `name_bg`, `name_en`, `city`, `descr_bg`, `descr_en`, `gps`, `url`, `category_bg`, `category_en`, `dateadd`, `views`, `ok`, `email`) VALUES ('', '".$_POST["name_bg"]."', '".$_POST["name_en"]."', '".$_POST["city"]."', '".$_POST["descr_bg"]."', '".$_POST["descr_en"]."', '".$_POST["gps"]."', '".$_POST["url"]."', '".$_POST["categ_bg"]."', '".$_POST["categ_en"]."', '".time()."', 0, 0, '".$_POST["email"]."')"); //mysql_query("INSERT INTO `monument_u` (`id`, `name_bg`, `name_en`, `city`, `descr_bg`, `descr_en`, `gps`, `url`, `category_bg`, `category_en`, `dateadd`, `views`, `ok`, `email`) VALUES ('', '".$_POST["name_bg"]."', '".$_POST["name_en"]."', '".$_POST["city"]."', '".$_POST["descr_bg"]."', '".$_POST["descr_en"]."', '".$_POST["gps"]."', '".$_POST["url"]."', '".$_POST["categ_bg"]."', '".$_POST["categ_en"]."', '".time()."', 0, 0, '".$_POST["email"]."')") or die(mysql_error()); // check the uploaded file if (!empty($_FILES)) { $id = $db->runQuery("SELECT id FROM monument_u ORDER BY id DESC LIMIT 1", true); handleFile($_FILES["mpic"], $id["id"]); } $in->selectFile("./templates/list.php"); $in->setVars(array("data" => $lang["a_ok"], "l_title" => "")); } else { $in->selectFile("./templates/monument.php"); $v = array( "l_name" => $lang["a_name"], "l_city" => $lang["city"], "l_descr" => $lang["a_descr"], "l_gps" => $lang["gps"], "l_url" => $lang["url"], "l_categ" => $lang["a_categ"], "l_pic" => $lang["a_pic"], "l_send" => $lang["a_send"], "l_reset" => $lang["a_reset"], "l_choose" => $lang["a_choose"], "l_email" => $lang["email"], "a_categ" => genCategories() // ,"a_cities" => genCities($db) ); $in->setVars($v); } $vars["entries"] = $in->parsePage(); $tpl->setVars($vars); $tpl->displayPage(); ?>