|
|
<?php$ U O. U/ ?; X( }
function Connect () {, u, x* r/ b4 P$ e2 z) t1 C1 o
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
5 t7 d; M" J( J7 w5 U" r& e5 g% ]3 F+ V
Failed.');8 n2 W) L/ G- c7 w% I! J3 w; |7 v
}- G9 L4 s# d" e9 y' k7 G2 p) X. N5 A
Connect();
7 ?& R+ Y- w3 C: R! s: g% {) _- W- j9 a8 @& Z6 _
function InitForm(){7 C5 B" F- D- x
//layout for the form+ T9 W3 L( u3 r+ w/ b! a- O: Y& j
echo "<strong>Send Items.</strong>6 H/ G) m5 }2 j* J' M+ T! W
<form name='select' method='post'>9 g& A8 z/ x8 w6 K
<lable>Character Name</lable><br/>
. n: V9 w3 {( n<input type='text' name='char'/><br/>
# h3 E( h6 B" e& T! j<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>, B2 G6 i6 u: b6 i: `) x0 G4 Y
<input type='text' name='item_name'/><br/>
' _' u: |9 }: l! k8 A<lable>Item Amount</lable><br/>$ Y. J& R2 Z. R7 z" Y. i7 h. H9 ?
<input type='text' name='item_amount'/><br/>
3 t0 I' R; H# B- j3 m0 s1 b+ z6 {<lable>Item Upgrade Amount</lable><br/>
2 w! _; q( n6 B7 f8 Y" n% K<input type='text' name='item_upgrade'/><br/>
/ I' ]0 u( B- O<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)8 i2 w/ ]$ z/ C- \8 K8 ]5 t$ V
! G. [" I) }5 N+ ?+ v5 ]</lable><br/>0 M) a9 J, C: ]$ p
<input type='text' name='item_element'/><br/>
& r! L8 T6 B! Z! R9 b+ J<lable>Element Upgrade Amount</lable><br/>
, Z* n; f. q* A8 `<input type='text' name='element_upgrade'/><br/>
% A1 L) Z2 c2 h+ p! W. Y' h<lable>Pierced Amount</lable><br/>
1 L% B" B2 P. I8 q5 L. P. r<input type='text' name='item_pierce'/><br/>
, L) {8 |. X5 ^7 Z<input type='submit'/>0 w+ k8 @! E' v0 \
</form>";2 A+ [9 S4 ~2 y \8 V
}
n: I. E/ a4 N9 K! l6 D9 f) o
6 W) r2 {+ ?7 F6 v& a2 jfunction PostListener (){
0 `. ~1 G( p# M }8 K7 \//Add more post variables if needed and add them to initform() function aswell
8 ?+ ]' F/ G7 d' D, I4 B) A' ^1 ?; C( u
################################. h6 }8 w, u7 x. e, q
##### Connection and Post ######8 b3 }, @0 O6 Y# }, ], _+ A1 E
################################
+ w8 x {9 z N4 `1 ~( d0 G/ L# X8 _$name = @$_POST['char'];
7 e. e4 S; C4 ]" y7 i- h$ItemName = @$_POST['item_name'];
0 C0 T. `0 Q' |1 [$ `$ItemAmount = @$_POST['item_amount'];
0 l0 t! h8 \; `5 N+ s7 ^3 a2 l$ItemId = @$_POST['item_id'];
0 C- k9 T& v' L3 O$ItemUpgrade = @$_POST['item_upgrade'];6 O2 ^( N! c2 y! {7 l
$ItemElement = @$_POST['item_element'];, r2 r' B0 g1 f) i' h F
$ElementUpgrade = @$_POST['element_upgrade'];2 F# P! o4 Q) w5 H, Y% V; M D
$ItemPierce = @$_POST['item_pierce'];
+ l7 x$ t/ w- x################################' G; @- K4 l* S; v
" {2 S0 }9 r1 _6 a% g- y//Check both variables for empty value
5 Q+ q6 _1 E" j0 b8 h- x" K4 {$ D. f$ `# p3 [7 d
if (!empty($_POST['char'])){+ t% w9 l6 o9 t ?
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
, ~! j9 D/ _3 |% O4 w/ O) r' e8 I4 a) {0 S
m_szName = '{$name}'");6 H, r3 B1 L5 I2 Q
while ($row = mssql_fetch_object($find)){
8 N9 |( A6 F* r- \( B1 [2 ?0 Necho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";9 Q! w9 G* ?+ p
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
1 F. s& M% {6 C; h! {
5 N+ F2 o# b5 @* E- l" N0 e[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], : {6 L, d* d' h2 C) ^+ b/ q
7 K# l; x+ _- |6 \; ^' t[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', " ^! J6 E. k Q' b
4 @7 e5 ~, b& P, L* {% d6 cN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
# Z; P0 v2 n7 \/ c( m; h s
1 l1 S$ @0 @+ o: }( ]! V5 I! A, ?; g'{$ElementUpgrade}', '{$ItemPierce}');");
/ K% L/ W* b. o7 M}% J* x! t" h- U* S
5 z8 [1 H: ^% K3 F% T. y% G
}" E/ `" K% _' {* o4 G7 N9 H
4 h0 i& d6 R. Z: d2 B% a2 V
}
8 R& L* V: R8 r; ]& z' x% d( k9 m# b& W9 G8 w2 n; b6 P
$InitForm = InitForm();) ^2 r, W! H% p/ W( P% _1 Z6 n, q
$Listener = PostListener();
% i% N; b+ p H3 K# t! v9 R" F
9 z; H( |) j+ t: @?>
+ A R! X- L) p+ Z0 F, V3 H
) T3 |8 @# P2 r4 b& N* d3 Z# u0 j5 w' X S' X, C
7 ]" b0 S: s2 g3 I N' W
' w+ l! m. `! i0 }; i |
|