物品发送脚本

admin

<?php
function Connect () {
9 X& x1 U+ z" t. G; |9 l/ Bmssql_connect('Server','UserName','Password') or die('Error: Connection to DB

4 O! v, N& `% h4 t8 OFailed.');
2 _( v& Q4 n3 y! L1 j. B( S, u}
Connect();

. R9 E5 D( }3 {; {function InitForm(){
) t0 z- S3 A1 D7 `3 m  C" f; `//layout for the form
* B* E9 Z- @! |+ S0 s1 O, Zecho "<strong>Send Items.</strong>
' _( u" s! f( Y9 n: n<form name='select' method='post'>
<lable>Character Name</lable><br/>
* u% ~* M# d/ H! x9 s<input type='text' name='char'/><br/>
+ N- h$ q: S* ]<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
6 W* O* C  S/ N' I9 p( d3 o  t7 I<input type='text' name='item_name'/><br/>
! O- [! K3 P8 s6 b, s+ e' p) B7 Y<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
<lable>Item Upgrade Amount</lable><br/>
0 [6 f" R( R' U' m0 X! E0 e( A# I<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
2 R6 x! w; I: l& u
</lable><br/>
6 R# k  }+ _* W<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
</form>";
}

function PostListener (){
//Add more post variables if needed and add them to initform() function aswell

################################
##### Connection and Post ######
################################
$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
# I2 j- P  I9 L5 h8 i$ Q$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
) r% v& B) k! H) }$ItemElement = @$_POST['item_element'];
' d. E4 B! |7 G7 ?: {$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
################################

4 }4 v6 S/ K2 }" o( T; }//Check both variables for empty value

. h. J4 q0 C% G5 p  bif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
$ U1 B# e- i% K* Y; Z7 \- r( \' g# J" l
m_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
0 f1 h% T& t3 g$ W4 ~/ y$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
; N( y3 E$ x, D- K3 W1 @+ y1 B4 p
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

3 i) \+ b4 ?3 t9 O4 s[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
0 C7 [4 Y) |0 y9 T# d
, \. ^& T1 T2 @N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
# d8 c- A5 l- Y3 Z4 v  m
/ s' v9 M* K( R9 M7 j5 {'{$ElementUpgrade}', '{$ItemPierce}');");
}
- l" U9 i0 f" H; K
! l% g9 Y+ t4 ]) w: z: E6 Y}

}
* J8 m  g+ j" w
$InitForm = InitForm();
$Listener = PostListener();

! \" x5 t, m' O" D4 J: @  P% I?>

. b) {7 M" {9 t, b: u! E  a% `" N4 J


! F8 Z: d; @) L  |! J4 w& g2 B. j