{$GLOBALS['CRH_LINK_NAME']}"; // return $actionLinks; } // update record order so there is space between order values for new records to be inserted // Note: The only reason we're using a filter for this is because there is no hook available function crh_updateRecordOrder($message, $tableName, $recordNum) { global $schema; if (!@$schema['dragSortOrder']) { return $message; } // skip sections without dragSortOrder field // re-order records $tableNameWithPrefix = getTableNameWithPrefix($tableName); $query1 = "SET @count = 0"; $query2 = "UPDATE `$tableNameWithPrefix` SET `dragSortOrder` = (SELECT @count := @count + 10) ORDER BY dragSortOrder"; mysqli()->query($query1) or die("MySQL Error: ". htmlencode(mysqli()->error) . "\n"); mysqli()->query($query2) or die("MySQL Error: ". htmlencode(mysqli()->error) . "\n"); // return $message; } // eof