Обучение/Помощь новичкам | вапхеро
tdev.exe
скажите где и как прописать базу в вапхеро
core/system.php
Вилы_Выкидные , а где и что
вот данные... vit306_admin это база а пароль пускай будет 111111 ну пароль я не даю верный. а вот подставь..
<?php
/*
Определяем текущий домен сайта.
Дальнейшее использование
echo $set['site'];
*/
$set['site'] = htmlspecialchars($_SERVER['HTTP_HOST']);
/*
Записываем в константу полный путь до корня сайта.
Я обычно использую в функции require_once, т.к при указании полного пути до файла, файл находится быстрее
*/
define("H", $_SERVER["DOCUMENT_ROOT"].'/');
/*
==========================
Подключение к базе
==========================
*/
ob_start();
$db = mysql_connect('localhost','vit306_admin','vi');
mysql_query('SET NAMES`utf8`',$db);
// Устанавливаем кодировку по умолчанию
mysql_select_db('vit306_admin',$db);
// Загрузка остальных плагинов из папки "core/function/"
$opdirbase = opendir(H.'core/function/');
while ($filebase = readdir($opdirbase))
{
if (preg_match('#.php$#i', $filebase))
{
require_once(H.'core/function/' . $filebase);
}
}
function smiles($text){
$aa = mysql_query("SELECT name,adres FROM `smiles` order by `id` desc");
while($ba = mysql_fetch_assoc($aa)){
$text=str_replace($ba['name'],'<img src="'.$ba['adres'].'" alt="smile" />', $text);
}
$bbcode = array(
'/ (.+) /isU' => '<em>$1</em>',
'/ (.+) /isU' => '<strong>$1</strong>',
'/ (.+) /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>',
'/ (.+) /isU' => '<span style="color:#ff0000;">$1</span>',
'/ (.+) /isU' => '<span style="color:#00bb00;">$1</span>',
'/ (.+) /isU' => '<span style="color:#0000bb;">$1</span>',
'/[white](.+)[/white]/isU' => '<span style="color:#ffffff;">$1</span>');
$text= preg_replace(array_keys($bbcode), array_values($bbcode), $text);
$text = preg_replace('/
{1}/', '<img src="$1"/>', $text);
return nl2br($text);
}
/*
========================
Куки
========================
*/
session_start();
if(mysql_result(mysql_query("SELECT count(id) from `ipban` where `ip` = '".check($_SERVER['REMOTE_ADDR'])."'"),0) >= 1){
echo'Ваш IP заблокирован.'; exit;
}
if(isset($_COOKIE['nick']) && isset($_COOKIE['pass'])) {
$usernick = check($_COOKIE['nick']);
$userpass = check($_COOKIE['pass']);
$user = mysql_fetch_assoc(mysql_query("SELECT * FROM `user` WHERE `nick` =
'$usernick' && `pass` = '$userpass' LIMIT
1"));
}
// Дальнейшее обращение к пользователю $user['nick']
$act = isset($_GET['act']) ? htmlspecialchars($_GET['act']) : '';
// Постраничная навигация
if ($user['set_p_str']!=NULL)
$set['p_str'] = $user['set_p_str'];
mysql_query("update `user` set `online` = '".time()."', `ip` = '".htmlspecialchars(mysql_real_escape_string($_SERVER['REMOTE_ADDR']))."' where (`id` = '".$user['id']."') LIMIT 1");
mysql_query("update `user` set `health` = '".($user['health'] < $user['max_health'] ? ($user['health']+3) : ($user['health']+0) )."' where (`id` = '".$user['id']."') LIMIT 1");
$param = $user[sila] + $user[lovk] + $user[zashit] + $user[max_health];
mysql_query("UPDATE `user` SET `param` = '$param' WHERE `id` = '$user[id]' LIMIT 1");
if($user[health] < 0)mysql_query("UPDATE `user` SET `health` = '0' WHERE `id` = '$user[id]' LIMIT 1");
function pagenav($base_url, $start, $max_value, $num_per_page) {
////////////////////////////////////////////////////////////
// Функция постраничной навигации //
////////////////////////////////////////////////////////////
// За основу взята аналогичная функция от форума SMF2.0 //
////////////////////////////////////////////////////////////
$pgcont = 4;
$pgcont = (int)($pgcont - ($pgcont % 2)) / 2;
if ($start >= $max_value)
$start = max(0, (int)$max_value - (((int)$max_value % (int)$num_per_page) == 0 ? $num_per_page : ((int)$max_value % (int)$num_per_page)));
else
$start = max(0, (int)$start - ((int)$start % (int)$num_per_page));
$base_link = '<a href="' . strtr($base_url, array ('%' => '%%')) . 'starts=%d' . '">%s</a> ';
$pageindex = $start == 0 ? '' : sprintf($base_link, $start - $num_per_page, '<<');
if ($start > $num_per_page * $pgcont)
$pageindex .= sprintf($base_link, 0, '1');
if ($start > $num_per_page * ($pgcont + 1))
$pageindex .= '<span style="font-weight: small;"> ... </span>';
for ($nCont = $pgcont; $nCont >= 1; $nCont--)
if ($start >= $num_per_page * $nCont) {
$tmpStart = $start - $num_per_page * $nCont;
$pageindex .= sprintf($base_link, $tmpStart, $tmpStart / $num_per_page + 1);
}
$pageindex .= '[<b>' . ($start / $num_per_page + 1) . '</b>] ';
$tmpMaxPages = (int)(($max_value - 1) / $num_per_page) * $num_per_page;
for ($nCont = 1; $nCont <= $pgcont; $nCont++)
if ($start + $num_per_page * $nCont <= $tmpMaxPages) {
$tmpStart = $start + $num_per_page * $nCont;
$pageindex .= sprintf($base_link, $tmpStart, $tmpStart / $num_per_page + 1);
}
if ($start + $num_per_page * ($pgcont + 1) < $tmpMaxPages)
$pageindex .= '<span style="f
________
посл. ред. 02.09.2015 в 14:08; всего 1 раз(а); by vitekya3
вот данные... vit306_admin это база а пароль пускай будет 111111 ну пароль я не даю верный. а вот подставь..
<?php
/*
Определяем текущий домен сайта.
Дальнейшее использование
echo $set['site'];
*/
$set['site'] = htmlspecialchars($_SERVER['HTTP_HOST']);
/*
Записываем в константу полный путь до корня сайта.
Я обычно использую в функции require_once, т.к при указании полного пути до файла, файл находится быстрее
*/
define("H", $_SERVER["DOCUMENT_ROOT"].'/');
/*
==========================
Подключение к базе
==========================
*/
ob_start();
$db = mysql_connect('localhost','vit306_admin','vi');
mysql_query('SET NAMES`utf8`',$db);
// Устанавливаем кодировку по умолчанию
mysql_select_db('vit306_admin',$db);
// Загрузка остальных плагинов из папки "core/function/"
$opdirbase = opendir(H.'core/function/');
while ($filebase = readdir($opdirbase))
{
if (preg_match('#.php$#i', $filebase))
{
require_once(H.'core/function/' . $filebase);
}
}
function smiles($text){
$aa = mysql_query("SELECT name,adres FROM `smiles` order by `id` desc");
while($ba = mysql_fetch_assoc($aa)){
$text=str_replace($ba['name'],'<img src="'.$ba['adres'].'" alt="smile" />', $text);
}
$bbcode = array(
'/ (.+) /isU' => '<em>$1</em>',
'/ (.+) /isU' => '<strong>$1</strong>',
'/ (.+) /isU' => '<span style="text-decoration:underline;">$1</span>',
'/[big](.+)[/big]/isU' => '<span style="font-size:large;">$1</span>',
'/
(.+)
/isU' => '<center>$1</center>', '/[small](.+)[/small]/isU' => '<span style="font-size:xx-small;">$1</span>',
'/ (.+) /isU' => '<span style="color:#ff0000;">$1</span>',
'/ (.+) /isU' => '<span style="color:#00bb00;">$1</span>',
'/ (.+) /isU' => '<span style="color:#0000bb;">$1</span>',
'/[white](.+)[/white]/isU' => '<span style="color:#ffffff;">$1</span>');
$text= preg_replace(array_keys($bbcode), array_values($bbcode), $text);
$text = preg_replace('/
{1}/', '<img src="$1"/>', $text); return nl2br($text);
}
/*
========================
Куки
========================
*/
session_start();
if(mysql_result(mysql_query("SELECT count(id) from `ipban` where `ip` = '".check($_SERVER['REMOTE_ADDR'])."'"),0) >= 1){
echo'Ваш IP заблокирован.'; exit;
}
if(isset($_COOKIE['nick']) && isset($_COOKIE['pass'])) {
$usernick = check($_COOKIE['nick']);
$userpass = check($_COOKIE['pass']);
$user = mysql_fetch_assoc(mysql_query("SELECT * FROM `user` WHERE `nick` =
'$usernick' && `pass` = '$userpass' LIMIT
1"));
}
// Дальнейшее обращение к пользователю $user['nick']
$act = isset($_GET['act']) ? htmlspecialchars($_GET['act']) : '';
// Постраничная навигация
if ($user['set_p_str']!=NULL)
$set['p_str'] = $user['set_p_str'];
mysql_query("update `user` set `online` = '".time()."', `ip` = '".htmlspecialchars(mysql_real_escape_string($_SERVER['REMOTE_ADDR']))."' where (`id` = '".$user['id']."') LIMIT 1");
mysql_query("update `user` set `health` = '".($user['health'] < $user['max_health'] ? ($user['health']+3) : ($user['health']+0) )."' where (`id` = '".$user['id']."') LIMIT 1");
$param = $user[sila] + $user[lovk] + $user[zashit] + $user[max_health];
mysql_query("UPDATE `user` SET `param` = '$param' WHERE `id` = '$user[id]' LIMIT 1");
if($user[health] < 0)mysql_query("UPDATE `user` SET `health` = '0' WHERE `id` = '$user[id]' LIMIT 1");
function pagenav($base_url, $start, $max_value, $num_per_page) {
////////////////////////////////////////////////////////////
// Функция постраничной навигации //
////////////////////////////////////////////////////////////
// За основу взята аналогичная функция от форума SMF2.0 //
////////////////////////////////////////////////////////////
$pgcont = 4;
$pgcont = (int)($pgcont - ($pgcont % 2)) / 2;
if ($start >= $max_value)
$start = max(0, (int)$max_value - (((int)$max_value % (int)$num_per_page) == 0 ? $num_per_page : ((int)$max_value % (int)$num_per_page)));
else
$start = max(0, (int)$start - ((int)$start % (int)$num_per_page));
$base_link = '<a href="' . strtr($base_url, array ('%' => '%%')) . 'starts=%d' . '">%s</a> ';
$pageindex = $start == 0 ? '' : sprintf($base_link, $start - $num_per_page, '<<');
if ($start > $num_per_page * $pgcont)
$pageindex .= sprintf($base_link, 0, '1');
if ($start > $num_per_page * ($pgcont + 1))
$pageindex .= '<span style="font-weight: small;"> ... </span>';
for ($nCont = $pgcont; $nCont >= 1; $nCont--)
if ($start >= $num_per_page * $nCont) {
$tmpStart = $start - $num_per_page * $nCont;
$pageindex .= sprintf($base_link, $tmpStart, $tmpStart / $num_per_page + 1);
}
$pageindex .= '[<b>' . ($start / $num_per_page + 1) . '</b>] ';
$tmpMaxPages = (int)(($max_value - 1) / $num_per_page) * $num_per_page;
for ($nCont = 1; $nCont <= $pgcont; $nCont++)
if ($start + $num_per_page * $nCont <= $tmpMaxPages) {
$tmpStart = $start + $num_per_page * $nCont;
$pageindex .= sprintf($base_link, $tmpStart, $tmpStart / $num_per_page + 1);
}
if ($start + $num_per_page * ($pgcont + 1) < $tmpMaxPages)
$pageindex .= '<span style="f
________
посл. ред. 02.09.2015 в 14:08; всего 1 раз(а); by vitekya3
$db = mysql_connect('localhost','имя пользователя БД','пароль БД');
mysql_query('SET NAMES`utf8`',$db);
mysql_select_db('имя БД',$db);
a в первом
ну я прописал а пишет вот что
Warning: mysql_connect(): Access denied for user 'vit306_admin'@'localhost' (using password: YES) in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 19
Warning: mysql_query() expects parameter 2 to be resource, boolean given in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 20
Warning: mysql_select_db() expects parameter 2 to be resource, boolean given in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 22
Notice: Undefined index: miniS in /var/www/vit306/data/www/warbitva.ru/core/function/games.php on line 2
Warning: preg_match(): Unknown modifier 'c' in /var/www/vit306/data/www/warbitva.ru/core/function/ddos.php on line 19
Notice: A session had already been started - ignoring session_start() in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 62
Warning: mysql_real_escape_string(): Access denied for user ''@'localhost' (using password: NO) in /var/www/vit306/data/www/warbitva.ru/core/function/text.php on line 6
Warning: mysql_real_escape_string(): A link to the server could not be established in /var/www/vit306/data/www/warbitva.ru/core/function/text.php on line 6
Warning: mysql_query(): Access denied for user ''@'localhost' (using password: NO) in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 64
Warning: mysql_query(): A link to the server could not be established in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 64
Warning: mysql_result() expects parameter 1 to be resource, boolean given in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 64
Warning: mysql_real_escape_string(): Access denied for user ''@'localhost' (using password: NO) in /var/www/vit306/data/www/warbitva.ru/core/function/text.php on line 6
Warning: mysql_real_escape_string(): A link to the server could not be established in /var/www/vit306/data/www/warbitva.ru/core/function/text.php on line 6
Warning: mysql_real_escape_string(): Access denied for user ''@'localhost' (using password: NO) in /var/www/vit306/data/www/warbitva.ru/core/function/text.php on line 6
Warning: mysql_real_escape_string(): A link to the server could not be established in /var/www/vit306/data/www/warbitva.ru/core/function/text.php on line 6
Warning: mysql_query(): Access denied for user ''@'localhost' (using password: NO) in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 73
Warning: mysql_query(): A link to the server could not be established in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 73
Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 73
Warning: mysql_real_escape_string(): Access denied for user ''@'localhost' (using password: NO) in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 80
Warning: mysql_real_escape_string(): A link to the server could not be established in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 80
Warning: mysql_query(): Access denied for user ''@'localhost' (using password: NO) in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 80
Warning: mysql_query(): A link to the server could not be established in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 80
Warning: mysql_query(): Access denied for user ''@'localhost' (using password: NO) in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 81
Warning: mysql_query(): A link to the server could not be established in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 81
Notice: Use of undefined constant sila - assumed 'sila' in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 82
Notice: Use of undefined constant lovk - assumed 'lovk' in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 82
Notice: Use of undefined constant zashit - assumed 'zashit' in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 82
Notice: Use of undefined constant max_health - assumed 'max_health' in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 82
Warning: mysql_query(): Access denied for user ''@'localhost' (using password: NO) in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 83
Warning: mysql_query(): A link to the server could not be established in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 83
Notice: Use of undefined constant health - assumed 'health' in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 84
Warning: mysql_real_escape_string(): Access denied for user ''@'localhost' (using password: NO) in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 157
Warning: mysql_real_escape_string(): A link to the server could not be established in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 157
Warning: mysql_real_escape_string(): Access denied for user ''@'localhost' (using password: NO) in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 160
Warning: mysql_real_escape_string(): A link to the server could not be established in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 160
Warning: mysql_real_escape_string(): Access denied for user ''@'localhost' (using password: NO) in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 160
Warning: mysql_real_escape_string(): A link to the server could not be established in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 160
Warning: mysql_real_escape_string(): Access denied for user ''@'localhost' (using password: NO) in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 160
Warning: mysql_real_escape_string(): A link to the server could not be established in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 160
Warning: mysql_query(): Access denied for user ''@'localhost' (using password: NO) in /var/www/vit306/data/www/warbitva.ru/c
ну я прописал а пишет вот что
Warning: mysql_connect(): Access denied for user 'vit306_admin'@'localhost' (using password: YES) in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 19
Warning: mysql_query() expects parameter 2 to be resource, boolean given in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 20
Warning: mysql_select_db() expects parameter 2 to be resource, boolean given in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 22
Notice: Undefined index: miniS in /var/www/vit306/data/www/warbitva.ru/core/function/games.php on line 2
Warning: preg_match(): Unknown modifier 'c' in /var/www/vit306/data/www/warbitva.ru/core/function/ddos.php on line 19
Notice: A session had already been started - ignoring session_start() in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 62
Warning: mysql_real_escape_string(): Access denied for user ''@'localhost' (using password: NO) in /var/www/vit306/data/www/warbitva.ru/core/function/text.php on line 6
Warning: mysql_real_escape_string(): A link to the server could not be established in /var/www/vit306/data/www/warbitva.ru/core/function/text.php on line 6
Warning: mysql_query(): Access denied for user ''@'localhost' (using password: NO) in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 64
Warning: mysql_query(): A link to the server could not be established in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 64
Warning: mysql_result() expects parameter 1 to be resource, boolean given in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 64
Warning: mysql_real_escape_string(): Access denied for user ''@'localhost' (using password: NO) in /var/www/vit306/data/www/warbitva.ru/core/function/text.php on line 6
Warning: mysql_real_escape_string(): A link to the server could not be established in /var/www/vit306/data/www/warbitva.ru/core/function/text.php on line 6
Warning: mysql_real_escape_string(): Access denied for user ''@'localhost' (using password: NO) in /var/www/vit306/data/www/warbitva.ru/core/function/text.php on line 6
Warning: mysql_real_escape_string(): A link to the server could not be established in /var/www/vit306/data/www/warbitva.ru/core/function/text.php on line 6
Warning: mysql_query(): Access denied for user ''@'localhost' (using password: NO) in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 73
Warning: mysql_query(): A link to the server could not be established in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 73
Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 73
Warning: mysql_real_escape_string(): Access denied for user ''@'localhost' (using password: NO) in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 80
Warning: mysql_real_escape_string(): A link to the server could not be established in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 80
Warning: mysql_query(): Access denied for user ''@'localhost' (using password: NO) in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 80
Warning: mysql_query(): A link to the server could not be established in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 80
Warning: mysql_query(): Access denied for user ''@'localhost' (using password: NO) in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 81
Warning: mysql_query(): A link to the server could not be established in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 81
Notice: Use of undefined constant sila - assumed 'sila' in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 82
Notice: Use of undefined constant lovk - assumed 'lovk' in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 82
Notice: Use of undefined constant zashit - assumed 'zashit' in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 82
Notice: Use of undefined constant max_health - assumed 'max_health' in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 82
Warning: mysql_query(): Access denied for user ''@'localhost' (using password: NO) in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 83
Warning: mysql_query(): A link to the server could not be established in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 83
Notice: Use of undefined constant health - assumed 'health' in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 84
Warning: mysql_real_escape_string(): Access denied for user ''@'localhost' (using password: NO) in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 157
Warning: mysql_real_escape_string(): A link to the server could not be established in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 157
Warning: mysql_real_escape_string(): Access denied for user ''@'localhost' (using password: NO) in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 160
Warning: mysql_real_escape_string(): A link to the server could not be established in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 160
Warning: mysql_real_escape_string(): Access denied for user ''@'localhost' (using password: NO) in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 160
Warning: mysql_real_escape_string(): A link to the server could not be established in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 160
Warning: mysql_real_escape_string(): Access denied for user ''@'localhost' (using password: NO) in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 160
Warning: mysql_real_escape_string(): A link to the server could not be established in /var/www/vit306/data/www/warbitva.ru/core/system.php on line 160
Warning: mysql_query(): Access denied for user ''@'localhost' (using password: NO) in /var/www/vit306/data/www/warbitva.ru/c