|
|
<?php
8 L& I* B5 s( j. C" a( J5 Cfunction Connect () {
1 E& @1 e; `, O, q6 V9 umssql_connect('Server','UserName','Password') or die('Error: Connection to DB & I$ O3 B# f. a6 W
3 O& s& Y- J- K5 mFailed.');, W3 M2 L" _8 N7 [/ E. \& t7 f% m
} F5 m/ X& [5 _( r/ n; \
Connect(); K4 Q. u1 o) A/ R
2 W4 L% A1 G. h: H/ w6 h- O
function InitForm(){
# ]3 b# }( J- s: j//layout for the form
/ R, l; X# q' D C& i- Fecho "<strong>Send Items.</strong>
2 Z# M. N- Y$ P0 J0 y<form name='select' method='post'>
+ [- D Y% T: j: n<lable>Character Name</lable><br/>
6 L) D/ p! o P6 B* i; x A. P<input type='text' name='char'/><br/>' u2 x, L3 m% O) s7 T- a
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
! D* Q f, _& R- l! J% y1 B<input type='text' name='item_name'/><br/>7 _3 c' ?: x! K; C
<lable>Item Amount</lable><br/>2 X( \( Q L' z% F3 C Y' R! J, I
<input type='text' name='item_amount'/><br/>6 D: G0 X7 q p. E4 q
<lable>Item Upgrade Amount</lable><br/>5 Q }7 n' s3 i# t2 M- B
<input type='text' name='item_upgrade'/><br/>
; P4 K& a# |4 }* i- V<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.); ^3 h @; V" f8 u3 D" [' s0 {9 N
8 g- o: P2 R, n2 H1 h9 A |
</lable><br/>
3 i4 ]) S1 q+ _( C$ d( _<input type='text' name='item_element'/><br/>
0 Y8 l$ E4 h2 B' N& K<lable>Element Upgrade Amount</lable><br/>6 Y2 k S: `. v6 d% O; m' d. Q
<input type='text' name='element_upgrade'/><br/>
- l2 `% {9 C0 m( [<lable>Pierced Amount</lable><br/>
7 f9 f, s9 X& ~* j+ i<input type='text' name='item_pierce'/><br/>5 t3 ^1 n4 _. q& z
<input type='submit'/># ]6 F. h. I, Y, |/ i) ]
</form>";4 u; m+ j/ o1 Z
}
7 Y6 Z' L8 w% G0 v4 ~/ Q! j5 J: l, X
function PostListener (){
; G! x5 I' F w( M//Add more post variables if needed and add them to initform() function aswell
+ v; z& B$ |; z* `* b+ q! U
" a( \& O: C9 _5 Y5 A5 S################################; j4 ^# r+ A( H) i1 S0 s
##### Connection and Post ######" N# e D* z' u) \$ F; d. Q
################################
+ {" O' R; W% R6 w7 k$name = @$_POST['char'];
7 Z8 X# C9 e" P" z$ItemName = @$_POST['item_name'];& M. |$ d! b: a3 \" D
$ItemAmount = @$_POST['item_amount'];% |& w8 g& [5 x1 Y# I
$ItemId = @$_POST['item_id'];, x# J# a+ O9 m5 C
$ItemUpgrade = @$_POST['item_upgrade'];
) H2 g2 P% @1 A% \$ItemElement = @$_POST['item_element'];
8 y8 c: n' _. V. B/ ?$ElementUpgrade = @$_POST['element_upgrade'];
% Y s5 `8 W3 k$ItemPierce = @$_POST['item_pierce'];
; y" m, L& v+ V################################
4 w# ?) l6 v. a( f. _% i6 z8 n; T ^4 ^7 [7 N9 O% v+ N4 G
//Check both variables for empty value
( J9 e8 k7 R5 r: z
( d9 A. A7 X) x. ]: u8 c- {if (!empty($_POST['char'])){
- @% U" e9 N p4 L. A8 `0 {7 O$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
- c' j0 l2 G+ h7 ~. o9 {7 \6 X3 X- K
m_szName = '{$name}'");
1 _: x6 R! y- A2 b U1 }while ($row = mssql_fetch_object($find)){- P4 g4 u% b ]2 G y/ K
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
" |7 m: a, d% }$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
$ g* E0 p' C* k6 Q; L2 i: {5 S1 O4 N! ]: a8 Q
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
9 S. L/ T1 N" G
9 w0 T) @% | z) g* H+ D[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
O" f- p9 {0 V$ T* G, c
; K! t) K5 w tN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', # n" s% R* ]2 y4 W
, a" J: {! b- I
'{$ElementUpgrade}', '{$ItemPierce}');");8 Q7 f4 e: `) Z8 c
}' ~0 F Z# u: a* z+ O0 K
) N" B3 R* \7 E% F/ f; r}
9 l, W( ~2 h- B- N: N5 G h# M1 H' R% {( E2 e+ z1 I
}* ?; D) o0 X* L
) I" [6 i5 M8 B* _1 [) v/ e7 b- ?# [
$InitForm = InitForm();: Q, h$ H9 T* d( d3 y# [; U
$Listener = PostListener();5 {2 M! Q7 y: P1 ] F4 Z8 e0 x
) s& t7 h) `) p: e4 `8 w: P$ }
?>, Q( v5 u! ^! m
3 E+ S. |5 k: o9 @. X
N& P9 ~; S; n$ g+ Q1 J' _, ?6 K) Z4 h, k) _6 I$ y* u
, o% b4 i! z' ~) U" L" J7 J( @ |
|