|
|
<?php( Y; t0 T% t5 t/ a+ s2 G
function Connect () {
1 s! v2 b' R n( i; c' pmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
2 N8 W' {- h. T. L9 h2 I
" u' V/ y9 O% M) p- a4 x9 pFailed.');
4 n" _( m) ?- l, \! m B}5 r) B1 Y% R4 b: [1 i
Connect();
) }; W- z9 n; F
V( E5 _. a! ~/ m" `1 V$ [function InitForm(){
- z# m5 E u" M$ I6 m3 T9 b//layout for the form
- z5 O& @/ S) B4 L* Wecho "<strong>Send Items.</strong>
; q( o, \3 u+ r2 J7 R<form name='select' method='post'>
1 s* o; T4 J1 o$ k* e0 o<lable>Character Name</lable><br/>- D0 o4 N& U: u' }, v& g/ u
<input type='text' name='char'/><br/>
; i2 C% u; I; P7 _- k5 k<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
- X- t( N' c0 A5 |<input type='text' name='item_name'/><br/>' {+ t, }. u* G" H
<lable>Item Amount</lable><br/>
1 M+ s3 K) ^0 { j* `<input type='text' name='item_amount'/><br/>
) H0 w3 ?# P2 ]# a8 D# L5 U( y8 Q<lable>Item Upgrade Amount</lable><br/>& L+ Z, V1 K7 L2 Q2 D2 F+ q/ R2 L R b
<input type='text' name='item_upgrade'/><br/>
) \3 n! C* d% K8 Q<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
+ A; X$ G! r" g V9 ^+ i+ ^" U$ e& u
</lable><br/>
1 a) f$ a' {* T8 R# d& P, e% M<input type='text' name='item_element'/><br/>
8 @+ q* c/ F3 q+ @* \<lable>Element Upgrade Amount</lable><br/>
6 k7 U9 r9 g& y<input type='text' name='element_upgrade'/><br/>
# N, O; M7 w5 P# I<lable>Pierced Amount</lable><br/>& r4 H/ [0 i v, [! @- x
<input type='text' name='item_pierce'/><br/>
, X- \) p J ]1 ~8 u% B) }( g<input type='submit'/>
: M6 J. \3 Q2 m# _ E2 n</form>";
) U% E; L7 g8 k/ f1 g" U}
% M" f% L7 F& E- A4 C/ h: L# q2 b5 _7 y3 ]& z* P u, [' m( j
function PostListener (){9 h( |& P. f5 D/ K7 f. I' ~" k( X
//Add more post variables if needed and add them to initform() function aswell( W4 [6 O/ M) f; i" D, X
- S6 ~: C$ v/ D! o- M {+ ~8 m. q################################: P4 d: ^# J* ~4 V: C
##### Connection and Post ######
+ k' _2 c1 H5 r' A9 d################################
2 y5 v2 j2 W s8 \1 b$name = @$_POST['char'];
! l, X) I* u: i- ]1 v1 S9 \+ b$ItemName = @$_POST['item_name'];2 u* H% }, F& Y; Z
$ItemAmount = @$_POST['item_amount'];
9 A9 n8 V& z3 F$ItemId = @$_POST['item_id'];
/ {& ^7 j2 A+ x! ~3 u$ItemUpgrade = @$_POST['item_upgrade'];
0 t) J" d* p: U; u% X; C. z- A6 V: u$ItemElement = @$_POST['item_element'];
4 R( Y6 K7 o: R$ElementUpgrade = @$_POST['element_upgrade'];/ b- I, C. e$ k0 i6 s/ [; G3 d
$ItemPierce = @$_POST['item_pierce'];4 j: s1 u6 o6 X- E+ k1 ?4 {0 c
################################
8 E* K# @% Z4 a7 U; x( Z( C1 x% J) f5 `5 o+ J9 d
//Check both variables for empty value4 B4 L- p) D# F) N1 g
6 S8 ]# L+ @/ H! D" z% S4 t
if (!empty($_POST['char'])){" [7 Y: X, K6 t+ ^
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where : _, @ `% G! _- e+ E) V' ~. e# v- l2 y
9 P1 K4 r& a* A6 {5 N8 R3 x- F
m_szName = '{$name}'");
$ O& v9 Z U; w V) p7 z nwhile ($row = mssql_fetch_object($find)){. B d! [& t" a! q1 N H& W6 O4 K# l
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";4 Z) n. s/ ~% b6 q8 g# {/ {
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 3 X% e' H# W- H5 }9 V1 }
8 f7 R* R0 }6 Y, ^# ~- `& v[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
. m9 ~. R: b! u& h9 V& c) D# E j0 L* N+ t
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 5 a9 F4 p+ y* b! e
, s! J! H/ F" l V4 |
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 6 p0 X' p H+ \) B" h
I( D, `5 j! j+ C3 M5 B
'{$ElementUpgrade}', '{$ItemPierce}');");3 w; t0 c1 j5 k; b8 A: E3 a' G
}
; L! x. u# i' ?1 X
* s0 G7 g" T( R% B% Y" A}( w* H( p% h% h/ y/ }) }
. R( e; N# s, r( X8 d0 ?9 j# C! D}
# r4 W- H# {3 {+ S) g9 B
$ E' r& L" n! j0 d; u$InitForm = InitForm();
5 c3 e( h( T8 Y, Q0 L: R$Listener = PostListener();
* u `* ^4 s3 g# K
: p- Q' ^) I% ]% v4 g5 L?>
: W ^: c) Q1 E8 W4 m. d; R; V! {) o8 U9 l
' Z$ n$ h7 c7 j: d% I7 P
6 ]1 H7 \% H; T4 d1 ~7 O; J3 ]
! r6 V- U, p3 _" C2 t+ Z* O- c+ E0 k |
|