|
|
<?php* v p* Y" h- B1 s; X9 {( l$ l0 @
function Connect () {
# ~, g# k4 U' ~1 h9 Tmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
, {$ p8 B, U) M" ~
0 U& p K# M) k$ b& h. U IFailed.');7 \) y) ^/ \" B. f A
}, U8 J! m- e7 d2 B. e) l
Connect();
: ]% {/ s; V4 M6 W6 O# L5 A" \ B5 j
! Y: T2 z% ~' z- |- mfunction InitForm(){$ f. ]& Z; {- H& L7 H& E
//layout for the form
3 T' h! u' b) N' C: a6 }2 Hecho "<strong>Send Items.</strong>4 T- Y& J$ y; h, K
<form name='select' method='post'>
. x9 [3 q, z, s% w<lable>Character Name</lable><br/>' C" V4 L5 U: E; Q( p: k
<input type='text' name='char'/><br/>; x! |8 v/ J! X; S+ ?
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
( R- y7 r. [/ @# a( S<input type='text' name='item_name'/><br/>* f. b9 d" H* s5 j g- \9 z ]
<lable>Item Amount</lable><br/>
' n' I8 |$ [) p \0 a- I2 p! T* g<input type='text' name='item_amount'/><br/>
5 f3 z* t; d, _+ g0 I5 [<lable>Item Upgrade Amount</lable><br/>
! h5 l! K$ q* p3 n$ ?* |<input type='text' name='item_upgrade'/><br/>( r; r, Z7 g/ c! ~+ G
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.); n$ D- s( W |2 \/ P' i0 M2 F2 C4 C
1 x6 w0 X: G/ I, \
</lable><br/>
/ I2 y2 C+ {. b; M) N* R<input type='text' name='item_element'/><br/>
; d$ S) q/ C4 K" ?( I. u<lable>Element Upgrade Amount</lable><br/>( }" }4 Y' G. D' \* Z1 U8 {
<input type='text' name='element_upgrade'/><br/>
8 [7 n8 U$ W) A9 v; w. G }2 I5 J<lable>Pierced Amount</lable><br/>
7 [! M$ T* ?3 Z u- [<input type='text' name='item_pierce'/><br/>0 C7 d8 W4 A) G# `+ _% j7 p
<input type='submit'/>% B" a2 ~5 }6 |5 t0 |( b1 u; m, k, @+ ~
</form>";$ E) F1 ^7 }! i" u
}6 C0 ^. i3 w$ g7 e* O+ v) H
5 F. _/ B9 e+ t) ?; ?% Nfunction PostListener (){
! ^" w" j* }) ^2 N9 u//Add more post variables if needed and add them to initform() function aswell, a/ r# |: {: j
6 ]) l; B. l: V4 O################################
2 k' w! X l6 Y# O+ R9 o! P: X# Y. g! K##### Connection and Post ######
/ W& g1 \$ ]6 R; H################################
8 f# N- r& G2 s/ ]1 T$name = @$_POST['char'];7 Y) l b% K! x# K+ d
$ItemName = @$_POST['item_name'];3 B. y3 P8 W5 b" h. y+ O: A: X
$ItemAmount = @$_POST['item_amount'];
# d E- T: w: w, U9 |$ItemId = @$_POST['item_id'];
$ |! e4 Z$ o7 W: J8 C( ^2 Q P$ItemUpgrade = @$_POST['item_upgrade'];. D; m' y! B( C+ A& S
$ItemElement = @$_POST['item_element'];4 V" \& A+ X P# D, |8 _
$ElementUpgrade = @$_POST['element_upgrade'];
5 a9 o- F) Q/ R# s/ k$ItemPierce = @$_POST['item_pierce'];
6 }7 _8 |+ J2 k k$ ]! ]################################
6 X- C: c* j8 C; q
" x; e" `8 f4 p3 a//Check both variables for empty value+ ^6 s) {9 G5 W: Q
5 _5 W: C. ~( J" { Sif (!empty($_POST['char'])){
4 O7 N# N7 D [$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
8 M3 K7 a1 X( M" V$ @2 Y. t# H4 C2 H. H* B2 z
m_szName = '{$name}'");! k6 \+ V7 | W
while ($row = mssql_fetch_object($find)){
6 {3 E* L+ L# [" xecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";5 K9 m! R4 ]; A, D" S. Z
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 3 v! T; l2 \, d: V4 D
6 G. N8 }" L& d9 s# o! i5 Y[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], 9 Q0 U6 |6 l- m$ m9 O6 j
: |. w, h0 n, E+ A; o[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
- b5 y0 m5 b; ?8 G+ p% C. c+ v4 V d, [3 j+ t# a5 _9 W
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
' o: i k4 `6 N) {) R1 O8 ]$ D* B9 v6 A* y8 Q
'{$ElementUpgrade}', '{$ItemPierce}');");& ^3 O. Z" z( `% f6 R0 q. j0 w
}& ?. v0 j$ M/ K( `
1 p8 Y5 G) q6 H
}+ P2 L) T. W& O. P: F3 J! d
7 X/ s d$ a6 q6 Y2 `
}
5 ?/ o; p) z; |+ z& ~. M7 u" E+ h5 |, K- ~7 K
$InitForm = InitForm();
6 M! G& Z: O. P4 a4 j [: R3 r$Listener = PostListener();
9 b/ ?/ O, O! U: y5 M6 ~1 |) u' I( K3 P* y }5 X( e
?>0 `0 a1 v! ~0 l, h7 [
) i" H; ?+ A" f* e8 @
3 W% y: [3 I0 @: m& H6 E4 I
1 j& P* L/ K3 Y" ^ K6 z: }0 N' y: g$ g" R- _5 h! n
|
|