|
|
<?php
/ R+ q* ~# v5 i1 W R/ Kfunction Connect () {
. G+ M; Z2 K! \( Z( Emssql_connect('Server','UserName','Password') or die('Error: Connection to DB + I7 ~. l9 e9 ~2 z
" B' W4 j9 e! B: |Failed.');
B$ U* X1 Z4 Y# A9 a3 o7 L}
7 Y8 D" @1 L( w0 \3 P; ?Connect();
$ o& a4 r, D; l% P. l" F: r, N) z6 \* V! S4 r+ t: u
function InitForm(){
- R5 E2 a$ {0 T- m1 N" s//layout for the form
, Y# [4 I+ C4 k0 R- Yecho "<strong>Send Items.</strong>2 p1 I1 |1 W5 P' ^6 _
<form name='select' method='post'>
2 q' b5 O) d3 i# }1 H- H<lable>Character Name</lable><br/>
8 F, [6 i+ k3 k0 |2 z/ F<input type='text' name='char'/><br/>/ @1 j' T; G2 H# Z/ L. i
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>. i- d# c# b% G5 B2 |5 s
<input type='text' name='item_name'/><br/>
: t( J7 J0 ?8 o% i0 Q<lable>Item Amount</lable><br/>& v& g3 O: W8 v" O$ S" y
<input type='text' name='item_amount'/><br/>& d7 \" {3 S0 w8 s( \, [( j& q
<lable>Item Upgrade Amount</lable><br/>8 J+ B5 Q [* _7 _
<input type='text' name='item_upgrade'/><br/>
. `/ R. z" ^4 Z' v7 U<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)# X6 f/ u, E8 B+ _
0 F4 ?+ a" V8 Y- b& Q& D% r</lable><br/>
$ g4 ?9 ?5 @7 a$ k- B<input type='text' name='item_element'/><br/>
9 v3 i# j! k# Z& [7 ]; B<lable>Element Upgrade Amount</lable><br/>
7 G, L- a6 e/ X6 a% B/ O( G<input type='text' name='element_upgrade'/><br/>7 Z+ d4 F( O- q) ~! G7 o
<lable>Pierced Amount</lable><br/>$ g' l0 x3 d2 N# @
<input type='text' name='item_pierce'/><br/>
! Z, K1 j% [6 n<input type='submit'/>+ {0 A3 } _7 E4 M, H' N0 j
</form>";9 [) J+ \* l3 o( p! `1 v
} N3 z d. c0 @7 \0 Y
1 e8 [ I6 n! cfunction PostListener (){# y" ^) F8 q% R/ B9 m
//Add more post variables if needed and add them to initform() function aswell$ r* T& p; m6 U- E2 i
( C4 d: K; i9 O/ Q9 {( r- x
################################
% E& m$ O. _, H, f) \% M0 P##### Connection and Post ######
4 T$ I, }9 Y, K( l: A( S################################
5 Q) \4 p; o9 F- S2 d$name = @$_POST['char'];
3 q" B. h* V4 x' R$ItemName = @$_POST['item_name'];1 J0 e! _/ n% w7 y- p/ ?5 ?. l' ^
$ItemAmount = @$_POST['item_amount'];5 l3 M$ q8 @9 Y8 w, h7 `/ o
$ItemId = @$_POST['item_id'];/ @. ]/ D: s: x9 h/ H1 s8 f
$ItemUpgrade = @$_POST['item_upgrade']; J/ h! h8 ^5 F
$ItemElement = @$_POST['item_element'];
U4 Y1 g+ E7 z& L, ^/ v$ElementUpgrade = @$_POST['element_upgrade'];$ k; A: p2 g7 F5 ^
$ItemPierce = @$_POST['item_pierce'];$ h. Z8 r: M) l1 l% y
################################
( m, s% R M X: o7 ~# O' ~5 g3 d& S: t
//Check both variables for empty value- g0 o0 ^3 I- |2 e' X' Z# Z, q
3 v( v L' U" T# d4 [1 a4 V" r0 v! bif (!empty($_POST['char'])){
* x |6 w5 k% Z7 b) @$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
9 ~8 M! b( P% M5 |4 [+ o
- i1 X+ Q$ R. j: ^7 `& ?3 Bm_szName = '{$name}'");
& g0 b# q6 K3 Z& ` q% m _while ($row = mssql_fetch_object($find)){5 R* Z% k9 C1 F( e1 E, H
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
3 A+ m! j- ~/ y( G/ M$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
( i3 \0 i" Z0 Q$ P" U/ v
0 X4 ^$ h' i4 Z[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], - E3 _; |% l. h8 w, r1 U
$ z3 s2 y G! t( A1 P
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 0 \/ H& k& z. K) `9 K
, K; ^, p. F) }' _
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 7 n+ w) P& `, q( W; `
7 A1 r$ }8 s# p7 e) A! u'{$ElementUpgrade}', '{$ItemPierce}');");+ g' A. t: S; @
}
: ~+ A' I* s/ ?; P
7 m1 K& N/ U+ V! ^}
) ?) O6 T; ?; `/ l
/ c9 P7 u. b* [5 O3 B4 s}
+ H# N6 {8 Y; K; K: _1 j
8 B1 V* t5 P' Q2 x( H" V$ [$InitForm = InitForm();2 M7 o4 T, i$ ^' w& A
$Listener = PostListener();4 S- n, p* r. O: e
% q( H7 D; B3 ^9 w4 l! Z?>
3 F5 U, e O, u: J1 M" \$ t
?: [7 Z' H3 @: {" Q. A
+ Q% ]: r+ O& f& u6 z0 m0 b
5 u' T; i& l1 F0 V2 o( l$ _4 x; j, U
|
|