yourWBB | [WBB 2.3.x] Hacks und Addons

// Start Letzte 5 Beiträge $pop = $db->query("SELECT bb".$n."_threads.topic, bb".$n."_threads.threadid, bb".$n."_threads.lastposttime, bb".$n."_threads.views, bb".$n."_users.userid, bb".$n."_threads.boardid as parentid, bb".$n."_users.username, bb".$n."_boards.invisible FROM bb".$n."_threads LEFT JOIN bb".$n."_users ON (bb".$n."_users.userid=bb".$n."_threads.lastposterid) LEFT JOIN bb".$n."_boards ON (bb".$n."_boards.boardid=bb".$n."_threads.boardid) WHERE bb".$n."_boards.invisible=0 ORDER BY bb".$n."_threads.lastposttime DESC LIMIT 5"); while ($poptop = $db->fetch_array($pop)){ if(strlen($poptop[topic]) > '37') $poptop[topic] = "".substr($poptop[topic], 0, 34)."..."; $popthread .= "» <a href=\"thread.php?goto=lastpost&threadid=$poptop[threadid]&sid=$session[hash]\">$poptop[topic]</a><br>"; $lastposter .= "<a href=\"profile.php?userid=$poptop[userid]&sid=$session[hash]\">$poptop[username]</a><br>"; $popviews .= "$poptop[views] <br>"; } // Ende Letzte 5 Beiträge

code:

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:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:

<!--- Top 5 Start --->
<table cellpadding="{$style['tableincellpadding']}" cellspacing="{$style['tableincellspacing']}" border="{$style['tableinborder']}" style="width:{$style['tableinwidth']}" class="tableinborder">
  <tr>
    <td class="tabletitle" colspan="3"><span class="smallfont"><b>$master_board_name: Top Five Anzeige</b></span></td>
  </tr>
  <tr>
    <td valign="top" width="25%" class="tablea">
	<table cellpadding="{$style['tableincellpadding']}" cellspacing="{$style['tableincellspacing']}" border="{$style['tableinborder']}" width="100%" class="tableinborder">
        <tr>
          <td class="tablecat" align="center"><span class="smallfont"><b>Top 5 Poster:</b></span></td>
        </tr>
        <tr>
          <td valign="top" class="tableb"><table width="100%" border="0" cellspacing="0" cellpadding="3">
  <tr>
                <td class="smallfont"><b>Benutzername:</b></td>
                <td class="smallfont"><b>Beitr&auml;ge:</b></td>
  </tr>
  <tr>
                <td class="smallfont">$posts5name</td>
                <td class="smallfont">$posts5post</td>
  </tr>
</table></td>
        </tr>
      </table></td>
    <td valign="top" class="tablea" width="25%">
	<table cellpadding="{$style['tableincellpadding']}" cellspacing="{$style['tableincellspacing']}" border="{$style['tableinborder']}" width="100%" class="tableinborder">
        <tr>
          <td class="tablecat"><span class="smallfont"><b>Neueste Mitglieder:</b></span></td>
        </tr>
        <tr>
          <td valign="top" class="tableb" align="center"><table width="100%" border="0" cellspacing="0" cellpadding="3">
              <tr>
                <td class="smallfont"><b>Benutzername:</b></td>
                <td class="smallfont"><b>Beitr&auml;ge:</b></td>
              </tr>
              <tr>
                <td class="smallfont">$username</td>
                <td class="smallfont">$userposts</td>
              </tr>
            </table></td>
        </tr>
      </table></td>
    <td valign="top" class="tablea" align="center" height="50%">
	<table cellpadding="{$style['tableincellpadding']}" cellspacing="{$style['tableincellspacing']}" border="{$style['tableinborder']}" width="100%" class="tableinborder">
        <tr>
          <td class="tablecat"><span class="smallfont"><b>letzte Beitr&auml;ge:</b></span></td>
        </tr>
        <tr>
          <td valign="top" class="tableb"><table width="100%" border="0" cellspacing="0" cellpadding="3">
              <tr>
                <td class="smallfont"><b>Benutzername:</b></td>
                <td class="smallfont"><b>Beitr&auml;ge:</b></td>
              </tr>
              <tr>
                <td class="smallfont">$lastposter</td>
                <td class="smallfont">$popthread</td>
              </tr>
            </table></td>
        </tr>
      </table></td>
  </tr>
  <tr>
<td colspan="2" class="tablea"><span style="font-size: 10px"><b>Top Thema: $pop1title | $pop1views klicks.</b></span></td>
<td class="tablea" align="right"><span style="font-size: 10px"><b>Top Bewertung: $votedthread | $votedrating Stimmen.</b></span></td>
</tr>
</table>
<!--- Top 5 Ende --->