|
|
<?php
. l4 j2 _+ P i# ^( o5 L5 Mfunction Connect () {
" r! f! Q- f4 {# L0 Omssql_connect('Server','UserName','Password') or die('Error: Connection to DB
6 r2 h" m( P6 W# G5 L4 f( j) y/ Q8 D' l
Failed.');% E9 Z. @! N g8 R8 ~
}
5 Q4 y- g+ e" r0 j) EConnect();
/ b' I( P, G- M" s* x( w( d, s, a& O
function InitForm(){
8 h6 {( w$ U v8 j4 ^* w//layout for the form+ }* o1 t* l9 T, a( U% Z2 z5 j
echo "<strong>Send Items.</strong>
H8 O: O( F8 J" s<form name='select' method='post'>; j4 N- D% m1 D7 u. N' A
<lable>Character Name</lable><br/>
0 C" I' k' k% |, C C# J/ L<input type='text' name='char'/><br/>
7 U9 l7 v9 e4 q) ?# T# b; @<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>' m* b/ {' e* |+ U" M% v, Q6 h
<input type='text' name='item_name'/><br/>
4 m- \0 z5 u' {7 e<lable>Item Amount</lable><br/>
6 h& X4 g8 K) {4 Y<input type='text' name='item_amount'/><br/>
0 c3 N. }( D2 g% t5 Y: W( P% j& q<lable>Item Upgrade Amount</lable><br/>; v/ b# L9 g5 x, I+ x
<input type='text' name='item_upgrade'/><br/>
0 b: Q0 a- O6 V& p6 S! p: E. e<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
4 _9 }0 u* d4 ^+ e& D8 r
% d$ B( A8 e/ q( O+ @3 x( O4 T</lable><br/>" k0 m2 [ S6 _+ J# b* y: t
<input type='text' name='item_element'/><br/>
& s$ t+ o- Q0 N- K6 P<lable>Element Upgrade Amount</lable><br/>
; Q O1 w0 T+ k) X2 J9 L<input type='text' name='element_upgrade'/><br/>0 S; L) P% e! @1 @: C4 f
<lable>Pierced Amount</lable><br/>
9 ] G2 L; ^& w% V* x! j: V P<input type='text' name='item_pierce'/><br/>
% C {" a f& N' l* D" q<input type='submit'/>
$ [( ^7 p0 l1 A# I' ~6 y</form>";
0 t* i& G( m# j' o" l" \}/ [, R2 ~2 J1 ?4 ? ]3 R
$ L+ d3 e+ V) k( `- j. `, h. }
function PostListener (){
" K3 A1 O. m2 c* B) ^, V8 v2 f# M//Add more post variables if needed and add them to initform() function aswell$ P7 V# }: o' X! @5 L
- `3 [7 H5 E4 _1 X8 H
################################4 k( k: T% y" m' m
##### Connection and Post ######
* Q: f" k8 I, |& T+ r8 Z################################8 |9 q- V8 l0 T8 x+ l+ K0 d% a% E
$name = @$_POST['char'];2 B! W) L/ v( c$ G
$ItemName = @$_POST['item_name'];- ]5 Q% n& X" x' x
$ItemAmount = @$_POST['item_amount'];
) u) M8 o/ p8 L+ f; V) M$ItemId = @$_POST['item_id'];
# ~0 q( w# f/ Y$ `' u& Z- p2 u, m0 |$ItemUpgrade = @$_POST['item_upgrade'];
, C1 M' W2 a$ d& L+ l% Q$ItemElement = @$_POST['item_element'];/ {& ~( i- r. q8 A' H1 A
$ElementUpgrade = @$_POST['element_upgrade'];7 \# E; ]: I/ b$ w# ^" a f
$ItemPierce = @$_POST['item_pierce'];% B7 ]4 R/ r2 J7 z+ M
################################
, s( s: f" E2 |6 T
" M/ }9 k( w( V/ V [//Check both variables for empty value
7 `) `0 O3 L$ H$ f: P0 O
/ q: O j3 Y. t6 T6 oif (!empty($_POST['char'])){9 ^) j3 A$ O E' L: x5 b# K6 d
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
6 L3 V- L4 s. Q( Q
9 M, I# }# Z0 Om_szName = '{$name}'");: D4 z$ L. ^* _- E, r9 I# Z+ |
while ($row = mssql_fetch_object($find)){0 m0 t2 `! L u0 I7 _( G
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
: I, ^; x9 T8 A! i2 u$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
! _/ _! k h+ v5 `7 k/ N+ K# S9 p9 o; a
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
" V3 i9 d" Z* Z6 g" c2 c. `1 b7 t8 w# A8 ]- L
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', ( l, O6 M5 v" e1 X' f$ A1 i$ ~
$ Z5 V, J9 I2 ?4 [ I7 M
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
4 T3 Z! {0 h) C. |, U" t3 K8 O
* r2 M$ ^ v# J$ D A! j% c1 \'{$ElementUpgrade}', '{$ItemPierce}');");- `* E( j: F% V. s1 w# J% y
}. Q4 y1 n5 v, E _9 d
* y% ]; { J9 M3 V6 ^
}
$ u( F$ u8 Y2 f. g1 g; F( D( M- n9 k; Y' A# b7 c9 i
}
/ n' n1 v R% r5 F+ m% x* Y
1 g7 x2 n! u" V) o" }$InitForm = InitForm();
' y1 w: g F" L9 E4 S/ l$Listener = PostListener();
7 c1 s* D- b$ r5 m5 I6 M
7 T/ J; G( N; Z k) C8 r2 n?>; O# T9 }+ g# Y" F! o, O' G
, p8 ] |$ _+ z" R$ `0 F2 a: S* |: ~5 g. @' P1 J0 ?
1 C( q) d( E; |1 K' {
' `0 a5 v" e9 c
|
|