飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
( K* D4 @! ^4 S, X
function Connect () {
! O+ x! [8 e4 L0 \, [; j
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
$ q# f' c) `- F6 Y2 v
# y1 T, i# J6 \: \4 r( R# r6 Z+ @5 M
Failed.');
1 n6 C3 x6 Y* ^1 R" i9 `4 d
}
5 y. M: f7 w7 [
Connect();
, k$ h- z% J$ ]6 S" ~
$ `4 A+ E6 _6 x
function InitForm(){
( R# @% T% V# p$ ]
//layout for the form
& k% H! @+ E! r& ]! X
echo "<strong>Send Items.</strong>
2 u" k' v: E9 p' z
<form name='select' method='post'>
- |) t1 K% K6 S& h* U
<lable>Character Name</lable><br/>
! |; P$ N/ K/ K o$ X6 c
<input type='text' name='char'/><br/>
' j* p# o) @& T5 m' S
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
3 R" [1 S( W( t- }
<input type='text' name='item_name'/><br/>
+ J, k1 I# y& W) ^9 s- v
<lable>Item Amount</lable><br/>
; M. M s0 G O" U$ E" d( ~9 L
<input type='text' name='item_amount'/><br/>
: D+ ?- d$ s6 W- X5 c; ^& @" A8 g
<lable>Item Upgrade Amount</lable><br/>
: R" ?9 W8 W; R, c
<input type='text' name='item_upgrade'/><br/>
5 ]0 N' [5 h, W# s
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
) h- f# g' b( }. b; z" k- y# Y( M3 ~3 j
# b( }! U9 N. x: L4 f8 w" D; v
</lable><br/>
8 _( V4 J+ ?( S [2 T) @% E
<input type='text' name='item_element'/><br/>
! ^# h" q9 u o5 B
<lable>Element Upgrade Amount</lable><br/>
1 O, V) K+ g7 c# O% q
<input type='text' name='element_upgrade'/><br/>
* B7 t3 a7 k9 Y
<lable>Pierced Amount</lable><br/>
* G% j% }4 H/ q
<input type='text' name='item_pierce'/><br/>
7 W! D, @+ g) b& ~$ ~
<input type='submit'/>
: x$ h# N. m% q/ {6 `
</form>";
& v; W1 l6 Q1 c5 b" e
}
- S5 S* d6 [& c9 r& Z# v5 o! H
% `% Y0 `+ t* I$ x8 h) h
function PostListener (){
. X; p" P" P# h7 R. K1 s
//Add more post variables if needed and add them to initform() function aswell
0 h8 q8 v1 \) [* [3 x( e" K
* i- C, S) e8 d: C8 S
################################
7 f2 v; q3 D' H `2 s
##### Connection and Post ######
$ o; Q8 s6 x8 C6 j6 ]. o
################################
" _& \. h+ A, F- H. v2 f4 E6 [% z% h
$name = @$_POST['char'];
& t) x' G7 I# m8 M
$ItemName = @$_POST['item_name'];
! _) l) m8 z9 C; [% p6 ~7 Z
$ItemAmount = @$_POST['item_amount'];
6 L/ w9 d) r" |7 ^1 o; t
$ItemId = @$_POST['item_id'];
: @* c8 R+ ?% j% u v( T, Y% I
$ItemUpgrade = @$_POST['item_upgrade'];
5 J$ D% T7 a: j4 v' m+ i! ^/ F
$ItemElement = @$_POST['item_element'];
) U* @- {5 ?# w' z
$ElementUpgrade = @$_POST['element_upgrade'];
: Z8 L4 t4 N6 ~- C: f
$ItemPierce = @$_POST['item_pierce'];
' B: S! a! h5 Z9 F7 O' }
################################
# p4 k% @& i, L- R) c8 N* J
9 F0 A8 s. E# q/ X3 R/ ~
//Check both variables for empty value
' o; V2 m+ {) J( M
3 ~' E. n, i% `' V5 ?% S5 N8 k
if (!empty($_POST['char'])){
" Y, D% \8 _! v# M4 i
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
$ k3 T5 b3 p3 r9 Q3 L( S
1 P% P/ I) I7 U7 ^# q
m_szName = '{$name}'");
8 c* Z8 t4 ` P' Q8 ^0 q5 g
while ($row = mssql_fetch_object($find)){
1 @4 O4 T9 ]( K% c0 v
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
J6 I4 P! z/ h5 l7 y
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
. T0 l4 b$ t2 h# m1 P$ m: z
5 } V% I7 R$ {; I$ E, j( ]
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
3 A3 G+ O& I( P6 f6 P: F n+ l. h
1 d, U4 r% l# [4 ~6 w. `$ @# ?
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
) g, ~5 C0 u% s
/ w* n5 p# i. e- Z6 Q. f& j2 Z
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
( c; `5 Z7 @9 J% h4 Y& `
. a! K/ f& u" R* }$ e& p
'{$ElementUpgrade}', '{$ItemPierce}');");
- b3 u6 w6 z# d
}
! C \" }/ {$ b& `0 ]& j
7 V7 l/ U x0 Q0 i
}
9 w C, @; {' }( L2 u6 d4 {, m
( c+ X$ X- ^4 Z0 g
}
3 H$ @ E$ m2 N$ N& A5 Q
% w( m" q. v. k/ {
$InitForm = InitForm();
1 m$ R) `0 N: U
$Listener = PostListener();
- B& |% t- g1 q( w7 x( r+ `
- K1 W- R$ h7 s
?>
1 B# {8 g: j! {
. A5 `9 I4 y) ` `; c1 |) z
* t+ X& m! W5 M8 Q! X" @. ~! N$ k
: k; h9 K( I6 T* a
- o* z% j0 f6 Q7 O: t6 H
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2