Mozilla Firefox - Revision history

SvenBursch at 09:54, 17 May 2013

2013-05-17T09:54:16Z

2012-02-17T16:31:38Z

‎External Links

2011-11-03T10:09:54Z

2011-11-03T10:08:23Z

2011-11-03T10:06:42Z

2011-11-03T10:02:33Z

2011-11-03T09:51:18Z

2011-11-03T09:49:25Z

2011-09-27T09:35:59Z

2008-09-21T14:08:20Z

@@ Line 50: / Line 50: @@
 To get an overview of the visited sites:
 <pre>
-SELECT moz_historyvisits.visit_date, moz_places.url FROM moz_places, moz_historyvisits WHERE moz_places.id = moz_historyvisits.place_id;
+SELECT datetime(moz_historyvisits.visit_date/1000000, 'unixepoch', 'localtime'), moz_places.url FROM moz_places, moz_historyvisits WHERE moz_places.id = moz_historyvisits.place_id;
 </pre>

@@ Line 80: / Line 80: @@
 * [http://www.mozilla.com/firefox/ Official website]
 [[Category:Applications]]
 [[Category:Web Browsers]]

@@ Line 37: / Line 37: @@
 The places.sqlite uses the following timestamps.
-The '''moz_historyvisits.visit_date''' are in (the number of) microseconds since January 1, 1970 UTC
+The '''moz_historyvisits.visit_date''' is in (the number of) microseconds since January 1, 1970 UTC
 Some Python code to do the conversion into human readable format:
@@ Line 61: / Line 61: @@
 The places.sqlite uses the following timestamps.
-The '''moz_downloads.startTime''' and '''moz_downloads.endTime''' both are are in (the number of) microseconds since January 1, 1970 UTC.
+The '''moz_downloads.startTime''' and '''moz_downloads.endTime''' are in (the number of) microseconds since January 1, 1970 UTC.
 === Example queries ===

@@ Line 37: / Line 37: @@
 The places.sqlite uses the following timestamps.
-==== moz_historyvisits.visit_date ====
+The '''moz_historyvisits.visit_date''' are in (the number of) microseconds since January 1, 1970 UTC
-−
-The visit date and time values in the moz_historyvisits table are in (the number of) microseconds since January 1, 1970 UTC
 Some Python code to do the conversion into human readable format:
@@ Line 59: / Line 57: @@
 '''downloads.sqlite''' can be found in the same location as '''places.sqlite'''.
 === Example queries ===

← Older revision		Revision as of 10:06, 3 November 2011
Line 59:		Line 59:

	'''downloads.sqlite''' can be found in the same location as '''places.sqlite'''.		'''downloads.sqlite''' can be found in the same location as '''places.sqlite'''.
		+
		+	=== Example queries ===
		+	Some example queries:
		+
		+	To get an overview of the downloaded files:
		+	<pre>
		+	SELECT moz_downloads.startTime, moz_downloads.source, moz_downloads.currBytes, moz_downloads.maxBytes FROM moz_downloads;
		+	</pre>

	== See Also ==		== See Also ==

@@ Line 45: / Line 45: @@
 date_string = datetime.datetime( 1970, 1, 1 )
              + datetime.timedelta( microseconds=timestamp )
 </pre>

@@ Line 10: / Line 10: @@
 == History ==
-Firefox 3 stores the history of visited sites in a file named '''places.sqlite'''. This files uses the [[SQLite database format]].
+Firefox 3 stores the history of visited sites in a file named '''places.sqlite'''. This file uses the [[SQLite database format]].
 '''places.sqlite''' can be found in the following locations:
@@ Line 46: / Line 46: @@
              + datetime.timedelta( microseconds=timestamp )
 </pre>
 == See Also ==

@@ Line 1: / Line 1: @@
 {{expand}}
-Mozilla Firefox is a Free and Open Source [[Web Browser|web browser]].
+Mozilla Firefox is a Free and Open Source [[Web Browser|web browser]] developed by the Mozilla Foundation.
 It can have many [http://addons.mozilla.org add-ons] which give it extra capabilities.
@@ Line 8: / Line 8: @@
 This bug affects Firefox 2 (all versions) and Firefox 3 Beta3.
 == See Also ==
@@ Line 13: / Line 29: @@
 * [[Mozilla Suite]]
 * [[Mozilla Firefox History File Format]]
 == External Links ==
 * [http://www.mozilla.com/firefox/ Official website]

@@ Line 7: / Line 7: @@
 Mozilla Firefox can be used in anonymous browsing (see [[The Onion Router]]). However, it is known that Firefox reveals computer's uptime in TLS (SSL) "Client Hello" packets allowing investigator correlate anonymous and non-anonymous traffic [http://archives.seul.org/or/talk/Apr-2008/msg00050.html].
-This bug affects Firefox 2 (all versions) and Firefox 3 (including Beta3).
+This bug affects Firefox 2 (all versions) and Firefox 3 Beta3.
 == See Also ==