Файл: liwar.ru/Yadro/PDO_connect.php
Строк: 157
<?php
//имя базы
$dbn = 'valryru_vi';
//имя сервера
$dbh = 'localhost';
//порт
$dbr = '3306';
//имя пользователя
$dbu = 'valryru_vius';
//пароль
$dbp = 'akso1989n';
ob_start();
session_name('sid');
@session_start();
define ('DBHOST', "$dbh");
define ('DBPORT', "$dbr");
define ('DBNAME', "$dbn");
define ('DBUSER', "$dbu");
define ('DBPASS', "$dbp");
if (!class_exists('PDO'))
die('Fatal Error: Для работы нужна поддержка PDO');
class PDO_ extends PDO {
function __construct($dsn, $username, $password) {
parent :: __construct($dsn, $username, $password);
$this -> setAttribute(PDO :: ATTR_ERRMODE, PDO :: ERRMODE_EXCEPTION);
$this -> setAttribute(PDO :: ATTR_DEFAULT_FETCH_MODE, PDO :: FETCH_ASSOC);
}
function prepare($sql) {
$stmt = parent :: prepare($sql, array(
PDO :: ATTR_STATEMENT_CLASS => array('PDOStatement_')
));
return $stmt;
}
function query($sql, $params = array()) {
$stmt = $this -> prepare($sql);
$stmt -> execute($params);
return $stmt;
}
function querySingle($sql, $params = array()) {
$stmt = $this -> query($sql, $params);
$stmt -> execute($params);
return $stmt -> fetchColumn(0);
}
function queryFetch($sql, $params = array()) {
$stmt = $this -> query($sql, $params);
$stmt -> execute($params);
return $stmt -> fetch();
}
}
class PDOStatement_ extends PDOStatement {
function execute($params = array()) {
if (func_num_args() == 1) {
$params = func_get_arg(0);
} else {
$params = func_get_args();
}
if (!is_array($params)) {
$params = array($params);
}
parent :: execute($params);
return $this;
}
function fetchSingle() {
return $this -> fetchColumn(0);
}
function fetchAssoc() {
$this -> setFetchMode(PDO :: FETCH_NUM);
$data = array();
while ($row = $this -> fetch()) {
$data[$row[0]] = $row[1];
}
return $data;
}
}
class DB {
static $dbs;
public function __construct() {
try {
self :: $dbs = new PDO_('mysql:host=' . DBHOST . ';port=' . DBPORT . ';dbname=' . DBNAME, DBUSER, DBPASS);
self :: $dbs -> exec('SET CHARACTER SET utf8');
self :: $dbs -> exec('SET NAMES utf8');
}
catch (PDOException $e) {
die('Connection failed: ' . $e -> getMessage());
}
}
}
$array = explode(" ",microtime());
$gen = $array[1] + $array[0];
$db = new DB();
DB::$dbs->query("SET NAMES utf8");
class cms {
var $us;
}
function links_preg1($arr){
global $set;
if(ereg('^http://'.$_SERVER['HTTP_HOST'],$arr[1])){
return '<a href="'.$arr[1].'">'.$arr[2].'</a>';
}else{
return '<a href="'.$arr[1].'">'.$arr[2].'</a>';
}
}
function links_preg2($arr){
global $set;
if(ereg('^http://'.$_SERVER['HTTP_HOST'],$arr[2])){
return $arr[1].'<a href="'.$arr[2].'">'.$arr[2].'</a>'.$arr[4];
}else{
return $arr[1].'<a href="'.$arr[2].'">'.$arr[2].'</a>'.$arr[4];
}
}
function br($msg,$br='<br />')
{
$msg=eregi_replace("((<br( ?/?)>)|n|r)+",$br, $msg);
return $msg;
}
function bb($msg)
{
$bbcode = array(
'/[url](.+)[/url]/isU'=>'<a href="$1">$1</a>',
'/[url=(.+)](.+)[/url]/isU'=>'<a href="$1">$2</a>',
'/[i](.+)[/i]/isU' => '<em>$1</em>',
'/[b](.+)[/b]/isU' => '<strong>$1</strong>',
'/[u](.+)[/u]/isU' => '<span style="text-decoration:underline;">$1</span>',
'/[big](.+)[/big]/isU' => '<span style="font-size:large;">$1</span>',
'/[small](.+)[/small]/isU' => '<span style="font-size:xx-small;">$1</span>',
'/[code](.+)[/code]/isU' => '<code>$1</code>',
'/[red](.+)[/red]/isU' => '<span style="color:#ff0000;">$1</span>',
'/[green](.+)[/green]/isU' => '<span style="color:#00bb00;">$1</span>',
'/[blue](.+)[/blue]/isU' => '<span style="color:lightblue;">$1</span>',
'/[white](.+)[/white]/isU' => '<span style="color:#ffffff;">$1</span>',
'/[img](.+)[/img]/isU' => '<a href="$1"><img src="$1" alt="" width="100" height="90" /></a>',
);
$msg= preg_replace(array_keys($bbcode), array_values($bbcode), $msg);
$msg=preg_replace_callback('#<?(.*?)?>#sui', 'bbcodehightlight', $msg);
$msg=preg_replace('#[code](.*?)[/code]#si', '1', $msg);
return $msg;
}
// ----------- Смайлы -------------//
function sm($msg){
$msg=str_replace(":)","<img src='/Images/smile/smile.gif' alt=':)'/>",$msg);
$msg=str_replace(":(","<img src='/Images/smile/2.gif' alt=':('/>",$msg);
$msg=str_replace(";)","<img src='/Images/smile/3.gif' alt=';)'/>",$msg);
$msg=str_replace(":P","<img src='/Images/smile/4.gif' alt=':P)'/>",$msg);
$msg=str_replace(".крут.","<img src='/Images/smile/5.gif' alt='крут'/>",$msg);
$msg=str_replace(":D","<img src='/Images/smile/6.gif' alt=':D'/>",$msg);
$msg=str_replace("хаха","<img src='/Images/smile/1.gif' alt='хаха'/>",$msg);
$msg=str_replace(".покраснел.","<img src='/Images/smile/7.gif' alt='покраснел'/>",$msg);
$msg=str_replace("0_о","<img src='/Images/smile/8.gif' alt='0_о'/>",$msg);
$msg=str_replace(".фак.","<img src='/Images/smile/40.gif' alt='фак'/>",$msg);
return $msg;
}
function links($msg){
$msg=preg_replace_callback('~[url=([a-z]+://[^ rnt`'"]+)](.*?)[/url]~iu', 'links_preg1', $msg);
$msg=preg_replace_callback('~(^|s)([a-z]+://([^ rnt`'"]+))(s|$)~iu', 'links_preg2', $msg);
return $msg;
}
function secure($mess){
$mess=htmlspecialchars(trim($mess));
return $mess;
}
error_reporting(0);
if(DB::$dbs->querySingle("SELECT count(id) FROM `us` where `id` = ?",array(intval($_COOKIE['username'])))==1){
$password = secure($_COOKIE['password']);
$cms->us = DB::$dbs->queryFetch("SELECT * FROM `us` where `id` = ? and `pass` = ? limit 1",array(intval($_COOKIE['username']),$password));
if($cms->us['pass']==$password && $cms->us['id'] == intval($_COOKIE['username'])){
DB::$dbs->query("UPDATE `us` SET `last` = ?, `ip`=?, `soft` = ? WHERE `id` = ? limit 1",array(time(),$_SERVER['REMOTE_ADDR'],$_SERVER['HTTP_USER_AGENT'],$cms->us['id']));
} }
function slv($str,$msg1,$msg2,$msg3) {
$str = (int)$str;
$str1 = abs($str) % 100;
$str2 = $str % 10;
if ($str1 > 10 && $str1 < 20) return $str .' '. $msg3;
if ($str2 > 1 && $str2 < 5) return $str .' '. $msg2;
if ($str2 == 1) return $str .' '. $msg1;
return $str .' '. $msg3;
}
function t($times=NULL){
global $db;
$time = time();
if(($time-$times)<=60){
$timesp = slv((($time-$times)),'сек','сек','сек').' назад';
return $timesp;
}else if(($time-$times)<=3600){$timesp = slv((($time-$times)/60),'мин','мин','мин').' назад';
return $timesp;
}else{
$today = date("j M Y", $time);
$today = date("j M Y", $time);
$yesterday = date("j M Y", strtotime("-1 day"));
$timesp=date("j M Y в H:i", $times);
$timesp = str_replace($today, '', $timesp);
$timesp = str_replace($yesterday, 'Вчера', $timesp);
$timesp = strtr($timesp, array ("Jan" => "Янв","Feb" => "Фев","Mar" => "Марта","May" => "Мая","Apr" => "Апр","Jun" => "Июня","Jul" => "Июля","Aug" => "Авг","Sep" => "Сент","Oct" => "Окт","Nov" => "Ноября","Dec" => "Дек",));
return $timesp;}
}
function ti($times=NULL){
global $db;
$time = time();
if(($times-$time)<=60){
$timesp = slv((($times-$time)),'секундa','секунды','секунд').'';
return $timesp;
}else if(($times-$time)<=3600){$timesp = slv((($times-$time)/60),'минутa','минуты','минут').'';
return $timesp;
}else{
$today = date("j M Y", $time);
$today = date("j M Y", $time);
$yesterday = date("j M Y", strtotime("-1 day"));
$timesp=date("j M Y в H:i", $times);
$timesp = str_replace($today, 'Сегодня', $timesp);
$timesp = str_replace($yesterday, 'Вчера', $timesp);
$timesp = strtr($timesp, array ("Jan" => "Янв","Feb" => "Фев","Mar" => "Марта","May" => "Мая","Apr" => "Апр","Jun" => "Июня","Jul" => "Июля","Aug" => "Авг","Sep" => "Сент","Oct" => "Окт","Nov" => "Ноября","Dec" => "Дек",));
return $timesp;}
}
ini_set('magic_quotes_gpc', 0);
ini_set('magic_quotes_runtime', 0);
include 'Classies.php';
?>