|
<?php
+ n8 U% G) z( g, @function Connect () {
# {6 v& z5 v/ f+ w# }mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
/ @$ T, B/ J2 C9 A% `
' n6 L+ i2 K O1 [9 sFailed.');% {6 g+ y4 e1 C
}
# Z9 f7 J! M! X7 K; g5 i; `Connect();$ F3 n2 u8 ]6 P
1 r- T5 {" k: Q3 G' z( M0 X
function InitForm(){
$ ?9 D# r' }/ n+ \//layout for the form
/ b0 v2 e$ }6 c. Q5 x; S- A4 j" h# mecho "<strong>Send Items.</strong>, b7 t3 D6 z3 ?; C% D8 W& h7 h/ k% v
<form name='select' method='post'>* p8 r- L6 J; O
<lable>Character Name</lable><br/>4 {2 e& M5 E" S" u" g5 d1 _. X
<input type='text' name='char'/><br/>
( x8 f4 q6 K \1 l+ p<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
. ` k- I$ H% X" z7 M& @- @<input type='text' name='item_name'/><br/># m9 C. `4 t0 Y/ J. s/ S7 W" q
<lable>Item Amount</lable><br/># a* Z7 p& N1 R* C$ q+ g6 N
<input type='text' name='item_amount'/><br/>, z8 [ a4 S% m3 q# w
<lable>Item Upgrade Amount</lable><br/>1 o0 e w4 p* }, i; G% u
<input type='text' name='item_upgrade'/><br/> g; S! \/ @* b& r
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)$ g9 d$ i$ v3 J; l
6 i" x! R/ C* K1 P( Q
</lable><br/>7 b5 v6 Y7 N- F9 N: ~, n7 E. V
<input type='text' name='item_element'/><br/>
7 N$ m, B2 Z2 m" `& `<lable>Element Upgrade Amount</lable><br/>) Z$ q: l) T5 P- Y# e; h+ Z! Z9 z
<input type='text' name='element_upgrade'/><br/>- z$ \" `. }/ T7 |7 @
<lable>Pierced Amount</lable><br/>5 m/ C! t# e/ x: D' R
<input type='text' name='item_pierce'/><br/>
% i& U4 C# i& u<input type='submit'/>
! d. o$ C( k9 i8 R: o l0 s! N! q9 A</form>";
) Q. I3 e+ Q3 n% f) z2 Y}
/ c: n3 z+ F: b6 t" L! Q' H8 [2 g& d( t
function PostListener (){- w" l; [; j5 q1 x/ K' N6 y
//Add more post variables if needed and add them to initform() function aswell% x w! P/ W, U7 G9 I# a- A- u
6 Q' m* _7 M+ {4 |. P$ I2 F################################5 l$ i/ D5 c0 ]& s& G
##### Connection and Post ######
: {. v; R& w: q################################
) w/ i5 X, P8 A$ F' w6 @* s) J$name = @$_POST['char'];
9 S" m; \; w: _ U+ K$ S# b$ItemName = @$_POST['item_name'];$ j1 C& d- Z$ p
$ItemAmount = @$_POST['item_amount'];# g. v2 |& w5 ^: E9 |9 I- A _: N* q
$ItemId = @$_POST['item_id'];7 U4 E9 X2 r! t* p
$ItemUpgrade = @$_POST['item_upgrade'];
% P. b8 H& {4 ~9 |8 v$ItemElement = @$_POST['item_element'];( W2 r# d5 R4 y6 Q- }2 d$ z, m$ j
$ElementUpgrade = @$_POST['element_upgrade'];0 u5 d& U- n) O2 D5 F5 L, }
$ItemPierce = @$_POST['item_pierce'];- g1 X, M- A; |' o
################################
! c/ O* A4 k) o% C% w+ f- [
- k2 x# o2 h3 a* L//Check both variables for empty value
4 S# @! W, w `# U. c& v3 X f6 j8 d3 U; X5 c6 @; \
if (!empty($_POST['char'])){
+ s1 n- i: U# G! _; P. T, g2 |$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
& |. t$ q# H8 b
1 p& W% }8 @/ A% U! A6 s) Jm_szName = '{$name}'");3 @; E' K# V* K7 f6 L( D" K( x. t
while ($row = mssql_fetch_object($find)){
+ E" ~: G) ~/ D0 R/ uecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
1 Z1 |+ W j1 @! {3 B$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
/ L2 @+ c' U/ v% t7 L2 x" I; l% C4 O( n4 D( o
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
% l3 v8 i8 Q" F! `% a6 C
& s% U' X, d8 v/ N9 M[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
% ^6 n1 c2 {* s" M. ]+ `
" N5 \1 n5 Z: i, M8 a* aN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', Q2 {; F" d3 C! H* M; p
- ~" q: R0 i2 ^' ] w8 V0 O4 z
'{$ElementUpgrade}', '{$ItemPierce}');");
0 X) s8 S' c5 Q1 V' i* b}* P p, o. k9 ]8 A
" h! K- q2 S: F$ |' V7 {2 V0 w! a: Z
}! x- \. B i; Q0 t& ]4 S3 E. r. b
. c1 s, f% e' y4 V, y4 d
}/ ]( P% N q/ f2 e C
& d9 r+ o& M# m# ^& {! @2 H$InitForm = InitForm();( ^4 G7 T+ f3 H( C( }
$Listener = PostListener();
$ v. v4 O# ?5 S; F: Z" O( G7 b3 w7 ?7 Q5 P& s
?>
0 O3 }. n: Z, |. W% \6 _) a5 @, n% N* x$ d$ Z5 a0 C
$ O6 w' t% Q# A3 I, b% j4 y+ ]/ ]% w' U$ }9 y% s s( l
) ~( ?) _5 V/ d, i3 T/ r# a |
|