|
|
<?php
8 y3 w7 G8 X% k; n5 _function Connect () {
% ]2 Z9 g( x3 d$ t9 Mmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
2 x3 N; k. Y- n* V7 w' D0 n3 y& J' t) U+ o% F
Failed.');
% g5 ~% j5 n& Z( O7 l; q' B: J% G}" x O, M& C7 z' R1 o" g9 U
Connect();4 p) g ]% } g6 ~/ |& |
" [8 h* B7 ]: v0 W' Y4 S
function InitForm(){
' p9 ]3 @& ]7 K" m, m/ E//layout for the form F1 K4 ~& M6 G
echo "<strong>Send Items.</strong>( X. H! j( n" D& M
<form name='select' method='post'>1 H( {0 F. n& i+ Q
<lable>Character Name</lable><br/>5 t' F t) K* Y0 F: H4 I
<input type='text' name='char'/><br/>
6 p( d9 j% R4 k2 Q' l<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>4 P/ Q8 c# D+ ^
<input type='text' name='item_name'/><br/>
- O1 F: F" e, g; q6 N3 ]<lable>Item Amount</lable><br/>
% W1 `" j$ i7 I% V1 |: k$ J' S<input type='text' name='item_amount'/><br/>% t! R4 S* t( { U# b2 c' M
<lable>Item Upgrade Amount</lable><br/>3 }$ n/ J; [* J( E& |, S1 W+ c% s4 b
<input type='text' name='item_upgrade'/><br/>
D" s. x, E9 j1 P, e- O/ y<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
0 W7 R# z- E5 B( ?( M
: \ r* G5 [* |4 C0 K0 M</lable><br/>
& E, ^* z( [2 e<input type='text' name='item_element'/><br/>0 e) M. q2 s* s
<lable>Element Upgrade Amount</lable><br/>
4 X9 Y* s0 `. o: G$ S, g. ]<input type='text' name='element_upgrade'/><br/>2 C& x$ k% ?+ B9 S& T* D Q/ s4 J, J5 g) g
<lable>Pierced Amount</lable><br/>8 i! a. k. X# ?. Q) L
<input type='text' name='item_pierce'/><br/>
9 }: w5 Z9 E. }1 O8 Z<input type='submit'/># N1 |' a8 I4 R, k/ _! i
</form>";3 C+ J/ l' o% t+ {$ p' A
}
/ U, M8 J* `% \. W4 F
; `8 k- `( b! D( I* w1 zfunction PostListener (){
: X" N4 ?# i: h& ]# A//Add more post variables if needed and add them to initform() function aswell- t( B7 D& a$ H/ f% Q
& Y9 a" ]) p, [# x* e0 {0 u U: N################################& C) F/ ]$ O: q4 I& t) i
##### Connection and Post ######
; D- m, S8 H; R4 y& ~/ ^################################' C7 u1 q& {! I7 _ i
$name = @$_POST['char'];( A$ S( P! a* {. F. ?
$ItemName = @$_POST['item_name'];% j6 v% ]$ N% C" Y4 b$ W0 l% s
$ItemAmount = @$_POST['item_amount'];1 u( c( s3 k+ I* M( r# O
$ItemId = @$_POST['item_id'];4 [4 g- p% [5 D) ^; Y' ?
$ItemUpgrade = @$_POST['item_upgrade'];3 G/ M0 P! m$ e( Q7 W
$ItemElement = @$_POST['item_element'];7 @' W4 d1 t/ g
$ElementUpgrade = @$_POST['element_upgrade'];2 ~6 ]# G \( x: Q4 X1 Y
$ItemPierce = @$_POST['item_pierce'];8 A& k. h& N% k4 D! W7 Z
################################7 E j. M" Q* ~' a6 u3 K5 S
; B+ Y( e( m r//Check both variables for empty value! w1 w) ^7 W/ ~: ~) ]
5 u5 U$ ?- D- R+ [0 \if (!empty($_POST['char'])){
8 _1 g2 A. E. C/ h. g4 Z& U+ @1 d$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
8 Z/ P4 C" Q# k8 A' |6 i. }" U s9 b; C9 s2 u u
m_szName = '{$name}'");
4 Y5 ^6 g( N4 v8 ?# ^while ($row = mssql_fetch_object($find)){. P2 }0 J/ R% ]% t# M& `
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";+ E! P5 |4 X7 p
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
! l6 p; n( `# p' s9 B8 [ r
, D( b9 j, y6 N; u! K[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], & R& r, ` F* f" z
6 k: E5 z- l- r: F6 P[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
o! _1 |2 M; m) `! K7 ~/ Z D6 w X% O
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
k- Y: E5 k1 O1 z, @$ t1 K
( M5 F# l" e5 q( r8 P'{$ElementUpgrade}', '{$ItemPierce}');");4 ?9 {1 b- B+ F* I- z
}
# T, c4 b; @3 E G6 ^# `- A. g4 x0 W7 H0 }
}& ?. X9 H( z: s+ L
1 w3 u5 O2 P r' `}/ E8 }: w1 B$ d4 o& @( G
% j2 G1 O0 O8 k, `
$InitForm = InitForm(); [; p: C, f5 D% o9 H, j, v& r
$Listener = PostListener();( U7 E) k" {; J ]2 z6 n r
2 I9 p& o# W8 m
?>
. U# x% [, j: g. X7 C; G* g
3 R" {9 D% L! d5 ~: U# ?# _- y1 C. \! g r8 e
5 c! Z7 l- B+ s
! ]6 l+ T- E5 Q$ x2 D" m |
|