Breaking out the visit count of a bookmark, so I can see when I visited it across the space of an evening.
I need to prove that on Wednesday night (19 Sept) I could not access a particular careers website. I found the error message url in my history and made the mistake of opening it, it therefore read 11pm today (21 Sept) as the last time it was visited. There is, however, a visit count of 14 which is in line with the amount of times I tried to get onto this site on Wednesday night. I could show the break down of visits on that date it would prove that I was not able to access the said site and could, therefore, not submit my application. Any help would be most appreciated!
All Replies (3)
You can see all dates that you've visited a website by using inspecting the places.sqlite database file with the SQLite Manager extension.
- SQLite Manager: https://addons.mozilla.org/firefox/addon/sqlite-manager/
Modify the AND url LIKE '%google.com%' part to select which URL to see or leave out that part to get the complete history.
See also http://www.sqlite.org/lang_select.html
- Open Profile Directory -> places.sqlite -> Go
- Hit the Execute SQL tab
- Use a Select like this:
SELECT datetime(visit_date/1000000,'unixepoch'), url, title, visit_count, frecency FROM moz_places, moz_historyvisits WHERE moz_places.id = moz_historyvisits.place_id AND url LIKE '%google.com%' ORDER BY url, visit_date DESC
Modified by cor-el
Hi, thank you for the help.
I managed to download the addon, then got to the profile page, selected places.sqlite and the Execute SQL tab.
In terms of the programming you suggested, am I just supposed to fill in the gaps? I typed the following into the Enter SQL field:
ELECT www.careers.un.org/Install/UnderConstruction.htm, 14 FROM moz_places, moz_historyvisits WHERE moz_places.id = moz_historyvisits.place_id AND www.careers.un.org/Install/UnderConstruction.htm LIKE '%google.com%' ORDER BY www.careers.un.org/Install/UnderConstruction.htm, 09/19/12 DESC
Am I on the right track at all? Sorry, this is somewhat above my level of understanding. The site url is as above, the date I need is 09/19/12 and the time was from 8:30pm onwards. I can see from my firefox history that I hit the same page 12 times but I can't show the exactly when. You can see the screen shot showing the url and the last time I opened it (Friday at 11pm).
Cheers,
James.
No, that is not the correct code for the SQLite query.
You only need to specify the domain or URL in the "like" field and don't make any changes elsewhere.
The first SELECT line specifies which columns to show in the results and you can lweave out the ones that you do not need.
SELECT datetime(visit_date/1000000,'unixepoch'), url, title, visit_count, frecency FROM moz_places, moz_historyvisits WHERE moz_places.id = moz_historyvisits.place_id AND url LIKE '%www.careers.un.org%' ORDER BY url, visit_date DESC