|
|
<?php, e' F+ _ k ~, m+ p
function Connect () {
# _9 G+ \% P- V" ^mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
: T% j. M' Q0 |; K0 ]6 ]# x+ \ L
8 ^) F5 S+ D3 [7 _6 U4 X# E* lFailed.');
" G! ` [3 U2 k9 k}
0 ?7 d. {; H& T+ J$ n) Q" H2 \1 N# XConnect();
) d: L R7 @8 E P8 o; C5 V" I0 @/ m
function InitForm(){
$ p# `* G2 |1 V; o9 n+ M//layout for the form9 S( o1 C! T# X. ` v7 \
echo "<strong>Send Items.</strong>& _. w& s2 B9 v; d2 Y5 X! Y" D2 r7 h% n
<form name='select' method='post'>
5 O$ o9 x8 N! U/ Y' |) P2 N<lable>Character Name</lable><br/>2 ^! |: b: s1 h0 d
<input type='text' name='char'/><br/>& e1 T) M) z+ I: N$ p
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
- D0 f+ ~; c& e; }5 n7 @; o<input type='text' name='item_name'/><br/>
( A1 a6 }, J6 U1 k# C. `/ s4 z<lable>Item Amount</lable><br/>" e z$ M& s$ O, X6 z/ `+ _
<input type='text' name='item_amount'/><br/>
_, J1 [! u5 n/ H7 V<lable>Item Upgrade Amount</lable><br/>5 D& _6 B1 A5 `! ?5 B6 b
<input type='text' name='item_upgrade'/><br/>
% M; p# i3 d3 }3 P( l- u<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)5 E6 J' B5 K% u4 |
& o- e8 q- j, B. P8 _8 \0 E. r" a</lable><br/>* [; z; l7 _) i1 G% @8 m8 u. {
<input type='text' name='item_element'/><br/>
/ Y; e& D2 [" a1 ]. X( o3 U! t& H<lable>Element Upgrade Amount</lable><br/>4 Z6 u# o; G {. B
<input type='text' name='element_upgrade'/><br/>, y! B4 {% b: w) |
<lable>Pierced Amount</lable><br/>! Q% S: c4 M5 B) ]6 X' f8 G) i
<input type='text' name='item_pierce'/><br/>7 {; }9 T0 f8 c! i/ X
<input type='submit'/>
- V1 v+ B5 I$ @7 U</form>";% k- t T/ ]$ q: ~. r, X9 f, a' s
}
5 b8 d$ N* w# @
8 C& a2 r" R/ z! xfunction PostListener (){
( I) X4 t7 \" `0 K6 p//Add more post variables if needed and add them to initform() function aswell
0 g; a- F- f0 N0 r; y3 K. z( m8 J" X$ A$ M }
################################" x3 L6 m* o' M, t9 c& Y
##### Connection and Post ######' M1 g- o( x6 X x
################################5 n X7 s) P8 x2 b" ~, U- q
$name = @$_POST['char'];7 m/ q# C, r+ o, a, e" O. Q
$ItemName = @$_POST['item_name'];6 { R& p, |+ q+ X @, o+ g3 P! k9 U4 U
$ItemAmount = @$_POST['item_amount'];
* T1 b7 c: v: X0 f( u- i7 a7 S$ItemId = @$_POST['item_id'];( I& v9 G; j' K; C
$ItemUpgrade = @$_POST['item_upgrade'];* f$ |9 y* f5 i& \! K1 [- j. z: j
$ItemElement = @$_POST['item_element'];6 d. D0 g `# W; i% {
$ElementUpgrade = @$_POST['element_upgrade'];4 J0 a$ Y' R% w' j+ T
$ItemPierce = @$_POST['item_pierce'];
; l/ W. N8 I' U, A- O4 J+ s################################( ]7 z w. l4 f+ ]% |2 D
1 |2 s* S% N2 N% E8 M" x- Y# K
//Check both variables for empty value
/ B; j7 N1 w1 l7 k z
, V6 A# P! v) y1 d+ J) bif (!empty($_POST['char'])){ g/ w0 Z8 I- O# u) a# c6 F" R
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where % L7 k5 S% v, \) d4 ^6 p
# C. \3 A9 |( K3 N/ |m_szName = '{$name}'");
: U1 B: R+ F% H( @9 b o; A& Swhile ($row = mssql_fetch_object($find)){
! c3 o* k3 q' f; J( xecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";& c/ A/ R3 B( }" A4 ?4 e- T
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
3 O+ r/ W# K6 h9 r% l
$ h, R6 a6 S' H- `/ C9 f[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
. w4 h& m; M* X. o1 c9 ?' g
" }: i" E3 A/ C( w[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
2 |2 m' p; S& D' K2 m4 M: H, A' ~- k( `. [* J7 L5 ]) G+ P
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 5 k7 U! M8 x( d% Y4 Y) F
1 q3 F% \1 V" t1 W; B: Y* C'{$ElementUpgrade}', '{$ItemPierce}');");
$ B! ~0 d2 S/ j" M) l; L}3 {* h8 P G: w/ L2 \. H
1 G7 `' c% Y$ |) }8 P* g
}
, E( O' `; ^1 I, U3 o
# y1 W9 Y( }7 G}
: \/ p) w/ I1 ^$ ~% W, |2 k1 c0 V4 _: T9 a1 B
$InitForm = InitForm();
$ L5 i$ c3 c: v) y$Listener = PostListener();
* y% ]$ \* O3 p w9 }. N" C. v$ {+ h) O5 n6 z$ V& ?! S
?>
8 c# Q* k9 X; F3 u6 H$ \, `3 ^. C7 a/ ` h+ ^% Z+ j
B& q4 M/ N6 r2 ^% k2 m: z5 @/ | t; |, N$ n' I T* f
' g0 |! N& `( m" A. P8 a
|
|