|
|
<?php& _2 T8 u3 W; F) \# V$ j
function Connect () {
/ q! P( Y* S+ @5 O/ A4 F+ U, Amssql_connect('Server','UserName','Password') or die('Error: Connection to DB # @5 C$ o2 m* M5 s. U
3 |+ e8 a# l2 e6 C z$ f$ E/ aFailed.');
S5 w f% E/ s( P( b1 X7 D4 ~}6 d; p' ^- U" L) N& ^3 ~
Connect();& @$ v1 f% T, k. u o
2 |: t. ^9 W# k4 d. f
function InitForm(){( T% O) s" @1 z/ y8 g& @' `0 g
//layout for the form: {1 D' B! S) f1 w3 C0 M* H4 P
echo "<strong>Send Items.</strong>/ ^$ E7 E9 R3 {) N8 Y
<form name='select' method='post'> I4 V. }, t; F) v3 }+ H! i8 C
<lable>Character Name</lable><br/>0 r3 e1 e3 Y2 k* s3 a
<input type='text' name='char'/><br/>
8 H" e$ T( e$ f( m<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
8 L2 N+ O) p" E<input type='text' name='item_name'/><br/>" i/ D) A% z `% \ J
<lable>Item Amount</lable><br/>+ Q7 Z' r: z1 {' Q v% b
<input type='text' name='item_amount'/><br/>
4 J9 u+ s4 w# S) `) ]# w3 L<lable>Item Upgrade Amount</lable><br/>
8 Y" P5 f8 C' L; u& `# G' b7 N<input type='text' name='item_upgrade'/><br/>; C5 d& Y. L9 r% k) t7 q u
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)! B5 }% ?& T2 X3 ?6 d- N
" E" O$ ?/ V6 K0 @% m1 k
</lable><br/>
- u0 C! {5 w) t<input type='text' name='item_element'/><br/>
; r4 N! D* H. f6 C8 L) M, m6 C9 F, |<lable>Element Upgrade Amount</lable><br/>
( D0 v( A, R6 f1 M# O& t4 P2 h' o<input type='text' name='element_upgrade'/><br/>/ p, K; J& V3 [6 `5 a5 g& d% b
<lable>Pierced Amount</lable><br/>
4 l+ ?+ K& p8 C f9 t2 c/ E; j<input type='text' name='item_pierce'/><br/>* @, i9 ^! a: J. F& x4 `
<input type='submit'/>
& X2 ]2 r! H/ u+ A) _) _</form>";
: i$ z6 g1 j8 p3 x8 E}
3 U+ R% @. u$ P$ }$ c# i1 d; x0 [
function PostListener (){
8 V% y5 `% U' H \, c//Add more post variables if needed and add them to initform() function aswell$ |0 j: E/ z# l. \! k, o
, J( ~% c% H5 R* ?# l% ]6 S
################################
1 z( f5 E/ @8 T R$ t##### Connection and Post ######& H% Y; b3 ]! F) [4 c/ U4 D0 y
################################, y/ D5 I3 k6 s2 A
$name = @$_POST['char'];) N- l4 C! H7 T5 h4 _
$ItemName = @$_POST['item_name'];
2 G5 Y4 B( _% k7 F9 f4 V' d$ItemAmount = @$_POST['item_amount'];
j2 d, v! ~9 a: D0 u5 F) m) ~$ItemId = @$_POST['item_id'];
5 x" c8 N: X7 ]4 G$ G/ W$ItemUpgrade = @$_POST['item_upgrade'];
! ^8 o$ Z5 g/ T: L$ItemElement = @$_POST['item_element'];
0 B2 ?# m9 ?' V0 Q$ H$ElementUpgrade = @$_POST['element_upgrade'];
3 ?' g; u7 U5 ]+ e8 G% ^$ItemPierce = @$_POST['item_pierce'];
' D. m/ f6 S& ^8 D) t* i3 Y################################
: u5 v5 Z, C1 R v( J
% U! r& t# H* Q2 X. H, i//Check both variables for empty value
1 p- ?5 i) @+ N3 O6 f2 _2 H
+ C. F' G# T. f3 z( |( v+ P4 @if (!empty($_POST['char'])){5 o& U7 ~: q, J5 x" ~
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
) z# z6 w: Y2 M' o8 x3 x+ L7 C& l- {0 G
m_szName = '{$name}'");
2 r G9 L8 W" T, Awhile ($row = mssql_fetch_object($find)){
1 X, j) s. g" l8 b: ~/ pecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";( q/ T- c$ E$ P* U' v
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
1 c# [, g) }% U" o0 @/ @1 B0 D7 j4 J- [/ v
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], $ v5 [4 u, B" t4 ?! J
" a) i U) p( t! Q b8 A[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 3 K1 j; j1 g3 I% _4 Q
. H' q: ~/ \, {( O
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
. @ x( k+ _6 v' b% c& L
9 S; Z- B0 c# Q: @8 }'{$ElementUpgrade}', '{$ItemPierce}');");' ~4 r2 ` u- Q n& v
}( I/ q: }4 R6 P* S
; O. Z( X% R9 E0 S4 J9 E6 a}
" Z8 b$ p/ W. z. r( E
; e& a& k4 g% ?. b* x+ h}
/ K/ \6 o: q- S% f4 o5 A7 T+ _. ?
$InitForm = InitForm();; t' G8 ~; y3 n/ |( g6 y
$Listener = PostListener();: q4 }$ l3 U2 m8 k! m8 A( z; v3 j
' O: Q; n3 V" b9 [4 d$ r4 c- L& p2 Y" s8 J
?>6 L/ O+ e( h) Y% Y( f
) `( J0 G s0 ^# p B: O% l' b- l% b# S6 I, ~1 @; u
5 K+ ?, B8 C& \0 q* a1 R3 _- i( w0 U# D4 A8 S9 g
|
|