{"slug":"aegilock-transaction-guardian-for-woocommerce","name":"Aegilock Transaction Guardian for WooCommerce","description":"Advanced transaction security for WooCommerce stores. Blocks bots, detects fraud patterns, protects revenue. Works instantly, no API key required.","author":"Thomas Röhrig","active_installs":0,"version":"1.0.24","wp_org_url":"https://wordpress.org/plugins/aegilock-transaction-guardian-for-woocommerce/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":true},"tables":[{"table_name":"aegilock_wc_fraud_logs","full_table_name":"wp_aegilock_wc_fraud_logs","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"order_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"fraud_score","type":"decimal(5,4)","nullable":false,"primary_key":false},{"name":"risk_factors","type":"longtext","nullable":true,"primary_key":false},{"name":"recommendation","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"action_taken","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"review_status","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"reviewed_at","type":"datetime","nullable":true,"primary_key":false},{"name":"reviewed_by","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"api_response","type":"longtext","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"date_recorded","type":"date","nullable":false,"primary_key":false},{"name":"orders_checked","type":"int(11)","nullable":true,"primary_key":false},{"name":"orders_blocked","type":"int(11)","nullable":true,"primary_key":false},{"name":"orders_held","type":"int(11)","nullable":true,"primary_key":false},{"name":"avg_fraud_score","type":"decimal(5,4)","nullable":true,"primary_key":false},{"name":"api_calls_used","type":"int(11)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_aegilock_wc_fraud_logs ( id bigint(20) NOT NULL AUTO_INCREMENT, order_id bigint(20) NOT NULL, fraud_score decimal(5,4) NOT NULL DEFAULT 0.0000, risk_factors longtext, recommendation varchar(20) DEFAULT 'allow', action_taken varchar(50) NOT NULL, review_status varchar(20) NULL, reviewed_at datetime NULL, reviewed_by bigint(20) NULL, api_response longtext, created_at datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY order_id (order_id), KEY fraud_score (fraud_score), KEY created_at (created_at) ) $charset_collate;\"; // Statistics table $sql .= \"CREATE TABLE IF NOT EXISTS wp_aegilock_wc_stats ( id bigint(20) NOT NULL AUTO_INCREMENT, date_recorded date NOT NULL, orders_checked int(11) DEFAULT 0, orders_blocked int(11) DEFAULT 0, orders_held int(11) DEFAULT 0, avg_fraud_score decimal(5,4) DEFAULT 0.0000, api_calls_used int(11) DEFAULT 0, PRIMARY KEY (id), UNIQUE KEY date_recorded (date_recorded) ) $charset_collate;\"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; try { $result = dbDelta( $sql );"},{"table_name":"aegilock_wc_stats","full_table_name":"wp_aegilock_wc_stats","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null}],"table_count":2}