|
|
<?php% y1 U8 ~( M4 `# D8 ]* X- H% e2 B
function Connect () {6 s- \/ I- [* j: \1 [1 u3 k) m4 x
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB 0 K% a1 i# \' T2 S/ Z2 s7 y$ H
" s3 x' a* j8 h8 s3 P' tFailed.');8 b, H1 D) n( k4 Z, N
}5 R: r$ J' }0 M- E# o8 `
Connect();
4 I0 V( S4 V- E8 J& H! s& M) G; ^2 S6 z# o2 e( c' r% k
function InitForm(){
! i) ?, p5 G3 F9 V//layout for the form
. ?) A! _5 `( J7 P9 p5 x% ^echo "<strong>Send Items.</strong> k; O8 ~4 y9 P8 d. E9 c* l
<form name='select' method='post'>
+ O8 {4 r! D% l j) v<lable>Character Name</lable><br/>! B0 U7 M X% Z; h3 o5 J4 u* T
<input type='text' name='char'/><br/>
8 T3 [$ ~! h' H3 v* {4 s<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>( z, ~: i) r+ a. s, Q9 b/ [
<input type='text' name='item_name'/><br/>7 ]% }9 h2 F4 D1 } q
<lable>Item Amount</lable><br/>5 \. J4 X7 r5 y1 Q
<input type='text' name='item_amount'/><br/>, S4 R7 z3 p. v, t4 I
<lable>Item Upgrade Amount</lable><br/>& h% Y! Y3 k( N8 H* D
<input type='text' name='item_upgrade'/><br/>
( U; J, i$ Y' P0 I/ c: A4 E0 `3 z<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
; |9 c) d. J1 p
' r2 X( K2 H- z, j( E</lable><br/>
( H) ^0 U4 ^ W. a5 }<input type='text' name='item_element'/><br/>2 y6 w2 q% }1 s
<lable>Element Upgrade Amount</lable><br/>
W! B4 f( q) F% e<input type='text' name='element_upgrade'/><br/>
4 L: K! [) U3 e$ g<lable>Pierced Amount</lable><br/>
+ E9 a# O' v( N3 X0 S" X$ M<input type='text' name='item_pierce'/><br/>
/ r7 t" x9 P/ d# A' V1 M<input type='submit'/>" O8 T. b E* `# N3 B/ N
</form>";
7 N, [9 g/ o% \/ l7 A}
/ p I3 E2 `5 ?; f* k9 u5 g& y( l! z0 Q6 a8 p% \
function PostListener (){
- W/ ], @% M. e9 C* C* Q9 `//Add more post variables if needed and add them to initform() function aswell. g) L4 E# L. G
6 k6 s, G2 v7 P$ p |, M, K
################################
, g4 n: [ n% S+ ^; ~. P##### Connection and Post ######
; \7 I3 R/ T/ f7 k- J- c( I2 c################################
2 h4 h- s7 W `" D' c+ L$name = @$_POST['char'];1 x e" o% s4 x* ]
$ItemName = @$_POST['item_name'];
; ~$ B1 }$ B/ Z. {& i q, J9 c8 W: G$ItemAmount = @$_POST['item_amount'];. j* ~* m# Y( D1 a8 E3 W( L
$ItemId = @$_POST['item_id'];
8 ?/ \& ?1 K. g% K/ a) p G$ItemUpgrade = @$_POST['item_upgrade'];
) P" x0 L! V( p9 H6 T7 J2 x: d$ItemElement = @$_POST['item_element'];
% h& w, {8 N+ o5 O0 s6 D) p$ElementUpgrade = @$_POST['element_upgrade'];
7 p0 P# h- G' J: x$ItemPierce = @$_POST['item_pierce'];
" x; C9 `7 w3 `0 s################################
% G# j, ]8 M7 a$ _# k- f; ]4 e+ ^4 |7 C9 q' N2 P
//Check both variables for empty value( D( [* W3 w+ n
# d7 _: c4 n4 x( Vif (!empty($_POST['char'])){5 W1 X6 G- X& |# g3 V0 r
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where . v. k. ]) s. p
K6 a! W6 j: v6 o7 k
m_szName = '{$name}'");) }3 a, I. ?1 I( T$ g) i
while ($row = mssql_fetch_object($find)){
0 X) L4 j+ [, l! V8 \echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
' O* V0 Q( q# G: P6 ?1 g$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 1 P$ L: M3 ?! D- P9 O( d2 g
2 ?" u. ]: `$ A; O[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], ' @. W% O' A7 F9 I/ V" e) n3 [
9 j) O$ E9 Q1 V6 C n3 e2 ?3 _[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
. U; ^2 v d$ B: {0 T, ~. M" t5 p# |% n0 T# _5 R2 S
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', ! g) M% h) X: l4 h, ~5 {& ^* X+ p
" c. R# |. k! h* Z: ['{$ElementUpgrade}', '{$ItemPierce}');");/ T9 o0 }6 q1 d
}& S. C# }" H5 v; ]
+ Y: D3 _, C' h4 y1 ^) J
}
9 w$ K& o7 C; ^. m' Z- m9 ?% Q1 h# _
1 `/ j5 n) r" {5 c0 S1 ^}. \% J% g; C0 J& d+ e" u. k( H1 G
$ @0 v# T7 l# n% Z+ f6 f0 t- O
$InitForm = InitForm();4 X3 Y: e7 s0 Q$ U K8 o
$Listener = PostListener();
! ~* G! e l4 l. X* L7 w. m6 o3 P4 d8 ^: Y% U
?>
. I) a3 g! R. y, y l& _3 P& h8 b$ i0 {3 Z' G
% E7 o; V; v9 E5 v' U: k9 E8 a. F$ M+ M
% O! h) v! N! E0 o B6 Q
|
|