I'm trying to make a block to put in my site index that can out put a member when click on it (redirect them) , to the forum's posts table order them by the newest to older posts not open for that user.
I think the code who make this is :
- Code: Select all
( $userdata['session_logged_in'] )
{
$sql = "SELECT t.forum_id, t.topic_id, p.post_time
FROM " . TOPICS_TABLE . " t, " . POSTS_TABLE . " p
WHERE p.post_id = t.topic_last_post_id
AND p.post_time > " . $userdata['user_lastvisit'] . "
AND t.topic_moved_id = 0";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not query new topic information', '', __LINE__, __FILE__, $sql);
}
My question is , how can I associate this code it with a .gif for button's image ?
Thank you all the help
Best regards
Keltic
