Jump to content

horo

Members
  • Posts

    3
  • Credits

  • Joined

  • Last visited

    Never
  • Feedback

    0%

Everything posted by horo

  1. Hi to all! I go direct to the subject: I have 2 servers and would like to know as to place the two servers to use the same login server… that is with same acc it could have access to the ones of the worlds. if they to know of one link that it teaches to make this process sends me please. or if they will be able to explain me as it functions I will be very grateful
  2. 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
×
×
  • Create New...