|
|
<?php# S/ R/ n/ ~5 G7 y
function Connect () {, M% O8 o& @! G
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
3 q% E& ]8 J5 _) s5 a6 x* x+ j6 E
Failed.');$ z$ E y! X6 {- A, w
}& W8 {' X3 f1 u/ i
Connect();/ H6 C& ^$ h& E( O' p6 \
2 I6 z. j+ I0 A/ S) W. {
function InitForm(){
9 k" A" [9 `' N# ]# H//layout for the form
' b# ?/ |# _( U9 C8 B7 _& }- necho "<strong>Send Items.</strong>+ b7 c" ~# b9 L( D7 \6 w% [) y
<form name='select' method='post'>7 R8 G+ L2 V A4 I! j
<lable>Character Name</lable><br/>1 q: w1 F, _1 K& J7 Z3 G# [5 n
<input type='text' name='char'/><br/>
1 Y7 u a! c) I* i<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>2 ]6 ^1 o3 d8 v9 c# z* f
<input type='text' name='item_name'/><br/>
" U( {! A% V, f/ i9 g8 t7 R<lable>Item Amount</lable><br/>
/ Y5 J! _, g0 \# O# @<input type='text' name='item_amount'/><br/>8 M" R \2 x( Q) R* ?; p1 P1 A
<lable>Item Upgrade Amount</lable><br/>
" @$ W0 E+ V+ S. y! U<input type='text' name='item_upgrade'/><br/>7 f5 u' V5 \0 F5 t& [
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)1 V! @' ]5 E) }. V
+ g* k3 |9 }( F7 N; u% R</lable><br/>* q& k0 t. p' Z V5 X: \& x
<input type='text' name='item_element'/><br/>
+ b" Q8 z5 T* s% p- e3 }<lable>Element Upgrade Amount</lable><br/>
' [1 i& Z- b' x) R0 ~. R. Q& d<input type='text' name='element_upgrade'/><br/>
9 C$ | M" A: d8 K7 l& Z<lable>Pierced Amount</lable><br/>
% j7 U. t4 N2 q. i7 Y<input type='text' name='item_pierce'/><br/>% Q" }. C m; C6 X6 D
<input type='submit'/>2 p# I' l1 c% [
</form>";: q' ~+ m1 A1 K b8 _3 h0 H* @
}
" P. ?7 b+ O7 s. T
, o: }7 q2 z: I8 Ffunction PostListener (){
# L% ^4 V- o& Z( ]. ~//Add more post variables if needed and add them to initform() function aswell* ~' x' e! \1 D* D; m0 E
# D+ Y6 K' ^, W9 k3 U
################################9 |+ o! ]* b8 |; F( n9 M
##### Connection and Post ######( A; f/ V( b/ @% a
################################1 \' @6 v2 ^! Z# g9 Q7 Q0 Y( b
$name = @$_POST['char'];
* v1 V& X' D" Y5 v$ItemName = @$_POST['item_name'];( t5 s/ x: Y8 C, i( Z) Y) A
$ItemAmount = @$_POST['item_amount'];
% g4 c" @9 `$ E" M3 k$ItemId = @$_POST['item_id'];
# q8 h/ z7 l- ^% m* Z' U$ItemUpgrade = @$_POST['item_upgrade'];
7 V8 s% v( U1 F) z1 v7 g- i$ItemElement = @$_POST['item_element'];1 H. x- ?$ F( H: ]
$ElementUpgrade = @$_POST['element_upgrade'];
. i6 e: T3 L& X' Q4 k; S( S3 n$ItemPierce = @$_POST['item_pierce'];- {% e4 @7 b2 o, p! l' n
################################8 l# c5 W# v: \8 [7 X( z1 |
% J1 V1 V+ p4 s! |6 u
//Check both variables for empty value
; s6 E% e+ W7 v, l( z3 f. d* I+ C: G; { U' N" ^4 t
if (!empty($_POST['char'])){
/ k$ @" @3 v6 h6 H5 L: z$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where % z. P2 U3 y' {* W$ E! c
, R: N' h% e# E9 |. i' w i7 T
m_szName = '{$name}'");$ M: R1 D, `+ Y. k E2 o
while ($row = mssql_fetch_object($find)){1 w6 f' H$ g* X, ?2 L, Y$ g( r8 r, J. @
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
) U( K" V( L1 M. F: a+ g$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], # j! M$ u, }( W' O
! x& p* d4 t& w8 H1 w. S
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
+ E2 d; n7 {1 c; E+ |( E, |. h1 z; C$ |
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 6 ^, i' l; R9 r9 d/ V* V1 e
1 ~* v. a% w$ c; X3 i- JN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
4 \6 i1 T9 V, ], d0 B
8 C; p8 g' c- z* O0 s3 i& K'{$ElementUpgrade}', '{$ItemPierce}');");& F$ f' K# b7 g ~, O& Z
}
9 H% ^( R3 L# j+ [, W0 n- x& v: W! O; Q& r4 C9 r7 U h; }
}6 D/ ~! ~/ P& N4 V, b; m* m8 p/ X" S
. c' v; q6 u+ Q" n1 |- J}
+ W7 ?4 i0 P {: u+ [( X3 \4 s; W. _0 l( ~ @ `5 }
$InitForm = InitForm();( y/ i7 z. e2 h( `9 T p
$Listener = PostListener();
* N2 ]( ?) y; a# r% I. v2 H0 q6 @5 a; {) b0 _* h
?>1 s8 l, L7 Z* M6 B! r+ h
, N, g) a' r" @& _& e" }0 V* t( j. r
6 L) K$ |3 l5 n# P1 G C' y
+ A1 ]. T8 f5 x! @
# z3 G' ~5 @9 ~* T& v6 J
|
|