S
S
Stacy None2017-05-09 14:22:49
PHP
Stacy None, 2017-05-09 14:22:49

How to fix a database query to display an avatar in DLE 11.1?

There is a certain module, it is for older versions of dle.
I have dle 11.1 in the module, everything works fine except for the user's avatar. If I understand correctly, then in older versions of dle there are other requests to the database to display the avatar. Please tell me how to fix the code so that the avatar is displayed in dle 11.1?
Here is part of the code:

$db->query("SELECT p.id, p.subj, p.text, p.user_from, p.date, u.foto FROM ".PREFIX."_pm as p, ".USERPREFIX."_users as u WHERE p.user_from=u.name AND p.pm_read='no' AND p.folder='inbox' AND p.user='{$member_id['user_id']}' ORDER BY p.id DESC");
  while($row = $db->get_row()) {
    $pm++;
    
    $foto = ( $row['foto'] AND (file_exists( ROOT_DIR."/uploads/fotos/{$row['foto']}" )) ) ? "/uploads/fotos/{$row['foto']}" : "/templates/{$config['skin']}/dleimages/noavatar.png";

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question