It provides the basics for creating tools to manage Databases and perhaps files related to LastChaos.
-
The idea behind the project is to have a fast and efficient tool in terms of requests to the database. With that in mind I designed a scheme in which there are Global Tables, these are populated for the first time by the Tool that requires the information, and later said information can be used by another tool, Avoiding constants requests each time some Tool open.
-
When a Tool populates a Global Table, it is not necessarily populated with all the information available in the Database, but rather the system is designed so that different tools request only the columns necessary for the operation of said Tool. Being able to load different columns by different Tools without the information overlapping or replacing.
-
Finally, when in a Tool the operator decides to apply changes made, an attempt is made to execute a Query either type UPDATE or INSERT, in case of success, said changes are updated in the Global Tables.
- This information is stored in Definitions.cs
- In ItemEditor.cs, 2 directives can be found.
- ENABLE_SECOND_SKILL_TO_CRAFT Used to activate the controls for editing a_need_sskill2 & a_need_sskill_level2.
- ALLOWED_ZONE_SYSTEM It is used to have a Button to select the flag (It is necessary for a personal modification) this directive is disabled by default.
- Pickers
- Flag Picker Implementation Example
- Icon Picker Implementation Example
- Skill Picker Implementation Example
- Item Picker Implementation Example
- Rare Option Picker Implementation Example
- String Picker Implementation Example
- Option Picker Implementation Example
- Magic Picker Implementation Example
- NOTE: Picker Dialogs are intended to complement larger Tools, however, they have the ability to request information autonomously. This means that you can make the decision to load, for example, t_skill names to be able to display them in your Tool, which will increase loading times. On the other hand, you could not request this information and work only with IDS, but when invoking the Skill Picker Dialog, it will request data such as the name and description of the skills automatically if necessary.
- Others
- Example of requesting and storing t_item data in the Global Table: pItemTable. To later store information in a temporary variable to work with, to finally pass that temporary data to the Global Table.
// This function will be executed asynchronously when opening the Item Editor Tool
private async void ItemEditor_LoadAsync(object sender, EventArgs e)
{
// In my case I decided for readability reasons to separate the functions that request and store information in the __Global Tables__ into 3 different asynchronous functions. Taking this into account, I decided to use: <a href="hhttps://learn.microsoft.com/es-es/dotnet/api/system.threading.tasks.task.whenall?view=net-8.0">await Task.WhenAll</a>. But to simplify the explanation, I will do it with a single asynchronous function.
await LoadItemDataAsync();
// Once we have the necessary information stored in the Global Table, we can proceed to create a temporary Row based on the structure and data of the Global Table, but outside of it.
if (pMain.pItemTable != null)
{
// We can declare a private variable for our Tool using: private DataRow pTempRow; if necessary
// Using: NewRow() we can replicate the structure of the Global Table in a single row.
pTempRow = pMain.pItemTable.NewRow();
// Finally we can clone the content of a desired row to our temporary variable. To later be able to work with said variable and its content temporarily, without adulterating the content of the Global Table.
pTempRow.ItemArray = (object[])pMain.pItemTable.Select("a_index = 19")[0].ItemArray.Clone();
/*------------------------------------------------------------------*/
// Eventually we can get information from our temporary variable by doing the following.
string strGetItemEnable = pTempRow["a_enable"].ToString();
/*------------------------------------------------------------------*/
// By deduction we can alter the content of temporary variable by doing:
pTempRow["a_enable"] = "0";
/*------------------------------------------------------------------*/
// To transfer all the data from our temporary variable to the Global Table we can do the following...
// We obtain the reference to the desired row to alter.
DataRow pItemTableRow = pMain.pItemTable.Select("a_index = 19").FirstOrDefault();
if (pItemTableRow != null) // We verify that said row exists.
{
//In case of original structure of the Global Table is not altered we can do: pItemTableRow.ItemArray = pTempRow.ItemArray;
//In case of original structure of the Global Table is altered we can do the following...
foreach (DataColumn column in pTempRow.Table.Columns) // We can iterate through all the columns of the temporary variable.
{
if (!pMain.pItemTable.Columns.Contains(column.ColumnName)) // In case any of the columns do not exist in the Global Table.
pMain.pItemTable.Columns.Add(column.ColumnName, column.DataType); // We add it. Keep in mind, this adds the column only for a single row, the rest will not have that new column.
pItemTableRow[column.ColumnName] = pTempRow[column.ColumnName]; // Finally we write the values of all the columns of the Global Table with the data of the temporary variable.
}
}
}
}
private async Task LoadItemDataAsync()
{
bool bRequestNeeded = false;
// Here you must define the columns that you want to request from the Database.
HashSet<string> listQueryCompose = new HashSet<string> { "a_enable", "a_texture_id", "a_texture_row", "a_texture_col" };
// If columns related to locale are required, they must be defined here.
for (int i = 0; i < pMain.pSettings.NationSupported.Length; i++)
{
string strNation = pMain.pSettings.NationSupported[i].ToLower();
listQueryCompose.Add("a_name_" + strNation);
listQueryCompose.Add("a_descr_" + strNation);
}
if (pMain.pItemTable == null) // If the global table is empty, directly indicate that a Query must be executed requesting all previously defined columns
{
bRequestNeeded = true;
}
else // If the Global Table is not empty, check if any of the columns to request are already present. To remove it from the Query and not request redundant information.
{
foreach (var column in listQueryCompose.ToList())
{
if (!pMain.pItemTable.Columns.Contains(column))
bRequestNeeded = true;
else
listQueryCompose.Remove(column);
}
}
if (bRequestNeeded)
{
pMain.pItemTable = await Task.Run(() =>
{
// As you can see, regardless of the columns to request, it is always necessary to request the reference column, in this case a_index. Because this column will be used for the storage/overwriting process of the Global Table.
return pMain.QuerySelect(pMain.pSettings.DBCharset, $"SELECT a_index, {string.Join(",", listQueryCompose)} FROM {pMain.pSettings.DBData}.t_item ORDER BY a_index;");
});
}
}