|
|
<?php
. G9 Z+ Z& F+ C( Bfunction Connect () {
3 h& J( P/ W& o/ o$ `mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
( ^6 g0 Q$ L4 m/ y H8 `9 [- ?1 u" `4 W
Failed.');
+ r. X+ q0 h) u2 V1 C$ a6 F% M}
' K/ q Y% \( T+ {6 a1 rConnect();$ w9 O& x$ v O8 Q% j
! G6 s, V" F' d5 n" }$ U3 i1 Pfunction InitForm(){( w! x. f" V4 M, x( {
//layout for the form/ X- A' U# a/ O5 h
echo "<strong>Send Items.</strong>
7 g" C5 U6 `" z, ~, t<form name='select' method='post'>7 w+ c+ V' }2 y6 o- @
<lable>Character Name</lable><br/>' [: D3 G/ O: Q4 d
<input type='text' name='char'/><br/>
0 f, ^# B, J4 ^: a* a4 c+ e. L<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>" B2 p& v2 Q: \ R. C
<input type='text' name='item_name'/><br/>
, D7 m+ c; ]+ X: s4 v2 {% ^3 u<lable>Item Amount</lable><br/>3 u" M4 P/ v) A5 x
<input type='text' name='item_amount'/><br/>" T% q$ E4 x" A7 t$ {& V" e" i2 B
<lable>Item Upgrade Amount</lable><br/>
1 X) j2 b0 m/ \8 g<input type='text' name='item_upgrade'/><br/>% O) `1 w4 Y! P
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
: |5 S. \$ x! ]# @2 p1 x1 O
$ u! E; Z0 R5 l</lable><br/>
3 E- L2 f2 [9 F! }. A5 [/ F<input type='text' name='item_element'/><br/>
1 Z0 B- F. N: _1 K- |) O" p7 t<lable>Element Upgrade Amount</lable><br/>% t% R+ Y1 D- p5 K- c
<input type='text' name='element_upgrade'/><br/>
' T5 ^8 |! S; ^; k0 l<lable>Pierced Amount</lable><br/>6 `; M( w$ p1 F5 S: J
<input type='text' name='item_pierce'/><br/>5 e7 V( j* D1 W
<input type='submit'/>& l8 c+ T$ N( [3 w, k
</form>";
) q0 F# m ~7 V3 s! q& n}
% F; I! k: x% \2 R$ z' o, k- C( ?( l7 H7 o9 N+ B& D
function PostListener (){) O y/ |4 W4 ]% R( A6 B
//Add more post variables if needed and add them to initform() function aswell2 n* D4 F2 ?, S) k! K% W; F
) n% [6 X$ U0 f; L4 v( W' D################################! X0 H/ E5 |$ {5 @
##### Connection and Post ######8 B( X( r" o M3 m* r
################################
$ a7 `# ?, f& }1 ~) m- k$name = @$_POST['char'];
C6 K7 w6 G& H$ f' _2 t a7 z$ItemName = @$_POST['item_name'];+ Y+ L9 b1 _0 O& T P. k
$ItemAmount = @$_POST['item_amount'];( }7 a3 Y0 }5 b+ M6 K! T
$ItemId = @$_POST['item_id'];
" w. Y2 | D5 C6 q$ItemUpgrade = @$_POST['item_upgrade'];% \7 E0 n$ s: m; y3 U$ @7 v# A
$ItemElement = @$_POST['item_element'];
i8 p, n7 i5 \. z7 j$ElementUpgrade = @$_POST['element_upgrade'];4 |1 r) U; g1 ^
$ItemPierce = @$_POST['item_pierce'];
/ N: J2 |9 F: G' ?2 L6 B" G7 {( O################################3 O3 l0 ?: P `8 O8 O/ ^
6 L6 J L% {4 [+ p! b- i: N
//Check both variables for empty value8 ~9 `1 q- Y, h
1 v, y4 L: e. {8 g) O7 V
if (!empty($_POST['char'])){
' k# f+ P1 T k$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
. ?+ i- Y5 ~4 @( _" ]
4 e; A K" d( [* b$ Sm_szName = '{$name}'");
' c- n: r) N$ s+ L3 m& i4 N: q9 D! `0 _while ($row = mssql_fetch_object($find)){8 M; D0 k7 m% l1 H
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";) E7 H7 p; I, ~5 W- i: g; M1 W) a
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
( ]+ O, d) o1 y4 ]
' i! {0 \ M9 f" @[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
1 Y8 @5 }3 l( O
# Q" U6 v, c# L" f. b[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 4 g" h, d! f( F7 R# ^7 _
9 J/ b+ J# w' l8 C
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', ) j, S, J" [7 \3 `% b
' L: t" _( W+ n0 V% {( V'{$ElementUpgrade}', '{$ItemPierce}');");
. ]2 L; ]2 N9 v3 q$ q}
% ~# z) h$ ^# B# s* K6 V7 f: L7 H2 k8 @7 I' K; _2 A
}
, Y: n9 D% G& V F0 D3 }" I' W6 {/ N& X# I% _
}6 f; k, \0 \! d1 \7 t: f
" E+ i6 q" |- g, [" _, t/ N$InitForm = InitForm();
$ I' `, X9 H5 e( Q$Listener = PostListener();. L9 r7 I/ {2 {& ]$ C
Y: O7 s7 o# ?' J3 r
?>
" W8 s1 x3 o* j8 Q# V; p
# W1 u. v" F) [2 U
$ U4 I7 c! m0 I
! u5 V( U V! A z6 l" U' l K* I' A7 w6 R% l! D2 g* Y) L
|
|