|
|
<?php
8 r0 Q; K! Y+ p" H9 Yfunction Connect () {
: h( j6 t% |& c6 h" ymssql_connect('Server','UserName','Password') or die('Error: Connection to DB # J& x: k6 f6 X7 t2 K
1 X% S& R% c$ y% o! W9 K3 f4 P* X$ M
Failed.');" n2 ~/ B) Q+ b5 o
}
- ]8 e) `3 W. m+ n2 uConnect();
1 b% F \ v) S2 O* B$ m+ `* r- ?4 V8 r2 Z' m! D
function InitForm(){) S3 W, q% ?( k( u5 J8 f1 ?) @; Z* T
//layout for the form3 g6 ^3 F4 r+ }9 I
echo "<strong>Send Items.</strong>5 B! i& _. ^. u: j+ f
<form name='select' method='post'>
( ^. }+ C9 M5 @& ^<lable>Character Name</lable><br/>; T) F- \ u C" B
<input type='text' name='char'/><br/>9 _0 i# ~5 L. P' z; _5 E$ \
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
5 S7 i% q/ q- N! g<input type='text' name='item_name'/><br/>
0 |6 [0 Z) k, ?7 l6 r$ q/ c<lable>Item Amount</lable><br/>
- ]1 f9 ^0 e: g( B1 A" i* v<input type='text' name='item_amount'/><br/>4 L4 N3 j0 t' t- y; K4 a1 T7 K9 s
<lable>Item Upgrade Amount</lable><br/>
: K8 t! F* O1 c4 Q S, @2 n<input type='text' name='item_upgrade'/><br/>1 H, |2 a* B8 b. M" U
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
8 Y. Y* i: s8 _
4 r& z! Y* n0 r3 K, x, S: }</lable><br/>2 q- Q! T3 [' u3 f/ K# }# ^
<input type='text' name='item_element'/><br/>
, q4 E. \+ r; D$ F6 K<lable>Element Upgrade Amount</lable><br/>6 |* ?! \+ V; W( D: t" W" q
<input type='text' name='element_upgrade'/><br/>
, ? V- Z9 J. W: u: t<lable>Pierced Amount</lable><br/>
1 Y6 S# L6 ~1 A5 ]/ T1 f<input type='text' name='item_pierce'/><br/>
2 b1 n) C4 m" u# B<input type='submit'/>
$ j8 F9 @8 m+ X* W F* U</form>";
. U9 S& Z! D# u8 [ w- X}
3 O; _: T& U. P: O) ^# D! O
9 B) B' ^! j8 C$ e9 p0 [4 X7 Cfunction PostListener (){! ]+ m6 w; E) D) S& O0 J; _( j
//Add more post variables if needed and add them to initform() function aswell
* |. a. o& a; T N4 A. H7 d! q* `5 S3 X8 _, X' W3 q
################################
% F, n0 r+ m& B; w% d# Y##### Connection and Post ######1 n5 h: v( G" H! ~
################################1 {- o% i. \, s& X, J: L y/ N# Z
$name = @$_POST['char'];2 n( o, ?4 [* L. h7 D! q
$ItemName = @$_POST['item_name'];
8 d6 h: d! L8 d; s; k0 X+ l! d$ItemAmount = @$_POST['item_amount'];
5 P: F7 E$ R$ K) N* P5 ~$ItemId = @$_POST['item_id'];* _( U, M5 }$ D. [6 B
$ItemUpgrade = @$_POST['item_upgrade'];$ u5 o7 e% f( v0 n( Y
$ItemElement = @$_POST['item_element'];+ m- g! J" b1 e- D7 U2 ^
$ElementUpgrade = @$_POST['element_upgrade']; `6 ~3 e/ R) T) q
$ItemPierce = @$_POST['item_pierce'];
! j4 Y8 v) V1 T& P& ~* k% J- \( Q3 C################################
( e. Q2 |! k& L- W' W: c8 \4 |1 E, [- S, Z: X
//Check both variables for empty value4 U f( d5 o! a( i7 z5 R& c
: f- Y0 A' @- c# o
if (!empty($_POST['char'])){* p4 D" c# g! e% M" L
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where & [: W3 E8 w# u/ H( J5 e' } |8 e
7 A* H# ~" ^% m" U) b8 w; @
m_szName = '{$name}'");
4 q: R. I# [- _6 q+ dwhile ($row = mssql_fetch_object($find)){
& k0 Y% |/ {' y- X) h, ~" Secho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";8 b; E& u- v& x8 f3 P
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], ; |% K: M- A9 s' U
& |' T! v2 A; X# X% E3 B& m[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], " x0 M. D$ I' N6 X$ }% @
8 V$ B; {# A7 i# y1 O
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', - O( j/ B9 G+ d) V8 S% s) H; Q
2 ?# ]9 D) B# V& d. t, U) b: m& y" FN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', + a- G k* f# d- Q
' m" p( k% z0 b) F/ [; o
'{$ElementUpgrade}', '{$ItemPierce}');");. x$ x/ O7 }1 ~* n' y0 b, \
}
4 u; x$ ~5 L- L$ |3 j
% ?8 M/ H$ t# L6 R5 w}
# p# s9 \2 \! L3 J" m7 c' w% J7 U& H
}
) O& U# L" l: x- D' Y8 }; T# h0 {8 `5 _/ l3 x6 d6 h8 v7 g; d
$InitForm = InitForm();
' z; M: T! t% b8 t; s1 v$Listener = PostListener();
6 }9 J G, ]' \) _. Y, @* r; f2 A) m4 v |- {7 M
?>
/ P" ?" r% Z& s* P4 ^
( l$ Q, I+ ~- ]+ a0 E! x, Z' I4 M9 Q( @; u, ]0 w1 W
& ^! P* y& J3 K( D
5 p) R9 r4 h% [. T6 i
|
|