|
|
<?php
# t" D d$ b- y$ W, Rfunction Connect () {
9 P+ G9 e9 f, f) pmssql_connect('Server','UserName','Password') or die('Error: Connection to DB & e i' ~$ Z+ h5 U: s) T8 E
, f9 }: k; J8 g4 T" U: }Failed.');2 w$ u) {8 Q& l! N
}
# B8 \4 z. Q5 o+ s4 O& [* \Connect();
$ h0 g% f. }4 P$ R6 ~9 E* H2 E/ q. M! b R c! ~
function InitForm(){
3 y- ]5 H7 M& U4 P- C- J z* G//layout for the form, g# Z, h4 ?! f! _' S7 z
echo "<strong>Send Items.</strong>; u% l: k) B& x, N1 R& _7 f
<form name='select' method='post'>! H5 q Q0 z( X, ]# k7 x+ a- G
<lable>Character Name</lable><br/>) l1 W) B5 A: v' A0 i
<input type='text' name='char'/><br/>. ~& j, l6 }( Q3 A
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
( @& X: L3 J; _0 v5 V1 l, S<input type='text' name='item_name'/><br/>; |" d: W$ `1 [0 q2 E
<lable>Item Amount</lable><br/>; M. A( y* m# t d* s# ?. l# }0 {4 X
<input type='text' name='item_amount'/><br/>
m& T# a6 t( g4 c- F2 y<lable>Item Upgrade Amount</lable><br/>
$ o" I- ~/ Q; j9 U5 l<input type='text' name='item_upgrade'/><br/>& [- g* Z6 A* K+ ^5 z
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
9 _# `+ J# {1 N9 o0 y1 z& B, C( ?+ U& j
</lable><br/>
% W4 t6 a; ~2 p<input type='text' name='item_element'/><br/>6 R1 u2 u G! R7 M9 z8 y- c9 c3 S
<lable>Element Upgrade Amount</lable><br/>) E. ?# a" ]9 V* e2 f2 V
<input type='text' name='element_upgrade'/><br/>
6 F- M- i" z0 @# f k+ q( U<lable>Pierced Amount</lable><br/>9 s' N8 M1 i/ |+ W
<input type='text' name='item_pierce'/><br/>
& C# O' u1 Q1 T5 h x<input type='submit'/>2 k' y1 ~3 N3 N1 q% B
</form>";' I& K% l; t6 ^! E0 s
}3 w8 }4 d/ Y& }3 ^- Q m6 `
) L( B) N- h) _: |* Y
function PostListener (){
4 d" P! U. T4 K/ y* K: y% R//Add more post variables if needed and add them to initform() function aswell
$ ~( G8 i5 v' W* H) o- T; Y
, j' I) Q* @2 W################################
( R3 B0 o) `. [, c# c##### Connection and Post ######6 C, I4 t4 D& b: y! ~! O* M' P4 f. @
################################' a/ p- {- N' K
$name = @$_POST['char'];
! h% v, ^" e3 ~- h* I$ S$ItemName = @$_POST['item_name'];
: U- x5 C! D& z8 y$ItemAmount = @$_POST['item_amount'];4 Z' ^3 J# r& B8 v! B- J! \
$ItemId = @$_POST['item_id'];
" |4 ]( L y4 W; S% a$ItemUpgrade = @$_POST['item_upgrade'];
, `4 c5 _7 I' t% ~* C. x' }; P/ a$ItemElement = @$_POST['item_element'];
# A9 @' H2 o& k& F. a/ b$ElementUpgrade = @$_POST['element_upgrade'];
5 s6 Q: l8 R% f) w0 r3 u9 b% G$ItemPierce = @$_POST['item_pierce'];2 e3 H- |, @5 K
################################- i1 Z/ i5 R0 J/ S; j9 e5 K
# Q' Z$ ?/ g% k3 q' m. ?( ]
//Check both variables for empty value
V1 E. P2 A# V0 ^) n) J5 [" F/ x, E- g$ W1 g; f' m5 m
if (!empty($_POST['char'])){
8 {4 z* w: [, w, T6 S$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
8 q7 S5 e8 _: Z L0 a! S6 E. t0 x4 \8 l; K- R
m_szName = '{$name}'");+ I) z: @% ?# J {, \- I0 ?+ A
while ($row = mssql_fetch_object($find)){9 q* Y( G1 m6 I6 ~: H, @( q
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
" e% L; Q$ R* Z$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
6 V2 U9 E7 P' _% T. X! t. c$ [2 Q7 ~# P2 N
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
7 O( }4 P8 b5 A9 i; ]* \1 i( N
" B+ p5 K) I/ O: P* i[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
! ?" B8 r3 q; M6 o3 h# I; u' H' z8 L/ t/ K$ t8 _
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
2 n9 }* I( b2 a0 X3 x9 P4 B: Y. ^$ {" o& K9 G" @
'{$ElementUpgrade}', '{$ItemPierce}');");
! l/ U* ?9 J9 G6 c0 S9 _}
; s$ M% R* Z; R$ o% q; e: l
- @5 M+ o5 B8 `}' C) Q* F, E, N
# S" I7 M3 Z3 n& b# ?2 b4 }
}% f- b3 Q! p4 `! s1 K' a( F5 s6 N
* h9 E: E! g: M( F+ S- h: ?
$InitForm = InitForm();
1 a* C' p* d8 P- g P$Listener = PostListener();! L$ ]" p9 V1 M( X& e& D6 n: a
5 o0 ]; r$ E- t( i& f$ |
?>3 d1 x( z: M0 \, k
# W! x$ o6 n: h1 O1 J+ s) A6 ?( k. h9 D% s* R2 [5 t
3 a, w. }; T" g
! v9 u. A' h; q" n |
|