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";