飞飞世界论坛

标题: 物品发送脚本 [打印本页]

作者: admin    时间: 2016-1-10 03:43
标题: 物品发送脚本
<?php" i7 o6 u7 ?+ e3 I
function Connect () {
9 {  B& Z3 h& y9 l' r  {6 |mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
7 Q! E; O- B* i2 Z# O9 ~' t) n2 G* W' \
Failed.');
9 k+ O1 ]$ E. E: D' E}
& c: ~6 Z  Z+ E0 ]. k! lConnect();" I3 J5 g/ @2 S: s6 p
! L% B7 o) o3 {" g5 f/ l  b- ]
function InitForm(){" ?- U0 B- r! B4 G9 g5 ~
//layout for the form' l; p6 g. O7 e. Y
echo "<strong>Send Items.</strong>8 b' F  v$ E& X3 H3 Y
<form name='select' method='post'>  y" O( p" X# x3 y: j7 c5 n
<lable>Character Name</lable><br/>
# _+ U: G& ^8 M, ~& h<input type='text' name='char'/><br/>+ O$ C8 Q' ^# Z: Z0 R
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
; `/ t+ n1 l$ j( k2 |! b<input type='text' name='item_name'/><br/>* p& }4 ]' |2 o& S' N. w
<lable>Item Amount</lable><br/>) ^! h1 T0 R1 A0 |- v9 L1 l
<input type='text' name='item_amount'/><br/>4 d" X# b: m3 P4 t5 L; _: p
<lable>Item Upgrade Amount</lable><br/>% U' E1 y1 V/ F" @; V& o1 A, q
<input type='text' name='item_upgrade'/><br/>& J0 @. g3 O9 G6 `8 d3 e: h5 g, n' V
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
2 t1 j. _4 m. B3 X1 t( j% [' x' z. m" u' |4 q% ]
</lable><br/>
, \8 s* E/ g7 G<input type='text' name='item_element'/><br/>
# J# w2 ]  j5 c( M: W7 \- C<lable>Element Upgrade Amount</lable><br/>3 n2 O+ N; c, V2 u+ e! S* r0 I
<input type='text' name='element_upgrade'/><br/>
0 N0 b* P) E6 |- c, u<lable>Pierced Amount</lable><br/>, o7 x2 [; @" c0 X* \- t8 |
<input type='text' name='item_pierce'/><br/>
& X* T, [; y" G. q9 x5 S<input type='submit'/>& y6 I9 d. F! o+ z
</form>";& t6 C& P5 l5 S; g3 P" U) J' e# e
}
1 e( K9 I' i, N! a4 V( ?/ }7 U$ n: H: S. U  g7 b* f
function PostListener (){
( Z! o: s$ D$ d//Add more post variables if needed and add them to initform() function aswell% L6 z7 Z) D2 H2 ]3 t: s: f2 ^. Q

5 k' J+ N% e3 ~  h9 @7 M) G9 w2 e################################
5 v9 L  S! B+ Y2 _" q" q  E##### Connection and Post ######" U6 Z  w% A( m# x/ ]
################################
- a1 s6 `/ G( j6 u- @! }- v6 m% ?- U$name = @$_POST['char'];& f* H3 i7 w/ o4 r
$ItemName = @$_POST['item_name'];. u+ @9 z9 s& B9 C, M9 ~8 e
$ItemAmount = @$_POST['item_amount'];2 ?" h; a+ H" C+ e5 g* h  M! i
$ItemId = @$_POST['item_id'];4 G6 W; n4 q2 f% U& ~. b8 b
$ItemUpgrade = @$_POST['item_upgrade'];$ F8 G: o& ]8 b% L
$ItemElement = @$_POST['item_element'];
; i9 Q2 r# ]% d% i8 ?& V$ElementUpgrade = @$_POST['element_upgrade'];
& x4 `! X. A; Q! w( s/ n  `5 I5 l$ItemPierce = @$_POST['item_pierce'];! ?9 a. b" S: X' T5 {1 R1 O% ?
################################' m+ O# L5 z" ^* z/ h

( {! {$ o- k! x( i6 P! h1 W+ }7 n//Check both variables for empty value* A& k0 M% s, U+ n  U+ F

+ i8 R& V/ W1 ?  `0 ?if (!empty($_POST['char'])){
+ _. \% k+ W+ d) N; ]$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where # A% R4 T3 `8 l5 M

/ U, J* E- n/ {9 nm_szName = '{$name}'");( u# N& T! ]* _* I' w  I
while ($row = mssql_fetch_object($find)){/ m5 B) S/ ]0 T' X: o
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
* n5 _3 r4 _6 _8 g$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
! l& y, s; ?8 H, ~) z1 o& M% @6 q4 Q6 @6 a
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
, J( s) A. u( r5 x' d& v4 D
8 j' u( f, f/ t: X, U9 d# e3 \3 @[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
# U. O& e" ^0 i1 J9 v
' U$ X2 C- N) M! }. Q* Q# ZN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 4 \; @8 ^) `7 W; @
6 ?+ o7 f8 F" i
'{$ElementUpgrade}', '{$ItemPierce}');");
1 q# {/ H# ^4 E3 W1 c: I( e7 o}
. D" |+ N; v) \; D1 x1 q7 c2 K. M, E
}9 O" F4 C: ]4 y; P0 s" f. t

1 W. d' a$ {- J) \}1 i5 G3 |2 _+ }0 K* J
9 M" e: Y/ @0 u0 u
$InitForm = InitForm();
2 N& [2 k! }) G, F7 a( {$Listener = PostListener();
: Q6 P4 v$ X% a- k$ ?$ U/ u) z3 Z
8 {, y, ?  e8 W?>( o6 ]7 z! P7 T- _/ p! _

' _* a1 k3 r4 i- l6 s* c
2 R: T2 z- l" ^: v: K7 Y  @
: w( ^$ o, T  a6 {
0 |+ s: c8 O+ a. P- B; A& B




欢迎光临 飞飞世界论坛 (http://www.ffwold.com/) Powered by Discuz! X3.2