|
|
<?php
! \: T- ^; l6 d; T0 Bfunction Connect () {0 t* k9 d$ D, _
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB 8 |+ b: r& q8 l6 b* o" L! [9 _/ Z" u
5 x/ j; Q$ K5 T& M' BFailed.');* N% N) ? N- |
}
3 Z4 x; {( U6 W" yConnect();
. n6 t5 t# r2 f" u& u
, e, {5 W) @0 g. {2 Hfunction InitForm(){( k# `5 U& ] h8 E8 e/ U0 ~- t
//layout for the form' I, I6 Q, U( _5 m" t; ]
echo "<strong>Send Items.</strong>8 a0 U; j* K% _
<form name='select' method='post'>/ y" z& h% D9 @- \% ~
<lable>Character Name</lable><br/>
& n7 W2 ^$ s% z+ S/ U! G, _; C<input type='text' name='char'/><br/>2 K" Q# ]8 D- `# d7 K3 g
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
: a7 {6 W- Y/ r: [<input type='text' name='item_name'/><br/>
. p9 n6 E8 S: R' I5 m8 _% X<lable>Item Amount</lable><br/>3 B9 R# Q! j% z2 `) T! w
<input type='text' name='item_amount'/><br/>$ p9 r8 g; s, p& p+ n& x) X8 A
<lable>Item Upgrade Amount</lable><br/>
' `8 l. [8 v/ y% _<input type='text' name='item_upgrade'/><br/>6 d. [4 ~' ]# c/ M5 X
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)% B% H" \: ~2 Q2 t) [9 V
+ k. ~+ k/ I+ w8 g</lable><br/>, w* w, d$ O' h. ?
<input type='text' name='item_element'/><br/> f1 V5 p7 A3 n6 d: O1 B1 f
<lable>Element Upgrade Amount</lable><br/>
8 C! j6 r) q* r( S: z<input type='text' name='element_upgrade'/><br/>
, P1 x% r! Q+ }4 i" d+ G<lable>Pierced Amount</lable><br/>: q I1 c* ^" J$ `! L h
<input type='text' name='item_pierce'/><br/>
! W b! `4 H# _" N; u<input type='submit'/>7 P' R8 @9 {0 d. [
</form>";
3 I" ~8 ?$ ]% I) Y0 Z* p}
( c! M2 H# F/ g6 {, G
' Y: `1 s. ?. m* m5 ~" P T6 A* bfunction PostListener (){$ I7 p7 r6 {- n9 m$ u
//Add more post variables if needed and add them to initform() function aswell" c V, E0 O. {* S/ `2 X6 R
a, H' x+ _4 Q$ n6 K, x& v) c################################
& r$ j, k3 l, W% Y+ k. b9 @ _##### Connection and Post ######1 n3 H$ J u8 _0 d) Q) v9 l/ m2 U5 K
################################& r: y+ q$ ~ R$ T0 N) o5 ?
$name = @$_POST['char'];, T: ~0 \1 i0 V" E7 N
$ItemName = @$_POST['item_name'];3 A; O% z8 B; a3 q) y: e' X t
$ItemAmount = @$_POST['item_amount'];
; ?( K" n/ G$ {2 b$ItemId = @$_POST['item_id'];5 d: \' P, }0 m* i( ^
$ItemUpgrade = @$_POST['item_upgrade'];
, k) e) n9 i9 j; b4 S$ItemElement = @$_POST['item_element'];; R2 e) q& U5 B4 L: c
$ElementUpgrade = @$_POST['element_upgrade'];
5 F y7 Q+ f, i% k* s+ b, ]$ItemPierce = @$_POST['item_pierce'];
1 y4 S. z6 M7 ~& x) s################################
2 ^) Q! S; p9 l" [2 Y; @/ y2 ~ x p9 u9 P/ i$ @
//Check both variables for empty value
/ L# O% r3 {; |4 C7 w+ F" `( v h- n* A: x( q. D
if (!empty($_POST['char'])){
- y! z! f* D# j) d+ t0 n$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where 2 i6 j _3 {9 e" {" n
/ h. a) E6 F& Q! R. K$ h# r
m_szName = '{$name}'");( U% o: s% n6 K
while ($row = mssql_fetch_object($find)){- M0 ]# O% K( S' t
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
8 a" e9 w$ ^9 O$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 8 `: k+ [' m0 ^) h; @, V1 w9 x
: w$ G6 @ Q% q' |
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], + Q) T- H# N- Q8 H; \# ]9 w! ]
) R# _' b8 \. ~( g# T, |& a[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
8 p5 J: g$ g6 I" A% C+ m$ ?, B6 f6 \4 p! d) B4 w/ I3 Z
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
$ H6 u* H8 s8 y: u' S5 V) F
1 z4 a+ `, M7 @% ?'{$ElementUpgrade}', '{$ItemPierce}');");
6 o% p, T0 p, [8 ^' m# M9 N+ o}) ?5 Q" g( w8 O/ q' t0 ^1 J
9 _' [. M6 Q$ |1 [) N- [
}
5 O* o/ k2 L, {% Y1 w4 X- Z* e, v" E! a, d1 ~7 f
}4 e9 K$ _& x5 q1 n2 C
" A# m# C; Z6 ^2 B$InitForm = InitForm();
* ]$ |! }2 O- k( v. ]$Listener = PostListener();2 z/ [% a, Y' _+ u( U# [, z
8 T9 M; r$ Q# N- L X2 i
?> a% h/ e1 |6 B# h8 }9 y: A; h
0 z6 I1 e3 R; l. e3 Z$ F5 A0 ^
# f9 V+ \, A6 Z8 b2 ^5 [) ~! g
9 X" R# N# `* p+ b0 E1 Z
- _: n! g4 Q C0 X: q4 S: j
|
|