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, u.username FROM ' . QUIZ_LITE_TABLE . ' q, ' . USERS_TABLE . ' u WHERE active_id = 1 AND u.user_id = q.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++; }