|
|
<?php
& ?( S$ N8 N' U3 S0 f, i- @5 Hfunction Connect () {
' h0 ]" w9 q: u7 k" E2 Z: `mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
8 b" A6 G: _# y) h& E+ ~1 m) n! O& R9 c ^
Failed.');, b$ N- r: y( |% G3 a
}1 D9 G( N o$ j! }. H1 d
Connect(); ~6 L( _3 {1 z
) U3 U h0 A$ e# M" mfunction InitForm(){/ H- m4 D3 D ~& o& q7 S
//layout for the form
* q' f$ x. N5 h7 B( k( u5 w) e1 kecho "<strong>Send Items.</strong>
. ~. L- ~1 t3 ?( g8 g<form name='select' method='post'>
1 U* N8 h2 E9 h2 m+ q& z1 c M- k<lable>Character Name</lable><br/>5 e7 G1 {" Q" M7 p! g: U$ L% f; W" l
<input type='text' name='char'/><br/>
. h, \& c' l. } W<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
/ p. x, ~" Z0 w/ p<input type='text' name='item_name'/><br/>
' |1 K- \6 d. z3 a# x. P<lable>Item Amount</lable><br/>
, Z/ L8 j9 w) V( i4 o<input type='text' name='item_amount'/><br/>
7 ~- m3 F. J8 C' `! n) q<lable>Item Upgrade Amount</lable><br/>
0 D( f( X8 s' L& _' U) s/ L4 [<input type='text' name='item_upgrade'/><br/>
/ [+ d4 D3 o/ R }( D<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
% J# m* O, F. I6 a
7 @) B/ N( d* n5 D</lable><br/>6 }$ c: K, U; K' ]4 ~' ]6 O" G2 w. d
<input type='text' name='item_element'/><br/>, m2 e! n6 W. S# |$ a i
<lable>Element Upgrade Amount</lable><br/>0 x$ p3 q' D3 b P: x. d
<input type='text' name='element_upgrade'/><br/>
/ j( q H+ y% l3 T/ @$ q<lable>Pierced Amount</lable><br/>
; R$ b0 i4 ?0 j# Q9 m' _<input type='text' name='item_pierce'/><br/>; n( e9 v" X: p1 a
<input type='submit'/>
' Q- E3 C" @8 F' p v1 Z* H</form>";
* [8 R8 {" Y' b6 [" g6 j8 h* Q}
1 N0 i% h; R3 b) k8 }3 m# [; E" @1 t- y$ A- ?8 I
function PostListener (){
9 L: Z1 Q" g7 ?' T//Add more post variables if needed and add them to initform() function aswell- C* k0 b. m t, g3 B# H6 |
* q. j: Y( ]5 B" t! `1 X
################################' b& ?+ A) u# N/ b" R# e; r( U; x
##### Connection and Post ######
8 v% x" z# C- q% V- @3 R9 j) i################################- _# U7 y4 k9 Y3 R/ K: j- s+ W4 s
$name = @$_POST['char'];
+ _# X+ i) v$ h# r1 n" ^+ ?) R$ItemName = @$_POST['item_name'];
* W9 f1 P3 _" o& x9 r$ItemAmount = @$_POST['item_amount'];$ C1 W! f1 d* }, L! m. l
$ItemId = @$_POST['item_id'];$ @; d6 c9 E$ t+ Y
$ItemUpgrade = @$_POST['item_upgrade'];
1 a! {+ m2 c. J& i. m$ItemElement = @$_POST['item_element'];4 A4 @( O u/ K- E9 ~! L' I
$ElementUpgrade = @$_POST['element_upgrade'];
; p/ Y& c) h0 l% W2 N* P$ItemPierce = @$_POST['item_pierce'];9 D3 k( `- I# Z
################################" ?& P+ ]5 b) z: P+ `4 [
& H8 g1 {- }- ^2 N5 M9 l" q
//Check both variables for empty value/ B6 \0 ^0 n. c0 M
# w8 d' N# _ i+ N
if (!empty($_POST['char'])){
" x/ o$ ~5 `7 m- I2 C$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where ) L) }9 K/ ~" o; D" ?' ]1 T
$ ~/ ?& z; e, x% l
m_szName = '{$name}'");
1 i4 W$ z2 W6 ^! Z6 q; h" x uwhile ($row = mssql_fetch_object($find)){% k8 w0 w- {% h
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";: a C- Y: n6 o. B5 P. E
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
M" H7 t+ o& ~
/ ~7 I l2 @. O2 y# C7 g[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
% ?, Y ~/ _9 \8 s3 o! p( x( e; s; N; H, h! G1 } ]
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', ( D6 \# R* W. Y+ z2 i+ p
. e8 S2 H9 p: Q! Z+ x
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', * ~6 c& ], t) [. }4 b
" S# e8 u M! s- d- S
'{$ElementUpgrade}', '{$ItemPierce}');");
1 l$ U' K# f8 a" }}
7 W% Y q/ b5 ]- u# h- [
- }2 M( d, T9 j4 Q# s$ u; r}/ Q( \! {7 _2 N( ]0 W" ?/ V7 \2 W8 I
- {3 _ v/ G6 z/ l) W( y2 g}
b" I! q3 ^% n! m H
) ~# @0 Z3 V& \& e* q: b2 T$InitForm = InitForm();& l1 D+ A# Q2 _0 e0 \
$Listener = PostListener();
. w/ |. ~& c7 C. q
~$ Q/ ?) |* _" N. b# u?>4 l7 m# t! L2 N8 o# `7 S
H2 q5 z: n( x1 L) ~* |" o$ c# O8 Q
) @' j8 U0 _8 L0 `7 u8 B6 n9 ^
0 P1 |, v9 T) d& s
! [6 z' a6 \0 V: `( { |
|