|
|
<?php8 q# _: x& B; U
function Connect () {
. b/ l; ]0 U5 n/ u* Z. {mssql_connect('Server','UserName','Password') or die('Error: Connection to DB $ I- z$ [7 ~& Q3 c0 V) }
" C; A1 w/ T6 j; e# _1 K, h5 S
Failed.');
/ F6 a' k; S T) v$ f. `8 u: n0 K}& M( [8 w: f' d* I: f0 S" T5 [
Connect();) y+ _% V/ {6 v8 V7 ?; w
7 m# a5 d9 l: P4 H- B: E
function InitForm(){# F& A4 d8 l' ^* C% i+ L
//layout for the form! f) ]8 g# H- ^0 _1 h6 F5 ?
echo "<strong>Send Items.</strong>
6 E, m% h/ P% \8 C% C/ B4 n" ?; Q2 r5 c<form name='select' method='post'>
# r" V/ ]8 S5 E5 p<lable>Character Name</lable><br/>
3 q. ? m' o d. c; C }<input type='text' name='char'/><br/>
7 x& z X2 \- D/ u2 f- b<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>& i; p6 m( o0 I! Y5 ?( c
<input type='text' name='item_name'/><br/>
' P2 l- y! X) L& U<lable>Item Amount</lable><br/>
- l) G+ i$ q1 m/ A1 Z4 l1 [<input type='text' name='item_amount'/><br/> ?5 F: D0 t y5 Q: O/ _
<lable>Item Upgrade Amount</lable><br/>0 R6 I( Y7 \. w0 c& W
<input type='text' name='item_upgrade'/><br/>
5 d. }9 O7 c6 v" O<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)+ `5 K2 ^) a# A D) ]2 s( z6 ?' U$ Z" B
9 X( t; w1 d% ]5 t: l3 y0 E
</lable><br/>" k, E' k7 R4 x! F+ Q8 A2 @
<input type='text' name='item_element'/><br/>
' i: W4 _/ s8 O- c6 D$ T9 h<lable>Element Upgrade Amount</lable><br/>& |% i& ~" r: K& k" [
<input type='text' name='element_upgrade'/><br/>
$ w6 Z1 N- v) |8 m<lable>Pierced Amount</lable><br/>
5 p; B4 [4 a2 H, d4 X1 O8 @<input type='text' name='item_pierce'/><br/>
) `4 a7 R8 L z6 h( [8 ]<input type='submit'/>
+ I6 v. _. `& O/ |6 t# P</form>";8 q5 i' }3 A Q p8 n) Y# r
}+ E6 u+ z; ]0 a+ \* Z
/ ^1 o2 E2 q% o# B2 Zfunction PostListener (){
* H% p8 U9 p: s" Q3 ?( Q `//Add more post variables if needed and add them to initform() function aswell; X" i4 P3 d& R$ N& m. }7 T' A
( |: [4 Z1 H& a2 H n
################################
' [% i$ K( N1 j: P- _##### Connection and Post ######
3 d# _! {9 Q7 e" r3 ^/ D1 S5 ]################################5 v1 i5 F, i- W; H' g/ t
$name = @$_POST['char'];
; ?% x4 K% ?! }3 r$ItemName = @$_POST['item_name'];
% a4 D# _' b) Q5 g- u% P1 a$ItemAmount = @$_POST['item_amount'];
. P: f9 e# O# f8 y5 W$ G$ItemId = @$_POST['item_id'];+ ?- \9 u, ~% }3 f, S* P4 m5 h" f
$ItemUpgrade = @$_POST['item_upgrade'];) d2 H2 U; \; @) S8 E8 B
$ItemElement = @$_POST['item_element'];
2 w" V# H1 b( U$ElementUpgrade = @$_POST['element_upgrade'];
* g, W5 W8 s: _- X5 b$ItemPierce = @$_POST['item_pierce'];
. x7 [. L3 z" H################################
4 c, W/ _4 o5 W( Q* U T+ d
) E. W( [# [/ ]2 G! G/ @//Check both variables for empty value! l* `( F+ v( |6 \% T5 G1 R5 m5 y6 V
8 M. {' w$ Q9 A2 J1 J: R7 o( y
if (!empty($_POST['char'])){0 X; b) g9 g/ \# N: a. X
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
- I9 l0 R- r, u% O8 Y, Q. i- }4 t9 u+ V4 @. B7 p* i
m_szName = '{$name}'");
( y" E/ R9 ]' ~" Rwhile ($row = mssql_fetch_object($find)){
- S, j# }! [( ~( I+ y* lecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";+ ]4 l1 P9 i# k1 V. @! l" a" c
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], * O; J: A" r( G& W& C
6 Z# o% x# {. p, D P- p) Q$ _
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
5 \ a1 a6 i* ]! {& e8 Q9 |' I3 R Q
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
% S) a8 [6 t) E+ \# I2 q A' R7 R6 h" W, G l6 o
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
2 T. B* @/ @1 R4 o/ ^
, w9 w+ P! y% C% P, w) t. y'{$ElementUpgrade}', '{$ItemPierce}');");0 R6 {" }2 k' Q! |4 `" I
}/ J8 i; @0 Z6 r s+ v- w" W/ l
1 E. f6 o5 X8 d# l}
, C# W4 X0 |& @) s
5 a; l; h0 p3 H( ]}
# ?& w- S* [) W0 V% Z
3 W/ E4 Q3 R I0 h$InitForm = InitForm();
3 M* o' T' {1 c0 h5 {1 E4 q# |$Listener = PostListener();5 `: ^/ T3 u9 E3 U( ^" S+ T* y
/ K5 T: \ Q2 O4 | b2 p?>3 d( d" b" y0 [+ B( `
+ |7 X5 r S p, X2 K" ~
' `) c8 B: @" N* ?4 T, m+ {$ F& z+ g$ r$ o* L# B
% u, b" ?3 y' }: O9 b9 }
|
|