|
|
<?php* d' B) T0 |4 s0 {7 ?
function Connect () {
3 ^9 W1 R0 b4 ?3 `2 ~7 Fmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
3 J j# K: m V, x7 n4 P
/ |% s5 w) E9 l0 \, WFailed.');
0 @. ~- c7 e2 e9 P0 @6 q" Y}: G H* M: r. e: |' }8 t
Connect();6 H; x4 ^0 g: r& A( U
a/ r4 l R5 v4 ifunction InitForm(){2 w) B) V( G9 h H8 a$ `
//layout for the form
3 f3 X" P& L8 ?2 b. Aecho "<strong>Send Items.</strong>: ^6 Q0 c$ Z& E4 @8 [3 i) v1 ]
<form name='select' method='post'># e, x0 ^# T% S& K$ U0 [
<lable>Character Name</lable><br/>
L% G" ^+ |2 D! O& x: h3 |<input type='text' name='char'/><br/>, y) n3 S& S: y1 P" g$ ~6 _
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>6 L+ V- Q0 A# l. W
<input type='text' name='item_name'/><br/>/ j) |! m/ Z: n( B/ J/ O3 _
<lable>Item Amount</lable><br/>
, v0 R" @7 P/ E1 |9 t7 o<input type='text' name='item_amount'/><br/>
5 Z1 M7 Y+ Y1 {' z, j9 P<lable>Item Upgrade Amount</lable><br/>
% u7 Z. c! _/ s5 p) b<input type='text' name='item_upgrade'/><br/>; ]7 s* ^" I% m2 N
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
3 H4 O2 c9 V& t* y5 ~
- Q( J. r% {# h</lable><br/>8 x+ e/ ]1 r S* W
<input type='text' name='item_element'/><br/>, U+ p3 F' |! N A9 f5 {3 `
<lable>Element Upgrade Amount</lable><br/>
: P& f' ?7 v S8 u; o7 J<input type='text' name='element_upgrade'/><br/>
* X( c! k/ I2 j5 x3 h3 d# l<lable>Pierced Amount</lable><br/>
! q; t) {% s0 P# A I% W<input type='text' name='item_pierce'/><br/>$ w$ k! h+ }# T# V
<input type='submit'/>
: W) A& q! j" Z0 |% ^</form>";
6 R5 X3 W7 P% k4 M' S}
2 Z3 F' z# l! { B% F8 E6 v
Y; S, b# M6 q# cfunction PostListener (){' o- [. y( x; H$ j8 v- J9 C0 \' y
//Add more post variables if needed and add them to initform() function aswell2 O) S+ q! Q. ~4 e b& U1 M+ j
# Z! H% m( d3 h& W: W2 k7 d################################) m& D9 L& V' a6 v* b. f6 s( F
##### Connection and Post ######5 G+ O7 X: ?+ U: F8 Z6 d
################################
+ b4 M' Q" ?3 H$name = @$_POST['char'];$ I- Y u; S; d* E' ]8 m
$ItemName = @$_POST['item_name'];
: G( L3 Q. S9 R0 \6 j# r; f5 \$ItemAmount = @$_POST['item_amount'];
2 }; Z, I5 z% b6 Q$ItemId = @$_POST['item_id'];% x- @+ d" G" p7 P8 Q
$ItemUpgrade = @$_POST['item_upgrade'];
Q/ R J0 u3 B" H4 d/ l9 n$ItemElement = @$_POST['item_element'];
" j& I* Q8 X0 \# [# K$ElementUpgrade = @$_POST['element_upgrade'];
! r2 o4 h" { x. ^. K4 ^$ItemPierce = @$_POST['item_pierce'];* t( d% \; e' A8 Q
################################( n# e) G. C2 K- z) d0 {4 p
4 V& D6 i/ m* H! H//Check both variables for empty value! S* E% q2 u1 J$ a7 L2 O' r* ^
1 K5 i) G d5 |- Q* l' w
if (!empty($_POST['char'])){
5 V1 T( L; G0 Z7 G5 [* Z$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
0 J, r4 Y/ Q( J! \
6 \& U& G/ ?1 um_szName = '{$name}'");
) l9 R* Z4 n& d4 i- uwhile ($row = mssql_fetch_object($find)){
7 O; C, e1 i6 @2 b% B9 [echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
% J' M A3 a4 m# t. A! Z1 Z4 Y$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], % W0 ?6 U3 _" T
5 Q# o0 L4 Q1 k[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], ; }" ^5 m. v1 [/ Z f1 Z8 i8 O
: E* {2 I! L- |- n" ?) \) r# V7 J$ q/ g
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
( M0 `4 g y4 t* y* `
1 @( \5 Q/ ^$ DN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 1 [% f. w, g; t
3 r7 |: A8 U5 C7 B3 Z
'{$ElementUpgrade}', '{$ItemPierce}');");8 U3 N- H# G3 L
}( P3 B5 C5 x8 R1 ~ z
7 Z+ u+ i" W/ ]
}
3 F( r) F( s! f, N" R& [; r* p# H9 n. j- r. [/ o* Y0 Z
}
+ p; H$ d$ s; l/ x8 n, B' ]" k/ b: O. [& ?
$InitForm = InitForm();
$ Y1 G$ n* O" H# L# b M7 ]$Listener = PostListener();
/ a h. v) p5 B# `: r( \# k
8 G. f; C) w3 m?>2 _% N$ O9 Z7 t% `6 F/ Q: L
1 ~" w- D5 u; |9 \9 A* |2 g9 w5 S+ m/ u8 n. f
$ y4 ^ R, i# H$ P& ~) |
1 n( F* [5 `4 R# ~- o1 W: f$ Q( t3 a |
|