Hi to all! I found an article here in the explained forum as add adena in char. I tried to make with another one procedure that I found. more it is generating an error…. could speak to me where is the error? I go to post scripts to facilitate.
precedure: lin_BetaAddItem
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
/****** Object: Stored Procedure dbo.lin_BetaAddItem Script Date: 2003-09-20 ?? 11:51:56 ******/
ALTER PROCEDURE [dbo].[lin_BetaAddItem]
(
@char_id int,
@Item_type int,
@amount int
)
AS
SET NOCOUNT ON
DECLARE @tempRowCount INT
DECLARE @bIsStackable TINYINT
SELECT @bIsStackable = IsStackable FROM ITEMNAME WHERE id = @Item_type
If @bIsStackable Is NULL
Begin
RAISERROR ('Not exist Item Type', 16, 1)
End
Else
Begin
If @bIsStackable = 1
Begin
Update user_item set amount = amount + @amount where item_type = @Item_type and char_id = @char_id
Set @tempRowCount = @@ROWCOUNT
If @tempRowCount = 0
INSERT INTO user_item (char_id, item_type, amount, enchant, eroded, bless, ident, wished, warehouse) VALUES (@char_id, @Item_type, @amount, 0,0,0,0,0,0)
End
Else If @amount = 1
Begin
INSERT INTO user_item (char_id, item_type, amount, enchant, eroded, bless, ident, wished, warehouse) VALUES (@char_id, @Item_type, @amount, 0,0,0,0,0,0)
Set @tempRowCount = @@ROWCOUNT
End
Else
Begin
RAISERROR ('Amount is invalid', 16, 1)
End
End
If @tempRowCount Is NOT NULL
Select @tempRowCount
==================
script PHP
<?
session_start();
$mssql_host = '127.0.0.1';
$mssql_user = 'sa';
$mssql_pass = '';
$store_cashier = array('local'=>"127.0.0.1", 'pc2'=>"192.168.0.1");
$store = "";
foreach ($store_cashier as $key=>$value) {
$rip = $_SERVER['REMOTE_ADDR'];
if ($rip == $value) { $store = $key; }
}
if ($store != "") {
$_SESSION['store'] = $store;
} else {
die("You are not permitted to view this page, actually who gave you this url?");
}
function antiinjection($str) {
$banwords = array ("'", ",", ";", "--");
if ( eregi ( "[a-zA-Z0-9]+", $str ) ) {
$str = str_replace ( $banwords, '', strtolower ( $str ) );
} else {
$str = NULL;
}
return $str;
}
?>
<html>
<head>
<title>Lineage II Adena Managment</title>
<style>
.style1 {
font-family:Verdana, Arial, Helvetica, sans-serif;
font-size:14px;
}
.formPaneGeneral {
font: normal 12pt/10px Verdana, sans-serif;
background:#F2FDFF;
border: 1px groove #6600FF;
vertical-align: middle;
}
.formButtonGeneral {
font: 9pt/10pt Verdana, sans-serif;
color:#333333;
background:#F2FDFF;
border: 1px solid #666666;
}
.border {
border: 1px groove #000000;
}
</style>
</head>
<body topmargin="150" leftmargin="0" rightmargin="0" bottommargin="0" bgcolor="#CCCCCC">
<div align="center">
<table cellpadding="0" cellspacing="0" border="1" bgcolor="#FFCC33">
<tr>
<td align="center" bgcolor="#000000">
<font face="Geneva, Arial, Helvetica, sans-serif" size="+1" color="#FFFFFF">ADENA MANAGMENT</font>
</td>
</tr>
<tr>
<td>
<form name="addadena" method="post" action="addadena.php">
<table cellpadding="0" cellspacing="0" border="0">
<tr>
<td align="center" colspan="2" bgcolor="#FFCC99" class="border">
<?
$error = 0;
$noname = FALSE;
$noamount = FALSE;
if ($_POST['action']) {
if ($_POST['charname']) { $character_name = antiinjection($_POST['charname']); }
else { echo "<font face=\"Times New Roman, Times, serif\" color=\"#FF0000\">- Please insert a character name</font>
"; $error=1; $noname = TRUE; }
if ($_POST['item_type']) { $item_type = antiinjection($_POST['item_type']); }
else { echo "<font face=\"Times New Roman, Times, serif\" color=\"#FF0000\">- Please insert a item id</font>
"; $error=1; $noitem = TRUE; }
if ($_POST['amount']) { $amount = antiinjection($_POST['amount']); }
else { echo "<font face=\"Times New Roman, Times, serif\" color=\"#FF0000\">- Please insert adena amount</font>
"; $error=2; $noamount = TRUE; }
}
if (($error == 0) && $_POST['action']) {
$connection = mssql_connect($mssql_host,$mssql_user,$mssql_pass);
if ($connection) {
mssql_select_db('lin2world',$connection);
$query = mssql_query("EXEC lin_BetaAddItem '$character_name', $item_type, $amount");
$arr = mssql_fetch_array($query);
$last_msg = mssql_get_last_message();
if (empty($last_msg) && empty($arr['amount'])) {
echo "<font face=\"Times New Roman, Times, serif\" color=\"#FF0000\">Account does not exists</font>";
mssql_close($connection);
} else if(empty($arr['amount'])) {
echo "<font face=\"Times New Roman, Times, serif\" color=\"#FF0000\">-$last_msg</font>";
mssql_close($connection);
} else {
echo "<font face=\"Times New Roman, Times, serif\" color=\"#0000FF\">{$amount} adena added to $character_name
Total: {$arr['amount']} adena</font>"; }
mssql_close($connection);
} else {
echo "Can't connect to the database"; }
}
?>
</td>
</tr>
<tr>
<td align="right" height="30">
<span class="style1"> <? echo ($noname?"<font color=\"#FF0000\">Character Name</font>" : "Character Name"); ?></span>
</td>
<td align="left" width="150">
<input type="text" name="charname" size="15" maxlength="15" class="formPaneGeneral" value=<? echo ($_POST['charname'] ? $_POST['charname'] : "" ); ?> >
</td>
</tr>
<tr>
<td height="5">
</td>
</tr>
<tr>
<td align="right" height="30">
<span class="style1"> <? echo ($noitem?"<font color=\"#FF0000\">Id Item</font>" : "Item Type"); ?></span>
</td>
<td align="left" width="150">
<input type="text" name="item_type" size="15" maxlength="15" class="formPaneGeneral" value=<? echo ($_POST['item_type'] ? $_POST['item_type'] : "" ); ?> >
</td>
</tr>
<tr>
<td height="5">
</td>
</tr>
<tr>
<td align="right">
<span class="style1"><? echo ($noamount?"<font color=\"#FF0000\">Adena amount</font>" : "Adena amount"); ?></span>
</td>
<td align="left">
<input type="text" name="amount" size="15" maxlength="15" class="formPaneGeneral" value=<? echo ($_POST['amount'] ? $_POST['amount'] : "" ); ?>>
</td>
</tr>
<tr>
<td>
</td>
<td align="left" height="30">
<input type="submit" name="submit" value="Add Item" class="formButtonGeneral">
<input type="hidden" name="action" value="action">
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="15" bgcolor="#000000">
</td>
</tr>
</table>
</form>
</div>
</body>
</html>
thanks a lot to all