|
|
<?php. x* G- ]+ V+ ]9 k3 c. e; q
function Connect () {* n5 f! _. e; {+ E0 T8 B1 p
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB 5 ~: j# v1 l& [2 w j2 e
6 |/ o& | J* s! ?) D, s
Failed.');
$ {% M$ i% v2 O8 ?2 U}
9 T- P D; w, JConnect();; L9 U* O/ W% J
6 I8 f8 s& Y3 ~/ H$ c. f kfunction InitForm(){: ^) \# h" D+ |/ T
//layout for the form# u9 ~/ u8 t% ~! G) |9 }+ |
echo "<strong>Send Items.</strong>1 G- n* V8 H' Z9 T& h2 o0 ?
<form name='select' method='post'>- W+ I& x, D& @% S6 S
<lable>Character Name</lable><br/>
. z7 j* q# W: y/ f7 N' P9 R6 D<input type='text' name='char'/><br/>8 T$ r* Q, D0 x7 \ q
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>3 V- E0 A. A! P1 k
<input type='text' name='item_name'/><br/>. h' `1 x/ F$ a) h
<lable>Item Amount</lable><br/>3 m" b" ~9 z& F! J2 E
<input type='text' name='item_amount'/><br/>
( S2 ], C0 i5 S0 m<lable>Item Upgrade Amount</lable><br/>& n9 F% S% @3 z8 k" Z' U
<input type='text' name='item_upgrade'/><br/>% k$ H) l8 l5 y; u7 p
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
" _- Q, W7 c1 o: `4 y, e4 c1 q/ l
1 [4 p9 a5 j+ t; i" |+ l</lable><br/>
$ U9 V, \# Q; T+ K4 ~# h<input type='text' name='item_element'/><br/>3 z# ~* q, a! p) a- b
<lable>Element Upgrade Amount</lable><br/>
1 Q9 q0 Z6 d( Q% x+ M4 E8 Q9 C; K& O9 N# U<input type='text' name='element_upgrade'/><br/>- t3 q/ O) T) P6 A. I7 G3 M
<lable>Pierced Amount</lable><br/>
2 N4 m# S, s( o; A- C4 Q<input type='text' name='item_pierce'/><br/>
! @' {5 \# M. G" W$ z. ~. d; ]<input type='submit'/>
' q* F) `4 U& [& L$ d</form>";) n. P$ i q, ]. B' n: R( p
}
1 A b$ S& P. b8 v/ d: x' { G7 z$ {1 h- Z5 ^
function PostListener (){
: {" ^9 Q5 ^7 D3 C//Add more post variables if needed and add them to initform() function aswell
9 n; t/ ~8 v( l; v) r/ t& s
" b* a* A, s; t9 P4 U* o################################
0 o' S, a9 o+ c( Y##### Connection and Post ######
3 T' f: h `& u) h' ^* f4 w################################
9 c: V' ?6 c& N, O' S& }$name = @$_POST['char'];6 K0 Y$ x5 F2 X- B
$ItemName = @$_POST['item_name'];0 A0 T" g# C. D- {0 {* [+ r" [
$ItemAmount = @$_POST['item_amount'];3 l# {+ X$ H6 I# ` z8 O8 Y
$ItemId = @$_POST['item_id'];% x& J( c( I, k+ Z, |8 V9 i7 Z, G
$ItemUpgrade = @$_POST['item_upgrade'];
2 ^* N2 G5 r$ H) G$ d3 B( p( l$ItemElement = @$_POST['item_element'];; ]' t- D9 h4 v8 p
$ElementUpgrade = @$_POST['element_upgrade'];% M. L7 v# u3 ^! O$ V
$ItemPierce = @$_POST['item_pierce'];5 A' S8 o; W* [; g5 z
################################) |, u% J# g! F5 g* V
& J3 m$ c5 d* J5 ~% q4 ^//Check both variables for empty value
9 }: ]/ |# Y3 Q" b4 K6 n
+ g& S5 ~% t2 I" c& B/ i& p* @if (!empty($_POST['char'])){
& B9 f. g; g3 g0 R7 R! ^$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where : K9 v5 }+ F( ~8 {. `
- W: _. T) a. {+ k" n7 p
m_szName = '{$name}'");5 T4 c; M2 Z; H
while ($row = mssql_fetch_object($find)){4 U. t4 z* @ o* n! e$ @# }; F
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
! y( j- J5 o+ _% n e) b$ P0 q7 u. Y$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 8 B4 _8 ]% m' T
s- B' W& D6 q) d- W[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], 6 S6 K9 y6 `5 l2 U$ c
* Z* ]; C. i. Q[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
& R7 V: G. M3 o% A& r: @& X( \$ a4 W2 P
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', ) h. \% b' L+ W. }! {5 l/ Q
$ C: Q2 R7 F. }4 \' N, S'{$ElementUpgrade}', '{$ItemPierce}');");2 l: I4 s) s5 e9 `5 D0 w
}
$ |8 S3 u _. d2 b1 f1 C# Y2 r$ h! A, o# H1 k
}) r& a3 S5 _( P0 T5 L% s
$ \ }- H2 ]2 C5 T+ ^1 X) y" \4 q Q}% ]6 X: C6 O0 J" B9 @
% w3 p, R& b7 h$InitForm = InitForm(); P( m2 N# [; Q: [! ?
$Listener = PostListener();
8 t8 ~- @6 o- K3 D0 ?6 U8 P4 g# e: M. U
?># Y! o# m2 o$ k
0 d1 h h, P4 j& H. D) }5 G- C+ [$ N5 m2 H
5 j% Q7 A7 \% _$ ]$ {! h; m
* v+ {3 z( B' f5 [% s |
|