Forum PHP Romania - Discutii despre PHP, MySQL, Javascript, AJAX, etc

[kleampa]

Cine cunoaste structura phpbb-ului ma poate ajuta

As dori si eu interogarea care sa imi scoata ca linkuri ultimele n subiecte create intr-un anumit topic

multumesc

[skym]

Am facut recent un script pentru ceva asemanator de curand, insa f la repezeala si probabil unele lucruri (de exemplu u.user_icq in query) sunt inutile, insa atunci nu ma interesa decat sa functioneze:

<?php
// from phpBB

define('IN_PHPBB', true);
$phpbb_root_path = 'forum/';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);
include($phpbb_root_path . 'includes/bbcode.'.$phpEx);
ini_set('display_errors', 0);
error_reporting(0);
$sql = "SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid
FROM " . POSTS_TABLE . " p, " . USERS_TABLE . " u, " . POSTS_TEXT_TABLE . " pt
WHERE pt.post_id = p.post_id
AND u.user_id = p.poster_id
ORDER BY p.post_time DESC
LIMIT 3";
if ( !($result = $db->sql_query($sql)) )
{
echo "Could not obtain post/user information.";
}
$postrow = array();
if ($row = $db->sql_fetchrow($result))
{
do
{
$postrow[] = $row;
}
while ($row = $db->sql_fetchrow($result));
$db->sql_freeresult($result);

$total_posts = count($postrow);
}
?>

Acesta extrage ultimele 3 raspunsuri in orice topic.
Pentru a le afisa am folosit:
<?php
for ($i=0;$i<3;$i++) {
$poster_id = $postrow[$i]['user_id'];
$poster = ( $poster_id == ANONYMOUS ) ? "Guest" : $postrow[$i]['username'];
$post_subject = ( $postrow[$i]['post_subject'] != '' ) ? $postrow[$i]['post_subject'] : '';
$message = $postrow[$i]['post_text'];
$data = create_date($board_config['default_dateformat'], $postrow[$i]['post_time'], $board_config['board_timezone']);
$topic_id = $postrow[$i]['topic_id'];
$sql = "SELECT topic_title FROM phpbb_topics WHERE topic_id=".$topic_id." LIMIT 1";
$result = $db->sql_query($sql);
$row = mysql_fetch_assoc($result);
$topic_title = $row['topic_title'];
if (strlen($topic_title)>20)
$topic_title = substr($topic_title,0,20)."...";
if (strlen($message)>20)
$message = substr($message,0,20)."...";
?>
<a href="forum/viewtopic.php?t=<?php echo $topic_id; ?>" target="_blank" class="left"><?php echo $topic_title; ?></a><br>
<?php echo $poster; ?><br>
<?php echo $message; ?>...<br>
<?php echo $data; } ?>

Probabil te ajuta sa te inspiri din el.

[kleampa]

asta scoate ultimele mesaje introduse, eu am nevoie de ultimele thread-uri deschise

[PHPRomania Bot]