|
<?php. ~4 O2 [5 U) r! S
function Connect () {
z5 x |" R8 |* k6 G: Gmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
3 c2 O, P0 S3 D; x5 v6 J8 ^2 V
9 E/ l/ h M- [- U& N1 UFailed.');3 J0 R0 w. D- R
}
) e( `! `6 _4 sConnect();
P/ z" t. }) U
3 q" W6 i `0 n4 zfunction InitForm(){ n5 p8 |; U6 M
//layout for the form
% r, O- F& e, U" becho "<strong>Send Items.</strong>9 H$ B2 }6 o5 e
<form name='select' method='post'>- h T) |: z+ `/ Z7 X
<lable>Character Name</lable><br/>6 Z/ _9 P H0 d- s# [! U
<input type='text' name='char'/><br/>
+ D/ m! G3 f4 L9 G& R: m- L<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
( e0 C0 v2 ~& T" w3 g<input type='text' name='item_name'/><br/>% V% N0 v# I# b; ^. j' I5 i
<lable>Item Amount</lable><br/>4 L7 a& K! U) d% N4 U) F
<input type='text' name='item_amount'/><br/>
% o/ q5 L! g4 \& o; ?$ Y<lable>Item Upgrade Amount</lable><br/>
+ v/ w. r; n3 ^! m! _7 c4 j<input type='text' name='item_upgrade'/><br/>
5 C0 m0 K5 P- ^" h" m* \1 p. c<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)+ x8 z; t* q, G3 H6 T/ M( T3 h9 z
& @: Y# I2 {* o# h' c</lable><br/>
. j( f: ]' K, o9 }; m( B<input type='text' name='item_element'/><br/>
( E- v! v5 j6 p% Y% b( } |<lable>Element Upgrade Amount</lable><br/>
* M* J& U- C' }6 p' z/ y+ K8 h<input type='text' name='element_upgrade'/><br/>
+ i3 c# P4 ], w4 W0 K8 ?0 U<lable>Pierced Amount</lable><br/>
- |3 `: M( ?$ i<input type='text' name='item_pierce'/><br/>
B, N( H& b, k# m+ f<input type='submit'/>
# K- J( ]1 q$ e# N0 N# t</form>";. w- H2 a9 {* k: R3 n' e, K- l
}) s5 t% P& ~; h9 B* ?4 E
- {, J/ Q$ S( r, f) hfunction PostListener (){
7 ?- a0 L2 K. ]+ o//Add more post variables if needed and add them to initform() function aswell' D9 x5 ]. {# {) r' t5 Y- z% s8 O
6 N+ L) m; F D; S8 {' U. g
################################
. O/ S& E1 y! @8 y9 P##### Connection and Post ######3 ^, H2 h1 \$ T
################################; u5 Z6 j3 w& C5 o3 Y6 U
$name = @$_POST['char'];
" _ z: p6 t7 n' |' u$ItemName = @$_POST['item_name'];
9 g D6 X9 v# z; q$ItemAmount = @$_POST['item_amount'];
( P/ f3 I% R" ~9 Y1 F5 P5 j& O) s$ItemId = @$_POST['item_id'];8 y5 I+ }* f- Q
$ItemUpgrade = @$_POST['item_upgrade'];
. T$ w6 O% `$ q e$ItemElement = @$_POST['item_element'];* R( ~! C) |* ]- |% a) D
$ElementUpgrade = @$_POST['element_upgrade'];. S7 G1 \1 R3 n9 A7 M+ G% W
$ItemPierce = @$_POST['item_pierce'];' l; X$ y, o+ Q* o( W
################################
/ J" ]- ?" H3 n; G3 t% j. k* w) o/ `+ ~. l
//Check both variables for empty value
$ A. y7 i/ I) a) f5 t/ o6 q
) X/ Y2 }/ z- Oif (!empty($_POST['char'])){0 G& V: P1 H$ _& D8 r
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
/ R* o$ K- |, |8 C
& G$ i0 ]$ e- d) Hm_szName = '{$name}'");
5 Z8 \$ r, s, ]! X& W8 o9 Nwhile ($row = mssql_fetch_object($find)){
: u, G) w. s" v5 T( |4 b3 Recho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";0 a3 }. E! b% m
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
' H* f! Q4 p4 h# H- |& P$ T- K; \: }3 y- k# a$ f M% b( G4 Q
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], 7 C) ^- n5 `$ E1 l9 k
$ p$ B. x7 H) p& h
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', / y- ~' j0 k) S% a. g: I% F& z
7 D, G/ U( f# [
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
0 L% T4 j6 K- o0 ]9 Q
0 @; M1 u! S+ }/ y$ d8 }'{$ElementUpgrade}', '{$ItemPierce}');");. d! l: ~; q0 D# l) s# h% M
}
+ y, V' t, A3 e- h$ n' x
' x1 I( l& z. t- ]( P$ f( y}
! e( o3 m8 l6 W% O. q( M
6 M7 |9 ? v# {" o. x}7 m, s4 S+ d4 ]. i X; ?
' }: h* O5 M# y% g
$InitForm = InitForm();. d. ^2 y) Z4 s/ z" ^4 K, d9 K
$Listener = PostListener();
$ E; A1 Y* @6 _1 X; ^( q) `0 r u: D; n4 F* H4 M5 S* y
?>3 _* S! _7 p. ]( J# d# [
& ?5 n8 ? }& W6 ?
- G1 X7 S; i: `4 d! T9 r$ e) z& C
; l* j5 q* _7 i5 g% m6 u; M
% l! X+ w$ V4 s( y |
|