Guest
May 20, 2012, 4:10 pm UTCHome arrow Commands arrow Additional Conditions arrow Database Checks
header image
Database Checks
Written by Dream Dancer   
Nov 26, 2007 at 04:24 AM

You  will notice that the $Database checks contain more types of checks than $Log checks, because you can do more with database's than you can with the logfile system. The logfile system is super stupid in the format, you have records, and non-named entries in the records. With database's you can check specific fields in the database for some very exacting information, like access levels being above or below a certain value, or that the text of a field is something like what you're looking for. Using the like command over just a simple equal check does provide wildcarding of the searched for text.

$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.
Last Updated ( Nov 27, 2008 at 10:06 AM )
<Previous   Next>
header image