|
|
<?php2 W+ N6 o; m' |0 b
function Connect () {3 ~1 k) \3 ]+ ]. A2 i7 \* L
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
2 k( `& H- e5 j! f' q* G; R0 \4 P/ y7 O/ Q0 Q
Failed.');
, J! N* r! G, ?}
3 P" G: f+ R! ?: _Connect();% @* w2 B1 W, A% N7 ?0 t
! S K5 P7 F! X: H) M. K9 hfunction InitForm(){
" b- x) O, ?3 A5 ^//layout for the form
( ^+ u7 @ j& k0 u* Qecho "<strong>Send Items.</strong>+ I5 I) L' L; T! r% A* {1 l. H1 ^
<form name='select' method='post'>0 `/ A* L" x8 i4 ` ?. C7 b1 H5 n
<lable>Character Name</lable><br/>% B9 H! Q+ q. ]/ i) q
<input type='text' name='char'/><br/>
3 Y0 D( L: R; ~( B' U# f<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
2 c' E$ o* | ~ o3 ]$ C6 I<input type='text' name='item_name'/><br/>
9 |( j- E& x5 e8 \. a<lable>Item Amount</lable><br/>9 p$ F3 _$ ~: Q4 S( }% i
<input type='text' name='item_amount'/><br/>
( l) `8 U, L; g( m- u<lable>Item Upgrade Amount</lable><br/>
5 _/ S4 w9 @9 V<input type='text' name='item_upgrade'/><br/>
' p/ ^: D: t5 F5 y* G" u' C<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
# [! O' } N6 U* }/ k+ y- I& c* A, B7 @1 Z! E9 p
</lable><br/>- R; a% Q( V0 i' J5 E* g5 o5 N
<input type='text' name='item_element'/><br/>
+ |' J' g9 i# l; o! r<lable>Element Upgrade Amount</lable><br/>
8 z y/ \ ^5 \2 W: m5 ?<input type='text' name='element_upgrade'/><br/>
* l4 Y3 x9 ]# e4 {<lable>Pierced Amount</lable><br/>
% r& K$ P5 J' \<input type='text' name='item_pierce'/><br/>4 `, h! q% L- k q" m$ K
<input type='submit'/>
?* d( T( y; \& r: i9 o" K</form>";
- b3 V- n' u. E0 z}6 G+ ?! s6 j, L( X0 B: w
; Q0 G6 e* Y& Wfunction PostListener (){& R7 [1 }/ q7 J# `3 Y
//Add more post variables if needed and add them to initform() function aswell* t" E8 L' ^! m( m4 x9 w1 N
% M+ k9 Q8 S* T
################################
2 D( `* |4 _) O a7 F b2 b. I##### Connection and Post ######, A" ?* v! b1 S/ s+ m
################################
2 _. E* C) ~* D; X$name = @$_POST['char'];
1 Z2 L' {' O0 N Z5 [$ItemName = @$_POST['item_name'];/ y4 V* }9 s; \: V+ N* u- F1 R; [
$ItemAmount = @$_POST['item_amount'];
9 v( D' B+ `1 x7 M$ Q$ItemId = @$_POST['item_id'];3 E7 s o- t: c' y- ^# w
$ItemUpgrade = @$_POST['item_upgrade'];
' K- s/ A/ s$ `4 Y- T$ItemElement = @$_POST['item_element'];
9 q q8 P7 a5 M3 C5 Z' m$ElementUpgrade = @$_POST['element_upgrade'];
6 r1 P& B" o8 V& K; L# a$ItemPierce = @$_POST['item_pierce'];
% y! G6 d- M3 ?3 V2 ~! D################################
w; M/ P5 g+ }! e
. P4 P1 \! K0 ?' J: F# z//Check both variables for empty value0 b4 V5 l) v8 i+ g0 r
1 [" Y7 N# b9 O+ j. y% A! x
if (!empty($_POST['char'])){
/ j8 E% @7 [6 d4 E$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
+ m3 A3 y0 j/ [! k' F; x
/ h; d# A' w" H( |m_szName = '{$name}'");) |! }, W) Q- j* S0 P
while ($row = mssql_fetch_object($find)){) B3 h- {: f; F1 {1 P9 D2 X- T( S
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";! ?; S) k; }- J, Z" e
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], + F5 `; c" e4 z6 {
& g+ Z8 L6 }6 [8 ^) p2 |) ^[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], $ z, W0 j$ K3 F' U! i+ Z0 N
6 h* A" c$ S* u- @# E) i
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 4 t- ?, H+ c }" @* p0 p
# |7 ^# A7 h, U. }7 w; U
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', % U {" J# L# D
; H$ B$ S% N0 H3 X'{$ElementUpgrade}', '{$ItemPierce}');");
. u5 X" ^: w3 v4 I) Q6 X6 L& P0 U0 l! I}$ j* C) |$ f$ \+ O& u
2 J- f& G) q2 |5 r% W/ _
}5 w, q0 U- b9 Y5 d( W- F1 i
+ W$ N1 o0 {7 }, r
}, p9 t. q/ s+ g$ i" ~ L2 r
- ^# O4 ^/ d k% m7 p$InitForm = InitForm();) C/ H4 j+ n& @" S# `0 R2 h! g
$Listener = PostListener();
+ K2 F n6 R d5 }
- L! _% t+ m E T: E) P' j/ h?>1 l( d, \( B+ w/ H2 A
! A B) n: v$ |2 x' u! z k
6 x& _& C u- o" s3 u9 t! b7 D4 E; R/ X1 C2 \1 I& ?" n
' H; G8 @: ^0 w) \) ~4 q- u5 W |
|