|
|
<?php8 m; B/ u9 O% R( r; `- T
function Connect () {
3 d7 u1 A. I# {! amssql_connect('Server','UserName','Password') or die('Error: Connection to DB
- x. q8 o) E+ B3 W' J, J
/ d& f3 f1 Y0 s6 ?3 dFailed.');
9 X# d+ k$ x" F- g7 e3 b X. _- Q}1 T4 P8 x6 @' e
Connect();
( Y( v3 h4 i! G7 b |
( j) {5 F! S2 P7 jfunction InitForm(){
; \" a) ]/ I* ]/ u1 {0 t1 G- _//layout for the form
- Z9 p: g: e6 z5 _* ~1 N; v' jecho "<strong>Send Items.</strong>
9 w7 l8 [3 F& z+ k# \) z# ^$ W! h<form name='select' method='post'>
7 u7 R+ Q# w/ K% J1 F. g) J" S+ E<lable>Character Name</lable><br/>
# X8 D3 S0 S1 ~+ D6 g<input type='text' name='char'/><br/>
6 v: F; k+ D) E0 Y<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>, ?0 v0 I' i% p! L0 H
<input type='text' name='item_name'/><br/>/ E4 |& D5 n* {; ~- v
<lable>Item Amount</lable><br/>
3 ?6 p- w4 U5 j+ n1 Y% U<input type='text' name='item_amount'/><br/>
1 x2 T* g. @# I; j<lable>Item Upgrade Amount</lable><br/>0 J( D, F* x5 V5 b8 W
<input type='text' name='item_upgrade'/><br/>
) N% ~* f5 Y1 A7 e J7 i2 a<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)% v0 v% f# a8 f9 p
2 t/ k# B) X2 h' R' b</lable><br/>7 {2 a5 G: @9 y& A$ g* h' F
<input type='text' name='item_element'/><br/>
$ |9 Q% K4 [9 {, O( Y! Q<lable>Element Upgrade Amount</lable><br/>+ l! B& l+ n$ ~) D
<input type='text' name='element_upgrade'/><br/>
9 o9 O, e4 N3 w( `$ D<lable>Pierced Amount</lable><br/>
3 \9 o( h" z8 I* V" I<input type='text' name='item_pierce'/><br/>
2 w! X1 N2 T. U- v7 B- ^<input type='submit'/>
2 [- j# L' X+ E</form>";
0 }, W/ c% a9 @8 R( E" y9 S0 W}
1 G' z$ q( y1 @5 {' k
: C" T3 N/ X* F2 Q W \4 pfunction PostListener (){
5 S7 P# L$ A, a//Add more post variables if needed and add them to initform() function aswell1 j u1 j3 j1 K: J5 v
7 x( Z( _% T/ `################################
3 I/ J- r) p0 V" Z##### Connection and Post ######
( W% W1 L C9 m1 ]################################
, j2 i+ v' v3 v+ R$name = @$_POST['char'];. o* L9 H0 n+ u0 _) m1 v; N& M
$ItemName = @$_POST['item_name'];
I' ^9 k, U* [$ItemAmount = @$_POST['item_amount'];7 ?. {0 ]" V, y" O/ n/ [# I
$ItemId = @$_POST['item_id'];
) S# S4 [ d1 F, L+ L$ItemUpgrade = @$_POST['item_upgrade'];
. x' b. n& d) K% |2 t8 O- F5 y$ItemElement = @$_POST['item_element'];
3 J: i; m4 P2 W$ElementUpgrade = @$_POST['element_upgrade'];) X8 Z# Q4 ]; ^4 f2 E
$ItemPierce = @$_POST['item_pierce'];
0 ]3 ]& ~. Y2 S) v3 l################################+ v7 M7 ~* x7 U* ?5 _
* s1 `+ k# Q, A/ k+ o# _$ |+ g//Check both variables for empty value
4 T; p" t& _% Q6 m: l. w" ~. k$ {8 n9 \. N# t V& `$ B
if (!empty($_POST['char'])){: q; |/ @& @9 Z$ g
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where % b8 @1 z, @$ V! b* a
7 T# P& |6 j! L6 e: k- K* c
m_szName = '{$name}'");6 A+ Z2 x. A5 r. \/ O/ I5 R$ l' O. K
while ($row = mssql_fetch_object($find)){8 t8 h' l9 P8 Z6 ?4 j/ O. q
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
5 M; g& Q/ M) c& i* S# }$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 3 }' L) i9 {! o) w/ o0 V3 m
2 e1 y+ G" c: x9 o1 `[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
& D( G* m% V4 v8 b. [5 B
' s6 q) X6 q `* y ~! V' p5 ^[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
: K! W6 O' ?/ f# H( t2 ?
3 |/ Z% m3 R7 f, K% {; E9 Q& UN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', : P- B, _3 u2 q8 N
: E {! Y4 z7 J& ]( }, s. U8 V
'{$ElementUpgrade}', '{$ItemPierce}');");
7 Y" w$ o7 o8 k3 a- l1 D}
) w+ b- I) E) ^% r$ h [
& N( _; k/ W* [" g}
7 l* B/ S( B- z! V
8 u9 c8 M& T# P: W6 F}" M/ v" a5 l& Z
6 @7 @/ G; u1 B0 z& r/ h
$InitForm = InitForm();
# t4 v( r, j [5 Z( C {1 r$Listener = PostListener();- u' x+ i& h, @ I1 o" W3 L9 x
9 o* r1 U* u7 N. F" |" f?># L7 B- Q. F6 O1 h4 E; }
/ [- k% e' R% C6 r s
- {: D5 s& A4 a: Z8 q6 q8 ^ p# }9 l7 U, c) L
6 K" `8 d3 L$ l. N5 l) S; q- R |
|