|
|
<?php4 b6 s6 s# q) x
function Connect () {/ d- [' U7 R. g9 M
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB 8 f; f% a6 r( g+ D6 x. f2 V0 S0 ^
) u% D9 ~* [% a C: b
Failed.');
+ I! ^3 J. r. p' o4 @) X7 Z}1 Q% T: t9 Z9 l3 J; b- W7 ^7 C
Connect();
3 [+ O* w+ P$ v& L& y) ]5 } N$ R( y5 I1 B# q1 r0 Q' A
function InitForm(){6 L/ Y; X; P+ p, r& ^; \7 k# Q
//layout for the form. c; L' m) j6 j) J) {
echo "<strong>Send Items.</strong>8 E7 {8 {0 D+ R+ c3 p1 P9 J/ Y
<form name='select' method='post'>, d8 ?6 C9 a2 N" ?9 M2 {3 J
<lable>Character Name</lable><br/>
9 E6 l( y4 Q! t+ J0 C$ f0 ~9 k8 L<input type='text' name='char'/><br/>
! t1 R6 G8 J; |; Q0 T" X- g# w" V/ W/ c8 H<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
: v/ d0 l( [2 `<input type='text' name='item_name'/><br/># _# v1 c! t2 u* e, ]/ ?
<lable>Item Amount</lable><br/>: z/ L6 z! N5 o- O0 _
<input type='text' name='item_amount'/><br/>7 ~: F8 f* r. N3 j
<lable>Item Upgrade Amount</lable><br/>" U2 S) o9 S. E: k5 r/ {
<input type='text' name='item_upgrade'/><br/>5 x, s! \3 w( V4 [& M7 L
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)5 Q: f' I2 U" m7 i- a3 X
6 X6 B q( {: o9 U b</lable><br/>4 Y& E! Z9 p- A" c S
<input type='text' name='item_element'/><br/>" y; U7 [/ s: n3 [
<lable>Element Upgrade Amount</lable><br/>
. F( }: I# I9 B6 v# R8 M2 D; J, |9 b<input type='text' name='element_upgrade'/><br/>
- n6 N6 i% S* [- X4 y$ Z/ k' U<lable>Pierced Amount</lable><br/>
Y4 |- s* k; U<input type='text' name='item_pierce'/><br/>
! {% l" {% _' H( l<input type='submit'/>+ n4 X% B; Y y% l" R- u2 V9 u2 j8 ~
</form>";
7 m( ^, k5 s$ v1 o9 @+ i}6 I. A9 g4 V, d: b; K
, c9 g; m+ w5 Kfunction PostListener (){
4 w9 L# G, {$ K3 d0 `& R6 s t//Add more post variables if needed and add them to initform() function aswell
6 @4 r5 w" C$ V5 i0 J% o, U: {4 H. }+ R3 {1 Q( D
################################9 _. V f$ }& F6 K
##### Connection and Post ######; G7 {' M7 Z* O5 t; F6 n9 Z9 Q% c8 O
################################3 Z. I/ U. ]7 M
$name = @$_POST['char'];5 V' a7 B- N0 U' G$ s+ E2 \2 V, a
$ItemName = @$_POST['item_name'];
# j h8 n# n& h" e- S$ItemAmount = @$_POST['item_amount'];0 y+ n: x$ e! G
$ItemId = @$_POST['item_id'];
5 j: c ]+ I: m' S' T' K; N! B( Z$ItemUpgrade = @$_POST['item_upgrade'];& [) V" u" J v; L: m1 g& E6 @! Y- q
$ItemElement = @$_POST['item_element'];) e4 N. Y5 }0 u \' i7 E3 d6 X$ {
$ElementUpgrade = @$_POST['element_upgrade'];& b; o7 C0 i; c: s- U; `- C
$ItemPierce = @$_POST['item_pierce'];" U* Z F( f$ ]3 [$ l4 p1 r3 I6 u
################################
% d7 R3 f/ z1 ~' B6 R4 D0 e" F! h* Y
//Check both variables for empty value
5 {/ p ?3 w3 D
$ \; ~8 @1 e2 r- |" U2 W: X3 d% eif (!empty($_POST['char'])){
9 W+ T' ?- n% {. }8 P1 M) M4 d& b8 e$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where 9 B W6 b/ b1 e$ ~' l
8 Z0 m+ f7 r- n& A. S: T. Sm_szName = '{$name}'");/ n; `( Y8 ]- C J$ i" {
while ($row = mssql_fetch_object($find)){. Z5 z! ]2 D4 _* c% D s# ]
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";2 k" a' f4 D [# @5 G1 ]
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 5 \/ V6 @& ~+ W. \" i/ g7 O
/ @' S0 @% `8 R& _2 w8 k) U4 g% i
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
+ O% Y! [" ^& X+ v# E) h- f, K* n
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
* [( T/ N0 E) s- e# t% I# u; k2 g2 U* n
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 1 v4 q6 O$ T5 c& J
5 K2 N A- U7 o& A'{$ElementUpgrade}', '{$ItemPierce}');");
& g1 D5 }" `- J" V$ V( D}, q; R9 T7 Y; h# L
* e9 U, ~5 P- i* i}
( e+ `4 L1 g3 ~( t6 H
' [$ M! q& J5 d}! ~$ w4 y) _: j. M# i+ e4 u
! ]4 P8 |, Y5 p! p8 w/ A2 c" V
$InitForm = InitForm();
" H" O0 ^* w R8 s+ E! ~" i$Listener = PostListener();
! h5 u1 d. M# H& T$ T! d8 i% W& q1 c9 _% A. E' C1 Q8 L
?>
+ x! b! w/ P* d U0 X+ B
/ P) n7 z0 n; v4 s" M9 W& p6 V5 J& Q' k$ ~
, ^: f, p! ]% G2 c
# W: H$ C0 S* x( C$ @ |
|