飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
: P( I0 w1 Z7 p% @5 B
function Connect () {
. N2 Q- t X5 w' T' T1 z
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
/ n: D0 n2 w3 @% E5 F* I: i
9 Y3 W, s- k3 ~' A& M
Failed.');
3 }2 Q% s8 e1 ]8 A" ~
}
( z% D# H6 n6 V
Connect();
' _. E2 T2 s5 X+ d9 Z+ B9 M
$ L2 a' a) L; W! x( e
function InitForm(){
' r$ e4 u! O( b
//layout for the form
7 i+ m1 C0 y, N: p. e
echo "<strong>Send Items.</strong>
& l& o, L v- {7 Q
<form name='select' method='post'>
9 U# t Q+ p% H
<lable>Character Name</lable><br/>
* n: Z) H. _# Q: z8 ]
<input type='text' name='char'/><br/>
/ [3 ]! v7 G# r9 r; D- L
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
9 M- {7 A. N; V( p; a
<input type='text' name='item_name'/><br/>
3 t, u5 g/ N8 q& |: K* s
<lable>Item Amount</lable><br/>
6 S+ p4 [% A, Z0 G% Z# j9 ]
<input type='text' name='item_amount'/><br/>
; T) w5 h3 \/ w; l
<lable>Item Upgrade Amount</lable><br/>
7 m& o- L# n0 ~+ R ~
<input type='text' name='item_upgrade'/><br/>
7 o; C: f3 @4 i% I) s/ W0 H. [
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
F: ^$ g4 {5 R3 f2 I) m( M' D
7 W" f1 W, {6 U- I
</lable><br/>
3 I7 i8 d& e3 I9 e
<input type='text' name='item_element'/><br/>
7 W# Q8 B( R$ J1 e! D$ K
<lable>Element Upgrade Amount</lable><br/>
% A: S. _2 G* Z! L) Z% r
<input type='text' name='element_upgrade'/><br/>
( Y+ @9 D. o- `- X2 u) U6 \4 {
<lable>Pierced Amount</lable><br/>
; n& Z+ Z: o7 ]0 w: [+ {
<input type='text' name='item_pierce'/><br/>
$ O/ V( Q8 [% s& ]4 x
<input type='submit'/>
% z8 E) I0 B) l' @+ U3 h; ~
</form>";
1 e& B3 p' N# y& E8 d& }6 {: n
}
# `7 v/ U( e: ?. l1 @
w) W, o& E8 J8 T8 R+ d
function PostListener (){
+ {7 v# B: j2 t @3 L; A7 u; u
//Add more post variables if needed and add them to initform() function aswell
% J( \# |! z1 v/ U
/ ?! L# a% ~4 V7 K1 N- H
################################
/ N8 ]/ f& }' ]. S: S
##### Connection and Post ######
% s" Y' [7 c( n) @- A' n
################################
! ]: B/ I% I# u8 ?8 D
$name = @$_POST['char'];
$ ?& P) o, I$ b9 ]* I- C
$ItemName = @$_POST['item_name'];
) X$ }* `! v& z2 {4 p
$ItemAmount = @$_POST['item_amount'];
v' u) \3 Y# H: ?
$ItemId = @$_POST['item_id'];
2 Z/ w3 {& f H3 K- {" j- X4 Z5 _9 a" r
$ItemUpgrade = @$_POST['item_upgrade'];
1 y" C) e3 r+ v8 K: E: o
$ItemElement = @$_POST['item_element'];
0 o0 K8 n8 Q n+ q1 _
$ElementUpgrade = @$_POST['element_upgrade'];
6 E) e8 n; b1 b7 C4 R
$ItemPierce = @$_POST['item_pierce'];
$ @* z/ z- Y& g
################################
( ^# J/ c! x8 t+ O: Z
j) h8 Q; ^# o5 @5 s8 h/ P! x
//Check both variables for empty value
4 {/ G% L( g$ F
& V- O7 l5 l/ } P" n$ H
if (!empty($_POST['char'])){
. V( i3 w) E4 b9 M4 }) E1 s6 u
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
/ p8 V3 v+ I8 C4 ^9 |
4 E+ |% m' ?' ^9 ~5 f3 p; L1 i. S# w1 b
m_szName = '{$name}'");
2 M% D/ F& b- I3 D) m2 W
while ($row = mssql_fetch_object($find)){
$ d3 z( Q% U. J t. h' l3 o
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
: N H0 B- y8 }6 @
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
% ?8 R6 c- p' \8 B7 G5 l
/ p* b4 I) g7 q. l
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
* o! l& z" [3 I3 E+ x
7 [! j% [8 N/ A) Q, t
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
- o+ s* w. \) l9 J# O
$ f& L& o% b& q: ^! n/ ]6 J3 H- ?
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
: }' h Y+ L7 ?) h) f% H" Y" U
, P3 @1 Q; ^. P8 Q8 ^% {
'{$ElementUpgrade}', '{$ItemPierce}');");
( w8 ^$ d. K7 F8 n- o
}
" N" K* n. U2 V' b% @
; S0 b/ C6 q. ]/ F4 {: I3 d8 D
}
( e+ U; T5 R/ i$ T) }4 V) A* G2 o' C
) S% g/ U+ g4 V! w5 q
}
5 D7 V) i( Z( v! x& `3 D( p2 @9 N
3 q5 N5 x0 j8 `! g
$InitForm = InitForm();
2 T5 L1 ?7 O' L5 b
$Listener = PostListener();
m; t. m3 `8 R2 M2 O
3 o3 v) y3 p* ^7 r M
?>
% g8 w1 L5 i$ _& `' g+ m( t6 M: ]
/ @( Z7 T% _. }: ^. o ?
4 @4 _& S; U! r% `- @5 w" h5 J
) l' g' ~5 @) F3 Y" D8 ^; R2 @4 Z
( X! X! L9 B d' B5 N9 P
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2