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"> <BR> <B>' . $Language->getText('snippet_package', 'description') . '</B><BR> ' . util_make_links(nl2br(db_result($result, 0, 'description'))) . ' </TD></TR> </TABLE>'; }
// // 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)) {