飞飞世界论坛

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

作者: admin    时间: 2016-1-10 03:43
标题: 物品发送脚本
<?php6 t' Y( n% P( R' u& p
function Connect () {. J: n" R2 T' J' E8 H( n2 U
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
5 b: p$ q  `5 C; G1 e
& b( T/ n" `% `+ RFailed.');/ @& ~: e4 y# _+ \
}+ w' c  E, I, s6 t/ L# B
Connect();, z; S" f9 L, F+ c
1 x1 z$ ~* \# K' w+ x
function InitForm(){( l$ l( l, h/ g/ e
//layout for the form8 U8 f: _( v* y6 B5 u: D5 J
echo "<strong>Send Items.</strong>
3 {% a4 Q6 U! A9 _; w- A<form name='select' method='post'>
/ H0 c" w9 A) M- i" T+ U' @<lable>Character Name</lable><br/>7 j' E8 t& r# I: T
<input type='text' name='char'/><br/>
: [7 v( s8 w9 k0 x$ P3 e<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
" K" K+ Y# S* y( y9 V<input type='text' name='item_name'/><br/>4 Q2 a* R0 Z4 g. R) U
<lable>Item Amount</lable><br/>, }" s  Q: ]9 u  F1 P* y# f1 n
<input type='text' name='item_amount'/><br/>
% g/ m+ l6 [7 k8 P5 K* [<lable>Item Upgrade Amount</lable><br/>
+ p. M6 ]( A" E% P; r: X( N<input type='text' name='item_upgrade'/><br/>
' {) f7 ^% f9 J3 K3 g  n<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)( I! j9 N  h( k

: f7 a7 d1 s  w% }</lable><br/>" w! u" @6 E2 k& s0 a8 u
<input type='text' name='item_element'/><br/>& a4 z: F' I% _; u& i' I. z
<lable>Element Upgrade Amount</lable><br/>1 j. z- M. Q' D7 s! |! D9 R% n0 P
<input type='text' name='element_upgrade'/><br/>
' S1 `5 z- v; @" V  R% |3 q% z- S<lable>Pierced Amount</lable><br/>8 Y; h6 }3 O- C  t
<input type='text' name='item_pierce'/><br/>
+ V$ x  W. s3 x<input type='submit'/>
7 M% a" P$ U2 {5 S9 j</form>";: C) C0 z; l3 y# ~5 F% n, O
}
9 g" Q9 ^4 G( p2 I% T* @7 g' U
; h# E" x6 P- g; |3 u  d7 g: j) qfunction PostListener (){8 p: \' D0 B# e" ^% N
//Add more post variables if needed and add them to initform() function aswell
( q3 Q( [% `+ |  E# h& S- \& u
  e9 G0 \5 |. F# N################################; w7 I# O6 n( h5 c& N7 X, \
##### Connection and Post ######
8 h/ I  [! H) k7 e- Z) z/ a8 F################################; F' Q1 ^5 G7 C0 f; h5 K
$name = @$_POST['char'];! B0 l) n4 H3 J5 G% C5 s2 b
$ItemName = @$_POST['item_name'];8 F+ h8 M6 S0 \+ l6 T+ W
$ItemAmount = @$_POST['item_amount'];; d4 h' v( Y' e6 E
$ItemId = @$_POST['item_id'];2 t1 [# l# Z+ T1 J' J9 F' R
$ItemUpgrade = @$_POST['item_upgrade'];$ b. l& Y- i; p6 z5 S4 h
$ItemElement = @$_POST['item_element'];+ ~* |4 q) W( G/ n; \$ D6 s0 @
$ElementUpgrade = @$_POST['element_upgrade'];/ ?, ^1 v: M3 i9 L. m
$ItemPierce = @$_POST['item_pierce'];. e9 _# @: h. ]% Y, i" }
################################/ o( _- U0 t( I! t3 Y6 S: i

( n9 w/ D' d& d9 J! @2 t  P0 c) y//Check both variables for empty value
  Q* `+ ?7 J, x- M8 I- {5 R( ^& U- ~% h5 E
if (!empty($_POST['char'])){  G0 S8 ^% |; B
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where 4 k& Q$ S& |  o

" g8 d% k, k' a% H' ~: bm_szName = '{$name}'");
: k# ?8 O( [0 r0 A; V2 Fwhile ($row = mssql_fetch_object($find)){
: Z# k# i* q+ U2 eecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
# `4 o$ y0 y1 ]: B$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
4 {& ~* w7 @8 ]$ C& o  e  u
0 U4 u3 X+ K9 V, c( |[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], % r5 t7 U1 X) Z$ u9 Z2 M# b1 O
3 ^: y7 a' P7 J% C0 u8 l
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
; v/ T" i' M2 J0 ?) R9 e/ ]9 W1 ?: F0 [- R) y# r( D" l
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
$ f5 n2 P' D3 F/ C. t
" {  U+ s6 {/ h9 L4 p'{$ElementUpgrade}', '{$ItemPierce}');");  E" [% U* h  @0 `2 i! b- ?, ~+ N/ c
}
, P6 x* L& T# c5 P) r
! R8 h7 S" r. {% C}6 w; `) Q& E" [
- p% s- R  \. _) B# i4 O9 J) c& y
}
, e! A, }4 V; l) u
: j5 }. D9 }4 [! C: B6 _$InitForm = InitForm();3 p) W5 @8 z+ J1 x0 U8 f$ l
$Listener = PostListener();  a. [( ^* ~9 ]

* O6 Y- F. m* U) d. E6 b, O?>7 i- `  i# x, S/ ?1 I6 h

) g) H) {9 z: ]* v6 r) E' Y. v: Y* ^- ]# k7 S+ [$ |

2 s! y; X" l% N% H6 M9 r# y+ @* c* {" x6 t4 O





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