25 lines
668 B
PHP
25 lines
668 B
PHP
<?php
|
|
|
|
/**
|
|
* This migration script updates the avatar field of the user table to use the new avatar path.
|
|
*/
|
|
|
|
/** @noinspection PhpUndefinedVariableInspection */
|
|
$sql = "SELECT avatar FROM user";
|
|
$stmt = $db->prepare($sql);
|
|
$result = $stmt->execute();
|
|
$row = $result->fetchArray(SQLITE3_ASSOC);
|
|
|
|
if ($row) {
|
|
$avatar = $row['avatar'];
|
|
|
|
if (strlen($avatar) < 2) {
|
|
$avatarFullPath = "images/avatars/" . $avatar . ".svg";
|
|
$sql = "UPDATE user SET avatar = :avatarFullPath";
|
|
$stmt = $db->prepare($sql);
|
|
$stmt->bindValue(':avatarFullPath', $avatarFullPath, SQLITE3_TEXT);
|
|
$stmt->execute();
|
|
}
|
|
}
|
|
|
|
?>
|