<?php
require_once 'includes/db.php';

$target_dir = __DIR__ . '/uploads/members/';
if(!is_dir($target_dir)) mkdir($target_dir, 0777, true);

// Image List
$images = [
    'male' => 'indian_male_1.png',
    'female' => 'indian_female_1.png',
    'young_male' => 'indian_young_male.png',
    'young_female' => 'indian_young_female.png',
    'adv_male' => 'adv_male.png',
    'adv_female' => 'adv_female.png'
];

// Update STATE cell members
$res = $conn->query("SELECT id FROM board_members WHERE cell='STATE' ORDER BY id");
$i = 0;
while($row = $res->fetch_assoc()) {
    $img_keys = ['male', 'female', 'young_male', 'young_female'];
    $img = $images[$img_keys[$i % 4]];
    $conn->query("UPDATE board_members SET image='$img' WHERE id=".$row['id']);
    $i++;
}

// Update LEGAL cell members
$res = $conn->query("SELECT id FROM board_members WHERE cell='LEGAL' ORDER BY id");
$i = 0;
while($row = $res->fetch_assoc()) {
    $img = ($i % 2 == 0) ? $images['adv_male'] : $images['adv_female'];
    $conn->query("UPDATE board_members SET image='$img' WHERE id=".$row['id']);
    $i++;
}

// Update MEDIA cell members
$res = $conn->query("SELECT id FROM board_members WHERE cell='MEDIA' ORDER BY id");
$i = 0;
while($row = $res->fetch_assoc()) {
    $img = ($i % 2 == 0) ? $images['young_male'] : $images['young_female'];
    $conn->query("UPDATE board_members SET image='$img' WHERE id=".$row['id']);
    $i++;
}

echo "Database Updated With Indian Dummy Avatars";
?>