|
|
<?php/ W: c2 {) y1 E2 @ y% S' P0 Z
function Connect () {
# ?0 q3 D( ]# s+ y6 b! amssql_connect('Server','UserName','Password') or die('Error: Connection to DB
" ?/ P/ C7 C- i) Z
% p; m* `9 x6 sFailed.');
8 R" z9 k0 T9 D9 n}
% G* J4 S9 y; T! ^6 |3 @* qConnect();
3 y. Q" S: p P+ I2 E* f7 H$ d8 K6 Z( m" U* m; s5 k7 d$ D: A! i
function InitForm(){ v' P# A: ^# S3 P5 p9 W5 M3 `
//layout for the form
/ Z: ?$ j7 D" j1 }; kecho "<strong>Send Items.</strong>" _8 p1 ~* Y' [# j8 x' @
<form name='select' method='post'>
6 x9 @) m+ J4 l- h2 c0 r: V<lable>Character Name</lable><br/>
8 a4 V, ^" w3 Y<input type='text' name='char'/><br/>- Y$ k+ O' J. I3 E
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
* j$ Y, t2 J- {7 N<input type='text' name='item_name'/><br/>
6 N* H8 O! K$ R$ z$ w0 K<lable>Item Amount</lable><br/>& ~3 t* o' }: L5 Q$ d
<input type='text' name='item_amount'/><br/>, |- o1 n; ^% c' b4 G) e
<lable>Item Upgrade Amount</lable><br/>
@! D! H" @: G9 }! ^8 e<input type='text' name='item_upgrade'/><br/>$ q; @4 t- u& ~% A2 R. N
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)0 e8 I; V5 N: V6 r* H8 o
' G$ P# J/ T& x/ t' H
</lable><br/>
2 P0 }3 ]9 c7 @* f1 @. o<input type='text' name='item_element'/><br/>
1 a- K) i2 I7 X<lable>Element Upgrade Amount</lable><br/> q! u b9 F0 j( I4 D! V+ E1 d
<input type='text' name='element_upgrade'/><br/>) \) a8 t* W/ `# Q0 b' c6 D
<lable>Pierced Amount</lable><br/>
: b) K4 H/ p( ?& G& Z" M<input type='text' name='item_pierce'/><br/>
8 J; M) B- K& j0 Q<input type='submit'/>
6 e; n: m/ |$ J8 l4 H& j8 L& d</form>";
- `$ l0 }/ @/ p}
" `! c- H( a; I4 S, O
& l( y- r+ U& K( Xfunction PostListener (){4 A8 X0 ~' g' l4 M, K
//Add more post variables if needed and add them to initform() function aswell: l/ h2 U& M7 ^; K: Y8 n
7 |% f& e; h* a2 f/ B% \! {, ~################################
( L; t5 w* i6 K7 e G6 n& M5 r7 r##### Connection and Post ######
2 n$ R9 C9 \* d+ O4 m################################
3 h$ E" s X" G4 L, t; {& o: j$name = @$_POST['char'];& ~6 d4 t9 D( E9 ~; e% Z1 A
$ItemName = @$_POST['item_name'];0 ^, T# v3 G/ Q4 C: C- p. c
$ItemAmount = @$_POST['item_amount'];
* P3 @ l$ O# M- M$ItemId = @$_POST['item_id'];
& I* W& u/ E' Y5 S% m1 z$ItemUpgrade = @$_POST['item_upgrade'];. X. K. v+ D( s8 X$ K: |- Q
$ItemElement = @$_POST['item_element'];
9 ]4 e+ b4 `8 N8 d- S; o; z$ElementUpgrade = @$_POST['element_upgrade'];
" I+ |4 A) h3 s. A* `, l, W$ a$ItemPierce = @$_POST['item_pierce'];/ V1 o; z" v+ y3 d3 J
################################
; v0 C0 f; y/ F' N) ^6 m/ A, b' ~9 Q
//Check both variables for empty value" r5 H: v7 ^- E7 v( k, I+ v
2 _( _9 g; W0 L& I8 r K
if (!empty($_POST['char'])){! o- n% d2 u* Z Z$ ]" e' ?
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
, A& g' p2 t3 `0 a7 z. T2 Y) S5 |
) [ x' I$ I9 s, s+ r0 Zm_szName = '{$name}'");0 ]7 c2 h; Q/ Q0 I8 O
while ($row = mssql_fetch_object($find)){- x1 p* E' Q* M( {
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
/ Z5 E! p, \) a5 X% v! z$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], - S/ y5 V5 b! H5 g. d. R/ r
. E7 }, X7 y+ @, i' y[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
, p6 o- O" Z# B- c7 F/ t6 I% {% o
8 @3 b, g2 L- E% y- o[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 5 h0 Y! d0 z2 T, D( n) f5 {, ~
7 [0 N1 s; T1 p8 M8 PN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', $ p' v4 E& K- H" r
. T U3 m& Z8 v' ?9 x& ~
'{$ElementUpgrade}', '{$ItemPierce}');");& x, [5 V9 t g# E
}& O7 p) [& r9 k9 `( {& i5 B5 R
4 M# f6 q3 N3 A, x: K}" E1 o9 B0 e6 O# j' e [
& e' `* j% V/ y1 _0 G}1 u2 b/ {& V& P+ Y ~% \9 Y
$ U3 l, O* h4 h- \, o6 E
$InitForm = InitForm();* P0 W9 l/ _$ \* K. ^7 s
$Listener = PostListener();
& m8 K% a9 d) T5 c4 z4 {9 R5 P$ i. U3 j9 o! }2 Y0 b6 I
?>
& p6 j H) d/ I6 M* Y: S: S, X# A& G" q+ c) h+ g8 f
5 _$ T% h* u+ J% b% n5 A
! Y% p8 a4 D9 H7 T! c+ K* b; h$ r
+ h1 x7 W7 e# D" h, }, V: N$ x+ Y, b
|
|