|
|
<?php: y- G/ y; z9 K$ F7 W1 w7 N
function Connect () {5 \2 x: L1 h# F- y/ L
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
8 Q* V1 z3 l4 |9 n( |7 N" x: J
) |& M1 w0 D! y7 z% a: `8 S/ AFailed.');
+ M' }+ b% ]: v7 I5 G$ }2 b}
1 ~3 c0 [4 V1 Z( T7 EConnect();0 Q) y/ O9 W2 }: F
: ~6 l7 V$ D" a- R8 f8 H
function InitForm(){" H" p2 l' C! W; T$ }" C6 b( R
//layout for the form
/ D, E; k4 m# D secho "<strong>Send Items.</strong>
: [! a$ z6 D* e" Y! ^% d1 y<form name='select' method='post'>( \; e3 g0 }' Q9 `/ q4 f
<lable>Character Name</lable><br/>
+ F, v8 v* B( Q<input type='text' name='char'/><br/># ^' j1 g( ?( v7 s! f- f% }
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>- b* N+ O1 Q, P3 X1 X
<input type='text' name='item_name'/><br/>
. z! w8 u3 x+ `& ~5 [- L2 ~<lable>Item Amount</lable><br/>
. D4 K9 |) G6 o5 C1 b% o( z<input type='text' name='item_amount'/><br/>: [" c# {& Q& Z, R* s
<lable>Item Upgrade Amount</lable><br/>$ b! H/ M4 m( e3 V9 y) C
<input type='text' name='item_upgrade'/><br/>: Y5 ]% D- c) K% \, a
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
) _6 A _% k" l/ t" o3 M* B8 R: m# m9 W) s! X
</lable><br/>6 [! ^' v; S6 C
<input type='text' name='item_element'/><br/>$ W- ^: M4 m; o, Z. _
<lable>Element Upgrade Amount</lable><br/>8 @+ c+ J# f1 f3 z9 n$ R8 t3 s
<input type='text' name='element_upgrade'/><br/>1 L2 G5 i5 H( K7 C
<lable>Pierced Amount</lable><br/>
: \7 k9 @. H' m4 c' m& a<input type='text' name='item_pierce'/><br/>+ _ d7 K7 G0 j8 O/ @* [0 i: m C+ f
<input type='submit'/>0 Q/ h% r+ N( i" D( E
</form>";4 t" c) j; u) ^7 ~1 |" s r
}/ h1 y; @7 Y! D4 m( u. H
) ?5 r& v: z Q$ m( W# b- f% Lfunction PostListener (){
5 ~9 b# k4 G3 {8 X2 g//Add more post variables if needed and add them to initform() function aswell% P; W, n, _: V
8 a5 Y4 Y! I" X################################' E+ G7 z- m3 | f
##### Connection and Post ######
& r' d5 Y" b( u7 e4 X6 S################################
) z4 E! x/ j: ?6 @0 P; G$name = @$_POST['char'];
) h0 E7 N! t' D, U+ U$ItemName = @$_POST['item_name'];
2 k' C" C/ q8 y, ^3 T$ItemAmount = @$_POST['item_amount'];2 n/ H5 g8 F0 x/ U
$ItemId = @$_POST['item_id'];5 F% C7 K9 z9 [& p# M7 i; ^
$ItemUpgrade = @$_POST['item_upgrade'];& W2 E" P: n' W% [. M1 @% V1 I
$ItemElement = @$_POST['item_element'];' Q' Z) T5 h7 f$ U! P+ m+ l
$ElementUpgrade = @$_POST['element_upgrade'];1 e+ a& l& [' C+ R
$ItemPierce = @$_POST['item_pierce'];, T9 O1 d6 K# g4 P
################################
w8 Y2 y& w" N3 U) U7 T" `. _ }+ c% A9 M
//Check both variables for empty value
0 x4 C) K; [! z: h8 ^: U5 K( {6 P/ w; m6 i
if (!empty($_POST['char'])){+ |; m; w7 [1 [4 D
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where & L3 M; i3 M: i9 T0 y
& H$ l8 ~$ t3 r6 x( bm_szName = '{$name}'");) K. L q% W$ |* Z2 N
while ($row = mssql_fetch_object($find)){
i; m' `9 z0 l: U$ ?! P cecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
+ A+ A# J) M" M+ i6 c) Y$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 4 z B; g) T# D- q7 \0 Z
% w4 {. K4 [. V9 R[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], ) ?) B G! T% V o- w
4 C3 m! {3 |; {, H[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
+ X2 t6 B" W4 i1 `& I6 e' R( O9 `/ t8 [& ?4 \) [+ z
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
0 C8 [! x+ q% j5 i5 S: Q& k8 O/ V) b* O: b1 i
'{$ElementUpgrade}', '{$ItemPierce}');");" I' U# L4 G) e1 E8 R+ o2 b
}' N4 V$ U5 @7 w9 @9 `: v
$ k# \ k' ^: a}
- K! ~. b5 }! x# x$ N
' R$ I9 Y* p, z0 `}# ~" t" C7 p- n1 ]# d6 f- Y
% Q/ ]3 f/ s6 _
$InitForm = InitForm();
! T4 N! p: a Q4 [2 s) c4 C$Listener = PostListener();
8 w6 S& w, U, ?( T# p) U: P8 }( `0 b+ H% _2 i3 n
?>- z7 Y& L8 x$ F' h
( g4 n* t8 n- m5 }9 y/ Q4 q; ^6 a. t
" m' t5 z$ Y( s& K4 s# Q; q! N* ~" s! o
( O1 S% \% W1 ]8 r: }1 |
|
|