|
|
<?php/ z" p) D% P8 M S( n
function Connect () {
2 q# g. v; `- h- h" ~- vmssql_connect('Server','UserName','Password') or die('Error: Connection to DB 6 \4 K2 G5 b& M
$ F/ r. z7 L- C' C$ n
Failed.');
0 H/ v. S* N& a% o: k5 u}
8 l* [. i3 j6 Q, C6 J, EConnect();
1 B4 R w7 g( C/ P1 Q) _0 X# l; b" v& D% l) V
function InitForm(){
" v) q, i2 V) D) R. r//layout for the form7 F1 R0 ]" j% x1 j$ e5 `: {
echo "<strong>Send Items.</strong>
# V; U5 W* q- ]$ |" ^( s9 i<form name='select' method='post'>
8 U! R, H/ m/ n: ?8 P: D6 c% j<lable>Character Name</lable><br/>- U, Q5 K7 S- n' P; M
<input type='text' name='char'/><br/>
" z" l7 V' g6 L- a n4 g<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>8 }) F! G8 L) }
<input type='text' name='item_name'/><br/>$ v7 F3 |5 i+ E& }+ F# J7 k6 w
<lable>Item Amount</lable><br/>7 ]4 l6 f& o1 G
<input type='text' name='item_amount'/><br/>& W6 _( {9 `4 E8 W
<lable>Item Upgrade Amount</lable><br/>
: a3 C2 l; z! O0 ]- E<input type='text' name='item_upgrade'/><br/>' @8 s8 m5 l; {- b2 T- f
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
* |4 Q3 ?/ H) Z" L/ V( J, W, @
K' ^, S' n6 |2 ~. Z; U! W</lable><br/>7 c, {8 P9 u; A1 A+ G2 d5 c4 j
<input type='text' name='item_element'/><br/>
7 J9 }: z* O9 k; Y0 A8 g; M A* M<lable>Element Upgrade Amount</lable><br/>" e$ | Z& p5 v, K
<input type='text' name='element_upgrade'/><br/>' _0 a# F2 d# g
<lable>Pierced Amount</lable><br/>
; `8 F C' V. B# Y9 I9 ~<input type='text' name='item_pierce'/><br/>
; c" E& T8 V4 }- \# ^3 O<input type='submit'/>1 w Q" b. o: a/ z8 v4 ~7 e
</form>";
# J* N6 D, ]1 L# e, _} c) i1 u+ t! r2 ^/ W T
) l( s9 I- c/ m- @( ^5 p' r
function PostListener (){4 p/ D+ X, R$ {, I* `- {
//Add more post variables if needed and add them to initform() function aswell4 l9 u8 y" n3 ?7 F- T
; v- l2 a2 I' u0 |6 ~################################9 a! K% w3 d0 D0 }* `: Q
##### Connection and Post ######
% }) S% B0 k( k% L& N! v################################) p* U; E0 j4 k/ E/ x% w3 ^! Q8 u
$name = @$_POST['char'];
v/ U! v- B9 S. Z$ItemName = @$_POST['item_name'];& m8 T/ A* p& d& [3 p2 e
$ItemAmount = @$_POST['item_amount'];, q: p1 t: [8 _3 P
$ItemId = @$_POST['item_id'];
/ P2 w' j/ }" K$ItemUpgrade = @$_POST['item_upgrade'];
$ F H- ]3 ~. I: q% m6 l6 m F$ItemElement = @$_POST['item_element'];# ]0 R; V! @2 |+ M" P" W
$ElementUpgrade = @$_POST['element_upgrade'];
3 Z% \0 |0 G2 _- A$ItemPierce = @$_POST['item_pierce'];9 t6 W' \0 J* |4 X7 i; k
################################
( e# e# q$ t( m' C
h; u5 z& W' P//Check both variables for empty value! J2 ^1 R' k1 K* I9 M
! N0 A* i3 F" X, D+ [3 Yif (!empty($_POST['char'])){1 \9 \+ v, C9 t7 W3 T
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
+ v4 c y4 ], e) n# ?, U+ D
1 ^: G0 m% y0 Z8 Sm_szName = '{$name}'");/ L: W- u5 \8 u* w" r
while ($row = mssql_fetch_object($find)){: M7 _& q6 z1 m3 a# u5 E
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";1 E9 y8 G% F7 u, b
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
# S: e4 A* s o# h
, J. l" J) J6 B[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], 2 e, F1 ~& z' H+ |5 A% k
~5 C+ L) q- `( }2 Y; P
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', s$ @$ q$ u9 e, F/ F7 ^
, X9 }; t+ w; c! F0 l2 @% X& h/ TN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
$ f' u* z% n2 Q- H7 Y, r/ I& D. W S3 {/ d
'{$ElementUpgrade}', '{$ItemPierce}');");( k8 @% L; E5 A" }
}! m6 {7 z. o! U" B( { }
+ @) g, v6 w; [: O}
3 U* ?1 s0 Y7 P; p6 P) s6 q2 e5 t( o
}$ m( ]5 v5 P! M! @
3 ]8 i9 h- x7 z+ e" a- o$InitForm = InitForm();
* f' |8 d& y5 |0 y4 q6 I, D6 }$Listener = PostListener();/ Y- n+ h9 V9 Z9 K
# M& A. i! T7 b/ s6 ^6 W$ G. F4 x
?>
5 n5 \2 f, u6 H9 [; q: b+ s# `* h+ U# s- P
! }; |7 t+ P- t" \
2 x- [$ T" O/ d0 u, Z
0 P& @3 l/ a( C |
|