Firefox history harvesting!

%APPDATA%\Mozilla\Firefox\Profiles
=======

select *
FROM moz_places
WHERE
last_visit_date BETWEEN strftime(‘%s’,’2000-04-01′)*1000000
AND strftime(‘%s’,’2014-07-10′)*1000000
AND visit_count < (2) AND frecency < 21

—-
delete
FROM moz_places
WHERE
last_visit_date BETWEEN strftime(‘%s’,’2000-04-01′)*1000000
AND strftime(‘%s’,’2014-07-10′)*1000000
AND visit_count < (2) AND frecency < 21

=============
select * from moz_historyvisits as hv
LEFT OUTER JOIN moz_places as p
on hv.place_id = p.id where p.visit_count IS NULL
—-
delete from moz_historyvisits where id in(
select hv.id from moz_historyvisits as hv
LEFT OUTER JOIN moz_places as p
on hv.place_id = p.id where p.visit_count IS NULL)
========

VACUUM

=====

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *