|
|
<?php+ t8 d! D7 A3 i
function Connect () {
( e/ L4 ^; K" lmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
7 R, V6 r+ z8 i2 n* |6 |/ @
4 r$ I: F/ l. F/ v3 ]+ y: `Failed.');* k0 U( A( N" G+ p U
}
" Y+ w6 D) t5 FConnect();
S f6 A1 E) o8 R
/ U! H- E# K% `9 W) _* Mfunction InitForm(){4 y M& k! X# e# ^0 |2 i) M5 |* S
//layout for the form
. j% c+ v( c) O; n1 Iecho "<strong>Send Items.</strong>
( t: n% O3 \7 F8 W/ B4 o5 G<form name='select' method='post'>6 n) X: |. H% m0 q% [% H! Y
<lable>Character Name</lable><br/>
& S9 @2 q5 b7 }7 k# C k) x<input type='text' name='char'/><br/>
; _* u7 m4 c. A+ y. {3 y<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
9 i- A+ u9 A7 m9 a" |- e<input type='text' name='item_name'/><br/>
4 u, Z6 s. M( w, s9 p9 X<lable>Item Amount</lable><br/>
9 F6 R+ |0 z9 S, B1 @, [0 O<input type='text' name='item_amount'/><br/>% p9 v+ d- I2 g3 |
<lable>Item Upgrade Amount</lable><br/>
$ _& T1 Z( e0 F5 j<input type='text' name='item_upgrade'/><br/>2 q+ c. `7 X: M+ O7 B- e
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.): I: N r% `3 E8 U3 c
* y3 H3 t5 d! @, B
</lable><br/>! q; d' {8 l. L( h# J
<input type='text' name='item_element'/><br/>
& C/ Z/ T9 R! _1 A$ n0 C<lable>Element Upgrade Amount</lable><br/>5 f: }, y* Z' w6 g- N+ Z l
<input type='text' name='element_upgrade'/><br/>5 z8 F1 V* E* f7 L( n5 ]
<lable>Pierced Amount</lable><br/>
5 `6 f1 v4 e3 \# d. L* p/ Z<input type='text' name='item_pierce'/><br/>
% m5 m L( m% u- w5 M3 c" |; g$ [<input type='submit'/>
' L. I) P1 F+ m) C) f</form>";) x% f- M* i- h# g, g7 x- w
}
t! V& ^) F9 u
! K; {% c# f" I k5 F0 R+ Qfunction PostListener (){
" v8 ?6 v* P: T. J//Add more post variables if needed and add them to initform() function aswell
9 s& r3 r/ p# q; _& S6 h5 }0 q
7 M' F. q' ]. e" r################################
4 a* k! b- p9 Y1 p##### Connection and Post ######( T2 G! B$ N: c$ Q( b
################################
4 d' b( ^: M4 f: W6 n2 x$name = @$_POST['char'];. P, K& v/ P4 A9 d
$ItemName = @$_POST['item_name'];. T$ l1 F3 ?& R+ v9 O' c' w
$ItemAmount = @$_POST['item_amount'];
3 f6 r0 L4 C! k7 s3 k; f$ItemId = @$_POST['item_id'];6 H% }: f/ T5 d5 d0 Q8 g0 g
$ItemUpgrade = @$_POST['item_upgrade'];* a2 r ?+ J9 }. a) }# u& B( ]& C
$ItemElement = @$_POST['item_element'];
) P. S Z: i! n t$ElementUpgrade = @$_POST['element_upgrade'];
; A& h6 `" G z3 r$ItemPierce = @$_POST['item_pierce'];
" z. N) p6 Z3 i# w################################- e0 l4 p% s3 u- O
- w0 v" V" v4 A( S* o1 h//Check both variables for empty value! W& Z" ~- R% M+ e. ?, |
6 m7 J( i5 j" T! w* g
if (!empty($_POST['char'])){
9 @$ y# E+ `3 `" `5 ^$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
! L3 ?4 j; L4 M: b5 k5 b8 d7 }" r- |( i. y# E/ O, x) Q
m_szName = '{$name}'");
8 o" @9 g( `2 v" k+ Fwhile ($row = mssql_fetch_object($find)){8 ~ \ u& X. ~5 V9 B( V
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";" z9 ^ V6 I1 Q3 N- J' v
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
0 t$ c* c% I$ u: `+ Q8 [
3 {% _" q9 T9 U3 x+ w2 P[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], . u$ d" r( ~ }" {
6 N- {9 t) n. U( O- N, |' s, B
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
/ f( P$ b \. ^. F6 U5 j5 O" v( ~
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', $ E6 w7 N# T; l+ t% j
, z* X$ b2 u0 _) h8 V" Y: C'{$ElementUpgrade}', '{$ItemPierce}');");9 X/ @; T1 a; _8 ]
}
' N; U. _8 n7 x. u; U) ~6 Z9 ^
. j8 u4 w2 h& o}+ \" c9 |+ U; n/ X1 o
# ^1 v& C$ Z! l2 i
}/ }& f3 z' ~2 M5 Z) U( x% s7 O- {
' y, r+ J& c4 o$InitForm = InitForm();9 K$ ]* _" d6 {5 F1 v6 A
$Listener = PostListener();4 O5 D. h. E1 }7 T
9 l/ H) |: k3 @. k
?>5 ]& M/ ?; ~' ^
+ |% h6 O, w6 }/ B& `0 Q
$ u% Q' ]2 A% ~1 y
; S( k0 {* L5 x+ E
( v+ b0 E- x- t: p* u* G |
|