|
|
<?php; @+ Z' k; [1 x* M s$ P$ _2 j
function Connect () {
" ]9 h) L1 P( _: N% f, {mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
4 u+ S; p# D8 O$ o- [- k- B
" v6 S. K" C$ v4 A+ W+ L+ PFailed.');
0 {/ W5 u1 v0 F( }( V4 S}$ q. v% \3 D4 I: D! R
Connect();' ^7 q# n {# z
& @) g" h' I8 O( L( D% N' Ffunction InitForm(){3 F5 X8 ?# f' g4 C3 g- F
//layout for the form: x$ X/ s2 s: c. I7 K3 ~' \$ C
echo "<strong>Send Items.</strong>
4 ]5 \2 m/ ? {3 |' W5 M<form name='select' method='post'>. J+ ~7 {, G# y8 }
<lable>Character Name</lable><br/>. q. T t9 s+ O" j; T
<input type='text' name='char'/><br/>
( _+ J# y4 w7 X5 I* `$ z* S<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>* \, o# e4 ?* B" C7 [% d. X
<input type='text' name='item_name'/><br/>
+ a1 [* ?$ w/ q% x<lable>Item Amount</lable><br/>. U6 }4 U# ]# m* H7 f
<input type='text' name='item_amount'/><br/>
; n! r1 M6 W9 t8 H2 H- D5 z! \<lable>Item Upgrade Amount</lable><br/>
8 i9 T2 i# V' \' U' g! z9 y<input type='text' name='item_upgrade'/><br/>
. X( W) {$ H( k X( \: |' m<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
7 ]3 |* V; t. }& b% M0 u6 o: D; r( d# ?% q2 e( O. N: @
</lable><br/>7 O( A# q' G [3 A) M# j/ O k/ ~
<input type='text' name='item_element'/><br/>
. |7 h& q9 H- b9 H. u& E7 e<lable>Element Upgrade Amount</lable><br/>! m, i u! R6 @6 [' y- y% h
<input type='text' name='element_upgrade'/><br/>
+ b7 e2 n4 t; K' o! U+ g* q<lable>Pierced Amount</lable><br/>( a. f' x. A# J a( d
<input type='text' name='item_pierce'/><br/>- a0 `* C- y( h2 Q
<input type='submit'/>
7 D5 t; R1 X9 Z6 I- W& h</form>";
: H# W9 v4 I7 j$ U( p; B; J}' U5 ^$ b- o( i! }6 W
7 B, [! Z1 |4 a9 hfunction PostListener (){6 o& U, M+ J5 i7 U/ _
//Add more post variables if needed and add them to initform() function aswell
. p: q! T3 h! y# t4 P0 B
* p& N$ o$ ~3 O+ N4 W0 T) A$ H################################
8 c+ i% q. Z a8 ~- {##### Connection and Post ######$ E+ Z H; m; l% k/ ^; ^) D) H
################################
; l: b: s) v; a7 S% p- O* x$name = @$_POST['char'];8 n% h- b' S& ?" L
$ItemName = @$_POST['item_name'];9 ^* {# ^/ x3 n
$ItemAmount = @$_POST['item_amount'];$ l) G; ?3 p4 ?- h5 r4 R3 }, ~0 [
$ItemId = @$_POST['item_id'];
7 S; A, u8 y/ @$ItemUpgrade = @$_POST['item_upgrade'];
3 s% X6 t& O9 R5 s; o8 {$ItemElement = @$_POST['item_element'];# j/ g* T' j7 j2 B
$ElementUpgrade = @$_POST['element_upgrade'];' V8 A! O, G( m( J- o2 y$ s7 i( N! w
$ItemPierce = @$_POST['item_pierce'];* I$ P9 a/ B! z
################################
& h) o6 h6 ]* ~! y' h, `9 M+ J/ u! f1 P- @8 h9 k2 D
//Check both variables for empty value
; m v7 W; I9 s" V9 a
E/ c4 F2 |+ Q, Q! H' gif (!empty($_POST['char'])){1 H0 u/ b8 O& c J
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where - T" k" X. U) I# e0 s% l
9 c0 L; W+ ~3 l
m_szName = '{$name}'");
% x4 K1 w* F, \/ W7 O* dwhile ($row = mssql_fetch_object($find)){! C- e/ r- j, Q- c( C- A) p
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";7 ]2 ~" H8 p, l- v0 `1 d
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], ; c2 q) ] p0 \) I K2 D
3 T5 H' k+ D/ C4 [& C6 `[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
5 C( _" h. k, C4 h5 i; g- I9 V* I; ^/ ^! {; H; y. D
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', n8 L- @, D1 W! G; }: f
2 X5 O% y4 R$ e6 _/ l7 N6 A+ c3 u: yN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
) j; \# j! \: j- V1 ~9 \% C, Z! ` S
1 V% W5 h& [# p$ j. @'{$ElementUpgrade}', '{$ItemPierce}');");
2 e( {1 {' k7 A' M}
. |; O O; l/ \; ]; ^# |# h2 L6 v0 o6 x0 O* a& G: g7 b* I
}+ F- G$ d2 _1 ]8 }
$ D2 ?: I, [1 b' g}! N; U! j' }: {" p. Q+ I1 y2 ~
% |% F: |7 M$ E% V1 Z! t; Y+ U1 a$InitForm = InitForm();
) M: e6 W3 y8 R. `$Listener = PostListener();0 W" k- K5 G) e; B( ~0 Q3 `: q% p! n
5 I, ?" W9 s, k4 @ V/ C?>
- }2 K. Y. w. ^8 V
2 G i% ?) J8 R! E) |! M' ]5 u2 v$ O) [$ H4 z6 o8 Q7 J
2 o3 h* _, `. w6 b7 a
# c3 C8 J- |2 z) W+ }; N! i B |
|