public bool UpdateRegUser(DatabaseService.DatabaseLink dbLink, string show_id, string nick, string icon, string reg_ip, string reg_mac, string account)
{
return(dbLink.ExecuteNonQuery("update reg user", show_id, nick, icon, reg_ip, reg_mac, account) > 0);
}
public bool RecordAccount(DatabaseService.DatabaseLink dbLink, string action, string show_id, string ip, string mac)
{
return(dbLink.ExecuteNonQuery("record account", DateTime.Now, action, show_id, ip, mac) > 0);
}
public bool SetUserGameData(DatabaseService.DatabaseLink dbLink, string game_name, int grade, string show_id, JObject jData)
{
string jsonData = jData.ToString(Formatting.None);
return(dbLink.ExecuteNonQuery("set user game data", game_name, grade, show_id, jsonData, jsonData) > 0);
}
public bool EffectiveBackControl(DatabaseService.DatabaseLink dbLink, int id)
{
return(dbLink.ExecuteNonQuery("effective back control", DateTime.Now, id) > 0);
}
public bool SetJackpot(DatabaseService.DatabaseLink dbLink, string game_name, int grade, long jackpot)
{
return(dbLink.ExecuteNonQuery("set game jackpot " + grade, jackpot, game_name) > 0);
}
public bool SetProfit(DatabaseService.DatabaseLink dbLink, string game_name, int grade, string show_id, long profit)
{
return(dbLink.ExecuteNonQuery("set user game profit", game_name, grade, show_id, profit, profit) > 0);
}
public bool SetUserIcon(DatabaseService.DatabaseLink dbLink, string icon, string show_id)
{
return(dbLink.ExecuteNonQuery("set user icon", icon, show_id) > 0);
}
public bool SetUserLastTable(DatabaseService.DatabaseLink dbLink, string last_server, string last_game, int last_grade, int last_table_id, string show_id)
{
return(dbLink.ExecuteNonQuery("set user last table", last_server, last_game, last_grade, last_table_id, show_id) > 0);
}
public bool DelOneMail(DatabaseService.DatabaseLink dbLink, int mailID)
{
return(dbLink.ExecuteNonQuery("del one mail", mailID) >= 0);
}
public bool SetUserNick(DatabaseService.DatabaseLink dbLink, string nick, string show_id)
{
return(dbLink.ExecuteNonQuery("set user nick", nick, show_id) > 0);
}
public bool DelAllMail(DatabaseService.DatabaseLink dbLink, string show_id)
{
return(dbLink.ExecuteNonQuery("del all mail", show_id) >= 0);
}
public bool AddMail(DatabaseService.DatabaseLink dbLink, string show_id, string content)
{
return(dbLink.ExecuteNonQuery("add mail", DateTime.Now, show_id, content) > 0);
}
public bool UpdateLoginUser(DatabaseService.DatabaseLink dbLink, string login_token, string login_ip, string login_mac, int login_ismobile, string account)
{
return(dbLink.ExecuteNonQuery("update login user", login_token, login_ip, login_mac, login_ismobile, account) > 0);
}
public bool RecordTrade(DatabaseService.DatabaseLink dbLink, string number, string show_id, int item_id, string type, int money)
{
return(dbLink.ExecuteNonQuery("record trade", DateTime.Now, number, show_id, item_id, type, money, 0) > 0);
}
public bool SetUserSign(DatabaseService.DatabaseLink dbLink, string sign, string show_id)
{
return(dbLink.ExecuteNonQuery("set user sign", sign, show_id) > 0);
}
public bool SetUserMoney(DatabaseService.DatabaseLink dbLink, long money, string show_id)
{
return(dbLink.ExecuteNonQuery("set user money", money, show_id) > 0);
}
public bool SetUserBankPwd(DatabaseService.DatabaseLink dbLink, string pwd, string show_id)
{
return(dbLink.ExecuteNonQuery("set user bank pwd", pwd, show_id) > 0);
}
public bool SetStore(DatabaseService.DatabaseLink dbLink, string game_name, int grade, long store)
{
return(dbLink.ExecuteNonQuery("set game store " + grade, store, game_name) > 0);
}
public bool SetUserPhone(DatabaseService.DatabaseLink dbLink, string phone, string show_id)
{
return(dbLink.ExecuteNonQuery("set user phone", phone, show_id) > 0);
}
public bool SetBigAwardCounter(DatabaseService.DatabaseLink dbLink, string game_name, int grade, long counter)
{
return(dbLink.ExecuteNonQuery("set game bigaward counter " + grade, counter, game_name) > 0);
}
public bool SetUserVc(DatabaseService.DatabaseLink dbLink, string vc, string show_id)
{
return(dbLink.ExecuteNonQuery("set user vc", vc, show_id) > 0);
}
public bool SetForce(DatabaseService.DatabaseLink dbLink, string game_name, int grade, string show_id, long force)
{
return(dbLink.ExecuteNonQuery("set user game force", game_name, grade, show_id, force, force) > 0);
}
public bool SetUserGetVcTime(DatabaseService.DatabaseLink dbLink, DateTime getVcTime, string show_id)
{
return(dbLink.ExecuteNonQuery("set user getvc time", getVcTime, show_id) > 0);
}
public bool RegGameServer(DatabaseService.DatabaseLink dbLink, string game_name, string ip_port)
{
return(dbLink.ExecuteNonQuery("reg game server", game_name, ip_port) > 0);
}
public void StatRecordRank(DatabaseService.DatabaseLink dbLink, string type)
{
dbLink.ExecuteNonQuery("stat rank" + type);
}
public bool AddNotice(DatabaseService.DatabaseLink dbLink, int type, string title, string content)
{
return(dbLink.ExecuteNonQuery("add notice", DateTime.Now, type, title, content) > 0);
}
public bool AddUser(DatabaseService.DatabaseLink dbLink, string account, string login_pwd)
{
return(dbLink.ExecuteNonQuery("add user", account, login_pwd) > 0);
}