飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
3 n: W" b5 _9 k' e
function Connect () {
) Y& ]" E6 H5 [/ z" Y
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
1 R1 F% b& X) y: c' y
" E; ?0 p- h+ g" W& p
Failed.');
1 p5 P5 b7 A) J7 v. q# p1 M
}
* Q7 Q4 r" Q7 S4 r) V* C/ z* {3 x
Connect();
! \" L8 h8 {* u1 G% G
6 W4 ]- k5 T; H4 q8 t @
function InitForm(){
) f; E$ s1 u+ t/ @$ i1 u
//layout for the form
0 L8 N5 ]6 N3 v9 v5 G. a
echo "<strong>Send Items.</strong>
) S/ h c1 h# W& Y$ V. o# {& V7 ~, w
<form name='select' method='post'>
' Z5 o$ L' u: m% @
<lable>Character Name</lable><br/>
7 q- `, M7 @& Z3 w" r$ Q
<input type='text' name='char'/><br/>
/ j; t2 f7 g% p; z0 u$ g' t8 W
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
8 K% a. n' ^7 D/ v
<input type='text' name='item_name'/><br/>
% B& k0 z7 E$ c# V7 ^5 U& }0 v
<lable>Item Amount</lable><br/>
5 @0 m' ~4 D- M; N, G& D- R; u; i
<input type='text' name='item_amount'/><br/>
" E0 |0 O, o! X1 L8 h
<lable>Item Upgrade Amount</lable><br/>
' p3 I: D# |# m" w# ~
<input type='text' name='item_upgrade'/><br/>
: e5 N Y, `1 u* w1 V$ Y
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
+ H3 m4 R1 ^( S& I8 M
: X7 O, |% b, Z h: F
</lable><br/>
! \2 z( m4 k1 `" Y, v e) G
<input type='text' name='item_element'/><br/>
" o. ?% t5 g7 H7 N, q! M
<lable>Element Upgrade Amount</lable><br/>
3 t' f) S6 z" c! C0 Y" G6 ~
<input type='text' name='element_upgrade'/><br/>
* x) Q5 X8 g" g! n- [: e
<lable>Pierced Amount</lable><br/>
8 m# a" w7 M) q) |3 l8 c1 w, r9 F
<input type='text' name='item_pierce'/><br/>
8 h, L! E1 v$ b- U& g
<input type='submit'/>
/ S& V5 \1 ^% \& ?* s) P8 X; @
</form>";
. z3 t Z) \7 Z% h
}
- w1 f; ]: _4 g% P4 l
. o0 e0 @ K; M% V9 s ]
function PostListener (){
1 O# q* P) T& s) g X& U; Y4 w: j
//Add more post variables if needed and add them to initform() function aswell
+ K% J& a5 Q7 u6 i
2 X& N( r2 ]2 ~0 \$ t* d! l
################################
* F+ g. I8 z% L& J! k6 q* x
##### Connection and Post ######
( g& R5 p, G8 R; ~' T) D
################################
* E6 s4 L; @, f. P, t
$name = @$_POST['char'];
B6 g: p. t! \. Q4 q2 V
$ItemName = @$_POST['item_name'];
6 L. O8 t8 B: b2 M8 E' X8 d
$ItemAmount = @$_POST['item_amount'];
s" | |. Q l* q- e1 d# Y9 c
$ItemId = @$_POST['item_id'];
& ~2 W* h# C |5 |. G" X
$ItemUpgrade = @$_POST['item_upgrade'];
3 i+ ?; D7 Y3 O2 N F8 b' z. _
$ItemElement = @$_POST['item_element'];
$ ^- h1 g n/ o! l. z, q
$ElementUpgrade = @$_POST['element_upgrade'];
4 E/ M5 T4 N! j( W
$ItemPierce = @$_POST['item_pierce'];
% `: P" N% D; I4 E* |( l: A
################################
0 v: _5 A# w4 c2 q3 }
0 u- f# g' B, ~! }) _6 U7 M* }
//Check both variables for empty value
' L7 H% S: M2 Z6 {8 i+ S
( V, b+ h0 I$ L' [
if (!empty($_POST['char'])){
: T* l7 F2 o1 Y) K$ Z) d# }- B( U
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
! @ M: G- T# |
2 a! I( k- u2 c
m_szName = '{$name}'");
# \; d1 z! q" L) g+ i5 I
while ($row = mssql_fetch_object($find)){
; W, a7 D ^; R
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
7 ]% M* {" P. R1 d8 v v2 e
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
; j' E; G s0 O% G% w5 Y& M: J
5 h; n9 B& }8 [
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
: \+ Z# Z( z& T, c4 ^ I# P
# `* Y0 F V% _) H' G% F1 [
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
- m* w, o& @2 C e0 W2 E
+ K+ F3 e9 h7 g% i
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
( {0 C; e8 a8 b' O
i2 |# O" P3 i6 R/ ~. E
'{$ElementUpgrade}', '{$ItemPierce}');");
+ b& U" R+ d/ R& c, z
}
% l$ m/ B& T& @0 u$ G
6 U: S, s# r' ], }. ]6 y
}
8 T+ k: F* N( ^
+ K5 u' h1 m! ?/ s
}
2 J6 `8 P5 F/ d1 j) Q
1 j) p: @7 D6 \9 z9 k# K; r% B3 U) @
$InitForm = InitForm();
) u) x5 _# v7 Y; }& c/ ^
$Listener = PostListener();
! d- d2 \ _4 ]9 a; J3 t
. e5 D( _4 Z1 S% o
?>
3 ?& A* |- E9 b. V9 N
- Q3 h" T1 M- H4 F7 s7 m6 }
2 q7 a2 L! m% d2 }. k( |' \8 u& y
) R, x3 R+ N* [! _3 e
. O3 R+ m7 ]* B* V4 X4 b9 i! \
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2