|
|
<?php6 I1 \$ Y# B L8 B0 T
function Connect () {* t* C% j6 i3 ? d
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB 6 L" F; @2 I/ ~. j2 ]% t; p
+ \0 m4 l0 F% X v
Failed.');7 ? }* P4 i+ A7 w$ m8 e# a# K
}# r, R" ?/ Y9 a1 z7 Y7 {( v
Connect();
0 S: N: e( r8 X' \9 }( x0 V( a6 ^$ }' ?
function InitForm(){: f O+ G7 n6 p0 k1 a) R h1 S
//layout for the form
4 E/ h, e1 k8 W3 {5 e$ G- Vecho "<strong>Send Items.</strong>
8 L6 T( n1 d6 b, l9 Y<form name='select' method='post'>
# E7 X7 q2 V8 A<lable>Character Name</lable><br/>7 B/ I; W. U& i8 E
<input type='text' name='char'/><br/>' N$ y0 ^: O4 K0 v2 s9 A* }
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>& K) S( I% S% q8 K
<input type='text' name='item_name'/><br/>
( ^" d; V" w ?# ?7 O3 ?" i/ C# |<lable>Item Amount</lable><br/>
1 x+ C- P( X% D$ c/ L/ h, P8 C<input type='text' name='item_amount'/><br/>4 {- ^4 S6 x7 T$ J7 Y( q
<lable>Item Upgrade Amount</lable><br/>
: P3 K0 t: x+ Y" M<input type='text' name='item_upgrade'/><br/>; z* a% _1 V: i% f( _2 q+ u
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.). n! ]8 Q3 M( z4 Q" m+ t ^7 z9 ~# a0 c
! B n' ^, z. Y* \7 s9 O</lable><br/># I3 z5 V" Z/ S$ D. p8 I4 x
<input type='text' name='item_element'/><br/>1 d5 P2 ?$ u) t: y1 C n
<lable>Element Upgrade Amount</lable><br/>" l* r6 n$ A* Q
<input type='text' name='element_upgrade'/><br/>
& Y# a J; e* q! `+ j2 {+ I<lable>Pierced Amount</lable><br/>
4 g6 u! m$ B! t<input type='text' name='item_pierce'/><br/>; i! V; k, t5 B# k' }: D+ U
<input type='submit'/>
) l8 n- T- K8 l; Q) |( y0 i% s2 v</form>";
# Q0 \) J0 G/ n3 c}
$ J1 g0 Y7 z3 T P
8 f( b: _/ [- z( Yfunction PostListener (){; F* s: z, T1 O( \
//Add more post variables if needed and add them to initform() function aswell
/ m7 g, ~; I6 E1 H, F8 X. h. ]5 q* ^1 b: F3 R, e, J
################################
+ H# b8 J+ o7 ]1 f; X##### Connection and Post ######
E. l' E0 V7 l3 B- Q- f################################
- P" w, E! ~$ v: ^& k. \$name = @$_POST['char'];, W @1 d8 p# g$ Q# c0 ^. ^
$ItemName = @$_POST['item_name'];
3 @. p/ D8 i* r0 g0 H( p9 R% w$ItemAmount = @$_POST['item_amount'];
: l+ T) R0 K9 W3 e* \8 Q$ItemId = @$_POST['item_id'];
3 e4 R* T4 o5 n8 U; E7 `$ItemUpgrade = @$_POST['item_upgrade'];
5 n3 }+ a$ c. Z$ W$ItemElement = @$_POST['item_element'];
7 f' m+ ~. C2 f$ElementUpgrade = @$_POST['element_upgrade'];+ X& d7 E3 r3 P C% Y
$ItemPierce = @$_POST['item_pierce'];; Q9 ?/ |4 ^+ j# M; c$ F# c
################################/ M- C/ M9 G. \7 z9 g1 f3 g# t& O4 N
' |- S4 `4 w1 W* w& p e2 @
//Check both variables for empty value
6 s; b- E6 t3 N5 S
& Q* M8 H3 I# Lif (!empty($_POST['char'])){
9 Z" z0 Q8 W% f2 V% A/ l' T' |& f$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where 0 A1 z; I8 `/ p; v) C
. E9 m6 d( z; ~' Z; Dm_szName = '{$name}'");
% {* _8 F, d$ c- q. A, @8 i7 a1 @9 _while ($row = mssql_fetch_object($find)){
- [# R- H1 l8 W, W. t9 Uecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";" J& _4 S2 L4 K3 i
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], ) j. \0 W2 }4 P% H
' \6 O( U0 w) I" G k
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
$ o2 I0 D/ h) ?/ g; l; r% N1 d3 m" H2 r
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', , l: U/ m) u6 r9 I# l U% l
B6 [/ V& w8 T( E6 u; e) E7 Z- Z& ~
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
. L% A7 Z! k" o8 f7 Q4 G) n% {" o7 A% R
0 C$ _6 @( M; H- t+ D, w'{$ElementUpgrade}', '{$ItemPierce}');");. [3 s' v2 n* p( c
}4 P4 _ p- r9 Y2 e5 a
* T2 H5 o9 \& G}
, H! d7 j. s0 R) Y7 [* o
; _; ~, A) t- Z: o# a" Q}
8 w D/ Z5 }' t! _ w6 F- l6 t, ?0 N$ N* E! U$ |
$InitForm = InitForm();
! p+ o' _. i. S/ T+ H$Listener = PostListener();
) a8 F* a s9 f" S! T* K$ G. z) a0 o8 z7 w* d% |
?>7 B9 w B) g- }5 X
2 v# u, x- @# {5 F' T
) V; m0 \- G6 O- `' K" ]% h3 K: l9 s3 s. q4 O* t5 ~# N: \, j
5 s/ @! ?# F8 Y- J6 ~/ v0 h
|
|