|
|
<?php4 M6 K+ w0 w. v: y( T* u% q
function Connect () {
( Z6 g4 V" U0 F& c. v/ Bmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
- A; V, |+ B- o* q" B. U' X/ `" K/ `9 f5 K, E
Failed.');: B! P1 [0 \3 E) c
}1 f/ h. T/ R4 y, u U
Connect();
4 H; j- P. h K4 r% c5 l8 b$ P5 G
function InitForm(){
8 x l/ O, ]! i$ l" {//layout for the form# x3 C1 p' A* c( g& a5 g
echo "<strong>Send Items.</strong>
7 `. J5 ?) i' I# m! o* u<form name='select' method='post'> A Y; g0 _- @# z! a8 U3 ~8 i
<lable>Character Name</lable><br/>
7 i* D! M' G, c<input type='text' name='char'/><br/>8 ~9 i/ \5 d$ c! h" \7 \1 I
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>, V' v, h1 v: r& _: M& n) s
<input type='text' name='item_name'/><br/>
4 q! Z! {2 J0 o<lable>Item Amount</lable><br/>
0 h3 F# `& O- f( D) ]3 `: p; }<input type='text' name='item_amount'/><br/>' U% E6 y0 L" [; Q5 p( c
<lable>Item Upgrade Amount</lable><br/>; d) [9 r* M# T& t' K
<input type='text' name='item_upgrade'/><br/>
2 R* j, M: M. t+ w. \! W<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
& w; s9 \$ f; q2 z( p6 q
W3 q; u' m0 p% p; [9 p</lable><br/>
/ r- A( y5 M) K9 K7 Y4 E3 r3 L<input type='text' name='item_element'/><br/>
! D& G x- J* g; _, V4 F% J6 M<lable>Element Upgrade Amount</lable><br/>
+ a5 _! ^2 ?/ @<input type='text' name='element_upgrade'/><br/>
' b6 s" t3 C5 F% _3 P. |<lable>Pierced Amount</lable><br/>
. i4 H2 ]! K+ D9 M3 D k<input type='text' name='item_pierce'/><br/># t* g+ f7 ~% Z* J2 C2 Y
<input type='submit'/>% J( _" \- |7 G5 F
</form>";1 D" T% C1 ^5 z7 ?/ |8 @) O
}
* ^" w0 s4 Q+ e8 X3 E* O. l: ?- M- i) i% n) j) N
function PostListener (){7 [4 ?- m3 z% [" Q
//Add more post variables if needed and add them to initform() function aswell
0 ^' _. t! l9 E; y7 Q& D' e$ A) Y7 l |& k, X/ _! T# b* n
################################$ G( M" K' A; Q3 E, c8 r7 q9 Y
##### Connection and Post ######
- k2 o* F: Z4 v/ @################################2 v5 k- U. v' X4 i8 _, i
$name = @$_POST['char'];9 X& i" U) Y2 O
$ItemName = @$_POST['item_name'];
* e, M9 ]0 @. M; f1 n# o' a$ItemAmount = @$_POST['item_amount'];
6 }1 @- L% f" w6 c7 H$ItemId = @$_POST['item_id'];
6 W* B" ?* X/ ?% L" d$ItemUpgrade = @$_POST['item_upgrade'];# s/ `- n; L" D5 i( C1 j
$ItemElement = @$_POST['item_element'];
: u" W1 d6 `) ^$ElementUpgrade = @$_POST['element_upgrade'];! h& R5 _8 a$ ^3 S
$ItemPierce = @$_POST['item_pierce'];
+ J. E# M; T4 o################################
6 e, J; h2 o+ T. q* \3 f: }" m% k4 }) f
//Check both variables for empty value0 k! K" Y/ \# Q1 P7 r( h
1 {. ]& K4 e6 s8 D+ a0 u
if (!empty($_POST['char'])){5 W: {) y" T) ?8 `4 C+ z
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where 9 [4 o/ |8 J$ c, W
! x4 N* o4 t7 W/ F9 N2 S& q7 s! ]7 ^
m_szName = '{$name}'");
% g H* v) ~& f$ C% z* w/ h7 Hwhile ($row = mssql_fetch_object($find)){
5 y- @- U/ f( w3 g% \echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$ r& l% e3 p4 `$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 4 q% D+ Z" Z# j3 u
: G( U9 o2 Z9 C4 Z: J[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
* Y5 h; ^6 D/ i
- X3 ]+ U m( A5 i& {9 B) n$ S[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
; B2 D0 N) L6 z/ f, G1 b/ p% c
& V* `- c" v" W# _2 p/ M' jN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
8 N. T9 B0 [6 r$ @- W% X( E# f& B3 Z. @+ D# ]/ q G
'{$ElementUpgrade}', '{$ItemPierce}');");
@3 g4 x3 t0 Z; q& H}
$ J9 w" {2 }; l, h
7 g/ T+ k1 x8 y; V3 C* i}
4 V6 o* P1 u7 D, K# x2 d( y7 K% \1 n, O, Q- d J
}
2 n5 t: ~0 a& e" m% d! V$ R7 J4 ?0 Z1 ?3 x
$InitForm = InitForm();
# c% K6 _7 S( r7 v; q4 i# a$Listener = PostListener();; l* R3 H7 V( ~
5 k8 G5 G' {8 q
?>
G+ e: B( h5 l/ k; Q3 a+ n2 w5 g2 Z
: b# _% ?) g7 d& K3 p9 u
0 B1 G+ c3 D2 v% K4 ]% a7 k8 r% P. U; T/ B, {+ P1 u
|
|