飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
/ j% w& p# t8 f7 g+ B
function Connect () {
; P; Q+ s0 { O6 M# y( H7 w
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
" f% a& g3 }* j- V% i5 V1 g# a1 Y6 {
5 [& [$ A# `. x$ c8 U3 O
Failed.');
) E* Q; a9 d0 B0 u* l& g
}
( r7 m8 w: q) E7 \! `
Connect();
/ E8 f* [9 m* p1 h* ^) q
4 ?2 J. [5 g$ W8 w% F' t
function InitForm(){
' y$ w; e5 U& F. D& H1 S& Q
//layout for the form
, J% O+ h; i$ [/ w% n3 {1 }; D* o
echo "<strong>Send Items.</strong>
6 c1 j1 | P& C, f8 k! y) {7 K) h
<form name='select' method='post'>
/ C, v) l# h# t& U
<lable>Character Name</lable><br/>
4 Q6 U1 M% ?% ^2 U# u
<input type='text' name='char'/><br/>
+ _/ ?- ?* Y" ?6 d
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
! i2 x- a" l/ j& F$ Q( [
<input type='text' name='item_name'/><br/>
# a9 y2 d6 a+ w
<lable>Item Amount</lable><br/>
1 c0 m+ T4 {& M4 {
<input type='text' name='item_amount'/><br/>
* E0 C' y6 G+ o9 R2 y
<lable>Item Upgrade Amount</lable><br/>
6 N& F* a6 @- a7 ^6 K0 s9 R5 O4 t
<input type='text' name='item_upgrade'/><br/>
1 G5 [! n& B; i: ~' p5 G; C
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
: R: ]. H& S; m# S6 P6 ]* a& x
( e+ F t/ V/ o( j& F% R9 I$ T
</lable><br/>
[; T/ o4 i" Y; x" }. Q
<input type='text' name='item_element'/><br/>
7 P0 d; i3 S& E# u
<lable>Element Upgrade Amount</lable><br/>
& x, D! D+ Z" ~$ `* J& T+ A3 `
<input type='text' name='element_upgrade'/><br/>
8 [1 j5 v5 e2 m; F2 V9 H
<lable>Pierced Amount</lable><br/>
: P8 \) O, v% \4 z0 m
<input type='text' name='item_pierce'/><br/>
: X0 `% i8 {! G4 L2 J& W" k
<input type='submit'/>
' ^, B4 ~8 ?$ ^4 N3 V
</form>";
0 d+ a5 {5 X e) \
}
1 f& J9 P3 _5 K
4 m v% S4 y0 {5 P7 p2 Z
function PostListener (){
$ h$ q5 O0 Z9 Y5 J2 H
//Add more post variables if needed and add them to initform() function aswell
7 S) T' z3 w9 s. S
& a/ a9 ]! @0 ^/ D: a
################################
/ r/ u% e v: U: s, i; R
##### Connection and Post ######
, I* L) m$ k. ?5 ^1 j* P* I. r( A
################################
o$ G1 A% _( q& L1 t
$name = @$_POST['char'];
1 X. l& Y* ?: E* L/ P
$ItemName = @$_POST['item_name'];
- h' ]' o5 h9 T$ I: K- r( U
$ItemAmount = @$_POST['item_amount'];
5 H+ i. e/ E9 m \* {; ]& E
$ItemId = @$_POST['item_id'];
2 w3 S6 ], m: x5 `
$ItemUpgrade = @$_POST['item_upgrade'];
- ^! e2 E6 H9 I' z0 M6 K* c/ N0 ~
$ItemElement = @$_POST['item_element'];
5 ~/ o9 f5 F- }* \* {* Q E
$ElementUpgrade = @$_POST['element_upgrade'];
5 Y( s% }& h) r6 n H8 X+ s
$ItemPierce = @$_POST['item_pierce'];
$ h) ?# t1 J1 c7 Z
################################
4 J3 [7 c' v3 ?7 O- ]0 ?+ E* `+ {
7 w( l4 B2 b& A4 a; Z
//Check both variables for empty value
! x. h6 ^5 t2 U) i6 z( K
" i0 Z0 [% R- C/ [. P$ C. h p) J
if (!empty($_POST['char'])){
# p- x0 m/ b$ L
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
5 m% {+ n/ f0 I
/ f7 r; i1 ?! D; V! M
m_szName = '{$name}'");
3 | e" N8 P9 O# d% m4 G
while ($row = mssql_fetch_object($find)){
$ E0 ?4 J8 H3 p& M. C# x
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
9 i4 B( n ?7 a9 G
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
" A( g R" e e% j! v; Z
" E4 i8 m' K$ f, y. Z
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
9 D9 n! K$ I- K3 b' o
* ^- {7 I2 J$ `% Y8 {( }
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
7 c8 p `: n4 o# T* S! V3 y; U
- g2 {7 Y6 Y8 n3 l: @' h
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
5 `3 |; w" r; m
7 j) k& o# n( G
'{$ElementUpgrade}', '{$ItemPierce}');");
: J& H' p6 M9 F. V' Q. Q
}
6 v$ \' Z3 Y$ X8 b o- s
9 Q( {2 U5 x/ g
}
/ Y0 W- [/ l3 f# F
1 g. x' W+ E. M2 }# j
}
2 d! `8 k9 j6 }- X+ P0 ]! k) }
. n/ m7 Y0 n. [
$InitForm = InitForm();
5 ^7 r- f! D$ W' n1 s
$Listener = PostListener();
" c+ T" e$ r* Y# D& _
+ K% C( y; G+ v7 h" v( Z
?>
. u6 }+ Z4 u3 W8 n3 n! X& E
+ n4 ?! o; R/ n% m
2 \5 _3 y8 q8 u* b& I; a x( j
E% G1 i5 ]% E* q) R
0 F" t; b& Q" [6 C% ]/ d
欢迎光临 飞飞世界论坛 (http://ffwold.com/)
Powered by Discuz! X3.2