飞飞世界论坛

标题: 物品发送脚本 [打印本页]

作者: 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( \# _; BConnect();
. 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! hecho "<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$ jfunction 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) N0 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 xecho "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 wN'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