|
|
<?php
+ L3 D' U6 @2 I/ e" I: Bfunction Connect () {
; v# ]$ e3 {3 ?& r: x, ymssql_connect('Server','UserName','Password') or die('Error: Connection to DB 5 f* O& }8 d3 }: W' }% o# B2 ?
% m: A% N+ R: X( a. _
Failed.');
# u# s7 m v) I}
7 d6 ^' \% S( ]/ U8 u, `Connect();% V, a$ F$ v3 }4 n6 F$ r) i
. ] V* J% h5 Bfunction InitForm(){5 R7 k* ^ E5 ?1 [9 b) z# f5 K6 p
//layout for the form
& e1 i+ V& A Q. ^* uecho "<strong>Send Items.</strong>% ^4 W7 B4 R( N v4 B9 p
<form name='select' method='post'>
; s, n8 \7 l2 ~! D, y" T<lable>Character Name</lable><br/>
: Q J) `, E, a4 H* N: q# H<input type='text' name='char'/><br/>& A. Y. G% R! ?) f3 a; e6 |
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
) j- i$ i* ~/ S0 E9 B1 F& f<input type='text' name='item_name'/><br/>1 }- |1 {0 C6 W7 z) c
<lable>Item Amount</lable><br/>4 s" o$ ]* B6 q% N0 N
<input type='text' name='item_amount'/><br/>% [& h, X/ L7 { L; l- ?2 ^
<lable>Item Upgrade Amount</lable><br/>7 E- r3 |/ O& w$ H1 B4 a
<input type='text' name='item_upgrade'/><br/>
+ V! g; y* M$ Z- M3 R9 o( F( e2 P<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.) y, i0 w0 ]# t z: O
2 q3 g4 T9 j7 t
</lable><br/>
" G& v4 s- o# B& I# W<input type='text' name='item_element'/><br/>
8 o% o& m( y: [ o<lable>Element Upgrade Amount</lable><br/>
8 k% \/ y# X# f* m<input type='text' name='element_upgrade'/><br/>
/ b, R, r$ \7 l, J8 l<lable>Pierced Amount</lable><br/>
; N2 {5 C/ @' U: J$ l; e<input type='text' name='item_pierce'/><br/>) R+ I! @, r; S6 w3 b
<input type='submit'/>- Q8 ]: ^" P# s/ \% r9 @+ q' e
</form>";1 F9 ^2 ?+ e" T3 i
}
0 y4 i8 {: m7 ~* s3 b: i- M& G/ B# z' F: `1 u
function PostListener (){2 [$ H' g6 M$ J; L* u% m2 v
//Add more post variables if needed and add them to initform() function aswell
3 f1 Q2 j! H: e6 `+ K5 Z9 T; T' o9 B" J# L2 S6 Y. D
################################1 S, H# G& @- x3 l& ]4 b: S
##### Connection and Post ###### x- l. _0 J; R- p0 M( t
################################% t' D P. e u p$ p' \
$name = @$_POST['char'];
/ K; h' e" g: _) e4 G: z$ItemName = @$_POST['item_name'];) q2 x+ u( ~% D2 l! s7 I
$ItemAmount = @$_POST['item_amount'];9 ~- n( I9 S% D3 d
$ItemId = @$_POST['item_id'];
6 U3 k4 N/ G: s- }6 k: D- _$ItemUpgrade = @$_POST['item_upgrade'];
+ O% n8 @: _* w K! }% s4 H$ItemElement = @$_POST['item_element']; ^; f/ B9 n7 N. X
$ElementUpgrade = @$_POST['element_upgrade'];9 G4 x {. m- ]- k
$ItemPierce = @$_POST['item_pierce'];
. w9 ?2 f9 K- t################################
/ T) E2 k7 i. ^) t0 L; J( O$ Z$ F/ L8 B
//Check both variables for empty value' b3 z7 Z! V/ U7 r
( |5 o# s! z$ [if (!empty($_POST['char'])){
( v' q f6 b2 E$ \* W- ?$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
* |: E! W& i( P: d: Z& a; h; Y7 V
3 O4 |9 f* K/ j4 Q: z; D$ c0 Xm_szName = '{$name}'");
0 T$ o* e% f9 F% l Lwhile ($row = mssql_fetch_object($find)){- V; o: T1 I$ N( x& J
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
. \* R/ g+ }/ x1 G, X$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 8 ~( a! Z+ v) [+ h
+ z. s+ C7 N9 x& U: \
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
( j5 ]% _7 F3 `. Y% d2 G
2 W0 f$ k% v! j" x) J[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
& r q" A5 F: N4 y; F6 ]- n& N3 a
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', ! z6 R; n/ r! T
8 U$ A* S [9 d( I% q0 v1 V
'{$ElementUpgrade}', '{$ItemPierce}');");# `7 I% t, p9 p8 r( d$ f
}
( T/ N. Q ^- p( m/ U. N c% |. [7 o1 I
}
_ q6 ?) y% U6 N4 X9 ~* \
& j0 R# }4 N! M/ e2 Q$ k}( e2 V) k2 T1 y, S
7 J9 N) g% {1 k( L& y) [1 Y
$InitForm = InitForm();6 k1 m8 g) v; w, U0 i+ u
$Listener = PostListener();& K- p8 @" O& Q
+ l# V0 W6 l! F5 X" w) K
?>; V v; E! N ^4 J4 y! ]1 F- |3 R
" `# P2 O5 E u6 p) P" B
7 Z4 q; S3 a( R) K2 h3 ?9 i2 P3 k8 \
& n" {; S# }% S
|
|