|
|
<?php
' D, m# Z/ G4 xfunction Connect () {: A7 [" {% t# i1 k! p
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
2 P2 B# D4 u! L
1 i( K' \ g' TFailed.');: q8 c: ]/ E3 Y$ r
}: {5 {! f, z' d! O, N. `7 R) }
Connect();
: i' D( L p8 h. B' E9 ? T8 k1 n+ k, d. K6 k) g/ s% i! j5 F
function InitForm(){- @# ~5 [/ i/ V g+ h! J* a
//layout for the form+ z. H8 V' B/ A/ \& Z
echo "<strong>Send Items.</strong>9 e! r) @ v5 J, I$ o9 H
<form name='select' method='post'>2 n3 J' q; U, r9 r+ Q
<lable>Character Name</lable><br/>
( V/ @6 `' K+ [( H3 H<input type='text' name='char'/><br/>
3 s1 {' A" \/ `& R<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
0 d8 J+ q# U0 X<input type='text' name='item_name'/><br/>
( T4 |2 O- z! d" o5 S<lable>Item Amount</lable><br/>
- Q" C$ [9 Z5 x, r" h' O* _<input type='text' name='item_amount'/><br/>
2 @$ {) u6 V$ O<lable>Item Upgrade Amount</lable><br/>0 j& F0 N3 G2 B% C
<input type='text' name='item_upgrade'/><br/>2 R2 m" {( M, b# c
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
; B6 O# U1 y: f- O( w! f4 Z5 Z( q# ~$ f; f" D/ i* ?7 B7 V* Z
</lable><br/>
, x+ K1 j% {$ S$ Q3 l<input type='text' name='item_element'/><br/>
- H% y' w( w) U E1 N<lable>Element Upgrade Amount</lable><br/>
0 l! o6 f$ ?: V. ~ B! h2 @<input type='text' name='element_upgrade'/><br/># C9 a" n7 O' n6 T8 v/ s2 T/ T" t
<lable>Pierced Amount</lable><br/>
* H" b6 g! J6 ^<input type='text' name='item_pierce'/><br/>1 a0 O0 w' `7 C9 R; q( L$ U
<input type='submit'/>) v( q5 O: H7 C/ [4 F) p6 B: h
</form>";
4 W+ z. l! c% A7 }. i/ O4 B}! @7 f& U( c: k
* B$ T& T/ s4 e7 m; p2 ^
function PostListener (){
& O8 g7 x# }( g! C//Add more post variables if needed and add them to initform() function aswell
0 M: e/ C: Z. f8 Z$ E7 X, C; o4 q& i4 q) b* d
################################5 A' \ V2 b/ {8 f5 B
##### Connection and Post ######, u5 @. ^( }9 N
################################
7 f3 i0 o. M! `7 `9 m$name = @$_POST['char'];) W! v; ]& B) _( R
$ItemName = @$_POST['item_name'];) a" @* D4 _. q0 n& j
$ItemAmount = @$_POST['item_amount'];
1 y( Y9 ?. }8 j r$ z$ItemId = @$_POST['item_id'];
; V4 ^1 }; |0 e( H$ItemUpgrade = @$_POST['item_upgrade'];4 O& G e/ ~4 k/ K
$ItemElement = @$_POST['item_element'];
8 G1 y1 y7 n5 `1 a$ElementUpgrade = @$_POST['element_upgrade'];
2 h6 R% a- c3 e! q$ItemPierce = @$_POST['item_pierce'];: o+ K$ A' d ^5 W' S! b, f
################################- c h5 B6 _/ ]* M+ C. z
. y- L* ~) }# C% t! G& z: i4 z4 Q//Check both variables for empty value+ V8 y& D2 `. V% [$ p- `4 |
; g) e; E* [" o3 Q7 B: m/ q0 c/ n
if (!empty($_POST['char'])){
/ ]: D6 B- N9 c8 q$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
6 E5 S8 k( ~" A5 y/ I4 ]3 M }" R( m4 N# g. S* w1 S F
m_szName = '{$name}'"); l( j: N4 r7 a6 A/ ~: K' e
while ($row = mssql_fetch_object($find)){
3 y8 h6 a( X! [; becho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";; ~3 {2 C' m/ M4 D: a: N, V
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
$ J4 O: B, v2 F- W! w9 m9 m+ d1 y, Y
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
' _5 H7 i% Y7 d* q% F0 j L9 X4 p8 @4 R' f( ^* @
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', + e: e; H3 W* q( P4 @7 R; G A& I9 H, _
' S- }- C: N/ ~6 tN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
' E9 m: k3 O3 ~9 z, q' Y' {4 Z5 @) ~6 v4 ~+ K9 o9 f4 [
'{$ElementUpgrade}', '{$ItemPierce}');");
' t0 V: [4 I3 e/ @7 I. Q( p}: l: t) B/ Z% \! S* }7 o( b
) t3 N" D1 j% U* k3 l4 J; ^
}" c( T+ B; _1 y* V4 c" j2 i9 Y
/ H! E, r* f/ I5 x
}
2 V4 o" ^) E% D: z) o: J9 k& P0 B8 I7 D9 o5 f- ?
$InitForm = InitForm();
3 C! N2 u% V; \$Listener = PostListener();
) N, u0 B6 R, k& N* C& `& T* Y* M# ]6 v" P+ g. ]; T4 b
?>
8 R. r2 G1 D- o: E$ Z
8 \3 M! o; Q( M! G! ~* t- d* h9 o4 n( w( X* k: q7 w' r' ?7 V" M
, p! x$ M2 t; _
7 t: X/ g' d! ^1 @ |
|