24 | 01 | 2018
Command Reference

There are many commands that do many things in MudMaster 2k6. This command reference groups them into the following catergories.

Database 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.

The Database Connect String controls which database is used. If left out it defaults to using mm2k6Arrays.mdb in the default session folder (pointed to by @sessionpath(). The default case also does not require DB User and DB Password either.

 If you include it the type of database if tries to use is controled by a 3 letter prefix followed by a colon and then the appropriate connect string info.

For text database files it is the path to the folder where the text files are and the Schema.ini file is. For example if these are in your session folder {txt:@sessionpath()} would work. For text files the table name is the text file name so an query example would look like:

/sqlquery {select * from ClanDB.txt where ClanNumber = 21}{clans}{@sessionpath()}

If instead you have a table called clan in the mm2k6Arrays.mdb this would be:

/sqlquery {select * from clan where ClanNumber = 21}{clans}

Prefix DB Type Connect String
txt: Text path to folder with Schema.ini and text files txt:@sessionpath()
dsn any DSN

For System DSN dsn:DSN=myDsn;Uid=myUsername;Pwd=;

For file DSN dsn:FILEDSN=c:\myDsnFile.dsn;Uid=myUsername;Pwd=;

xls Excel

xls:pathIncludingFileName for example
/sqlquery {select * from array}{stuff}{xls:@sessionpath()stuff.xls}
This require the "database" table be a defined name in the spreadsheet

mdb MS Access mdb:pathToMDBfileWithFileName
mys MySql mys:Port=1234;Host=myServerAddress;Database=myDataBase;
mss MS Sqlsever msq:Server=myServerAddress;Database=myDataBase;User ID=myUsername;
Session Window Commands

There are several commands which are used to altar the appearance or route commands or text of session windows in MudMaster 2k6. These mean that you not only can have more than one window open at once but can use script to make the windows interact with each other. You can even open new session windows via script commands.

Miscellaneous Commands
A variety of commands which somehow escaped the other categories exist for display output, speedwalking, some calcualtions, file input and output, and of course help. 
Script Entity Info

These commands display existing script entities either by searching or by group name or lists how many of each exist. 

grep groupactions groupaliases
grouparrays groupbaritems groupevents
groupgag grouplists groupmacros
groupsubstitutes grouptablist groupvariables
information message 
List Commands
clearlist itemadd listcopy
itemdelete listadd listdelete
listitems lists
« StartPrev123NextEnd »

Page 1 of 3