|
|
<?php
' m0 t0 c, d" }# D% F1 @function Connect () {$ i- Q/ l- H9 Y4 E
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
/ y6 c! C* z1 u+ p/ y* S
, m# v% ~5 R3 \$ UFailed.');
/ g9 E" k+ p( a0 P9 [- u}% W# D3 |' d) |- R" |6 t4 M
Connect();
2 i+ h2 e5 g2 S! Y7 P3 y4 P6 S
' R( x l0 ]7 V/ j, ~7 u; o8 ]/ {function InitForm(){# S. L6 z4 E: E& S2 L
//layout for the form
: j; W0 u" ]0 s, ^1 v! s. _echo "<strong>Send Items.</strong>
1 h& h2 C& V! e+ c& Y6 b<form name='select' method='post'>
/ z- v* ?+ p b; M<lable>Character Name</lable><br/>
5 E) {8 W& ~3 Q: H<input type='text' name='char'/><br/>: G+ j6 ]; Y G1 O+ K
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>. Z/ R& }8 o* a, Q" w# v
<input type='text' name='item_name'/><br/>
8 a9 f& K( g2 K; k" H, v! N# K<lable>Item Amount</lable><br/>1 I8 T1 ]7 v0 j
<input type='text' name='item_amount'/><br/>
_* P) k" @; b- D$ `<lable>Item Upgrade Amount</lable><br/>
3 Y: G7 i6 E3 G3 ~9 ~<input type='text' name='item_upgrade'/><br/>: Q7 Y% O7 X2 b5 j3 `# x8 l
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
' D$ _6 Y' }5 q( G% T+ \7 Y& w9 H0 \6 R \' B
</lable><br/>9 ^4 X: y6 l/ z
<input type='text' name='item_element'/><br/>6 p+ h3 L% o1 }9 U- S
<lable>Element Upgrade Amount</lable><br/>
; o2 Q* t% }* |0 {" h. u<input type='text' name='element_upgrade'/><br/>
% `) E) i' ~ E' Z4 \<lable>Pierced Amount</lable><br/>% `8 E2 E% i- Z, Z* T
<input type='text' name='item_pierce'/><br/>
" h) l" t/ L6 O7 g+ q* s<input type='submit'/>
* k4 q* A: e6 v4 ]' I" z4 S</form>";
& P- A, d4 h; c* D}: ?% z7 M N4 ]% f* }
1 [. \6 G$ `0 Y
function PostListener (){
3 _, R9 R6 y$ h4 ]//Add more post variables if needed and add them to initform() function aswell2 G+ ?: t$ W" a w4 m W# d0 v6 u5 e
7 }$ c' S8 |1 d( j
################################
+ o5 s3 e9 f f: g* b" J##### Connection and Post ######
) B3 t# S8 r( r9 u, ?8 f################################
* m3 s$ S! ]1 s$ x$name = @$_POST['char'];1 r: h" T' L, _$ U: L
$ItemName = @$_POST['item_name'];, a# @; G2 y: @ E5 ?& X3 T% w g
$ItemAmount = @$_POST['item_amount'];
8 s% z4 A. J% l4 X$ItemId = @$_POST['item_id'];' L9 [! W- j. a: K
$ItemUpgrade = @$_POST['item_upgrade'];# G9 W, q+ D' d3 _- ^7 Y( E
$ItemElement = @$_POST['item_element'];
' J2 p) j* G. j6 A9 ^$ I- r$ElementUpgrade = @$_POST['element_upgrade'];
% r0 m8 w) j3 T( T }& ~$ItemPierce = @$_POST['item_pierce'];0 D5 b. C2 u( J! o+ G- d9 O
################################ r& M% ~0 T4 v/ e9 Z, V1 f
! a* ~1 w( m+ ~( W: p, T
//Check both variables for empty value
+ C! g8 [1 R, D9 o5 ?5 t9 ]& Y' h: H$ P5 L) U
if (!empty($_POST['char'])){
+ v; j+ K+ M+ J$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
4 u9 ]: C s2 v' h2 M) n, F, y5 [4 C% G% p! n8 K& T
m_szName = '{$name}'");
7 X; q6 v0 ?2 {while ($row = mssql_fetch_object($find)){
( q% G. U; l" l; x0 kecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$ E' Q! V& @6 X1 `8 o: P$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], ! M0 H+ |( ~2 v+ v) a6 C
H5 Q" u, u' t7 W
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
! }5 D: E# c5 m' X' \6 b7 Y
4 L2 Z0 D: _& r; I% `[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
4 d! r& l: u7 ~* d$ O8 V8 ]2 P; x8 i
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', + {3 } `: G& d! Q" [( E' \
5 i6 }; b+ z% y7 m! C
'{$ElementUpgrade}', '{$ItemPierce}');");
" V/ J/ J% p. R% b0 t" @5 F}$ s4 [" L" \6 T1 N! {
4 ~: r+ h8 o [4 K2 h; M
}
& a% N9 ?% x1 H
0 U, h; T2 h1 V* ?. G- j$ e: d}& q2 ~$ X \( p7 O9 p
; s9 I: l% g& G4 E
$InitForm = InitForm();
4 O& U4 v/ K' U$Listener = PostListener();% Z$ i4 [7 I/ {6 {) Y* a5 j' @
1 K# Z! ]9 X! {?>& E; g, w7 w; {, l9 b
& @3 a, C7 [0 m& F
8 I V t" `1 ] Y5 f# W- l: x0 ^) ^ p5 W. Q/ g; i1 A# w* I
- l/ O$ y5 K6 y3 M
|
|