|
|
<?php4 W& `- ?# ~9 V S% Q/ \3 z
function Connect () {
* t! k6 L/ R, `. O2 n* k! bmssql_connect('Server','UserName','Password') or die('Error: Connection to DB # I" V0 U- F3 s5 W4 s: ^
& n8 `! i: J7 cFailed.');+ }* t! I" l2 c2 `8 s
}! K! B6 v& T K8 m2 g# p) P( |
Connect();
; X$ k" ?4 x) g; C
# X0 G( z. @8 g1 Y5 K# {; Gfunction InitForm(){# ^2 R9 H! U# \7 T2 v# f
//layout for the form8 f& w1 x |6 G; Z# o
echo "<strong>Send Items.</strong>8 C) M, d+ t% U9 \% k# ~% _
<form name='select' method='post'>4 \. z& f8 e. b j+ a& B$ l% ?! v
<lable>Character Name</lable><br/>8 F# u1 J* b, o) C2 R& w
<input type='text' name='char'/><br/>) n2 G9 |; O1 ^
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
- K2 g& D. v o4 H<input type='text' name='item_name'/><br/>' x, l0 ~ m1 I) y
<lable>Item Amount</lable><br/>8 S! x; Y/ S7 f) p4 A9 M7 r( a
<input type='text' name='item_amount'/><br/>
$ u9 ?, C( h: L3 v# T' K- s: J<lable>Item Upgrade Amount</lable><br/>6 v( x0 H9 F4 I9 d
<input type='text' name='item_upgrade'/><br/>5 P2 E/ b8 Y. [) U7 M8 M
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.). }/ ]: I0 d' C6 p, V
) E2 R5 S: }, z- k, U</lable><br/>" E. I3 ]/ [$ p0 G
<input type='text' name='item_element'/><br/>6 T E" I( ?2 _# A1 `9 B
<lable>Element Upgrade Amount</lable><br/>0 U" z5 F, |7 I6 S }$ M+ i
<input type='text' name='element_upgrade'/><br/>
% }2 z. J3 a9 Q3 a4 V0 t! H+ O<lable>Pierced Amount</lable><br/>- @; o) `* j2 ]8 r$ W
<input type='text' name='item_pierce'/><br/>5 z. q- |) ~9 I" c5 l
<input type='submit'/>
& j% c$ a2 Q0 s. N3 q. z</form>";/ N6 B& ~% `" D) Y: F# y( }1 O
}
- Z$ F8 ?9 I M! v. b; l, v C. J
function PostListener (){
# c4 a- ?" H4 P$ f, I6 ]; k) Q+ v. h//Add more post variables if needed and add them to initform() function aswell
D" k0 i, O/ ~' J' I' \
4 V+ ]0 w1 F# w, L- [################################
2 ^, O! r2 ?3 a##### Connection and Post ######
/ E( P( q' a! o0 K* c" R################################
- C& ?+ S! d% ]% }) M" |$name = @$_POST['char'];$ }" c0 s( i2 Z0 v9 g
$ItemName = @$_POST['item_name'];
; J( A6 Z+ f1 M) J2 V: v8 N$ItemAmount = @$_POST['item_amount'];
1 q% M: K3 y: f b$ItemId = @$_POST['item_id'];4 W: |7 Q4 c# l3 Z& I9 Z
$ItemUpgrade = @$_POST['item_upgrade'];
! N" X+ A, `. _. u* }$ItemElement = @$_POST['item_element'];& S; U2 ]6 u/ o3 m
$ElementUpgrade = @$_POST['element_upgrade'];
$ i' I1 \/ I3 \7 u$ItemPierce = @$_POST['item_pierce'];
* ^5 V& D) s7 n; w/ ]################################
% k) g: @9 I% g1 h; N, r: B# _. {9 ~9 W/ o5 Z
//Check both variables for empty value
% ?5 }6 ]4 g* O, a' \( h1 A2 c# t
if (!empty($_POST['char'])){
0 V( B2 H2 a% g. P$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
# m8 |- G* H( v* U6 k5 A
( R3 Q2 x W" e$ am_szName = '{$name}'");
, Z! t; k o, ?# X b# gwhile ($row = mssql_fetch_object($find)){
4 t% c9 ]) r5 }! j& F: `; e3 xecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";: t, ^! ]/ U8 a& w
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 4 r+ y/ [, V6 O. z
0 o$ q2 @$ s3 Q$ ]
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
8 _( C% f$ i- y% r
: U0 B' q+ U: g$ h[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 8 ]% Y, Y& {! }% V! c. D0 C* E
6 u* a9 `7 @- P
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
" F: N. C& q9 V- \# M
% v' L8 l/ B$ T( v% R: B4 ], N'{$ElementUpgrade}', '{$ItemPierce}');");0 n3 N- A9 M1 {" h) i4 Y8 i- V
}
! S* |% L$ w6 W% v+ a0 S9 o+ F
, U, P. f6 W# M}9 p" i! D0 S9 z" E/ z) |3 P
6 W' k7 g% f8 T. Z) a& Z$ I5 q}3 k1 F' ~1 x7 B* J
2 X' W% f, K2 ?$InitForm = InitForm();( _) T( j8 ?5 h( w+ _1 p4 q
$Listener = PostListener();: |, z7 {2 S# a& Z& j2 D# I
% O& U# {' u' ~
?>
4 x \& z6 x6 Y' U- U$ Z2 [9 F
* Q& u+ L! R) K' t
. a0 y% O' A, K2 W
+ N' W6 \7 @) h; B
- z+ C1 s; z0 M |
|