public static void smethod_4() { int num = 0; Form1.WriteLine(100, "删除帮派数据开始"); DataTable dBToDataTable = DBA.GetDBToDataTable(string.Format("select * from TBL_XWWL_GuildMember", new object[0])); if (dBToDataTable != null) { Form1.WriteLine(100, string.Concat("共有帮派数据", dBToDataTable.Rows.Count)); for (int i = 0; i < dBToDataTable.Rows.Count; i++) { DataTable dataTable = DBA.GetDBToDataTable(string.Format("select * from TBL_XWWL_Char where FLD_NAME='{0}'", dBToDataTable.Rows[i]["Name"])); if (dataTable.Rows.Count < 1) { num++; if (dBToDataTable.Rows[0]["leve"].ToString() != "6") { Form1.WriteLine(100, string.Concat(new object[] { "删除帮派", dBToDataTable.Rows[i]["G_Name"], " ", dBToDataTable.Rows[i]["Name"].ToString() })); DBA.ExeSqlCommand(string.Format("DELETE FROM TBL_XWWL_GuildMember WHERE Name ='{0}'", dBToDataTable.Rows[i]["Name"].ToString())); } else { Form1.WriteLine(100, string.Concat("删除帮派", dBToDataTable.Rows[i]["G_Name"])); DBA.ExeSqlCommand(string.Format("DELETE FROM TBL_XWWL_Guild WHERE G_Name ='{0}'", dBToDataTable.Rows[0]["G_Name"].ToString())); DBA.ExeSqlCommand(string.Format("DELETE FROM TBL_XWWL_GuildMember WHERE G_Name ='{0}'", dBToDataTable.Rows[0]["G_Name"].ToString())); } } dataTable.Dispose(); } dBToDataTable.Dispose(); } Form1.WriteLine(100, string.Concat("删除帮派数据完成", num)); }
public static void smethod_1() { int num = 0; Form1.WriteLine(100, "删除人物仓库数据开始"); DataTable dBToDataTable = DBA.GetDBToDataTable(string.Format("select * from TBL_XWWL_warehouse", new object[0])); if (dBToDataTable != null) { Form1.WriteLine(100, string.Concat("共有人物数据", dBToDataTable.Rows.Count)); for (int i = 0; i < dBToDataTable.Rows.Count; i++) { DataTable dataTable = DBA.GetDBToDataTable(string.Format("select * from TBL_XWWL_Char where FLD_NAME='{0}'", dBToDataTable.Rows[i]["FLD_NAME"])); if (dataTable.Rows.Count < 1) { num++; Form1.WriteLine(100, string.Concat(new object[] { "删除人物仓库[", dBToDataTable.Rows[i]["FLD_ID"].ToString(), "] [", dBToDataTable.Rows[i]["FLD_NAME"], "]" })); DBA.ExeSqlCommand(string.Format("DELETE FROM TBL_XWWL_warehouse WHERE FLD_ID='{0}'and FLD_NAME ='{1}'", dBToDataTable.Rows[i]["FLD_ID"].ToString(), dBToDataTable.Rows[i]["FLD_NAME"].ToString())); } else if (dataTable.Rows[0]["FLD_ID"].ToString() != dBToDataTable.Rows[i]["FLD_ID"].ToString()) { num++; Form1.WriteLine(100, string.Concat(new object[] { "删除人物仓库[", dBToDataTable.Rows[i]["FLD_ID"].ToString(), "] [", dBToDataTable.Rows[i]["FLD_NAME"], "]" })); DBA.ExeSqlCommand(string.Format("DELETE FROM TBL_XWWL_warehouse WHERE FLD_ID='{0}'and FLD_NAME ='{1}'", dBToDataTable.Rows[i]["FLD_ID"].ToString(), dBToDataTable.Rows[i]["FLD_NAME"].ToString())); } dataTable.Dispose(); } dBToDataTable.Dispose(); } Form1.WriteLine(100, string.Concat("删除人物仓库数据完成", num)); }
public static void UpItemsDate(string ServerId, string UserName, byte[] Itmes, string SelectDb) { string str = "TBL_XWWL_Char"; string str2 = "FLD_ITEM"; string str3 = "FLD_NAME"; if (SelectDb == "0") { str = "TBL_XWWL_Char"; str2 = "FLD_ITEM"; str3 = "FLD_NAME"; } else if (SelectDb == "1") { str = "TBL_XWWL_Char"; str2 = "FLD_WEARITEM"; str3 = "FLD_NAME"; } else if (SelectDb == "2") { str = "TBL_XWWL_Warehouse"; str2 = "FLD_ITEM"; str3 = "FLD_NAME"; } else if (SelectDb == "3") { str = "TBL_XWWL_PublicWarehouse"; str2 = "FLD_ITEM"; str3 = "FLD_ID"; } DBA.ExeSqlCommand(string.Format("update {0} set {1}=0x{2} WHERE {3} ='{4}'", str, str2, ToString(Itmes), str3, UserName), "rxjhgame", ServerId); }
public static void DELETE_BANG_CHIEN_DAT_CUOC_DATA(string string_0, string string_1, int int_0, int int_1) { DBA.ExeSqlCommand(string.Format("DELETE FROM BANG_CHIEN_TIEN_DAT_CUOC WHERE UserId = '{0}' and UserName='******' and UserName='******'", string_0, string_1, int_0)); if (int_1 == 1) { DBA.ExeSqlCommand(string.Format("UPDATE TBL_XWWL_Guild SET Thang=Thang+1 WHERE ID='{0}'", int_0)); RxjhClass.INSERT_BACH_BAO_GHI_CHEP(string_0, string_1, 0, "Bang chien thang loi duoc", 1, 50); return; } if (int_1 != -1) { if (int_1 == 0) { DBA.ExeSqlCommand(string.Format("UPDATE TBL_XWWL_Guild SET Hoa=Hoa+1 WHERE ID='{0}'", int_0)); } return; } DBA.ExeSqlCommand(string.Format("UPDATE TBL_XWWL_Guild SET Bai=Bai+1 WHERE ID='{0}'", int_0)); RxjhClass.INSERT_BACH_BAO_GHI_CHEP(string_0, string_1, 0, "Bang chien that bai thua tran", 1, 50); }
public static void smethod_2() { int num = 0; Form1.WriteLine(100, "删除宗合仓库开始"); DataTable dBToDataTable = DBA.GetDBToDataTable(string.Format("select * from TBL_XWWL_PublicWarehouse", new object[0])); if (dBToDataTable != null) { Form1.WriteLine(100, string.Concat("共有宗合仓库数据", dBToDataTable.Rows.Count)); for (int i = 0; i < dBToDataTable.Rows.Count; i++) { string.Format("select count(*) from TBL_ACCOUNT where FLD_ID='{0}'", dBToDataTable.Rows[i]["FLD_ID"]); num++; Form1.WriteLine(100, string.Concat("删除宗合仓库[", dBToDataTable.Rows[i]["FLD_ID"].ToString(), "]")); DBA.ExeSqlCommand(string.Format("DELETE FROM TBL_XWWL_PublicWarehouse WHERE FLD_ID ='{0}'", dBToDataTable.Rows[i]["FLD_ID"].ToString())); } dBToDataTable.Dispose(); } Form1.WriteLine(100, string.Concat("删除宗合仓库完成", num)); }
public static void Update_Mon_Huy(int int_0, byte[] byte_0) { DBA.ExeSqlCommand(string.Format("UPDATE TBL_XWWL_Guild SET Mon_huy={1} WHERE ID='{0}'", int_0, Converter.smethod_25(byte_0))); }
public static void UPDATE_GUILD_TRANG_PHUC(int int_0, int int_1, int int_2) { DBA.ExeSqlCommand(string.Format("UPDATE TBL_XWWL_Guild SET Mon_trang_phuc_tu={1},Mon_trang_phuc_mau_sac={2} WHERE ID='{0}'", int_0, int_1, int_2)); }
public static void INSERT_MsgLog(string string_0, string string_1, string string_2, string string_3, int int_0) { DBA.ExeSqlCommand(string.Format("INSERT INTO MsgLog (userid,username,ToUserName,msg,msgType) VALUES ('{0}','{1}','{2}','{3}',{4})", new object[] { string_0, string_1, string_2, string_3, int_0 })); }
public static void INSERT_BANG_CHIEN_TIEN_DAT_CUOC(string string_0, string string_1, int int_0, int int_1) { DBA.ExeSqlCommand(string.Format("INSERT INTO BANG_CHIEN_TIEN_DAT_CUOC (UserId,UserName,Bang_phai_ID,So_luong_cash) VALUES ('{0}','{1}',{2},{3})", new object[] { string_0, string_1, int_0, int_1 })); }
public static void INSERT_BACH_BAO_GHI_CHEP_2(string string_0, string string_1, double double_0, string string_2, int int_0, long long_0) { DBA.ExeSqlCommand(string.Format("INSERT INTO BACH_BAO_GHI_CHEP (UserId,UserName,Item_ID,Item_ten,Item_so_luong,So_luong_cash) VALUES ('{0}','{1}','{2}','{3}',{4},{5})", new object[] { string_0, string_1, double_0, string_2, int_0, long_0 })); }
public static void SetLog(string userid, string username, string itmename, string serverid, int sl, int POINT) { object[] objArray = new object[] { userid, username, itmename, serverid, sl, POINT }; DBA.ExeSqlCommand(string.Format("INSERT INTO BBGLog (userid,username,itmename,serverid,sl,POINT)values('{0}','{1}','{2}','{3}',{4},{5})", objArray)); }
public void THOI_GIAN_KET_THUC_SU_KIEN3(object sender, ElapsedEventArgs e) { DateTime now; if (World.jlMsg == 1) { Form1.WriteLine(0, "EventClass_THOI_GIAN_KET_THUC_SU_KIEN3"); } try { DBA.ExeSqlCommand(string.Concat("DELETE FROM EventTop where PHAN_KHU_TIN_TUC='", World.Phan_khu_danh_so, "'")); foreach (EventTopClass value in World.EventTop.Values) { DBA.ExeSqlCommand(string.Format("INSERT INTO EventTop (NHAN_VAT_TEN,BANG_PHAI,THE_LUC,DANG_CAP,GIET_NGUOI_SO,TU_VONG_SO,PHAN_KHU_TIN_TUC)values('{0}','{1}','{2}',{3},{4},{5},'{6}')", new object[] { value.string_0, value.string_1, value.THE_LUC, value.int_0, value.Kills, value.Dead, World.Phan_khu_danh_so })); } string empty = string.Empty; World.EventTop.Clear(); if (World.THE_LUC_CHIEN_2_CHINH_PHAI_DIEM_SO > World.THE_LUC_CHIEN_2_TA_PHAI_DIEM_SO) { this.THE_LUC_CHIEN_sj = 1; World.SendMsg("Death loss of っ leave Iraq by Nan Yi Yi づ cut Bru village: the ignorant column"); } else if (World.THE_LUC_CHIEN_2_CHINH_PHAI_DIEM_SO != World.THE_LUC_CHIEN_2_TA_PHAI_DIEM_SO) { this.THE_LUC_CHIEN_sj = 2; World.SendMsg("Death loss of っ Iraqi borrow clothes づ Yijianangua Bru village: through sister bright"); } else { this.THE_LUC_CHIEN_sj = 3; World.SendMsg("Death loss of っ Iraqi borrow clothes づ Yijianangua Bru village: Suo Restraints"); } foreach (Players player in World.allConnectedChars.Values) { if (player.CharacterCoords_Map == 801) { player.GUI_DI_THE_LUC_CHIEN_KET_THUC_TIN_TUC(this.THE_LUC_CHIEN_sj); if (player.Player_Zx == this.THE_LUC_CHIEN_sj) { if (World.The_luc_chien_khen_thuong_Loai_hinh == 1) { string[] strArrays = World.The_luc_chien_khen_thuong_Thuoc_tinh.Split(new char[] { ';' }); string[] strArrays1 = World.Thang_cap_thanh_vien_can_Thuoc_tinh.Split(new char[] { ',' }); if (int.Parse(strArrays[0]) != 0) { Players khenThuongThemVaoSinhMenh = player; khenThuongThemVaoSinhMenh.Khen_thuong_them_vao_sinh_menh = khenThuongThemVaoSinhMenh.Khen_thuong_them_vao_sinh_menh + long.Parse(strArrays[0]); player.GameMessage(string.Concat("life", long.Parse(strArrays[0])), 10, "Forces battle reward"); } if (long.Parse(strArrays[1]) != 0 && player.Khen_thuong_them_vao_cong_kich < long.Parse(strArrays1[0])) { Players khenThuongThemVaoCongKich = player; khenThuongThemVaoCongKich.Khen_thuong_them_vao_cong_kich = khenThuongThemVaoCongKich.Khen_thuong_them_vao_cong_kich + long.Parse(strArrays[1]); player.GameMessage(string.Concat("attack", long.Parse(strArrays[1])), 10, "Forces battle reward"); } if (long.Parse(strArrays[2]) != 0 && player.Khen_thuong_them_vao_phong_ngu < long.Parse(strArrays1[1])) { Players khenThuongThemVaoPhongNgu = player; khenThuongThemVaoPhongNgu.Khen_thuong_them_vao_phong_ngu = khenThuongThemVaoPhongNgu.Khen_thuong_them_vao_phong_ngu + long.Parse(strArrays[2]); player.GameMessage(string.Concat("defense", long.Parse(strArrays[2])), 10, "Forces battle reward"); } if (int.Parse(strArrays[3]) != 0) { Players khenThuongThemVaoNeTranh = player; khenThuongThemVaoNeTranh.Khen_thuong_them_vao_ne_tranh = khenThuongThemVaoNeTranh.Khen_thuong_them_vao_ne_tranh + int.Parse(strArrays[3]); player.GameMessage(string.Concat("avoid", int.Parse(strArrays[3])), 10, "Forces battle reward"); } if (int.Parse(strArrays[4]) != 0) { Players khenThuongThemVaoNoiCong = player; khenThuongThemVaoNoiCong.Khen_thuong_them_vao_noi_cong = khenThuongThemVaoNoiCong.Khen_thuong_them_vao_noi_cong + int.Parse(strArrays[4]); player.GameMessage(string.Concat("Neigong", int.Parse(strArrays[4])), 10, "Forces battle reward"); } if (int.Parse(strArrays[5]) != 0) { Players khenThuongThemVaoTrungMucTieu = player; khenThuongThemVaoTrungMucTieu.Khen_thuong_them_vao_trung_muc_tieu = khenThuongThemVaoTrungMucTieu.Khen_thuong_them_vao_trung_muc_tieu + int.Parse(strArrays[5]); player.GameMessage(string.Concat("Hit", int.Parse(strArrays[5])), 10, "Forces battle reward"); } if (int.Parse(strArrays[6]) != 0 && player.FLD_RXPIONT != World.Nhan_vat_lon_nhat_CASH_so_luong) { player.KIEM_TRA_BACH_BAO_CAC_NGUYEN_BAO_SO_LUONG(); player.KIEM_SOAT_CASH_SO_LIEU(int.Parse(strArrays[6]), 1); player.GameMessage(string.Concat("Get", int.Parse(strArrays[6]), "Ingot!"), 10, "Forces battle reward"); player.UPDATE_RXPIONT(); } if (int.Parse(strArrays[7]) != 0) { Players playerWuXun = player; playerWuXun.Player_WuXun = playerWuXun.Player_WuXun + int.Parse(strArrays[7]); player.GameMessage(string.Concat("Nhan duoc diem vo huan: ", int.Parse(strArrays[7])), 10, World.ServerName); player.UpdatePowersAndStatus(); } if (int.Parse(strArrays[8]) != 0) { DateTime dateTime = DateTime.Now; now = DateTime.Now; dateTime = now.AddDays((double)int.Parse(strArrays[8])); player.FLD_VIP = 1; player.FLD_VIPTIM = dateTime; player.LUU_THANH_VIEN_SO_LIEU(); player.GameMessage(string.Concat("Congratulations, you get", int.Parse(strArrays[8]), "Day membership, please check the small back!"), 10, "Reward fighting forces"); } } else if (World.The_luc_chien_khen_thuong_Loai_hinh == 2) { int num = player.DUOC_KIEN_HANG_RONG(player); if (num == -1) { player.GameMessage("Please leave by empty backpack, send have AK IT!", 10, "Reward fighting forces"); return; } else { byte[] bytes = BitConverter.GetBytes(RxjhClass.GetDBItmeId()); byte[] numArray = new byte[56]; player.TANG_CUONG_VAT_PHAM_1(bytes, BitConverter.GetBytes(World.The_luc_chien_khen_thuong_trang_phuc), num, BitConverter.GetBytes(1), numArray, false); player.GameMessage("Congratulations, you get a package, please check!", 10, "Reward fighting forces"); } } else if (World.The_luc_chien_khen_thuong_Loai_hinh == 3) { string[] strArrays2 = World.The_luc_chien_khen_thuong_Item.Split(new char[] { ';' }); int num1 = player.DUOC_KIEN_HANG_RONG(player); if (num1 == -1) { player.GameMessage("Please leave an empty backpack, send you a mysterious gift Oh!", 10, "Reward fighting forces"); return; } else { player.BACH_BAO_TANG_CUONG_ITEM_MANG_THUOC_TINH(int.Parse(strArrays2[0]), num1, int.Parse(strArrays2[1]), int.Parse(strArrays2[2]), int.Parse(strArrays2[3]), int.Parse(strArrays2[4]), int.Parse(strArrays2[5]), int.Parse(strArrays2[6]), int.Parse(strArrays2[7]), int.Parse(strArrays2[8]), int.Parse(strArrays2[9]), int.Parse(strArrays2[10]), int.Parse(strArrays2[11])); player.GameMessage("Congratulations, you get a system of reward items, please check!", 10, "Reward fighting forces"); } } } } player.SendCountdown(5, 2, 0); } World.THE_LUC_CHIEN_2_TIEN_TRINH = 5; now = DateTime.Now; this.kssjgj = now.AddMinutes(30); this.THOI_GIAN_3.Enabled = false; this.THOI_GIAN_3.Close(); this.THOI_GIAN_3.Dispose(); this.THOI_GIAN_4 = new System.Timers.Timer(60000); this.THOI_GIAN_4.Elapsed += new ElapsedEventHandler(this.THOI_GIAN_KET_THUC_SU_KIEN4); this.THOI_GIAN_4.Enabled = true; this.THOI_GIAN_4.AutoReset = true; this.THOI_GIAN_5 = new System.Timers.Timer(60000); this.THOI_GIAN_5.Elapsed += new ElapsedEventHandler(this.THOI_GIAN_KET_THUC_SU_KIEN5); this.THOI_GIAN_5.Enabled = true; this.THOI_GIAN_5.AutoReset = true; } catch (Exception exception) { Form1.WriteLine(1, string.Concat("势力战 THOI_GIAN_KET_THUC_SU_KIEN3 出错:", exception)); } }