|
|
<?php3 a( F' L/ \- q% `
function Connect () {% q/ Y; U) W1 ?; `. H* \! T& D
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB , P6 g' r- i2 I2 V2 j" b
1 _5 B, p4 \' x
Failed.');! k0 q; \# M- b8 t' J' @& e% t
} {# o- @& y& K! I$ ^* `7 n# v
Connect();, A+ |! R! o/ T5 v1 _* C _
6 J' B/ C" K% H$ Q, f# Xfunction InitForm(){, w5 I& p) u7 Z4 C
//layout for the form; G0 m, l" o9 c9 Y% V1 y
echo "<strong>Send Items.</strong>
: k7 O4 I* P, x3 z# x: Y! `<form name='select' method='post'>2 [5 W( v* o% _( r/ o7 B$ z
<lable>Character Name</lable><br/>
' g0 e c0 F# z G<input type='text' name='char'/><br/># L0 l. P* v/ i
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
2 A$ ~0 V7 D; E6 l) p. m; u- A, J<input type='text' name='item_name'/><br/>1 |+ F' f- j) s: ^# Q
<lable>Item Amount</lable><br/>
" x4 Z9 m0 y- r2 k: D2 R1 ]3 ?<input type='text' name='item_amount'/><br/>
5 g. O4 E8 ~% `3 Z9 W+ v5 f- g<lable>Item Upgrade Amount</lable><br/>! o1 t; _8 |4 n2 B' I; G) L
<input type='text' name='item_upgrade'/><br/>4 A! W) J, _$ e
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)2 k! f8 h# Q; b! s5 E
$ ]" x) m8 K! y</lable><br/>: _* a; H9 e% X1 Y1 U
<input type='text' name='item_element'/><br/>/ v" p# S" @9 l- A+ E& ]- T
<lable>Element Upgrade Amount</lable><br/>+ f" d) ?( X; c2 k
<input type='text' name='element_upgrade'/><br/>
7 z {4 D# \- r# ~$ N5 I6 x<lable>Pierced Amount</lable><br/>3 M P6 [ l) ?' k- n2 F8 A
<input type='text' name='item_pierce'/><br/>1 R2 M$ \0 l: p! f/ `# q
<input type='submit'/>
: x2 w% _' i$ `</form>";
2 ]' Y" g% e# c) W% U# J} P A! ]2 S0 s; F
3 i4 U( c% F& A: d
function PostListener (){
3 y- i' t- |) P! o//Add more post variables if needed and add them to initform() function aswell
% F3 h8 l( \$ d$ q* T8 T' B v
+ j& _: b `0 t$ @! L################################/ H: q2 R5 G: f+ G, |! m
##### Connection and Post ######
Y% U$ o7 v4 Q6 N################################
+ @4 y2 u7 l* W( i0 S0 ]$name = @$_POST['char'];
8 G0 X0 L9 A5 Q2 r7 O Q% L8 v3 ~$ItemName = @$_POST['item_name'];
% v) K: X0 G7 J2 i. S4 z) p$ItemAmount = @$_POST['item_amount'];
, J5 B, O& \! {( {% Q- _$ItemId = @$_POST['item_id'];
) d0 B! T5 e# j d$ItemUpgrade = @$_POST['item_upgrade'];
+ J6 [9 M3 u& K+ D0 C3 x$ItemElement = @$_POST['item_element'];; c4 b& X( T' E
$ElementUpgrade = @$_POST['element_upgrade'];0 t% G/ D: S: R q: Q
$ItemPierce = @$_POST['item_pierce'];) M2 L- d* \& o8 v, C
################################- z4 U2 f* A. }
( g6 Z3 l7 }% o6 n9 H* t4 e
//Check both variables for empty value
1 a2 k; T1 |( m
|5 v+ l! L$ A6 g$ Qif (!empty($_POST['char'])){ |6 b5 X. U+ |& N
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
6 @5 B# I& Q6 l: z1 V/ S8 D# L
$ A, c/ ^ F9 B1 Y$ u9 Am_szName = '{$name}'");% |) W* Q3 h$ M! k# g7 p1 z
while ($row = mssql_fetch_object($find)){, O$ S+ p7 f- x" L$ |
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
' {+ w& x. a- T/ |& u$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
- n. v% |% a/ x' {2 b" i' e* o# ^0 Z& Q& q
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
' Y+ @1 Y+ {/ z0 l' x
3 R- Y A0 o+ s/ q9 G5 b) o1 e) {: U[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 2 p; X' F5 |% I' M# ?
3 q: m, S' k# T: v7 k' U6 o! h; {
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 3 g& L2 X- Q# ]3 d
' j/ w# \! R/ ]/ ]: s4 a! F
'{$ElementUpgrade}', '{$ItemPierce}');");# s9 W& ?; u# V( v* H' ?2 P
}7 J+ V. i* ]/ _& \0 f
1 t! e0 K8 |+ m# F$ U}' |; |3 L, ^6 p) P% H
3 h# o. O( E, _7 s; o$ R
}
9 _$ j" P/ E9 w. v
: x& _2 P" C: v2 i- x/ \$InitForm = InitForm();
- q2 {2 Y) v" h. x( `% V$Listener = PostListener();6 c" c2 w$ m2 g2 j+ W, V1 \( B
) y% T) S! E* i" n' T5 `9 D; x
?>
c3 w/ E1 o9 Y/ J: Q: f7 z" D
/ R* o: w6 S6 O' M1 x: l" q3 R7 Q5 m3 K/ _5 P
, m9 W# [* W$ j6 E( N$ v( A
) v. a( B# D* @ |
|