飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
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! l
Connect();
" 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 n
m_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# Z
N'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