|
|
<?php4 _, L' H/ C+ ~$ z
function Connect () {; ]& c& d& i1 X* K) u& ]/ L
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
! d$ ]1 d; x5 T( ~ M9 h4 f; w! i$ W, f
Failed.');
& |6 H& r2 _! m}
/ n0 W3 _- t) cConnect();
. \# M' I: W) ~, N8 t# R9 Z
U) J# T8 ^! r3 e0 ^function InitForm(){
/ R$ E1 C$ v c* Z* V# `/ d//layout for the form
M; v% J4 ?6 w3 @8 l4 R% O& ]echo "<strong>Send Items.</strong>" [7 T N _6 R
<form name='select' method='post'>
5 E8 m0 F1 `' _! a6 j) I4 o<lable>Character Name</lable><br/># Y4 x$ Y) C& @' N& `* Z
<input type='text' name='char'/><br/>5 _7 a8 B% E8 W4 A& j$ T1 k
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>* t- T- a+ m* b" K1 F. p
<input type='text' name='item_name'/><br/>' |8 F; s& r9 D C" p- A: W9 l
<lable>Item Amount</lable><br/>
1 }/ a# B. _6 q4 _: B9 ~" o) m<input type='text' name='item_amount'/><br/>
9 R) u: D& a4 z<lable>Item Upgrade Amount</lable><br/>
$ v1 ~0 r0 f6 l8 f<input type='text' name='item_upgrade'/><br/># V) H6 u) Q5 T" ]" X" N
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)+ K9 F- u$ c. U% R
( A7 w0 q* t& E f! N! M
</lable><br/>3 o9 \4 Q1 s' F2 x+ E
<input type='text' name='item_element'/><br/>
/ ^9 U1 D' K( \8 [* ]<lable>Element Upgrade Amount</lable><br/>
: v' T6 {/ [& }1 \; i<input type='text' name='element_upgrade'/><br/>
" D9 d; V) `; G' v<lable>Pierced Amount</lable><br/>5 L8 S' _2 v- ^/ F5 Y
<input type='text' name='item_pierce'/><br/>
7 Q; e7 A' @( J' f& p! g) u8 |<input type='submit'/>
( P. R b5 K" W4 k. N# _* Y w. i</form>";) k' x- s' R* Z) p
}
+ t3 S7 B! T; s; f4 N" a: L! C* U$ A3 U( S
function PostListener (){
4 X1 m( z( Y; X/ f- [% a//Add more post variables if needed and add them to initform() function aswell
9 a2 z0 R# X/ \! n8 c/ q% t/ C6 e# H6 L( p4 Z
################################
) n1 q6 A5 b0 ]- M( r k5 p##### Connection and Post ######, n# V2 m. O# X8 H2 B6 X5 P
################################
* C7 [; O3 k" \% i! {+ j( @$name = @$_POST['char'];
t& M. D& _5 r" X4 O3 [$ItemName = @$_POST['item_name'];
# v( Y4 ]4 h7 L: _' M$ItemAmount = @$_POST['item_amount'];9 b6 S- ^: V7 K- U1 F) _
$ItemId = @$_POST['item_id'];2 g$ `/ p- r4 ]. C7 U$ ^
$ItemUpgrade = @$_POST['item_upgrade'];: Y! O# |4 [; M+ f- g1 ?
$ItemElement = @$_POST['item_element'];
: j7 n. j# [2 E4 N& V$ElementUpgrade = @$_POST['element_upgrade'];4 M+ @, D: t$ G5 f
$ItemPierce = @$_POST['item_pierce'];% _ ~5 @& W, P: Z* q6 }8 g
################################
, [' I9 X1 ^! f6 q: t, b
% D- M# J- s! L/ k7 i3 b4 R% ?5 }//Check both variables for empty value c+ u3 B) g* b$ l/ D& m/ }" n$ `
; v% t6 R2 T; M l- \/ ^4 j1 p& I
if (!empty($_POST['char'])){& T- |& V4 T2 d4 }7 _, I( c
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
$ Y% Y* d. O. Y8 E2 ^; s0 y
+ F8 I6 r& M/ ]4 C( h! im_szName = '{$name}'");
, j7 ~0 s7 t/ B) h2 wwhile ($row = mssql_fetch_object($find)){
1 v3 _+ Z2 W# B* ~' i9 decho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";$ V% S ]) m( M6 _1 f8 x* {, ]# }
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], & d. ?5 z' Q' C& j
- t( V R% P- K[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
/ I0 J4 W& F" t" Y/ h& [
9 N' L& D% H6 T( e/ A; o/ {# ?. Q4 L[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', * j0 |1 y; ]# K) C, y% u f
# |: [$ b4 J2 O0 `; t5 S5 }/ E* KN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', $ w/ [5 f) t, C9 h$ y" M& \3 d- d
7 y- i( ~* u8 y3 F) L8 V4 \- h'{$ElementUpgrade}', '{$ItemPierce}');");& t: A/ o* w. i. f* p2 N
}
1 m& Z! |: R0 e! F7 Z0 w3 R6 n" |+ O" u+ D2 k
}
$ I) N" i/ o b9 b& H s* p* s: X c1 ?$ C
}
& X9 p/ Y& D! X) ?: a7 p
! _0 }+ v* M3 {/ U: ~$InitForm = InitForm();4 \ U! V* z, J$ p. J! d
$Listener = PostListener();
; y4 L) U6 j6 t7 t3 E( [ m5 x
6 S# \; d" _& b% @7 C5 W" {?>/ _! [% k$ H0 }! x% H- H. b8 K
$ D6 p8 _ v# v; @" J* j5 b- r z
) l! B) _( R- f' u9 H1 @1 b4 R8 u
% {1 `* v, W5 A1 y; G7 r: T# B
* ?( _; [$ N9 t% L9 M/ K
|
|