|
|
<?php j9 L1 g3 C' l4 w4 P4 m
function Connect () {
* p7 |2 r$ K5 S. Y) Amssql_connect('Server','UserName','Password') or die('Error: Connection to DB 7 ^' C9 Z# R5 R+ c7 j3 a
# g$ R/ k1 _2 }( i- B3 o+ W. q* \Failed.');4 Z3 B( M3 S; B7 W E' w
}
3 N7 u- H# {3 G( B7 W3 V, TConnect();. a6 R. u) y+ y4 r
( n* e- f, R! rfunction InitForm(){: J8 m3 Y/ J. D- H9 I. K
//layout for the form$ k- y/ Q; k: o; m$ k! M$ W
echo "<strong>Send Items.</strong>6 Q+ W: ~9 O( [& D$ y" n& W
<form name='select' method='post'>! j& Z9 \1 S$ L
<lable>Character Name</lable><br/>
* M0 C+ N# v3 I) _# s( q<input type='text' name='char'/><br/>/ ~" m! s7 s7 l( d p
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
1 E: u, ~6 e; t: x<input type='text' name='item_name'/><br/>
2 {# I' c1 j+ v. b<lable>Item Amount</lable><br/>( b4 o4 w2 \' r) n2 P9 ?9 {/ x( J
<input type='text' name='item_amount'/><br/>
4 V4 F3 ^) L# n- h0 @ x<lable>Item Upgrade Amount</lable><br/>
, s, ?7 V: J1 K5 ]4 q2 w<input type='text' name='item_upgrade'/><br/>
7 \9 Y/ A: d+ `( M3 u0 I u<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
; K. r/ ]1 _# ^2 J
, M; T! \, ]. k3 E; n$ ~</lable><br/>- Q8 b/ C5 r* B6 t% T
<input type='text' name='item_element'/><br/>
7 J$ P: c- F5 j0 h. k- H4 c/ Q: J<lable>Element Upgrade Amount</lable><br/>- e3 k( g" y, A6 v4 _8 `
<input type='text' name='element_upgrade'/><br/>
$ b1 A6 x/ t3 a) D% |<lable>Pierced Amount</lable><br/>
' a5 C# m7 g3 m- D* s6 K<input type='text' name='item_pierce'/><br/>' i: I4 v4 p- K
<input type='submit'/>
" p, E, V2 l, y, J$ I2 m- q</form>";3 A6 `5 B6 {7 }0 O9 I0 p! D
}* ]+ i: j* j# l
y4 Y; k! i+ q } \3 h
function PostListener (){
8 h3 G8 Z3 I/ Z7 B5 N, C//Add more post variables if needed and add them to initform() function aswell' W2 J$ s2 h6 z3 N/ C. T9 m6 z$ ]
% D: T6 O" U+ [3 v################################
# l5 m& ?+ r6 w##### Connection and Post ######: J4 s9 _2 `2 `. I4 L0 d0 c+ K0 `
################################
3 X2 M7 B5 n( F; _# F1 i$name = @$_POST['char'];
5 G# }! d9 e9 ^. {5 u5 N' f$ItemName = @$_POST['item_name'];
( R7 Z& B! y* N4 s4 Z8 ~, A$ItemAmount = @$_POST['item_amount'];- ^/ c; U: S: [' Y; A' S' H# [
$ItemId = @$_POST['item_id'];8 w. k9 `+ t$ J6 _2 R
$ItemUpgrade = @$_POST['item_upgrade'];5 g- {! H# k |8 T* g6 p# m
$ItemElement = @$_POST['item_element'];- C' e: V+ l1 B# X! H( k
$ElementUpgrade = @$_POST['element_upgrade'];
5 i$ G( r- S( w$ItemPierce = @$_POST['item_pierce'];
6 t/ ^% z3 i# Z. x################################
5 B; `1 S6 G4 O& b6 O! _$ }+ ?& K. V+ @# C
//Check both variables for empty value
; M2 o8 Y+ V9 N' `, C. v: \) r: R2 G2 u. G
if (!empty($_POST['char'])){
' n; c5 C+ y3 j( |- Z; w$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
/ ?. v( R- i! o: G: v. g t W* V4 V) d2 @0 g) D o! S
m_szName = '{$name}'");
9 T& g" ]" u# Jwhile ($row = mssql_fetch_object($find)){
* D& m3 y2 Z$ ^" T- q8 qecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
. {# j" Y7 r* @- E5 s$ ~' a$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
& F- d6 U( W. v+ b2 z$ E7 B+ h. c1 L# U" s
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], % |5 d7 l$ o S- T" u/ U. l3 O+ \
G9 y$ a3 _- ?7 s/ g
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
0 Q C: _& @3 E9 W
" z" g" d7 }9 T: ]- rN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
, [" g2 p5 ]7 {& N/ b
( f0 _* {% f% Y( R8 L, {'{$ElementUpgrade}', '{$ItemPierce}');");& T2 S+ e. A8 I. x8 |2 Y
}
1 p) m, v. P9 [1 w- d$ j) {* I. G1 ^8 l5 p R# u$ L
}
' z+ _1 p0 f! m. T$ K* R( S2 J" h1 V( N* g3 P: l
}! F0 L: Z4 P. w+ [: P8 I2 a0 d
: P; ~* B. V1 R3 e, a
$InitForm = InitForm();0 ?- d% q6 A0 i3 Q8 r. P. D! D
$Listener = PostListener();6 h& L7 I5 K/ g+ w0 {6 h! B
, B+ K9 N& y. @, i$ V6 ^( q?>
7 `& n% v9 L4 s
" T6 p- w) f& b, V1 u7 S5 k9 W
& Q& L8 |" h7 i5 ~. h0 }
$ v* O, d- z' j
d/ v t3 r& ?, N X* d |
|