Vreau sa-l foloseasca totii playeri este script darkdev
Multumesc aniticipat
Cod: Selectaţi tot
<?PHP
include("inc/drepturi.php");
if(isset($_SESSION['user']) && isset($_SESSION['pass']) && $_SESSION['admin'] >=$drepturi['create_item'])
{
include 'inc/daten.inc.php';
?>
<h4>CREAZA ITEM</h4>
<?PHP
if(isset($_POST['submit']) && $_POST['submit']=="Creaza") {
if(is_numeric($_POST['aid'])) {
$sqlCmd = "SELECT COUNT(*) AS checkIn FROM account.account WHERE id='".$_POST['aid']."' LIMIT 1";
$cmd = mysql_query($sqlCmd) or die(mysql_error());
$getCount = mysql_fetch_object($cmd) ;
if($getCount->checkIn==1) {
if(!empty($_POST['window']) && is_numeric($_POST['position']) && !empty($_POST['itemtyp']) && is_numeric($_POST['stufe']) && is_numeric($_POST['stapelmenge'])) {
if(!empty($_POST['vnum']) && is_numeric($_POST['vnum'])) {
$avnum=$_POST['vnum'];
}
else {
if($_POST['itemtyp']>=11971 && $_POST['itemtyp']<=11974) {
$_POST['stufe']=0;
}
$avnum=$_POST['itemtyp']+$_POST['stufe'];
}
$luamid=mysql_query("select * from player.item where id=(SELECT MAX(id) FROM player.item)");
$idul = mysql_fetch_array($luamid);
$var_id=$idul['id']+1;
$ids = $_SESSION['user'];
$tsd = mysql_fetch_row(mysql_query("SELECT id,login from account.account where login='$ids'")) or die(mysql_error());
$sqlCmd="INSERT INTO player.item
(owner_id,window,pos,count,vnum,socket0,socket1,socket2,attrtype0,attrvalue0,attrtype1,attrvalue1,attrtype2,attrvalue2,attrtype3,attrvalue3,attrtype4,attrvalue4,attrtype5,attrvalue5,attrtype6,attrvalue6)
VALUES
('".$_POST['aid']."','".$_POST['window']."','".$_POST['position']."','".$_POST['stapelmenge']."','".$avnum."','".$_POST['socket0']."','".$_POST['socket1']."','".$_POST['socket2']."','".$_POST['boni0']."','".$_POST['boniv0']."','".$_POST['boni1']."','".$_POST['boniv1']."','".$_POST['boni2']."','".$_POST['boniv2']."','".$_POST['boni3']."','".$_POST['boniv3']."','".$_POST['boni4']."','".$_POST['boniv4']."','".$_POST['boni5']."','".$_POST['boniv5']."','".$_POST['boni6']."','".$_POST['boniv6']."')";
$sqlQry = mysql_query($sqlCmd) or die(mysql_error());
$ora = date("H:i");
$data = date("d.M.Y");
$sqlCmdLog="INSERT INTO web.ic_log
(autor,autorid,id,owner_id,window,pos,count,vnum,socket0,socket1,socket2,attrtype0,attrvalue0,attrtype1,attrvalue1,attrtype2,attrvalue2,attrtype3,attrvalue3,attrtype4,attrvalue4,attrtype5,attrvalue5,attrtype6,attrvalue6,ora,data)
VALUES
('$tsd[1]','$tsd[0]','$var_id','".$_POST['aid']."','".$_POST['window']."','".$_POST['position']."','".$_POST['stapelmenge']."','".$avnum."','".$_POST['socket0']."','".$_POST['socket1']."','".$_POST['socket2']."','".$_POST['boni0']."','".$_POST['boniv0']."','".$_POST['boni1']."','".$_POST['boniv1']."','".$_POST['boni2']."','".$_POST['boniv2']."','".$_POST['boni3']."','".$_POST['boniv3']."','".$_POST['boni4']."','".$_POST['boniv4']."','".$_POST['boni5']."','".$_POST['boniv5']."','".$_POST['boni6']."','".$_POST['boniv6']."','$ora','$data')"; // check !
$sqlQryLog = mysql_query($sqlCmdLog) or die('test');
if($sqlQry) {
echo succes("Itemul cu id ".$var_id." a fost creat cu succes!");
}
}
else { echo error("Itemul nu a putut fi creat pentru ca datele dvs sunt incorecte."); }
}
else { echo error("AccountID-ul este gresit"); }
}
else { echo error("Introduceti un accountID valid."); }
}
?>
<form action="" method="POST">
<table>
<tr>
<th class="topLine">AccountID:</th>
<td class="tdunkel"><input type="text" name="aid" size="11" value="<?PHP echo $_GET['acc']; ?>" maxlength="11" class="iRg_input"/></td>
</tr>
<tr>
<th class="topLine">Loc:</th>
<td class="thell">
<select name="window" class="iRg_input">
<option value="SAFEBOX">Depozit</option>
<option value="MALL">Depozit ItemShop</option>
<!-- <option value="INVENTORY">Inventar</option> -->
</select>
</td>
</tr>
<tr>
<th class="topLine">Pozitie (Max. 44)</th>
<td class="tdunkel"><input name="position" type="text" size="20" value="0" maxlength="20" class="iRg_input"/></td>
</tr>
<tr>
<th class="topLine">Item:</th>
<td class="thell">
<input type="text" name="itemtyp" size="11" value="" maxlength="11" class="iRg_input"/>
<select name="stufe" class="iRg_input">
<?PHP
for($i=0;$i<10;$i++) {
echo "<option value=\"$i\">+$i</option>";
}
?>
</select>
</td>
</tr>
<tr>
<th class="topLine">Numar de iteme:</th>
<td class="tdunkel"><input type="text" name="stapelmenge" size="20" maxlength="20" value="1" class="iRg_input"/></td>
</tr>
<tr>
<th class="topLine">Stone #1:</th>
<td class="thell">
<select name="socket0" class="iRg_input">
<?PHP
foreach($itemSteine AS $aKey => $aValue) {
echo'<option value="'.$aKey.'">'.$aValue.'</option>';
}
?>
</select>
</td>
</tr>
<tr>
<th class="topLine">Stone #2:</th>
<td class="tdunkel">
<select name="socket1" class="iRg_input">
<?PHP
foreach($itemSteine AS $aKey => $aValue) {
echo'<option value="'.$aKey.'">'.$aValue.'</option>';
}
?>
</select>
</td>
</tr>
<tr>
<th class="topLine">Stone #3:</th>
<td class="thell">
<select name="socket2" class="iRg_input">
<?PHP
foreach($itemSteine AS $aKey => $aValue) {
echo'<option value="'.$aKey.'">'.$aValue.'</option>';
}
?>
</select>
</td>
</tr>
<tr>
<th class="topLine">Bonus #1:</th>
<td class="tdunkel">
<select name="boni0" class="iRg_input">
<?PHP
foreach($itemBoni AS $aKey => $aValue) {
echo'<option value="'.$aKey.'">'.$aValue.'</option>';
}
?>
</select>
<input type="text" name="boniv0" size="6" maxlength="6" class="iRg_input"/>
</td>
</tr>
<tr>
<th class="topLine">Bonus #2:</th>
<td class="thell">
<select name="boni1" class="iRg_input">
<?PHP
foreach($itemBoni AS $aKey => $aValue) {
echo'<option value="'.$aKey.'">'.$aValue.'</option>';
}
?>
</select>
<input type="text" name="boniv1" size="6" maxlength="6" class="iRg_input"/>
</td>
</tr>
<tr>
<th class="topLine">Bonus #3:</th>
<td class="tdunkel">
<select name="boni2" class="iRg_input">
<?PHP
foreach($itemBoni AS $aKey => $aValue) {
echo'<option value="'.$aKey.'">'.$aValue.'</option>';
}
?>
</select>
<input type="text" name="boniv2" size="6" maxlength="6" class="iRg_input"/>
</td>
</tr>
<tr>
<th class="topLine">Bonus #4:</th>
<td class="thell">
<select name="boni3" class="iRg_input">
<?PHP
foreach($itemBoni AS $aKey => $aValue) {
echo'<option value="'.$aKey.'">'.$aValue.'</option>';
}
?>
</select>
<input type="text" name="boniv3" size="6" maxlength="6" class="iRg_input"/>
</td>
</tr>
<tr>
<th class="topLine">Bonus #5:</th>
<td class="tdunkel">
<select name="boni4" class="iRg_input">
<?PHP
foreach($itemBoni AS $aKey => $aValue) {
echo'<option value="'.$aKey.'">'.$aValue.'</option>';
}
?>
</select>
<input type="text" name="boniv4" size="6" maxlength="6" class="iRg_input"/>
</td>
</tr>
<tr>
<th class="topLine">Bonus #6:</th>
<td class="thell">
<select name="boni5" class="iRg_input">
<?PHP
foreach($itemBoni AS $aKey => $aValue) {
echo'<option value="'.$aKey.'">'.$aValue.'</option>';
}
?>
</select>
<input type="text" name="boniv5" size="6" maxlength="6" class="iRg_input"/>
</td>
</tr>
<tr>
<th class="topLine">Bonus #7:</th>
<td class="tdunkel">
<select name="boni6" class="iRg_input">
<?PHP
foreach($itemBoni AS $aKey => $aValue) {
echo'<option value="'.$aKey.'">'.$aValue.'</option>';
}
?>
</select>
<input type="text" name="boniv6" size="6" maxlength="6" class="iRg_input"/>
</td>
</tr>
<tr>
<th class="topLine" colspan="2" style="text-align:center;">
<br /><input type="submit" value="Creaza" name="submit" class="buton"/> • <input type="reset" value="Reset" class="buton"/></th>
</tr>
</table>
</form>
<?php } else { echo error("Zona restrictionata.Drepturi de acces insuficiente.");}?><a href="index.php?page=panou-admin">« Inapoi la panou administrare</a>
de 
de 
de 
de