_('Snippet Library'), 'header'=>''));
$by = getStringFromRequest('by');
if ($by=='lang') {
$lang = getStringFromRequest('lang');
$sql=createSnippetQuery("snippet.language='$lang'");
$sql2=createPackageQuery("snippet_package.language='$lang'");
echo '
' .sprintf(_('Snippets by language: %1$s'), $SCRIPT_LANGUAGE[$lang]).'
';
} else if ($by=='cat') {
$cat = getStringFromRequest('cat');
$sql=createSnippetQuery("snippet.category='$cat'");
$sql2=createPackageQuery("snippet_package.category='$cat'");
echo '' .sprintf(_('Snippets by category: %1$s'), $SCRIPT_CATEGORY[$cat]).'
';
} else {
exit_error(_('Error'),_('Error - bad url?'));
}
$result=db_query($sql);
$rows=db_numrows($result);
$result2=db_query($sql2);
$rows2=db_numrows($result2);
if ((!$result || $rows < 1) && (!$result2 || $rows2 < 1)) {
echo '' ._('No snippets found').'
';
} else {
$title_arr=array();
$title_arr[]= _('Snippet ID');
$title_arr[]= _('Title');
$title_arr[]= _('Creator');
echo $GLOBALS['HTML']->listTableTop ($title_arr);
// List packages if there are any
if ($rows2 > 0) {
echo '
' ._('Packages Of Snippets').' | ';
}
for ($i=0; $i<$rows2; $i++) {
echo '
|
boxGetAltRowStyle($i) .'>'.
util_make_link ('/snippet/detail.php?type=package&id='.db_result($result2,$i,'snippet_package_id'),''.db_result($result2,$i,'snippet_package_id').'').' | '.
db_result($result2,$i,'name').' | '.
util_make_link_u (db_result($result2, $i, 'user_name'), db_result($result2, $i, 'user_id'), db_result($result2, $i, 'realname')).' |
';
echo '
boxGetAltRowStyle($i) .'>'.util_make_links(nl2br(db_result($result2,$i,'description'))).' |
';
}
// List snippets if there are any
if ($rows > 0) {
echo '
' ._('Snippets').' | ';
}
for ($i=0; $i<$rows; $i++) {
echo '
boxGetAltRowStyle($i) .'>'.
util_make_link ('/snippet/detail.php?type=snippet&id='.db_result($result,$i,'snippet_id'),''.db_result($result,$i,'snippet_id').'').
' | '.
util_make_link ('/snippet/detail.php?type=snippet&id='.db_result($result,$i,'snippet_id'),db_result($result,$i,'name')).
' | '.
util_make_link_u (db_result($result, $i, 'user_name'), db_result($result, $i, 'user_id'), db_result($result, $i, 'realname')).' |
';
echo '
boxGetAltRowStyle($i) .'>'.util_make_links(nl2br(db_result($result,$i,'description'))).' |
';
}
echo $GLOBALS['HTML']->listTableBottom();
}
snippet_footer(array());
?>