|
|
<?php
. z7 y% z7 J9 o" J0 a/ L- W& @function Connect () {
& m& s4 G! A/ j8 mmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
( c! }7 `* I, I. ~8 Q1 I) Q6 R. d7 S' W, s/ g
Failed.');/ N" z; K0 s( `. R
}
2 b& P4 [1 b! r9 F3 o1 e9 tConnect();" R: `9 R" w! T3 v& d% b
4 R- M9 p3 R6 E4 m/ K
function InitForm(){
) b7 l: T! G3 S* k//layout for the form/ N0 h2 [$ G0 f9 {& X5 f6 S7 f& x) \
echo "<strong>Send Items.</strong>
+ c" I! f* k8 _<form name='select' method='post'>
, w- N& O) L2 m# Z5 {& n<lable>Character Name</lable><br/>7 W& [4 `; w- l5 j% W
<input type='text' name='char'/><br/>9 P! s+ K# N# Q" U6 o( f+ `4 Y, J
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
- ~0 ?, w: ^" S# V3 a0 X& b<input type='text' name='item_name'/><br/>
4 k& ?. d l6 V: f, [<lable>Item Amount</lable><br/>
4 w% C4 m. m8 m# U$ a3 ^5 ?% w<input type='text' name='item_amount'/><br/>
0 @- K: N$ T. u3 c<lable>Item Upgrade Amount</lable><br/>
1 L7 j; }4 m; |$ k+ ?9 Q) s<input type='text' name='item_upgrade'/><br/>
2 y2 n. G9 n4 r2 I<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
* w6 |& C( p, h1 q3 W t6 p
4 F" O+ \" H1 W7 K% a) T; v</lable><br/>
& t9 Y9 l3 u4 l( P- N( i<input type='text' name='item_element'/><br/>/ D4 I i7 p7 {9 Y0 H, |
<lable>Element Upgrade Amount</lable><br/>
0 L' T% K2 |0 V<input type='text' name='element_upgrade'/><br/>9 e: W6 P. B$ k8 x" g/ V! z
<lable>Pierced Amount</lable><br/>
# r8 L) `" J( @+ e<input type='text' name='item_pierce'/><br/>' h# ^$ N5 K7 [( Y3 j- \- F
<input type='submit'/>& Z, J1 U7 O" J& `' ?
</form>";
: N; y0 D M* J2 r' R% p}
/ @( M) k* P, ?
! P2 q# `5 p4 ? h0 D3 q; O: ifunction PostListener (){
3 B" `- ?$ F4 x//Add more post variables if needed and add them to initform() function aswell8 b" A5 \7 Y& [9 V; U
: A9 `2 u4 c# L, h9 g################################! q( k! t f% k' k9 |
##### Connection and Post ######8 @, A* y* v! P5 `# b! [4 R
################################
! s* n6 `" m) n$ R" ]( }0 Y+ q$name = @$_POST['char'];) ?9 \9 n* e2 U1 W+ E4 k
$ItemName = @$_POST['item_name'];
- z; h1 J2 Z% ?2 ~2 b, Q$ItemAmount = @$_POST['item_amount'];
" }9 D2 v4 J7 |- F0 h- I$ItemId = @$_POST['item_id'];) a ?1 {+ r8 M
$ItemUpgrade = @$_POST['item_upgrade'];3 ?: u. C5 c0 H: I& \
$ItemElement = @$_POST['item_element'];
5 u% y5 h9 q1 o7 h. j$ElementUpgrade = @$_POST['element_upgrade'];
3 Q- ]* Z& B' Q) @5 Q$ItemPierce = @$_POST['item_pierce'];1 Y( G5 i$ F- R. p; L" P+ W5 N- e+ e
################################
! F# H# ^. Z# J- y# J
* ^$ O! C- w. \8 Q8 [7 _. m# T//Check both variables for empty value
% q: U, `% v8 n! |! P7 D5 e) B" g) Y! z f
if (!empty($_POST['char'])){
' b+ ?8 V( W4 {2 i$ s$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where ' C7 c$ N/ o' k4 V7 @4 x
9 i1 |- ^& h# ]: p
m_szName = '{$name}'");' b8 ~7 T0 T, `! q
while ($row = mssql_fetch_object($find)){6 C0 l1 w* o4 K, |* h
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";- C4 z0 ]9 P8 A" Y
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], $ B, V8 M) B8 Q; K0 e# Q: M' z
$ Q9 B. ~& s @3 v9 m; R- `
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
( q+ K; P9 v$ B Q6 t
" k' n# z# m/ c) f9 ][m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 7 E8 n8 J- v, [1 o2 e% S( e
( b: Q$ I* X. H( k+ j3 M$ IN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
& `5 K; V0 o) h; L& t6 w' ~
3 w" s& ~' i% r4 X# ?. L/ I'{$ElementUpgrade}', '{$ItemPierce}');");% J( v1 Y3 ^% P
}
" @: n+ }# s' }, e& z3 }5 s+ q1 ?/ h5 m% L8 \, r7 d
}7 R( \- ^1 _1 X& k! w9 N4 ^ V
, d# F, }$ J/ W}1 f* G: _3 [6 @
6 I4 e7 b; e7 [- y3 ~
$InitForm = InitForm();" S% t& @6 u4 y" R. h
$Listener = PostListener();
$ G) d: n6 R7 h2 b; v1 v( j* x" w6 B6 p, G& J' E, Y
?>
, I% b& }8 d9 z& ~2 Q5 Q; j1 o: S. I \" O
- D* E" k3 l. K" o% M
5 p+ F! A$ N6 G4 S& t- f
0 J& Q, x. q. R9 I1 k |
|