|
|
<?php0 v% P4 I i5 J6 f8 q* e
function Connect () {
& r' H+ E k- p! A6 Amssql_connect('Server','UserName','Password') or die('Error: Connection to DB 9 R; B7 H1 d. q2 |9 H
; O- S& R! J& t% |! y, a
Failed.');
6 X, |) S! `. ?: {4 C}
7 h: a0 |( B" EConnect();
, N4 @; j% V3 O! c
7 K3 ^. S @$ c* }# O, cfunction InitForm(){
( T6 Z" \7 N) [3 j) E//layout for the form
0 M7 u4 l8 |/ decho "<strong>Send Items.</strong>2 ~) U$ ~1 _. O5 O: G! G
<form name='select' method='post'>
* Q i$ }6 A) Z) C/ ]( `<lable>Character Name</lable><br/>4 W2 I1 v7 J$ P! t: e) G+ h3 H
<input type='text' name='char'/><br/>
/ {2 o& L* N% Z$ L' n3 C<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>6 E) k, W# |' ]. l
<input type='text' name='item_name'/><br/>+ ^) Z3 m* c1 V' C
<lable>Item Amount</lable><br/>
2 B, L& L0 X, @; k; `/ V# _2 r1 [<input type='text' name='item_amount'/><br/>
3 q* ]9 _8 M+ o& W7 [: \: A<lable>Item Upgrade Amount</lable><br/>( f9 a3 n! X& C4 y' Y. B; r; b
<input type='text' name='item_upgrade'/><br/>& `! a5 a# z" K0 o8 W& c5 y' ^6 H8 D
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
6 r8 Z( _1 m9 e1 w8 W# I& D9 j: y5 k& d7 k% R
</lable><br/>
$ j9 @1 O. n/ \/ @$ r; F2 m<input type='text' name='item_element'/><br/>
# S4 M" ]0 A4 G& x! e% b<lable>Element Upgrade Amount</lable><br/> T6 U. r5 E, N! Y% a% r- M e
<input type='text' name='element_upgrade'/><br/>
) ]$ b5 t- a" h<lable>Pierced Amount</lable><br/>2 [4 Q% o, u3 p+ z! ^, N; p$ m
<input type='text' name='item_pierce'/><br/>* E& r+ y1 n- P" F$ C& |- N
<input type='submit'/>
. _$ F; [% g4 N0 t9 h</form>";) H! L) U* g: T; Z" s
}
! J' j$ a% j/ r. x1 j' q- E+ \
' B- C6 Z: T8 V( K: r" e% ^/ Xfunction PostListener (){
. ^6 X8 O& b: X l. v//Add more post variables if needed and add them to initform() function aswell. D* q7 b0 g* U8 f+ N* R8 E! a
9 k, R4 x& p: Q- v( G5 k" Y################################, u; g# T. E- a/ @
##### Connection and Post ###### A! X* b( C2 W
################################
3 R( L- [5 v; ~- e3 n5 j$name = @$_POST['char'];& b/ u8 H q& Y$ L5 _
$ItemName = @$_POST['item_name'];
- b8 u1 u3 c$ k& A) P0 N/ P" C/ p$ItemAmount = @$_POST['item_amount'];9 P- z) { i+ B& z- r( _
$ItemId = @$_POST['item_id'];
' w$ D! M ^/ |9 V! S$ItemUpgrade = @$_POST['item_upgrade'];2 x; d i3 ]) m. m. K0 E$ s) x, r/ @
$ItemElement = @$_POST['item_element'];$ h' E2 c% Z8 l, r, ]
$ElementUpgrade = @$_POST['element_upgrade'];& {, O2 i9 r- r9 |
$ItemPierce = @$_POST['item_pierce'];
q( z) j1 Z7 T2 C2 B! g################################. T, h" ~" G+ U/ C; h
& l7 u% z! J$ [8 Q
//Check both variables for empty value
4 ]7 p- ~3 x' l) g. ]) n
$ G( G& M \' s( f" r* `if (!empty($_POST['char'])){4 |- F) D, P) V# N u
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
p! {/ Z7 q' Z* y( h- L7 O' ~5 G c7 P7 r& ]4 D0 Y, {; A, A- u
m_szName = '{$name}'");; y) p6 b7 M$ a; B2 \) U( p y# J
while ($row = mssql_fetch_object($find)){5 k. Z5 b# W$ ]" B' w
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";& u& @# t. T* }) ?, a n6 D! i& R
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], , _# N& }, ^6 f8 b; ?) |8 i X. }' G4 C
( S0 U+ ^* z- V+ Q& L
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
0 a3 O) a0 P3 v) x3 A
3 m. h P6 @2 X: s[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
! N3 G5 G) z$ Y! j, D# D) Z1 ~ b3 A* |
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
: y3 b9 d8 q) L
. D. F; r1 j& F7 t2 ^/ `, E'{$ElementUpgrade}', '{$ItemPierce}');");
2 L2 u. O# n* z, }}" v" ~: M2 \- n7 H8 P+ ^. Q4 \4 J
, y* w6 m3 J! {) d- n6 _}, K5 v% W, g+ v6 h
+ B( w* l# r( k1 e2 l, |}3 F4 R3 _4 { _5 _
; L a$ H0 M# e! t0 Y( `$InitForm = InitForm(); V9 O J4 n/ b6 c+ R$ I+ M
$Listener = PostListener();5 F$ N. ^( k O0 C2 Y0 c
7 x" p1 {! R8 s- S?>
6 R ]) |; B" Z) Z4 u; k, A( _) x+ ^: e7 m; L- C1 W+ R
* Q, q% k1 D9 E; ^- H U
0 A- f3 s" f0 o9 q! n% `! j& A' H1 w9 M: S" j" G! L+ d/ l5 t7 U
|
|