标题: 物品发送脚本 [打印本页] 作者: admin 时间: 2016-1-10 03:43 标题: 物品发送脚本 <?php9 n' U! b; Y, r7 h/ ?& E
function Connect () {7 v/ I. } _; D# V3 o$ u8 }# Y
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB " n2 @3 C9 w3 \* G: L/ {. B
) n# v$ r; W) a3 h0 _# aFailed.'); , r5 [1 j) J" ^0 |) A) X}2 F7 T9 i: N4 s% c
Connect(); t) n/ J% ^( D# p ' ?" r# R# R. E; Mfunction InitForm(){* Z0 G: g' W8 r3 ^8 a- ~
//layout for the form & H0 H. T1 q. E* Jecho "<strong>Send Items.</strong>, |1 Q. J- f& e! Y
<form name='select' method='post'>( o# b: k8 U& e. A, n' E. ~" e
<lable>Character Name</lable><br/>" w$ o& ]1 ]& O
<input type='text' name='char'/><br/> ) V7 M) d$ r/ v, Y; Y* _% L<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>' I4 T* S; A/ N% C, Q+ y. x( w z# C
<input type='text' name='item_name'/><br/>' i. p' U- W8 @8 |; B U7 ]( ]
<lable>Item Amount</lable><br/>4 j+ K* |7 c- y1 s
<input type='text' name='item_amount'/><br/> 1 y" o3 v' [, R* H* e2 m+ L4 p<lable>Item Upgrade Amount</lable><br/> 2 |# ` ^8 _. X: s A8 }<input type='text' name='item_upgrade'/><br/> 9 b9 k: p2 v$ _<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.) C: k3 N5 J. I! D1 }: R a5 }2 f( } 8 Z5 Z& Q5 e2 {2 o* P" ?</lable><br/> ; q8 @) }6 g' y6 Q& p<input type='text' name='item_element'/><br/>" N; h3 J& j8 k i5 j
<lable>Element Upgrade Amount</lable><br/># Q# u6 I" ]4 v1 v! g. [) `' ?: a
<input type='text' name='element_upgrade'/><br/> 3 k# i* J1 g; T2 ~+ p' v# Y" R F<lable>Pierced Amount</lable><br/> q7 s9 S. z! H$ [+ Y5 K<input type='text' name='item_pierce'/><br/> . w2 `" g$ H, f4 U<input type='submit'/> - Q" K' ^# }; C# W; S$ b</form>";; ~' i' l4 I) j: U. T$ h
}1 T( b. s1 f$ k, `0 n
& q7 R {0 R2 W0 Cfunction PostListener (){- T& K% c' l, k# q. Z) |
//Add more post variables if needed and add them to initform() function aswell 6 ^/ R* U3 C. {: I; \. M# M s6 f5 \& v- g/ C- P$ r3 s" s. ^
################################) n# ~4 n6 I. P9 j2 I+ q+ C
##### Connection and Post ###### 9 ?. l# H9 Z" Z5 H+ P9 y################################8 v! |. |) h" S% R
$name = @$_POST['char'];+ n4 o5 q$ H& _# L
$ItemName = @$_POST['item_name']; ' j- }! Z& ^; n$ItemAmount = @$_POST['item_amount']; ' f2 i8 q0 U6 }% B1 `) K$ItemId = @$_POST['item_id']; - H2 H6 k. I# n3 {/ O( C$ItemUpgrade = @$_POST['item_upgrade'];( v" C+ \+ ~) T4 ?
$ItemElement = @$_POST['item_element'];9 n5 G6 J# u: N9 Y+ p6 E1 ~
$ElementUpgrade = @$_POST['element_upgrade'];* ^6 X$ L' h9 l/ b1 W% K- n
$ItemPierce = @$_POST['item_pierce']; 0 n$ K) B, L4 T" F3 ~################################ 9 z! t% o. a! a0 v3 t2 m: u 7 i4 x. U' E# H& c; R, Y//Check both variables for empty value : p8 n5 b+ F J, ^, B2 R: m3 ` e, E* r
if (!empty($_POST['char'])){! q# s5 n' k( E5 ^% [8 l" X
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where . x0 y8 a- ~% M; y$ P! N 1 V3 n# B; R3 G5 fm_szName = '{$name}'");( F' W7 }( R2 k- ?2 P# n! M
while ($row = mssql_fetch_object($find)){; @) n' r0 y3 `( R4 Y/ ?6 B
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>"; A" T+ a' G* {5 U) u' X. [
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 8 I( P$ j4 T; I$ e# e8 X& m% p . c( r K8 u% z3 C[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], : b- u, a' S9 F( F8 |& j2 ~" x( }) w4 j8 K! q
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', & s: }3 O8 r: y5 ^
8 n+ O& |* V7 L7 QN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', ' m0 x) x6 B. Z2 J6 x
$ z. z2 A# C" O' \- J4 w/ x! Q0 n6 X
'{$ElementUpgrade}', '{$ItemPierce}');");4 g8 w: A. D/ K5 L' x- O$ P2 L
} 5 X. @ Z, J% b# X1 _1 J' j3 e! K0 s2 B5 l# L' o3 k, ~ ]
}' A8 r; o9 {, B5 J! @7 D
2 c% b1 n- E! \9 v# l
}% Z0 x; H* x" K0 q. M- N
3 X6 B; u& m( X
$InitForm = InitForm(); % u+ I, k3 V9 q i+ I) ~$Listener = PostListener();/ q2 ^) `% G; t$ }( [
- E: O E5 Q2 o, J( r; [1 \* B: m/ k! k?> & U, U3 q# B/ j5 ?7 w! S * S0 O$ O3 r2 G2 S1 Y 8 D. }* O- K: T @5 n( v- k5 d" a/ G( F6 s+ i
5 K2 V u0 C* b, ]5 h