<?php

if (PHP_SAPI !== 'cli') {
	die('Comment this line to upgrade');
}

require __DIR__ . '/include/init.php';

$db = DB::getInstance();

$query = $db->iterate('SELECT id, password FROM membres WHERE LENGTH(password) = 32 AND SUBSTR(password, 1, 1) != \'$\';');
$update = $db->prepare('UPDATE membres SET password = ? WHERE id = ?;');

$db->begin();

foreach ($query as $row) {
	$password = password_hash($row->password, PASSWORD_DEFAULT);
	$update->execute([$password, $row->id]);
}

$db->commit();