|
|
<?php
. F) B" i J5 P1 a: nfunction Connect () {# G8 y6 f$ W% M2 m X# J
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
4 d' U* O8 m8 [& r2 \; w$ r* ~
! D g: M2 G3 Z7 n% p; bFailed.');
: [9 E6 }7 q' Y! ~/ P}
. ~) o1 b# v1 w5 U0 ]& _2 v0 sConnect();- j4 J% f n. e% I4 ~( D/ Z7 X2 ~
: Y1 j9 }5 n3 B1 p* Wfunction InitForm(){
% \7 o" s' R$ v//layout for the form0 i c9 |; `1 T- r1 E5 O
echo "<strong>Send Items.</strong>
, ]- K! l" T ~7 Q<form name='select' method='post'>
1 w$ {! @4 N$ p8 ^# b<lable>Character Name</lable><br/>! L# O; Y5 m2 I
<input type='text' name='char'/><br/>
1 ~2 T$ H9 J+ v3 n _<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
1 v( k; t) _& p( Q$ c<input type='text' name='item_name'/><br/>
! {2 p2 n9 V) u4 s<lable>Item Amount</lable><br/>, P5 C* w0 d" k. |
<input type='text' name='item_amount'/><br/>
% e1 A% @2 c2 P/ ?3 u8 w5 K<lable>Item Upgrade Amount</lable><br/>! s* y" j; @( { F
<input type='text' name='item_upgrade'/><br/>
$ y! L3 R9 H) a0 p, N<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
* g* R8 y5 M5 K& `+ q
& c, H( B8 e' d2 H$ C</lable><br/>1 U r0 G& j/ i% X( E" D& G
<input type='text' name='item_element'/><br/>- B; ~2 p0 I* o
<lable>Element Upgrade Amount</lable><br/>
4 y* J7 X b$ l! ~5 c- o" S<input type='text' name='element_upgrade'/><br/>
5 o `& f2 s" J8 A<lable>Pierced Amount</lable><br/>+ H& v. g# U* @/ t+ I
<input type='text' name='item_pierce'/><br/>/ z. r: T6 D T% k& [5 F! P( ?3 }
<input type='submit'/>
8 t9 B$ s- Y2 f: F9 K</form>";
( |0 R" T; K! E2 W9 z( Q6 f' i: y9 R}
4 o2 G' e( @$ a2 r8 a1 K5 C5 o1 U' k; }& i) N2 r
function PostListener (){2 C" k/ i4 ? B+ @: \+ {- u9 K
//Add more post variables if needed and add them to initform() function aswell
* D& @9 _9 D" J; C9 P, d2 L* R3 y* G2 `9 g; u
################################- P- i/ Q7 w0 _" |' l% ?3 `7 K
##### Connection and Post ######
/ n: i+ h( y' h) X################################
6 ?# D, ~/ o8 R3 t% ~3 \8 M$name = @$_POST['char'];
# e$ v4 O. m5 t1 n$ t% I. e" l) h$ItemName = @$_POST['item_name'];
- r0 K) c) f& U* k; w$ItemAmount = @$_POST['item_amount'];) c# Q& U s0 P, N1 F: W- n
$ItemId = @$_POST['item_id'];# b3 @ z' m" q/ f! _2 W* A. @
$ItemUpgrade = @$_POST['item_upgrade'];
. P, e. V9 M- M) C! n! Q% a$ItemElement = @$_POST['item_element'];
& o2 J% g, v0 C- _$ElementUpgrade = @$_POST['element_upgrade'];
8 @% ~! q/ M# m# P, j$ItemPierce = @$_POST['item_pierce'];
5 @5 L# u r) t; Y, Q) q################################
0 ]3 M/ y; X7 K4 b$ x' v$ x) a; R& A. s1 l+ G5 u! T* L- a% g
//Check both variables for empty value @6 g* D( }2 ~2 t5 I; \2 Y/ K
" F& I* J$ K' ~% G" W* z/ Z9 c
if (!empty($_POST['char'])){- x3 a' v8 E3 n0 S- Z! \
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
, ^7 Y' `# |" i: P# ^. k
4 X' s+ o/ q- L" {m_szName = '{$name}'");2 m' h# O+ f- n5 i- W
while ($row = mssql_fetch_object($find)){
6 ]$ N7 J3 r3 Z- d! S" F" h& eecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";( A# n' R7 s6 E/ z- i" E& L, l: s+ t
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
* z1 c0 t- K- j4 ~3 Q) V! }/ |
R- c4 |) [- z& H# i- h- u; ][serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
: E$ U( m4 q/ X* Y# O+ {+ B6 o9 R( ]0 t. ?5 r( d2 d# b
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 2 H5 _- b" J0 R+ f" j6 g$ \! w
7 I3 }; I! b" y7 o: [: _ vN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 7 `+ R4 F+ G$ N. O% w
}. W4 h- e* r1 U- e# w/ i2 U
'{$ElementUpgrade}', '{$ItemPierce}');");5 Y) E6 M w6 F) k0 L+ W0 h
}( M" l2 p- B* B7 w
6 p/ j* Y/ O2 i. O3 s/ i6 \}5 f0 N+ y- s: W2 |% p( J
6 K. x7 Z" h+ q& o0 P3 \, W}" y r/ U1 g! h
B7 A) f( X4 ^! n! l1 r/ O$InitForm = InitForm();0 k0 \% c. r5 B& H3 ~& R5 N: o
$Listener = PostListener();( [7 C" p3 ~+ P
4 O& u: B5 a: A9 V% y?>
/ D/ S3 [# I8 N- i# t1 `2 ~; @/ S/ `; s- [) x H5 ~
/ E+ S. O# Q' g# l- s2 g/ _4 w8 Y
3 t# x" r g+ u [9 o' q
" T5 R; X1 t! |0 \# z( k6 f: |2 ? |
|