|
<?php
7 |. O# I# n( S4 r1 G4 hfunction Connect () {# a$ Y) @4 X( f7 E
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB / |* g; _. e9 C
, a9 w1 z4 S+ o! [4 l9 F6 ~' k
Failed.');
9 b5 Q9 D" j8 r3 F4 q5 W/ m}
! o3 c. Y. n# y$ i; G/ zConnect();! ~- k7 {& t& X6 w+ a' l7 p
) o3 ~2 z' N+ h3 Y: E1 z Bfunction InitForm(){7 a, o ?7 L4 e, _; ]& Z) W
//layout for the form7 H! ~& Y9 R& U- P0 D/ m' ?2 r
echo "<strong>Send Items.</strong>
6 j1 M1 c3 u4 n5 s( P( d8 z, \<form name='select' method='post'>+ r6 }. }+ ?2 }
<lable>Character Name</lable><br/>+ s5 q, F* \& I- }
<input type='text' name='char'/><br/>
& j9 ?1 f9 D. x, P+ F" Q/ G<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>. `( f8 y `' m8 p5 e! Z
<input type='text' name='item_name'/><br/>
( X/ s" ?7 @' C' P<lable>Item Amount</lable><br/>% h1 A% E9 c! t+ x; v
<input type='text' name='item_amount'/><br/>; V6 P) @; x2 w$ _& q$ e
<lable>Item Upgrade Amount</lable><br/>
9 k$ B( l# P" e0 n0 m# ^% J% w l<input type='text' name='item_upgrade'/><br/>& _ J0 ]. ^' c$ [% g# D. e% _
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
- Y1 a( C. _% @* F9 i) j
% |; B1 d+ O; J5 n0 ]7 v1 R% C5 M5 J</lable><br/>
+ ~( e7 F. n6 ] V& z<input type='text' name='item_element'/><br/>6 a5 E, D* J# V4 P
<lable>Element Upgrade Amount</lable><br/>
. N. |/ S& W9 C* j/ N' v6 C<input type='text' name='element_upgrade'/><br/>
& Q3 l& k" Y9 `+ a5 T<lable>Pierced Amount</lable><br/>
1 a: z+ E) S* d) r2 T<input type='text' name='item_pierce'/><br/>( v. [; k" X( [' `/ D
<input type='submit'/>
6 z5 @/ s7 I. O' j; h8 A. h</form>";
' d( {, l# h7 A8 ]}
# x. e* {2 B, n% y) g8 B- g1 s$ Q7 e8 b6 S2 r% Y0 \$ M
function PostListener (){
/ L7 O1 L) r3 }//Add more post variables if needed and add them to initform() function aswell( C6 B; j d% Q+ [6 a5 A+ i& z
7 v- ]6 C( ?* l/ b6 h" F O
################################
) S* ? d6 v. f! a##### Connection and Post ######
1 F) K8 j4 f u, _: K################################, w" I) [2 U& p! ~, ~
$name = @$_POST['char'];0 E/ }! O2 e) B% y2 e, v7 H2 z; S2 b
$ItemName = @$_POST['item_name'];
% M$ Y0 x% k4 J$ J& I- M+ K5 n# h$ItemAmount = @$_POST['item_amount'];
1 y: n% t* C" t$ItemId = @$_POST['item_id'];
7 G- s. A: l+ S a) \5 H! m$ItemUpgrade = @$_POST['item_upgrade'];
3 R9 w5 h5 e% e- N0 v$ItemElement = @$_POST['item_element'];3 ? D& t, B* T' o# r/ ~4 E5 d) i$ W
$ElementUpgrade = @$_POST['element_upgrade'];
. N6 ?8 N2 I& W7 Q' R' R$ItemPierce = @$_POST['item_pierce'];+ Q" m5 v4 A( q9 ]* @
################################& t; K& {! r5 P8 |$ K( T- H
& @, c7 j. [" k/ s" i4 g$ C" x% N
//Check both variables for empty value" W" H& V6 o, Q: W0 m
: A; y* I9 @. N$ yif (!empty($_POST['char'])){8 `: U- o# v8 j9 ?8 D& I/ R9 L
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
) ^2 h! E$ L/ V& V2 j1 F! x9 S2 r9 k1 f) ]+ y2 e' S
m_szName = '{$name}'");
; o0 b- b! u0 c9 ]& dwhile ($row = mssql_fetch_object($find)){- K6 C" H$ w' [$ S
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
4 i" m+ D [ _5 G9 Q2 {$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 7 F: |" e. t; t! `4 L& T& X
" v( ^* ^, f" V
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], ! N- v- ^9 ]+ b; B! n8 @. d
9 _ e- p$ {3 s2 b9 @& U, G
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
8 @: U6 W: Q- M; ~8 p$ X8 M
% S: t$ |& Z9 Y( e! E6 PN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
& ^( ^& j9 M5 |4 [6 k# n7 F& |8 p7 P/ X% E; r! X, X
'{$ElementUpgrade}', '{$ItemPierce}');");
9 U! j$ P4 S! g, K. l}' I" g# d& q8 Y! {% N8 ~
3 I2 ^) o, y5 \/ N* N# m6 \% a
}/ N* e3 R. g1 a Z
( A& r; V9 s9 S" l
}
% ?3 p6 A) C+ a6 \$ }/ l' ^7 ~( j1 X; | M( |: T
$InitForm = InitForm();9 I$ ]) v& Q, l3 o
$Listener = PostListener();
/ H/ W9 f* g6 a( v' X' N) a g+ |3 @
?>
2 b6 a. Z# j9 z
% r5 U I. S1 N
* b" @7 ?$ t$ ~5 E' V* U/ @- p
! R' V( O) `5 u5 H3 W& m V, U+ [9 G
: G; n; e5 j( v; \: [7 b |
|