[request]Script for insert item

waldemarnt · November 18, 2011

I need a system,query or script for insert item in the inventory of a player.

Interlude (c6)

BnB · December 12, 2011

<?php 
include "valida_session.php";
include "../useron.php";
?>
<title>add item </title>
<script language="javascript">
function checa_formulario(donate)
{
if (donate.idchar.value == "")
{ 
alert("Por Favor não deixe o campo ID char em branco!!!");
donate.idchar.focus();
return (false); 
}
if (donate.nqtd.value == "")
{ 
alert("Por Favor não deixe campo QTD em branco!!!");
donate.nqtd.focus();
return (false); 
}
}

</script>
<style type="text/css">
<!--
.style7 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10pt; }
.style9 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10pt; font-weight: bold; }
.style10 {
color: #FF6600;
font-weight: bold;
}
body {
background-image: url(imgs/box_bg.jpg);
}
-->
</style>
<body>
<form action="donate.php"  method="post" name="donate" onSubmit="return checa_formulario(this)">
  <p align="center"><img src="imgs/topo.jpg" width="703" height="98"></p>
  <table width="30%" border="0" align="center" cellpadding="0" cellspacing="3">
    <tr>
      <td colspan="2"><div align="center"><span class="style9">Inserir Item</span></div></td>
    </tr>
    <tr>
      <td colspan="2"><hr /></td>
    </tr>
    <tr>
      <td width="24%"><span class="style7">Id Char </span></td>
      <td width="76%"><input name="idchar" type="text" id="idchar" /></td>
    </tr>
    <tr>
      <td><span class="style7">Qtd </span></td>
      <td><input name="nqtd" type="text" id="nqtd" /></td>
    </tr>
    <tr>
      <td colspan="2"><hr /></td>
    </tr>
    <tr>
      <td><span class="style7">Local: </span></td>
      <td class="style7"><span class="style10">WareHouse</span></td>
    </tr>
    <tr>
      <td colspan="2"><hr /></td>
    </tr>
    <tr>
      <td colspan="2"><div align="center" class="style7">
        <input type="submit" name="Submit" value="Inserir Tickets" />
        <input name="item_id" type="hidden" id="item_id" value="9325" />
        <a href="logout.php">Logout</a></div></td>
    </tr>
  </table>
  
</form>
<br>
<br>
<center><b><font face=verdana color=red size=3>

</body>

</html>

Note

1° replace the item id of line 68 you want to insert the item

<input name="item_id" type="hidden" id="item_id" value="9325" />

.php

<meta http-equiv="refresh" content="3;URL=index.php">
<body background=imgs/box_bg.jpg></body><center>
<img src=imgs/topo.jpg width=703 height=98><br><br></center><br><br>
<? 
include "valida_session.php";
$ip="ip"; 
$user="sa";
$pass="pass";
$db="lin2world";

$conn=mssql_connect($ip,$user,$pass); 
mssql_select_db($db, $conn); 

$idchar = $_POST["idchar"];
$nqtd = $_POST["nqtd"];
$item_id = $_POST['item_id'];

$result = mssql_query("SELECT a-beep-t,item_id FROM user_item WHERE char_id = $idchar AND item_type = $item_id AND warehouse = 1");

$rows = mssql_num_rows($result);
$dba-beep-t = mssql_result($result, 0, 0);
$dbitemid = mssql_result($result, 0, 1);

$nqtd = $nqtd $dba-beep-t;

if ($dba-beep-t > 0) {
  mssql_query("UPDATE user_item SET a-beep-t = $nqtd WHERE item_id = $dbitemid");
  echo "<center><font face=verdana size=2 color=green>Tickets Entregues com sucesso!</font></center>";
}
else {
  mssql_query("INSERT INTO user_item (char_id, item_type, a-beep-t, enchant, eroded, bless, ident, wished, warehouse) values ($idchar,$item_id,$nqtd,0,0,0,0,0,1)"); 
  echo "<center><font face=verdana size=2 color=green>Tickets Entregues com sucesso!</font></center>";
}

$conn=mssql_close(); 

?>

config.php

Ps. if only to protect the page you log

otherwise disregard the codes below

<?php
$conexao=mysql_connect("localhost","root","pass");
mysql_select_db("yourdb"); 

?>

valida session

<?php
include "config.php";
/*session_start();

if (empty($_SESSION["login"]) || empty($_SESSION["senha"])) {
header("Location:form_login.php");
}*/
session_start();
if (isset ($_SESSION["login_usuario"]) AND isset($_SESSION["senha_usuario"])) {
$login_usuario = $_SESSION["login_usuario"];
$senha_usuario = $_SESSION["senha_usuario"];
}
else{
echo '<center><font face=verdana size=2 color=#999999><BR><BR><BR><BR>Voce nao efetuou o login.<BR>';
echo '<font face=verdana size=2 color=#999999>Caso você ja seja cadastrado <a href=form_login.php>clique aqui</a> para entrar. <br><br><br><img src="images/bgadminsite.gif" />';
exit(); 
} 

if(!(empty($login_usuario) OR empty($senha_usuario))){
$resultado = mysql_query("select * from tbluser where login = '$_SESSION[login_usuario]'");
if (mysql_num_rows ($resultado) == 1) {
	if ($senha_usuario !=mysql_result($resultado, 0, "senha")){
		unset ($_SESSION["nome_usuario"]);
		unset ($_SESSION["senha_usuario"]);
		echo '<font face=verdana size=2 color=#999999>você não efetuou o login.<br><br><br><img src="images/bgadminsite.gif" />';
		exit();
	}
}
else{
	echo '<font face=verdana size=2 color=#999999>voce nao efetuou o login.<br><br><br><img src="images/bgadminsite.gif" />';
	exit();
}
}
mysql_close($conexao);
?>

login.php

<body background=imgs/box_bg.jpg></body><center>
<img src=imgs/topo.jpg width=703 height=98><br><br></center><br><br>
<?php 
include "config.php";
$login = $_POST["login"];
$senha = $_POST["senha"];
$senha=md5($senha);
$resultado = mysql_query("select * from tbluser where login = '$login'");
$linhas = mysql_num_rows($resultado);
if ($linhas ==0)
{
echo "Usuário não encontrado ";
echo "<a href=form_login.php>Logar</a>";
} else {
if ($senha != mysql_result ($resultado, 0, "senha")) 
{
	echo "Usuário não encontrado ";
	echo "<a href=form_login.php>Logar</a>";
}else{ 
session_start(); 
$_SESSION["login_usuario"] = $login;
$_SESSION["senha_usuario"] = $senha;


header("Location: index.php");
}
}
mysql_close($conexao);
?>

item added after restart

Hazel · December 12, 2011

...

BnB · December 13, 2011

Do you know what l2off in name category mean ? :P

If you asked me, yes I know, if you're so smart should have seen the script before you speak.

ps. mysql only to validate session

Anarchy · December 17, 2011

you know that script will only work if the character is offline and hasn't logged in since the last server restart right?

waldemarnt · December 17, 2011

tested and it worked a little he'll get thanks!

BnB · December 27, 2011

...

:P

you know that script will only work if the character is offline and hasn't logged in since the last server restart right?

Note!

Thank u for remember

[request]Script for insert item

Question

waldemarnt

6 answers to this question

Recommended Posts

BnB

Hazel

BnB

Anarchy

waldemarnt

BnB

Create an account or sign in to comment

Create an account

Sign in

Posts

Topics

Browse

Activity

Store

Important Information