$foto in pm.php

[arturcik 0]

sorry, i cant talk in russian, but i hope that some english guy could help me. So i need a $foto variable in engine/modules/pm.php . When i try to write a new $row = .......... i get a big problem: you can see only one (newest) message in all pm page. So is there any way to have a message sender avatar in INBOX page?

[Al-x 7]

arturcik,

if ($doaction == "outbox")

{

/////

}

else $sql = "SELECT id, subj, user_from, date, pm_read, reply FROM " . USERPREFIX . "_pm where user = '$member_id[user_id]' AND folder = 'inbox' order by date desc";

There is no foto info in _pm table. You shold modifi it or use join sql with _users table. I think it`s optimal (join sql), because in this way you can use sql without LEFT JOIN. Like this:

$sql = "SELECT pm.id, pm.subj, pm.user_from, pm.date, pm.pm_read, pm.reply, u.foto FROM " . USERPREFIX . "_pm pm, " . USERPREFIX . "_users u where pm.user_from=u.user_id AND pm.user = '$member_id[user_id]' AND pm.folder = 'inbox' order by pm.date desc";

so variable:

$row['foto'] /////

Изменено 22 августа 2007 пользователем Al-x

[arturcik 0]

something is wrong with your code, everything dissapears, but thanx for the hint, i will analyze and try to fix it by my self

Изменено 22 августа 2007 пользователем arturcik

[Al-x 7]

arturcik,

yes, you right.

pm.user_from=u.user_id

<>

pm.user_from=u.name

[Jeka009 2]

Al-x

а все тоже самое только по-русски

[arturcik 0]

really big thanks for you, Al-x now it works 100%

[Al-x 7]

DocentX,

фотки человек хотел получить в личных сообщениях....

[arturcik 0]

Al-x,

you write me the code of inbox folder, can you now find some time to help me with outbox? I cant get that combined sql method..