22 | 01 | 2018
Version 4.2

Bugs Fixed

Top position of saved session no longer creeps with successive saves and opens.

New Database Interface Commands

If you use the default database (mm2k6Arrays.mdb in your MudMaster folder) you should not supply the Database Connect String, DB User, and DB Password in the following commands.

/SQLQuery {SQL Statement}{Array Name}{Database Connect String}{DB User}{DB Password} runs the SQL select against the database and returns two arrays. The result set is stored in an array with each result set column in the array columns and each result set row in an array row. The second array named with Columns appended to the name lists the column names.

/SQLExecute {SQL Statement}{Database Connect String}{DB User}{DB Password} runs the provided statement against the database. This is useful for running insert, update and delete statements but can be used for any kind of statement where you don't require a return.

/ArrayDBSave {ArrayName}{Database Connect String}{DB User}{DB Password} saves the named array in a database table called Array which must have columns of ArrayName,singleDimension,RowNumber, ColumnNumber,ElementText. At present ElementText can be up to 10255 characters long.

/ArrayDBRead {ArrayName}{Database Connect String}{DB User}{DB Password} reads the data matching the named array. The array must be defined with the /array command before the read and the dimensions must at least match the data stored.

New Procedures

@RegexArray(SearchPattern,ArrayName) returns the row number or row and column number for the first array element that matches the pattern. Returns 0 if no match is found. For example if you have an array called ItemStuff with 88 rows and 3 columns @RegexArray(.*balm.*,ItemStuff) might return 7,1

Changed Commands and Procedures

/math and @math will now do floating point math if a decimal is seen in the equation. For example @math(3 / 2) will return 1 but @math(3 / 2.0) will return 1.667

/susbtitute When token wildcards are used the original colours of the original line are applied to the new line. Under circumstances where the line lengths are different the colour may be shifted. Characters added to the end of a line which has increased in length will take the colour of the last character of the original line.

Interface Updates

New Dock Right session option allows you to set the right edge of a session window to stay docked to the right edge of the outer MudMaster window edge.

New input tab completion means that now if you hit tab while entering text in the input line mm2k6 will attempt to match the text entered so far with commands in the command history buffer. The first match is made is put into the input line. Tabadd entries are given priority over command completion so if the word you are on in the input line matches a tabbadd entry it will be completed rather than attempting to match a previous command.