exit;
/*-------------------------------------------------------------*/
/* Funcao que INSERE um CAMPUS no cadastro do ORIENTADOR */
/*-------------------------------------------------------------*/
# Retorno: 18 = sucesso, -18 = curso ja cadastrado, -1 = erro #
} else {
if (isset($_POST['opcao']) && $_POST['opcao'] == "inserirCampusOr") {
if (isset($_POST["f_campus"])) {
$id_user = $_SESSION["id_usuario"];
$id_campus = (int) $_POST["f_campus"];
// Verifica o numero de campus ja cadastrados pelo usuario
$nroCampusCad = recNumRows($id_user, "fk_orientador", "orientador_campus", $conexao);
// Verifica se o campus em questao ja esta cadastrado
$queryConfere = "SELECT *\r\n\t\t\tFROM orientador_campus\r\n\t\t\tWHERE fk_orientador = '" . $id_user . "'\r\n\t\t\tAND fk_campus = '" . $id_campus . "'";
$sqlConfere = runSQL($queryConfere);
$Confere = mysql_num_Rows($sqlConfere);
// Se este campus ainda nao foi inserido: INSERIR
if ($Confere == 0) {
$nroCampusCad++;
$query = "INSERT into orientador_campus\r\n\t\t\t\t\t\t(fk_orientador, fk_campus, seq)\r\n\t\t\t\t\t VALUES\r\n\t\t\t\t\t\t('{$id_user}', '{$id_campus}', '{$nroCampusCad}')";
$sql = runSQL($query);
$ans = 14;
// Se o campus ja esta cadastrado para este usuario: ERRO
} else {
$ans = -14;
}
// Se nao foi possivel recuperar dados do form: ERRO
} else {
$ans = -1;
}
$resp = "dados={retorno:'" . $ans . "'}";
function win($team, $battle)
{
include "conf.php";
$date = date("H:i");
$sql_bat = mysql_query("SELECT zayavka.type, zayavka.clan_id, zayavka.hidden, 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"];
$hidden = $B_DAT["hidden"];
$bot_battle = array(55, 10, 80, 15, 82, 33, 88, 89);
$boylar = array(3, 4, 101, 5, 6, 102, 11, 7);
$svet_ = array(4);
$tma_ = array(2, 6);
$neytral_ = array(3);
$gr = array(3, 4, 101);
$gr_perc = 0.05;
$haot = array(5, 6, 102);
$haot_perc = 0.1;
if ($hidden) {
$haot_perc = 0.15;
}
if (in_array($zay_type, $gr)) {
$faiz = $faiz + $faiz * $gr_perc;
}
if (in_array($zay_type, $haot)) {
$faiz = $faiz + $faiz * $haot_perc;
}
if ($zay_type == 23) {
$faiz = $faiz + 2;
}
//if ($zay_type==77) $faiz=1.5*$faiz;
if ($zay_type == 11) {
$faiz = 1.5 * $faiz;
}
$lev = 0;
$lev_a = 0;
$SSS = mysql_query("SELECT sum(users.level)as level, count(teams.player)as count FROM teams LEFT JOIN users on users.login=teams.player WHERE teams.battle_id='" . $cr . "' and teams.team='" . ($team == 1 ? 2 : 1) . "'");
$SD = mysql_fetch_array($SSS);
$lev = (int) $SD["level"];
$lev_a = (int) $SD["count"];
$SSS1 = mysql_query("SELECT sum(users.level)as level, count(bot_temp.prototype)as count FROM bot_temp LEFT JOIN users on users.login=bot_temp.prototype WHERE bot_temp.battle_id='" . $battle . "' AND team='" . ($team == 1 ? 2 : 1) . "' and zver=0");
$SD1 = mysql_fetch_array($SSS1);
$lev = $lev + (int) $SD1["level"];
$lev_a = $lev_a + (int) $SD1["count"];
$SSS2 = mysql_query("SELECT sum(zver.level)as level, count(bot_temp.prototype)as count FROM bot_temp LEFT JOIN zver on zver.id=bot_temp.prototype WHERE bot_temp.battle_id='" . $battle . "' AND team='" . ($team == 1 ? 2 : 1) . "' and zver=1");
$SD2 = mysql_fetch_array($SSS2);
$lev = $lev + (int) $SD2["level"];
$lev_a = $lev_a + (int) $SD2["count"];
if ($lev_a == 0) {
$lev_a++;
}
$user_level = ceil($lev / $lev_a);
include "basehp.php";
$svet = 0;
$tma = 0;
$winners = "";
$all_winners = "";
$win_array = array();
$art_array = array();
$max_hp = 0;
$max_hp_winner = "";
$T = mysql_query("SELECT hitted,player FROM teams WHERE battle_id='" . $cr . "' AND over=0 AND team='" . $team . "'");
$count_winners = mysql_num_Rows($T);
while ($DATA = mysql_fetch_array($T)) {
$monstr_win = 0;
$hitted_win = $DATA["hitted"];
$player = $DATA["player"];
$all_winners .= $player . ", ";
if ($hitted_win > $max_hp) {
$max_hp = $hitted_win;
$max_hp_winner = $player;
}
$WINNER_QUERY_D = mysql_query("SELECT users.*,zver.level as zver_level,zver.energy FROM users LEFT JOIN zver on zver.owner=users.id and zver.sleep=0 WHERE login='******'");
$WINNER_DATA = mysql_fetch_array($WINNER_QUERY_D);
mysql_free_result($WINNER_QUERY_D);
//$user_level=$WINNER_DATA["level"];
$art_array[] = $player;
if ($WINNER_DATA["hp"] > 0 && $WINNER_DATA["orden"] != 5) {
$winners .= "<b>" . $player . "</b>, ";
if ($hitted_win > 5000) {
$win_array[] = $player;
}
}
if ($WINNER_DATA["zver_on"] && $WINNER_DATA["zver_level"] < $WINNER_DATA["level"] && $WINNER_DATA["zver_level"] < 10) {
$exp_minus = rand(1, 4);
if ($WINNER_DATA["energy"] < $exp_minus) {
$exp_minus = rand(1, $WINNER_DATA["energy"]);
}
$zver_oput = (int) ($exp_table_bot[$WINNER_DATA["zver_level"]] * $faiz);
if (in_array($zay_type, $bot_battle)) {
$zver_oput = ($WINNER_DATA["zver_level"] + 1) * 3 * $faiz;
}
mysql_query("UPDATE zver SET energy=energy-{$exp_minus},exp=exp+" . $zver_oput . " WHERE owner=" . $WINNER_DATA["id"] . " and sleep=0");
$ms = "Опыт зверя увеличился на <b>" . $zver_oput . "</b>." . ($faiz > 1 && $zver_oput > 0 ? " (" . $faiz * 100 . "%)" : "");
talk($WINNER_DATA["login"], $ms, $WINNER_DATA);
}
if (in_array($zay_type, $boylar)) {
if ($WINNER_DATA['clan'] != "") {
mysql_query("UPDATE clan SET ochki=ochki+1 WHERE name='" . $WINNER_DATA["clan"] . "'");
}
if (in_array($WINNER_DATA['orden'], $svet_)) {
$svet++;
}
if (in_array($WINNER_DATA['orden'], $tma_)) {
$tma++;
}
if (in_array($WINNER_DATA['orden'], $neytral_)) {
$neytral++;
}
#new year
#mysql_Query("INSERT INTO inv (owner, object_id, object_type, object_razdel, gift, gift_author, iznos, iznos_max, term) VALUES('".$WINNER_DATA['login']."', '60', 'scroll', 'magic', '1', 'WWW.MEYDAN.AZ', '0', '1', '".(time()+30*24*3600)."');");
#talk($WINNER_DATA["login"],"Вы нашли <b>Снежок</b>",$WINNER_DATA);
#novruz
#mysql_Query("INSERT INTO inv (owner, object_id, object_type, object_razdel, gift, gift_author, iznos, iznos_max, term) VALUES('".$WINNER_DATA['login']."', '262', 'scroll', 'magic', '1', 'WWW.MEYDAN.AZ', '0', '1', '".(time()+30*24*3600)."');");
#mysql_Query("INSERT INTO inv (owner, object_id, object_type, object_razdel, gift, gift_author, iznos, iznos_max, term) VALUES('".$WINNER_DATA['login']."', '262', 'scroll', 'magic', '1', 'WWW.MEYDAN.AZ', '0', '1', '".(time()+30*24*3600)."');");
#talk($WINNER_DATA["login"],"Вы нашли 2 <b>Праздничные яйца</b>",$WINNER_DATA);
mysql_Query("INSERT INTO inv (owner, object_id, object_type, object_razdel, iznos, iznos_max) VALUES('" . $WINNER_DATA['login'] . "', '20', 'wood', 'thing', '0', '1');");
talk($WINNER_DATA["login"], "Вы нашли <b>Жетон Падшего Бойца</b>", $WINNER_DATA);
}
if ($zay_type == 82) {
//Ледяная пещера
$monstr_win = 1;
switch ($WINNER_DATA['room']) {
case "labirint_led":
$etaj = 1;
break;
case "labirint_led2":
$etaj = 2;
break;
}
if ($WINNER_DATA['fwd']) {
$gr_id = mysql_fetch_array(mysql_query("SELECT group_id FROM led_login WHERE player='" . $WINNER_DATA['login'] . "'"));
mysql_query("INSERT INTO led_setting VALUES (null,'" . $WINNER_DATA['fwd'] . "','" . $WINNER_DATA['login'] . "','" . $gr_id['group_id'] . "','" . $etaj . "','bot','')");
$count_led = rand(0, 2);
if ($count_led > 0) {
for ($kk = 1; $kk <= $count_led; $kk++) {
$item_led = rand(64, 68);
mysql_query("INSERT INTO led_setting VALUES (null,'" . $WINNER_DATA['fwd'] . "','" . $WINNER_DATA['login'] . "','" . $gr_id['group_id'] . "','" . $etaj . "','items','" . $item_led . "')");
}
}
}
}
if ($zay_type == 89) {
//Пещера Праздничная
$monstr_win = 1;
switch ($WINNER_DATA['room']) {
case "novruz_floor":
$etaj = 1;
break;
case "novruz_floor2":
$etaj = 2;
break;
}
if ($WINNER_DATA['fwd']) {
$gr_id = mysql_fetch_array(mysql_query("SELECT group_id FROM labirint_login WHERE player='" . $WINNER_DATA['login'] . "'"));
mysql_query("INSERT INTO labirint_setting VALUES (null,'" . $WINNER_DATA['fwd'] . "','" . $WINNER_DATA['login'] . "','" . $gr_id['group_id'] . "','" . $etaj . "','bot','')");
$count_led = rand(1, 2);
if ($count_led > 0) {
for ($kk = 1; $kk <= $count_led; $kk++) {
$item_led = rand(151, 155);
mysql_query("INSERT INTO labirint_setting VALUES (null,'" . $WINNER_DATA['fwd'] . "','" . $WINNER_DATA['login'] . "','" . $gr_id['group_id'] . "','" . $etaj . "','items','" . $item_led . "')");
}
}
}
}
if ($zay_type == 15) {
//Катакомбы
$monstr_win = 1;
if ($WINNER_DATA['fwd']) {
$sel_ = mysql_fetch_array(mysql_query("SELECT battle_id FROM zayavka_teams WHERE player='" . $WINNER_DATA['login'] . "'"));
mysql_query("INSERT INTO dungeon_bots VALUES ('" . $WINNER_DATA['fwd'] . "','" . $WINNER_DATA['login'] . "','" . $sel_['battle_id'] . "')");
$counts = rand(1, 4);
if ($counts > 0) {
for ($kk = 1; $kk <= $counts; $kk++) {
$items = rand(52, 63);
mysql_query("INSERT INTO predmet (creator, cord, object_id, type) VALUES ('" . $sel_['battle_id'] . "','" . $WINNER_DATA['fwd'] . "','" . $items . "','wood')");
}
}
}
}
if ($zay_type == 13 || $zay_type == 77) {
$winner_clan = $WINNER_DATA["clan_short"];
$winner_clan_name = $WINNER_DATA["clan"];
}
if ($zay_type == 33) {
//Проклеенный Клад
$monstr_win = 1;
switch ($WINNER_DATA['room']) {
case "crypt":
$etaj = 1;
break;
case "crypt_floor2":
$etaj = 2;
break;
}
if ($WINNER_DATA['fwd']) {
$gr_id = mysql_fetch_array(mysql_query("SELECT group_id FROM z_login WHERE player='" . $WINNER_DATA['login'] . "'"));
mysql_query("INSERT INTO crypt_setting VALUES (null,'" . $WINNER_DATA['fwd'] . "','" . $WINNER_DATA['login'] . "','" . $gr_id['group_id'] . "','" . $etaj . "','bot','')");
$counts = rand(0, 3);
if ($counts > 0) {
if ($etaj == 1) {
$item_array = array(84, 85, 86, 87, 88, 89, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117);
mysql_query("INSERT INTO crypt_setting VALUES (null,'" . $WINNER_DATA['fwd'] . "','" . $WINNER_DATA['login'] . "','" . $gr_id['group_id'] . "','" . $etaj . "','items','" . mt_rand(84, 89) . "')");
} else {
if ($etaj == 2) {
$have_qwest = mysql_fetch_Array(mysql_query("SELECT * FROM qwest WHERE owner='" . $WINNER_DATA["id"] . "' and status=0"));
if ($have_qwest) {
$item_array = array();
$item_array[] = $have_qwest["item1"];
if ($have_qwest["item2"]) {
$item_array[] = $have_qwest["item2"];
}
if ($have_qwest["item3"]) {
$item_array[] = $have_qwest["item3"];
}
}
}
}
for ($kk = 1; $kk <= $counts; $kk++) {
if ($etaj == 1) {
$all_res = rand(1, 5);
if ($all_res == 1) {
$items = rand(91, 93);
} else {
$items = $item_array[rand(0, count($item_array) - 1)];
}
} else {
if ($etaj == 2) {
$items = $item_array[rand(0, count($item_array) - 1)];
}
}
if ($items) {
mysql_query("INSERT INTO crypt_setting VALUES (null,'" . $WINNER_DATA['fwd'] . "','" . $WINNER_DATA['login'] . "','" . $gr_id['group_id'] . "','" . $etaj . "','items','" . $items . "')");
}
}
}
}
}
if ($zay_type == 88) {
//Загадочная пещера
$monstr_win = 1;
switch ($WINNER_DATA['room']) {
case "izumrud_floor":
$etaj = 1;
break;
case "izumrud_floor2":
$etaj = 2;
break;
}
if ($WINNER_DATA['fwd']) {
$gr_id = mysql_fetch_array(mysql_query("SELECT group_id FROM izumrud_login WHERE player='" . $WINNER_DATA['login'] . "'"));
mysql_query("INSERT INTO izumrud_setting VALUES (null,'" . $WINNER_DATA['fwd'] . "','" . $WINNER_DATA['login'] . "','" . $gr_id['group_id'] . "','" . $etaj . "','bot','')");
$counts = rand(0, 3);
if ($counts > 0) {
if ($etaj == 1) {
$item_array = array(142, 143, 144, 145, 146, 147);
} else {
if ($etaj == 2) {
$item_array = array(1);
}
}
for ($kk = 1; $kk <= $counts; $kk++) {
if ($etaj == 1) {
$items = $item_array[rand(0, count($item_array) - 1)];
} else {
if ($etaj == 2) {
$items = $item_array[rand(0, count($item_array) - 1)];
}
}
if ($items) {
mysql_query("INSERT INTO izumrud_setting VALUES (null,'" . $WINNER_DATA['fwd'] . "','" . $WINNER_DATA['login'] . "','" . $gr_id['group_id'] . "','" . $etaj . "','items','" . $items . "')");
}
}
}
}
}
$vip_bonus = 0;
$vip_text = "";
$add_exp = $exp_table[$user_level] * $hitted_win / 100 * ($WINNER_DATA["orden"] == 5 ? 0.2 : 1);
$w_exp = $add_exp;
if ($zay_type == 15) {
$w_exp = $w_exp / 3;
$monstr_win = 1;
} else {
if ($zay_type == 55) {
$w_exp = $w_exp / 4;
$monstr_win = 1;
} else {
if (in_array($zay_type, $bot_battle)) {
$w_exp = $WINNER_DATA["level"] * 10;
$monstr_win = 1;
}
}
}
if ($w_exp > $max_exp[$WINNER_DATA["level"]]) {
$w_exp = $max_exp[$WINNER_DATA["level"]];
}
if ($WINNER_DATA["vip"] > time()) {
$vip_bonus = ceil($w_exp * 0.5);
$vip_text = "<b>VIP Бонус</b> + {$vip_bonus} опыта. ";
}
$w_exp = $w_exp + $vip_bonus;
$w_exp = $w_exp * $faiz;
if ($zay_type == 19) {
//Таинственный Маяк
mysql_Query("UPDATE hellround_pohod SET `end` = 1, `date_out` = " . time() . " WHERE `end` = 0 and `owner`=" . $WINNER_DATA["id"] . ";");
$w_exp = 0;
$monstr_win = 1;
}
$w_exp = ceil($w_exp);
//-------give money-------------------------
$give_money = rand(5, 80);
//Групповые: с оружием
$str_money = ($zay_type == 4 || $zay_type == 5) && $WINNER_DATA["orden"] != 5 ? $give_money : 0;
$text = $str_money ? "Вы нашли <b>" . sprintf("%01.2f", $give_money) . " Зл.</b> у убитого бойца." : "";
if ($zay_type == 1 || $zay_type == 100) {
mysql_query("UPDATE daily_kwest SET taked=taked+1 WHERE user_id='" . $WINNER_DATA['id'] . "' and kwest_id=2");
}
if ($zay_type == 4 || $zay_type == 101) {
mysql_query("UPDATE daily_kwest SET taked=taked+1 WHERE user_id='" . $WINNER_DATA['id'] . "' and kwest_id=3");
}
if ($zay_type == 5 || $zay_type == 102 || $zay_type == 7) {
mysql_query("UPDATE daily_kwest SET taked=taked+1 WHERE user_id='" . $WINNER_DATA['id'] . "' and kwest_id=4");
}
//------------------------------------------
mysql_query("UPDATE daily_kwest SET taked=taked+{$w_exp} WHERE user_id='" . $WINNER_DATA['id'] . "' and kwest_id=1");
mysql_query("UPDATE users SET battle='0', " . ($zay_type == 11 ? "doblest=doblest+5," : "") . ($monstr_win ? "monstr=monstr+1," : "win=win+1,") . " money=money+{$str_money}, exp=exp+{$w_exp}, zver_on=0, zayavka=0, battle_opponent='', battle_pos='', battle_team='', fwd='' WHERE login='******'");
$wintext = "Бой окончен! Вы выиграли бой. Всего вами нанесено: <b>" . $hitted_win . " HP</b>. Получено опыта: <b>" . $w_exp . "</b>" . ($faiz > 1 && $w_exp > 0 ? ' (' . $faiz * 100 . '%)' : '') . ". " . $vip_text . $text;
talk($player, $wintext, $WINNER_DATA);
//---------хп при победе--------------
if ($WINNER_DATA["level"] < 4) {
setHP($WINNER_DATA['login'], $WINNER_DATA["hp_all"], $WINNER_DATA["hp_all"]);
} else {
setHP($WINNER_DATA['login'], $WINNER_DATA["hp"], $WINNER_DATA["hp_all"]);
}
setMN($WINNER_DATA['login'], $WINNER_DATA["mana"], $WINNER_DATA["mana_all"]);
}
mysql_query("UPDATE teams SET over = 1 WHERE battle_id='" . $cr . "' and team={$team}");
if ($count_winners > 20) {
talk("toall", "Бой закончен. Благодаря величайшим воинам " . $winners . "! Победа за <i>" . $all_winners . "</i>", "");
$co_arr = count($win_array);
for ($i = 0; $i < $co_arr; $i++) {
$user = $win_array[$i];
mysql_query("UPDATE users SET money=money+101 WHERE login='******'");
say($user, "Вы нашли <b>101.00 Зл.</b> у убитого бойца.", $user);
}
}
if ($zay_type == 23) {
shuffle($art_array);
$art_winner = $art_array[0];
if ($art_winner && $art_winner != "Исчадие Хаоса") {
mysql_query("INSERT INTO inv (owner,object_type,object_id) VALUES ('" . $art_winner . "','wood',23);");
if ($max_hp_winner && $max_hp_winner != $art_winner) {
mysql_query("INSERT INTO inv (owner,object_type,object_id) VALUES ('" . $max_hp_winner . "','wood',23);");
$str_art_winner = "и <b>{$max_hp_winner}</b> (за максимальный опыт)";
}
say("toall_news", "<font color=#ff0000>Внимание! <b>{$art_winner}</b> {$str_art_winner} нашел чек на АРТ. Обналичит чек на АРТ можна у <b>Торговец Вискаль</b></font>", "bor");
}
}
if ($zay_type == 13) {
mysql_query("TRUNCATE TABLE `castle_config`");
mysql_query("INSERT INTO castle_config SET owner = '" . $winner_clan . "'");
mysql_query("UPDATE clan SET kazna = kazna + 3000,level=level+1 WHERE name_short = '" . $winner_clan . "'");
mysql_query("UPDATE castle_log SET winner = '" . $winner_clan . "' WHERE battle_log = '" . $battle . "'");
say("toall_news", "<font color=#ff0000>Внимание! Битва за Башню завершилась. Победил Ханства <b>" . $winner_clan_name . "</b></font>", "bor");
}
if ($zay_type == 11) {
$phrase = "<span class=date>{$date}</span> ... и победители стали калечить проигравших...<BR>";
battle_log($battle, $phrase);
mysql_query("UPDATE align SET svet=svet+" . ($svet > 0 ? 1 : 0) . ", tma=tma+" . ($tma > 0 ? 1 : 0) . ", neytral=neytral+" . ($neytral > 0 ? 1 : 0));
if ($svet > 0) {
say("toall_news", "<font color=#ff0000>Бой СВЕТ VS TЬМА закончен. <b>Победил Свет</b></font>", "bor");
} else {
if ($tma > 0) {
say("toall_news", "<font color=#ff0000>Бой СВЕТ VS TЬМА закончен. <b>Победила Тьма</b></font>", "bor");
} else {
say("toall_news", "<font color=#ff0000>Бой СВЕТ VS TЬМА закончен. Ничья</font>", "bor");
}
}
}
if ($zay_type == 66) {
$s_ql = mysql_fetch_Array(mysql_query("SELECT * FROM bot_temp WHERE prototype='Рыцарь Смерти' and team={$team}"));
if (!$s_ql[0]) {
mysql_query("INSERT INTO bs_objects (type) VALUES (3);");
mysql_query("INSERT INTO bs_objects (bs_id,coord,type) VALUES (24,'19x11',4);");
mysql_query('UPDATE `deztow_turnir` SET `log` = CONCAT(`log`,\'' . "<span class=date>" . date("d.m.y H:i") . "</span> <b>Рыцарь Смерти</b> повержен и выбывает из турнира<BR>" . '\') WHERE `active` = TRUE');
}
}
if ($zay_type == 77) {
$c_b = mysql_fetch_Array(mysql_query("SELECT * FROM clan_battle WHERE id=" . $B_DAT["clan_id"]));
if ($c_b) {
if ($winner_clan == $c_b["attacker"]) {
$str = "win=win+1";
} else {
$str = "lose=lose+1";
}
mysql_query("UPDATE clan_battle SET " . $str . " WHERE id=" . $B_DAT["clan_id"]);
}
}
}
for ($i = 1; $i < $total_pages + 1; $i++) {
if ($page == $i && !$_GET["p"]) {
echo "<font color=red><b> {$i}</b></font>";
} else {
echo "<a href='?log={$logs}&page={$i}' class='us2'> {$i}</a> ";
}
}
echo " (<a href='?log={$logs}&p=all' " . ($_GET["p"] == "all" ? " style='color:red' " : "") . ">все</a>)</div>";
$btype = $DATA["type"];
$status = $DATA["status"];
$win = $DATA["win"];
$creator = $DATA["creator_id"];
$bid = $DATA["id"];
$span = $win == 1 ? "p1" : "p2";
$seek = mysql_query("SELECT * FROM `team_history` WHERE battle_id='" . $logs . "'");
$counts = mysql_num_Rows($seek);
while ($dat = mysql_fetch_array($seek)) {
if ($dat["team"] == $win) {
$winner .= $comma . "<script>drwfl('" . $dat['login'] . "','" . $dat['id'] . "','" . $dat['level'] . "','" . $dat['dealer'] . "','" . $dat['orden'] . "','" . $dat['admin_level'] . "','" . $dat['clan_short'] . "','" . $dat['clan'] . "');</script>";
$comma = ", ";
}
if ($dat["team"] == 1) {
$statistika1 .= "<tr><td><span class=p1><script>drwfl('" . $dat['login'] . "','" . $dat['id'] . "','" . $dat['level'] . "','" . $dat['dealer'] . "','" . $dat['orden'] . "','" . $dat['admin_level'] . "','" . $dat['clan_short'] . "','" . $dat['clan'] . "');</script></span></td><td>" . $dat["hitted"] . "</td></tr>";
} else {
if ($dat["team"] == 2) {
$statistika2 .= "<tr><td><span class=p2><script>drwfl('" . $dat['login'] . "','" . $dat['id'] . "','" . $dat['level'] . "','" . $dat['dealer'] . "','" . $dat['orden'] . "','" . $dat['admin_level'] . "','" . $dat['clan_short'] . "','" . $dat['clan'] . "');</script></span></td><td>" . $dat["hitted"] . "</td></tr>";
}
}
}
if ($counts >= 50) {
echo "<h3>Легендарный бой</h3>";
$msg = "Кто-то оказался быстрее и перехватил заявку!!!";
}
} else {
$msg = "Похоже противник отозвал свою заявку!";
}
}
}
}
}
}
}
}
/*=====VERDIYIM ZAYAVKANI GERI GOTURMEK==================================*/
if ($_REQUEST['recall']) {
$boy_type = array(1, 2, 100);
$S = mysql_num_Rows(mysql_query("SELECT * FROM teams WHERE player='" . $login . "' and team=1"));
if ($S) {
$DD = mysql_fetch_array(mysql_query("SELECT * FROM zayavka WHERE creator='" . $db['id'] . "'"));
if ($DD["status"] == 1 && in_array($DD["type"], $boy_type)) {
mysql_query("DELETE FROM zayavka WHERE creator='" . $db['id'] . "'");
mysql_query("DELETE FROM teams WHERE battle_id='" . $db['id'] . "'");
mysql_query("UPDATE users SET zayavka='0' WHERE login='******'");
$db['zayavka'] = 0;
}
}
}
/*=========QEBUL ETDIYIM ZAYAVKANI GERI GOTURMEK========================*/
if ($_REQUEST['recallBattle']) {
$boy_type = array(1, 2, 100);
$DD = mysql_fetch_array(mysql_query("SELECT zayavka.status, zayavka.type, bat_id.battle_id FROM zayavka,(SELECT battle_id FROM teams WHERE player='" . $login . "' and team=2) as bat_id WHERE creator=bat_id.battle_id"));
if ($DD["status"] != 3 && in_array($DD["type"], $boy_type)) {
switch ($school) {
case "air":
$school_d = "Воздух";
break;
case "water":
$school_d = "Вода";
break;
case "fire":
$school_d = "Огонь";
break;
case "earth":
$school_d = "Земля";
break;
}
echo "• Стихия: <b>" . $school_d . "</b><BR>";
}
if ($eat_add_sitost) {
echo "<B>Параметры:</B><BR>• Сытость: +{$eat_add_sitost}<BR>";
}
if ($DAT["descs"]) {
echo "<div style=\"width:300;\">";
echo "<small><b>Описание:</b> " . $DAT["descs"] . "</small>";
echo "</div>";
}
echo "</td></tr>";
}
if (!mysql_num_Rows($S)) {
echo "<tr><td bgcolor=#D5D5D5 colspan=2><center>У вас нет подходящей еды в рюкзаке</td></tr>";
}
echo "</TABLE>";
}
<?php
$login = $_SESSION['login'];
$ip = $db["remote_ip"];
if ($_POST['target']) {
$target = htmlspecialchars(addslashes(trim($_POST['target'])));
$q = mysql_query("SELECT * FROM users WHERE login='******'");
$res = mysql_fetch_array($q);
if (!$res) {
echo "Персонаж <B>" . $target . "</B> не найден в базе данных.";
} else {
$query = mysql_query("SELECT * FROM battles WHERE creator_id=" . $res["id"]);
if (mysql_num_Rows($query) > 0) {
while ($result = mysql_fetch_Array($query)) {
$sql1 = mysql_query("SELECT player FROM teams WHERE battle_id='" . $result["creator_id"] . "'");
while ($sql2 = mysql_fetch_Array($sql1)) {
mysql_query("UPDATE users SET zayavka='0', battle='0',battle_opponent='', battle_pos='', battle_team='',zver_on=0 WHERE login = '******'");
}
mysql_query("DELETE FROM teams WHERE battle_id='" . $result["creator_id"] . "'");
mysql_query("DELETE FROM battles WHERE id='" . $result["id"] . "'");
mysql_query("DELETE FROM bot_temp WHERE battle_id='" . $result["id"] . "'");
mysql_query("DELETE FROM battle_units WHERE battle_id='" . $result["id"] . "'");
mysql_query("DELETE FROM `hit_temp` WHERE battle_id='" . $result["id"] . "'");
mysql_query("DELETE FROM `zayavka` WHERE creator='" . $result["creator_id"] . "'");
}
}
echo "OK";
history($login, "Заявка удалена", "", $ip, $login);
}
}
if ($action == "vip") {
if ($_GET["id"]) {
$obraz_id = (int) $_GET["id"];
$sql_ = mysql_query("SELECT * FROM obraz WHERE owner='" . $login . "' and id=" . $obraz_id);
$res_ = mysql_fetch_array($sql_);
if (!$res_) {
echo "<b style='color:red'>Образ не найден...</b>";
} else {
mysql_query("UPDATE users SET obraz='" . $res_["img"] . "' WHERE login='******'");
echo "<b style='color:red'>Образ сохранен!</b>";
}
}
$i = 1;
echo "<table align=center><tr>";
$sql = mysql_query("SELECT * FROM obraz WHERE owner='" . $login . "'");
while ($res = mysql_fetch_array($sql)) {
echo "<td width=145 nowrap align=center><A href=\"?action=vip&id=" . $res["id"] . "\"><img src='img/obraz/" . $res["img"] . "' border=0></a></td>";
if ($i % 6 == 0) {
echo "</tr><tr>";
}
$i++;
}
if (!mysql_num_Rows($sql)) {
echo "<td><b style='color:red'>У вас нету персональных образов!</b></td>";
}
echo "</tr></table>";
}
?>
</body>
</html>
