|
<?php- _3 X- q7 Z3 e5 m( u
function Connect () {; T4 h: T a: i& d! i4 z3 }0 w
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
1 d K4 g6 C: g. j! \% ^/ Y
( f( Y( o$ c+ p- \Failed.');
& _" A% @% U# l# N8 H# ?4 P} q3 C. g; {; _$ c3 H
Connect();( X0 H$ r( l. ~! d% F$ [3 u: z1 Z) N
/ p* @/ c1 r- Q2 p1 Ofunction InitForm(){) S4 G0 R, o/ Q d* J
//layout for the form6 m/ s# W1 U) O2 P8 d* C8 N
echo "<strong>Send Items.</strong>
7 C- ?" v( c* w: M+ m<form name='select' method='post'>
" l; S9 n5 H' t3 f( {- z4 ]<lable>Character Name</lable><br/>
8 M" y- `, e; q) H' k5 {" Y6 v7 t" x<input type='text' name='char'/><br/>
0 A( o$ U+ m& e) ?<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>. y1 X; w* U5 i) F) I1 F
<input type='text' name='item_name'/><br/>" o, m* z/ d! v A m6 o
<lable>Item Amount</lable><br/>
1 V" K; k! H3 k/ V, Z m<input type='text' name='item_amount'/><br/>6 a( {6 e8 W+ X( d4 O0 b) I6 Y5 i
<lable>Item Upgrade Amount</lable><br/>; J+ D a" Y+ F
<input type='text' name='item_upgrade'/><br/>
; E, R4 T' H" O: }7 M* G/ V<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
) t" v$ D0 i; Z$ B! o# D/ j J& o, P0 p. \; b2 @/ x; a
</lable><br/>9 A' v/ N/ R$ Z! S+ s/ W
<input type='text' name='item_element'/><br/>
0 z9 V9 F8 R1 ]- S, Y2 o0 k" N0 e<lable>Element Upgrade Amount</lable><br/>8 P7 W" ^1 r' [, a' s4 l
<input type='text' name='element_upgrade'/><br/>
4 u' t, ^$ }: m* B+ O<lable>Pierced Amount</lable><br/>
& L( O! A# l( C; }0 K$ o1 b& B* R<input type='text' name='item_pierce'/><br/>6 e8 [6 G+ Z% ^$ ]. Q) R& r( d
<input type='submit'/>
4 r7 f- R4 v1 f& B/ R</form>";
+ P* A7 a- S7 `3 n}
s% a: Y9 L0 {& u. W3 w- I; u9 r5 C) k" z: ~2 z; i8 H
function PostListener (){
% O2 ]9 V8 P7 f5 e) w//Add more post variables if needed and add them to initform() function aswell
2 h# W, q: q" m) ?8 o! H$ x
l0 e2 e: ^2 Z8 Z: i################################
9 T; _& O/ f) F1 a w9 Z9 e; \##### Connection and Post ######" M% d# h- b, ?$ S$ I, [/ M
################################- o% I' U f4 P$ A' b3 L; p5 I- W
$name = @$_POST['char'];- g9 N% K4 N/ d
$ItemName = @$_POST['item_name'];
% @9 n3 N6 o$ j$ItemAmount = @$_POST['item_amount'];: e: M1 V9 `# J
$ItemId = @$_POST['item_id'];( n$ J2 v8 o! a E4 k O3 g+ i+ s/ h# f
$ItemUpgrade = @$_POST['item_upgrade'];! H6 {# n; S/ J* }1 o
$ItemElement = @$_POST['item_element'];3 E O% I7 R4 n. L' }2 t
$ElementUpgrade = @$_POST['element_upgrade'];7 V7 e5 \; H2 [. k' t s) ]7 k
$ItemPierce = @$_POST['item_pierce'];
* W' E- P4 C" `################################
" G; Z& h5 ]# o" p/ }2 a. {/ u" d$ v! x. S2 G7 B
//Check both variables for empty value# [: V+ V/ M; R. A! A) ~6 B
+ K: l+ V& ]0 q" Fif (!empty($_POST['char'])){
" E" J7 }6 q% u- I5 J+ r$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where ' a6 p3 r% R% L8 Y ?
( e" G# K$ D! \m_szName = '{$name}'");* n5 r N) h. @" E) E: v
while ($row = mssql_fetch_object($find)){5 R8 l' q) |1 M2 b U
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";" X- a1 u5 b1 Z: P! G0 P9 t, R
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
% X! r2 u+ z* A% ?7 J$ L
6 h8 d' u; C- X8 P. M9 \. P[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
P' A# q/ o) P3 I) F7 S. m* t! O! p/ ]
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
, I* p" s) M- P0 H" g0 i- |. V9 Z1 |! z/ h9 @, W% D
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
7 v% V7 A1 ~% v6 p# \1 f0 |* Y0 |# H, g* ?+ O4 ^0 V/ Z
'{$ElementUpgrade}', '{$ItemPierce}');");$ M4 I! D/ E1 S$ z, r
}
$ C! P6 g+ f/ ~! h. v2 D M* ]( W& k' y, H5 k: |
}
; P( ^9 Q) Y7 ]4 q# E* C' j( A) N) a E" y5 t& v4 [" y
}
$ z1 U. I$ L5 P. s( Z" Z* r$ ^5 \. T/ F& H% R
$InitForm = InitForm();
! Y' c/ s0 V* J8 @8 P$Listener = PostListener();
, K! O: \8 [/ d1 K1 ^" H7 a- l- u" v4 P) d+ E8 w! P! [
?>5 m; |; i; B% ~0 ?
" y" S) ^& [! } [" m9 l" C" E
7 W: i4 V6 c3 F* b3 k$ h
9 V) ]. O) d% ^8 W- r% Z/ l2 i7 ~+ S* Q Q7 Y
|
|