private static DataSet GetData(MySqlCommand cmd, int state)
{
using (var conn = new MySqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["COUNCILDB"].ConnectionString)) {
conn.Open();
using (MySqlDataAdapter msda = new MySqlDataAdapter()) {
cmd.Connection = conn;
msda.SelectCommand = cmd;
using (DataSet ds = new DataSet()) {
msda.Fill(ds, "Petition");
DataTable dt = new DataTable("PageCount");
dt.Columns.Add("PageCount");
dt.Rows.Add();
int petitionsCount = PetitionManager.GetPetitionsCount(state);
dt.Rows[0][0] = petitionsCount % 5 == 0 ? petitionsCount / elementCount : petitionsCount / elementCount + 1;
ds.Tables.Add(dt);
conn.Close();
return(ds);
}
}
}
}
protected void AllowButton_Click(object sender, EventArgs e)
{
AllowButton.Enabled = false;
PetitionManager.PetitionCheck(int.Parse(Request.QueryString["id"]), 1);
AllowButton.Enabled = true;
Response.Redirect("/admin/PetitionManagement.aspx");
}
protected void AgreeButton_Click(object sender, EventArgs e)
{
AgreeButton.Enabled = false;
if (Session["UserID"] != null)
{
PetitionManager.AgreePetition(int.Parse(Request.QueryString["id"]), (string)Session["UserID"]);
Response.Redirect(Request.RawUrl);
}
else
{
Response.Redirect("/Login.aspx?classification=1&id=" + Request.QueryString["id"]);
}
}
protected void AnswerButton_Click(object sender, EventArgs e)
{
AnswerButton.Enabled = false;
if (string.IsNullOrEmpty(AnswerContent.Text.Trim()))
{
Response.Write("<script>alert('답변 내용을 입력해주세요.')</script>");
}
else
{
PetitionManager.AddAnswer(int.Parse(Request.QueryString["id"]), AnswerContent.Text);
Response.Redirect("/admin/PetitionManagement.aspx?state=awaitingAnswer");
}
AnswerButton.Enabled = true;
}
public override void RunImpl()
{
L2Player player = _client.CurrentPlayer;
if (player.PBlockAct == 1)
{
player.SendActionFailed();
return;
}
L2Npc npc;
L2Warehouse warehouseNPC;
if (_alias.EqualsIgnoreCase("teleport_request"))
{
npc = GetNpc();
if (npc == null)
{
player.SendActionFailed();
return;
}
npc.OnTeleportRequest(player);
}
else
{
if (_alias.StartsWithIgnoreCase("menu_select?"))
{
npc = GetNpc();
_alias = _alias.Replace(" ", string.Empty);
string x1 = _alias.Split('?')[1];
string[] x2 = x1.Split('&');
int ask = int.Parse(x2[0].Substring(4));
int reply;
try
{
reply = int.Parse(x2[1].Substring(6));
}
catch
{
reply = 0;
}
npc.OnDialog(player, ask, reply);
}
else
{
if (_alias.EqualsIgnoreCase("talk_select"))
{
npc = GetNpc();
//QuestManager.Instance.TalkSelection(player, npc);
}
else
{
if (_alias.StartsWithIgnoreCase("quest_accept?"))
{
npc = GetNpc();
_alias = _alias.Replace(" ", string.Empty);
string x1 = _alias.Split('?')[1];
int qid = int.Parse(x1.Split('=')[1]);
//QuestManager.Instance.QuestAccept(player, npc, qid);
}
else
{
if (_alias.StartsWithIgnoreCase("quest_continue?"))
{
npc = GetNpc();
_alias = _alias.Replace(" ", string.Empty);
string x1 = _alias.Split('?')[1];
int qid = int.Parse(x1.Split('=')[1]);
//QuestManager.Instance.Quest_continue(player, npc, qid);
}
else
{
if (_alias.StartsWithIgnoreCase("quest_tryaccept?"))
{
npc = GetNpc();
_alias = _alias.Replace(" ", string.Empty);
string x1 = _alias.Split('?')[1];
int qid = int.Parse(x1.Split('=')[1]);
// QuestManager.Instance.Quest_tryaccept(player, npc, qid);
}
else
{
if (_alias.Contains("DepositP"))
{
warehouseNPC = GetWarehouseNPC();
warehouseNPC.ShowPrivateWarehouse(player);
return;
}
else
{
if (_alias.Contains("WithdrawP"))
{
warehouseNPC = GetWarehouseNPC();
warehouseNPC.ShowPrivateWarehouseBack(player);
return;
}
else
{
if (_alias.Contains("DepositC"))
{
warehouseNPC = GetWarehouseNPC();
warehouseNPC.ShowClanWarehouse(player);
return;
}
else
{
if (_alias.Contains("WithdrawC"))
{
warehouseNPC = GetWarehouseNPC();
warehouseNPC.ShowClanWarehouseBack(player);
return;
}
else
{
if (_alias.EqualsIgnoreCase("learn_skill"))
{
npc = GetNpc();
npc.ShowSkillLearn(player, false);
}
else
{
if (_alias.StartsWithIgnoreCase("create_pledge?"))
{
npc = GetNpc();
//bypass -h create_pledge?pledge_name= $pledge_name
string x1 = _alias.Split('?')[1];
string name = x1.Split('=')[1];
name = name.Substring(1);
// GrandmasterTotal.CreateClan(player, name, npc);
}
else
{
if (_alias.StartsWithIgnoreCase("teleport_next?"))
{
npc = GetNpc();
string x1 = _alias.Split('?')[1];
string[] x2 = x1.Split('&');
int ask = int.Parse(x2[0].Substring(4));
int reply = int.Parse(x2[1].Substring(6));
npc.UseTeleporter(player, ask, reply);
}
else
{
if (_alias.StartsWithIgnoreCase("npc"))
{
npc = GetNpc();
Log.Warn($"Bypass Accepted '{_alias}'");
}
else
{
if (_alias.StartsWithIgnoreCase("petitionlink?"))
{
PetitionManager.GetInstance().Petitionlink(player, _alias.Split('?')[1]);
}
else
{
Log.Warn($"Unknown bypass '{_alias}'");
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
public override void run()
{
L2Player player = getClient().CurrentPlayer;
if (player._p_block_act == 1)
{
player.sendActionFailed();
return;
}
L2Citizen npc;
if (_alias.Equals("teleport_request"))
{
npc = getNpc();
if (npc == null)
{
player.sendActionFailed();
return;
}
npc.onTeleportRequest(player);
}
else if (_alias.StartsWith("menu_select?"))
{
npc = getNpc();
_alias = _alias.Replace(" ", "");
string x1 = _alias.Split('?')[1];
string[] x2 = x1.Split('&');
int ask = int.Parse(x2[0].Substring(4));
int reply;
try
{
reply = int.Parse(x2[1].Substring(6));
}
catch
{
reply = 0;
}
npc.onDialog(player, ask, reply);
}
else if (_alias.Equals("talk_select"))
{
npc = getNpc();
QuestManager.getInstance().talkSelection(player, npc);
}
else if (_alias.StartsWith("quest_accept?"))
{
npc = getNpc();
_alias = _alias.Replace(" ", "");
string x1 = _alias.Split('?')[1];
int qid = int.Parse(x1.Split('=')[1]);
QuestManager.getInstance().questAccept(player, npc, qid);
}
else if (_alias.StartsWith("quest_continue?"))
{
npc = getNpc();
_alias = _alias.Replace(" ", "");
string x1 = _alias.Split('?')[1];
int qid = int.Parse(x1.Split('=')[1]);
QuestManager.getInstance().quest_continue(player, npc, qid);
}
else if (_alias.StartsWith("quest_tryaccept?"))
{
npc = getNpc();
_alias = _alias.Replace(" ", "");
string x1 = _alias.Split('?')[1];
int qid = int.Parse(x1.Split('=')[1]);
QuestManager.getInstance().quest_tryaccept(player, npc, qid);
}
else if (_alias.Equals("deposit"))
{
npc = getNpc();
npc.showPrivateWarehouse(player);
}
else if (_alias.Equals("withdraw"))
{
npc = getNpc();
npc.showPrivateWarehouseBack(player);
}
else if (_alias.Equals("deposit_pledge"))
{
npc = getNpc();
npc.showClanWarehouse(player);
}
else if (_alias.Equals("withdraw_pledge"))
{
npc = getNpc();
npc.showClanWarehouseBack(player);
}
else if (_alias.Equals("learn_skill"))
{
npc = getNpc();
npc.showSkillLearn(player, false);
}
else if (_alias.StartsWith("create_pledge?"))
{
npc = getNpc();
//bypass -h create_pledge?pledge_name= $pledge_name
string x1 = _alias.Split('?')[1];
string name = x1.Split('=')[1];
name = name.Substring(1);
grandmaster_total.createClan(player, name, npc);
}
else if (_alias.StartsWith("teleport_next?"))
{
npc = getNpc();
string x1 = _alias.Split('?')[1];
string[] x2 = x1.Split('&');
int ask = int.Parse(x2[0].Substring(4));
int reply = int.Parse(x2[1].Substring(6));
npc.UseTeleporter(player, ask, reply);
}
else if (_alias.StartsWith("petitionlink?"))
{
PetitionManager.getInstance().petitionlink(player, _alias.Split('?')[1]);
}
else if (_alias.StartsWith("_mr"))
{
npc = getNpc();
MonsterRace.Instance.OnBypass(player, npc, _alias);
}
else
{
CLogger.warning("Unknown bypass '" + _alias + "'");
}
}
