|
|
<?php
. s2 @8 Y8 z3 I! i' J1 Jfunction Connect () {
; e/ d4 N3 i% R5 J$ Q' O7 x. imssql_connect('Server','UserName','Password') or die('Error: Connection to DB
; K' Z1 |' k7 y1 n4 `$ n9 K7 u* C; W) d* i) e" W
Failed.');2 W% K6 ~7 E# F ~
}
# t; A, j5 m8 I5 }$ k" UConnect();
1 s- M. Q- G; Q4 O: h
- A$ D4 t( v; z3 Z4 b- x% n' ufunction InitForm(){
- i/ |/ T* y S: v+ l; M! B/ c//layout for the form
1 y# d% T9 P3 ]echo "<strong>Send Items.</strong>
/ W, B! d* g8 l4 Z% k9 Y<form name='select' method='post'>, k C4 u! t4 U7 r6 Z
<lable>Character Name</lable><br/>! F9 O# ?& T% E& M
<input type='text' name='char'/><br/>% J Q/ p, |7 g7 ^
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
3 D1 v- \' K; Q" U; M8 a<input type='text' name='item_name'/><br/>. p+ n$ k" s/ }7 I! t" W. i! E
<lable>Item Amount</lable><br/>
# D. I$ F4 V* _7 o7 h7 u<input type='text' name='item_amount'/><br/>1 G) f9 k$ H' t
<lable>Item Upgrade Amount</lable><br/>, f# c! H; |* E/ H9 o
<input type='text' name='item_upgrade'/><br/>% Y. U" L, q# J$ g/ p
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
8 t) I0 }" F# w) }2 f* C( m; ` ]7 ]! D
</lable><br/>9 C+ x2 w: K/ \; {# G: f
<input type='text' name='item_element'/><br/>7 V ]. d! d) j1 ]
<lable>Element Upgrade Amount</lable><br/>
& m7 u& l6 U. L1 `0 X- H0 ~<input type='text' name='element_upgrade'/><br/>; B& _6 {( I" y. X# B& l
<lable>Pierced Amount</lable><br/>7 t! w; C6 Z; E) b* b& o
<input type='text' name='item_pierce'/><br/>
2 u9 q& K6 Z) Q) B& Q, L7 J<input type='submit'/>
, E7 g& L7 U) b' S& _/ J9 c c</form>";, h8 E) E& d! w& c' b6 |$ u8 H
}
9 L! Q& Y3 s; d, v& o7 D! e% R4 {% R" p/ G+ U3 s* Z- k
function PostListener (){9 s* T# s, _% r5 U5 ]
//Add more post variables if needed and add them to initform() function aswell
/ A& X1 a2 M" U- b( }; a3 [/ |9 M5 K1 ]4 O) j3 i: Z l+ n6 J% Z# ]# s
################################
# W& Q- z+ n$ E# |! e. o##### Connection and Post ######
# V5 V7 ^4 T, k* i2 R. G7 S% q################################+ Z- ^9 k w K$ N. c
$name = @$_POST['char'];# K. @+ }0 H' o* ?& i, h& o
$ItemName = @$_POST['item_name'];1 |4 |( Z3 V) }. R/ U
$ItemAmount = @$_POST['item_amount'];
( Y2 f6 t( p7 T7 b* Y) i- G$ItemId = @$_POST['item_id'];8 l/ `% F6 w3 u6 _
$ItemUpgrade = @$_POST['item_upgrade'];
' o5 s' h/ O6 I- M8 \$ItemElement = @$_POST['item_element'];
( L9 O$ {. C/ s" o) \9 p$ElementUpgrade = @$_POST['element_upgrade'];0 u% ?' \+ Q y
$ItemPierce = @$_POST['item_pierce'];% ~3 x" m& O# E% e1 S; r& p
################################( D8 O, S q: j% U! U5 \7 X
$ ?9 B# F+ ?# j" B//Check both variables for empty value+ w( B- y d/ S; V. B' \! h
+ `8 C7 ]/ ^: ~& {2 o
if (!empty($_POST['char'])){
5 q4 m! m u; ~% G M( m$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
( P$ |& x2 b% E( u: U
# k9 w3 r+ V. g, [m_szName = '{$name}'");
9 g9 y/ W" Y+ l, ywhile ($row = mssql_fetch_object($find)){
% q9 D( c! ]' a) F' @+ G# decho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
1 O- l. b! C" H' e$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
9 \" u4 o/ y! R, ]6 ~, c* y, H
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], 0 T5 ^5 T: d0 f4 F2 @
5 G1 P; a% w# t8 Z$ K[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', + h- N; v* H' y8 u: P
! C3 I/ N2 y3 f4 h
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', % ?. u/ v J# n3 u# Y" W" p
4 L$ j5 R8 {# _: l8 H" M'{$ElementUpgrade}', '{$ItemPierce}');");
, W- B t; @8 o}
8 c& i7 z7 f% ?6 H8 q. ~9 s% n3 n/ }, F; F6 N" z+ d3 j5 z; D- n
}
: R9 H& ]' U; C1 V, W
( K m$ k9 N& P" Y}3 c! C' e& v T1 @8 L' v
7 @. C" T% `- x. |- j8 u ^- l, q# p
$InitForm = InitForm();: J# Z) V" Y" ?* Z% b
$Listener = PostListener();* @. ?) S2 H: }5 j5 \
, a* L* i2 n ?! e% r
?>
5 W+ j# ~/ B9 ?( q
) Y5 L' `% i N' O
% o% C6 L/ a7 G3 g8 w% Z: \# a$ a; k5 I: j# ]
q& q' L7 d9 W( B9 {9 D: K |
|