飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
" K% T& h9 t' d- X U
function Connect () {
/ T- Z" ?; M4 w z6 i' S7 i
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
' h8 R! S, d' ]$ c
" m( R0 s0 h! P6 K
Failed.');
; ?1 s+ P) o3 y/ t& z2 [& i2 I) s1 `
}
: c' X8 V2 b |' p) f
Connect();
' {" T" o+ g9 [% p* v. E& U8 U
# g: H6 v7 x# R. z
function InitForm(){
Z1 u; U+ H! f0 o6 a9 s) I3 ^ \
//layout for the form
6 k9 N/ a% G* v3 n1 Q: u/ _* g8 W) K
echo "<strong>Send Items.</strong>
- |' X: F& x7 j4 D* p
<form name='select' method='post'>
. L( e# [7 G& ?. k( T m9 \
<lable>Character Name</lable><br/>
U. ?6 k% Y( M$ |8 p7 T4 F
<input type='text' name='char'/><br/>
, K+ C1 T$ T$ Z7 m* z, o }, |
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
7 A" C8 R! I9 x/ I
<input type='text' name='item_name'/><br/>
2 _7 ]! D6 W7 H3 }
<lable>Item Amount</lable><br/>
* }9 H3 ^6 d6 K1 j8 [
<input type='text' name='item_amount'/><br/>
/ H4 w) P. Q7 Q9 ?7 y
<lable>Item Upgrade Amount</lable><br/>
: P5 u2 T" _# I B C Y
<input type='text' name='item_upgrade'/><br/>
* B, P4 b3 h5 h1 C, `$ E
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
2 `: Y/ a5 a# d6 B. L5 {- c
0 S+ g3 c+ w2 T# d. n* q& d3 o" @- o
</lable><br/>
p+ @+ `, W# Y# Q$ Y- T
<input type='text' name='item_element'/><br/>
, x9 k* X+ l/ C, ~( z5 e# R& U
<lable>Element Upgrade Amount</lable><br/>
+ X! I& }$ D3 S8 P# F
<input type='text' name='element_upgrade'/><br/>
: {/ K8 ~7 t5 \# D# |: U' g w& J5 i
<lable>Pierced Amount</lable><br/>
* l8 M7 E: l. n% O. i0 M8 j
<input type='text' name='item_pierce'/><br/>
/ k" h" d; K) _9 a- L2 O6 Y
<input type='submit'/>
" ^% |6 x/ E. w9 P
</form>";
6 ]2 |* I* ~$ @ H$ s
}
% p' n/ K9 M# _' e% H" J
# W3 D* ~5 ] h6 C$ k4 A
function PostListener (){
0 `$ [% x# L' x* p7 `& Q1 @
//Add more post variables if needed and add them to initform() function aswell
; @1 J: T, U5 R2 o' c# c
& E1 y: w3 z1 I3 K1 s
################################
, @, x" L6 q1 x- c
##### Connection and Post ######
/ ~ U. u4 [# C7 ]) K/ |! y7 q. L
################################
# N3 D, E& W5 Q& M1 m7 B" [
$name = @$_POST['char'];
( G) A2 v: w X7 x
$ItemName = @$_POST['item_name'];
0 s6 O. d6 E( Z5 D W
$ItemAmount = @$_POST['item_amount'];
3 l( a e! ~- B3 G1 L* `( F
$ItemId = @$_POST['item_id'];
5 L2 u( ^; F* g: }
$ItemUpgrade = @$_POST['item_upgrade'];
- ~: g9 x) J# ?1 ]: ?
$ItemElement = @$_POST['item_element'];
( S, F0 l5 u. B- f
$ElementUpgrade = @$_POST['element_upgrade'];
W* o" X: b2 R! \2 K; N
$ItemPierce = @$_POST['item_pierce'];
' g* q- e! N/ o$ I8 V9 B
################################
! {" O( i! E% n0 p
( G* R2 p R! n# F& @* D
//Check both variables for empty value
2 `$ B% |3 p k% | `9 }! `$ c
/ |- b+ ]$ ]5 m6 W8 L: k
if (!empty($_POST['char'])){
' G6 k% n; O3 m9 ]5 ^8 R5 o
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
2 x0 D" W# x0 N* W7 M
0 i- {3 \4 e/ D' N1 N
m_szName = '{$name}'");
+ K) G( k- s A7 C: M) p
while ($row = mssql_fetch_object($find)){
- t. a5 L; ?& i3 m, o* L- ^
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
" F1 I6 v4 ?& D" U
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
M" w$ Y2 S+ v: }6 m
* |1 G$ ?+ g) b2 D; q) o% j4 i
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
) }+ P5 f$ X5 f& f: [2 l" n
2 P* z* i6 f8 E7 S# f+ F
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
. n2 s: w2 I/ a) B# b
! T$ e$ E- i& E- {! x: U: X' C
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
' s, w* T4 Y6 u5 t
9 [8 N7 r9 e+ V( L
'{$ElementUpgrade}', '{$ItemPierce}');");
' v- W0 ^8 a, p; U
}
& b$ _2 d, G% W3 |5 z! o& \2 K
/ T, e T! R; n
}
) n1 ^* u9 w2 I$ i3 n( \
! `0 m! W- u* \8 [( h5 s' y
}
2 Z4 L3 Y& i! z6 ]4 b
S4 O8 n5 `$ a
$InitForm = InitForm();
) {$ j' B; [$ m8 Y- Z, Q, L
$Listener = PostListener();
3 L' ] a$ ]4 d+ P N1 |) A% J
. F, Y- z4 J, y& }! w( h3 N
?>
5 V, ^* Z+ b% y, r2 }
) X" G7 ]7 w# ^+ N+ n
) h- C" G# Q, y+ A4 W! } Y7 N
3 Z( v3 _" n0 [3 U
/ I4 L% C& ]2 i) X: Z2 I/ _5 Y
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2