|
|
<?php
' `5 P' X4 c0 h$ H. Ufunction Connect () {( l% Z# k1 V' d. ?& Z4 n
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB ' w& N1 u$ N9 B2 }% `& q8 M0 D, i
% f O9 T# _1 dFailed.');
5 F2 S- Z* k( L- m}
" l D7 ~2 Z( w! X XConnect();
0 u# H+ t4 Q3 i8 i$ R& D7 S2 K
* v& K( [! n M3 Cfunction InitForm(){9 i- h5 q/ d0 U' n
//layout for the form# m6 K$ ?1 [6 Y; e0 L9 r1 e
echo "<strong>Send Items.</strong>
7 v6 J5 U; s4 G' f t4 P( G3 l! Q<form name='select' method='post'>% {0 F7 E4 q. {: f0 x
<lable>Character Name</lable><br/>$ G. Q% e" O4 r- x2 b
<input type='text' name='char'/><br/>
9 n/ Z$ V5 q* o6 J5 Y5 U<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>5 V( @/ R. D5 D* y X. q
<input type='text' name='item_name'/><br/>8 h: K# i) n0 s7 K$ U4 C& a' Q0 g
<lable>Item Amount</lable><br/>
/ Q- B# X2 H9 V$ v<input type='text' name='item_amount'/><br/>0 x3 m, h7 h: g6 p# g2 v6 u; N
<lable>Item Upgrade Amount</lable><br/>
9 f6 M) R/ r/ x% L6 g<input type='text' name='item_upgrade'/><br/>
! D0 o' s- T7 S f<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
3 r* P5 O1 M# X" j3 h$ l% T. \$ l0 v2 t+ h/ [5 n
</lable><br/>2 J! [6 V" ~ j2 p- o3 p
<input type='text' name='item_element'/><br/> K4 D( j" _2 w& f# u' v: I
<lable>Element Upgrade Amount</lable><br/>! b+ g4 z6 J: u2 A/ G, g( p4 W
<input type='text' name='element_upgrade'/><br/>) t! U( G6 O; z9 N
<lable>Pierced Amount</lable><br/>
+ I' v& Q5 B% n9 ?, A- Z<input type='text' name='item_pierce'/><br/>
1 B% p4 g9 G% c- f<input type='submit'/>
* d( l" b3 A p" t6 v7 n& D</form>";7 K# b: C. t2 I' o, B
}
* i7 O/ B* @2 X9 }6 P
2 T4 ?6 w0 W, b# g6 nfunction PostListener (){
$ J: e# L5 n( [5 Q+ ^5 P' Y @//Add more post variables if needed and add them to initform() function aswell
2 r0 p/ r9 h7 @9 `" r9 z4 }: s- X3 x. _
################################1 N k6 s8 l: c( n
##### Connection and Post ######% s6 l8 w! z. X8 G, T
################################
/ N9 ]0 Z6 w& r8 T8 f; D# }$name = @$_POST['char'];1 ]0 N# c& p: D; R- \; N
$ItemName = @$_POST['item_name'];
; T% n z, x& d# N* ?. [$ItemAmount = @$_POST['item_amount']; D+ |+ {7 Q7 @9 p* S( ]
$ItemId = @$_POST['item_id'];" y! m1 z4 L2 c- s7 a; M
$ItemUpgrade = @$_POST['item_upgrade'];, S& N- ?5 V: z8 }
$ItemElement = @$_POST['item_element'];
' p3 B4 v! u8 ^/ |: m2 m7 ~$ElementUpgrade = @$_POST['element_upgrade'];
5 {) P4 E6 H- }$ItemPierce = @$_POST['item_pierce'];" E& Q3 g) v! \$ ^ N
################################
0 x5 C: e+ ~, B1 j( ]) Z! ~
5 ?/ {9 \8 C+ q3 S) D//Check both variables for empty value
' J6 D1 q/ ^$ f i2 K# s! f! c P6 ` f" Y: x. m$ v
if (!empty($_POST['char'])){2 P7 z, D5 i2 \" B$ l# f. H- K# g
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
! z& C( G6 `& k3 J) K7 p- G0 A5 x% K2 w
m_szName = '{$name}'");
" A# k2 I" |9 r3 y( q6 V0 z' x. V0 awhile ($row = mssql_fetch_object($find)){! i. _8 D2 Z( d# p, J. v$ g
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
h0 f4 y6 {( X* ^$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
1 P7 F8 p" `" v0 X) o% L
* s* O8 l$ ?# z8 m9 f0 ][serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], * x; w, Q* W- Q; t3 C# Y4 q g
5 ~4 F( ?4 f7 J/ u1 T" P5 `
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
% N' p* C8 |$ {' R- {+ B# A
. o; c8 N0 \# z& f0 g T L; [8 L: XN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 5 [) E- N" l1 q" w% k5 s
. t% ^( g* R/ V e$ u'{$ElementUpgrade}', '{$ItemPierce}');");
5 T( Q4 g' x3 T8 F/ E' G- v% b$ O% O}
7 E. ~6 n- F" }9 S# \& y; C- i) }! \* f
}
7 c. r5 W$ Q; ]1 E8 y3 f/ O* @5 ^2 e3 Q' m
}
4 ^3 G ?1 i( S, ?" u Y- q3 J
5 `) l8 E7 V$ I" I/ q2 C9 I$InitForm = InitForm();" z3 w" v4 t x7 S; v# x. S
$Listener = PostListener();
/ a+ M5 ~$ \& S1 |% m9 l% j% i+ X3 H' j# t
?>
, r4 `6 O' H+ i x& p% [ V* V% b4 |6 z" C. Z4 X! c8 Y
0 j& [9 c4 X2 t% P
1 ^. Y# t2 H3 F9 U0 J \2 H+ {0 G+ x# C3 i- i
|
|