|
|
<?php
. g: k! b) ?0 a0 l! Sfunction Connect () {
0 w! ~6 e; K9 n4 i+ Rmssql_connect('Server','UserName','Password') or die('Error: Connection to DB 9 W: B8 ], L, m; I8 k; r+ h
! @+ t9 H2 p" t2 b
Failed.');+ U5 j. G# @# Y [, n* P5 c& |
}7 f' b6 Q! Y4 |
Connect();
k, I: u! n# a- U1 K
2 e8 u/ ^ a& ?: u) jfunction InitForm(){
% A- w4 O- [, T, s7 G//layout for the form' c5 t @. `, M% d2 X
echo "<strong>Send Items.</strong>
% Z- }3 t- B/ m: m<form name='select' method='post'>
- s$ U# _2 J( }6 C( \5 F g8 m<lable>Character Name</lable><br/>0 Q+ \9 z2 n* Q6 o" D( V! _2 G
<input type='text' name='char'/><br/>5 k R1 Q+ P7 p K
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
: K# Y$ M: T4 k+ o0 G<input type='text' name='item_name'/><br/>9 P% v0 Y- j* S0 O) D
<lable>Item Amount</lable><br/>, c5 M0 A, l5 Y1 h
<input type='text' name='item_amount'/><br/>
; \" z# D+ ]9 ]8 ^: X; ]. G<lable>Item Upgrade Amount</lable><br/>
) m; a+ d; Z3 B# Z0 Q3 h' i1 f<input type='text' name='item_upgrade'/><br/>3 {% [- W) d5 `# K+ p1 r
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)" j& h" U- x+ W! r. h8 y
7 d$ y$ Z7 }- r" k0 V ?</lable><br/>' K8 ]& x; T% Y. G9 D4 l" e
<input type='text' name='item_element'/><br/>( \7 M8 v/ w2 G: S5 ?
<lable>Element Upgrade Amount</lable><br/>' K8 v% b/ s- s
<input type='text' name='element_upgrade'/><br/>! A! n2 _5 h) k! \/ R& D% F
<lable>Pierced Amount</lable><br/>
; Q3 y2 d$ r+ K7 G+ m( R! k<input type='text' name='item_pierce'/><br/>
( ^3 w0 ~& |6 j% b2 B/ D- o<input type='submit'/>
, J" t. A9 i0 H/ _* l</form>";
- s+ y1 {+ d5 T}
7 b$ l% ] N3 H7 H, S& p1 [4 l: y; W' f
function PostListener (){6 D$ t Z. U: A% O
//Add more post variables if needed and add them to initform() function aswell) ^/ ?7 P$ H# v# a) b/ o
t P5 c. m$ @4 \; w* z
################################% e7 |0 j8 _3 G. n9 o) j
##### Connection and Post ######
5 I% D! k5 s- H' p, u################################8 ^% n/ I. D# A# p4 A: }3 p' i
$name = @$_POST['char'];
$ M J8 ]6 w' u& p4 ^; m0 {$ItemName = @$_POST['item_name'];
9 e$ |( r! r; z2 d2 f$ItemAmount = @$_POST['item_amount'];: P! G* @) m! N
$ItemId = @$_POST['item_id'];
5 N: e" d0 x& Q# Y$ItemUpgrade = @$_POST['item_upgrade'];
# b; W6 D' t! L4 M$ItemElement = @$_POST['item_element'];; |/ \! }: v$ M% D; Y) c
$ElementUpgrade = @$_POST['element_upgrade'];
1 L: F: @% Z g" }: `& m$ItemPierce = @$_POST['item_pierce'];
8 k+ n0 x7 V+ B" D0 T9 o+ h0 ^: b################################* D1 p; p4 X) A3 z" K5 e2 P
: J. t5 J- f) R# q
//Check both variables for empty value4 e8 D9 i/ L1 F3 R$ {# _) `! P
' Z. ~& Q( _2 B _
if (!empty($_POST['char'])){
: ?- t I; m" B/ v+ L0 \$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
6 G u! q- V6 @% b4 C6 f: r* ^- K# M
m_szName = '{$name}'");
1 N, y7 G8 O# nwhile ($row = mssql_fetch_object($find)){& ^. [; b' L' }' o$ D) \6 l
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
: v# |2 A0 o9 o$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
( m9 Y5 b& K' U. P0 o1 b1 i( y6 [% {# ~5 ]
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
2 ^$ ~! t! Q* }1 H- B+ o
4 d" i& F1 q/ k5 J; a; E0 A[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 5 ~2 {/ z @7 H- Q
7 e9 R' g% K' i" IN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
5 m5 `; x- Y7 X7 n- h& `. n; h. X* g) d1 c; X' U8 P; ]
'{$ElementUpgrade}', '{$ItemPierce}');");% J/ T! c E! h* ]& J9 E+ r0 `
}
7 e3 ?1 \+ l) \: r- w
& r- n8 B+ T7 N4 t# e7 O}) l9 M1 ?4 F6 ]8 o$ _/ C+ H! S
6 k& s, {& c7 B# g
}
; M Z" H5 m( p3 t- g, e3 o5 W. t% W( k- A( D7 T. Q
$InitForm = InitForm();% H: H6 Z# p$ I8 U q3 \3 t9 I
$Listener = PostListener();
5 @0 O& j p0 p" C8 Y
* r: _) T, r# C" u. I: o* H3 `?>+ r- ]- s- [0 Z- l
# l4 B3 J; [) B& [* X& Q
+ E* X0 Y' M2 {. m) d0 t2 H0 v. Z# u$ `5 K7 q1 b
0 u# F' G. P P1 Z# B; m" U, E |
|