|
|
<?php
- l2 ~( o4 G7 a# h8 U5 s0 Yfunction Connect () {
+ J" i# Z" z. |mssql_connect('Server','UserName','Password') or die('Error: Connection to DB 4 _! T: v& Y5 o/ d2 O
& g4 B- \7 z r4 l
Failed.');
0 R5 ~" S! h; E# ~+ w9 m}
( A7 X! K f- q' nConnect();
0 q! `. ^- p7 y1 {$ W' Y5 @6 e: z8 o8 }5 y6 R9 e
function InitForm(){
" B# H% f7 n5 L/ |) W8 X//layout for the form
5 g9 d& R; K# c0 w, I9 _: y1 Pecho "<strong>Send Items.</strong> ]) W' H5 c/ r3 v h: a* C4 ~
<form name='select' method='post'>4 s% M Y) k% ?. h
<lable>Character Name</lable><br/>4 Y R$ k6 E' `+ ]) C, ?
<input type='text' name='char'/><br/>
% k8 V5 C! g, o5 l' k5 k& i<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
# T- `5 q; c% w" s$ e$ l5 G3 {<input type='text' name='item_name'/><br/>
7 W0 M( T& E7 m( h4 b7 B<lable>Item Amount</lable><br/>) F, b% D/ a4 p7 G4 S, @
<input type='text' name='item_amount'/><br/>$ z- d1 [$ D: k8 A6 F
<lable>Item Upgrade Amount</lable><br/>' ?' L, G# ]1 C
<input type='text' name='item_upgrade'/><br/>% I. m! O' c* |5 t
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
; m' S+ q5 f B; N, P0 s3 ]% y- z8 q9 w( g$ i6 D9 K
</lable><br/>
# S0 u8 Q( n; b. g! ^) q<input type='text' name='item_element'/><br/>" L9 ?/ Y( R* g5 E* g, z
<lable>Element Upgrade Amount</lable><br/>. R! Q4 `, K8 u' u% M
<input type='text' name='element_upgrade'/><br/>
/ T) A: d8 n! n0 X$ |5 k1 {<lable>Pierced Amount</lable><br/>; {' F/ A+ L3 |3 d/ N0 H- v
<input type='text' name='item_pierce'/><br/>
# h! r6 Z/ g6 U! X<input type='submit'/>
8 K1 r9 I5 y3 T$ Y</form>";( `, l. [8 o! Q8 I6 b
}) H# o* F( S& _. ]
( n% n; M) ~& }& ofunction PostListener (){
0 o- L1 E' c1 T0 h" U//Add more post variables if needed and add them to initform() function aswell# ~6 b' R2 b: @" P5 x4 U# `' t
; N! L! o0 m0 O/ |" Y5 ]################################
9 x/ t1 W5 b+ S% v* ?##### Connection and Post ######
# L2 r/ R9 j. c' U* h2 a################################4 o. o+ J; R6 n( H0 H( U1 U
$name = @$_POST['char'];
( f8 r+ Y$ B0 b( d$ItemName = @$_POST['item_name'];/ @4 i* e- a+ ?/ G7 {# b- v
$ItemAmount = @$_POST['item_amount'];- Y+ ~3 t [; n+ d, V
$ItemId = @$_POST['item_id']; r- E+ [/ m" M6 ?8 P/ \
$ItemUpgrade = @$_POST['item_upgrade'];
4 g: q9 P1 t+ s$ItemElement = @$_POST['item_element'];
$ k2 { U) {# P1 h$ElementUpgrade = @$_POST['element_upgrade'];: Q. O5 f: C! D7 c( T
$ItemPierce = @$_POST['item_pierce'];
/ L/ y9 E! _! t* H/ V( }* ~7 N6 x################################
: C9 ?# [! t7 f! }+ k7 o' v* ?8 y7 l; W/ `2 N, s+ [# h
//Check both variables for empty value3 J4 k# a" ^5 @& Q& d3 R
. F6 @& u: S- v1 k3 H
if (!empty($_POST['char'])){9 I& Q- A& V' X
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
5 V7 r: r" r( u9 i# p' C' V' L1 Q8 I4 b+ o6 V
m_szName = '{$name}'");) t9 _0 l' [+ K7 R; Z* Z2 @
while ($row = mssql_fetch_object($find)){- |' D& B% |% c$ v
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
3 A; k( l7 y3 X- c- U7 X5 o$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], ! W& u( N. ~5 F0 h! u0 e& H
2 p& y( z- D* p7 T5 C- p
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
* z# ~; z, \5 u- J4 R1 Y" Y
/ |; }; y0 ?7 @+ h4 s[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', & W( b% z( Q8 G7 i) L
S, n) r7 l2 H# a0 a% k
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
, ?% Y' L+ ?8 x1 P/ ?" \4 ^1 j3 y. n; J5 p
'{$ElementUpgrade}', '{$ItemPierce}');");2 T/ ^5 m) V$ ^2 w2 K0 t
}( q7 a0 q$ C+ K' h3 J/ q+ Q
6 r" t6 ^: K* r% V( L5 I# }
}0 x2 c: J8 b1 o
, E' x4 e% `8 s( Y* ]+ h1 I* }
}6 B8 A# w/ l; F4 r) Q
" s2 K$ [# a* b& ?
$InitForm = InitForm();7 e8 ]+ X9 W2 T6 I- p6 n& j
$Listener = PostListener();& f. i' e2 K/ z: G+ G
' t' {/ v/ h# E# b0 L- F5 G
?>: E! l0 I$ m; e, Y6 S
! `8 O! E0 K: h- b! L" W7 P/ Q# G) J& b) M3 \/ M6 D" \+ k' _
/ B3 E* d$ i% a/ o* \" j- v0 L5 p& S, E3 t/ [4 L% r
|
|