标题: 物品发送脚本 [打印本页] 作者: admin 时间: 2016-1-10 03:43 标题: 物品发送脚本 <?php O- v3 Y, ^* m tfunction Connect () {- d! K! ~$ \# \8 D2 c0 U
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB 3 \) C1 F3 G0 h+ ~, \
& h% P5 t4 W; v5 mFailed.'); 0 ~% M2 f% R4 C} * y2 t& k0 \$ B; [8 M, W* }1 eConnect(); & L; M* i; F% {; b/ F' K+ B* Z, V9 U. V( w. U) o$ h3 j
function InitForm(){ ! h" Q$ K3 G: c8 h//layout for the form5 g- p7 u& j; V1 ^
echo "<strong>Send Items.</strong> 9 M% }8 \) Z' ^/ U! e<form name='select' method='post'>% {0 M E% B0 I
<lable>Character Name</lable><br/>: Q1 R ?& x2 W8 b' ~* I: V& B6 s
<input type='text' name='char'/><br/> 3 n- \8 T( _) u v; @3 R8 m<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/> $ L9 l7 t% u3 F8 R<input type='text' name='item_name'/><br/> / ~0 e- b1 j/ W- [" E: C$ w: U<lable>Item Amount</lable><br/>" T, k7 L" B# Z. J! T0 J
<input type='text' name='item_amount'/><br/>: p; f+ G' B* b, r3 P, c
<lable>Item Upgrade Amount</lable><br/>) n: g" ^2 O& R& m" X. D% P( R
<input type='text' name='item_upgrade'/><br/>5 ^/ G3 X+ Y$ _' X7 y. L, O
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.) - h) B" ^* v/ Q1 K, h) X8 [: f4 `& b: r$ y9 M* {
</lable><br/>( |, R! ~9 ]5 W: \! f/ a
<input type='text' name='item_element'/><br/>9 P7 P" M/ F7 x3 H
<lable>Element Upgrade Amount</lable><br/> , u$ ]; S) E# V x1 Y<input type='text' name='element_upgrade'/><br/> & |3 X- O$ D- g% Z4 M; ~& s( n<lable>Pierced Amount</lable><br/>: y% \( K* F7 q' l0 H3 }
<input type='text' name='item_pierce'/><br/> - M4 E2 k0 }% e, d<input type='submit'/>/ _, B5 n( T" K+ t& m$ w
</form>"; / r% _2 N; p! \}8 Y+ N k' }1 m' M' q, E: u+ D: c
! C* m+ U! j+ s" D8 ]function PostListener (){. p. B; C) h N& J
//Add more post variables if needed and add them to initform() function aswell : `! w% q2 M" @* l# F e+ Z/ h0 ~- e" R# f D
################################ & g2 J! R9 M+ P* N J7 q1 ~5 D##### Connection and Post ###### / F7 o& L- O2 @# o, Z* S, \. _4 N################################. o8 E9 O3 G O9 m
$name = @$_POST['char']; ) V7 F% W6 K* Z5 h' r1 @8 z6 ~$ItemName = @$_POST['item_name'];/ r& c- w; Q+ x; A! I/ a$ O
$ItemAmount = @$_POST['item_amount'];$ n+ P; {' C C% Z; ~2 O
$ItemId = @$_POST['item_id']; ! U7 F4 r2 W' ~$ItemUpgrade = @$_POST['item_upgrade']; , {) C% |6 R& O* j: ~( N2 u0 k$ItemElement = @$_POST['item_element'];. ]1 e% _ I$ d% Q5 p
$ElementUpgrade = @$_POST['element_upgrade']; 9 K1 g8 T7 g8 q h$ItemPierce = @$_POST['item_pierce']; - C t2 W% v i################################7 x# w q4 E7 t; N
( Q/ w( J1 W! K' {9 ~0 @# @6 J/ P//Check both variables for empty value / B+ o& f3 n, w$ j9 i, y* M; s9 i! L4 W+ q
if (!empty($_POST['char'])){ 8 H3 c+ X2 t7 R5 Y8 m% r( d$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where , W' i/ \) K' F* e
/ |* }+ ]4 p9 N$ k& J Um_szName = '{$name}'");" m( A2 J+ [/ D/ Z
while ($row = mssql_fetch_object($find)){ 3 n, ^. d+ m$ O3 n& h: Hecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>"; , |/ s7 Q- ]" F" V% o6 i3 \2 _$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], / k$ ?. L. [, R& h' H7 p* b
# b3 {+ s5 Q `- s) z% s
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], R: ?" n. h5 U4 G
$ `( m1 }" O7 h0 v$ [% ]: D
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', " E) m4 M1 x( `( K* E + K# c5 X3 z; Y5 Q, sN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', b6 }+ [6 h3 [& j9 q9 s
- N; W$ v/ x, T' c'{$ElementUpgrade}', '{$ItemPierce}');");+ ?# ?# x, S5 S/ O# }; [
} % M6 z6 `' P7 z; B$ p9 V; ]& I# Z: V d5 \0 @
} - R4 J. n3 Q" A- [ * E/ f. f. l0 \* u+ z& {% p0 g}( p# R c8 P0 V- H6 n- N
8 R7 `; G& b( L( E* f
$InitForm = InitForm(); , R; n9 @) o5 d% h r$Listener = PostListener();6 m) e& i. {& m
5 v2 ~2 H, G4 M) r
?>$ k* s W% s5 T v7 f8 S% C5 s3 e/ L
0 J. f9 s; A* o4 b& F
0 N7 A) a0 K/ u
# U1 M9 U/ L9 B3 p1 U( x3 x
& Y4 ]# j' {- m* ]* b9 i