|
|
<?php
8 R4 H9 |. |- C, u/ ]4 |function Connect () {
" A: D& l3 F: [& r G; i7 j4 imssql_connect('Server','UserName','Password') or die('Error: Connection to DB 7 g, K4 x8 ?. I6 B
0 M( H D" ]$ b; @: E
Failed.');0 Z L" ^, k7 v z1 d
}
1 L% J% V; \2 t; T6 ~ P3 k* y: n2 GConnect();
: u; V9 t) z/ T3 l7 k4 ]% U3 Q5 Q2 C9 d; \" A
function InitForm(){
$ R' M! _: `" o" c8 T, e9 l! N//layout for the form% U5 h+ L' J2 c7 h
echo "<strong>Send Items.</strong>
& z& _3 P5 M' Q4 q2 E; y<form name='select' method='post'>) A, t9 w! h5 f2 m
<lable>Character Name</lable><br/>
) X! q: P/ t8 u9 b<input type='text' name='char'/><br/>+ f% I' k$ V/ l2 _% i& I) x( U' |
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>, `0 ^+ P9 {, }1 T
<input type='text' name='item_name'/><br/>4 ~+ Y7 D9 _9 B& A9 ]$ X
<lable>Item Amount</lable><br/>
3 P9 |3 U' G5 I+ H4 E! ^<input type='text' name='item_amount'/><br/>$ h, w2 J$ q9 o+ ^
<lable>Item Upgrade Amount</lable><br/>; X. @; h/ d- k. D9 t U# I8 n! M
<input type='text' name='item_upgrade'/><br/>% a! u$ d* K9 z. i$ d$ y, B
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
3 ?" [3 ]: l9 A# F8 }! {4 J7 i! O9 t3 Z. S9 a& T
</lable><br/>
6 x! W: q1 X3 d7 B<input type='text' name='item_element'/><br/>
' v1 D: }+ L5 {$ c7 W' O. I4 d<lable>Element Upgrade Amount</lable><br/>
# l- \3 o0 _2 z# k7 Q<input type='text' name='element_upgrade'/><br/>
2 }- P; b! x/ X8 j v1 P) }<lable>Pierced Amount</lable><br/>+ V4 U: q( a5 V; W) t4 @
<input type='text' name='item_pierce'/><br/>
2 r& ~; N3 e) n. _4 _<input type='submit'/>
3 j7 A: c# P$ ?* {</form>";
8 }# c; c1 K: l. `8 B. }5 H0 [% I: V}% K" `* X+ W! I* D: u
9 ]# m! S3 M+ {* L6 p6 F3 P
function PostListener (){9 v$ [3 K" Y1 u6 e5 w! e
//Add more post variables if needed and add them to initform() function aswell8 g `- Y. Y( B1 B) o/ I5 N! C
( _* G$ [/ X3 S) E6 G1 I5 r2 s: A
################################
6 s3 I8 N& ?% \6 k" q1 p" h4 o##### Connection and Post ######
# i5 q3 X) X8 w" |2 l################################
0 _9 D4 J& |# M/ t8 i5 {3 K$name = @$_POST['char'];" }0 ]" g) T2 {" a: l5 D/ l7 z% m2 K( v L3 R
$ItemName = @$_POST['item_name'];
0 _, r" G' b, k+ k$ItemAmount = @$_POST['item_amount'];
/ r* l5 W9 O0 q$ItemId = @$_POST['item_id'];7 J: m5 k& ^' e$ }+ A
$ItemUpgrade = @$_POST['item_upgrade'];
( T( A" P8 T" Z4 i5 K% g$ItemElement = @$_POST['item_element'];
2 T& ~+ e C: y) l" ^3 v$ElementUpgrade = @$_POST['element_upgrade'];
& h! _% [3 H1 K, L$ItemPierce = @$_POST['item_pierce'];
3 F1 I( c4 m' O$ m( Q################################
c; L/ U/ n* e* o! |& o6 d0 D2 m
6 \$ q4 H" s4 } n6 o//Check both variables for empty value) v/ B/ X9 s% f
$ q# D }0 z. h
if (!empty($_POST['char'])){8 B$ Y. j7 u& u) }# H( A
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
9 n# X$ L, r p F5 T
4 s9 _& i$ m v4 L6 k2 qm_szName = '{$name}'");
& e/ w! A, A- j; I4 V! Z$ b: \while ($row = mssql_fetch_object($find)){; ]3 l/ m/ d. T4 n
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";; l7 M" t. Y v4 V
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 2 m; g; m5 ]! y* Z" e" y$ E$ ~5 q
/ V6 W' M2 v. b; J1 _9 h[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], 6 s" C: {& ^9 \2 Z+ y8 [
& h$ i, d& X& z- |9 U
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', , b1 m, `" ^3 v( Y
8 L% J9 o9 P) |2 K9 Q, s4 F" w
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
% t: |: V9 X7 \0 n2 \3 \: Y3 G$ x/ d
'{$ElementUpgrade}', '{$ItemPierce}');");
/ S/ Q7 F3 r- H$ h}
7 z- \' P6 X% L" O/ K6 {0 B3 n0 t6 x$ k2 |9 J3 i* ^ W
}+ C& R3 X( S" s3 A% R2 \8 b
1 T9 C8 e' i) n; T- e+ p% A1 ?4 q}
& u2 E! {; T: E2 Z0 A& m% J7 n# @. ]( V& T& h, Z
$InitForm = InitForm();* s, I9 _7 o; \' X
$Listener = PostListener();3 j3 N- s7 D: i, i# E7 f
a% m8 ~0 `. J& G, u?>& r# k' v) |) P5 X O
; h+ o7 {. ?" ~ G" T; z$ P. O1 M' A# m8 ~
5 s8 F8 j, u" i1 @, v+ u% }
+ v7 D3 J0 k7 E- z7 U |
|