public string AccountToJson(Account account)
{
try
{
return JsonConvert.SerializeObject(account);
}
catch (JsonException ex)
{
return null;
}
}
// перегрузка поиска логина по id с учетом времени
//-----------------------
public void add_new_account(Account account)
{
var query = @"REPLACE INTO steam_accounts
(id, user_name, user_password, available, center_owner, center_holder, computer) VALUES("
+ account.id + ", '"
+ account.user_name + "', '"
+ account.user_password + "', "
+ account.available + ", '"
+ account.center_owner + "', '"
+ account.center_holder + "', '"
+ account.computer + "')";
ExecuteQuery(query);
}
public void AddTakenAccountsFromPostgres(DataTable source, List<int> hash)
{
foreach (DataRow row in source.Rows)
if (hash.Contains(int.Parse(row["id"].ToString())))
{
var account = new Account(int.Parse(row["id"].ToString()))
{
user_name = row["user_name"].ToString(),
user_password = row["user_password"].ToString(),
available = int.Parse(row["available"].ToString()),
center_owner = row["club"].ToString()
};
account.center_holder = account.available == 0 ? row["club"].ToString() : "";
account.computer = row["computer"].ToString();
add_new_account(account);
}
}
public Account get_first_free_account(string holder, string compName )
{
var dt = GetQueryResult("SELECT * FROM steam_accounts WHERE available=1 ORDER by id");
var rand = new Random();
var i = rand.Next(0, dt.Rows.Count);
var account = new Account(0)
{
id = int.Parse(dt.Rows[i][0].ToString())
};
change_account_status(account.id, holder, compName, 0);
account.user_name = dt.Rows[i][1].ToString();
account.user_password = dt.Rows[i][2].ToString();
account.available = 0;
account.computer = compName;
return account;
}
public List<Account> get_accounts_for_requester(int limit)
{
// отбор аккаунтов указанного количества
// для запросившего аккаунты. Сами аккаунты удаляются
var dt = GetQueryResult(
"SELECT * FROM steam_accounts WHERE available=1 LIMIT " + limit);
var result = new List<Account>(0);
foreach (DataRow row in dt.Rows)
{
var account = new Account(0)
{
id = int.Parse(row[0].ToString()),
user_name = row[1].ToString(),
user_password = row[2].ToString(),
available = 1,
computer = "",
center_owner = "",
center_holder = ""
};
delete_account(account);
result.Add(account);
}
return result;
}
public List<Account> get_accounts_array(string title)
{
var dt = GetQueryResult(
"SELECT * FROM steam_accounts");
var result = new List<Account>(0);
foreach (DataRow row in dt.Rows)
{
var account = new Account
{
id = int.Parse(row[0].ToString()),
user_name = row[1].ToString(),
user_password = row[2].ToString(),
available = 1,
center_owner = title,
center_holder = "",
computer = ""
};
result.Add(account);
}
return result;
}
public void delete_account(Account account)
{
ExecuteQuery("DELETE FROM steam_accounts WHERE id='" + account.id + "'");
}
public List<Account> GetAccountsForRequester(int limit)
{
// отбор аккаунтов указанного количества
// для запросившего аккаунты. Сами аккаунты удаляются
var dt = GetQueryResult(
"select * from steam_accounts where available=1 limit " + limit);
var result = new List<Account>(0);
foreach (DataRow row in dt.Rows)
{
var account = new Account(0)
{
id = int.Parse(row[0].ToString()),
user_name = row[1].ToString(),
user_password = row[2].ToString(),
available = 1,
computer = "",
center_owner = "",
center_holder = ""
};
DeleteAccount(account);
result.Add(account);
}
return result;
}
public bool UpdateAccount(Account account)
{
var query = @"UPDATE steamusers SET user_name='" + account.user_name
+ "', user_password='******', available='" + account.available
+ "', club='" + account.center_owner
+ "', computer='" + account.computer
+ "' WHERE id='" + account.id + "'";
if (ExecuteQuery(query))
{
CreateSystemMessage("Был обновлен аккаунт" +
"\r\nID аккаунта: " + account.id +
"\r\nЛогин: " + account.user_name +
"\r\nПароль: " + account.user_password +
"\r\nДоступ: " + account.available +
"\r\nВзят клубом: " + account.center_owner +
"\r\nКомпьютер: " + account.computer);
return true;
}
CreateSystemMessage("Ошибка 1.9");
return false;
}
public void DeleteAccount(Account account)
{
ExecuteQuery($"delete from steam_accounts where id='{account.id}'");
}
// перегрузка поиска логина по id с учетом времени
//-----------------------
public void add_new_account(Account account)
{
ExecuteQuery("replace into steam_accounts " +
"(id, user_name, user_password, available, center_owner, center_holder, computer) values("
+ account.id + ", '"
+ account.user_name + "', '"
+ account.user_password + "', "
+ account.available + ", '"
+ account.center_owner + "', '"
+ account.center_holder + "', '"
+ account.computer + "')");
}
public List<Account> get_account_array(int count, string title)
{
var dt = GetQueryResult($"SELECT * FROM steamusers WHERE available=1 LIMIT {count}");
var result = new List<Account>(0);
for (int i = 0; i < dt.Rows.Count; i++)
{
var account = new Account
{
id = int.Parse(dt.Rows[i][0].ToString()),
user_name = dt.Rows[i][1].ToString(),
user_password = dt.Rows[i][2].ToString(),
available = 1,
center_owner = title,
center_holder = "",
computer = ""
};
ChangeAccountStatus(account.id, title, "", 0);
result.Add(account);
}
return result;
}
public Account GetFirstFreeAccount(string club, string comp_name)
{
try
{
var dt = GetQueryResult(@"SELECT * FROM steamusers WHERE available=1 ORDER BY id");
var account = new Account(0);
//-------------------
var rand = new Random();
var i = rand.Next(0, dt.Rows.Count >= 5 ? 5 : dt.Rows.Count);
//---------------------
account.id = int.Parse(dt.Rows[i][0].ToString());
ChangeAccountStatus(account.id, club, comp_name, 0);
account.user_name = dt.Rows[i][1].ToString();
account.user_password = dt.Rows[i][2].ToString();
account.available = 0;
account.center_owner = club;
account.computer = comp_name;
return account;
}
catch (Exception ex)
{
CreateSystemMessage("Ошибка 1.15: " + ex.Message);
return null;
}
}
public void DeleteAccount(Account account)
{
if (ExecuteQuery("DELETE FROM steamusers WHERE id='" + account.id + "'"))
CreateSystemMessage("Был удален аккаунт по id = " + account.id);
else
CreateSystemMessage("Ошибка 1.13");
}
public DataTable AddNewAccount(Account account)
{
if (ExecuteQuery(
@"INSERT INTO steamusers (user_name, user_password, available) VALUES('"
+ account.user_name + "', '"
+ account.user_password + "', '"
+ account.available + "')"))
{
CreateSystemMessage("Был добавлен новый аккаунт");
var result = SearchUserLogin(account.user_name);
return result;
}
else
{
CreateSystemMessage("Ошибка 1.10");
return null;
}
}
public Account GetFirstFreeAccount(string holder, string compName)
{
var dt = GetQueryResult("select * from steam_accounts where available=1 order by id");
var rand = new Random();
var i = rand.Next(0, dt.Rows.Count);
var account = new Account(0)
{
id = int.Parse(dt.Rows[i][0].ToString())
};
ChangeAccountStatus(account.id, holder, compName, 0);
account.user_name = dt.Rows[i][1].ToString();
account.user_password = dt.Rows[i][2].ToString();
account.available = 0;
account.computer = compName;
return account;
}
public List<Account> get_accounts_reserved_for_me(string title)
{
var dt = get_accounts_taken_by(title);
var result = new List<Account>(0);
foreach (DataRow row in dt.Rows)
{
var account = new Account(0)
{
id = int.Parse(row[0].ToString()),
user_name = row[1].ToString(),
user_password = row[2].ToString(),
available = 1,
computer = "",
center_owner = title,
center_holder = ""
};
result.Add(account);
}
return result;
}
