物品发送脚本

admin

<?php
function Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
4 s; F. Y# }# r: c+ F$ Z
4 V' f8 {$ k8 l4 b8 x* o" MFailed.');
; o" d# [+ D( D, E: h}
; e' j8 g& ]6 K0 @+ U. h! A4 x0 yConnect();
  O0 S+ t6 a" A9 E8 D& ]  a
; ]. o, ], j5 Y( `function InitForm(){
//layout for the form
: w( d2 y- D* j4 @) |. Wecho "<strong>Send Items.</strong>
<form name='select' method='post'>
4 F, O( N6 x4 j7 V5 `# U9 Y<lable>Character Name</lable><br/>
<input type='text' name='char'/><br/>
  X8 P' |: D, h; S& W# V5 c<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
; \, w9 S9 ]9 d<input type='text' name='item_name'/><br/>
( r5 f8 A, |3 X<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
! U# b4 O; N4 P! ^/ X& z* D2 v<lable>Item Upgrade Amount</lable><br/>
7 y8 N1 \+ s- q. M) }% y0 d<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

+ y4 j/ T# G1 U8 L6 j</lable><br/>
" }: ~: K& u- r2 d3 K  c<input type='text' name='item_element'/><br/>
1 e! P  f9 e/ ^2 f5 O- b<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/>
4 ?/ m0 x/ `" j8 O0 R# ~# x* y<input type='submit'/>
</form>";
}

1 E! F# k6 `( t. S" N. _1 Y2 Efunction PostListener (){
//Add more post variables if needed and add them to initform() function aswell
' ^$ ^. O/ Z4 R( e
7 n/ a" D, ?) S2 ~################################
##### Connection and Post ######
0 P7 o# y! s, o* ]# s+ N################################
7 P& M5 g$ o: u6 X% Q$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
: k" {* O2 @8 t, H8 G- l4 x$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
2 @8 d0 U5 p, O6 X: U9 d* @& C$ItemUpgrade = @$_POST['item_upgrade'];
) I* b, m  T6 ^. E& O" [6 L! o$ItemElement = @$_POST['item_element'];
! K. h# ~! s+ a+ A& p0 x7 \  j$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
2 `* z! E  }2 ]* W; T################################

//Check both variables for empty value
3 D$ y5 r# `; N. c! c# M
if (!empty($_POST['char'])){
1 f7 i3 a0 b- S0 R$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

m_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
" y( l+ l$ F# ^  uecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
, }3 D) K$ O- R1 V$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
; e) Y4 j+ |1 k3 p2 e
7 d  @& y0 ^# U7 p, |8 n( i) d[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

6 m* a! C" a& p[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
& [( h$ r9 C7 s- p
9 l# t7 }! c. R  LN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
2 ^& N( p' E' _3 e7 h* b
'{$ElementUpgrade}', '{$ItemPierce}');");
}
4 B. ^( n. z% c) D& e
% N+ U+ W) V, F2 h9 Q2 X( ?! f) T! ?$ R}
% Q7 y( }9 R3 o+ W9 T9 \* R, o1 T
! o0 D" I. _. u1 I) f2 s% E}
' S" H" k2 t& [% ^! C( J
) X" p8 O  ?" ^" Q, ~4 w* Q$InitForm = InitForm();
$Listener = PostListener();

, `7 d3 H* s9 _: I9 f+ Q9 [?>
& _+ R1 J! h* m. @8 L. m" k
( z  m. a# e8 D+ C# f0 s; a2 m
" c5 v  N3 u$ u

! d/ Z, l0 V  r. B; R# T2 p