|
|
<?php
5 t& ~ z; E7 E0 d3 Z6 Tfunction Connect () {! e6 p. K& P, y* ^+ Q- u+ E
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB 5 r: d2 R% |/ }7 Z1 ~) ?
9 U6 g( u7 C& B* u' rFailed.');
, H7 y5 K2 `8 H2 ]7 `" ?9 D% i}( A) L0 w. u7 C+ e7 a
Connect();3 m* Q: J6 [. m' F' d
5 i& P. K2 b A) b1 e! J% U, r, }: v
function InitForm(){
4 i9 w+ w5 H/ i9 M//layout for the form
! u! h7 A9 E: B3 qecho "<strong>Send Items.</strong>7 R4 B3 c+ i# e% ~( {
<form name='select' method='post'>
9 j+ l" t. z; g6 D& E- o8 A# v3 w<lable>Character Name</lable><br/>
6 J3 m" p6 ? r& t9 T<input type='text' name='char'/><br/>& D2 ~8 ]4 L# {/ H* b0 I. h* E
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
' o) |+ [/ ^5 Z; Q$ s- z<input type='text' name='item_name'/><br/>
6 [* C* Z% n8 a% h6 h( x<lable>Item Amount</lable><br/>% s/ _6 }" e) d6 C+ u% h& T7 K
<input type='text' name='item_amount'/><br/>! ^4 L2 \0 ?" h( X! r/ e) `
<lable>Item Upgrade Amount</lable><br/>
. c& y! v4 ]( |; u<input type='text' name='item_upgrade'/><br/>, `, J! `" f" H' T6 ~
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)3 k$ B* B. J% \! _/ b0 [
$ O$ R, n+ P) W+ ?6 I</lable><br/>9 ^/ j6 F% ]! {- V5 f
<input type='text' name='item_element'/><br/>
" S. F, k# f9 d' p<lable>Element Upgrade Amount</lable><br/>9 o; t1 Y) X5 n) G! t6 k$ H+ e
<input type='text' name='element_upgrade'/><br/>6 C) ^; R! n" A. j
<lable>Pierced Amount</lable><br/>" g8 Z7 W# v# N0 ?& Y* g* l# S5 A
<input type='text' name='item_pierce'/><br/>' f! z. r& L; D) z% m% Y! l
<input type='submit'/>
# k. {4 h6 i, c; d0 E</form>";
1 w5 a6 n v" s8 ]9 q9 E}
: s% o$ V# p. C9 e( E# r* }! e
: C# m1 ?. o! v2 Zfunction PostListener (){
# F! @8 R+ u+ z" a* b//Add more post variables if needed and add them to initform() function aswell
' \+ e, o# C& y! Y& r r5 C% ?) U4 e1 C; E( `) Q' N1 A2 g
################################* L9 ` ?+ Y/ p2 O- _, d: t0 J
##### Connection and Post ######
- r" g) G& I% y. O8 ~& {/ k0 v################################
& B# W) M$ _2 C/ R L U7 D$name = @$_POST['char'];
8 E1 A9 X* e4 I9 m$ItemName = @$_POST['item_name'];
+ H( Y0 j% [5 R7 q) Q$ItemAmount = @$_POST['item_amount'];
' @& D a/ t' b% `3 h; G$ItemId = @$_POST['item_id'];! ^3 t+ P2 s& D* j3 j: M Y2 R
$ItemUpgrade = @$_POST['item_upgrade'];
4 M+ C& \. x1 Y# f$ItemElement = @$_POST['item_element'];
: ^# C# V ~+ {# t! R9 _4 G4 b$ElementUpgrade = @$_POST['element_upgrade'];4 o5 I. N- p) `+ g8 d* ^
$ItemPierce = @$_POST['item_pierce'];
+ r: e K' j4 ]) f& {7 N0 o- B, t: r1 [################################
' _8 @# q9 W" }6 h) o: d; c7 w& P5 b! g- i6 r" n( {1 }0 d
//Check both variables for empty value3 \/ Q( c- U3 i4 F6 c, @8 O. P
9 C: H! [4 H- R7 {3 {
if (!empty($_POST['char'])){
% |/ @; a7 d5 N2 c$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
4 |, E8 X1 G% H l3 x+ E! M) t! L7 @. t
m_szName = '{$name}'");3 [7 y0 B& ?1 G: b/ r# E9 T
while ($row = mssql_fetch_object($find)){
/ m2 y/ c/ N j2 Qecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";9 r+ ~& _3 s2 i% ` l; Y& b: }
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
3 _) g4 ~" f( a7 f6 V: N# N4 j7 Q- q5 ] f' q: \* b
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], 1 ?% \6 T) B# e0 f$ e; ]* R
0 R8 n3 E; c B; L# D6 l[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 6 }' i# m ^. i6 k, x$ u7 K
: B7 w9 v- M: B% w0 t0 g: x0 b# WN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', * b+ L R% l( ?
0 o. V+ f0 I0 v, m9 M6 A2 r4 T% G
'{$ElementUpgrade}', '{$ItemPierce}');");% A0 L$ a1 f1 r
}
5 ?+ J% V) I$ O( N2 k( g1 i7 R* B# k1 F
}
, F5 _* k- l' u+ {7 S
1 D+ h: ?' R6 x# _& N}& q! Q8 A1 c3 v8 I5 z" y
% r! l" |* Y; ^( G& M& z) B
$InitForm = InitForm();
6 U8 L) a+ X, F0 Z$Listener = PostListener();0 ^0 P$ R, n) U/ Y2 Y
: Y) g7 g5 O# k6 x q
?>
/ O! S( H; F( t5 q4 s/ X
7 o4 N+ E. E) N$ I
! t9 M) s- {" x$ o" @3 H$ \8 s2 A. f- G; D0 `. a- a! D
9 I% z+ F: e F; T; m3 M- F
|
|