question EXE lin...

horo · January 29, 2007

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

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

question EXE lin...

Question

horo

0 answers to this question

Recommended Posts

Create an account or sign in to comment

Create an account

Sign in

Posts

Topics

Browse

Activity

Store

Important Information