All pastes #909500 Raw Edit

Someone

public text v1 · immutable
·published 2008-02-19 05:32 UTC
rendered paste body
<?php
include("config.php");
if(!isset($_REQUEST["alias"])){
	$query = "select * from cms_categories where `name` = 'TOP'";
	$result = mysql_query($query);
	$myrow = mysql_fetch_assoc($result);
	
	$query = "select * from cms_menu where `category` = ".$myrow["id"]." order by ";
	if($myrow["orderby"] == "custom")
		$query .= "`orderby` asc";
	else
		$query .= "`name` ".$myrow["orderby"];
	$result = mysql_query($query);
	$myrow = mysql_fetch_assoc($result);
	$id = $myrow["link"];
	$indexs = mysql_query("SELECT * FROM cms_main WHERE `id` = '$id'") or die(mysql_error());
	$scene = 1;
} else {
	$alias = $_REQUEST["alias"];
	
	$indexs = mysql_query("SELECT * FROM cms_main WHERE `alias` = '$alias'") or die(mysql_error());
	if (!isset($_REQUEST['alias']) || $alias == "index") {
$scene = 1;
} else {
$scene = 2;
}
}
$index = mysql_fetch_array($indexs);
$metakeywords = $index["metakeywords"];
$metadescription = $index["metadescription"];
$sql = "SELECT * FROM cms_settings WHERE `site_type`='".$index['site_type']."'";
$settings = mysql_query($sql) or die(mysql_error());
$info = mysql_fetch_array($settings); 
?>