|
|
<?php) V0 P# j5 j' g
function Connect () {
8 D+ s" h2 d4 w4 Lmssql_connect('Server','UserName','Password') or die('Error: Connection to DB 6 r* n" V* T+ e1 c0 U
2 n' n0 @7 V" X
Failed.');8 m, N: @9 E' m7 Q6 `7 Y
}; v; g3 O" w+ E) \: d+ o
Connect();
, E* [+ T2 ]# P4 T, P
' ~1 T) I N- Y4 ?& q* y) J2 }; A6 Cfunction InitForm(){
; V& C# \) [/ O; O5 i+ M6 `//layout for the form
6 {, G4 V2 a" n: D+ ^& hecho "<strong>Send Items.</strong>1 e! ^: F& a5 I; X0 J
<form name='select' method='post'>
& _0 @8 O# K( n3 l$ E% L" Q% U, D<lable>Character Name</lable><br/>
0 D# U1 { _6 @* T3 W& F<input type='text' name='char'/><br/>8 C3 }% T: A- |6 U
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
- a2 q2 k% Y l& k* y& S, ]<input type='text' name='item_name'/><br/>
# U" ?. y2 [1 S' l6 t. N<lable>Item Amount</lable><br/>+ B% \/ q( ?( S. W# Y
<input type='text' name='item_amount'/><br/>
/ B/ [* K: v4 I% @* [* }<lable>Item Upgrade Amount</lable><br/>& z) n M5 M; S9 g, i* ]4 h! s
<input type='text' name='item_upgrade'/><br/>" r! n* X; U! I' k% u# e" F3 f# p* [
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
* m, N# o4 `5 ?4 ^3 d
* r& D4 u' s: A+ E. C</lable><br/>
) s5 T; R ~3 M% y- ]1 ?; X ~: H<input type='text' name='item_element'/><br/>
. s- H! o- }, {7 S. q<lable>Element Upgrade Amount</lable><br/># V- C+ ~5 `. d. M, `/ J- t4 g
<input type='text' name='element_upgrade'/><br/>" |" s# a) H+ k) c; d- p, [: n$ r
<lable>Pierced Amount</lable><br/>
. w* K% B& I1 u5 I<input type='text' name='item_pierce'/><br/>& F2 [% |% K9 V9 w
<input type='submit'/>& F$ H2 V G/ x' B: l# P% f! [# N& h
</form>";. | b9 M& A, O* q' ?3 j5 h5 j
}# D# x) C3 L* K( C* t: a+ b0 F1 g
2 W! m! I% l# y2 I4 v" }function PostListener (){+ Y4 d2 f/ H* X$ R
//Add more post variables if needed and add them to initform() function aswell+ _0 O, ^: Y1 N& }+ G) [, Z
' W& B$ O! K4 _5 ~6 j
################################
2 V& ~5 @+ l4 a0 }& N##### Connection and Post ######
) J0 M# K* |% W; v' T$ x$ o2 q! V) n################################
* ^8 @9 b7 f0 Q5 E$ T9 Q$name = @$_POST['char'];
- ^4 ]9 T+ J( v3 v- P0 B6 f8 f/ U" @$ItemName = @$_POST['item_name'];, q2 `/ Q+ n, [$ ?4 V
$ItemAmount = @$_POST['item_amount'];2 \1 a+ H# T* y( ?! b$ y% v# ?
$ItemId = @$_POST['item_id'];3 h$ K7 ~6 Z' A+ r. m
$ItemUpgrade = @$_POST['item_upgrade'];
1 I& a9 w3 Q- Q5 M O4 N# K, R$ItemElement = @$_POST['item_element'];
5 [, d0 F. v- s, K( R* |1 j$ElementUpgrade = @$_POST['element_upgrade'];
, ^/ ~$ v( b& e; x$ItemPierce = @$_POST['item_pierce'];6 l9 D/ E' V$ k2 t. n
################################
3 y7 B6 ^5 D) b [( z
0 l' X5 ?$ D7 K+ N4 t//Check both variables for empty value
9 J4 ~5 P+ T# t+ J) h( t4 j: I5 e3 [/ z2 _
if (!empty($_POST['char'])){/ P: O# R/ ?$ [2 v( f
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
' ]. B2 |" G o& T3 N
n( f5 g) C. O5 `m_szName = '{$name}'");1 H/ |% b0 H1 i3 ]
while ($row = mssql_fetch_object($find)){' G! g8 H" c: j4 y3 p
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";8 ^5 O; X, T; r' v- a5 X, ?
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 8 K2 o3 [. B5 g d+ O& a
' `0 t3 U& N8 u5 U" S4 r' r[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], / q. j: T t2 ~5 D
' J4 d! k. G+ H) q. J' D; I2 o[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
6 {1 w0 @4 C' S6 v; Z/ }, S+ q" k1 t* T! A& ~% [
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', # x- f! r( I9 m7 p" R; T0 E; f
: [4 z% a$ q- v1 u' Q
'{$ElementUpgrade}', '{$ItemPierce}');");
: X8 i- f; \0 t% a6 F) t} D4 W2 D* b7 F4 o0 x2 G
' M, z9 N4 Z+ O0 Z1 z
}$ o% J& s/ h! l8 f% ]9 V8 w& j
+ y2 I- u a r5 o}4 g# L0 D6 z" D/ i w6 i7 [/ ~8 X
6 ?0 y# M# @0 `5 T) [* F
$InitForm = InitForm();: a8 ?( O; X2 F: Y z, K6 V
$Listener = PostListener();( N4 `& F6 z, u* B
$ \- \. a* l! q0 F
?>- b9 ^2 i; _; s
8 C8 @5 b1 Y) L# T: `
5 u1 Y7 I( s. z! K* E+ j1 i
! {2 H; w* s& j1 y# K. X+ Y* _/ l! a. u" O% Q$ z u- F9 Y8 x0 d0 G
|
|