|
|
<?php5 N* S% w; J4 {- I# a. F. S
function Connect () {9 a4 ~ m* u( N3 b2 g+ L5 |" S7 }
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
3 M& b2 j* J$ z" n. l
* e# ^& p$ _; mFailed.');8 p$ T9 A1 V3 c2 G) ?
}
- r! Y! T3 Z0 _3 }& a; U, DConnect();
/ R+ P1 ~4 k1 L% n) f8 O
y5 G9 R& C. U% L! Y @$ l0 mfunction InitForm(){
9 r$ Z, i0 N; L, M! q//layout for the form2 [! M1 A" d6 o+ C
echo "<strong>Send Items.</strong>5 x4 v. u/ `7 N; l( J& i
<form name='select' method='post'>" l2 Y+ _* U0 W% Y) j
<lable>Character Name</lable><br/>
) Y; ~0 ?7 @3 y$ N<input type='text' name='char'/><br/>& s. H# I H2 i7 W' c* l! M8 K
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
3 I! ^0 w! A! ^ U- ~<input type='text' name='item_name'/><br/>
* \5 {1 n+ L" x# A* V ^<lable>Item Amount</lable><br/>
2 Q; V) t# Y0 I& U* ]5 S<input type='text' name='item_amount'/><br/>4 ] x* f! \6 u0 ]; o
<lable>Item Upgrade Amount</lable><br/>8 B& q$ `8 s* `( r) I- y8 r& ~) Y
<input type='text' name='item_upgrade'/><br/>
. |# Q7 \, H/ o- r<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
$ Q7 U, A$ M3 f! @, K' u2 C$ M3 Z2 Y8 d1 t! f
</lable><br/>1 T+ D7 t# }/ M J- d( x; J
<input type='text' name='item_element'/><br/>
$ o ?3 L) ?7 X2 l2 b6 ^<lable>Element Upgrade Amount</lable><br/>
% t# Q8 F1 B: V<input type='text' name='element_upgrade'/><br/>
1 w* F. l! w6 G3 J% F; |<lable>Pierced Amount</lable><br/>6 f/ I; j/ M$ z Y' x
<input type='text' name='item_pierce'/><br/>
" ]( F3 v* P4 J* U( J* F# Q<input type='submit'/>
. q; X0 \4 M* R% x</form>";
$ [. |3 n4 K0 c, w5 n6 ?}
( |/ r. X; k( V+ w; ?% V
1 a" t! O* N0 a; E; f8 `9 nfunction PostListener (){
( B* ~ B# D* a9 M5 C9 S8 o- u//Add more post variables if needed and add them to initform() function aswell
) C* D* D( D" _4 E, |9 v) V/ q8 B& O' u
################################
! y% H* C& `" b9 ~ W' C##### Connection and Post ######
$ |! B0 I- p# K. ?. m7 K################################ R2 b4 p+ y$ f7 R. Y
$name = @$_POST['char'];
* A) V0 o K: L9 H- |9 \4 g+ }" F$ItemName = @$_POST['item_name'];
* t4 k" l0 D2 r( s& k! o$ItemAmount = @$_POST['item_amount'];& \& a M* W! B. e! H5 d; [; N
$ItemId = @$_POST['item_id'];+ A: w3 C ]2 e) ]0 S. m7 x
$ItemUpgrade = @$_POST['item_upgrade'];
& i( V+ {! D. Y& y4 Q3 x1 j$ItemElement = @$_POST['item_element'];" I* W- z! j% P2 t6 n, i2 R
$ElementUpgrade = @$_POST['element_upgrade'];9 b+ K Y" n' u: w
$ItemPierce = @$_POST['item_pierce'];7 G9 ^2 o3 U/ j) a' g
################################
) Z, U5 t$ C1 a3 K& A8 A! C5 I7 W# C1 ?8 r9 P: p- G' p$ k9 u
//Check both variables for empty value
A+ e- b& V- m. L, S
Q1 S7 Q* t7 \0 Wif (!empty($_POST['char'])){
! x& D0 p, C0 ^/ g# Z" I$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
) o/ ~1 y3 ?! e- n1 K5 S# T7 h+ @! I, _0 y. `1 q+ Z
m_szName = '{$name}'");
0 E& K; D" X X* b" K7 M {while ($row = mssql_fetch_object($find)){
3 ^5 \ L1 y2 H6 q: Uecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";) F& R! I$ B0 `! k- t3 V, E
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
# q% e. {6 Z& u1 [$ J$ j/ p+ ]+ ~+ O/ E9 {; q4 T: @# h1 M6 [
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], , k3 h- y: V' S- T
1 f, ]$ P7 o! a% [
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
" M, A( |" n9 `- w2 g% d, h5 ]7 R1 [3 j8 Y6 x9 L
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', g' B8 Z5 y& v% G2 ?0 D C) U! t
$ t, f' S' e# R4 H1 G; X) {
'{$ElementUpgrade}', '{$ItemPierce}');");
@4 b! e7 p. {3 Q1 d& `) A M& D}
4 g% d8 I( j. o
1 S, [3 }2 H1 Y8 j7 {}
4 b" T; k, x Y: Y
, {, i7 N1 w) y6 S4 o$ B}
8 A/ a" @# }4 [/ h! q, z M2 }- ~
' i6 Y- t* q' E6 Q; G9 k& C$ [$InitForm = InitForm();
9 @+ [% D: ^1 S+ S% |$Listener = PostListener();* ^. A) i/ t% \8 `; J# g; R; b
4 B' l' _1 z& w* X& P?>
8 m5 ~: x# Y) R4 Q9 y( l/ G) h3 J2 L5 ]1 s+ F, {3 G
# h* L% b$ M* t4 P
3 P: k- J7 |/ x% r) Z. E3 v
9 z6 v% w4 ]& ? |
|