|
|
<?php0 G2 N9 R/ Q8 h Y4 E/ v
function Connect () {! W- Z# ~+ a3 w/ ^: V
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
' d+ a/ d5 {: x* t1 d; s* z( A; F: z f) B2 a: [& W
Failed.');. k: I( x4 h; {& j. w. ~
}0 h8 Y9 K4 j5 v* i# A; `
Connect();+ f! x+ Q3 B0 T0 T7 B# B! @! O
5 [; F" I* n. s' }' tfunction InitForm(){
; q% \/ p$ X5 B; O0 ?* k# I) u//layout for the form
- \- T0 ?+ w% Q9 gecho "<strong>Send Items.</strong>- L2 I3 v+ J* W6 v# O% o6 I5 Q
<form name='select' method='post'>3 v. ] x: Y) E( k. C q b
<lable>Character Name</lable><br/>3 f7 R( k) s7 G/ I9 |- t- {& ?
<input type='text' name='char'/><br/>
% C) c$ `8 |: p' o4 O/ N<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
* J# A& G6 L6 S9 ~' S8 D<input type='text' name='item_name'/><br/>( G9 Z9 |- b0 g3 y( F; _3 C
<lable>Item Amount</lable><br/>
) [' L R# S& p9 g9 B0 L8 m# r<input type='text' name='item_amount'/><br/>$ F; s5 a J3 g) T
<lable>Item Upgrade Amount</lable><br/>
1 M' B8 T- C7 g" c<input type='text' name='item_upgrade'/><br/>4 E1 @5 P J" N, E4 v
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)% `* ^3 R1 ]* k9 K x
3 [6 @& P6 P2 u! ]4 X y6 h$ [' [
</lable><br/># G% @4 U) R8 i* E$ \' w9 W
<input type='text' name='item_element'/><br/>
- {. K2 I& Y7 z; P8 B* T4 u<lable>Element Upgrade Amount</lable><br/>: n+ h- E2 n9 a9 |: r2 w) V7 |
<input type='text' name='element_upgrade'/><br/>+ ?5 M" h9 o" H9 t+ p
<lable>Pierced Amount</lable><br/>) y" p/ }( V$ R
<input type='text' name='item_pierce'/><br/>
" y% Y7 j2 N4 Y<input type='submit'/>- Z5 A, H" U/ \ B. \: c0 d& Q
</form>";
& Q1 _9 V6 G5 f3 ]- Z& Z}
5 V& m( B! z. s& z4 d8 b+ `" y9 a+ K5 u J: M" a
function PostListener (){
, I- @: D% R( l' ^; Z, v* p//Add more post variables if needed and add them to initform() function aswell. h8 J0 z) P) P; \$ R
5 B5 J M$ r' Q6 }( K: C8 J################################
8 n0 ^! o6 p" E: ~" L6 f0 Z##### Connection and Post ######
8 ^9 R% ]: R. F( |5 |################################
: L2 r) ^# f! J# P8 B U5 c% S$name = @$_POST['char']; I% K5 Z- C* {8 k, a
$ItemName = @$_POST['item_name'];/ b! {( X1 J5 V4 y* e( \: t
$ItemAmount = @$_POST['item_amount'];
( N7 S" ?% J* O+ c5 P' @' x, A$ItemId = @$_POST['item_id'];
. l A; h- \5 v- W$ItemUpgrade = @$_POST['item_upgrade'];
+ z/ Z- a. I/ V z$ E- {$ItemElement = @$_POST['item_element'];
8 t1 A1 B+ v8 u7 u$ElementUpgrade = @$_POST['element_upgrade'];
% X5 [& H( _# \+ k' E$ItemPierce = @$_POST['item_pierce'];2 |/ Z; H u, R) O' s# Z1 M
################################
/ ~( k6 l! N2 |6 _$ \% X
# b- j6 u1 p1 l4 ]# l1 [//Check both variables for empty value+ w& ]; j4 l6 c& u
- A; f# R. |- d$ a+ Oif (!empty($_POST['char'])){) }, M1 x8 D0 R
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
& K! p6 t9 @9 G% y% a+ a$ d( L- ] }' I4 |! b( { y. r( x
m_szName = '{$name}'");
- _) H% {! @+ m* A5 C% Z: F" K: zwhile ($row = mssql_fetch_object($find)){' q" s) _ h) p7 K, v% J
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
: M0 B) f" @+ d) `8 a R$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 6 l% ]7 |/ b: Z* y6 h+ x: x
& |" X: _ \$ @! b: [8 ?3 ~[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
+ j' |! `! u8 w, g& l) q) A; v, o/ z1 l$ l5 b2 a
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
* ~( b, x* u, R \& S
. h/ X2 ]' k1 n) a% E. _3 {: _N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', & |, y1 c1 D5 ^
" K. [4 \- y0 H* e3 d3 F
'{$ElementUpgrade}', '{$ItemPierce}');");
+ ?1 ]& i6 W0 v0 d3 h5 R}
9 |6 I3 ?: ?& _$ b' Z# _2 b9 U# I. m4 [( W
}/ y7 Q* L" h; G' T' e9 Y5 V
% r/ i; m5 y- t! C/ u q9 i; D}
' h$ s5 }+ `5 X" d, w. I4 u
3 p& v9 d. G4 g8 p, k$InitForm = InitForm(); t9 s0 L, W& @+ v$ V5 D4 A0 Q
$Listener = PostListener();3 G. n/ c4 L+ B8 [- y' n. y7 S
, B7 m3 C; a3 O3 ^
?>
4 E; I" `" D a! z! q. O3 E, A8 H. o" U$ e/ N9 T
5 K, ?: V; O: `8 k, p% l- r K% [. @) K7 H: C6 b
7 h$ O( I% B/ U2 H' \, Z7 f |
|