|
|
<?php `! m" Q6 _8 S! C
function Connect () {
( v' ^( v5 R7 x/ g3 `0 V( l4 cmssql_connect('Server','UserName','Password') or die('Error: Connection to DB ; [) s4 `% L0 l' J0 @$ T; [
. J: }4 c- \2 @! sFailed.');
" V( D/ R4 {) ~: H/ w}6 }# c: b7 T4 a
Connect();
% M3 B2 A0 e6 M4 D+ j# t- h. V. N# g3 L' a1 r9 R6 A4 A
function InitForm(){5 U) k2 ?( [! I4 P- e% l! }
//layout for the form
$ g8 q( Z9 ~1 @$ a- n' H# Becho "<strong>Send Items.</strong>3 G' I3 [2 M; g0 T
<form name='select' method='post'>
1 X3 M3 C6 [( D1 Y0 c4 \3 X<lable>Character Name</lable><br/>
! ?, q. S! P+ T' R5 D" s<input type='text' name='char'/><br/>( a7 T* Y- T5 }) j
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
0 z/ ~9 p: m& _; f/ z2 o% d- @<input type='text' name='item_name'/><br/>
0 w# Z3 s6 L! |( X( ^* z<lable>Item Amount</lable><br/>! @: D5 C6 g [# D& v
<input type='text' name='item_amount'/><br/>8 C# R# S; x- L) b
<lable>Item Upgrade Amount</lable><br/>8 `$ p: f/ b2 k: l& S* o2 W! L
<input type='text' name='item_upgrade'/><br/>( u3 K( S/ B5 z( c4 V8 E, }
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
* @" I8 r' P1 G$ U! e, @: H* t
3 p3 @0 V5 \) g</lable><br/> J% C: |2 V7 J. u* q- h
<input type='text' name='item_element'/><br/>! R# l" R& B( @
<lable>Element Upgrade Amount</lable><br/>% C8 t8 |% }9 }6 j% O
<input type='text' name='element_upgrade'/><br/>
8 }; m9 R7 r) Z! f<lable>Pierced Amount</lable><br/>1 g2 @* }1 j) O4 n
<input type='text' name='item_pierce'/><br/>9 r. |9 b) ?, a S: Q/ n: @* M/ K
<input type='submit'/>5 v/ ^& d& l* M" f s
</form>"; j) q3 S) E S- P
}
2 r; J6 B- i3 t6 ~: h1 V! K1 G5 W8 {! L
function PostListener (){) _! f+ l& B+ S. ?8 k+ I
//Add more post variables if needed and add them to initform() function aswell1 |+ `' B6 X& k* I: i! H% T
4 C! v& x# Z! h* P8 r2 F$ e* K
################################
0 W1 `, _: q$ t* R" t##### Connection and Post ######3 ~4 v6 B/ x& O- h
################################
C C: a* A' a; F0 W0 a$name = @$_POST['char'];3 w* K2 p& L a; u) b, J
$ItemName = @$_POST['item_name'];
, s( R" B4 M- U$ i$ItemAmount = @$_POST['item_amount'];
. K) `+ U! { Z1 Z( g$ItemId = @$_POST['item_id'];
& c- a$ k" ]1 E& w+ ?# R$ItemUpgrade = @$_POST['item_upgrade'];( E* S7 v/ S7 g4 K+ |
$ItemElement = @$_POST['item_element'];
9 ~3 q _5 l& L( q) ]" ]& w% _8 e$ElementUpgrade = @$_POST['element_upgrade'];
- u0 g, h3 \8 f5 a1 Q$ItemPierce = @$_POST['item_pierce'];, f# v8 m* K$ l6 t5 |+ c8 ]1 x
################################
( n# S w M5 i( N2 m/ z
2 L7 D; L1 u0 j0 N" g//Check both variables for empty value6 A6 E" G# f9 @+ n$ O
0 n8 h0 d2 j: v* `( `$ N7 Vif (!empty($_POST['char'])){- `( S( I9 ]9 S4 Q5 e0 r
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
1 t4 q! ~0 V- N+ V# x
3 p: l) j8 d- @m_szName = '{$name}'");0 s( V4 P* I3 D/ G6 q9 k( |
while ($row = mssql_fetch_object($find)){0 ^2 V; P. _: |2 l* X% i8 X
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";( q/ c# y- S3 h* r" w- X$ J
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
. r* N- j0 W+ B7 O7 o* H7 u6 T% v& I# m0 U0 @+ O
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], + P1 c9 l4 X8 S& B. b% F$ \1 o
2 I7 A |5 G) c[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
3 m {: X% p9 R+ V
9 U+ d( `2 h+ e& rN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', ; v0 n! B- F( s, {1 R4 A7 G
5 i9 x. H' i9 _7 w* @8 a
'{$ElementUpgrade}', '{$ItemPierce}');");4 N; Z7 V0 V& e- [0 H
}7 s( L. ?" f+ T. ]
9 T$ |( f% z, q& V
} x5 \) A! ~& W1 V; \) u
* a# j4 q' f! I' O/ D$ J7 I; V
}3 k' u2 r# I6 B# A1 X
" W* F7 A, H! y! z$InitForm = InitForm();! T& j6 j; \- Q
$Listener = PostListener();
# I9 P# S6 q! U6 E0 L) x0 a( ~
4 k6 X4 w, D$ I8 ]: c, ^% ]9 f0 H?>7 K! V. V- B1 V; A6 a: C+ f
3 \+ ^* e3 ^/ s+ X/ \
" l" }4 K" t8 k& E! u2 N8 Y# F$ O2 f7 z! N" c
' s, T( a0 ^/ O( W% S
|
|