|
|
<?php7 h# g4 T! L' k2 C6 U1 m; I
function Connect () {
8 f3 z* P4 Y$ V1 _mssql_connect('Server','UserName','Password') or die('Error: Connection to DB ! ^$ b0 I6 j" R- m; A4 [4 a6 G
6 B8 m+ m I! A* Y9 i
Failed.');+ _# d' U6 [1 ?: }7 ^4 d
}
2 [2 ]# i' p. y# v" O @Connect();% Q7 y# q8 ~; \7 B
( P) E& c# \& f: v bfunction InitForm(){- O6 ]* N2 k) K5 v1 `' J
//layout for the form
7 T b9 _' p) ]echo "<strong>Send Items.</strong>( N- A) }) q9 Z8 z i
<form name='select' method='post'>5 n# S! Q, J& s+ \/ J$ v, B
<lable>Character Name</lable><br/>
, o" ]8 J( h( Q0 Q A( P<input type='text' name='char'/><br/>' W" Z* @: ^, ^: n/ @) ], N9 V$ P
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
/ ~9 n: B' z, n0 e$ r9 t8 Z<input type='text' name='item_name'/><br/>
. C/ Z1 b+ l0 G% `! K: _2 I! R4 @<lable>Item Amount</lable><br/>% N, V) I5 i6 k5 P( \
<input type='text' name='item_amount'/><br/>0 _1 x3 g5 B; b% P/ a" F0 c6 e
<lable>Item Upgrade Amount</lable><br/>
+ E) Y9 v! p4 ` S! o/ B<input type='text' name='item_upgrade'/><br/>
" v7 x; g/ f: }7 r8 P9 V3 ^<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.). T! \" e$ |& b h0 C: o
5 q+ h w# H5 ~</lable><br/>
) y: w; Q2 P8 b<input type='text' name='item_element'/><br/>
& x2 e8 }, K* K( V<lable>Element Upgrade Amount</lable><br/>
$ h3 w' v, S4 x! ?6 s<input type='text' name='element_upgrade'/><br/>
8 w6 \5 z( M, h& n<lable>Pierced Amount</lable><br/>/ J. s# {( v8 ]7 p
<input type='text' name='item_pierce'/><br/>: O- r9 |& o7 W# z7 y
<input type='submit'/>. ^7 X9 L, M# `% E% `# Y& O
</form>";
' s7 E( n" _& ^# c}
; t9 @; ~: W1 H' q3 W* c( \7 j! g1 a8 L+ F- V
function PostListener (){7 _# \6 R/ Y6 Q7 s
//Add more post variables if needed and add them to initform() function aswell
, z* c+ e R+ j, }( o8 l" v' A5 a1 R% B8 \) u% _
################################
* @: t" l" ]7 {( ^: v& h+ @##### Connection and Post ######
& k+ v% v$ [$ x! u' R. j, {4 Z################################
f# M2 Z% y, k' Q( K$name = @$_POST['char'];
7 X! _. h0 E! a2 C1 w/ P/ w* U$ItemName = @$_POST['item_name'];" n: E& j$ k$ S+ n
$ItemAmount = @$_POST['item_amount'];
7 q. r- e( \9 u$ItemId = @$_POST['item_id'];
) J/ @6 p M8 T7 [3 i4 n$ItemUpgrade = @$_POST['item_upgrade'];
& P) w, {: m' o3 W7 a3 d$ItemElement = @$_POST['item_element'];0 o, C1 U2 [2 v" k% H! E9 W
$ElementUpgrade = @$_POST['element_upgrade'];
6 { x# q" c& h0 M3 H7 B5 \9 `& N9 H$ItemPierce = @$_POST['item_pierce'];
! @, k# u' T& @6 D, _################################. ?$ k9 J5 k' }; B
- W% D- b2 F# f5 s u# e" D B7 `) O//Check both variables for empty value
+ r% t; b6 z# j4 w8 b+ Q* @6 y+ S' j( [- i
if (!empty($_POST['char'])){
8 ^7 Q. f( V. m$ q4 M$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
4 G8 a; T/ y( c8 o* G- u. i6 `( ~5 {1 P n; _3 x% R
m_szName = '{$name}'");
& \' i) m( F" ?1 g: f0 e& Jwhile ($row = mssql_fetch_object($find)){
5 ]' G8 v# A. _echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";: q1 {8 _, U. o8 A p
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
1 e) c$ g4 o1 I. R2 g2 F
. [( e6 [, C! v9 d0 E[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], % G/ K5 ~1 f7 r- s, m `* P
7 V8 J. R" \ m b6 O5 m& p) W[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
. v R4 ]9 |) ~/ Q3 L9 U/ T$ {. H$ _
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', / {9 @; l2 _1 V" o! R2 E2 f
8 v* p$ D$ k7 |'{$ElementUpgrade}', '{$ItemPierce}');");3 R# T& Y3 e' b4 l% J% ?( f
}" z$ g! W. w0 L6 m
9 c& R) ~- ?# k) c5 q3 h; c
}
# ~2 v% m3 q& G- G1 q* O( H
& H6 a7 U# R+ G4 a$ r5 G+ F5 q}
, X5 \, g+ }7 }3 Z& g
) k5 {' J0 T L1 ~6 T" A! [2 |7 l7 r$InitForm = InitForm();
" D4 b. k" @# Z& t) U1 ~$ f; s$Listener = PostListener();5 K0 i& ~' k3 g# k" p( ]2 \0 r
2 Z$ S7 z) Z- D, t! m1 y% [
?>
" Y& i9 p4 ~/ x: O) \3 J3 K0 ?% E+ n/ P7 C4 x( k3 E5 H$ E
- g, b" _ k+ `* U3 v3 `: }# l8 T2 w( r
5 v) [) C6 d8 u5 U( O9 _
|
|