|
|
<?php
5 \3 N7 c8 x, R0 n! zfunction Connect () {) [ s; a- n) t# k6 k
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
' q$ ]- b& j, J) P; e I- Y& N; z+ D' R# [& Y6 m
Failed.');& d& E' |; o, v! d# ]
} z) @, e3 ^, L9 Y# r
Connect();# t F* C- Z L
( S% j% D8 H) |4 A0 Q: Mfunction InitForm(){
) S: C2 a% o6 l0 s& \' D% ]5 ?- `//layout for the form/ G4 V$ `$ {$ O. B; g5 S+ R7 y
echo "<strong>Send Items.</strong>2 I G- f" D, f: K. g
<form name='select' method='post'>
1 W" z5 b# ]4 _0 d/ r4 d<lable>Character Name</lable><br/>" d. [2 H. q% E" C" _& m
<input type='text' name='char'/><br/>
3 O4 W# U% }& ?- k- J# ?<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>. X1 N7 x3 P: e& }2 {6 w: Z
<input type='text' name='item_name'/><br/>8 t r$ i3 J: k( `2 `9 ]
<lable>Item Amount</lable><br/> Y1 V$ m S) z0 R. A
<input type='text' name='item_amount'/><br/> |- T9 P6 A1 i9 Y( ~. }
<lable>Item Upgrade Amount</lable><br/>
8 R6 b2 f- v* l4 l0 t<input type='text' name='item_upgrade'/><br/>; Q a. ?) b5 W2 H6 S3 j$ e5 G( h3 a3 q
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)$ t& Z, ]* L5 ]/ {1 e/ e; K/ L
$ c6 D" C6 |+ u8 p1 n( V
</lable><br/>
! P2 A+ ]0 D& I<input type='text' name='item_element'/><br/>
: W2 n$ t5 Y# j) n; a# o* g+ `<lable>Element Upgrade Amount</lable><br/>
) }( T' O% J& M& c& J<input type='text' name='element_upgrade'/><br/> H7 L! H& Y& U: p
<lable>Pierced Amount</lable><br/>
- S/ c0 h2 G. [# ^, k" o' W0 H# n<input type='text' name='item_pierce'/><br/>
# j5 n' B5 O B<input type='submit'/>
s+ }% U# v! k3 D6 T. w! ~</form>";
0 A2 F$ q& _( c( ]}
w1 U6 R+ G1 j6 \
" ~4 v' p/ w/ j, Ifunction PostListener (){
l* T6 W8 o. z! Q9 K( u//Add more post variables if needed and add them to initform() function aswell
2 I' h& L# X- F
8 S; l* c* D; J# G- e$ L0 x" ^6 l################################
6 u4 |' a r! @##### Connection and Post ######
1 g- J" G" g9 n7 z4 T1 W################################8 n' v) u, _! a' _4 y9 K
$name = @$_POST['char'];
& [$ n' P7 p+ x$ItemName = @$_POST['item_name'];: A: b: E% p8 {9 @" d: \4 }
$ItemAmount = @$_POST['item_amount'];
5 ~# f1 l5 R! f) S; g) I, n$ItemId = @$_POST['item_id'];
# {; v3 r; `$ c% t& _6 `! g3 b0 ]$ItemUpgrade = @$_POST['item_upgrade'];
% G/ `5 J& l, x; u# J$ItemElement = @$_POST['item_element'];! Z" w$ N7 h0 [0 ^
$ElementUpgrade = @$_POST['element_upgrade'];, r$ E, T' F! r: l7 ?% ]0 x9 ^
$ItemPierce = @$_POST['item_pierce'];. S0 h8 b5 V+ u: ]9 y
################################
: Q& F$ k4 e6 I' ?" L8 Q7 x9 N1 \$ V
//Check both variables for empty value7 `& x5 L* V* u7 F
6 e3 K; g- \4 h4 P( d
if (!empty($_POST['char'])){
( L- M+ H* f c, M$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
/ D, R/ M1 |& Y9 \' u6 I( b$ n5 s3 q1 l% l; y- ^& m
m_szName = '{$name}'");
5 i: j6 k) y' h& Pwhile ($row = mssql_fetch_object($find)){
" v% Z' B! Q. ^; [; v9 Z" ?* T0 xecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";4 Q+ a2 l4 ~: }" Y7 H
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
4 Y; b8 G" H' t* X m Z+ j! K
% m% f0 s$ s. s) K[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], : h% D$ y7 j. }- n- W) _1 I
- \, g$ K* \2 a2 Z
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', # T3 ?/ n8 b9 E7 J7 x+ |/ x2 }+ W
; A! {8 Q. x2 ?, `9 x
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', ; ~+ m/ F+ Z# e/ p
7 ?& c0 I- z: e! \0 u3 X+ `. W
'{$ElementUpgrade}', '{$ItemPierce}');");
& g0 s7 U" j! }. r$ W}: a: K, P) D, c- |0 I! t( U. r
8 G2 E3 p/ }7 U c
}
; {9 Q5 B& {) A, I
% R4 `2 L( K n: M D m( u6 Y}! J( T' ^# n: Y: g- X Z
- E7 q! L R! P
$InitForm = InitForm(); M& B" u* W( L( ^- u: q8 w
$Listener = PostListener();+ q* Z( e: W% k; _& ~
& r1 z1 q+ k: R6 _7 d5 ]& m d?>
( N) A; f- b; I5 V3 n" R2 S9 z7 `0 T4 Q* H/ T4 N* F6 g
6 S' T6 m2 s& \ l
+ ?! d% s# p( N2 F" d7 N
) P4 {) N' @$ i. y: T
|
|