4 * SourceForge Code Snippets Repository
6 * SourceForge: Breaking Down the Barriers to Open Source Development
7 * Copyright 1999-2001 (c) VA Linux Systems
8 * http://sourceforge.net
14 require_once('../env.inc.php');
15 require_once('pre.php');
16 require_once('www/snippet/snippet_utils.php');
19 * createSnippetQuery - Creates the SQL query for loading data about snippets
21 * @param string clause - the last part of the where clause
23 function createSnippetQuery($clause) {
24 return "SELECT users.realname,users.user_name,snippet.description,snippet.snippet_id,snippet.name FROM snippet,users WHERE users.user_id=snippet.created_by AND ".$clause;
28 * createPackageQuery - Creates the SQL query for loading data about packages
30 * @param string clause - the last part of the where clause
32 function createPackageQuery($clause) {
33 return "SELECT users.realname,users.user_name,snippet_package.description,snippet_package.snippet_package_id,snippet_package.name FROM snippet_package,users WHERE users.user_id=snippet_package.created_by AND ".$clause;
36 snippet_header(array('title'=>_('Snippet Library'), 'header'=>''));
38 $by = getStringFromRequest('by');
41 $lang = getStringFromRequest('lang');
42 $sql=createSnippetQuery("snippet.language='$lang'");
43 $sql2=createPackageQuery("snippet_package.language='$lang'");
44 echo '<h2>' .sprintf(_('Snippets by language: %1$s'), $SCRIPT_LANGUAGE[$lang]).'</h2>';
45 } else if ($by=='cat') {
46 $cat = getStringFromRequest('cat');
47 $sql=createSnippetQuery("snippet.category='$cat'");
48 $sql2=createPackageQuery("snippet_package.category='$cat'");
49 echo '<h2>' .sprintf(_('Snippets by category: %1$s'), $SCRIPT_CATEGORY[$cat]).'</h2>';
51 exit_error(_('Error'),_('Error'));
54 $result=db_query($sql);
55 $rows=db_numrows($result);
57 $result2=db_query($sql2);
58 $rows2=db_numrows($result2);
60 if ((!$result || $rows < 1) && (!$result2 || $rows2 < 1)) {
61 echo '<h2>' ._('No snippets found').'</h2>';
65 $title_arr[]= _('Snippet ID');
66 $title_arr[]= _('Title');
67 $title_arr[]= _('MISSINGTEXT:snippet_browse/Creator:TEXTMISSING');
69 echo $GLOBALS['HTML']->listTableTop ($title_arr);
71 // List packages if there are any
74 <tr class="tableheading"><td colspan="3">' ._('Packages Of Snippets').'<td>';
76 for ($i=0; $i<$rows2; $i++) {
78 <tr '. $GLOBALS['HTML']->boxGetAltRowStyle($i) .'><td rowspan="2"><a href="'.$GLOBALS['sys_urlprefix'].'/snippet/detail.php?type=package&id='.
79 db_result($result2,$i,'snippet_package_id').'"><strong>'.
80 db_result($result2,$i,'snippet_package_id').'</strong></a></td><td><strong>'.
81 db_result($result2,$i,'name').'</td><td>'.
82 $GLOBALS['HTML']->createLinkToUserHome(db_result($result2, $i, 'user_name'), db_result($result2, $i, 'realname')).'</td></tr>';
84 <tr '. $GLOBALS['HTML']->boxGetAltRowStyle($i) .'><td colspan="2">'.util_make_links(nl2br(db_result($result2,$i,'description'))).'</td></tr>';
87 // List snippets if there are any
90 <tr class="tableheading"><td colspan="3">' ._('Snippets').'</td>';
92 for ($i=0; $i<$rows; $i++) {
94 <tr '. $GLOBALS['HTML']->boxGetAltRowStyle($i) .'><td rowspan="2"><a href="'.$GLOBALS['sys_urlprefix'].'/snippet/detail.php?type=snippet&id='.
95 db_result($result,$i,'snippet_id').'"><strong>'.
96 db_result($result,$i,'snippet_id').'</strong></a></td><td><strong><a href="'.$GLOBALS['sys_urlprefix'].'/snippet/detail.php?type=snippet&id='.
97 db_result($result,$i,'snippet_id').'">'.db_result($result,$i,'name').'</a></td><td>'.
98 $GLOBALS['HTML']->createLinkToUserHome(db_result($result, $i, 'user_name'), db_result($result, $i, 'realname')).'</td></tr>';
100 <tr '. $GLOBALS['HTML']->boxGetAltRowStyle($i) .'><td colspan="2">'.util_make_links(nl2br(db_result($result,$i,'description'))).'</td></tr>';
102 echo $GLOBALS['HTML']->listTableBottom();
104 snippet_footer(array());