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