|
|
<?php
% S I; S) S3 \4 @# Jfunction Connect () {
' o5 L& X$ o* x6 L2 }+ i8 |mssql_connect('Server','UserName','Password') or die('Error: Connection to DB ) |5 x8 a6 `7 q& D, |! X/ A
( I, g# S9 z2 u$ ^
Failed.');
' @' J& U4 L6 N# {}
. M4 s. j. n& J4 z+ EConnect();
8 {3 t1 P1 z; k1 R" |% P8 z9 @
1 C3 q% M. f7 X' F0 p! Kfunction InitForm(){, b$ E* Y, C* [% r! |
//layout for the form+ d1 \# S, b: B# o0 C
echo "<strong>Send Items.</strong>3 t' [% X' f+ X4 E2 O
<form name='select' method='post'>6 I; {( J! A5 x2 F- ?
<lable>Character Name</lable><br/>% {/ a) x, p# n+ I' i9 E
<input type='text' name='char'/><br/>
# \1 s% s; i2 x+ E<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
3 g8 Y: ?: x0 ] ]<input type='text' name='item_name'/><br/>
1 F2 i2 f$ n( x9 Y<lable>Item Amount</lable><br/>4 |2 e# L5 I6 r6 k5 }. x8 Q( N
<input type='text' name='item_amount'/><br/>) ^8 H% O$ S8 V/ ?: t* z
<lable>Item Upgrade Amount</lable><br/>3 o* M' ~ c1 y6 X: ~! @
<input type='text' name='item_upgrade'/><br/>
, M! b2 Z, k- P4 V- _4 F7 X/ r. l<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
- F# L1 H% J- h9 }$ d; @$ ~2 o& P; d( e5 g1 A
</lable><br/>$ H: L% W# U: k/ {
<input type='text' name='item_element'/><br/>: P$ h/ L2 {: o0 n! E p' V0 N8 N- |
<lable>Element Upgrade Amount</lable><br/>
" f& q; C( D9 P1 O! J$ R<input type='text' name='element_upgrade'/><br/>/ r& h+ n/ n2 i2 j
<lable>Pierced Amount</lable><br/>5 A3 G! T2 o9 O: j' R6 V$ v
<input type='text' name='item_pierce'/><br/>1 m7 B$ c" K. P+ q$ z+ u
<input type='submit'/>
' b0 A8 V+ t/ z- O6 ]- M5 c% i' d* J</form>";9 K5 B$ y8 B! t- ^* b1 l1 ^- i
}
1 A' j5 W8 @5 Y7 P. K' Z" B1 s# t9 ^3 O+ y' S& t" g
function PostListener (){! a" i' W; B4 J) q
//Add more post variables if needed and add them to initform() function aswell
# \9 D% W6 E, |# x) z0 F# d% ?0 ^7 G* i( W
################################( m4 K5 v @2 Y- V+ U2 G* |& ?0 N: Q
##### Connection and Post ######/ L& i8 Y! k8 _0 l
################################0 b. M! X' R6 `- n* a! P: u' [
$name = @$_POST['char'];; K1 h- n+ g2 n1 u5 J/ M
$ItemName = @$_POST['item_name'];* s! B5 {3 c. H$ @+ j7 Q
$ItemAmount = @$_POST['item_amount'];5 k7 s. p2 {" u$ L- z7 ~2 c; H0 w
$ItemId = @$_POST['item_id'];
4 w$ t7 R2 l, U+ p0 B, a$ItemUpgrade = @$_POST['item_upgrade']; U8 B% u3 @" {4 z
$ItemElement = @$_POST['item_element'];# h( n% [- F- ~( k$ U+ T
$ElementUpgrade = @$_POST['element_upgrade'];
! W: O& W/ b( Z+ w; K$ItemPierce = @$_POST['item_pierce'];# ^4 o1 U2 R& I- ?0 b8 Q) u* \/ n* `
################################& A$ }1 I7 D% K" h0 ]: W/ y+ h. k
7 e8 E) g- G* [
//Check both variables for empty value
# Z( l0 N. i4 \6 |2 }% u
6 ]+ N! K7 W# r" P; Q9 k) S" W1 Jif (!empty($_POST['char'])){
& v: F4 g5 c, V- Q0 H, ^$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
" r! t8 F" f6 Z5 R% D/ U+ u% t
5 h( `( }& V. hm_szName = '{$name}'");# B6 t" [$ N$ O2 ~" c( R+ d$ R1 o
while ($row = mssql_fetch_object($find)){
4 C( w) T: T% _& Cecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
, K, S7 {! I6 a. A$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], $ `/ r* u8 t" `
" @( I2 D2 k3 u
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], " Q% t% T( L% Y* b' V
, B% y! D) a4 ?! j% S[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', - z/ Z. ~& v1 ^+ b* c: p$ m4 R. y
; C" l/ Z2 k- i& }9 ^N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 0 J; e, u5 |' h/ L3 Q# @6 L4 H
5 E* _: ?, L% ?; w1 [, x" }/ ]. U! F
'{$ElementUpgrade}', '{$ItemPierce}');");: A' \- _0 }/ D1 D
}# }2 `0 f4 H7 C% ~& B# `
4 ?9 Q% Y. N% ^8 I6 z) A, l1 E. q
}) A7 m3 D- [! T/ m( N) l
3 K: [* S# a; M5 F" Q}! t( p- [8 A- w7 k1 ]
+ D+ E" ~' V9 N9 |$ I6 C+ u$InitForm = InitForm();$ Z' D# Q8 b+ o8 c" O* o' q U
$Listener = PostListener();
9 I! s4 `# C9 G. e; _* V& z7 }: d7 t9 ^4 p1 w- F" c
?>
& l# j, o+ E& G" q d# Y( M4 `. j, w# Z) a S1 @
- F! Q; R. b( q& [8 w
8 M% }8 F/ H E0 `4 _0 T) J1 V2 L9 C, z9 O5 T
|
|