|
|
<?php
) ^; K) j: O' Rfunction Connect () {; ]! B7 m( c# ~- q! v& k: k7 Z ]; e- }
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
) t2 q1 w9 [0 b' M7 g* u( h5 m0 \
) n# I) R ^* b8 s3 [# q% JFailed.');
* ]1 M4 Q* a# n: Z$ y% X) }}( r0 X# m* Q" A! [' f2 _( R# j0 j3 _
Connect();& {# e8 M3 ^) \' h
; X2 }; s3 r% Z2 Ifunction InitForm(){9 n1 Y6 s# h& U+ C t% J! u
//layout for the form
6 z5 a' r* \8 s( y& Decho "<strong>Send Items.</strong>
/ l% W6 h# e6 t# e v+ b, b<form name='select' method='post'>; n/ t3 a5 h# h, T8 G
<lable>Character Name</lable><br/>; q+ _& [. y. u
<input type='text' name='char'/><br/>
* R8 B7 p0 `/ E v6 z: M8 h& S<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
- k* v. O+ H9 f<input type='text' name='item_name'/><br/>
! [8 o8 K4 H+ E/ m# S<lable>Item Amount</lable><br/>: g7 x" f+ U) N
<input type='text' name='item_amount'/><br/>2 c' {2 ?, a$ d2 w' j6 m2 f; h
<lable>Item Upgrade Amount</lable><br/>
8 Z9 E v* G7 q r<input type='text' name='item_upgrade'/><br/>
4 w+ T. b; @2 _+ U* e" f2 \8 Z. G4 ?<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.) P7 l, w$ w# h5 x' y
! u. s8 \4 _: s' t# b
</lable><br/>$ o1 o0 L/ D: ^ T
<input type='text' name='item_element'/><br/>
6 U# E6 B j3 f& G3 k<lable>Element Upgrade Amount</lable><br/>
2 [+ Y7 c! Y y9 w+ P$ W% w<input type='text' name='element_upgrade'/><br/>+ c& h9 E4 h9 j* y: f. G
<lable>Pierced Amount</lable><br/># R$ M& ~, f0 }+ A
<input type='text' name='item_pierce'/><br/>
) T) X% }6 I6 L6 z% i<input type='submit'/>
2 F/ I4 B' g, h! \5 l</form>";$ G/ `, s% V0 m; ], {
}
5 O/ M9 @+ b: [/ p4 C j, \( _/ @, @ c8 g9 N a
function PostListener (){
6 s: {' a* O' z! w//Add more post variables if needed and add them to initform() function aswell
5 F2 |" k* W8 a+ }: k O: \/ B3 {2 q0 g6 v5 }& I' |' b
################################) T% L7 O$ y( ? U/ v) _. _
##### Connection and Post ######
$ e* v6 l5 d9 P2 g# g' \: u################################3 M6 }0 s) H z' s Y5 K" N) ]
$name = @$_POST['char'];5 k# \" O8 d- J5 F) m! A
$ItemName = @$_POST['item_name'];
) \4 [( z& m3 K1 m& D$ \$ItemAmount = @$_POST['item_amount'];
5 \: v6 R1 a6 [6 M$ItemId = @$_POST['item_id'];
$ S/ f8 W# P; M$ n# l* }' \$ItemUpgrade = @$_POST['item_upgrade'];
2 `: c/ m( U5 W7 T Z9 u/ A9 u$ItemElement = @$_POST['item_element'];
, I& N1 h- S4 d/ t# B$ElementUpgrade = @$_POST['element_upgrade'];" Y8 S8 o7 `5 ?, M I- N- ~
$ItemPierce = @$_POST['item_pierce'];
0 u$ s! w! y. J################################
8 c( H4 {8 w- v# g3 h3 n9 e5 \, A4 L W. x
//Check both variables for empty value) [% [8 B1 ]7 p0 t2 d! _
7 G: Y, U2 k$ z; p8 m( v$ @$ H$ N
if (!empty($_POST['char'])){
3 G" N7 L4 f" \. A$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
6 T% v+ S, h# k2 g* o) P( b `; q6 U1 e, \/ w
m_szName = '{$name}'");) b* v1 H2 C4 k+ ^# _9 C4 K
while ($row = mssql_fetch_object($find)){% r+ u5 z4 d2 M c' y7 m
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
; A( n# }: L1 G, t3 d2 Q; ?$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], Y! Y* l _# A4 [, _, w% y
3 I4 W- X6 }3 q( z6 C[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
, @. f7 a( H1 g8 Q: n+ E9 e$ ~$ k9 h: W' v" K; B: J
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 2 A- Q* e; Y( h. R2 N: V
: y. I* k' `: {$ M& K: ^
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
& ^" i8 R, @/ O2 y7 |3 ? c- O3 C& ^- k& X' W& n7 G4 m
'{$ElementUpgrade}', '{$ItemPierce}');");* O1 E$ `9 \2 x: H* F, {, v1 i
}/ i/ _- C% H( N0 I3 ]' X$ t
8 C3 m; T' R I4 r4 a}
- ^; _( R' t- \4 n( @+ @ ~, G# f& H
" ?* E& i* l( _6 R}
; d1 t4 D9 U1 E6 u
& V) M; ^4 f' n2 ^/ j# R$InitForm = InitForm();% m' C7 Y' o% b
$Listener = PostListener();) E( }/ G! i w2 ?( b. A& f
8 M" C2 ?! |. k( b6 S7 ]! J?>
( R, f7 ]) W- Q a1 Q+ F; Y7 @6 m# R
u: k2 h" V) q" v0 ?& H- W% U
# |; v3 U, o, T# N, B0 e1 `
* C: k. v+ V+ b% c# F
|
|