|
|
<?php7 `$ X$ N9 G1 n3 e! j+ @
function Connect () {
8 b9 P# i! b6 }mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
5 V& G/ y5 A7 F& y+ G& B- ?2 n! k( t2 j
Failed.');
0 K; k1 z4 ]& n}
- N# Q& S9 `0 h4 p+ [5 RConnect();
/ R: B3 i& |3 c9 p% s; |6 P
; C+ Y1 M$ G+ Z1 Rfunction InitForm(){
1 E% I$ p" Z- a, I4 ]/ g) `//layout for the form
2 q4 p6 [/ }# _ g; Q2 i9 |echo "<strong>Send Items.</strong>+ E. C7 z/ S& q8 B+ z
<form name='select' method='post'>$ [1 S' c- R" t4 K' z6 J- |& I- y
<lable>Character Name</lable><br/>, f: C! D% b, k1 v
<input type='text' name='char'/><br/>
" F- W: z- o4 R* }- t+ z2 a4 `<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>, X6 C6 o$ X1 i0 s' x
<input type='text' name='item_name'/><br/>
* @5 Z0 h( C j' |, R0 e<lable>Item Amount</lable><br/>
2 ~. `& O( s1 P4 X<input type='text' name='item_amount'/><br/>& A! e! K9 l/ e) x7 L( z3 ~
<lable>Item Upgrade Amount</lable><br/>* E* z# T3 B/ H* h, r$ j
<input type='text' name='item_upgrade'/><br/>
5 O: z7 W! J4 f% O. \$ L<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.); b: k( j( G% l0 N7 i& n* S9 ?
. p7 R! O- w3 Q5 v" `* a</lable><br/># j! T4 p1 h. z. @% ? X
<input type='text' name='item_element'/><br/>0 w( \) C) h2 j% K3 M
<lable>Element Upgrade Amount</lable><br/>5 `+ M- t. W& _3 ^
<input type='text' name='element_upgrade'/><br/>
4 }# L* e8 j& M- f& `% `9 F5 D4 c<lable>Pierced Amount</lable><br/>& D8 S& L! e9 c, F$ I, z
<input type='text' name='item_pierce'/><br/>
0 [+ p( h- m1 @7 W, @( t3 \<input type='submit'/>
$ N6 b+ z9 c9 l* v: W3 Y3 Z1 [</form>";
; v1 O% S, e7 N5 N}/ O8 E. ?8 q" {
! u$ p' @, r9 ~0 s/ h
function PostListener (){ N" ~7 _: S R/ Z
//Add more post variables if needed and add them to initform() function aswell. {6 P9 |( s4 J
- j8 l. t# t. `! b################################
' z v! u# v& G' D##### Connection and Post ####### E; N- C' N& N- g
################################
/ |5 T) v; Q4 U8 o* _2 U$name = @$_POST['char'];
7 h2 n! h5 E1 n1 P7 r: K$ItemName = @$_POST['item_name'];
7 d9 _ z. U X5 ^$ItemAmount = @$_POST['item_amount'];
8 y# y/ t9 x* M, J7 g0 x$ItemId = @$_POST['item_id'];7 ]$ \' i5 |) V/ U
$ItemUpgrade = @$_POST['item_upgrade'];4 p- [. h+ ^+ D, G+ z6 {7 C. t
$ItemElement = @$_POST['item_element'];' {6 C' U8 W. p" ]
$ElementUpgrade = @$_POST['element_upgrade'];
5 e, i* X+ G; j/ q6 g3 `4 [$ItemPierce = @$_POST['item_pierce'];5 } {6 Y6 m7 K
################################/ ^( \$ l( t7 }/ Z
, h1 z4 i6 _! u2 d/ m
//Check both variables for empty value0 ~" `' G6 m# ]% a9 q
$ Z' t3 U) l1 u1 Q$ {. \# Xif (!empty($_POST['char'])){
- s, T- h# c, h$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
1 T: U5 _- f0 g4 {4 i* G/ Y+ o! y) i" k3 U- Y( F4 Q" E" |- b
m_szName = '{$name}'");
$ B- J( V) b$ b% T! ]while ($row = mssql_fetch_object($find)){
. n/ T8 Y, {1 ]0 c( V1 Jecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";# C. m9 ?# a- u( _$ g
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 6 q) V5 p$ Z! P7 e( W; x
- E j4 y% i3 k. u, ~: d7 I
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], h' G, E' ^2 D7 ~' G# i1 T
+ z. x; P2 [) t" @/ ~8 D, J) m
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 1 H4 z3 ]2 M( G) w
$ |8 y. }# v6 V4 Z8 P! I. o
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
, K7 b! A3 U' ~6 ~ ~ c9 v Q8 L3 f7 X6 a
'{$ElementUpgrade}', '{$ItemPierce}');");
% t5 T! q. H/ F}
8 u, W& a/ r9 e$ D( A
4 L, i& T( D5 i# p- \& B% f}! L/ `& x1 H& B ]+ r7 ^9 C
- [9 p$ X) ^4 l
}
. Y0 @$ {0 p" A( [9 j1 m0 z) Q1 T
3 l* q/ g* l( f8 h |$InitForm = InitForm();
& I$ E8 `/ [8 h1 L$Listener = PostListener();
& \3 f$ V* Z4 f% W
; f7 w3 k1 Q* h S9 n$ a# s6 P?>
: L$ x8 v/ ^0 D5 e
, H3 X# r$ h. d o+ h# l1 G8 S7 e
7 S2 J0 k4 l2 b
2 T! t4 F% H; ?" A8 @8 n) V
! o7 Y0 [, b, w9 C |
|