飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
! U, a& i# A% k. f0 Q
function Connect () {
0 X6 u3 o& C; `
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
& c0 |$ \, ~1 ^; s8 ]8 e
$ G& c+ {3 x# e! {1 B4 W( e% U
Failed.');
: J0 x* G: r. Q1 f3 k; ]
}
3 ~- Z) P3 W$ K' E6 U% V
Connect();
) q' ] K- N3 h8 S$ b7 E
1 N% O6 S8 D% L+ P+ ^) m; L5 v
function InitForm(){
9 l. D' C" O( \$ g/ O/ |: i5 R
//layout for the form
9 l: m' T6 H, i( Y5 l; Q, }- D; E
echo "<strong>Send Items.</strong>
- X4 L$ Z8 z5 [9 ?: n* l
<form name='select' method='post'>
' U, `" |* V! t
<lable>Character Name</lable><br/>
# a4 B* A$ \' v* D7 m2 n: K
<input type='text' name='char'/><br/>
) M+ e3 S) S n6 k% f9 X# I
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
; z6 V% A/ x) V M1 S: I" v
<input type='text' name='item_name'/><br/>
4 w% I# L, i8 J# _/ v3 J
<lable>Item Amount</lable><br/>
& t' `* h, Y: Q
<input type='text' name='item_amount'/><br/>
% V8 Y& _3 w3 ~; w
<lable>Item Upgrade Amount</lable><br/>
: c8 [7 u, G5 k1 R( `- i* U* r
<input type='text' name='item_upgrade'/><br/>
. P% |; j8 y! v' _
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
6 [9 Z( ]; j7 f( c
8 e+ g7 `0 ~$ E
</lable><br/>
' }% P8 {1 U" W8 |( k) m
<input type='text' name='item_element'/><br/>
( G" W. F$ l; A9 J
<lable>Element Upgrade Amount</lable><br/>
/ ]# C, T2 {+ _! A- N
<input type='text' name='element_upgrade'/><br/>
$ s' {% ]7 Q) T2 ~
<lable>Pierced Amount</lable><br/>
: A; C- C y1 D+ {1 Q3 X! Q
<input type='text' name='item_pierce'/><br/>
4 y. T) d* x0 }' ?* J5 `8 U
<input type='submit'/>
. z( g6 o/ f1 h& t6 D: E
</form>";
5 O3 \5 L; U- l: m+ a
}
& f% V& N3 @" t4 `
7 |* l3 n5 F5 v6 b
function PostListener (){
* D' H8 K1 T) `" ^; I6 W
//Add more post variables if needed and add them to initform() function aswell
, X+ B% @# U0 A, X. r
+ v& A" q R* ^# q+ b4 o! S9 u
################################
: H) p" t% J2 e- o8 f
##### Connection and Post ######
8 _) G3 P! Z- x, z
################################
& q( I% x3 O. s
$name = @$_POST['char'];
8 N5 j* {" [, y* Q1 w! x$ U
$ItemName = @$_POST['item_name'];
9 ?% ]' q# t2 C$ ^$ G3 R& P+ P
$ItemAmount = @$_POST['item_amount'];
4 `3 O1 V4 l9 Y$ d! b O6 H
$ItemId = @$_POST['item_id'];
8 f) _ s* E+ \; D" Y# y
$ItemUpgrade = @$_POST['item_upgrade'];
& W4 t% U" u j q
$ItemElement = @$_POST['item_element'];
" K- X/ Q" u1 x* A; ?+ J8 K
$ElementUpgrade = @$_POST['element_upgrade'];
' X' p/ ]2 @3 R: z+ o* R
$ItemPierce = @$_POST['item_pierce'];
" ?- s2 l9 W' O8 t
################################
& y! O, X4 J* s9 E+ P1 `
. a0 O0 F! ?7 p- h4 r6 j
//Check both variables for empty value
, N) ~- N( q+ b8 \4 ~
* h6 \9 z9 i. C5 R; y+ a
if (!empty($_POST['char'])){
! M+ n7 z5 M5 T3 }
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
, v6 S; J! y" h0 `/ O5 |" S
) x) }2 Q) d$ G) u
m_szName = '{$name}'");
7 s) z' W! J' T, p! Y
while ($row = mssql_fetch_object($find)){
! S Q* _, F* N% ?
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
: a# ^6 z/ C! x& `8 P
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
' ~0 I4 g4 E' T
V' \; E9 U% E0 |
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
! E) h4 U' @! ^ c! n3 R
9 J7 X( K, p" Q7 P6 Y
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
* w r8 W& q! r; Z0 ]
. K2 m8 U/ \# }$ l4 r) U5 e
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
; X0 F; Y* t% D
$ e( ]2 K$ u3 H+ M' H4 n9 z
'{$ElementUpgrade}', '{$ItemPierce}');");
, ?% L. y+ _! x; @ q
}
: C2 e+ P4 P$ H
1 K" ?& t2 o" Y) p; g
}
9 [0 S+ U; Y. r! t9 f
! T" S/ F3 a0 h. L0 c% e
}
8 i. k% ]+ q# U
- v# t( e. _/ [. m- J; Q+ j
$InitForm = InitForm();
6 p) e; J# X8 U. g- D+ E
$Listener = PostListener();
- h8 z9 B. S' j3 P+ g- k3 X
: _0 O- n0 E: }! U
?>
6 R1 F+ `( L) q( q) W
4 x3 n5 _- X1 t+ v& m8 O
% [. O2 m5 E2 F. @
# |+ L5 m1 _5 f1 b
' Z% X9 g2 m) j( o
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2