Avatar for Username

搜尋 Mozilla 技術支援網站

防止技術支援詐騙。我們絕對不會要求您撥打電話或發送簡訊，或是提供個人資訊。請用「回報濫用」功能回報可疑的行為。

Learn More

此討論串已被封存。 如果您有需要幫助，請新增一個新問題

Breaking out the visit count of a bookmark, so I can see when I visited it across the space of an evening.

  • 3 回覆
  • 1 有這個問題
  • 7 次檢視
  • 最近回覆由 cor-el

jayanglais
jayanglais
more options

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!

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!

所有回覆 (3)

cor-el
cor-el
  • Moderator
  • Top 10 Contributor
more options

You can see all dates that you've visited a website by using inspecting the places.sqlite database file with the SQLite Manager extension.

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

  1. Open Profile Directory -> places.sqlite -> Go
  2. Hit the Execute SQL tab
  3. 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

由 cor-el 於 修改

jayanglais
jayanglais 提出問題者
more options

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.

cor-el
cor-el
  • Moderator
  • Top 10 Contributor
more options

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