飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
) x+ Q1 C) w: |1 ]. J
function Connect () {
# H) }) R$ W, U8 U/ f6 J
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
! _& c+ l9 Y1 P& K. I" S
- W/ R- G5 Y( ]! S; u. y- d
Failed.');
& V a4 }! v; d8 @
}
0 s5 B- I& r1 P2 ? [
Connect();
* W. [) u0 g; C3 i% G! B1 R
$ `% P+ k- F, M/ c3 Y5 U' \) r/ [
function InitForm(){
5 E! M0 v' Q1 p% ~: m. _# J
//layout for the form
& H- p' v; M6 r6 A5 @- Z# r0 B
echo "<strong>Send Items.</strong>
' B9 }4 ?' w2 C0 n: F
<form name='select' method='post'>
3 Q+ `$ P! d0 ~6 B7 Q- [/ v
<lable>Character Name</lable><br/>
: ~3 m$ N; T( F; K! m- N% R Y& U
<input type='text' name='char'/><br/>
- K: k/ R% ?; A4 h1 F
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
4 k2 Z! K5 ]0 `$ S, W7 ?
<input type='text' name='item_name'/><br/>
) H( L) P% l& Q$ h6 T, ^
<lable>Item Amount</lable><br/>
+ O& v$ i9 M' i; _( L% N5 J
<input type='text' name='item_amount'/><br/>
4 h& \1 Q6 P# G
<lable>Item Upgrade Amount</lable><br/>
2 O1 t1 e1 G+ z2 T
<input type='text' name='item_upgrade'/><br/>
4 x* r( R" ]6 u
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
# ^1 B# j. j$ P2 p" N5 N& y( e
0 {) G. X1 O8 w2 x4 q6 ]$ O3 Z
</lable><br/>
# k# c4 z& b% ]# {! S4 Q
<input type='text' name='item_element'/><br/>
5 p2 t4 n& S! t( g* [( K' k
<lable>Element Upgrade Amount</lable><br/>
7 f4 L1 a$ w! H6 o
<input type='text' name='element_upgrade'/><br/>
3 f* m, o) h5 q5 b% k" b) G N5 P" c
<lable>Pierced Amount</lable><br/>
; ~/ z8 f7 R; _6 b7 L
<input type='text' name='item_pierce'/><br/>
' A* X2 a$ B& L# x! b
<input type='submit'/>
. F- G2 S" J9 g# U( r
</form>";
/ ^2 u. C+ Q1 X7 _0 T% R
}
9 A& b/ n* K# H. e
$ g0 V2 ]% o5 C
function PostListener (){
4 j. X' g+ C8 g8 Y5 f \ |+ x
//Add more post variables if needed and add them to initform() function aswell
% N; ?3 j. R! v, S0 O& v) ]
0 |- ?( b: V# q( v# o. K
################################
6 x4 L5 m( A* K) i Y" }/ k
##### Connection and Post ######
6 I5 _1 w! c) L% A
################################
$ g' F% f8 G. M* H6 s6 s) w
$name = @$_POST['char'];
6 S |' m4 [( _# f
$ItemName = @$_POST['item_name'];
/ J+ l# Q% j2 o, o1 x9 U+ D
$ItemAmount = @$_POST['item_amount'];
) J6 [4 n; n: w3 N7 r; E
$ItemId = @$_POST['item_id'];
5 a" |, V6 y2 r( G' [/ w
$ItemUpgrade = @$_POST['item_upgrade'];
- T! ]) ^/ Z# d. A1 ^0 m" w+ m2 G
$ItemElement = @$_POST['item_element'];
3 a; y3 o6 h+ Y- c u: b3 c
$ElementUpgrade = @$_POST['element_upgrade'];
2 J7 T d( {0 M/ t
$ItemPierce = @$_POST['item_pierce'];
4 T' y1 \" y [) Q. U
################################
8 M6 K4 F+ F" w- B" ~. z$ z: d
% a9 F0 r$ G/ L/ q
//Check both variables for empty value
+ A) F7 m% i2 O, y! }
5 F0 \: n/ ?. S7 }7 H7 r$ J5 q
if (!empty($_POST['char'])){
$ F: t% ~9 ]3 e
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
* L; Z# f; h6 r* i" K- H4 V
+ J. X/ M' F$ G5 A# F y
m_szName = '{$name}'");
( E8 s P% G9 I' q" @0 Y4 z
while ($row = mssql_fetch_object($find)){
0 ~! |! G7 m! k* `; [8 ~
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
7 R8 N9 c9 `3 N3 j; ^7 Y+ l x
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
8 O/ b" W* }0 e3 Z
) w% r# [% O6 l
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
1 X; F9 g5 y- i9 b0 L
0 U; f8 i- k% L) _% O( |, O
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
5 i, B, O' f$ o, h2 n3 x& b3 L
, `% B) y' @2 y" V) l5 y7 v1 P
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
5 T4 g' J0 ~4 Q# C% ?; k8 [
9 v. j2 k4 G& {" k& U) `0 g/ i, o
'{$ElementUpgrade}', '{$ItemPierce}');");
5 ]' Y/ V$ h- t( C$ D! T
}
( B7 J) f3 R5 L" t
% ]) p5 G) i8 }# D' f7 V6 m
}
$ ^& y( V, ~, S3 Y( g w- N
3 p8 h1 y& [. }% t/ q. l
}
/ A" a: p8 H" @. Y2 O2 [+ M# m
& V/ Z+ Z0 v# e& C5 N
$InitForm = InitForm();
6 m1 X* s9 O+ m* N7 @. m5 |
$Listener = PostListener();
N& T. H9 l6 y, U# H M- V3 n: c( ?
7 `2 q3 p7 A' ~- B; s/ d* {4 D
?>
1 m: T; b/ F% H0 X; G
?- T- K# c: ^% C
$ z9 |3 P5 Q' B7 g4 `* D/ e; ^
u% ?- i N& G8 }. t" @% K" \+ S! G! g
0 G6 o* o Y3 p& `2 f( ?
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2