|
|
<?php
8 x* s: u# B) `function Connect () {3 j- H U$ J3 {; s; q s
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
# I* `; n4 \! k9 ~( d1 E9 M( n
2 B3 w3 C. Z4 C. B2 ?2 V5 H& dFailed.');
6 f- V9 V4 w0 N0 {; b2 z" z d}+ a( u+ }3 m( Y) F" y% `, O- f! C) Y
Connect();
- D; W0 ?8 X% `" L6 Q% D: ^1 w0 I$ r* l
function InitForm(){
: ~; m5 u; }& U; u$ {1 G//layout for the form
7 k# ~) @2 V; Z. y: b& ~echo "<strong>Send Items.</strong>7 {( y) U0 ?" }( O; |! X1 a
<form name='select' method='post'>
) f$ D; }4 m- D4 R W<lable>Character Name</lable><br/>
$ n4 D1 m: }+ _/ a! K<input type='text' name='char'/><br/>
2 N% T9 j6 J6 e9 t- N- T/ T<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
j2 S g! W$ A# B* q<input type='text' name='item_name'/><br/>
: y; i0 C) s: X2 F9 M( ?<lable>Item Amount</lable><br/>9 i- Y$ x" }8 J: \9 l$ T+ e
<input type='text' name='item_amount'/><br/>
8 k! d: D! o0 K6 U. ]# _% h; x<lable>Item Upgrade Amount</lable><br/>
+ g6 w: T, T* M; t( i ?, j6 f$ z<input type='text' name='item_upgrade'/><br/>* b' \/ r& |7 T4 |& t2 n
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)) \0 [1 T; J! b- [1 X$ s2 K
: F* d" Y- ?% m2 R) |: r. ~
</lable><br/>
% z$ }3 Y9 l2 W0 m2 s<input type='text' name='item_element'/><br/>
9 W* i0 L! _! c! I% a+ [<lable>Element Upgrade Amount</lable><br/>$ m. x1 M4 `: z: u( {( o
<input type='text' name='element_upgrade'/><br/>
5 F @( Z2 ] o6 z" j<lable>Pierced Amount</lable><br/>
; Z& O" Z# n+ y* N<input type='text' name='item_pierce'/><br/>+ I+ Q5 I, i* w) s8 [! p: D
<input type='submit'/>
) n* I! C# T! G8 x1 q</form>";* f) @" b9 ^, ]; g; [) a
}* A# C! u1 s6 M( q
6 G! V6 P/ ] i1 o$ Gfunction PostListener (){
2 a/ V9 }7 a/ L2 p1 J//Add more post variables if needed and add them to initform() function aswell
( t( N* p# `( p2 ~. C5 E; X
' \: B: T P- X4 ~& Q################################
$ v8 p( x7 Y$ g6 {* h/ @% _##### Connection and Post ######
# Z6 U D/ A. y################################+ c7 ]8 a- ?6 D! `% [
$name = @$_POST['char'];
. b7 O! a2 Y) o1 O' A+ i$ItemName = @$_POST['item_name']; } }( T3 I4 l( {' a
$ItemAmount = @$_POST['item_amount'];3 N3 U; {( m1 ~+ R1 Z
$ItemId = @$_POST['item_id'];4 Q: t- g4 F* H( ~. @$ @7 H
$ItemUpgrade = @$_POST['item_upgrade'];
" K) n/ C8 S$ q% b$ItemElement = @$_POST['item_element'];
' E9 u3 X% X8 F5 n$ElementUpgrade = @$_POST['element_upgrade'];- [0 f$ o3 R2 A y7 i0 i
$ItemPierce = @$_POST['item_pierce'];4 i# T' |7 x+ Q
################################2 R+ y! s5 u. J1 K0 Y& ~
0 H8 M) B# e: {$ ~; E+ f% i
//Check both variables for empty value% P i% f: ]+ n7 |$ ]
6 P# W& m# F$ p6 k. C- Z9 S
if (!empty($_POST['char'])){
# [: ] g( l) _( \( m$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
6 y% P2 I6 G* ?" X5 {4 }# f3 u) k7 Z8 ~) B' @
m_szName = '{$name}'");$ U, g' k- C7 e8 D7 I O) s
while ($row = mssql_fetch_object($find)){5 |) {2 r4 K, k, E3 _
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";1 {% v9 G5 N. j+ n; i: L
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
" |& \3 A4 s" q4 T4 x# b" x u3 w( x' A" ~. w
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], ( M- O) V) y' D5 L' {" {. X8 }
) Z) d( w% S& w; C. {0 Q( z[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', - i) U$ c7 F) G' \; D& n
1 h+ R+ j, n4 Y2 q/ m( X
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', . G P J8 N+ g1 ?' A+ O
" U0 i+ _8 G& R7 b$ L4 \
'{$ElementUpgrade}', '{$ItemPierce}');");7 j) d9 B. z( J! ~- ^0 y0 w
}
( D) P2 H, a. b, s; v" q9 r4 I3 T' T6 ?8 `5 n/ V! I
}$ t" `" n$ L% {& `. ~6 l: U
$ e$ e6 q/ f" M! y$ f& A( y+ ~3 j}
5 E; v$ Y# i8 _3 O5 V$ ~2 [1 q0 Z- x+ S! j. C& j @% t) R% b
$InitForm = InitForm();$ z6 i# M: V% ]9 I. @7 @
$Listener = PostListener();! d/ z# P: i) ~( F$ N
& Q# E$ y- b" I. Q
?>) y, o4 C7 @4 e5 O6 r
r' J0 s( S8 [5 A, X9 f
! i8 k' f- f7 j' u) M3 e- f3 @* Q% B' k
0 `2 O, d% z! ]- g- \
|
|