|
|
<?php2 F$ X& G$ \6 W. R" F
function Connect () {; l- W- y4 M% E- J2 R0 g: L9 ?9 d" `
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB $ }1 S0 j: \) u) R; Y# k
- y% k: B# h. {+ v5 Y7 L1 tFailed.');/ l; y5 ^5 g( Q
}
* v/ Y+ u; `- T0 ~7 Z+ NConnect();
8 x, C* B! U+ R- N* z, p
. _) V) ]! n! W; }function InitForm(){( m; N9 C/ C! E: m# A, x0 O# x
//layout for the form
# m$ J# Y1 `+ W4 techo "<strong>Send Items.</strong>! x* ~6 T" B! O% l6 X9 d( L
<form name='select' method='post'>
! J) `: R3 ?5 G! |! i6 _<lable>Character Name</lable><br/>
, V; {+ u! x9 E<input type='text' name='char'/><br/>7 M1 Z, `- Z; D% j
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
, \* c g, M- v* B% {) v<input type='text' name='item_name'/><br/>% @! ^6 m* ~9 t& \3 G7 y P, [
<lable>Item Amount</lable><br/>7 f8 ~, h) D) I* u6 @* ?; ?
<input type='text' name='item_amount'/><br/>
3 k5 z1 ?0 n8 ~7 q3 L0 \<lable>Item Upgrade Amount</lable><br/>3 Q9 t2 ?. g; C$ X1 R4 L6 I
<input type='text' name='item_upgrade'/><br/>
/ K* r" v1 p" P+ P<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
4 q! V5 W( j8 c& u# `
; V3 o) }6 R; Q/ H+ A</lable><br/>
* z/ I4 O7 F* x7 L9 a2 _$ X. H' O<input type='text' name='item_element'/><br/>9 c+ _7 S" S: p0 h9 u- P+ J
<lable>Element Upgrade Amount</lable><br/>
$ o) x; B5 v" }2 Q6 t0 _<input type='text' name='element_upgrade'/><br/>4 f. y& b% q$ \: K
<lable>Pierced Amount</lable><br/>: E% y9 b/ x B, K
<input type='text' name='item_pierce'/><br/>
4 m) |* _5 R P U' O+ Q% o, i<input type='submit'/>' F0 a- o7 i* O. c! Y
</form>";$ I* X$ I" y% L% ]; |6 B2 \
}
, r' I) Q8 p, c- L
9 ^& Q$ M: F. ~# Z, j8 ffunction PostListener (){
& d D8 ]3 F) ?//Add more post variables if needed and add them to initform() function aswell3 W, [5 U* r) R- [' c$ M U
. e) y: b" y1 l+ m
################################
# L% ^8 c, ^- v: N1 |0 Q0 M##### Connection and Post ######
3 v" i* r/ s2 f6 F################################' p Y$ M9 x. C/ ~: ?
$name = @$_POST['char'];; w( {2 j3 {% ]5 k9 Y& Y
$ItemName = @$_POST['item_name'];" e, {4 c* i* J; {: g) {0 R8 W$ x# f
$ItemAmount = @$_POST['item_amount'];
0 ?2 { n) w' C8 q$ItemId = @$_POST['item_id'];
7 S4 g& ^: L. R- V" |$ItemUpgrade = @$_POST['item_upgrade'];9 O2 O6 W0 S; m6 g
$ItemElement = @$_POST['item_element'];8 P2 }: i9 A" r6 I. A
$ElementUpgrade = @$_POST['element_upgrade'];/ ~1 P( j( O2 z; W
$ItemPierce = @$_POST['item_pierce'];) l; T$ f$ E% X) d/ d5 |
################################
X2 M- @: w* W- E* \# k9 {: T2 |7 k; G) n
//Check both variables for empty value
( o$ p% {. i8 ~7 M
/ b/ q) s0 e8 ^! l6 I4 w* ]1 e1 \3 Bif (!empty($_POST['char'])){& X( `4 V9 _2 G6 s5 C; p% o% _
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
! f. {( u8 B( Z3 V Z
2 W+ a# v! I0 P. t9 ~+ i- Qm_szName = '{$name}'");
0 [6 p+ G5 u# A+ b3 Y4 W! m4 uwhile ($row = mssql_fetch_object($find)){
: t0 ~ t1 R" c7 g1 ^3 Mecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
) @3 ~# A I! P) t+ E! o# n$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
- q. y' c$ m# g; O9 n4 Q+ @8 |* g8 M( ?2 H* h& B9 y) p- H
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
. o& T5 B) e4 s0 D/ B
. @! z; j* U+ L( z L5 y[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', % _' q7 \, p9 [% [, a! Z
, C e$ X5 q4 x- c* \5 IN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
$ f3 O. u0 B3 G' k0 C; x
7 |. _2 d9 u5 X$ o* ^6 w+ _'{$ElementUpgrade}', '{$ItemPierce}');");
* S) h9 `6 m! y$ Q o} D- ^# B' A' a4 M8 y! r
( I: K' |: C5 A( O}6 } Y2 I" q9 q- t$ ^. s; \
# D! [8 _, p& e5 ~}. f* G3 f2 i$ o) E( h
, L' Y% ?- e7 K: R$InitForm = InitForm();7 o$ z. x9 `4 ?: u) L
$Listener = PostListener();4 _3 l/ X0 m% `7 E& \
# ~. Y) I( N6 }5 Q0 l; b4 f6 Y?>
1 `0 u2 Z$ I' F0 i
* V3 Q- s% y+ R$ R; _ A o: }' R3 T, l) n$ X- a- J% L
- Y4 x F0 k! {# D
* R6 V8 h" b, E |
|