|
|
<?php' b( r% d: N, ?$ P* D
function Connect () {
8 q, I/ d; c3 V, i$ s6 Q5 Emssql_connect('Server','UserName','Password') or die('Error: Connection to DB
: G- j. ~. z* n( D. H. U! d, Q
3 k! J5 C( u/ B- xFailed.');2 Z" O4 g5 ~% U5 {5 O
}' f7 \. U% Y; S) R# ?7 v. J) |4 S5 v
Connect();
' D- L" K" t) ^' k% i* w+ v9 }. R+ l) J4 u
function InitForm(){
: b: s; U6 ]4 q- m* L; v I3 [2 `//layout for the form
& L, x9 `0 B0 |1 uecho "<strong>Send Items.</strong>/ f7 w1 M7 }; {* x' V
<form name='select' method='post'>
& ?# q6 i/ R: P# B$ w9 X& f<lable>Character Name</lable><br/>
" P( T7 ~% b$ n<input type='text' name='char'/><br/>
0 [( c0 K: K( o( F- u<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>3 g5 c' A& Y1 j$ e3 O8 p
<input type='text' name='item_name'/><br/> z; P5 D3 E5 ?5 }3 d
<lable>Item Amount</lable><br/>
3 \2 v7 ]; k! h% D0 [/ Z" X<input type='text' name='item_amount'/><br/>: Q2 i) X# u' E% f
<lable>Item Upgrade Amount</lable><br/>+ W$ a" p: Q: W; F' {
<input type='text' name='item_upgrade'/><br/>
) j$ C: ~: i3 T: i; U( |" ?<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.). J0 V' R$ v1 I
9 Q; \$ d1 Z+ E# ?$ ~
</lable><br/>
5 u: r4 {; k3 u7 U<input type='text' name='item_element'/><br/>
4 N- T) s( e; g- P<lable>Element Upgrade Amount</lable><br/>
& c4 d: V0 q+ v6 N V! [, @5 Y<input type='text' name='element_upgrade'/><br/>
. L* g9 J& A8 t h, @% O<lable>Pierced Amount</lable><br/>
. W; ^4 E3 I1 T5 D6 B- ]<input type='text' name='item_pierce'/><br/>
) I/ h$ I/ O- t8 x7 ^+ Y9 B9 X<input type='submit'/>
/ R7 X* p; \7 e& W( L9 T7 ^</form>";( G5 S9 x0 M/ j# \9 U
}" L- _6 c; ~# Z
8 o$ m# E! [! w; gfunction PostListener (){
4 i$ v& U+ M$ f0 f- F* z! z//Add more post variables if needed and add them to initform() function aswell1 Z$ d( q5 c* G0 m5 Z, [0 U
0 c! j( D6 o1 M- N, t
################################4 r! ]% N2 |; X
##### Connection and Post ######* M! E) N# c9 P9 H# c; e9 @( z' n
################################5 w! N+ ]0 o" X; u( o
$name = @$_POST['char'];. m% q; G ^% m% v6 ?3 ]
$ItemName = @$_POST['item_name'];
& I/ x Q6 ?" n# j, B$ItemAmount = @$_POST['item_amount'];2 y% ?5 q6 Z+ R9 _6 S( T
$ItemId = @$_POST['item_id'];
8 |4 O- o$ C# U, L- y9 N6 [$ItemUpgrade = @$_POST['item_upgrade'];/ [2 i* I4 l2 l) y# |6 ^. `6 m
$ItemElement = @$_POST['item_element'];3 v: h+ Z: P+ \' b- K. Q- I8 A& z
$ElementUpgrade = @$_POST['element_upgrade'];, L* d$ w" z% L& x" s8 G
$ItemPierce = @$_POST['item_pierce'];
1 A$ w: n8 D- `3 m: c2 L################################5 l8 _9 u1 ~" T, B! x. Z" Q
: g& z; N3 O8 U# Z! A- L
//Check both variables for empty value) ~+ w9 x1 @2 v) F% y$ o% q
& `0 W) k: O6 j) \# Dif (!empty($_POST['char'])){" x- b2 D) k4 i& r, L
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where 0 V4 S6 H( r0 [5 [+ z. J! |
8 u% O: ]& P: V+ Ym_szName = '{$name}'");" X q- F0 H" J, S2 U1 J0 q
while ($row = mssql_fetch_object($find)){
' J" v7 I' Q& o, e+ f5 E& Recho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";! n. f4 P7 e5 y+ \/ P3 V
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], ! u% ~; T; ` V* Q+ I1 d9 X5 b: t
. ]5 L. X+ c% N) L
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
7 d- @4 q! g. K; o( p. o# K$ D- ?! c* f! i
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 4 W" \7 g. v' z3 |* m0 S$ N
- ?0 ^' I% g2 S" h g
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
- ]( C0 S O B% \! J5 c. a7 u
0 @4 \7 R+ X, s7 c'{$ElementUpgrade}', '{$ItemPierce}');");, H( {1 \ B# C
}
' M+ ^6 r0 F3 n
" @% F: X; T) a: Y! w1 q( u9 w}, G- h6 u$ b# t' B& e1 I; K
! T. G1 J$ U; {! f2 l( p
}* k' ?" C( B* t, C
0 A/ N! R. w7 s5 C* F
$InitForm = InitForm();
?0 ?9 k5 S6 O! u9 s6 s3 Z$Listener = PostListener();
% s( ^" ^* r3 H
3 O: O! [8 b- r# ~6 Z9 e8 Y?>4 V0 A, v5 g- i' }* I7 o
- N6 ~1 B/ K3 U
" k/ A# \4 s- Q# [
. A6 I1 C0 P# R* |3 g& w' |. n' q0 B* q
|
|