|
|
<?php
7 h# o1 f! k3 r0 R2 Jfunction Connect () {. i/ t( [1 ]8 n/ g
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB 3 H. e5 G2 \6 g3 F. n6 u
3 I2 \% p2 d, A+ s( O. v6 Z+ uFailed.');
% F: y* ?- i1 u9 E; B}( I8 }7 x. [" v0 ~+ A( c$ \$ `
Connect();
& @$ ^3 C: { [0 @, Q) j3 t0 `% c. A
function InitForm(){
- m0 }& f: _ R' h/ ^//layout for the form
, I* E" A+ R5 [* h4 N7 R. jecho "<strong>Send Items.</strong>
4 k% h. T; `+ V& I8 v8 p) f- G<form name='select' method='post'>& T" C+ g' H( H' o* H! p) w
<lable>Character Name</lable><br/>
% J4 c# h/ c+ H' _! m7 ]<input type='text' name='char'/><br/>
; d$ X' j- R# D; v# H3 ~8 l<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>3 f) c. |$ {* X, Y! s. D* W
<input type='text' name='item_name'/><br/>
- P: f$ g2 ?: o5 a" j+ |& `7 k: Z<lable>Item Amount</lable><br/>, v4 b9 m" Y( Q# U& r* A$ i9 f
<input type='text' name='item_amount'/><br/>
, t% K, \5 }6 m/ y6 j( h% D, v<lable>Item Upgrade Amount</lable><br/>
' }1 {. d1 H' ], l' g4 v) a<input type='text' name='item_upgrade'/><br/>
" @) B1 e. Q+ p: U4 J, M<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)0 I: @% J- G: O6 Z
0 ?. ^5 v1 c# v. H</lable><br/>
$ W! ^6 E9 E8 u2 E- f( k' T) _<input type='text' name='item_element'/><br/>$ h* A) Z( d! l
<lable>Element Upgrade Amount</lable><br/>
% a& Z" z( i# a, v" D9 [<input type='text' name='element_upgrade'/><br/>' g; l4 D- h* F, Y- C2 s0 c! X
<lable>Pierced Amount</lable><br/>
& r; I% Z- _0 R [% D+ d<input type='text' name='item_pierce'/><br/>( @7 }8 ]4 a& O
<input type='submit'/>
$ `# h6 N+ N% @* o</form>";7 d" }( n ^7 ^) h# z
}& O5 k% h5 u( {; u( N
# t2 D0 h6 }. \) n; ?0 a4 m7 kfunction PostListener (){% A) \/ E1 c( r; U( D5 M
//Add more post variables if needed and add them to initform() function aswell* x& Q7 Q' J- R' o* o
/ W, b$ B' T, C: k. l################################
- B/ t" Q _% m% s##### Connection and Post ######& M+ h8 y. ~6 h4 F4 m/ z
################################- R: S8 I: n7 A- ?7 C2 u
$name = @$_POST['char'];
" R+ ]/ B- V K9 g. W+ F9 K$ItemName = @$_POST['item_name'];5 u+ ^5 k' M. \7 }
$ItemAmount = @$_POST['item_amount'];2 e: N1 g" g( K) Q; {
$ItemId = @$_POST['item_id'];1 ?2 |3 D: P* D' J
$ItemUpgrade = @$_POST['item_upgrade'];# s. w; u9 n# {. M; c
$ItemElement = @$_POST['item_element'];% }/ u# W$ E& n1 v& \5 e
$ElementUpgrade = @$_POST['element_upgrade'];
; V% a |) g, V% q9 O) n$ItemPierce = @$_POST['item_pierce'];5 n' g1 t+ j2 j+ \, r, D9 X# Z
################################
( e5 z& j# n! B( D7 ~! S# @- d& a4 d' i
//Check both variables for empty value/ e. N* z1 O. K; X8 W
E$ P5 _) Z! h4 d; }if (!empty($_POST['char'])){
" x9 A+ y* E- `, ^$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where * g* }3 P: @5 n1 l7 G
& Z" e A6 R- @& X0 G: R9 ?, b
m_szName = '{$name}'");! V. ]/ a% ]+ j/ l7 S4 H
while ($row = mssql_fetch_object($find)){
2 P/ T: z6 P5 I/ jecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
; h2 d3 _/ S% k, h8 _8 R" L, W) l$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 9 T; L1 J+ B" G: p3 n, a2 u: Y
- g7 t `. h$ K; A+ y: F$ T[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], . Y: ]4 J( R8 f5 a
+ f: R( `6 `# }& Y! ^6 s1 i; m( R5 _ k
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
5 G% ?. u. x# O8 j3 d7 p4 ^. _+ b2 E& P C* Z; E9 n
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
! V3 o1 F- z2 s8 G1 Y }7 v
6 z5 P$ ^# S* x; y% l! y, i' G2 c'{$ElementUpgrade}', '{$ItemPierce}');");
E' M0 J5 {5 K( r; f! E' @1 H4 k}0 l" `* k! Z( W% b
8 b; @1 o( I5 k8 }}
, m" ~1 i# O. u. J9 y; G' W
$ l4 t- X8 p. Z+ h! J- {}
( ]! {: d2 }/ K0 o1 X% `
8 Y' h g$ o! H' @! @" j1 V8 `8 s% `$InitForm = InitForm();
- v% O2 G3 ^8 v- d+ B, T$Listener = PostListener();
& h& [$ T+ E6 u) a5 w: H5 s- g9 h3 O( t/ p
?>
0 n M% ~' P; Y$ D9 |8 e3 x3 C5 e# Z1 T% m8 s* g0 W2 W. x
' Z. G9 ]8 }( [/ @; b ~
4 z8 w+ N5 `, P, o
" P, T6 ?9 g8 k5 D |
|