<?php
header("Content-Type: text/html; charset=windows-1251");
session_start();
Error_Reporting(E_ALL & ~E_NOTICE);
$url=$_SERVER['REQUEST_URI'];
if(isset($_POST['bax'])){session_destroy(); header("Location: $url");}
$mysql['ip']="localhost";
$mysql['port']="3306";
$mysql['user']="root";
$mysql['password']="root";
$mysql['database']="test";
$link =
@mysql_connect($mysql['ip'].":".$mysql['port'], $mysql['user'], $mysql['password']);
if (!$link){die("Ошибка соединения Mysql!<br>Код Ошибки: <br>".mysql_error());}
$db =
@mysql_select_db($mysql['database'], $link);
if (!$db){die("Ошибка соединения с базой!<br>Код Ошибки: <br>".mysql_error());}
mysql_query("SET NAMES cp1251", $link);
if(!isset($_POST['enter']))
{
print('
<form method="post">
<table border="3" cellpadding="0" cellspacing="0" align="center" >
<tr>
<td>itemId</td>
<td>С lavel</td>
<td>по lavel</td>
<td>type</td>
</tr>
<td><input name="mobId" type="text" value="'.$_SESSION['mobId'].'" size="15" maxlength="15"></td>');
if(!isset($_SESSION['lavel']))$_SESSION['lavel']=0;
print('<td><input name="lavel" type="text" value="'.$_SESSION['lavel'].'" size="15" maxlength="15"></td>
<td><input name="lavelmax" type="text" size="15" value="'.$_SESSION['lavelmax'].'" maxlength="15"></td>');
print('<td><select name="type">
<option value="0">NULL</option>
<option value="L2Pet">L2Pet</option>
<option value="L2Monster">L2Monster</option>
<option value="L2BabyPet">L2BabyPet</option>
<option value="L2Npc">L2Npc</option>
<option value="L2ControlTower">L2ControlTower</option>
<option value="L2EffectPoint">L2EffectPoint</option>
<option value="L2SiegeSummon">L2SiegeSummon</option>
<option value="L2TamedBeast">L2TamedBeast</option>
<option value="L2FestivalMonster">L2FestivalMonster</option>
<option value="L2Chest">L2Chest</option>
<option value="L2PenaltyMonster">L2PenaltyMonster</option>
<option value="L2Minion">L2Minion</option>
<option value="L2FeedableBeast">L2FeedableBeast</option>
<option value="L2RiftInvader">L2RiftInvader</option>
<option value="L2GrandBoss">L2GrandBoss</option>
<option value="L2RaidBoss">L2RaidBoss</option>
<option value="L2Teleporter">L2Teleporter</option>
<option value="L2Warehouse">L2Warehouse</option>
<option value="L2VillageMaster">L2VillageMaster</option>
<option value="L2Trainer">L2Trainer</option>
<option value="L2Guard">L2Guard</option>
<option value="L2Warehouse">L2Warehouse</option>
<option value="L2Merchant">L2Merchant</option>
<option value="L2Trainer">L2Trainer</option>
<option value="L2SymbolMaker">L2SymbolMaker</option>
<option value="L2SignsPriest">L2SignsPriest</option>
<option value="L2CabaleBuffer">L2CabaleBuffer</option>
<option value="L2FestivalGuide">L2FestivalGuide</option>
<option value="L2ClassMaster">L2ClassMaster</option>
<option value="L2NpcWalker">L2NpcWalker</option>
<option value="L2Fisherman">L2Fisherman</option>
<option value="L2Adventurer">L2Adventurer</option>
<option value="L2OlympiadManager">L2OlympiadManager</option>
<option value="L2FriendlyMob">L2FriendlyMob</option>
<option value="L2Artefact">L2Artefact</option>
<option value="L2CastleBlacksmith">L2CastleBlacksmith</option>
<option value="0">L2CastleWarehouse</option>
<option value="0">L2CastleChamberlain</option>
<option value="L2Doormen">L2Doormen</option>
<option value="L2CastleTeleporter">L2CastleTeleporter</option>
<option value="0">L2WyvernManager</option>
<option value="L2MercManager">L2MercManager</option>
<option value="L2SiegeNpc">L2SiegeNpc</option>
<option value="L2ClanHallManager">L2ClanHallManager</option>
<option value="L2TvTEventNpc">L2TvTEventNpc</option>
<option value="L2WeddingManager">L2WeddingManager</option>
</select></td>');
print('</table>');
print('<table border="3" cellpadding="0" cellspacing="0" align="center" >
<tr>
<td>itemId</td>
<td>Min</td>
<td>Max</td>
<td>%</td>
</tr>
<tr>
<td><input name="itemId" type="text" value="'.$_SESSION['itemId'].'" size="15" maxlength="15"></td>
<td><input name="min" type="text" value="'.$_SESSION['min'].'" size="15" maxlength="15"></td>
<td><input name="max" type="text" value="'.$_SESSION['max'].'" size="15" maxlength="15"></td>
<td><input name="drop" type="text" value="'.$_SESSION['drop'].'" size="15" maxlength="15"></td>
</tr>
</table>
<table border="3" cellpadding="0" cellspacing="0" align="center" >
<tr align="center">
<td><input name="enter" type="submit" value="Сделать"></td>
<td><input name="bax" type="submit" value="Сброс"></td>
</tr>
</table>
</form>
');
}else{
if(empty($_POST['mobId'])){
if(isset($_POST['lavel']) && !empty($_POST['lavel']) || isset($_POST['type']) && !empty($_POST['type']))
{
$level=$_POST['lavel'];
$levelmax=$_POST['lavelmax'];
$type=$_POST['type'];
$S_0="SELECT id FROM npc WHERE ";
if(!empty($_POST['lavel']) && !empty($_POST['lavelmax'])){$S_1="LEVEL >='$level' AND LEVEL<='$levelmax'";}
if(empty($_POST['lavelmax']) && !empty($_POST['lavel'])){$S_1="LEVEL >='$level'";}
if(!empty($_POST['lavel']) && !empty($_POST['lavelmax']) && !empty($_POST['type']) || $_POST['lavelmax']=="0" && !empty($_POST['type'])){$S_and=" AND ";}
if(!empty($_POST['type'])){$S_2=" type='$type'";}
}else{print("Вы не ввели mobId ,или не выбрали дополнительные параметры!<br>"); $_SESSION['ment']=false;}
$mobId=$_POST['mobId'];
}else{$mobId=$_POST['mobId'];}
if(!empty($_POST['itemId'])){$itemId=$_POST['itemId'];}else{print("Вы не ввели itemId!<br>"); $_SESSION['ment']=false;}
if(!empty($_POST['min'])){$min=$_POST['min'];}else {print("Вы не ввели Min!<br>"); $_SESSION['ment']=false;}
if(!empty($_POST['max'])){$max=$_POST['max'];}else {print("Вы не ввели Max!<br>"); $_SESSION['ment']=false;}
if(!empty($_POST['drop'])){$drop=$_POST['drop'];}else {print("Вы не ввели drop!<br>"); $_SESSION['ment']=false;}
if($_SESSION['ment']==true || !isset($_SESSION['ment'])){
print('<br><a href="'.$url.'" align="center">Назад</a><br>');
if(!empty($_POST['mobId']))
{
$resulr_mobid=$mobId;
$category=0;
$result_2=mysql_query("SELECT category FROM droplist WHERE mobId='$resulr_mobid' ORDER BY droplist.category DESC", $link);
if(!$result_2){
print("Не могу сделать запрос! <br> Код Ошибки: <br>".mysql_error());
}else{
if(mysql_num_rows($result_2) > 0) {$result2 = mysql_fetch_array($result_2); $category=$result2['category']; $category++;}
$SQL = "INSERT INTO `droplist` VALUES ('$resulr_mobid', '$itemId', '$min', '$max', '$category', '$drop')";
$result = mysql_query($SQL, $link);
if(!$result){printf("не смог сделать запрос %s <br>Код Ошибки: <br>%s",$SQL,mysql_error());
}else{
printf("Запрос %s Сделать успешно!<br>",$SQL);
}
}
}else{
$result_sql=$S_0.$S_1.$S_and.$S_2;
$result_npc=mysql_query("$result_sql",$link);
printf("Ваш запрос: %s <br>Запросы :<br>",$result_sql);
while($resultnpc=mysql_fetch_array($result_npc))
{
$category=0;
$id_mob=$resultnpc['id'];
$result_5=mysql_query("SELECT category FROM droplist WHERE mobId='$id_mob' ORDER BY droplist.category DESC", $link);
if(!$result_5){print("Не могу сделать запрос! <br> Код Ошибки: <br>".mysql_error());}else{
if(mysql_num_rows($result_5) > 0) {$result5 = mysql_fetch_array($result_5); $category=$result5['category']; $category++;}
$SQL = "INSERT INTO `droplist` VALUES ('$id_mob', '$itemId', '$min', '$max', '$category', '$drop')";
$result = mysql_query($SQL, $link);
if(!$result){printf("не смог сделать запрос %s <br>Код Ошибки: <br>%s",$SQL,mysql_error());}else{print($SQL.";<br>");}
}
}
print("Успешно сделано!<br>");
}
}
$_SESSION['lavel']=$_POST['lavel'];
$_SESSION['lavelmax']=$_POST['lavelmax'];
$_SESSION['mobId']=$mobId;
$_SESSION['itemId']=$itemId;
$_SESSION['min']=$min;
$_SESSION['max']=$max;
$_SESSION['drop']=$drop;
$_SESSION['ment']=true;
print('<br><a href="'.$url.'" align="center">Назад</a><br>');
}
print("<center>Project by ~ArchAngel~</center>");
?>
