SimplePortal
Customization => Blocks and Modifications => Block Requests => Topic started by: MUSTAFAINE on June 03, 2009, 08:39:44 AM
-
u can see the block in smfmodding (http://www.smfmodding.com/index.php?action=forum) site, can anyone wrote it..
-
Your wish is granted.
global $scripturl, $smcFunc, $sourcedir;
// Making this a "smart" block.
if (!file_exists($sourcedir . '/SMFQuizDb.php'))
{
echo 'Unable to reach the quiz database!';
return;
}
// Include the SMF2 specific database file
require_once($sourcedir . '/SMFQuizDb.php');
// Make sure they're allowed to view.
isAllowedTo('quiz_view');
// Load the language file
loadLanguage('SMFQuiz');
// Parameters.
// How many quizzes should be shown?
$limit = 10;
// Do you want to only show 'certain' types of quizes? If so, fill out the common title between them. If not, leave this empty.
//$search_material = '';
// Doing the real work.
$result = $smcFunc['db_query']('', '
SELECT Q.id_quiz, Q.title, Q.image
FROM {db_prefix}quiz as Q
WHERE Q.enabled = 1
LIMIT {int:limit},
array(
//'quiz' => $search_material,
'limit' => $limit,
)
);
$quizzes = array();
while ($quiz = $smcFunc['db_fetch_assoc']($result))
{
$quizzes[] = array(
'title' => $quiz['title'],
'id' => $quiz['id_quiz'],
'image' => $quiz['image'],
'url' => $scripturl . '?action=SMFQuiz;sa=categories;id_quiz=' . $quiz['id_quiz']
);
}
$smcFunc['db_free_result']($result);
// No quizzes found?
if (empty($quizzes))
{
echo 'There are no quizzes at this time';
return;
}
// The template work.
echo
'<table border="0" width="100%">';
foreach ($quizzes as $quiz)
echo '
<tr>
<td>', (!empty($quiz['image']) ? $quiz['image'] : ''), '<a href="', $quiz['url'], '">', $quiz['title'], '</td>
</tr>';
// All done.
echo
'</table>';
unset($quizzes);
-
sorry but it is not working how can it be!!! its look like very logical..
-
What version of SMF are you running? 2.0, right?
Are you putting the code into a custom PHP block?
-
using smf 2.0 rc 1-1 and ofcourse i put in a php block, but have an empty block
-
this is an important block for me friends can anyone interest it?
---
now i found something for this block
global $smcFunc, $settings, $scripturl;
$result = $smcFunc['db_query']('', '
SELECT Q.id_quiz,
Q.title,
Q.image,
Q.updated
FROM {db_prefix}quiz Q
WHERE Q.enabled = 1
ORDER BY Q.updated DESC
LIMIT 0, 8'
);
echo '<table border="0">';
while ($row = $smcFunc['db_fetch_assoc']($result)) {
echo '<tr><td><img width="15" height="15" src="' , !empty($row['image']) ? $settings["default_images_url"] . '/quiz_images/Quizes/' . $row['image'] : $settings["default_images_url"] . '/quiz_images/Quizes/Default-64.png' , '"/></td><td><a href="' , $scripturl , '?action=SMFQuiz;sa=categories;id_quiz=' , $row['id_quiz'] , '">' , $smcFunc['db_unescape_string']($row['title']) , '</a></td></tr>';
}
echo '</table>';
$smcFunc['db_free_result']($result);
if you make a new one i want to take it... thanks..