|
|
<?php
6 B" u% Q+ S! C: D. Afunction Connect () {
" G1 h4 b1 p! z7 ~7 wmssql_connect('Server','UserName','Password') or die('Error: Connection to DB 4 f+ x5 n) {) q5 P" \
( c U4 E6 q+ [; {
Failed.');+ c2 `; X9 K& `" h; C
}/ j7 o0 |% h% b9 U! G6 i/ z
Connect();
7 B5 x1 D8 R3 n5 H9 V+ C7 \0 ]: ~1 s" p: z$ u: U# {
function InitForm(){" L2 {. w' R- ?; v9 p, n/ w# s
//layout for the form
+ ~& A2 L9 u5 f; F; v& o4 o" H2 Uecho "<strong>Send Items.</strong>3 Q# f7 O+ U. b0 b# e
<form name='select' method='post'>
" s* h' i' T# {<lable>Character Name</lable><br/># S6 r, S% D6 g
<input type='text' name='char'/><br/>1 e, X+ V; `& A* Y: A
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>6 U* x8 d1 m/ N! H% C Z
<input type='text' name='item_name'/><br/>7 y; p) E7 Z. Z3 t" c
<lable>Item Amount</lable><br/>
7 l% }; L! _; [: h5 _+ a<input type='text' name='item_amount'/><br/>
3 \9 @0 }; m) x) r8 ]$ m8 g; l<lable>Item Upgrade Amount</lable><br/>
2 U6 X$ f# L4 g7 { @- t# {" P+ L# w<input type='text' name='item_upgrade'/><br/>
$ z* b, R( s7 G<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
0 @- R7 \; |, {0 r5 O W, q! D2 q/ u* M5 W2 p% }! \+ v
</lable><br/>
g9 K( ^- \5 r4 I( p6 F<input type='text' name='item_element'/><br/>0 ?5 b! O2 h) G" p/ N& S
<lable>Element Upgrade Amount</lable><br/>
6 L& v m+ m T1 A" G<input type='text' name='element_upgrade'/><br/>
( K. X7 g* B* Y- E$ d& J1 ^3 b<lable>Pierced Amount</lable><br/>7 n. Q+ s; N0 m& B9 v5 X
<input type='text' name='item_pierce'/><br/>: Q6 m$ i9 H) j% }# J) e) B' X
<input type='submit'/>
/ E4 Y9 G- v N2 C/ R9 I- p</form>";3 e) Z2 a) q" h, e/ X
}
) g- i! a; d* ~9 T
& v( A9 C$ @. Q, Rfunction PostListener (){) f3 a- _; X' z- ^
//Add more post variables if needed and add them to initform() function aswell
$ k: t( Z/ A# ] Q- H0 N( t
h H) a7 `) N: B2 |################################
1 w& j9 Q5 ^. F* B( O+ P, m u##### Connection and Post ######
" }7 q: l" V( d% ]7 l! U% u################################
$ w4 H! ?* ~; V- ? A; e$name = @$_POST['char'];0 h& q2 y- }' t2 X: V( w/ m
$ItemName = @$_POST['item_name'];! F! s9 D' S/ P# m8 j s: x
$ItemAmount = @$_POST['item_amount'];$ F) T5 P1 `# ]4 O! y' A& Y5 ?
$ItemId = @$_POST['item_id']; |6 [8 X% ?. d
$ItemUpgrade = @$_POST['item_upgrade'];
/ u% E6 S7 T: t* Q& j! f8 R$ItemElement = @$_POST['item_element'];5 l# l) y# ?6 O/ }6 }- k2 e; F6 Y
$ElementUpgrade = @$_POST['element_upgrade'];6 \* Z% ]! X5 w
$ItemPierce = @$_POST['item_pierce'];* J" F: D8 I( m, h
################################
) \& J6 b+ T9 U, [4 f5 t3 G/ N0 T3 e4 Z* [+ {$ x
//Check both variables for empty value/ ?% q2 i. c1 X
# I; c; U- f. [" `& l6 P: y
if (!empty($_POST['char'])){+ b! H/ N0 P* {) A( u! d( I
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where # o( ^9 I; R5 Y' C8 j9 K& s1 X* k
# Q8 v) a! |( Q! }% o6 D+ ]
m_szName = '{$name}'");* x) n. L0 Y) j8 G) K% Y+ l
while ($row = mssql_fetch_object($find)){+ {) \( N1 ~+ i8 Q2 i7 C1 J
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
0 W) D! @4 x# _+ N, p$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
! A% f7 O/ C# r- {. U0 [& X( M( x# r! F: y' W2 J" ~5 `; C
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], 9 F& _( r/ w3 b" U% T
7 m) ^# d& E5 i; R# u[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
" a: ^! U$ f2 o: G% @; O2 S# P! l+ L4 S7 O
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
+ Z3 G; O5 o+ y5 z5 Y8 x2 Z1 G2 E& w. _& I
'{$ElementUpgrade}', '{$ItemPierce}');");# Q, y+ _( L3 T3 Z+ @/ `
}
, t) E5 f3 X! Z# Y. Q% p) ^( [' R. D4 f
}7 _- W. g: ~4 R! ^ p# c4 f
+ }5 r+ J; f; S}
" r+ e# Z. p. T" a V: \9 P
# p6 A7 F4 k$ L. ]" y$InitForm = InitForm();) k# B3 A; W+ `" F$ X( z0 Z+ q. K
$Listener = PostListener();
' a) a: l* x0 c& q
- k- Y" d5 r4 G( N( D# W?>' J5 B j1 N6 S9 }0 B: M' l: F. [
- A# d7 [. D5 |! L W
' C7 `' o6 G" [: ]9 A& j0 j1 v
7 l! B( j" y' p% M# ]
. N, r: Z; S* t- \9 f
|
|