|
|
<?php% e3 W7 J6 Z' a9 `1 m/ d: d. H
function Connect () {$ K: M; I2 H5 h! k7 P# s |7 Z
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB . u% n( h9 ~; ~
* U4 x6 B0 w7 [/ `3 k6 qFailed.');! w+ |" Q" x& z! C
}1 [$ f8 M ?3 e# Z! W' L" x9 ]5 c
Connect();
6 I o7 v( Y" v+ O0 ^2 E% X2 J `2 H
function InitForm(){
, z1 ~6 a2 n" A. Q$ Z$ R//layout for the form8 ^; d6 X, V2 |+ Q6 M& y
echo "<strong>Send Items.</strong>; e+ B& }3 p t( V* o* ^6 k# T5 Q
<form name='select' method='post'>) h5 m s/ W) W& g. m; \
<lable>Character Name</lable><br/>. c7 W( H6 K. K1 l5 B2 }. g
<input type='text' name='char'/><br/>
- i: q. }, m1 W* `! b<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>$ m' v. i) _+ k1 ]
<input type='text' name='item_name'/><br/>: f* X v; d! l$ Z1 S2 f0 O
<lable>Item Amount</lable><br/>" L4 A3 ], \- T# E- U7 p
<input type='text' name='item_amount'/><br/>+ m/ ^' `' n, p# X0 y& \/ A$ I
<lable>Item Upgrade Amount</lable><br/>. t* w1 z2 J& f S7 n, R
<input type='text' name='item_upgrade'/><br/>2 T; ?( V$ y, ~6 i# b( ^
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)0 L- z$ q, R/ |& h7 b# p. N
. K) r; ?; ]! |, m X: y6 n3 `) z
</lable><br/>% G0 C2 N7 W3 o; z3 m. m9 F
<input type='text' name='item_element'/><br/>
+ H! T9 x. l7 F% \<lable>Element Upgrade Amount</lable><br/>; A5 L, N+ }& S+ G2 C5 P+ Y! I$ p
<input type='text' name='element_upgrade'/><br/> Y' I# \7 d% _% L* u0 f3 v
<lable>Pierced Amount</lable><br/>" E4 b/ F$ L3 w% E) R' {
<input type='text' name='item_pierce'/><br/>
L9 K1 A8 q7 ]<input type='submit'/>
2 ?: ?, W( M' Q$ Z</form>";+ @* c5 O3 G, E( j- k
} s |4 d! [- e: k9 H3 [- d [
2 D9 g Z6 p1 Jfunction PostListener (){/ x8 {5 w. I" T8 D6 F! l" v: c
//Add more post variables if needed and add them to initform() function aswell& |, n2 w9 w2 K" b; T2 P
1 @2 [& \& B! @ H" n6 x; R! m################################
* H$ e2 M! [2 y1 n##### Connection and Post ######
" i& {6 \ z5 k################################
' _0 G( E& i7 q. v- [* S- W) `) Z$name = @$_POST['char'];8 R, q* x# U3 l5 o
$ItemName = @$_POST['item_name'];/ {! z" t& k4 T
$ItemAmount = @$_POST['item_amount'];. A" z% I) T' z8 ]; Q+ U; Q4 g! b0 S
$ItemId = @$_POST['item_id'];/ p- t7 U, {" [: y/ W
$ItemUpgrade = @$_POST['item_upgrade'];
, |9 o; O; F5 g/ N( R2 n' _$ItemElement = @$_POST['item_element'];; J5 d; n7 `1 E$ R6 U& ]( M! @/ p
$ElementUpgrade = @$_POST['element_upgrade'];4 Y' u9 g* k3 z9 s
$ItemPierce = @$_POST['item_pierce'];
3 X. G0 ?+ G1 w################################
, k1 ]) X8 f$ J! ^7 I! J9 d9 C8 l1 c, }
//Check both variables for empty value
/ s9 S7 V6 M' a3 A2 D3 v
9 c2 e" N+ B7 ~/ f8 C" Vif (!empty($_POST['char'])){5 K* M( w" G0 O K. w2 L
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where + z3 M9 D8 { T3 T. m
7 y/ w+ L; @% Z3 d, F3 e/ c5 y
m_szName = '{$name}'");
7 K. ?4 K( d3 \& Gwhile ($row = mssql_fetch_object($find)){
1 w' c. S# C+ g4 U- |- `( }9 ~. Techo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
& R& D7 `/ w1 E/ k3 k$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], q5 k4 T- b1 J8 y
. _$ Y n) y7 s/ | M( H
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
% s# `; p2 f* ?+ z c, n r3 |" v; Z. l
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
% y0 q; D h v. x. f
/ S7 b A/ @1 z4 y: m0 D+ F; ^N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
n( \; B; ?7 g& [2 n/ M; P" S
'{$ElementUpgrade}', '{$ItemPierce}');");
4 J& \) ^ U) v4 g0 m$ m}
* \, `3 k( ]' H! a- k; E: s/ g
0 Q# @5 n0 h/ Z5 I0 S. U! Y}0 D6 O3 ?* O; E8 @
" I" @9 u* b: }
}
1 S* w. l( j2 m7 E7 N) K- L$ T
X; S" Y' U0 m% N; Z' a O$InitForm = InitForm();
" q' m6 I2 g; m8 a% N5 j" C# v$Listener = PostListener();
; H* _- W8 x/ {5 A) X
/ A! f: ?0 f' _. G# B?>1 A, S; w- U7 Q& ]5 g
$ V8 v& K- [8 B- N# n0 m' P7 P
1 Z; t3 G$ j0 @) l1 h% m
- p2 t& \# i# S: a8 O+ Z8 k9 m7 @( b& E
+ B4 d0 }" n$ m* ^* K; M& m
|
|