|
|
<?php4 g; Z8 z) Q- b8 u8 b+ }% J: V8 @
function Connect () {
: H7 u# M8 ?4 H% v9 q/ E& {/ l* \mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
5 I4 U, I, e$ _7 |% S3 ?, e0 y: F# K. N$ X! ?7 U- _ b( q: Y
Failed.');
: F1 \9 n) n% |- Q}
6 ]6 I+ S5 O" rConnect();
! |( w8 w+ Y0 S! D* j' o" E; A. O4 L0 {8 `4 Q2 h& Y7 k4 z
function InitForm(){
0 J; X! E' E. ]% m8 U' i//layout for the form
- O; H3 P, a/ J4 b2 S1 e4 secho "<strong>Send Items.</strong>4 ^# |7 W" Y' c: D
<form name='select' method='post'>7 R# Z2 G2 ^: q# {
<lable>Character Name</lable><br/> k( L' e) K1 W/ p5 @6 j
<input type='text' name='char'/><br/>
! V' S9 ]* \5 {; l<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
2 Y3 M! l5 P2 o4 r. C7 M9 o6 X<input type='text' name='item_name'/><br/>
! K) `, g- `" C. ?: H# D; M+ e<lable>Item Amount</lable><br/>
# m0 ]7 N# t6 Y) ?! {, x; _# d# K<input type='text' name='item_amount'/><br/>
: x( ~9 Q: f! O; e, n1 r' c<lable>Item Upgrade Amount</lable><br/>1 o- G- ~4 O: P5 j# H
<input type='text' name='item_upgrade'/><br/>
# K. v2 Z- ]. d) u/ K<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)& d8 |( O( n$ n* y0 z
) j2 S7 m8 P$ \1 Y1 _* q</lable><br/>
( p, a4 B" H0 t& c<input type='text' name='item_element'/><br/>, O) y% d7 G. D. Q' Q
<lable>Element Upgrade Amount</lable><br/>
. K" z: G) A) Y: A8 S' G<input type='text' name='element_upgrade'/><br/>
, t4 y* e- O) G0 x" \8 K; a<lable>Pierced Amount</lable><br/>% V- N* \) B% @* \5 }
<input type='text' name='item_pierce'/><br/>' q. D* u# O- R3 @( j9 {* R
<input type='submit'/>& k. }2 T+ O1 c: E5 H
</form>";/ x8 u/ H8 o; m3 o2 H
}9 v6 i% k1 P7 f
. ]2 Y4 E" g: @function PostListener (){
, n( X9 a" }- z q% V* \) c//Add more post variables if needed and add them to initform() function aswell1 e& W% {, p% F* G7 p7 H
# E- T2 c9 I8 w# ~* s. L+ p7 D3 j
################################
5 w, w; g1 ?0 ?, P" I( L##### Connection and Post ######" a" W D. U9 g% t8 l3 U
################################0 X4 w7 y1 I& j
$name = @$_POST['char'];; u I0 T) L7 T+ d/ |4 V* }+ U
$ItemName = @$_POST['item_name'];# R* A; s: t' L* r
$ItemAmount = @$_POST['item_amount'];7 _) k- R! z7 @2 q
$ItemId = @$_POST['item_id'];
) T8 ^+ X1 Q2 H$ItemUpgrade = @$_POST['item_upgrade'];
7 n# {9 G: r' G/ _( i6 ]! M$ItemElement = @$_POST['item_element'];
' f0 |& J2 x+ i, R9 t9 I$ElementUpgrade = @$_POST['element_upgrade'];
* s, \/ m( W$ R3 D" ^" c) C( f$ItemPierce = @$_POST['item_pierce'];
) @" y# b5 F R2 i! {6 X# x# s################################+ `* p% K" J1 g5 Q& H+ c1 W
" |0 q, I0 n% i) z! }1 M; {& y
//Check both variables for empty value% a) E- E' y3 j; y& r1 A
( S' d% n0 Q2 {if (!empty($_POST['char'])){
) ~( S* e8 N, p2 s/ d+ G6 Q8 W$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
6 s0 r; p/ V3 A7 u8 A
2 D; r6 P5 U" E; a6 M7 im_szName = '{$name}'");
& Z$ u {+ G5 D* C2 bwhile ($row = mssql_fetch_object($find)){
) d, u8 f+ O6 e# y" Mecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
# f+ |. m$ W' W5 t$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
! r/ X7 v( ]3 m' c% I/ }, v# x; c! j4 x! g3 `. M9 m( V1 C
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
/ F6 G; T" ?9 y% C- c
- O3 D" a6 ^ D* r[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
; ?! B( C9 \3 v( t: {. p# o- ^. `7 W, n
7 v: M a/ j v: y) u9 b* ZN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', * F" q2 ~5 v# w' V
; Z+ s/ e/ U- ?' v9 e5 U
'{$ElementUpgrade}', '{$ItemPierce}');");# _! }2 _8 i8 l# x9 V d
}. }5 N. [' D" y8 l7 @
6 @# p9 m: \0 u$ e$ w- e}
& M2 @( d! o" L8 v5 x8 t" W, O- x
& B& h K* q6 ?' Z! W& t: p7 o. v}. E- w9 q$ W) [* D5 x, B8 S5 ]* \
6 r+ ?* g" }( E1 g
$InitForm = InitForm();, O2 w8 U& y& O& r3 h
$Listener = PostListener();
3 b3 L1 i% \ h- L! l* p" z o( A0 V1 g. L: A: w
?>
- K3 x' Z; B7 Z+ f
/ ~/ N: |6 ^' K. \" o( [% i# |( S+ t
3 X- d( q, X' X6 ]7 `
$ L6 Q) W- h) l. h
|
|