|
|
<?php
0 c# \+ i) s) j, G r/ Q; b* ?function Connect () {0 ^- y% p3 Y% ~* b) ?* M
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
( o: v, g7 x. |8 W, K
1 T4 t r- _& q/ u. CFailed.');
" ]& z9 o: l0 ^4 I6 W( f [}
; L9 g4 J& f" Q2 e' }Connect();( B L% x2 _) j% w( q
* M8 J/ w/ B* ?; Mfunction InitForm(){9 w4 a0 b8 @- p @8 Z
//layout for the form
5 ~7 L! G! ?" b* ]2 u. d, ~9 Decho "<strong>Send Items.</strong>
p6 W+ N1 w6 m. M3 M! G' [<form name='select' method='post'>7 t% S# [4 f* Z; a# V2 ]$ ?
<lable>Character Name</lable><br/>
7 x& F6 T: v7 o7 j( Y9 f' i<input type='text' name='char'/><br/>
% _$ c5 K8 W, n( g7 j<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>* x$ u* _$ S" V' p2 o @( ]
<input type='text' name='item_name'/><br/>! N+ {, `' v- k% Z
<lable>Item Amount</lable><br/>7 x9 r: L! p) B6 D5 Z" m$ E
<input type='text' name='item_amount'/><br/>+ l1 [/ y1 s& r5 t; U
<lable>Item Upgrade Amount</lable><br/># C; r* \6 \% F2 V3 X
<input type='text' name='item_upgrade'/><br/>
& ]# }# |9 n5 J<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)* B& W- Z. m3 y, \: W' D2 t
2 A6 o/ T+ U& B$ P |$ Y7 A</lable><br/>& l' Z8 R2 W7 L- @' i$ J. @7 d! p' ?. \; o
<input type='text' name='item_element'/><br/>. Z) P) e z5 b& g0 A
<lable>Element Upgrade Amount</lable><br/>
; R% j- j/ u5 ~& {, l0 M/ V6 v9 F<input type='text' name='element_upgrade'/><br/>. ?; |/ h! k1 [) J
<lable>Pierced Amount</lable><br/>
- X9 n, ~3 v b! q* ^; \<input type='text' name='item_pierce'/><br/>
' s4 s) D" [" x4 |3 f# A<input type='submit'/>
4 k \$ e) P9 [4 ~. U</form>";5 {+ Y# u3 _4 w& w
}: G# B+ ~ j, b( H* @" y, u
& {; C h! c- E/ M6 @5 hfunction PostListener (){0 u# o; s, m" Q" `4 W+ j! X6 j* I N
//Add more post variables if needed and add them to initform() function aswell
/ v# B; W4 d W. ^: R, D: e/ B4 B2 Y% o2 M
################################
" t5 y9 S' P, O2 `4 g6 @##### Connection and Post ######3 S) B" Q8 e a
################################/ i& h6 m$ l0 E1 I7 Q. M
$name = @$_POST['char'];" W( _' Q5 ~! C2 l/ Y& c) J$ y' ]
$ItemName = @$_POST['item_name'];
1 Y7 D' q) l& p6 E r$ItemAmount = @$_POST['item_amount'];
' i' X0 T' e2 t$ItemId = @$_POST['item_id'];5 G" u# G( J( c, T% y4 h6 K% w0 u
$ItemUpgrade = @$_POST['item_upgrade'];
; O4 z1 G7 E/ t; E/ A8 K. }# `$ItemElement = @$_POST['item_element'];
# g5 L! U" N4 ^8 F3 E$ElementUpgrade = @$_POST['element_upgrade'];
* J8 Y6 S0 d1 c& K* z9 I/ b% h$ItemPierce = @$_POST['item_pierce'];/ x s R2 W j' B
################################
4 z/ p$ k; j0 Z( d
( N2 [8 b5 H7 N8 W. n! l//Check both variables for empty value# x n; {5 r6 c4 T) e) K
- D# d1 B0 ?/ Pif (!empty($_POST['char'])){& @7 }5 O; m9 Z$ m( ?0 A
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
+ P) n3 G, t& ~, X8 G' Y" q( e1 x# [ d# A% }+ {0 S
m_szName = '{$name}'");8 v2 ~: o( ^ V9 T% J( |
while ($row = mssql_fetch_object($find)){
@; [0 T# l" T" _echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";5 B5 }4 z+ f/ E) i6 a* Z' M [9 j* O
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
( @+ S' ]* i: t9 W ?3 j2 Q' t5 l, x. f" t
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], 9 p( T( i8 z8 z4 B: }* U2 W
1 I! G) k5 ~4 ^- W% q
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
; j1 F! c! Z# E* K; u' V
4 G% l) m6 M) v' e5 ^9 i2 ON'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
+ K, ]( u. H% C: w( {( X* [ O& j( b' Q4 }0 k2 X
'{$ElementUpgrade}', '{$ItemPierce}');");
4 F: j! e/ A2 F" [* l+ M}7 x. K4 m7 C' e- G( M
/ i! a, R& c' i0 ]+ F& s
}
1 @% g; M }( e( A$ C5 _2 t+ h8 f# n$ t
}
j+ r2 p% P, p' ]6 ~) _1 z4 ~3 x, E0 S6 q" I- _) b
$InitForm = InitForm();
: v! J% t0 e$ g$ t$Listener = PostListener();- n4 u. U2 A7 E; @& p7 E
7 R- L, G4 M* p1 n' P/ w?>% h8 {( O/ F& V+ _+ h( Y- q: W6 [
0 L9 H( P; |+ Q' s, D% z: C
4 o+ i, C/ _: e+ Y- W1 R' J* ~9 N8 L* I
" K3 p. b8 x/ {1 T8 \- {- ?+ ~! Z. k$ t |
|