|
|
<?php* ] z! y' ^; I9 Z1 n9 `9 H' E2 V
function Connect () {$ K6 D1 _ ^" ]2 `/ p4 r. Y
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
/ q" X% v# _) W0 C. E' W. z0 r( q( o4 S
! i) p) A( _+ o- V/ I# o+ iFailed.');( N1 n. [" {# R: q' u" G
}
0 n" ? ` \( A- [# }5 a, TConnect();7 ]+ n0 l8 _1 w: |; s$ b
6 f/ r0 [2 c; b+ r& E+ }
function InitForm(){
+ `( }. ^: N/ ~4 B//layout for the form. ~: D5 a! R. @2 S2 F8 c
echo "<strong>Send Items.</strong>7 E. A0 N9 U- v! }9 J& s
<form name='select' method='post'>
& Q" p5 F& O2 u: p$ V$ F<lable>Character Name</lable><br/>
I, S2 E3 h0 C! D4 Q& N; t# o<input type='text' name='char'/><br/>, X, L# u% y4 u I% h X
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>9 N3 X ?0 o' Q0 `' T o
<input type='text' name='item_name'/><br/>( d" `0 o- I" q! G
<lable>Item Amount</lable><br/>
5 j9 v1 |0 D! o% {5 `<input type='text' name='item_amount'/><br/>! J- Z: O+ u; X2 m
<lable>Item Upgrade Amount</lable><br/>& c: S X! Z2 ^
<input type='text' name='item_upgrade'/><br/>* `0 Q# [/ c6 V' ?9 C
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)! q: F' `) y: H* C2 H" b9 D8 X
( {4 I/ E* i- A0 ~& y% R</lable><br/>+ |6 F. p" ?" S3 l+ {
<input type='text' name='item_element'/><br/>
0 [! N, H7 N# z/ f* v2 b( M. o<lable>Element Upgrade Amount</lable><br/>+ H+ Z: G# T4 v' U& T
<input type='text' name='element_upgrade'/><br/>( J$ f3 o0 A$ X
<lable>Pierced Amount</lable><br/>
2 l5 l9 ~* V- d( k; a! m4 q/ q p( B<input type='text' name='item_pierce'/><br/>0 m; \3 ~: o3 W1 \3 Q
<input type='submit'/>1 L4 n$ T0 N6 p2 v
</form>";: {* N7 Z+ }. O8 z; ?! J
}" O3 W3 G9 F9 Z# w1 g, I }, t* Q- X
7 y: G" ?1 J, p1 ufunction PostListener (){
& X1 c# R8 ]. t) ]2 s//Add more post variables if needed and add them to initform() function aswell+ N$ z4 r5 c% X1 l& y
: B" \1 n" k2 I N3 g& G" r7 Q################################
9 o8 H, e) J& b##### Connection and Post ######
5 }5 S( W" k6 h4 S' _2 A, F################################
" `8 Q3 C$ R1 I& ]$name = @$_POST['char'];! F2 ^: C2 i' B/ Z. K
$ItemName = @$_POST['item_name'];4 y& g% h7 i& a1 F: P
$ItemAmount = @$_POST['item_amount'];
0 p5 [# D9 X% A. X" S$ItemId = @$_POST['item_id'];
3 a) s* G' h+ n/ y4 D" h: a$ItemUpgrade = @$_POST['item_upgrade'];
2 F; a! j/ D2 r" ^0 N$ItemElement = @$_POST['item_element'];& O/ @& B+ Y. O
$ElementUpgrade = @$_POST['element_upgrade'];: ?5 c; g- _% B' p8 `8 h' b- x
$ItemPierce = @$_POST['item_pierce'];* `: J6 e L. ?; l9 L; l8 D
################################, w5 F" a; h0 d
3 V3 c% X/ {9 L$ L* f4 C& @//Check both variables for empty value" f6 a5 Q/ @8 M# c- B1 D
$ _/ H$ a# `7 A4 ]1 r5 i3 _
if (!empty($_POST['char'])){
/ H9 u1 g, [: u) ?+ B# t0 F- [$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
/ l: v" E% Q; M5 e6 h7 R) C' z0 a$ Q! o1 s. K
m_szName = '{$name}'");$ R' G2 ?: c9 D. o$ v1 ?' Q) J$ M
while ($row = mssql_fetch_object($find)){& b1 D8 k- z3 a# b
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
0 w8 @6 H$ Q0 |0 Z/ o; P" U$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], ' X4 e2 m% [$ T" g3 S s% _- K! N' O
& F# }0 f+ V- T/ H
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], . F8 v; `' w# l
, F* n8 _0 h$ M% W
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
2 f, X/ _6 s( ]; i6 P8 _ m/ |0 e8 a2 ?3 r f# {8 s
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', % b% M1 ]. E$ A4 M5 }5 [
- f' |6 s6 e' w4 F3 R' f# w7 f'{$ElementUpgrade}', '{$ItemPierce}');");
5 I& \0 F# W2 `' x* }4 g; S7 U}: i. _! N! s0 E# m3 G) |- F+ ?4 I
1 }3 K! Z9 Q4 D" M) k( {7 j
}$ a2 |$ C! n! ?# h8 [
/ i8 N* q: _ x( D R1 m4 _3 ?) h" F}
% [. u9 N& ~- R
p' Y8 F% m# f9 C4 Q. [4 } X$InitForm = InitForm();4 V8 u5 L- K4 I+ \$ |' X6 g5 G
$Listener = PostListener();( \) ]/ D; f8 d4 \: x d6 c. L
/ R% k1 u: J3 T: i2 N?>
) S$ U! z1 p3 E2 P; b) X: {$ q6 E+ o+ O. X
6 ]5 ?, M1 q) |) ]& k; {) O; r' v# ]/ G
* f2 I! ~) x2 q) Z, j* {4 h+ A
|
|