comprehensive-assessment-fix.php

COMPREHENSIVE ASSESSMENT FIX – ALL ASSESSMENTS

\n”;

global $wpdb;

// ALL assessment types that need to work
$all_assessments = array(
‘health’,
‘weight-loss’,
‘skin’,
‘hair’,
‘testosterone’,
‘hormone’,
‘sleep’,
‘menopause’,
‘ed-treatment’,
‘peptide-therapy’,
‘health-optimization’,
‘welcome’
);

echo “

Step 1: Import ALL Missing Configs

\n”;

foreach ($all_assessments as $assessment_type) {
$config_type = str_replace(‘-‘, ‘_’, $assessment_type); // Convert to config format

echo “

Processing: $assessment_type (config: $config_type)

\n”;

// Check if questions config exists
$questions_config_exists = $wpdb->get_var($wpdb->prepare(”
SELECT COUNT(*) FROM wp_ennu_assessment_configs
WHERE assessment_type = %s AND config_key = ‘questions’
“, $config_type));

if ($questions_config_exists > 0) {
echo “

✅ Questions config already exists for $config_type

\n”;
} else {
echo “

⚠️ Missing questions config for $config_type – importing…

\n”;

// Get from local database
$local_config = $wpdb->get_row($wpdb->prepare(”
SELECT config_value, data_type, sort_order, is_active
FROM wp_ennu_assessment_configs
WHERE assessment_type = %s AND config_key = ‘questions’
“, $config_type), ARRAY_A);

if ($local_config) {
$result = $wpdb->insert(
‘wp_ennu_assessment_configs’,
array(
‘assessment_type’ => $config_type,
‘config_key’ => ‘questions’,
‘config_value’ => $local_config[‘config_value’],
‘data_type’ => $local_config[‘data_type’],
‘sort_order’ => $local_config[‘sort_order’],
‘is_active’ => $local_config[‘is_active’],
‘created_at’ => current_time(‘mysql’),
‘updated_at’ => current_time(‘mysql’)
),
array(‘%s’, ‘%s’, ‘%s’, ‘%s’, ‘%d’, ‘%d’, ‘%s’, ‘%s’)
);

if ($result) {
echo “

✅ Imported questions config for $config_type

\n”;
} else {
echo “

❌ Failed to import questions config for $config_type: ” . $wpdb->last_error . “

\n”;
}
} else {
echo “

⚠️ No local questions config found for $config_type

\n”;
}
}

// Import other essential configs
$essential_configs = array(‘pillar_weights’, ‘scoring_method’, ‘assessment_engine’);

foreach ($essential_configs as $config_key) {
$exists = $wpdb->get_var($wpdb->prepare(”
SELECT COUNT(*) FROM wp_ennu_assessment_configs
WHERE assessment_type = %s AND config_key = %s
“, $config_type, $config_key));

if ($exists == 0) {
// Get from local
$local_config = $wpdb->get_row($wpdb->prepare(”
SELECT config_value, data_type, sort_order, is_active
FROM wp_ennu_assessment_configs
WHERE assessment_type = %s AND config_key = %s
“, $config_type, $config_key), ARRAY_A);

if ($local_config) {
$result = $wpdb->insert(
‘wp_ennu_assessment_configs’,
array(
‘assessment_type’ => $config_type,
‘config_key’ => $config_key,
‘config_value’ => $local_config[‘config_value’],
‘data_type’ => $local_config[‘data_type’],
‘sort_order’ => $local_config[‘sort_order’],
‘is_active’ => $local_config[‘is_active’],
‘created_at’ => current_time(‘mysql’),
‘updated_at’ => current_time(‘mysql’)
),
array(‘%s’, ‘%s’, ‘%s’, ‘%s’, ‘%d’, ‘%d’, ‘%s’, ‘%s’)
);

if ($result) {
echo “

✅ Imported $config_key for $config_type

\n”;
}
}
}
}
}

echo “

Step 2: Test ALL Assessments with UDM

\n”;

if (class_exists(‘ENNU_Universal_Data_Manager’)) {
$udm = ENNU_Universal_Data_Manager::get_instance();

echo “

\n”;

foreach ($all_assessments as $assessment_type) {
$config = $udm->get_assessment_config($assessment_type);
$question_count = isset($config[‘questions’]) ? count($config[‘questions’]) : 0;

if ($question_count > 0) {
$status = “✅ WORKING”;
$row_color = “background: #d4f6d4;”;
} else {
$status = “❌ BROKEN”;
$row_color = “background: #f5c6cb;”;
}

echo “

\n”;
echo “

\n”;
echo “

\n”;
echo “

\n”;
}

echo “

\n”;
} else {
echo “

❌ UDM class not found

\n”;
}

echo “

???? FINAL STATUS

\n”;
echo “

Check the table above to see which assessments are now working.

\n”;
?>