|
|
<?php
, q" G: n9 z/ G5 W. _function Connect () {+ T) t$ L( X' M: F5 H
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
! f6 {: k, e- Q9 G4 ^: t2 Y2 P1 M8 P% E5 L
Failed.');
% M: I% k0 R% J}
* i2 i: m" f* {( \Connect();8 t3 r _- o2 f% {& p) E2 S9 T
4 q5 f% s1 |; \8 ifunction InitForm(){
7 E) x8 V$ U, P" Q//layout for the form
" M" r* u8 R! L4 ]2 ~) Z- Techo "<strong>Send Items.</strong>+ m4 ^4 d7 i) `+ Q, S* o
<form name='select' method='post'>! @: b( O) j4 j3 E
<lable>Character Name</lable><br/>0 ~! k7 Z/ O; Q4 @
<input type='text' name='char'/><br/>6 P' p8 ~/ L5 j% }
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>1 G5 D0 C2 _: z: x* Z
<input type='text' name='item_name'/><br/>" R+ L2 j' }- A) f$ i& N
<lable>Item Amount</lable><br/>: G7 O( N6 ?' m2 s( }1 P
<input type='text' name='item_amount'/><br/>4 t! F9 T9 h( @( r7 N
<lable>Item Upgrade Amount</lable><br/>5 o3 a; S) f! C0 y( E. ?) x) e
<input type='text' name='item_upgrade'/><br/>( W, {6 }& a" @. Q) m7 |# H: U
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)4 Y) N! U" m# }& i. C! ^
c/ N7 U" C1 L</lable><br/>
2 ]. v$ i( x4 G2 t, i<input type='text' name='item_element'/><br/># v* j2 T$ D1 R8 K: f- ]: u3 M% ?/ S. v
<lable>Element Upgrade Amount</lable><br/>
4 V7 c) U' W+ |5 {<input type='text' name='element_upgrade'/><br/>
7 ]+ `3 B! Y6 S8 v* X<lable>Pierced Amount</lable><br/>+ @9 p, w$ k+ j( x0 t9 h: n9 V1 k& Q
<input type='text' name='item_pierce'/><br/>
- T1 S- j1 x6 ]- [' a/ s; ^<input type='submit'/>& P. l% C, ^' N- K
</form>";
: x, n5 R/ p9 i}
/ ?: f- s; e" O8 v
1 P- R# \3 c$ r }( h0 e- Gfunction PostListener (){& q9 [6 a4 J& G
//Add more post variables if needed and add them to initform() function aswell2 D) j. z3 m. J
0 K A- Y3 D! h9 ?5 @3 j, ~
################################# N) Z: j& ?$ z* W- l
##### Connection and Post ######. J! z" M( L( J9 F5 B3 R% l) ~
################################
7 l. b2 n) g; K! A/ n$name = @$_POST['char'];6 S( e2 A! i! g* z5 d. e
$ItemName = @$_POST['item_name']; x& E4 [ f6 r7 X4 V0 `1 f
$ItemAmount = @$_POST['item_amount'];
) D4 _( s9 W; o: c$ D+ v$ItemId = @$_POST['item_id'];
! V7 J O, y! b% V6 e$ItemUpgrade = @$_POST['item_upgrade'];
9 \+ M' U% T3 J; t& n9 ^$ItemElement = @$_POST['item_element'];
/ b: z$ @$ T# J: }" W+ N* s/ ?$ElementUpgrade = @$_POST['element_upgrade'];
9 a8 L8 ]/ F+ B) }* z2 j; A0 _$ItemPierce = @$_POST['item_pierce'];) R5 s/ g3 R: u0 h( a
################################
* P8 d& i X# Q) D) d! {# z$ @' y$ B: ^) r& M5 f! p; e
//Check both variables for empty value8 p. \4 r5 m F$ I4 \
) s) O/ g- A6 r; k: C" n& ^
if (!empty($_POST['char'])){1 U6 G7 O! N" t) b% k
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
+ V) F0 ]& N- M- ^
z0 a8 R: b7 c. ?* v6 m3 R. im_szName = '{$name}'");
# E$ |% @! X6 U6 O8 x9 t, Zwhile ($row = mssql_fetch_object($find)){* }2 C0 a8 F+ j9 p/ m
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";2 `" I* a9 g* T( [5 S3 s
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 7 j! P* c2 Y/ w3 g* H
. s; I1 [( f# Y: X% m[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
/ U8 K1 y/ h7 j
( C9 I+ p# H. t% g+ ]$ J[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', ; ~0 M( q9 d! C2 X3 q
& t- j$ r- H2 y) UN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 0 G- y F" _3 \8 a. G2 N% E, X1 D
1 X, Z. K4 U. b& L% X) x7 @ t( ]5 o'{$ElementUpgrade}', '{$ItemPierce}');");
2 b) Z3 b( b$ E" z0 E}$ K2 Q4 J- q" H$ s# ~
7 Y1 O! k( u0 K* S4 R( z}
3 l H3 L$ b9 C/ d( S% {$ A3 M
; f% b2 O2 c+ w$ U+ ^2 I}
, ?& q: H' ^4 S* v; W5 e
9 g' O) v# u# M! z9 X) `$InitForm = InitForm();
1 Q2 A: j3 R4 i+ Z$Listener = PostListener();! O; |2 D3 O$ d4 w0 ?1 e5 Y
8 l v+ }! G- a5 N?>2 k1 P M) k" H" ]
O; ^& R# J! i) s5 e5 Q* j1 C
( _7 X5 H4 p8 P
( d9 R- \! P& d9 o+ g
# M" \/ C! X1 D
|
|