|
<?php
, M5 C. \6 Q# c* [; {5 n6 {function Connect () {
! ]. H2 i5 h0 |mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
' v- W) J" ^4 n
& K. `2 V c/ ~/ h* d- KFailed.');& E" o$ e- O) l7 o3 ?
}8 S. E$ H2 v0 B6 w7 j' J! N* [& X
Connect();
' l R& p# E2 f: F5 y
9 V9 P, R. l7 z$ g" Yfunction InitForm(){% \6 I+ R* E7 U8 T* P. e n
//layout for the form/ x! Y3 D3 s N* S
echo "<strong>Send Items.</strong> \4 ?. ?8 U1 d" ? g0 m
<form name='select' method='post'>
# C/ C, t( G% T, \+ t- W& G& e<lable>Character Name</lable><br/>
- A; U- O+ E/ T# b* n0 Y# ^: M6 r<input type='text' name='char'/><br/>
9 z" P$ }! ?* C- `<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>) V' s$ T2 B$ i Q
<input type='text' name='item_name'/><br/>
" S6 B& F- {: l. Q$ s<lable>Item Amount</lable><br/>
( U* @ l( L$ E8 l) u<input type='text' name='item_amount'/><br/>/ U2 J7 D8 l; @; i1 t. S
<lable>Item Upgrade Amount</lable><br/>' k) b$ @" @5 J3 E- |+ B U
<input type='text' name='item_upgrade'/><br/>$ l" O( f, D8 C( c. t
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)# h- A- U S3 M; n7 B S
; z; K/ b0 f* r9 |
</lable><br/>
" A6 ^0 j3 ^' g( Y<input type='text' name='item_element'/><br/>
4 W' u1 H0 v$ R/ u6 K% {# V<lable>Element Upgrade Amount</lable><br/>' {( a/ e v6 B
<input type='text' name='element_upgrade'/><br/>
. ~4 y+ V* E7 n; u% \& S<lable>Pierced Amount</lable><br/>- W' i3 P% ?7 [0 h0 J9 G, Y* e8 j
<input type='text' name='item_pierce'/><br/>
# i# }+ a3 h- w<input type='submit'/>& E. N. ]7 u5 |" a; s
</form>";
0 R/ T5 e! b7 O5 ?. {: U! X* Y3 G! Z}
& Y8 s# `$ B( B8 ^* l4 x, i F8 T: u% A% n: f+ L( L
function PostListener (){
, |0 l5 l- T6 J5 g( y5 \/ T//Add more post variables if needed and add them to initform() function aswell
! P$ `, s8 W+ x6 ?* V% ?6 [& g" m; A! q- h1 G
################################
- f, l3 n4 x" G g, D8 _: m+ _##### Connection and Post ######
1 e* n! \5 n2 Z0 h& {) ?& t################################/ j c4 w: ~ ~) J9 {6 {* c2 I* L; q
$name = @$_POST['char'];3 {/ K- l/ w' e- e; [
$ItemName = @$_POST['item_name'];
/ K! A5 H8 H% P; ], v$ItemAmount = @$_POST['item_amount'];9 \2 n$ G5 y$ {2 {* P$ }) I
$ItemId = @$_POST['item_id'];) v% I4 b4 K2 w$ I" H: ?
$ItemUpgrade = @$_POST['item_upgrade'];2 t9 u2 d2 l% k$ S% u9 D0 t
$ItemElement = @$_POST['item_element'];3 c- x$ V- `# ], w! Q5 o
$ElementUpgrade = @$_POST['element_upgrade'];
5 V" R |7 ^' H$ItemPierce = @$_POST['item_pierce'];) `& a6 \) s( t/ p& n
################################% V% [# t1 l% L
; c( s* q+ J& W A) v' J
//Check both variables for empty value
; Q- X) v8 k8 ?! d' m3 d, e |+ K, A2 y9 t1 p
if (!empty($_POST['char'])){/ t) t: K, H0 A+ Z& n0 ]$ P
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
) g M7 s+ `; p. o4 i; e4 ?* }! [# Y+ S( r' n8 [+ q3 |3 y+ g$ r. t3 L
m_szName = '{$name}'");5 d# [( L8 O* Z6 {$ {& l2 D
while ($row = mssql_fetch_object($find)){- c. ~$ r b: @& _$ b: ~
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
* ^ e- l# [1 ^. [$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
- n- n& a( @, h$ B
/ [$ b' e+ G4 e$ _[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], + V7 M \! j- E. B' L. J6 ~' s
* r2 L( |0 V1 N6 U
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', $ \1 S4 H! ]0 i$ m
, }! r6 @0 M; K; t
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
( {" G9 b. E! l9 n" _- m$ q5 s4 c- w* @* |" B
'{$ElementUpgrade}', '{$ItemPierce}');");# P9 _4 C9 @2 [- ~3 G, W
}% Q( ^0 g& Z9 d
) @0 s( @8 Z, ^* U2 |# Q8 I0 i
}
$ ], V" p5 g& x# m& T
/ e; e9 s0 j" ^6 c2 e5 [) P9 H/ I, V}$ }% {. i& h8 ~& U# M7 D
2 D9 e, p3 ^- f% h; o$InitForm = InitForm();; w) Y x3 Z0 Q w" a$ ^7 O& u. @
$Listener = PostListener();& ]0 f7 S: K) f+ j3 q4 v; z) g! r
) b) Y$ L( U! u?>0 R+ R5 m7 p3 ^6 m: `" v
" z- ^) E- s. `& w' y! p
1 h; u/ L, P' E" D& P& Z0 O. L
$ u4 o% F2 D" m1 e" Y$ @
8 P M2 Q( ~0 \3 E$ J9 h/ t |
|