标题: 物品发送脚本 [打印本页] 作者: admin 时间: 2016-1-10 03:43 标题: 物品发送脚本 <?php) W% N C) |$ P2 K
function Connect () {3 }7 K. B$ N8 U9 v' a! n
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB ; }. c) E! K+ u* d( M 6 J9 p& Q0 j7 u6 uFailed.'); 1 v& U) x8 `& K}# [# w) M+ U9 h; T3 B8 U" O
Connect();4 q) k- n+ {6 x2 h
6 R/ H- Q8 b3 o; V5 h/ N
function InitForm(){ 5 A' C0 n' O! U1 ]//layout for the form : [- n+ d8 p. N; ]echo "<strong>Send Items.</strong>" y+ V4 T. z8 c8 u( [
<form name='select' method='post'> * d* s0 q7 W+ V8 B! u/ j<lable>Character Name</lable><br/> % K' v4 o3 b8 g2 R/ p5 h: y5 I5 q<input type='text' name='char'/><br/> , @! W; d+ {5 h: {4 ^8 l5 k<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/> 3 v# g! V; K8 [<input type='text' name='item_name'/><br/> 4 J# D8 ^1 y; k& p0 t r" I<lable>Item Amount</lable><br/> . M3 w4 s0 R( a3 C7 `4 u! L( f% L$ F<input type='text' name='item_amount'/><br/> ! S0 d5 d) }0 D6 n<lable>Item Upgrade Amount</lable><br/> ( Z, ]8 ]4 Q r+ W) D5 L6 y# c- N<input type='text' name='item_upgrade'/><br/> ! L1 Z1 @/ H7 `0 a<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)- ~2 P J/ z: e
6 d, A/ h- P8 P6 `5 x8 D0 r5 m6 I
</lable><br/> ; t5 ^" `9 w9 @/ C% |<input type='text' name='item_element'/><br/>! [$ b% C7 z% X) x+ q
<lable>Element Upgrade Amount</lable><br/>4 f' p8 }5 O# e7 H$ p! E/ Q
<input type='text' name='element_upgrade'/><br/>9 ^# n' c. g& e
<lable>Pierced Amount</lable><br/>* J# r- s. w) }
<input type='text' name='item_pierce'/><br/>0 M- ?* J4 ~7 t+ _: T
<input type='submit'/> . ]& r* f! ?6 f" K8 k</form>";1 V/ L" ?9 P' o" e, y9 v7 {1 h
}# O' r/ H5 G" K
0 d9 W! H; e) ?9 f/ \function PostListener (){( z+ M7 {, k, Y) l; W& n6 k
//Add more post variables if needed and add them to initform() function aswell* ?) L# _. k4 P# Y0 N3 [
: N: d6 e O# L" ? X################################; r# J! L4 G+ m2 e1 y
##### Connection and Post ######9 X5 {( w9 A, r6 X$ |
################################ 1 T) P) k$ N' x9 E/ v9 L$name = @$_POST['char'];0 A9 ^% k: K+ x- d5 C
$ItemName = @$_POST['item_name']; 8 n b1 |$ [: @" s$ItemAmount = @$_POST['item_amount'];* I6 Y# i( _% X2 A9 J. ?& N$ X* V8 T3 [
$ItemId = @$_POST['item_id']; {- V/ p2 ~& m; x. I
$ItemUpgrade = @$_POST['item_upgrade'];! X; M3 s5 o9 s. G- M. ?
$ItemElement = @$_POST['item_element'];' e; s- Y7 X. x. `5 v
$ElementUpgrade = @$_POST['element_upgrade'];% U( t5 o# |# l# h
$ItemPierce = @$_POST['item_pierce'];% X6 K) U I( W, M* A
################################: n. T5 r9 u/ `
3 k$ k% {7 G3 X. f( i' o4 e' c0 k
//Check both variables for empty value, ?# t, u0 J3 N+ V( X
! a. R6 ?5 v- T0 y& u
if (!empty($_POST['char'])){6 p( a% P( v5 ]
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where 7 l, X! O7 {( H1 G1 k- ]6 Z' J
' M; b6 k8 [5 ~/ k6 l8 K; ~1 m- qm_szName = '{$name}'"); 7 @+ [2 S6 g) T4 G0 b) J$ hwhile ($row = mssql_fetch_object($find)){$ G1 B3 m9 v+ [6 p' s8 _9 R
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>"; 6 X& t5 ]" M# v5 p, L+ R) i$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], & ^4 s7 F% O* U6 B) h2 p+ ] ( o c$ r% z. u% A, M/ g5 b5 b[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], " X. J5 b% v E) q: @; d$ N6 L$ q, c# n8 u3 w, [
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 0 d# @1 U9 t# N( U+ S2 ]% B2 a7 G 0 r6 I" D8 z5 ]. u4 l, a2 J5 w# rN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', % n! T( \: s; R, B
( s! }: O+ l" Q% J+ x
'{$ElementUpgrade}', '{$ItemPierce}');");& |( [9 |9 u' ?. n6 y$ n* o$ W
}# c0 h" I! H& k3 h, F
6 u$ i( Y& `3 o# k- H) G+ j
}# m) r2 U# R- p+ G% ?! X# u
: g9 l2 ^! k) U6 a* h$ I
} ; j) H( N4 d7 k/ B3 n* p) g4 D) d1 t4 ~- p4 x3 W! U1 u% Q- ?1 e4 P
$InitForm = InitForm(); % s/ v& |4 x v7 e, P( u/ g' j+ ~$Listener = PostListener(); 7 s; `: G4 P' T h* F& E/ | t/ v8 n( e( K8 v" e ?; Z* b
?>& n9 l; }9 D! _6 H. j
3 x( _$ U/ t+ L7 q/ b! }6 ^ " }4 ~/ n/ E5 U2 ?8 z/ n: J4 y. M$ r, E7 u5 D9 p
/ X/ V0 _0 J: a+ j" d% t) h