飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
! T% Q) {2 L, b. G- M; b
function Connect () {
4 K6 h1 h f; n$ R& c
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
0 a w: e" P, V& @& z
2 w7 R& g/ ~# G/ ^8 A% H/ q
Failed.');
9 M7 J9 Q! d2 c# M* \9 \6 W
}
! B1 p2 H0 y' V+ i* Z; G' E6 x* ^
Connect();
. [ ^ F' G2 h4 M: ]4 o
5 E: f5 T0 q2 D ~8 L
function InitForm(){
+ U* v2 p$ p, q5 Q6 l
//layout for the form
# f5 h/ `* R1 x
echo "<strong>Send Items.</strong>
0 T# C3 a" r3 B( W" f
<form name='select' method='post'>
5 _6 F/ `) O7 ^$ h/ z% |
<lable>Character Name</lable><br/>
. |" b4 b6 k" U: g1 @ e! [( R, g3 Z! Z
<input type='text' name='char'/><br/>
- E+ P$ \" Z* |5 q: J0 e( `
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
; v1 {, J# _* b# K/ j
<input type='text' name='item_name'/><br/>
: b2 ]$ h1 e$ B9 N
<lable>Item Amount</lable><br/>
/ M% \: \' u; h- _" I- r7 c1 y
<input type='text' name='item_amount'/><br/>
. i' t8 p1 H; P3 N
<lable>Item Upgrade Amount</lable><br/>
$ W* \* w7 \- Z: D' y: ^! S
<input type='text' name='item_upgrade'/><br/>
% @9 V! y) q9 q
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
* _5 f0 r1 i8 H# {: q2 }
' w+ P3 u- n8 Z; i' j0 w
</lable><br/>
1 m- o8 ^7 a1 ]7 k
<input type='text' name='item_element'/><br/>
9 r! j5 \; }2 ?/ E
<lable>Element Upgrade Amount</lable><br/>
, y* o7 S- }: A$ v
<input type='text' name='element_upgrade'/><br/>
) Z2 K7 J* a0 R* Y( P, |
<lable>Pierced Amount</lable><br/>
3 C0 R4 X# K3 q2 y# e
<input type='text' name='item_pierce'/><br/>
; T/ F# w" }& y5 ]
<input type='submit'/>
: C/ D4 V8 k% O9 w* \0 e
</form>";
! m1 D# R* R7 B1 N- x$ b
}
5 S. t5 E' g) ]
* P3 l& p3 s+ [( B! U
function PostListener (){
0 d: H- G; J6 g5 x9 j
//Add more post variables if needed and add them to initform() function aswell
! S! P4 N; l x; o+ H. Q) e
! O5 M2 J3 G: [0 m
################################
* g0 `: @" c2 ~& Z7 t3 ~ c& {
##### Connection and Post ######
! b2 D$ V! Q$ Q; x
################################
. F9 n g/ j- Q7 S7 X
$name = @$_POST['char'];
: V: b' U' n2 W; `. F9 z; @
$ItemName = @$_POST['item_name'];
+ h" u4 j% G- } v }8 w
$ItemAmount = @$_POST['item_amount'];
$ p4 @' b% d; j4 {. F8 g4 i
$ItemId = @$_POST['item_id'];
- M9 P6 T( m! [, b! `2 J; ]- F
$ItemUpgrade = @$_POST['item_upgrade'];
) R% a+ p/ h5 }
$ItemElement = @$_POST['item_element'];
) h U8 l8 ?8 o0 e+ P) `
$ElementUpgrade = @$_POST['element_upgrade'];
. N8 s) K2 N3 j' l+ L! n
$ItemPierce = @$_POST['item_pierce'];
7 p' ^4 R1 Z) \: }- J
################################
( x/ [ K6 i1 Y% P& x
" }* s0 X* a. E+ S2 x
//Check both variables for empty value
f9 P1 ]. _8 m/ U3 L+ y3 k
! c8 D5 ~) F9 o
if (!empty($_POST['char'])){
, q, @& |2 L% e/ r# ^, H8 ^
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
& l$ c1 S% S; j4 Y+ _% t: Q) K
$ i! a: `7 s/ H, g
m_szName = '{$name}'");
' \- e8 v9 L$ N1 v+ z# m. d
while ($row = mssql_fetch_object($find)){
, a5 ^3 |6 C# i8 r2 h
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
/ [# d- V @% s5 X
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
4 g6 K; z8 {5 ]% T; n/ P4 k
2 a) Y$ Z' n% {9 k# x( e2 u
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
, [- R/ o% E; u" g+ t( J6 O
/ E1 T [* Z E) V: i0 g W
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
( H$ a- F$ [8 q5 c$ \5 d. N- a5 m
; N8 e7 J6 D7 I7 }; M4 l8 m" T
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
& j4 P/ P" v: @ C1 V6 y6 z
; p! c4 X1 q. n
'{$ElementUpgrade}', '{$ItemPierce}');");
9 F X }0 h6 A0 e0 q) Z! G
}
- {* u. [+ h/ N7 y; H% ~
- ]8 x! ^/ x6 x
}
. {" J, A9 |: j
* P9 ^0 v$ P: K! h7 m8 }7 A6 Q
}
- R. i% E& T' v' g" r$ `
8 p& H; G9 J" I
$InitForm = InitForm();
& k w G% g& x) n8 k( m# t8 g
$Listener = PostListener();
6 x" Q2 c9 h% c% y! N
. Q; n2 U! L3 n. }6 l9 u$ Y
?>
' l5 V! p* T9 V. Q. j5 z
# F. v( E8 p6 L( r: i
' \' n) S4 ]# i7 C) i
7 s; C/ I2 T4 k1 }' j
& g" `) g. p7 T* o7 f" X, t
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2