|
|
<?php
! j6 t3 ~% G' x) z# {3 [/ W8 D" }function Connect () {- q! z' P2 q0 }
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB / o& o$ a+ r' N0 V7 t9 I* G
' R& a# m8 j" b" XFailed.');
; y. K, l+ l. i; v% h}/ S3 y2 p+ `# Z2 J) ]$ I" D& p( ?
Connect();7 ?) ?$ F- G0 f, ?: o
9 `/ o J/ l$ b' M, t( lfunction InitForm(){5 y; {' C- b, B1 V) j7 O
//layout for the form3 }4 }3 x9 I' ]" T- g! l: P
echo "<strong>Send Items.</strong>
) r V! H( q# ^) v5 }5 x<form name='select' method='post'>% R6 d3 k6 A7 Q
<lable>Character Name</lable><br/>
/ P) T2 P! C3 ?: I8 @: }<input type='text' name='char'/><br/>! K: h& J! s- X6 N, g$ U! P
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
$ _" {) l6 T* x: m( `. c' `; z$ U3 z) R<input type='text' name='item_name'/><br/>
) ^) k+ i# V/ x( B6 m<lable>Item Amount</lable><br/>8 Q1 L: ~2 \7 K K7 c6 V: T
<input type='text' name='item_amount'/><br/>
0 P6 ?" w& c5 S6 e; r9 i, F/ k2 G<lable>Item Upgrade Amount</lable><br/>6 ^! u; i: \$ j2 S7 M
<input type='text' name='item_upgrade'/><br/>* ~! Z# _7 L- l- ~( H7 c" h8 m
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)3 a3 L5 M& v& s: c" s
9 }/ M1 @; D9 x% d9 E, X' G</lable><br/>5 X7 F2 ?4 i6 P: D8 m8 n a
<input type='text' name='item_element'/><br/>
- P' ~. q/ ~6 b<lable>Element Upgrade Amount</lable><br/>
2 ?/ o. V z% c* _$ E& [<input type='text' name='element_upgrade'/><br/>+ Q3 i& z( S. Y( h- q$ T. G2 J
<lable>Pierced Amount</lable><br/>
3 a {& o% H( u<input type='text' name='item_pierce'/><br/>
* t4 ~6 _: c W; r8 \<input type='submit'/>
) A/ D* K7 F, M</form>";2 p6 Q8 K6 n; t8 w$ Z- t4 C1 I
}
) p6 Z# ~( @2 X7 ?" F! m4 K3 R3 \5 @+ B0 @' h5 x& X7 b
function PostListener (){2 G% n* j( t/ a2 n, A
//Add more post variables if needed and add them to initform() function aswell4 L( G9 r( J6 `, Y2 p( v# n. `$ t
5 \$ c/ {: J4 R* l* M9 N$ T* E################################
" ]! N. \( f. Q# M##### Connection and Post ###### ]; D% b! ?; u3 e- E' y6 C/ e8 W
################################3 c* ?" m- }8 b5 g3 l" g
$name = @$_POST['char'];
2 `8 Y& P. q" y2 @8 g$ItemName = @$_POST['item_name'];9 `9 M0 r3 c; N* O U
$ItemAmount = @$_POST['item_amount'];
6 Y/ V0 q* N( J/ q" s# }+ |: l$ItemId = @$_POST['item_id'];
~4 X& s8 S$ c8 P" s Y% o* O! E# c$ItemUpgrade = @$_POST['item_upgrade'];
* d8 }4 e* a M0 }1 K! U$ItemElement = @$_POST['item_element']; S ]; r; P* Z9 C6 R
$ElementUpgrade = @$_POST['element_upgrade'];
; ^3 K$ \; [* Z, \+ t! @$ItemPierce = @$_POST['item_pierce'];
8 [5 g/ Q% z w" X) O################################- h1 k a, ]7 l3 ]
$ T+ A: [/ J9 A0 x6 \9 n2 y//Check both variables for empty value
5 w. x/ O+ a7 g) y7 R; _8 Y9 H( T( n
) d8 b1 B" k7 A( W. s$ _& {0 ?2 vif (!empty($_POST['char'])){. S# @7 @/ y1 [8 _0 u$ G( P
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where 1 e5 g0 T2 j( _$ f0 C
( s/ J9 L# b3 S; [- R0 zm_szName = '{$name}'");
2 v' n l2 \/ b( B" u. T: j# Uwhile ($row = mssql_fetch_object($find)){
6 G, r! E5 {$ c2 M1 e4 V8 |echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
9 N' q! |! ~; A+ r- {" o$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
; z6 g% W: _ Y o; i! z. Q1 _/ X7 z+ B* s7 T4 ]0 h' T y
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], 5 w9 a) a6 m3 W+ I( D( ]
5 M8 c2 K$ u; |
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 6 ~& N2 _2 z [* q5 |4 S* w, _
% Z) b0 p6 S% h6 U5 Q% TN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', : R5 w# Y# k" G
% m* s; {. `$ l+ F6 I
'{$ElementUpgrade}', '{$ItemPierce}');");5 ^: R, d% |, e- R0 l! c
}) g7 s$ w: Z* L$ x- w3 q
- a. o J) _) r" {3 Y2 g. d2 c" W1 K: x}: `3 V- Y G/ i
/ \8 K& T4 G0 L, f# J}
) D) W0 R: S- M4 U) S+ v0 e: t8 b% O1 v; l/ C
$InitForm = InitForm(); W* x. U+ \/ {$ T' v
$Listener = PostListener();
% f$ F% f0 a/ R) X, ]0 f T1 Y
# o# p8 C5 K5 l% p% Y8 H?>
; J0 u6 h+ t, g6 M+ ]
Y$ x9 p4 m; N9 S+ U4 n: o3 F, s& l' e
8 h, a, D& D+ j( ?' u8 R. q3 Y n% v
|
|