|
|
<?php0 a& F. h( u3 s! @" r. `
function Connect () {
* n* P1 ^9 s5 d# }mssql_connect('Server','UserName','Password') or die('Error: Connection to DB 8 N; @7 m- K/ Q2 t6 @
( E- H, p# R( L* h/ GFailed.');. \, f6 i' W$ z1 k" z; [& W3 r& q+ A
}
% l8 w( v& A# g) _8 hConnect();
- w# \8 H. m! {; |
, H9 ?! {: z1 ~- [function InitForm(){6 [% r# J( ^2 ]0 F& r: E8 f
//layout for the form
7 R: u5 b- {7 h C' Oecho "<strong>Send Items.</strong>' T) t5 o5 L; D) D. R D
<form name='select' method='post'>, m- s( z3 ?7 h) O, m
<lable>Character Name</lable><br/>
& P6 |) Z$ Z& P( B3 U9 i8 G<input type='text' name='char'/><br/>8 |2 h4 ~- ?: |0 |
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/> Z$ x- F$ Q( \6 E9 V0 p
<input type='text' name='item_name'/><br/>
+ t+ T4 ~% @3 _# D1 T' `<lable>Item Amount</lable><br/>
1 D, J; ?9 J( m- X<input type='text' name='item_amount'/><br/>
! z. T& Z" K; a+ v- S$ d% S<lable>Item Upgrade Amount</lable><br/>
7 Y0 l4 ?# E5 u8 w<input type='text' name='item_upgrade'/><br/>
* Q! ^& B3 P$ v; j<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)$ e, S# a& s+ g
( O7 f: l% U( g# b, w! G" |</lable><br/>( N; F8 r6 q7 ~! n2 r
<input type='text' name='item_element'/><br/>+ z' [% M2 }5 t3 F( T) g/ {
<lable>Element Upgrade Amount</lable><br/>1 C# B0 U4 B0 H7 P6 {2 t; _" z1 f
<input type='text' name='element_upgrade'/><br/>
5 p4 J7 ~2 t1 d9 B<lable>Pierced Amount</lable><br/>
2 j, y! ]5 P* W9 I* P<input type='text' name='item_pierce'/><br/>
# G' r) X& q2 G6 i' y9 O; M<input type='submit'/>2 K/ _/ ^& p, ]* J7 |
</form>";2 Z% c# R6 X% W1 |# E/ t# a
}
5 U5 N7 o3 H d' y/ o
j& V8 d% r$ [; }# _0 xfunction PostListener (){
" t2 W6 Z& h: D6 r3 W; w//Add more post variables if needed and add them to initform() function aswell
. w M0 B9 w- U8 V, K
; I; D% I V# l4 p" ~+ u. S################################
* v: X: D7 B) t d##### Connection and Post ######& R5 r8 M2 Z8 ?% M8 B- \8 h5 W/ Z
################################% d B# G f6 }; f/ Z5 N
$name = @$_POST['char'];4 m, H- G: h, u3 y; s8 `. A
$ItemName = @$_POST['item_name'];
4 a' n6 K Q! p- R$ItemAmount = @$_POST['item_amount'];$ t+ J( p9 j* g G2 A* A+ d' r4 t8 Y
$ItemId = @$_POST['item_id'];
& V, S# u4 W* }1 ?3 |& @! s6 E8 T3 M$ItemUpgrade = @$_POST['item_upgrade'];3 k6 r. z0 r9 o4 U t- B
$ItemElement = @$_POST['item_element'];
/ G6 e$ v0 @; H; n$ElementUpgrade = @$_POST['element_upgrade'];
9 y4 F( }/ V5 a9 i& {2 I$ItemPierce = @$_POST['item_pierce'];/ W$ t, \' v) X0 M1 P+ J# v% B8 p1 ^- Q
################################- z8 m5 x4 O: p: [
. _( S! {/ t4 _//Check both variables for empty value
1 \% k2 ~/ Z o* N+ @2 \2 S8 I) t, s% s% T
if (!empty($_POST['char'])){3 ^0 R3 C4 Y8 X
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where 0 u1 X: ^ d8 g- @
! W B& G9 c# Bm_szName = '{$name}'");& m A) O: d- z& z, Y# R$ ?
while ($row = mssql_fetch_object($find)){" Q/ {9 v* c0 p5 k2 B5 A
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
D6 e6 E0 G y# g, s$ F+ K$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
! K/ q: y& E9 y/ B
9 U! S6 F: {9 E4 {2 D! h7 S* M[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], 5 a/ N# S( t0 N2 v
8 Z! C" }5 e' y" F[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 1 p3 l8 h9 }4 ]( T( k0 h
3 ^1 q1 Z: t- U' o+ z
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
0 n3 z4 ~' e6 x) w) d0 B+ w0 T. F5 G
'{$ElementUpgrade}', '{$ItemPierce}');");
6 `: w. F0 z3 I# f1 E; \}0 j* M) F8 [0 g; x
" I" P( N+ f% y. T: y6 @4 u
}
3 V i# u2 M( m& v5 x
& F7 P4 S1 P/ r/ |( C}
) c6 h- R p8 ?+ R* n. B0 k( ~% }( W) N3 ^& i' m
$InitForm = InitForm();
; y4 u3 R. g8 O$Listener = PostListener();7 b2 [: ?; D5 n5 {' j$ y+ m
& S& n& d2 W$ h4 k a
?>
, w' r: L. d& ^) M, w% n3 R u0 I
S9 c9 f: P: b: x( p$ b; }) Z
9 T: |& c, P3 N$ G; i' |. x6 }2 ^3 Y* d
1 K1 [4 f; @1 `) U |
|