function break_axe(&$action1)
{
global $user_id;
myquery("UPDATE game_items SET item_uselife=item_uselife-2 WHERE priznak=0 AND user_id={$user_id} AND used=21");
list($id_item, $cur_uselife) = mysql_fetch_array(myquery("SELECT id,item_uselife FROM game_items WHERE priznak=0 AND user_id={$user_id} AND used=21"));
if ($cur_uselife <= 0) {
$Item = new Item($id_item);
$Item->down();
craft_DelFunc($user_id);
$action1 = 'У тебя сломано кайло!';
}
}
case $id_resource_mithril_ore:
$res_id_bullion = $id_resource_mithril_bullion;
break;
case $id_resource_gold_nugget:
$res_id_bullion = $id_resource_gold_bullion;
break;
}
$res_in = mysql_fetch_array(myquery("SELECT * FROM craft_resource WHERE id='" . $res_id_bullion . "' "));
$Res = new Res($res_in);
$check = $Res->add_user(0, $user_id);
if ($check == 1) {
myquery("UPDATE game_items SET item_uselife=item_uselife-" . mt_rand(400, 600) / 100 . " WHERE user_id={$user_id} AND used=21 AND priznak=0");
list($id_item, $cur_uselife) = mysql_fetch_array(myquery("SELECT id,item_uselife FROM game_items WHERE priznak=0 AND user_id={$user_id} AND used=21"));
if ($cur_uselife <= 0) {
$Item = new Item($id_item);
$Item->down();
}
$mes = 'Получен ресурс: <i>' . $res_in['name'] . '</i> в количестве 1 ед.';
setCraftTimes($user_id, 10, 3, 1);
myquery("insert into craft_stat (build_id, gp, res_id, dob, vip, dat, user, type) values (0, 0, {$res_id_bullion}, 0, 1, " . time() . ", {$user_id}, 'z')");
} else {
$mes = 'Неудачная попытка работы на плавильне. Проверь, хватает ли у тебя места для новых ресурсов в инвентаре!';
}
myquery("DELETE FROM craft_build_founder WHERE user_id={$user_id}");
} else {
mt_srand(make_seed());
$new_nas = mt_rand(1, $founder['nas'] - 10);
mt_srand(make_seed());
$new_teplo = mt_rand(1, 100);
$new_state = $founder['state'] + 1;
$mes = 'Выполнена ' . $new_state . ' из 3 стадий плавления.';
if ($result_items != false and mysql_num_rows($result_items) > 0) {
//предмет проверили. дальше идем
$item = mysql_fetch_array($result_items);
$breakdown = 0;
$chance = mt_rand(1, 100);
if ($item['breakdown'] == 1 and $chance > 1) {
$breakdown = 1;
}
if ($item['type'] == 3) {
$item['uselife_template'] = 100;
}
list($molot_id, $molot_uselife) = mysql_fetch_array($est_molot);
$break = ($item['uselife_template'] - $item['uselife_now']) / 100;
if ($molot_uselife <= $break) {
$molot = new Item($molot_id);
$molot->down();
myquery("UPDATE game_items SET item_uselife=0 WHERE id={$molot_id}");
} else {
myquery("UPDATE game_items SET item_uselife=item_uselife-{$break} WHERE id={$molot_id}");
}
QuoteTable('open');
echo '<br>';
if ($item['uselife_max_now'] > 1 or $breakdown == 0) {
myquery("UPDATE game_items SET item_uselife=" . $item['uselife_template'] . ",item_uselife_max=item_uselife_max-{$breakdown} WHERE id={$nak}");
echo 'Предмет <span style="font-weight:800;color:red;">' . $item['name'] . '</span> отремонтирован до состояния: ' . $item['uselife_template'] . '%.';
if ($breakdown > 0) {
//Выдадим опыт за подход
add_exp_for_craft($user_id, 12);
setCraftTimes($user_id, 12, 2, 2);
echo ' <br />У предмета уменьшена долговечность на ' . $breakdown . '';
}
echo '<center><font face=verdana color=white size=2><b>Профессия забыта!</b></font><meta http-equiv="refresh" content="4;url=town.php?option=' . $option . '">';
}
} elseif (isset($_GET['action']) and $_GET['action'] == 'new_race') {
$id = 5;
$cost = check_lr($user_id, $id);
$attr = $_GET['attr'];
list($user_race) = mysql_fetch_array(myquery("Select race from game_users where user_id={$user_id}"));
if ($cost == -1) {
echo '<center><font face=verdana color=ff0000 size=2>У вас нет Личного Рейтинга на покупку данной услуги!</font><meta http-equiv="refresh" content="4;url=town.php?option=' . $option . '"><br />';
} elseif ($attr == $user_race) {
echo '<center><font face=verdana color=ff0000 size=2>Ваша раса совпадает с выбранной!</font><meta http-equiv="refresh" content="4;url=town.php?option=' . $option . '"><br />';
} else {
$check = myquery("Select t1.id From game_items as t1 Join game_items_factsheet as t2 on t1.item_id=t2.id Where t1.user_id={$user_id} and t1.used>0 and t2.race<>{$attr} and t2.race<>0");
while (list($item_id) = mysql_fetch_array($check)) {
$Item = new Item();
$Item->down($item_id);
}
list($hp, $hp_max, $mp, $mp_max, $stm, $stm_max, $gp, $str, $dex, $vit, $ntl, $pie, $spd) = mysql_fetch_array(myquery("SELECT t1.hp-t2.hp, t1.hp_max-t2.hp_max, t1.mp-t2.mp, t1.mp_max-t2.mp_max, t1.stm-t2.stm, t1.stm_max-t2.stm_max, t1.gp-t2.gp, t1.str-t2.str, t1.dex-t2.dex, t1.vit-t2.vit, t1.ntl-t2.ntl, t1.pie-t2.pie, t1.spd-t2.spd FROM game_har as t1, game_har as t2 WHERE t2.id={$user_race} and t1.id={$attr}"));
myquery("Update game_users Set race={$attr}, hp_max=hp_max+{$hp_max}, mp_max=mp_max+{$mp_max}, stm_max=stm_max+{$stm_max}, gp=gp+{$gp}, str=str+{$str}, vit=vit+{$vit}, dex=dex+{$dex}, spd=spd+{$spd}, pie=pie+{$pie}, ntl=ntl+{$ntl}, spd_max=spd_max+{$spd}, vit_max=vit_max+{$vit}, str_max=str_max+{$str}, pie_max=pie_max+{$pie}, ntl_max=ntl_max+{$ntl}, dex_max=dex_max+{$dex} where user_id={$user_id}");
myquery("Insert into game_lr_services_hist (user_id, serv_id, lr, value) Values ({$user_id}, {$id}, {$cost}, {$user_race})");
echo '<center><font face=verdana color=white size=2><b>Раса изменена!</b></font><meta http-equiv="refresh" content="4;url=town.php?option=' . $option . '">';
}
} elseif (isset($_GET['action']) and $_GET['action'] == 'add_clan') {
$attr = $_GET['attr'];
if ($attr == '') {
echo '<center><font face=verdana color=ff0000 size=2>Введены некорректные данные!</font><meta http-equiv="refresh" content="4;url=town.php?option=' . $option . '"><br />';
} else {
$id = 6;
$number = strpos($attr, ";");
$clan_id = substr($attr, 0, $number);
$kol = substr($attr, $number + 1);
private function check_item_down($id_items, $user_id)
{
if ($id_items == -1) {
$sel = myquery("SELECT id FROM game_items WHERE used=1 AND priznak=0 AND user_id={$user_id} AND item_uselife<=0");
while (list($it_id) = mysql_fetch_array($sel)) {
$Item = new Item($it_id);
$Item->down();
}
} else {
$sel = myquery("SELECT id FROM game_items WHERE used>0 AND priznak=0 AND user_id={$user_id} AND item_uselife<=0 AND id={$id_items}");
while (list($it_id) = mysql_fetch_array($sel)) {
$Item = new Item($it_id);
$Item->down();
}
}
}
$item_name = mysqlresult(myquery("SELECT name FROM game_items_factsheet WHERE id=" . $item_id . ""), 0, 0);
$complect_name = mysqlresult(myquery("SELECT name FROM game_items_factsheet WHERE id=" . $complect_id . ""), 0, 0);
myquery("DELETE FROM game_items_complect WHERE id={$id}");
$da = getdate();
$log = myquery("INSERT INTO game_log_adm (adm,dei,cur_time,day,month,year) \n\t VALUES (\n\t '" . $char['name'] . "',\n\t 'Для предмета: <b>" . $item_name . "</b> удалил из комплекта " . $complect_name . ": предмет <b>" . $item_name . "</b>',\n\t '" . time() . "',\n\t '" . $da['mday'] . "',\n\t '" . $da['mon'] . "',\n\t '" . $da['year'] . "')") or die(mysql_error());
$response = 'ok';
}
// При изменении состава комплекта пересчитать всех игроков.
if (isset($_GET['save']) or isset($_GET['delete'])) {
$complect_id = (int) $_GET['read'];
// Снимаем комплект со всех, у кого он был одет.
$res = myquery("SELECT `id`,`user_id` FROM `game_items` WHERE `priznak`=0 AND `used`=22 AND `item_id` = {$complect_id}");
while ($list = mysql_fetch_array($res)) {
$item = new Item($list['id']);
$item->setChar($list['user_id']);
$item->down();
}
$complect_fact = mysql_fetch_assoc(myquery("SELECT * FROM game_items_factsheet WHERE id={$complect_id}"));
$complect_fact['weight'] = (double) $complect_fact['weight'];
$sel_check = myquery("SELECT item_id FROM game_items_complect WHERE complect_id={$complect_id}");
// Игроки у которых можеь быть одета новая версия комплекта
$res = myquery("SELECT DISTINCT `user_id` FROM `game_items` WHERE `priznak`=0 AND `used`!=0 AND `item_id` IN (SELECT DISTINCT `item_id` FROM `game_items_complect` WHERE `complect_id` = {$complect_id});");
while ($list = mysql_fetch_array($res)) {
//Требования к этому комплекту выполненны?
$check_user_id = $list['user_id'];
$est_complect = 0;
$kol_item_in_complect = 0;
$kol_item_complect_used = 0;
mysql_data_seek($sel_check, 0);
while (list($item_ch_id) = mysql_fetch_array($sel_check)) {
$kol_item_in_complect++;
if ($f_id == '1') {
if (function_exists("save_debug")) {
save_debug();
}
exit;
}
if (!empty($_GET['inv_option'])) {
switch ($_GET['inv_option']) {
case 'equip':
$id = (int) $_GET['id'];
$Item = new Item();
$Item->up($id, 0);
break;
case 'unequip':
$Item = new Item();
$Item->down($_GET['id']);
break;
case 'kleymo_return':
$Item = new Item();
$Item->kleymo_return($_GET['id']);
break;
case 'use':
$Item = new Item();
$Item->use_item($_GET['id']);
break;
case 'drop':
$Item = new Item();
$Item->drop($_GET['id']);
break;
case 'takeres':
if (!isset($_GET['id']) or !is_numeric($_GET['id']) or !isset($_GET['col']) or $_GET['col'] <= 0 or !is_numeric($_GET['col'])) {
}
$mas[3][1] = 1249;
$mas[3][2] = 1250;
$mas[3][3] = 1251;
$mas[6][1] = 1266;
$mas[6][2] = 1267;
$mas[6][3] = 1268;
$mas[9][1] = 1237;
$mas[9][2] = 1238;
$mas[9][3] = 1239;
$mas[12][1] = 1272;
$mas[12][2] = 1273;
$mas[12][3] = 1274;
$check = myquery("SELECT id, user_id FROM game_items WHERE used>0 AND priznak=0 AND item_id in ('" . $mas[$cur][1] . "', '" . $mas[$cur][2] . "', '" . $mas[$cur][3] . "')");
if (mysql_num_rows($check) > 0) {
while ($item = mysql_fetch_array($check)) {
$Item = new Item();
$Item->down($item['id'], $item['user_id']);
}
}
list($weight) = mysql_fetch_array(myquery("SELECT weight FROM game_items_factsheet WHERE id = '" . $mas[$cur][1] . "' "));
myquery("UPDATE game_users gu SET gu.CW=gu.CW - '" . $weight . "'*(SELECT count(*) \n\t\t\t FROM game_items gi WHERE gu.user_id = gi.user_id and gi.item_id in ('" . $mas[$cur][1] . "', '" . $mas[$cur][2] . "', '" . $mas[$cur][3] . "') and gi.priznak = 0)\n\t\t\t");
myquery("UPDATE game_users_archive gu SET gu.CW=gu.CW - '" . $weight . "'*(SELECT count(*) \n\t\t\t FROM game_items gi WHERE gu.user_id = gi.user_id and gi.item_id in ('" . $mas[$cur][1] . "', '" . $mas[$cur][2] . "', '" . $mas[$cur][3] . "') and gi.priznak = 0)\n\t\t\t");
myquery("DELETE FROM game_items WHERE item_id in ('" . $mas[$cur][1] . "', '" . $mas[$cur][2] . "', '" . $mas[$cur][3] . "')");
myquery("UPDATE game_npc_drop SET items_id = '" . $mas[$next][1] . "' WHERE items_id = '" . $mas[$cur][1] . "' and drop_type = 1");
myquery("UPDATE game_npc_drop SET items_id = '" . $mas[$next][2] . "' WHERE items_id = '" . $mas[$cur][2] . "' and drop_type = 1");
myquery("UPDATE game_npc_drop SET items_id = '" . $mas[$next][3] . "' WHERE items_id = '" . $mas[$cur][3] . "' and drop_type = 1");
}
myquery("UPDATE game_cron_log SET step='28. Очищение логов', timecron=" . time() . " WHERE id={$idcronlog}");
myquery("DELETE FROM `game_items_deleted` WHERE action_time<adddate( now( ) , INTERVAL -3 MONTH) ");
myquery("UPDATE game_cron_log SET step='final', timecron=" . time() . " WHERE id={$idcronlog}");
