|
|
<?php
; N$ R& D) C _$ |9 jfunction Connect () {+ k$ o g7 d9 p7 |7 U/ C
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB ' R4 s9 Y" J- x- O
7 V' s) c6 X/ f, j/ o
Failed.');; M1 }+ I) U8 P* X: m* W
}1 @( }% f& C9 v) ]
Connect();. S: M1 g# a& K
3 `, a# l* A% Cfunction InitForm(){
9 ~3 ?- M8 z, Z$ N* R//layout for the form
& G" `' M1 d' C& decho "<strong>Send Items.</strong>8 ?* s- |/ X7 l; d b c: Z
<form name='select' method='post'>" Q, Z4 d' X" }2 |- r4 Z
<lable>Character Name</lable><br/>
' H4 W4 g/ ^3 ]( K<input type='text' name='char'/><br/>
; y& l: v2 u8 e0 ` K2 P<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
7 i( m' c0 ^! L9 ^. N: u<input type='text' name='item_name'/><br/>) ~& x0 d7 E: J0 f: W! X3 E6 x( k
<lable>Item Amount</lable><br/>
& g8 k- [: l) u7 h<input type='text' name='item_amount'/><br/>
$ G# c+ g+ i8 @: G" ~<lable>Item Upgrade Amount</lable><br/>* Y' s& B; x3 e8 G3 A; O
<input type='text' name='item_upgrade'/><br/>5 b# N+ t q! @# @2 [
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
* i! }# D0 C0 D/ r) T2 T5 F* [/ u4 ?+ q+ p3 j, G) V/ `; b( N9 @, A
</lable><br/>
7 I8 N8 d; R `' \ l2 O<input type='text' name='item_element'/><br/>
/ V" v0 d7 V p<lable>Element Upgrade Amount</lable><br/> m7 w4 `& l! R7 R2 f
<input type='text' name='element_upgrade'/><br/>
' Q6 T+ \" ?+ X<lable>Pierced Amount</lable><br/>) Z" @; k( v' V; ^2 d$ v
<input type='text' name='item_pierce'/><br/>
& w: r) v" A4 l" ~9 F& f; P! R2 q, h<input type='submit'/>$ t/ z* n5 j; g; d4 r
</form>";
; d" N3 y4 d3 U* l/ r: A3 u}
) N( F/ c+ g6 q/ X+ t5 s$ Y0 _6 c6 Z+ t7 q7 P$ |9 b
function PostListener (){
J$ w( N: ?0 @, L8 I' T//Add more post variables if needed and add them to initform() function aswell
6 R- j5 W7 [; `" |0 C' \0 K
) s0 Z0 w( A4 c* c( z8 O* t################################
$ L8 q' O- M8 E* c, h5 {/ V/ g# ~##### Connection and Post ######
2 L( S$ h! L7 ]################################. Z0 q" o$ R( R. P O3 l
$name = @$_POST['char'];
0 f+ }+ @+ e" R$ItemName = @$_POST['item_name'];8 |( X2 E4 v I2 L
$ItemAmount = @$_POST['item_amount'];
# F/ A0 x. p4 t% f& w/ l& l$ItemId = @$_POST['item_id'];. m. {9 _; G7 o! ]
$ItemUpgrade = @$_POST['item_upgrade'];
! [) b2 v7 }0 |, Y! v W$ItemElement = @$_POST['item_element'];
% U' i' R; |% y# Q+ O" e$ElementUpgrade = @$_POST['element_upgrade'];# @$ l: v7 Q: q& a; j P
$ItemPierce = @$_POST['item_pierce'];
- h1 l- z! d) \- W% p################################
0 O9 Z: y- S @+ X: ^# O e& N6 G7 M$ }% Z; z3 u
//Check both variables for empty value
7 x- m; o' y. U( w, p& p9 q2 W
" {/ `4 @8 D' Y2 f4 x% S; q0 @' t: Qif (!empty($_POST['char'])){
& \9 R% R4 {: n" i$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where . d) u$ E: g6 w9 e. R4 t4 j* r, Y
: r4 u. k8 j9 I. U9 dm_szName = '{$name}'");8 d# ?$ s, x0 s V
while ($row = mssql_fetch_object($find)){7 ? e: ~: v/ d: m* M: x7 F
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";7 f7 _% a. Q( G3 F" j
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
2 F/ x8 t# m1 f$ R ~- z8 \5 y4 U: R0 r7 k9 Q
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
( C' q9 H3 K) n) }$ u1 B l: v5 L e5 I7 v
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
$ W" b* I) g9 @# U1 I4 ^; Z1 l, o- `6 F; Z. f: p
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
& O: R" d4 {8 V- j
F% }. I* n% ]'{$ElementUpgrade}', '{$ItemPierce}');");6 [# L: w' f* b1 Q @+ @8 K% t/ m6 B3 I' F0 i
} V4 `3 {% m4 ^$ ~1 U/ S' \
* Y9 u- L S+ o" s
}4 K# r+ m( t4 N' T! u
; k8 y. m h$ U w% X; u}. x B! p0 }4 J, P0 p
( C# G3 r+ h6 {$ |/ t# q
$InitForm = InitForm();: W' a$ W& d+ Y' z6 w0 m5 C! f
$Listener = PostListener();* B* R. R- i7 H+ g7 ^% t
) T* B$ ?- G4 P4 L; m
?>0 v1 Y( I& w! H
, t9 \" {5 S) ~8 t7 ^/ [+ S
- X4 |9 B" \/ Q6 x6 k
6 K' a9 |: {! o) w3 R5 i/ t
, n E* u) r1 d' k# u: v |
|