20/04/2026 - 15:47:51 [ OPERATION OK ] Connected to 'rankrise_iwitintn9': [DBHOST] = localhost | [DBUSER] = rankrise_iwitintn9
20/04/2026 - 15:47:51 [ OPERATION OK ] SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'oc_t_usc_schema_version' LIMIT 1
20/04/2026 - 15:47:51 [ OPERATION OK ] SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'oc_t_usc_user_meta' LIMIT 1
20/04/2026 - 15:47:51 [ OPERATION OK ] SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'oc_t_usc_user_plans' LIMIT 1
20/04/2026 - 15:47:51 [ OPERATION OK ] SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'oc_t_usc_plans_config' LIMIT 1
20/04/2026 - 15:47:51 [ OPERATION OK ] SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'oc_t_usc_payments' LIMIT 1
20/04/2026 - 15:47:51 [ OPERATION OK ] CREATE TABLE IF NOT EXISTS `oc_t_usc_payment_logs` ( `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `payment_id` INT UNSIGNED NOT NULL DEFAULT 0, `user_id` INT UNSIGNED NOT NULL DEFAULT 0, `admin_id` INT UNSIGNED NOT NULL DEFAULT 0, `action_type` VARCHAR(50) NOT NULL DEFAULT '', `old_status` VARCHAR(30) NOT NULL DEFAULT '', `new_status` VARCHAR(30) NOT NULL DEFAULT '', `note` TEXT NULL, `meta` JSON NULL, `ip_address` VARCHAR(45) NOT NULL DEFAULT '', `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `idx_payment_id` (`payment_id`), KEY `idx_admin_id` (`admin_id`), KEY `idx_action` (`action_type`), KEY `idx_created` (`created_at`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
20/04/2026 - 15:47:51 [ OPERATION OK ] CREATE TABLE IF NOT EXISTS `oc_t_usc_schema_version` ( migration_id VARCHAR(60) NOT NULL, applied_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, description VARCHAR(255) NOT NULL DEFAULT '', PRIMARY KEY (migration_id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
20/04/2026 - 15:47:51 [ OPERATION OK ] SELECT migration_id FROM `oc_t_usc_schema_version` WHERE migration_id = '001_user_meta' LIMIT 1
20/04/2026 - 15:47:51 [ OPERATION OK ] SELECT migration_id FROM `oc_t_usc_schema_version` WHERE migration_id = '002_user_plans' LIMIT 1
20/04/2026 - 15:47:51 [ OPERATION OK ] SELECT migration_id FROM `oc_t_usc_schema_version` WHERE migration_id = '003_feature_usage' LIMIT 1
20/04/2026 - 15:47:51 [ OPERATION OK ] SELECT migration_id FROM `oc_t_usc_schema_version` WHERE migration_id = '004_plans_config' LIMIT 1
20/04/2026 - 15:47:51 [ OPERATION OK ] SELECT migration_id FROM `oc_t_usc_schema_version` WHERE migration_id = '005_audit_log' LIMIT 1
20/04/2026 - 15:47:51 [ OPERATION OK ] SELECT migration_id FROM `oc_t_usc_schema_version` WHERE migration_id = '006_enforce_log' LIMIT 1
20/04/2026 - 15:47:51 [ OPERATION OK ] SELECT migration_id FROM `oc_t_usc_schema_version` WHERE migration_id = '007_user_credits' LIMIT 1
20/04/2026 - 15:47:51 [ OPERATION OK ] SELECT migration_id FROM `oc_t_usc_schema_version` WHERE migration_id = '008_credit_transactions' LIMIT 1
20/04/2026 - 15:47:51 [ OPERATION OK ] SELECT migration_id FROM `oc_t_usc_schema_version` WHERE migration_id = '009_feature_pricing' LIMIT 1
20/04/2026 - 15:47:51 [ OPERATION OK ] SELECT migration_id FROM `oc_t_usc_schema_version` WHERE migration_id = '010_credit_packages' LIMIT 1
20/04/2026 - 15:47:51 [ OPERATION OK ] SELECT migration_id FROM `oc_t_usc_schema_version` WHERE migration_id = '011_user_plans_add_assigned_by' LIMIT 1
20/04/2026 - 15:47:51 [ OPERATION OK ] SELECT migration_id FROM `oc_t_usc_schema_version` WHERE migration_id = '012_enforce_log_add_plugin' LIMIT 1
20/04/2026 - 15:47:51 [ OPERATION OK ] SELECT migration_id FROM `oc_t_usc_schema_version` WHERE migration_id = '013_credit_tx_add_balance_after' LIMIT 1
20/04/2026 - 15:47:51 [ OPERATION OK ] SELECT migration_id FROM `oc_t_usc_schema_version` WHERE migration_id = '014_payments' LIMIT 1
20/04/2026 - 15:47:51 [ OPERATION OK ] SELECT migration_id FROM `oc_t_usc_schema_version` WHERE migration_id = '015_notifications' LIMIT 1
20/04/2026 - 15:47:51 [ OPERATION OK ] SELECT migration_id FROM `oc_t_usc_schema_version` WHERE migration_id = '016_analytics' LIMIT 1
20/04/2026 - 15:47:51 [ OPERATION OK ] SELECT migration_id FROM `oc_t_usc_schema_version` WHERE migration_id = '017_monetization_logs' LIMIT 1
20/04/2026 - 15:47:51 [ OPERATION OK ] SELECT migration_id FROM `oc_t_usc_schema_version` WHERE migration_id = '018_usc_credits_wallet' LIMIT 1
20/04/2026 - 15:47:51 [ OPERATION OK ] SELECT migration_id FROM `oc_t_usc_schema_version` WHERE migration_id = '019_usc_credit_tx_monetization' LIMIT 1
20/04/2026 - 15:47:51 [ OPERATION OK ] SELECT migration_id FROM `oc_t_usc_schema_version` WHERE migration_id = '020_ads_logs' LIMIT 1
20/04/2026 - 15:47:51 [ OPERATION OK ] SELECT migration_id FROM `oc_t_usc_schema_version` WHERE migration_id = '021_import_map' LIMIT 1
20/04/2026 - 15:47:51 [ OPERATION OK ] CREATE OR REPLACE VIEW `oc_v_usc_payment_summary` AS SELECT payment_method, status, COUNT(*) AS total, SUM(amount) AS total_amount, DATE(MAX(created_at)) AS last_payment_date FROM `oc_t_usc_payments` GROUP BY payment_method, status
20/04/2026 - 15:47:52 [ OPERATION OK ] CREATE OR REPLACE VIEW `oc_v_usc_payment_funnel` AS SELECT DATE(created_at) AS day, event, COUNT(*) AS total, COUNT(DISTINCT user_id) AS unique_users FROM `oc_t_usc_analytics` GROUP BY DATE(created_at), event ORDER BY day DESC, total DESC
20/04/2026 - 15:47:52 [ OPERATION OK ] CREATE OR REPLACE VIEW `oc_v_monetization_daily` AS SELECT DATE(created_at) AS day, action, COUNT(*) AS total_events, SUM(credits_used) AS total_credits_used FROM `oc_t_monetization_logs` GROUP BY DATE(created_at), action ORDER BY day DESC, total_events DESC
20/04/2026 - 15:47:52 [ OPERATION OK ] CREATE OR REPLACE VIEW `oc_v_monetization_top_features` AS SELECT feature_key, COUNT(*) AS total_activations, SUM(credits_used) AS total_credits, COUNT(DISTINCT user_id) AS unique_users FROM `oc_t_monetization_logs` WHERE action IN ('activated_subscription','activated_credits','purchase') GROUP BY feature_key ORDER BY total_activations DESC
20/04/2026 - 15:47:52 [ OPERATION OK ] CREATE OR REPLACE VIEW `oc_v_monetization_funnel` AS SELECT feature_key, SUM(action='view') AS views, SUM(action='blocked') AS blocked, SUM(action IN ('activated_subscription','activated_credits')) AS activated, SUM(action='upgrade') AS upgrade_clicks, ROUND(SUM(action IN ('activated_subscription','activated_credits')) / NULLIF(SUM(action='view'),0)*100,1) AS conversion_pct FROM `oc_t_monetization_logs` GROUP BY feature_key ORDER BY views DESC
20/04/2026 - 15:47:52 [ OPERATION OK ] SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'oc_t_usc_plans_config' LIMIT 1
20/04/2026 - 15:47:52 [ OPERATION OK ] INSERT IGNORE INTO `oc_t_usc_plans_config` (plan_key, feature_key, limit_value, reset_period) VALUES ('free', 'post_listing', 3, 'monthly')
20/04/2026 - 15:47:52 [ OPERATION OK ] INSERT IGNORE INTO `oc_t_usc_plans_config` (plan_key, feature_key, limit_value, reset_period) VALUES ('free', 'featured_listing', 0, 'monthly')
20/04/2026 - 15:47:52 [ OPERATION OK ] INSERT IGNORE INTO `oc_t_usc_plans_config` (plan_key, feature_key, limit_value, reset_period) VALUES ('free', 'image_upload', 5, 'monthly')
20/04/2026 - 15:47:52 [ OPERATION OK ] INSERT IGNORE INTO `oc_t_usc_plans_config` (plan_key, feature_key, limit_value, reset_period) VALUES ('pro', 'post_listing', -1, 'monthly')
20/04/2026 - 15:47:52 [ OPERATION OK ] INSERT IGNORE INTO `oc_t_usc_plans_config` (plan_key, feature_key, limit_value, reset_period) VALUES ('pro', 'featured_listing', 5, 'monthly')
20/04/2026 - 15:47:52 [ OPERATION OK ] INSERT IGNORE INTO `oc_t_usc_plans_config` (plan_key, feature_key, limit_value, reset_period) VALUES ('pro', 'image_upload', -1, 'monthly')
20/04/2026 - 15:47:52 [ OPERATION OK ] INSERT IGNORE INTO `oc_t_usc_plans_config` (plan_key, feature_key, limit_value, reset_period) VALUES ('vip', 'post_listing', -1, 'monthly')
20/04/2026 - 15:47:52 [ OPERATION OK ] INSERT IGNORE INTO `oc_t_usc_plans_config` (plan_key, feature_key, limit_value, reset_period) VALUES ('vip', 'featured_listing', -1, 'monthly')
20/04/2026 - 15:47:52 [ OPERATION OK ] INSERT IGNORE INTO `oc_t_usc_plans_config` (plan_key, feature_key, limit_value, reset_period) VALUES ('vip', 'image_upload', -1, 'monthly')
20/04/2026 - 15:47:52 [ OPERATION OK ] SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'oc_t_usc_feature_pricing' LIMIT 1
20/04/2026 - 15:47:52 [ OPERATION OK ] INSERT IGNORE INTO `oc_t_usc_feature_pricing` (feature_key, price_credits, is_active) VALUES ('featured_listing', 10, 1)
20/04/2026 - 15:47:52 [ OPERATION OK ] INSERT IGNORE INTO `oc_t_usc_feature_pricing` (feature_key, price_credits, is_active) VALUES ('boost_listing', 5, 1)
20/04/2026 - 15:47:52 [ OPERATION OK ] INSERT IGNORE INTO `oc_t_usc_feature_pricing` (feature_key, price_credits, is_active) VALUES ('highlight_listing', 3, 1)
20/04/2026 - 15:47:52 [ OPERATION OK ] SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'oc_t_usc_credit_packages' LIMIT 1
20/04/2026 - 15:47:52 [ OPERATION OK ] INSERT IGNORE INTO `oc_t_usc_credit_packages` (label, credits, price_usd, bonus_pct, is_popular, is_active, sort_order) VALUES ('Starter', 100, 4.99, 0, 0, 1, 1)
20/04/2026 - 15:47:52 [ OPERATION OK ] INSERT IGNORE INTO `oc_t_usc_credit_packages` (label, credits, price_usd, bonus_pct, is_popular, is_active, sort_order) VALUES ('Basic', 250, 9.99, 10, 0, 1, 2)
20/04/2026 - 15:47:52 [ OPERATION OK ] INSERT IGNORE INTO `oc_t_usc_credit_packages` (label, credits, price_usd, bonus_pct, is_popular, is_active, sort_order) VALUES ('Pro', 600, 19.99, 20, 1, 1, 3)
20/04/2026 - 15:47:52 [ OPERATION OK ] INSERT IGNORE INTO `oc_t_usc_credit_packages` (label, credits, price_usd, bonus_pct, is_popular, is_active, sort_order) VALUES ('Enterprise', 1500, 39.99, 30, 0, 1, 4)
20/04/2026 - 15:47:52 [ OPERATION OK ] SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'oc_t_usc_schema_version' LIMIT 1
20/04/2026 - 15:47:52 [ OPERATION OK ] SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'oc_t_usc_user_meta' LIMIT 1
20/04/2026 - 15:47:52 [ OPERATION OK ] SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'oc_t_usc_user_plans' LIMIT 1
20/04/2026 - 15:47:52 [ OPERATION OK ] SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'oc_t_usc_feature_usage' LIMIT 1
20/04/2026 - 15:47:52 [ OPERATION OK ] SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'oc_t_usc_plans_config' LIMIT 1
20/04/2026 - 15:47:52 [ OPERATION OK ] SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'oc_t_usc_audit_log' LIMIT 1
20/04/2026 - 15:47:52 [ OPERATION OK ] SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'oc_t_usc_enforce_log' LIMIT 1
20/04/2026 - 15:47:52 [ OPERATION OK ] SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'oc_t_usc_user_credits' LIMIT 1
20/04/2026 - 15:47:52 [ OPERATION OK ] SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'oc_t_usc_credit_transactions' LIMIT 1
20/04/2026 - 15:47:52 [ OPERATION OK ] SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'oc_t_usc_feature_pricing' LIMIT 1
20/04/2026 - 15:47:52 [ OPERATION OK ] SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'oc_t_usc_credit_packages' LIMIT 1
20/04/2026 - 15:47:52 [ OPERATION OK ] SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'oc_t_usc_payments' LIMIT 1
20/04/2026 - 15:47:52 [ OPERATION OK ] SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'oc_t_usc_notifications' LIMIT 1
20/04/2026 - 15:47:52 [ OPERATION OK ] SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'oc_t_usc_analytics' LIMIT 1
20/04/2026 - 15:47:52 [ OPERATION OK ] SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'oc_t_monetization_logs' LIMIT 1
20/04/2026 - 15:47:52 [ OPERATION OK ] SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'oc_t_usc_credits' LIMIT 1
20/04/2026 - 15:47:52 [ OPERATION OK ] SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'oc_t_ads_logs' LIMIT 1
20/04/2026 - 15:47:52 [ OPERATION OK ] SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'oc_t_usc_import_map' LIMIT 1
20/04/2026 - 15:47:52 [ OPERATION OK ] CREATE TABLE IF NOT EXISTS `oc_t_usc_payment_logs` ( `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `payment_id` INT UNSIGNED NOT NULL DEFAULT 0, `user_id` INT UNSIGNED NOT NULL DEFAULT 0, `admin_id` INT UNSIGNED NOT NULL DEFAULT 0, `action_type` VARCHAR(50) NOT NULL DEFAULT '', `old_status` VARCHAR(30) NOT NULL DEFAULT '', `new_status` VARCHAR(30) NOT NULL DEFAULT '', `note` TEXT NULL, `meta` JSON NULL, `ip_address` VARCHAR(45) NOT NULL DEFAULT '', `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `idx_payment_id` (`payment_id`), KEY `idx_admin_id` (`admin_id`), KEY `idx_action` (`action_type`), KEY `idx_created` (`created_at`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
20/04/2026 - 15:47:52 [ OPERATION OK ] Connection with 'rankrise_iwitintn9' released properly

Recherche

Prix

Condition

Transaction

Période

Paramètres supplémentaires

Aucune annonce trouvée