示例#1
0
function snippet_show_snippet_details($id)
{
    global $Language;
    $sql = "SELECT * FROM snippet WHERE snippet_id='{$id}'";
    $result = db_query($sql);
    echo '
	<P>
	<TABLE WIDTH="100%" BORDER="0" CELLSPACING="1" CELLPADDING="2">

	<TR><TD COLSPAN="2">
	<H2>' . db_result($result, 0, 'name') . '</H2>
	</TD></TR>

	<TR><TD><B>' . $Language->getText('snippet_utils', 'type') . '</B><BR>
		' . snippet_data_get_type_from_id(db_result($result, 0, 'type')) . '</TD>
	<TD><B>' . $Language->getText('snippet_package', 'category') . '</B><BR>
		' . snippet_data_get_category_from_id(db_result($result, 0, 'category')) . '
	</TD></TR>

	<TR><TD><B>' . $Language->getText('snippet_utils', 'license') . '</B><BR>
		' . snippet_data_get_license_from_id(db_result($result, 0, 'license')) . '</TD>
	<TD><B>' . $Language->getText('snippet_package', 'language') . '</B><BR>
		' . snippet_data_get_language_from_id(db_result($result, 0, 'language')) . '
	</TD></TR>

	<TR><TD COLSPAN="2">&nbsp;<BR>
	<B>' . $Language->getText('snippet_package', 'description') . '</B><BR>
	' . util_make_links(nl2br(db_result($result, 0, 'description'))) . '
	</TD></TR>

	</TABLE>';
}
示例#2
0
//
// SourceForge: Breaking Down the Barriers to Open Source Development
// Copyright 1999-2000 (c) The SourceForge Crew
// Copyright (c) Enalean, 2015. All Rights Reserved.
// http://sourceforge.net
//
//
require_once 'pre.php';
require '../snippet/snippet_utils.php';
$by = $request->get('by');
snippet_header(array('title' => $Language->getText('snippet_browse', 's_library'), 'header' => $Language->getText('snippet_browse', 's_browsing'), 'help' => 'overview.html#code-snippet-library'));
if ($by == 'lang') {
    $lang = (int) $request->get('lang');
    $sql = "SELECT user.user_name,snippet.description,snippet.snippet_id,snippet.name " . "FROM snippet,user " . "WHERE user.user_id=snippet.created_by AND snippet.language='" . db_ei($lang) . "'";
    $sql2 = "SELECT user.user_name,snippet_package.description,snippet_package.snippet_package_id,snippet_package.name " . "FROM snippet_package,user " . "WHERE user.user_id=snippet_package.created_by AND snippet_package.language='" . db_ei($lang) . "'";
    echo '<H2>' . $Language->getText('snippet_browse', 's_by_lang', snippet_data_get_language_from_id($lang)) . '</H2>';
} else {
    if ($by == 'cat') {
        $cat = (int) $request->get('cat');
        $sql = "SELECT user.user_name,snippet.description,snippet.snippet_id,snippet.name " . "FROM snippet,user " . "WHERE user.user_id=snippet.created_by AND snippet.category='" . db_ei($cat) . "'";
        $sql2 = "SELECT user.user_name,snippet_package.description,snippet_package.snippet_package_id,snippet_package.name " . "FROM snippet_package,user " . "WHERE user.user_id=snippet_package.created_by AND snippet_package.category='" . db_ei($cat) . "'";
        echo '<H3>' . $Language->getText('snippet_browse', 's_category', snippet_data_get_category_from_id($cat)) . '</H3>';
    } else {
        exit_error($Language->getText('global', 'error'), $Language->getText('snippet_browse', '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)) {