飞飞世界论坛

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

作者: admin    时间: 2016-1-10 03:43
标题: 物品发送脚本
<?php
# x$ W& M1 M: X! \0 ifunction Connect () {/ m7 Q: @5 m9 D  O, f- f0 g
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
5 b7 ^, O- a/ r- M3 P
: l/ p2 l: C$ [2 e0 D5 t  _Failed.');
3 v" L  J' u$ z" e: H2 S}) f* }! G# F8 |
Connect();. N9 t* C% f. P, K2 h
1 \, W5 P/ J9 S. h. j6 m$ T
function InitForm(){4 r9 P  c# ?% c# O( P0 k3 ]" ^
//layout for the form1 B$ i1 \/ t3 c. W5 s5 o( O
echo "<strong>Send Items.</strong>
1 {8 l& t, ?$ `6 S. T/ ^0 N6 L/ H1 K<form name='select' method='post'>% Z, t5 Z/ l* R. |9 [% Z/ h* |5 z
<lable>Character Name</lable><br/>
  }/ k8 `9 |1 U. c<input type='text' name='char'/><br/>! K; V/ O- L" b% }
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
5 u$ [" e$ w7 @; x% N<input type='text' name='item_name'/><br/>
! R/ D9 b; b) E<lable>Item Amount</lable><br/>7 c, \" @4 F* N1 U+ W
<input type='text' name='item_amount'/><br/>( Z9 R% b, R$ X. r0 ^  c, }
<lable>Item Upgrade Amount</lable><br/># z8 `6 a. `. W0 m
<input type='text' name='item_upgrade'/><br/>3 F- W) i' N7 b7 E0 A7 W. T$ S4 @
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
9 j- k  j1 f; Z  n7 B  P& A" J8 L7 T3 f4 R3 ~! O5 b9 g: ~
</lable><br/>% @9 ~0 L' \+ g$ ^) e" @4 Z
<input type='text' name='item_element'/><br/>
8 z) N$ V2 ^; x; A<lable>Element Upgrade Amount</lable><br/>
9 v" j' h  l: L) z<input type='text' name='element_upgrade'/><br/>* v3 o0 _. D$ K% G/ p
<lable>Pierced Amount</lable><br/>
  K7 q! O' G8 W5 \! V<input type='text' name='item_pierce'/><br/>
  h7 ]4 s3 I) i3 T<input type='submit'/>2 i, ^: ~( k% X
</form>";
$ I5 S, y8 x; W4 C# M}
# C6 x& q' D0 t, v
6 _& x" v0 Z, J" c. ^function PostListener (){
8 L6 w  O( f6 l4 I9 h9 A& F//Add more post variables if needed and add them to initform() function aswell7 V) h' f. v' c

, M  y  H5 S+ p. G% v################################
2 [" s' {, b: L" s##### Connection and Post ######( {( q$ A4 }7 w# d  E8 n" A- D5 P
################################
$ R: s. K; w4 O/ ]( B$ @0 N$name = @$_POST['char'];
( T' b4 i6 `! R( d8 \1 _( L$ItemName = @$_POST['item_name'];
' _$ X+ h' ^1 A& X2 j1 n% p$ItemAmount = @$_POST['item_amount'];- \( ]5 Q- ~% r9 I" _- Q4 k) H( M
$ItemId = @$_POST['item_id'];
9 I) [; a$ P* T% C; ]. j7 X$ItemUpgrade = @$_POST['item_upgrade'];
: E) E9 C! q1 d9 ^7 F$ItemElement = @$_POST['item_element'];4 c9 q" R9 l. T: q5 ]( ?; k
$ElementUpgrade = @$_POST['element_upgrade'];
2 [+ i4 ?  r) Q! k$ItemPierce = @$_POST['item_pierce'];& a* |5 t, n( q2 H9 m
################################8 Z+ V. \1 d/ G' z3 @
- w+ I% ]6 W( W% ~
//Check both variables for empty value
* r0 p. X0 y: c  m$ e% X3 {- ^9 m+ b1 x2 o& R
if (!empty($_POST['char'])){
  \( |) G1 Y1 b3 ]( T$ @9 G$ G$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where " D# p7 C/ ]6 p2 x! C8 G; X  S1 w
! p9 L/ f6 A3 `
m_szName = '{$name}'");) \7 d/ W" K. s" ^/ |. |
while ($row = mssql_fetch_object($find)){
1 E7 Y) e( K! h8 q7 J0 i% pecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
2 q8 g* p' ^4 e  O" i& u$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], : E2 H( P- f1 F5 P+ x; C
  s* y8 M* k/ ?
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], 0 {2 Y# e& k" U# R) l
- L! c- a5 o7 D4 s* z0 s2 g- u
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
+ S, c8 A- o/ }8 P) T% n+ @7 k
2 T3 G( u% _. l1 @- S/ {N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 9 J% `. X. ?0 Y0 c( F. }) o4 E& P9 u
8 V# }' P9 R* l* X. G2 C
'{$ElementUpgrade}', '{$ItemPierce}');");
1 Z1 f! A$ @3 ]# _# F}
* k, {1 u+ N- N8 z5 g1 Z
4 n: p  c5 N, c; ?}" I/ k5 x) u2 M  X7 r

  r8 Q0 N/ K+ y9 w+ V' C}
7 |6 q% O9 X, U: i8 n& U) p
4 F, T' f$ B: P5 B( O( Z- W$InitForm = InitForm();
$ ^& d4 B3 O8 b  {$Listener = PostListener();
- ^3 f1 ~. I, Q  x' L8 N
9 K1 \( ^) l: e: ]1 t+ Z1 V8 ]?>" D4 ?# S6 }( Z) s' ?; v8 P

3 F: r9 K7 N$ }: z* s8 o; W- P- c+ ^9 f2 @# L) m( g
8 n  m/ D) u: ], o! b3 r/ N/ P# J

( J) n6 A# J3 ?6 i6 {9 d7 w




欢迎光临 飞飞世界论坛 (http://www.ffwold.com/) Powered by Discuz! X3.2