+// Is a table column there?
+function ifSqlColumnExists ($tableName, $columnName) {
+ //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'tableName=' . $tableName . ',columnName=' . $columnName . ' - ENTERED!');
+ // Is there cache?
+ if (!isset($GLOBALS[__FUNCTION__][$tableName][$columnName])) {
+ // And column name as well
+ $columnName = str_replace('`', '', $columnName);
+
+ // If the table is not there, it is okay
+ if (!ifSqlTableExists($tableName)) {
+ // Then abort here
+ return FALSE;
+ } // END - if
+
+ // Get column information
+ $result = SQL_QUERY_ESC("SHOW COLUMNS FROM `%s` LIKE '%s'",
+ array(
+ $tableName,
+ $columnName
+ ), __FUNCTION__, __LINE__);
+
+ // Is a link there?
+ if (!is_resource($result)) {
+ // Is installation phase?
+ if (isInstallationPhase()) {
+ // Then silently abort here
+ //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'result[]=' . gettype($result) . ',isLinkUp=' . intval(SQL_IS_LINK_UP()) . ',tableName=' . $tableName . ',columnName=' . $columnName . ' - Returning FALSE ...');
+ return FALSE;
+ } else {
+ // Please report this
+ reportBug(__FUNCTION__, __LINE__, 'result[]=' . gettype($result) . ' is not a resource.');
+ }
+ } // END - if
+
+ // Determine it
+ $GLOBALS[__FUNCTION__][$tableName][$columnName] = (!SQL_HASZERONUMS($result));
+ //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'tableName=' . $tableName . ',columnName=' . $columnName . ',hasZeroNums=' . intval(SQL_HASZERONUMS($result)) . ',numRows=' . intval($GLOBALS[__FUNCTION__][$tableName][$columnName]));
+
+ // Free result
+ SQL_FREERESULT($result);
+ } // END - if
+
+ // Return cache
+ //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'tableName=' . $tableName . ',columnName=' . $columnName . ',result=' . intval($GLOBALS[__FUNCTION__][$tableName][$columnName]) . ' - EXIT!');
+ return $GLOBALS[__FUNCTION__][$tableName][$columnName];
+}
+
+// Checks depending on the mode if the index is there
+function ifSqlTableIndexExist ($tableName, $keyName) {
+ //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'tableName=' . $tableName . ',columnName=' . $keyName . ' - ENTERED!');
+ // Is there cache?
+ if (!isset($GLOBALS[__FUNCTION__][$tableName][$keyName])) {
+ // If the table is not there, it is okay
+ if (!ifSqlTableExists($tableName)) {
+ // Then abort here
+ return FALSE;
+ } // END - if
+