|
|
<?php( o5 F3 `/ Z. V9 Z& b+ o
function Connect () {
3 ^/ H* v5 I: @* Q: G5 B& Vmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
+ s+ r7 l9 M- d; ]7 u7 W
! ^7 L) E. y& Z# l' { R9 k( @; _Failed.');
* m0 a# v' z% D" X) i}
0 Q' K8 K8 O% w# r2 jConnect();
6 @% F8 u9 w B7 E+ [ \+ W
- C) a! W* V" @0 I# Qfunction InitForm(){; q6 f: F9 ?0 `1 Y/ _8 Y' G/ X
//layout for the form8 |2 W, E2 I% {4 g
echo "<strong>Send Items.</strong>! o; ?2 b5 w) B
<form name='select' method='post'>
+ l/ ~3 S p& Y" P, I: s5 ^' _<lable>Character Name</lable><br/>: b) z/ C. z/ p$ W5 U
<input type='text' name='char'/><br/>
5 G4 z+ A" ~0 u2 l<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>2 {. D) D, L5 f6 `
<input type='text' name='item_name'/><br/>
* W* F& {7 w! ^9 ^/ x, c<lable>Item Amount</lable><br/>0 v! V/ H7 c8 g& Q+ V( N
<input type='text' name='item_amount'/><br/>7 f$ S6 T* ^8 _, Z' V/ ^
<lable>Item Upgrade Amount</lable><br/>. i! l, {8 i: A( F& T
<input type='text' name='item_upgrade'/><br/>
( A7 B+ {) u* v2 x! P; | |<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)8 J) Q, k! v2 M7 a0 Z+ a5 c9 o2 s) c
/ I! s# I5 l! j) ?. ^; ^- Q
</lable><br/>
9 m. j9 P5 ]+ _& }<input type='text' name='item_element'/><br/>
( {$ K7 P+ v6 d& D W% X<lable>Element Upgrade Amount</lable><br/>+ z3 [' m7 g1 o3 C0 g6 R
<input type='text' name='element_upgrade'/><br/>
( |, D! P4 h5 B2 V/ x O<lable>Pierced Amount</lable><br/>9 m7 N& D( M) U5 O. _
<input type='text' name='item_pierce'/><br/>
& s$ ^0 B/ B/ M, U2 G<input type='submit'/>% ~: o3 j8 G9 n# s9 B
</form>";* z) I7 `) E, T/ @/ z
}7 w- T' k4 ~6 G+ Z9 i9 R4 I" v
H% I/ h9 j- l/ mfunction PostListener (){; v1 }* d" Q+ {: s, M% s
//Add more post variables if needed and add them to initform() function aswell, q$ O6 @9 V' Z* D3 s0 s
D7 b# Z' ^5 T& S, K
################################+ b% Q: u% P: G7 E) U
##### Connection and Post ####### _; x6 ]$ u! f+ A
################################4 {5 q& I* n' m; U' O! M0 O
$name = @$_POST['char'];
9 {/ h5 D5 ?& f& ^. Z8 p E. R$ItemName = @$_POST['item_name'];
$ X# {9 J7 o* U' w+ ^* ~6 R$ItemAmount = @$_POST['item_amount'];! d6 t# O) D8 c
$ItemId = @$_POST['item_id'];
: E9 G7 o( g$ o0 b8 Z$ItemUpgrade = @$_POST['item_upgrade'];
2 H% p8 z9 k) \$ e- p: I5 F; p$ItemElement = @$_POST['item_element'];2 o3 ~9 a& x/ {" ?; _7 Y6 g; R
$ElementUpgrade = @$_POST['element_upgrade'];
1 \8 R7 D. _& e+ [* v z" C$ItemPierce = @$_POST['item_pierce'];9 f/ ~: v( v6 a2 c! U* L
################################" M. S9 f: ]/ G/ [! \8 L: A) n
/ J4 N$ @; n3 a! ?& R
//Check both variables for empty value. [3 i% R7 [& x5 @! e3 f& A7 n* J
5 {4 I1 D: n! |( I
if (!empty($_POST['char'])){
" H4 L3 g, r/ \& [: X8 x# i0 _$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where 5 q$ q `" y3 U* Z7 q! _! \
- e% V/ t; Y. M( P
m_szName = '{$name}'");" ]4 \& l. L, k7 l! a6 d
while ($row = mssql_fetch_object($find)){
5 G4 g- t) U; L9 B- }echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
3 Q8 g2 d0 n' ]6 h* X* E: B$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 6 R, G# ]; P9 F3 G, ]/ E
9 P1 A7 R! K7 f: q, {1 m
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
# Z5 @' g( X* b
2 P h* u# A6 l% n" ~: u[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
0 O( l0 S2 j; y" e2 n: D2 a; y3 [, A8 x9 [
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
6 S3 }) h8 r; W6 v, y! C4 x9 V2 X; _# ^, y5 e V$ P
'{$ElementUpgrade}', '{$ItemPierce}');");
V' j. R# N5 }" w$ G4 R4 U( `} O9 y& q4 n* X8 z; j: d
: ?; b+ q! B- v$ D
}
" X9 U$ Q8 m6 H/ V# Q( e# o5 ]3 \& A9 @
}
1 \" E. h n4 t' E1 i) S' s, _
% o$ X- b# t/ p8 E" _" y$InitForm = InitForm();& L/ C; E# P; p, `9 O. e" p
$Listener = PostListener();, z) E4 Z8 U* A) z" P
; N# E9 J1 N! C/ m% o, V5 b
?>: b+ M6 ]& O9 `' ]
5 A8 L: ?4 j0 |# V9 U8 T
! E2 B) B4 k5 ?' G, P6 [2 b- b1 O& v3 w) o- l9 [3 P
$ h9 g1 K% O- }. W$ v
|
|