|
|
<?php0 |+ v7 p$ x. S0 w( V' s `
function Connect () {
, Q7 i* a" H8 L0 J; Z1 v& b1 M% amssql_connect('Server','UserName','Password') or die('Error: Connection to DB
8 [0 ^6 z* V/ F) O" z& }" p
3 Y7 c2 V9 v& a( G: `Failed.');7 f* ~1 V9 M1 s$ b$ p
}' S7 [' K, |& X0 n9 D+ Y
Connect();: G4 x0 R9 S2 |9 p; D0 ?
& w+ R. M% O: j6 efunction InitForm(){
" R- _5 R! I# y) s! G//layout for the form! K1 e0 V* B$ f5 [5 z _
echo "<strong>Send Items.</strong>; [7 i' g- N* C; ~! U
<form name='select' method='post'>( B5 s- R4 r* d" O* e
<lable>Character Name</lable><br/>
2 `' b( `1 j2 \7 O+ E<input type='text' name='char'/><br/>. a- U, b+ V2 \( b) f" X2 X/ i1 n; Y
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/> X" k- b3 {3 h4 S, m5 s
<input type='text' name='item_name'/><br/>
1 W& T3 i* b- T6 V# I) y: D<lable>Item Amount</lable><br/>) _- U- r2 J4 |0 D
<input type='text' name='item_amount'/><br/>
/ S6 {- ?. n3 I$ ~" N/ ~" ~<lable>Item Upgrade Amount</lable><br/>
+ z+ ^. k2 U- f7 {+ t4 n' e<input type='text' name='item_upgrade'/><br/>
& e m6 {' v; C/ G<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)4 X' O, h' a! n! x9 B o
( D$ [# I' ?4 e) F, O% w3 g
</lable><br/>
2 ?9 i4 a+ `: K4 H8 Q/ [& g: E<input type='text' name='item_element'/><br/>
& z/ a- B' T! S<lable>Element Upgrade Amount</lable><br/>+ ~4 `. b0 U6 L% o1 V$ x0 E7 N
<input type='text' name='element_upgrade'/><br/>2 u, T) b. Q' b$ C" X/ X. E" Y
<lable>Pierced Amount</lable><br/>
( [" A6 c, z3 W0 Y6 b8 U: t" j/ z" Z<input type='text' name='item_pierce'/><br/>
4 t+ w/ X0 n" z' f# h1 W& q3 J) A( W<input type='submit'/>
* g- v/ h( f. t2 G0 O1 n% q</form>";
3 s2 F3 I: P3 F}7 S0 E1 f7 d% o8 t, _3 G/ {
- S# P$ `7 B, b% gfunction PostListener (){- ]% ~& K) {' c, }& A
//Add more post variables if needed and add them to initform() function aswell/ Y2 g% m" ?: Z+ z( e
2 L, ^+ L& @! X/ _
################################0 q9 @! c8 ?. c7 b! y, U0 X
##### Connection and Post ######1 {$ J7 h3 R0 Y6 A$ }. ]4 Y1 A; x
################################$ b9 g- b9 G6 H' O
$name = @$_POST['char'];
0 B$ s/ I$ ~! U3 ]' n# ~0 V$ItemName = @$_POST['item_name'];' h3 c. f" P @' ]
$ItemAmount = @$_POST['item_amount'];" i) [" J, H5 T u$ T# c
$ItemId = @$_POST['item_id'];
, f6 F9 \/ v. k+ l- Q$ItemUpgrade = @$_POST['item_upgrade'];
" B) D. A/ H1 N$ItemElement = @$_POST['item_element'];8 l" _/ U8 I; Z& F9 i( }8 w
$ElementUpgrade = @$_POST['element_upgrade'];/ O; E' K2 Y$ P. u# R' A; P
$ItemPierce = @$_POST['item_pierce'];
; c6 m+ d: _% x; ?9 n" a################################
+ v2 g B: d2 ^% J& ]0 \* q, O! @9 W! P) Y* _; T0 T& D5 T& O" l0 ?
//Check both variables for empty value: k3 H6 U& ]0 O0 h, [8 M( ?- p
! Y- r& `8 w( J5 H( n+ tif (!empty($_POST['char'])){
& | C( Q7 G) e" v3 y$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
* k) }+ [& z1 n& B
# C: e* o5 F$ W" Zm_szName = '{$name}'");
! }1 x$ a2 g" H* ?while ($row = mssql_fetch_object($find)){3 V( M" Q* o& H- c. C
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
: g1 h& H) q& {0 g$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 8 F' Z) e8 N3 O1 r; \
/ H2 {1 I* L' a
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], * f! E' |3 j) X& p7 @
+ o: k g7 O- I* P- X
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', + E) l/ V3 v3 y
. M; n, L4 [8 b: k
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
: A9 T7 B2 M3 A5 n. ]; ^/ J' E0 z. C+ K- `# i) [: w7 @
'{$ElementUpgrade}', '{$ItemPierce}');");. q. f$ f' ?6 {# h# b# i
}
$ w* b/ S6 W* M: s
* R6 g0 E3 u1 ~3 s# D- h r: X}
2 s0 T/ {' O# i. p: L
# T/ @: l" b' d}) C/ m* E: m! D9 [6 y% T/ Q
% \, [; W* r& h p/ b
$InitForm = InitForm();+ [( x0 D( q- R- g" B$ a
$Listener = PostListener();) l, x8 T' z! r" G
3 C1 T# Z" b, Y+ y$ i' A+ _4 g6 {?>
' x7 o3 z: a5 Y' Z1 e. h# L7 r. t
U. l# P7 n* L1 n1 z
( q; ^# a+ y4 |( |% o' |( \" q$ D- U7 U5 R& a* [$ X
. X* c- A* v0 G# }2 S, y7 @* ? |
|