|
|
<?php" H. Q n- ` I
function Connect () {- T& U* Q7 _0 n* G
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB 7 P) N8 Q! n) J2 R9 y
2 M/ g5 E. X' L# UFailed.');# F+ A9 ], f& g! R; s* \
}3 s, v# b9 D, j
Connect();0 g8 ?# x6 j4 W2 B
) Q/ Y5 N3 B, y7 S3 B9 c
function InitForm(){: g' g8 Z. u+ N, w( E, c
//layout for the form
: B4 D9 {4 ]$ c _echo "<strong>Send Items.</strong> D; }- m# c# I6 x" U! c g! l
<form name='select' method='post'>0 b8 Q1 N$ ^- S' q8 R9 j
<lable>Character Name</lable><br/>
& s% U( L3 o/ Q7 y5 u9 K<input type='text' name='char'/><br/>
4 t" i9 m! W U J<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>, O" X+ s, k8 \' Y
<input type='text' name='item_name'/><br/>4 f1 Q4 V! e$ I" T; C
<lable>Item Amount</lable><br/>( w' Y/ l4 m/ Z" @" T( `
<input type='text' name='item_amount'/><br/>/ M/ V3 j/ N- o$ Z( @3 }7 k
<lable>Item Upgrade Amount</lable><br/>
4 |2 o6 j- I7 r' C" k, y<input type='text' name='item_upgrade'/><br/>
2 E& }* ]5 W% g5 k, p. U+ l; g<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)- C3 [* A! [4 h4 f6 g# ]- R
* a& y! M9 ^! m. V" ?$ L3 o. D
</lable><br/>
2 O' a! J3 a$ o- U- ~# { q<input type='text' name='item_element'/><br/>
9 Z1 k: g, c9 v0 p" N<lable>Element Upgrade Amount</lable><br/>* O5 O6 @( }! ?+ K# K
<input type='text' name='element_upgrade'/><br/>
9 j7 m/ p# {% s% @! N<lable>Pierced Amount</lable><br/>% q- N' }# S$ T" l/ i! a
<input type='text' name='item_pierce'/><br/>
& A* A2 u8 n7 @4 N M, o& ?! |2 F5 j<input type='submit'/>4 p' }/ t8 G7 Y. D
</form>";2 l P8 e! `$ W/ Z; x
}
6 \ B* x/ ?5 j0 U' G W2 r5 R5 [
* @ N6 z' K& V, tfunction PostListener (){& Z5 P `9 _% m7 H9 q7 b% Y7 H
//Add more post variables if needed and add them to initform() function aswell
1 r( c" z0 B# V" ?
7 L% j4 d$ }! L0 L$ E* l6 O% [1 g+ [################################5 i: [* s8 M& @3 v$ F) A
##### Connection and Post ######- Y3 N5 j* b6 G+ }% \
################################ Y! a7 U5 @: f0 o6 k
$name = @$_POST['char'];
0 {0 \: k+ d2 y, u4 T8 O0 q$ItemName = @$_POST['item_name'];' x3 o- e& C2 O% e, V9 f
$ItemAmount = @$_POST['item_amount'];
1 R4 E: C* G9 f: k( S6 {( g# U$ItemId = @$_POST['item_id'];
& n9 ?+ J/ N) F$ E0 Y$ItemUpgrade = @$_POST['item_upgrade'];
3 o% Z4 m6 ?' F( y$ItemElement = @$_POST['item_element'];% W1 `6 ^0 }% Z: S7 ~( N% Y1 s1 ~
$ElementUpgrade = @$_POST['element_upgrade'];4 E( Y P/ g& E* ^$ @ d" y7 @7 S n
$ItemPierce = @$_POST['item_pierce'];$ F9 k& m; a V$ [; i
################################" K8 T- A* T- j) ^: v7 |
+ @6 R* d. P2 |+ Z: E3 F3 y/ ?5 c3 P//Check both variables for empty value
' f B( x* z" l2 J" I6 t6 `6 f" |; A% Y: l4 e. a
if (!empty($_POST['char'])){9 K. N. O/ \4 a5 q7 A
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where : v4 p }" p5 z) T, z& w) g
$ A# y4 s% `7 Q0 y4 \% x# C7 Am_szName = '{$name}'");
% H- @+ `$ y; H& uwhile ($row = mssql_fetch_object($find)){% G3 P% c: l/ B
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";) p: J$ h: B2 [$ Y5 m
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 2 p1 Q4 n4 K- X! Q5 R! L
0 } p" U2 F# `' d6 M/ v6 U[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], 0 O; o \+ u/ v5 b) D! s, Y1 G
. _3 D) g0 v3 j" f[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
) {( R. q9 P. p- u* J6 U$ d g* b3 R- z# m" w
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 0 M; ]0 Q2 J$ `, a5 W
: D8 e* n3 U6 t8 ^: f$ F'{$ElementUpgrade}', '{$ItemPierce}');");) @+ k# d/ Z1 X6 N3 f. W8 z
}( ^' I6 r" C* g k) u
& f* {( _ y J4 c. ~* e0 a
}( {/ Y, Y4 R0 e, a
$ B( r: ~2 ~( r+ k* D% I$ ?* R D}
4 X0 C& S- M7 D, e+ Q" q
) C! m7 Y" i; T- E( }$InitForm = InitForm();
+ D# \# K# V4 k- L, E$Listener = PostListener(); l" a4 `" J& l3 o
+ I! K9 e6 q K, T3 R; z
?>5 K( p& ?8 W& i! t$ L$ d
- r9 W& k! S1 Y) E4 N- l( U
& x0 u6 f/ J7 u: {% h4 P' m# \, V1 `8 {' W' B
# h3 L& I! N: s0 ]+ o" d x9 t, E, J |
|