|
|
<?php/ k( D: O7 W+ O+ F6 p. v
function Connect () {
7 V. d% G: Z) T! w8 ^mssql_connect('Server','UserName','Password') or die('Error: Connection to DB % C& t2 `8 |. t8 e b8 w2 H
# m- G9 ]- d2 }3 [) cFailed.');+ z, V& k. o7 @. P
}
- j) X, T2 \) T. A' p. W6 xConnect();. ?# u- n+ ^! i4 h6 n; o
" b8 m4 w( ?+ {: j' ]! u; H4 {function InitForm(){
( e9 k+ [' W0 I1 W8 H//layout for the form
$ ?9 ]% ?$ ~3 n% S9 ^3 n/ S; oecho "<strong>Send Items.</strong>
& |1 h( A$ Q3 }<form name='select' method='post'>
4 G" p4 h" G/ D E3 ]) Q, ?" {<lable>Character Name</lable><br/>
) u8 M7 q M9 D. y+ Z- ~<input type='text' name='char'/><br/>: ~5 E# z# a4 k B/ f, o; {7 D
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>4 Y2 k u) ]' t. o+ a
<input type='text' name='item_name'/><br/>3 F3 T9 p1 _, D6 [0 b
<lable>Item Amount</lable><br/>
: N$ h' \7 v8 k- _8 @- u$ U<input type='text' name='item_amount'/><br/>! k3 @2 \/ g9 `6 f' X8 @
<lable>Item Upgrade Amount</lable><br/>4 ^8 l# l# ^1 I4 v7 P( ^% L
<input type='text' name='item_upgrade'/><br/>
K' x: b4 p' k' D<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
. O; }, j- o/ E- j# ~8 ]9 }* d
9 {& d2 a# b" `! w" @</lable><br/>
& @$ q% V& l( w0 @% U<input type='text' name='item_element'/><br/>- K! Y+ E1 ~$ H
<lable>Element Upgrade Amount</lable><br/>
, }& N0 s* Q) |' O, t<input type='text' name='element_upgrade'/><br/>
; U( k: s/ d: l. q<lable>Pierced Amount</lable><br/>. ^* _" h* \$ O! ?7 G+ _8 e
<input type='text' name='item_pierce'/><br/>& H3 D; t" z+ z
<input type='submit'/>
: x* s8 z, x. w0 t3 l</form>";
- ?$ w% y$ U# W2 Q& U3 O* }7 t}
9 R) } o& Y/ c2 a- |: Y
6 ^7 {1 J) `& k. R% ^( s" jfunction PostListener (){
. _' L; K$ K5 i0 E% o//Add more post variables if needed and add them to initform() function aswell0 V2 W N& v/ \& k5 f( e' R
+ h) @, y3 O+ L8 p) j. u( R% S
################################! q+ }& q" @$ t8 Y, ~( l! _
##### Connection and Post ######
# E% E, J/ c/ G6 \- y################################7 P8 K6 a \& y& H! K/ K
$name = @$_POST['char'];7 t* s4 b, b0 k1 X2 w: |
$ItemName = @$_POST['item_name'];
* T. i. U, p8 w1 {$ItemAmount = @$_POST['item_amount'];
: v: b$ n9 B2 A$ l$ItemId = @$_POST['item_id'];: y) v" ~) I* M4 y- w9 ]
$ItemUpgrade = @$_POST['item_upgrade'];; g" a m0 L, H
$ItemElement = @$_POST['item_element'];5 ?: I3 V+ M% T ?$ A( w b) g+ Z Z
$ElementUpgrade = @$_POST['element_upgrade'];% R A' w' C, `, c8 j6 D
$ItemPierce = @$_POST['item_pierce'];
, l- f$ i* P: a4 B, ]################################2 H& Y+ [1 Y6 D3 N- Z+ _7 |
4 V, ]3 }# i T9 z8 e
//Check both variables for empty value s& q. z$ J8 q5 s
3 U; _# u0 N y. h- N2 ~if (!empty($_POST['char'])){
; x v# ?7 G5 t; j: H$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
' Q# r3 E* E" T# [% X7 h( U
4 H; o/ ]* E) d! X( s; ^8 im_szName = '{$name}'");1 z% c, L* T$ N/ b8 h; z! ~
while ($row = mssql_fetch_object($find)){
9 R6 C9 R5 i$ r; R1 ]4 F8 a9 Techo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
" |0 b1 L" ^9 f) r! n6 S1 Z$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], ' e1 i# [6 k: B8 F
0 ?/ ~: \2 m* M# Z! ]: A% R
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
; ^1 G( _3 r# _! a# e) K! Z( b
* f0 K, \* t5 N# O" U0 [[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
. }; y! [: Z& d
* U/ }# R1 r$ ON'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', ) ~0 H& J$ o: `
& `8 s2 Z+ E1 D& z- @+ S* J' z& I7 J'{$ElementUpgrade}', '{$ItemPierce}');");6 x+ h0 M2 R. w8 I6 z' S; i
}
. i1 @9 ]' h3 F
; W/ A: F6 E6 P% y9 E1 D}, J. W! V: [. X w: B1 m& V
/ O; w- ?( h, k. h( t/ S' y
}
1 W2 ~/ C8 z' p; F8 i8 n1 p
' a ~$ Q, o: S" r' ` \" h$InitForm = InitForm();
6 k6 D: i, ^# a+ w% n$Listener = PostListener();; E) N. s! ?' m; ~3 k+ v6 r& Z
$ c: N# B9 m: \# k
?>5 T! m! U6 |( d2 u7 o
7 J: }" j6 Y W& S8 Y% t, c4 ^7 Z1 J, Z+ W
0 I N) {, j# N/ @3 D4 H& g) O! O$ d" h1 x1 `$ X7 [, a, A# J
|
|