Public feed
#527721
default:
$l_title = $user->lang['QUIZ'];
$i = 1;
$template->assign_vars(array(
'U_QUIZ' => append_sid("{$phpbb_root_path}$quiz_filename.$phpEx"),
'L_QUIZ' => $user->lang['QUIZ']));
$sql = 'SELECT quiz_id, quiz_name, quiz_author, active_id, u.user_id
FROM ' . QUIZ_LITE_TABLE . '
WHERE active_id = 1
INNER JOIN phpbb_users u ON u.user_id = quiz_author
ORDER BY quiz_id DESC';
$result = $db->sql_query($sql);
while( $row = $db->sql_fetchrow($result) )
{
$template->assign_block_vars('quiz_row', array(
'QUIZ_ID' => $i,
'QUIZ_NAME' => $row['quiz_name'],
'QUIZ_AUTHOR' => )
$i++;
}