飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
% _8 J. n' P e, W, a5 j
function Connect () {
) M+ a4 D0 ^* [* o- v
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
3 R; b/ x v9 Z2 c6 a1 P4 L% G
8 o: N- e( z% V" e9 ^
Failed.');
4 j& j- A6 Q& J% G
}
3 ~' G! [3 d+ v
Connect();
0 W; `, W" b* G! W8 [. f) z, O
& q( B* A: V5 L
function InitForm(){
3 k/ J! V1 }: w- J; K8 w5 ?; A0 J
//layout for the form
# {7 M/ W! o' w6 D
echo "<strong>Send Items.</strong>
" @- g% x# r3 E/ g, ^
<form name='select' method='post'>
& ?( ~9 a1 A' B( P
<lable>Character Name</lable><br/>
; R2 n) z$ v! I7 I: |1 H
<input type='text' name='char'/><br/>
! }$ l; t6 K% V4 d$ z
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
7 p& I- W7 T2 N# F w: b/ J
<input type='text' name='item_name'/><br/>
0 @1 \' X& A6 I* ~* x
<lable>Item Amount</lable><br/>
/ m4 m; Q& P6 s* q
<input type='text' name='item_amount'/><br/>
4 k4 O6 i; R' [( y
<lable>Item Upgrade Amount</lable><br/>
2 J1 f/ z2 |, U& ~" \$ c, V
<input type='text' name='item_upgrade'/><br/>
/ Y2 E; ^7 n, @& g
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
4 V* w1 o+ x0 H0 }0 [6 g
o8 r, c- N _$ M0 _6 f
</lable><br/>
* X% b: l5 A, U+ a: |4 a
<input type='text' name='item_element'/><br/>
: g# f, `& L. P
<lable>Element Upgrade Amount</lable><br/>
5 k( s# e7 P& H6 F
<input type='text' name='element_upgrade'/><br/>
1 E) J/ I, D2 o; a2 x& q0 ^4 m6 A
<lable>Pierced Amount</lable><br/>
2 |+ n' |$ f# @; i- _$ e
<input type='text' name='item_pierce'/><br/>
; h) i! A+ }3 h- Y5 l, g
<input type='submit'/>
3 H3 c1 Q' Y( K: S6 \
</form>";
+ b8 S) X2 ^# \) `3 t
}
1 W" |; K7 U" {# Q9 L' m* k( H
( _1 R% }) F" W9 L5 E- ?2 v2 A
function PostListener (){
% ~ U2 G# B( K/ ~$ M, ~: L7 o
//Add more post variables if needed and add them to initform() function aswell
g# j0 l- s5 Y' C8 v% A
6 Z# K# s/ Q }8 I' q
################################
) E/ ^% O1 f1 c. M# q5 T/ Y
##### Connection and Post ######
; p! T' j5 ]+ e& C- l W
################################
7 r& S2 y3 L1 E. |! _- C
$name = @$_POST['char'];
1 H- s( v3 p. I! `% C
$ItemName = @$_POST['item_name'];
% Z! r; F3 A4 B6 F
$ItemAmount = @$_POST['item_amount'];
7 g6 R" K7 q1 D$ o9 Z
$ItemId = @$_POST['item_id'];
' }9 Z; s e: j8 Q" D: a& N
$ItemUpgrade = @$_POST['item_upgrade'];
4 _! K' `! Z" D8 J& Q
$ItemElement = @$_POST['item_element'];
# d( L, m/ b! C1 _. u; n
$ElementUpgrade = @$_POST['element_upgrade'];
7 ?- h1 g! D5 B$ N
$ItemPierce = @$_POST['item_pierce'];
6 @6 x6 @1 G5 X+ W3 w s
################################
- @# S! \# ?/ H$ k* M5 H" M
; J3 E1 W# x! o$ ?7 D3 H
//Check both variables for empty value
% w. f2 ~" [0 F+ E
) g) A4 a( g7 C' v0 l
if (!empty($_POST['char'])){
3 S0 p3 o- D* S8 m
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
6 R; R* T6 |( [. A5 ?% u% l
# k6 ^' q$ I" m1 Z; |6 u! ^5 r
m_szName = '{$name}'");
6 |8 i/ r/ x. C
while ($row = mssql_fetch_object($find)){
( A4 T; h2 [! b) t* U5 Y
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
a) ]$ ]. O; t, o; n; T
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
1 b& m" {; ?# o2 s) z$ L3 e j
# e9 ^+ F- A; `& _3 {; O6 Z# g
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
2 r; x! M! r3 |7 X |# Z9 `
2 }- E9 B4 k: z. W
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
6 H& d# i2 s$ F0 m5 N3 p
5 S+ O8 i! |1 i0 Y) ? Z
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
! I- x/ ^, Q4 Q+ ^' w+ X [& r
- d7 S+ Y! O9 T2 H
'{$ElementUpgrade}', '{$ItemPierce}');");
6 N' s1 { ~7 j5 S& S8 }& n
}
3 B- F- u* u _& F8 e! H
0 u S/ q" v: {: Y& Y8 Y
}
; f' t5 n# T2 e8 }6 S9 [
- W2 q' B4 A+ U( g3 U
}
; q5 \( T) p1 l& D8 _1 P8 I. l7 p
" m$ a& e# o! w
$InitForm = InitForm();
6 L0 K( B# }" R3 j
$Listener = PostListener();
6 K: J6 i* R/ n( w& s# B$ n
( S# p- t- r7 u1 x8 u
?>
5 A# l& K; x) ^- @* {
% m% k+ z7 r# K8 q/ p
6 |/ }9 {$ E6 Q& I3 C
6 L. h; x6 r% B: f- ~& ]
. U3 ?8 ?0 G, q8 h8 x1 a# }5 p& |* M
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2