|
|
<?php
# N* P; A7 N. m: {4 N' _) Z( {4 z, Nfunction Connect () {
3 \9 J O: t- L, R3 l Zmssql_connect('Server','UserName','Password') or die('Error: Connection to DB ; V' k; e( E- z, B+ `% A; K- Y
- I1 a+ r6 [( h: C% p: q) h& |( JFailed.');# G5 K x+ [/ J+ S9 } ^/ q
}4 a7 u1 m$ p2 @# r; Z1 g% f! N
Connect();
I) h; y2 r* }7 }3 n$ N* J4 I6 `3 [8 G
function InitForm(){7 j) S. m6 f' b( c
//layout for the form3 k3 k3 O1 F7 O8 `7 v4 x/ n X
echo "<strong>Send Items.</strong># v4 C, ^- A* s9 h; X' T
<form name='select' method='post'>* D5 W+ H# h4 C# I) W% L2 [
<lable>Character Name</lable><br/>% S! ^* t& E# \/ `/ T$ u0 N
<input type='text' name='char'/><br/>
. J9 U) |' E8 s7 P7 u& U<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
& [: T7 Y: \; o! P<input type='text' name='item_name'/><br/> w$ `/ o! I7 M) f/ ?& ~3 }& H
<lable>Item Amount</lable><br/>9 N9 [3 f w4 q1 I& s
<input type='text' name='item_amount'/><br/>( P& t% N! b- ~& \7 {
<lable>Item Upgrade Amount</lable><br/>
/ R5 a, Y* `1 X7 T' Z<input type='text' name='item_upgrade'/><br/>4 L d; z3 h5 E* R4 Z
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)* E+ P! w2 w6 a2 R! w; M
9 h8 A3 u! z0 D1 E! P: ~& o: E& S</lable><br/>8 G! R% J: ]! b
<input type='text' name='item_element'/><br/>' a4 v) p1 J( @6 m: N
<lable>Element Upgrade Amount</lable><br/>: r t8 e3 W; l& ^% O/ {2 A
<input type='text' name='element_upgrade'/><br/>
# {8 C- @! j( s<lable>Pierced Amount</lable><br/>
) d3 h! j+ S! T, N<input type='text' name='item_pierce'/><br/>
+ ~8 ~2 k9 J# `7 @) F<input type='submit'/>
6 X; |5 B6 f/ ^5 G V8 c3 s</form>";
5 I. m: w, x. o5 r; ~* b+ F}
2 }& T, g* c; p3 e! ]6 E" F9 W
4 {9 j d- S E* `+ }2 ?9 Efunction PostListener (){* g* ~4 z/ O: D, X$ R* }) j0 d
//Add more post variables if needed and add them to initform() function aswell" B- ], q- b" m+ c4 [1 u7 @# k
4 d5 V0 t9 S; Y& X! S* E. W: f) s################################. {- F/ R* ~# Y4 l0 E
##### Connection and Post ######, `# v, v8 q/ [
################################
6 ^* i: |5 s6 ?2 o: v$name = @$_POST['char'];& ] Z k1 p* r* [ O }% m
$ItemName = @$_POST['item_name'];- F6 ]4 N7 l5 s) w& g
$ItemAmount = @$_POST['item_amount'];
* d* w7 Y! f( F$ k9 k$ItemId = @$_POST['item_id'];
$ N$ s! {3 ~$ Y4 G) R$ItemUpgrade = @$_POST['item_upgrade'];
! k( H# i1 H0 B$ItemElement = @$_POST['item_element'];
* R2 X8 L+ f$ M, l' P5 ?% A$ElementUpgrade = @$_POST['element_upgrade'];6 E# u \6 G! j3 N/ [* N K, s
$ItemPierce = @$_POST['item_pierce'];
" |1 O( }6 ]1 [0 M \################################
) r+ B0 O- V; f# A: V" |; {5 q% a
5 u, \$ M" ?, A//Check both variables for empty value5 @7 E; N3 s; o5 m' {9 w8 P
; B# |/ ]; \! b: n% _! ~0 g
if (!empty($_POST['char'])){! R9 A6 T, J P/ v/ i) h% c
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where ' v7 I! f+ f B( i7 L/ V; r
3 X0 e; e6 v: p# a1 C8 g1 P- w
m_szName = '{$name}'");. @& j2 R6 v6 \0 q- n. r
while ($row = mssql_fetch_object($find)){! e9 a% E0 i/ r
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
! H1 Z; C( @( D0 i' y$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 7 L$ k% t$ h* y/ \2 \, h
; J+ ]. \) G' n o8 L5 u( E- `[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
% L: j/ w" g. b" t% G6 D6 w0 v! N- }8 j. }* ~! W& S
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 4 S3 K3 R, D% E1 v
! q o2 h" y' d5 x) B3 k. q/ E/ ^N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
. F' s3 D1 n- k9 z# U8 G" r3 J, e6 F; Z
'{$ElementUpgrade}', '{$ItemPierce}');");5 r5 o& i# W# o; e& b" L" \
}
5 ^; v9 [# K' l" f# j8 `5 @' k1 @3 |. }$ n/ U( s3 d
}4 w* v2 ^% h4 t% `0 h5 K6 t( v
- m( ]8 }& |! a! {1 r" H. ^8 l}9 g* d+ t0 ^! H" I c. ^$ e$ w
# F) S1 k% ?( F6 U& ~, r
$InitForm = InitForm();
7 _5 N" m. C+ Q8 n+ B( v% }% t$Listener = PostListener();4 Q+ p7 q8 f6 k2 f+ ~# m+ K
4 J8 E% I, p! ~$ ` }9 p$ `?>
; F& ]0 D9 s4 c" J% k' _; ~9 k: e$ u+ P9 b
; @( d$ e: ]9 F! D+ b, Q* J/ k
* \- v3 u g4 C' R; {9 o: ?( i5 _3 z
0 M" g+ ?+ W; {7 C i3 G+ h2 l |
|