飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
2 c3 v$ g# `2 P [& R9 y6 q9 C
function Connect () {
& W, y! m& ~, \, p+ |5 g1 I2 x
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
) N% s4 c: w9 }6 U
8 U% { W4 e! ^' s/ b( M
Failed.');
5 Q* C" @6 r% l& m0 H5 g; k
}
/ ~) O1 g) L) s, D; b
Connect();
% p/ B6 \& F5 V$ F: H: [
9 k' a2 t' I7 z$ L5 X# C
function InitForm(){
. L: p: C8 p, Y
//layout for the form
- D, ?0 i/ b7 B! W+ K: f* k
echo "<strong>Send Items.</strong>
+ Q$ b* L% a; L4 M) o
<form name='select' method='post'>
% S2 T w% ]3 |3 P9 R
<lable>Character Name</lable><br/>
4 ]9 o: j7 u) E) W1 u" K- h5 u
<input type='text' name='char'/><br/>
0 b0 T* ^5 v" n i+ _) a- g
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
5 t+ p+ N$ R0 H% W/ W
<input type='text' name='item_name'/><br/>
. }$ R: X' B Q+ B3 a' B1 \
<lable>Item Amount</lable><br/>
2 Q c! d" x2 Q6 L' T& o
<input type='text' name='item_amount'/><br/>
8 R+ K( s! Z0 u* ~6 n' O
<lable>Item Upgrade Amount</lable><br/>
( X- Q) I% s$ v4 d$ @
<input type='text' name='item_upgrade'/><br/>
5 X7 u+ [0 u3 g5 b5 ?" j; G
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
$ \( Z' e% A9 R6 I9 k1 s
2 L8 L9 }9 {6 S+ N. O2 h
</lable><br/>
! A8 p: I( k1 b
<input type='text' name='item_element'/><br/>
: \& T, m& |2 [( J8 c: I* ]: r+ P
<lable>Element Upgrade Amount</lable><br/>
2 {+ b+ w, B; U
<input type='text' name='element_upgrade'/><br/>
% P5 N' O0 J5 O0 Z W3 A
<lable>Pierced Amount</lable><br/>
" X8 p* b, q/ e ~. {
<input type='text' name='item_pierce'/><br/>
( J8 g" ~' P0 k& U
<input type='submit'/>
( f5 H' A8 K8 P1 A
</form>";
) X/ b% ]% q' i
}
+ o0 e' J: T! W- O- @' d# d
0 m' p1 b) n* A" u4 M8 o; U# J) P
function PostListener (){
+ ^7 r7 Z, O; K) d( h
//Add more post variables if needed and add them to initform() function aswell
: m# P+ f! @: k* F$ m2 n* p" B
4 j; \ Z8 y) U% y
################################
9 w5 c2 a: E3 |8 \2 y
##### Connection and Post ######
, w; F6 ]( z# m! s+ ~* g8 ?1 _
################################
5 |. b+ G, {2 }! V: J
$name = @$_POST['char'];
/ x) V8 q& p' }/ _4 o0 P
$ItemName = @$_POST['item_name'];
! |8 d! Y5 N# Q
$ItemAmount = @$_POST['item_amount'];
7 U6 J5 z5 e$ |+ M
$ItemId = @$_POST['item_id'];
W/ Q3 M J6 f& r8 z0 W. ^: C) w
$ItemUpgrade = @$_POST['item_upgrade'];
! e$ a5 A) x5 a7 a
$ItemElement = @$_POST['item_element'];
8 s" V) v1 \+ I! W( A4 r! d. |
$ElementUpgrade = @$_POST['element_upgrade'];
3 z! \9 w0 q; ?: G: q; @
$ItemPierce = @$_POST['item_pierce'];
) v! G5 _& r5 t$ o+ _7 j
################################
( {9 Z( K3 Z& S5 \( ]) j
/ S+ J& S) A7 ?3 q6 Z
//Check both variables for empty value
- i! |9 m1 b4 F
) d4 P, {# }% d) R7 c- G" O+ D( E
if (!empty($_POST['char'])){
- m% A: @; D: z, x
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
/ }8 {9 [) f" f; U1 b8 S2 D
' s2 }; _$ P% s/ Z
m_szName = '{$name}'");
, g& G& F' L. }" i: {
while ($row = mssql_fetch_object($find)){
4 K1 o; L# T. m) v) C9 C
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
4 K) N# F6 k% R' o, u) b8 U0 J5 ?
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
9 U3 U/ n# @! B
' q* t! l9 N2 L% v! k, m' G) I
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
9 p0 w6 `- p' d) m* U2 ]( t5 K
# J; h+ N9 ~8 t
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
# P# U* \5 A! C2 `( C- R1 w
: m' H- e6 G; o+ q! [" ?
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
' Y( D1 E0 v, E) f, e) ]* I
9 R. n$ I+ L7 H: _7 |# _
'{$ElementUpgrade}', '{$ItemPierce}');");
7 e* D; P/ o: W. _
}
& k+ l8 n! d9 r& i3 h
! G/ ~; w3 }7 \* _$ A G0 N
}
7 A, Y+ g- i2 V6 Z
5 ]; ]& ]8 ]; |; V6 f% a: g
}
* ]% B( b+ G7 Z y$ I3 n
& D# d1 p" }5 o1 e4 K7 T
$InitForm = InitForm();
, Y& V4 m1 ~; b' ]7 ~
$Listener = PostListener();
6 E `* m# e$ {) _* h8 e% n
4 w' D# `9 H2 Z
?>
3 w. k9 ?5 N( V+ m9 {
7 h# o! H" _! I: {$ o# H
$ t1 p) V# V3 l! B/ y
$ n9 ~$ i! Y3 S% _3 p
" Z) `" w' d) O4 K! q$ P
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2