飞飞世界论坛

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

作者: admin    时间: 2016-1-10 03:43
标题: 物品发送脚本
<?php
" l7 J4 d+ J; W4 Q( B3 Xfunction Connect () {+ D; i2 Q4 Z8 X( ]* C- a
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
, B% X/ T% R0 `; L3 C; E: w
) j0 {, E! O& E. ~& \Failed.');
% V# `$ h7 Y4 g( K; d8 @8 V}
' w$ h/ y- [5 p+ a$ V2 j/ `Connect();% ]0 c) v/ j4 y" I2 a

$ ~: r! ^9 K, ?function InitForm(){
. [+ E: P; X1 J& \" }( I6 _% N//layout for the form+ [% M5 [! }  {' a  m/ h: q
echo "<strong>Send Items.</strong>
' a4 \5 m* }$ S) [<form name='select' method='post'>
1 S  s4 U; u( F% B- E: E' G3 ^<lable>Character Name</lable><br/>
3 v: C( A+ X$ V9 x/ i6 f<input type='text' name='char'/><br/>
/ l4 n& D! G3 ?4 C1 s5 K- p<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
: H% N: \5 B& A- p9 ~- i- P$ |' n5 J<input type='text' name='item_name'/><br/>
  H8 t$ U4 Z2 o$ v: a<lable>Item Amount</lable><br/>
5 L: n+ Z5 r( T! ^/ W/ e# b<input type='text' name='item_amount'/><br/>* ~2 J! g9 t$ }5 ^1 U
<lable>Item Upgrade Amount</lable><br/>; N! j1 `1 W* C+ }# V, x4 b
<input type='text' name='item_upgrade'/><br/>
# y* h- T) @6 X8 N+ b<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
2 u5 V- s. ?' D1 I" P6 A- K/ T( G3 u" Z; M% R
</lable><br/>
) _. N3 b* |% o, l0 X9 K& W<input type='text' name='item_element'/><br/>
: E2 R& i; y1 p* J% l( m4 m<lable>Element Upgrade Amount</lable><br/>, k2 S. \, r, `# ^
<input type='text' name='element_upgrade'/><br/>
, _! F# \$ I. U  e5 G) E<lable>Pierced Amount</lable><br/>: W+ ~' p6 K0 Z0 P0 L' q5 W  E* |
<input type='text' name='item_pierce'/><br/>
) f6 H( Z6 v4 ?<input type='submit'/>
! y9 J& ?  K) x7 G' w2 z</form>";( @! D9 }/ S! _) u
}
" n1 O# m# _. \9 d! d+ }1 W
; y. c0 d- E7 z* W7 Afunction PostListener (){
4 |& `$ p4 ]- _//Add more post variables if needed and add them to initform() function aswell
) v( z$ ~- V# E% z5 u, l6 Z7 \7 b) L( R- _/ t* b
################################
8 W: z% ~1 e3 V" v' {  e" R##### Connection and Post ######. M1 _# M) [* B5 f2 m, t
################################
7 @0 I  d  o1 n- I4 D& J/ B1 i$name = @$_POST['char'];
+ X% t; o9 N% S2 B$ItemName = @$_POST['item_name'];
- h4 ^, f& y8 ~+ T$ItemAmount = @$_POST['item_amount'];5 h. {% M* s, W& g" K; _: I4 T
$ItemId = @$_POST['item_id'];( l5 N$ S" t" j$ v; V+ k
$ItemUpgrade = @$_POST['item_upgrade'];
: R( W9 f; q$ \& r: T$ItemElement = @$_POST['item_element'];( J4 J& V4 A1 H; _
$ElementUpgrade = @$_POST['element_upgrade'];0 Q! X$ r! l' m3 ^. F9 ?6 j9 `
$ItemPierce = @$_POST['item_pierce'];
3 c5 t% E; l% B################################4 i' B+ e% j3 v# L

. C- [1 E. b, b  J//Check both variables for empty value
# G1 m3 W7 v6 g" e0 z
5 e. \' @+ U: N/ ?if (!empty($_POST['char'])){2 [4 c. `; Q3 ?$ Z  P- S
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
1 ~3 Q6 \) \5 }% c0 |* p* J/ O' o: ]2 l, \3 F
m_szName = '{$name}'");, A+ L) K; [- ]
while ($row = mssql_fetch_object($find)){
, A+ P. G+ a4 I& N' v+ Z. K4 Cecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";0 }/ f; D4 k- @7 C
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], & Q- L' }- f# _7 S
0 k1 a5 C) ]& r: `
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], 7 z5 H* A" Y* F( F; }

( ^2 C% ^' a, m$ ][m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
+ ^0 {" J, Z9 ]
& v- g' J* `( H3 N1 pN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', $ _) ^6 c# }6 J& N3 ]6 n# V
- i8 |" R. e1 D; R  R& H
'{$ElementUpgrade}', '{$ItemPierce}');");
; j' A1 a/ ~& G% }% {$ r4 V}
8 a$ f% a: E8 c: O. N4 ^2 {' t' L9 o& D
}
: f0 |5 [9 T9 x- P- [" ^# K8 i, s; T% K
}( B: K! L1 S$ B
9 m! P( ^9 ^2 Q) j! L+ |; x; F( d
$InitForm = InitForm();
! g3 Z: C5 ?7 z& _6 f7 i$Listener = PostListener();  m  S) t, P) b
( c4 c) M, k! e, {
?>
& i& X0 o1 i8 j$ G, i
' g$ x& _: a3 u% W' d, m2 a! o# S& x

4 X4 v# \( u+ n2 r  @, H6 s. s
$ Q+ f0 E" Z$ I& V* T2 u" y9 Y




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