|
|
<?php
q( J& X% q" ?% d" |function Connect () {# F& X. n1 R' b% k/ N
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB 8 q2 H1 Q f" Y
( d" d% z& @ f3 hFailed.');
2 j. S6 m) T, J; @; a}
& S) T @: C t# R. |Connect();
8 @" ?) F: I: _" a' g4 J9 D4 \
4 c( C5 ~) ] g# Ifunction InitForm(){
, c) y/ `6 W4 m- i6 Q! `, G//layout for the form
r, S2 }! b2 C# Qecho "<strong>Send Items.</strong>% \6 ^. C, @2 f% }: H1 k
<form name='select' method='post'>
( E- X& {/ [* i( k<lable>Character Name</lable><br/>; n, a6 h& [: E5 K, z
<input type='text' name='char'/><br/>) n& b* p# d+ n4 A: X( l
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>% }7 @1 X0 J1 a" Q" B+ j
<input type='text' name='item_name'/><br/>& _& q% v7 e1 E9 L6 i, m
<lable>Item Amount</lable><br/>2 s8 Y- B S& B9 r' e- e
<input type='text' name='item_amount'/><br/>: z' p, m9 n3 z O% b
<lable>Item Upgrade Amount</lable><br/>
- A6 F0 E: I3 I0 o<input type='text' name='item_upgrade'/><br/>
+ T$ d( g; M! Z<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
* @' B* f! k7 J9 e5 I
" Z# {) n; G5 v</lable><br/>
: X2 I$ p% j, T* g' E' v7 L<input type='text' name='item_element'/><br/>! E7 @. B/ t# c
<lable>Element Upgrade Amount</lable><br/>9 S) ^1 k# y8 ]" T
<input type='text' name='element_upgrade'/><br/>
; Z- t$ _ H+ D- J, |# z! E<lable>Pierced Amount</lable><br/>
- F# Q$ x9 K5 n( L% B* [: Z$ V<input type='text' name='item_pierce'/><br/>
0 Q8 b: d& D8 i h<input type='submit'/>2 Q# ? g4 o$ q
</form>";- w% b3 }" P- e
}
# M% l4 j# m) ~2 p
, q% H0 M8 N' F+ I) Afunction PostListener (){
, M1 a+ K `+ S' t. I. U//Add more post variables if needed and add them to initform() function aswell& R3 H7 H0 K1 x( Q
1 O( ~/ W6 K4 Z) K7 `" ]. U" L- ~
################################
) h& S, ?3 Z' ^& I; {+ W4 E/ e+ \) d0 g##### Connection and Post ######8 D/ i8 v3 \( u7 `$ }; b% J) b" b
################################; b, Q' C2 |5 ^# J0 K8 s3 Z
$name = @$_POST['char'];
. b3 g0 @" p+ Y7 s+ T! I' o$ItemName = @$_POST['item_name'];8 `7 \1 f! q% w% i' z
$ItemAmount = @$_POST['item_amount'];
2 q0 `. ]' I! ?" S$ItemId = @$_POST['item_id'];
' ^9 S" b. Z4 v* R8 q% j3 o$ItemUpgrade = @$_POST['item_upgrade'];5 b& A/ a4 o; `; v5 F
$ItemElement = @$_POST['item_element'];! H3 `4 ^: K2 M& D
$ElementUpgrade = @$_POST['element_upgrade'];1 H6 R3 p3 T; B% n7 F8 k& l
$ItemPierce = @$_POST['item_pierce'];
# X4 h: d1 v/ j/ c5 l5 b/ X################################" V% E) t W6 M7 M% d! A
/ s6 H$ L1 k5 A% C( k//Check both variables for empty value
# }2 f( n! m5 v* D# I) a8 p3 y( x' b# ~8 d( r) x7 x
if (!empty($_POST['char'])){
5 P) ~: J8 h: E* b1 y- x- t$ s3 m$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where ' @$ |0 n0 S3 W; T0 ^
' A0 F/ [# O9 D( v3 b8 um_szName = '{$name}'");
/ Q& N7 R# f2 Awhile ($row = mssql_fetch_object($find)){) s) T7 u) R8 @6 D8 a
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
# z$ @0 o p$ q8 I6 u$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], : ^6 b* B5 f: \: n; }
' P8 _" @3 x4 K' ?* {[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
, U/ b4 i1 [; L3 ~6 K* J! ?
+ Y; w( U$ V7 E8 }- f b[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
# h9 t9 a- ~9 s% H. n, V9 n( F$ ~! D
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', * j6 Y: r- a8 |8 j' J- R7 }% a
; J+ O$ B- i8 @ B. c3 v/ Z- e M& {
'{$ElementUpgrade}', '{$ItemPierce}');");- |. C& g2 O8 p U
}
9 v4 Q5 G6 Q; Z; N" o4 }7 s4 n
* M5 ]( [# T9 N; M+ @}3 b) F) W6 u5 S) Z$ H
1 |6 p% X, U/ s: K& E0 C& J}) j& _5 S: d5 q- W# A6 E9 D
; b- k% M2 J7 }# d9 F/ [! r
$InitForm = InitForm();
9 V7 [" T4 S% K* G; q$Listener = PostListener(); k8 u- K2 V4 u5 u
: f9 e5 w2 u" I
?>
- \' _$ n+ l2 N& M7 |; O
: Z v" J3 k3 g8 c0 ?& Z9 l- ~& X' d: V
, }6 F# h- L" c
; Z O( h$ t4 A* D$ P9 s |
|