|
|
<?php
6 `+ F$ ^) V5 s) y1 c6 I/ Z1 ?3 ?function Connect () {
# t. K! y2 x7 W8 Z( imssql_connect('Server','UserName','Password') or die('Error: Connection to DB
8 S7 E+ i' W0 s p( t3 d
- p' ^: U c' H. e4 a [/ wFailed.');
4 |% c" l$ J1 T# F+ w! I1 U}. w0 M' T% V4 { E, ~8 H6 I' w5 I
Connect();: l# J3 P2 w( p9 o
2 w4 o r1 g: }
function InitForm(){* k* L2 I9 T+ `
//layout for the form
# z% y# s7 v7 _( _( O) K! Qecho "<strong>Send Items.</strong>2 h/ ^9 q" H0 L+ O
<form name='select' method='post'> p3 B# {% a9 r" i4 L- J% @9 o
<lable>Character Name</lable><br/>
! T' C& ^! S; W: l( v G. h7 G<input type='text' name='char'/><br/>
* p, O& }8 Q p, O. P7 _' l<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>, n- V6 \% D% R! K% T* \( {8 T8 Q% u
<input type='text' name='item_name'/><br/>
( t# }" G) U' U: V<lable>Item Amount</lable><br/>! m! g7 V' i. s3 ~ b! ?0 O
<input type='text' name='item_amount'/><br/>
4 y: s+ M% d7 f ~3 E; i<lable>Item Upgrade Amount</lable><br/>! ?) E) i P- T/ {3 C
<input type='text' name='item_upgrade'/><br/>
: F2 `+ C3 v" k! W' O6 s% t<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
# z6 ~7 B7 C0 Y, t( u) T5 A l3 ~ b
</lable><br/>
4 e8 Z m" r! o4 Q6 z& x0 C& M<input type='text' name='item_element'/><br/>
7 `3 d& M8 h0 b% j& C<lable>Element Upgrade Amount</lable><br/>
( G3 |# L% T6 e5 \" N6 X<input type='text' name='element_upgrade'/><br/>, i/ U2 h/ D2 O. M
<lable>Pierced Amount</lable><br/>5 \* _! q' R! m' T
<input type='text' name='item_pierce'/><br/>
; R. D2 K. j* s& q! a( |( x8 \<input type='submit'/>) Z+ J1 k O* A0 Z
</form>";
; v2 j$ m2 `# n1 z/ r8 P}
' m8 J9 {5 c" F8 I1 z* |# U$ X% o5 v& { y- F& V: U5 R( q
function PostListener (){
& N) V+ }9 K$ `2 k Y$ y. v* A# ^3 A//Add more post variables if needed and add them to initform() function aswell- p; o% L; n0 C2 S% t
9 P1 F7 E" q; z$ i) L, n, C7 w# s6 H
################################
3 O+ f" ?3 e6 x1 D7 e5 b, c##### Connection and Post ######! A. t Y1 l/ ^( V
################################" N" c3 o- T C9 F# {7 f$ k3 N
$name = @$_POST['char'];8 ?) w: N3 h. o! b) w
$ItemName = @$_POST['item_name'];2 E' u$ A. `; R, U0 J
$ItemAmount = @$_POST['item_amount'];' b9 [# z! F0 Z5 W' T# J9 ~* y
$ItemId = @$_POST['item_id'];+ C9 M+ x6 p3 c1 {0 z
$ItemUpgrade = @$_POST['item_upgrade'];
8 D/ S2 N. d, r5 ] V( g6 a) G4 r$ItemElement = @$_POST['item_element'];; L7 e2 h' ?& x: e" W$ o! o
$ElementUpgrade = @$_POST['element_upgrade'];3 d) y* l/ E U0 O
$ItemPierce = @$_POST['item_pierce'];
* m7 ]$ s- j& L+ Y################################; G) P7 j7 \4 a6 }) F0 b6 E
' J' k, e- g! H//Check both variables for empty value
& i i- O) e6 C+ k# b/ \) ?
4 V: y7 ]: D @! n" dif (!empty($_POST['char'])){
" k3 C+ x' f( E7 g& ^2 V: n$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where 7 V" E0 ?! Y2 t; M% A4 a& v5 b
8 u: ^* b3 J% [. Tm_szName = '{$name}'");" v$ d, E: E; T& u3 N( g$ w
while ($row = mssql_fetch_object($find)){' I/ p' P( @+ z, t6 O
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";! K1 l: j2 r8 N; g# T. Q
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
# F. [$ \9 g. n7 t: y: j7 }" I7 I( t- k: v! c
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], * z& g& R7 d+ G% ]. {
( ~4 P p, ~. p$ g, n9 {8 N
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', ) i0 ~, [1 R: b, _% N/ i! h
: ^2 K1 ?' K' ` ?5 Y
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 3 n+ Z& s e' h
8 o, J5 s; g3 j$ @+ X; q2 R R'{$ElementUpgrade}', '{$ItemPierce}');");
. v- R; E( H a* X: b. }& j2 N}
) W: e1 G+ }4 X; p% s2 a# o' M- \" i% P" W0 \- }- M* e
}! @' o* c5 \7 S7 C
# {# ?# I% I6 m: |
}. V/ |. z P8 E; o$ H( t' g
/ [ n4 E8 e/ ^( S+ x1 B) X. m
$InitForm = InitForm();, C" _4 G m% x+ V
$Listener = PostListener();1 n( f! ]- n: H Q% W
# n6 s4 w4 ?* p: u& @( a
?>' g$ ~) {. \8 x( c6 i4 T& _
( _# O9 k, `3 F. o9 r/ o/ j7 N( S( m. R) R
. t- P3 j2 K& l, L
9 X, J" N( s. p( K* m" W9 I |
|