示例#1
0
        private void ParseGossipOptionData(GossipMenuOption GossipMenu)
        {
            _tbGossipMenuID.Text     = GossipMenu.menu_id.ToString();
            _tbGossipID.Text         = GossipMenu.id.ToString();
            _tbGossipOptionText.Text = GossipMenu.option_text;
            _tbGossipNpcMenu.Text    = GossipMenu.npc_menu_id.ToString();
            _tbGossipPOI_id.Text     = GossipMenu.action_poi_id.ToString();
            _tbGossipAction.Text     = GossipMenu.action_script_id.ToString();
            _tbGossipBoxCoded.Text   = GossipMenu.box_coded.ToString();
            _tbGossipBoxMoney.Text   = GossipMenu.box_money.ToString();
            _tbGossipBoxText.Text    = GossipMenu.box_text;

            _cbGossipOptionIcon.SelectedValue    = GossipMenu.option_icon;
            _cbGossipOptionID.SelectedValue      = GossipMenu.option_id;
            _cbGossipOptionNpcFlag.SelectedValue = GossipMenu.npc_option_npcflag;

            _cbGossipOptionCondtion_1.SelectedValue = GossipMenu.cond[0];
            _cbOptionCondtion1Value_1.SetValue(GossipMenu.cond_val[0, 0]);
            _cbOptionCondtion1Value_2.SetValue(GossipMenu.cond_val[0, 1]);
            _cbGossipOptionCondtion_2.SelectedValue = GossipMenu.cond[1];
            _cbOptionCondtion2Value_1.SetValue(GossipMenu.cond_val[1, 0]);
            _cbOptionCondtion2Value_2.SetValue(GossipMenu.cond_val[1, 1]);
            _cbGossipOptionCondtion_3.SelectedValue = GossipMenu.cond[2];
            _cbOptionCondtion3Value_1.SetValue(GossipMenu.cond_val[2, 0]);
            _cbOptionCondtion3Value_2.SetValue(GossipMenu.cond_val[2, 1]);
        }
示例#2
0
        private void _bGossipOptionCreate_Click(object sender, EventArgs e)
        {
            rtbGossipOptionMenuOut.Clear();
            rtbGossipOptionMenuOut.ForeColor = Color.Blue;

            GossipMenuOption gossip = new GossipMenuOption();

            gossip.menu_id            = _tbGossipMenuID.Text.ToInt32();
            gossip.id                 = _tbGossipID.Text.ToInt32();
            gossip.option_text        = _tbGossipOptionText.Text;
            gossip.npc_menu_id        = _tbGossipNpcMenu.Text.ToInt32();
            gossip.action_poi_id      = _tbGossipPOI_id.Text.ToInt32();
            gossip.action_script_id   = _tbGossipAction.Text.ToInt32();
            gossip.box_coded          = _tbGossipBoxCoded.Text.ToInt32();
            gossip.box_money          = _tbGossipBoxMoney.Text.ToInt32();
            gossip.box_text           = _tbGossipBoxText.Text;
            gossip.option_icon        = _cbGossipOptionIcon.GetIntValue();
            gossip.option_id          = _cbGossipOptionID.GetIntValue();
            gossip.npc_option_npcflag = _cbGossipOptionNpcFlag.GetIntValue();
            gossip.cond[0]            = _cbGossipOptionCondtion_1.GetIntValue();
            gossip.cond_val[0, 0]     = _cbGossipOptionCondtion_1.GetIntValue();
            gossip.cond_val[0, 1]     = _cbOptionCondtion1Value_2.GetIntValue();
            gossip.cond[1]            = _cbGossipOptionCondtion_2.GetIntValue();
            gossip.cond_val[1, 0]     = _cbOptionCondtion2Value_1.GetIntValue();
            gossip.cond_val[1, 1]     = _cbOptionCondtion2Value_2.GetIntValue();
            gossip.cond[2]            = _cbGossipOptionCondtion_3.GetIntValue();
            gossip.cond_val[2, 0]     = _cbOptionCondtion3Value_1.GetIntValue();
            gossip.cond_val[2, 1]     = _cbOptionCondtion3Value_2.GetIntValue();

            StringBuilder sb = new StringBuilder();

            sb.AppendFormatLine("DELETE FROM `gossip_menu_option` WHERE `entry`='{0}' AND `id`='{1}';", gossip.menu_id, gossip.id);
            sb.AppendFormatLine("INSERT INTO `gossip_menu_option` VALUES ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', '{8}'," +
                                "'{9}', '{10}', '{11}', '{12}', '{13}', '{15}', '{16}', '{17}', '{18}', '{19}', '{20}');"
                                , gossip.menu_id, gossip.id, gossip.option_icon, gossip.option_text.RemExc(), gossip.option_id, gossip.npc_option_npcflag, gossip.npc_menu_id
                                , gossip.action_poi_id, gossip.action_script_id, gossip.box_coded, gossip.box_money, gossip.box_text, gossip.cond[0], gossip.cond_val[0, 0]
                                , gossip.cond_val[0, 1], gossip.cond[1], gossip.cond_val[1, 0], gossip.cond_val[1, 1], gossip.cond[2], gossip.cond_val[2, 0], gossip.cond_val[2, 1]);

            rtbGossipOptionMenuOut.Text = sb.ToString();
        }
示例#3
0
        public static void SelectGossipOption(int MenuID)
        {
            if (!IsConnected)
            {
                System.Windows.Forms.MessageBox.Show("No connection to database, please check settings", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                return;
            }

            string query;

            if (MenuID > 0)
            {
                query = "SELECT * FROM gossip_menu_option WHERE menu_id=" + MenuID;
            }
            else
            {
                query = "SELECT * FROM gossip_menu_option";
            }

            using (_conn = new MySqlConnection(ConnectionString))
            {
                _command = new MySqlCommand(query, _conn);
                _conn.Open();
                _GossipMenuOption.Clear();

                using (var reader = _command.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        GossipMenuOption GossipOption = new GossipMenuOption();

                        GossipOption.menu_id            = reader[0].ToInt32();
                        GossipOption.id                 = reader[1].ToInt32();
                        GossipOption.option_icon        = reader[2].ToInt32();
                        GossipOption.option_text        = reader[3].ToString();
                        GossipOption.option_id          = reader[4].ToInt32();
                        GossipOption.npc_option_npcflag = reader[5].ToInt32();
                        GossipOption.npc_menu_id        = reader[6].ToInt32();
                        GossipOption.action_poi_id      = reader[7].ToInt32();
                        GossipOption.action_script_id   = reader[8].ToInt32();
                        GossipOption.box_coded          = reader[9].ToInt32();
                        GossipOption.box_money          = reader[10].ToInt32();
                        GossipOption.box_text           = reader[11].ToString();

                        GossipOption.cond[0]        = reader[12].ToInt32();
                        GossipOption.cond_val[0, 0] = reader[13].ToInt32();
                        GossipOption.cond_val[0, 1] = reader[14].ToInt32();

                        GossipOption.cond[1]        = reader[15].ToInt32();
                        GossipOption.cond_val[1, 0] = reader[16].ToInt32();
                        GossipOption.cond_val[1, 1] = reader[17].ToInt32();

                        GossipOption.cond[2]        = reader[18].ToInt32();
                        GossipOption.cond_val[2, 0] = reader[19].ToInt32();
                        GossipOption.cond_val[2, 1] = reader[20].ToInt32();

                        _GossipMenuOption.Add(GossipOption);
                    }
                }

                _conn.Close();
            }
        }
示例#4
0
        private void _bGossipOptionCreate_Click(object sender, EventArgs e)
        {
            rtbGossipOptionMenuOut.Clear();
            rtbGossipOptionMenuOut.ForeColor = Color.Blue;

            GossipMenuOption gossip = new GossipMenuOption();
            gossip.menu_id  = _tbGossipMenuID.Text.ToInt32();
            gossip.id = _tbGossipID.Text.ToInt32();
            gossip.option_text = _tbGossipOptionText.Text;
            gossip.npc_menu_id = _tbGossipNpcMenu.Text.ToInt32();
            gossip.action_poi_id = _tbGossipPOI_id.Text.ToInt32();
            gossip.action_script_id = _tbGossipAction.Text.ToInt32();
            gossip.box_coded = _tbGossipBoxCoded.Text.ToInt32();
            gossip.box_money = _tbGossipBoxMoney.Text.ToInt32();
            gossip.box_text = _tbGossipBoxText.Text;
            gossip.option_icon = _cbGossipOptionIcon.GetIntValue();
            gossip.option_id = _cbGossipOptionID.GetIntValue();
            gossip.npc_option_npcflag = _cbGossipOptionNpcFlag.GetIntValue();
            gossip.cond[0] = _cbGossipOptionCondtion_1.GetIntValue();
            gossip.cond_val[0, 0] = _cbGossipOptionCondtion_1.GetIntValue();
            gossip.cond_val[0, 1] = _cbOptionCondtion1Value_2.GetIntValue();
            gossip.cond[1] = _cbGossipOptionCondtion_2.GetIntValue();
            gossip.cond_val[1, 0] = _cbOptionCondtion2Value_1.GetIntValue();
            gossip.cond_val[1, 1] = _cbOptionCondtion2Value_2.GetIntValue();
            gossip.cond[2] = _cbGossipOptionCondtion_3.GetIntValue();
            gossip.cond_val[2, 0] = _cbOptionCondtion3Value_1.GetIntValue();
            gossip.cond_val[2, 1] = _cbOptionCondtion3Value_2.GetIntValue();

            StringBuilder sb = new StringBuilder();
            sb.AppendFormatLine("DELETE FROM `gossip_menu_option` WHERE `entry`='{0}' AND `id`='{1}';", gossip.menu_id, gossip.id);
            sb.AppendFormatLine("INSERT INTO `gossip_menu_option` VALUES ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', '{8}'," +
                "'{9}', '{10}', '{11}', '{12}', '{13}', '{15}', '{16}', '{17}', '{18}', '{19}', '{20}');"
                , gossip.menu_id, gossip.id, gossip.option_icon, gossip.option_text.RemExc(), gossip.option_id, gossip.npc_option_npcflag, gossip.npc_menu_id
                , gossip.action_poi_id, gossip.action_script_id, gossip.box_coded, gossip.box_money, gossip.box_text, gossip.cond[0], gossip.cond_val[0, 0]
                , gossip.cond_val[0, 1], gossip.cond[1], gossip.cond_val[1, 0], gossip.cond_val[1, 1], gossip.cond[2], gossip.cond_val[2, 0], gossip.cond_val[2, 1]);

            rtbGossipOptionMenuOut.Text = sb.ToString();
        }
示例#5
0
        private void ParseGossipOptionData(GossipMenuOption GossipMenu)
        {
            _tbGossipMenuID.Text = GossipMenu.menu_id.ToString();
            _tbGossipID.Text = GossipMenu.id.ToString();
            _tbGossipOptionText.Text = GossipMenu.option_text;
            _tbGossipNpcMenu.Text = GossipMenu.npc_menu_id.ToString();
            _tbGossipPOI_id.Text = GossipMenu.action_poi_id.ToString();
            _tbGossipAction.Text = GossipMenu.action_script_id.ToString();
            _tbGossipBoxCoded.Text = GossipMenu.box_coded.ToString();
            _tbGossipBoxMoney.Text = GossipMenu.box_money.ToString();
            _tbGossipBoxText.Text = GossipMenu.box_text;

            _cbGossipOptionIcon.SelectedValue = GossipMenu.option_icon;
            _cbGossipOptionID.SelectedValue = GossipMenu.option_id;
            _cbGossipOptionNpcFlag.SelectedValue = GossipMenu.npc_option_npcflag;

            _cbGossipOptionCondtion_1.SelectedValue = GossipMenu.cond[0];
            _cbOptionCondtion1Value_1.SetValue(GossipMenu.cond_val[0, 0]);
            _cbOptionCondtion1Value_2.SetValue(GossipMenu.cond_val[0, 1]);
            _cbGossipOptionCondtion_2.SelectedValue = GossipMenu.cond[1];
            _cbOptionCondtion2Value_1.SetValue(GossipMenu.cond_val[1, 0]);
            _cbOptionCondtion2Value_2.SetValue(GossipMenu.cond_val[1, 1]);
            _cbGossipOptionCondtion_3.SelectedValue = GossipMenu.cond[2];
            _cbOptionCondtion3Value_1.SetValue(GossipMenu.cond_val[2, 0]);
            _cbOptionCondtion3Value_2.SetValue(GossipMenu.cond_val[2, 1]);
        }
示例#6
0
        public static void SelectGossipOption(int MenuID)
        {
            if (!IsConnected)
            {
                System.Windows.Forms.MessageBox.Show("No connection to database, please check settings", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                return;
            }

            string query;

            if (MenuID > 0)
            {
                query = "SELECT * FROM gossip_menu_option WHERE menu_id=" + MenuID;
            }
            else
            {
                query = "SELECT * FROM gossip_menu_option";
            }

            using (_conn = new MySqlConnection(ConnectionString))
            {
                _command = new MySqlCommand(query, _conn);
                _conn.Open();
                _GossipMenuOption.Clear();

                using (var reader = _command.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        GossipMenuOption GossipOption = new GossipMenuOption();

                        GossipOption.menu_id            = reader[0].ToInt32();
                        GossipOption.id                 = reader[1].ToInt32();
                        GossipOption.option_icon        = reader[2].ToInt32();
                        GossipOption.option_text        = reader[3].ToString();
                        GossipOption.option_id          = reader[4].ToInt32();
                        GossipOption.npc_option_npcflag = reader[5].ToInt32();
                        GossipOption.npc_menu_id        = reader[6].ToInt32();
                        GossipOption.action_poi_id      = reader[7].ToInt32();
                        GossipOption.action_script_id   = reader[8].ToInt32();
                        GossipOption.box_coded          = reader[9].ToInt32();
                        GossipOption.box_money          = reader[10].ToInt32();
                        GossipOption.box_text           = reader[11].ToString();

                        GossipOption.cond[0]            = reader[12].ToInt32();
                        GossipOption.cond_val[0, 0]     = reader[13].ToInt32();
                        GossipOption.cond_val[0, 1]     = reader[14].ToInt32();

                        GossipOption.cond[1]            = reader[15].ToInt32();
                        GossipOption.cond_val[1, 0]     = reader[16].ToInt32();
                        GossipOption.cond_val[1, 1]     = reader[17].ToInt32();

                        GossipOption.cond[2]            = reader[18].ToInt32();
                        GossipOption.cond_val[2, 0]     = reader[19].ToInt32();
                        GossipOption.cond_val[2, 1]     = reader[20].ToInt32();

                        _GossipMenuOption.Add(GossipOption);
                    }
                }

                _conn.Close();
            }
        }