|
|
<?php
7 j* x5 `# W& B5 @2 w/ j1 ]function Connect () {% }2 l! u# ?& z) A, e& O
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB 9 w$ s7 m: {& Z
8 v+ R, z& l2 E2 e3 I% _& O7 C8 `$ E
Failed.');
. f4 p- g R- P& D* L3 B r& Z}4 b/ W6 P L9 @
Connect();5 m$ b) [6 A. ]) l# V$ P
& t. z8 j, _; A
function InitForm(){
8 k3 j0 x+ }6 J) O8 _//layout for the form
- W6 Q; z7 e' w; _! b/ U" [echo "<strong>Send Items.</strong>
0 S: F j3 a5 V% k( Y4 a. h% R<form name='select' method='post'>
2 g* f( T) p9 n5 g6 t6 s<lable>Character Name</lable><br/> i1 P4 k6 K! ?' m2 p* v' u
<input type='text' name='char'/><br/>
/ R+ _/ x4 y( y% ~" g<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
2 V+ X( _4 L0 j9 F' U2 t<input type='text' name='item_name'/><br/>
9 C i `: G3 m9 Y5 V2 T9 V- \<lable>Item Amount</lable><br/>
# N0 E: M5 n5 M) z<input type='text' name='item_amount'/><br/>
J- y, `$ m! ~4 e, A. [) U) l<lable>Item Upgrade Amount</lable><br/>
: L: y! Z# z1 G0 K<input type='text' name='item_upgrade'/><br/>
4 u% P; P" F+ n<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)5 B/ P6 N1 g S0 J/ y
4 r# u# o) c. p' C3 `5 e" p' L
</lable><br/>
c, @- Q0 V% Z6 r<input type='text' name='item_element'/><br/>5 `* ]5 i% J% U9 ^3 ^$ K. _5 B
<lable>Element Upgrade Amount</lable><br/>
. R1 z2 e$ R2 G0 F( X<input type='text' name='element_upgrade'/><br/> E y! p3 l8 s; X2 B
<lable>Pierced Amount</lable><br/>
7 C( F" r8 o7 J: t# @; v8 g, ?<input type='text' name='item_pierce'/><br/>3 f0 M/ Z. C3 @9 U1 ~2 L
<input type='submit'/>
1 Q3 G @4 A1 i: s' Q</form>";
+ c( c8 w0 U! e9 q}
" @8 s* z3 x* G9 w0 A1 U, Z9 Y Q: R* \. E$ K" `) v; H' V! ~
function PostListener (){# u; Y' ]# ^" l( r) w+ r/ c
//Add more post variables if needed and add them to initform() function aswell2 C* Q& c; A: A/ {3 t! V W
. q7 N6 }8 p0 n
################################# X V3 \: d L% O8 `
##### Connection and Post ######" L& F2 D9 G& C3 o8 d: Y& c! [
################################. V' X9 e7 Z; W: }
$name = @$_POST['char'];
0 _- ~7 ~# `8 ^4 l; }* J$ItemName = @$_POST['item_name'];
0 G9 {- I/ y. l& d- E$ItemAmount = @$_POST['item_amount'];
! v3 q$ Z; x) J8 O$ItemId = @$_POST['item_id'];/ D/ u+ H7 a' B; p
$ItemUpgrade = @$_POST['item_upgrade'];
* m( f7 ]1 K" n& P; V( W/ r# k$ItemElement = @$_POST['item_element'];! z- N2 ?/ c6 o! U O7 ^* ^
$ElementUpgrade = @$_POST['element_upgrade'];1 N" W; `" O) U0 Q, s4 P% W2 {
$ItemPierce = @$_POST['item_pierce'];
( M3 G; Z( e, G################################/ _. r, w1 c# ~6 D$ e: f
8 z+ |# Z7 G* m2 s* X( j2 P& K
//Check both variables for empty value
! `, d% ^4 g2 b6 O. ~8 W8 H* Q9 i/ L6 n7 p5 P/ F e# O4 O
if (!empty($_POST['char'])){
" S. ^4 ?8 S$ C6 @) ~4 `$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where # y9 V8 H; E% e3 F# h+ L
/ ~" j( W3 T4 i4 N8 B5 k5 w5 C1 W
m_szName = '{$name}'");
; z/ {# H' l1 q' ?/ V+ U% Gwhile ($row = mssql_fetch_object($find)){. v E3 r) S/ w; ^6 { y' o
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
. B) B" p) p0 o$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
4 P+ ?7 @( _% J7 u" z7 c5 P
: k2 g! i! v3 O1 G4 f$ Z" x[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
; Q1 ]# [- ~( n5 Q0 Z
6 @3 I' W X3 ]. s+ K[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 3 [/ G/ P/ d$ A# s
# w' O9 }& b; l4 e% ?
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', $ C2 i7 {$ c* d& w, |
% d+ J0 X8 h) j {+ C'{$ElementUpgrade}', '{$ItemPierce}');");
) a- E: `; M$ C: _6 e& z}
1 ^; f# r! K8 j) V% c5 \) C1 k- C8 p; H
}" R0 P3 R% V. e2 Z) G
4 V# t/ l- r( k) e3 Y5 Z
}) Z4 h+ p" g3 R
4 m4 a( ?% J$ b
$InitForm = InitForm();
# k+ `5 j) Z( b6 W* K4 M$Listener = PostListener();
; o7 m0 K# l2 b1 { i9 t( @& k/ g: M6 W
* y2 d0 h# ]' O# Z2 L5 |: ??>+ U5 [# w, L+ Q' B
% g/ }7 l3 T2 i2 s$ v
9 X& M. X! s, z, e, ^# A' ]6 c
/ i" Q7 x; h9 ?: }% ]- B6 X0 m. {; e* C
|
|