物品发送脚本

admin

<?php
function Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB

4 w- j0 Z+ ]' F) O/ p9 i$ \' iFailed.');
}
Connect();

) A* p, |: {: @# G3 n1 @! }" tfunction InitForm(){
, J6 Y, ?* t1 y//layout for the form
" K: B, ~! b; H' [  Secho "<strong>Send Items.</strong>
<form name='select' method='post'>
<lable>Character Name</lable><br/>
<input type='text' name='char'/><br/>
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
<input type='text' name='item_name'/><br/>
+ U2 a# H; m; ^4 ]/ |9 O<lable>Item Amount</lable><br/>
* g" C/ h+ Z" I; f2 p$ e<input type='text' name='item_amount'/><br/>
<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

</lable><br/>
<input type='text' name='item_element'/><br/>
1 K7 R5 W8 f( U' [) n* e8 X<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
& b1 ^) x$ H5 T* A<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
+ g" N2 @* }  t5 i' H<input type='submit'/>
</form>";
4 F% R6 h3 h$ c1 Q- Q6 s3 M}

; Q7 }5 l, r# A8 ]function PostListener (){
//Add more post variables if needed and add them to initform() function aswell
( G- [- Y+ O) j! O6 U. |
################################
+ O: }2 ^3 j  n2 T##### Connection and Post ######
; ~& ~- P0 H: @' J) e$ I################################
$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
! w! \2 Q: t" L5 x  `+ H( ]; L: N$ItemElement = @$_POST['item_element'];
. S6 u/ ~/ \6 w  a* e: s! F8 R& s$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
$ I( Q9 @" n' J. t4 l################################

//Check both variables for empty value
. J+ _& p1 Q$ K
2 R$ l3 A/ P9 `; u. ]! yif (!empty($_POST['char'])){
$ `# C) W* r6 b/ P$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

6 D5 H5 z" m% K8 D( M9 jm_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
% b& i; F  |, _echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
, F' g9 ?7 E9 n7 E& w3 e
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

* b+ r5 W: N! B7 V# W* Q[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
/ j0 N/ N, D- d( ?8 p
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
& g% s8 e! g3 C& y. r1 i; e( y+ p
'{$ElementUpgrade}', '{$ItemPierce}');");
}
) I" c  H& b1 `2 G
/ X, N6 x, D" G2 w& x* \}

, J% N9 w( X; S" `}
  U% J0 A! T4 j+ S, P
6 x7 N4 h1 h- F$ P$ W' K: E$InitForm = InitForm();
! s* M0 F' N9 C5 H5 r' e/ ^$Listener = PostListener();

* v7 B" E6 {8 A: H8 E5 G& j8 {$ P1 H?>



' l: [, M8 X  i2 }
+ L6 h# ]1 r0 e& a1 D& n