|
|
<?php& L" _0 {' h i# X( ^; ^
function Connect () {
# R6 a/ [5 O% \; ~4 e' [& z6 Cmssql_connect('Server','UserName','Password') or die('Error: Connection to DB 8 j, L) R/ r' ?5 X6 z8 s
3 B3 c/ [" A+ {! `) p; iFailed.');
1 Y" ]$ S2 ?) E- ~" O7 l; L}8 ?4 q2 C1 v# H) i. i; w$ H
Connect();% T9 n: M$ i' `( O: ~- j3 L/ g" l4 I
% \$ O( J/ p; i. q
function InitForm(){
' | j! S i# j$ c//layout for the form, Y$ X* m$ g, b! W1 A9 C
echo "<strong>Send Items.</strong>8 V0 v) @3 ?6 d! r% ~4 \
<form name='select' method='post'>
5 ^' h4 l, a' Z' Z: }2 C<lable>Character Name</lable><br/>
+ p. M; M/ p6 y. K2 ^<input type='text' name='char'/><br/>3 P9 h1 \6 B5 E ?/ Y( {3 K
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
7 R4 ~( z' y' o1 }. D" g<input type='text' name='item_name'/><br/>
2 u( a6 D- \5 }9 G- x0 ?# F<lable>Item Amount</lable><br/>8 z8 I* D: D0 E( L; _5 t# n
<input type='text' name='item_amount'/><br/>2 M' a. I ]6 \* q3 C
<lable>Item Upgrade Amount</lable><br/>
/ J* L7 N' H1 [9 x1 n: ?9 \' `<input type='text' name='item_upgrade'/><br/>
# J9 i, T- Y0 j. |<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
9 |" u$ s4 t9 F9 a! z% K4 P- Z6 |' w4 o' A
</lable><br/>
1 d$ N! f6 g$ {/ o<input type='text' name='item_element'/><br/>- v& A: o/ ^0 c7 O* |% P
<lable>Element Upgrade Amount</lable><br/>% v) ?7 s( q- p
<input type='text' name='element_upgrade'/><br/>, S/ c- F0 T& |1 R' f/ U
<lable>Pierced Amount</lable><br/>
# V: ]0 w; R, E( ]: s<input type='text' name='item_pierce'/><br/>/ @6 O! O5 f- g8 T- K8 X3 _
<input type='submit'/>0 U) X( ^# E: p% B6 t7 D' R
</form>";
4 _+ D. O) e% u( L. D1 ]2 ]}
5 j ] \4 A1 M& O. c5 `% l! {3 p* K
function PostListener (){" O' ~! \7 u4 `$ L+ I9 o5 F! O
//Add more post variables if needed and add them to initform() function aswell8 ? W8 z3 o' C8 D
3 ]8 T6 r, B, B9 Q! }0 D################################/ E4 k H s/ o) @/ v4 R+ k
##### Connection and Post ######$ p$ B6 \/ w0 J* f
################################
$ F) y7 d9 n. L3 X; M# B- C: _$name = @$_POST['char'];- X+ p) p* i! N9 D0 S% _1 j
$ItemName = @$_POST['item_name'];
) U7 f: f+ ]" }$ItemAmount = @$_POST['item_amount'];
0 A |4 G7 Y: c# p! f M$ItemId = @$_POST['item_id'];1 W7 W9 ~ v W3 [8 i- v
$ItemUpgrade = @$_POST['item_upgrade'];7 O/ l# p8 i; E9 ]4 D
$ItemElement = @$_POST['item_element'];" P& w$ v2 {% g3 d& [0 s, u
$ElementUpgrade = @$_POST['element_upgrade'];
2 `- n8 T* b" p1 n; i$ItemPierce = @$_POST['item_pierce'];& |- }0 B! ?5 W, E. B. X1 @
################################
3 B+ K4 ?# Z' G! S8 e* t, I/ D
3 |2 M0 i6 p' f) e' G# V//Check both variables for empty value4 d. U) m" g4 W9 n0 t5 e
! @* l3 S( h9 i) E
if (!empty($_POST['char'])){1 L7 ]7 {% ^6 n, I. w# r4 Z
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
7 k$ s: ~+ T$ W1 k+ d2 T e8 y) ^8 H. _1 T1 i
m_szName = '{$name}'");/ t9 @7 ^) k& W$ l; e) y
while ($row = mssql_fetch_object($find)){ j+ h6 @7 W4 F
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";# \" m. e9 i+ K0 @$ G! ^
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 4 X9 f; T% m: X% {+ M& h5 K
/ B+ f8 e3 M5 U# E
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], / }6 z/ b* }7 f' n9 U' U7 h. ?! D
- C# s6 l# A0 s3 r j[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 4 J) r1 F& g- u% ]" B
) w' ~ g4 t9 q) q6 i: m$ B: E
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
$ R6 P t4 l3 n* O; V
7 ]' ?7 e5 i$ p# ]; H, h! x! c. `' b$ m'{$ElementUpgrade}', '{$ItemPierce}');");
2 z) Q) [3 j, z- W. t6 y1 @; p}
# A5 H3 K8 o( y9 m, @1 u9 E# N/ S- F( D( E& e
}
3 u z3 g+ A" E* q; }# C: X5 Q
% L. i0 J7 c; W}. `5 |" m8 S* m( `" i
4 w; L5 {, ?) S, e
$InitForm = InitForm();3 s3 S: l: I) p& h
$Listener = PostListener(); [( G/ ?, J) a4 e
" H8 b9 h7 N* @9 \& @?>5 x; s, _6 O+ {# \
7 k$ U5 r) w; q+ A& O
5 I& y8 u4 F; H/ R- ^2 F d
8 @8 y: M3 y- l; q% J( Q. ~8 v+ X2 u7 b% C) m$ `
|
|