|
|
<?php2 Y ^& [5 F5 n% G* Y
function Connect () {) Y7 ~0 A; R* e6 L4 y
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
, K( j) `5 [$ |1 a n$ O& R c
( o$ h$ A- ?" O$ z+ H3 P, f( gFailed.');* `" C( X, R' q- P0 t
}7 Z6 E a4 M- W: l+ W7 [; \) b5 S
Connect();
3 M9 @' I3 i& A9 c: H: u% n% u% x+ N" H/ c! o4 N7 R& J
function InitForm(){" A7 Q3 {7 D# Z8 z/ L0 m
//layout for the form
( [/ v' `/ @- ^- e- p9 R, qecho "<strong>Send Items.</strong>' c" T/ f+ n+ Z( h' U
<form name='select' method='post'>4 L }; _4 ?, t/ p, |! f: x
<lable>Character Name</lable><br/>8 e2 q) l6 ^7 r" v6 i2 @- T. Z, T
<input type='text' name='char'/><br/>" V5 W4 I1 B N4 _
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
% P" _; S6 o: v- I<input type='text' name='item_name'/><br/>
' o7 t7 A3 A9 _& _. N<lable>Item Amount</lable><br/>
: q, m& T6 N7 N0 O! w @% V7 u<input type='text' name='item_amount'/><br/>( [3 K. f5 o. {% n3 E' I( Q1 u7 c
<lable>Item Upgrade Amount</lable><br/>( j+ a) y- t w' j6 k
<input type='text' name='item_upgrade'/><br/>; ~( U7 F+ @, d$ b
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
& P( W' O& ^2 K6 ^6 e6 k; V' ^
& z5 n" @* u7 @" Z</lable><br/>! S9 i5 m/ @2 r
<input type='text' name='item_element'/><br/>3 K, G6 j/ X- y* q7 j, p8 E( Y# U
<lable>Element Upgrade Amount</lable><br/>2 i1 h2 A- Z% o' a: w; s- V
<input type='text' name='element_upgrade'/><br/>! [% K/ T- S; ~6 F
<lable>Pierced Amount</lable><br/>
- U6 v$ f+ Y* Z- u9 ~2 |<input type='text' name='item_pierce'/><br/>
|! B0 Z) V+ g m& h" n<input type='submit'/>* w9 x5 N% o8 `- k7 z) ]
</form>";- Q7 s) O- ?5 e9 D) W8 S
}* O: h# E7 u9 w2 y2 h5 R% F K
7 Y6 U3 V& @& J) ?function PostListener (){- b+ N# r, }9 T+ f4 a
//Add more post variables if needed and add them to initform() function aswell4 C) B0 G$ w4 R
/ b& }8 G* Y. w* f( O
################################
* q, ~* q8 Y+ N: D##### Connection and Post ######& y9 q& z! e7 |) m7 N
################################% I8 }5 k) e4 k! R2 ^, e K9 ^4 z4 ^
$name = @$_POST['char'];/ L9 S! w$ \3 K/ \; V6 H# s# z
$ItemName = @$_POST['item_name'];# P; t% r* b. x( r3 x6 u
$ItemAmount = @$_POST['item_amount'];
g4 j7 e+ o9 v; j, K6 Z' L$ItemId = @$_POST['item_id'];
9 ~* K/ W, G2 O2 t* t$ItemUpgrade = @$_POST['item_upgrade'];/ u7 ^+ D( F$ P5 ^1 y* S [
$ItemElement = @$_POST['item_element'];
- G$ Z9 p% G9 c7 ~ q' @) [; J" M$ElementUpgrade = @$_POST['element_upgrade'];: J/ @$ k% a% A3 S1 w4 S/ X
$ItemPierce = @$_POST['item_pierce'];
) p: L+ |* w5 @ T5 s################################$ k8 Y5 }) [1 K6 g! u* S9 ^3 W0 ~
9 [" E" E+ m" K% y: ~4 i//Check both variables for empty value6 w) b4 u! g, y# K4 `
/ @/ V ]1 ?' V6 @0 @1 L) gif (!empty($_POST['char'])){! B+ ?) Z0 g8 I) t
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
. m" H* W* l5 E) x
- E8 S- h; E) ^) K2 `* |! }; h& H& Jm_szName = '{$name}'");
9 L2 g# `% o% V( d6 a/ ^0 T9 b, Gwhile ($row = mssql_fetch_object($find)){
2 P0 u& t; U) I f7 f2 wecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";% o+ U; S3 w$ u: {' n! x! h( G
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
2 [5 d$ y- x. z: C+ m/ _( E
2 B1 G, A4 k; K[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
* C4 V0 D- { L1 ~3 e+ O7 I0 m% f z% Y( ^$ y
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 6 k* c0 |$ H- j, Q
# i& n- k2 f# y( m1 Y/ j1 f @N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 2 e. C8 S' @& o
! A; B2 H2 e, {+ u
'{$ElementUpgrade}', '{$ItemPierce}');");
8 f9 ~- T. J/ [}
: k# \& T6 c# J/ y3 ^5 W7 T1 ~" W0 H' \* m& m
}; T8 b/ _: W5 F1 x. ~' T) d
2 I8 R0 M8 E& i% \}$ G4 W" W/ u0 m7 P
8 u/ L, q8 i2 {
$InitForm = InitForm();
W. y( k4 h! z7 |- S* n( b$Listener = PostListener();4 v& f( [- | ]2 h6 P
9 j5 T0 }; x# t- |! _6 g' m?>
' {' i0 L) J9 o( ^4 @1 e# X; D/ i0 _( K
6 `8 _; d; n5 b4 E5 F+ J
5 D. P! x- @, j& i6 I
' ?1 v! i& K, A( l9 Z3 T |
|