public static void bst_2_create_player(RecordBSTAccount a, RecordBSTBase b, string custom, string last_tips)
{
using (MySqlConnection conn = new MySqlConnection(ConnStr)) {
conn.Open();
string query = "INSERT INTO bst_player2_data VALUES (" +
$"\"{a.rid}\", {a.usrid}, {a.is_takeover}, {a.tpc}, {a.dpc}, {a.crd}, {a.brd}, {a.tdc}, \"{a.lid}\", {a.mode}, {a.ver}, {a.pp}, {a.ps}, {a.pay}, {a.pay_pc}, {a.st}, " +
$"\"{b.name}\", {b.brnk}, {b.bcnum}, {b.lcnum}, {b.volt}, {b.gold}, {b.lmid}, {b.lgrd}, {b.lsrt}, {b.ltab}, {b.splv}, {b.pref}, {b.lcid}, {b.hat}, " +
$"\"{custom}\", {last_tips})";
MySqlCommand cmd = new MySqlCommand(query, conn);
cmd.ExecuteNonQuery();
foreach (int i in Enumerable.Range(0, 61))
{
query =
$"INSERT INTO bst_player2_hacker (refid, id, state0, state1, state2, state3, state4) VALUES (\"{a.rid}\", {i}, 0, 0, 0, 0, 0)";
cmd = new MySqlCommand(query, conn);
cmd.ExecuteNonQuery();
}
}
}
public static void bst_2_write_player(RecordBSTAccount a, RecordBSTBase b, string custom, string last_tips)
{
using (MySqlConnection conn = new MySqlConnection(ConnStr)) {
conn.Open();
string query = "UPDATE bst_player2_data SET " +
$"usrid = {a.usrid}, " +
$"is_takeover = {a.is_takeover}, " +
$"tpc = {a.tpc}, " +
$"dpc = {a.dpc}, " +
$"crd = {a.crd}, " +
$"brd = {a.brd}, " +
$"tdc = {a.tdc}, " +
$"lid = \"{a.lid}\", " +
$"mode = {a.mode}, " +
$"ver = {a.ver}, " +
$"pp = {a.pp}, " +
$"ps = {a.ps}, " +
$"pay = pay + {a.pay}, " +
$"pay_pc = pay_pc + {a.pay_pc}, " +
$"st = {a.st}, " +
$"name = \"{b.name}\", " +
$"brnk = {b.brnk}, " +
$"bcnum = {b.bcnum}, " +
$"lcnum = {b.lcnum}, " +
$"volt = {b.volt}, " +
$"gold = {b.gold}, " +
$"lmid = {b.lmid}, " +
$"lgrd = {b.lgrd}, " +
$"lsrt = {b.lsrt}, " +
$"ltab = {b.ltab}, " +
$"splv = {b.splv}, " +
$"pref = {b.pref}, " +
$"lcid = {b.lcid}, " +
$"hat = {b.hat}, " +
$"custom = \"{custom}\", " +
$"last_tips = {last_tips} WHERE refid = \"{a.rid}\"";
MySqlCommand cmd = new MySqlCommand(query, conn);
cmd.ExecuteNonQuery();
}
}
