public MySqlDataReader GetRecordRank(DatabaseService.DatabaseLink dbLink, string type, string show_id = "") { if (show_id.Length == 0) { return(dbLink.ExecuteReader("get all rank" + type)); } return(dbLink.ExecuteReader("get rank" + type, show_id)); }
bool CheckToken(DatabaseService.DatabaseLink dbLink, string show_id, string token) { if (Program.dbHelper.GetUserLoginToken(dbLink, show_id) != token) { return(false); } return(true); }
void CreateRooms(DatabaseService.DatabaseLink dbLink, string gameName) { using (var reader = Program.dbHelper.GetGameInfo(dbLink, gameName)) { if (reader == null) { return; } if (!reader.Read()) { return; } GameInfo gameInfo = new GameInfo(); gameInfo.name = gameName; gameInfo.dllFile = reader.GetStringSafe("dll_file"); gameInfo.baseDir = string.Format(@"{0}Games\{1}", AppDomain.CurrentDomain.BaseDirectory, gameInfo.dllFile); var assembly = Assembly.LoadFile(string.Format(@"{0}\{1}.dll", gameInfo.baseDir, gameInfo.dllFile)); gameInfo.gameLogicType = assembly.GetType("Game.GameLogic"); gameInfo.methodLoadConfigs = gameInfo.gameLogicType.GetMethod("LoadConfigs", BindingFlags.Static | BindingFlags.Public); gameInfo.jConfigs = (JObject)gameInfo.methodLoadConfigs.Invoke(null, new object[] { gameInfo.baseDir }); gameInfo.roomCount = reader.GetInt32Safe("room_count"); gameInfo.tableCount = reader.GetInt32Safe("table_count"); gameInfo.seatCount = reader.GetInt32Safe("seat_count"); int gradeCount = reader.GetInt32Safe("grade_count"); bool isNeedUpdate = reader.GetBoolSafe("need_update"); gameInfo.roomGrades = new RoomGrade[gradeCount]; for (int i = 0; i < gradeCount; i++) { RoomGrade roomGrade = new RoomGrade(); roomGrade.grade = i; roomGrade.moneyLimit = reader.GetInt64Safe("grade" + i + "_money"); for (int j = 0; j < gameInfo.roomCount; j++) { Room room = new Room(gameInfo, roomGrade.grade, idToTableDict, isNeedUpdate); roomGrade.rooms.Add(room); } gameInfo.roomGrades[i] = roomGrade; } gameInfos[gameName] = gameInfo; } }
public long GetUserMoney(DatabaseService.DatabaseLink dbLink, string show_id) { using (var reader = GetUserBaseInfo(dbLink, show_id)) { if (reader == null || !reader.Read()) { return(0); } return(reader.GetInt64Safe("money")); } }
public bool UserIsRobot(DatabaseService.DatabaseLink dbLink, string show_id) { using (var reader = GetUserBaseInfo(dbLink, show_id)) { if (reader == null || !reader.Read()) { return(false); } return(reader.GetBoolSafe("is_robot")); } }
public DateTime GetUserGetVcTime(DatabaseService.DatabaseLink dbLink, string show_id) { using (var reader = GetUserBaseInfo(dbLink, show_id)) { if (reader == null || !reader.Read()) { return(DateTime.MinValue); } return(reader.GetDateTimeSafe("getvc_time")); } }
public string GetUserNick(DatabaseService.DatabaseLink dbLink, string show_id) { using (var reader = GetUserBaseInfo(dbLink, show_id)) { if (reader == null || !reader.Read()) { return(""); } return(reader.GetStringSafe("nick")); } }
public bool ReleaseLock(DatabaseService.DatabaseLink dbLink, string key) { using (var reader = dbLink.ExecuteReader("release lock", key)) { if (reader != null && reader.Read()) { return(reader.GetBoolSafe(0)); } } return(false); }
public MySqlDataReader GetRecordGift(DatabaseService.DatabaseLink dbLink, string show_id, string type) { if (type == "1") { return(dbLink.ExecuteReader("get send gift record", show_id)); } if (type == "2") { return(dbLink.ExecuteReader("get recv gift record", show_id)); } return(null); }
public int GetPhoneCount(DatabaseService.DatabaseLink dbLink, string phone) { using (var reader = dbLink.ExecuteReader("get phoneNum", phone)) { if (reader == null || !reader.Read()) { return(0); } else { return(Convert.ToInt32(reader["num"])); } } }
public long GetForce(DatabaseService.DatabaseLink dbLink, string game_name, int grade, string show_id) { using (var reader = dbLink.ExecuteReader("get user game info", game_name, grade, show_id)) { if (reader == null) { return(0); } if (!reader.Read()) { return(0); } return(reader.GetInt64Safe("force_value")); } }
public long GetJackpot(DatabaseService.DatabaseLink dbLink, string game_name, int grade) { using (var reader = dbLink.ExecuteReader("get game info", game_name)) { if (reader == null) { return(0); } if (!reader.Read()) { return(0); } return(reader.GetInt64Safe(string.Format("grade{0}_jackpot", grade))); } }
public int GetBigAwardCounter(DatabaseService.DatabaseLink dbLink, string game_name, int grade) { using (var reader = dbLink.ExecuteReader("get game info", game_name)) { if (reader == null) { return(0); } if (!reader.Read()) { return(0); } return(reader.GetInt32Safe(string.Format("grade{0}_bigaward_counter", grade))); } }
public JObject GetUserGameData(DatabaseService.DatabaseLink dbLink, string game_name, int grade, string show_id) { using (var reader = dbLink.ExecuteReader("get user game info", game_name, grade, show_id)) { if (reader == null) { return(null); } if (!reader.Read()) { return(null); } string jsonData = reader.GetStringSafe("data"); if (jsonData.Length == 0) { return(null); } return(JObject.Parse(jsonData)); } }
public bool EffectiveBackControl(DatabaseService.DatabaseLink dbLink, int id) { return(dbLink.ExecuteNonQuery("effective back control", DateTime.Now, id) > 0); }
public MySqlDataReader GetBackControl(DatabaseService.DatabaseLink dbLink, string cmd, string game_name, int grade) { return(dbLink.ExecuteReader("get back control", cmd, game_name, grade)); }
public MySqlDataReader GetGameInfo(DatabaseService.DatabaseLink dbLink, string game_name) { return(dbLink.ExecuteReader("get game info", game_name)); }
public bool RegGameServer(DatabaseService.DatabaseLink dbLink, string game_name, string ip_port) { return(dbLink.ExecuteNonQuery("reg game server", game_name, ip_port) > 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 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 SetUserMoney(DatabaseService.DatabaseLink dbLink, long money, string show_id) { return(dbLink.ExecuteNonQuery("set user money", money, show_id) > 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 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 SetJackpot(DatabaseService.DatabaseLink dbLink, string game_name, int grade, long jackpot) { return(dbLink.ExecuteNonQuery("set game jackpot " + grade, jackpot, game_name) > 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 SetStore(DatabaseService.DatabaseLink dbLink, string game_name, int grade, long store) { return(dbLink.ExecuteNonQuery("set game store " + grade, store, game_name) > 0); }
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 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 MySqlDataReader GetUserBaseInfo(DatabaseService.DatabaseLink dbLink, string show_id) { return(dbLink.ExecuteReader("get user base info", show_id)); }
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); }