|
|
<?php+ t( P) l3 i. n6 c! S
function Connect () {" p6 S$ y3 o; n( S5 A
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB % l* ^; b D$ W d. J( y3 n
* `, J2 W1 a5 M, o7 j' YFailed.');
1 r3 l) t% B; P}
9 g+ B0 g# t5 i5 C% E: Y+ Y0 VConnect();1 @) u d2 a. J
- o& }- Q' m0 u8 B# t7 bfunction InitForm(){
, k8 o7 h& J# [- q d//layout for the form
2 e C2 b$ `; v6 b% D2 b. q; E& fecho "<strong>Send Items.</strong>5 l( L* |1 H [& M& a% `, F
<form name='select' method='post'>* W1 W5 `5 [% k; }5 c
<lable>Character Name</lable><br/>
: k& j' P" ?, w9 H5 p<input type='text' name='char'/><br/>
: Q; G+ |6 h) c/ _3 i9 i6 H<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
8 l3 `! G( M" @! A s<input type='text' name='item_name'/><br/>$ I- S5 F, }( S q. y' L, K
<lable>Item Amount</lable><br/>
8 e @# ], P: \! x: l<input type='text' name='item_amount'/><br/>
5 t* k6 Y6 ~+ d<lable>Item Upgrade Amount</lable><br/>7 W! p. B4 k/ O. j5 r: ?
<input type='text' name='item_upgrade'/><br/>7 J2 n. j, d- V
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)$ \+ ]. M' b+ c8 H& q( q
' H3 {0 E: J' Q) n+ \' G d8 W
</lable><br/>0 `, C3 ~ j3 l; u+ U" y3 g1 |
<input type='text' name='item_element'/><br/>
7 I- G$ D! [) t0 p; g8 C<lable>Element Upgrade Amount</lable><br/>
, Z# j' ^7 I0 X7 J! _ }4 e, o<input type='text' name='element_upgrade'/><br/>
[8 O$ B7 S4 @# G$ O<lable>Pierced Amount</lable><br/>$ X* ~% G i' A' W8 I3 @8 V/ O
<input type='text' name='item_pierce'/><br/>
! [/ e! e- ^0 W* a7 ~<input type='submit'/>
: q$ @. [5 K W v</form>";
" V; @9 O0 z) n/ {}/ u; r' R" H1 v- q9 b+ J
. \9 K+ e+ E3 }/ V/ lfunction PostListener (){
# J- ^- P, D5 Y) Y; k//Add more post variables if needed and add them to initform() function aswell
: u" O; C$ `2 U: S% D( l& t. w# n% ?' }' w3 e6 y* J# T
################################9 H0 N( M# z' G
##### Connection and Post ######! W$ j3 W# s* K& B
################################& k0 l# G7 G6 ]% b- p5 k8 y
$name = @$_POST['char'];' F+ W6 U$ e) H& }6 L9 ?
$ItemName = @$_POST['item_name'];, t: V6 o9 v7 q E. H
$ItemAmount = @$_POST['item_amount'];
7 w: p( R& N5 a) r9 n% t3 {! j8 X$ItemId = @$_POST['item_id'];$ H: ~/ @! F6 z4 K, X8 p
$ItemUpgrade = @$_POST['item_upgrade'];4 Y/ Y8 w P$ {; k7 a; u
$ItemElement = @$_POST['item_element'];
1 J y9 ]8 A# g% c- ^% \. d* o5 V2 m$ElementUpgrade = @$_POST['element_upgrade'];/ w# V. s& f7 X; \3 W6 a
$ItemPierce = @$_POST['item_pierce'];% _: d6 r2 |8 @1 [
################################
$ `9 O3 H! ~5 `: K( s( f& K/ @
$ N: N( T( h: Y. R5 D2 M3 Y//Check both variables for empty value2 O* {! u* Y! O; C; a7 z
7 d; p2 ^" q& D# S3 Y' M6 e
if (!empty($_POST['char'])){
1 G+ U: C7 D! y0 O9 q5 d. H$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
7 H$ K6 F: ^0 ^* \4 X- I% P
, v7 f; J+ g& r. z& x M& rm_szName = '{$name}'");
! A! D- U! g3 a4 [: X( s$ C( f- U8 Bwhile ($row = mssql_fetch_object($find)){
! z( x6 B" @8 m2 U3 v7 g7 becho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
5 v! j f( Q& {8 Q. s1 X$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
& v1 x+ f6 I9 p+ U: I5 H1 g2 ?( h
, Y, h4 }% `0 B[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
7 d. P7 a. a7 E$ e: ~: E
7 c) w! w% S0 e$ d% ~7 ][m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 8 \) q1 T; k9 z$ C
6 h' ~" |# I1 cN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
# E. |! s. N9 w' s' B$ n6 u% `# ?2 B/ h/ e# B1 k2 H+ ?
'{$ElementUpgrade}', '{$ItemPierce}');");% c5 ?+ O2 y9 j& W% m
}
9 I* T C5 v0 \& _: {. W: V8 s2 V
}0 c8 H4 a4 b ~' G; p
! l7 C- C8 m& U; x5 H$ |} W: G5 L: u( j+ y% b6 Q! Y$ `
9 v, l4 a! n( I; k; z* c
$InitForm = InitForm();: u9 ]6 n4 W' @' }1 E( T
$Listener = PostListener();- V2 J; P) g/ e7 I: d9 o
8 d# ]2 k! I* L% w* o' v# Z?>
1 P- g4 T0 s" V3 i* h& t1 X; M5 `
( Y" ~ u7 {9 D/ q& c( K' J
( E+ V- s3 Q& |* q. D$ \# H% m4 _
( ^8 K& L+ w. k/ @: ]
: W' `2 G6 ~9 r |
|