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);
}
