|
|
<?php
G: J6 Q* D( {& vfunction Connect () {
! h8 ^- C- ^6 o2 k- \mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
# X, J i$ \, R/ m+ E. V7 Y- G; l w5 Q4 @* K
Failed.');
|+ [! p, }# K- D}
+ I7 a/ A! P% GConnect();5 ~" d3 b8 y) ^$ t
# C9 y" z0 h& [function InitForm(){0 I5 [! k+ Y0 J/ j% x
//layout for the form
; e% L* N/ w" s4 g \echo "<strong>Send Items.</strong> `3 S3 y4 w% [8 T* I
<form name='select' method='post'>
3 q2 b% A4 _' L6 i: `<lable>Character Name</lable><br/>
4 F& U! `, L' f<input type='text' name='char'/><br/>' |4 U7 r" p& Y/ l' Q! c
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
: I, a1 t8 R; A2 @2 ~<input type='text' name='item_name'/><br/>
9 H& Z0 F/ ?7 o0 i% B* L [<lable>Item Amount</lable><br/>. z- P6 M T8 R( C, h5 [
<input type='text' name='item_amount'/><br/>
- O, ]+ _2 f3 r" G8 g<lable>Item Upgrade Amount</lable><br/>
2 J4 A5 q) K" F3 _2 r1 g; @2 J<input type='text' name='item_upgrade'/><br/>7 v0 E2 a, B g0 { s
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)- b& A# a Q% p5 [- ^' D5 @
0 h5 J7 z( x8 X. |5 R! E3 H% z
</lable><br/>+ V2 ` Q% `1 z, Q. Y
<input type='text' name='item_element'/><br/>
; h, Z0 b( ?6 ~- l7 R<lable>Element Upgrade Amount</lable><br/>4 x* S* i- ^, [; ?
<input type='text' name='element_upgrade'/><br/>6 U& J/ ~1 r# @
<lable>Pierced Amount</lable><br/>9 @7 H7 X; y* B8 U2 N
<input type='text' name='item_pierce'/><br/>
! }" [6 D, u* |8 m3 j<input type='submit'/>
6 e; q+ l: |0 ?3 `; [8 k; O5 j! U</form>";
- k1 ?! y$ }) b2 I}7 n! t2 n) a# W" J8 m6 i
9 ?4 X# s" l' w9 ?5 A' P+ kfunction PostListener (){
* ~7 {6 N; C' ~+ T" G1 S; a* E//Add more post variables if needed and add them to initform() function aswell! P: h$ i, t! R+ s
/ w: p6 N, {$ M7 y, S3 V! x################################$ B/ X( b2 |8 s# O, x1 E
##### Connection and Post ######% f+ F/ P) } _' ^0 Z. B
################################; r+ x$ `* W7 }3 f3 ^
$name = @$_POST['char'];
7 ?: ]0 {' L& s M* S$ItemName = @$_POST['item_name'];
" C' o2 D+ q v: F( Z$ItemAmount = @$_POST['item_amount'];
1 F4 H* a5 b1 b$ W4 ]# K# s0 J$ItemId = @$_POST['item_id'];
+ y" q' J+ V, Z( n$ItemUpgrade = @$_POST['item_upgrade'];
6 p; d. m8 C: D; |# t$ItemElement = @$_POST['item_element'];
$ a3 [; L; I0 t( z' @- e! u$ElementUpgrade = @$_POST['element_upgrade'];( M* z9 x J2 j+ O1 f, y
$ItemPierce = @$_POST['item_pierce'];! d" @/ c% M6 o* q
################################2 Z8 X1 L' t, [ t2 H
3 _1 y0 k1 i2 D. W7 Y: R: y) h$ t
//Check both variables for empty value
' n# S$ F8 Q5 X! H3 ~1 |
( r: Z# ]: v! x) I$ ~if (!empty($_POST['char'])){ X* M6 l/ L8 t! k- K; l1 c
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
# C' K# T% F% L* {, l
4 ~5 ?" |- _' K5 C. P5 B6 U0 v# \2 wm_szName = '{$name}'");5 M. ?2 F+ a0 n6 d" u
while ($row = mssql_fetch_object($find)){$ u$ q5 V5 y8 ~* h# `
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
# T5 P& R0 g# B4 m9 G4 ^$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
" V% f! h2 p3 t: l' i4 g, p1 g" R8 \1 b' D' K
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
. V* w% j- \: g9 f
9 |. S) I. m; g. I+ v[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
, l" _; U: p# [4 |! x* v4 {+ R; P/ q7 U5 o. y+ t
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
3 N% S7 X4 [% j4 ~2 i6 w" A
6 X* `0 V I$ W$ p; I x9 z$ t'{$ElementUpgrade}', '{$ItemPierce}');");# E8 o# O# `: P) T& S
}8 T6 J" N4 y9 O
) b4 K) g3 t: z9 m}+ J8 ~. {* R3 C! e% K! e! |
# c8 i g' F& B1 a5 q/ P- e& n}8 h' g, d% v1 w- A% ?5 v
0 P% u7 }7 t1 r6 [- ]( d$InitForm = InitForm();
5 w( U; \$ q, `6 G: K( D; V! ?9 G) Y$Listener = PostListener();; s( p& H) G/ i& v8 k
; g/ u, g; H+ D& x* ^- y?> p/ O7 P+ S& \ W* f& J
4 x* Q' k" y5 f& f& h
" l) |0 T1 v, l% u6 i9 [
0 T% T( R" E6 {- @/ q! O2 i5 y
/ l* r: o) Y/ y, f5 R* \8 L |
|