飞飞世界论坛

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

作者: admin    时间: 2016-1-10 03:43
标题: 物品发送脚本
<?php5 T: D7 H2 q+ t) O6 v9 O4 M
function Connect () {9 ?" n& Z( P$ ~0 H* v
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
& }( |. L( r5 {' d3 Q5 N
6 Q5 j+ U( J5 |" l2 r  P8 qFailed.');
1 I9 A* G6 O7 h; P* |0 [}
/ [$ o! i- S% [# p1 g, hConnect();5 J  h  m- k. q2 @+ X

2 q: a! E& v3 f$ Ofunction InitForm(){' S5 ^. A! y5 k! V2 ?1 e
//layout for the form
3 Z4 c3 d0 h' L. {8 lecho "<strong>Send Items.</strong>- j& E, `0 Q# C( U
<form name='select' method='post'>
% W1 v( |" K  u6 `) r! \<lable>Character Name</lable><br/>8 [" G" R; N4 @" M5 _, N/ ]: u
<input type='text' name='char'/><br/>$ C- v; U2 N* X& f1 o
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
! P7 i( C' b7 I<input type='text' name='item_name'/><br/>% O* i  H& e/ B2 j( F6 j0 y* \$ L
<lable>Item Amount</lable><br/>
; j9 x; C) Z: i' Z2 _) P<input type='text' name='item_amount'/><br/>) H) U: `: @* Z; q# j% n2 i) F
<lable>Item Upgrade Amount</lable><br/>8 W' l; j" x; m. U
<input type='text' name='item_upgrade'/><br/>
3 u' T* Z1 L* U- j0 N, y. ?<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)3 g, F( A# R) r. q6 v1 T, d+ b
! ^8 _. E  R( {1 f
</lable><br/>
7 Q& z" R' \. e' C<input type='text' name='item_element'/><br/>
$ ]3 n( z( c, E! M1 m0 l) u<lable>Element Upgrade Amount</lable><br/>
/ a7 a5 b( W* H<input type='text' name='element_upgrade'/><br/>
* q# T# i; `9 Q& [+ y# _( Z  x<lable>Pierced Amount</lable><br/>
. i3 A2 c) x) e9 u) }<input type='text' name='item_pierce'/><br/>
, F. B+ `+ Y' R( I9 t% t- w5 ~<input type='submit'/>
4 _5 t0 s) [  N- V! s</form>";) g& R+ u  g8 U8 @) e
}
0 ?4 S. p0 g3 Z9 m1 j' f8 K2 k$ p! t2 F. K' L7 e+ ]7 [
function PostListener (){( l2 j1 o% j$ Y. w/ u" @' Y" ~$ @
//Add more post variables if needed and add them to initform() function aswell3 O- S  R# x. y$ c" z9 Z6 j

' a- _' n0 q: i) A8 n$ a################################
) }4 d, q0 j, E4 B( N5 c  I+ E##### Connection and Post ######
. X- ~  [6 V* R& i4 Y################################
) }* @6 E4 S- l/ n& Z  E# i$name = @$_POST['char'];
+ _" R. E. D6 m& H$ItemName = @$_POST['item_name'];
9 g8 Z+ K% h' @+ \3 v$ItemAmount = @$_POST['item_amount'];
# J7 h% C% ^2 H$ItemId = @$_POST['item_id'];
% I2 J4 f+ C9 B0 S+ u& A$ItemUpgrade = @$_POST['item_upgrade'];
. M+ e0 |$ R. F, A' r. K; C! f9 h$ItemElement = @$_POST['item_element'];+ e3 r- c7 t9 |
$ElementUpgrade = @$_POST['element_upgrade'];5 e+ G. T6 ~% {  b3 c
$ItemPierce = @$_POST['item_pierce'];
+ n# a0 y7 V9 R$ v1 b################################9 u- Z0 z, n4 M, I! |4 @* c' O; Q

5 D4 z- B: U" Q//Check both variables for empty value
9 h% n, U" ~% Z; \) W, w
% v3 j; Y/ i! ]& a& iif (!empty($_POST['char'])){
0 `; e& Z8 f# w- x: j$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where 6 g/ g1 h) u: @

1 Y' @3 \, A8 u$ r$ U2 lm_szName = '{$name}'");4 Z% p. E; O- \4 o1 H
while ($row = mssql_fetch_object($find)){7 e4 [$ m5 c; @$ I
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";; P" b9 y* L  ^! ^  W% D0 h: s" ?
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
! L: l# H7 _" p6 M' s1 v1 g, f: F+ ~; A/ J! \* Z
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
, o, v6 r. T0 I# o: f+ L+ m" b0 \: n3 C; n
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', ' X5 z' B3 ^5 M& [/ ~/ `) Q2 o8 _

2 N% N# Y% |1 W* o# ?N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
. q  Q+ o' }! C+ g8 D) p, Y, I' F& t7 S- o6 X3 F
'{$ElementUpgrade}', '{$ItemPierce}');");3 h8 a$ Y3 a3 ]+ I% D( c7 w
}
/ v* i5 K, m2 c2 c
  j6 d, K. M, U}
" k5 T& P7 Z6 Q1 ~" O  u3 B
9 y' m" e4 c/ m$ P! j$ T}
  ]& n+ q0 S# {/ h1 H# }% v  }. H" W' [
$InitForm = InitForm();
- j3 s  R$ e( q7 U4 o$Listener = PostListener();
  d+ t- [/ o/ g( }5 K( k2 P4 q3 n6 {( w3 ?3 ^3 y7 e0 P  O6 b
?>: d/ v2 a) L. Y9 I

7 V: I# P) E; g7 [0 P* i
6 `+ d. e4 w0 {) x0 d9 `) |% ^' ?2 X3 t2 a$ H, o( `& F
9 d+ g( {( W  D5 w





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