|
|
<?php8 l8 J( D g) ?
function Connect () {0 k \7 p4 V8 x% C( O- e- e
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB 7 b; K4 \! w7 N
8 t" v6 F5 T+ J( W
Failed.');) ~! c, b9 \* k- O
}
7 B' i6 y2 N) z h$ gConnect();
" n/ k, \" w* {5 l& U5 W
4 E8 W: p+ P" V7 ?% P; wfunction InitForm(){
. |1 \: Y8 j) |; H1 |2 _//layout for the form
& [0 H0 v4 t& ~2 wecho "<strong>Send Items.</strong>( b1 U) v3 K4 R1 R
<form name='select' method='post'>5 c ?2 T8 i' W* @, N
<lable>Character Name</lable><br/>, i3 r0 t% J: f5 @. y. @3 `( M) \
<input type='text' name='char'/><br/>
, }) X' {- X' I# s- K3 r<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>- j* _! U" n0 d1 X. [' {
<input type='text' name='item_name'/><br/>
1 ~. f3 t5 ~5 ?$ C u0 ?<lable>Item Amount</lable><br/>
T) p; L) y/ J! F/ N: ^! a<input type='text' name='item_amount'/><br/>
# l7 x# e+ c$ f6 D& ~: {<lable>Item Upgrade Amount</lable><br/>6 V6 D' l4 X! Z b) e7 J! Q8 e
<input type='text' name='item_upgrade'/><br/>
9 R# q8 I( w, j$ h: F<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
& O3 |6 u& ?8 p4 f- U; U( |! C6 W, |1 D! c# ^& y
</lable><br/>( k! w( T# e/ c0 {. s
<input type='text' name='item_element'/><br/>- L: P. p2 r% v( Z
<lable>Element Upgrade Amount</lable><br/>4 _! e: s h# d$ N# ~8 D
<input type='text' name='element_upgrade'/><br/>
! o3 h0 F/ ^- h/ l. {<lable>Pierced Amount</lable><br/>
. F/ ~7 W1 d3 q r( q- n' |<input type='text' name='item_pierce'/><br/>
/ m9 {+ u5 e8 p4 F: H<input type='submit'/>! i3 U7 q, I: W+ a% p* U
</form>";/ W3 Q' M5 }7 j2 N
}- G# W U7 R2 U
: z' k& R/ O. v" M* L5 afunction PostListener (){5 c6 X9 H/ R6 m' u
//Add more post variables if needed and add them to initform() function aswell
2 g& n0 t- f N% j: ]( z& _9 e$ I
4 S0 y# I- O/ W3 @################################- s* E. I: _' C* B
##### Connection and Post ######
. L4 }% d3 [; u1 t8 P) |8 k) U! G; ?################################
" Q0 _3 Q2 i9 t" d; s. a$name = @$_POST['char'];! o) C# E h' J* c Z& H
$ItemName = @$_POST['item_name'];
6 z# p6 F* f) s& T& Y$ItemAmount = @$_POST['item_amount'];
% @- h; a6 O6 p) h7 [$ItemId = @$_POST['item_id'];- k# l/ F# X+ h0 ? I9 U
$ItemUpgrade = @$_POST['item_upgrade'];
5 E7 ]. y% s4 C! y0 S: u$ItemElement = @$_POST['item_element'];3 X8 z$ Y' q+ [' e, k. z W$ @
$ElementUpgrade = @$_POST['element_upgrade'];' {3 N+ M; O& T7 D* r, U
$ItemPierce = @$_POST['item_pierce'];7 U8 R7 [: q" W4 a1 B, _
################################; q* U. D7 N* d; J% U
: A# r9 m) v, Y/ ?5 m6 U: G
//Check both variables for empty value
: i- A) y& t* v- B9 [4 Z- o
7 N0 U/ V/ E, y( {1 tif (!empty($_POST['char'])){3 {, L( H* M/ I: Q/ b( L
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where , k8 V3 C" o- C) c0 b
: I8 y3 v. B% K5 D- Gm_szName = '{$name}'");0 h0 W7 K" o% u/ c
while ($row = mssql_fetch_object($find)){
* K8 `& ^( @6 m8 Q- \echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";4 F8 q- N% a9 ]- H. T1 o
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
/ F" Q$ h3 t1 y) R' `' v$ Y8 R7 L" r. q4 b- f; c
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
, v7 Q: O$ J- ]* K. [# c2 k0 y$ [* S* z0 r
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 4 Z/ q, ]- K/ I3 J" X& b
& |' _- z( @8 k) ?5 NN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', / q$ u# D# s3 x$ a. Y/ p8 i
7 N3 Z7 H. ^; x1 j- b- b, R. b7 {'{$ElementUpgrade}', '{$ItemPierce}');");0 q0 q* g1 H2 O- J' y4 j
}
; ~, E' e' e: L
( j. B' ^3 Q( e. i5 O% I}7 ^* s4 t, ?# M% E+ _% H$ \
! t# c7 \: P- Y4 I4 c0 y
}
& H; m) n! b% D9 M; |( u C1 Q
/ O. h# d$ v! a$InitForm = InitForm();
( K5 U: w7 C7 |9 q' {$Listener = PostListener();
y0 \. p- f7 Z) a) j% P0 N( Y' C0 V) T0 W- O7 A9 k
?>5 R- p" M% b2 M9 \6 k' [7 C' q) Z
/ d' L9 H8 l7 L7 Q+ l- s
* \0 j5 V/ N* U: q; x+ C- D
1 {& v) u- V9 b. M, W( y* O; S/ w6 [4 H) H: a
|
|