|
|
<?php
, Z. g& G, h7 U& f7 Gfunction Connect () {1 _$ P9 ?2 n7 ~9 x0 ~5 @& ~' U
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB . o- A7 J5 I3 G) ~, e, ^
4 A _1 O/ ^7 [- r
Failed.');6 t+ [0 L9 W6 _8 T% B- r# G
}
1 n1 Y5 ~) j# P2 s. Y- sConnect();
8 l. h: X( c, y8 y3 Q5 `
: h7 P& _' j0 `2 o' |* N' s. [function InitForm(){- n% {% c; N& e( d' ?! n
//layout for the form
7 q' U! [8 E- e* `* a$ d( \echo "<strong>Send Items.</strong>
: q5 i0 \, V3 }: U, B<form name='select' method='post'>
3 M! V5 d; y' a& `! V, c<lable>Character Name</lable><br/>
9 r t. g3 ^; q' r8 F9 u' }' j<input type='text' name='char'/><br/>: i+ p! y( o9 U$ l' M' g
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
) r* M& U6 X6 D8 j; \ t6 I<input type='text' name='item_name'/><br/>
7 l- I' t% \! r<lable>Item Amount</lable><br/>% k" W: W6 K% T4 a
<input type='text' name='item_amount'/><br/>
1 a2 C$ k( q0 a6 ^<lable>Item Upgrade Amount</lable><br/>
1 D) G0 a' z+ q9 C& N<input type='text' name='item_upgrade'/><br/>
1 |! d) F2 |# |- c<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
7 C( I; Y" o2 f4 Y' V% ?3 }
2 l- K3 H% u& ~- h0 q) }2 }</lable><br/>
6 L. |% t5 N; Z+ b, R- B& x<input type='text' name='item_element'/><br/>
5 M& K7 R# @! n9 V# g! s<lable>Element Upgrade Amount</lable><br/>
( p' n9 s! Q0 W: k: J5 o( {% h+ D<input type='text' name='element_upgrade'/><br/>
) I' M |2 R8 ~4 w. _1 E<lable>Pierced Amount</lable><br/>: x( h* d2 Q. i: ~8 ^) X9 K$ ^5 p
<input type='text' name='item_pierce'/><br/>6 ^3 x C5 B8 j
<input type='submit'/>
# i$ W1 v" y, P& I</form>";6 g7 q) p1 r9 j9 [3 }. k
}
1 d; z" q: r9 L1 }7 ?
: ^& t* [0 r1 Ufunction PostListener (){
- p L e, I. {) E7 ~, ?//Add more post variables if needed and add them to initform() function aswell9 K( X) H [1 S8 F# i; a
& `+ H6 {* ~. S4 r! l' e: C" F! ?################################5 X7 C* B: }5 K0 d4 h
##### Connection and Post ######& g# y- D4 Y% z9 j
################################) ~3 T/ j' h+ u/ a
$name = @$_POST['char'];; }6 t3 i1 w0 `1 `
$ItemName = @$_POST['item_name'];
. e; [5 E3 W0 B$ItemAmount = @$_POST['item_amount'];
7 [2 q! Z- k H$ ?# f% s8 b$ItemId = @$_POST['item_id'];
s9 |# V( D* L' l1 H$ItemUpgrade = @$_POST['item_upgrade'];
0 G8 a0 I1 L/ g6 H- G- [+ A' e4 [9 V$ItemElement = @$_POST['item_element'];. R5 i/ q6 @$ w
$ElementUpgrade = @$_POST['element_upgrade'];
! ^& J7 k: I" w5 f* ?& [$ItemPierce = @$_POST['item_pierce'];
% S2 ~. t- D- t2 X################################% y0 k1 H0 N. b& X! D9 O% L2 m
6 d8 t1 ]6 ? K6 \" j
//Check both variables for empty value8 P0 c8 m+ M0 I- r7 x- j
8 l- F( A3 d7 S, A
if (!empty($_POST['char'])){
2 ^) u! K: V( m$ ]0 k$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
) H% \# P1 X& A. a/ d- a* c" s% a6 H: J) [
m_szName = '{$name}'");
' u W8 o3 c* j, w6 R, nwhile ($row = mssql_fetch_object($find)){. U" C1 M r5 E! \
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$ ?2 i; L: o9 X$ J5 E$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], & Q4 w: m b1 t9 ] G
! H* N& K) S, j; c' r
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], ; u9 Q# h# N; D& g8 P7 E
6 ?! \6 b: h* n0 s! \- I[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
+ n4 v0 t$ N @* e: O8 g, d8 {' B( }+ M) D M
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
% r% W: g- {- w& z, V" [# g. m# }- k5 o2 x
'{$ElementUpgrade}', '{$ItemPierce}');");
# s% B; [5 M6 \' ^) g}
- K+ }0 Q( U+ d' z' m d q7 R: H- F
. ]% g# ?& R/ g' x1 a}. ]+ [4 T: E# t( F4 }! f
3 K' _7 i+ l6 \6 J) {. m9 h}9 _5 ?9 {) Q1 f3 S9 y, Y
* i; s* ~: _, t" G' m$InitForm = InitForm();- R" b3 J4 L: D: \; j% B) p9 n4 v$ c
$Listener = PostListener();
- z5 }( c( ^8 G1 D
) T, [7 h4 A% g! n3 ]?>8 Y0 _9 r. G- y, v/ W" }& _7 Q7 p- b
2 f' x3 d$ b# h4 B5 d# u! {2 F
8 b. D$ t% `+ [/ B1 t% o, x% s0 K# p( y, W3 O! C
% {, f( L# ?3 |# A) e |
|