Esempio n. 1
1
        public DbScriptControl(Event_dataset_script Data, Int32 ID, uint id)
        {
            InitializeComponent();

            this.Name = ID.ToString();
            eventid = ID;
            script_id = id;
            this.eventCheckbox.Text = "Event: " + ID.ToString();

            this.eventCheckbox.Checked = true;

            for (int n = 0; n < Info.ScriptCommands.GetLength(0); n++)
                this.comboBoxAction.Items.Add(Info.ScriptCommands[n, 0]);

            // set width
            comboBoxAction.DropDownWidth = DropDownWidth(comboBoxAction);
            comboBoxAction.DropDownStyle = ComboBoxStyle.DropDownList;

            this.comboBoxAction.SelectedIndex = Data.command;
            this.textBoxDelay.Text = Data.delay.ToString();

            this.textBox_datalong.Text = Data.datalong.ToString();
            this.textBox_datalong2.Text = Data.datalong2.ToString();

            this.textBox_buddy.Text = Data.buddy.ToString();
            this.textBox_radius.Text = Data.radius.ToString();
            this.textBox_flags.Text = Data.dataflags.ToString();

            this.textBox_dataint1.Text = Data.dataint.ToString();
            this.textBox_dataint2.Text = Data.dataint2.ToString();
            this.textBox_dataint3.Text = Data.dataint3.ToString();
            this.textBox_dataint4.Text = Data.dataint4.ToString();

            this.textBox_posX.Text = Data.position_x.ToString();
            this.textBox_posY.Text = Data.position_y.ToString();
            this.textBox_posZ.Text = Data.position_z.ToString();
            this.textBox_orientation.Text = Data.orientation.ToString();

            this.commentTextbox.Text = Data.comment;

            //switch (comboBoxAction.SelectedIndex)
            //{
            //    case 0:     // talk
            //        textBox_dataint1.ReadOnly = false;
            //        textBox_dataint2.ReadOnly = false;
            //        textBox_dataint3.ReadOnly = false;
            //        textBox_dataint4.ReadOnly = false;
            //        break;
            //    case 3:     // move
            //    case 6:     // teleport
            //    case 10:    // summon
            //        textBox_posX.ReadOnly = false;
            //        textBox_posY.ReadOnly = false;
            //        textBox_posZ.ReadOnly = false;
            //        textBox_orientation.ReadOnly = false;
            //        break;
            //}

            locked = false;
        }
Esempio n. 2
0
        // Load event data to list
        public Event_dataset_script GetEventData()
        {
            Event_dataset_script Data = new Event_dataset_script();

            Data.command = comboBoxAction.SelectedIndex;
            if (textBoxDelay.Text.Length != 0)          Data.delay = Convert.ToUInt32(textBoxDelay.Text);

            if (textBox_datalong.Text.Length != 0)      Data.datalong = Convert.ToUInt32(textBox_datalong.Text);
            if (textBox_datalong2.Text.Length != 0)     Data.datalong2 = Convert.ToUInt32(textBox_datalong2.Text);

            if (textBox_dataint1.Text.Length != 0)      Data.dataint = Convert.ToUInt32(textBox_dataint1.Text);
            if (textBox_dataint2.Text.Length != 0)      Data.dataint = Convert.ToUInt32(textBox_dataint2.Text);
            if (textBox_dataint3.Text.Length != 0)      Data.dataint = Convert.ToUInt32(textBox_dataint3.Text);
            if (textBox_dataint4.Text.Length != 0)      Data.dataint = Convert.ToUInt32(textBox_dataint4.Text);

            if (textBox_posX.Text.Length != 0)          Data.position_x = float.Parse(textBox_posX.Text);
            if (textBox_posY.Text.Length != 0)          Data.position_x = float.Parse(textBox_posY.Text);
            if (textBox_posZ.Text.Length != 0)          Data.position_x = float.Parse(textBox_posZ.Text);
            if (textBox_orientation.Text.Length != 0)   Data.position_x = float.Parse(textBox_orientation.Text);

            if (textBox_buddy.Text.Length != 0)         Data.buddy = Convert.ToUInt32(textBox_buddy.Text);
            if (textBox_radius.Text.Length != 0)        Data.radius = Convert.ToUInt32(textBox_radius.Text);
            if (textBox_flags.Text.Length != 0)         Data.dataflags = Convert.ToUInt32(textBox_flags.Text);

            if (commentTextbox.Text.Length != 0)        Data.comment = commentTextbox.Text;

            db_scripts.scriptList[script_id].line[eventid] = Data;
            db_scripts.scriptList[script_id].changed = true;
            return Data;
        }
Esempio n. 3
0
        public void AddScriptLine()
        {
            Event_dataset_script temp = new Event_dataset_script();

            line.Add(temp);
        }
Esempio n. 4
0
        // Load DB scripts
        public static void LoadDBScripts(string sTable)
        {
            if (!Datastores.dbused)
                return;

            MySqlDataReader reader = null;

            // Check for the creatureAI tables
            try
            {
                string sQuery = "SELECT information_schema.TABLES.table_name FROM information_schema.TABLES " +
                    "where information_schema.TABLES.table_name IN ('creature_movement_scripts','event_script','gameobject_scripts','gossip_scripts','quest_end_scripts','quest_start_scripts','spell_scripts') and information_schema.TABLES.Table_schema='" + Properties.Settings.Default.DBMANGOS + "'";
                MySqlCommand comm = new MySqlCommand(sQuery, SQLConnection.conn);
                reader = comm.ExecuteReader();

                while (reader.Read())
                {
                    if (!reader.HasRows)
                    {
                        MessageBox.Show("Your database doesn't contain the script tables. The application won't use the database anymore");
                        dbused = false;
                    }
                }
            }
            catch (Exception e)
            {
                MessageBox.Show(e.Message);
            }
            reader.Close();

            if (Datastores.dbused)
            {
                // Select all creature scripts and creature names
                MySqlCommand c = new MySqlCommand("SELECT * FROM " + sTable, SQLConnection.conn);
                reader = c.ExecuteReader();

                // clear existing script first
                db_scripts.scriptList.Clear();

                try
                {
                    while (reader.Read())
                    {
                        if (!db_scripts.scriptList.ContainsKey(reader.GetUInt32("id")))
                        {
                            db_script temp = new db_script(reader.GetUInt32("id"));
                            db_scripts.scriptList.Add(reader.GetUInt32("id"), temp);
                        }

                        Event_dataset_script item = new Event_dataset_script();

                        item.id = reader.GetUInt32("id");
                        item.delay = reader.GetUInt32("delay");
                        item.command = reader.GetInt32("command");
                        item.datalong = reader.GetUInt32("datalong");
                        item.datalong2 = reader.GetUInt32("datalong2");
                        item.buddy = reader.GetUInt32("buddy_entry");
                        item.radius = reader.GetUInt32("search_radius");
                        item.dataint = reader.GetUInt32("dataint");
                        item.dataint2 = reader.GetUInt32("dataint2");
                        item.dataint3 = reader.GetUInt32("dataint3");
                        item.dataint4 = reader.GetUInt32("dataint4");
                        item.position_x = reader.GetFloat("x");
                        item.position_y = reader.GetFloat("y");
                        item.position_z = reader.GetFloat("z");
                        item.orientation = reader.GetFloat("o");
                        item.comment = reader.GetString("comments");

                        db_scripts.scriptList[reader.GetUInt32("id")].line.Add(item);
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
                reader.Close();
            }
        }
Esempio n. 5
0
        // Load event data to list
        public Event_dataset_script GetEventData()
        {
            Event_dataset_script Data = new Event_dataset_script();

            Data.command = comboBoxAction.SelectedIndex;
            if (textBoxDelay.Text.Length != 0)
            {
                Data.delay = Convert.ToUInt32(textBoxDelay.Text);
            }

            if (textBox_datalong.Text.Length != 0)
            {
                Data.datalong = Convert.ToUInt32(textBox_datalong.Text);
            }
            if (textBox_datalong2.Text.Length != 0)
            {
                Data.datalong2 = Convert.ToUInt32(textBox_datalong2.Text);
            }
            if (textBox_datalong3.Text.Length != 0)
            {
                Data.datalong3 = Convert.ToUInt32(textBox_datalong3.Text);
            }

            if (textBox_dataint1.Text.Length != 0)
            {
                Data.dataint = Convert.ToInt32(textBox_dataint1.Text);
            }
            if (textBox_dataint2.Text.Length != 0)
            {
                Data.dataint = Convert.ToInt32(textBox_dataint2.Text);
            }
            if (textBox_dataint3.Text.Length != 0)
            {
                Data.dataint = Convert.ToInt32(textBox_dataint3.Text);
            }
            if (textBox_dataint4.Text.Length != 0)
            {
                Data.dataint = Convert.ToInt32(textBox_dataint4.Text);
            }

            if (textBox_posX.Text.Length != 0)
            {
                Data.position_x = float.Parse(textBox_posX.Text, System.Globalization.CultureInfo.InvariantCulture);
            }
            if (textBox_posY.Text.Length != 0)
            {
                Data.position_y = float.Parse(textBox_posY.Text, System.Globalization.CultureInfo.InvariantCulture);
            }
            if (textBox_posZ.Text.Length != 0)
            {
                Data.position_z = float.Parse(textBox_posZ.Text, System.Globalization.CultureInfo.InvariantCulture);
            }
            if (textBox_orientation.Text.Length != 0)
            {
                Data.orientation = float.Parse(textBox_orientation.Text, System.Globalization.CultureInfo.InvariantCulture);
            }

            if (textBox_buddy.Text.Length != 0)
            {
                Data.buddy = Convert.ToUInt32(textBox_buddy.Text);
            }
            if (textBox_radius.Text.Length != 0)
            {
                Data.radius = Convert.ToUInt32(textBox_radius.Text);
            }
            if (textBox_flags.Text.Length != 0)
            {
                Data.dataflags = Convert.ToUInt32(textBox_flags.Text);
            }

            if (commentTextbox.Text.Length != 0)
            {
                Data.comment = commentTextbox.Text;
            }

            db_scripts.scriptList[script_id].line[eventid] = Data;
            db_scripts.scriptList[script_id].changed       = true;
            return(Data);
        }
Esempio n. 6
0
        public DbScriptControl(Event_dataset_script Data, Int32 ID, uint id)
        {
            InitializeComponent();

            this.Name = ID.ToString();
            eventid   = ID;
            script_id = id;
            this.eventCheckbox.Text = "Event: " + ID.ToString();

            this.eventCheckbox.Checked = true;

            for (int n = 0; n < Info.ScriptCommands.GetLength(0); n++)
            {
                this.comboBoxAction.Items.Add(Info.ScriptCommands[n, 0]);
            }

            // set width
            comboBoxAction.DropDownWidth = DropDownWidth(comboBoxAction);
            comboBoxAction.DropDownStyle = ComboBoxStyle.DropDownList;

            this.comboBoxAction.SelectedIndex = Data.command;
            this.textBoxDelay.Text            = Data.delay.ToString();

            this.textBox_datalong.Text  = Data.datalong.ToString();
            this.textBox_datalong2.Text = Data.datalong2.ToString();
            this.textBox_datalong3.Text = Data.datalong3.ToString();

            this.textBox_buddy.Text  = Data.buddy.ToString();
            this.textBox_radius.Text = Data.radius.ToString();
            this.textBox_flags.Text  = Data.dataflags.ToString();

            this.textBox_dataint1.Text = Data.dataint.ToString();
            this.textBox_dataint2.Text = Data.dataint2.ToString();
            this.textBox_dataint3.Text = Data.dataint3.ToString();
            this.textBox_dataint4.Text = Data.dataint4.ToString();

            this.textBox_posX.Text        = Data.position_x.ToString();
            this.textBox_posY.Text        = Data.position_y.ToString();
            this.textBox_posZ.Text        = Data.position_z.ToString();
            this.textBox_orientation.Text = Data.orientation.ToString();

            this.commentTextbox.Text = Data.comment;

            //switch (comboBoxAction.SelectedIndex)
            //{
            //    case 0:     // talk
            //        textBox_dataint1.ReadOnly = false;
            //        textBox_dataint2.ReadOnly = false;
            //        textBox_dataint3.ReadOnly = false;
            //        textBox_dataint4.ReadOnly = false;
            //        break;
            //    case 3:     // move
            //    case 6:     // teleport
            //    case 10:    // summon
            //        textBox_posX.ReadOnly = false;
            //        textBox_posY.ReadOnly = false;
            //        textBox_posZ.ReadOnly = false;
            //        textBox_orientation.ReadOnly = false;
            //        break;
            //}

            locked = false;
        }
Esempio n. 7
0
        // Load DB scripts
        public static void LoadDBScripts(string sTable)
        {
            // Force using dots on floats, no matter which is the system setting
            System.Globalization.CultureInfo customCulture = (System.Globalization.CultureInfo)System.Threading.Thread.CurrentThread.CurrentCulture.Clone();
            customCulture.NumberFormat.NumberDecimalSeparator = ".";
            System.Threading.Thread.CurrentThread.CurrentCulture = customCulture;

            if (!Datastores.dbused)
                return;

            MySqlDataReader reader = null;

            // Check for the creatureAI tables
            try
            {
                string sQuery = "SELECT information_schema.TABLES.table_name FROM information_schema.TABLES " +
                    "where information_schema.TABLES.table_name IN ('dbscripts_on_creature_movement','dbscripts_on_event','dbscripts_on_go_use','dbscripts_on_go_template_use','dbscripts_on_gossip','dbscripts_on_quest_end','dbscripts_on_quest_start','dbscripts_on_spell') and information_schema.TABLES.Table_schema='" + Properties.Settings.Default.DBMANGOS + "'";
                MySqlCommand comm = new MySqlCommand(sQuery, SQLConnection.conn);
                reader = comm.ExecuteReader();

                while (reader.Read())
                {
                    if (!reader.HasRows)
                    {
                        MessageBox.Show("Your database doesn't contain the script tables. The application won't use the database anymore");
                        dbused = false;
                    }
                }
            }
            catch (Exception e)
            {
                MessageBox.Show(e.Message);
            }
            reader.Close();

            if (Datastores.dbused)
            {
                // Select all creature scripts and creature names
                MySqlCommand c = new MySqlCommand("SELECT * FROM " + sTable, SQLConnection.conn);
                reader = c.ExecuteReader();

                // clear existing script first
                db_scripts.scriptList.Clear();

                try
                {
                    while (reader.Read())
                    {
                        if (!db_scripts.scriptList.ContainsKey(reader.GetUInt32("id")))
                        {
                            db_script temp = new db_script(reader.GetUInt32("id"));
                            db_scripts.scriptList.Add(reader.GetUInt32("id"), temp);
                        }

                        Event_dataset_script item = new Event_dataset_script();

                        item.id = reader.GetUInt32("id");
                        item.delay = reader.GetUInt32("delay");
                        item.command = reader.GetInt32("command");
                        item.datalong = reader.GetUInt32("datalong");
                        item.datalong2 = reader.GetUInt32("datalong2");
                        item.buddy = reader.GetUInt32("buddy_entry");
                        item.radius = reader.GetUInt32("search_radius");
                        item.dataint = reader.GetUInt32("dataint");
                        item.dataint2 = reader.GetUInt32("dataint2");
                        item.dataint3 = reader.GetUInt32("dataint3");
                        item.dataint4 = reader.GetUInt32("dataint4");
                        item.position_x = reader.GetFloat("x");
                        item.position_y = reader.GetFloat("y");
                        item.position_z = reader.GetFloat("z");
                        item.orientation = reader.GetFloat("o");
                        item.comment = reader.GetString("comments");

                        db_scripts.scriptList[reader.GetUInt32("id")].line.Add(item);
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
                reader.Close();
            }
        }
Esempio n. 8
0
 public void AddScriptLine()
 {
     Event_dataset_script temp = new Event_dataset_script();
     line.Add(temp);
 }