= 10000 && $i < 1000000) {
}
elseif($i >= 1000000) {
}
else
{
$i = number_format($i, 0, '', '\'');
}
return $i;
}
function pages($path){
global $page, $pages;
if ($page-3 > 0) $a='1';
if ($page-2 > 0) $d=''.($page-2).'';
if ($page-1 > 0) $e=''.($page-1).'';
if ($page+1 <= $pages) $v=''.($page+1).'';
if ($page+2 <= $pages) $w=''.($page+2).'';
if ($page+3 <= $pages) $z=''.$pages.'';
echo' '.$a.$b.$c.$d.$e.' '.$page.' '.$v.$w.$x.$y.$z.'
';
}
//////////////////////////////////////////////////////
///////////////////////////////////////////////
function _time($i) {
$d = floor(($i / 86400) - $d * 24); //Считаем дни
$h = floor(($i / 3600) - $d * 24); //Считаем часы
$m = floor(($i - $h * 3600 - $d * 86400) / 60); //Считаем минуты
if($h == '0'){
$s = $i - ($m * 60 + $h * 3600 + $d * 86400); //Считаем секунды
}
return ($d > 0 ? ($d < 10 ? '':'').$d.'д ':'').($h > 0 ? ($h < 10 ? '':'').$h.'ч ':'').($m > 0 ? ($m < 10 ? '':'').$m.'м ':'').($s > 0 ? ($s < 10 ? '0':'').$s.'с':'');
}
/////////////////////////////////////////////////////
///////////////////////////////////////////////
function bb($string) {
$string = str_replace("\r\n","
",$string);
return $string;
}
function _times($i) {
$d = floor($i / 86400);
$h = floor(($i / 3600) - $d * 24);
$m = floor(($i - $h * 3600 - $d * 86400) / 60);
$s = $i - ($m * 60 + $h * 3600 + $d * 86400);
if($d > 0) {
$result = $d.' д';
}
elseif($h > 0)
{
$result = $h.' ч';
}elseif($m > 0)
{
$result = $m.' мин';
}elseif($s >= 0)
{
$result = $s.' сек';
}
return $result.' назад';
}
//////////////////////////////////////////
###############################
############ Время ############
###############################
function vremja($time = NULL) {
if(!$time) $time = time();
$data = date('j.n.y', $time);
if($data == date('j.n.y')) $res = 'Сегодня в '. date('G:i', $time);
elseif($data == date('j.n.y', time() - 86400)) $res = 'Вчера в '. date('G:i', $time);
elseif($data == date('j.n.y', time() - 172800)) $res = 'Позавчера в '. date('G:i', $time);
else {
$m = array('0',
'Янв', 'Фев',
'Мар', 'Апр', 'Май',
'Июн', 'Июл', 'Авг',
'Сен', 'Окт', 'Ноя',
'Дек');
$res = date('j '. $m[date('n', $time)] .' Y в G:i', $time);
$res = str_replace(date('Y'), '', $res);
}
return $res;
}
/////////////////////////////////////////
function mes($ok = NULL){
$m = '';
return $m;
}
//////////////////////////////////////////////////////
function nick($id){
global $HOME;
$users = mysql_fetch_array(mysql_query("SELECT * FROM `users` WHERE `id` = '".$id."' LIMIT 1"));
//-----Если пол == 1(мужской)-----//
if($users['sex'] == 0)
{
//-----Если онлайн-----//
if($users['online'] > time()-360)
{
$p = '
';
} else {
$p = '
';
}
}
//-----Если пол == 2(жен)-----//
elseif($users['sex'] == 1)
{
if($users['online'] > time()-360)
{
$p = '
';
} else {
$p = '
';
}
}
$us=null;
if($users['access']==1) $us='[Мд]';
if($users['access']==2) $us='[Адм]';
if($users['access']==3) $us='[Соз]';
if($users['id']==2) $us='[Системный робот]';
return (empty($users)?'[Удален]':' '.$p.''.$users['login'].' '.$us.'');
}
///////////////////////////////////////////
function color($id){//Цвет сообщений
global $HOME;
$users = mysql_fetch_array(mysql_query("SELECT * FROM `users` WHERE `id` = '".$id."' LIMIT 1"));
$color=null;
if($users['access']==0) $color='#61646a'; //Цвет для юзеров
if($users['access']==1) $color='#E3D104'; //Цвет для модераторов
if($users['access']==2) $color='#5CB85C'; //Цвет для админов
if($users['access']==3) $color='#D9534F'; //Цвет для создателей
if($users['id']==2) $color='#B2CDAE'; //Цвет для системного робота
return $color;
}
///////////////////////////////////////////////
function bbcode($msg){
$msg = stripslashes($msg);
$msg = preg_replace('#\[center\](.*?)\[\/center\]#si', '\1', $msg); //По центру
$msg = preg_replace('#\[s\](.*?)\[\/s\]#si', '\1', $msg); //Зачеркнутый
$msg = preg_replace('#\[i\](.*?)\[\/i\]#si', '\1', $msg); //Курсив
$msg = preg_replace('#\[b\](.*?)\[/b\]#si', ' \1 ', $msg); //Жирный
$msg = preg_replace('#\[u\](.*?)\[\/u\]#si', '\1', $msg); //Подчеркнутый
$msg = preg_replace('#\[small\](.*?)\[\/small\]#si', '\1', $msg); //Мелкий
$msg = preg_replace('#\[white\](.*?)\[\/white\]#si', '\1', $msg); //Белый
$msg = preg_replace('#\[red\](.*?)\[\/red\]#si', '\1', $msg); //Красный
$msg = preg_replace('#\[lime\](.*?)\[\/lime\]#si', '\1', $msg); //Зеленый
$msg = preg_replace('#\[yellow\](.*?)\[\/yellow\]#si', '\1', $msg); //Желтый
$msg = preg_replace('#\[violet\](.*?)\[\/violet\]#si', '\1', $msg); //Фиолетовый
$msg = preg_replace('#\[pink\](.*?)\[\/pink\]#si', '\1', $msg); //Розовый
$msg = preg_replace('#\[blue\](.*?)\[\/blue\]#si', '\1', $msg); //Синий
$msg = preg_replace('#\[orange\](.*?)\[\/orange\]#si', '\1', $msg); //Оранжевый
$msg = preg_replace('#\[silver\](.*?)\[\/silver\]#si', '\1', $msg); //Серебристый
$msg = preg_replace('#\[cyan\](.*?)\[\/cyan\]#si', '\1', $msg); //Сине-зеленый
$msg = preg_replace('/\[url\s?=\s?([\'"]?)(?:http:\/\/'.$_SERVER['HTTP_HOST'].')?(.*?)\1\](.*?)\[\/url\]/', ' $3 ', $msg);
$msg = preg_replace('/\[img\s?=\s?([0-9]+)\](?:http:\/\/'.$_SERVER['HTTP_HOST'].')?(.*?)\[\/img\]/', ' 
', $msg);
return $msg;
}
###############################
############ Смайлы ###########
###############################
function smile($msg) {
$msg = str_replace(array('@_@'), '
', $msg);
$msg = str_replace(array(':P'), '
', $msg);
$msg = str_replace(array(';)'), '
', $msg);
$msg = str_replace(array('8/'), '
', $msg);
$msg = str_replace(array(';('), '
', $msg);
$msg = str_replace(array(':['), '
', $msg);
$msg = str_replace(array(':]'), '![:]](/images/ico/smiles/07.png)
', $msg);
$msg = str_replace(array(':/['), '
', $msg);
$msg = str_replace(array(':D'), '
', $msg);
$msg = str_replace(array(':*'), '
', $msg);
$msg = str_replace(array(';O'), '
', $msg);
$msg = str_replace(array(':O'), '
', $msg);
$msg = str_replace(array(':}'), '
', $msg);
$msg = str_replace(array(':('), '
', $msg);
$msg = str_replace(array(':)'), '
', $msg);
$msg = str_replace(array('-:-'), '
', $msg);
$msg = str_replace(array('=:='), '
', $msg);
$msg = str_replace(array(':!'), '
', $msg);
$msg = str_replace(array('V:V'), '
', $msg);
$msg = str_replace(array('#\[img](.+?)\[/img]#'), '
', $msg);
return $msg;
}
/////////////////////////////////////////////////
///////////////////////////////////////////////////
?> 0 && $clan_buff) {
$user['str'] += $clan_buff;
$user['vit'] += $clan_buff;
$user['def'] += $clan_buff;
}
}
/////////////////////////////Если игрок в бане///////////////////////////////
$ban = mysql_fetch_array(mysql_query('SELECT * FROM `ban` WHERE `user` = "'.$user['id'].'"'));
if($ban) {
if($ban['time'] <=time()) {
mysql_query('DELETE FROM `ban` WHERE `user` = "'.$user['id'].'"');
}
}
/////////////////////////////Если игрок в блоке///////////////////////////////
$block = mysql_fetch_array(mysql_query('SELECT * FROM `block` WHERE `user` = "'.$user['id'].'"'));
if($block) {
if($block['time'] <=time()) {
mysql_query('DELETE FROM `block` WHERE `user` = "'.$user['id'].'"');
}
if($block['time'] > time() && $_SERVER['PHP_SELF'] != '/block.php') {
header('location: /block.php');
exit;
}
}
//////////////////////////////////////////////////////////////////////
//////////////ПРЕМИК///////////////////////////////////
$premium = mysql_fetch_array(mysql_query('SELECT * FROM `premium` WHERE `user` = "'.$user['id'].'"'));
if($premium) {
if($premium['time'] < time()) {
mysql_query('UPDATE `users` SET `str` = `str` - 200,
`vit` = `vit` - 200,
`def` = `def` - 200 WHERE `id` = \''.$user['id'].'\'');
mysql_query('DELETE FROM `premium` WHERE `user` = \''.$user['id'].'\'');
}
}
////////////////////////////////////////////////////////
//////////////Вторжение, камень///////////////////////////////////
$invasion_stone = mysql_fetch_array(mysql_query('SELECT * FROM `invasion_stone` WHERE `user` = "'.$user['id'].'"'));
if($invasion_stone) {
if($invasion_stone['time'] < time()) {
mysql_query('UPDATE `users` SET `str` = `str` - 250,
`vit` = `vit` - 250,
`def` = `def` - 250 WHERE `id` = \''.$user['id'].'\'');
mysql_query('DELETE FROM `invasion_stone` WHERE `user` = \''.$user['id'].'\'');
}
}
///////////////////////////////////////////////////////
//Задания
////////////////////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////////////////
////////////////////////////// Обновление новых квестов////////////////////////////
//Добавляем только ежеднемные задания
$req_task = mysql_query ('select * from `task_user` WHERE (`user`="' . $user['id'] . '") AND (`complete`="0") AND (`type`="daily")');
if (mysql_num_rows ($req_task) < 10) {
// Обновление квестов
$req_task = mysql_query ('select * from `task` WHERE (`type`="daily")');
$i_task = 0;
while ($task__ = mysql_fetch_array ($req_task)) {
$q_task = mysql_query ('SELECT * FROM `task_user` WHERE (`user`="' . $user['id'] . '") AND (`task`="' . $task__['id'] . '") AND (`type`="daily")');
if (mysql_num_rows ($q_task)==0) {
$i_task++;
if ($i_task <10) {
mysql_query ('INSERT INTO `task_user` (`user`, `task`, `type`) VALUES ("'.$user['id'].'", "'.$task__['id'].'", "'.$task__['type'].'") ');
}}}
}
////////////////////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////////////////
/* mysql_query("DELETE FROM `task_user` WHERE `user` = '".$user['id']."' AND `glava` = '".$user['lair_glava']."' AND `type` = 'storyline' AND `complete` = '1' "); //удаляем все выполненые задания
mysql_query("UPDATE `users` SET `lair_glava`=`lair_glava`+'1' WHERE `id`='".$user['id']."' ");
*/
////////////////////////////// Обновление новых квестов////////////////////////////
//Добавляем только сюжетные задания
$req_task = mysql_query ('select * from `task_user` WHERE (`user`="' . $user['id'] . '") AND (`complete`="0") AND (`type`="storyline")');
if (mysql_num_rows ($req_task) == 0) {
$req_task = mysql_query ('select * from `task` WHERE (`type`="storyline") AND (`glava`="'.$user['lair_glava'].'") ');
$i_task = 0;
while ($task__ = mysql_fetch_array ($req_task)) {
$q_task = mysql_query ('SELECT * FROM `task_user` WHERE (`user`="'.$user['id'].'") AND (`glava`="'.$user['lair_glava'].'") AND (`task`="'.$task__['id'].'") AND (`type`="storyline")');
if (mysql_num_rows ($q_task)==0) {
mysql_query ('INSERT INTO `task_user` (`user`, `task`, `type`) VALUES ("'.$user['id'].'", "'.$task__['id'].'", "'.$task__['type'].'") ');
}}
}
/////////////////////////
}
?>1){$lair=1;}
if($user['lair']>2){$lair=2;}
if($user['lair']>3){$lair=3;}
$task = mysql_fetch_array(mysql_query ('SELECT * FROM `task` WHERE (`id`="'.$task_id.'")'));
if ($t['how'] < $task['how']){
mysql_query ('UPDATE `task_user` SET `how`="'.$lair.'" WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'")');
}}}
/////////////////////////
$task_id=10;// Улучши амулет
$req = mysql_query('select * from `task_user` WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'") AND (`complete`="0")');
if (mysql_num_rows ($req) != 0) {
while ($t = mysql_fetch_array ($req)) {
$task = mysql_fetch_array(mysql_query ('SELECT * FROM `task` WHERE (`id`="'.$task_id.'")'));
if ($t['how'] < $task['how']){
mysql_query ('UPDATE `task_user` SET `how`="'.$user['amulet'].'" WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'")');
}}}
/////////////////////////
$task_id=12;// Тренируй силу до 15
$req = mysql_query('select * from `task_user` WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'") AND (`complete`="0")');
if (mysql_num_rows ($req) != 0) {
while ($t = mysql_fetch_array ($req)) {
$task = mysql_fetch_array(mysql_query ('SELECT * FROM `task` WHERE (`id`="'.$task_id.'")'));
if ($t['how'] < $task['how']){
if($user['_str'] < '15'){
mysql_query ('UPDATE `task_user` SET `how`="'.($user['_str']*3).'" WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'")');
}else{
mysql_query ('UPDATE `task_user` SET `how`=15 WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'")');
}}}}
/////////////////////////
$item_13=mysql_result(mysql_query('SELECT COUNT(*) FROM `inv` WHERE `user`= "'.$user['id'].'" AND `quality` >= "1" AND `equip`="1" '),0);
$task_id=13;// Надень 8 простых вещей
$req = mysql_query('select * from `task_user` WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'") AND (`complete`="0")');
if (mysql_num_rows ($req) != 0) {
while ($t = mysql_fetch_array ($req)) {
$task = mysql_fetch_array(mysql_query ('SELECT * FROM `task` WHERE (`id`="'.$task_id.'")'));
if ($t['how'] < $task['how']){
mysql_query ('UPDATE `task_user` SET `how`="'.$item_13.'" WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'")');
}}}
/////////////////////////
$task_id=15;// Набери 125 здоровья
$req = mysql_query('select * from `task_user` WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'") AND (`complete`="0")');
if (mysql_num_rows ($req) != 0) {
while ($t = mysql_fetch_array ($req)) {
$task = mysql_fetch_array(mysql_query ('SELECT * FROM `task` WHERE (`id`="'.$task_id.'")'));
if ($t['how'] < $task['how']){
if($user['vit'] < '125'){
mysql_query ('UPDATE `task_user` SET `how`="'.$user['vit'].'" WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'")');
}else{
mysql_query ('UPDATE `task_user` SET `how`=125 WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'")');
}}}}
/////////////////////////
$item_16=mysql_result(mysql_query('SELECT COUNT(*) FROM `inv` WHERE `user`= "'.$user['id'].'" AND `smith` >= "1" AND `equip`="1" '),0);
$task_id=16;// Заточи все вещи на +1
$req = mysql_query('select * from `task_user` WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'") AND (`complete`="0")');
if (mysql_num_rows ($req) != 0) {
while ($t = mysql_fetch_array ($req)) {
$task = mysql_fetch_array(mysql_query ('SELECT * FROM `task` WHERE (`id`="'.$task_id.'")'));
if ($t['how'] < $task['how']){
mysql_query ('UPDATE `task_user` SET `how`="'.$item_16.'" WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'")');
}}}
////////////////////////////
$task_id=17;// Убей оборотня в пещере
$req = mysql_query('select * from `task_user` WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'") AND (`complete`="0")');
if (mysql_num_rows ($req) != 0) {
while ($t = mysql_fetch_array ($req)) {
if($user['lair']>4){$lair=1;}
$task = mysql_fetch_array(mysql_query ('SELECT * FROM `task` WHERE (`id`="'.$task_id.'")'));
if ($t['how'] < $task['how'] AND $user['lair'] > '4'){
mysql_query ('UPDATE `task_user` SET `how`="'.$lair.'" WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'")');
}}}
/////////////////////////
//2-я глава
////////////////////////
$task_id=18;// Убей 3 орков
$req = mysql_query('select * from `task_user` WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'") AND (`complete`="0")');
if (mysql_num_rows ($req) != 0) {
while ($t = mysql_fetch_array ($req)) {
if($user['lair']>5){$lair=1;}
if($user['lair']>6){$lair=2;}
if($user['lair']>7){$lair=3;}
$task = mysql_fetch_array(mysql_query ('SELECT * FROM `task` WHERE (`id`="'.$task_id.'")'));
if ($t['how'] < $task['how']){
mysql_query ('UPDATE `task_user` SET `how`="'.$lair.'" WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'")');
}}}
/////////////////////////
$task_id=20;// Тренируй броню до 30
$req = mysql_query('select * from `task_user` WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'") AND (`complete`="0")');
if (mysql_num_rows ($req) != 0) {
while ($t = mysql_fetch_array ($req)) {
$task = mysql_fetch_array(mysql_query ('SELECT * FROM `task` WHERE (`id`="'.$task_id.'")'));
if ($t['how'] < $task['how']){
if($user['_def'] < '30'){
mysql_query ('UPDATE `task_user` SET `how`="'.($user['_def']*3).'" WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'")');
}else{
mysql_query ('UPDATE `task_user` SET `how`=30 WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'")');
}}}}
/////////////////////////
$item_21=mysql_result(mysql_query('SELECT COUNT(*) FROM `inv` WHERE `user`= "'.$user['id'].'" AND `smith` >= "2" AND `equip`="1" '),0);
$task_id=21;// Заточи все вещи на +2
$req = mysql_query('select * from `task_user` WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'") AND (`complete`="0")');
if (mysql_num_rows ($req) != 0) {
while ($t = mysql_fetch_array ($req)) {
$task = mysql_fetch_array(mysql_query ('SELECT * FROM `task` WHERE (`id`="'.$task_id.'")'));
if ($t['how'] < $task['how']){
mysql_query ('UPDATE `task_user` SET `how`="'.$item_21.'" WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'")');
}}}
/////////////////////////
$task_id=23;// Прокачай умение Ярость до 1 уровня
$req = mysql_query('select * from `task_user` WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'") AND (`complete`="0")');
if (mysql_num_rows ($req) != 0) {
while ($t = mysql_fetch_array ($req)) {
$task = mysql_fetch_array(mysql_query ('SELECT * FROM `task` WHERE (`id`="'.$task_id.'")'));
if ($t['how'] < $task['how']){
if($user['ability_1'] >= '1'){
mysql_query ('UPDATE `task_user` SET `how`=1 WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'")');
}}}}
/////////////////////////
$task_id=24;// Набери 330 здоровья
$req = mysql_query('select * from `task_user` WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'") AND (`complete`="0")');
if (mysql_num_rows ($req) != 0) {
while ($t = mysql_fetch_array ($req)) {
$task = mysql_fetch_array(mysql_query ('SELECT * FROM `task` WHERE (`id`="'.$task_id.'")'));
if ($t['how'] < $task['how']){
if($user['vit'] < '330'){
mysql_query ('UPDATE `task_user` SET `how`="'.$user['vit'].'" WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'")');
}else{
mysql_query ('UPDATE `task_user` SET `how`=330 WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'")');
}}}}
/////////////////////////
$task_id=27;// Убей горного троля
$req = mysql_query('select * from `task_user` WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'") AND (`complete`="0")');
if (mysql_num_rows ($req) != 0) {
while ($t = mysql_fetch_array ($req)) {
if($user['lair']>8){$lair=1;}
$task = mysql_fetch_array(mysql_query ('SELECT * FROM `task` WHERE (`id`="'.$task_id.'")'));
if ($t['how'] < $task['how'] AND $user['lair'] > '8'){
mysql_query ('UPDATE `task_user` SET `how`="'.$lair.'" WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'")');
}}}
/////////////////////////
//3-я глава
////////////////////////
$task_id=28;// Убей 3 зомби
$req = mysql_query('select * from `task_user` WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'") AND (`complete`="0")');
if (mysql_num_rows ($req) != 0) {
while ($t = mysql_fetch_array ($req)) {
if($user['lair']>9){$lair=1;}
if($user['lair']>10){$lair=2;}
if($user['lair']>11){$lair=3;}
$task = mysql_fetch_array(mysql_query ('SELECT * FROM `task` WHERE (`id`="'.$task_id.'")'));
if ($t['how'] < $task['how']){
mysql_query ('UPDATE `task_user` SET `how`="'.$lair.'" WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'")');
}}}
/////////////////////////
$task_id=29;// Улучши амулет до 5
$req = mysql_query('select * from `task_user` WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'") AND (`complete`="0")');
if (mysql_num_rows ($req) != 0) {
while ($t = mysql_fetch_array ($req)) {
$task = mysql_fetch_array(mysql_query ('SELECT * FROM `task` WHERE (`id`="'.$task_id.'")'));
if ($t['how'] < $task['how']){
mysql_query ('UPDATE `task_user` SET `how`="'.$user['amulet'].'" WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'")');
}}}
/////////////////////////
$task_id=30;// Набери 500 брони
$req = mysql_query('select * from `task_user` WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'") AND (`complete`="0")');
if (mysql_num_rows ($req) != 0) {
while ($t = mysql_fetch_array ($req)) {
$task = mysql_fetch_array(mysql_query ('SELECT * FROM `task` WHERE (`id`="'.$task_id.'")'));
if ($t['how'] < $task['how']){
if($user['def'] < '500'){
mysql_query ('UPDATE `task_user` SET `how`="'.$user['def'].'" WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'")');
}else{
mysql_query ('UPDATE `task_user` SET `how`=500 WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'")');
}}}}
/////////////////////////
$task_id=31;// Прокачай все умения до 1 уровня
$req = mysql_query('select * from `task_user` WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'") AND (`complete`="0")');
if (mysql_num_rows ($req) != 0) {
while ($t = mysql_fetch_array ($req)) {
if($user['ability_1']>=1){$ability+=1;}
if($user['ability_2']>=1){$ability+=1;}
if($user['ability_3']>=1){$ability+=1;}
if($user['ability_4']>=1){$ability+=1;}
$task = mysql_fetch_array(mysql_query ('SELECT * FROM `task` WHERE (`id`="'.$task_id.'")'));
if ($t['how'] < $task['how']){
mysql_query ('UPDATE `task_user` SET `how`="'.$ability.'" WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'")');
}}}
/////////////////////////
$item_32=mysql_result(mysql_query('SELECT COUNT(*) FROM `inv` WHERE `user`= "'.$user['id'].'" AND `quality` >= "3" AND `equip`="1" '),0);
$task_id=32;// Надень 6 вещей редкого качества и выше
$req = mysql_query('select * from `task_user` WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'") AND (`complete`="0")');
if (mysql_num_rows ($req) != 0) {
while ($t = mysql_fetch_array ($req)) {
$task = mysql_fetch_array(mysql_query ('SELECT * FROM `task` WHERE (`id`="'.$task_id.'")'));
if ($t['how'] < $task['how']){
mysql_query ('UPDATE `task_user` SET `how`="'.$item_32.'" WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'")');
}}}
/////////////////////////
$item_34=mysql_result(mysql_query('SELECT COUNT(*) FROM `inv` WHERE `user`= "'.$user['id'].'" AND `smith` >= "5" AND `equip`="1" '),0);
$task_id=34;// Заточи все вещи на +5
$req = mysql_query('select * from `task_user` WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'") AND (`complete`="0")');
if (mysql_num_rows ($req) != 0) {
while ($t = mysql_fetch_array ($req)) {
$task = mysql_fetch_array(mysql_query ('SELECT * FROM `task` WHERE (`id`="'.$task_id.'")'));
if ($t['how'] < $task['how']){
mysql_query ('UPDATE `task_user` SET `how`="'.$item_34.'" WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'")');
}}}
///////////////////////
$item_36=mysql_result(mysql_query('SELECT COUNT(*) FROM `inv` WHERE `user`= "'.$user['id'].'" AND `rune` >= "1" AND `equip`="1" '),0);
$task_id=36;// Установи 2 руны обычного качества и выше
$req = mysql_query('select * from `task_user` WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'") AND (`complete`="0")');
if (mysql_num_rows ($req) != 0) {
while ($t = mysql_fetch_array ($req)) {
if($item_36 <= 2){$run=item_36;}else{$run=2;}
$task = mysql_fetch_array(mysql_query ('SELECT * FROM `task` WHERE (`id`="'.$task_id.'")'));
if ($t['how'] < $task['how']){
mysql_query ('UPDATE `task_user` SET `how`="'.$run.'" WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'")');
}}}
/////////////////////////////
$task_id=37;// Набери 600 силы
$req = mysql_query('select * from `task_user` WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'") AND (`complete`="0")');
if (mysql_num_rows ($req) != 0) {
while ($t = mysql_fetch_array ($req)) {
$task = mysql_fetch_array(mysql_query ('SELECT * FROM `task` WHERE (`id`="'.$task_id.'")'));
if ($t['how'] < $task['how']){
if($user['str'] < '600'){
mysql_query ('UPDATE `task_user` SET `how`="'.$user['def'].'" WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'")');
}else{
mysql_query ('UPDATE `task_user` SET `how`=600 WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'")');
}}}}
/////////////////////////
$task_id=38;// Тренируй здоровье до 35
$req = mysql_query('select * from `task_user` WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'") AND (`complete`="0")');
if (mysql_num_rows ($req) != 0) {
while ($t = mysql_fetch_array ($req)) {
$task = mysql_fetch_array(mysql_query ('SELECT * FROM `task` WHERE (`id`="'.$task_id.'")'));
if ($t['how'] < $task['how']){
if($user['_vit'] < '35'){
mysql_query ('UPDATE `task_user` SET `how`="'.($user['_vit']*3).'" WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'")');
}else{
mysql_query ('UPDATE `task_user` SET `how`=35 WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'")');
}}}}
/////////////////////////
$task_id=39;// Найди и убей Вампира
$req = mysql_query('select * from `task_user` WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'") AND (`complete`="0")');
if (mysql_num_rows ($req) != 0) {
while ($t = mysql_fetch_array ($req)) {
if($user['lair']>12){$lair=1;}
$task = mysql_fetch_array(mysql_query ('SELECT * FROM `task` WHERE (`id`="'.$task_id.'")'));
if ($t['how'] < $task['how'] AND $user['lair'] > '12'){
mysql_query ('UPDATE `task_user` SET `how`="'.$lair.'" WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'")');
}}}
/////////////////////////
//4-я глава
////////////////////////
$task_id=40;// Прокачай 4 умения до 3 уровня
$req = mysql_query('select * from `task_user` WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'") AND (`complete`="0")');
if (mysql_num_rows ($req) != 0) {
while ($t = mysql_fetch_array ($req)) {
if($user['ability_1']>=3){$ability+=1;}
if($user['ability_2']>=3){$ability+=1;}
if($user['ability_3']>=3){$ability+=1;}
if($user['ability_4']>=3){$ability+=1;}
$task = mysql_fetch_array(mysql_query ('SELECT * FROM `task` WHERE (`id`="'.$task_id.'")'));
if ($t['how'] < $task['how']){
mysql_query ('UPDATE `task_user` SET `how`="'.$ability.'" WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'")');
}}}
/////////////////////////
$item_41=mysql_result(mysql_query('SELECT COUNT(*) FROM `inv` WHERE `user`= "'.$user['id'].'" AND `quality` >= "4" AND `equip`="1" '),0);
$task_id=41;// Надень 6 вещей эпического качества и выше
$req = mysql_query('select * from `task_user` WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'") AND (`complete`="0")');
if (mysql_num_rows ($req) != 0) {
while ($t = mysql_fetch_array ($req)) {
$task = mysql_fetch_array(mysql_query ('SELECT * FROM `task` WHERE (`id`="'.$task_id.'")'));
if ($t['how'] < $task['how']){
mysql_query ('UPDATE `task_user` SET `how`="'.$item_41.'" WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'")');
}}}
/////////////////////////
$item_42=mysql_result(mysql_query('SELECT COUNT(*) FROM `inv` WHERE `user`= "'.$user['id'].'" AND `smith` >= "6" AND `equip`="1" '),0);
$task_id=42;// Заточи все вещи на +6
$req = mysql_query('select * from `task_user` WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'") AND (`complete`="0")');
if (mysql_num_rows ($req) != 0) {
while ($t = mysql_fetch_array ($req)) {
$task = mysql_fetch_array(mysql_query ('SELECT * FROM `task` WHERE (`id`="'.$task_id.'")'));
if ($t['how'] < $task['how']){
mysql_query ('UPDATE `task_user` SET `how`="'.$item_42.'" WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'")');
}}}
///////////////////////
$task_id=44;// Убей 3 гончих
$req = mysql_query('select * from `task_user` WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'") AND (`complete`="0")');
if (mysql_num_rows ($req) != 0) {
while ($t = mysql_fetch_array ($req)) {
if($user['lair']>13){$lair=1;}
if($user['lair']>14){$lair=2;}
if($user['lair']>15){$lair=3;}
$task = mysql_fetch_array(mysql_query ('SELECT * FROM `task` WHERE (`id`="'.$task_id.'")'));
if ($t['how'] < $task['how']){
mysql_query ('UPDATE `task_user` SET `how`="'.$lair.'" WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'")');
}}}
/////////////////////////
$task_id=45;// Убей цербера
$req = mysql_query('select * from `task_user` WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'") AND (`complete`="0")');
if (mysql_num_rows ($req) != 0) {
while ($t = mysql_fetch_array ($req)) {
if($user['lair']>16){$lair=1;}
$task = mysql_fetch_array(mysql_query ('SELECT * FROM `task` WHERE (`id`="'.$task_id.'")'));
if ($t['how'] < $task['how'] AND $user['lair'] > '16'){
mysql_query ('UPDATE `task_user` SET `how`="'.$lair.'" WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'")');
}}}
/////////////////////////
$task_id=46;// Улучши амулет до 7
$req = mysql_query('select * from `task_user` WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'") AND (`complete`="0")');
if (mysql_num_rows ($req) != 0) {
while ($t = mysql_fetch_array ($req)) {
$task = mysql_fetch_array(mysql_query ('SELECT * FROM `task` WHERE (`id`="'.$task_id.'")'));
if ($t['how'] < $task['how']){
mysql_query ('UPDATE `task_user` SET `how`="'.$user['amulet'].'" WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'")');
}}}
/////////////////////////
$task_id=48;// Тренируй силу до 40
$req = mysql_query('select * from `task_user` WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'") AND (`complete`="0")');
if (mysql_num_rows ($req) != 0) {
while ($t = mysql_fetch_array ($req)) {
$task = mysql_fetch_array(mysql_query ('SELECT * FROM `task` WHERE (`id`="'.$task_id.'")'));
if ($t['how'] < $task['how']){
if($user['_str'] < '40'){
mysql_query ('UPDATE `task_user` SET `how`="'.($user['_str']*3).'" WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'")');
}else{
mysql_query ('UPDATE `task_user` SET `how`=40 WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'")');
}}}}
/////////////////////////
$task_id=49;// Прокачай здоровье до 1100
$req = mysql_query('select * from `task_user` WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'") AND (`complete`="0")');
if (mysql_num_rows ($req) != 0) {
while ($t = mysql_fetch_array ($req)) {
$task = mysql_fetch_array(mysql_query ('SELECT * FROM `task` WHERE (`id`="'.$task_id.'")'));
if ($t['how'] < $task['how']){
if($user['vit'] < '1100'){
mysql_query ('UPDATE `task_user` SET `how`="'.$user['vit'].'" WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'")');
}else{
mysql_query ('UPDATE `task_user` SET `how`=1100 WHERE (`user`="'.$user['id'].'") AND (`task`="'.$task_id.'")');
}}}}
/////////////////////////
?>