|
|
<?php4 A1 m/ V9 @# p% z
function Connect () {5 Q1 ^" L' D$ E/ E/ B
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB 8 v% ~. D- j0 a2 A
2 {8 U; l& y# r' l: _, @6 Q c
Failed.');7 R& b3 }8 m7 o. T7 i
}# ~, v; [" x% L7 n, }' Q! x) h) S
Connect();9 D0 }4 _, w& J6 h4 i3 |' J. R$ ]
: T; ^# F" e! I' wfunction InitForm(){! ?9 x- Y: E, R+ X; Y
//layout for the form0 e' S0 i# F z }
echo "<strong>Send Items.</strong>% O7 }/ }4 S# m/ f- ?, R
<form name='select' method='post'># t; L" W: w- u3 @# ~% p0 w5 t
<lable>Character Name</lable><br/>
7 @1 C" T0 b5 Y& Z; K1 a2 y<input type='text' name='char'/><br/>
& y4 ]$ s3 ~: R b( i<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
4 i( |# |! N, z! m" F6 K<input type='text' name='item_name'/><br/>, |( f8 x5 b" i8 Z+ j, {
<lable>Item Amount</lable><br/>8 e) m H- g5 S% I% H( m
<input type='text' name='item_amount'/><br/>
$ ^* n, D" g( B9 z1 N! N7 U<lable>Item Upgrade Amount</lable><br/>
- B- b9 ^& Y0 Z) a* e) d) w<input type='text' name='item_upgrade'/><br/>. k2 \ y+ i7 s3 F6 y% R4 o L- `! C4 |
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)9 w9 ?8 J- D- a U# a. I
- e' y# L3 m4 r
</lable><br/>1 J9 f* c8 n; N" @+ N2 O9 ?
<input type='text' name='item_element'/><br/>
) y" ^% e$ p2 S% s<lable>Element Upgrade Amount</lable><br/>
, ?; y" K/ p5 U0 z<input type='text' name='element_upgrade'/><br/>( A- s7 I. F8 Y
<lable>Pierced Amount</lable><br/>; t. Z! A; ^ g
<input type='text' name='item_pierce'/><br/>
7 V. a' q, i P# H- h7 l<input type='submit'/>
2 \: O! s$ W8 \6 q( V</form>";& V2 f; W3 K5 D: J; [4 M
}% `! V$ m5 Q2 D- M5 C- X3 l l
0 c8 w% J% l- v) w& {5 y) Y& ^function PostListener (){: H3 j. v$ u6 G
//Add more post variables if needed and add them to initform() function aswell! Z* B b2 P; r/ T
1 {% k0 L* j L- l. F
################################
# ]% u( B8 B" y- [: ]0 E##### Connection and Post ######/ ~6 {5 q# Q5 s; V1 T
################################: e# f7 _- X h$ h( \. M; r- I/ y
$name = @$_POST['char'];1 q9 Y4 a/ W# r4 x
$ItemName = @$_POST['item_name'];
: g) G; _# j4 I( E4 W$ItemAmount = @$_POST['item_amount'];$ M5 N4 F9 o& x% J9 b3 F& u- q( p
$ItemId = @$_POST['item_id'];3 h- |% ?) a7 |! @- y/ W0 a
$ItemUpgrade = @$_POST['item_upgrade'];( P y- {' E5 E8 k1 I! H
$ItemElement = @$_POST['item_element'];# k8 ?/ q( I- I4 u
$ElementUpgrade = @$_POST['element_upgrade'];
# o! w7 j7 k4 l: U$ItemPierce = @$_POST['item_pierce'];' X3 M3 G5 c$ J% q2 l8 U6 Y
################################( k- f8 `+ ]5 b4 }6 t5 @
5 w7 ^+ D5 H5 D' |//Check both variables for empty value( J8 v$ {; I% X( }7 R6 w
1 L6 k0 o6 A9 a5 K2 f' D5 I
if (!empty($_POST['char'])){
) v4 X4 e+ |4 t# w; R( M$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where " D+ D" ?! w8 l, o& E3 H B
$ v/ F. n( ?5 i5 P. N/ t( x+ m
m_szName = '{$name}'");% e$ f. ?! F5 o. Z
while ($row = mssql_fetch_object($find)){
/ I7 G( ^4 |6 Z. B9 ]9 Y; R4 }echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";6 G7 a; R+ N% d. c Q; D) }' u
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], $ P; v6 Z7 V! [2 a- L) X
% Y7 \, S# }6 i. L* w% ?
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
% D; W" `2 p0 |1 T" E2 n! u% }2 D, P: ~
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 1 l M5 }, ]9 H% L; u; i+ K
% a" J* e" X# AN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
# w/ ?9 }$ o1 M& e% \
9 H' p0 N% Z6 h, p& z' L" n- s) v'{$ElementUpgrade}', '{$ItemPierce}');");& G. G( N3 ~$ M1 I; [1 I- ]5 Z
}
5 i( y3 k6 J0 s& Y! K" r r T3 G2 Q& J$ K+ @+ {
}) n& f* Y3 _- P& w
& V0 T2 z" B% I6 e4 O
}( ^' `/ s) j/ ~" h& B& v' Y
7 _. \/ b2 U! ~) v7 s
$InitForm = InitForm();
$ H9 b; C) t& b. G2 F+ e$Listener = PostListener();+ \" N' H' H; _! @8 U P3 v5 I
) r V& k3 a) M8 Y. ^
?>+ `9 Y: i2 |2 M U, }$ V" r# m
$ T* a4 @2 l1 p( G- d7 j" T" w5 d% I1 I! {: B
2 q) f6 e, C; n4 n1 \
) Q+ i0 ~! V% S" y |
|