|
<?php
' F/ ^ `+ \8 k* Nfunction Connect () {
9 i& p. c: k6 s- y% M# Z* xmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
5 M& T4 K" A# |! {. G
3 s* |1 ~6 `/ c* D( `: x$ fFailed.');2 ^: p. s* t5 Z- k
}
; T1 U: n. c/ p7 o- ~Connect();1 N. @1 @8 \8 i; E9 @' U& w
* i c7 X3 z' }% I% w+ h
function InitForm(){
5 ?* t, ?! g0 d" S3 \! Z4 Q, Y' B4 w( D//layout for the form
5 v* U" s% ~3 C2 X" ?echo "<strong>Send Items.</strong>
+ R# T& q1 H- _" B4 }" P<form name='select' method='post'>
! o J' G2 G- w- e0 b' c<lable>Character Name</lable><br/>
; O u+ ~0 b5 |<input type='text' name='char'/><br/>9 w8 p& [% u: C) E. F# i
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
" v8 F7 R: l. w/ r<input type='text' name='item_name'/><br/>$ B# R& Z9 m1 X- ]0 v3 o
<lable>Item Amount</lable><br/>4 |* }3 C1 ^) }3 }' [6 v p
<input type='text' name='item_amount'/><br/>
; D& [" w1 Z# w3 d. y' g, E- Z) F/ E<lable>Item Upgrade Amount</lable><br/>
/ I7 K* p; B! n# p3 i$ G% M% L<input type='text' name='item_upgrade'/><br/>
1 v* z6 W; p) E( N ]<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)( m ~; z- Z- [" @8 J8 E& Y
- }3 }4 q; F9 R+ u" J7 @* i
</lable><br/>" w% T2 N# L1 [0 W8 r9 ^. m3 q0 M3 [
<input type='text' name='item_element'/><br/>
3 U7 n" j+ S$ o4 L2 w<lable>Element Upgrade Amount</lable><br/>
4 Z& z9 L/ z! L* d1 ~<input type='text' name='element_upgrade'/><br/>* S. e @4 U$ E# d: R! i
<lable>Pierced Amount</lable><br/>
. A/ Y" T$ I+ l% r. Z6 V0 o<input type='text' name='item_pierce'/><br/>
" V h0 K5 `& k1 d<input type='submit'/>
$ H: g5 g, r+ }+ Z; Z8 J</form>";
P$ X) @7 ~) n: @. \}, Q" ~' I8 v& ~8 x
( T7 [1 A( I* d: X5 t1 \+ y
function PostListener (){
/ U; W+ b% u8 Z: A//Add more post variables if needed and add them to initform() function aswell! Y: [6 Z; W4 f4 C- }! ^% [( u
0 v9 r; S f9 {" J
################################
7 o1 p7 m$ q' w4 t! W) R( F+ e##### Connection and Post ######+ ~' j& t: x( H1 I2 `4 J& ^
################################) r$ m& w8 \- |
$name = @$_POST['char'];
# t3 s3 W: K1 k x5 A' v' ~2 x/ E$ItemName = @$_POST['item_name'];! P/ x/ G6 o- F
$ItemAmount = @$_POST['item_amount'];
! _7 H8 {4 c% O1 x! ^& M$ItemId = @$_POST['item_id'];
6 r0 z" e+ E" q8 x$ L! r$ItemUpgrade = @$_POST['item_upgrade'];
& H/ n* {& B8 i( K# `$ItemElement = @$_POST['item_element']; ^; q3 b: ~: _* s& e! ?
$ElementUpgrade = @$_POST['element_upgrade'];
/ f* \3 d% v' E7 n$ItemPierce = @$_POST['item_pierce'];
2 ?+ V5 @, m" H8 E################################
0 o; |0 x4 ~/ f+ P. V. e( b) j; X. f+ E( E0 P* H+ y
//Check both variables for empty value: i- V$ c, U) u! ~( D% Z5 W
- ^' R% W7 a- [/ bif (!empty($_POST['char'])){ H8 B6 `( f7 o* [" B. ^, [- o) a9 K
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
7 V/ z6 I8 [$ e; b, N
. M, M5 q1 @+ A( u( [( y, w2 vm_szName = '{$name}'");
& R4 q# ]2 \: E/ @$ L/ Kwhile ($row = mssql_fetch_object($find)){
g& m7 l, N! c7 g Yecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
! s. {+ g& [: j+ u% V8 t+ W5 w$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], - G' A: c9 P+ ^' k! U$ D6 h' K
& _2 f" \' c# A; t9 c[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], : K+ h3 c1 S5 F8 {* l& ^! {
! q& V1 O5 A/ p* p
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 4 {: T& W1 C* m1 }7 D, ?& i
& ]5 V! W; n. Z0 ?" ` ?5 e7 E
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
& z4 [1 O$ F& Z+ h0 G y( y5 E
7 b6 v3 k+ V) K'{$ElementUpgrade}', '{$ItemPierce}');");8 J# }( m9 Z) J) w
}
+ Y% a; e3 N0 ]: u5 p3 f' f
; Z3 t7 A( `( g4 k+ N K" D* P6 X7 a}
, y5 y2 _2 g! Z! P2 O! A" z E8 z
}
* A2 Q* u' ~4 c/ v _6 h0 R0 _4 h. i' J# ?% v- Y
$InitForm = InitForm();5 ^/ @! m; K; @0 }# E3 h. t4 C) ?
$Listener = PostListener();* b B2 b' f$ H) H7 X7 q% e
4 M& ?$ E) w" ?! T7 A1 w
?>
9 V* g' S" V- p7 c" v1 Q2 L4 g$ a2 O
8 d5 ~) o0 |3 C4 O6 _
) B; J2 E6 a$ |* U7 _4 l5 _* O
' [( [ j9 D. o) c% ~( Z; J1 N8 M1 j |
|