|
|
<?php3 A) C* o: [! f! E X! L
function Connect () {
1 |. b4 J' t5 G/ Omssql_connect('Server','UserName','Password') or die('Error: Connection to DB
3 {4 f, i$ o# _
" z0 a7 U" o+ j! z$ IFailed.');
) E7 r& G- I" y% T1 c}
7 W- ~ z! B4 K% @! IConnect();
2 e- z" m) n# K$ W' `
1 N: S5 T" N- ]2 R6 v" zfunction InitForm(){3 G8 Y2 j0 Y1 B( F* C
//layout for the form
: S% f! |. N4 u0 L. O: X2 gecho "<strong>Send Items.</strong>
2 J) N* C+ ~: q4 m" N1 S" O4 W<form name='select' method='post'>1 I p+ d) h- q" {+ X
<lable>Character Name</lable><br/>' q! e/ D6 _5 A" N$ h& A
<input type='text' name='char'/><br/>
+ g& U4 V' A( d6 C2 {1 I# a<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>0 i6 s& q* m1 k5 d! {# F5 w$ x% w
<input type='text' name='item_name'/><br/>
7 {4 p& b& G$ Z* T g: o<lable>Item Amount</lable><br/>
4 o6 p& j5 Q3 i& N$ x4 X+ f<input type='text' name='item_amount'/><br/>
5 w6 t3 L O' N5 d<lable>Item Upgrade Amount</lable><br/>
8 o- U, P* ?1 ?! @<input type='text' name='item_upgrade'/><br/>+ `* o, q* [; ?* R6 Y
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)4 L- M6 F* J( z, U
0 s% d |4 d- z. G' U</lable><br/>
$ S* e' ^/ Z6 k4 I- F. p<input type='text' name='item_element'/><br/>6 N4 c m" S. `7 E
<lable>Element Upgrade Amount</lable><br/>* C- i' R4 O+ `1 f7 a, a+ U
<input type='text' name='element_upgrade'/><br/>+ H; b8 I, l3 A- O
<lable>Pierced Amount</lable><br/>
7 a2 K% G \4 v) S<input type='text' name='item_pierce'/><br/>
+ b7 ^+ p! L! g<input type='submit'/>' T* h9 ?( B9 d- u4 q, }
</form>";# x2 I$ [$ _# C1 c6 {# G
}
! L1 b. v- M$ S. q% [/ f9 l, G; u4 ^8 |6 d, L' s a
function PostListener (){$ C% q# P4 D1 {: y2 b! s' J3 C
//Add more post variables if needed and add them to initform() function aswell
0 S/ K* @) [2 d' C( z# ~. Q; v5 s+ K. J! g/ m8 t/ B) N
################################: j) L4 B' e6 z: E
##### Connection and Post ###### E# E" v- q% l$ _- c) L+ ?
################################& c" W" C. u: D+ r( g* {% O
$name = @$_POST['char'];
2 ^) K3 ^1 _% a$ItemName = @$_POST['item_name'];
d; I3 Y+ ^* [$ItemAmount = @$_POST['item_amount'];. a p4 f8 {) [
$ItemId = @$_POST['item_id'];
* P8 f, a+ A! Q$ M% _. p% X: G$ItemUpgrade = @$_POST['item_upgrade'];- J$ }3 i1 U. U3 t9 P" A- S
$ItemElement = @$_POST['item_element'];! n# M! [, |# w# {) V2 G1 b( Z
$ElementUpgrade = @$_POST['element_upgrade'];
1 |, W; R. q2 ]$ItemPierce = @$_POST['item_pierce'];- o- U% w8 E. o0 h, \" W
################################9 |# ]" r) v- z) g
9 g" ?( A- n8 y8 R//Check both variables for empty value2 S" k7 s1 w* @* N/ R0 Q
5 b; x5 d) [9 d9 S ]' r' H! o
if (!empty($_POST['char'])){
6 g9 R, J1 o+ X1 X$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
/ r& H' \5 n m
4 p4 d& m/ u: Km_szName = '{$name}'");' p/ @1 d7 S9 K, d4 a) W9 h* a
while ($row = mssql_fetch_object($find)){( h+ G& t. I4 @/ J( l5 s4 I
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
; k8 p6 l6 [( y5 E2 [$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], C1 G& n7 D5 \8 o
) p, B2 O( ^; g9 C5 S- B
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
* {- B ?& J7 Q4 r5 `% z( q2 A- c7 J6 M! d7 V
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
1 w; M% p6 i2 W* F$ |8 C. Z) [: _5 ]
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', * @3 \8 S( O2 }! o" ~
, i$ _! o# S& n8 }' a" `- ~3 Z7 o'{$ElementUpgrade}', '{$ItemPierce}');");- E' b. s; R2 x/ ^$ e( F* Q
}
$ `, @6 O* A4 L: W8 b- }* M
5 A9 G: s/ q& c7 ^}) ~6 [- r: M+ m! L: K! a
" U2 k$ _! x8 u
}" t( T* N* b6 @ s4 y1 ~/ O
( l" ^0 z- {+ G5 |! o
$InitForm = InitForm();% e, \" ] @- o, a# G: l4 u# Z
$Listener = PostListener();; _. Z7 O5 {3 A: _ ?0 y, q
; _+ y9 x7 ]+ c; v: N+ Y* I?>$ ^9 h, S( f* v5 N$ r. N8 ~
3 B$ h+ z+ J( \+ i+ B) f' h
0 G' @" E8 Q. p' i8 Z1 z6 A: \$ T1 P# l- f& Z. Y" b
+ I+ P3 w! h& ] E0 p: b |
|