Пример #1
0
    // IF NOTHING IS SET, SHOW INDEX
} else {
    $action = "article";
    $mode = "name";
    $name = "index";
}
if ($action == "article") {
    $res = sql_query("SELECT * FROM wiki WHERE {$mode} = '" . ($mode == "name" ? "{$name}" : "{$id}") . "'");
    if (mysql_num_rows($res) == 1) {
        echo navmenu();
        echo "<div id=\"wiki-container\">\r\n  <div id=\"wiki-row\">";
        while ($wiki = mysql_fetch_array($res)) {
            if ($wiki[lastedit]) {
                $check = sql_query("SELECT username FROM users WHERE id = {$wiki['lastedituser']}");
                $checkit = mysql_fetch_assoc($check);
                $edit = "<i>Last Updated by: <a href=\"userdetails.php?id={$wiki['userid']}\">{$checkit['username']}</a> - " . datetimetransform($wiki[lastedit]) . "</i>";
            }
            $check = sql_query("SELECT username FROM users WHERE id = {$wiki['userid']}");
            $author = mysql_fetch_assoc($check);
            echo "\r\n\t\t\t\t<div id=\"wiki-content-left\" align=\"right\">\r\n\t\t\t\t\t<div id=\"name\"><b><a href=\"wiki.php?action=article&name={$wiki['name']}\">{$wiki['name']}</a></b></div>\r\n\t\t\t\t\t<div id=\"content\">" . ($wiki[userid] > 0 ? "<font style=\"color: grey; font-size: 9px;\"><i>Article added by <a href=\"userdetails.php?id={$wiki['userid']}\"><b>{$author['username']}</b></i></a></font><br /><br />" : "") . wikireplace(format_comment($wiki["body"])) . "";
            echo "<div align=\"right\">" . ($edit ? "<font style=\"color: grey; font-size: 9px;\">{$edit}</font>" : "") . (get_user_class() >= UC_MODERATOR || $CURUSER["id"] == $wiki["userid"] ? " - <a href=\"wiki.php?action=edit&id={$wiki['id']}\">Edit</a>" : "") . "</div>";
            echo "</div></div>";
        }
        echo wikimenu();
        echo "</div>";
        echo "</div>";
    } else {
        $search = sql_query("SELECT * FROM wiki WHERE name LIKE '%" . wikisearch($name) . "%'");
        if (mysql_num_rows($search) > 0) {
            echo "Search results for: <b>{$name}</b>";
            while ($wiki = mysql_fetch_array($search)) {
Пример #2
0
} else {
    $action = "article";
    $mode = "name";
    $name = "index";
}
if ($action == "article") {
    $res = sql_query("SELECT * FROM wiki WHERE {$mode} = '" . ($mode == "name" ? "{$name}" : "{$id}") . "'");
    if (mysqli_num_rows($res) == 1) {
        $HTMLOUT .= navmenu();
        $edit = '';
        $HTMLOUT .= "\n        <div id=\"wiki-container\">\n  <div id=\"wiki-row\">";
        while ($wiki = mysqli_fetch_array($res)) {
            if ($wiki['lastedit']) {
                $check = sql_query("SELECT username FROM users WHERE id = " . sqlesc($wiki['lastedituser']));
                $checkit = mysqli_fetch_assoc($check);
                $edit = "<i>Last Updated by: <a href=\"userdetails.php?id=" . (int) $wiki['userid'] . "\">" . htmlsafechars($checkit['username']) . "</a> - " . datetimetransform($wiki['lastedit']) . "</i>";
            }
            $check = sql_query("SELECT username FROM users WHERE id =" . sqlesc($wiki['userid']));
            $author = mysqli_fetch_assoc($check);
            $HTMLOUT .= "\n\t\t\t\t<div id=\"wiki-content-left\" align=\"right\">\n\t\t\t\t\t<div id=\"name\"><b><a href=\"wiki.php?action=article&amp;name=" . htmlsafechars($wiki['name']) . "\">" . htmlsafechars($wiki['name']) . "</a></b></div>\n\t\t\t\t\t<div id=\"content\">" . ($wiki['userid'] > 0 ? "<i>Article added by <a href=\"userdetails.php?id=" . (int) $wiki['userid'] . "\"><b>" . htmlsafechars($author['username']) . "</b></a></i><br /><br />" : "") . wikireplace(format_comment($wiki["body"])) . "";
            $HTMLOUT .= "<div align=\"right\">" . ($edit ? "{$edit}" : "") . ($CURUSER['class'] >= UC_STAFF || $CURUSER["id"] == $wiki["userid"] ? " - <a href=\"wiki.php?action=edit&amp;id=" . (int) $wiki['id'] . "\">Edit</a>" : "") . "</div>";
            $HTMLOUT .= "</div></div>";
        }
        $HTMLOUT .= wikimenu();
        $HTMLOUT .= "</div>";
        $HTMLOUT .= "</div>";
    } else {
        $search = sql_query("SELECT * FROM wiki WHERE name LIKE '%" . wikisearch($name) . "%'");
        if (mysqli_num_rows($search) > 0) {
            $HTMLOUT .= "Search results for: <b>" . htmlsafechars($name) . "</b>";
            while ($wiki = mysqli_fetch_array($search)) {