🚀 User Suite
Intelligence & Growth v1.0.0
📊 Overview
v1.0.0 Settings
👥
1,144
Total Users
281
Active
🚫
863
Inactive
🆕
0
Today
📅
2
This Week
🎯
27
Valid Refs
✉️
0
Magic Logins
📈
100%
Ref Conv.
New Registrations (30 days)
Referrals (7 days)
System Summary
Magic Login On
Active Refs 27
Pending Refs 0
Referrers 1
Magic Tokens 0
Active Tokens 0
Log Retention 90 days
Animations - ichri W irbah | Annonces Gratuites en Tunisie - Vente & Achat Facile

Immobilier

Informatique

Véhicules

Emploi

Freelance

Multimédia

Services

Evènements

Vêtements

Loisirs

Autres

Debug mode enabled in config.php.
20/04/2026 - 20:36:31 [ OPERATION OK ] Connected to 'rankrise_iwitintn9': [DBHOST] = localhost | [DBUSER] = rankrise_iwitintn9
20/04/2026 - 20:36:31 [ OPERATION OK ] SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'rankrise_iwitintn9' AND TABLE_NAME = 'oc_t_usc_user_meta' LIMIT 1
20/04/2026 - 20:36:31 [ OPERATION OK ] SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'rankrise_iwitintn9' AND TABLE_NAME = 'oc_t_usc_user_plans' LIMIT 1
20/04/2026 - 20:36:31 [ OPERATION OK ] SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'rankrise_iwitintn9' AND TABLE_NAME = 'oc_t_usc_feature_usage' LIMIT 1
20/04/2026 - 20:36:31 [ OPERATION OK ] SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'rankrise_iwitintn9' AND TABLE_NAME = 'oc_t_usc_plans_config' LIMIT 1
20/04/2026 - 20:36:31 [ OPERATION OK ] SELECT COUNT(*) AS c FROM oc_t_user
20/04/2026 - 20:36:31 [ OPERATION OK ] SELECT COUNT(*) AS c FROM oc_t_user WHERE b_active=1
20/04/2026 - 20:36:31 [ OPERATION OK ] SELECT COUNT(*) AS c FROM oc_t_user WHERE b_active=0
20/04/2026 - 20:36:31 [ OPERATION OK ] SELECT COUNT(*) AS c FROM oc_t_user WHERE DATE(dt_reg_date)=CURDATE()
20/04/2026 - 20:36:31 [ OPERATION OK ] SELECT COUNT(*) AS c FROM oc_t_user WHERE dt_reg_date >= DATE_SUB(NOW(), INTERVAL 7 DAY)
20/04/2026 - 20:36:31 [ OPERATION OK ] SELECT COUNT(DISTINCT ref_id) AS c FROM oc_t_referral
20/04/2026 - 20:36:31 [ OPERATION OK ] SELECT COUNT(*) AS c FROM oc_t_referral WHERE status='Valid'
20/04/2026 - 20:36:31 [ OPERATION FAILED ] SELECT COUNT(*) AS c FROM oc_uigs_magic_tokens | Table 'rankrise_iwitintn9.oc_uigs_magic_tokens' doesn't exist (1146)
20/04/2026 - 20:36:31 [ OPERATION FAILED ] SELECT COUNT(*) AS c FROM oc_uigs_magic_tokens WHERE is_used=1 | Table 'rankrise_iwitintn9.oc_uigs_magic_tokens' doesn't exist (1146)
20/04/2026 - 20:36:31 [ OPERATION OK ] SELECT DATE(dt_reg_date) AS d, COUNT(*) AS cnt FROM oc_t_user WHERE dt_reg_date >= DATE_SUB(CURDATE(), INTERVAL 30 DAY) GROUP BY DATE(dt_reg_date) ORDER BY d ASC
20/04/2026 - 20:36:31 [ OPERATION OK ] SELECT COUNT(*) AS c FROM oc_t_referral
20/04/2026 - 20:36:31 [ OPERATION OK ] SELECT COUNT(*) AS c FROM oc_t_referral WHERE status='Valid'
20/04/2026 - 20:36:31 [ OPERATION OK ] SELECT COUNT(*) AS c FROM oc_t_referral WHERE status='Pending'
20/04/2026 - 20:36:31 [ OPERATION OK ] SELECT COUNT(DISTINCT ref_id) AS c FROM oc_t_referral
20/04/2026 - 20:36:31 [ OPERATION OK ] SELECT DATE(date) AS d, COUNT(*) AS cnt FROM oc_t_referral WHERE date >= DATE_SUB(CURDATE(), INTERVAL 7 DAY) GROUP BY DATE(date) ORDER BY d ASC
20/04/2026 - 20:36:31 [ OPERATION FAILED ] SELECT COUNT(*) AS total, SUM(is_used=1) AS used, SUM(is_used=0 AND expires_at > NOW()) AS active, SUM(is_used=0 AND expires_at <= NOW()) AS expired FROM oc_uigs_magic_tokens | Table 'rankrise_iwitintn9.oc_uigs_magic_tokens' doesn't exist (1146)
20/04/2026 - 20:36:31 [ OPERATION OK ] CREATE TABLE IF NOT EXISTS `oc_t_usc_payments` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `user_id` INT(11) UNSIGNED NOT NULL, `purchase_type` VARCHAR(20) NOT NULL DEFAULT 'plan', `purchase_ref` VARCHAR(50) NOT NULL DEFAULT '', `credits_amount` INT(11) NOT NULL DEFAULT 0, `amount` DECIMAL(10,2) NOT NULL DEFAULT 0.00, `currency` VARCHAR(10) NOT NULL DEFAULT 'TND', `payment_method` VARCHAR(20) NOT NULL DEFAULT 'bank', `status` VARCHAR(20) NOT NULL DEFAULT 'pending', `idempotency_key` VARCHAR(64) DEFAULT NULL COMMENT 'Prevents duplicate payments', `reference_code` VARCHAR(30) DEFAULT NULL, `proof_image` VARCHAR(255) DEFAULT NULL, `transaction_id` VARCHAR(100) DEFAULT NULL, `gateway_payload` TEXT DEFAULT NULL, `admin_note` VARCHAR(500) DEFAULT NULL, `reviewed_by` INT(11) DEFAULT NULL, `reviewed_at` DATETIME DEFAULT NULL, `expires_at` DATETIME DEFAULT NULL, `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `uq_reference` (`reference_code`), UNIQUE KEY `uq_idempotency` (`idempotency_key`), KEY `idx_user` (`user_id`), KEY `idx_status` (`status`), KEY `idx_method` (`payment_method`), KEY `idx_type` (`purchase_type`), KEY `idx_created` (`created_at`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
20/04/2026 - 20:36:31 [ OPERATION OK ] CREATE TABLE IF NOT EXISTS `oc_t_usc_audit_log` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `payment_id` INT(11) NOT NULL, `action` VARCHAR(50) NOT NULL, `from_state` VARCHAR(20) DEFAULT NULL, `to_state` VARCHAR(20) DEFAULT NULL, `actor_id` INT(11) DEFAULT NULL, `meta` TEXT DEFAULT NULL, `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `idx_payment` (`payment_id`), KEY `idx_action` (`action`), KEY `idx_date` (`created_at`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
20/04/2026 - 20:36:31 [ OPERATION OK ] CREATE TABLE IF NOT EXISTS `oc_t_usc_events_log` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `event_type` VARCHAR(50) NOT NULL, `payload` TEXT DEFAULT NULL, `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `idx_event` (`event_type`), KEY `idx_date` (`created_at`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
20/04/2026 - 20:36:31 [ OPERATION OK ] CREATE TABLE IF NOT EXISTS `oc_t_usc_notifications` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `user_id` INT(11) UNSIGNED NOT NULL, `type` VARCHAR(30) NOT NULL DEFAULT 'info', `title` VARCHAR(120) NOT NULL DEFAULT '', `message` VARCHAR(500) NOT NULL DEFAULT '', `icon` VARCHAR(10) DEFAULT NULL, `link` VARCHAR(255) DEFAULT NULL, `is_read` TINYINT(1) NOT NULL DEFAULT 0, `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `idx_user` (`user_id`), KEY `idx_read` (`is_read`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
20/04/2026 - 20:36:31 [ OPERATION OK ] CREATE TABLE IF NOT EXISTS `oc_t_usc_analytics` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `user_id` INT(11) UNSIGNED NOT NULL DEFAULT 0, `event` VARCHAR(50) NOT NULL DEFAULT '', `meta` VARCHAR(500) DEFAULT NULL, `ip` VARCHAR(45) DEFAULT NULL, `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `idx_user` (`user_id`), KEY `idx_event` (`event`), KEY `idx_date` (`created_at`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
20/04/2026 - 20:36:31 [ OPERATION OK ] Connection with 'rankrise_iwitintn9' released properly