|
|
<?php
5 X) }; l1 p+ x9 ?function Connect () {
6 |, |) o* n- u: nmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
1 h+ o; s+ t0 F* _
( s9 z/ ~7 ]# ~- h4 P/ ~Failed.');* i5 W3 g Y1 @
}" A* [, d1 b0 k3 a
Connect();1 V1 Q- X& }; G+ e9 N
8 p0 M- k A! {! o8 \function InitForm(){
h# E4 a4 [1 V//layout for the form1 U; u1 ]: O8 b6 [ j: F
echo "<strong>Send Items.</strong>
2 l+ ?" `) C4 L4 m: n9 J+ v<form name='select' method='post'>
z& @9 `: V) d$ n4 O4 o% I<lable>Character Name</lable><br/>, h, v R% [1 J
<input type='text' name='char'/><br/>
$ Y) a, W- f% r( `9 m<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
$ j; g4 e1 L2 B+ V% ^<input type='text' name='item_name'/><br/>8 y1 q! e4 S* Y7 Y7 u g
<lable>Item Amount</lable><br/>* _9 A Y% S% {" ~" I" c
<input type='text' name='item_amount'/><br/>5 @! ?, W9 B2 V3 Q7 T6 j
<lable>Item Upgrade Amount</lable><br/>
9 L, x- [4 t( P* \* U<input type='text' name='item_upgrade'/><br/>* J: Z7 l0 \" \- N( I2 P: N/ G
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)' {8 G& v% ]9 E! j' i: G1 @; w
+ @; L5 j$ t2 G, A9 V! Q x$ i
</lable><br/>
4 E4 A. k( K5 ?. ^& I<input type='text' name='item_element'/><br/>
% ~6 j9 d! W* {- f- `<lable>Element Upgrade Amount</lable><br/>
* W. ? p) N, |2 B+ z8 @) p, T<input type='text' name='element_upgrade'/><br/>
) O R7 b& _, {3 m2 ]<lable>Pierced Amount</lable><br/>) w4 a& f- A9 ?2 b2 Q6 s
<input type='text' name='item_pierce'/><br/>$ Y! a4 C, n& L
<input type='submit'/>
6 i N$ T/ e9 ~ p2 ` ?</form>";
* X Q# E5 C" Y9 u6 S$ }1 @' |}1 i5 `% ?) C, d6 k) w3 e) P
# C9 @9 @: q; A; d: \* Yfunction PostListener (){
' p, F; A% G- ^, E8 c//Add more post variables if needed and add them to initform() function aswell
- Y7 @; Z% F) F+ y, l; O# |: c! ]' Y
4 F. [ N9 v4 N R################################7 Z: w, O1 F' x8 h9 ^# \
##### Connection and Post ######1 v5 K! T) Z4 }9 x( B
################################: B# |9 K' _# U \* E5 ~
$name = @$_POST['char'];
; W( F( m: E' m7 Q/ z! \$ItemName = @$_POST['item_name'];7 G! c" e2 W5 N( E3 k
$ItemAmount = @$_POST['item_amount'];; L; A; M$ Z& n: }
$ItemId = @$_POST['item_id'];8 ?7 u6 m9 _! g) O3 m7 b9 ?1 z& t" q
$ItemUpgrade = @$_POST['item_upgrade'];* W- h) d: E/ S! v5 k5 `" |
$ItemElement = @$_POST['item_element'];
8 Q1 H; @2 F% z4 z; y! e$ElementUpgrade = @$_POST['element_upgrade'];
9 e1 z; F8 m, l) @) x" s H9 J$ItemPierce = @$_POST['item_pierce'];
* i3 `, I$ W6 c' S8 O2 k################################& J( H, F: }* ^9 l
8 X" B P% Y V# p; A
//Check both variables for empty value4 S1 P/ W+ n3 ~, m, \
( K' W. I- h! i& o3 X
if (!empty($_POST['char'])){5 V2 g4 N) O0 v- K( Q
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where . u7 ~: C( t; D6 f
3 z r& L* e* j7 ]; S
m_szName = '{$name}'");
1 C* \: Q. v- ^% cwhile ($row = mssql_fetch_object($find)){4 G; @4 W+ ]2 A: Y( [
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";8 d4 }3 z9 {* V! R# ^. u
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 0 V1 X/ m3 G. [& O6 a2 q
8 s, w# P' y7 J n( y% l
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], 7 g L6 p6 e! b/ w1 U" \
# f/ S6 N6 d& v2 N: s' @' v; i[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
( ] d m. }% W& P6 u T9 g' }; z' U( w6 ~1 [+ C
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
& s, [; j1 K3 G2 X
@: v4 B# `$ f2 E- T I8 |6 S'{$ElementUpgrade}', '{$ItemPierce}');");
: M/ R9 A+ J7 t8 V}! u% B8 a# f: u) B. d+ C; L& ]
' [5 ], V' F2 B/ I
}
2 Z8 i7 j( W$ F; ~2 o& O! w/ }9 e# p
' `: Q& v ^8 | d}
, o/ B/ W4 u( X; S- o N
/ I) [- G) `0 @# C, O' M$InitForm = InitForm();
: a+ q5 c* l. B% U$Listener = PostListener();. A" i8 Q ]" d( e9 J; y
! L) N9 v, n7 ?) `, o1 L; N- F
?>
, W N, U" s; s. i6 u* ]: P. Y- r9 d" i
# t5 k# U- F% P+ t4 J! R
# B" Z: X2 @, C0 Y3 w+ F
6 B! m2 m" ?/ t0 Z! J: Y
|
|