|
|
<?php9 R- z/ J+ h# I3 S
function Connect () {# p1 S$ U* X1 H. c
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB 7 A& f) ~; s: o) D9 p
) e' ^5 t: e; N) J8 s$ U$ ?Failed.');5 N: l( G0 \ |9 N( @! |
}
" {: z* U( a2 A- h6 w" e& GConnect();
K' W u7 `/ W9 k" K _) o2 F
5 h" B7 ]/ c& Q+ xfunction InitForm(){
( O+ d9 u1 L2 `) N" N//layout for the form
: _ Y7 o, ?/ l% Cecho "<strong>Send Items.</strong>
4 q% H: T; ?3 N9 ^4 h! o& ]7 a<form name='select' method='post'>
* C' X X( o8 ]<lable>Character Name</lable><br/>
/ K5 |, t. e. ?1 u/ K, x `<input type='text' name='char'/><br/>" D' ]* B Q8 ]( ^7 ]8 o) T
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>5 l6 S9 y' i$ O0 \0 i9 H
<input type='text' name='item_name'/><br/>' y7 V* ~3 |& H z$ D' e( ]
<lable>Item Amount</lable><br/>
5 n* l0 {) m5 L4 g7 e8 T. t6 S<input type='text' name='item_amount'/><br/>
/ [8 J+ t/ l. S4 A) | F<lable>Item Upgrade Amount</lable><br/>% K4 M6 j% R. _' H
<input type='text' name='item_upgrade'/><br/>
' i& X2 S9 w, @' a4 j<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)" C' g6 J8 n% R( G
0 S$ h$ V1 l( R9 `: g
</lable><br/>
- J( x3 G$ A8 W. w! k" Z<input type='text' name='item_element'/><br/>, U' O3 l5 F+ g, F
<lable>Element Upgrade Amount</lable><br/>* d) |1 Z8 J1 ~4 c3 j. e8 w' K
<input type='text' name='element_upgrade'/><br/>
& U3 C7 B# {- y<lable>Pierced Amount</lable><br/>% u T; X6 H* }% g4 M. b# d
<input type='text' name='item_pierce'/><br/>1 |: e. p0 S* m# a. D* i# f/ Y
<input type='submit'/>
% B" n8 Z f7 o2 ~" Q</form>";
6 H( m. \3 c2 E9 w}6 G3 u" } c0 P. p3 M
{6 D& f* K5 C+ w+ h! b" Bfunction PostListener (){
/ f B- p+ b4 k+ d/ ]& f//Add more post variables if needed and add them to initform() function aswell6 i2 z9 w* R T1 t" ?
$ R' c. p$ D1 X! U1 j; A
################################' m& x+ g" j/ }" q' h( ]
##### Connection and Post ######* J* n, E) m) V' m, T d! n$ `' u L2 a
################################5 f0 @; J# I: `8 _
$name = @$_POST['char'];
3 B( v) W" `- P5 g% T$ItemName = @$_POST['item_name'];9 t8 ~: I6 r& \5 I- n
$ItemAmount = @$_POST['item_amount'];
4 j3 y: r1 X; x/ V! T$ItemId = @$_POST['item_id'];/ m4 R3 {/ U" C
$ItemUpgrade = @$_POST['item_upgrade'];
4 ?" D$ k1 u8 z, |% n$ItemElement = @$_POST['item_element'];: L, ~5 g! e; P6 G4 ^
$ElementUpgrade = @$_POST['element_upgrade'];2 _8 G2 B' B) `; |' w* |; l& n
$ItemPierce = @$_POST['item_pierce'];' N! L1 s; M D( e
################################$ |7 x7 N2 {6 ]# G
" f9 ?! u& v& X5 \8 e7 `
//Check both variables for empty value7 k6 A, \' w% o1 f
8 X9 \* ?$ W; s M- @& M. t1 O. Rif (!empty($_POST['char'])){4 H% x; X( p0 k1 i. E
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
; o0 T2 j1 C! S& h1 v
* n3 s7 q) Q: [* L2 t8 _m_szName = '{$name}'");
8 d. g [6 Y. n# cwhile ($row = mssql_fetch_object($find)){' b4 s; m9 P* P* W% S2 ^( Q+ Q3 S. f
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";% q4 p7 I- \! i8 j. m( H3 c8 E
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
" b4 Y2 `" Y$ T o1 I! ?) F2 W B- S' d
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
5 j" t( n. d- h( j/ z4 ~# p
$ z8 r. B1 Y( ]( p) ^[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 0 t9 A% o' h) ?! ]
! F( j$ J) U( U8 B* ~/ V
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 9 I; [. l& [, {! ?9 x9 n
( D5 W* a7 c! U$ I2 n" `; x: z
'{$ElementUpgrade}', '{$ItemPierce}');");, q$ C0 o( v v+ Y# f: a. a4 M
}( M4 B( _1 }4 l7 V7 E9 [) j- H2 n
$ \& |$ i, f0 i}! u' A% T$ _. q& p$ ]4 D
4 r. K* K' ]1 Q2 ]* E9 z
}
4 B2 i8 }8 A! j
+ M! G% b2 ]0 @ ], ]# L$InitForm = InitForm();
X% `: H( ]" Y' ~$Listener = PostListener();
7 w' A4 I1 c8 S3 K9 G: _! \! P; M. H' j3 d* `' `" G/ n
?>% f9 Q" |$ Z! j8 v9 g9 N- K
" Z$ G: g8 S) u( g* R
9 P" G4 E# e5 D# r- L
) u+ ^! A% I' U. I# B; i- n; k9 X) M1 \" p
|
|