I want to view the entire cookies folder where it shows last time accessed
I want to be able to view the inter cookies folder. It is no longer easily accessible. It is an sqlite file now and I can not open it. We used to be able to see this file where it showed last time a cookie was updated or a site was accessed. I want to have this ability again. I know where the cookies.sqlite file resides, I just can not open it.
All Replies (3)
SQLIte Manager Extension: https://addons.mozilla.org/en-US/firefox/addon/5817/
the SQLite manager extension is a good tool but it still will not open the cookies.sqlite file because it says it is locked. how do you un-lock it? also when opening other mozilla .sqlite files the date field is many characters long, how do you convert to an actual date?
thanks
You need to make a copy of the sqlite file if you want to open the file while Firefox is using that profile.
The date and time is saved in 64 bit EPOCH format in micro seconds.
See http://en.wikipedia.org/wiki/Unix_time
javascript:(function(){var D='%s'||'0',d,n; while(D){d=new Date(D);n=parseInt(D);if(!isNaN(n))d.setTime(n/1000);D=prompt('Enter EPOCH in microseconds and click OK\nClick Cancel to Stop\n\n'+D+'\n'+d.toLocaleString()+'\n'+(d.getTime()*1000),d.toGMTString())}})();