|
|
<?php
- S" W! ]4 Q+ Q$ m# ~function Connect () {3 r! X1 p y6 q' d1 V3 b! ^
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB / Q9 [0 l2 Y+ t6 n4 f, q! W
* v1 x) Q& O/ {+ H! c' [Failed.'); H, m. s3 L4 t! X3 f/ K; ^
}% ^/ o. b. ~" s: T; Y2 R
Connect();
5 I/ B% t+ G- f& b4 `" S0 y2 Q( [4 r" L8 V* V
function InitForm(){1 V/ m; h- ^3 H7 H% S
//layout for the form/ m/ r2 O; Q4 [7 g
echo "<strong>Send Items.</strong>
5 j. O0 t; j/ [9 Z; n<form name='select' method='post'>
& g4 J- w: K0 v8 \<lable>Character Name</lable><br/>% E" Q9 X* \% {+ `5 \7 d6 i: k
<input type='text' name='char'/><br/>$ b7 v3 N$ e+ V+ L
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>, X& I$ k4 {5 ]+ g
<input type='text' name='item_name'/><br/># {8 Q2 p: {9 K# d5 _
<lable>Item Amount</lable><br/>+ z! o, S, R' X
<input type='text' name='item_amount'/><br/>
: k0 O: e! m# s6 ?! Y$ V<lable>Item Upgrade Amount</lable><br/>/ Z; r3 V: y* _, X9 Q$ P, v
<input type='text' name='item_upgrade'/><br/>6 N1 x7 k. s9 b4 X+ I' j# v
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)) b& H6 _& C" Y
% W' [0 n$ R$ y4 z( [
</lable><br/>
5 u- ?8 B4 @+ f& U2 x8 `6 i$ o<input type='text' name='item_element'/><br/>
) a8 Q6 Y4 R* e4 d0 R2 u o<lable>Element Upgrade Amount</lable><br/>
5 l. ?" }6 [& c& J+ q<input type='text' name='element_upgrade'/><br/>; Q2 U7 ~1 i0 Q' h; N
<lable>Pierced Amount</lable><br/>
9 {4 x$ _: f! w9 i3 E7 |9 L0 c<input type='text' name='item_pierce'/><br/>6 F) u E9 n. X0 U
<input type='submit'/>0 f: x/ d. o& ^; c- m( V
</form>";
; g9 {1 g( w, W. ^}
: x3 {: q% I5 Y8 N6 d z: ^$ G$ J2 E7 N! y# Q- C" @ t8 t
function PostListener (){
" N: `/ h: X; {, L7 J//Add more post variables if needed and add them to initform() function aswell* B% M2 h* p x5 d0 V1 Y
4 `: \+ w: G4 r x( w
################################7 b2 n, f2 K( k6 y2 X9 z
##### Connection and Post ######
( I! B8 {/ `; f. V################################) s/ }$ J9 ~8 J2 g+ X1 d; l# v
$name = @$_POST['char'];0 Z0 m2 O" o, l. [7 r% T9 }' u
$ItemName = @$_POST['item_name'];
) j- Z& s: S- p5 x$ItemAmount = @$_POST['item_amount'];
0 [6 O& h2 U3 X; B6 B$ItemId = @$_POST['item_id'];0 k W- b0 l( M. E- y
$ItemUpgrade = @$_POST['item_upgrade'];
% Q# i7 }( o: O1 X- U$ Z* X$ItemElement = @$_POST['item_element'];
# y( W/ _* }) a$ElementUpgrade = @$_POST['element_upgrade'];, A- ?7 y4 m* w* i
$ItemPierce = @$_POST['item_pierce'];
: _) Z& A' [( L R6 I: q################################
" ?- ?6 r7 W' m. N* f0 D. W7 Z* z. b- M+ W
//Check both variables for empty value
* t5 @0 h. K% s# a
1 @- p" B* e* q; `, I3 _if (!empty($_POST['char'])){* _" A8 N; ?, ~0 A
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
# M' b+ S5 t4 z% }: R' w1 ^0 F' c7 v. H4 B& R
m_szName = '{$name}'");) c! H- i) T+ |( }7 y
while ($row = mssql_fetch_object($find)){
' S N+ B; F$ u1 h: c4 O) gecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
( W4 M7 p' Q& {& S8 _ q$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 0 l! ]9 [ w& M- ^
# L# k/ @; w/ w# N l
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
+ Z- x+ {# e& Z b; b9 |7 y5 W, H5 [( r% S. r% w( r. F& [
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 7 f2 H9 j* P# m8 M; t( A2 I' R
, K' e+ E( \& Y2 ZN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
+ ?% _6 w, a/ K0 a2 w' b2 T' f/ q
: }* u; s. b' J, v6 }4 s'{$ElementUpgrade}', '{$ItemPierce}');");
" H" g- X6 t" e7 ~! r}! C) U$ q' j, n' S+ X
/ k9 t: b' M( y b0 h. j, i
}
# w- k' |( P. m' u( _
" H3 P" L" a+ {$ E}1 h0 z- s% ?0 e% q
5 X6 `" w6 s6 I6 u, p, g
$InitForm = InitForm();" \% z+ F4 a2 w* A
$Listener = PostListener();# p- `; T& I* W; Y; G
: I% }1 L+ k r! F* b2 n, Y; @' p% u?>4 t5 D) O/ i9 c6 ^2 A5 D. i
: K) x$ h8 j0 |+ w9 y
+ H& j2 W a9 R+ k+ p! t
2 h5 x- [. \ q5 `$ F( k
0 J O; X4 ?) s, ~' V0 U |
|