Tipologie server: PvM
*Resursă folosită: HomePage Darkdev
*ServerFiles utilizat: -
*Syserr: -
Poză: -
*Detalii suplimentare: Am nevoie de inc_log pentru a functiona creare_item.php , imi poate da cineva unul? Sau sa-l creeze el, am incercat odata sa-l fac singur dar nu a mers, nu am gasit deloc pe internet pana acum, nici in folder-ul lasat de ei la instalare.
Cod: Selectaţi tot
<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."); }
}
<?php } else { echo error("Zona restrictionata.Drepturi de acces insuficiente.");}?><a href="index.php?page=panou-admin">« Inapoi la panou administrare</a>Cod: Selectaţi tot
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
CREATE TABLE IF NOT EXISTS `ic_log` (
`autor` varchar(33) NOT NULL,
`autorid` varchar(33) NOT NULL,
`id` int(11) NOT NULL,
`owner` varchar(33) NOT NULL,
`owner_id` int(11) NOT NULL,
`pos` int(11) NOT NULL,
`count` int(11) NOT NULL,
`vnum` varchar(22) NOT NULL,
`socket0` varchar(22) NOT NULL,
`socket1` varchar(22) NOT NULL,
`socket2` varchar(22) NOT NULL,
`attrtype0` varchar(22) NOT NULL,
`attrvalue0` varchar(22) NOT NULL,
`attrtype1` varchar(22) NOT NULL,
`attrvalue1` varchar(22) NOT NULL,
`attrtype2` varchar(22) NOT NULL,
`attrvalue2` varchar(22) NOT NULL,
`attrtype3` varchar(22) NOT NULL,
`attrvalue3` varchar(22) NOT NULL,
`attrtype4` varchar(22) NOT NULL,
`attrvalue4` varchar(22) NOT NULL,
`attrtype5` varchar(22) NOT NULL,
`attrvalue5` varchar(22) NOT NULL,
`attrtype6` varchar(22) NOT NULL,
`attrvalue6` varchar(22) NOT NULL,
`ora` datetime NOT NULL,
`data` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
de 
de 
de