# automatorwp/6.0.3/includes/custom-tables.php AutomatorWP – No-Code Workflow Automation, Integration & Webhooks Plugin, now with AI, version 6.0.3. 305 lines. - Page: https://pluginprobe.com/plugins/automatorwp/6.0.3/code/includes/custom-tables.php - Raw: https://pluginprobe.com/plugins/automatorwp/6.0.3/raw/includes/custom-tables.php - Modified: 2026-09-30T10:02:50+00:00 Line numbers below start at 1. Link to a line or a range by appending a fragment to the page URL, for example `https://pluginprobe.com/plugins/automatorwp/6.0.3/code/includes/custom-tables.php#L10-L20`. ```php , Ruben Garcia * @since 1.0.0 */ // Exit if accessed directly if( !defined( 'ABSPATH' ) ) exit; // Custom Tables require_once AUTOMATORWP_DIR . 'includes/custom-tables/automations.php'; require_once AUTOMATORWP_DIR . 'includes/custom-tables/triggers.php'; require_once AUTOMATORWP_DIR . 'includes/custom-tables/actions.php'; require_once AUTOMATORWP_DIR . 'includes/custom-tables/logs.php'; /** * Register all custom database Tables * * @since 1.0.0 * * @return void */ function automatorwp_register_custom_tables() { // Automations ct_register_table( 'automatorwp_automations', array( 'show_ui' => true, 'show_in_rest' => true, 'rest_base' => 'automatorwp-automations', 'version' => 4, 'capability' => automatorwp_get_manager_capability(), 'supports' => array( 'meta' ), 'views' => array( 'list' => array( 'parent_slug' => 'automatorwp', 'priority' => 10, ), ), 'schema' => array( 'id' => array( 'type' => 'bigint', 'length' => '20', 'auto_increment' => true, 'primary_key' => true, ), 'title' => array( 'type' => 'text', ), 'type' => array( 'type' => 'text', ), 'user_id' => array( 'type' => 'bigint', 'length' => '20', 'key' => true, ), 'sequential' => array( 'type' => 'tinyint', 'length' => '1', 'default' => '0', ), 'times_per_user' => array( 'type' => 'int', 'length' => '11', 'default' => '1', ), 'times' => array( 'type' => 'int', 'length' => '11', 'default' => '0', ), 'status' => array( 'type' => 'varchar', 'length' => '50', ), 'date' => array( 'type' => 'datetime', 'default' => '0000-00-00 00:00:00' ), 'expiration' => array( 'type' => 'datetime', 'default' => '0000-00-00 00:00:00' ), ), ) ); // Triggers ct_register_table( 'automatorwp_triggers', array( 'show_ui' => false, 'show_in_rest' => true, 'rest_base' => 'automatorwp-triggers', 'version' => 2, 'capability' => automatorwp_get_manager_capability(), 'supports' => array( 'meta' ), 'schema' => array( 'id' => array( 'type' => 'bigint', 'length' => '20', 'auto_increment' => true, 'primary_key' => true, ), 'automation_id' => array( 'type' => 'bigint', 'length' => '20', 'key' => true, ), 'title' => array( 'type' => 'text', ), 'type' => array( 'type' => 'text', ), 'status' => array( 'type' => 'varchar', 'length' => '50', ), 'position' => array( 'type' => 'int', 'length' => '11', 'default' => '0', ), 'date' => array( 'type' => 'datetime', 'default' => '0000-00-00 00:00:00' ), ), ) ); // Actions ct_register_table( 'automatorwp_actions', array( 'show_ui' => false, 'show_in_rest' => true, 'rest_base' => 'automatorwp-actions', 'version' => 2, 'capability' => automatorwp_get_manager_capability(), 'supports' => array( 'meta' ), 'schema' => array( 'id' => array( 'type' => 'bigint', 'length' => '20', 'auto_increment' => true, 'primary_key' => true, ), 'automation_id' => array( 'type' => 'bigint', 'length' => '20', 'key' => true, ), 'title' => array( 'type' => 'text', ), 'type' => array( 'type' => 'text', ), 'status' => array( 'type' => 'varchar', 'length' => '50', ), 'position' => array( 'type' => 'int', 'length' => '11', 'default' => '0', ), 'date' => array( 'type' => 'datetime', 'default' => '0000-00-00 00:00:00' ), ), ) ); // Logs ct_register_table( 'automatorwp_logs', array( 'show_ui' => true, 'show_in_rest' => true, 'rest_base' => 'automatorwp-logs', 'version' => 2, 'capability' => automatorwp_get_manager_capability(), 'supports' => array( 'meta' ), 'views' => array( 'list' => array( 'parent_slug' => 'automatorwp', 'priority' => 10, ), 'add' => false, ), 'schema' => array( 'id' => array( 'type' => 'bigint', 'length' => '20', 'auto_increment' => true, 'primary_key' => true, ), 'title' => array( 'type' => 'text', ), 'type' => array( 'type' => 'text', ), 'object_id' => array( 'type' => 'bigint', 'length' => '20', 'key' => true, ), 'user_id' => array( 'type' => 'bigint', 'length' => '20', 'key' => true, ), 'post_id' => array( 'type' => 'bigint', 'length' => '20', 'key' => true, ), 'date' => array( 'type' => 'datetime', 'default' => '0000-00-00 00:00:00' ), ), ) ); } add_action( 'ct_init', 'automatorwp_register_custom_tables' ); /** * Helper function to generate a where from a CT Query * * @since 1.0.0 * * @param array $query_vars The query vars * @param string $field_id The field id * @param string $table_field The table field key * @param string $field_type The field type (string|integer) * @param string $single_operator The single operator (=|!=) * @param string $array_operator The array operator (IN|NOT IN) * * @return string */ function automatorwp_custom_table_where( $query_vars, $field_id, $table_field = '', $field_type = 'string', $single_operator = '=', $array_operator = 'IN' ) { global $ct_table; $table_name = $ct_table->db->table_name; $where = ''; // Backward compatibility for automatorwp_custom_table_where( $query_vars, $field_id, $field_type ) if( in_array( $table_field, array( 'string', 'integer', 'text', 'int' ) ) ) { $table_field = $field_id; } // Shorthand $qv = $query_vars; // Type if( isset( $qv[$field_id] ) && ! empty( $qv[$field_id] ) ) { if( is_array( $qv[$field_id] ) ) { // Multiples values if( $field_type === 'string' || $field_type === 'text' ) { // Sanitize $value = array_map( 'esc_sql', $qv[$field_id] ); // Join values by a comma-separated list of strings $value = "'" . implode( "', '", $value ) . "'"; $where .= " AND {$table_name}.{$table_field} {$array_operator} ( {$value} )"; } else if( $field_type === 'integer' || $field_type === 'int' ) { // Sanitize $value = array_map( 'absint', $qv[$field_id] ); // Join values by a comma-separated list of integers $value = "'" . implode( ", ", $value ) . "'"; $where .= " AND {$table_name}.{$table_field} {$array_operator} ( {$value} )"; } } else { // Single value if( $field_type === 'string' || $field_type === 'text' ) { $value = esc_sql( $qv[$field_id] ); $where .= " AND {$table_name}.{$table_field} {$single_operator} '{$value}'"; } else if( $field_type === 'integer' || $field_type === 'int' ) { $value = absint( $qv[$field_id] ); $where .= " AND {$table_name}.{$table_field} {$single_operator} {$value}"; } } } return $where; } ```