$dirmess = changedir($currdir); } if ($currsort == "posting_id") { $dirbelo = changedir($currdir); } if ($currsort == "audio_length") { $dirtime = changedir($currdir); } //table which should be coded way more beautiful echo "<table>\n<tr>\n"; echo "<th><a href=\"index.php" . addToUrl("sort", $dirpost . "posted") . "\">date</a></th>\n"; echo "<th><a href=\"index.php" . addToUrl("sort", $dirname . "name") . "\">name</a></th>\n"; echo "<th><a href=\"index.php" . addToUrl("sort", $dirmess . "message_input") . "\">message</a></th>\n"; echo "<th><a href=\"index.php" . addToUrl("sort", $dirbelo . "posting_id") . "\">belongs to</a></th>\n"; echo "<th>play</th>\n"; echo "<th class=\"size\"><a href=\"index.php" . addToUrl("sort", $dirtime . "audio_length") . "\">time</a></th>\n"; echo "<th></th>\n</tr>\n\n"; //one table-row for each entry in the database for ($i = 0; $i < $rowcount; $i++) { echo "<tr>\n"; //showing the date/time $dateformat = $settings['dateformat']; $showdate = date($dateformat, strtotime($showtable[$i]['posted'])); echo "<td>" . $showdate . "</td>\n"; //showing the commentators name echo "<td>" . $showtable[$i]['name'] . "</td>\n"; //generating the link $link = $settings['url'] . "/audio/" . $showtable[$i]['audio_file']; //showing the message $text = strip_tags($showtable[$i]['message_html']); if (substr($text, 0, 80) == $text) {
} //pink print for active sorting type $pink = array("posted" => "", "author_id" => "", "title" => "", "audio_length" => "", "status" => ""); foreach ($pink as $key => $value) { if ($currsort == $key) { $pink[$key] = " class=\"pink\""; } } //generates the links echo "<th><a" . $pink['posted'] . " href=\"index.php" . addToUrl("sort", $dirpost . "posted") . "\">" . bla("post_date") . "</a></th>\n"; echo "<th><a" . $pink['author_id'] . " href=\"index.php" . addToUrl("sort", $dirauth . "author_id") . "\">" . bla("post_author") . "</a></th>\n"; //echo "<th>".bla("post_sticky")."</th>\n"; echo "<th><a" . $pink['title'] . " href=\"index.php" . addToUrl("sort", $dirtitl . "title") . "\">" . bla("post_title") . "</a></th>\n"; echo "<th>" . bla("post_play") . "</th>\n"; echo "<th><a" . $pink['audio_length'] . " href=\"index.php" . addToUrl("sort", $diraudi . "audio_length") . "\">" . bla("post_length") . "</a></th>\n"; echo "<th><a" . $pink['status'] . " href=\"index.php" . addToUrl("sort", $dirstat . "status") . "\">" . bla("post_status") . "</a></th>\n"; echo "<th></th>\n</tr>\n\n"; //one table-row for each entry in the database for ($i = 0; $i < $rowcount; $i++) { echo "<tr>\n"; //showing the date/time $dateformat = $settings['dateformat']; $showdate = date($dateformat, strtotime($showtable[$i]['posted'])); echo "<td>" . $showdate . "</td>\n"; //showing the author $tempauth = getnickname($showtable[$i]['author_id']); if ($tempauth == $_SESSION['nickname']) { $tempauth = "<b>" . bla("post_yourself") . "</b>"; } echo "<td>" . $tempauth . "</td>\n"; //generating the link
function link_next($content) { //generates a href-link to the next page global $nextpage; if (isset($_GET['page'])) { $here = $_GET['page']; } else { $here = 1; } if (!isset($_GET['id']) and $nextpage == true) { $return = "<a href=\"index.php" . addToUrl("page", $here + 1) . "\" title=\"previous page\">"; $return .= fullparse(stripcontainer($content)); $return .= "</a>\n"; } else { $return = ""; } return $return; }
/** * @param string $code * @param string $name * @param string $canHaveCourses * @param int $parent_id * * @return bool */ function addNode($code, $name, $canHaveCourses, $parent_id) { $tbl_category = Database::get_main_table(TABLE_MAIN_CATEGORY); $code = trim(Database::escape_string($code)); $name = trim(Database::escape_string($name)); $parent_id = trim(Database::escape_string($parent_id)); $canHaveCourses = Database::escape_string($canHaveCourses); $code = generate_course_code($code); $result = Database::query("SELECT 1 FROM {$tbl_category} WHERE code='{$code}'"); if (Database::num_rows($result)) { return false; } $result = Database::query("SELECT MAX(tree_pos) AS maxTreePos FROM {$tbl_category}"); $row = Database::fetch_array($result); $tree_pos = $row['maxTreePos'] + 1; $sql = "INSERT INTO {$tbl_category}(name, code, parent_id, tree_pos, children_count, auth_course_child)\n VALUES('{$name}','{$code}'," . (empty($parent_id) ? "NULL" : "'{$parent_id}'") . ",'{$tree_pos}','0','{$canHaveCourses}')"; Database::query($sql); $categoryId = Database::insert_id(); updateCategoryChildren($parent_id); if (isMultipleUrlSupport()) { addToUrl($categoryId); } return $categoryId; }
/** * generates a href-link to the next page * * @param unknown_type $content * @return unknown */ function link_next($content) { global $nextpage; $here = isset($_GET['page']) ? $_GET['page'] : 1; if (!isset($_GET['id']) and $nextpage == true) { $return = '<a href="index.php' . addToUrl('page', $here + 1) . '" title="next page">'; $return .= fullparse(stripcontainer($content)); $return .= "</a>\n"; } else { $return = ''; } return $return; }
if ($currsort == "title") { $dirtitl = changedir($currdir); } if ($currsort == "audio_length") { $diraudi = changedir($currdir); } if ($currsort == "status") { $dirstat = changedir($currdir); } //generates the links echo "<th><a href=\"index.php" . addToUrl("sort", $dirpost . "posted") . "\">date</a></th>\n"; echo "<th><a href=\"index.php" . addToUrl("sort", $dirauth . "author_id") . "\">by</a></th>\n"; echo "<th><a href=\"index.php" . addToUrl("sort", $dirtitl . "title") . "\">title</a></th>\n"; echo "<th>play</th>\n"; echo "<th><a href=\"index.php" . addToUrl("sort", $diraudi . "audio_length") . "\">time</a></th>\n"; echo "<th><a href=\"index.php" . addToUrl("sort", $dirstat . "status") . "\">status</a></th>\n"; echo "<th></th>\n</tr>\n\n"; //one table-row for each entry in the database for ($i = 0; $i < $rowcount; $i++) { echo "<tr>\n"; //showing the date/time $dateformat = $settings['dateformat']; $showdate = date($dateformat, strtotime($showtable[$i]['posted'])); echo "<td>" . $showdate . "</td>\n"; //showing the author $tempauth = getnickname($showtable[$i]['author_id']); if ($tempauth == $_SESSION['nickname']) { $tempauth = "<b>yourself</b>"; } echo "<td>" . $tempauth . "</td>\n"; //generating the link
/** * @param string $code * @param string $name * @param string $canHaveCourses * @param int $parent_id * * @return bool */ function addNode($code, $name, $canHaveCourses, $parent_id) { $tbl_category = Database::get_main_table(TABLE_MAIN_CATEGORY); $code = trim($code); $name = trim($name); $parent_id = trim($parent_id); $code = CourseManager::generate_course_code($code); $sql = "SELECT 1 FROM {$tbl_category}\n WHERE code = '" . Database::escape_string($code) . "'"; $result = Database::query($sql); if (Database::num_rows($result)) { return false; } $result = Database::query("SELECT MAX(tree_pos) AS maxTreePos FROM {$tbl_category}"); $row = Database::fetch_array($result); $tree_pos = $row['maxTreePos'] + 1; $params = ['name' => $name, 'code' => $code, 'parent_id' => empty($parent_id) ? '' : $parent_id, 'tree_pos' => $tree_pos, 'children_count' => 0, 'auth_course_child' => $canHaveCourses, 'auth_cat_child' => 'TRUE']; $categoryId = Database::insert($tbl_category, $params); updateParentCategoryChildrenCount($parent_id, 1); if (isMultipleUrlSupport()) { addToUrl($categoryId); } return $categoryId; }
} //pink print for active sorting type $pink = array("posted" => "", "name" => "", "message_input" => "", "posting_id" => "", "audio_length" => ""); foreach ($pink as $key => $value) { if ($currsort == $key) { $pink[$key] = " class=\"pink\""; } } //table which should be coded way more beautiful echo "<table>\n<tr>\n"; echo "<th><a" . $pink['posted'] . " href=\"index.php" . addToUrl("sort", $dirpost . "posted") . "\">" . bla("com_date") . "</a></th>\n"; echo "<th><a" . $pink['name'] . " href=\"index.php" . addToUrl("sort", $dirname . "name") . "\">" . bla("com_name") . "</a></th>\n"; echo "<th><a" . $pink['message_input'] . " href=\"index.php" . addToUrl("sort", $dirmess . "message_input") . "\">" . bla("com_message") . "</a></th>\n"; echo "<th><a" . $pink['posting_id'] . " href=\"index.php" . addToUrl("sort", $dirbelo . "posting_id") . "\">" . bla("com_belong") . "</a></th>\n"; echo "<th>" . bla("com_play") . "</th>\n"; echo "<th class=\"size\"><a" . $pink['audio_length'] . " href=\"index.php" . addToUrl("sort", $dirtime . "audio_length") . "\">" . bla("com_time") . "</a></th>\n"; echo "<th></th>\n</tr>\n\n"; //one table-row for each entry in the database for ($i = 0; $i < $rowcount; $i++) { echo "<tr class=\"" . $showtable[$i]['id'] . "\">\n"; //showing the date/time $dateformat = $settings['dateformat']; $showdate = date($dateformat, strtotime($showtable[$i]['posted'])); echo "<td class=\"date\">" . $showdate . "</td>\n"; //showing the commentators name echo "<td class=\"author\"><p>" . $showtable[$i]['name'] . "</p></td>\n"; //generating the link $link = $settings['url'] . "/audio/" . $showtable[$i]['audio_file']; //showing the message $text = strip_tags($showtable[$i]['message_input']); if (substr($text, 0, 80) == $text) {
echo addToUrl("sort", $dirpost . "posted") . "\">"; echo "<span>" . bla("sta_date") . "</span></a></th>\n"; echo " <th><a" . $pink['title'] . " href=\"index.php"; echo addToUrl("sort", $dirtitle . "title") . "\">"; echo bla("sta_title") . "</a></th>\n"; echo " <th class=\"number\"><a" . $pink['countweb'] . " href=\"index.php"; echo addToUrl("sort", $dirweb . "countweb") . "\">"; echo bla("sta_web") . "</a></th>\n"; echo " <th class=\"number\"><a" . $pink['countfla'] . " href=\"index.php"; echo addToUrl("sort", $dirfla . "countfla") . "\">"; echo bla("sta_fla") . "</a></th>\n"; echo " <th class=\"number\"><a" . $pink['countpod'] . " href=\"index.php"; echo addToUrl("sort", $dirpod . "countpod") . "\">"; echo bla("sta_pod") . "</a></th>\n"; echo " <th class=\"number\"><a" . $pink['countall'] . " href=\"index.php"; echo addToUrl("sort", $dirall . "countall") . "\">"; echo bla("sta_all") . "</a></th>\n"; echo "</tr>\n\n"; //showing numbers in a table foreach ($showtable as $value) { echo "<tr>\n"; echo " <td class=\"date\">"; echo date($settings['dateformat'], strtotime($value['posted'])) . "</td>\n"; echo " <td><a href=\"index.php?page=record2&do=edit&"; echo "id=" . $value['id'] . "\">" . $value['title'] . "</a></td>\n"; echo " <td class=\"number\">" . $value['countweb'] . "</td>\n"; echo " <td class=\"number\">" . $value['countfla'] . "</td>\n"; echo " <td class=\"number\">" . $value['countpod'] . "</td>\n"; echo " <td class=\"number\">" . $value['countall'] . "</td>\n"; echo "</tr>\n\n"; }