|
|
<?php9 \4 H- L, H+ G0 `) L
function Connect () {
4 r' }& V4 ^7 ^ |+ j2 Jmssql_connect('Server','UserName','Password') or die('Error: Connection to DB - ]3 l) ~* E+ Q, f
: f! J3 ]7 K7 m+ ?" _) R. z9 |. p% m( a
Failed.');
7 ^( c4 Z! z2 Y; x" @& W+ a} y; J* V6 X* e' k$ P' A
Connect();$ a) P8 b4 X; S. k. C: E
) I8 o$ i1 l. W8 f/ c
function InitForm(){/ c4 z7 W, Z3 }/ t9 F
//layout for the form) V! N' `1 m) a- T( n" b6 n
echo "<strong>Send Items.</strong>
1 s D/ h) A4 ^2 r% f<form name='select' method='post'>+ j* F4 y' V( s+ D
<lable>Character Name</lable><br/> j9 Z7 y# }) C+ g
<input type='text' name='char'/><br/>
; M b3 P# B6 z" |<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>' n6 |+ m0 t% P- L( Q9 \
<input type='text' name='item_name'/><br/>/ F& T# I- W; `3 @3 w7 ]) q
<lable>Item Amount</lable><br/>0 B9 ]0 b: Y2 c+ r
<input type='text' name='item_amount'/><br/>- ]6 A. p% b+ g6 ^, S$ _( _/ [" a# i
<lable>Item Upgrade Amount</lable><br/>
+ y$ q' |7 M: b/ f2 r1 |<input type='text' name='item_upgrade'/><br/>1 r- N' g2 v9 c
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)2 m9 K* a9 U0 p0 U. y
: j; j: \2 K/ _9 |. O# j8 i</lable><br/>/ a- H7 V1 B+ O. L
<input type='text' name='item_element'/><br/> M9 m' Z7 v; Z( B
<lable>Element Upgrade Amount</lable><br/>3 S2 h/ J3 ~6 I1 ~9 u! d* ]
<input type='text' name='element_upgrade'/><br/>
* W o" @4 L1 I X- k$ F<lable>Pierced Amount</lable><br/>7 a2 S V$ T3 e9 W
<input type='text' name='item_pierce'/><br/>
/ l' g, A$ k& ~" Y- m7 C* a<input type='submit'/>- v# E0 S. F+ F/ [3 _9 W
</form>";
- k# d! b& M' x6 U5 O2 y}/ L" y% I. e- f% r N1 v: Q
9 i1 R/ l4 M$ }# u3 M" Mfunction PostListener (){
1 F# k+ j! z- W//Add more post variables if needed and add them to initform() function aswell
5 h% Y9 }( f( t D6 `* {' _; F
) p* [) w: h$ e################################) E' {2 I( o* |& l) r) m
##### Connection and Post ######0 R9 w9 j( n! N' s3 w
################################
" b- b7 j7 ]9 c3 ?( X$name = @$_POST['char']; X' y- R! h) l5 m$ F
$ItemName = @$_POST['item_name'];
! X, e6 L6 H. r- o: k0 j' X$ItemAmount = @$_POST['item_amount'];
0 i A5 B$ j6 G9 S$ItemId = @$_POST['item_id'];( O0 J* D1 i/ U" t
$ItemUpgrade = @$_POST['item_upgrade'];
, w3 A8 t4 T' C. ~8 O) e# L$ItemElement = @$_POST['item_element'];
% b, q8 X! d/ d+ a1 i5 Y$ElementUpgrade = @$_POST['element_upgrade'];& `- `: L3 u8 M9 l: c8 {7 P
$ItemPierce = @$_POST['item_pierce'];
0 ?/ H! i1 o/ _- g' F- C$ J- q################################0 b9 I# p3 I- G7 Z( s! c6 z7 d
' T2 ?2 B0 h/ F1 v2 S//Check both variables for empty value
8 e% r- _% x; K( W
( N9 S+ q- M ~if (!empty($_POST['char'])){
* c8 H8 A/ a- [' U* d5 ?1 W/ n6 V$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
4 _5 ?6 ]7 F$ N9 y$ d% X5 b. |! ` t
m_szName = '{$name}'");! K8 f* ~0 y9 `/ T1 ^) O/ p
while ($row = mssql_fetch_object($find)){! z6 W! X6 S6 }( W% c* F
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";# c. s% b& K* K
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
# s' S% Z2 L) ~! m. L0 h% R* X7 P; c4 [* i
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], * o& }9 i- U- c! p ]
) W3 f" e5 |( l; I/ W* I& G
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
v# G! M, v3 s+ t+ X; ], b, B, E! e2 ^
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', * n1 Q. F$ C/ p2 _$ y5 r
g) e) a. N1 v; l X% x
'{$ElementUpgrade}', '{$ItemPierce}');");, M9 J _ k: g
}5 y2 Q) p1 ^( q: G' S
& R* k/ f( ~1 k1 Q1 U( x; G
}; z3 F" {: Q* g3 n/ A) X
+ ~6 I% _ _4 @7 B, y1 m3 s}
6 C) p4 S8 N" R! t7 }" p( K( g* w+ G I
$InitForm = InitForm();3 n- v: D, C- w4 ^
$Listener = PostListener();4 ?+ m' o4 C: l
# o' k2 H3 z9 _1 A- O0 k
?>
5 }' r8 }9 Z5 X; p/ m3 {" N% T5 d
) |# P, n$ a* _ g. c7 k% U6 S! @) f. r3 B
. g0 P% J3 U+ q4 G: C% P" @3 k' u6 k W1 q# O
|
|