|
|
<?php
5 D( j( q% h! P0 i5 `function Connect () {: m) l9 ^% [' X* y# J
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
; u5 e/ z' {& C
- ~, p! I! [' X. G. TFailed.');
* p- }% X; s5 V0 P: T}
* r3 M9 ^7 [ Y( a" n8 MConnect();
- Q; _2 r* `; {% _8 N' j1 ~
, L2 f# x# D R& {function InitForm(){# @9 t- R, x$ \
//layout for the form
* X$ Y3 T- r r6 v0 Jecho "<strong>Send Items.</strong>
0 T8 m- h8 P6 K0 M- I<form name='select' method='post'>3 d3 ~. {* Q4 L
<lable>Character Name</lable><br/>, V1 ~( F( Y6 v! Z6 |) A
<input type='text' name='char'/><br/>( i, S% q; p* A: x7 @$ z, K2 ^% Y- U
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>0 ^" _/ U( D! j n" ]% G
<input type='text' name='item_name'/><br/>
) k. ~4 b( U$ |<lable>Item Amount</lable><br/>8 p9 W# P/ x7 u+ r1 r( C
<input type='text' name='item_amount'/><br/>& M7 p* }4 z( r" v* C. a8 v
<lable>Item Upgrade Amount</lable><br/>
5 g# n' a r/ J' d- y! {<input type='text' name='item_upgrade'/><br/>; j) K! {0 d0 J7 I$ I
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)4 p' r9 m' L3 q# W8 U- n6 L# c
- G- K4 i: i- |# c</lable><br/>, Y9 i, k1 [3 _ [7 A
<input type='text' name='item_element'/><br/>- D4 _6 M* }5 o" R
<lable>Element Upgrade Amount</lable><br/>
+ E" i% S1 i: i u<input type='text' name='element_upgrade'/><br/>
% J4 S4 E1 B- `<lable>Pierced Amount</lable><br/>
* s+ A; p% j) e2 g, G- J0 ]<input type='text' name='item_pierce'/><br/>
# b! D! ?* R! C2 ]' l1 Z<input type='submit'/>
/ T" y: X( c& T6 d</form>";
' o6 T3 P5 _2 n# y4 i}
! v& \+ I0 U# T0 j% m( I( z) M4 @$ s
function PostListener (){
; h8 \4 M/ F% z4 h$ _& n& P5 ]//Add more post variables if needed and add them to initform() function aswell
: v* E! o3 i/ C* S
" K, y* |6 i6 h################################) s. }, G6 N9 Q9 o1 u0 z+ y9 [
##### Connection and Post ######7 b0 m* @1 O$ M x+ c9 D
################################
% i2 P1 {" p9 s- ]" D8 ? m. N$name = @$_POST['char'];6 S, b. V5 e, F: ^
$ItemName = @$_POST['item_name'];3 p: s: S+ l# V8 H
$ItemAmount = @$_POST['item_amount'];
0 Z! r @- @5 X* P$ t7 F$ g$ItemId = @$_POST['item_id'];
/ _6 p% X+ m! \% o2 o$ItemUpgrade = @$_POST['item_upgrade'];7 |5 K5 I$ h2 E A
$ItemElement = @$_POST['item_element'];5 t: u, V7 J( d" x/ B
$ElementUpgrade = @$_POST['element_upgrade'];) U6 T: m! Q# U
$ItemPierce = @$_POST['item_pierce'];
. S" O- j, p9 a: S2 x################################; f7 D9 h: b" A6 @2 t, w
- {/ [( X( z. D" h8 r
//Check both variables for empty value
3 e4 n$ s( F% ?% A x5 p
6 c. U) X" ~! U2 o1 x# h/ ?( D7 Z- C" Eif (!empty($_POST['char'])){
! X0 p& s& k( a8 Q: a6 X3 ]! c$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
$ [% L! e0 o3 k. A7 N( o# Q% y% y2 L7 \) I- u% p# M# \) l6 L
m_szName = '{$name}'");
5 x9 U' ~8 J( F: z6 _; I5 nwhile ($row = mssql_fetch_object($find)){- s N$ `8 {- P5 e% B
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>"; m" _% k# o( G; w$ T- ]
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
, x7 c/ u6 c4 ^0 m" d. e) k
" {6 a* I6 e3 U& T0 u# O[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
5 H$ |5 o* t8 S U4 k3 w0 ]
, N8 t1 N) ]4 q) R[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', ' K- z! U# A( `. z
7 M; T( w) N; k
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
. x! [% ^: y: d! W6 u9 G$ i, x* g2 k) D4 h7 l }
'{$ElementUpgrade}', '{$ItemPierce}');");
) D& ^% R+ W* a5 z7 J6 ~}/ h: x/ A4 @% x m$ Z/ b1 ^6 ]/ [
6 q# T8 V0 p& D1 X+ l}
+ q# ^- Q# L( Q+ J: y: G* _ T# O) l% S/ a! W* {
}! d' T v- F9 h
R/ w/ c, N1 `( D* `4 x, F$InitForm = InitForm();
0 f) ?$ v1 C9 k i9 a* E7 d/ j$Listener = PostListener();
7 ^+ p: m8 o$ ~4 X2 K* B2 \
1 l8 Q0 w# [8 r% Y?>
! ]3 O( [: R3 \# M4 z& a% x7 X6 Z& @' P& Q8 C0 D6 O9 u% ~& |/ \
. o, {6 q6 @+ A% d$ R! v
9 ]% e. ?8 b& @, K7 S' T
( |# H7 q& M- _" z% d! C3 r; H% Y2 ~ |
|