|
|
<?php' c: ]& s. m9 B$ i
function Connect () {
& v& }: h5 v; @& K, J4 \4 ~mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
% ?8 o) V) P! d3 P I% c
: R1 K+ Q* w- D. ?9 d& ?4 vFailed.');" f# p) g. L1 w4 h
}( F1 a8 g/ U2 w( W- ^9 m
Connect();5 @4 v# P& L4 Y+ C8 H
2 m3 r: r9 @, @( v- ?( n
function InitForm(){
+ m& }$ |7 U, d( l6 g2 j" k//layout for the form
' z" r3 p1 S1 U" W$ Y, H& i5 mecho "<strong>Send Items.</strong>; R2 k3 N: V V' C5 C; p
<form name='select' method='post'>' X8 j) R( ^ v& [* H( O4 U/ R
<lable>Character Name</lable><br/>
6 X% l! C9 J* N8 n9 ?" v<input type='text' name='char'/><br/>
: ~7 U( P D7 x& s$ }% d<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>' h: @" U: T5 f. s% Q5 S/ G, z
<input type='text' name='item_name'/><br/>4 z" S2 Q* g/ P5 I5 ?7 s
<lable>Item Amount</lable><br/>
( l3 R: Z5 M: T: e) M, v<input type='text' name='item_amount'/><br/>5 O2 U! x3 [1 g5 X7 H
<lable>Item Upgrade Amount</lable><br/>
- k: J6 X) l$ C* D$ }6 ]0 c6 y$ l<input type='text' name='item_upgrade'/><br/>* N( ?; I' p3 r; [! }
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.) M0 q/ \% W6 q' U
{; m3 e7 Z. b( _/ j
</lable><br/>" K# w! L" A! p1 B Y% q) A
<input type='text' name='item_element'/><br/>
5 u& z6 o# |6 f9 _4 H<lable>Element Upgrade Amount</lable><br/>
5 E/ O' f/ G7 J" C: [/ E<input type='text' name='element_upgrade'/><br/> w& s) a0 N' K' Q3 u% P
<lable>Pierced Amount</lable><br/>
5 T& |- q* K# {! K& G- W<input type='text' name='item_pierce'/><br/># q+ p7 T# r7 R4 F: o. s' l5 y8 ?
<input type='submit'/>
0 ?- t2 V6 _1 V8 |5 v- V e5 c</form>";
2 v- y9 p8 _9 p' T$ ^8 L( r}
# N( F: V6 q/ \ X0 f. s- i; N! k7 T# B7 w6 F4 B
function PostListener (){
5 S' K+ E/ }! i5 B! B//Add more post variables if needed and add them to initform() function aswell
# @% A8 U# l( P* [& q2 l4 T7 e! Q3 B/ e
################################
8 r0 _* `- W! B0 P+ g##### Connection and Post ######* z' N9 u6 H) b& h9 }/ V! J/ M/ B
################################0 p* f, b; N4 K, Z4 t3 ?$ d% i/ R
$name = @$_POST['char'];
& i/ K5 L& i- {6 d7 Q6 D; W% @" ^$ItemName = @$_POST['item_name'];
* l+ I0 o8 u6 N. x( L7 r& @$ItemAmount = @$_POST['item_amount'];
( w$ `+ }3 M0 q1 V& f# G$ItemId = @$_POST['item_id'];5 S) N0 r1 S# B* \& _6 H3 ]) Z
$ItemUpgrade = @$_POST['item_upgrade'];
8 g9 I. u/ a( A8 V& }3 c$ItemElement = @$_POST['item_element'];
. s; Z+ D( ~% I. l, a7 b$ElementUpgrade = @$_POST['element_upgrade'];) j7 Z" a( j0 K! i; Q& I$ q$ L& K
$ItemPierce = @$_POST['item_pierce'];& \8 R. O S9 s* B, e/ n% ^. Q7 |
################################
" o8 m7 Z5 s- T6 G
6 ?8 i) @; p: \. Z0 W; w8 o//Check both variables for empty value2 V0 e; Z9 L) ^# V0 y
) |2 ?- s) x% x7 ^) zif (!empty($_POST['char'])){
9 f" r7 m# \% l& W! F; ?$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
. ^ b( u) d L. j. L0 p4 B) G- y! A j$ u
m_szName = '{$name}'");
: U# i2 a1 i' k9 e q mwhile ($row = mssql_fetch_object($find)){0 \9 O' l4 E. k6 v \% ^/ j6 ~# h1 H
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";* l( [3 J. x* V4 ?. c+ \
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 0 Q6 n1 U9 o, Q" n8 n9 Q3 Z. _9 a8 {
0 i- K- i3 |2 Y[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
2 i# [3 o' H. J8 Z+ d2 A7 v0 V5 K* P ~( \* l
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', ! N$ ]9 ]( B% I
$ f( R( W0 W- y; b1 b
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', / D- [# P4 Y( C0 \6 G2 J+ D
8 [" J6 w" M- l% Z8 L6 h1 N
'{$ElementUpgrade}', '{$ItemPierce}');");
9 f# U2 v; ?1 Z! N}
% ^! V6 N* }+ a% o: R' L
7 a* R; T# c$ A( u}
# Y0 p' _( T7 {+ x/ t9 Y H$ G, w5 Y
}
! w+ v% ~, M$ R/ O5 e
4 H/ @' E4 b1 ?5 F$InitForm = InitForm();
2 h* r$ I! ?- D% p$Listener = PostListener();% }3 A8 {1 `! ^# [
: o# [* n1 U' l$ ~' y?>
% U8 l! u- I: x7 ~( s* u+ g1 g- T
% J- C& J. A# `+ M4 D$ j% d) Y
+ n4 |! [' N! \1 _, ^
4 z& ^! N4 A, p1 K" w. T. z* Q; V
5 _# d( q1 u# S/ t |
|