|
|
<?php+ H5 v0 T; h' s+ P2 z' q
function Connect () {
# s- X+ o" \6 T* B1 s7 Q0 c' U+ Emssql_connect('Server','UserName','Password') or die('Error: Connection to DB
% N5 g, U! ~* N" _% H Y. r" g, Z1 D2 y" x
Failed.');
% z7 L0 t7 Q; e: X8 E- h}& H1 P" ~, C2 c- y7 N
Connect();
* A2 Q& @! W- v: b
! A5 |$ F, f8 W# Jfunction InitForm(){7 M5 A0 e3 ^. B1 ~
//layout for the form
[/ T% {* f6 z* Eecho "<strong>Send Items.</strong>
- `4 v2 S$ w! N<form name='select' method='post'>
3 _7 |2 |/ n+ B' a0 n0 I<lable>Character Name</lable><br/>
; U/ X3 j; {8 T' X( m<input type='text' name='char'/><br/>* b) s/ K% D& w9 d) m, D; @) T
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/># \7 P4 R; [6 n7 A+ L8 l$ P; s3 S' y
<input type='text' name='item_name'/><br/>
: {" b& j8 m" q% n2 N- V8 `/ P<lable>Item Amount</lable><br/>
7 P0 H8 S8 s' Y) ]6 B) H<input type='text' name='item_amount'/><br/>
$ a F3 [! X H1 X! T3 C- {<lable>Item Upgrade Amount</lable><br/>* p6 k7 j! Z( W: [0 X
<input type='text' name='item_upgrade'/><br/>
1 F0 v0 K6 K9 x2 L; i5 r M+ C<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
2 s7 ?" J4 w, b) O/ i5 N7 F( O" s, G2 A4 r* M. n
</lable><br/>8 [/ u, F, O! }3 X; H: \
<input type='text' name='item_element'/><br/> M6 J. ?. g5 Q: W Q7 A/ X
<lable>Element Upgrade Amount</lable><br/>
6 o0 V" d4 u9 @3 T! n0 K' R; I<input type='text' name='element_upgrade'/><br/>
: m9 B, U) v& N4 S<lable>Pierced Amount</lable><br/>
$ y4 t2 C; d$ Q% ~* J<input type='text' name='item_pierce'/><br/>9 q( t1 B# g* s6 Z% q& T0 t/ F) V- v
<input type='submit'/>
. M7 a8 E: Z" `</form>";7 k8 k7 D* d$ `# g0 U, R% j% E& Q
}( j9 P1 z) R3 e/ J0 P. `1 c$ @
6 ^6 b0 e% n1 Pfunction PostListener (){$ u3 \4 C8 Z" t. d ~% [8 E& M
//Add more post variables if needed and add them to initform() function aswell
3 t* P/ o% |* W ]4 T$ p
$ B: u: A. B* x6 K################################3 P! R. B! G0 B9 A" x
##### Connection and Post ######) a( D" m: ~: f. s. B4 \4 W
################################$ Y7 N E3 m( I* [
$name = @$_POST['char'];
& M' L5 k" l2 ]( ~$ItemName = @$_POST['item_name'];2 `8 E" n3 r' M2 J) C
$ItemAmount = @$_POST['item_amount'];
% ?$ \" u8 k5 L2 Y' i0 X$ItemId = @$_POST['item_id'];# G* P' {8 g. t
$ItemUpgrade = @$_POST['item_upgrade'];
, D* f5 T5 ^4 i" P( E4 w$ItemElement = @$_POST['item_element'];; L/ T7 @% l5 W; |
$ElementUpgrade = @$_POST['element_upgrade']; L+ J6 X( X% j' `0 s1 p( N
$ItemPierce = @$_POST['item_pierce'];
' U W7 p8 W/ p################################
& m# H2 I% p8 d7 a
! E3 Y( L) l% P" \+ ~0 ?1 h//Check both variables for empty value
" _- ~+ \- o- S3 [
. e7 X( |2 Z- ?- y/ i8 c' h4 y# yif (!empty($_POST['char'])){
) M7 [+ A& H q5 ~% n8 ^- A& b$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
' e0 [/ P; P% e; K N5 V3 c2 R/ {0 V" u0 W
m_szName = '{$name}'");
- ?: C7 m( @3 b" a* nwhile ($row = mssql_fetch_object($find)){
- X+ K# x' s7 r; V3 @/ |& }echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";2 l9 c' [( p5 B: D" J1 ~& j& P! o
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], ) n; ]2 _- S( r) i9 l
4 n5 T: Y7 l" [& @# o0 p" n[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
& n, G: j7 m1 ~- |8 E7 E* ^: ]% H8 F3 P
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', ; k) {2 Y3 s& p: S
" N! H$ q: @. u S9 D" K, w9 XN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
7 n% I7 v' G5 S; _( J8 j
5 b( c* C! N" @4 q9 p'{$ElementUpgrade}', '{$ItemPierce}');");
) `$ G1 o; I. G+ O5 j2 k}
7 l( [' X* f# q4 \9 J& ~6 y
7 z9 l, D% j0 e0 s5 ?4 X}
) A/ S* m4 w5 Z+ q
2 V; [% X; l; X3 W& n& y6 O! c, U}! f; u, }) |; z& I
: x, s8 ?; L& g0 V0 Z$InitForm = InitForm();+ i' d6 ~: j' a* D: k
$Listener = PostListener(); O: t/ r! ~' x, j" K
3 r& W {. q: d/ L
?>, {! x* v) _' w, V8 t+ q# E5 j
- b; s8 q7 l+ Q# d( \
) ]( H( g! Y$ F" i, R) _3 J* T# Q$ I+ L! y$ G
4 u& S" V/ |( t |
|