|
|
<?php& [9 y5 L3 s) l$ [' j
function Connect () {' `- M$ l2 K3 B7 }2 k9 M
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB 8 N, c( I& [# F( K7 M/ G! o
0 w' }' u8 ?6 m% G
Failed.');
5 W; \9 w: L8 d; q7 ^ h H}( I. D' L: _+ s( V7 H, }4 o7 k: V
Connect();+ j! B0 h8 h: S
* f) v/ c7 F. ]7 ?7 _% j
function InitForm(){, ~: [# v6 ^- l" R- }3 K
//layout for the form( }$ ]6 N! Y' g" H$ ^
echo "<strong>Send Items.</strong>8 k: v- p8 f% M7 m% L, _
<form name='select' method='post'>
( L) x2 c0 ^! ^, { W<lable>Character Name</lable><br/>: S4 d0 i; Z# _
<input type='text' name='char'/><br/>
' d* I! N2 p: }5 B5 v<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>$ Y9 K+ H. ?9 E* [
<input type='text' name='item_name'/><br/>4 v: t! I+ Y# z; ~+ P( [
<lable>Item Amount</lable><br/>
, N8 h4 I1 J) s1 ^6 H3 V Z# H: p<input type='text' name='item_amount'/><br/>& d/ u0 L( N% G
<lable>Item Upgrade Amount</lable><br/>
6 E! c5 W7 n$ G* }) ^) f" g<input type='text' name='item_upgrade'/><br/>
3 F3 g0 J7 E. i% U<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)+ ^( d- P6 G n0 F8 b. C) b, n
2 C2 X5 z( m, G) S5 k/ O4 U8 j</lable><br/>4 k/ A5 B" _8 f8 \+ X- Q. }. R
<input type='text' name='item_element'/><br/>
1 \5 c, m1 l5 r- b, Q( [<lable>Element Upgrade Amount</lable><br/>
: R* S# q' o& v<input type='text' name='element_upgrade'/><br/>
# w- K9 a/ m( m+ L<lable>Pierced Amount</lable><br/>
7 x4 u. I r. H8 v7 X$ |<input type='text' name='item_pierce'/><br/>( a9 v+ M* P" z! X
<input type='submit'/>5 ]" X% X4 ?, q, t
</form>";' R& t- X9 s+ z4 E
}5 y9 E7 s5 _: j, a- s& i
+ S4 E M Z% [1 F/ dfunction PostListener (){
R" F" y, u- B! E. \5 F h//Add more post variables if needed and add them to initform() function aswell6 Z6 l* v6 T1 k. P
3 B3 u+ C% `, F8 \3 p7 ]2 Y################################, _6 r W( F4 @% w3 O6 n
##### Connection and Post ####### N. x: I3 @) S
################################3 f+ h2 D$ W1 d9 D/ F
$name = @$_POST['char'];9 U# ]- M# |( t( R! z2 P
$ItemName = @$_POST['item_name'];
8 V R' z9 u7 `4 S8 V! F$ItemAmount = @$_POST['item_amount'];
6 @9 m3 V: `9 ]+ o3 s$ItemId = @$_POST['item_id'];
& B' w! F* Y2 ?" _$ c% ?) E; I$ItemUpgrade = @$_POST['item_upgrade'];
. B% M" ^! L$ N$ItemElement = @$_POST['item_element'];
' G& s8 n$ J; H$ R6 l, w0 L. t K$ElementUpgrade = @$_POST['element_upgrade'];, H8 I* ?$ Y/ E/ g) x$ L
$ItemPierce = @$_POST['item_pierce'];3 `; b4 ^$ C% o0 ]
################################! [( {6 r1 |+ d- J1 f+ T
. g# @. F: J% z; D) g, ?8 R0 k
//Check both variables for empty value2 ~4 [* U& \5 o, ~) B
8 J9 ]3 C3 h: }7 ?. `' h
if (!empty($_POST['char'])){
# {1 b7 i5 I; t5 P3 \* m/ I$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where . e# }. B! Z: F% v2 f% j% r
# R, Z( z( X: i. {/ dm_szName = '{$name}'");: ~4 a0 r, K! m0 S
while ($row = mssql_fetch_object($find)){
; |% n, s: ^( I0 r8 x( b" u3 techo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
1 \* v! m9 k E1 V% n2 x2 o/ u$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
) R' ^: X: [# i% R4 \5 Y) A# c) H
1 B2 z2 k9 _* t* d[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], $ e3 \6 @2 @6 V1 x; M3 [- G
- {: \: Z1 `8 j+ j
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', / ]( c* {# }- ?/ i6 L2 O
. B6 O- H6 X' U v+ P# H5 `
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
3 _; o" z" l* E
5 A& a; C+ E$ q$ w* W% z; |' {'{$ElementUpgrade}', '{$ItemPierce}');");# ~ U) |3 L) c' o$ ?. ~0 N; r0 b( e
}
9 H: _! k& v0 C# P) d* L R- t/ r% C8 G$ v. Z, Y$ D7 c- C) c: s
}" {0 ^( r( E; y# F T& f6 l) i
: C; a* p& Z* A
}9 R* q/ e0 n% C' v/ t
& b8 Z2 G+ ]$ j. c
$InitForm = InitForm();. ?) v5 m( [4 N
$Listener = PostListener();
3 a* |7 x7 g5 T j7 W2 ?0 e8 i: f' k. l, u; y! Z2 R! t$ h& u+ C
?>
, L* X* {5 E# [- e8 t2 j0 J9 M
& H, |+ ]; d4 \% O- V- F S( h( z, n) `! g( Y9 y
; o$ J2 g/ A1 Q: f+ {5 q3 m4 z" M1 T" w9 C; c
|
|