|
|
<?php
2 j' b, B+ {. S& G, Ufunction Connect () {/ y! J. ]& b! Q- o$ A
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB * F, Z2 Y1 V: E$ S
! o* g; r/ C# |
Failed.');; I0 F5 B- t- C" l- y3 \4 J
}
! @/ Y% [" J" M$ E* x: [+ E( uConnect();- C8 H5 o& X% F: k- z( ]/ x6 B7 F
0 r; _; D/ X* u$ X, K( l+ t; C4 K. Sfunction InitForm(){2 g( B- c, b& }5 |; o: A+ W
//layout for the form
6 ~2 @1 H0 k1 I1 c' |echo "<strong>Send Items.</strong>/ V5 ~$ g3 W% Q
<form name='select' method='post'>
0 s- I0 O/ i* ~" f5 p0 S; n2 D3 v# e<lable>Character Name</lable><br/>; `. q3 F: Q" x" w8 A
<input type='text' name='char'/><br/>9 ^, e2 u/ P8 x0 n: r$ F
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
2 `7 C2 L' v1 Y5 [6 k<input type='text' name='item_name'/><br/>- ]7 X( x3 ?2 _% K2 U, H7 ~0 N
<lable>Item Amount</lable><br/>- B b$ f1 v! @' p- f5 v% L
<input type='text' name='item_amount'/><br/>
9 @' y) H2 ^/ T<lable>Item Upgrade Amount</lable><br/>! h3 \1 `- o2 W& {! s5 k1 h# A2 w0 }
<input type='text' name='item_upgrade'/><br/>
7 Q4 h# i' U( V, n$ \2 `8 u<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)/ r) T* W+ u% ^/ U# n) _
% V8 S5 h# _: r6 [) i
</lable><br/>! ^/ m% r$ Q d$ r9 [/ l
<input type='text' name='item_element'/><br/>
# m! X0 N& E$ y3 d7 I0 Q<lable>Element Upgrade Amount</lable><br/>
' K! p/ y2 z* x5 X/ r<input type='text' name='element_upgrade'/><br/>! U6 r& o& g# l9 b5 J% p
<lable>Pierced Amount</lable><br/>3 x- |! W6 o5 G4 y) b
<input type='text' name='item_pierce'/><br/>$ C! X% z; ^5 U
<input type='submit'/>
/ ^# o; \ t* J, S: _! w</form>";
. x7 b# r2 C. I* Q. L9 T) t% _( e4 f}
4 J5 g9 k0 e5 P' B! {2 J6 z8 K
function PostListener (){
0 Q3 c- L5 m* n" u9 B K//Add more post variables if needed and add them to initform() function aswell! g& A0 _: Q. S2 }: T
2 G$ E( s8 l( S$ x7 D################################
) J- |5 p- f. h3 l \, @6 o+ \##### Connection and Post ######
; }3 G) W7 s1 ^################################+ _( }& `' q, t" }; l
$name = @$_POST['char'];' o6 ?' ^$ i: S" X6 u* r
$ItemName = @$_POST['item_name'];
2 Z2 t7 F% G( n! m3 K3 V5 H" p$ItemAmount = @$_POST['item_amount'];" P W8 t9 g5 D2 e; ]
$ItemId = @$_POST['item_id'];# ]* B: A' m0 X/ l9 W
$ItemUpgrade = @$_POST['item_upgrade'];) C8 q# _) @3 U. \. N
$ItemElement = @$_POST['item_element'];
+ I4 W& ^' M) {: u$ q4 W( P! G$ElementUpgrade = @$_POST['element_upgrade'];
% F2 m! M1 j. [* L0 }$ItemPierce = @$_POST['item_pierce'];
9 x. s! n9 ]' n1 @, [; w3 E################################) A2 ~. S+ u' Q
/ E/ f" N3 [0 u4 Y! t1 w+ l7 B//Check both variables for empty value8 Q0 _5 H3 }7 R
# V+ u' J k# ^3 _3 v# o
if (!empty($_POST['char'])){+ E* w9 u6 M8 C! V. D) X+ [
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
& v$ h/ T! s* P, ^, W
2 O! j- k( P8 s2 @3 U0 _! \7 zm_szName = '{$name}'");$ v# n! E- t8 R8 a
while ($row = mssql_fetch_object($find)){
6 u9 a! ]8 I8 l. E Secho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";/ r' G/ q4 j- H% D4 [+ J
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 5 m# u9 k' ~+ k! }6 ^
: L9 t/ n5 g+ ^3 F. m3 \( C' I[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], # J. L8 L9 V* _5 X3 }6 u
' m; a( n$ Q$ `- q5 O
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', . ~7 s; {# \! U! @" m
9 {3 F% T+ _4 Q( B) y# `2 n9 L
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 9 C' ^( h' G1 u6 [
( A* D2 _3 \8 d3 b* ]% B1 S'{$ElementUpgrade}', '{$ItemPierce}');");
# H6 ~1 @; C0 f7 N}' n# I: ^0 z. j
% I' c0 x* J% f* v}) `; p( F1 ^" ^9 H3 F
1 u. v2 k! o i: x3 B W* V
}' z9 m3 H8 a# H* \/ Z' H
. R. p: X3 \2 k, U5 _8 {: {$InitForm = InitForm();
! ^* J! M: u4 e1 O$Listener = PostListener();
" N4 C' l. A2 e8 ]6 `8 g% v6 d% w3 T. r' d6 ?6 B [* a0 `
?>3 C% U/ X5 C& L; C9 Z( `6 J8 W" T1 ^
+ K% x1 i2 z9 I8 k3 Y- h2 p
$ z& l7 O. X' C9 M
6 I; t8 C6 h6 c. X: G+ S8 ^4 @8 D/ D/ W: l# m' Q- |
|
|