|
|
<?php
, o }; L: d' h% M% [/ N' ^function Connect () {/ u) [) f5 j3 y
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB , Q2 |3 i8 }2 [2 I; E4 C1 p- b
3 o ]! v1 f6 g' N" I5 K1 zFailed.');
' c' M( S0 r2 p% X}+ u. J. M1 _5 L/ i, c
Connect();; I( j: B& U2 R) ?
( W8 W7 Q" T/ i+ W
function InitForm(){
) ]# F, V2 B5 D* [* P/ X& e4 n//layout for the form! N, b' s1 T- @5 |' N. J) F
echo "<strong>Send Items.</strong>
" m1 C( P7 W; q( x& o9 j' _0 D4 Q<form name='select' method='post'>
' B/ {# ?0 b$ I$ A( X<lable>Character Name</lable><br/>+ V+ ?- h& V1 ?
<input type='text' name='char'/><br/>9 ] C7 M) ~% F/ W$ I* M
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>7 _6 P; `) Z1 W C, B5 }3 \0 D
<input type='text' name='item_name'/><br/>, c- V8 V2 w, q5 J* s: w; P
<lable>Item Amount</lable><br/>9 w6 Y. P ?- s5 \
<input type='text' name='item_amount'/><br/>
1 }- ^+ S8 g" ?+ Y' K) K& K1 z. ?<lable>Item Upgrade Amount</lable><br/>+ b: u3 _. o9 v0 B% v! \. e) S
<input type='text' name='item_upgrade'/><br/>
8 R5 q5 h+ P \1 z1 E<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)& j. l# D' \* D* w. g: c# O
3 Z* @. s* z( ?
</lable><br/>
% p! z3 \" k# ^' b6 x<input type='text' name='item_element'/><br/>
% \* h0 h- |$ m$ w5 T! O<lable>Element Upgrade Amount</lable><br/>" ~& Y( q9 h+ E y6 w( w
<input type='text' name='element_upgrade'/><br/>7 D$ x& q U# _1 n+ Q
<lable>Pierced Amount</lable><br/>+ v* ~# ~- ~% J! D( K* Z# r
<input type='text' name='item_pierce'/><br/>+ K' i8 O) L8 T- F1 _
<input type='submit'/>3 C% i) ~3 Q$ h3 r( P2 f
</form>";
- ~. d2 L8 ~! c- D}
( V& w* y1 p, R3 J: B* E3 `6 Y0 q0 ^3 n' S$ w7 W2 v
function PostListener (){. S2 j2 C9 |0 B \6 J' \7 s) Y
//Add more post variables if needed and add them to initform() function aswell( I. o* o: _0 }) g; @7 v" K
, i8 @3 _+ U$ E7 z3 w. _
################################% a) i( Z% m" Q, f
##### Connection and Post ######
/ `3 R0 D0 c- D$ | C( d0 G################################3 b$ D. G$ D( q! I# Z$ j
$name = @$_POST['char'];
: c- N# J8 I4 K4 K% ~8 d/ ?$ItemName = @$_POST['item_name'];
, s# ?2 W& k s+ i) o$ItemAmount = @$_POST['item_amount'];
I X" x# J2 O: X$ItemId = @$_POST['item_id'];3 g7 R7 z/ [/ @( q7 {% j$ Q9 O$ D+ t
$ItemUpgrade = @$_POST['item_upgrade'];* y0 W9 k }. ~6 Q" R
$ItemElement = @$_POST['item_element'];
+ G2 G6 t: q; }" m1 o4 Q1 W8 j$ElementUpgrade = @$_POST['element_upgrade'];! P5 }5 e# e9 Q/ k
$ItemPierce = @$_POST['item_pierce'];
9 h4 X% }1 I w################################
0 z+ g6 `' K: t7 ]- _0 ]
2 o0 u: N( n& K2 g9 s! p' ^9 _//Check both variables for empty value
# u% h# U. q% M$ T2 h. ?! P3 _& G: }& O2 t7 g
if (!empty($_POST['char'])){4 ~4 r$ z; l/ ?6 R7 V
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
2 P1 S. ]) R5 g4 ~5 F
9 Q* `4 e1 I0 {) U$ b+ Jm_szName = '{$name}'");& @3 X% u0 t; M" r
while ($row = mssql_fetch_object($find)){
/ r- f ]3 V6 t0 _9 g z7 v! t: `6 Uecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
5 Z) d& m) Z" U$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
( e2 c: _# t& X+ k! x- A8 w1 e( a. I. p+ X# C
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
& |% f& ^ {) K7 n. _" A0 G/ U( m, o
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
8 m; L1 O* ?0 b' ^6 t( t' I2 z, y" O) i
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', . w( B5 S$ }& |% E' h9 ]
' T S& v' D% g9 F. ?0 |'{$ElementUpgrade}', '{$ItemPierce}');");* o; P! i+ A/ o) b; j$ _9 y. L6 M) Q
}
I( V6 b, N; u" _5 ~* C) j( V4 [% d0 G; E
}; `8 q" [5 ?1 \1 N* t% c ~* }; m- c
' `$ o; R* L8 C# F" L
}+ K- K' |" `4 V; o: e( x" B/ I8 l) s
$ f& a$ ^, k* M7 C- G8 W1 F$InitForm = InitForm(); ~+ J" W, O5 h
$Listener = PostListener();
9 X3 J1 R L! {1 M; n- S9 M8 F+ w* Y I+ k% c I6 i
?>
" p) j8 f5 r" ?
5 U- H* w+ R* S4 S! h, C) j5 M1 ^5 ~* _" D7 Q
+ K: J ]& V) R( F6 Q+ B
4 b* I( M" S% z |
|