Форумы портала PHP.SU

PHP:
скопировать код в буфер обмена

 
<?
error_reporting(E_ALL);
session_start();
 
/******************** VARIABLES ********************/
$db_host = "localhost";
$db_port = "3306";
$db_user = "root";
$db_pass = "";
$db_base = "test";
 
$d_user_data = array("nobody"); // Default user value.
$d_language = "en"; // Default language value.
$d_urn = "main";  // Default URN value.
 
/******************** DB ********************/
$db_link = mysql_connect($db_host.":".$db_port, $db_user, $db_pass) or die(mysql_error());
mysql_select_db($db_base, $db_link) or die(mysql_error());
 
/******************** USER ********************/
$user_data = $d_user_data;
if (isset($_SESSION['user']) and isset($_SESSION['pass'])) {
    $_SESSION['user'] = trim($_SESSION['user']);
    $_SESSION['pass'] = trim($_SESSION['pass']);
    if (strlen($_SESSION['user']) > 0 and strlen($_SESSION['pass']) > 0) {
        $sql = mysql_query("SELECT * FROM `users` WHERE user = `".mysql_escape_string($_SESSION['user'])."' AND pass = '".mysql_escape_string($_SESSION['pass'])."' LIMIT 1") or die(mysql_error());
        if (mysql_num_rows($sql) != 1) {
            $user_data = mysql_fetch_row($sql);
        }
    }
} else if (isset($_POST['user']) and isset($_POST['pass'])) {
    $_POST['user'] = trim($_POST['user']);
    $_POST['pass'] = trim($_POST['pass']);
    if (strlen($_POST['user']) > 0 and strlen($_POST['pass']) > 0) {
        $_SESSION['user'] = $_POST['user'];
        $_SESSION['pass'] = md5($_POST['pass']);
        $sql = ("SELECT * FROM `users` WHERE user = '".mysql_escape_string($_POST['user'])."' AND pass = '".mysql_escape_string(md5($_POST['pass']))."' LIMIT 1") or die(mysql_error());
        if (mysql_num_rows($sql) != 1) {
            $user_data = mysql_fetch_row($sql);
        }
    }
}
 
/******************** LANGUAGE ********************/
$language = $d_language;
if ($user_data != $d_user_data) {
    $language = $user_data[4]; // $user_data[4] = language
} else if (isset($_SESSION['language'])) {
    $_SESSION['language'] = trim($_SESSION['language']);
    if (strlen($_SESSION['language']) == 2) {
        $sql = mysql_query("SELECT * FROM `languages` WHERE language = '".mysql_escape_string($_SESSION['language'])."' LIMIT 1") or die(mysql_error());
        if (mysql_num_rows($sql) != 1) {
            $language = $_SESSION['language'];
        }
    }
}
if (isset($_POST['language'])) {
    $_POST['language'] = trim($_POST['language']);
    if (strlen($_POST['language']) == 2) {
        $sql = mysql_query("SELECT * FROM `languages` WHERE language = '".mysql_escape_string($_POST['language'])."' LIMIT 1") or die(mysql_error());
        if (mysql_num_rows($sql) != 1) {
            $_SESSION['language'] = $language = $_POST['language'];
        }
    }
}
 
/******************** PAGE ********************/
$urn = $d_urn;
if (isset($_GET['urn'])) {
    $_GET['urn'] = trim($_GET['urn']);
    $urn = $_GET['urn'];
}
$sql = mysql_query("SELECT * FROM `pages` WHERE `urn` = '".mysql_escape_string($urn)."' LIMIT 1") or die(mysql_error());
$page_data = mysql_fetch_row($sql);
if (mysql_num_rows($sql) != 1) {
    $urn = $d_urn;
    $sql = mysql_query("SELECT * FROM `pages` WHERE `urn` = '".mysql_escape_string($urn)."' LIMIT 1") or die(mysql_error());
    $page_data = mysql_fetch_row($sql);
}
 
/******************** INCLUDE ********************/
$path = "/home/localhost/subdomain/";
include $path.$page_data[1].".php"; // $page_data[1] = type
 
/******************** DB ********************/
mysql_close($db_link);
?>
 

CODE (SQL):
скопировать код в буфер обмена

 
-- phpMyAdmin SQL Dump
-- version 3.2.3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 02, 2011 at 01:36 AM
-- Server version: 5.1.40
-- PHP Version: 5.3.3
 
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
 
--
-- Database: `test`
--
 
-- --------------------------------------------------------
 
--
-- Table structure for table `pages`
--
 
CREATE TABLE IF NOT EXISTS `pages` (
  `id` int(11) NOT NULL,
  `type` text COLLATE utf8_unicode_ci NOT NULL,
  `urn` text COLLATE utf8_unicode_ci NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 
--
-- Dumping data for table `pages`
--
 
INSERT INTO `pages` (`id`, `type`, `urn`) VALUES
(0, 'catalog', 'main'),
(1, 'page', 'page1');
 
-- --------------------------------------------------------
 
--
-- Table structure for table `users`
--
 
CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL,
  `user` text COLLATE utf8_unicode_ci NOT NULL,
  `pass` text COLLATE utf8_unicode_ci NOT NULL,
  `language` text COLLATE utf8_unicode_ci NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 
--
-- Dumping data for table `users`
--
 
INSERT INTO `users` (`id`, `user`, `pass`, `language`) VALUES
(0, 'nobody', '', 'ru'),
(1, 'alfred', 'dd88f82e4a92f5b61f65c456d544d010', 'en'),
(3, 'vasya', 'a2e2fb92e9ea48f1b26b67983ea729a3', 'ru');
 