|
<?php1 ]8 f' x: E0 B* R
function Connect () {
& ]; C# y' C( q G7 W/ l qmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
$ m9 \. F( o% E, W5 y5 L
3 s- o! J; O5 o, B9 tFailed.');( K. f! F% F( Y
}
0 q$ r' O! Q1 ?( ]Connect();2 K& f( S9 Q6 }# Y6 M# ]! k
( s; W7 x3 z* _function InitForm(){$ s4 r& B: ^: v, u
//layout for the form
4 S' r7 B5 K3 b; decho "<strong>Send Items.</strong>
5 ^) @% I1 V! B" r# e<form name='select' method='post'>
( I: r8 X( |3 x8 k<lable>Character Name</lable><br/>' b$ B+ `( x# o* K; I/ C$ d7 t
<input type='text' name='char'/><br/>
, s# `/ F1 B# ?2 c6 v- {4 O<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
; @! h( w, j& v: k! U( i<input type='text' name='item_name'/><br/>
3 r6 V! x$ ?: }2 B4 f! _<lable>Item Amount</lable><br/>
) G2 C- B X# d! s<input type='text' name='item_amount'/><br/>, ]+ k, Q7 z9 X$ K
<lable>Item Upgrade Amount</lable><br/>6 ^' G- m: q$ G1 m4 Z, `) N
<input type='text' name='item_upgrade'/><br/>
. M* f. E. }& p9 S5 v' I<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
: ^) m5 ^) a/ g t. r: I. q. j8 r! c2 G
</lable><br/>( ?8 o% Y8 f7 S2 n7 A& |
<input type='text' name='item_element'/><br/>
0 o5 x' F8 R" y' P2 V1 i# {<lable>Element Upgrade Amount</lable><br/> b' p& n$ K% [4 m9 y
<input type='text' name='element_upgrade'/><br/>
6 C$ Q- l( m& u) ~/ ^<lable>Pierced Amount</lable><br/>
- }; A$ R/ d7 S& S2 ~. @<input type='text' name='item_pierce'/><br/>
# M M- c1 s( {<input type='submit'/>
' m2 {6 }8 X r</form>";1 y" v# o& s/ @' J: V4 P X8 t
}, ~) k; Z4 P: v0 H" Y. _" h
8 [( z0 k6 m" X0 f+ ^ w4 E) y& X% @% dfunction PostListener (){5 T1 i2 `2 g# v2 P7 D) W* `& P. z3 |
//Add more post variables if needed and add them to initform() function aswell
" _- ~/ J) B" h- B' E
0 k6 j" T) r1 W9 f3 w% z: [################################
7 i8 h$ }! ]- t- x @7 T##### Connection and Post ######. ^7 Q% v" q$ q9 a' U
################################3 ^& c6 i$ Y7 T( W7 s8 O- S
$name = @$_POST['char'];
9 a% ~' R5 b5 [$ItemName = @$_POST['item_name'];
* b8 u& p0 w/ G/ s+ K& R$ItemAmount = @$_POST['item_amount'];
2 Q3 c1 M) q8 I/ t A$ItemId = @$_POST['item_id'];/ Q4 p) f& U$ k8 }) q
$ItemUpgrade = @$_POST['item_upgrade'];& K$ Q; m6 I3 [/ y
$ItemElement = @$_POST['item_element'];9 S& ]- r9 o$ {+ G; p
$ElementUpgrade = @$_POST['element_upgrade'];
& I- o8 [$ U* ]' s3 L5 B$ItemPierce = @$_POST['item_pierce']; i9 C0 d, @* ]! O9 h {
################################
0 B* e; v7 I- ^4 A0 T# ]7 D" K" x% C/ C- f& I# a/ e) R+ O
//Check both variables for empty value
* K* v& D6 f, O9 ?
; _( N2 u$ z& e* V5 _if (!empty($_POST['char'])){' A5 l( Q* v1 m
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
% q# Z/ P6 i) a7 T/ ]6 d
4 Z3 F! X4 H5 A2 Jm_szName = '{$name}'");, j/ {$ h3 C$ g( D
while ($row = mssql_fetch_object($find)){
+ U: H- v+ ~ pecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";# t( t# Y8 i$ I6 `+ p! e& J- r2 t
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
! S- l! g5 d6 t# H2 g
# E1 J( v- O4 z6 G6 h( h0 d. B9 {[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], & X: _; u* y! p$ `5 |
- _- _' o8 Q0 [2 c4 ]6 b[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', ; v0 t' O ~9 x6 w1 r/ c; H
; ~; @3 f& _- j! t( L# G
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
. j& j) V+ X7 H6 b( Y! t6 B1 e
. H4 S& k4 h" Z) M# V$ N6 B; j7 O4 J! k; K'{$ElementUpgrade}', '{$ItemPierce}');"); Q2 u* S. D, B+ d, O0 o: ?7 t
}+ Z' u: X; I' J, D; ^, t
; E& P6 ?7 S# ?% k& w& C7 D5 a
}
8 p: s: ]2 i0 J' v3 @& ^2 S: t# K& a) o+ _/ A
}2 N3 t' n: J( c; `+ s6 N( V' _* L0 L
4 k: k3 n% S5 G5 ~$ y0 X' X
$InitForm = InitForm();
' Z4 v& h. D3 Q/ ]' @* r$Listener = PostListener();
' X" ~4 a& k( G6 w: m0 t
9 {* Q/ S3 z# I, Y( S4 T% V% l) ~?>" e. P* h3 K" d( ~0 b8 d& D4 D
$ s) x* X2 V. n' Z" A. Q; {% ~0 i; r+ K3 |2 Z, ~5 f
, }7 Q; ]# H9 C8 P( B% c, U
7 r4 g2 A5 x5 w0 T+ w" y* f4 d& M" Z |
|