|
|
<?php1 \: F# h9 F# n. d
function Connect () {
6 a! R- `! w# O2 H( _* Z$ rmssql_connect('Server','UserName','Password') or die('Error: Connection to DB 2 X! @& A8 U6 y1 p/ j; ^4 h' h( D
2 Y' x1 e% ^9 O9 } W2 }
Failed.');
( i( ~. L9 l/ i/ @}
/ b% W3 a1 Y4 jConnect();
9 b t9 R5 B# Y- y/ `8 Y/ u
% Q% o6 u. P, Q9 ~ k& [* I- bfunction InitForm(){1 l$ J' v- g: V0 @
//layout for the form' Z8 _3 X# j% M& X2 x$ E% ~4 p
echo "<strong>Send Items.</strong>" \7 W _# \! g: Y
<form name='select' method='post'>
. ]3 _$ ]/ }0 F0 f5 j0 |$ S<lable>Character Name</lable><br/>; F6 ?' }' Z$ z" G2 O) p, Q
<input type='text' name='char'/><br/>; R2 X" i! e G, _- x" W
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>& m! O$ @( R! x+ I8 ?9 j G
<input type='text' name='item_name'/><br/>* l9 }! h6 K0 h0 Y" r; m
<lable>Item Amount</lable><br/>
/ i+ Q1 t) G5 T; ]+ `1 ` X; Z/ p<input type='text' name='item_amount'/><br/>0 u% D" B8 M) S7 p5 r% p/ U
<lable>Item Upgrade Amount</lable><br/>9 r; e1 m v0 W' G: a! V D$ i+ U
<input type='text' name='item_upgrade'/><br/>5 i* v$ j2 n0 ?" r/ h: ?
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
: ]2 @; B# J7 t3 B8 v6 j! T
% Y8 `3 \+ d9 h, j" M</lable><br/>
6 x. o1 Z- C1 r8 N2 G" X<input type='text' name='item_element'/><br/>3 h% ^7 e# _( v6 }! u4 y# w+ B0 ^9 I3 }
<lable>Element Upgrade Amount</lable><br/>
* N0 M5 B1 p. s+ _3 `% w<input type='text' name='element_upgrade'/><br/> l. s0 T) P+ \
<lable>Pierced Amount</lable><br/>+ D% V) g0 Y! j- y1 W% D
<input type='text' name='item_pierce'/><br/>
! G7 X7 D& b5 d G: F% E<input type='submit'/>
. e& ]2 h5 M" [9 l</form>";, c4 O4 A X" t. ~/ x" f% s$ o1 P( r
}0 _: f" y p& s g E) e* e
" {0 a9 `* B. Q" k; @' [9 Xfunction PostListener (){6 W4 @0 F. s- t$ I
//Add more post variables if needed and add them to initform() function aswell
; H8 M' S- V% u) b2 W+ W5 ]! n* K
################################+ ]: f& d3 X s/ T
##### Connection and Post ######
% h9 ^) t- u5 n) z& d################################1 ]0 l5 }6 W0 \, k d9 g
$name = @$_POST['char'];& T# B$ S. A- d& J; Z: V! {
$ItemName = @$_POST['item_name'];$ s# i. n( H( c. E% \8 v3 V
$ItemAmount = @$_POST['item_amount'];7 z. A; }* A- Y& s: Y$ d
$ItemId = @$_POST['item_id'];
3 f6 q1 w3 E; G$ItemUpgrade = @$_POST['item_upgrade'];9 P c& q, A/ ]# e2 H
$ItemElement = @$_POST['item_element'];
' t* j' C4 U T$ElementUpgrade = @$_POST['element_upgrade'];; x1 P5 F; g8 i7 ?7 u% l1 I
$ItemPierce = @$_POST['item_pierce'];
* ` l. ]' i2 k& c% k( D9 r- ?################################/ m7 L; v& d- t5 R! h/ s* | _
. s8 {4 x/ [, h s- }$ D//Check both variables for empty value
( r1 f* ]( Z! z# N% z
, ~- [& m- A) F1 Jif (!empty($_POST['char'])){2 Q8 v6 U! P& X. n! r- Y2 @
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
: m4 Z# G, x$ c
0 v9 ]. g) [: @m_szName = '{$name}'");) T( W4 T/ K- s n4 S6 }
while ($row = mssql_fetch_object($find)){
! Y. b5 ]/ |% X" Lecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
2 A3 J! |" @! w$ v, F3 Z. _' x$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
) m' b; P* s5 q8 t2 @4 v Y
1 K' U& u0 h* v6 k- c[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], $ U. z( h: q* A3 O; c
! F+ `& w3 s# u$ h! t: S m% [
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
; Z2 X- y- |( L/ F2 n2 g) ]/ W) ~$ N: _* {' U
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', / n# C9 B" c( I6 {
7 z, T8 e8 ]: [/ ~* P! M: [2 @" ?; c'{$ElementUpgrade}', '{$ItemPierce}');");
2 } A- @' n! N9 u* M+ d' u}5 o$ [2 [3 f: i8 B! a' [9 x9 ]
" Y4 o7 A9 [1 ~# |}
& B' T3 U$ C% J- ^& s: [: \% `& G$ h$ e1 _/ l
}
! y) q$ C' J: d$ {* y
" d. S( R& {# [) K$InitForm = InitForm();
4 \: J/ y2 S& ?. S$Listener = PostListener();9 s; `$ q* O, k
. Z+ A0 h& l, ?5 C! \
?>
1 s; v+ u) l P! J
& K# I% q; m, S9 M7 J2 o+ x& }5 T) B* J. z3 h$ G) O3 C: E$ B
9 g* g8 B# a5 ^5 g K( m1 k
1 |; x8 |9 Z4 b- I) B& E |
|