|
<?php
+ |# |% C# l5 Z3 k$ E& a, ^) c! B# \function Connect () {' C1 I) d) k9 v2 V# X1 S
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB 5 k D' u! K/ U( [" _* i! P
9 `2 D5 }1 \/ [; n1 \- M& Q7 D' v
Failed.');* x6 o9 d* e5 g2 B- l
}
4 ]& ^, D$ R$ AConnect();
3 @' ]0 M8 c4 o9 U
6 p4 }! ^- k) S/ R: Jfunction InitForm(){
4 F; }& B+ o# e, o//layout for the form
! H& A/ C/ S/ y5 s4 u- Iecho "<strong>Send Items.</strong>
( `2 n! O. h. Y) ^- t<form name='select' method='post'>: V1 g* t6 o9 b+ t% l9 t
<lable>Character Name</lable><br/>% Q8 l- \, d4 [6 l' ?5 F
<input type='text' name='char'/><br/>( X6 [9 ] p, E$ ?7 _
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
/ Z2 z" `+ A( {. z% p<input type='text' name='item_name'/><br/>
: p2 b! ]) A2 l$ p3 j! U7 v<lable>Item Amount</lable><br/>6 e3 j/ q% `- B, x( U
<input type='text' name='item_amount'/><br/>
) I5 m/ i+ Q6 i<lable>Item Upgrade Amount</lable><br/>3 L9 ]9 m1 }* K* ^% s
<input type='text' name='item_upgrade'/><br/>6 V, i; N6 n/ k5 x9 [) I
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
9 o; ?' g1 a' _7 g7 e
, a; Y2 S3 U# A* N4 a+ C( j</lable><br/>
2 X" L, Q3 [5 W7 B* A<input type='text' name='item_element'/><br/>
/ U1 y2 F- v: M/ X% @6 j<lable>Element Upgrade Amount</lable><br/>
; N% m# n9 g7 T2 c2 U7 S<input type='text' name='element_upgrade'/><br/>
/ D. `+ v; N- c<lable>Pierced Amount</lable><br/>
5 {* \0 ` w+ X$ W+ k0 j<input type='text' name='item_pierce'/><br/>8 W# D M" l3 {3 I% t l
<input type='submit'/>5 ^# Y# C$ y5 p: Z
</form>";
4 u( m; } G+ r}! ^6 Q! f) ~1 ^- R6 w& t1 N
2 r% o9 i/ _6 x$ X; sfunction PostListener (){) U! o6 p# ~# |! l: ]- D7 G6 w
//Add more post variables if needed and add them to initform() function aswell
9 @; K- y& C- N# H; g. M: @
$ D$ M% T+ A2 b2 Q# `################################- [' L2 `, b& Y/ { q0 s
##### Connection and Post ######5 `& P, ^" s$ J ?) j M' \
################################ s5 G7 J+ f& e- _
$name = @$_POST['char'];
* k+ a; P- V9 w8 E0 z$ItemName = @$_POST['item_name'];& E2 [6 x1 t; J# \3 t
$ItemAmount = @$_POST['item_amount'];
- e( ^2 S8 q. y) _$ T$ItemId = @$_POST['item_id'];
# ] \/ j" F% V* P3 y4 t/ ~. |) N! t$ItemUpgrade = @$_POST['item_upgrade'];# m- q) U' J5 e0 ^0 m, `
$ItemElement = @$_POST['item_element'];0 |: @; b8 l! Q* E( ]7 t
$ElementUpgrade = @$_POST['element_upgrade'];( |5 t4 X7 f& d3 c# q) H/ Q* L
$ItemPierce = @$_POST['item_pierce'];
& m! E6 p+ F# O8 M2 ?################################
+ ]0 D) ]( U! f$ k- t- i/ E" ^$ R3 b" w" F2 q7 t' Y) h
//Check both variables for empty value, x' b# f4 p% k% R3 ?
! b" }) `. g# M+ E5 k3 ]if (!empty($_POST['char'])){: s1 b _* n) n" f3 z& ~4 x* Z( ^: s/ P
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where & O6 l7 m% g. \0 P/ V) F7 n
# {8 n8 R" E }: k: dm_szName = '{$name}'");% }/ P+ l' p% Y* a6 X. o: I
while ($row = mssql_fetch_object($find)){' {7 e7 ~7 F) }2 @* a( i, {
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";2 X% P1 n: _* y4 J C0 p
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
% ]) _! X7 w& c5 C& }5 G1 q7 H- r F, ^' @. K
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], & ]. q) ]" v! c9 k, V: I
l8 ?- w0 ~6 K" [/ ~# B0 W[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
) B( [- P8 Q" e6 {: O3 P' s( T
' G+ ?' F+ H, W `" ?% H+ IN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', & b7 R* @+ R+ a0 u) B3 }4 R
9 L. Q' r9 E: y. e: U/ f j
'{$ElementUpgrade}', '{$ItemPierce}');");
{$ h2 g8 y* f; w}
% E1 p4 u' `! V1 j5 r( P: [- z2 g; f2 {2 W; Y# v* m
}3 g' Y" Y! R. G$ r3 b* k
- b% X( c6 L/ q: p- K& d/ P! X}! W5 l3 v# g4 s: f! r" m
' {. p }, x$ f
$InitForm = InitForm();1 j+ B4 i( X$ d; m
$Listener = PostListener();# ?# p4 t) W2 d: n+ v; b
. h( e' ~9 n' v- [7 ?8 `" W
?>& G5 w: L4 W% ^4 P' v9 i, b6 C
" O; g9 B' _0 Y5 b+ w2 R
* P( R6 I- V6 C% ] o
% b4 t$ a3 _6 Q
; s& R1 Q: j1 T5 `# Z" U |
|