|
|
<?php
7 i4 ]' {7 ~) n+ S4 k( cfunction Connect () {
5 l: [7 y8 ^& h0 Y$ Vmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
; ]- S+ d! K" X9 W5 h* s
% m4 n3 I" M- P+ G2 UFailed.');
" P0 k8 T; Y7 L+ O0 {# g6 \9 b} }# @7 }* Y Y- S5 w/ E
Connect();
; R# M3 V% g# q) S2 W( X
' ~4 e t+ T1 Y d Afunction InitForm(){3 R9 C, x: u5 I$ G' Z9 ~& E
//layout for the form2 O; D T9 v% D) A' w* G0 y
echo "<strong>Send Items.</strong>
* {7 ~+ a& z* U3 c8 U+ B2 M<form name='select' method='post'>
- _: L$ M% I' j9 ?! u& ^<lable>Character Name</lable><br/>
: m; z" h$ l' o, @ E0 f<input type='text' name='char'/><br/>
4 W4 t) V$ o4 [5 D4 h7 d _ ~0 P<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>1 v( D; j% t- ` d4 z. }
<input type='text' name='item_name'/><br/>
) z) ^+ w5 s# a g<lable>Item Amount</lable><br/>
s2 Z: e8 q- j6 I: G( Z m<input type='text' name='item_amount'/><br/>
6 g( Z" @2 C7 }* I0 f- i<lable>Item Upgrade Amount</lable><br/>" b+ X2 }- T/ z% U/ K; R
<input type='text' name='item_upgrade'/><br/>+ T7 O1 V% Y, ]( W& D+ F
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)6 \7 C+ Y! q" m: t. e! T: l8 o
3 U( C9 r1 K; h
</lable><br/>
& v6 Z" u4 i9 M/ X ?# w6 G<input type='text' name='item_element'/><br/>! C9 y. { n7 O |' c& E* {5 G
<lable>Element Upgrade Amount</lable><br/>
6 B: Q0 z/ T$ z$ F+ ^<input type='text' name='element_upgrade'/><br/>$ X: E7 b/ a0 ?; }- k
<lable>Pierced Amount</lable><br/>
* k& ~2 D& G2 D* w- h8 `<input type='text' name='item_pierce'/><br/>
* e0 ^; |+ i$ X$ X2 ~<input type='submit'/>
5 F" d1 y: D2 R5 K# n</form>";* x) n9 J8 s/ ?7 ~6 y# ?+ a4 x" L
}; \8 B# B- w3 g5 ~
0 \( a# V8 }* D1 ^1 rfunction PostListener (){
4 ?( L7 _: H: M+ I//Add more post variables if needed and add them to initform() function aswell- F2 G! X7 R, O/ T
% v+ t3 S8 b1 S% ^2 w% b
################################0 {' a( p4 N6 M/ C! u+ q; k! [
##### Connection and Post ######
! C/ m8 h; B, [3 [################################+ c! s0 A3 B: \3 ~* k# F7 @
$name = @$_POST['char'];; G1 l5 n) X+ e9 ?' ^
$ItemName = @$_POST['item_name'];3 j: `; D' P T8 X l. O
$ItemAmount = @$_POST['item_amount'];( _) G1 h' h4 c; ~( K0 c, W+ L
$ItemId = @$_POST['item_id'];/ {1 |! D1 z& |4 I# F
$ItemUpgrade = @$_POST['item_upgrade'];
0 B% o' J. d( p$ItemElement = @$_POST['item_element'];
! h% E6 G0 ?7 B8 }6 ^6 l& ^$ElementUpgrade = @$_POST['element_upgrade'];
/ \2 N& S* R8 A% F( B4 z6 q$ItemPierce = @$_POST['item_pierce'];
$ t" z" L$ A. A* }/ ^+ t( p, M################################
' A: c. }# }' ]* w# ?- b$ f. \* K. a3 D6 d
//Check both variables for empty value3 P- h: S! ?% }. m
& v2 w5 W6 L; l
if (!empty($_POST['char'])){
; w4 q( }, L/ e) @% I W. [5 }+ {$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where ' c( o5 w5 S1 E' W* Y4 }8 ~& z
. p# |# u& W' p7 }; G, \$ {0 i. ym_szName = '{$name}'");
% }1 r: R. u# A/ w' ~) z8 z8 fwhile ($row = mssql_fetch_object($find)){
' k7 e7 G6 ]# F0 I- W$ S; f4 gecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
5 x5 D. n& ~0 p" |$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
* t! F: Y" X# |! p& N+ F% ^$ E
/ _) d0 }, @+ p( ?. ^8 ~/ x. f[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], , s3 E/ `' E+ K& |
8 u3 Y. g+ I, z3 ]+ w$ F8 F o
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
) L# @. r2 M. j5 Y G" Q" T# o. q* a5 i$ F- `9 a+ N7 t
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
/ @& y$ g e6 ~" U6 c& `% X" [
$ n" Y* o+ M5 d* @0 I6 J'{$ElementUpgrade}', '{$ItemPierce}');");+ s- L# l/ n n$ s$ r" j
}
1 a) ?1 P, V4 k1 C( f
1 S( K( T! _! x4 B2 U8 {}
- Z0 @! W# N1 ^1 }2 m9 m l8 T" o
}
/ _3 T2 u. ?# O9 }6 Q T' B
1 p% R/ [% ~4 m* U* _" V! U3 j& E: |$InitForm = InitForm();
' y" L, d# _7 T1 K4 M" b% L$Listener = PostListener();) k" O0 W* V. @8 q3 k! F7 A" ]7 {
" I' e* @, e* p2 |* z
?>
) c, D' ~, V: ?& Z; B3 {3 n& x0 d
7 X2 E& e: }% u- M- ], Z8 X4 g" m6 j& Z [& O
3 S9 l, Y; d# e! C
, b6 Q4 R5 ~# g3 Q |
|