|
|
<?php
; E( x$ a2 Z& X& R6 e& p9 [* e9 cfunction Connect () {
, b# ^, e7 j( @5 bmssql_connect('Server','UserName','Password') or die('Error: Connection to DB - Y8 q/ J; X+ v. q3 G1 k. l" X& x. V( k3 m
" A5 P# m4 l+ E: s8 e7 G
Failed.');
, R* F% e1 \# y5 x+ s& F}
. x& ~8 G9 W; o* aConnect();
: K6 p$ G! M' w# n1 y+ l8 W' q* S9 u$ _
function InitForm(){; g; l6 G, t' z7 c
//layout for the form+ y7 J, H1 f }; d
echo "<strong>Send Items.</strong>
0 E& \8 L. P- f& n<form name='select' method='post'>
* v9 `' w) J5 _+ f& }; [9 F<lable>Character Name</lable><br/># |& s" Q) e3 U- n; P
<input type='text' name='char'/><br/>* _0 O* e6 `) R4 f! c% a
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>. l) A% p, N) ?) w
<input type='text' name='item_name'/><br/>" ]9 s# k3 h2 g" V
<lable>Item Amount</lable><br/>' {$ i0 p3 x0 M# U Z# H
<input type='text' name='item_amount'/><br/>' d0 c: z0 ?- k" s
<lable>Item Upgrade Amount</lable><br/>
: u! q0 D9 ~4 E<input type='text' name='item_upgrade'/><br/># k$ |4 `1 p, M, s
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
! b2 `4 V5 c& B1 V+ k" P3 |5 K1 U6 Q# f% l
</lable><br/>2 U8 P/ l5 ~) A# L+ k
<input type='text' name='item_element'/><br/>, c7 y) k+ q4 {6 O# f: U; z7 Y
<lable>Element Upgrade Amount</lable><br/>
5 N) n7 b2 \% E; z% b6 X+ j<input type='text' name='element_upgrade'/><br/>
9 Q7 I& p i" a4 M" }5 t<lable>Pierced Amount</lable><br/>
1 T/ f; M1 r3 }" ~- Z$ q) \<input type='text' name='item_pierce'/><br/>
, }: C( |) l% R# w( Y: j$ q1 `<input type='submit'/>
: R. d9 R2 L* f</form>";# A% E' Q2 d. f2 e2 k0 y- \
}
& |. x# _0 X( a9 c) [" Z9 d6 N5 d0 t& ]* h4 `# x* Y1 p6 ]# h5 \" Z
function PostListener (){
% _7 P6 C5 b2 ?- H; R ]) o//Add more post variables if needed and add them to initform() function aswell0 u" z: I3 M; n7 Y! z, t; z
9 B4 {: t' i2 w. v5 S5 b Z6 J
################################
8 j& c4 E9 E: A. X##### Connection and Post ######5 k8 G2 k2 Q' u
################################# M$ \4 N( X. b0 I
$name = @$_POST['char'];" o& ?4 c4 G& P2 A$ x! P* ^% ^7 i" J# X
$ItemName = @$_POST['item_name'];2 r M' ^8 E3 T0 a6 l. ~. T
$ItemAmount = @$_POST['item_amount'];4 _! W7 I+ K. H# U% J$ F4 H& o$ u
$ItemId = @$_POST['item_id'];
% s2 t8 B& r2 M5 a( t# Y S* @$ItemUpgrade = @$_POST['item_upgrade'];
8 `5 Q/ ]5 r% b7 @# {7 f$ItemElement = @$_POST['item_element'];' w7 ]* e2 ~% |
$ElementUpgrade = @$_POST['element_upgrade'];
+ P8 d3 c8 L. d0 j$ItemPierce = @$_POST['item_pierce'];. m( G. P, i& y
################################
4 x5 ^2 l, N o; h+ h3 t
/ _/ u" V9 i/ R# L4 {( S1 J//Check both variables for empty value! M! \, G" B# ?+ l! }
$ x* `' [6 f% pif (!empty($_POST['char'])){, l$ n( b: j3 i% U7 V" l7 {2 Y% q/ c0 M
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where 1 }3 Q/ B, d5 u9 N6 w8 ^/ L
# v1 m* y) J' Z8 m- y# xm_szName = '{$name}'");
9 K& k7 T- H! X) z5 kwhile ($row = mssql_fetch_object($find)){7 s( X& E7 q) G6 K' x/ h" j8 f
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
) _! s. i/ v7 P( p! I7 ?$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
8 j1 Q9 G( [- s
- Z1 `7 v8 H% k A* `[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
) K. F* u& \8 l2 S6 G
9 q4 t- w" @" C' C4 ~' P[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', & n H2 ], j& G7 p) ]" {
1 p$ x; ^' p8 u4 A" F% d
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', ! Z* `) |- y8 m) b0 ^
" V7 ~* z, C+ r& [) k'{$ElementUpgrade}', '{$ItemPierce}');");
& D3 `) D9 P! K}
- l) F7 ~/ n! d1 q& ^- h
* x3 _. z; F: Q% S( J}" Y( v9 I8 d% t- H2 m
2 d2 K/ I- b, n' {9 t$ c
}. K& @& j! b. z( l# Q
2 R; t4 |6 A9 A1 U& @- F
$InitForm = InitForm();- M+ Z, Y3 A3 g+ r" `% m
$Listener = PostListener();
/ z9 `% _) k3 r$ T
# Y- i' {' L/ L; r5 A?>) P! a) x2 w/ j5 {) R
8 K3 v8 D- R( E" m5 P" q4 l
. M j% z* R5 R' Y
& w: l) |2 d- S6 X6 g
- ^4 E) ~! u! z( g |
|