ispCP Omega 1.0.2

[Kika]

bocs, az elobb melo volt nagyon, csak jott a level igy rapislantottam a forumra

Code:

SELECT a.domain_name, sum(b.dtraff_web) as traff_web, sum(b.dtraff_ftp) as traff_ftp, sum(b.dtraff_mail) as traff_mail, sum(b.dtraff_pop) as traff_pop FROM domain a left join domain_traffic b on (a.domain_id=b.domain_id)
where b.dtraff_time > UNIX_TIMESTAMP('2009-10-01') and b.dtraff_time < UNIX_TIMESTAMP('2009-10-22')
group by b.domain_id
order by a.domain_name

van benne ket datum mintanak, azok persze cserelodhetnek vagy ha kell lehet pl ugy modositani, hogy automatikusan szedje honapokra az egesz evet