飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
/ @" M/ \/ v$ T' q8 |0 s
function Connect () {
' |# T5 i, j8 B3 C
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
- e, ]1 j9 S9 N1 j* b
/ p7 T: e" K& L2 Y) g9 Z3 M
Failed.');
% X3 e2 m" E( J
}
' ^1 z+ i" U1 `; K9 W1 b/ g/ _
Connect();
/ [9 z, B% m9 j3 E9 ~
6 e$ ^2 z$ e8 T2 q1 i& Q! B2 w
function InitForm(){
6 o; i' u& w0 t3 u3 |
//layout for the form
0 p& ~( m8 } }
echo "<strong>Send Items.</strong>
6 P3 K! J0 B' }7 Q1 y
<form name='select' method='post'>
& i( O6 R. t; w4 o1 U/ O
<lable>Character Name</lable><br/>
) P; m$ @* M2 M2 `( h$ K
<input type='text' name='char'/><br/>
% p- v; p$ ^. B4 V: ^- `& [
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
& J( N. B" } R1 i7 V* O4 U
<input type='text' name='item_name'/><br/>
- b' _( V9 o$ j
<lable>Item Amount</lable><br/>
9 B7 i2 L- W& S9 d
<input type='text' name='item_amount'/><br/>
% m, Q5 {( y3 F
<lable>Item Upgrade Amount</lable><br/>
! I) t0 p. X8 b9 u. c
<input type='text' name='item_upgrade'/><br/>
0 d- K" d3 A5 f7 o
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
" K1 H7 m# C4 r: e1 [
+ g+ `8 t; T3 q6 M1 e# z) _
</lable><br/>
8 O) S7 B* J" Z
<input type='text' name='item_element'/><br/>
3 p' z" [( g" b6 r& J; d
<lable>Element Upgrade Amount</lable><br/>
. a( ]: v2 J+ l8 V, u, ?
<input type='text' name='element_upgrade'/><br/>
- j$ i8 Q2 n/ Q4 O! j6 V2 |
<lable>Pierced Amount</lable><br/>
* B2 |/ k8 m6 p4 K6 F5 N
<input type='text' name='item_pierce'/><br/>
& N! p6 X) ]6 T1 O/ x
<input type='submit'/>
. z! X" K, q0 v
</form>";
/ M$ w$ R3 J% x: c# T3 m8 c
}
) z& A& v+ H& l( [' }2 N
+ Y8 |9 d. l/ Z- N
function PostListener (){
) V' X! ~6 I' e+ t, g
//Add more post variables if needed and add them to initform() function aswell
8 H: L# A: V2 {; s: ?- `
3 g, v6 T b, I, E- }
################################
/ K ~$ k+ Z$ u) S
##### Connection and Post ######
" A# H- r2 K& r4 V4 r2 V! G# n
################################
6 n! O: [, M- ]8 x- {( l M
$name = @$_POST['char'];
. b1 C @7 r' m6 t; @- A
$ItemName = @$_POST['item_name'];
& w. W8 J- u, A% Q, U: f
$ItemAmount = @$_POST['item_amount'];
, G: A k! w$ i2 R
$ItemId = @$_POST['item_id'];
! ]. J1 Q- H. D6 C; o
$ItemUpgrade = @$_POST['item_upgrade'];
; e8 |* A; [+ h6 ~5 z2 Z M) b
$ItemElement = @$_POST['item_element'];
P0 |: H$ ^# C7 M* ^/ Z
$ElementUpgrade = @$_POST['element_upgrade'];
4 [% C' m4 } o ^9 `
$ItemPierce = @$_POST['item_pierce'];
5 O6 s P$ T4 g& E" u; E, x" A
################################
7 |6 w/ g( C& {6 R- S
" v& p2 J5 A; @. d
//Check both variables for empty value
/ r2 h8 G0 t7 @5 B r
% `3 d1 F( U9 l8 W* Y6 p9 I1 u9 L
if (!empty($_POST['char'])){
4 R" v R; w" p2 M. U3 v8 Y
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
8 v; B/ w- z9 B6 [
3 V! V/ h- ]8 T2 P3 i
m_szName = '{$name}'");
2 R+ T8 ]8 ~" d$ A1 |7 [
while ($row = mssql_fetch_object($find)){
8 D9 V0 B+ X* y9 z; |- k$ y4 i" _
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
4 N1 _9 j0 p9 c- y: Z i
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
# b- a4 M# U$ l/ B) [+ @
0 X4 q q/ B3 L+ B3 V7 K3 e, L
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
9 a: N: b+ H4 ^
; q0 \! I/ y3 o% h/ ]7 N8 F
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
" Z- l$ T5 E' [% H5 t0 C$ S0 r F
; k" u; o4 t) A- w6 }
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
# S3 p1 F- V/ {( }2 P8 Y, l
, \1 { ?( f$ ]% n- R
'{$ElementUpgrade}', '{$ItemPierce}');");
/ f2 v2 r- z1 C- w+ i
}
/ v% x- _% i) x) n Z! h
5 g: D$ t; w9 P; w: O
}
% I# }, X5 W! I
% [; x* m4 q; K
}
7 i1 Q1 t0 i' P; k$ _+ I
# f% }8 }4 f" S3 w) _9 h4 a" _" E- l
$InitForm = InitForm();
5 E- ^* v. h" {, f* i8 e
$Listener = PostListener();
" o! e+ E4 J- @ M& N& t
: s9 X0 y, n( y& S
?>
. s3 i3 g# N; p$ T. _/ t+ g1 N8 d$ [
5 w3 u! T0 R1 I* @! Y1 g9 M' w0 y
$ L( J9 Z% X3 a- t
: q# t0 L- y2 j* d b
; M& F* P5 l. H" R* S3 `) r0 P2 ?0 s3 H
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2