飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
8 R; L" ?) O7 X$ R; C6 V* `
function Connect () {
! P( k E P2 U. r2 E" N8 ^. J
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
0 q+ b' X: ^* r& p) m$ C/ H
: I1 V/ ^6 j* j- c
Failed.');
/ U1 B, d* N, ? X, l$ G/ r! H' m
}
' @9 p: L" ]0 K& b {* n
Connect();
* K- r3 G- _- T U
+ q; }! J# p0 `0 w; s
function InitForm(){
/ _. G* r, i9 T" r2 L
//layout for the form
) ~) t* A$ ]6 [! n7 p
echo "<strong>Send Items.</strong>
k8 t! _& j- _
<form name='select' method='post'>
, B) X4 K) t' k9 ^5 q" b
<lable>Character Name</lable><br/>
* A- d \( ~3 ]* M7 M
<input type='text' name='char'/><br/>
5 u6 Z* W3 F/ O( K) I& w" a8 H
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
3 U5 `1 `$ h+ R) p+ T
<input type='text' name='item_name'/><br/>
& B5 U7 L2 Z- ~/ G
<lable>Item Amount</lable><br/>
! e' Z9 t3 f! P
<input type='text' name='item_amount'/><br/>
1 e( v% T/ j6 q* L4 O9 y) ?# i, P
<lable>Item Upgrade Amount</lable><br/>
6 K- ~! {9 {# I' v$ r7 V# g, g
<input type='text' name='item_upgrade'/><br/>
) s" K ^+ \: A
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
9 n( D( t- f3 X* v
* Z' G2 |, g" p
</lable><br/>
* c" N6 P5 E U* Z
<input type='text' name='item_element'/><br/>
0 ?: i5 Z0 @% P
<lable>Element Upgrade Amount</lable><br/>
- o! \1 V, |) c3 ]
<input type='text' name='element_upgrade'/><br/>
, y! G4 c( n' E2 l7 ]5 H" m
<lable>Pierced Amount</lable><br/>
6 I& F1 R% N! }% F/ n& x- m
<input type='text' name='item_pierce'/><br/>
. q' f ]( D$ B, k' b
<input type='submit'/>
" n9 |. n) p" V( r% u
</form>";
. Y2 z4 i: F) s
}
! Q5 S9 s! w, F8 b) \# A" L
+ o& O, c/ |3 }, }; F! q% O8 i
function PostListener (){
3 ?0 D: o2 o5 {5 b1 l2 J, M$ Q! l
//Add more post variables if needed and add them to initform() function aswell
$ |6 ]6 S3 _/ x1 V* ]; L
& k- X R7 I$ w/ @5 T
################################
+ @: i$ Q( i% z; r; N) h( z! [
##### Connection and Post ######
4 X1 @1 n% K+ ~
################################
* o- S, {7 [& V4 I
$name = @$_POST['char'];
0 V C* Z5 H- p& T0 |: f! ^3 ~
$ItemName = @$_POST['item_name'];
% C0 ?' D( U) G r* Z
$ItemAmount = @$_POST['item_amount'];
7 [8 I9 d4 B4 W# q; `" ^) p
$ItemId = @$_POST['item_id'];
3 T+ n" ?" v) c3 ^" c6 k
$ItemUpgrade = @$_POST['item_upgrade'];
3 |. P: A0 ]4 J: E
$ItemElement = @$_POST['item_element'];
# K' ^( C8 S5 B" e1 p4 Q$ K o& _
$ElementUpgrade = @$_POST['element_upgrade'];
2 ], l& a9 ]4 Y
$ItemPierce = @$_POST['item_pierce'];
5 ?2 ~, o. w- X
################################
9 f& W. t( \, a* k" | o: M
7 N$ R7 P: g- r: E/ G
//Check both variables for empty value
1 x& h% o( d1 a5 w1 u
& `& x7 ^% r+ r7 l3 I, `9 E
if (!empty($_POST['char'])){
2 p; V/ C9 i; n4 y: W8 x2 G4 E
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
+ R( Y2 e+ X* }. g2 c* |
1 c2 g: c' o2 Q- I' p$ s' `9 R
m_szName = '{$name}'");
6 h6 d! r0 G2 s& I
while ($row = mssql_fetch_object($find)){
% }0 m; U% q' V4 j
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
6 Y$ H9 ?: q- Y4 t; N0 X# S
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
+ \3 m* Z& \# H+ R1 U( S" V# `
) x% y/ I4 m6 E: g& o
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
% @. \1 d b% O! X1 \$ F
4 |' I0 N n: U2 S1 v z8 `
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
) q: P5 u6 u6 v# Z3 c
5 L/ L* [$ E* W; z
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
+ Z! H6 R+ M+ [1 O k" \5 ~
0 \% c) b- l/ |1 M& c) P
'{$ElementUpgrade}', '{$ItemPierce}');");
0 X' p' r. e5 }
}
/ t8 d2 _" W9 J0 t0 L
3 w2 p# B! D; Q
}
' C9 w$ |# b$ \/ x
1 o# h4 v o& T7 e* x/ _
}
1 e8 X" h! w5 r& Y) |* B
# Q6 H! M* n& g: r
$InitForm = InitForm();
) }$ B$ r: c d5 R/ L& T) a/ B
$Listener = PostListener();
% r, b. S" A( B! j5 N% Y
- Q- |6 @6 B0 s% F. P
?>
9 U% l, t8 n! B
9 z. o% m6 a: W3 ~
+ c; E" z8 t1 h1 f0 j
, g' [! f+ w+ n# ?; f
. t9 T3 F5 |- w
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2