|
All The Additional Conditions |
|
Written by Dream Dancer
|
|
Nov 25, 2007 at 08:12 AM |
|
All the additional checks
| $DATABASE: If field {#0) in table {#1} doesn't exist in database {#0} |
 |
| 0 |
0 FieldName |
| 1 |
1 TableName |
| 2 |
2 Database ID |
|
TRUE if FieldName does not exist in TableName in DatabaseID. |
|
|
| $DATABASE: If field {#0) in table {#1} exists in database {#2} |
|
| 0 |
0 FieldName |
| 1 |
1 TableName |
| 2 |
2 Database ID |
|
TRUE if FieldName exists in TableName in DatabaseID. |
|
|
| $DATABASE: if field {#0} in database {#1} in table {#2} is equal to {#3} from ID {#4} |
|
| 0 |
Field Name |
| 1 |
DBID |
| 2 |
Table |
| 3 |
Is equal to value |
| 4 |
From record ID |
|
TRUE if the Entry in Field Name is equal to Value in Record ID. |
|
|
| $DATABASE: if field {#0} in database {#1} in table {#2} is EXACTLY {#3}(text) from ID {#4} |
|
| 0 |
Field Name |
| 1 |
DBID |
| 2 |
Table |
| 3 |
Is exact text |
| 4 |
From record ID |
|
TRUE if the Entry in Field Name is exactly Text in Record ID. Case sensitive comparision. |
|
|
| $DATABASE: if field {#0} in database {#1} in table {#2} is greater than {#3} from ID {#4} |
|
| 0 |
Field Name |
| 1 |
DBID |
| 2 |
Table |
| 3 |
Is greater than value |
| 4 |
From record ID |
|
TRUE if the Entry in Field Name is greater than Value in Record ID. |
|
|
| $DATABASE: if field {#0} in database {#1} in table {#2} is less than {#3} from ID {#4} |
|
| 0 |
Field Name |
| 1 |
DBID |
| 2 |
Table |
| 3 |
Is less than value |
| 4 |
From record ID |
|
TRUE if the Entry in Field Name is less than Value in Record ID. |
|
|
| $DATABASE: if field {#0} in database {#1} in table {#2} is not equal to {#3} from ID {#4} |
|
| 0 |
Field Name |
| 1 |
DBID |
| 2 |
Table |
| 3 |
Is not equal to value |
| 4 |
From record ID |
|
TRUE if the Entry in Field Name is not equal to Value in Record ID. |
|
|
| $DATABASE: if field {#0} in database {#1} in table {#2} is not the same as {#3}(text) from ID {#4} |
|
| 0 |
Field Name |
| 1 |
DBID |
| 2 |
Table |
| 3 |
Is not like as text |
| 4 |
From record ID |
|
TRUE if the Entry in Field Name is not LIKE Text in Record ID. Caseless comparision. |
|
|
| $DATABASE: if field {#0} in database {#1} in table {#2} is same as {#3}(text) from ID {#4} |
|
| 0 |
Field Name |
| 1 |
DBID |
| 2 |
Table |
| 3 |
Is like text |
| 4 |
From record ID |
|
TRUE if the Entry in Field Name is LIKE Text in Record ID. Caseless comparision. |
|
|
| $DATABASE: If table {#0} doesn't exist in database {#1} |
|
| 0 |
0 TableName |
| 1 |
1 Database ID |
|
TRUE if TableName does not exist in DatabaseID. |
|
|
| $DATABASE: If table {#0} exists in database {#1} |
|
| 0 |
0 TableName |
| 1 |
1 Database ID |
|
TRUE if TableName exists in DatabaseID. |
|
|
| $DATABASE: if there is a record in table {#0} in database {#1} where ID is {#2} |
|
| 0 |
Table |
| 1 |
DBID |
| 2 |
Record to find |
|
TRUE if Record exists in Table. |
|
|
| $DATABASE: if there is not a record at table {#0} in database {#1} where field {#2} is ID {#3} |
|
| 0 |
Table |
| 1 |
DBID |
| 2 |
Field Name |
| 3 |
Is not ID Name |
|
This will look for an Entry in the Table which is LIKE the ID Name, and if found, returns FALSE.
SQL: SELECT * FROM Table WHERE Field LIKE "StrToDb(IDName)*" ORDER BY Field |
|
|
| $DATABASE: if there is not a record in table {#0} in database {#1} where ID is {#2} |
|
| 0 |
Table |
| 1 |
DBID |
| 2 |
Record to not find |
|
TRUE if Record does not exist in Table. |
|
|
| $FILESYSTEM: If file {#0} does not exist |
|
|
|
TRUE if FileName does not exist. |
|
|
| $FILESYSTEM: If file {#0} exists |
|
|
|
|
| $LOGFILE: if logfile {#0} contains {#1} compared to {#2} entries in record {#3} |
|
| 0 |
0 FileName |
| 1 |
&1 Compare/Less Than,More Than,Exactly,Not This Many |
| 2 |
To This |
| 3 |
Record |
|
$LOGFILE: if logfile {#0} contains {#1} compared to {#2} entries in record {#3}
Like below, it checks for the number of entries in a single record, and if true, continues processing the command. |
|
|
| $LOGFILE: if logfile {#0} contains {#1} compared to {#2} records |
|
| 0 |
0 FileName |
| 1 |
&1 Compare/Less Than,More Than,Exactly,Not This Many |
| 2 |
To This |
|
$LOGFILE: if logfile {#0} contains {#1} compared to {#2} records
The parameter {#1} is a selector for one of four possible outcomes, Less Than, More Than, Exactly, Not This Many, or the last one could also be termed Not Exact. This checks for the number of records in a log file and based on the comparision, either allows the command to continue processing, or bails the processor on failure. |
|
|
| if {#0} is not on the list in file {#1} |
|
|
|
$LOG system, TRUE if a Record isn't in the file. |
|
|
| if {#0} is on the list in file {#1} |
|
|
|
$LOG system, TRUE if a Record is in the file. |
|
|
| if element {#0} in record {#1} in file {#2} is like {#3} |
|
| 0 |
Element Number |
| 1 |
Record Name |
| 2 |
FileName |
| 3 |
Compared to (text) |
|
$LOG system, TRUE if a particular Entry (referenced by number) in under Record is LIKE the text it compares it against. Currently, the engines Option Compare mode is BINARY, this produces a sort order of:
A < B < E < Z < a < b < e < z < À < Ê < Ø < à < ê < ø
HOWEVER, the comparision is done caseless internally, so the net result is that ALPHONSE is like alphonse. |
|
|
| if element {#0} in record {#1} in file {#2} is not like {#3} |
|
| 0 |
Element Number |
| 1 |
Record Name |
| 2 |
FileName |
| 3 |
Compared to (text) |
|
$LOG system, TRUE if a particular Entry by number under Record is not LIKE the text it compares it against. |
|
|
| if random roll {#0} is equal to {#1} |
|
| 0 |
Random range |
| 1 |
Equal to |
|
TRUE if a random number from 0 to {#0} is equal to {#1}. |
|
|
| if random roll {#0} is greater than {#1} |
|
| 0 |
Random range |
| 1 |
Greater than this |
|
TRUE if a random number from 0 to {#0} is greater than {#1}. |
|
|
| if random roll {#0} is not equal to {#1} |
|
| 0 |
Random range |
| 1 |
Not Equal to |
|
TRUE if a random number from 0 to {#0} is not equal to {#1}. |
|
|
| if random roll is {#0} is less than {#1} |
|
| 0 |
Random range |
| 1 |
Less than this |
|
TRUE if a random number from 0 to {#0} is less than {#1}. |
|
|
| if the ds event contains index {#0} |
|
|
|
TRUE if the ds event contains index {#0}
Whenever a DS event is triggered, and you check for a specific DS event, the system generates a table of the DSID's (and XY components) from the event. This table can be checked for the presense of a specific EventID so you don't have to do strange things to determine if a secondary event was also triggered along with the main DSID, you now have a table that holds all the events for you. This table is also accessable in WolfScript for detailed work. |
|
|
| if the ds event does not contain index {#0} |
|
|
|
TRUE if the ds event does not contain index {#0}
Complement of the above, to determine if a particular DSID did not happen when the trigger is fired. |
|
|
| if variable {#0} contains text {#1} (case insensitive) |
|
| 0 |
0 Variable (text) |
| 1 |
1 Contains text |
|
TRUE if variable {#0} contains text {#1} (case insensitive). Permits you to scan a string for particular words or characters. Uses the INSTR() Function. |
|
|
| if variable {#0} does not contain text {#1} (case insensitive) |
|
| 0 |
0 Variable (text) |
| 1 |
1 Contains text |
|
TRUE if variable {#0} does not contain text {#1} (case insensitive). Permits you to scan a string for the lack of particular words or characters. Uses the INSTR() Function. |
|
|
| if variable {#0} is equal to {#1} (numeric comparison) |
|
| 0 |
Variable (numeric) |
| 1 |
Is equal to this |
|
TRUE if {#0} is equal to {#1}. |
|
|
| if variable {#0} is greater than {#1} (numeric comparison) |
|
| 0 |
Variable (numeric) |
| 1 |
Is greater than this |
|
TRUE if {#0} is greater than {#1}. |
|
|
| if variable {#0} is less than {#1} (numeric comparison) |
|
| 0 |
Variable (numeric) |
| 1 |
Is less than this |
|
TRUE if {#0} is less than {#1}. |
|
|
| if variable {#0} is not equal to {#1} (numeric comparison) |
|
| 0 |
Variable (numeric) |
| 1 |
Is not equal to this |
|
TRUE if {#0} is not equal to {#1}. |
|
|
| if variable {#0} is not the same as {#1} (text comparison) |
|
| 0 |
Variable (text) |
| 1 |
Is not the same as |
|
TRUE if {#0} is not LIKE {#1}. Caseless comparision. |
|
|
| if variable {#0} is the same as {#1} (text comparison) |
|
| 0 |
Variable (text) |
| 1 |
Is the same as |
|
TRUE if {#0} is LIKE {#1}. Caseless comparision. |
|
|
|
|
Last Updated ( Feb 20, 2010 at 08:41 PM )
|
Commands 
