|
|
<?php+ T2 j8 D( |4 T" f) B# E# a; a
function Connect () {
) ]+ G* D$ n! j0 [mssql_connect('Server','UserName','Password') or die('Error: Connection to DB 6 _! Y2 \7 a. e# E
: |' m7 ~* `" IFailed.');) V3 }$ o$ D t0 C; ]& N/ W
}
7 ^8 N7 M" j% ~% Z# PConnect();9 r8 o6 H" q0 Y Y* Y
4 C5 b0 o6 G" ^( v& b) b
function InitForm(){$ Y- i! `$ e# A0 a% _7 B
//layout for the form
q9 i6 _) x, m2 Decho "<strong>Send Items.</strong>. Q4 I4 o$ g$ l
<form name='select' method='post'>. Z7 C3 ?& P S& {' I$ B
<lable>Character Name</lable><br/>7 ~8 k6 D) h; \
<input type='text' name='char'/><br/>
& L1 U+ L# t" ^<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
3 M) K; l% c- s<input type='text' name='item_name'/><br/>) f8 W" f+ j4 b Q7 S/ E
<lable>Item Amount</lable><br/>
, [$ T* P7 T: Q<input type='text' name='item_amount'/><br/>
. S/ V ]* B s* \! `<lable>Item Upgrade Amount</lable><br/>/ s- r* [. g x; ~1 n+ V
<input type='text' name='item_upgrade'/><br/>% Q, v6 z$ P% [$ s' a
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
0 u' h$ Z" [7 Y+ @7 {/ \, T4 R# U, X4 n& S
</lable><br/>' {9 X" p4 J* [+ `+ N- l1 q
<input type='text' name='item_element'/><br/>
: t2 P- O+ r2 A3 z<lable>Element Upgrade Amount</lable><br/>3 g e( z% K) @9 O. ?
<input type='text' name='element_upgrade'/><br/>* A V ^" F3 P; x) e% D5 r$ a
<lable>Pierced Amount</lable><br/>
" _! k& |2 ~, t/ T<input type='text' name='item_pierce'/><br/>! Y$ f+ t( [/ e, i: _. G( ]
<input type='submit'/>; }. b+ B% l/ x" N% ~( }$ J" t) o& r
</form>";; ]* W/ N6 C% ` X1 a/ l5 D" y
}
( w7 m9 ?- z) _
% U) J6 E, Y' r' nfunction PostListener (){7 C F" o# V9 `- r& h$ r* y
//Add more post variables if needed and add them to initform() function aswell
' k2 w/ w+ z. e4 R8 Q$ h. f5 V# {* R2 x
################################: B, x: G3 O) x
##### Connection and Post ######. t; G# u4 D# S4 h9 C$ x
################################7 @1 y4 X( w6 d7 d: f" H8 p
$name = @$_POST['char'];
! x/ U, Z3 x; m. o0 w# M$ItemName = @$_POST['item_name'];/ x- x: M( u! G/ i8 L
$ItemAmount = @$_POST['item_amount'];' i$ r* I2 G3 v
$ItemId = @$_POST['item_id'];
' Q$ t: K7 L+ n5 E d. A% S$ItemUpgrade = @$_POST['item_upgrade'];
- P* `& `1 n. j/ T9 K$ItemElement = @$_POST['item_element'];* e3 e& I8 p+ }4 Q9 X9 [7 `
$ElementUpgrade = @$_POST['element_upgrade'];( R% i E0 k+ ?# U9 k% u
$ItemPierce = @$_POST['item_pierce'];
7 S0 |+ S7 y3 w, J0 v1 y6 u################################" E6 w- E) p% H6 b
6 X, g; d; Q* c: @9 e2 K( I3 G: A% a
//Check both variables for empty value
6 {' I. k( X7 w5 r. b3 S# d5 {
/ Z" s2 S9 H* H. s& l6 m1 lif (!empty($_POST['char'])){) o6 n$ y( l5 c" {5 f: N# A
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
1 l) p5 D, W% g8 k0 w! l( t P5 u. g. ^. Q7 m* X) N; E
m_szName = '{$name}'");1 K2 H$ {7 E& A! n6 \5 E: ~
while ($row = mssql_fetch_object($find)){* O* r( I6 M& K) c- M- G% Q
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
q4 {! B7 I* i( i3 z. Q$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
: q! ^, s V8 ~, p5 y2 G) U. y3 _8 \9 c7 c; u' _# c
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], 9 X" v+ k* Y F
# Q$ e" {7 G- c4 ~( x' |; V0 ?: n# C/ T[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
; s, W' t3 i$ Y, x! Z8 C# {) j: _0 `* Y* w$ n
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', ; F; B/ s, U/ Z' f1 }7 y
7 l3 e+ @8 E6 m2 J3 ]+ y+ ]- k' P
'{$ElementUpgrade}', '{$ItemPierce}');");
# s) l2 V+ ]$ x. ~" ~8 e M}
$ ^" R2 r) C1 H
( H$ a* M# C0 C6 r}7 l% J* W' p2 L' A" v+ h. o
7 C/ O/ W* ]6 S9 [% _6 |
}, |4 M; ?: ], W0 t1 j
/ E% K( {9 L4 k. ?, f4 w
$InitForm = InitForm();) e, L4 u& Z% ` d& b" J% t
$Listener = PostListener();
7 Y+ x3 A, G/ {5 {( o1 i+ e; q; X3 `0 F2 D
6 K9 E9 t( ]/ a1 O?>
+ ]$ R0 k3 o' {" K; A
! m. m# C- b3 `# l [& `
5 r% p7 x) K8 d! V3 A, g" ?" E' [: e$ f+ Z- z
- n9 J/ |3 E5 o7 h
|
|