Example #1
0
        // Not used currently (button is hidden) but have ideas for this.   Reuse  for importing body tables.
        private void btnGenerateBodyTable_Click(object sender, RoutedEventArgs e)
        {
            string header = $"INSERT INTO `weenie_properties_body_part` (`object_Id`, `key`, `d_Type`, `d_Val`, `d_Var`, `base_Armor`, `armor_Vs_Slash`, `armor_Vs_Pierce`, `armor_Vs_Bludgeon`, `armor_Vs_Cold`, `armor_Vs_Fire`, `armor_Vs_Acid`, `armor_Vs_Electric`, `armor_Vs_Nether`, `b_h`, `h_l_f`, `m_l_f`, `l_l_f`, `h_r_f`, `m_r_f`, `l_r_f`, `h_l_b`, `m_l_b`, `l_l_b`, `h_r_b`, `m_r_b`, `l_r_b`)";

            string bodyparts = TableToSql.ConvertBodyPart(bodypartsDataTable, tbWCID.Text, header);

            rtbBodyParts.Document.Blocks.Clear();
            rtbBodyParts.Document.Blocks.Add(new System.Windows.Documents.Paragraph(new Run(bodyparts)));
        }
Example #2
0
        public void WriteSQLFile(string filename)
        {
            string dateModified = string.Format("'{0:yyyy-MM-dd hh:mm:ss}'", DateTime.Now);

            string[] weenieTypeDescription = cbWeenieType.Text.Split(" ");

            // Header
            string header = $"DELETE FROM `weenie` WHERE `class_Id` = {tbWCID.Text} \n\n";
            string body   = $"DELETE FROM `weenie` WHERE `class_Id` = {tbWCID.Text};\n\n";

            // WeenieType
            body += $"INSERT INTO `weenie` (`class_Id`, `class_Name`, `type`, `last_Modified`)\n";
            body += $"VALUES ({tbWCID.Text}, '{tbWeenieName.Text}', {cbWeenieType.SelectedIndex}, {dateModified}) /* {weenieTypeDescription[1]} */;\n\n";

            // Integer32
            header = $"INSERT INTO `weenie_properties_int` (`object_Id`, `type`, `value`)";
            body  += TableToSql.ConvertTriValueTable(integerDataTable, tbWCID.Text, header);

            // Integer64
            header = $"INSERT INTO `weenie_properties_int64` (`object_Id`, `type`, `value`)";
            body  += TableToSql.ConvertTriValueTable(integer64DataTable, tbWCID.Text, header);

            // Boolean
            header = $"INSERT INTO `weenie_properties_bool` (`object_Id`, `type`, `value`)";
            body  += TableToSql.ConvertBooleanTable(boolDataTable, tbWCID.Text, header);

            // Float
            header = $"INSERT INTO `weenie_properties_float` (`object_Id`, `type`, `value`)";
            body  += TableToSql.ConvertFloatTable(floatDataTable, tbWCID.Text, header);

            // String
            header = $"INSERT INTO `weenie_properties_string` (`object_Id`, `type`, `value`)";
            body  += TableToSql.ConvertStringTable(stringDataTable, tbWCID.Text, header);

            // DiD
            header = $"INSERT INTO `weenie_properties_d_i_d` (`object_Id`, `type`, `value`)";
            body  += TableToSql.ConvertDidTable(didDataTable, tbWCID.Text, header);

            // IiD
            header = $"INSERT INTO `weenie_properties_i_i_d` (`object_Id`, `type`, `value`)";
            body  += TableToSql.ConvertIidTable(iidDataTable, tbWCID.Text, header);

            // Positions
            header = $"INSERT INTO `weenie_properties_position` (`object_Id`, `position_Type`, `obj_Cell_Id`, `origin_X`, `origin_Y`, `origin_Z`, `angles_W`, `angles_X`, `angles_Y`, `angles_Z`)";
            body  += TableToSql.ConvertPositionTable(positionsDataTable, tbWCID.Text, header);

            // Body Parts
            header = $"INSERT INTO `weenie_properties_body_part` (`object_Id`, `key`, `d_Type`, `d_Val`, `d_Var`, `base_Armor`, `armor_Vs_Slash`, `armor_Vs_Pierce`, `armor_Vs_Bludgeon`, `armor_Vs_Cold`, `armor_Vs_Fire`, `armor_Vs_Acid`, `armor_Vs_Electric`, `armor_Vs_Nether`, `b_h`, `h_l_f`, `m_l_f`, `l_l_f`, `h_r_f`, `m_r_f`, `l_r_f`, `h_l_b`, `m_l_b`, `l_l_b`, `h_r_b`, `m_r_b`, `l_r_b`)";
            body  += TableToSql.ConvertBodyPart(bodypartsDataTable, tbWCID.Text, header);

            //string bodyparts = new TextRange(rtbBodyParts.Document.ContentStart, rtbBodyParts.Document.ContentEnd).Text;
            //if (bodyparts != "")
            //    body += TableToSql.ConvertBodyTable(bodyparts, tbWCID.Text, header);

            // Attributes
            header = $"INSERT INTO `weenie_properties_attribute` (`object_Id`, `type`, `init_Level`, `level_From_C_P`, `c_P_Spent`)";
            body  += TableToSql.ConvertAttributeTable(attributeDataTable, tbWCID.Text, header);

            // Attributes 2 - Health, Stam, Mana
            header = $"INSERT INTO `weenie_properties_attribute_2nd` (`object_Id`, `type`, `init_Level`, `level_From_C_P`, `c_P_Spent`, `current_Level`)";
            body  += TableToSql.ConvertAttribute2Table(attribute2DataTable, tbWCID.Text, header);

            // Skills
            header = $"INSERT INTO `weenie_properties_skill` (`object_Id`, `type`, `level_From_P_P`, `s_a_c`, `p_p`, `init_Level`, `resistance_At_Last_Check`, `last_Used_Time`)";
            body  += TableToSql.ConvertSkillsTable(skillsDataTable, tbWCID.Text, header);

            // Spells
            header = $"INSERT INTO `weenie_properties_spell_book` (`object_Id`, `spell`, `probability`)";
            body  += TableToSql.ConvertSpellTable(spellDataTable, tbWCID.Text, header);

            // Emotes
            string tempES = new TextRange(rtbEmoteScript.Document.ContentStart, rtbEmoteScript.Document.ContentEnd).Text;

            // To fix the issue with Rich Text Boxes
            tempES = tempES.Replace("\n", "\r\n");
            tempES = tempES.Replace("\r\r\n", "\r\n");

            string[] saES        = tempES.Split(new string[] { System.Environment.NewLine }, StringSplitOptions.RemoveEmptyEntries);
            int      tWCID       = ConvertToInteger(tbWCID.Text);
            string   finalEmotes = "";

            // var eslist = EmoteScriptLib.Converter.es2sql(saES, ConvertToInteger(tbWCID.Text));

            try
            {
                var eslist = EmoteScriptLib.Converter.es2sql(saES, (uint)tWCID);
                foreach (var emoteline in eslist)
                {
                    finalEmotes += emoteline + "\r\n";
                }
            }
            catch (Exception ex)
            {
                LogError(ex);
                MessageBoxButton buttons = MessageBoxButton.OK;
                MessageBoxImage  icon    = MessageBoxImage.Error;
                MessageBoxResult result  = MessageBox.Show("FILE NOT SAVED WITH E MOTES! Please Copy Emotes and save outside of WF.  Issue with Emote Script.  Please send WeenieFabErrorLog.txt to Harli Quinn on Discord", "ERROR!", buttons, icon);
                //MessageBox.Show($"{ex.Message} \n {ex.StackTrace} \n {ex.Source} \n {ex.TargetSite}");
                //throw;
            }

            body += finalEmotes;

            // Create Items
            header = $"INSERT INTO `weenie_properties_create_list` (`object_Id`, `destination_Type`, `weenie_Class_Id`, `stack_Size`, `palette`, `shade`, `try_To_Bond`)";
            body  += TableToSql.ConvertCreateItemsTable(createListDataTable, tbWCID.Text, header);

            // Book Info
            header = $"INSERT INTO `weenie_properties_book` (`object_Id`, `max_Num_Pages`, `max_Num_Chars_Per_Page`)";
            body  += TableToSql.ConvertBookInfo(bookInfoDataTable, tbWCID.Text, header);

            // Book Pages
            header = $"INSERT INTO `weenie_properties_book_page_data` (`object_Id`, `page_Id`, `author_Id`, `author_Name`, `author_Account`, `ignore_Author`, `page_Text`)";
            body  += TableToSql.ConvertBookPages(bookPagesDataTable, tbWCID.Text, header);

            // Generator

            if (tbGenerator.Text != "")
            {
                // header = $"INSERT INTO `weenie_properties_generator` (`object_Id`, `probability`, `weenie_Class_Id`, `delay`, `init_Create`, `max_Create`, `when_Create`, `where_Create`, `stack_Size`, `palette_Id`, `shade`, `obj_Cell_Id`, `origin_X`, `origin_Y`, `origin_Z`, `angles_W`, `angles_X`, `angles_Y`, `angles_Z`)";
                // body += header;
                body += tbGenerator.Text;
            }
            File.WriteAllText(filename, body);
        }