|
|
<?php+ U! K( Z1 l4 M$ l
function Connect () {$ I. q( S" {9 v+ Q' I2 k
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
0 u" F: y6 X. ^! Q5 m4 I5 L, I* F: m# J
Failed.');
& Q5 E1 L! N0 z6 r7 O}( ~+ h0 B X; Y3 g( }0 o
Connect();
! U+ Q V, k2 D1 ^" T* ~( K, \4 O3 r# ?- h2 g4 M! H/ l
function InitForm(){, X9 _7 H) i, F
//layout for the form
% a4 y- \: ~5 ^& p5 lecho "<strong>Send Items.</strong>
! ^0 e- u9 Z- }+ ?$ o<form name='select' method='post'>3 i$ w0 e$ J+ Y1 V1 a" c
<lable>Character Name</lable><br/>
; w6 b8 Q v0 Z* }5 Q) B<input type='text' name='char'/><br/>
/ z2 [/ p& H, d$ g3 V/ J<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
5 \0 g' \4 `5 H8 Q; E) i! R<input type='text' name='item_name'/><br/>" }0 e+ g9 w- E9 y9 D1 j$ V A, ^; A
<lable>Item Amount</lable><br/>
3 t9 _1 G Y5 M* p0 P<input type='text' name='item_amount'/><br/>! M5 M, @' B9 Q1 B# S" C: l
<lable>Item Upgrade Amount</lable><br/>
3 R$ n, m* N, w7 |<input type='text' name='item_upgrade'/><br/>! c6 h7 P" w7 r" Z- d* b
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)" Z3 Y: ?3 ?- h* U) J
P2 k E5 N: T3 p1 Q2 s& s
</lable><br/>
i/ a- _0 l% K4 ~8 E4 H) ]( [! G<input type='text' name='item_element'/><br/>1 L4 k. ` B( |# L( D4 D( c
<lable>Element Upgrade Amount</lable><br/>+ t1 J! }5 N, b
<input type='text' name='element_upgrade'/><br/>
( R8 T! ?( }7 Q: ]3 G<lable>Pierced Amount</lable><br/>
' B6 n: y. J) I) e, M( R) V<input type='text' name='item_pierce'/><br/>3 k! |& q" a5 M7 a5 v; q; b4 d
<input type='submit'/>
% m1 W* O+ n1 F$ C# }! \</form>";5 `* u; m- I: r! {4 C! K) v1 B
}
7 H- k, W ?8 H' n9 [) T4 O+ n0 t9 b" t, N |
function PostListener (){
: {4 e/ _' w% [9 q S- T9 z' t//Add more post variables if needed and add them to initform() function aswell
, E% ~ h% K0 S( o+ p
1 V/ F/ o# |+ i7 L$ ^% I################################
% @ w2 m: x0 _1 U##### Connection and Post ######( \+ Z+ y3 V+ f! o3 h
################################4 L2 v$ Q( h2 `4 I8 _
$name = @$_POST['char'];
+ {3 n# l3 X0 D, [/ U7 H0 i$ItemName = @$_POST['item_name'];
H1 i: ?4 _% U0 b- x$ItemAmount = @$_POST['item_amount'];
' q5 g- s5 ]# K$ItemId = @$_POST['item_id'];
o; A0 B. U; C. U5 f( J# Y# J$ItemUpgrade = @$_POST['item_upgrade'];) X) Z. c& |% C
$ItemElement = @$_POST['item_element'];
- u h# m. u. i; g/ n$ElementUpgrade = @$_POST['element_upgrade'];" j5 X' W9 W/ ~" r }
$ItemPierce = @$_POST['item_pierce'];
2 f4 f) t+ D# p& [" b9 `$ Z ~################################' u7 z8 N5 G& s5 d7 I- G* ]1 V
. \& k9 b3 ^; ]
//Check both variables for empty value, L+ [& t6 P$ |! [
4 N; e1 u5 g0 c4 i
if (!empty($_POST['char'])){
: k, l( B# @& b m% |: e( q$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
' k+ n+ N6 X: ^8 p) M+ o5 v* e
0 ], _, J' @2 Dm_szName = '{$name}'");; F* _. V; v. ?+ R( f
while ($row = mssql_fetch_object($find)){1 c- ?, f6 m8 J( A$ F: l% u5 f
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";5 L5 S1 O: @+ d( E
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], # C/ D6 E# [5 G0 `% \* ?
; P. }$ r) i9 W& v$ M
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], $ @: R" J! d$ e2 d0 c7 V$ {# w7 o
& u0 G* r0 Y" y5 m
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
) G* l) t# t+ S, J) p$ t* J, O8 z% |$ n. @) s0 u% J
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 0 V B$ B& r% J3 ~ M6 o) A
/ |! K. B8 ~* W, E9 z. X- Z5 B" M
'{$ElementUpgrade}', '{$ItemPierce}');");; ?( [9 j* [* P# a* i; @: U' P9 P
}
8 y$ R5 b2 M1 ^3 _3 M2 x( r8 c7 u/ W, P
}
4 m, J& q5 N3 {& r6 C# ~4 h: r2 ]6 T' B. ~
}; _; J$ S: A6 h
' D# S F2 r# w. i: V$InitForm = InitForm();
5 i+ x4 a8 z+ e* L/ g$Listener = PostListener();
& V) o9 i2 H0 Z E5 A$ s% U
5 Y" c; E/ [( u: Z1 K" [; I?>
! j! h( q5 v: G* C: a& g# w7 a* t: N1 b8 M+ v8 ]+ o3 K8 ^
; w7 B9 D' o1 A/ b6 g+ m. q+ Z+ \) N8 P" o
! A7 v- l1 o$ N) \9 X& y X7 M
|
|