标题: 物品发送脚本 [打印本页] 作者: admin 时间: 2016-1-10 03:43 标题: 物品发送脚本 <?php6 t' Y( n% P( R' u& p
function Connect () {. J: n" R2 T' J' E8 H( n2 U
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB 5 b: p$ q `5 C; G1 e & b( T/ n" `% `+ RFailed.');/ @& ~: e4 y# _+ \
}+ w' c E, I, s6 t/ L# B
Connect();, z; S" f9 L, F+ c
1 x1 z$ ~* \# K' w+ x
function InitForm(){( l$ l( l, h/ g/ e
//layout for the form8 U8 f: _( v* y6 B5 u: D5 J
echo "<strong>Send Items.</strong> 3 {% a4 Q6 U! A9 _; w- A<form name='select' method='post'> / H0 c" w9 A) M- i" T+ U' @<lable>Character Name</lable><br/>7 j' E8 t& r# I: T
<input type='text' name='char'/><br/> : [7 v( s8 w9 k0 x$ P3 e<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/> " K" K+ Y# S* y( y9 V<input type='text' name='item_name'/><br/>4 Q2 a* R0 Z4 g. R) U
<lable>Item Amount</lable><br/>, }" s Q: ]9 u F1 P* y# f1 n
<input type='text' name='item_amount'/><br/> % g/ m+ l6 [7 k8 P5 K* [<lable>Item Upgrade Amount</lable><br/> + p. M6 ]( A" E% P; r: X( N<input type='text' name='item_upgrade'/><br/> ' {) f7 ^% f9 J3 K3 g n<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)( I! j9 N h( k
: f7 a7 d1 s w% }</lable><br/>" w! u" @6 E2 k& s0 a8 u
<input type='text' name='item_element'/><br/>& a4 z: F' I% _; u& i' I. z
<lable>Element Upgrade Amount</lable><br/>1 j. z- M. Q' D7 s! |! D9 R% n0 P
<input type='text' name='element_upgrade'/><br/> ' S1 `5 z- v; @" V R% |3 q% z- S<lable>Pierced Amount</lable><br/>8 Y; h6 }3 O- C t
<input type='text' name='item_pierce'/><br/> + V$ x W. s3 x<input type='submit'/> 7 M% a" P$ U2 {5 S9 j</form>";: C) C0 z; l3 y# ~5 F% n, O
} 9 g" Q9 ^4 G( p2 I% T* @7 g' U ; h# E" x6 P- g; |3 u d7 g: j) qfunction PostListener (){8 p: \' D0 B# e" ^% N
//Add more post variables if needed and add them to initform() function aswell ( q3 Q( [% `+ | E# h& S- \& u e9 G0 \5 |. F# N################################; w7 I# O6 n( h5 c& N7 X, \
##### Connection and Post ###### 8 h/ I [! H) k7 e- Z) z/ a8 F################################; F' Q1 ^5 G7 C0 f; h5 K
$name = @$_POST['char'];! B0 l) n4 H3 J5 G% C5 s2 b
$ItemName = @$_POST['item_name'];8 F+ h8 M6 S0 \+ l6 T+ W
$ItemAmount = @$_POST['item_amount'];; d4 h' v( Y' e6 E
$ItemId = @$_POST['item_id'];2 t1 [# l# Z+ T1 J' J9 F' R
$ItemUpgrade = @$_POST['item_upgrade'];$ b. l& Y- i; p6 z5 S4 h
$ItemElement = @$_POST['item_element'];+ ~* |4 q) W( G/ n; \$ D6 s0 @
$ElementUpgrade = @$_POST['element_upgrade'];/ ?, ^1 v: M3 i9 L. m
$ItemPierce = @$_POST['item_pierce'];. e9 _# @: h. ]% Y, i" }
################################/ o( _- U0 t( I! t3 Y6 S: i
( n9 w/ D' d& d9 J! @2 t P0 c) y//Check both variables for empty value Q* `+ ?7 J, x- M8 I- {5 R( ^& U- ~% h5 E
if (!empty($_POST['char'])){ G0 S8 ^% |; B
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where 4 k& Q$ S& | o
" g8 d% k, k' a% H' ~: bm_szName = '{$name}'"); : k# ?8 O( [0 r0 A; V2 Fwhile ($row = mssql_fetch_object($find)){ : Z# k# i* q+ U2 eecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>"; # `4 o$ y0 y1 ]: B$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 4 {& ~* w7 @8 ]$ C& o e u 0 U4 u3 X+ K9 V, c( |[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], % r5 t7 U1 X) Z$ u9 Z2 M# b1 O
3 ^: y7 a' P7 J% C0 u8 l
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', ; v/ T" i' M2 J0 ?) R9 e/ ]9 W1 ?: F0 [- R) y# r( D" l
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', $ f5 n2 P' D3 F/ C. t " { U+ s6 {/ h9 L4 p'{$ElementUpgrade}', '{$ItemPierce}');"); E" [% U* h @0 `2 i! b- ?, ~+ N/ c
} , P6 x* L& T# c5 P) r ! R8 h7 S" r. {% C}6 w; `) Q& E" [
- p% s- R \. _) B# i4 O9 J) c& y
} , e! A, }4 V; l) u : j5 }. D9 }4 [! C: B6 _$InitForm = InitForm();3 p) W5 @8 z+ J1 x0 U8 f$ l
$Listener = PostListener(); a. [( ^* ~9 ]
* O6 Y- F. m* U) d. E6 b, O?>7 i- ` i# x, S/ ?1 I6 h
) g) H) {9 z: ]* v6 r) E' Y. v: Y* ^- ]# k7 S+ [$ |