飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
+ R5 K/ p4 Q8 K& Z2 u
function Connect () {
9 H, P7 F7 o3 k! d O0 t
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
( z7 Z8 {8 v5 W
; _* M6 r9 ^4 N# k: B' O. G
Failed.');
+ u. D0 |- e7 M& U* k
}
9 `5 z2 {; y& w3 [% Z
Connect();
( K6 T& a+ Z/ q3 |5 [
+ V4 N$ X* i! r. i* R" S+ u" W
function InitForm(){
1 K. E7 _% U8 ~$ s0 a# S/ ?1 d
//layout for the form
! j8 b+ b& Q; \; B4 ]! v
echo "<strong>Send Items.</strong>
- j/ ^$ i4 e' B" ^5 X5 r
<form name='select' method='post'>
) R' M+ f! ^* Z+ U
<lable>Character Name</lable><br/>
. k4 {) B( s# c2 G4 a$ [
<input type='text' name='char'/><br/>
" n' n4 C8 }+ d. D( Z5 v
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
$ _6 p( q3 j5 v3 ~
<input type='text' name='item_name'/><br/>
3 v& V b9 K7 M5 h( |
<lable>Item Amount</lable><br/>
9 y' W6 I( a" i+ a' I/ {$ z
<input type='text' name='item_amount'/><br/>
+ @" o' N* V V/ p$ P, e
<lable>Item Upgrade Amount</lable><br/>
: W' d+ ?3 G6 v" I3 d. p- \
<input type='text' name='item_upgrade'/><br/>
. w) G3 j7 ]* A1 v0 @& _! N
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
* ^% S5 T; E; X
& j- X4 X, I# `( p
</lable><br/>
2 h! k, X2 l$ K) }. i5 P
<input type='text' name='item_element'/><br/>
' L4 t; w* Z& p( K
<lable>Element Upgrade Amount</lable><br/>
- ]: v, ^ ^6 J4 ?7 y! p2 j
<input type='text' name='element_upgrade'/><br/>
9 u8 Q* A& I% E
<lable>Pierced Amount</lable><br/>
0 |: t# Z" d1 N1 } F
<input type='text' name='item_pierce'/><br/>
2 W* c V! {8 Z) P
<input type='submit'/>
$ E* [* g4 j4 Y# b1 D
</form>";
% E4 d( w* V e
}
/ q* Y+ S2 s1 c: r7 o! n
8 `! h$ @+ Z2 d9 w7 m) t
function PostListener (){
9 x# u8 i. `) ?3 r8 N
//Add more post variables if needed and add them to initform() function aswell
# r, D# \4 a: ~" o) N
. L5 x9 h" i% ?3 h8 |8 f0 l
################################
8 b1 r. R) I0 h& v* U0 _- s8 c; L
##### Connection and Post ######
, F4 G8 p; v+ Y8 ?$ D6 g% U# _
################################
0 l" C. ]$ W+ s' c7 A! \$ n/ J
$name = @$_POST['char'];
/ R4 n& Q' N' d) x7 ^
$ItemName = @$_POST['item_name'];
! S. _9 K1 X* ~
$ItemAmount = @$_POST['item_amount'];
) g7 Y c( o: `; l- C" `3 D* p; }
$ItemId = @$_POST['item_id'];
0 Z, ~8 d2 A* C+ z# J6 [
$ItemUpgrade = @$_POST['item_upgrade'];
+ d- q5 Y' B% D; d- y- T2 I
$ItemElement = @$_POST['item_element'];
; a. ^! b" ?+ [% X V
$ElementUpgrade = @$_POST['element_upgrade'];
3 A+ C6 b$ v) t0 B3 ] ]+ J( g
$ItemPierce = @$_POST['item_pierce'];
! v0 D @7 [! h( N( z
################################
1 z+ S! z9 S# Q# k" L( m/ n
3 l6 ?) Y: G7 |3 ~$ {
//Check both variables for empty value
+ R) @3 G3 X' ^; }6 G- l
) ~4 b! d9 l! B% k e
if (!empty($_POST['char'])){
; ]% P) M6 H2 w5 Y$ |
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
0 ]8 E2 T/ T2 R/ d+ p
* B6 J( Z: X, n$ r
m_szName = '{$name}'");
$ i& j6 `, i+ Q9 l
while ($row = mssql_fetch_object($find)){
8 p0 ^* r& e" f. a9 |; k
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
) N: j4 `; ] Z
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
" K4 s' m+ ?( V& ?
# X$ I/ n b( Z. ]/ r6 u
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
6 w, }$ N" K* j/ A, g* G3 \" |
/ W% ]6 g% w& o3 S6 V/ G
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
) ^" F: M; h) p% C) l
& l" @3 L2 i- ~* p" M! w# _
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
3 ~4 G# ]0 k% _$ T5 |! T
' [$ b0 J9 R+ \$ A+ e) y! `
'{$ElementUpgrade}', '{$ItemPierce}');");
& g) I' P# L! c! Z5 u( A. ]
}
/ Y8 ?3 q# U2 A: ^. W3 N
. h( D/ {6 G p% [
}
$ A1 r4 s2 Q- K
`% m3 \2 a( M$ E0 m1 i
}
' i" g. z8 K7 K5 V/ J) i R
& _4 }# h5 Y/ j% _ u% F, G4 }+ f
$InitForm = InitForm();
2 F8 l; i. ~0 i1 k7 ?6 Q4 k
$Listener = PostListener();
* Y/ [( }( r" j, T w
) u/ u: g: A# F, Z! t# F+ q
?>
( g2 _6 g3 \" q4 T! F6 o! W
& u/ g, U1 w7 P8 f0 u+ p' l. J/ j
v& \! \( V s" a
4 w9 ^& W! T* @& U3 y0 M
8 L( ^ F# e; j) Z
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2