phpBB2 by Przemo

karzniczka · Posty: 47

Witam mam małe pytanie odnośnie php. Jak wyświetlić w jednym zapytaniu autora posta i autora tematu ??

Gadatliwa Kasia

Woytec · **Pomógł:** 2596 razy Posty: 7676

Kod:

SELECT u.username FROM phpbb_users u, phpbb_posts p WHERE u.user_id=p.poster_id AND p.post_id=IDPOSTU

Kod:

SELECT u.username FROM phpbb_users u, phpbb_topics t WHERE u.user_id=t.topic_poster AND t.topic_id=IDTEMATU

karzniczka · Posty: 47

Nie do końca o takie coś mi chodziło może bardziej wyjaśnie. Kombinuje przerobić Ostatnie tematy na coś takiego jak na screenie poniżej i w tym zapytaniu nie mogę umieścić autora tematu i ostatniego postu.

Kod:

//Ostatnio napisane tematy
$sql = 'SELECT p.topic_id, p.topic_title, p.topic_poster, p.topic_time, a.user_id, a.username, a.user_level, a.user_jr, a.user_avatar_type, a.user_avatar
FROM ' . TOPICS_TABLE . ' p
LEFT JOIN ' . USERS_TABLE . ' a ON (a.user_id = p.topic_poster)
WHERE forum_id AND (topic_status <> 2)
ORDER BY topic_time DESC
LIMIT 5';
$result = mysql_query($sql);
$i=0;
while ($row = $db->sql_fetchrow($result))
{
$posttime = create_date($board_config['default_dateformat'], $row['topic_time'], $board_config['board_timezone']);
$colored_username = color_username($row['user_level'], $row['user_jr'], $row['user_id'], $row['username']);
$row_user_name = $colored_username[0];
$userAvatar = '';
if($row['user_avatar_type']) {
switch($row['user_avatar_type']) {
case USER_AVATAR_UPLOAD:
$userAvatar = ($board_config['allow_avatar_upload']) ? '<img style="width:40px; height:40px;" src="' . $board_config['avatar_path'] . '/' . $row['user_avatar'] . '" alt="" border="0" width="40" height="40" style="border:2px solid #292929; background: #1a1a1a; -moz-border-radius:3px;-webkit-border-radius:3px;border-radius:3px;"/>' : '';
break;
case USER_AVATAR_REMOTE:
$userAvatar = ($board_config['allow_avatar_remote']) ? '<img src="' . $row['user_avatar'] . '" alt="" border="0" style="width:40px; height:40px;"style="border:2px solid #292929; background: #1a1a1a; -moz-border-radius:3px;-webkit-border-radius:3px;border-radius:3px;"/>' : '';
break;
case USER_AVATAR_GALLERY:
$userAvatar = ($board_config['allow_avatar_local']) ? '<img src="' . $board_config['avatar_gallery_path'] . '/' . $row['user_avatar'] . '" alt="" border="0" style="width:40px; height:40px;"style="border:2px solid #292929; background: #1a1a1a; -moz-border-radius:3px;-webkit-border-radius:3px;border-radius:3px;"/>' : '';
break;
}
}
else {
$userAvatar = '<img width="40" height="40" src="images/default_avatar.png" alt="" border="0" style="border:2px solid #292929; background: #1a1a1a; -moz-border-radius:3px;-webkit-border-radius:3px;border-radius:3px;"/>';
}
$poster = '<a href="' . append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=" . $row['user_id']) . '" class="gensmall"' . $colored_username[1] . '>' . $row_user_name . '</a>';
$i++;
if (strlen($row['topic_title']) > 25)
{
$topic_title = substr($row['topic_title'], 0, 25)."...";
}
else
{
$topic_title = $row['topic_title'];
}
$template->assign_block_vars('tem', array(
'LI' => $i+0,
'POSTTIME' => $posttime,
'UZYTKOWNIK' => $poster,
'AVATAR' => $userAvatar,
'URL' => '<a href="' . append_sid("viewtopic.$phpEx?t=" . $row['topic_id']) . '" class="gensmall" title="' . $row['topic_title'] . '">' . $topic_title . '</a>')
);
}

bez_nazwy_1_146.png

Plik ściągnięto 43 raz(y) 29,1 KB