that shouldnt be a problem...
FIND:
PHP Code:
SELECT
user.avatarid AS a_id,
avatar.avatarpath AS a_path,
customavatar.userid AS c_id,
customavatar.dateline AS dateline,
profiletagboard.msg AS msg,
profiletagboard.fromuserid AS fromuserid,
profiletagboard.touserid AS touserid,
user.username AS username,
user.userid AS userid,
user.usertitle AS title,
profiletagboard.id AS id
FROM avatar,customavatar,profiletagboard
LEFT JOIN user ON user.userid=profiletagboard.fromuserid
WHERE
touserid='$userinfo[userid]' AND user.avatarid=avatar.avatarid
OR touserid='$userinfo[userid]' AND user.avatarid='0' AND user.userid=customavatar.userid
OR touserid='$userinfo[userid]' AND user.avatarid='0' AND user.userid!=customavatar.userid
GROUP BY msg ORDER BY id DESC
and replace with: (2 times)
PHP Code:
SELECT
profiletagboard.msg AS msg,
profiletagboard.fromuserid AS fromuserid,
profiletagboard.touserid AS touserid,
user.username AS username,
user.userid AS userid,
user.usertitle AS title,
profiletagboard.id AS id
FROM profiletagboard
LEFT JOIN user ON user.userid=profiletagboard.fromuserid
WHERE
touserid='$userinfo[userid]'
GROUP BY msg ORDER BY id DESC
FIND and delete: (2 times)
PHP Code:
if ($result[a_id] == "0" AND $result[c_id] == "$result[userid]") {
$tbavatar="avatar.php?userid=$result[userid]&dateline=$result[dateline]";
};
if ($result[a_id] == "0" AND $result[c_id] != "$result[userid]") {
$tbavatar="avatar.php?userid=$result[userid]&dateline=$result[dateline]";
};
if ($result[a_id] != "0") {
$tbavatar="$result[a_path]";
};
I haven't tested this but i think it works