|
|
<?php
$ i- E( S& u' Y9 j+ Yfunction Connect () {' B+ S9 G1 C+ p, ]
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
0 O g5 J. E5 c% ^8 n" d% D2 p# F! W' R( j
Failed.');) l: w0 d3 h. I9 {6 `* _/ u
}" \% s# J9 ]9 v
Connect();9 b3 u* m3 _9 R: d4 I
0 ?) b0 F6 F; h6 afunction InitForm(){! c' r* P8 W5 }
//layout for the form
, @( q [5 X; f$ a t4 x/ jecho "<strong>Send Items.</strong>
: `" j4 E w# v# z<form name='select' method='post'> Q- W# v7 v O3 @0 e, `: i. ]. L$ n
<lable>Character Name</lable><br/>
; N: z2 n$ P8 i! ^/ O8 C<input type='text' name='char'/><br/>; L8 k0 X+ M+ I# G+ ?! a6 L6 \. J% G
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
* d9 \/ u& ]5 C8 g<input type='text' name='item_name'/><br/>
( \# g5 g$ N2 }# W- c<lable>Item Amount</lable><br/>/ M8 s. V# Z1 T
<input type='text' name='item_amount'/><br/>
( T# M! y5 z5 Y<lable>Item Upgrade Amount</lable><br/>5 {8 H# g: H+ ^ X
<input type='text' name='item_upgrade'/><br/>
8 i' V/ F, ^+ V- {! Z5 O! h2 p) |" j: X<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)1 \- O% d) l% Y$ U$ I. T/ [
3 x- C- s+ B/ Y. a4 ]5 L</lable><br/>
9 t' r( g% F( R* c& w<input type='text' name='item_element'/><br/>
' J, J, R& \% X+ g# P0 v& }2 K<lable>Element Upgrade Amount</lable><br/>" X, G- Y# G: s& H
<input type='text' name='element_upgrade'/><br/>/ J' \% F1 U: j
<lable>Pierced Amount</lable><br/>
7 |# S0 {) J2 k# g<input type='text' name='item_pierce'/><br/>
% ~# u# p, c1 d, ?<input type='submit'/>
* ?1 M7 X6 n9 m</form>";
9 y* U# I3 A$ d: R- N ~( q4 i, m6 }}+ h6 J0 e0 A! f+ p, @& E8 m8 t3 s
' d; a0 m4 G) i; Lfunction PostListener (){
5 i/ F1 r7 s' K3 K6 h0 Z! D//Add more post variables if needed and add them to initform() function aswell+ w& ~* t/ F4 e. Q
. [7 j1 M- s; {3 z" ~1 X################################: k( K5 }2 ]0 E1 o! s1 F% ~/ k8 @
##### Connection and Post ######/ n! O( K; q) U& J
################################
! o* f$ ^6 X; A; ]/ t& [6 y2 y* ]$name = @$_POST['char'];
4 s9 E2 j# p6 p0 k$ItemName = @$_POST['item_name'];
& t8 e1 ~. ~9 v2 T4 S& K$ItemAmount = @$_POST['item_amount'];
7 A5 v/ i: } q" I. i. V# h$ItemId = @$_POST['item_id'];
! w7 H j P4 ^% C. ?9 r2 }! Q& v$ItemUpgrade = @$_POST['item_upgrade'];
8 j, |! K. W4 u! s- _, M$ItemElement = @$_POST['item_element'];7 g: a* u( C1 r8 O
$ElementUpgrade = @$_POST['element_upgrade'];
9 M% Y. r! c9 C: W! |' b1 ]$ItemPierce = @$_POST['item_pierce'];5 R! F6 b; C% Y
################################ R3 \" p& n$ T0 K
+ K% P$ \- m/ o" I% ^8 Q, h) ^. m//Check both variables for empty value: E" n5 D& P# K
+ g9 c p9 [) j. Aif (!empty($_POST['char'])){/ r: _+ v! \. G% U
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where ! ^4 r- l4 o' U9 a% W0 F% y+ U1 ^4 i
' K2 {1 A' W1 [
m_szName = '{$name}'");$ l3 @* B$ e5 b
while ($row = mssql_fetch_object($find)){* r) ]: N A" l
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";6 Z- v9 K0 M$ v( v- m% F" B2 P
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 1 ]4 E: s+ F) a
$ Q, }; _3 k8 B q* ^! C8 C) P
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
$ V* K) a& A- _! U- |9 m8 w2 m& H. f
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
/ x7 o/ d1 e! y- u" p k) @3 Y- u, C9 P
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
% ]& R7 } _* B: a& M! ~
" I' n/ Z9 ?5 p0 I7 d5 E* m'{$ElementUpgrade}', '{$ItemPierce}');");4 s Y+ u, Y6 ^3 X+ W; N: B
}
9 b$ I& {5 |& Q+ `! d5 a5 ^; u' l$ S. H: z8 U0 K
}+ u- n' o. d! C2 j
6 F" v7 w7 ~7 \! }: u( V}' B1 t1 B+ } h
" G6 B0 ^! f( Z1 j9 v3 p( X! U6 M
$InitForm = InitForm();, F; l( m7 y+ k) A! L, X( P1 v$ r7 t
$Listener = PostListener();
H) n$ M- F/ c; ^- L
) H, }% v( n8 S; M?>5 Z6 a2 X5 M7 l$ M; ]' h
2 R9 U& `" \1 M
# s p6 U( g% q' T7 D- Z5 r- {' Y. A( g7 s# I( Z) C- J& y" Z
3 Q" I) {8 R! w" R* J9 U, \2 W$ |
|
|