飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
* V3 U, g. ~: y
function Connect () {
5 `% T: s9 I' Y- F5 T1 e& i, f9 `
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
2 S% W: P) W% e4 G, C
. T. m1 s3 U( }4 a* T5 ?$ T ]' b( j6 y
Failed.');
6 {& ~/ Q* h9 V( \
}
8 C. P" x* Z& _$ O
Connect();
9 g2 h1 G6 M5 O* P# @. U
# ~8 ^4 Q+ p. z$ o, ?
function InitForm(){
; L; ^5 N/ g8 v5 Q
//layout for the form
6 l( B. b s. P+ `1 Q) G
echo "<strong>Send Items.</strong>
3 l: c; |$ {$ g; c
<form name='select' method='post'>
5 Q/ @$ Q* e8 z, _( {6 n
<lable>Character Name</lable><br/>
4 B, }" W; |; M4 G/ c
<input type='text' name='char'/><br/>
& a0 o+ m4 F' a8 D
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
; Q, J: I- B2 D+ J
<input type='text' name='item_name'/><br/>
8 M. V; ~( m. W
<lable>Item Amount</lable><br/>
+ n1 `$ m! G7 K4 P% V
<input type='text' name='item_amount'/><br/>
2 M5 t, A2 l% Y; o# R
<lable>Item Upgrade Amount</lable><br/>
% ~2 B5 w2 T6 [* Y; L
<input type='text' name='item_upgrade'/><br/>
' j0 z. x/ ~9 T9 c B; Q( J6 ?; X, y. w
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
- F5 a7 M/ G+ y
3 x9 d5 g2 w0 z% o8 e
</lable><br/>
9 ~* `5 ~( z' E M2 W
<input type='text' name='item_element'/><br/>
5 Y5 ~: Z1 A2 ?1 ^2 K7 P
<lable>Element Upgrade Amount</lable><br/>
$ B9 r- G F: v: P$ \1 C
<input type='text' name='element_upgrade'/><br/>
: x& n( r( t8 ?. F* T
<lable>Pierced Amount</lable><br/>
; S3 x- ^% {4 ]; B& z# \. H( l
<input type='text' name='item_pierce'/><br/>
2 b3 b+ P% X0 o. U- D- M" k% T
<input type='submit'/>
. N0 {: w1 r: d. f- B
</form>";
* c1 J( I' ^) ]% ^7 z0 I
}
& ]; }; e* O& i h
. {5 Q3 L) ^3 g& i
function PostListener (){
2 _. ~7 X) D, L; q( B
//Add more post variables if needed and add them to initform() function aswell
( B5 o$ Y0 {, o1 w
1 k5 z( { h; `; l; _
################################
, r+ i+ @& G8 U. e$ q# L
##### Connection and Post ######
: m" ]! _! `# t6 u
################################
' E" r. t" s9 V+ ]# v
$name = @$_POST['char'];
7 ~ k; V/ m1 h. k8 W- f f9 t
$ItemName = @$_POST['item_name'];
$ k/ k: f/ l/ q) F
$ItemAmount = @$_POST['item_amount'];
* l q1 d( M3 H. r1 P% J/ h
$ItemId = @$_POST['item_id'];
& i2 n- f2 M3 F
$ItemUpgrade = @$_POST['item_upgrade'];
2 e3 A" p2 {) m$ N0 y0 C
$ItemElement = @$_POST['item_element'];
/ f2 \- P5 E! v9 R
$ElementUpgrade = @$_POST['element_upgrade'];
% h0 O2 D, A; O, N9 M0 z
$ItemPierce = @$_POST['item_pierce'];
: V; |0 s6 k0 D/ u5 _7 V0 d
################################
; }4 Q. k) }# T3 S- [$ o4 g5 [, S7 g9 ^
/ m+ ?" c; o2 ?' O1 ^# H. O/ L$ u
//Check both variables for empty value
8 _+ s+ y" M! @! o7 M7 V1 ^0 Z
$ z1 \# Y5 z) i7 j w4 Z' _
if (!empty($_POST['char'])){
$ x( L Y; c: N& `
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
! k8 K/ g8 T; D6 n+ s
. T2 y, C5 I: k) v1 M8 B
m_szName = '{$name}'");
$ d- p( n* ?! j' l. i4 A
while ($row = mssql_fetch_object($find)){
7 D! T/ a; Z) k/ l
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
" d5 Q) c+ h+ \4 N- \$ p
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
0 Y F$ T% |# I7 F9 h
. Z1 k" g. O9 U: g: j: k/ L
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
% n2 O4 x4 K% p u0 b. ?$ ^
9 H) j" U1 d1 H X, T, Q
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
. t4 } w; g# S. t6 o
& H- v4 S% K" Y. d! Z
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
( N" |& y6 q$ F: b$ L( C6 y- Z5 M
1 v9 s" s8 R- b: M1 ^
'{$ElementUpgrade}', '{$ItemPierce}');");
6 x; @0 \8 F7 P
}
& ]# Y0 C6 V5 a
* V4 I0 r% n" T+ N! q5 u" F2 L6 O/ w+ A
}
- O$ B2 i9 \% T' o3 X3 O/ m8 r
) n h7 t0 g6 c* B
}
7 I. Z9 }+ }6 o2 W# q' u
' y$ U' X7 X+ z/ @0 @% T
$InitForm = InitForm();
1 Z S2 F# Q4 d* B
$Listener = PostListener();
1 w6 ^: c: G4 }. Z% f- w6 G
0 k! r: g. U0 X- q5 R( ~ N9 p
?>
6 y$ F9 k+ k/ t
( E p4 V* Y. `: p# F) F
5 D! h4 s4 o3 ^2 |
6 U, z x0 s" ~: _9 j$ `
5 u# W0 `/ ]7 i
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2