|
|
<?php
/ O- J( ^, m0 O& x) Ffunction Connect () {# Y* ^1 p& ]6 W
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
7 S0 Z' B' G3 n
0 s- x+ f8 f" A/ LFailed.');
7 ~" s. v5 k0 w4 N R) s I}
! ?, e6 l0 H; |$ @2 eConnect();
7 f+ a# r. d) p' n, P+ z. s3 Y+ D0 f; r
function InitForm(){, ?( W& P0 h9 p. F2 s* M
//layout for the form1 N8 q( f" ~7 k" O
echo "<strong>Send Items.</strong>
5 q1 C/ V# D) o9 m5 s, T( j9 t* @<form name='select' method='post'>
0 ^8 I4 c6 G0 d8 e4 D1 A<lable>Character Name</lable><br/>
1 L- \/ \) l/ Q- k<input type='text' name='char'/><br/>
% o0 A( S L. I; l<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>" M1 k; o% v2 V( c2 Y1 z* U7 l
<input type='text' name='item_name'/><br/>$ j5 {8 M* i6 x' C
<lable>Item Amount</lable><br/>! k* M3 K2 ~; W: }- |& V7 B
<input type='text' name='item_amount'/><br/>
3 M# J6 }9 o7 j6 C. s<lable>Item Upgrade Amount</lable><br/>9 R+ _; t, Q3 f4 w7 W8 \
<input type='text' name='item_upgrade'/><br/>
) e# q4 E$ F1 g" v" v<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)7 ~$ O; }! s5 d: \2 o
" ?! i. I( }; _9 P</lable><br/>1 y" E2 I- K o, x
<input type='text' name='item_element'/><br/>
9 c. m# c2 C8 J<lable>Element Upgrade Amount</lable><br/>1 F4 u7 x* T8 o
<input type='text' name='element_upgrade'/><br/>
& [& X5 P0 P& z9 n0 I. \<lable>Pierced Amount</lable><br/>
4 e5 M8 ]9 o& M8 X2 c! ?" r<input type='text' name='item_pierce'/><br/>+ o" w8 }) m, v) k" `/ V( C
<input type='submit'/>9 x0 `$ k a" |% x9 }, _. o
</form>";
. E) y6 q- D' Y0 `, R, r& S}
4 @( X1 z" @! F$ g. x/ S, I4 T/ L! M" ^9 r* m0 Y
function PostListener (){
2 d0 {% V+ E% u//Add more post variables if needed and add them to initform() function aswell
/ B4 k9 G2 t. `8 t2 J) k9 f0 i, @2 {% `* l0 k! ~" j4 C
################################* z$ `* \& I! m0 _: z+ d& b
##### Connection and Post ######* t3 Z6 L* j% ~1 H7 W" N+ A% {
################################ a; q0 X: ?5 i/ C* ^
$name = @$_POST['char'];) I4 ]! b) Z3 D, h0 [& s8 m; r4 U. n
$ItemName = @$_POST['item_name'];
+ {3 h) ]8 v" o2 }6 U- Z/ u$ItemAmount = @$_POST['item_amount'];3 U0 P5 i- v1 q0 ^& X
$ItemId = @$_POST['item_id'];6 O# t' e) F: Q0 p$ h3 M
$ItemUpgrade = @$_POST['item_upgrade']; p) g5 M1 [% L* ~& W& Q( a2 x
$ItemElement = @$_POST['item_element'];! H% B3 w& [* a
$ElementUpgrade = @$_POST['element_upgrade'];
1 \+ K: U" {1 b0 _, T& c$ItemPierce = @$_POST['item_pierce'];
! W9 q% v2 R5 }% X% ]! \$ A: o################################3 f( p5 S; A. }0 ^7 x ]
6 E+ k$ R% }+ I$ S
//Check both variables for empty value
2 A( C2 S' Y0 W+ P
# l) V' E1 V% J3 v1 ]" n Hif (!empty($_POST['char'])){
% G5 |7 F! x, |/ D7 A$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
8 ^) ^9 M" B0 z! V
! }4 b/ l6 n. [' ?m_szName = '{$name}'");
3 h% z. w9 T6 E% |8 P9 c* N+ e! C, ~while ($row = mssql_fetch_object($find)){) V x# F* T5 z% g# c
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
1 X% i: i" y( @+ P% d7 K; C6 Z$ T$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], * T7 t5 w6 k d% ]
, ?8 w, b2 Q( p4 \ C& c' m! G
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
$ s$ G! B% J1 z' T1 _3 z
& v7 v# A1 b( e" ^+ T) t3 a[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', ( l9 M, T7 P( |$ D9 u$ T4 b
( y5 q8 T% ]# G5 e( A" ^
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', # g0 ~, f7 |8 v+ X
0 F+ O' Q8 E( D% @9 r, u9 A0 K'{$ElementUpgrade}', '{$ItemPierce}');");
4 _0 l+ w0 G/ P3 D}; h" c/ O8 y5 y( K
- A1 t* X+ m& c, S$ U- l! o M% E}, i4 J7 C3 f8 K, T* c- L
0 k. m7 [7 K# m8 v) i2 @2 D( a) L
}
0 x; ~4 f% d& K; W, e
& m3 g8 j$ Y4 l# e p- ^" [$InitForm = InitForm();# R5 g8 l& R% |! I3 J: K
$Listener = PostListener();
( B- g/ s5 R& d$ o2 K/ u: D% {
?>& k" e( Y# v' J; ]! P
5 }' d" `1 H, e/ ~! B2 f5 B* `
% b! v0 E/ n' j5 S
; g. K" `- F/ ^# B7 y1 T0 }1 h1 \9 w( ]* [8 B; r- L/ F
|
|