|
|
<?php, W& X7 Q" E: A) h/ S% `
function Connect () {9 F" D- [* w8 \, g* A# B9 k
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB 9 }5 g+ e- h5 Y. P8 Q
1 i" }4 C, p# _* G! p" f
Failed.');
) N( V( @0 O" f( [6 M( k% K+ P) C}( l1 I2 M* n) a) m) I8 J. Y3 x
Connect();
0 A1 H7 g4 f) {' |( Q$ e1 u9 k9 q1 r: p) I% I6 s6 ]9 w
function InitForm(){
* X* r" @) \9 T5 [% |//layout for the form
" m7 a9 O& n3 p9 a7 u R, I. \echo "<strong>Send Items.</strong>
! b& g: p) J& w- M<form name='select' method='post'>
1 o% x$ E4 \1 l3 r<lable>Character Name</lable><br/>+ ~3 Z) k l( @2 ^+ X
<input type='text' name='char'/><br/>
* y" Y& i m% Y2 ]2 g- h: C/ S" P<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
# A- I+ ^' i& [2 }1 ?3 Y5 D/ {$ D# f<input type='text' name='item_name'/><br/>! q: B0 h# A6 x/ U; Y
<lable>Item Amount</lable><br/>
' A2 X% O$ Z$ o* U2 E# {, \<input type='text' name='item_amount'/><br/>
/ b, m) e0 k5 q8 E<lable>Item Upgrade Amount</lable><br/>& o( h7 \6 m. r! I7 C
<input type='text' name='item_upgrade'/><br/>
4 g* t2 H: ~9 g) t/ B<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)$ g; N Q- \% M5 m
* s* P( m" G! e* Z4 ~6 R
</lable><br/>
* P: X" y6 |1 Z+ t% ]1 k4 H( C<input type='text' name='item_element'/><br/>2 m# ^1 K2 x; C
<lable>Element Upgrade Amount</lable><br/>- ^7 n& `2 _1 e, i* Y6 Z9 N$ T
<input type='text' name='element_upgrade'/><br/>4 T; O. b5 b6 ~. c$ i# C3 n
<lable>Pierced Amount</lable><br/>
: z% e& q& q# J6 P7 W# U<input type='text' name='item_pierce'/><br/>
& M# F8 y% K" U( f# m* V3 y; C<input type='submit'/>
% B u- U/ q4 E9 V; B</form>";
6 ~) c0 M' q) d1 ` g}: M, f$ S- q% w) V- P, y) q
) Q& A1 |2 G- S& `$ m; [$ rfunction PostListener (){5 r- `; f" x0 U+ t/ T/ ?1 x5 V
//Add more post variables if needed and add them to initform() function aswell
! N+ ~ y6 X$ l; y5 P) P' p( c- e' M) Z U" X( m6 k
################################ R# ^ F2 Q0 c6 {, ~* p& H
##### Connection and Post ######
8 I9 X! U6 g0 Y################################
+ ^5 Y. `3 @7 [, a8 d) X2 v; A( R$name = @$_POST['char'];
1 U- r1 | l2 R T* r+ o+ F0 Y$ItemName = @$_POST['item_name'];, y( F1 H7 U; | Q: t1 l
$ItemAmount = @$_POST['item_amount'];
9 S- i( u- g- Y: g+ s! z# A$ItemId = @$_POST['item_id'];
- r6 ?9 a4 v! x$ _6 i: i4 Q$ItemUpgrade = @$_POST['item_upgrade'];
/ N' [2 E2 ?2 F' f( D7 w% f$ItemElement = @$_POST['item_element'];% x: ^) m- |& J/ ?/ e; Q P; R
$ElementUpgrade = @$_POST['element_upgrade'];/ _. }, S, ^, `1 m8 n
$ItemPierce = @$_POST['item_pierce'];1 x1 g0 i, k0 l" `: }+ }/ g
################################
4 x. \: T7 W1 G0 H9 c
( ?! r0 k- F4 h' n- w//Check both variables for empty value
1 D' x* X! e8 u
+ z- U& A' p+ O( R& X& T, A" J" rif (!empty($_POST['char'])){4 o1 T9 d9 J; P& I
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
& x' X0 S0 N* n7 f$ _' v9 f+ ~- v0 D% U6 b! T u
m_szName = '{$name}'");3 d" [2 ?: L" m3 O9 Z8 G
while ($row = mssql_fetch_object($find)){
5 }5 {3 N" Z3 e8 g1 J: N1 Oecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";5 k8 F( F* c' ?7 J3 p
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
c/ o6 J. a5 D# ?- p6 M% S8 k6 j# _3 B5 o, R/ N
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
; w( k0 A# i# i" h2 `/ ~. l* h( n/ K! [1 ~
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
, t# q; j% J* ~9 c0 X# e0 L5 ]2 Z5 t8 _: Z5 a
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', , ]! d6 |! O9 o+ v
- q) o5 ^# c: l z" K
'{$ElementUpgrade}', '{$ItemPierce}');");
8 w- V7 U5 \: e2 v, P/ d4 T' M}
2 Q5 p; ~+ g. p. t, i% C$ U
- S: I$ p; {/ N+ |4 E0 B}! s5 _, L7 P- H8 Q
( b& s' j4 w" R( Z" _
}! s! X2 A& o& e% @) g
4 b$ n7 e% ` H9 z- H" N/ H. B$ M/ C$InitForm = InitForm(); F9 g1 ^8 d9 \! u5 b; \6 H# h
$Listener = PostListener();# x8 p# ~$ e' B5 q2 T% O
8 b6 Y2 C; u5 a7 \- z W- \% s
?>1 O3 Z, F/ y9 I$ _6 _- y
0 R6 P- X' v; q
) l4 s& Z3 R2 N3 |5 y6 O$ ]1 n3 ~
h5 l& |; M* W& u- W! K
3 q# ~- k# `7 J0 q- h/ b8 M" u/ p4 ]7 E |
|