1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:

/* users lastpost */
    $showlastpost = 0;
    if ($showlastpostinprofile == 1 && $wbbuserdata['can_enter_board'] == 1) {
        $boardids = '';
    
        $permissioncache = getPermissions();
    
        $result = $db->unbuffered_query("SELECT boardid, password, invisible FROM bb".$n."_boards");
        while ($row = $db->fetch_array($result)) {
            if ($row['password'] != '' || $row['invisible'] == 2) continue;
            if (!isset($permissioncache[$row['boardid']]['can_enter_board']) || $permissioncache[$row['boardid']]['can_enter_board'] != 0) $boardids .= ",".$row['boardid'];
        }
    
        if ($boardids != '') {
            $lastpost = $db->query_first("SELECT p.postid, p.posttime, t.topic, t.boardid, b.title FROM bb".$n."_posts p, bb".$n."_threads t
            LEFT JOIN bb".$n."_boards b ON (t.boardid=b.boardid)
            WHERE p.threadid=t.threadid AND t.boardid IN (0$boardids) AND p.userid = '$userid' AND p.visible=1
            ORDER BY p.posttime DESC", 1);
            if ($lastpost['postid']) {
                $lastpostdate = formatdate($wbbuserdata['dateformat'], $lastpost['posttime'], 1);
                $lastposttime = formatdate($wbbuserdata['timeformat'], $lastpost['posttime']);
    
                $lastpost['topic'] = htmlconverter(textwrap($lastpost['topic']));
                $lastpost['title'] = getlangvar($lastpost['title'], $lang);
                $showlastpost = 1;
            }
        }
    }

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:

/* users lastpost */
    $lastpostanzahl = 10;
    $lang->items['LANG_MEMBERS_PROFILE_LASTPOST'] = $lang->get("LANG_MEMBERS_PROFILE_LASTPOST", array('$lastpostanzahl' => $lastpostanzahl));
    $showlastpost = 0;
    if ($showlastpostinprofile == 1 && $wbbuserdata['can_enter_board'] == 1) {
        $boardids = '';
    
        $permissioncache = getPermissions();
    
        $result = $db->unbuffered_query("SELECT boardid, password, invisible FROM bb".$n."_boards");
        while ($row = $db->fetch_array($result)) {
            if ($row['password'] != '' || $row['invisible'] == 2) continue;
            if (!isset($permissioncache[$row['boardid']]['can_enter_board']) || $permissioncache[$row['boardid']]['can_enter_board'] != 0) $boardids .= ",".$row['boardid'];
        }
    
        if ($boardids != '') {
            $lastpost_db = $db->query("SELECT p.postid, p.posttime, t.topic, t.boardid, b.title FROM bb".$n."_posts p, bb".$n."_threads t
            LEFT JOIN bb".$n."_boards b ON (t.boardid=b.boardid)
            WHERE p.threadid=t.threadid AND t.boardid IN (0$boardids) AND p.userid = '$userid' AND p.visible=1
            ORDER BY p.posttime DESC LIMIT $lastpostanzahl");
            while($lastpost = $db->fetch_array($lastpost_db)) {
                if ($lastpost['postid']) {
                    $lastpostdate = formatdate($wbbuserdata['dateformat'], $lastpost['posttime'], 1);
                    $lastposttime = formatdate($wbbuserdata['timeformat'], $lastpost['posttime']);
        
                    $lastpost['topic'] = htmlconverter(textwrap($lastpost['topic']));
                    $lastpost['title'] = getlangvar($lastpost['title'], $lang);
                    $showlastpost = 1;
                    $rowclass=getone($count++,"tablea","tableb");
                    eval("\$profile_lastposts .= \"".$tpl->get("profile_lastposts")."\";");
                }
            }
        }
    }

1:
2:
3:
4:
5:

<tr>
  <td><span class="smallfont">&raquo; <b><a href="thread.php?postid=$lastpost[postid]{$SID_ARG_2ND}#post$lastpost[postid]">$lastpost[topic]</a></b></span></td>
  <td><span class="smallfont">{$lang->items['LANG_MEMBERS_PROFILE_POSTED_ON']} $lastpostdate <span class="time">$lastposttime</span></td>
  <td><span class="smallfont">{$lang->items['LANG_MEMBERS_PROFILE_FORUM']} <b><a href="board.php?boardid=$lastpost[boardid]{$SID_ARG_2ND}">$lastpost[title]</a></b></span></td>
</tr>

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:

<if($showlastpost==1)>
    <then>
     <tr align="left">
      <td><span class="normalfont"><b>{$lang->items['LANG_MEMBERS_PROFILE_LASTPOST']}</b></span></td>
      <td><span class="normalfont"><b>&raquo; <a href="thread.php?postid=$lastpost[postid]{$SID_ARG_2ND}#post$lastpost[postid]">$lastpost[topic]</a></b></span><br />
      <span class="smallfont">{$lang->items['LANG_MEMBERS_PROFILE_POSTED_ON']} $lastpostdate <span class="time">$lastposttime</span><br />
      {$lang->items['LANG_MEMBERS_PROFILE_FORUM']} <b><a href="board.php?boardid=$lastpost[boardid]{$SID_ARG_2ND}">$lastpost[title]</a></b></span></td>
     </tr>
    </then>
   </if>

1:
2:
3:
4:
5:
6:
7:
8:

<if($showlastpost==1)>
    <then>
     <tr align="left">
      <td valign="top"><span class="normalfont"><b>{$lang->items['LANG_MEMBERS_PROFILE_LASTPOST']}</b></span></td>
      <td><table border="0" width="100%" align="left">$profile_lastposts</table></td>
     </tr>
    </then>
   </if>