|
|
<?php; P2 m0 z6 ?( p. J2 X
function Connect () {3 c0 W& n4 j. X: f# |
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
7 w) a9 ^+ T. ]# {' Y" ]' f
- t/ Z0 ]* [3 \0 h* }& T# f' dFailed.');
. H0 W) R1 Q" R2 Z}
0 L; v& K4 b& ~2 u2 fConnect();2 R9 `* Y! [3 D* k p( b/ n
/ I7 k4 C$ \3 l1 p9 |function InitForm(){+ v- T6 z# j: ^% O
//layout for the form
4 Z$ S5 { X! t' l" K( ]" z- xecho "<strong>Send Items.</strong>, l/ t& |! Z( G3 m! y
<form name='select' method='post'>
# X& G' }# C$ E3 h1 ~<lable>Character Name</lable><br/>$ p( m2 }3 C8 B* u) \; q
<input type='text' name='char'/><br/>' a3 K$ V8 f6 f8 y' f
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>9 I1 ]* l% I- U- ^
<input type='text' name='item_name'/><br/>
9 g7 y+ P" K! K. s ]<lable>Item Amount</lable><br/>
& j) g1 d) _# ~. j( e7 ~' k<input type='text' name='item_amount'/><br/>
/ Y# A0 l/ l' m! ]6 R" R<lable>Item Upgrade Amount</lable><br/>
" C/ S1 c* c2 b) ?6 x1 ^<input type='text' name='item_upgrade'/><br/>. _9 ~% n& I9 L, p
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
G9 P1 W. t$ U, i3 P" J3 P6 n* i; W9 d! W; a
</lable><br/>
6 y& i `6 k' A( W* w<input type='text' name='item_element'/><br/>
2 i6 W9 j" U: n+ ^- x3 r6 T<lable>Element Upgrade Amount</lable><br/>
5 [7 O' R( J( e4 j<input type='text' name='element_upgrade'/><br/>( M+ H) I% _6 v
<lable>Pierced Amount</lable><br/>
4 o \& I/ g x; a! `' ?. H<input type='text' name='item_pierce'/><br/>* d! u1 |" J! q( ~+ o2 d
<input type='submit'/>2 Z' L% U6 F/ A) x" `
</form>"; }% Z& D) P' k- ^. E! D
}
4 R( Z @2 C2 X6 x4 q9 y
7 Z# O ^9 W0 R5 P* Vfunction PostListener (){
& }0 x7 [" N* C% B- s8 k! N1 ?//Add more post variables if needed and add them to initform() function aswell4 i7 m' }! x" h, b! A N8 \
/ i5 w" ^% U+ y$ _/ F4 M
################################, S/ b4 _2 Q: Q. H
##### Connection and Post ######
( W2 p% R2 N+ }. y3 t/ v5 l K1 H7 F################################
: E7 T& t( d% K7 T4 S) N9 r; c$name = @$_POST['char'];
6 ^6 l" k3 U, m0 L- I6 w3 ^& t2 _. a8 f$ItemName = @$_POST['item_name'];) V9 o3 E+ H6 g) M
$ItemAmount = @$_POST['item_amount'];
7 R- J, S" c" o% M# b6 m" g* P$ItemId = @$_POST['item_id'];
% }- X% Q, Y3 A4 o$ItemUpgrade = @$_POST['item_upgrade'];
2 @3 p; H* P" {, t% [7 V* P: e4 G$ItemElement = @$_POST['item_element'];4 ~/ E2 r$ t: P9 v
$ElementUpgrade = @$_POST['element_upgrade'];
: ~% a4 u2 c% H7 e# [$ItemPierce = @$_POST['item_pierce'];4 C! g: T* N* U/ j" z* g, |
################################
: E2 b3 p F" f" i; t. o. n
7 A. @$ u0 | o) L- E//Check both variables for empty value4 T$ Y/ m# `. o E9 P% \( u
0 W0 |0 z+ T. K) b- E6 s4 Q4 P
if (!empty($_POST['char'])){
P: T' G- N+ |! r0 o4 s$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
' W9 R9 c, t* q) w3 k5 C& ]& H) B x5 Z& @
m_szName = '{$name}'");; W" n5 e! O$ }, ~6 d) ?; @
while ($row = mssql_fetch_object($find)){) T8 G+ c! r( S
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
& b/ P7 O1 ^7 q7 \ S3 X$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
: r3 V1 C& l. [) X8 Q; [4 A" \0 Q( z( d$ S2 D$ s2 C, o+ R
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], # e" k6 L% \0 [' d: C' q& o
_* G: P4 ~6 T+ A* ^[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
, x& [! n3 L. Y1 \7 ~! x$ p$ ~0 z' i. a. _1 |0 `& E) c
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
, X! W0 r5 s! ~ o8 f& S8 M* o: J8 h; m( U' h
'{$ElementUpgrade}', '{$ItemPierce}');");
1 k+ R9 ^* v1 k2 h n8 h- {) Q! `}, a* |1 p7 y5 o, V
3 y5 N3 H9 h1 ?1 b/ }
}
5 J! ~' m$ v# j0 @# w9 @0 V
% Q; e6 @6 z$ @# ^$ F}
$ Z% \* Q) K( C" m3 W! h, ~: D, s, a5 L+ H' z% M$ {: m
$InitForm = InitForm();
4 b" S* y/ j; H& E$ C: |$Listener = PostListener();
/ z) [4 c. N8 w% P$ L; m R6 r3 i9 G: \/ i) h* J4 `5 G+ x& M
?>
5 F; z( K. ^) `' m9 b
0 _+ Q8 C/ D: S! c9 F4 l- x( m" a3 V
( B4 R% I6 B. t% S. ^
L8 P1 B0 J' A! P) _% t$ y |
|