|
|
<?php. O9 S+ f' g' E0 W( } s
function Connect () {: T9 @5 d8 V/ z5 u9 g, h
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
0 R! {& U! N0 v. A$ }2 F% u5 x) E" c
- T+ M4 q: t1 k6 MFailed.');8 \8 }9 M" N/ F
}- Q( v, g9 d8 t! o+ V& \3 L
Connect();8 N! [6 C2 S, A; g
* ?% a. x6 N' ^5 _0 v$ ^9 ifunction InitForm(){1 m+ X) @- W; M8 }; m+ r/ J
//layout for the form
' B }8 E- }- Q3 `4 m' t0 yecho "<strong>Send Items.</strong>
. Z" }- G% M6 }) B+ t0 m* ]: R<form name='select' method='post'>
6 h& V$ Y, r& o s<lable>Character Name</lable><br/>
, C4 |- i3 s Y* |3 K W<input type='text' name='char'/><br/>: G: F$ m' P4 y* [; g" I
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>6 z( W! y# _) N) ~' `" J ^) m
<input type='text' name='item_name'/><br/>
' G b$ q2 a" E; ?1 n- ~7 z* T' ]<lable>Item Amount</lable><br/>3 A5 t3 p) l- Z
<input type='text' name='item_amount'/><br/>5 P; O# B1 z# @) z
<lable>Item Upgrade Amount</lable><br/>+ F% s5 T* e2 x/ H7 R
<input type='text' name='item_upgrade'/><br/>, K& h+ F7 E; `) \% o
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)6 R" D8 [8 v' L! U
" P) F9 l" {$ T" ]% A+ _7 B</lable><br/>$ Q# B) u' d- f
<input type='text' name='item_element'/><br/>& J+ Q0 p7 ^, C; \0 ? s6 r; P, O6 D
<lable>Element Upgrade Amount</lable><br/>2 P3 p" s: s) D: w* C, O
<input type='text' name='element_upgrade'/><br/>
% }! d& b3 [* O. E! |<lable>Pierced Amount</lable><br/>1 q8 t1 ?; P1 W$ S y; z, q
<input type='text' name='item_pierce'/><br/>
2 r6 P _; Q, V. f<input type='submit'/>* K' d2 C, t% E% j
</form>";8 i |9 ?; O% d* j0 i# g
}
7 M ?$ I4 J0 H3 e) \9 S0 k. Q
0 F6 H6 b2 I, C. M) I3 }4 i' @# ?function PostListener (){
" r- }/ f3 U! U- S//Add more post variables if needed and add them to initform() function aswell" J! @. p, @3 a$ A( f9 `
' b2 u) S+ s; j! Z% F
################################( f4 K9 C# W- E. u6 n' n
##### Connection and Post ######9 C; |8 E- C- R
################################
# V& y. V' D- H: M$name = @$_POST['char'];
! e8 u5 N# {0 e1 L% e3 j' j$ItemName = @$_POST['item_name'];5 z1 v; q/ b) p6 z4 @; {
$ItemAmount = @$_POST['item_amount'];4 g' H* \" M$ _6 D7 E
$ItemId = @$_POST['item_id'];
. h( z, b: [0 b: ]4 L+ X% m3 }& ?$ItemUpgrade = @$_POST['item_upgrade'];0 E6 D! h* J" W6 C
$ItemElement = @$_POST['item_element'];
3 x e+ A0 t& S. Q$ElementUpgrade = @$_POST['element_upgrade'];
3 {& U# R6 y! S$ItemPierce = @$_POST['item_pierce'];9 I+ Y( e5 b+ w1 s1 B; s/ ~8 b' j+ w
################################' B; w7 v& S( p# k R% s. C2 D2 T9 t. Y
0 \# W! Y8 l+ m) }$ H* U//Check both variables for empty value8 W+ {& |. i3 S9 b; F% S
: m3 p# d9 j. [4 m( `; L0 ?: J: nif (!empty($_POST['char'])){
# W7 h. w4 W, @' d" ]( U& b! R) k$ B$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where 1 P2 d- p) y: I4 b8 t5 A$ X! ^% T
* [1 y6 A0 U: k, R8 c: U0 vm_szName = '{$name}'");
5 B' Q* O, @ b' Swhile ($row = mssql_fetch_object($find)){
8 N) j* r% k! y- gecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
" b; k5 E. D7 w$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
" d7 z% y+ ?/ g# n4 c! S' ^: [, {+ f& j/ g
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
6 B/ {) A. q M( F, F0 }+ A4 O
3 a/ O6 Z$ k% ]) e" M. M[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
9 \- q" [; x8 n& g! u7 @+ y0 @
: q! P7 F+ g3 AN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
* P' p: t- s% M4 f4 G: d9 Z8 k
0 X, i: Q: F y# J E7 p'{$ElementUpgrade}', '{$ItemPierce}');");
' W9 h1 H) b' p: `8 t0 p}
2 y) `; l5 D6 V% j L
% w& K' f+ o% X' {9 }" ~; F. p}
8 {. b3 Y! o, y5 g% a: x% t y0 \+ S, K p1 Q1 F4 k& S) B' J* ~
}
0 Q6 Q3 Z0 g& |( e7 Z7 J
4 @7 H9 [0 {4 J/ b1 Y$InitForm = InitForm();
2 c5 k' K$ M o! s! \8 B$Listener = PostListener();* i* c8 z; H5 N# i7 N
I$ E, }; G+ f/ |+ U' I) _
?>
5 N9 B: z6 T) |2 W6 c) b$ C1 Z; _
$ l: x$ R: h- W1 M
. b+ ]0 `( V2 o, F2 a
9 q Z+ Z$ n* _. t( T# j3 P9 o7 L, ^, c) g4 w6 u2 @! |- b
|
|