飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
2 K5 K! y( ^/ g8 I( M% d- [
function Connect () {
; @$ {; O- z* E& W( T8 c
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
8 O/ q2 ^' t: Z+ e* Z* Y
b# n/ m* t% O" I
Failed.');
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 Z
function InitForm(){
2 |9 u: h+ t1 X6 j0 }) z& n7 j% `
//layout for the form
8 G, }. I$ e+ i0 p$ |! n/ ?7 d
echo "<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. j
function 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 G
echo "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 |& x
N'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