|
|
<?php
% J% H( r" q9 l! Y4 g7 Lfunction Connect () {
7 L) s" L, v4 y8 t5 T( Umssql_connect('Server','UserName','Password') or die('Error: Connection to DB
- \( C* d# F" i# W! R0 e$ u: X) H1 Z: q7 d# n
Failed.');/ K" m% f' C+ H& q6 A
}3 X4 b4 f5 c$ M4 Q
Connect();
' D" B3 m# O/ K- x4 t- H% c. ?
& X; D! c) x' f6 T1 Y6 Mfunction InitForm(){: a4 \0 ?7 c. V3 T0 X' N H
//layout for the form
7 R- }( a7 C% t7 Kecho "<strong>Send Items.</strong>* E& u7 P' a; z% W7 Q4 u+ ?- }
<form name='select' method='post'>
. L7 Q/ l0 o0 O: q0 d* G) R<lable>Character Name</lable><br/>
. I: u" }& E- @ k. D9 s<input type='text' name='char'/><br/>
5 {$ j( j- \9 L<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>$ g' ~9 u0 R1 W8 |# @
<input type='text' name='item_name'/><br/>+ e. q" |9 i3 r# k" U, R3 Q
<lable>Item Amount</lable><br/>* y; t# `- P8 w) A( X7 X
<input type='text' name='item_amount'/><br/>0 ~& ^* }! Y0 T. G9 }
<lable>Item Upgrade Amount</lable><br/>1 n; n& ~# D- Z6 m: p8 k
<input type='text' name='item_upgrade'/><br/>! s) ` x! f0 P. @: O$ A
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
1 }* h4 t* Y4 `' t: i* F
/ O) P/ P1 A8 i0 T- N2 M</lable><br/>
( A* p7 S2 U; T- z( R+ J6 i4 H<input type='text' name='item_element'/><br/>* x* s) h0 i4 _
<lable>Element Upgrade Amount</lable><br/>" I! u1 [% J, L- @
<input type='text' name='element_upgrade'/><br/>4 l8 f" h# F1 h W" B
<lable>Pierced Amount</lable><br/>6 e! [9 f& I" t1 a* y* E
<input type='text' name='item_pierce'/><br/>
8 i5 @/ C) b: [+ N( ~0 C<input type='submit'/>6 R0 c2 Y0 C# C1 V; i: Z$ t
</form>";+ C4 V' t: k" I. k
}# S4 Y |% a4 Y' _( T
" ]+ _" r/ N! C+ u+ e2 | }9 q a
function PostListener (){
3 l1 @% e6 ^& f0 X+ p7 B# @2 V+ _//Add more post variables if needed and add them to initform() function aswell) S1 J# i; N: i# k9 n4 r
3 O9 P7 ?- o" [/ [, c* h' q% O################################( p. k3 @; i) u& B- H- F! i4 \2 W% x
##### Connection and Post ######9 }6 V# t: f& {* U; Q; l
################################
g9 J/ @! R! E$ s4 R4 l1 w$name = @$_POST['char'];
: @, Y L7 E* ^4 v( u; d( y$ItemName = @$_POST['item_name'];0 ]# C7 x5 t- }
$ItemAmount = @$_POST['item_amount'];% j+ E. |: k k2 }' n/ J4 o
$ItemId = @$_POST['item_id'];
: v7 t3 q" l) U/ r$ItemUpgrade = @$_POST['item_upgrade'];
( P/ }6 E5 w! k5 F: C& I8 a$ItemElement = @$_POST['item_element'];
# e5 S) I5 q4 p& Y; O" t: O$ElementUpgrade = @$_POST['element_upgrade'];
7 ]$ h4 y, `! D1 j( R$ \$ItemPierce = @$_POST['item_pierce'];
' @. {, L( t1 `$ f' J8 K( ?################################
) k' T0 E* T/ S" m; G9 O Q
}) l0 W6 D4 V7 n2 r2 E V" q//Check both variables for empty value
/ O3 t/ e+ H8 |! ]! P/ o- P& y E D6 v
if (!empty($_POST['char'])){% j! n; a* \- c
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where & n- Z. h' w6 ]
/ J. }. e* z$ j& u, E7 v5 \0 A
m_szName = '{$name}'");
6 q, W" e& w' b6 w* p8 hwhile ($row = mssql_fetch_object($find)){& E% f$ r% N5 i6 I% v7 U
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";3 O$ y! ~$ T& I) K3 w
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
6 q) T7 _6 z2 B K, B, `' ~7 A0 N8 d# i; i& y
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], 0 |: J. Y& Z6 Q: F" e! G9 E# }
5 \/ ?: W- t7 X& ]7 @5 f4 [
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', $ x5 Z, u& O: ^, h1 M, T( i
% }6 }( q) ^; K e
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
. M+ s! W& @% @) _% c+ R; f2 E
& l5 @6 Y; Q/ z, E j! }& C9 a6 D, w'{$ElementUpgrade}', '{$ItemPierce}');");+ p+ D! m8 Q0 x1 |4 d9 i$ J3 Y. B9 h
}% M, q; @8 u- S4 f$ M% H: Z; j
9 s& _% _/ s$ X}
5 |- R2 ]+ a% I7 F; X2 f: H/ B9 O6 E4 X/ ^3 J: w% @3 Y2 ~& O! g
}2 ]9 w3 o& p! y2 L$ Q
2 y% o" B& n" P5 r: [( b% g' c9 `$InitForm = InitForm();
; M" r+ ]. A8 |0 t2 |3 Y% \& G$Listener = PostListener();
' {( z4 d# R& u c) j9 f; `5 Y+ I' K+ Z
?>9 V5 ]3 J, |7 A7 _6 U
' l7 R8 P2 `8 n6 X. W8 P3 p% k' l
^! t1 T( E: m' H( k9 |; T
8 z4 K5 r* K4 y4 \* q0 t9 I0 a
5 f& ]% y8 a) I+ @+ O0 W: n |
|