public static void ParseChromeHistory(string historyFilePath, string user, HostCookies[] cookies)
{
SQLiteDatabase database = new SQLiteDatabase(historyFilePath);
string query = "SELECT url, title, visit_count, last_visit_time FROM urls ORDER BY visit_count;";
DataTable resultantQuery = database.ExecuteQuery(query);
database.CloseDatabase();
foreach (DataRow row in resultantQuery.Rows)
{
var lastVisitTime = row["last_visit_time"];
Console.WriteLine("--- Chrome History (User: {0}) ---", user);
Console.WriteLine("URL : {0}", row["url"]);
if (row["title"] != String.Empty)
{
Console.WriteLine("Title : {0}", row["title"]);
}
else
{
Console.WriteLine("Title : No Title");
}
Console.WriteLine("Visit Count : {0}", row["visit_count"]);
HostCookies matching = FilterHostCookies(cookies, row["url"].ToString());
Console.WriteLine("Cookies : {0}", matching.ToJSON());
Console.WriteLine();
}
}
public static HostCookies[] ParseChromeCookies(string cookiesFilePath, string user, bool printResults = false, string[] domains = null)
{
SQLiteDatabase database = new SQLiteDatabase(cookiesFilePath);
string query = "SELECT * FROM cookies ORDER BY host_key";
DataTable resultantQuery = database.ExecuteQuery(query);
database.CloseDatabase();
// This will group cookies based on Host Key
HostCookies[] rawCookies = SortCookieData(resultantQuery);
if (printResults)
{
if (domains != null)
{
foreach (string domain in domains)
{
HostCookies hostInstance = FilterHostCookies(rawCookies, domain);
Console.WriteLine("--- Chrome Cookie (User: {0}) ---", user);
Console.WriteLine("Domain : {0}", hostInstance.HostName);
Console.WriteLine("Cookies (JSON) : {0}", hostInstance.ToJSON());
Console.WriteLine();
}
}
else
{
foreach (HostCookies cookie in rawCookies)
{
Console.WriteLine("--- Chrome Cookie (User: {0}) ---", user);
Console.WriteLine("Domain : {0}", cookie.HostName);
Console.WriteLine("Cookies (JSON) : {0}", cookie.ToJSON());
Console.WriteLine();
}
}
}
// Parse the raw cookies into HostCookies that are grouped by common domain
return(rawCookies);
}
public void Print()
{
string user = Environment.GetEnvironmentVariable("USERNAME");
Console.WriteLine("--- Chrome History (User: {0}) ---", user);
int spaces = 15;
Console.WriteLine("{0}{1}: {2}", "URL", SpaceGenerator(spaces - 3), Url);
Console.WriteLine("{0}{1}: {2}", "Title", SpaceGenerator(spaces - 5), Title == "" ? "No Title" : Title);
Console.WriteLine("{0}{1}: {2}", "Visit Count", SpaceGenerator(spaces - 11), VisitCount);
Console.WriteLine("{0}{1}: {2}", "Cookies", SpaceGenerator(spaces - 7), Cookies == null ? "": Cookies.ToJSON());
Console.WriteLine();
}
