Last 10 News Submissions sent by...

New Member Joined: Jun 10, 2003 Posts: 5

hi there,

I got a problem with Your_Account Module

the problem is that when I try to look info for any user,
it doesn't show Last 10 comments or subsions !

while, when I login in into my account
I can see last 10 comments and subsions ?

has anybody has a clue what could it be?

I look forward to hear from anyone

thank you,

ohh yeah, this is my code for index.php in Your_Account folder

Quote:

OpenTable();
echo ""._LAST10COMMENTS." $username: ";
$sql6 = "SELECT tid, sid, subject FROM ".$prefix."_comments WHERE name='$username' ORDER BY tid DESC LIMIT 0,10";
$result6 = $db->sql_query($sql6);
while($row6 = $db->sql_fetchrow($result6)) {
$tid = $row6[tid];
$sid = $row6[sid];
$subject = $row6[subject];
echo "<li><a href=\"modules.php?name=News&file=article&thold=-1&mode=flat&order=0&sid=$sid#$tid\">$subject</a> ";
}
CloseTable();
echo " ";
OpenTable();
echo ""._LAST10SUBMISSIONS." $username: ";
$sql7 = "SELECT sid, title FROM ".$prefix."_stories WHERE informant='$username' ORDER BY sid DESC LIMIT 0,10";
$result7 = $db->sql_query($sql7);
while($row7 = $db->sql_fetchrow($result7)) {
$sid = $row7[sid];
$title = $row7[title];
echo "<li><a href=\"article.html$sid\">$title</a> ";
}
CloseTable();

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

Open modules/Your_Account/index.php and find:

Code:

    echo "<b>"._LAST10COMMENTS." $username:</b><br>";


    $sql6 = "SELECT tid, sid, subject FROM ".$prefix."_comments WHERE name='$username' ORDER BY tid DESC LIMIT 0,10";

Replace with:

Code:

    echo "<b>"._LAST10COMMENTS." $userinfo[username]:</b><br>";


    $sql6 = "SELECT tid, sid, subject FROM ".$prefix."_comments WHERE name='$userinfo[username]' ORDER BY tid DESC LIMIT 0,10";

Also find:

Code:

    echo "<b>"._LAST10SUBMISSIONS." $username:</b><br>";


    $sql7 = "SELECT sid, title FROM ".$prefix."_stories WHERE informant='$username' ORDER BY sid DESC LIMIT 0,10";

Replace with:

Code:

    echo "<b>"._LAST10SUBMISSIONS." $userinfo[username]:</b><br>";


    $sql7 = "SELECT sid, title FROM ".$prefix."_stories WHERE informant='$userinfo[username]' ORDER BY sid DESC LIMIT 0,10";