飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
; j" G. j/ J' B, L
function Connect () {
; d% Z! c" ^; F% ?' Z4 t/ J, d
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
% W- h5 y3 [+ v% r9 z; K; ~
' J: X5 `$ c& s u& o1 V1 ?
Failed.');
( [* t/ k1 `5 m' y
}
+ D2 z7 V0 v( \# _; B
Connect();
. u4 }2 x+ W" m" U: o- S; H
% ^& R3 [# R4 l' v3 L# }; p
function InitForm(){
) [7 p. U4 G ?- P& F" a% E1 |
//layout for the form
8 L, P, G: D1 N( q! h
echo "<strong>Send Items.</strong>
& _; \9 K; u8 ]3 Y& \ `
<form name='select' method='post'>
& q( W0 V; X6 }4 J1 |3 e
<lable>Character Name</lable><br/>
1 M' ?: M5 H7 J' W* t& G& ^2 i
<input type='text' name='char'/><br/>
9 F+ G0 J" F8 W6 r
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
: L4 m) ]8 U1 P2 H: M
<input type='text' name='item_name'/><br/>
9 Z+ ]& I) `2 r& o
<lable>Item Amount</lable><br/>
: Q0 D0 b( z9 D) j5 a" k ?- B1 J
<input type='text' name='item_amount'/><br/>
/ F# b# \. w, U x! H1 H: q+ ^
<lable>Item Upgrade Amount</lable><br/>
" o/ h* z2 s' ^6 s* B
<input type='text' name='item_upgrade'/><br/>
1 `3 Q$ v/ I2 n! x% c
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
. t) Y4 B# m1 N5 [
5 u. ]3 K8 ], d# c2 ^( s7 H
</lable><br/>
) f! F {. t7 [& g( b( u2 R% A
<input type='text' name='item_element'/><br/>
2 t4 F$ ]2 D3 f7 X' h0 A1 e) j
<lable>Element Upgrade Amount</lable><br/>
4 \3 ]8 [' E4 b* T/ W# \7 j; r# H
<input type='text' name='element_upgrade'/><br/>
7 e3 U: { x5 T6 h1 ~! k
<lable>Pierced Amount</lable><br/>
* f3 B' a" x7 V5 l9 n# q& ~7 T
<input type='text' name='item_pierce'/><br/>
0 \( f1 _ l( k4 M
<input type='submit'/>
$ Z5 m6 O! R# {
</form>";
2 ~' J6 d4 w4 G; Z) m! s D
}
4 q1 R, e, @1 x4 |1 t/ \, {, r9 ?1 e
- V! C8 f4 m$ j
function PostListener (){
/ H8 M: @8 q5 }
//Add more post variables if needed and add them to initform() function aswell
& k2 p/ P% I0 V1 I) j7 V) N
0 O& u& T ?* v6 Y
################################
& j- T1 e+ e, o& }/ P5 M
##### Connection and Post ######
m( t4 Z# h- L: b; F& C0 P: C
################################
6 l5 u. J9 ]$ N# D% c
$name = @$_POST['char'];
2 C# x+ ~6 b8 }" k
$ItemName = @$_POST['item_name'];
+ ]) b# }+ Q6 ]$ b( t1 h3 E
$ItemAmount = @$_POST['item_amount'];
) p" ^' P$ C$ }; \" H8 X
$ItemId = @$_POST['item_id'];
4 }6 }) c- h) m1 m
$ItemUpgrade = @$_POST['item_upgrade'];
4 @1 s) a, ]* r! e* `* x
$ItemElement = @$_POST['item_element'];
% G# D$ y- q5 v8 u
$ElementUpgrade = @$_POST['element_upgrade'];
1 N% _) h, c: S+ m4 _* P, y8 i
$ItemPierce = @$_POST['item_pierce'];
8 ?5 O$ _) s- |6 p5 A F
################################
( t! M3 F8 i6 v3 Z9 M8 ^- ?
$ M3 z9 k. i! u3 Q) m
//Check both variables for empty value
7 X& ^; |/ t' X' f6 u$ k- b' L
) G* ]; Y( S0 H( s F6 S
if (!empty($_POST['char'])){
* L7 [: e; \' g/ f4 [! L6 l# o$ p
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
* T1 _" Z% d- X/ v0 N
! X, k7 n' C# H+ W% r
m_szName = '{$name}'");
4 j8 k' g9 f8 P7 ?$ A
while ($row = mssql_fetch_object($find)){
; A6 p' J4 f8 Q8 j7 x
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$ S& O5 d& W# o8 l
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
+ c6 G" \- X: Q0 H" a7 j5 E$ Y' `6 s
( f$ S: S G7 Q/ f
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
8 a7 {* s y v3 u
* [ g2 X0 h: `/ l( i" U, X6 @
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
* l- Q5 }7 L: v7 o2 Q
" R! @9 v, q1 Q2 w
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
! @0 f3 I% |( ]/ f/ {3 M! D
: N1 Q& z* y& [. L
'{$ElementUpgrade}', '{$ItemPierce}');");
% y3 N! O: m. J" g, D9 d
}
$ S: C$ J5 f* y1 ^
* n+ R% |( H7 a
}
& G1 }; s0 w% y* r" J
8 i2 S3 O5 F" @) G. p( Q5 v5 t2 M4 p
}
: h1 P; z9 T/ A
9 Y+ t( V# a, a: X4 g
$InitForm = InitForm();
) a) Y6 }, o( Y) {( s* p& Q# l
$Listener = PostListener();
' z& L; }+ K! Q) k ]9 `" T# c8 U
] q4 p4 T# Z
?>
' `: _9 e7 V+ y
; _; l/ B- _% K6 G
7 X9 E5 `0 a2 S3 e+ I/ v
# k& s) J9 g+ x6 s) K5 V5 N4 o# | ^
, F. {/ U# }# V8 M3 F7 K5 o9 `5 Y
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2