|
|
<?php" N! j9 i0 @4 A \- o: f0 x2 A, `
function Connect () {9 ~- F$ Z5 I/ B
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
$ S* W/ l. | @4 z) T
F; w r1 p9 M9 G: j- ^$ |; sFailed.');
6 v9 w" {8 B4 T; G" w}
2 a# {! \+ e, s* i8 U9 z8 CConnect();- W: f* c; a8 e) J4 C- c
; j W; p4 H. nfunction InitForm(){, s0 ]7 `$ m; r% K8 k4 C. f
//layout for the form0 ?$ N: M+ b1 _8 F
echo "<strong>Send Items.</strong>9 U, y, z4 t' f
<form name='select' method='post'>
6 |! F6 ]" h2 W<lable>Character Name</lable><br/>
! |* C# x" f6 @+ H/ ~5 V) A<input type='text' name='char'/><br/> \0 _1 b5 Q; X5 E% p3 k) H
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
4 D- z7 }1 p6 }2 ^- J8 c. ^5 ^7 z1 g<input type='text' name='item_name'/><br/>
/ q, y: k+ ^4 |<lable>Item Amount</lable><br/>- H) O) r: v& z9 D
<input type='text' name='item_amount'/><br/>
! h; u) V: R' ^# d<lable>Item Upgrade Amount</lable><br/>- r+ F6 j" \& h9 ~1 b
<input type='text' name='item_upgrade'/><br/>
, ~# y! _ [# \<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.), ?+ k+ W- ]& \3 J) ?
" t- ?6 H8 D8 ~ M0 ^7 B! H</lable><br/>! @* j4 k7 L. m) g) ?6 P
<input type='text' name='item_element'/><br/>3 W% e; [$ }+ o& K7 s9 W9 z" ^
<lable>Element Upgrade Amount</lable><br/>
; Z; k3 ~6 Q) t+ s+ \8 I5 {& T<input type='text' name='element_upgrade'/><br/>6 i, U3 D$ |) e! A9 |
<lable>Pierced Amount</lable><br/>
* F$ C' u4 D0 ^% B! ^" [! `<input type='text' name='item_pierce'/><br/>% r2 k2 a$ B e1 M! ]
<input type='submit'/>
, A6 ^, t$ n( _, G/ s& G! s! f8 @</form>";
1 h$ r+ \! V3 ]: j}
" Q! M, U# q3 {% [! a+ T
; W( j. t0 m8 _1 sfunction PostListener (){4 ~6 X) k# H) T- X9 P- v! \2 a
//Add more post variables if needed and add them to initform() function aswell( t* z) ^8 n" e) e
9 A I4 g9 w. R################################5 R! S* u; h, |$ a, @
##### Connection and Post ####### s$ I6 `4 p1 v; D
################################
( }7 u! C7 P2 {! z8 [" C$name = @$_POST['char'];& b- ]0 E3 c8 M/ u( z4 F
$ItemName = @$_POST['item_name'];
7 e- Y7 B( z- m( m+ i4 K) n" e2 x' F$ItemAmount = @$_POST['item_amount'];$ V$ t- h# k9 @) v4 f+ o9 s
$ItemId = @$_POST['item_id'];* i7 k- F( R" o7 b9 w ^
$ItemUpgrade = @$_POST['item_upgrade'];, B$ a& V) j& C6 N: h, j9 W! `
$ItemElement = @$_POST['item_element'];
( Q# m& m2 K- Y2 h+ w8 @$ElementUpgrade = @$_POST['element_upgrade'];
5 ?- O+ \/ e2 ]; b, O5 Z$ItemPierce = @$_POST['item_pierce'];( Q$ p- ]- ^: E- k" o0 s' W
################################ M9 {2 Z% d# N/ f& [
; A) c4 ^3 u/ f" L7 d//Check both variables for empty value& z4 V9 Z1 |/ k' ^
( U3 d# I' l: i" ]9 j/ F6 Sif (!empty($_POST['char'])){
$ j8 V! }0 g' g5 [5 {$ {$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where ) G3 {9 o. l# Z8 |) S5 A
) g5 R8 }# O3 n4 X2 v Z
m_szName = '{$name}'");7 U( a3 p$ N, c. |, H, i* Z
while ($row = mssql_fetch_object($find)){
, N3 Z; ?8 {3 Q3 z# _" X$ t4 |echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
& @1 N: L ?8 |& l8 D X5 w3 h+ e$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
/ e8 q* Y5 c, d+ m/ N3 m6 v
N: }! G- E" h! Q, L' f[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], - R, @$ \3 x" S3 y3 L1 p- x
# ]& L% I" `9 H7 _[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
! y* {$ W$ L% i* J5 b9 O5 d% R+ t7 ~7 f3 T
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', # D6 ^9 Y ?7 i# a7 l! |/ v
/ c. g) @1 K f0 O! a) }+ N
'{$ElementUpgrade}', '{$ItemPierce}');");
- M) y i' U! d0 E9 D. L}+ F8 R3 p& ^. I! B2 ?
H0 v+ P1 d/ l7 N v/ f3 ^4 U
}
6 Q/ a& @2 \# f9 ^3 s# @6 F" \0 l9 X- B. e
}
; A& W6 v* f5 }: s5 C- D" p3 ~- j5 ^) Z- Z
$InitForm = InitForm();
* F0 W; `4 H: f" X7 Q$ z. |+ s$Listener = PostListener();
]% {. k, o! E7 l5 O7 w% @/ L
4 q l9 V3 w- U" W?>: L7 D* ~; N# Z4 M
o' H# e$ E6 |7 k C
5 O* c) j7 v' k& V7 b: o
/ K* k% F$ `/ ]. Y+ n* V
; y) f$ U0 u) ?3 i |
|