|
|
<?php
" d' O' X1 a" P2 Bfunction Connect () {8 b. ?; o I8 k; _
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
) I, {" {3 \9 L6 W
# b0 l9 s& ]1 ^5 j' yFailed.');
* r% P$ w( M( c5 ]$ I4 m. K. _}" C; G/ ~9 u# t$ Z
Connect();
- Q- O4 k: O3 k
1 L6 k2 S M( _* C0 H5 T& v! N+ Vfunction InitForm(){
) A! z4 @( [) V) f2 N* Z+ m//layout for the form3 w7 }4 c, n$ ?9 V- {
echo "<strong>Send Items.</strong>+ k' d! h3 R1 ^9 i
<form name='select' method='post'>' D: z; r9 m7 D$ C- F4 D; ~9 X
<lable>Character Name</lable><br/>
+ C: ~4 N6 A: A {<input type='text' name='char'/><br/>
- W. _! ]6 ~; f) _1 a" a9 e<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>1 L# X! A5 J& @. r
<input type='text' name='item_name'/><br/>" m' q8 }: x& C; B5 R# j
<lable>Item Amount</lable><br/>
7 j, U9 c0 B/ x6 F8 F4 b% H<input type='text' name='item_amount'/><br/>
& T2 P9 N4 k( l" n0 K. u" n' q0 V<lable>Item Upgrade Amount</lable><br/>
+ X9 G d# O9 u, A: K$ {5 c<input type='text' name='item_upgrade'/><br/>8 }/ C7 [+ X) \% D
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)% @1 p# ^; @6 {' d( Q
- | G, H* S9 v4 }' t8 s& G" B
</lable><br/>
% q8 i4 } M9 d- \' K<input type='text' name='item_element'/><br/>; A4 ^2 R9 s3 w7 ^3 d
<lable>Element Upgrade Amount</lable><br/>/ T: v: _2 V. \
<input type='text' name='element_upgrade'/><br/>; S7 ^# \- c4 B8 F6 n7 ? _
<lable>Pierced Amount</lable><br/>
# ?0 n+ u& n) X( s5 |1 i- ?: C<input type='text' name='item_pierce'/><br/>, \: V% K @3 `; l, k
<input type='submit'/> j3 Z! A0 k* X8 P; }* B* j
</form>";
1 ?5 ?7 d+ w% ]}! }; p- E) [% t8 y
# S- Y# k1 {( G$ K* ^8 c- Z
function PostListener (){
' J6 ~& r% a# P//Add more post variables if needed and add them to initform() function aswell M4 ?$ w& U9 `
' N b2 G: P. P( c6 V
################################$ N U; Z' g! Q. d1 l4 `: b9 J
##### Connection and Post ######
. u% X, @ U, f2 W################################' u4 ]3 K4 X7 w8 L% m, M8 H( d: ]
$name = @$_POST['char'];! F, R4 ?7 ^' _: {
$ItemName = @$_POST['item_name'];( f# u# s: p( e! }9 U* u
$ItemAmount = @$_POST['item_amount'];6 `4 V+ P7 C5 W# @
$ItemId = @$_POST['item_id'];/ F& _( |$ ^% s1 R2 d$ N
$ItemUpgrade = @$_POST['item_upgrade'];' q6 T! A' ~' T+ Q b
$ItemElement = @$_POST['item_element'];( U" N1 c# v2 J5 b- N7 U1 V
$ElementUpgrade = @$_POST['element_upgrade'];& Y7 i# m0 Z0 N) F* G
$ItemPierce = @$_POST['item_pierce'];
9 S7 I1 B f$ t9 h6 I. S O################################, B0 s" E$ W# Z5 j% Y
4 M1 ^7 f e* [6 ~! G# A9 W f( e
//Check both variables for empty value
% T' R9 O. |# J1 S* d" A1 ~* A5 P" z
if (!empty($_POST['char'])){
# ?% R! n" E, U! Q$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where 9 m8 O; p4 F/ ^# k' B
8 t) |/ b$ A- f" mm_szName = '{$name}'");
/ z9 }9 ^; u7 q3 E2 g: e. ]$ wwhile ($row = mssql_fetch_object($find)){2 z$ i7 {$ ~, R5 K. G" z/ |
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";. `4 ^ z# |" j( B+ _2 s& p
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
" s8 |( |8 h* W: B, \! ~
: Q7 {* L u5 B* |[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
/ v% ]; X4 J7 r( R5 ?
' {5 b! J& l) v3 P[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
$ i5 Q, i- m5 ?8 y9 [7 w6 P. i+ \9 w- J- V4 h
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
6 j$ Y; l5 v2 f
; O5 b8 B5 e: n! c'{$ElementUpgrade}', '{$ItemPierce}');");
+ M/ T7 `7 R' b' J+ ~/ h/ V% ?}7 L" o& k6 j" Z" a
9 r2 _% q& d7 S1 v7 Z
}9 a9 m4 W" r& \8 u4 l4 g: ?' k
! W" m7 `$ f9 k' Z: q D
}
& |4 d. x( g; T6 W) H P% v- T n# _. Y. i! V; E: e" L2 f2 m
$InitForm = InitForm();
8 S" M2 B4 ]( T8 H. o: w$Listener = PostListener();
6 T3 I; H* d5 E, B# o7 s6 E5 P* n6 O \
?>; y6 j6 D( }; T* N2 F
3 i( g# b/ r; a; J# D
6 x# u3 | A2 I- f3 @
+ O K+ Z) x: c0 j
8 V& ~+ Q8 k3 N |
|