|
|
<?php9 s+ J& f3 ^4 {& e+ H1 P7 O$ ^& e
function Connect () {$ V) l7 A* U' P, J2 b
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB " @, B3 X3 d6 m, q8 J
. t$ \! x1 z% D, G$ G% @Failed.');
. `2 B r) ~% r5 G/ R5 c}
1 x, ^. H2 l4 \; MConnect();
2 G+ F( P2 Q1 _0 U( F* n3 `4 C# X
function InitForm(){
( O4 t9 v$ Y. S. ?" U//layout for the form5 s; {- K5 J( M; u
echo "<strong>Send Items.</strong>
C+ L+ i( S2 a6 a2 n6 Z( u<form name='select' method='post'>
) [: j" c3 ~) V8 k" e9 U<lable>Character Name</lable><br/>7 ]6 B" X1 ]1 R8 b
<input type='text' name='char'/><br/>0 v; R4 C0 R& E/ m( s+ v" [
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>1 H) G! N" X/ w
<input type='text' name='item_name'/><br/>
G2 d# d; a8 w K' ]<lable>Item Amount</lable><br/>
; Q# k8 N* Z& g3 J' }<input type='text' name='item_amount'/><br/>
4 q$ O) @5 g5 j<lable>Item Upgrade Amount</lable><br/>" M5 @- B9 @8 x; v3 t! x6 e8 D
<input type='text' name='item_upgrade'/><br/>+ \# ~5 u6 g5 [
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
* G5 \) y {# h, O
7 X n* y0 m6 r. Z</lable><br/>: \2 g. x: ] Q1 q: I# X# w2 q
<input type='text' name='item_element'/><br/># I2 g2 n8 ^( v6 {
<lable>Element Upgrade Amount</lable><br/>
* S1 n* j8 l5 c3 c<input type='text' name='element_upgrade'/><br/>" y, M! U3 e+ b/ D$ K1 m R* O
<lable>Pierced Amount</lable><br/>& v9 h2 w4 n' l+ A
<input type='text' name='item_pierce'/><br/>5 t5 Y: P9 I: u; i# U; r
<input type='submit'/>
3 W0 F' e( ~- d- g% u</form>";
7 C" _7 V: v6 n6 S3 g}6 d! T5 E! g. z! h$ {3 v; O# s
7 V: s1 `7 t0 l. P6 D$ K' |3 a4 A
function PostListener (){
9 A6 Z& P9 j0 o0 A6 |//Add more post variables if needed and add them to initform() function aswell
* l. s8 ?( p1 J" j/ J
; w- V" x& {' d2 L# u################################5 b. p* ~" ~9 V
##### Connection and Post ######
! Y: B' ?5 t* k$ B/ x################################; |3 A9 }7 G# i
$name = @$_POST['char'];
% C& o) c5 k& C. j/ N: G6 D$ItemName = @$_POST['item_name'];8 h' e. y P% g$ Y+ }: I
$ItemAmount = @$_POST['item_amount'];
' P1 }( u/ p: Z+ A$ItemId = @$_POST['item_id'];; e! o" ?2 v( U- j% F' m
$ItemUpgrade = @$_POST['item_upgrade'];, ?9 e- @5 g# L: B' |0 f% k. B
$ItemElement = @$_POST['item_element'];# Y. [# V+ N. d: v8 N5 O+ J, [' F
$ElementUpgrade = @$_POST['element_upgrade'];
' r1 K9 ]& U3 H* d7 Q" p9 h$ItemPierce = @$_POST['item_pierce'];% `2 M5 e" m, s+ [: ]7 _2 V
################################
0 X* n6 S. e* x! N/ W
/ U) t* {( [1 e8 O//Check both variables for empty value0 }) F z- q' J
/ u6 O* J! g! \
if (!empty($_POST['char'])){
9 {& @/ m% X+ k( f. G1 C c; Y$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where ) o) ^; y' F K% M/ K' R2 S4 W
1 a0 ?8 K6 r- s# t( em_szName = '{$name}'");- ?7 o" M( T% Y2 \. f
while ($row = mssql_fetch_object($find)){
R3 S2 v' M* _$ m! v! Fecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";; w! n/ B: q, e% j# F) K
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
5 z% w M. ]4 j7 b, \
! E5 t6 V" m. }+ g- g% f8 _( h[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
) C7 [, T, y! X- F0 t m4 m* @1 Q0 _* @2 G7 F# l2 K
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', ( h- Y. Y, l3 K: I, D& B
6 h1 B8 e3 c+ I' \) xN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
, k/ l. N9 H5 L8 H. ~7 L; \) ?; X' @0 i
'{$ElementUpgrade}', '{$ItemPierce}');"); u. [+ R- ?* h% }
}: {, Y6 o8 t ?
( _9 x/ o, a& \. p6 M
}
: E1 r/ }& G G- j% z
3 t' Y, s- E9 F, U}+ g5 k1 c) B2 |! E" B
) q" b1 K# S* Y0 V; E% c- K
$InitForm = InitForm();
) E0 i+ y7 v# J/ n/ M7 N/ n$Listener = PostListener();3 q7 S+ F5 r- h9 S$ K S
6 h* o% I& y' e/ F! c) q3 g?>, R( o, v' {, s3 f
9 {8 W) o; P% v, ?0 t8 y- l
7 T9 K+ S* o. t4 i4 a+ Q
\. ?: l( B$ b7 ~' d% N1 f$ ]+ j% {. p4 r- O2 ~9 X \
|
|