物品发送脚本

admin

<?php
$ g: Y) f' ~- W6 O3 n9 Lfunction Connect () {
0 Z6 c1 y! m) Z, [  smssql_connect('Server','UserName','Password') or die('Error: Connection to DB

$ @( a# V8 x% {7 \, j" wFailed.');
}
, p' n2 ~& T: |2 O+ \0 ^4 T4 b, W+ oConnect();

function InitForm(){
! d) p$ ^$ ^& X7 h) ~8 T  U* \# X- Y//layout for the form
/ e4 J5 V7 z- L( a1 T. Y: y, oecho "<strong>Send Items.</strong>
<form name='select' method='post'>
9 U1 S3 j6 x7 _0 S' S<lable>Character Name</lable><br/>
<input type='text' name='char'/><br/>
8 o' C1 D. y# O1 y: b<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
! s* C# i8 o7 ?/ b( X7 A% w<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
' t# J8 L7 U$ Q" Q<input type='text' name='item_amount'/><br/>
" f4 s$ b% j# V) D<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.)
4 x& u1 r: j# }4 X7 s. V. r
</lable><br/>
<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
( @) v! \0 T9 P- b: T5 H<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
7 X) w% d# H2 P6 _# l' o* Z) i3 Z; }<input type='submit'/>
) J" W7 P& R: [% k, F* U! k</form>";
/ k3 g; Q  q$ h* O9 ]}

; h: o  g  E9 m  Bfunction PostListener (){
//Add more post variables if needed and add them to initform() function aswell
& {6 `* v0 Q. @6 H2 C- ?  B
& y5 n  E: N+ Z9 O$ P3 u6 d2 @################################
* z2 o, P& `# a: I: |: V( q, h##### Connection and Post ######
################################
) b4 I4 g/ [2 M$ H7 p7 j$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
2 o1 }, L; d8 f. }9 ?$ItemAmount = @$_POST['item_amount'];
. V: w* u- R4 |* a2 u0 f$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
1 K  L' \) [3 j- i. Y9 O+ J$ g: K0 C$ItemElement = @$_POST['item_element'];
: Y- X# l% @( f$ElementUpgrade = @$_POST['element_upgrade'];
; m9 O! H8 l0 J& G$ItemPierce = @$_POST['item_pierce'];
################################

//Check both variables for empty value

6 O7 F( u! t8 T% Pif (!empty($_POST['char'])){
8 ~2 ~0 |6 e: A+ M# t* n1 V$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
5 O5 h9 ^; B& Q4 r
m_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
1 I7 E' C  H& A9 _, r
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
# i( ]( ^% O0 r7 h4 ^
, x8 }7 [8 j# S6 b'{$ElementUpgrade}', '{$ItemPierce}');");
}
- {3 t5 ?# a2 f7 U
$ H: E$ V$ V3 d# p! d- n}
2 |4 [- l/ }" N
}
% K) r4 g  k' u8 X
2 i# Y2 F. {7 r3 r& e" I$InitForm = InitForm();
$Listener = PostListener();
$ N7 [! l# H& Z" z
0 F; B% C+ \8 W! e/ `& p?>
; \3 w# B% @$ W7 s2 @# {" q

+ }& V% M) Y& V5 C
, q- X6 A. s8 }- i* R, s8 C; q# ^4 I
+ \( b. \7 u4 \% u* d* d/ R4 I