|
|
<?php
, r. z5 v }8 A: _: w wfunction Connect () {7 s* d* V+ }# o4 V( \. S Q3 g
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
% ~* O- h4 n5 E2 z, A
) J; E8 u2 [* ?2 E1 c3 m- cFailed.');
* ]* M- w! a f/ g( l; x" m7 O9 ^}& s" m6 S; L, Y( Q- [6 H+ {( F9 ` d
Connect();- a/ G& d/ n) U# B# W, |
5 m$ }8 N. x: d& c' l' U4 W+ o
function InitForm(){
1 t0 u- g2 X& F4 U//layout for the form
& h- a5 q) p1 w3 ^& w$ eecho "<strong>Send Items.</strong>
8 d, e r, G& b- J+ z, h4 R3 u<form name='select' method='post'>
4 y" p' w5 F2 ^, p, |5 |<lable>Character Name</lable><br/>
" P+ D0 u) C# U6 I$ \* i! W<input type='text' name='char'/><br/>
4 ]( J3 Y/ W/ p<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>" K/ G: E: [! I7 @; h
<input type='text' name='item_name'/><br/> q. `3 s2 r. X7 ]' P6 j# R6 `$ C
<lable>Item Amount</lable><br/>! y/ k! f3 _% f
<input type='text' name='item_amount'/><br/>6 D8 s& y: @" }
<lable>Item Upgrade Amount</lable><br/>
$ Y( @: f ~, I<input type='text' name='item_upgrade'/><br/>; R5 D) f0 m' o+ u
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
' R/ d! g! Y5 K3 U. D( Y
) f8 h6 l6 X; _3 d) I) Z2 {' Y</lable><br/>
0 J* f2 y2 j4 J$ D, C% c( P& @<input type='text' name='item_element'/><br/>
% p2 R! a& G9 n* O' {% \* t' q( {9 |<lable>Element Upgrade Amount</lable><br/>
, V3 z: [ M* n5 W' W1 C<input type='text' name='element_upgrade'/><br/>) s g8 h- i& E! H/ ]
<lable>Pierced Amount</lable><br/>
8 {1 U6 [$ M( J" y$ }<input type='text' name='item_pierce'/><br/>: S8 @; v6 l0 P+ Z( I1 D
<input type='submit'/>
1 R2 ]) a* F# z/ z</form>";7 J' j( ]$ X% i, s8 X7 U
}
8 {2 B$ K" G0 M' m9 g' K" E3 U1 n1 O# F* o3 d& c0 Z" F$ |( C: k2 l
function PostListener (){
6 M' a. h* i1 M% `2 a8 T' ^5 F//Add more post variables if needed and add them to initform() function aswell+ G; A$ u3 l+ `- F
1 m& _: v' V, m- @6 j
################################+ `& r4 C1 A. i, r! l# h( B
##### Connection and Post ######
- A, B% O( b* x; v5 e2 t& O################################
" P3 y$ [, `2 |( w# ^" q/ g$name = @$_POST['char'];* ?! @1 M! u7 `2 B; |) Z2 B
$ItemName = @$_POST['item_name'];" b& R% c# C# H* `6 `5 h
$ItemAmount = @$_POST['item_amount'];
9 h! R7 y/ A$ s: G, E$ItemId = @$_POST['item_id'];1 B3 N% d! [* D) g
$ItemUpgrade = @$_POST['item_upgrade'];
: |5 g m2 y- V; H) u( t$ R% G5 `$ItemElement = @$_POST['item_element'];
/ k! b" c0 f* Q& q, L( N$ElementUpgrade = @$_POST['element_upgrade'];
* k9 i3 \3 K. `$ItemPierce = @$_POST['item_pierce'];- G/ A( {( Q w: G! W
################################8 D4 _8 Q1 `4 c( a, ^ l' P; ~& T
. l, Z2 Z2 y g7 f i* |//Check both variables for empty value6 M8 {- _1 K. O: q d4 @9 @: k
5 o- r- g+ B2 y8 ]: Pif (!empty($_POST['char'])){# e1 @9 B" F$ @+ m2 k) J
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
) s# y$ ^( e1 t4 k) K' p# o+ t/ k, _& d9 \
m_szName = '{$name}'");7 s9 w8 A$ q# t% {! X4 ]
while ($row = mssql_fetch_object($find)){
/ C( @# `( u* A+ h& ^2 V5 xecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";5 j# V/ W. W6 r W0 `- W% x
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 7 [' u* }8 H1 T
- |+ x2 ^9 s( F7 M4 G7 [* w
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], . }7 v5 t" I; |+ a; e
% L1 i8 ]; x. X! d1 p3 g. i; r+ f[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 3 d }5 U( V; c& e4 f' z) N7 T
7 t7 z, \+ M) X+ C6 e
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', # V. m- T* m1 y: r. u. |
) o) i2 Y' f" U0 ~5 J'{$ElementUpgrade}', '{$ItemPierce}');");
7 T, J: r: L8 I1 {8 Q}, U0 o# b' n% O1 i3 r% \
; O1 e5 g' e3 Z+ {
}
/ {" @$ b }& d& R+ E& A$ P$ U
$ b+ k) F% B4 }" k; o( I}
# \& X4 s( h0 ^! W& E$ g. F1 @
b- E! z& y6 M; ]; j% J. o4 X$InitForm = InitForm();
$ k- L* M( n' S$ \+ [& f$Listener = PostListener();
}& w/ S( @3 A) T$ c6 n: s
, @$ s" W6 ?- \8 X1 J9 p5 c?>) b% l! c0 n l' G7 t. E
% S1 _8 M0 D+ [& _3 ^7 z8 i8 Y% W1 Z- z. B
n1 w1 l( f, l5 ?7 r2 u" \* N# U* `
! A/ i" {( L5 r, }& d |
|