飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
9 h* t( u5 O8 S4 M# N
function Connect () {
1 n+ ]# } }6 y/ M* |1 |+ H" z* }
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
. N$ v/ s0 Q) Q: D* l9 `
( K6 }8 Z, G! b$ E
Failed.');
) C% g* b% \* t
}
# K( g1 F/ z+ t9 _5 x/ \
Connect();
; P+ o. e% k; v' r
1 d$ I" _. I' s2 e5 T
function InitForm(){
, o' C" b( r' {
//layout for the form
0 N- r: V& c# [' K: j5 j/ J
echo "<strong>Send Items.</strong>
2 E. {$ A2 t O- }% A
<form name='select' method='post'>
$ z3 I/ |( s* T- v. m$ J& @, ~( `
<lable>Character Name</lable><br/>
% G: f$ Q; j* }( i& ] L
<input type='text' name='char'/><br/>
; _1 {4 ^# |1 w
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
% p, z4 N Z( ^5 G+ Y
<input type='text' name='item_name'/><br/>
: f/ E# Y% k' K, z; ]+ C
<lable>Item Amount</lable><br/>
5 u+ ~ Q3 X; y ?
<input type='text' name='item_amount'/><br/>
3 P& y: l8 R% V. K0 T1 b. U
<lable>Item Upgrade Amount</lable><br/>
8 }! e0 f F) h; t' x
<input type='text' name='item_upgrade'/><br/>
" U* ?- N8 \! `3 W3 Q8 s
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
9 e& F3 {! F. ]% d7 ?# Z2 I" C8 ?
, g0 i+ A) v" L1 |+ O
</lable><br/>
$ K- l+ E- o e3 P4 p O
<input type='text' name='item_element'/><br/>
. [( H# C. w K2 I4 S
<lable>Element Upgrade Amount</lable><br/>
: W8 X! C0 z& L/ W6 z& @; `& Q
<input type='text' name='element_upgrade'/><br/>
: c1 X O( M( t
<lable>Pierced Amount</lable><br/>
I, F7 o2 c* @% K& K) e
<input type='text' name='item_pierce'/><br/>
1 [/ ^) f5 H4 o' c+ [
<input type='submit'/>
y: J1 C6 ^8 b; F2 {5 ]; N. w
</form>";
) P5 z) E9 p6 H: r6 C8 i
}
* y: j3 Z# E) a# x" X4 W
0 h* f& m( o6 r( g. W
function PostListener (){
2 n% ^: p1 ]2 o+ T1 |# M$ c
//Add more post variables if needed and add them to initform() function aswell
, ]1 s4 }/ l, L4 a6 o* v
3 V. W1 O* s2 Q1 t
################################
7 d: _# ~* Q+ Q; L4 |: \
##### Connection and Post ######
, R8 o/ r( P; w" e( S2 h
################################
- k9 r3 e/ @! v, y) ~& f! P$ J
$name = @$_POST['char'];
9 ^8 z: U( F A% }' s8 W: _" T
$ItemName = @$_POST['item_name'];
$ A7 U& [4 F- H* j. F
$ItemAmount = @$_POST['item_amount'];
1 J( \ U9 H7 H2 W2 c$ \
$ItemId = @$_POST['item_id'];
* Z; E) f4 r" j0 L
$ItemUpgrade = @$_POST['item_upgrade'];
6 l+ D8 g: c/ d/ }! @2 r% J
$ItemElement = @$_POST['item_element'];
! U/ ^$ Y6 f. Q
$ElementUpgrade = @$_POST['element_upgrade'];
9 L3 f8 U# B, T. q
$ItemPierce = @$_POST['item_pierce'];
! |" d7 Y$ F4 @
################################
$ ~, C( L( ]" P' }7 R
+ ^$ G8 F, {3 L% N# Z8 J# L
//Check both variables for empty value
5 k0 G9 M E, v
% v) P' V5 ^' R# q
if (!empty($_POST['char'])){
/ M, p# C4 ?* E0 Y6 l5 D
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
+ U& X: H$ B* s }# R5 c/ H
# ]6 N, p1 b2 S3 I/ Y
m_szName = '{$name}'");
/ p% k D z, x( e- X; f: ?
while ($row = mssql_fetch_object($find)){
2 w$ l7 S U& B0 ^: i5 d' Q
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
: H8 [ V! h1 _; E) v, S& N
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
% B+ X! ?6 `$ C3 ?$ ]6 L) m
- |4 Q' {6 @- y9 }
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
. y9 n3 w( }5 I& x5 z
9 o2 v7 o" B8 m5 ]
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
3 C' ?3 s* y" {" r
' o+ a4 e. Q" w& r
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
3 }% X" ?# p7 C+ G/ w% s4 O
" I6 w" e& a! t. H
'{$ElementUpgrade}', '{$ItemPierce}');");
" o# w" u$ w) L, U) d
}
) V7 |% t! I2 U0 M
$ E- @( F: b2 ^9 g
}
+ {# T7 j2 ]5 s/ b% p
2 r3 ]! l' r( K# P9 y# n w4 ~
}
0 @" O" j) i2 G4 U1 L
8 n1 x# ~+ W0 `% K
$InitForm = InitForm();
0 U3 U" K* i4 G; {1 P
$Listener = PostListener();
1 D& }0 w: s0 b8 Z4 q8 ]- V
6 V% R1 w: o: C& G: I
?>
: n; @5 s9 a1 G/ k/ T; s3 Y' R
3 G n2 j s/ H) y
$ F5 m2 k% J4 h. t
1 {/ d& R( z; U: i2 x/ m
2 p) v- {: I5 K8 h
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2