simple-skin-import.php

Skin Questions Import

\n”;

global $wpdb;

// Just the skin questions from local database
$questions = $wpdb->get_results(“SELECT * FROM wp_ennu_assessment_questions WHERE assessment_type = ‘skin’ ORDER BY sort_order”, ARRAY_A);

echo “

Found ” . count($questions) . ” skin questions to import

\n”;

if (empty($questions)) {
die(“

❌ No skin questions found!

“);
}

$success = 0;
$errors = 0;

echo “

Import Progress:

\n”;
echo “

\n”;

foreach ($questions as $question) {
// Check if question already exists
$exists = $wpdb->get_var($wpdb->prepare(”
SELECT id FROM wp_ennu_assessment_questions
WHERE assessment_type = %s AND question_key = %s
“, ‘skin’, $question[‘question_key’]));

if ($exists) {
// Update existing
$result = $wpdb->update(
‘wp_ennu_assessment_questions’,
array(
‘question_text’ => $question[‘question_text’],
‘question_type’ => $question[‘question_type’],
‘options’ => $question[‘options’],
‘is_required’ => $question[‘is_required’],
‘scoring_config’ => $question[‘scoring_config’],
‘sort_order’ => $question[‘sort_order’],
‘is_active’ => $question[‘is_active’],
‘updated_at’ => current_time(‘mysql’)
),
array(‘id’ => $exists),
array(‘%s’, ‘%s’, ‘%s’, ‘%d’, ‘%s’, ‘%d’, ‘%d’, ‘%s’),
array(‘%d’)
);

if ($result !== false) {
echo “

• ✅ Updated: {$question[‘question_key’]}

\n”;
$success++;
} else {
echo “

• ❌ Update failed: {$question[‘question_key’]} – ” . $wpdb->last_error . “

\n”;
$errors++;
}
} else {
// Insert new
$result = $wpdb->insert(
‘wp_ennu_assessment_questions’,
array(
‘assessment_type’ => $question[‘assessment_type’],
‘question_key’ => $question[‘question_key’],
‘question_text’ => $question[‘question_text’],
‘question_type’ => $question[‘question_type’],
‘options’ => $question[‘options’],
‘is_required’ => $question[‘is_required’],
‘scoring_config’ => $question[‘scoring_config’],
‘sort_order’ => $question[‘sort_order’],
‘is_active’ => $question[‘is_active’],
‘created_at’ => current_time(‘mysql’),
‘updated_at’ => current_time(‘mysql’)
),
array(‘%s’, ‘%s’, ‘%s’, ‘%s’, ‘%s’, ‘%d’, ‘%s’, ‘%d’, ‘%d’, ‘%s’, ‘%s’)
);

if ($result) {
echo “

• ✅ Inserted: {$question[‘question_key’]}

\n”;
$success++;
} else {
echo “

• ❌ Insert failed: {$question[‘question_key’]} – ” . $wpdb->last_error . “

\n”;
$errors++;
}
}
}

echo “

\n”;

echo “

Import Summary:

\n”;
echo “

✅ Success: $success

\n”;
echo “

❌ Errors: $errors

\n”;

// Verify the import
$count = $wpdb->get_var(“SELECT COUNT(*) FROM wp_ennu_assessment_questions WHERE assessment_type = ‘skin'”);
echo “

???? Total skin questions in database: $count

\n”;

if ($count > 0) {
echo “

???? Skin questions successfully imported!

\n”;
} else {
echo “

❌ Import failed – no questions found in database

\n”;
}
?>