|
|
<?php
, F) A' S, @$ N; cfunction Connect () {- m5 Z0 X6 X+ a6 w2 Z: q
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB : W# x+ R3 y3 i: _- a* E! A
4 b: }: {+ w6 ~7 M: X* T1 AFailed.');3 S ~$ L3 G9 w( U2 k2 G* |
}- O6 h2 C; W: t7 e. c
Connect();# ^: Z0 ]0 i9 P
( Y. o8 c5 V1 f8 A, a& t" `4 T
function InitForm(){
! ~! c t3 h! b$ W! f4 S//layout for the form
" U# g6 D* T i1 P& ?echo "<strong>Send Items.</strong>0 w, `5 \1 W6 I
<form name='select' method='post'>
' A/ I; k+ Y& D* X2 |) M/ k<lable>Character Name</lable><br/>( A1 M5 y0 j ?& L' L9 J* c ~
<input type='text' name='char'/><br/>
7 c& Y% q3 P: W& y7 A+ U<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
2 R. p: p% P' o# `8 i! A7 _0 v<input type='text' name='item_name'/><br/>6 i' s+ X% c* v6 X$ H& `: L
<lable>Item Amount</lable><br/>
. U) f! c) w) B0 U& t9 |<input type='text' name='item_amount'/><br/>
: F0 h6 b) N" C: l( @2 U* E. W<lable>Item Upgrade Amount</lable><br/>
5 f( g' ]5 D7 |8 {3 ?$ J<input type='text' name='item_upgrade'/><br/>
! Y8 q9 Q" \0 x<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
; f/ \& w% E( v1 P( ]) A' e
4 Z. s. m8 K! D) W3 d. ]</lable><br/>
, D4 \# }- ]) y. N, x5 o4 @ W<input type='text' name='item_element'/><br/>
. A( Z; Z0 \" b: u: ~/ m0 W5 V. ?<lable>Element Upgrade Amount</lable><br/>
4 u$ \" G# U( U+ Y<input type='text' name='element_upgrade'/><br/>
0 d3 U9 P) f# L D, V% t l3 Z% \+ J<lable>Pierced Amount</lable><br/>, d/ z8 \8 N& i# a
<input type='text' name='item_pierce'/><br/>0 S$ U; ^% P0 b* R
<input type='submit'/>
, l- m5 t+ O3 @</form>";2 V5 N5 N; ?# N2 g& |" n/ Q
}3 ?( c# V$ C/ N' L7 W
# B% g4 w; U6 [7 h! b. n0 ^: v
function PostListener (){
8 i/ S- E8 [' U5 w6 X//Add more post variables if needed and add them to initform() function aswell
9 K3 X) n+ F; T) L' r# I' l
) P+ b# ]' N* k6 M################################
" K( l4 U* ]! S! g8 h##### Connection and Post ######
) O2 D1 b& q8 D, |$ ]( m& o################################' ]. f8 r" ~, Z# F
$name = @$_POST['char'];/ A5 q# X; P( H0 t$ y
$ItemName = @$_POST['item_name'];
7 }$ v! u/ v f: S5 C$ItemAmount = @$_POST['item_amount'];
' }6 K% f5 k# T/ a8 a( r- P$ItemId = @$_POST['item_id'];
: c! g. y3 l2 n* i+ |' b8 A$ItemUpgrade = @$_POST['item_upgrade'];
! Z. U7 n3 R4 u$ItemElement = @$_POST['item_element'];: n9 U/ ^1 v' u/ C
$ElementUpgrade = @$_POST['element_upgrade'];
. j) Y8 P* }5 h$ItemPierce = @$_POST['item_pierce'];
( z0 q; g# y4 _: D) I' l) D* U################################8 f* ?2 C$ i1 J3 @+ Q
7 @! x2 x( M, W$ n2 I2 D2 x$ V8 ^9 s
//Check both variables for empty value
( X4 Z$ Q& K1 ]5 G K8 c1 x7 {+ \; ~) W, A
if (!empty($_POST['char'])){
: K& C$ x& m0 h5 M/ w$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where 8 ]2 U" t% W; X- `
& {1 U: O4 P+ y, s' \m_szName = '{$name}'");- `7 V: k9 J7 U- ]( }+ b. Z
while ($row = mssql_fetch_object($find)){3 o% a0 D! f% I
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
' s4 Y, ^. z7 H9 \2 |, p5 t$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
8 g4 o5 @' {4 |' Q" u3 ~
# S$ U0 h' O! u' C5 _) {[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
) D8 }6 ~ n$ |( p+ P( E% u2 i6 T! r
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 9 v% ]; T0 Y2 i; [3 @
# s. R3 M% _' v7 h. z' e. XN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 9 i& Y1 w i2 U* U
2 A5 n# {& {% S, D7 C'{$ElementUpgrade}', '{$ItemPierce}');");
, P8 p# {- P2 b' X# S. u6 b# n}
/ g4 ?" J* q8 e. Y" d! {. u( L; V9 H, k. ^/ X2 P! p
}) _; ?5 d+ R1 h* I) _6 w5 N
- B# C$ \9 a$ p& J3 \}- x* c; w9 {3 z' w, `# d9 F
7 ~% c+ o6 k9 P, N9 K
$InitForm = InitForm();
2 V( N2 x! _1 g5 m5 y- ]% q! b" n$Listener = PostListener();5 e3 Y9 W( w4 G9 L
6 r$ ^( x/ \0 g
?>
8 e" D: K _4 ]4 D6 n% U! S/ F
' O$ j/ ]* ~& V+ | {- w6 I* y1 H5 b! r# L8 Z2 s
' h2 c3 X A) b3 u. G
+ \" n3 R0 P8 B$ ] |
|