Функция ЧПУ на php. Создание человеческих ссылок в постах

RewriteEngine on
RewriteRule ^post/([-a-z0-9]+.html)$ index.php?post=$1 [L]
RewriteRule ^category/([-a-z0-9]+)/$ index.php?category=$1 [L]
RewriteRule ^contacts.html$ index.php?contact=1 [L]

if($chpu == 1)//если блог работает в режиме вкл ЧПУ
{
	include("moduls/chpu.php");
	//GET ПЕРЕМЕННАЯ post
	if(isset($_GET['post']))
	{
	    if(!preg_match("/^[-a-z0-9]+\.html$/",$_GET['post']))//если имя не корректное,то переносим
	    {
	        header("location: ".$server_root);//на главную страницу
	        exit;
	    }
	    
		$blog = chpu($_GET['post'],"post");//по имени страницы достаем из бд id
	    
		if($blog == "")//если результат функции пустота, то переносим пользователя
	    {
	        header("location: ".$server_root);//на главную страницу
	        exit;		
	    }
	}
	//GET ПЕРЕМЕННАЯ post
	//GET ПЕРЕМЕННАЯ category
	if(isset($_GET['category']))
	{
	    if(!preg_match("/^[-a-z0-9]+\/$/",$_GET['category']))//если имя не корректное,то переносим
	    {
	        header("location: ".$server_root);//на главную страницу
	        exit;
	    }
	    
		$cat = chpu($_GET['category'],"category");//по имени страницы достаем из бд id
	    
		if($cat == "")//если результат функции пустота, то переносим пользователя
	    {
	        header("location: ".$server_root);//на главную страницу
	        exit;		
	    }
	}
	//GET ПЕРЕМЕННАЯ category
}

mysql_query()

mysqli_query()

//ПОДКЛЮЧЕНИЕ К БАЗЕ ДАННЫХ (БД)
$nameDB     = "blog";//Название БД
$nameSERVER = "localhost";//Сервер
$nameUSER   = "root";//Имя пользователя БД
$passUSER   = "";//Пароль пользователя БД
mysql_select_db($nameDB, mysql_connect($nameSERVER,$nameUSER,$passUSER));	
//ПОДКЛЮЧЕНИЕ К БАЗЕ ДАННЫХ (БД)

$nameDB     = "blog";//Название БД
$nameSERVER = "localhost";//Сервер
$nameUSER   = "root";//Имя пользователя БД
$passUSER   = "";//Пароль пользователя БД

$db = mysqli_connect(
        $nameSERVER,
        $nameUSER,
        $passUSER,
        $nameDB
);

$result   = mysql_query("SELECT * FROM table");
$myrow    = mysql_fetch_array($result);

$result   = mysqli_query($db, "SELECT * FROM table");
$myrow    = mysqli_fetch_array($result);

$(document).ready(function() {
	$(function() {
        $("#initpl").toggle(function (){
			$(".getWrapper").css({width: "initial", minWidth: "initial", margin: "10px"})
			$(".getHead").css({width: "initial"})
			$(".getContents").css({width: "initial"})
			$(".getWrapper .getContents .getCol1").css({width: "100%"})
			$(".comments_content").css({width: "initial"})
			$(".commcont").css({width: "auto", minWidth: "100%"})
			$(".comment_cont02").css({width: "auto"})
			$("#header #wrp .headpanel .heads .wrass").css({width: "95%"})
            $("#initpl").text("Уменьшить шаблон")
            .stop();
        }, function(){
			$(".getWrapper").css({width: "900px", minWidth: "900px", margin: "10px auto 10px auto"})
			$(".getHead").css({width: "900px"})
			$(".getContents").css({width: "900px"})
			$(".getWrapper .getContents .getCol1").css({width: "699px"})
			$(".comments_content").css({width: "680px"})
			$(".commcont").css({width: "680px", minWidth: "680px"})
			$(".comment_cont02").css({width: "527px"})
			$("#header #wrp .headpanel .heads .wrass").css({width: "960px"})
            $("#initpl").text("Увеличить шаблон")
            .stop();
        });
    });
});

$.cookie('tpl', 'состояние', { path: '/' });

Warning: mysqli_query() expects parameter 1 to be mysqli, null given in Z:\home\udiscuz.ru\www\source\modules\returnconfig.php on line 18

Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given in Z:\home\udiscuz.ru\www\source\modules\returnconfig.php on line 19

Warning: Invalid argument supplied for foreach() in Z:\home\udiscuz.ru\www\source\modules\menu.php on line 35
Template file for uDiscuz! not fount - file: templates//menu.tpl

var_dump( $db );

object(mysqli)#1 (18) {
	["affected_rows"]		=> int(0)
	["client_info"]		=> string(78) "mysqlnd 5.0.8-dev - 20102224 - $Id: 65fe78e70ce53d27a6cd578597722950e490b0d0 $"
	["client_version"]		=> int(50008)
	["connect_errno"]		=> int(0)
	["connect_error"]		=> NULL
	["errno"]			=> int(0)
	["error"]			=> string(0) ""
	["field_count"]		=> int(0)
	["host_info"]		=> string(20) "localhost via TCP/IP"
	["info"]			=> NULL
	["insert_id"]		=> int(0)
	["server_info"]		=> string(6) "5.5.25"
	["server_version"]		=> int(50525)
	["stat"]			=> string(130) "Uptime: 948 Threads: 1 Questions: 52 Slow queries: 0 Opens: 35 Flush tables: 1 Open tables: 4 Queries per second avg: 0.054"
	["sqlstate"]		=> string(5) "00000"
	["protocol_version"]	=> int(10)
	["thread_id"]		=> int(19)
	["warning_count"]		=> int(0)
}

function returnconfig()
{
    global $db; // делаем переменную с подключением видимой для функции
    $result_page = mysqli_query($db, "SELECT configblog FROM page WHERE id='1'");
    $myrow_page  = mysqli_fetch_array($result_page);

    global $maxSQL;
    $maxSQL++;

    return $myrow_page['configblog'];
}

mysqli_query($db, "SET NAMES 'cp1251'");

mysqli_set_charset($db, "cp1251");

@mysqli_query($db, "SET NAMES 'utf8'");

mysqli_set_charset($db, "utf8");

$result_meta = mysqli_query($db, "SELECT title,meta_d,meta_k FROM page WHERE id='1'");
$myrow_meta = mysqli_fetch_array($result_meta);

	$sql = ""
		."SELECT"
			." news.title			AS news_title,"
			." news.meta_d			AS news_meta_d,"
			." news.meta_k			AS news_meta_k,"
		." FROM"
			." page"
		." WHERE"	
		."     id		= '1'"
	;

$result_meta = mysqli_query($db, $sql);
$myrow_meta = mysqli_fetch_array($result_meta);	

$maxSQL++;

	if($myrow_meta != "")
	{
		$headerMETA[0] = $myrow_meta['news_title'];
		$headerMETA[1] = $myrow_meta['news_meta_d'];
		$headerMETA[2] = $myrow_meta['news_meta_k'];
		$headerMETA[3] = $myrow_meta['news_title'];
		$headerMETA = implode("[META]",$headerMETA);
		
		writeCACHE("news_meta",$headerMETA);
	}
}

	$sql = ""
		."SELECT"
			." news.title			AS news_title,"
			." news.meta_d			AS news_meta_d,"
			." news.meta_k			AS news_meta_k"
		." FROM"
			." page"
		." WHERE"	
			."id				= '1'"
	;

$result_meta	= mysqli_query($db, $sql);
$myrow_meta	= mysqli_fetch_assoc($result_meta);

$myrow_meta	= $myrow_meta[0];

$maxSQL++;

	if($myrow_meta != "")
	{
		$headerMETA[0]	= $myrow_meta['news_title'];
		$headerMETA[1]	= $myrow_meta['news_meta_d'];
		$headerMETA[2]	= $myrow_meta['news_meta_k'];
		$headerMETA[3]	= $myrow_meta['news_title'];
		$headerMETA	= implode("[META]",$headerMETA);

		writeCACHE("news_meta",$headerMETA);
	}
}

    $sql = ""
        ."SELECT"
            ." news.title			AS news_title,"
            ." news.meta_d			AS news_meta_d,"
            ." news.meta_k			AS news_meta_k"
        ." FROM"
            ." page"
        ." WHERE"	
            ."id				= '1'"
    ;

	$result_meta	= mysqli_query($db, $sql);
	$myrow_meta		= mysqli_fetch_assoc($result_meta);

	$maxSQL++;

    if($myrow_meta != FALSE) {
			
		while ($myrow_meta = mysqli_fetch_assoc($result_meta)) {

			$headerMETA[0]	= $myrow_meta['news_title'];
			$headerMETA[1]	= $myrow_meta['news_meta_d'];
			$headerMETA[2]	= $myrow_meta['news_meta_k'];
			$headerMETA[3]	= $myrow_meta['news_title'];
			$headerMETA		= implode("[META]",$headerMETA);
		
		}
		
        writeCACHE("news_meta",$headerMETA);
    }

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in Z:\home\udiscuz.ru\www\source\modules\news.php on line 33

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at Z:\home\udiscuz.ru\www\source\modules\news.php:33) in Z:\home\udiscuz.ru\www\source\modules\adminbar.php on line 19

    $sql = ""
        ."SELECT"
            ." page.title			AS news_title,"
            ." page.meta_d			AS news_meta_d,"
            ." page.meta_k			AS news_meta_k"
        ." FROM"
            ." page"
        ." WHERE"	
        ."     id		= '1'"
    ;

<?php
/* 

 uDiscuz! - (c) 2013-2099.
 
 Powered by SibWeb Group
 
 Official site: www.udiscuz.net
 
 License GNU/GPL v 2

 */

if(!defined('MYADMIN')) die('');

$headerMETA = readerCACHE("post_meta_".$blog,3600);

if($headerMETA == FALSE)
{
	
    $sql = ""
        ."SELECT"
            ." page.title			AS page_title,"
            ." page.meta_d			AS page_meta_d,"
        ." FROM"
            ." page"
        ." WHERE"	
        ."     page.id		        = '1'"
    ;

    $result_meta	= mysqli_query($db, $sql);
    $myrow_meta		= mysqli_fetch_assoc($result_meta);
	
	$maxSQL++;

	if($myrow_meta != FALSE)
	{
		
    $sql = ""
        ."SELECT"
            ." news.title			AS news_title,"
            ." news.meta_d			AS news_meta_d,"
            ." news.meta_k			AS news_meta_k"
        ." FROM"
            ." blog"
        ." WHERE"	
        ."     news.id		        = '$blog'"
    ;

    $result_meta_blog	= mysqli_query($db, $sql);
    $meta_blog		= mysqli_fetch_assoc($result_meta_blog);		
		
		$maxSQL++;

		$headerMETA[0] = $meta_blog['news_title']." - ".$myrow_meta['page_title'];
		$headerMETA[1] = $myrow_meta['page_meta_d'];
		$headerMETA[2] = $meta_blog['news_meta_k'];
		$headerMETA[3] = $myrow_meta['page_title'];
		
		$headerMETA = implode("[META]",$headerMETA);
		
		writeCACHE("post_meta_".$blog,$headerMETA);
	}
}

$headerMETA = explode("[META]",$headerMETA);

$header_title = $headerMETA[0];
$header_metaD = $headerMETA[1];
$header_metaK = $headerMETA[2];
$title_origin = $headerMETA[3];

function blog($blog,$canon,$chpu,$morepostACTIV)
{

global $db;

include("./source/modules/aut.php");

include("./source/modules/bbeditor.php");

include ("./source/lang/news.php");

if (checketHESH() === TRUE) $sql = "SELECT * FROM blog WHERE id='$blog'";
else $sql = "SELECT * FROM blog WHERE id='$blog' AND pablick='1'";

$result_index = mysqli_query($db, $sql);
$myrow_index = mysqli_fetch_array($result_index);

$newloock = $myrow_index['loock'] + 1;
$up_loock = mysqli_query ($db, "UPDATE blog SET loock='$newloock' WHERE id='$blog'");

global $maxSQL;
$maxSQL = $maxSQL + 2;

if($myrow_index != "")
{
$sm_read = getTPL('text.tpl');

if($myrow_index['meta_k'] != "")
{
 $sm_read = str_replace("{meta_k}",$myrow_index['meta_k'],$sm_read);
}
else $sm_read = str_replace("{meta_k}",$lang['not_tags'],$sm_read);

$text = str_replace("[end]","",$myrow_index['meta_d']);

if($morepostACTIV == 1)
{
include("./source/modules/morepost.php");
$more = morepost($chpu,$myrow_index['cat'],$blog);
$sm_read = str_replace("[_morepost]",$more,$sm_read);
}
else $sm_read = str_replace("[_morepost]","",$sm_read);

$datePOST = date("c",$myrow_index['date_b']);

$sm_read = str_replace("{canon}",$canon,$sm_read);
$sm_read = str_replace("{news}",mynews($text),$sm_read);
$sm_read = str_replace("{titles}",$myrow_index['title'],$sm_read);
$sm_read = str_replace("{author}",$myrow_index['author'],$sm_read);
$sm_read = str_replace("{date}",$datePOST,$sm_read);
$sm_read = str_replace("{comm}",$myrow_index['comm'],$sm_read);
$sm_read = str_replace("{cat}",get_catalog($myrow_index['cat']),$sm_read);
$sm_read = str_replace("{authors}",$lang['author'],$sm_read);
$sm_read = str_replace("{data_add}",$lang['data_add'],$sm_read);
$sm_read = str_replace("{comments_counter}",$lang['comments_counter'],$sm_read);
$sm_read = str_replace("{cate}",$lang['cate'],$sm_read);
$sm_read = str_replace("{tags}",$lang['tags'],$sm_read);
$sm_read = str_replace("{form_comments}",$lang['form_comments'],$sm_read);
}
else
{
$sm_read = "<p align='center'>".$lang['not_found']."</p>";
}
$result[0] = $sm_read;
$result[1] = $myrow_index['viewcomm'];
return $result;
}
function get_catalog($catalog_id = 0)
{
    include ("./source/lang/news.php");

    $catalog_link = "".$lang['not_cat']."";
    
    $catalog_id = (int)$catalog_id;
    
    if ($catalog_id == 0)
        return $catalog_link;
    
    global $station_menu;
    
    if (empty($station_menu) OR !is_array($station_menu))
        return $catalog_link;
        
    $path = array(); 
    $name = array();
    
    foreach ($station_menu as $key => $station)
        if ($station[0] == $catalog_id) {

            if ($station[3] != '')
                break;
            
            $path[] = $station[1]; 
            $name 	= $station[2]; 
            
            if ($station[4] != 0)
                get_path($path, $station[4], $station_menu);
            
            break;
        }
    
    if (empty($path))
        return $catalog_link;
    
    $catalog_link = '/'.implode('/', array_reverse($path));
    
    return "<a onClick=\"expandit('loading')\" href=\"".$catalog_link."\">".$name."</a>";
}
function get_path(&$path, $podmenu, $station_menu)
{
    foreach ($station_menu as $key => $station)
        if ($station[0] == $podmenu){
            $path[] = $station[1]; 

            if ($station[4] != 0)
                get_path($path, $station[4], $station_menu);
            
            break;
        }
}
?>

    $sql = ""
        ."SELECT"
            ." blog.title			AS news_title,"
            ." blog.meta_d			AS news_meta_d,"
            ." blog.meta_k			AS news_meta_k"
        ." FROM"
            ." blog"
        ." WHERE"	
        ."     blog.id		        = '".$blog."'"
    ;

Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in Z:\home\udiscuz.ru\www\source\modules\view_news.php on line 32

$blog = chpu($_GET['post'],"post");//по имени страницы достаем из бд id