|
|
<?php
& `- ?' I8 Y2 l- ~( Wfunction Connect () {; `7 R5 I# M+ ]+ U+ W; ~( `1 |
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB + O }; u. B9 b/ U6 T2 |
' B* I8 q% }- ^, R% l( i
Failed.');
2 s, n8 h/ b9 t0 f( c}
$ O& _0 e+ m/ j9 x" Z N* a9 VConnect();
) w& S/ p D$ [; W5 E% L1 o. ~1 I6 I" A1 }
function InitForm(){, t- h# k7 X/ X% W
//layout for the form
: d1 j( H' y- B( O7 ]/ ]echo "<strong>Send Items.</strong>
( u7 c6 I, F' L+ W+ [7 J8 t* e<form name='select' method='post'>2 ]! z$ K* X8 g6 A5 W B
<lable>Character Name</lable><br/> a6 t7 _: p- V
<input type='text' name='char'/><br/>
$ N6 Y4 d3 j# v) I<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>3 r( e$ W0 V* O9 Y; u. U" e
<input type='text' name='item_name'/><br/>
: i' S* y7 R i( a" l<lable>Item Amount</lable><br/>
& \+ G' b" }7 J( i/ ~<input type='text' name='item_amount'/><br/>
. o5 U! e7 U+ U/ x<lable>Item Upgrade Amount</lable><br/>; \4 L+ p7 D+ l
<input type='text' name='item_upgrade'/><br/># Z% {9 u5 ~/ n5 E4 ]
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)2 g; K' T% ~- T T
1 {( b' f2 j3 O8 w y* |
</lable><br/>( t% d. R( w- A' {3 a# [
<input type='text' name='item_element'/><br/>. ]1 t9 V9 l) M6 z% B2 a
<lable>Element Upgrade Amount</lable><br/>$ g) m& C- ^: s1 j
<input type='text' name='element_upgrade'/><br/>
# B5 {& i# Y0 L0 i- G0 C<lable>Pierced Amount</lable><br/>) l5 ]$ ^# B. r2 b4 Y9 A8 U4 Q
<input type='text' name='item_pierce'/><br/>% h! ~1 @. A( ]$ L
<input type='submit'/>
5 M8 n; g+ P- D. u3 b! L& j</form>";5 b$ O; l" c& O* E% h" i- a0 k
}
6 [ K! B/ j4 l/ ?3 n, h$ L) @3 d1 \; r0 r
function PostListener (){9 L* K8 \' [; ^$ S, z1 }8 W
//Add more post variables if needed and add them to initform() function aswell
, J) @+ g( \7 B$ b6 _/ S# o* e: k: ?4 W' b; R; e% K
################################
3 W7 c: m3 [2 U4 I4 _1 w6 R. ^##### Connection and Post ######
! b% L- k! n$ R6 w% ~0 _6 h( W################################' }$ k$ F9 _" |0 g/ P( j: \8 l
$name = @$_POST['char'];+ f. J9 R! U. Y) b0 w1 ~" l @
$ItemName = @$_POST['item_name'];
" u/ X7 Q% C% ] g T$ItemAmount = @$_POST['item_amount'];" Q" G2 u/ W! l# `! R# I- }
$ItemId = @$_POST['item_id'];
4 V/ n8 F. _! `. e M5 ~. H$ItemUpgrade = @$_POST['item_upgrade'];/ r3 S: e: ~% w6 `6 w, V; D
$ItemElement = @$_POST['item_element'];# x8 S, P* N9 X/ Q
$ElementUpgrade = @$_POST['element_upgrade'];
$ F2 }( n' Q/ V2 _$ItemPierce = @$_POST['item_pierce'];
. d9 L+ L$ A# z: a; W7 f9 T4 H$ Q################################
4 f$ Q( b, L% _0 G$ |* \- K1 C% g
3 ?1 k4 C3 @ i; d3 i0 o' _- P//Check both variables for empty value# @2 e8 P' `2 `4 g: d# w$ w
: K/ J3 a: S' y8 I8 r; L7 b! mif (!empty($_POST['char'])){" l5 L! ^5 K$ q& n% a
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where / P$ B# k2 r4 ~7 @ x5 L
# `7 q( N9 g% \" q `8 tm_szName = '{$name}'");5 L6 S! C* g, W0 a/ e
while ($row = mssql_fetch_object($find)){' @# a# @$ V! e3 p
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
9 `8 R5 P2 W* ~0 p$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], + H* O! p( B8 I& V0 l2 n
8 `( b# X% p+ O# ?) O
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], 1 N- s! u; @$ x7 g% ]$ L9 R
- }8 k5 t& y, ]% U. `
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', # G1 U% H" r' v4 G
3 k. n/ L; n( p) h. {( U7 fN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', $ b7 I6 f# Z% ]4 G" L
. n% V- \ s8 M1 T/ [" ^
'{$ElementUpgrade}', '{$ItemPierce}');");
9 @. U6 y, Q: Q) j( f& _% E( p$ m}) ]3 t8 S" C. n" E& D' H- }( [, E5 Y
T2 C- p9 O M6 h}! G7 |; A7 N( b8 P9 j" \0 K
: h! X% q+ X/ K- u
}3 W2 W& i# T) } B/ j' Z
7 [7 h/ l3 [$ u1 l( {* \) T
$InitForm = InitForm();& c* Y( P4 p1 L3 @( v! o
$Listener = PostListener();
, t# q& O8 B+ f. p
, n- ?8 w5 J% v U7 T6 k- \6 h?>
9 U- D! E0 ]2 u- N
. d* u' I0 O! L* `2 m* e4 j) J" g
8 h) f! a0 @/ S8 f. d
6 Q$ r$ x8 _5 Z6 W4 E! x' t |
|