Prima data editam:
Cod: Selectaţi tot
// Cate topicuri sa apara?
$topicnumber =10;
Cod: Selectaţi tot
// Calea catre forum
$urlPath = "./forum/";
Cod: Selectaţi tot
// Unde se afla configul ?
include './forum/config.php';
Cod: Selectaţi tot
<?php
// Cate topicuri sa apara?
$topicnumber =10;
// Calea catre forum
$urlPath = "./forum/";
// Unde se afla configul ?
include './forum/config.php';
$table_topics = $table_prefix. "topics";
$table_forums = $table_prefix. "forums";
$table_posts = $table_prefix. "posts";
$table_users = $table_prefix. "users";
$link = mysql_connect("$dbhost", "$dbuser", "$dbpasswd") or die("Could not connect");
mysql_select_db("$dbname") or die("Could not select database");
$query = "SELECT t.topic_id, t.topic_title, t.topic_last_post_id, t.forum_id, p.post_id, p.poster_id, p.post_time, u.user_id, u.username
FROM $table_topics t, $table_forums f, $table_posts p, $table_users u
WHERE t.topic_id = p.topic_id AND
f.forum_id = t.forum_id AND
t.forum_id != 4 AND
t.topic_status <> 2 AND
p.post_id = t.topic_last_post_id AND
p.poster_id = u.user_id
ORDER BY p.post_time DESC LIMIT $topicnumber";
$result = mysql_query($query) or die("Query failed");
?>
<table class="table table-condensed">
<thead>
<tr class="text-warning">
<td> Topic </td>
<td> Nume </td>
</tr>
</thead>
<tbody>
<?
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
if(strlen($row["topic_title"])>12)
{
$topic = "".substr($row["topic_title"],0,12)."..";
}
else
{
$topic = $row["topic_title"];
}
$date = date('d-m, g:i', $row["post_time"]);
if(strlen($date)>12)
{
$data= "".substr($date,0,12)."..";
}
else
{
$data = $date;
}
if(strlen($row["username"])>9)
{
$nume = "".substr($row["username"],0,9)."..";
}
else
{
$nume = $row["username"];
}
echo "<tr><td><a href='$urlPath/viewtopic.php?f=$row[forum_id]&t=$row[topic_id]&p=$row[post_id]#p$row[post_id]' TARGET='_blank'>".$topic.
"</a></td><td width='15%'><a href='$urlPath/memberlist.php?mode=viewprofile&u=$row[user_id]'>".$nume."</td><td>".$data."</td></tr>";
}
?>
</tbody>
</table>
<?
mysql_free_result($result);
mysql_close($link);
?>
