|
|
<?php
1 D5 E3 q. R% D/ Xfunction Connect () {" c' Q# L R# Y( P8 D: w- c
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB ' u: l2 _, {- m8 P' `
; |& p, U; Q' n
Failed.');
3 `! f# F, j- N}
6 ?( v3 E" Q5 v. J& NConnect();# c. O3 B7 v/ ~* q {7 d6 J
7 Z. I3 U0 ~1 L& d
function InitForm(){
$ I( W2 c* }3 c$ ^6 x//layout for the form
7 Z$ q( l8 J3 k3 zecho "<strong>Send Items.</strong>
' {4 S3 U5 w. ~! }: u6 x1 {" K5 |0 u<form name='select' method='post'>" F' G4 p6 e7 {; p6 g+ p* R
<lable>Character Name</lable><br/>
. _8 p4 h( E8 }2 n, H% Q0 B2 R<input type='text' name='char'/><br/>
2 o! V) q& e0 f, d! d2 F<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
, A" X0 Z; X) z$ x7 `<input type='text' name='item_name'/><br/>
4 e: s; q) u1 g+ p1 I! K<lable>Item Amount</lable><br/>2 E: Q+ r4 C: g9 l I9 x
<input type='text' name='item_amount'/><br/>
( I$ A6 j/ ?: P( h, \0 l( U<lable>Item Upgrade Amount</lable><br/>
# T& k ^1 n: A% _3 _$ e& g<input type='text' name='item_upgrade'/><br/>2 P, H8 G1 m- @6 i/ I) l. s( f: n
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)/ R, i* q0 i" p* F' f: y
+ r1 L: \+ ~6 w8 c G7 B0 j& x: F" i' Q</lable><br/>0 m. Y" y( G& r3 I! X# u- \
<input type='text' name='item_element'/><br/>
[& u. S+ H7 K; E<lable>Element Upgrade Amount</lable><br/>' Q: f" M9 \! T7 Q7 [
<input type='text' name='element_upgrade'/><br/>' t. n! a" f6 t" ^) u
<lable>Pierced Amount</lable><br/>
2 c% Z0 B4 y( d; V8 m7 K) }8 p<input type='text' name='item_pierce'/><br/>
! E) C$ G! ^7 ^1 l7 m<input type='submit'/>
4 b& H r7 h Y- X9 q6 Z( `</form>";
# g# N4 y& J+ z1 W2 A7 P, n! ?& Q( n/ A) Z& v}
. {4 m3 k% L6 f% Y* a7 B/ P+ ?5 i. t& c$ H I3 M
function PostListener (){- L) D6 g1 Y5 G# A% L
//Add more post variables if needed and add them to initform() function aswell a5 y, ?0 p4 s g5 a
0 h$ N. n% _- ~3 ?* t5 r, n- [' B
################################
9 D( M3 l3 g9 Q) k/ p##### Connection and Post ######
' ]1 V$ s3 i- ` o################################: ^$ D1 o* [6 k
$name = @$_POST['char'];& ?) N# ]) A1 x! m/ o3 w: X: ^6 r5 j
$ItemName = @$_POST['item_name'];
, k9 j% e7 A7 W8 F5 [/ t$ItemAmount = @$_POST['item_amount'];
2 ^, l$ \) u% \$ItemId = @$_POST['item_id'];* V7 M( o7 x$ K* `, v+ `4 ~2 |
$ItemUpgrade = @$_POST['item_upgrade'];
( F' ?6 W4 G3 o3 \) Y: P3 K. u: L; w- T$ItemElement = @$_POST['item_element'];
; O! [% C$ E2 l: U; H$ElementUpgrade = @$_POST['element_upgrade'];
* r+ o, L+ @& a& s) X$ItemPierce = @$_POST['item_pierce'];
$ o+ Z7 A3 ?, ]################################ j% c7 G7 @; A# `2 j
# F1 H0 F4 ^2 f//Check both variables for empty value
/ S* Z9 c% q, o" c
2 D1 f, b$ x- `9 kif (!empty($_POST['char'])){
: \) S* M0 [- V! p8 V1 _6 g* p$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
) N. c y$ m' Q" @
5 z. a. Y$ b5 b+ f- j* {m_szName = '{$name}'");
0 W% c8 Z" f2 i" p6 ewhile ($row = mssql_fetch_object($find)){0 ]; H U0 t' d/ q" c9 o
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>"; v1 p: x; [7 A6 J' }( B6 T, y
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], ; g( c/ n# N+ Y& H2 o
4 t* ^7 M1 z+ u" W3 h[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
8 Q! o( h/ M6 K$ k+ H' R: J% z0 P @' \# \
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 7 v7 e3 R: c6 Z. O5 p
* ]1 j! |' t4 ^8 B5 K( HN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
' s/ F: K- j- k3 H2 ` \- q# ^+ H; W+ B+ P, W8 r
'{$ElementUpgrade}', '{$ItemPierce}');");
7 {3 }: Y( Y5 J1 W2 m}9 [8 k9 e0 _0 d
& {4 h. M& c# _9 i) I' p}9 i$ I- N2 ?# A$ ~# @" {
3 D) Z' o R1 t( p5 i. ^
}
! z. ~! ?9 A9 K4 H' G3 \
3 G# D4 x0 z( [3 [3 l5 c* ?' O3 O$InitForm = InitForm();
2 Y; `; G z$ x7 X! a+ J% T$Listener = PostListener();" ~2 o9 [7 [; m/ z
- |7 ^# v0 H9 Q* ?( L8 c- c# O2 \
?>. S4 e0 B, [( j) b4 K& C1 _: m
) o- W- H$ u) C7 R a% F
/ M: X( h/ `; J$ f5 K8 a* t- A8 O% z2 H( Z T4 i. T3 F
- {8 o! L7 k S
|
|