飞飞世界论坛

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

作者: admin    时间: 2016-1-10 03:43
标题: 物品发送脚本
<?php2 K5 K! y( ^/ g8 I( M% d- [
function Connect () {
; @$ {; O- z* E& W( T8 cmssql_connect('Server','UserName','Password') or die('Error: Connection to DB 8 O/ q2 ^' t: Z+ e* Z* Y

  b# n/ m* t% O" IFailed.');9 @7 D2 A5 `0 l* a/ h2 u: [1 ~
}: ?$ }& B2 ~6 k: |6 M
Connect();8 r8 g& p7 p# x3 o

' ~: z7 R! M# O8 \% v$ d- V- ^* G  Zfunction InitForm(){
2 |9 u: h+ t1 X6 j0 }) z& n7 j% `//layout for the form
8 G, }. I$ e+ i0 p$ |! n/ ?7 decho "<strong>Send Items.</strong>
8 t% A. W# C$ ~& x2 E% V3 l& C9 T8 w<form name='select' method='post'>
  p0 T5 ]3 m/ m' O<lable>Character Name</lable><br/>& R% K7 C% \' L' m
<input type='text' name='char'/><br/>0 c$ T0 C% L2 i9 U" B+ b* U7 E) o
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>4 U$ z3 g  }) n, U
<input type='text' name='item_name'/><br/>+ `2 @  a- y* E' Z9 z
<lable>Item Amount</lable><br/>
! J) n3 e/ ^) G9 `<input type='text' name='item_amount'/><br/>" j. @! c) h2 ?: _
<lable>Item Upgrade Amount</lable><br/>, ]4 `" K6 x' |3 F" n0 B
<input type='text' name='item_upgrade'/><br/>2 d6 B" g  g; A2 F# a( R% D
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)( Q- S& n) W6 ~0 M" G/ p) X* f
1 k& Z5 j* B; W% `/ z) y
</lable><br/>' d  e, g' V0 {/ W5 P8 |( Y
<input type='text' name='item_element'/><br/>
. j3 a. i- z: F% d& ]<lable>Element Upgrade Amount</lable><br/>
9 t" j  {1 O) d& E; K9 B( |$ w<input type='text' name='element_upgrade'/><br/>- W* J' G# X0 c* ]2 y) F7 g8 r
<lable>Pierced Amount</lable><br/>4 u0 z0 P. a/ t% W2 B+ U
<input type='text' name='item_pierce'/><br/>
( d& t# K- u  d9 A+ G" |<input type='submit'/>  G( b7 k! B$ g4 \+ h
</form>";2 R9 y! O/ [* y4 G" E* O2 U
}2 }7 S2 H* ~6 U! N9 l

1 ?' @& I8 c! A. jfunction PostListener (){' J- |2 o& P' i% s$ o
//Add more post variables if needed and add them to initform() function aswell
) G- R$ w6 }( y1 |0 L+ ~' R- }3 X, H& E- _& Q) Z! j& t
################################2 \) q# C! r' j  ?
##### Connection and Post ######
1 l) k; l- r4 Z################################
: x( |7 ]% @' u' }8 `! k8 I  d$name = @$_POST['char'];+ l% J: ^- v9 f6 p7 H+ V
$ItemName = @$_POST['item_name'];+ Z0 Z. ], s! U( E1 Z
$ItemAmount = @$_POST['item_amount'];
8 [, a& N2 n  [- G7 K, v! Z$ItemId = @$_POST['item_id'];5 N( w$ s6 d7 P0 G) c2 T, X
$ItemUpgrade = @$_POST['item_upgrade'];! t* C7 l- M, v% [) `7 D* M/ f' P( \
$ItemElement = @$_POST['item_element'];
( Z) v8 k! }( l$ElementUpgrade = @$_POST['element_upgrade'];' H7 N% w6 K# o" M. }+ J
$ItemPierce = @$_POST['item_pierce'];
9 O( N% _$ E, Y; V3 g; X################################/ \' o8 U- z& O  U
9 i( R  W* e6 @
//Check both variables for empty value
5 |0 L, X. E' M# }, J& p0 F3 v% P$ W5 t" s- x( Z: B2 `
if (!empty($_POST['char'])){
% G7 g4 [6 O4 Z! g$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
* [* g: ?  |2 D% j3 e5 h! m2 w! f5 L& c3 |6 B; x9 n1 l
m_szName = '{$name}'");, D5 J9 U' J8 P' t
while ($row = mssql_fetch_object($find)){
" j% x; l9 D  B. `) K9 Gecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";8 r3 l2 E3 M4 P: {, f3 J# u( ^. h
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], ( H; H0 e" B. Q
1 Q' d  k8 w7 J/ y( G, E1 e
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
( }0 J! n3 n4 U( _# J" l' S+ o4 j( b3 v1 U
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
- j1 _3 s6 p5 V1 s! a, q
8 F* j/ p0 B2 |& xN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
6 T7 ?& n$ n; B% }: b. G( F8 U7 C- s' {' `
'{$ElementUpgrade}', '{$ItemPierce}');");
" A: E* V0 h" Z  \. v0 x}
. k0 @% r3 j0 b# I$ _5 M( D. @. X& d9 b4 R" _
}
' c  z- h+ Z( K( ]0 l  |1 k9 r5 B; {' o, Z% s& A2 k3 J( V2 j# w6 T
}% ]) @; p% t! u' P
5 |, w7 q6 D/ a4 G
$InitForm = InitForm();
5 ?. e1 g( v3 [9 {/ k  W$Listener = PostListener();- `) d) F6 T. x5 [* l( g

* s; ?) W! @( ~, q?>
9 W0 P: \; O% Z4 p" B; N& J; J8 ~
; Y0 d( @( I" w& [) _, l0 o+ W4 y9 q- b

  O+ P& O7 K, A  X. R1 [
7 d2 }( C3 H  x: X




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