All pastes #534451 Raw Edit

Anonymous

public text v1 · immutable
·published 2007-06-03 19:51 UTC
rendered paste body
<?
session_start();

include("modules/connect.php");

/* S: korrektse ID loomine */ 
	if(!defined(ID)) {
	$result = sql("SELECT page_id FROM ".PREFIX."menu WHERE sup_id=0 ORDER BY position LIMIT 1");
	$row=arr($result);
	define(ID, $row[0]);
	mysql_free_result($result);	
	}
/* E: korrektse ID loomine */

/* S: kasutaja login */
if(strlen($_POST[kasutaja]) && strlen($_POST[parool]) && !strlen($_SESSION["user"])) {	
	$res = sql("select * from ".PREFIX."kasutajad where user='".$_POST[kasutaja]."' and pass='".md5($_POST[parool])."' and usr_level > 0");	
	if($row=arr($res)) {
		$_SESSION["usid"] = $row[id];
		$_SESSION["user"] = $row[user];
		$_SESSION["pass"] = $row[pass];
		$_SESSION["usrl"] = $row[usr_level];		
		$_SESSION["adml"] = $row[usr_level];		
	}
	Header("Location: ?".ID);
}
/* E: kasutaja login */

/* S: baasist lehe andmete otsimine */
	$result = sql("SELECT caption, module, template, link, content, parse FROM ".PREFIX."content WHERE id='".ID."' LIMIT 1");
	$row=arr($result);
	$caption  = $row['caption'];
	$module   = $row['module'];
	$template = $row['template'];
	$link     = $row['link'];
	//if($vars[1]==""&&$vars[2]=="") {
		$content = $row['content'];
	//}
	$parse    = $row['parse'];
	mysql_free_result($result);
/* E: baasist lehe andmete otsimine */  

/* S: template incluudimine */
	require "template/xtpl.p";	
	$xtpl=new XTemplate ("template/".$template.".html");
/* E: template incluudimine */

/* S: keelevärk */
	$xtpl->assign("charset",trans("codepage"));
/* E: keelevärk */

/* S: suvapildi kuvamine headerisse */
	$xtpl->assign("IMGNUM",rand(1,4));
/* E: suvapildi kuvamine headerisse */

/* S: välise lingi korral lehe ümbersuunamine */
    if($link) { header("Location: ".$link); 	}
/* E: välise lingi korral lehe ümbersuunamine */

/* S: footer kontaktinfo saamine */
$result = sql("SELECT value FROM ".PREFIX."settings WHERE setting = 'footer'");
$footer = arr($result); $footer=$footer[value];mysql_free_result;
$xtpl->assign("footer",$footer);unset($footer);
/* E: footer kontaktinfo saamine */

/* S: s i s u  s a a m i n e */
  if($module) {
	ob_start();
	include("modules/mod_".$row["module"].".php");
	$content.=ob_get_contents();
	ob_end_clean();
  }

/* E: s i s u  s a a m i n e */

/* S: Menüü */

	$res = sql("select value from ".PREFIX."settings where setting='menu_type'");
	$row = arr($res);
	if($row[0]=="d") {
/* S: Dünaamiline menüü */	
	$res = sql("select ".PREFIX."dmenu.*,".PREFIX."content.caption from ".PREFIX."dmenu join ".PREFIX."content on ".PREFIX."dmenu.page = ".PREFIX."content.id where step=0 and lng = '".$_SESSION[keel]."' order by 1");
	$i = 0;
	while($row = arr($res)) {
		$i++;
		$xtpl->assign("did",$i);
		$xtpl->assign("link",$row[page]);
		if($row[page]==ID) {
			$xtpl->assign("capt","<b>".$row[caption]."</b>");
		} else {
			$xtpl->assign("capt",$row[caption]);
		}
		
		$res2 = sql("select * from ".PREFIX."dmenu WHERE step=1 and sup_page=".$row[0]);
		$row2 = arr($res2);
		if($row2) {
			$xtpl->assign("subs","onmouseover='show(".$i.")' onmouseout='hide(".$i.")'");
		
			$res2 = sql("select ".PREFIX."dmenu.*,".PREFIX."content.caption from ".PREFIX."dmenu join ".PREFIX."content on ".PREFIX."dmenu.page = ".PREFIX."content.id where step=1 and sup_page = ".$row[0]." order by 1");
			while($row2 = arr($res2)) {
				$xtpl->assign("sub_capt",$row2[caption]);
				$xtpl->assign("sub_link",$row2[page]);
				$xtpl->parse("main.Dynamic_Menu.Sub_Menu.Sub_Item");
			}
			$xtpl->parse("main.Dynamic_Menu.Sub_Menu");
		} else {
			$xtpl->assign("subs","");

		}
		$xtpl->parse("main.Dynamic_Menu");
	}

/* E: Dünaamiline menüü */
	
	} else {	

/* S: ülemise menüü loomine */ 
	$res_menu = sql("SELECT id, page_id, name FROM ".PREFIX."menu WHERE visible=1 and sup_id=0 ORDER BY position");
	unset($i);
	while($row=arr($res_menu)) {
		$xtpl->assign("item_id",$row[page_id]);
		$xtpl->assign("item_capt",$row[name]);
		$res2_menu = sql("SELECT id, page_id, name FROM ".PREFIX."menu WHERE visible=1 and sup_id=".$row[id]." ORDER BY position");
		while($row2=arr($res2_menu)) {
			$xtpl->assign("subitem_id",$row2[page_id]);
			$xtpl->assign("subitem_capt",$row2[name]);
			$xtpl->parse("main.menu.menuitem.submenu.submenuitem");
		}
		$xtpl->parse("main.menu.menuitem.submenu");
		$xtpl->parse("main.menu.menuitem");
	}
	$xtpl->parse("main.menu");
/* E: ülemise menüü loomine */

/* S: alamenüü loomine
	$sql_q = "SELECT ".PREFIX."menu.id, ".PREFIX."menu.link, ".PREFIX."content.caption FROM ".PREFIX."menu LEFT JOIN ".PREFIX."content ON ".PREFIX."menu.link = ".PREFIX."content.id WHERE ".PREFIX."menu.lk = ".ID;
	$res_menu = sql($sql_q);
	while($row=arr($res_menu))
	{ 
			$xtpl->assign("sub_id",$row[link]);
			$xtpl->assign("sub_name",$row[caption]);
			$xtpl->parse("main.submenu");
	}
E: alamenüü loomine */
	}
/* E: Menüü */

  $tag[0] = "#skript/";
  $tag[1] = "#";

/* S: s k r i p t i d e  p a r s e m i n e */
if($parse == "1") {

  $res = sql("select distinct(alias) from ".PREFIX."skripts");
  while($row = arr($res)) {
	$skriptid[] = $row[alias];
  }
  
  foreach ($skriptid as $skript) {
	  if(strstr($content,$tag[0].$skript.$tag[1])) {
		$res = sql("select * from ".PREFIX."skripts where alias='".$skript."'");
		$row = arr($res);
		$parameetrid = explode("./.", $row[param]);
		if(is_array($parameetrid)) {
			foreach($parameetrid as $par) {
				$par = explode("=",$par);
				$param[$row[skript]][$par[0]] = $par[1];
				unset($par);
			}
		}

		ob_start();
		include("skriptid/skr_".$row[skript].".php");
		$skript_content=ob_get_contents();
		ob_end_clean();
		$content = str_replace($tag[0].$skript.$tag[1],$skript_content,$content);
	  }
  }
}
/* E: s k r i p t i d e  p a r s e m i n e */

/* S: bannerid */
	$res = sql("select * from ".PREFIX."settings where setting in('banner1','banner2','banner3')");
	$row = arr($res);
	if($row[value] == "1") { $xtpl->assign("banner1",showbanner(1)); }
	$row = arr($res);
	if($row[value] == "1") { $xtpl->assign("banner2",showbanner(2)); }
	$row = arr($res);
	if($row[value] == "1") { $xtpl->assign("banner3",showbanner(3)); }
/* E: bannerid */

/* S: globaalsed komponendid */
	@include("template/components/cmp_global.php");
/* E: globaalsed komponendid */

$xtpl->assign("CAPTION",$caption);
$xtpl->assign("CONTENT",$content);
/* S: templatepõhised komponendid */
	@include("template/components/cmp_".$template.".php");
/* E: templatepõhised komponendid */
$xtpl->parse("main.Content_Frame");

$xtpl->assign("keel",$_SESSION[keel]);
$xtpl->parse("main");
$xtpl->out("main");
?>