|
|
<?php
8 Y7 |& Z, Z9 I6 {function Connect () {
2 }7 C c9 a c8 h. O* h; Umssql_connect('Server','UserName','Password') or die('Error: Connection to DB 7 J1 p& T8 ]9 c+ Z
0 X/ C1 c7 N$ G7 a7 h: k3 b
Failed.');3 d9 A% e' @2 ]1 B+ a
}8 v" h; X; ~$ E/ L
Connect();
) H' m' X9 Y3 G" i6 p9 |) B9 C: H4 C
9 M5 }3 A0 C/ [. k5 I% T1 z: F5 \function InitForm(){+ F# V# c2 M# g" J, u
//layout for the form
$ |$ s. Z6 \7 A U5 Xecho "<strong>Send Items.</strong>! t4 W; C8 ?6 F: b |" s. f- Y1 _
<form name='select' method='post'>- ?9 t3 O5 N2 ]0 ]
<lable>Character Name</lable><br/>
! F3 m4 E2 a# c* J- s<input type='text' name='char'/><br/>, q$ Y& s) T, q$ n/ D
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>. g! Y' i" m! {% D1 i: M5 _
<input type='text' name='item_name'/><br/>
: S. n$ c! S \3 l+ T<lable>Item Amount</lable><br/>& p- B9 O9 P5 D0 `7 L. z8 I9 L
<input type='text' name='item_amount'/><br/>8 D: X/ k+ l( q2 G4 T& z" X! R
<lable>Item Upgrade Amount</lable><br/>
& M- o$ k0 P- D0 V<input type='text' name='item_upgrade'/><br/>/ i$ }7 x4 g5 E" F
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)# o1 G2 d, P# b f# Y
5 a" j7 |, g' _1 [3 a
</lable><br/>
* X$ O2 A! B/ F: k6 A }$ D<input type='text' name='item_element'/><br/>
6 l' ^, y6 H8 n' q3 v4 [2 H<lable>Element Upgrade Amount</lable><br/>
& ~* e G4 B0 ?, v* l) z<input type='text' name='element_upgrade'/><br/>
: a( j" k6 a; I6 n3 @$ I<lable>Pierced Amount</lable><br/>
. a, L$ d: H6 p, b( `* m/ b p<input type='text' name='item_pierce'/><br/>$ c0 u5 z3 ?9 n5 y
<input type='submit'/>
' |" W% M* T7 r( U" F8 Y</form>";! i% b. O2 J' Q9 M& F" [/ E( C
}
; m1 V0 t' Z# a7 ^: d7 `$ H8 H2 l% s& G
function PostListener (){. G9 }9 C1 ~9 K! R Q
//Add more post variables if needed and add them to initform() function aswell+ G6 k5 E/ x/ }9 b% R7 f9 s6 W1 k
& t Z3 Q% R- J- C- F
################################
0 X+ q+ ~2 X8 H+ S##### Connection and Post ######, I, B) m* I: z S# R+ f, p3 |# x
################################4 \" t# |' N/ y& P. n' i
$name = @$_POST['char'];
) U3 S8 J7 @. `5 ]! N; J v, G. ]! q& f$ItemName = @$_POST['item_name'];
' p5 u; }# g- K) O" L5 K$ItemAmount = @$_POST['item_amount'];
0 u% W" m/ Z ?5 W. a$ x7 J1 |$ i. Z1 o$ItemId = @$_POST['item_id'];" \, a' C* o) R. K$ a" ?1 x
$ItemUpgrade = @$_POST['item_upgrade'];, U# k: `! s0 {% Q
$ItemElement = @$_POST['item_element'];
+ s1 h" c( ~: B7 V' F+ U9 v# `$ElementUpgrade = @$_POST['element_upgrade'];' E( s, m4 A* ]' K0 Y: h8 z' i
$ItemPierce = @$_POST['item_pierce'];
! c" B4 g- F1 J# a8 E! g################################
5 I, i- m- `+ ]3 d+ v( k2 q# L5 J1 f( ?7 g F, ]1 s+ F
//Check both variables for empty value/ G) a. c: p# [4 ^
5 p- M: g( A/ W& E1 Xif (!empty($_POST['char'])){
1 z3 ?& P; \6 {: L$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
+ M: T; A8 Y2 k, N6 U1 p8 w+ j8 q' l' z- Y6 l" R
m_szName = '{$name}'");7 L5 o5 w7 P; @) n5 N$ Q- B) [
while ($row = mssql_fetch_object($find)){
8 t6 N) g8 k( v6 j( D1 D1 A/ |echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";' Z; e0 L2 `- |. f; R
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
9 N" u2 ?1 A! q% U" L
: R7 V; }2 {% y% ~1 _) h[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], , U+ w6 v) S! }2 B$ K$ _6 k
" E& h( o" n' e4 A7 C% {7 W[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
6 M3 r# S9 v: J* N. ?( a9 J( U
; z) E; B! f/ W& T( \N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
3 o5 J' i7 V4 r7 f' x$ `
7 i7 ?9 y* z/ V9 }'{$ElementUpgrade}', '{$ItemPierce}');");
! s: p: A8 X9 ]! G" x% g' q6 J( i}* D* }# K6 d# X' l G
, h* l5 J% t4 O' ]( k! Q0 x
}
, E/ Y7 ~7 M) f. V9 Q% ?+ I( k
2 [4 p2 \6 o- O2 ]: v}: E. w6 a G7 y
2 H1 f5 \, U( {" H' @, x2 X+ B
$InitForm = InitForm();
, ?$ ]( i. X* s: H# C0 D& M3 n; S$Listener = PostListener();
9 V, K U3 h( @, V
6 T7 h. d( _1 C! S0 ]?>0 R, Z; w; j! i! b8 ~
% X- ~$ ]2 r- `" G1 y4 a0 D6 i% U& G9 Y
: ^9 `& _! Y& f) x( @8 s0 ?3 D
: Q' |7 b( e' x6 ]/ X8 Y |
|