标题: 物品发送脚本 [打印本页] 作者: admin 时间: 2016-1-10 03:43 标题: 物品发送脚本 <?php 4 k$ \( ]7 w0 p, W l5 |function Connect () { " H, @6 u2 g- c- }/ w. \mssql_connect('Server','UserName','Password') or die('Error: Connection to DB 8 ` ^# C' d" D0 G' j# Z) a
* N, _8 C; e# _* t
Failed.');- X7 x. V+ ~2 c1 Z* Y
}* }$ P P+ S9 f5 c0 g" B
Connect(); 3 Z: u* c9 {- h5 e% M : Y9 d4 y# j& Efunction InitForm(){% ]- ~9 e- [ R$ _4 z
//layout for the form : ]- j, C( w2 q* a, Iecho "<strong>Send Items.</strong> ) j6 H/ f% H; s, I<form name='select' method='post'> 2 M! k2 V) n' X d2 L<lable>Character Name</lable><br/> 6 C$ P0 O( x8 R5 ~4 v* z<input type='text' name='char'/><br/>4 v c' I; }9 j7 c8 Z
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>8 m* J' ^+ L- R2 t
<input type='text' name='item_name'/><br/> 9 w8 O- Y: A6 R+ V+ P4 [6 g<lable>Item Amount</lable><br/> 9 k# W9 R( g2 j<input type='text' name='item_amount'/><br/>- D1 o$ ~- }4 {' U
<lable>Item Upgrade Amount</lable><br/>( `+ Z- w4 @3 J9 H+ m
<input type='text' name='item_upgrade'/><br/> ) A; d6 i, k# j2 s<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.) : e, Y% r* ?" X 7 D' [1 }9 _2 V( U) V/ `6 Z</lable><br/> ( c8 r0 e! y+ }5 j. T<input type='text' name='item_element'/><br/>" P; A9 G- j* _$ i* b7 K
<lable>Element Upgrade Amount</lable><br/> , p# h, B- s* ^& {* n Q4 [+ k<input type='text' name='element_upgrade'/><br/>3 ]. x$ c( L Z+ x3 A" V3 o8 Y
<lable>Pierced Amount</lable><br/>* W7 U1 H$ k# ^7 Y3 a$ W% F; X
<input type='text' name='item_pierce'/><br/> ) L6 R" h7 T: z: m9 C' H# c: o1 d<input type='submit'/> . G }# ^* A( H4 s: r) e& T</form>"; ' w6 t) A$ J# a}* [, B: U0 T! h2 J2 D, R: l
c+ `0 ^2 l1 qfunction PostListener (){ ' [! A, F& S C+ t. O- D//Add more post variables if needed and add them to initform() function aswell& l9 ~* ]# u" C: X4 {
1 R$ w6 Y2 h& u, K################################9 o/ t. z% B8 b/ W9 w
##### Connection and Post ######$ z {# F H" V4 _4 B1 n$ O
################################ 0 M5 j# j/ x# w; e$name = @$_POST['char'];% G+ T& D, e/ j
$ItemName = @$_POST['item_name']; 2 `7 U+ H& ^, n& F1 |' v4 o$ItemAmount = @$_POST['item_amount'];3 H; C4 i2 q6 D# p; h1 f: a. N; i4 P
$ItemId = @$_POST['item_id']; " p6 m6 |+ C [% ]4 W! T) b5 e$ItemUpgrade = @$_POST['item_upgrade']; # ]" D& b5 c6 q$ItemElement = @$_POST['item_element'];7 v$ |+ C; _7 R, j a) i
$ElementUpgrade = @$_POST['element_upgrade']; : H: w4 h# e4 Y& S8 y$ItemPierce = @$_POST['item_pierce'];' Q9 {' ?) k4 y5 g
################################ * x( j8 j* Y/ F ; g8 j; [& ~& w7 e1 c5 V//Check both variables for empty value" Y! q( e0 \4 m2 Y% b# E: j6 i8 A
4 z% E) X, [2 S# {% G( v! B& N; I/ j3 E
if (!empty($_POST['char'])){ 7 e" x7 o# J# G, ?- w4 ^0 x$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where " v: s( E! T7 R4 x* s; h7 R( t
+ e8 ~! v7 P8 R9 Y1 \
m_szName = '{$name}'");8 b3 r% W5 V4 E/ s- w ]
while ($row = mssql_fetch_object($find)){2 R# e2 y; J0 `. w. K" s1 b! X
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>"; ! c: K5 Z) p# U0 M$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], " f$ ^6 X' x- Q0 r- B
3 n6 O3 _7 G% a6 ^6 `# p
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], , l; z0 ?0 R; }. U7 L# Q3 z 2 r. z; Q& r- B& ?3 O2 z4 I9 H[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 9 L+ [# n4 H. E- s3 f0 p" R0 t4 A8 U( H! D* y+ v/ e6 O( L8 z
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', ) X/ n6 K. c$ ^" d& z! Y# W) _8 ~% _. w. t% z5 ~
'{$ElementUpgrade}', '{$ItemPierce}');"); i! F7 u' r) H% R* ^( L3 I
}# i6 o. [- E0 Y) \8 K
- E9 Z9 A) y6 q( N' Z% t} ?; h2 f2 z3 E+ i: A, \7 {3 l d# T/ z5 V) l
}) N! V* H' g V( t. W$ H5 G4 D
: j: K( k1 F, k; Q5 S
$InitForm = InitForm(); ! h L9 Y" z1 M1 K$Listener = PostListener();8 l* h0 A2 V) z$ x7 P, P
7 u1 x6 p. m- ], C/ ?
?> $ d, H( p# H8 i8 r3 `0 U 3 P: J- b& H6 i$ V: E! X( I% S* `; k* Y