|
|
<?php
8 L. B: o* |! |% {' ?function Connect () {6 `- h- X& W: U; q4 w+ [ j2 h
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB $ G8 [, _& U' V& d& D
" W/ X9 f _5 [; `Failed.');! G! @, }% g. t
}
2 _1 M( t9 y% q7 @! vConnect();3 i- t$ X9 \; C2 r! q- ]
8 V) z9 U5 P# \: _
function InitForm(){
# u4 @8 d% S. A, E# `1 g//layout for the form& {# B: b( e) q# ~( c. t/ n' [: ?
echo "<strong>Send Items.</strong>9 [1 ^( i: A7 ^
<form name='select' method='post'>
0 ?5 Q+ `* m1 {: M, U- J<lable>Character Name</lable><br/>- q; `7 e% G$ C# \+ S
<input type='text' name='char'/><br/>! N# V) S. S) ?0 r4 S( @/ [1 F
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>; r, Z$ O( l& ~( k. `( w8 b9 I
<input type='text' name='item_name'/><br/>% ~1 b5 |+ b4 N4 e# t
<lable>Item Amount</lable><br/>
( I' V! b6 ^, X4 H0 y" _* u" A/ _<input type='text' name='item_amount'/><br/>* z% }0 ^1 N- k$ `
<lable>Item Upgrade Amount</lable><br/>
& `% p9 |, H9 `0 E, B7 p<input type='text' name='item_upgrade'/><br/>
: M0 s9 ~$ j' H<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)0 C* L. P; W% ^$ U' |( I
' H# d8 F7 C5 }- w2 c</lable><br/>" s5 J+ M. n% q. U& q+ C
<input type='text' name='item_element'/><br/>0 D" r+ n# O0 V' \2 U- h' D! z. r
<lable>Element Upgrade Amount</lable><br/>
2 J8 r3 Q9 j( U* E<input type='text' name='element_upgrade'/><br/>, P3 P4 N. ?% t$ @4 R u
<lable>Pierced Amount</lable><br/>1 N) C$ I! j3 W8 M3 d
<input type='text' name='item_pierce'/><br/>$ o5 u8 X% t( J s
<input type='submit'/>
" C" W/ ~- o l; ^- W</form>";" Z9 w e9 N. f
}
3 ]# K q3 d2 d' v
; p3 c: M: O/ q) G3 ~function PostListener (){! J7 ]8 o6 J% ]5 e- Z$ x/ M
//Add more post variables if needed and add them to initform() function aswell
5 W/ [7 g0 ?+ T6 n" L
% \ M, ^3 I. N6 o################################
- F5 U" s- M9 e3 V" l##### Connection and Post ######
0 G1 Y8 \3 j6 R( C################################ P5 }6 }8 g( F$ |' c1 ~) T1 L
$name = @$_POST['char'];
+ n: J! x4 x: k, ]8 c$ItemName = @$_POST['item_name'];
' r% U+ L1 M/ E- b) Y$ItemAmount = @$_POST['item_amount'];
% l2 u* P# a# v. ]" j$ItemId = @$_POST['item_id'];
, \0 y$ y# D2 ?# z3 I$ H$ItemUpgrade = @$_POST['item_upgrade'];
( {+ Q1 r8 i9 k D9 T$ItemElement = @$_POST['item_element'];
' A% O8 F W# q! C+ H$ElementUpgrade = @$_POST['element_upgrade'];- g1 [8 c; O6 @4 d9 X* A& S
$ItemPierce = @$_POST['item_pierce'];# c/ Y. F/ T& u" }
################################" Y7 u( t3 f& n: g4 l& Y/ U0 _
( G5 A* N3 L' |//Check both variables for empty value
; W- R' T6 m5 k1 m( i' M5 P) `5 [1 x) d
if (!empty($_POST['char'])){/ W3 J4 g8 i% t
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
9 C( _- |5 R8 Y" t1 Z( r5 b6 }& H' S1 k
m_szName = '{$name}'");
2 y* X3 o- l" Q" A) ~while ($row = mssql_fetch_object($find)){
. e3 c- D+ c ^% n8 A9 e- a. wecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";6 J8 g8 e" m% H2 Y
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], ' v8 w( O6 r; b9 \. H7 @* a
! F: q6 G, t, B1 J2 \. i! I- Q8 `
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], 3 B& I' H; ^ Y, `0 h& d% W3 |. v- r
" R4 N' F5 O6 |/ z9 ]/ h[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', % M, N- q! X0 c: K( M' G0 H$ O
6 w* v' B/ ~! n3 R( n, KN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
: T% L" y8 B5 ~1 ]5 ~8 M( j0 t( X% ?( X% E% X
'{$ElementUpgrade}', '{$ItemPierce}');");
( a/ P4 v: X" H% G7 k; k9 H3 \% w}- i C1 R) i A2 A
: d* q" P+ m: p( S}
# ~/ {( e! Q( ~' H' R5 O! V5 V4 P+ g& G# q, D
}
% C+ J1 Y4 N" J
9 m0 P) {9 N) E. ]( Q) P$InitForm = InitForm();
+ O: \( H! j$ _( Y$Listener = PostListener();
# x0 ~- f# f1 u% ?
$ V$ B- |) J/ a& ?6 x: O, K?>
# i- U7 [+ d: B+ _9 U5 T0 b
/ y' J4 d9 h2 E+ q2 t h
7 T0 D+ ], u1 E% R" D4 g6 O4 O; c) C- r4 J6 _) {0 H% p
. V0 Q' [3 D' }) n
|
|