|
|
<?php
1 u5 Q# A% U$ N* N, Mfunction Connect () {8 S. ]1 X0 ~" t4 i6 @
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB * R8 Q) s1 B( ?( N
+ X* c6 k2 V3 p# J) J2 N( B0 @
Failed.');( E5 l7 D" d+ j' w& l1 A# v0 H: F6 A
}9 {" y- P/ i0 r/ `6 ]
Connect();- e1 D# e4 ^" c: z: |$ b2 @
y% f5 K) X' Z1 |" T% d; f
function InitForm(){6 b* l/ q4 p( N4 f/ [ E" X
//layout for the form! F( T% [( ~! o+ R6 h5 ^% S
echo "<strong>Send Items.</strong>
9 I F8 Y, ~' g; c0 u6 V( [<form name='select' method='post'>$ y* z- e/ B2 l [8 z Y, W
<lable>Character Name</lable><br/>
, V7 U" g/ J y4 ^<input type='text' name='char'/><br/>
2 J3 l- q( h! Z5 d! X6 Q<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
1 b' b: x3 C) K9 J4 d* E9 P<input type='text' name='item_name'/><br/>
3 I% g7 o# s) H8 f% p$ v<lable>Item Amount</lable><br/>
' Q& R. l/ Z2 q y M& _1 |<input type='text' name='item_amount'/><br/>
" p0 R: i2 S! E<lable>Item Upgrade Amount</lable><br/>
7 _/ q" T3 E+ a<input type='text' name='item_upgrade'/><br/>( Q1 K* n" v& Z7 O+ ~0 o
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)) n3 X; A" t6 u
' ]0 q. b8 y! u' f4 E' b
</lable><br/>
; }/ G7 o/ B4 K<input type='text' name='item_element'/><br/># J% C4 f3 K$ [* t
<lable>Element Upgrade Amount</lable><br/>
0 M, A( ?( f# d4 `) k' P' s- r<input type='text' name='element_upgrade'/><br/>
* ]) G) ~% S p( w- v<lable>Pierced Amount</lable><br/>
4 y" R) f+ f/ |9 j' Y4 k C<input type='text' name='item_pierce'/><br/>) d8 B4 h1 g1 ], x& c
<input type='submit'/># I: T/ r' A2 t9 N1 s) S
</form>";9 C9 @; x- Y, ~4 Y' s3 ^$ x' x
}
& f9 ?$ r( o7 d6 t- _
& H0 l0 z1 D0 N7 z9 G! V6 Qfunction PostListener (){
: w1 O8 g `5 Y//Add more post variables if needed and add them to initform() function aswell+ K" t3 I: \. Z
$ ]3 o4 S" Z5 D# V0 @################################
^ z; P5 L# ]; ]; L3 z##### Connection and Post ######; } ^# [" l) m) O0 Y: f8 C
################################/ t' t9 B. \; D; X
$name = @$_POST['char'];* k5 u9 K* A/ W2 w% Q3 h
$ItemName = @$_POST['item_name'];* Y, R; y9 x, O" _
$ItemAmount = @$_POST['item_amount'];
6 Y- g8 {7 I2 Z; A. E j$ItemId = @$_POST['item_id'];" _" ]+ C' `' E% t8 T* o
$ItemUpgrade = @$_POST['item_upgrade'];
0 H* a" w7 w3 E% R+ g$ E$ItemElement = @$_POST['item_element'];* F( x0 P) T% T1 Y. H5 [
$ElementUpgrade = @$_POST['element_upgrade'];
7 L7 h, W* M: H4 e, P" ?$ItemPierce = @$_POST['item_pierce'];: n1 ~% ]( F9 o4 o2 t
################################0 @6 b9 C1 Z1 H* O* u8 b1 z
' Q, X6 b, Z1 n//Check both variables for empty value! B: t- E+ I0 Q; j G l" B
9 K( p s7 K. j6 `if (!empty($_POST['char'])){/ k- @ B3 b+ Y( ^
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where I+ e+ j& S% {" |
) f v: `) q8 h/ l
m_szName = '{$name}'");( ?+ _! r9 `$ b/ {3 B, j$ Y* @
while ($row = mssql_fetch_object($find)){
2 r2 K' g$ f" H6 P1 y, d4 g/ w6 [echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
4 V2 s7 {4 }# Q; C3 ?3 s3 r$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
' i1 h% P' u: A4 ]4 m7 N! [. G O& d
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], 8 u l! z" s+ ?
$ a2 q# P3 p" Q5 l
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
! S. w; }5 h( V+ R [" G' G6 \# l2 o- k
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
6 |) G" S) C# Q
2 m: v _7 T: q8 k! w- _'{$ElementUpgrade}', '{$ItemPierce}');");
/ a3 ]( [" `( S2 n7 d0 G6 e( P}
1 f9 `+ a* Y% l2 Y: c( D8 |. l+ o' [" C+ G2 g0 U* [* n$ B
}
5 J/ \/ E4 o7 i" P: F; {( e* `
& ?5 A- S' U6 n- s3 @5 e+ D}
6 m5 f( j$ d! C' P* c% U: J
' P$ P% L+ [0 s7 S& W) P( F$InitForm = InitForm();' k X' F" l& n+ J! J
$Listener = PostListener();+ w6 a' {- K# b7 W
q: S8 \/ K5 _- I# m?>3 o& e: h/ I* }$ e! @' ]% _
- B' l" N6 L& w' e: [4 g" o+ w
" R" M* |6 e2 ]: @; V! C
: r2 G% d' O# Y2 {7 d& F# S; G! o+ @% o* C8 V
|
|