飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
7 o; o5 k7 y' ~+ k
function Connect () {
! K6 o0 A+ ]" K7 f
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
! N- Y1 @& d0 Y- f# D" r( s" o
% [ f; W6 v2 Z( J) W, f( C0 z
Failed.');
" r1 {8 v6 z4 v& {& I2 n( v. r. g" w
}
' R4 o! A, z8 J4 O0 C
Connect();
% @0 s! D2 B+ x, |
* J/ E/ h3 |3 K
function InitForm(){
' s4 l* u6 [, `
//layout for the form
* B8 ]: M! l, M' W4 N
echo "<strong>Send Items.</strong>
) B, Y2 B# r% b" M8 U% _8 l: X; |/ L
<form name='select' method='post'>
) \% m- E8 J; q$ b2 |
<lable>Character Name</lable><br/>
' t4 n+ Z# y0 O/ a2 n& h+ ]3 M
<input type='text' name='char'/><br/>
( Q& B* ~4 }, G+ |% X7 l
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
' f/ w2 Q" H4 @& P! b
<input type='text' name='item_name'/><br/>
6 I, \) l' A3 y' O1 K6 I6 f
<lable>Item Amount</lable><br/>
8 q) ?* s N+ L5 l' `) i/ a
<input type='text' name='item_amount'/><br/>
; I$ R! Y1 y& @+ n- M& z
<lable>Item Upgrade Amount</lable><br/>
1 s4 `( c. @- N- {- F9 T
<input type='text' name='item_upgrade'/><br/>
! b$ _$ ~0 k, Y
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
7 X+ h+ M6 S1 E! u* }6 r2 N1 d: K
+ q) J& S. |' f d
</lable><br/>
2 O# a. b1 Y' {& _/ ^3 f
<input type='text' name='item_element'/><br/>
x2 {1 _3 b. r3 Q4 ~' Y
<lable>Element Upgrade Amount</lable><br/>
" @4 R# L4 F9 A9 G- \$ x- |$ K
<input type='text' name='element_upgrade'/><br/>
# j. D" k6 O1 I6 D
<lable>Pierced Amount</lable><br/>
4 @3 _6 I5 b& {, T$ x
<input type='text' name='item_pierce'/><br/>
. ?! S! S* f4 @- ], f
<input type='submit'/>
4 j: ~, L# t$ ~ v5 n
</form>";
) H5 X3 Z9 }! {5 t- L: @# I0 K
}
* t2 z6 x' Z# s
# c& z5 n& h+ S
function PostListener (){
% _1 d3 Q2 O% e' c. [5 ~4 Z
//Add more post variables if needed and add them to initform() function aswell
% d6 d( z. s+ K5 j( [0 E& a* b
; y: ~% k7 X" O3 `7 `
################################
( J# r+ H* m$ N0 t
##### Connection and Post ######
: A/ C8 E9 `: ^* _' w. G
################################
7 w* M) m/ m% k% a- n: J8 W
$name = @$_POST['char'];
, c# R1 l% s9 N5 L6 }, Y5 H5 H
$ItemName = @$_POST['item_name'];
, r3 C3 H: h+ {. m
$ItemAmount = @$_POST['item_amount'];
+ M6 B5 H/ ~; s$ ^# C* q; p
$ItemId = @$_POST['item_id'];
) y/ ? X0 c! g* Z' b, v
$ItemUpgrade = @$_POST['item_upgrade'];
# f& {0 K1 T! a
$ItemElement = @$_POST['item_element'];
, Q Y8 \" E) j+ k) V; D5 Q* N* ?' Q" ]
$ElementUpgrade = @$_POST['element_upgrade'];
- T6 Z3 r# C L t+ ?
$ItemPierce = @$_POST['item_pierce'];
( f# ] `5 b" ^6 G; S9 P
################################
' J6 \& e0 s7 H8 g3 @2 U2 ~$ q( H
9 D4 Z( x U& b
//Check both variables for empty value
i8 @ a3 j3 N0 _0 c/ e+ ] D, ]
* x' X' ]4 a+ P8 W9 y* ?1 ~5 n
if (!empty($_POST['char'])){
$ ~9 `/ J# K; {# S3 E6 Z/ c
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
l% Q, g! f* }" p& e& M1 z
) P% L( P2 Q7 P9 l" W, F3 H
m_szName = '{$name}'");
5 N1 d! m! W) @
while ($row = mssql_fetch_object($find)){
& [: T' o# G6 c; S' k
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
: q! l. | \$ A& [$ x" X7 L
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
; t p' I; }" M* M
. U8 I; z+ t1 q; V# h
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
$ {# n' K: Q' D2 r
& }2 i5 g+ c; i' o+ r$ ]* q
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
) `, _( U4 p: [% _6 ~, X2 Z
' o' J& c% E8 |5 k
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
+ \9 K* o! t( L) X
3 [; C( O9 V' M0 Y& M# R9 v& l
'{$ElementUpgrade}', '{$ItemPierce}');");
: X. X4 U5 c/ h& u
}
2 b6 m4 W& b- t% ?+ z
- G0 p9 r8 y* B9 c8 V* Y. n! U8 H
}
4 e9 Y# P K Y" |, w' `4 u t' P
! f# `# q; v, `1 {7 a0 u- g% a. }/ }; [! w
}
6 O& H# G6 X2 K; T
, [4 m6 t0 I" g6 k
$InitForm = InitForm();
/ P) _7 z7 R: D3 y. K& H8 ^
$Listener = PostListener();
) D/ {$ Y3 H5 J4 @8 Q
( {# r! O g9 m' b0 E
?>
. z$ ]5 E3 I4 n2 E/ [3 e
& Z9 R6 T4 d6 H0 ^
: j. m8 Z: X9 R7 q. W- L( X
2 t7 l* C( i" y2 b( F ?
; t8 U. t. ~; x* s i' C5 A
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2