Profile Image

[ksgrg]

I am currently using the following PHP Script to inject the profile photo and it works perfectly and I can see the Photos if I visit the users from People but when the user would edit the profile it should just show a broken image URL as below

https://asset.mywebsite.com/uploads/avatars/https://mywebsite.com/photos/employee_num.jpg

How can I fix the edit profile page so that it has just the https://mywebsite.com/photos/employee_num.jpg instead of https://asset.mywebsite.com/uploads/avatars/https://mywebsite.com/photos/employee_num.jpg please

`<?php
// Database connection parameters
$servername = "localhost";
$username = "snipeit";
$password = "";
$dbname = "snipeit";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}

// Query users with non-empty employee_num field
$sql = "SELECT * FROM users WHERE employee_num IS NOT NULL AND employee_num <> ''";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
// Update avatar URLs for each user
while($row = $result->fetch_assoc()) {
$employee_num = $row['employee_num'];
$avatar_url = "https://mywebsite.com/photos/$employee_num.jpg";
$user_id = $row['id'];

    // Update the avatar field in the database
    $update_sql = "UPDATE users SET avatar = '$avatar_url' WHERE id = $user_id";
    if ($conn->query($update_sql) === TRUE) {
        echo "Avatar URL updated for user ID $user_id\n";
    } else {
        echo "Error updating avatar URL: " . $conn->error . "\n";
    }
}

} else {
echo "No users found with non-empty employee_num field\n";
}

// Close connection
$conn->close();
?>`

[ksgrg]

I was able to fix this by modifying the following file
/var/www/html/snipeit/resources/views/account# vi profile.blade.php

Changing
<img src="{{ Storage::disk('public')->url(app('users_upload_path').e($user->avatar)) }}" class="img-responsive">

to
<img src="{{ url($user->avatar) }}" width="150" height="150" class="img-responsive">

But I assume this will be overwritten when there's an upgrade or update on SnipeIT.
Is there a way I can do this without getting overwritten, please.