|
|
<?php" }9 X$ Z3 a* X" Z
function Connect () {
+ f6 Z" t' F. d( V4 |( Z p! ?2 Pmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
1 q' f& {$ \/ `! W3 f' u& ~2 L6 ]" n" h9 S t
Failed.');
3 c9 _, G; l4 I+ P}
) @% O; C% k/ X6 n) d$ k3 o" bConnect();/ O9 @( J! u5 Y- M1 w) \9 `
' `% M: s9 h1 V- p1 Q. B5 e
function InitForm(){, x: X9 a0 \- P' A. r/ t( }, p: t
//layout for the form
/ l7 E' j4 H+ D& u) k) g: gecho "<strong>Send Items.</strong>
7 r' w) i! s+ b7 F$ F<form name='select' method='post'>- b* V) [! R8 X
<lable>Character Name</lable><br/>
0 p( j& R( I$ G* L3 L3 B+ k<input type='text' name='char'/><br/>) Q/ x# \* A; M A, O; w% P
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>9 N4 h! s ^) ^! g/ j }- Y1 a$ s+ p
<input type='text' name='item_name'/><br/>
* ^: J. U, ]3 D: Z<lable>Item Amount</lable><br/>
4 J1 L1 m% }1 o; K<input type='text' name='item_amount'/><br/>
( N% o( r1 Q% w<lable>Item Upgrade Amount</lable><br/>
* Z j: { a0 D+ u, L<input type='text' name='item_upgrade'/><br/>% m) u& h3 n: G# m
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)* H0 V8 ?% |* k+ B/ y
, P P, C4 e( f0 f2 V8 \9 ]. m</lable><br/>
0 x3 E3 j+ C! Y' \0 s<input type='text' name='item_element'/><br/>' b7 v, N* x" Q3 n( @
<lable>Element Upgrade Amount</lable><br/>' A# j4 J# ~7 `6 j( @
<input type='text' name='element_upgrade'/><br/>
/ y8 c' ]6 q N" r$ V0 @<lable>Pierced Amount</lable><br/>
* l4 y$ y. _" q" {0 w<input type='text' name='item_pierce'/><br/>7 `5 t. p* j$ t8 Y
<input type='submit'/>1 i1 i" j* W0 @, `8 d5 S4 O
</form>";
$ @; K0 b$ U# ~) j ?, g}
: [% \3 Q7 C h9 g! x$ j' [+ J
function PostListener (){% Q+ I: t# }% V) y3 a r/ @6 x- I/ R
//Add more post variables if needed and add them to initform() function aswell7 Z5 g& k1 c; ?6 `
9 K4 O9 J( k& w- E5 c- u
################################
5 R! J1 B- s6 Q5 |- z3 a7 i##### Connection and Post ######* Y. g6 Y" }2 c- m: U
################################/ C5 x, d- @% @/ R
$name = @$_POST['char'];3 Z0 j' W5 F* ^% w
$ItemName = @$_POST['item_name'];
# E7 T8 o6 o, S/ W4 W* D$ItemAmount = @$_POST['item_amount'];
& d9 j$ I0 Q1 L W9 a$ItemId = @$_POST['item_id'];) _" u+ A. Q& f5 Q+ s; E1 a! C
$ItemUpgrade = @$_POST['item_upgrade'];
+ I: Y0 f$ p# G2 t" H! g1 [, `" T$ItemElement = @$_POST['item_element'];( Q* L& v( {( y3 C4 U2 x: M
$ElementUpgrade = @$_POST['element_upgrade'];5 S0 G# z$ P% W. p0 X& R9 @4 z- q2 K- E
$ItemPierce = @$_POST['item_pierce'];: g' |! [4 s7 Y1 ]) m5 [
################################; A. F* a& i/ n1 _
0 Y# ~& v# B- Z4 \//Check both variables for empty value
* U/ Z1 g: ?. ?5 D. r
5 Q* n& a) N( {' uif (!empty($_POST['char'])){; i! O. j/ T. F4 \
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
- v/ [3 m: o4 h4 d' c h" T
$ v5 M( R* i2 z, a) Q9 h, X km_szName = '{$name}'");. y/ q% K8 h6 s
while ($row = mssql_fetch_object($find)){- h/ w3 a' y4 U3 G3 z* w, E) Y
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
* I! p- e L. \$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], * j0 M, p- ]! f/ h5 ^
f& P" ^6 o! u+ s2 n
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
& X( S- D0 }, f) f" n7 H
- Y# r; [) T, v. I, \[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
5 i0 h0 n" D2 U5 U
$ R! I% i, @# \" F* s9 ZN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 2 A/ T8 Y4 C$ |2 r$ T$ h7 X
( n8 m. c5 y& J( ]' f'{$ElementUpgrade}', '{$ItemPierce}');");
. W9 x7 c( Y9 y, N: i$ D7 T, V, m) L9 n}
' n6 K& U% A- Y" J- h& I& a9 Z) H" ^" H/ q. W W+ i' _
}
x3 R' W+ W( U" {9 C
4 v, v. E+ B, @}
4 m" y" I! H7 k) G" `7 }0 v. ?. r2 |* p! ]
$InitForm = InitForm();$ C0 R- _& J. _
$Listener = PostListener();: j- \. ?' |1 V6 G) c$ j
: l+ B8 S/ ]$ w6 u: \
?>
; X( U4 I: S4 S( k. \+ f. N
! K* W3 B. r K8 [, t
: d" j( V$ j% i- \8 Y+ ^2 q3 b! b7 v/ K' C
( B3 s& ~# A5 T, }
|
|