function MySQL_get_array($Table, $Collumn, $Condition)
{
$Query = "SELECT " . $Collumn . " FROM `" . $Table . "`";
if (isset($Condition)) {
$Query = $Query . " WHERE " . $Condition;
}
$Data = mysql_Query($Query) or die(mysql_error());
$Array = mysql_fetch_Array($Data);
return $Array;
}
<table cellspacing=0 cellpadding=0 border=0 width="100%">
<tr>
<td background="img/design/left-bgr-blank.gif"><img src="img/design/dot.gif" width=10 height=1 hspace=0 vspace=0 border=0></td>
<td width=100% background="img/design/bgr.jpg">
<?php
$db = mysql_fetch_array(mysql_query("SELECT * FROM users WHERE login='******'"));
if ($db) {
echo "\n\t\t\t\t\t<br/><br/><br/>\n\t\t\t\t\t<h3>Покупка Платины (Пл.) Оплата со счета мобильного телефона.</h3>\n\t\t\t\t\t<center>Оплата за покупку будет списана с баланса счета Вашего мобильного телефона.<br>";
if ($bonus) {
echo "<font color=red>Внимание! Акция! При покупке Платины - в подарок дополнительно <b>" . $bonus . "%</b> от суммы покупки!</font><br><br>";
}
echo "<br><br>";
##===========================================================
if ($_POST["bankid"]) {
$bank_id = (int) $_POST["bankid"];
$have_bank_id = mysql_fetch_Array(mysql_query("SELECT number FROM bank WHERE login='******' and number=" . $bank_id));
if ($have_bank_id) {
$_SESSION["bank_id"] = $bank_id;
switch ($_POST["amount"]) {
case 1:
$_SESSION["amount"] = 0.1;
break;
case 2:
$_SESSION["amount"] = 2;
break;
case 5:
$_SESSION["amount"] = 5;
break;
default:
$_SESSION["amount"] = 2;
break;
?>
</font>
<h4>Статистика</h4>
• Побед в Башне Смерти: <B><?php
echo $res[0];
?>
</B><BR>
• Рейтинг в Башне Смерти: <B><?php
echo $reputation;
?>
</B><BR>
• Репутация в Башне Смерти: <B><?php
echo $db["reputation"];
?>
</B><BR>
<h4>Задания в Башне</h4>
1. <a href="?zad=1">Выиграть поединок в Башне Смерти</a> <i>(5 репутации, 50.00 Зл.)</i><BR>
2. <a href="?zad=2">Выиграть Башню Смерти</a> <i>(100 репутации, 1000.00 Ед.)</i><BR>
<BR><BR>
<h4>Последний 10 Рыцарей Башни Смерти</h4>
<?php
$sql = mysql_Query("SELECT users.login,users.level,users.id,users.orden,users.admin_level,users.clan,users.clan_short,users.dealer FROM `inv` LEFT JOIN users on users.login=inv.owner WHERE `object_id`=31 and `object_type`='medal' ORDER BY inv.date ASC");
while ($dat = mysql_fetch_Array($sql)) {
echo "<script>drwfl('" . $dat['login'] . "','" . $dat['id'] . "','" . $dat['level'] . "','" . $dat['dealer'] . "','" . $dat['orden'] . "','" . $dat['admin_level'] . "','" . $dat['clan_short'] . "','" . $dat['clan'] . "');</script><br>";
}
?>
</BODY>
</HTML>
}
if ($total < $start + $ttt) {
$end = $total;
} else {
$end = $start + $ttt;
}
for ($i = 0; $i < $total; $i++) {
$classdate = "date";
#$time =date("d.m.y H:i",$chat_array[$i][1]);
$time = date("H:i", $chat_array[$i][1]);
$name = $chat_array[$i][2];
$color = $chat_array[$i][3];
$body = $chat_array[$i][4];
$msg_room = $chat_array[$i][5];
$msg_city = $chat_array[$i][6];
$have_ignor = mysql_fetch_Array(mysql_Query("SELECT count(*) FROM ignor WHERE login='******' and ignored='" . $name . "'"));
if (eregi("to \\[{$login}\\]", $body, $regs)) {
$classdate = "date2";
$forom = 1;
}
if (eregi("private \\[{$login}\\]", $body, $regs)) {
$classdate = "date2";
}
if (eregi("clan \\[{$my_clan}\\]", $body, $regs)) {
$classdate = "date2";
}
if (substr($body, 0, 7) == "private") {
if (eregi("private \\[{$login}\\]", $body, $regs)) {
if (!$have_ignor[0]) {
$massages .= "<font class='{$classdate}'>{$time}</font> [<a href='?who={$name}'>{$name}</a>] <font color='{$color}'>{$body}</font> <br/>";
}
$res = mysql_fetch_Array(mysql_query("SELECT users.login,id,level,users.remote_ip FROM online LEFT JOIN users on users.login=online.login WHERE users.battle=0 and zayavka=0 and online.room='room4' and level>=9 ORDER BY level DESC LIMIT 1"));
if ($res) {
$prototype = "Исчадие Хаоса";
mysql_query("INSERT INTO zayavka(status,type,timeout,creator) VALUES('3','23','3','" . $res["id"] . "')");
mysql_query("INSERT INTO teams(player,team,ip,battle_id,hitted,over,leader) VALUES('" . $res["login"] . "','1','" . $res["remote_ip"] . "','" . $res["id"] . "','0','0','1')");
addBot($res["login"], $res["id"], $prototype, $prototype);
goBattle($res["login"]);
say("toall_news", "<font color=\"#ff0000\">Объявления:</font> <font color=darkblue><b>Началась Битва между " . $res["login"] . " и Исчадием Хаоса</b></font>", $res["login"]);
echo "OK";
} else {
echo "NO USERS";
}
}
}
if ($_POST["heal"]) {
$query = mysql_fetch_Array(mysql_query("SELECT * FROM zayavka WHERE type=23"));
if ($query) {
$res = mysql_fetch_array(mysql_Query("SELECT * FROM battles WHERE creator_id=" . $query["creator"]));
$have_bot = mysql_fetch_array(mysql_Query("SELECT * FROM bot_temp WHERE battle_id=" . $res["id"] . " and team=2"));
$hp_add = 50000;
$new_hp = $have_bot["hp"] + $hp_add;
if ($new_hp > $have_bot["hp_all"]) {
$new_hp = $have_bot["hp_all"];
$hp_add = $have_bot["hp_all"] - $have_bot["hp"];
}
mysql_Query("UPDATE bot_temp SET hp=hp+{$hp_add} WHERE id=" . $have_bot["id"]);
$phrase_priem = "<span class=date>" . date("H:i") . "</span> <b>Исчадие Хаоса</b> понял что его спасение это прием <b>Воля к победе. <font color=green>+{$hp_add}</font></b> [" . $new_hp . "/" . $have_bot['hp_all'] . "]<br>";
battle_log($res["id"], $phrase_priem);
} else {
echo "You Should Start Battle";
}
<?php
$priem = htmlspecialchars(addslashes($_GET['special']));
if ($db["battle_team"] == 1) {
$span = "p1";
} else {
$span = "p2";
}
$priems = mysql_fetch_array(mysql_query("SELECT * FROM battle_units WHERE player='" . $login . "' and battle_id='" . $bid . "'"));
$is_pr = mysql_fetch_Array(mysql_query("SELECT * FROM person_on LEFT JOIN priem ON priem.type=pr_name WHERE pr_name = '" . $priem . "' and id_person=" . $db["id"] . " and battle_id='" . $bid . "'"));
if ($is_pr) {
$enable = true;
$can_use = checkbattlehars((int) $is_pr["hit"], (int) $is_pr["krit"], (int) $is_pr["block"], (int) $is_pr["uvarot"], (int) $is_pr["hp"], (int) $is_pr["all_hit"], (int) $is_pr["parry"], (int) $priems["hit"], (int) $priems["krit"], (int) $priems["block"], (int) $priems["uvarot"], (int) $priems["hp"], (int) $priems["counter"], (int) $priems["parry"]);
if ($can_use) {
if ($is_pr["pr_cur_uses"] > 0) {
if ($is_pr["pr_wait_for"]) {
if ($is_pr['pr_wait_for'] > 0) {
$enable = false;
echo "<b style='color:red'>Нельзя использовать: еще идет задержка </b>";
}
if ($is_pr['pr_active'] != 1 && $is_pr["pr_cur_uses"] <= 1) {
$enable = false;
echo "<b style='color:red'>Нельзя использовать: активен</b>";
}
} else {
if ($is_pr['pr_active'] != 1 && $is_pr["pr_cur_uses"] <= 1) {
$enable = false;
echo "<b style='color:red'>Нельзя использовать: уже активен</b>";
}
}
} else {
<?php
include "conf.php";
$data = mysql_connect($base_name, $base_user, $base_pass);
mysql_select_db($db_name, $data);
$row = mysql_query("select inv.id from users left join inv on inv.owner=users.login where users.orden=1 and inv.object_type='scroll' and inv.object_id=60");
while ($res = mysql_fetch_Array($row)) {
mysql_query("UPDATE inv SET iznos_max=121 WHERE id=" . $res[0]);
}
/**
* change heat
* ---------------------------------
*/
function AA_heats_changePosition($round)
{
require './lib/common.lib.php';
include './config.inc.php';
if (empty($_POST['pos']) && empty($_POST['track'])) {
AA_printErrorMsg($GLOBALS['strErrEmptyFields']);
} else {
mysql_query("LOCK TABLES runde READ, serie WRITE, serienstart WRITE, wettkampf READ, disziplin READ, meeting READ");
// change request by text field
if (empty($_POST['heat'])) {
$result = mysql_query("\r\n\t\t\t\tSELECT xSerie FROM \r\n\t\t\t\t\tserie \r\n\t\t\t\tWHERE\tBezeichnung = '" . $_POST['heatname'] . "'\r\n\t\t\t\tAND\txRunde = {$round}");
if (mysql_errno() > 0) {
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
} else {
if (mysql_num_rows($result) > 0) {
$row = mysql_fetch_array($result);
$_POST['heat'] = $row[0];
mysql_free_result($result);
}
}
}
$xSerie = 0;
// heat does not yet exist
if (AA_checkReference("serie", "xSerie", $_POST['heat']) == 0) {
// check if round still valid
if (AA_checkReference("runde", "xRunde", $round) != 0) {
// get discipline type for evaluating if a filmnumber is needed
$filmnr = 0;
$res_dist = mysql_query("SELECT disziplin.Typ FROM \r\n\t\t\t\t\t\t\t\trunde\r\n\t\t\t\t\t\t\t\tLEFT JOIN wettkampf USING(xWettkampf)\r\n\t\t\t\t\t\t\t\tLEFT JOIN disziplin USING(xDisziplin)\r\n\t\t\t\t\t\t\tWHERE runde.xRunde = {$round}");
if (mysql_errno() > 0) {
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
} else {
$row_dist = mysql_fetch_Array($res_dist);
if ($row_dist[0] == $cfgDisciplineType[$strDiscTypeTrack] || $row_dist[0] == $cfgDisciplineType[$strDiscTypeTrackNoWind] || $row_dist[0] == $cfgDisciplineType[$strDiscTypeRelay] || $row_dist[0] == $cfgDisciplineType[$strDiscTypeDistance]) {
$filmnr = AA_heats_getNextFilm();
}
}
mysql_query("INSERT INTO serie SET" . " Bezeichnung = '" . $_POST['heatname'] . "'" . ", xRunde = {$round}" . ", xAnlage = 0\r\n\t\t\t\t\t\t\t , Film = {$filmnr}" . ", MaxAthlet = " . $cfgMaxAthlete);
if (mysql_errno() > 0) {
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
} else {
$xSerie = mysql_insert_id();
// get new heat ID
}
}
} else {
$xSerie = $_POST['heat'];
}
if ($xSerie != 0) {
if (!empty($_POST['track'])) {
mysql_query("UPDATE serienstart SET" . " xSerie = " . $xSerie . ", Bahn = " . $_POST['track'] . " WHERE xSerienstart = " . $_POST['item']);
} else {
// update heat start with new heat / position
mysql_query("UPDATE serienstart SET" . " Position = '" . $_POST['pos'] . "', xSerie = " . $xSerie . ", Bahn = " . $_POST['pos'] . " WHERE xSerienstart = " . $_POST['item']);
}
if (mysql_errno() > 0) {
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
}
}
AA_heats_deleteHeats();
mysql_query("UNLOCK TABLES");
// reset round status
if (AA_getRoundStatus($round) >= $GLOBALS['cfgRoundStatus']['heats_done']) {
AA_utils_changeRoundStatus($round, $GLOBALS['cfgRoundStatus']['heats_in_progress']);
if (!empty($GLOBALS['AA_ERROR'])) {
AA_printErrorMsg($GLOBALS['AA_ERROR']);
}
}
}
}
$q = mysql_query("SELECT * FROM users WHERE login='******'");
$res = mysql_fetch_array($q);
if (!$res) {
echo "Персонаж <B>" . $target . "</B> не найден в базе данных.";
} else {
$sql_teams = mysql_fetch_Array(mysql_query("SELECT * FROM zayavka_teams WHERE player='" . $res["login"] . "'"));
if ($sql_teams) {
$sql_teams_p = mysql_query("SELECT * FROM zayavka_teams WHERE battle_id=" . $sql_teams["battle_id"]);
while ($result = mysql_fetch_array($sql_teams_p)) {
mysql_query("UPDATE users SET zayava=0 WHERE login='******'");
}
mysql_query("DELETE FROM zayavka_teams WHERE battle_id=" . $sql_teams["battle_id"]);
mysql_query("DELETE FROM zayavka_bot WHERE id=" . $sql_teams["battle_id"]);
echo "OK-Спуск в Катакомбы";
} else {
$sql_teams = mysql_fetch_Array(mysql_query("SELECT * FROM z_login WHERE player='" . $res["login"] . "'"));
if ($sql_teams) {
$sql_teams_p = mysql_query("SELECT * FROM z_login WHERE group_id=" . $sql_teams["group_id"]);
while ($result = mysql_fetch_array($sql_teams_p)) {
mysql_query("UPDATE users SET zayava=0 WHERE login='******'");
}
mysql_query("DELETE FROM z_login WHERE group_id=" . $sql_teams["group_id"]);
mysql_query("DELETE FROM z_group WHERE id=" . $sql_teams["group_id"]);
echo "OK-Вход в Клад";
} else {
mysql_query("UPDATE users SET zayava=0 WHERE login='******'");
echo "OK";
}
}
}
}
<?php
session_start();
ob_start("@ob_gzhandler");
include "conf.php";
$login = $_SESSION["login"];
Header("Cache-Control: no-cache, must-revalidate");
// говорим браузеру что-бы он не кешировал эту страницу
Header("Pragma: no-cache");
$data = mysql_connect($base_name, $base_user, $base_pass) or die('Не получается подключиться. Проверьте имя сервера, имя пользователя и пароль!');
mysql_select_db($db_name) or die('Ошибка входа в базу данных');
$my_info = mysql_fetch_Array(mysql_query("SELECT admin_level FROM users WHERE login='******'"));
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
<meta http-equiv="Content-Language" content="ru">
<meta http-equiv=Cache-Control Content=no-cache>
<meta http-equiv=PRAGMA content=NO-CACHE>
<meta http-equiv=Expires content=0>
<LINK rel="stylesheet" type="text/css" href="main.css">
</head>
<body bgcolor="#faeede">
<script language="JavaScript" type="text/javascript" src="commoninf.js"></script>
<?php
$clan = htmlspecialchars(addslashes($_GET['clan']));
if (empty($clan)) {
echo "Неверный запрос.";
} else {
$sql = mysql_query("SELECT clan.*,clan.level as c_level,users.login,users.id,users.level,users.dealer,users.orden,users.admin_level,users.clan_short,users.clan FROM clan LEFT JOIN users on users.id=clan.creator WHERE name_short='" . $clan . "'");
}
if ($perf == NULL) {
// invalid performance
$perf = 0;
}
mysql_query("\r\n\t\t\t\t\t\t\t\t\t\t\t\tINSERT INTO start SET \r\n\t\t\t\t\t\t\t\t\t\t\t\t\txWettkampf = " . $_POST['event'] . "\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t, xStaffel = {$xStaffel}\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t, Bestleistung = {$perf}\r\n\t\t\t\t\t\t\t\t\t\t\t\t");
if (mysql_errno() > 0) {
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
} else {
// get each round for this event
$xRounds = array();
$res_rnd = mysql_query("SELECT xRunde FROM runde WHERE xWettkampf = " . $_POST['event']);
if (mysql_errno() > 0) {
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
} else {
while ($row_rnd = mysql_fetch_Array($res_rnd)) {
$xRounds[] = $row_rnd[0];
}
}
if (count($xRounds) == 0) {
AA_printErrorMsg($strRelayDefineRounds);
}
$xStart = mysql_insert_id();
// get new ID
$c = 0;
if ($_POST['starts'] > 0) {
foreach ($_POST['starts'] as $start) {
foreach ($xRounds as $xRound) {
if ($_POST['positions'][$c] > 0) {
mysql_query("\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tINSERT INTO staffelathlet\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tSET\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\txStaffelstart = {$xStart}\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t, xAthletenstart = {$start}\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t, Position='" . $_POST['positions'][$c] . "'\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t, xRunde = '{$xRound}'\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t");
}
function sum_betto($num)
{
$sum_s = mysql_fetch_Array(mysql_query("SELECT count(*) FROM roul_bets WHERE betto={$num}"));
return $sum_s[0];
}
$mn_add = $db["mana_all"] - $db["mana"];
}
setMN($login, $new_mn, $db['mana_all']);
}
##################################################
if ($db["battle_team"] == 1) {
$span = "p1";
} else {
$span = "p2";
}
$phrase_hell = "<span class=date>" . $date . "</span> <span class={$span}>" . $login . "</span>, нетрезво оценив положение, решил, что поможет ему только прием <b>Передышка</b> <font color=green><b>+{$hp_add} HP</b></font> [" . $new_hp . "/" . $db['hp_all'] . "] " . ($mn_add > 0 ? "<font color=blue><b>+{$mn_add} MN</b></font> [" . $new_mn . "/" . $db['mana_all'] . "]" : "") . ".<br>";
battle_log($bid, $phrase_hell);
##################################################
$names = array("Бармаглот", "Пещерный-Ящер", "Повелитель-Бармаглотов", "Угрюмый-Дендроид", "Мерцающий-феникс", "Сумрачный-Грифон", "Ядерник", "Радскорпион", "Дикий гул", "Леврета", "Линграонц", "Падший король");
$names_unikal = array("Темный Линграонц", "Темный Леврета", "Лютый Линграонц", "Лютый Леврета", "Коварная Смотрительница", "Жадный Смотритель", "Осквернитель Хаоса");
$bot_count = mysql_fetch_Array(mysql_Query("SELECT count(*) FROM `bot_temp` WHERE `battle_id`={$bid} and team=2"));
if ($have_hell["unikal"] == 5) {
$bot_u = array();
if ($db["level"] == 8) {
$bot_u[0] = $names_unikal[0];
$bot_u[1] = $names_unikal[1];
} else {
if ($db["level"] == 9) {
$bot_u[0] = $names_unikal[2];
$bot_u[1] = $names_unikal[3];
} else {
if ($db["level"] >= 10) {
$bot_u[0] = $names_unikal[4];
$bot_u[1] = $names_unikal[5];
$bot_u[2] = $names_unikal[6];
}
<SCRIPT LANGUAGE="JavaScript" SRC="scripts/magic-main.js"></SCRIPT>
<script>
function prodaja(id,name)
{
if(confirm('Вы уверены что хотите продать предмет '+name+' ?'))
{
location.href = '?otdel=12&sell_id='+id+'&name='+name;
}
}
</script>
<div id=hint4></div>
<?php
if ($_GET["sell_id"]) {
$item_id = (int) $_GET['sell_id'];
$item_sell = mysql_fetch_Array(mysql_query("SELECT scroll.price, scroll.name, scroll.art, inv.id, inv.iznos, inv.iznos_max, inv.gift, inv.gift_author,inv.podzemka FROM inv LEFT JOIN scroll on scroll.id=inv.object_id WHERE inv.owner='" . $login . "' and inv.id={$item_id} and inv.wear=0"));
if (!$item_sell) {
$msg = "Вещь не найдена";
} else {
$pal_price = round(0.75 * $item_sell["price"]);
$m_type = "money";
$money_type = "Зл.";
if ($item_sell["art"]) {
$m_type = "platina";
$money_type = "Пл.";
}
$price = $pal_price * ($item_sell["iznos_max"] - $item_sell["iznos"]) / $item_sell["iznos_max"];
$price = round($price, 2);
if ($price < 0) {
$price = 0;
}
<tr>
<td align=center>
<TABLE WIDTH=100% CELLSPACING=1 CELLPADDING=2 BGCOLOR=#CEBBAA>';
if ($_GET['otdel'] == "obj") {
$seek = mysql_query("SELECT * FROM paltar WHERE id in {$item_Array_str} ORDER BY min_level ASC,price ASC");
while ($res = mysql_fetch_array($seek)) {
$n = !$n;
$str = '';
echo '
<tr class="' . ($n ? 'l0' : 'l1') . '">
<td valign=center align=center width=300 nowrap>
<img src="img/items/' . $res['img'] . '"><br>
<a href="?buy=' . $res["id"] . '">Купить</a><br><br><br><b>Требуется</b><br>';
if (count($item_array[$res["id"]])) {
foreach ($item_array[$res["id"]] as $currentValues) {
$query = mysql_fetch_Array(mysql_query("SELECT img FROM wood WHERE id=" . $currentValues["item"]));
$str .= "<span style=\"position:relative; width:60px; height:60px;\"><img src=img/" . $query["img"] . "><small style='background-color: #E0E0E0; position: absolute; right: 1; bottom: 1;'><B>" . $currentValues["count"] . " шт.</B></small></span> ";
}
echo $str;
}
echo '
</td>
<td width=100%>';
show_item($db, $res);
echo '</td>
</tr>';
}
if (!mysql_num_rows($seek)) {
echo "<tr bgcolor='#C7C7C7'><td valign=center align=center nowrap colspan=2><b>Прилавок магазина пустой...</b></td></tr>";
}
} else {
if ($db["battle"] && $db["hp"] && $db["battle_opponent"] != "") {
$target = $db["battle_opponent"];
$battle_id = $db["battle"];
if ($db["battle_team"] == 1) {
$span = "p1";
$span2 = "p2";
} else {
$span = "p2";
$span2 = "p1";
}
$date = date("H:i");
$zaman = time() + 2 * 3600;
$my_id = $db["id"];
$type = 'prokl';
$phrase = "";
$if_bot = mysql_fetch_Array(mysql_query("SELECT count(*) FROM `bot_temp` WHERE battle_id='" . $db["battle"] . "' AND bot_name='" . $target . "'"));
if (!$if_bot[0]) {
$res = mysql_fetch_array(mysql_query("SELECT id, login FROM users WHERE login='******'"));
if (!$res) {
say($login, "Персонаж <B>" . $target . "</B> не найден в базе данных.", $login);
} else {
mysql_query("UPDATE inv SET iznos = iznos+1 WHERE id='" . $id . "'");
$DAT = mysql_fetch_array(mysql_query("SELECT iznos,iznos_max FROM inv WHERE id = '" . $id . "'"));
if ($DAT["iznos"] == $DAT["iznos_max"]) {
mysql_query("UPDATE users SET slot" . $slot . "=0 WHERE login='******'");
mysql_query("DELETE FROM inv WHERE id = '" . $id . "'");
say($login, "Заклинание <b>«" . $name . "»</b> полностью использован!", $login);
}
switch ($mtype) {
case "silach":
$add = -30;
public function importDataAction(Request $request)
{
$em = $this->getDoctrine()->getEntityManager();
$link = mysql_connect('localhost', 'root', 'root');
if (!$link) {
die('Could not connect: ' . mysql_error());
} else {
mysql_select_db('sample_drp');
$queryData = "select * from Provincial_Lease";
$resultData = mysql_query($queryData, $link);
$arrData = array();
while ($rowData = mysql_fetch_Array($resultData, MYSQL_ASSOC)) {
$arrData[] = $rowData;
//echo"<pre>";print_r($arrData);die;
$propertyData = new Book();
$propertyData->SetSerialNumber($rowData['Serial_registration']);
//$propertyData->SetReferenceNumber($arrCells[0]);
$propertyData->SetExecutionDate($rowData['Date_of_execution']);
$propertyData->SetReceiptDate($rowData['Date_of_receipt']);
$propertyData->SetLandSituation($rowData['Situation_of_land']);
$propertyData->SetOrNumber($rowData['O_R_Number']);
$propertyData->SetStampDuty($rowData['Stamp_duty']);
$propertyData->SetLomp($rowData['LOMP']);
$propertyData->SetRegistrationType('PL');
$em->persist($propertyData);
$em->flush();
$id = $propertyData->getId();
$companyDataGR = new Company();
$companyDataGR->SetFirstName($rowData['Lessor_fname']);
$companyDataGR->SetLastName($rowData['Lessor_lname']);
$companyDataGR->SetNin($rowData['Lessor_NIN']);
$companyDataGR->SetDob($rowData['Lessor_DOB']);
$companyDataGR->SetTelephone1($rowData['Lessor_tel1']);
$companyDataGR->SetEmail($rowData['Lessor_email']);
$companyDataGR->SetAddress($rowData['Lessor_Address']);
$companyDataGR->SetTelephone2($rowData['Lessor_tel2']);
$companyDataGR->SetBookId($id);
$companyDataGR->SetType('LR');
$em->persist($companyDataGR);
$em->flush();
$companyDataGE = new Company();
$companyDataGE->SetFirstName($rowData['Lessee_fname']);
$companyDataGE->SetLastName($rowData['lessee_lname']);
$companyDataGE->SetNin($rowData['Lessee_NIN']);
$companyDataGE->SetDob($rowData['Lessee_DOB']);
$companyDataGE->SetTelephone1($rowData['Lessee_tel1']);
$companyDataGE->SetEmail($rowData['lessee_email']);
$companyDataGE->SetTelephone2($rowData['Lessee_tel2']);
$companyDataGE->SetAddress($rowData['Lessee_address']);
$companyDataGE->SetBookId($id);
$companyDataGE->SetType('LE');
$em->persist($companyDataGE);
$em->flush();
$companyDataPR = new Company();
$companyDataPR->SetFirstName($rowData['PR_fname']);
$companyDataPR->SetLastName($rowData['PR_lname']);
$companyDataPR->SetNin($rowData['PR_NIN']);
$companyDataPR->SetDob($rowData['PR_DOB']);
$companyDataPR->SetTelephone1($rowData['PR_tel1']);
$companyDataPR->SetEmail($rowData['PR_email']);
$companyDataPR->SetTelephone2($rowData['PR_tel2']);
$companyDataPR->SetAddress($rowData['PR_address']);
$companyDataPR->SetBookId($id);
$companyDataPR->SetType('PR');
$em->persist($companyDataPR);
$em->flush();
$companyDataRP = new Company();
$companyDataRP->SetFirstName($rowData['Recipient_fname']);
$companyDataRP->SetLastName($rowData['recipient_lname']);
$companyDataRP->SetNin($rowData['recipient_NIN']);
$companyDataRP->SetDob($rowData['recipient_DOB']);
$companyDataRP->SetTelephone1($rowData['recipient_tel1']);
$companyDataRP->SetEmail($rowData['recipient_email']);
$companyDataRP->SetTelephone2($rowData['recipient_tel2']);
$companyDataRP->SetAddress($rowData['recipient_address']);
$companyDataRP->SetBookId($id);
$companyDataRP->SetType('RP');
$em->persist($companyDataRP);
$em->flush();
$status = new RegistrationStatus();
$status->SetStatus(0);
$status->SetPropertyType('lease');
$status->SetBookId($id);
$em->persist($status);
$em->flush();
}
}
mysql_close($link);
if ($request->getMethod() == 'POST') {
if (is_uploaded_file($_FILES['file']['tmp_name'])) {
//readfile($_FILES['file']['tmp_name']);
}
$i = 0;
$handle = fopen($_FILES['file']['tmp_name'], "r");
while (($data = fgetcsv($handle, 10000000, ",")) !== FALSE) {
if ($i > 2) {
$arrCells = explode(',', $data[0]);
echo "<pre>";
print_r($arrCells);
die;
}
$i++;
}
}
return $this->render('DRPAdminBundle:Pages:importData.html.twig');
}
</head>
<body>
<div id="cnt" class="content">
<div class="aheader">
<b>Инвентар</b><br/>
<font color='#ff0000'><?php
echo $_SESSION["message"];
$_SESSION["message"] = "";
?>
</font>
</div>
<?php
if ($_GET["info"]) {
$item_id = (int) $_GET["info"];
$sql_info = mysql_fetch_Array(mysql_query("SELECT * FROM inv WHERE owner='" . $login . "' and object_razdel='obj' and id=" . $item_id));
if ($sql_info) {
echo "<img src='http://www.meydan.az/img/items/" . $sql_info["img"] . "' border='0' /><br/>";
echo show_item($db, $sql_info);
}
} else {
if ($otdel == "obj") {
showPlayer_inv($db);
echo "<br/>[<a href=\"?act=unwear_full\">Снять все</a>]<br/>";
} else {
if ($otdel == "magic") {
for ($j = 0; $j <= 1; $j++) {
for ($i = $j * 6 + 100; $i <= $j * 6 + 105; $i++) {
echo showpic($db, $i, 2);
}
unset($i);
while ($ip_data = mysql_fetch_Array($SEEK_IP)) {
$id_ip = $ip_data["id"];
$player_ip = $ip_data["login"];
$level_ip = $ip_data["level"];
$orden_ip = $ip_data["orden"];
$admin_level_ip = $ip_data["admin_level"];
$dealer_ip = $ip_data["dealer"];
$clan_s_ip = $ip_data["clan_short"];
$clan_f_ip = $ip_data["clan"];
echo drwfl($player_ip, $id_ip, $level_ip, $dealer_ip, $orden_ip, $admin_level_ip, $clan_s_ip, $clan_f_ip) . "<br>";
}
} else {
if ($remote_ip) {
print "<h3>Последний Обший IP: <b>{$remote_ip}</b></h3>";
$SEEK_IP = mysql_query("SELECT id,login,level,orden,admin_level,clan,clan_short,dealer FROM users WHERE remote_ip='{$remote_ip}'");
while ($ip_data = mysql_fetch_Array($SEEK_IP)) {
$id_ip = $ip_data["id"];
$player_ip = $ip_data["login"];
$level_ip = $ip_data["level"];
$orden_ip = $ip_data["orden"];
$admin_level_ip = $ip_data["admin_level"];
$dealer_ip = $ip_data["dealer"];
$clan_s_ip = $ip_data["clan_short"];
$clan_f_ip = $ip_data["clan"];
echo drwfl($player_ip, $id_ip, $level_ip, $dealer_ip, $orden_ip, $admin_level_ip, $clan_s_ip, $clan_f_ip) . "<br>";
}
}
}
}
}
}
</script>
<SCRIPT language="JavaScript" type="text/javascript" src="fight.js"></SCRIPT>
<h3>Больница</h3>
<font color=red><?php
echo $msg;
?>
</font>
<table width=100%>
<tr valign=top>
<td>
<?php
showHPbattle($db);
showPlayer($db);
?>
</td>
<td>
<div id='bernard'></div>
<script>dialog();</script>
</td>
<td width=210>
<?php
$result = mysql_query("SELECT * FROM users WHERE login='******' limit 1");
$bot = mysql_fetch_Array($result);
mysql_free_result($result);
showHPbattle($bot);
showPlayer($bot);
?>
</td>
</tr>
</table>
<?php
include "conf.php";
include "functions.php";
$data = mysql_connect($base_name, $base_user, $base_pass);
mysql_select_db($db_name, $data);
$chat_base = "/srv/www/meydan.az/public_html/chat/lovechat";
#$chat_base="C:\\AppServ\www\ever\chat\lovechat";
$query = mysql_fetch_Array(mysql_query("SELECT * FROM war_group"));
if ($query) {
echo "Doyuw Gedir";
} else {
$wait_to = 10 * 60 + time();
mysql_query("INSERT INTO war_group VALUES (null, unix_timestamp()+30*60,0);");
$mess = "Начался приём заявок на Величайшую Битву между Светом и Тьмой на Пещере Воинов";
$mess = "sys<b style=background-color:#CCD1FF>{$mess}</b>endSys";
$fopen_chat = fopen($chat_base, "a");
fwrite($fopen_chat, "::" . time() . "::sys_news::#CCD1FF::{$mess}::room4::mountown::\n");
fclose($fopen_chat);
//echo "OK";
}
<?php
//die("Извините сайт временно не работает.");
include "key.php";
ob_start("@ob_gzhandler");
include "../conf.php";
include 'time.php';
$data = mysql_connect($base_name, $base_user, $base_pass) or die('Не получается подключиться. Проверьте имя сервера, имя пользователя и пароль!');
mysql_select_db($db_name) or die('Ошибка входа в базу данных');
Header("Cache-Control: no-cache, must-revalidate");
// говорим браузеру что-бы он не кешировал эту страницу
Header("Pragma: no-cache");
$login = $_SESSION["login"];
$USER_DATA = mysql_fetch_Array(mysql_query("SELECT forum_shut,level,orden,dealer,admin_level,clan,clan_short,remote_ip,adminsite FROM users WHERE login='******'"));
$level = $USER_DATA["level"];
$orden = $USER_DATA["orden"];
$dealer = $USER_DATA["dealer"];
$admin_level = $USER_DATA["admin_level"];
$clan = $USER_DATA["clan"];
$clan_s = $USER_DATA["clan_short"];
$ip = $USER_DATA["remote_ip"];
$fid = strtolower(htmlspecialchars(addslashes($_GET["fid"])));
$tid = (int) $_GET["tid"];
$view_id = (int) $_GET["view_id"];
$id = htmlspecialchars(addslashes($_GET["id"]));
$get = array("news", "help", "thanks", "relax", "bugs", "idea", "clan", "laws", "contest", "jeremiad", "sales", "lies", "others", "palach", "tarman");
$name = array("Официальные объявления", "Вопросы и помощь в игре", "Благодарности и поздравления", "Отдых", "Ошибки и сбои (Баги)", "Идеи и предложения", "Ханствы", "Законы проекта www.OlDmeydan.Pe.Hu", "Конкурсы", "Жалобы", "Сделки", "Обманы", "Комм. Отдел", "Совещание Стражи Порядка", "Тьма");
$test_out = $name[array_search($fid, $get)];
$date = date("d.m.Y-H:i:s");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
if(stop_time<1) return true;
else
{
document.getElementById("mess").innerHTML="Дождитесь...";//'Дождитесь завершения перемещения..';
return false;
}
}
</script>
<script>
load_page();
</script>
<DIV ID=oMenu CLASS="menu"></DIV>
<?php
echo "\n<table width=100% border=0>\n<tr>\n<td width=100% valign=top>";
$pl_sql = mysql_query("SELECT users.id, users.login, users.battle, level, dealer, orden, admin_level, clan_short, clan, hp, hp_all, labirint.location, war_team.team FROM war_team LEFT JOIN users ON users.login=war_team.player LEFT JOIN labirint on labirint.user_id=war_team.player WHERE group_id='" . $group_id . "' and war_team.lose=0");
while ($players = mysql_fetch_Array($pl_sql)) {
$team_str = "\n\t\t<tr height=10 nowrap>\n\t\t\t<td>\n\t\t\t\t<a href='javascript:top.AddToPrivate(\"" . $players['login'] . "\")'><img border=0 src=img/arrow3.gif alt=\"Приватное сообщение\" ></a> \n\t\t\t\t<script>drwfl('" . $players['login'] . "','" . $players['id'] . "','" . $players['level'] . "','" . $players['dealer'] . "','" . $players['orden'] . "','" . $players['admin_level'] . "','" . $players['clan_short'] . "','" . $players['clan'] . "');</script> \n\t\t\t</td>\n\t\t\t<td>\n\t\t\t\t<script>show(" . $players["hp"] . "," . $players["hp_all"] . ");</script>\n\t\t\t</td>\n\t\t\t<td>\n\t\t\t\t <small>[" . $players['location'] . "]" . ($players['battle'] ? " <a href='log.php?log=" . $players['battle'] . "' target='_blank'><img src='img/b.jpg'>" : "") . "</small>\n\t\t\t</td>\n\t\t\t<td width=20 nowrap>\n\t\t\t\t" . ($my_team != $players["team"] && $step1['fwd'] == $players['location'] ? "<a href='?attack=" . $players['id'] . "'><img src='img/fight.gif' title='напаст'></a>" : "") . "\n\t\t\t</td>\n\t\t</tr>";
if ($players["team"] == 1) {
$team1_str .= $team_str;
} else {
$team2_str .= $team_str;
}
if ($login != $players["login"]) {
$users[] = array(login => $players["login"], coord => $players["location"]);
}
}
echo "\n\t<table border=0 cellpadding=0 cellspacing=0>\n\t\t<tr><td colspan=4 class=newbut align=center><b>Свет</td></tr>\n\t\t{$team1_str}\n\t\t<tr><td colspan=4 height=30></td></tr>\n\t\t<tr><td colspan=4 class=newbut align=center><b>Тьма</td></tr>\n\t\t{$team2_str}\t\n\t</table><br>";
echo "<font color=#ff0000>{$msg}</font>";
//-----------------
echo "</td>";
echo "<td valign=top align=right>\n<table bgcolor=#000000 width=100%><tr><td>";
$mac = "";
}
echo "<tr style=\"background-color: {$row_colour}; padding: 5px;\" valign=top onmouseover=\"this.style.backgroundColor='{$list_highlight}';\" onmouseout=\"this.style.backgroundColor='{$row_colour}';\" onclick=\"location.href='/device/" . $device['device_id'] . "/interface/" . $interface['interface_id'] . "/'\" style='cursor: hand;'>\n <td valign=top width=350>";
echo " <span class=list-large>\n " . generateiflink($interface, $interface['ifIndex'] . ". " . $interface['label']) . " {$error_img} {$mac}\n\n </span><br /><span class=interface-desc>" . $interface['ifAlias'] . "</span>";
if ($interface['ifAlias']) {
echo "<br />";
}
unset($break);
if ($port_details) {
$ipdata = mysql_query("SELECT * FROM `ipv4_addresses` WHERE `interface_id` = '" . $interface['interface_id'] . "'");
while ($ip = mysql_fetch_Array($ipdata)) {
echo "{$break} <a class=interface-desc href=\"javascript:popUp('/netcmd.php?cmd=whois&query={$ip['ipv4_address']}')\">{$ip['ipv4_address']}/{$ip['ipv4_prefixlen']}</a>";
$break = "<br />";
}
$ip6data = mysql_query("SELECT * FROM `ipv6_addresses` WHERE `interface_id` = '" . $interface['interface_id'] . "'");
while ($ip6 = mysql_fetch_Array($ip6data)) {
echo "{$break} <a class=interface-desc href=\"javascript:popUp('/netcmd.php?cmd=whois&query=" . $ip6['ipv6_address'] . "')\">" . Net_IPv6::compress($ip6['ipv6_address']) . "/" . $ip6['ipv6_prefixlen'] . "</a>";
$break = "<br />";
}
}
echo "</span>";
echo "</td><td width=100>";
if ($port_details) {
$interface['graph_type'] = "port_bits";
echo generateiflink($interface, "<img src='graph.php?type=port_bits&port=" . $interface['interface_id'] . "&from=" . $day . "&to=" . $now . "&width=100&height=20&legend=no&bg=" . str_replace("#", "", $row_colour) . "'>", $interface['graph_type']);
$interface['graph_type'] = "port_upkts";
echo generateiflink($interface, "<img src='graph.php?type=port_upkts&port=" . $interface['interface_id'] . "&from=" . $day . "&to=" . $now . "&width=100&height=20&legend=no&bg=" . str_replace("#", "", $row_colour) . "'>", $interface['graph_type']);
$interface['graph_type'] = "port_errors";
echo generateiflink($interface, "<img src='graph.php?type=port_errors&port=" . $interface['interface_id'] . "&from=" . $day . "&to=" . $now . "&width=100&height=20&legend=no&bg=" . str_replace("#", "", $row_colour) . "'>", $interface['graph_type']);
}
echo "</td><td width=120>";
TestBattle($db);
testPrision($db);
testCureTravm($login);
if ($db["exp"] >= $db["next_up"]) {
testUps($db);
}
if ($db["zver_count"]) {
$zver_db = mysql_fetch_assoc(mysql_query("SELECT * FROM zver WHERE id=" . $db["zver_count"]));
if ($zver_db["exp"] >= $zver_db["next_up"]) {
testZverUp($zver_db, $db["login"]);
}
}
######################################################
if ($db["son"] == 0) {
########################## Жажда жизни ############################################
$have_elik = mysql_fetch_Array(mysql_query("SELECT * FROM effects WHERE user_id=" . $db["id"] . " and type='jj'"));
if ($have_elik) {
if ($have_elik["end_time"] < time()) {
mysql_query("UPDATE users SET hp_all=hp_all-" . $have_elik["add_hp"] . " WHERE login='******'");
mysql_query("DELETE FROM effects WHERE id=" . $have_elik["id"]);
$_SESSION["message"] .= "Действие Эликсира <b>«Жажда жизни+?»</b> закончилось!!!<br/>";
}
}
####################################################################################
mysql_query("DELETE FROM effects WHERE user_id=" . $db["id"] . " and end_time<" . time() . " and type!='jj'");
if (mysql_affected_rows() > 0) {
$_SESSION["message"] .= "Действие Эликсира закончилось!!!<br/>";
}
}
####################################################################################
include "fill_hp.php";
$random = md5(time());
$data = mysql_connect($base_name, $base_user, $base_pass);
if (!mysql_select_db($db_name, $data)) {
echo mysql_error();
die;
}
header('Expires: Mon, 26 Jul 1997 05:00:00 GMT');
header('Cache-Control: no-store, no-cache, must-revalidate');
header('Cache-Control: post-check=0, pre-check=0', FALSE);
header('Pragma: no-cache');
//------------------------------
if ($_GET["bat_id"]) {
$bat_id = (int) $_GET["bat_id"];
$bat_sql = mysql_query("SELECT creator_id FROM battles WHERE id=" . $bat_id);
if (mysql_num_rows($bat_sql)) {
$battle = mysql_fetch_Array($bat_sql);
$bot = mysql_query("SELECT * FROM bot_temp WHERE battle_id='" . $bat_id . "' and hp>0");
while ($bots = mysql_fetch_array($bot)) {
$enemy_teams = $bots["team"] == 1 ? 2 : 1;
$sql = mysql_query("SELECT * FROM teams WHERE team={$enemy_teams} and battle_id=" . $battle["creator_id"]);
while ($teams = mysql_fetch_array($sql)) {
$hits = mysql_query("SELECT * FROM hit_temp WHERE attack='" . $teams["player"] . "' and defend='" . $bots["bot_name"] . "' and battle_id=" . $bat_id);
if (!mysql_num_rows($hits)) {
$hit1 = rand(1, 5);
$hit2 = rand(1, 5);
$block = rand(1, 5);
hit($bots["bot_name"], $teams["player"], $hit1, $hit2, $hit3, $block, $bat_id, 1);
}
}
$sql_bot = mysql_query("SELECT * FROM bot_temp WHERE team={$enemy_teams} and battle_id=" . $bat_id . " and hp>0");
while ($teams_bot = mysql_fetch_array($sql_bot)) {
$login = $_SESSION['login'];
?>
<head>
<title>WWW.MEYDAN.AZ - отчеты о переводах.</title>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
<meta http-equiv="Content-Language" content="ru">
<META Http-Equiv=Cache-Control Content="no-cache, max-age=0, must-revalidate, no-store">
<meta http-equiv=PRAGMA content=NO-CACHE>
<meta http-equiv=Expires content=0>
<LINK REL=StyleSheet HREF='main.css' TYPE='text/css'>
</head>
<body bgcolor=#dddddd topMargin=0 leftMargin=0 rightMargin=0 bottomMargin=0 >
<?php
$data = mysql_connect($base_name, $base_user, $base_pass) or die('Не получается подключиться. Проверьте имя сервера, имя пользователя и пароль!');
mysql_select_db($db_name) or die('Ошибка входа в базу данных');
$db = mysql_fetch_Array(mysql_query("SELECT admin_level,dealer,adminsite FROM users WHERE login='******'"));
if ($db["admin_level"] < 4 && !$db["dealer"]) {
die("<h3>Вам сюда нельзя!</h3>");
}
//---------------------------------------------
$start = 0;
if (isset($_GET['start'])) {
$start = htmlspecialchars($_GET['start']);
}
if ($start < 0 || !is_numeric($start)) {
$start = 0;
}
//---------------------------------------------
$tar = htmlspecialchars(addslashes($_GET['tar']));
$q = mysql_query("SELECT * FROM users WHERE login='******'");
$res = mysql_fetch_array($q);
function lose($team, $battle, $phrase)
{
$date = date("H:i");
$sql_bat = mysql_query("SELECT zayavka.type,battles.creator_id FROM `battles` LEFT JOIN zayavka on zayavka.creator=battles.creator_id WHERE battles.id={$battle}");
$B_DAT = mysql_fetch_array($sql_bat);
mysql_free_result($sql_bat);
$cr = $B_DAT["creator_id"];
$zay_type = $B_DAT["type"];
$boylar = array(3, 4, 101, 5, 6, 102, 11);
$T = mysql_query("SELECT player,hitted FROM teams WHERE battle_id='" . $cr . "' AND over=0 and team='" . $team . "'");
while ($DATA = mysql_fetch_array($T)) {
$player = $DATA["player"];
$hitted_win = $DATA["hitted"];
if ($zay_type == 15) {
mysql_query('UPDATE labirint SET location="29x15", vector="180" WHERE user_id="' . $player . '"');
}
if ($zay_type == 88) {
mysql_query('UPDATE labirint SET location="29x2", vector="180", lose=lose+1 WHERE user_id="' . $player . '"');
}
if ($zay_type == 89) {
mysql_query('UPDATE labirint SET lose=lose+1 WHERE user_id="' . $player . '"');
}
//-------------------------------------------------------------------------------------
$LOSER_QUERY_D = mysql_query("SELECT users.*,zver.energy FROM users LEFT join zver on zver.owner=users.id and zver.sleep=0 WHERE login='******'");
$LOSER_DATA = mysql_fetch_array($LOSER_QUERY_D);
mysql_free_result($LOSER_QUERY_D);
$objects = array();
$objects[0] = $LOSER_DATA["amulet"];
$objects[1] = $LOSER_DATA["hand_r"];
$objects[2] = $LOSER_DATA["armour"];
$objects[3] = $LOSER_DATA["poyas"];
$objects[4] = $LOSER_DATA["ring1"];
$objects[5] = $LOSER_DATA["ring2"];
$objects[6] = $LOSER_DATA["ring3"];
$objects[7] = $LOSER_DATA["helmet"];
$objects[8] = $LOSER_DATA["perchi"];
$objects[9] = $LOSER_DATA["hand_l"];
$objects[10] = $LOSER_DATA["boots"];
$objects[11] = $LOSER_DATA["naruchi"];
$objects[12] = $LOSER_DATA["rubaxa"];
$objects[13] = $LOSER_DATA["plash"];
$objects[14] = $LOSER_DATA["mask"];
$objects[15] = $LOSER_DATA["pants"];
$objects[16] = $LOSER_DATA["masdrikon"];
$objects[17] = $LOSER_DATA["rukavic"];
$damage = 0;
shuffle($objects);
foreach ($objects as $key => $value) {
if ($value == 0) {
unset($objects[$key]);
}
}
$new_array = array_values($objects);
$damage = $new_array[0];
if ($damage != 0) {
$GET_F_INV = mysql_query("SELECT paltar.name,inv.iznos_max,inv.iznos FROM inv LEFT JOIN paltar on paltar.id=inv.object_id WHERE inv.id=" . $damage);
$GET_D = mysql_fetch_array($GET_F_INV);
mysql_free_result($GET_F_INV);
$iznos_all = $GET_D["iznos_max"];
$iznos = $GET_D["iznos"] + 1;
$obj_name = $GET_D["name"];
$krit_iznos = $iznos_all - 2;
if ($iznos >= $krit_iznos && $iznos < $iznos_all) {
talk($player, "Предмет <b>" . $obj_name . "</b> в критическом состоянии!<BR><small>(на правах рекламы) <b>Ремонтная мастерская</b>. Мы даем вторую жизнь старым вещам!</small>", $LOSER_DATA);
}
if ($iznos <= $iznos_all) {
mysql_query("UPDATE inv SET iznos =iznos+1 WHERE id = '" . $damage . "'");
}
if ($iznos_all == 1) {
unWear($player, $damage);
mysql_query("DELETE FROM inv WHERE id='" . $damage . "'");
history($player, 'Пришел в негодность', $obj_name, $LOSER_DATA["remote_ip"], "Бой " . $battle);
talk($player, "Предмет <b>" . $obj_name . "</b> сломался", $LOSER_DATA);
} else {
if ($iznos == $iznos_all) {
unWear($player, $damage);
talk($player, "Предмет <b>" . $obj_name . "</b> нуждается в ремонте!<BR><small>(на правах рекламы) <b>Ремонтная мастерская</b>. Мы даем вторую жизнь старым вещам!</small>", $LOSER_DATA);
}
}
}
if ($zay_type == 29) {
#Пещера Воинов
mysql_query("UPDATE users SET zayava=0 WHERE login='******'");
mysql_query("UPDATE war_team SET lose=1 WHERE player='" . $player . "'");
say("toroom", "<b>{$player}</b> трагически погиб и покидает турнир.", $player);
}
if ($zay_type == 99 || $zay_type == 66) {
mysql_query("UPDATE users SET bs=0,location='', vector='' WHERE login='******'");
$str = "<span class=date>" . date("d.m.y H:i") . "</span> <script>drwfl('" . $LOSER_DATA['login'] . "','" . $LOSER_DATA['id'] . "','" . $LOSER_DATA['level'] . "','" . $LOSER_DATA['dealer'] . "','" . $LOSER_DATA['orden'] . "','" . $LOSER_DATA['admin_level'] . "','" . $LOSER_DATA['clan_short'] . "','" . $LOSER_DATA['clan'] . "');</script> повержен и выбывает из турнира<BR>";
mysql_query('UPDATE `deztow_turnir` SET `log` = CONCAT(`log`,"' . $str . '") WHERE `active` = TRUE');
mysql_Query("DELETE FROM labirint WHERE user_id='" . $player . "'");
mysql_Query("UPDATE bs_objects SET bs=0,owner='',coord='" . $LOSER_DATA["location"] . "' WHERE owner='" . $player . "'");
mysql_query("DELETE FROM inv WHERE owner='" . $player . "' and object_razdel='thing' and object_id=24 LIMIT 1");
say("toroom", "<b>{$player}</b> трагически погиб и покидает турнир.", $player);
}
if ($zay_type == 19) {
//Таинственный Маяк
$have_hell = mysql_fetch_Array(mysql_Query("SELECT * FROM hellround_pohod WHERE `end` = 0 and `owner`=" . $LOSER_DATA["id"] . ";"));
$count_wood = $have_hell["volna"];
for ($i = 0; $i < $count_wood; $i++) {
mysql_query("INSERT INTO `inv` (`owner`, `object_id`, `object_type`, `object_razdel` ,`iznos`, `iznos_max`) VALUES ('" . $LOSER_DATA['login'] . "', '139','wood','thing','0','1');");
}
$count_redkiy = $have_hell["unikal_count"] - 1;
if ($count_redkiy > 0) {
for ($i = 0; $i < $count_redkiy; $i++) {
mysql_query("INSERT INTO `inv` (`owner`, `object_id`, `object_type`, `object_razdel` ,`iznos`, `iznos_max`) VALUES ('" . $LOSER_DATA['login'] . "', '140','wood','thing','0','1');");
}
$str_redkiy = "<b>Редкий Образец</b> x{$count_redkiy}.";
}
say("toroom", "<b>" . $LOSER_DATA['login'] . "</b> создал предмет <b>Образец</b> x{$count_wood}. {$str_redkiy}", $LOSER_DATA['login']);
mysql_Query("UPDATE hellround_pohod SET `end` = 1, `date_out` = " . time() . " WHERE `end` = 0 and `owner`=" . $LOSER_DATA["id"] . ";");
}
/*if(in_array($zay_type,$boylar))
{
//new year
//mysql_Query("INSERT INTO inv (owner, object_id, object_type, object_razdel, gift, gift_author, iznos, iznos_max, term) VALUES('".$LOSER_DATA['login']."', '60', 'scroll', 'magic', '1', 'WWW.MEYDAN.AZ', '0', '1', '".(time()+30*24*3600)."');");
//talk($LOSER_DATA["login"],"Вы нашли <b>Снежок</b>",$LOSER_DATA);
//novruz
mysql_Query("INSERT INTO inv (owner, object_id, object_type, object_razdel, gift, gift_author, iznos, iznos_max, term) VALUES('".$LOSER_DATA['login']."', '262', 'scroll', 'magic', '1', 'WWW.MEYDAN.AZ', '0', '1', '".(time()+30*24*3600)."');");
talk($LOSER_DATA["login"],"Вы нашли <b>Праздничные яйца</b>",$LOSER_DATA);
}*/
if ($LOSER_DATA["zver_on"]) {
$exp_minus = rand(1, 4);
if ($LOSER_DATA["energy"] < $exp_minus) {
$exp_minus = rand(1, $LOSER_DATA["energy"]);
}
mysql_query("UPDATE zver SET energy=energy-{$exp_minus} WHERE owner=" . $LOSER_DATA["id"] . " and sleep=0 ");
}
$krov = array("100", "101", "102", "11");
if (in_array($zay_type, $krov)) {
$travm = rand(1, 3);
getTravm($player, $travm);
include "travm_dis.php";
$travm_dis = array();
$travm_dis[1] = $ushib_d_h[rand(0, count($ushib_d_h) - 1)];
$travm_dis[2] = $ushib_d_c[rand(0, count($ushib_d_c) - 1)];
$travm_dis[3] = $ushib_d_l[rand(0, count($ushib_d_l) - 1)];
$phrase = "<span class=date>{$date}</span> <B>" . $player . "</B> получил повреждение: <font color=red>" . $travm_dis[$travm] . "</font>.<BR>";
battle_log($battle, $phrase);
}
if ($zay_type == 20) {
getTravm($player, 4);
$phrase = "<span class=date>{$date}</span> <B>" . $player . "</B> получил повреждение: <font color=red>Неличимая травма</font>.<BR>";
battle_log($battle, $phrase);
}
if ($phrase == 0) {
talk($player, "Бой окончен! Вы проиграли бой. Всего вами нанесено: <b>" . $hitted_win . " HP</b>. Получено опыта: <b>0</b>.", $LOSER_DATA);
} else {
if ($phrase == 1) {
talk($player, "Бой окончен! Ничья! Всего вами нанесено: <b>" . $hitted_win . " HP</b>. Получено опыта: <b>0</b>.", $LOSER_DATA);
} else {
if ($phrase == 2) {
$travm = rand(1, 3);
getTravm($player, $travm);
include "travm_dis.php";
$travm_dis = array();
$travm_dis[1] = $ushib_d_h[rand(0, count($ushib_d_h) - 1)];
$travm_dis[2] = $ushib_d_c[rand(0, count($ushib_d_c) - 1)];
$travm_dis[3] = $ushib_d_l[rand(0, count($ushib_d_l) - 1)];
$phrase = "<span class=date>{$date}</span> <B>" . $player . "</B> получил повреждение: <font color=red>" . $travm_dis[$travm] . "</font>.<BR>";
battle_log($battle, $phrase);
talk($player, "Бой окончен! Вы проиграли бой. Всего вами нанесено: <b>{$hitted_win} HP</b>. Получено опыта: <b>0</b>.", $LOSER_DATA);
} else {
if ($phrase == 11) {
talk($player, "Бой окончен по таймауту! Ничья! Всего вами нанесено: <b>{$hitted_win} HP</b>. Получено опыта: <b>0</b>.", $LOSER_DATA);
}
}
}
}
$all_hp = $LOSER_DATA["hp_all"];
if ($LOSER_DATA["level"] < 4) {
setHP($player, $all_hp, $all_hp);
} else {
setHP($player, '0', $all_hp);
}
$cur_m = $LOSER_DATA["mana"];
$all_m = $LOSER_DATA["mana_all"];
setMN($player, $cur_m, $all_m);
}
mysql_query("UPDATE users,(SELECT player FROM teams WHERE battle_id='" . $cr . "' AND team='" . $team . "') as upd SET battle='0', " . ($phrase == 1 || $phrase == 11 ? "nich=nich+1" : "lose=lose+1") . ", zayavka=0, battle_opponent='', battle_pos='', battle_team='',fwd='',zver_on=0,oslab=" . (time() + 5 * 60) . " WHERE login=upd.player");
mysql_query("UPDATE teams SET over = 1 WHERE battle_id='" . $cr . "' and team={$team}");
}
<?php
echo "<form name='action' action='?spell=clan_perevod' method='post'>";
echo "<select name=clan class=new>";
$sql = mysql_query("SELECT name, name_short FROM clan");
while ($res = mysql_fetch_Array($sql)) {
echo "<option value='" . $res["name_short"] . "' " . ($res["name_short"] == $_POST["clan"] ? " selected" : "") . ">" . $res["name"];
}
echo "</select>\n<input type=submit value='Посмотрет Отчет' class=new>\n</form>";
if ($_POST["clan"]) {
$clan_s = htmlspecialchars(addslashes($_POST["clan"]));
$lines = file("clan/operation/" . $clan_s . ".dis");
foreach ($lines as $line_num => $line) {
$dis = explode("|", $line);
$txt .= $dis[2] . " " . $dis[0] . " [" . $dis[1] . "]\n";
}
echo "<textarea rows=30 cols=120>" . str_replace("<b>", "", str_replace("</b>", "", $txt)) . "</textarea>";
}
} else {
$msg = "Вы не можете идти на поединок против своих...";
}
} else {
$msg = "Максимальное колличество бойцов в группе - 20 чел.";
}
} else {
$msg = "Вы уже и так в группе";
}
}
#######################################################
echo "\n\t\t\t\t\t<font color='#ff0000'>{$msg}</font><br>\n\t\t\t\t\t<table cellspacing=1 cellpadding=3 align=center width=600>\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<td colspan=2 align=center><b>До войны еще: " . convert_time($have_Zayavka['start_time']) . "</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='newbut' align=center>\n\t\t\t\t\t\t\t<td width=50%><b>Свет</td><td><b>Тьма</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<td valign=top>";
$sql_team1 = mysql_query("SELECT users.login, users.level, users.id, users.orden, users.admin_level, users.clan, users.clan_short, users.dealer FROM war_team LEFT JOIN users ON users.login=war_team.player WHERE group_id=" . $have_Zayavka['id'] . " and war_team.team=1");
while ($team1 = mysql_fetch_Array($sql_team1)) {
echo "<script>drwfl('" . $team1['login'] . "','" . $team1['id'] . "','" . $team1['level'] . "','" . $team1['dealer'] . "','" . $team1['orden'] . "','" . $team1['admin_level'] . "','" . $team1['clan_short'] . "','" . $team1['clan'] . "');</script><br>";
}
echo "</td>\n\t\t\t\t\t\t\t<td valign=top>";
$sql_team2 = mysql_query("SELECT users.login, users.level, users.id, users.orden, users.admin_level, users.clan, users.clan_short, users.dealer FROM war_team LEFT JOIN users ON users.login=war_team.player WHERE group_id=" . $have_Zayavka['id'] . " and war_team.team=2");
while ($team2 = mysql_fetch_Array($sql_team2)) {
echo "<script>drwfl('" . $team2['login'] . "','" . $team2['id'] . "','" . $team2['level'] . "','" . $team2['dealer'] . "','" . $team2['orden'] . "','" . $team2['admin_level'] . "','" . $team2['clan_short'] . "','" . $team2['clan'] . "');</script><br>";
}
echo "</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr align=center>\n\t\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t\t<input class='newbut' type='button' onclick=\"document.location.href='?team=1'\" value=\"Я за Свет!\">\n\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t\t<input class='newbut' type='button' onclick=\"document.location.href='?team=2'\" value=\"Я за Тьма!\">\n\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t</table>";
}
}
?>
</td>
</tr>
</table>
<br><br><br><br><br><br><br><br>
<?php
include_once "counter.php";
