Example #1
0
function viewdownloadeditorial()
{
    global $downloadsprefix, $db;
    $lid = intval($_GET['lid']);
    include "header.php";
    downl_menu_tpl(1);
    $result = $db->sql_query("SELECT adminid, editorialtimestamp, editorialtext, editorialtitle FROM " . $downloadsprefix . "_editorials WHERE downloadid = {$lid}");
    $recordexist = $db->sql_numrows($result);
    $displaytitle = ereg_replace("_", " ", $ttitle);
    echo '<br />';
    OpenTable();
    echo "<center><font class=\"option\"><b>" . _DOWNLOADPROFILE . ": {$displaytitle}</b></font><br />";
    downl_infomenu_tpl($lid, $ttitle);
    if ($recordexist != 0) {
        while (list($adminid, $editorialtimestamp, $editorialtext, $editorialtitle) = $db->sql_fetchrow($result)) {
            ereg("([0-9]{4})-([0-9]{1,2})-([0-9]{1,2}) ([0-9]{1,2}):([0-9]{1,2}):([0-9]{1,2})", $editorialtimestamp, $editorialtime);
            $editorialtime = strftime("%F", mktime($editorialtime[4], $editorialtime[5], $editorialtime[6], $editorialtime[2], $editorialtime[3], $editorialtime[1]));
            $date_array = explode("-", $editorialtime);
            $timestamp = mktime(0, 0, 0, $date_array["1"], $date_array["2"], $date_array["0"]);
            $formatted_date = date("F j, Y", $timestamp);
            echo "<br /><br />";
            OpenTable2();
            echo "<center><font class=\"option\"><b>'{$editorialtitle}'</b></font></center>" . "<center><font class=\"tiny\">" . _EDITORIALBY . " {$adminid} - {$formatted_date}</font></center><br /><br />" . "{$editorialtext}";
            CloseTable2();
        }
    } else {
        echo "<br /><br /><center><font class=\"option\"><b>" . _NOEDITORIAL . "</b></font></center>";
    }
    echo "<br /><br /><center>";
    downloadfooter($lid);
    echo "</center>";
    CloseTable();
    include "footer.php";
}
function viewdownloadeditorial($lid, $ttitle)
{
    global $prefix, $dbi, $admin, $module_name;
    include "header.php";
    include "modules/{$module_name}/d_config.php";
    menu(1);
    $result = sql_query("SELECT adminid, editorialtimestamp, editorialtext, editorialtitle FROM " . $prefix . "_downloads_editorials WHERE downloadid = {$lid}", $dbi);
    $recordexist = sql_num_rows($result, $dbi);
    $transfertitle = ereg_replace("_", " ", $ttitle);
    $transfertitle = stripslashes($transfertitle);
    $displaytitle = $transfertitle;
    echo "<br>";
    OpenTable();
    echo "<center><font class=\"option\"><b>" . _DOWNLOADPROFILE . ": {$displaytitle}</b></font><br>";
    downloadinfomenu($lid, $ttitle);
    if ($recordexist != 0) {
        while (list($adminid, $editorialtimestamp, $editorialtext, $editorialtitle) = sql_fetch_row($result, $dbi)) {
            $editorialtitle = stripslashes($editorialtitle);
            $editorialtext = stripslashes($editorialtext);
            ereg("([0-9]{4})-([0-9]{1,2})-([0-9]{1,2}) ([0-9]{1,2}):([0-9]{1,2}):([0-9]{1,2})", $editorialtimestamp, $editorialtime);
            $editorialtime = strftime("%F", mktime($editorialtime[4], $editorialtime[5], $editorialtime[6], $editorialtime[2], $editorialtime[3], $editorialtime[1]));
            $date_array = explode("-", $editorialtime);
            $timestamp = mktime(0, 0, 0, $date_array["1"], $date_array["2"], $date_array["0"]);
            $formatted_date = date("F j, Y", $timestamp);
            echo "<br><br>";
            OpenTable2();
            echo "<center><font class=\"option\"><b>'{$editorialtitle}'</b></font></center>" . "<center><font class=\"tiny\">" . _EDITORIALBY . " {$adminid} - {$formatted_date}</font></center><br><br>" . "{$editorialtext}";
            CloseTable2();
        }
    } else {
        echo "<br><br><center><font class=\"option\"><b>" . _NOEDITORIAL . "</b></font></center>";
    }
    echo "<br><br><center>";
    downloadfooter($lid, $ttitle);
    echo "</center>";
    CloseTable();
    include "footer.php";
}
Example #3
0
function index()
{
    global $downloadsprefix, $db, $show_links_num, $show_links_info, $show_links_inum, $module_name, $bgcolor1, $bgcolor3;
    require_once 'header.php';
    downl_menu_tpl(0);
    echo '<br />';
    OpenTable();
    echo "<center><font class=\"title\"><b>" . _DOWNLOADSMAINCAT . "</b></font></center><br />";
    echo "<table border=\"0\" cellspacing=\"10\" cellpadding=\"0\" align=\"center\"><tr>";
    $sql = "SELECT cid, title, cdescription FROM " . $downloadsprefix . "_categories WHERE parentid='0' ORDER BY title";
    $result = $db->sql_query($sql);
    $count = $dum = 0;
    while ($row = $db->sql_fetchrow($result)) {
        $cid = $row['cid'];
        $title = $row['title'];
        $cdescription = $row['cdescription'];
        if ($show_links_num == 1) {
            list($cnumrows) = $db->sql_ufetchrow("SELECT COUNT(*) FROM " . $downloadsprefix . "_downloads WHERE cid='{$cid}'", SQL_NUM);
            $cnumm = " ({$cnumrows})";
        } else {
            $cnumm = '';
        }
        if ($cnumrows > 0) {
            $folder = "modules/Downloads/images/openfolder.gif";
        } else {
            $folder = "modules/Downloads/images/closedfolder.gif";
        }
        if (can_admin('downloads')) {
            $folderImg = "<a href=\"" . adminlink("{$module_name}&mode=DownloadsModCat&amp;cat={$cid}") . "\"><img src=\"{$folder}\" border=\"0\" alt=\"" . _EDIT . "\" /></a>";
        } else {
            $folderImg = "<img src=\"{$folder}\" border=\"0\" alt=\"{$title}\" />";
        }
        echo "<td valign=\"top\"><font class=\"title\">{$folderImg} <a href=\"" . getlink("&amp;d_op=viewdownload&amp;cid={$cid}") . "\"><b>{$title}</b></a></font>{$cnumm}";
        categorynewdownloadgraphic($cid);
        if ($cdescription) {
            echo "<br /><font class=\"content\">{$cdescription}</font><br />";
        } else {
            echo '<br />';
        }
        $result2 = $db->sql_query("SELECT cid, title FROM " . $downloadsprefix . "_categories WHERE parentid='{$cid}' ORDER BY title LIMIT 0,3");
        $space = 0;
        while ($row2 = $db->sql_fetchrow($result2)) {
            $cid = $row2['cid'];
            $stitle = $row2['title'];
            if ($space > 0) {
                echo ',&nbsp;';
            }
            if ($show_links_num == 1) {
                list($cnumrows2) = $db->sql_ufetchrow("SELECT COUNT(*) FROM " . $downloadsprefix . "_downloads WHERE cid='{$cid}'", SQL_NUM);
                $cnum = " ({$cnumrows2})";
            } else {
                $cnum = "";
            }
            echo "<font class=\"content\"><a href=\"" . getlink("&amp;d_op=viewdownload&amp;cid={$cid}") . "\">{$stitle}</a>{$cnum}</font>";
            $space++;
        }
        if ($count < 1) {
            echo "</td><td>&nbsp;&nbsp;&nbsp;&nbsp;</td>";
            $dum = 1;
        }
        $count++;
        if ($count == 2) {
            echo "</td></tr><tr>";
            $count = 0;
            $dum = 0;
        }
    }
    if ($dum == 1) {
        echo '</tr></table>';
    } elseif ($dum == 0) {
        echo '<td></td></tr></table>';
    }
    list($numrows) = $db->sql_ufetchrow("SELECT COUNT(*) FROM " . $downloadsprefix . "_downloads", SQL_NUM);
    list($catnum) = $db->sql_ufetchrow("SELECT COUNT(*) FROM " . $downloadsprefix . "_categories", SQL_NUM);
    echo "<center><font class=\"content\">" . _THEREARE . " <b>{$numrows}</b> " . _DOWNLOADS . " " . _AND . " <b>{$catnum}</b> " . _CATEGORIES . " " . _INDB . "</font></center>";
    CloseTable();
    if ($show_links_info == 1) {
        echo '<br />';
        OpenTable();
        echo "<table border=\"0\" cellpadding=\"0\" cellspacing=\"3\" width=\"100%\">" . "<tr><td width=\"50%\" valign=\"top\" align=\"center\">";
        echo "<div align=\"center\" class=\"title\">" . _NEWDOWNLOADS . "</div>";
        echo "</td><td width=\"50%\" valign=\"top\" align=\"center\">";
        echo "<div align=\"center\" class=\"title\">" . _MOSTPOPULAR . " {$show_links_inum}</div>";
        echo "</td></tr>" . "<tr><td width=\"50%\" valign=\"top\" align=\"center\">";
        OpenTable2();
        $content = '<table border="0" width="100%">';
        $color = $bgcolor3;
        $result = $db->sql_query("SELECT lid, title, hits FROM " . $downloadsprefix . "_downloads ORDER BY date DESC LIMIT 0, {$show_links_inum}");
        while ($row = $db->sql_fetchrow($result)) {
            $title2 = ereg_replace("_", " ", $row['title']);
            $color = $color == $bgcolor3 ? $bgcolor1 : $bgcolor3;
            $content .= "<tr><td bgcolor=\"{$color}\" align=\"left\"><a href=\"" . getlink("&amp;d_op=viewdownloaddetails&amp;lid={$row['lid']}") . "\">{$title2}</a></td>" . "<td bgcolor=\"{$color}\" align=\"center\" width=\"20\">{$row['hits']}</td></tr>";
        }
        echo "{$content}</table>";
        CloseTable2();
        echo "|[ <a href=\"" . getlink("&amp;d_op=NewDownloads") . "\">" . _NEWDOWNLOADS . "</a> ]|";
        echo "</td><td width=\"50%\" valign=\"top\" align=\"center\">";
        OpenTable2();
        $content = "<table border=\"0\" width=\"100%\">";
        $color = $bgcolor3;
        $result = $db->sql_query("SELECT lid, title, hits FROM " . $downloadsprefix . "_downloads ORDER BY hits DESC LIMIT 0, {$show_links_inum}");
        while ($row = $db->sql_fetchrow($result)) {
            $title2 = ereg_replace("_", " ", $row['title']);
            $color = $color == $bgcolor3 ? $bgcolor1 : $bgcolor3;
            $content .= "<tr><td bgcolor=\"{$color}\" align=\"left\"><a href=\"" . getlink("&amp;d_op=viewdownloaddetails&amp;lid={$row['lid']}") . "\">{$title2}</a></td>" . "<td bgcolor=\"{$color}\" align=\"center\" width=\"20\">{$row['hits']}</td></tr>";
        }
        echo "{$content}</table>";
        CloseTable2();
        echo "|[ <a href=\"" . getlink("&amp;d_op=MostPopular") . "\">" . _MOSTPOPULAR . " " . _DOWNLOADS . "</a> ]|";
        echo "</td></tr></table>";
        CloseTable();
    }
    include "footer.php";
}
Example #4
0
function viewlinkeditorial($lid, $ttitle)
{
    global $prefix, $db, $admin, $module_name;
    include "header.php";
    include "modules/{$module_name}/l_config.php";
    menu(1);
    $lid = intval(trim($lid));
    $result = $db->sql_query("SELECT adminid, editorialtimestamp, editorialtext, editorialtitle FROM " . $prefix . "_links_editorials WHERE linkid = '{$lid}'");
    $recordexist = $db->sql_numrows($result);
    $transfertitle = ereg_replace("_", " ", $ttitle);
    $displaytitle = $transfertitle;
    echo "<br>";
    OpenTable();
    echo "<center><font class=\"option\"><b>" . _LINKPROFILE . ": {$displaytitle}</b></font><br>";
    linkinfomenu($lid, $ttitle);
    if ($recordexist != 0) {
        while ($row = $db->sql_fetchrow($result)) {
            $adminid = intval($row['adminid']);
            $editorialtimestamp = $row['editorialtimestamp'];
            $editorialtext = stripslashes($row['editorialtext']);
            $editorialtitle = stripslashes(check_html($row['editorialtitle'], "nohtml"));
            ereg("([0-9]{4})-([0-9]{1,2})-([0-9]{1,2}) ([0-9]{1,2}):([0-9]{1,2}):([0-9]{1,2})", $editorialtimestamp, $editorialtime);
            $editorialtime = strftime("%F", mktime($editorialtime[4], $editorialtime[5], $editorialtime[6], $editorialtime[2], $editorialtime[3], $editorialtime[1]));
            $date_array = explode("-", $editorialtime);
            $timestamp = mktime(0, 0, 0, $date_array["1"], $date_array["2"], $date_array["0"]);
            $formatted_date = date("F j, Y", $timestamp);
            echo "<br><br>";
            OpenTable2();
            echo "<center><font class=\"option\"><b>'{$editorialtitle}'</b></font></center>" . "<center><font class=\"tiny\">" . _EDITORIALBY . " {$adminid} - {$formatted_date}</font></center><br><br>" . "{$editorialtext}";
            CloseTable2();
        }
    } else {
        echo "<br><br><center><font class=\"option\"><b>" . _NOEDITORIAL . "</b></font></center>";
    }
    echo "<br><br><center>";
    linkfooter($lid, $ttitle);
    echo "</center>";
    CloseTable();
    include "footer.php";
}
Example #5
0
        $send = "no";
    }
    if ($message == "") {
        $message_err = "<center><font class=\"option\"><b><i>" . _FBENTERMESSAGE . "</i></b></font></center><br>";
        $send = "no";
    }
    if ($send != "no") {
        $sender_name = removecrlf($sender_name);
        $sender_email = removecrlf($sender_email);
        $msg = "{$sitename}\n\n";
        $msg .= "" . _SENDERNAME . ": {$sender_name}\n";
        $msg .= "" . _SENDEREMAIL . ": {$sender_email}\n";
        $msg .= "" . _MESSAGE . ": {$message}\n\n";
        $to = $adminmail;
        $mailheaders = "From: {$sender_name} <{$sender_email}>\n";
        $mailheaders .= "Reply-To: {$sender_email}\n\n";
        mail($to, $subject, $msg, $mailheaders);
        echo "<P><center>" . _FBMAILSENT . "</center></p>";
        echo "<P><center>" . _FBTHANKSFORCONTACT . "</center></p>";
    } elseif ($send == "no") {
        OpenTable2();
        echo "{$name_err}";
        echo "{$email_err}";
        echo "{$message_err}";
        CloseTable2();
        echo "<br><br>";
        echo "{$form_block}";
    }
}
CloseTable();
include "footer.php";
Example #6
0
function userinfo($username, $bypass = 0, $hid = 0, $url = 0)
{
    global $articlecomm, $user, $cookie, $sitename, $prefix, $user_prefix, $db, $admin, $broadcast_msg, $my_headlines, $module_name, $subscription_url, $admin_file;
    $username = substr(htmlspecialchars(str_replace("\\'", "'", trim($username))), 0, 25);
    $username = rtrim($username, "\\");
    $username = str_replace("'", "\\'", $username);
    $sql = "SELECT * FROM " . $prefix . "_bbconfig";
    $result = $db->sql_query($sql);
    while ($row = $db->sql_fetchrow($result)) {
        $board_config[$row['config_name']] = $row['config_value'];
    }
    $sql2 = "SELECT * FROM " . $user_prefix . "_users WHERE username='******'";
    $result2 = $db->sql_query($sql2);
    $num = $db->sql_numrows($result2);
    if ($num != 1) {
        Header("Location: modules.php?name={$module_name}");
        die;
    }
    $userinfo = $db->sql_fetchrow($result2);
    if (!$bypass) {
        cookiedecode($user);
    }
    include "header.php";
    OpenTable();
    echo "<center>";
    if ($username != '') {
        // SecurityReason.com Fix 2005 [sp3x]
        if (isset($cookie[1]) and strtolower($username) == strtolower($cookie[1]) and $userinfo['user_password'] == $cookie[2]) {
            echo "<font class=\"option\">" . htmlentities($username) . ", " . _WELCOMETO . " {$sitename}!</font><br><br>";
            echo "<font class=\"content\">" . _THISISYOURPAGE . "</font></center><br><br>";
            nav(1);
            echo "<br><br>";
        } else {
            echo "<font class=\"title\">" . _PERSONALINFO . ": " . htmlentities($username) . "</font></center><br><br>";
        }
    } else {
        Header("Location: modules.php?name={$module_name}");
    }
    if ($userinfo['user_website']) {
        if (!preg_match('#^http[s]?:\\/\\/#i', $userinfo['user_website'])) {
            $userinfo['user_website'] = "http://" . $userinfo['user_website'];
        }
        if (!preg_match('#^http[s]?\\:\\/\\/[a-z0-9\\-]+\\.([a-z0-9\\-]+\\.)?[a-z]+#i', $userinfo['user_website'])) {
            $userinfo['user_website'] = '';
        }
    }
    if ($userinfo['user_avatar_type'] == 1) {
        $userinfo['user_avatar'] = $board_config['avatar_path'] . "/" . $userinfo['user_avatar'];
    } elseif ($userinfo['user_avatar_type'] == 2) {
        $userinfo['user_avatar'] = $userinfo['user_avatar'];
    } else {
        $userinfo['user_avatar'] = $board_config['avatar_gallery_path'] . "/" . $userinfo['user_avatar'];
    }
    if ($num == 1 && ($userinfo['user_website'] || $userinfo['femail'] || $userinfo['bio'] || $userinfo['user_avatar'] || $userinfo['user_icq'] || $userinfo['user_aim'] || $userinfo['user_yim'] || $userinfo['user_msnm'] || $userinfo['user_location'] || $userinfo['user_occ'] || $userinfo['user_interests'] || $userinfo['user_sig'])) {
        echo "<center><font class=\"content\">";
        echo "<img src=\"" . $userinfo['user_avatar'] . "\"><br><br>\n";
        if ($userinfo['user_website'] != "http://" and !empty($userinfo['user_website'])) {
            echo "" . _MYHOMEPAGE . " <a href=\"" . $userinfo['user_website'] . "\" target=\"new\">" . $userinfo['user_website'] . "</a><br>\n";
        }
        if ($userinfo['femail']) {
            echo "" . _MYEMAIL . " <a href=\"mailto:" . $userinfo['femail'] . "\">" . $userinfo['femail'] . "</a><br>\n";
        }
        if ($userinfo['user_icq'] && preg_match('/^[0-9]+$/', $userinfo['user_icq'])) {
            echo "" . _ICQ . ": " . $userinfo['user_icq'] . "<br>\n";
        }
        if ($userinfo['user_aim']) {
            echo "" . _AIM . ": " . $userinfo['user_aim'] . "<br>\n";
        }
        if ($userinfo['user_yim']) {
            echo "" . _YIM . ": " . $userinfo['user_yim'] . "<br>\n";
        }
        if ($userinfo['user_msnm']) {
            echo "" . _MSNM . ": " . $userinfo['user_msnm'] . "<br>\n";
        }
        if ($userinfo['user_from']) {
            echo "" . _LOCATION . ": " . $userinfo['user_from'] . "<br>\n";
        }
        if ($userinfo['user_occ']) {
            echo "" . _OCCUPATION . ": " . $userinfo['user_occ'] . "<br>\n";
        }
        if ($userinfo['user_interests']) {
            echo "" . _INTERESTS . ": " . $userinfo['user_interests'] . "<br>\n";
        }
        $userinfo['user_sig'] = nl2br($userinfo['user_sig']);
        if ($userinfo['user_sig']) {
            echo "<br><b>" . _SIGNATURE . ":</b><br>" . $userinfo['user_sig'] . "<br>\n";
        }
        if ($userinfo['bio']) {
            echo "<br><b>" . _EXTRAINFO . ":</b><br>" . $userinfo['bio'] . "<br>\n";
        }
        $sql2 = "SELECT uname FROM " . $prefix . "_session WHERE uname='{$username}'";
        $result2 = $db->sql_query($sql2);
        $row2 = $db->sql_fetchrow($result2);
        $username_pm = $username;
        $username_online = $row2['uname'];
        if (empty($username_online)) {
            $online = _OFFLINE;
        } else {
            $online = _ONLINE;
        }
        echo "<br><br>" . _USERSTATUS . ": <b>{$online}</b><br>\n";
        if ($userinfo['newsletter'] == 1 and $username == $cookie[1] and $userinfo['user_password'] == $cookie[2] or is_admin($admin) and $userinfo['newsletter'] == 1) {
            echo "<i>" . _SUBSCRIBED . "</i><br>";
        } elseif (isset($cookie[1]) and $userinfo['newsletter'] == 0 and $username == $cookie[1] and $userinfo['user_password'] == $cookie[2] or is_admin($admin) and $userinfo['newsletter'] == 0) {
            echo "<i>" . _NOTSUBSCRIBED . "</i><br>";
        }
        if (is_user($user) and $cookie[1] == "{$username}" or is_admin($admin)) {
            $numpoints = $db->sql_fetchrow($db->sql_query("SELECT points FROM " . $user_prefix . "_users WHERE user_id = '" . intval($cookie[0]) . "'"));
            $n_points = intval($numpoints['points']);
            echo "" . _YOUHAVEPOINTS . " <b>{$n_points}</b><br>";
            if (paid()) {
                $row = $db->sql_fetchrow($db->sql_query("SELECT * FROM " . $prefix . "_subscriptions WHERE userid='" . intval($cookie[0]) . "'"));
                if (!empty($subscription_url)) {
                    $content = "<br><center>" . _YOUARE . " <a href='{$subscription_url}'>" . _SUBSCRIBER . "</a> " . _OF . " {$sitename}<br>";
                } else {
                    $content = "<br><center>" . _YOUARE . " " . _SUBSCRIBER . " " . _OF . " {$sitename}<br>";
                }
                $diff = $row['subscription_expire'] - time();
                $yearDiff = floor($diff / 60 / 60 / 24 / 365);
                $diff -= $yearDiff * 60 * 60 * 24 * 365;
                if ($yearDiff < 1) {
                    $diff = $row['subscription_expire'] - time();
                }
                $daysDiff = floor($diff / 60 / 60 / 24);
                $diff -= $daysDiff * 60 * 60 * 24;
                $hrsDiff = floor($diff / 60 / 60);
                $diff -= $hrsDiff * 60 * 60;
                $minsDiff = floor($diff / 60);
                $diff -= $minsDiff * 60;
                $secsDiff = $diff;
                if ($yearDiff < 1) {
                    $rest = "{$daysDiff} " . _SBDAYS . ", {$hrsDiff} " . _SBHOURS . ", {$minsDiff} " . _SBMINUTES . ", {$secsDiff} " . _SBSECONDS . "";
                } elseif ($yearDiff == 1) {
                    $rest = "{$yearDiff} " . _SBYEAR . ", {$daysDiff} " . _SBDAYS . ", {$hrsDiff} " . _SBHOURS . ", {$minsDiff} " . _SBMINUTES . ", {$secsDiff} " . _SBSECONDS . "";
                } elseif ($yearDiff > 1) {
                    $rest = "{$yearDiff} " . _SBYEARS . ", {$daysDiff} " . _SBDAYS . ", {$hrsDiff} " . _SBHOURS . ", {$minsDiff} " . _SBMINUTES . ", {$secsDiff} " . _SBSECONDS . "";
                }
                $content .= "<b>" . _SUBEXPIREIN . "<br><font color='#FF0000'>{$rest}</font></b></center>";
            } else {
                if (!empty($subscription_url)) {
                    $content .= "<br><center>" . _NOTSUB . " {$sitename}. " . _SUBFROM . " <a href='{$subscription_url}'>" . _HERE . "</a> " . _NOW . "";
                } else {
                    $content .= "<br><center>" . _NOTSUB . " {$sitename}.";
                }
            }
            echo "{$content}<br><br>";
            if (is_admin($admin)) {
                $subnum = $db->sql_numrows($db->sql_query("SELECT * FROM " . $prefix . "_subscriptions WHERE userid='" . intval($userinfo['user_id']) . "'"));
                if ($subnum != 0) {
                    echo "<center><b>" . _ADMSUB . "</b></center><br>";
                    $row = $db->sql_fetchrow($db->sql_query("SELECT * FROM " . $prefix . "_subscriptions WHERE userid='" . intval($userinfo['user_id']) . "'"));
                    $diff = $row['subscription_expire'] - time();
                    $yearDiff = floor($diff / 60 / 60 / 24 / 365);
                    $diff -= $yearDiff * 60 * 60 * 24 * 365;
                    if ($yearDiff < 1) {
                        $diff = $row['subscription_expire'] - time();
                    }
                    $daysDiff = floor($diff / 60 / 60 / 24);
                    $diff -= $daysDiff * 60 * 60 * 24;
                    $hrsDiff = floor($diff / 60 / 60);
                    $diff -= $hrsDiff * 60 * 60;
                    $minsDiff = floor($diff / 60);
                    $diff -= $minsDiff * 60;
                    $secsDiff = $diff;
                    if ($yearDiff < 1) {
                        $rest = "{$daysDiff} " . _SBDAYS . ", {$hrsDiff} " . _SBHOURS . ", {$minsDiff} " . _SBMINUTES . ", {$secsDiff} " . _SBSECONDS . "";
                    } elseif ($yearDiff == 1) {
                        $rest = "{$yearDiff} " . _SBYEAR . ", {$daysDiff} " . _SBDAYS . ", {$hrsDiff} " . _SBHOURS . ", {$minsDiff} " . _SBMINUTES . ", {$secsDiff} " . _SBSECONDS . "";
                    } elseif ($yearDiff > 1) {
                        $rest = "{$yearDiff} " . _SBYEARS . ", {$daysDiff} " . _SBDAYS . ", {$hrsDiff} " . _SBHOURS . ", {$minsDiff} " . _SBMINUTES . ", {$secsDiff} " . _SBSECONDS . "";
                    }
                    $content = "<b>" . _ADMSUBEXPIREIN . "<br><font color='#FF0000'>{$rest}</font></b><br><br>";
                    echo "{$content}";
                } else {
                    echo "<center><b>" . _ADMNOTSUB . "</b><br><br>";
                }
            }
        }
        if (is_active("Journal") and $cookie[1] != $username) {
            $sql3 = "SELECT jid FROM " . $prefix . "_journal WHERE aid='{$username}' AND status='yes' ORDER BY pdate,jid DESC LIMIT 0,1";
            $result3 = $db->sql_query($sql3);
            $row3 = $db->sql_fetchrow($result3);
            $jid = intval($row3['jid']);
            if (!empty($jid) and isset($jid)) {
                echo "[ <a href=\"modules.php?name=Journal&amp;file=search&amp;bywhat=aid&amp;forwhat={$username}\">" . _READMYJOURNAL . "</a> ]<br>";
            }
        }
        if (is_admin($admin)) {
            echo "<br>";
            OpenTable2();
            if ($userinfo['last_ip'] != 0) {
                echo "<center><font class=\"title\">" . _ADMINFUNCTIONS . "</font><br><br>" . _LASTIP . " <b>" . $userinfo['last_ip'] . "</b><br><br>";
                echo "[ <a href='" . $admin_file . ".php?op=ipban&ip=" . $userinfo['last_ip'] . "'>" . _BANTHIS . "</a> | <a href=\"" . $admin_file . ".php?op=modifyUser&chng_uid=" . $userinfo['username'] . "\">" . _EDITUSER . "</a> ]</center>";
            } else {
                echo "<center>[ <a href=\"" . $admin_file . ".php?op=modifyUser&chng_uid=" . $userinfo['username'] . "\">" . _EDITUSER . "</a> ]</center>";
            }
            if ($userinfo['karma'] == 0) {
                $karma = _KARMAGOOD;
                $karma_help = _KARMAGOODHLP;
                $change_karma = "<a href=\"modules.php?name={$module_name}&op=change_karma&user_id=" . $userinfo['user_id'] . "&karma=1\"><img src=\"images/karma/1.gif\" border=\"0\" alt=\"" . _KARMALOW . "\" title=\"" . _KARMALOW . "\" hspace=\"5\"></a>";
                $change_karma .= "<a href=\"modules.php?name={$module_name}&op=change_karma&user_id=" . $userinfo['user_id'] . "&karma=2\"><img src=\"images/karma/2.gif\" border=\"0\" alt=\"" . _KARMABAD . "\" title=\"" . _KARMABAD . "\" hspace=\"5\"></a>";
                $change_karma .= "<a href=\"modules.php?name={$module_name}&op=change_karma&user_id=" . $userinfo['user_id'] . "&karma=3\"><img src=\"images/karma/3.gif\" border=\"0\" alt=\"" . _KARMADEVIL . "\" title=\"" . _KARMADEVIL . "\" hspace=\"5\"></a>";
            } elseif ($userinfo['karma'] == 1) {
                $karma = _KARMALOW;
                $karma_help = _KARMALOWHLP;
                $change_karma = "<a href=\"modules.php?name={$module_name}&op=change_karma&user_id=" . $userinfo['user_id'] . "&karma=0\"><img src=\"images/karma/0.gif\" border=\"0\" alt=\"" . _KARMAGOOD . "\" title=\"" . _KARMAGOOD . "\" hspace=\"5\"></a>";
                $change_karma .= "<a href=\"modules.php?name={$module_name}&op=change_karma&user_id=" . $userinfo['user_id'] . "&karma=2\"><img src=\"images/karma/2.gif\" border=\"0\" alt=\"" . _KARMABAD . "\" title=\"" . _KARMABAD . "\" hspace=\"5\"></a>";
                $change_karma .= "<a href=\"modules.php?name={$module_name}&op=change_karma&user_id=" . $userinfo['user_id'] . "&karma=3\"><img src=\"images/karma/3.gif\" border=\"0\" alt=\"" . _KARMADEVIL . "\" title=\"" . _KARMADEVIL . "\" hspace=\"5\"></a>";
            } elseif ($userinfo['karma'] == 2) {
                $karma = _KARMABAD;
                $karma_help = _KARMABADHLP;
                $change_karma = "<a href=\"modules.php?name={$module_name}&op=change_karma&user_id=" . $userinfo['user_id'] . "&karma=0\"><img src=\"images/karma/0.gif\" border=\"0\" alt=\"" . _KARMAGOOD . "\" title=\"" . _KARMAGOOD . "\" hspace=\"5\"></a>";
                $change_karma .= "<a href=\"modules.php?name={$module_name}&op=change_karma&user_id=" . $userinfo['user_id'] . "&karma=1\"><img src=\"images/karma/1.gif\" border=\"0\" alt=\"" . _KARMALOW . "\" title=\"" . _KARMALOW . "\" hspace=\"5\"></a>";
                $change_karma .= "<a href=\"modules.php?name={$module_name}&op=change_karma&user_id=" . $userinfo['user_id'] . "&karma=3\"><img src=\"images/karma/3.gif\" border=\"0\" alt=\"" . _KARMADEVIL . "\" title=\"" . _KARMADEVIL . "\" hspace=\"5\"></a>";
            } elseif ($userinfo['karma'] == 3) {
                $karma = _KARMADEVIL;
                $karma_help = _KARMADEVILHLP;
                $change_karma = "<a href=\"modules.php?name={$module_name}&op=change_karma&user_id=" . $userinfo['user_id'] . "&karma=0\"><img src=\"images/karma/0.gif\" border=\"0\" alt=\"" . _KARMAGOOD . "\" title=\"" . _KARMAGOOD . "\" hspace=\"5\"></a>";
                $change_karma .= "<a href=\"modules.php?name={$module_name}&op=change_karma&user_id=" . $userinfo['user_id'] . "&karma=1\"><img src=\"images/karma/1.gif\" border=\"0\" alt=\"" . _KARMALOW . "\" title=\"" . _KARMALOW . "\" hspace=\"5\"></a>";
                $change_karma .= "<a href=\"modules.php?name={$module_name}&op=change_karma&user_id=" . $userinfo['user_id'] . "&karma=2\"><img src=\"images/karma/2.gif\" border=\"0\" alt=\"" . _KARMABAD . "\" title=\"" . _KARMABAD . "\" hspace=\"5\"></a>";
            }
            echo "<center><br><br>" . _USERKARMA . " <img src=\"images/karma/" . $userinfo['karma'] . ".gif\" border=\"0\" alt=\"{$karma}\" title=\"{$karma}\"> ({$karma})<br>({$karma_help})</center><br><br>";
            OpenTable2();
            echo "<center><b>" . _CHANGEKARMA . " <i>" . $userinfo['username'] . "</i></b><br><br>";
            echo "{$change_karma}</center>";
            CloseTable2();
            echo "<br>";
            echo "<table border=\"0\" width=\"80%\" cellpadding=\"3\" cellspacing=\"3\" align=\"center\">";
            echo "<tr><td valign=\"middle\"><img src=\"images/karma/0.gif\" border=\"0\" alt=\"" . _KARMAGOOD . "\" title=\"" . _KARMAGOOD . "\"></td><td>" . _KARMAGOODREF . "</td></tr>";
            echo "<tr><td valign=\"middle\"><img src=\"images/karma/1.gif\" border=\"0\" alt=\"" . _KARMALOW . "\" title=\"" . _KARMALOW . "\"></td><td>" . _KARMALOWREF . "</td></tr>";
            echo "<tr><td valign=\"middle\"><img src=\"images/karma/2.gif\" border=\"0\" alt=\"" . _KARMABAD . "\" title=\"" . _KARMABAD . "\"></td><td>" . _KARMABADREF . "</td></tr>";
            echo "<tr><td valign=\"middle\"><img src=\"images/karma/3.gif\" border=\"0\" alt=\"" . _KARMADEVIL . "\" title=\"" . _KARMADEVIL . "\"></td><td>" . _KARMADEVILREF . "</td></tr></table>";
            CloseTable2();
        }
        if ((is_user($user) and $cookie[1] != $username or is_admin($admin)) and is_active("Private_Messages")) {
            echo "<br>[ <a href=\"modules.php?name=Private_Messages&amp;mode=post&amp;u=" . intval($userinfo['user_id']) . "\">" . _USENDPRIVATEMSG . " {$username_pm}</a> ]<br>\n";
        }
        echo "</center></font>";
    } else {
        echo "<center>" . _NOINFOFOR . " " . htmlentities($username) . "</center>";
    }
    CloseTable();
    if (isset($cookie[1]) and $my_headlines == 1 and $username == $cookie[1] and $userinfo['user_password'] == $cookie[2]) {
        echo "<br>";
        OpenTable();
        echo "<center><b>" . _MYHEADLINES . "</b><br><br>" . "" . _SELECTASITE . "<br><br>" . "<form action=\"modules.php?name={$module_name}\" method=\"post\">" . "<input type=\"hidden\" name=\"op\" value=\"userinfo\">" . "<input type=\"hidden\" name=\"username\" value=\"{$username}\">" . "<input type=\"hidden\" name=\"bypass\" value=\"{$bypass}\">" . "<input type=\"hidden\" name=\"url\" value=\"0\">" . "<select name=\"hid\" onChange='submit()'>\n" . "<option value=\"0\">" . _SELECTASITE2 . "</option>";
        $sql4 = "SELECT hid, sitename FROM " . $prefix . "_headlines ORDER BY sitename";
        $headl = $db->sql_query($sql4);
        while ($row4 = $db->sql_fetchrow($headl)) {
            $nhid = intval($row4['hid']);
            $hsitename = filter($row4['sitename'], "nohtml");
            if ($hid == $nhid) {
                $sel = "selected";
            } else {
                $sel = "";
            }
            echo "<option value=\"{$nhid}\" {$sel}>{$hsitename}</option>\n";
        }
        echo "</select></form>" . "" . _ORTYPEURL . "<br><br>" . "<form action=\"modules.php?name={$module_name}\" method=\"post\">" . "<input type=\"hidden\" name=\"op\" value=\"userinfo\">" . "<input type=\"hidden\" name=\"username\" value=\"{$username}\">" . "<input type=\"hidden\" name=\"bypass\" value=\"{$bypass}\">" . "<input type=\"hidden\" name=\"hid\" value=\"0\">" . "<input type=\"text\" name=\"url\" size=\"40\" maxlength=\"200\" value=\"http://\">&nbsp;&nbsp;" . "<input type=\"submit\" value=\"" . _GO . "\"></form>" . "</center><br>";
        if ($hid != 0 or $hid == 0 and $url != "0" and $url != "http://" and !empty($url)) {
            if ($hid != 0) {
                $sql5 = "SELECT sitename, headlinesurl FROM " . $prefix . "_headlines WHERE hid='{$hid}'";
                $result5 = $db->sql_query($sql5);
                $row5 = $db->sql_fetchrow($result5);
                $nsitename = filter($row5[sitename], "nohtml");
                $url = filter($row5[headlinesurl], "nohtml");
                $title = filter($nsitename, "nohtml");
                $siteurl = eregi_replace("http://", "", $url);
                $siteurl = explode("/", $siteurl);
            } else {
                if (!ereg("http://", $url)) {
                    $url = "http://{$url}";
                }
                $siteurl = eregi_replace("http://", "", $url);
                $siteurl = explode("/", $siteurl);
                $title = "http://{$siteurl['0']}";
            }
            $rdf = parse_url($url);
            $fp = fsockopen($rdf['host'], 80, $errno, $errstr, 15);
            if (!$fp) {
                $content = "<center><font class=\"content\">" . _RSSPROBLEM . "</font></center>";
            }
            if ($fp) {
                fputs($fp, "GET " . $rdf['path'] . "?" . $rdf['query'] . " HTTP/1.0\r\n");
                fputs($fp, "HOST: " . $rdf['host'] . "\r\n\r\n");
                $string = "";
                while (!feof($fp)) {
                    $pagetext = fgets($fp, 300);
                    $string .= chop($pagetext);
                }
                fputs($fp, "Connection: close\r\n\r\n");
                fclose($fp);
                $items = explode("</item>", $string);
                $content = "<font class=\"content\">";
                for ($i = 0; $i < 10; $i++) {
                    $link = ereg_replace(".*<link>", "", $items[$i]);
                    $link = ereg_replace("</link>.*", "", $link);
                    $link = stripslashes(check_html($link, "nohtml"));
                    $title2 = ereg_replace(".*<title>", "", $items[$i]);
                    $title2 = ereg_replace("</title>.*", "", $title2);
                    $title2 = stripslashes(check_html($title2, "nohtml"));
                    if (empty($items[$i]) and $cont != 1) {
                        $content = "<center>" . _RSSPROBLEM . "</center>";
                    } else {
                        if (strcmp($link, $title2) and !empty($items[$i])) {
                            $cont = 1;
                            $content .= "<img src=\"images/arrow.gif\" border=\"0\" hspace=\"5\"><a href=\"{$link}\" target=\"new\">{$title2}</a><br>\n";
                        }
                    }
                }
            }
            if (!empty($content)) {
                OpenTable2();
                echo "<center><b>" . _HEADLINESFROM . " <a href=\"http://{$siteurl['0']}\" target=\"new\">{$title}</a></b></center><br>";
                echo "{$content}";
                CloseTable2();
            } elseif ($cont == 0 or empty($content)) {
                OpenTable2();
                echo "<center>" . _RSSPROBLEM . "</center><br>";
                CloseTable2();
            }
            echo "<br>";
        }
        CloseTable();
    }
    if (isset($cookie[1]) and $broadcast_msg == 1 and $username == $cookie[1] and $userinfo['user_password'] == $cookie[2]) {
        echo "<br>";
        OpenTable();
        echo "<center><b>" . _BROADCAST . "</b><br><br>" . _BROADCASTTEXT . "<br><br>" . "<form action=\"modules.php?name={$module_name}\" method=\"post\">" . "<input type=\"hidden\" name=\"who\" value=\"{$username}\">" . "<input type=\"hidden\" name=\"op\" value=\"broadcast\">" . "<input type=\"text\" size=\"60\" maxlength=\"255\" name=\"the_message\">&nbsp;&nbsp;<input type=\"submit\" value=\"" . _SEND . "\">" . "</form></center>";
        CloseTable();
    }
    if (isset($cookie[1]) and is_active("Private_Messages") and $username == $cookie[1] and $userinfo['user_password'] == $cookie[2]) {
        echo "<br>";
        OpenTable();
        echo "<center><b>" . _PRIVATEMESSAGES . "</b><br><br>";
        $numrow = $db->sql_numrows($db->sql_query("SELECT * FROM " . $prefix . "_bbprivmsgs WHERE privmsgs_to_userid='" . intval($userinfo['user_id']) . "' AND (privmsgs_type='1' OR privmsgs_type='5' OR privmsgs_type='0')"));
        if (is_active("Members_List")) {
            $mem_list = "<a href=\"modules.php?name=Members_List\">" . _BROWSEUSERS . "</a>";
        } else {
            $mem_list = "";
        }
        if (is_active("Search")) {
            $mod_search = "<a href=\"modules.php?name=Search&amp;type=users\">" . _SEARCHUSERS . "</a>";
        } else {
            $mod_search = "";
        }
        if (!empty($mem_list) and !empty($mod_search)) {
            $a = " | ";
        } else {
            $a = "";
        }
        if (!empty($mem_list) or !empty($mod_search)) {
            $links = "[ {$mem_list} {$a} {$mod_search} ]";
        } elseif (empty($mem_list) and empty($mod_search)) {
            $links = "";
        }
        echo "" . _YOUHAVE . " <a href=\"modules.php?name=Private_Messages\"><b>{$numrow}</b></a> " . _PRIVATEMSG . "<br><br>" . "<form action=\"modules.php?name=Private_Messages\" method=\"post\">" . "" . _USENDPRIVATEMSG . ": <input type=\"text\" name=\"pm_uname\" size=\"20\">&nbsp;&nbsp;{$links}" . "<input type=\"hidden\" name=\"send\" value=\"1\">" . "</form></center>";
        CloseTable();
    }
    if ($articlecomm == 1) {
        echo "<br>";
        OpenTable();
        echo "<b>" . _LAST10COMMENTS . " " . $userinfo['username'] . ":</b><br>";
        $sql6 = "SELECT tid, sid, subject FROM " . $prefix . "_comments WHERE name='" . $userinfo['username'] . "' ORDER BY tid DESC LIMIT 0,10";
        $result6 = $db->sql_query($sql6);
        while ($row6 = $db->sql_fetchrow($result6)) {
            $tid = intval($row6['tid']);
            $sid = intval($row6['sid']);
            $subject = filter($row6['subject'], "nohtml");
            echo "<li><a href=\"modules.php?name=News&file=article&thold=-1&mode=flat&order=0&sid={$sid}#{$tid}\">{$subject}</a><br>";
        }
        CloseTable();
    }
    echo "<br>";
    OpenTable();
    echo "<b>" . _LAST10SUBMISSIONS . " " . $userinfo['username'] . ":</b><br>";
    $sql7 = "SELECT sid, title FROM " . $prefix . "_stories WHERE informant='" . $userinfo['username'] . "' ORDER BY sid DESC LIMIT 0,10";
    $result7 = $db->sql_query($sql7);
    while ($row7 = $db->sql_fetchrow($result7)) {
        $sid = intval($row7['sid']);
        $title = filter($row7['title'], "nohtml");
        echo "<li><a href=\"modules.php?name=News&file=article&sid={$sid}\">{$title}</a><br>";
    }
    CloseTable();
    include "footer.php";
}
Example #7
0
function Stats_Main()
{
    global $prefix, $db, $startdate, $sitename, $ThemeSel, $user_prefix, $Version_Num, $module_name, $textcolor2;
    include "header.php";
    $result = $db->sql_query("SELECT type, var, count from " . $prefix . "_counter order by type desc");
    while ($row = $db->sql_fetchrow($result)) {
        $type = stripslashes(check_html($row['type'], "nohtml"));
        $var = stripslashes(check_html($row['var'], "nohtml"));
        $count = intval($row['count']);
        if ($type == "total" && $var == "hits") {
            $total = $count;
        } elseif ($type == "browser") {
            if ($var == "FireFox") {
                $firefox[] = $count;
                $firefox[] = substr(100 * $count / $total, 0, 5);
            } elseif ($var == "Netscape") {
                $netscape[] = $count;
                $netscape[] = substr(100 * $count / $total, 0, 5);
            } elseif ($var == "MSIE") {
                $msie[] = $count;
                $msie[] = substr(100 * $count / $total, 0, 5);
            } elseif ($var == "Konqueror") {
                $konqueror[] = $count;
                $konqueror[] = substr(100 * $count / $total, 0, 5);
            } elseif ($var == "Opera") {
                $opera[] = $count;
                $opera[] = substr(100 * $count / $total, 0, 5);
            } elseif ($var == "Lynx") {
                $lynx[] = $count;
                $lynx[] = substr(100 * $count / $total, 0, 5);
            } elseif ($var == "Bot") {
                $bot[] = $count;
                $bot[] = substr(100 * $count / $total, 0, 5);
            } elseif ($type == "browser" && $var == "Other") {
                $b_other[] = $count;
                $b_other[] = substr(100 * $count / $total, 0, 5);
            }
        } elseif ($type == "os") {
            if ($var == "Windows") {
                $windows[] = $count;
                $windows[] = substr(100 * $count / $total, 0, 5);
            } elseif ($var == "Mac") {
                $mac[] = $count;
                $mac[] = substr(100 * $count / $total, 0, 5);
            } elseif ($var == "Linux") {
                $linux[] = $count;
                $linux[] = substr(100 * $count / $total, 0, 5);
            } elseif ($var == "FreeBSD") {
                $freebsd[] = $count;
                $freebsd[] = substr(100 * $count / $total, 0, 5);
            } elseif ($var == "SunOS") {
                $sunos[] = $count;
                $sunos[] = substr(100 * $count / $total, 0, 5);
            } elseif ($var == "IRIX") {
                $irix[] = $count;
                $irix[] = substr(100 * $count / $total, 0, 5);
            } elseif ($var == "BeOS") {
                $beos[] = $count;
                $beos[] = substr(100 * $count / $total, 0, 5);
            } elseif ($var == "OS/2") {
                $os2[] = $count;
                $os2[] = substr(100 * $count / $total, 0, 5);
            } elseif ($var == "AIX") {
                $aix[] = $count;
                $aix[] = substr(100 * $count / $total, 0, 5);
            } elseif ($type == "os" && $var == "Other") {
                $os_other[] = $count;
                $os_other[] = substr(100 * $count / $total, 0, 5);
            }
        }
    }
    title("{$sitename} " . _STATS . "");
    OpenTable();
    OpenTable();
    echo "<center><font class=\"option\"><b>{$sitename} " . _STATS . "</b></font><br><br>" . _WERECEIVED . " <b>{$total}</b> " . _PAGESVIEWS . " {$startdate}<br><br>" . "[ <a href=\"modules.php?name={$module_name}&op=Stats\">" . _VIEWDETAILED . "</a> ]</center>";
    CloseTable();
    echo "<br><br>";
    $l_size = getimagesize("themes/{$ThemeSel}/images/leftbar.gif");
    $m_size = getimagesize("themes/{$ThemeSel}/images/mainbar.gif");
    $r_size = getimagesize("themes/{$ThemeSel}/images/rightbar.gif");
    OpenTable2();
    echo "<table cellspacing=\"0\" cellpadding=\"2\" border=\"0\" align=\"center\"><tr><td colspan=\"2\">\n";
    echo "<center><font color=\"{$textcolor2}\"><b>" . _BROWSERS . "</b></font></center><br></td></tr>\n";
    echo "<tr><td><img src=\"modules/{$module_name}/images/explorer.gif\" border=\"0\" alt=\"\">&nbsp;MSIE: </td><td><img src=\"themes/{$ThemeSel}/images/leftbar.gif\" height=\"{$l_size['1']}\" width=\"{$l_size['0']}\" Alt=\"Internet Explorer\"><img src=\"themes/{$ThemeSel}/images/mainbar.gif\" Alt=\"Internet Explorer\" height=\"{$m_size['1']}\" width=", $msie[1] * 2, "><img src=\"themes/{$ThemeSel}/images/rightbar.gif\" height=\"{$r_size['1']}\" width=\"{$r_size['0']}\" Alt=\"Internet Explorer\"> {$msie['1']} % ({$msie['0']})</td></tr>\n";
    echo "<tr><td><img src=\"modules/{$module_name}/images/firefox.gif\" border=\"0\" alt=\"\">&nbsp;FireFox: </td><td><img src=\"themes/{$ThemeSel}/images/leftbar.gif\" height=\"{$l_size['1']}\" width=\"{$l_size['0']}\" Alt=\"FireFox\"><img src=\"themes/{$ThemeSel}/images/mainbar.gif\" Alt=\"FireFox\" height=\"{$m_size['1']}\" width=", $firefox[1] * 2, "><img src=\"themes/{$ThemeSel}/images/rightbar.gif\" height=\"{$r_size['1']}\" width=\"{$r_size['0']}\" Alt=\"FireFox\"> {$firefox['1']} % ({$firefox['0']})</td></tr>\n";
    echo "<tr><td><img src=\"modules/{$module_name}/images/netscape.gif\" border=\"0\" alt=\"\">&nbsp;Netscape: </td><td><img src=\"themes/{$ThemeSel}/images/leftbar.gif\" height=\"{$l_size['1']}\" width=\"{$l_size['0']}\" Alt=\"Netscape\"><img src=\"themes/{$ThemeSel}/images/mainbar.gif\" Alt=\"Netscape\" height=\"{$m_size['1']}\" width=", $netscape[1] * 2, "><img src=\"themes/{$ThemeSel}/images/rightbar.gif\" height=\"{$r_size['1']}\" width=\"{$r_size['0']}\" Alt=\"Netscape\"> {$netscape['1']} % ({$netscape['0']})</td></tr>\n";
    echo "<tr><td><img src=\"modules/{$module_name}/images/opera.gif\" border=\"0\" alt=\"\">&nbsp;Opera: </td><td><img src=\"themes/{$ThemeSel}/images/leftbar.gif\" height=\"{$l_size['1']}\" width=\"{$l_size['0']}\" Alt=\"Opera\"><img src=\"themes/{$ThemeSel}/images/mainbar.gif\" Alt=\"Opera\" height=\"{$m_size['1']}\" width=", $opera[1] * 2, "><img src=\"themes/{$ThemeSel}/images/rightbar.gif\" height=\"{$r_size['1']}\" width=\"{$r_size['0']}\" Alt=\"Opera\"> {$opera['1']} % ({$opera['0']})</td></tr>\n";
    echo "<tr><td><img src=\"modules/{$module_name}/images/konqueror.gif\" border=\"0\" alt=\"\">&nbsp;Konqueror: </td><td><img src=\"themes/{$ThemeSel}/images/leftbar.gif\" height=\"{$l_size['1']}\" width=\"{$l_size['0']}\" Alt=\"Konqueror\"><img src=\"themes/{$ThemeSel}/images/mainbar.gif\" Alt=\"Konqueror (KDE)\" height=\"{$m_size['1']}\" width=", $konqueror[1] * 2, "><img src=\"themes/{$ThemeSel}/images/rightbar.gif\" height=\"{$r_size['1']}\" width=\"{$r_size['0']}\" Alt=\"Konqueror\"> {$konqueror['1']} % ({$konqueror['0']})</td></tr>\n";
    echo "<tr><td><img src=\"modules/{$module_name}/images/lynx.gif\" border=\"0\" alt=\"\">&nbsp;Lynx: </td><td><img src=\"themes/{$ThemeSel}/images/leftbar.gif\" height=\"{$l_size['1']}\" width=\"{$l_size['0']}\" Alt=\"Lynx\"><img src=\"themes/{$ThemeSel}/images/mainbar.gif\" Alt=\"Lynx\" height=\"{$m_size['1']}\" width=", $lynx[1] * 2, "><img src=\"themes/{$ThemeSel}/images/rightbar.gif\" height=\"{$r_size['1']}\" width=\"{$r_size['0']}\" Alt=\"Lynx\"> {$lynx['1']} % ({$lynx['0']})</td></tr>\n";
    echo "<tr><td><img src=\"modules/{$module_name}/images/altavista.gif\" border=\"0\" alt=\"\">&nbsp;" . _SEARCHENGINES . ": </td><td><img src=\"themes/{$ThemeSel}/images/leftbar.gif\" height=\"{$l_size['1']}\" width=\"{$l_size['0']}\" Alt=\"Robots - Spiders - Buscadores\"><img src=\"themes/{$ThemeSel}/images/mainbar.gif\" Alt=\"Robots - Spiders - Buscadores\" height=\"{$m_size['1']}\" width=", $bot[1] * 2, "><img src=\"themes/{$ThemeSel}/images/rightbar.gif\" height=\"{$r_size['1']}\" width=\"{$r_size['0']}\" Alt=\"" . _BOTS . "\"> {$bot['1']} % ({$bot['0']})</td></tr>\n";
    echo "<tr><td><img src=\"modules/{$module_name}/images/question.gif\" border=\"0\" alt=\"\">&nbsp;" . _UNKNOWN . ": </td><td><img src=\"themes/{$ThemeSel}/images/leftbar.gif\" height=\"{$l_size['1']}\" width=\"{$l_size['0']}\" Alt=\"Otros - Desconocidos\"><img src=\"themes/{$ThemeSel}/images/mainbar.gif\" Alt=\"Otros - Desconocidos\" height=\"{$m_size['1']}\" width=", $b_other[1] * 2, "><img src=\"themes/{$ThemeSel}/images/rightbar.gif\" height=\"{$r_size['1']}\" width=\"{$r_size['0']}\" Alt=\"" . _OTHER . "\"> {$b_other['1']} % ({$b_other['0']})\n";
    echo "</td></tr></table>";
    CloseTable2();
    echo "<br><br>\n";
    OpenTable2();
    echo "<table cellspacing=\"0\" cellpadding=\"2\" border=\"0\" align=\"center\"><tr><td colspan=\"2\">\n";
    echo "<center><font color=\"{$textcolor2}\"><b>" . _OPERATINGSYS . "</b></font></center><br></td></tr>\n";
    echo "<tr><td><img src=\"modules/{$module_name}/images/windows.gif\" border=\"0\" alt=\"\">&nbsp;Windows:</td><td><img src=\"themes/{$ThemeSel}/images/leftbar.gif\" height=\"{$l_size['1']}\" width=\"{$l_size['0']}\" Alt=\"Windows\"><img src=\"themes/{$ThemeSel}/images/mainbar.gif\" Alt=\"Windows\" height=\"{$m_size['1']}\" width=", $windows[1] * 2, "><img src=\"themes/{$ThemeSel}/images/rightbar.gif\" height=\"{$r_size['1']}\" width=\"{$r_size['0']}\" Alt=\"Windows\"> {$windows['1']} % ({$windows['0']})</td></tr>\n";
    echo "<tr><td><img src=\"modules/{$module_name}/images/linux.gif\" border=\"0\" alt=\"\">&nbsp;Linux:</td><td><img src=\"themes/{$ThemeSel}/images/leftbar.gif\" height=\"{$l_size['1']}\" width=\"{$l_size['0']}\" Alt=\"Linux\"><img src=\"themes/{$ThemeSel}/images/mainbar.gif\" Alt=\"Linux\" height=\"{$m_size['1']}\" width=", $linux[1] * 2, "><img src=\"themes/{$ThemeSel}/images/rightbar.gif\" height=\"{$r_size['1']}\" width=\"{$r_size['0']}\" Alt=\"Linux\"> {$linux['1']} % ({$linux['0']})</td></tr>\n";
    echo "<tr><td><img src=\"modules/{$module_name}/images/mac.gif\" border=\"0\" alt=\"\">&nbsp;Mac/PPC:</td><td><img src=\"themes/{$ThemeSel}/images/leftbar.gif\" height=\"{$l_size['1']}\" width=\"{$l_size['0']}\" Alt=\"Mac/PPC\"><img src=\"themes/{$ThemeSel}/images/mainbar.gif\" Alt=\"Mac - PPC\" height=\"{$m_size['1']}\" width=", $mac[1] * 2, "><img src=\"themes/{$ThemeSel}/images/rightbar.gif\" height=\"{$r_size['1']}\" width=\"{$r_size['0']}\" Alt=\"Mac/PPC\"> {$mac['1']} % ({$mac['0']})</td></tr>\n";
    echo "<tr><td><img src=\"modules/{$module_name}/images/bsd.gif\" border=\"0\" alt=\"\">&nbsp;FreeBSD:</td><td><img src=\"themes/{$ThemeSel}/images/leftbar.gif\" height=\"{$l_size['1']}\" width=\"{$l_size['0']}\" Alt=\"FreeBSD\"><img src=\"themes/{$ThemeSel}/images/mainbar.gif\" Alt=\"FreeBSD\" height=\"{$m_size['1']}\" width=", $freebsd[1] * 2, "><img src=\"themes/{$ThemeSel}/images/rightbar.gif\" height=\"{$r_size['1']}\" width=\"{$r_size['0']}\" Alt=\"FreeBSD\"> {$freebsd['1']} % ({$freebsd['0']})</td></tr>\n";
    echo "<tr><td><img src=\"modules/{$module_name}/images/sun.gif\" border=\"0\" alt=\"\">&nbsp;SunOS:</td><td><img src=\"themes/{$ThemeSel}/images/leftbar.gif\" height=\"{$l_size['1']}\" width=\"{$l_size['0']}\" Alt=\"SunOS\"><img src=\"themes/{$ThemeSel}/images/mainbar.gif\" Alt=\"SunOS\" height=\"{$m_size['1']}\" width=", $sunos[1] * 2, "><img src=\"themes/{$ThemeSel}/images/rightbar.gif\" height=\"{$r_size['1']}\" width=\"{$r_size['0']}\" Alt=\"SunOS\"> {$sunos['1']} % ({$sunos['0']})</td></tr>\n";
    echo "<tr><td><img src=\"modules/{$module_name}/images/irix.gif\" border=\"0\" alt=\"\">&nbsp;IRIX:</td><td><img src=\"themes/{$ThemeSel}/images/leftbar.gif\" height=\"{$l_size['1']}\" width=\"{$l_size['0']}\" Alt=\"SGI Irix\"><img src=\"themes/{$ThemeSel}/images/mainbar.gif\" Alt=\"SGI Irix\" height=\"{$m_size['1']}\" width=", $irix[1] * 2, "><img src=\"themes/{$ThemeSel}/images/rightbar.gif\" height=\"{$r_size['1']}\" width=\"{$r_size['0']}\" Alt=\"SGI Irix\"> {$irix['1']} % ({$irix['0']})</td></tr>\n";
    echo "<tr><td><img src=\"modules/{$module_name}/images/be.gif\" border=\"0\" alt=\"\">&nbsp;BeOS:</td><td><img src=\"themes/{$ThemeSel}/images/leftbar.gif\" height=\"{$l_size['1']}\" width=\"{$l_size['0']}\" Alt=\"BeOS\"><img src=\"themes/{$ThemeSel}/images/mainbar.gif\" Alt=\"BeOS\" height=\"{$m_size['1']}\" width=", $beos[1] * 2, "><img src=\"themes/{$ThemeSel}/images/rightbar.gif\" height=\"{$r_size['1']}\" width=\"{$r_size['0']}\" Alt=\"BeOS\"> {$beos['1']} % ({$beos['0']})</td></tr>\n";
    echo "<tr><td><img src=\"modules/{$module_name}/images/os2.gif\" border=\"0\" alt=\"\">&nbsp;OS/2:</td><td><img src=\"themes/{$ThemeSel}/images/leftbar.gif\" height=\"{$l_size['1']}\" width=\"{$l_size['0']}\" Alt=\"OS/2\"><img src=\"themes/{$ThemeSel}/images/mainbar.gif\" Alt=\"OS/2\" height=\"{$m_size['1']}\" width=", $os2[1] * 2, "><img src=\"themes/{$ThemeSel}/images/rightbar.gif\" height=\"{$r_size['1']}\" width=\"{$r_size['0']}\" Alt=\"OS/2\"> {$os2['1']} % ({$os2['0']})</td></tr>\n";
    echo "<tr><td><img src=\"modules/{$module_name}/images/aix.gif\" border=\"0\" alt=\"\">&nbsp;AIX:</td><td><img src=\"themes/{$ThemeSel}/images/leftbar.gif\" height=\"{$l_size['1']}\" width=\"{$l_size['0']}\" Alt=\"AIX\"><img src=\"themes/{$ThemeSel}/images/mainbar.gif\" Alt=\"AIX\" height=\"{$m_size['1']}\" width=", $aix[1] * 2, "><img src=\"themes/{$ThemeSel}/images/rightbar.gif\" height=\"{$r_size['1']}\" width=\"{$r_size['0']}\" Alt=\"AIX\"> {$aix['1']} % ({$aix['0']})</td></tr>\n";
    echo "<tr><td><img src=\"modules/{$module_name}/images/question.gif\" border=\"0\" alt=\"\">&nbsp;" . _UNKNOWN . ":</td><td><img src=\"themes/{$ThemeSel}/images/leftbar.gif\" height=\"{$l_size['1']}\" width=\"{$l_size['0']}\" Alt=\"Otros - Desconocidos\"><img src=\"themes/{$ThemeSel}/images/mainbar.gif\" ALt=\"Otros - Desconocidos\" height=\"{$m_size['1']}\" width=", $os_other[1] * 2, "><img src=\"themes/{$ThemeSel}/images/rightbar.gif\" height=\"{$r_size['1']}\" width=\"{$r_size['0']}\" Alt=\"" . _OTHER . "\"> {$os_other['1']} % ({$os_other['0']})\n";
    echo "</td></tr></table>\n";
    CloseTable2();
    echo "<br><br>\n";
    $unum = $db->sql_numrows($db->sql_query("select user_id from " . $user_prefix . "_users"));
    $anum = $db->sql_numrows($db->sql_query("select * from " . $prefix . "_authors"));
    $snum = $db->sql_numrows($db->sql_query("select sid from " . $prefix . "_stories"));
    $cnum = $db->sql_numrows($db->sql_query("select tid from " . $prefix . "_comments"));
    $subnum = $db->sql_numrows($db->sql_query("select * from " . $prefix . "_queue"));
    if (is_active("Topics")) {
        $tnum = $db->sql_numrows($db->sql_query("select * from " . $prefix . "_topics"));
    }
    if (is_active("Web_Links")) {
        $links = $db->sql_numrows($db->sql_query("select * from " . $prefix . "_links_links"));
        $cat = $db->sql_numrows($db->sql_query("select * from " . $prefix . "_links_categories"));
    }
    OpenTable2();
    echo "<table cellspacing=\"0\" cellpadding=\"2\" border=\"0\" align=\"center\"><tr><td colspan=\"2\">\n";
    echo "<center><font color=\"{$textcolor2}\"><b>" . _MISCSTATS . "</b></font></center><br></td></tr>\n";
    echo "<tr><td><img src=\"modules/{$module_name}/images/users.gif\" border=\"0\" alt=\"\">&nbsp;" . _REGUSERS . "</td><td><b>{$unum}</b></td></tr>\n";
    echo "<tr><td><img src=\"modules/{$module_name}/images/authors.gif\" border=\"0\" alt=\"\">&nbsp;" . _ACTIVEAUTHORS . "</td><td><b>{$anum}</b></td></tr>\n";
    echo "<tr><td><img src=\"modules/{$module_name}/images/news.gif\" border=\"0\" alt=\"\">&nbsp;" . _STORIESPUBLISHED . "</td><td><b>{$snum}</b></td></tr>\n";
    if (is_active("Topics")) {
        echo "<tr><td><img src=\"modules/{$module_name}/images/topics.gif\" border=\"0\" alt=\"\">&nbsp;" . _SACTIVETOPICS . "</td><td><b>{$tnum}</b></td></tr>\n";
    }
    echo "<tr><td><img src=\"modules/{$module_name}/images/comments.gif\" border=\"0\" alt=\"\">&nbsp;" . _COMMENTSPOSTED . "</td><td><b>{$cnum}</b></td></tr>\n";
    if (is_active("Web_Links")) {
        echo "<tr><td><img src=\"modules/{$module_name}/images/topics.gif\" border=\"0\" alt=\"\">&nbsp;" . _LINKSINLINKS . "</td><td><b>{$links}</b></td></tr>\n";
        echo "<tr><td><img src=\"modules/{$module_name}/images/sections.gif\" border=\"0\" alt=\"\">&nbsp;" . _LINKSCAT . "</td><td><b>{$cat}</b></td></tr>\n";
    }
    echo "</table>\n";
    CloseTable2();
    CloseTable();
    include "footer.php";
}
Example #8
0
function viewdownload($cid, $min, $orderby, $show)
{
    global $prefix, $dbi, $admin, $perpage, $module_name, $user, $bgcolor1, $bgcolor3, $show_links_num;
    include "header.php";
    if (!isset($min)) {
        $min = 0;
    }
    if (!isset($max)) {
        $max = $min + $perpage;
    }
    if (isset($orderby)) {
        $orderby = convertorderbyin($orderby);
    } else {
        $orderby = "title ASC";
    }
    if ($show != "") {
        $perpage = $show;
    } else {
        $show = $perpage;
    }
    $result = sql_query("SELECT title,cdescription,ldescription,parentid FROM " . $prefix . "_downloads_categories WHERE cid={$cid}", $dbi);
    list($title, $cdescription, $ldescription, $parentid) = sql_fetch_row($result, $dbi);
    $title = getparentlink($parentid, $title);
    $title = "<a href=modules.php?name={$module_name}>" . _MAIN . "</a>/{$title}";
    menu(1);
    echo "<br>";
    if ($ldescription != '') {
        OpenTable2();
        echo "{$ldescription}";
        CloseTable2();
        echo "<BR>";
    }
    OpenTable();
    if ($cdescription != '') {
        $cdescription = "<BR>" . $cdescription;
    }
    echo "<center><font class=\"title\"><b>" . _CATEGORY . ": {$title}</b></font>{$cdescription}</center>";
    echo "<table border=\"0\" cellspacing=\"10\" cellpadding=\"0\" align=\"center\"><tr>";
    $result2 = sql_query("SELECT cid, title, cdescription FROM " . $prefix . "_downloads_categories WHERE parentid={$cid} order by title", $dbi);
    $count = 0;
    while (list($cid2, $title2, $cdescription2) = sql_fetch_row($result2, $dbi)) {
        if ($show_links_num == 1) {
            $cresult = sql_query("SELECT * FROM " . $prefix . "_downloads_downloads WHERE cid={$cid2}", $dbi);
            $cnumrows = sql_num_rows($cresult, $dbi);
            $cnumm = " ({$cnumrows})";
        } else {
            $cnum = "";
        }
        if ($cnumrows > 0) {
            $folder = "modules/Downloads/images/openfolder.gif";
        } else {
            $folder = "modules/Downloads/images/closedfolder.gif";
        }
        if (is_admin($admin)) {
            $folderImg = "<A HREF=\"admin.php?op=DownloadsModCat&amp;cat={$cid2}\"><IMG SRC=\"{$folder}\" BORDER=0 ALT=\"" . _EDIT . "\"></A>";
        } else {
            $folderImg = "<IMG SRC=\"{$folder}\" BORDER=0 ALT=\"{$title2}\">";
        }
        echo "<td><font class=\"title\">{$folderImg} <a href=\"modules.php?name={$module_name}&d_op=viewdownload&amp;cid={$cid2}\"><b>{$title2}</b></a></font>{$cnumm}";
        categorynewdownloadgraphic($cid2);
        if ($cdescription2) {
            echo "<BR><font class=\"content\">{$cdescription2}</font><br>";
        } else {
            echo "<br>";
        }
        $result3 = sql_query("SELECT cid, title FROM " . $prefix . "_downloads_categories WHERE parentid={$cid2} order by title limit 0,3", $dbi);
        $space = 0;
        while (list($cid3, $title3) = sql_fetch_row($result3, $dbi)) {
            if ($space > 0) {
                echo ",&nbsp;";
            }
            if ($show_links_num == 1) {
                $cresult2 = sql_query("SELECT * FROM " . $prefix . "_downloads_downloads WHERE cid={$cid3}", $dbi);
                $cnumrows2 = sql_num_rows($cresult2, $dbi);
                $cnum = " ({$cnumrows2})";
            } else {
                $cnum = "";
            }
            echo "<font class=\"content\"><a href=\"modules.php?name={$module_name}&d_op=viewdownload&amp;cid={$cid3}\">{$title3}</a></font>{$cnum}";
            $space++;
        }
        if ($count < 1) {
            echo "</td><td>&nbsp;&nbsp;&nbsp;&nbsp;</td>";
            $dum = 1;
        }
        $count++;
        if ($count == 2) {
            echo "</td></tr><tr>";
            $count = 0;
            $dum = 0;
        }
    }
    if ($dum == 1) {
        echo "</tr></table>";
    } elseif ($dum == 0) {
        echo "<td></td></tr></table>";
    }
    echo "<hr noshade size=\"1\">";
    $orderbyTrans = convertorderbytrans($orderby);
    echo "<center><font class=\"content\">" . _SORTDOWNLOADSBY . ": " . "" . _TITLE . " (<a href=\"modules.php?name={$module_name}&d_op=viewdownload&amp;cid={$cid}&amp;orderby=titleA\">A</a>\\<a href=\"modules.php?name={$module_name}&d_op=viewdownload&amp;cid={$cid}&amp;orderby=titleD\">D</a>) " . "" . _DATE . " (<a href=\"modules.php?name={$module_name}&d_op=viewdownload&amp;cid={$cid}&amp;orderby=dateA\">A</a>\\<a href=\"modules.php?name={$module_name}&d_op=viewdownload&amp;cid={$cid}&amp;orderby=dateD\">D</a>) " . "" . _RATING . " (<a href=\"modules.php?name={$module_name}&d_op=viewdownload&amp;cid={$cid}&amp;orderby=ratingA\">A</a>\\<a href=\"modules.php?name={$module_name}&d_op=viewdownload&amp;cid={$cid}&amp;orderby=ratingD\">D</a>) " . "" . _POPULARITY . " (<a href=\"modules.php?name={$module_name}&d_op=viewdownload&amp;cid={$cid}&amp;orderby=hitsA\">A</a>\\<a href=\"modules.php?name={$module_name}&d_op=viewdownload&amp;cid={$cid}&amp;orderby=hitsD\">D</a>)" . "<br><b>" . _RESSORTED . ": {$orderbyTrans}</b></font></center>";
    echo "<hr noshade size=\"1\">";
    $result = sql_query("SELECT lid, title, url, description, date, hits, downloadratingsummary, totalvotes, totalcomments, filesize, version, homepage FROM " . $prefix . "_downloads_downloads WHERE cid={$cid} order by {$orderby} limit {$min},{$perpage} ", $dbi);
    $fullcountresult = sql_query("SELECT lid FROM " . $prefix . "_downloads_downloads WHERE cid={$cid}", $dbi);
    $totalselecteddownloads = sql_num_rows($fullcountresult, $dbi);
    echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"10\" border=\"0\"><tr><td><font class=\"content\">";
    $x = 0;
    $color = $bgcolor3;
    while (list($lid, $title, $url, $description, $time, $hits, $downloadratingsummary, $totalvotes, $totalcomments, $filesize, $version, $homepage) = sql_fetch_row($result, $dbi)) {
        $downloadratingsummary = number_format($downloadratingsummary, $mainvotedecimal);
        $title = stripslashes($title);
        $description = stripslashes($description);
        $color = switchColor($color);
        echo "<TABLE BORDER=0 CELLPADDING=2 CELLSPACING=0 WIDTH=100%><TR BGCOLOR=\"{$color}\"><TD>";
        if (is_admin($admin)) {
            if (eregi("http", $url)) {
                echo "<a href=\"admin.php?op=DownloadsModDownload&amp;lid={$lid}\"><img src=\"modules/{$module_name}/images/icon30.gif\" border=\"0\" alt=\"" . _EDIT . "\"></a>";
            } else {
                echo "<a href=\"admin.php?op=DownloadsModDownload&amp;lid={$lid}\"><img src=\"modules/{$module_name}/images/download.gif\" border=\"0\" alt=\"" . _EDIT . "\"></a>";
            }
        } else {
            if (eregi("http", $url)) {
                echo "<img src=\"modules/{$module_name}/images/icon30.gif\" border=\"0\" alt=\"\">";
            } else {
                echo "<img src=\"modules/{$module_name}/images/download.gif\" border=\"0\" alt=\"\">";
            }
        }
        echo "</td><TD WIDTH=100% CLASS=\"title\" VALIGN=TOP><a href=\"modules.php?name={$module_name}&d_op=getit&amp;lid={$lid}\" TARGET=\"_blank\"><B>{$title}</B></a>";
        newdownloadgraphic($datetime, $time);
        popgraphic($hits);
        detecteditorial($lid, $transfertitle, 1);
        echo "</TD></TR><TR BGCOLOR=\"{$color}\"><TD COLSPAN=2>";
        echo "<DIV ALIGN=\"JUSTIFY\"><b>" . _DESCRIPTION . ":</b> {$description}</TD></TR><TR BGCOLOR=\"{$color}\"><TD COLSPAN=2>";
        setlocale(LC_TIME, $locale);
        ereg("([0-9]{4})-([0-9]{1,2})-([0-9]{1,2}) ([0-9]{1,2}):([0-9]{1,2}):([0-9]{1,2})", $time, $datetime);
        $datetime = strftime("" . _LINKSDATESTRING . "", mktime($datetime[4], $datetime[5], $datetime[6], $datetime[2], $datetime[3], $datetime[1]));
        $datetime = ucfirst($datetime);
        echo "<b>" . _VERSION . ":</b> {$version} <b>" . _FILESIZE . ":</b> " . CoolSize($filesize) . "<br>";
        echo "<b>" . _ADDEDON . ":</b> {$datetime} <b>" . _UDOWNLOADS . ":</b> {$hits}";
        $transfertitle = str_replace(" ", "_", $title);
        /* voting & comments stats */
        if ($totalvotes == 1) {
            $votestring = _VOTE;
        } else {
            $votestring = _VOTES;
        }
        if ($downloadratingsummary != "0" || $downloadratingsummary != "0.0") {
            echo " <b>" . _RATING . ":</b> {$downloadratingsummary} ({$totalvotes} {$votestring})";
        }
        if ($homepage == "") {
            echo "<br>";
        } else {
            echo "<br><a href=\"{$homepage}\" target=\"new\">" . _HOMEPAGE . "</a> | ";
        }
        echo "<a href=\"modules.php?name={$module_name}&d_op=ratedownload&amp;lid={$lid}&amp;ttitle={$transfertitle}\">" . _RATERESOURCE . "</a>";
        if (is_user($user)) {
            echo " | <a href=\"modules.php?name={$module_name}&d_op=brokendownload&amp;lid={$lid}\">" . _REPORTBROKEN . "</a>";
        }
        echo " | <a href=\"modules.php?name={$module_name}&d_op=viewdownloaddetails&amp;lid={$lid}&amp;ttitle={$transfertitle}\">" . _DETAILS . "</a>";
        if ($totalcomments != 0) {
            echo " | <a href=\"modules.php?name={$module_name}&d_op=viewdownloadcomments&amp;lid={$lid}&amp;ttitle={$transfertitle}\">" . _SCOMMENTS . " ({$totalcomments})</a>";
        }
        detecteditorial($lid, $transfertitle, 0);
        echo "</DIV></TD></TR></TABLE><br>";
        $x++;
    }
    echo "</font>";
    $orderby = convertorderbyout($orderby);
    /* Calculates how many pages exist. Which page one should be on, etc... */
    $downloadpagesint = $totalselecteddownloads / $perpage;
    $downloadpageremainder = $totalselecteddownloads % $perpage;
    if ($downloadpageremainder != 0) {
        $downloadpages = ceil($downloadpagesint);
        if ($totalselecteddownloads < $perpage) {
            $downloadpageremainder = 0;
        }
    } else {
        $downloadpages = $downloadpagesint;
    }
    /* Page Numbering */
    if ($downloadpages != 1 && $downloadpages != 0) {
        echo "<br><br>";
        echo "" . _SELECTPAGE . ": ";
        $prev = $min - $perpage;
        if ($prev >= 0) {
            echo "&nbsp;&nbsp;<b>[ <a href=\"modules.php?name={$module_name}&d_op=viewdownload&amp;cid={$cid}&amp;min={$prev}&amp;orderby={$orderby}&amp;show={$show}\">";
            echo " &lt;&lt; " . _PREVIOUS . "</a> ]</b> ";
        }
        $counter = 1;
        $currentpage = $max / $perpage;
        while ($counter <= $downloadpages) {
            $cpage = $counter;
            $mintemp = $perpage * $counter - $perpage;
            if ($counter == $currentpage) {
                echo "<b>{$counter}</b>&nbsp";
            } else {
                echo "<a href=\"modules.php?name={$module_name}&d_op=viewdownload&amp;cid={$cid}&amp;min={$mintemp}&amp;orderby={$orderby}&amp;show={$show}\">{$counter}</a> ";
            }
            $counter++;
        }
        $next = $min + $perpage;
        if ($x >= $perpage) {
            echo "&nbsp;&nbsp;<b>[ <a href=\"modules.php?name={$module_name}&d_op=viewdownload&amp;cid={$cid}&amp;min={$max}&amp;orderby={$orderby}&amp;show={$show}\">";
            echo " " . _NEXT . " &gt;&gt;</a> ]</b> ";
        }
    }
    echo "</td></tr></table>";
    CloseTable();
    include "footer.php";
}
Example #9
0
 function moderation_reviews_view($id)
 {
     global $prefix, $db, $admin_file;
     $id = intval($id);
     include "header.php";
     GraphicAdmin();
     mod_menu();
     OpenTable();
     $comm = $db->sql_fetchrow($db->sql_query("SELECT * FROM " . $prefix . "_reviews_comments_moderated WHERE cid='{$id}'"));
     $comm['userid'] = intval($comm['userid']);
     $comm['score'] = intval($comm['score']);
     $comm['comments'] = filter($comm['comments']);
     $revi = $db->sql_fetchrow($db->sql_query("SELECT title FROM " . $prefix . "_reviews WHERE id=" . intval($comm['rid'])));
     $revi['title'] = filter($revi['title'], "nohtml");
     echo "<center><b>Comment to the Review:</b></center><br>";
     OpenTable2();
     echo "<center><i>" . $revi['title'] . "</i></center>";
     CloseTable2();
     echo "<br><br><center><b>" . _COMMENTAPPPENDING . "</b></center><br>";
     OpenTable2();
     echo "<b>" . $revi['title'] . "</b><br>" . _BY . " " . $comm['userid'] . " " . _WITHSCORE . " " . $comm['score'] . "/10<br><br>" . $comm['comments'] . "<br><br>";
     echo "<center><hr size=\"1\" width=\"80%\"><a href=\"" . $admin_file . ".php?op=moderation_approval&section=reviews&id={$id}\"><img src=\"images/karma/approve.gif\" alt=\"" . _APPROVE . "\" title=\"" . _APPROVE . "\" width=\"15\" heigh=\"15\" border=\"0\"></a> &nbsp; <a href=\"" . $admin_file . ".php?op=moderation_reject&section=reviews&id={$id}\"><img src=\"images/karma/reject.gif\" alt=\"" . _REJECT . "\" title=\"" . _REJECT . "\" width=\"15\" heigh=\"15\" border=\"0\"></a></center>";
     CloseTable2();
     echo "<br>";
     CloseTable();
     include "footer.php";
 }
function replace_var($vars)
{
    $var = $vars[1];
    if (substr($var, 0, 9) == '?sitemgr:') {
        $params = explode(',', substr($var, 9));
        switch (count($params)) {
            case 0:
                $val = '';
                break;
            case 1:
                $val = sitemgr_link2('', $params[0]);
                break;
            case 2:
                $val = sitemgr_link2($params[0], $params[1]);
                break;
            default:
                $val = $var;
        }
    } elseif (substr($var, 0, 7) == '?phpgw:') {
        $params = explode(',', substr($var, 7));
        switch (count($params)) {
            case 0:
                $val = '';
                break;
            case 1:
                $val = phpgw_link('', $params[0]);
                break;
            case 2:
                $val = phpgw_link($params[0], $params[1]);
                break;
            default:
                $val = $var;
        }
    } elseif (substr($var, 0, 1) == '?') {
        $val = sitemgr_link2('/index.php', substr($var, 1));
    } elseif ($var == 'news') {
        $ui = new ui();
        $val = $ui->get_news();
        unset($ui);
    } elseif (substr($var, 0, 6) == 'block-') {
        if (file_exists('blocks/' . $var . '.php')) {
            $title = ereg_replace('_', ' ', substr($var, 6));
            include 'blocks/' . $var . '.php';
        } else {
            $title = lang('Block not found.');
            $content = lang('Contact the administrator.');
        }
        add_theme_var('block_title', $title);
        add_theme_var('block_content', $content);
        if (function_exists('themecenterbox')) {
            $val = themecenterbox($title, $content);
        } else {
            $val = parse_theme_vars(implode("", file('templates/' . $GLOBALS['sitemgr_info']['themesel'] . '/centerblock.tpl')));
        }
    } else {
        /* Check for reserved vars first, otherwise
        			   get from the global theme_vars
        			*/
        switch (strtolower($var)) {
            case 'opentable':
                $val = OpenTable();
                break;
            case 'opentable2':
                $val = OpenTable2();
                break;
            case 'closetable':
                $val = CloseTable();
                break;
            case 'closetable2':
                $val = CloseTable2();
                break;
            default:
                $val = $GLOBALS['theme_vars'][$var];
        }
    }
    return $val;
}
Example #11
0
function userinfo($username, $bypass = 0, $hid = 0, $url = 0)
{
    global $articlecomm, $user, $cookie, $sitename, $prefix, $user_prefix, $db, $admin, $broadcast_msg, $my_headlines, $module_name, $subscription_url;
    $username = substr("{$username}", 0, 25);
    $sql = "SELECT * FROM " . $prefix . "_bbconfig";
    $result = $db->sql_query($sql);
    while ($row = $db->sql_fetchrow($result)) {
        $board_config[$row['config_name']] = $row['config_value'];
    }
    $sql2 = "SELECT * FROM " . $user_prefix . "_users WHERE username='******'";
    $result2 = $db->sql_query($sql2);
    $num = $db->sql_numrows($result2);
    $userinfo = $db->sql_fetchrow($result2);
    if (!$bypass) {
        cookiedecode($user);
    }
    include "header.php";
    OpenTable();
    echo "<center>";
    if (strtolower($username) == strtolower($cookie[1]) and $userinfo[user_password] == $cookie[2]) {
        echo "<font class=\"option\">{$username}, " . _WELCOMETO . " {$sitename}!</font><br><br>";
        echo "<font class=\"content\">" . _THISISYOURPAGE . "</font></center><br><br>";
        nav(1);
        echo "<br><br>";
    } else {
        echo "<font class=\"title\">" . _PERSONALINFO . ": {$username}</font></center><br><br>";
    }
    if ($userinfo[user_website]) {
        if (!eregi("http://", $userinfo[user_website])) {
            $userinfo[user_website] = "http://{$userinfo['user_website']}";
        }
    }
    if ($userinfo[user_avatar_type] == 1) {
        $userinfo[user_avatar] = $board_config['avatar_path'] . "/" . $userinfo[user_avatar];
    } elseif ($userinfo[user_avatar_type] == 2) {
        $userinfo[user_avatar] = $userinfo[user_avatar];
    } else {
        $userinfo[user_avatar] = $board_config[avatar_gallery_path] . "/" . $userinfo[user_avatar];
    }
    if ($num == 1 && ($userinfo[user_website] || $userinfo[femail] || $userinfo[bio] || $userinfo[user_avatar] || $userinfo[user_icq] || $userinfo[user_aim] || $userinfo[user_yim] || $userinfo[user_msnm] || $userinfo[user_location] || $userinfo[user_occ] || $userinfo[user_interests] || $userinfo[user_sig])) {
        echo "<center><font class=\"content\">";
        echo "<img src=\"{$userinfo['user_avatar']}\"><br><br>\n";
        if ($userinfo[user_website] != "http://" and $userinfo[user_website] != "") {
            echo "" . _MYHOMEPAGE . " <a href=\"{$userinfo['user_website']}\" target=\"new\">{$userinfo['user_website']}</a><br>\n";
        }
        echo "<CENTER><BR>" . _FULLNAME . ": {$userinfo['name']}" . "<BR>" . _REGNEWUSERTYPE . ": {$userinfo['usertype']}" . "<BR>" . _REGNEWUSERGRADYEAR . ": {$userinfo['gradyear']}" . "<BR>" . _SPECIALIZATION . ": {$userinfo['specialization']}" . "<BR>" . _REGNEWUSERCOMPANY . ": {$userinfo['company']}" . "</font></center><br><br>";
        if ($userinfo[femail]) {
            echo "" . _MYEMAIL . " <a href=\"mailto:{$userinfo['femail']}\">{$userinfo['femail']}</a><br>\n";
        }
        if ($userinfo[user_icq]) {
            echo "" . _ICQ . ": {$userinfo['user_icq']}<br>\n";
        }
        if ($userinfo[user_aim]) {
            echo "" . _AIM . ": {$userinfo['user_aim']}<br>\n";
        }
        if ($userinfo[user_yim]) {
            echo "" . _YIM . ": {$userinfo['user_yim']}<br>\n";
        }
        if ($userinfo[user_msnm]) {
            echo "" . _MSNM . ": {$userinfo['user_msnm']}<br>\n";
        }
        if ($userinfo[user_from]) {
            echo "" . _LOCATION . ": {$userinfo['user_from']}<br>\n";
        }
        if ($userinfo[user_occ]) {
            echo "" . _OCCUPATION . ": {$userinfo['user_occ']}<br>\n";
        }
        if ($userinfo[user_interests]) {
            echo "" . _INTERESTS . ": {$userinfo['user_interests']}<br>\n";
        }
        $userinfo[user_sig] = nl2br($userinfo[user_sig]);
        if ($userinfo[user_sig]) {
            echo "<br><b>" . _SIGNATURE . ":</b><br>{$userinfo['user_sig']}<br>\n";
        }
        if ($userinfo[bio]) {
            echo "<br><b>" . _EXTRAINFO . ":</b><br>{$userinfo['bio']}<br>\n";
        }
        $sql2 = "SELECT uname FROM " . $prefix . "_session WHERE uname='{$username}'";
        $result2 = $db->sql_query($sql2);
        $row2 = $db->sql_fetchrow($result2);
        $username_pm = $username;
        $username_online = $row2[uname];
        if ($username_online == "") {
            $online = _OFFLINE;
        } else {
            $online = _ONLINE;
        }
        echo "" . _USERSTATUS . ": <b>{$online}</b><br>\n";
        if ($userinfo[newsletter] == 1 and $username == $cookie[1] and $userinfo[user_password] == $cookie[2] or is_admin($admin) and $userinfo[newsletter] == 1) {
            echo "<i>" . _SUBSCRIBED . "</i><br>";
        } elseif ($userinfo[newsletter] == 0 and $username == $cookie[1] and $userinfo[user_password] == $cookie[2] or is_admin($admin) and $userinfo[newsletter] == 0) {
            echo "<i>" . _NOTSUBSCRIBED . "</i><br>";
        }
        if (is_user($user) and $cookie[1] == "{$username}" or is_admin($admin)) {
            $numpoints = $db->sql_fetchrow($db->sql_query("SELECT points FROM " . $user_prefix . "_users WHERE username='******'1']}'"));
            $n_points = intval($numpoints['points']);
            echo "" . _YOUHAVEPOINTS . " <b>{$n_points}</b><br>";
            if (paid()) {
                $row = $db->sql_fetchrow($db->sql_query("SELECT * FROM " . $prefix . "_subscriptions WHERE userid='{$cookie['0']}'"));
                if ($subscription_url != "") {
                    $content = "<br><center>" . _YOUARE . " <a href='{$subscription_url}'>" . _SUBSCRIBER . "</a> " . _OF . " {$sitename}<br>";
                } else {
                    $content = "<br><center>" . _YOUARE . " " . _SUBSCRIBER . " " . _OF . " {$sitename}<br>";
                }
                $diff = $row[subscription_expire] - time();
                $yearDiff = floor($diff / 60 / 60 / 24 / 365);
                $diff -= $yearDiff * 60 * 60 * 24 * 365;
                if ($yearDiff < 1) {
                    $diff = $row[subscription_expire] - time();
                }
                $daysDiff = floor($diff / 60 / 60 / 24);
                $diff -= $daysDiff * 60 * 60 * 24;
                $hrsDiff = floor($diff / 60 / 60);
                $diff -= $hrsDiff * 60 * 60;
                $minsDiff = floor($diff / 60);
                $diff -= $minsDiff * 60;
                $secsDiff = $diff;
                if ($yearDiff < 1) {
                    $rest = "{$daysDiff} " . _SBDAYS . ", {$hrsDiff} " . _SBHOURS . ", {$minsDiff} " . _SBMINUTES . ", {$secsDiff} " . _SBSECONDS . "";
                } elseif ($yearDiff == 1) {
                    $rest = "{$yearDiff} " . _SBYEAR . ", {$daysDiff} " . _SBDAYS . ", {$hrsDiff} " . _SBHOURS . ", {$minsDiff} " . _SBMINUTES . ", {$secsDiff} " . _SBSECONDS . "";
                } elseif ($yearDiff > 1) {
                    $rest = "{$yearDiff} " . _SBYEARS . ", {$daysDiff} " . _SBDAYS . ", {$hrsDiff} " . _SBHOURS . ", {$minsDiff} " . _SBMINUTES . ", {$secsDiff} " . _SBSECONDS . "";
                }
                $content .= "<b>" . _SUBEXPIREIN . "<br><font color='#FF0000'>{$rest}</font></b></center>";
            } else {
                if ($subscription_url != "") {
                    $content .= "<br><center>" . _NOTSUB . " {$sitename}. " . _SUBFROM . " <a href='{$subscription_url}'>" . _HERE . "</a> " . _NOW . "";
                } else {
                    $content .= "<br><center>" . _NOTSUB . " {$sitename}.";
                }
            }
            echo "{$content}<br><br>";
            if (is_admin($admin)) {
                $subnum = $db->sql_numrows($db->sql_query("SELECT * FROM " . $prefix . "_subscriptions WHERE userid='{$userinfo['user_id']}'"));
                if ($subnum != 0) {
                    echo "<center><b>" . _ADMSUB . "</b></center><br>";
                    $row = $db->sql_fetchrow($db->sql_query("SELECT * FROM " . $prefix . "_subscriptions WHERE userid='{$userinfo['user_id']}'"));
                    $diff = $row[subscription_expire] - time();
                    $yearDiff = floor($diff / 60 / 60 / 24 / 365);
                    $diff -= $yearDiff * 60 * 60 * 24 * 365;
                    if ($yearDiff < 1) {
                        $diff = $row[subscription_expire] - time();
                    }
                    $daysDiff = floor($diff / 60 / 60 / 24);
                    $diff -= $daysDiff * 60 * 60 * 24;
                    $hrsDiff = floor($diff / 60 / 60);
                    $diff -= $hrsDiff * 60 * 60;
                    $minsDiff = floor($diff / 60);
                    $diff -= $minsDiff * 60;
                    $secsDiff = $diff;
                    if ($yearDiff < 1) {
                        $rest = "{$daysDiff} " . _SBDAYS . ", {$hrsDiff} " . _SBHOURS . ", {$minsDiff} " . _SBMINUTES . ", {$secsDiff} " . _SBSECONDS . "";
                    } elseif ($yearDiff == 1) {
                        $rest = "{$yearDiff} " . _SBYEAR . ", {$daysDiff} " . _SBDAYS . ", {$hrsDiff} " . _SBHOURS . ", {$minsDiff} " . _SBMINUTES . ", {$secsDiff} " . _SBSECONDS . "";
                    } elseif ($yearDiff > 1) {
                        $rest = "{$yearDiff} " . _SBYEARS . ", {$daysDiff} " . _SBDAYS . ", {$hrsDiff} " . _SBHOURS . ", {$minsDiff} " . _SBMINUTES . ", {$secsDiff} " . _SBSECONDS . "";
                    }
                    $content = "<b>" . _ADMSUBEXPIREIN . "<br><font color='#FF0000'>{$rest}</font></b><br><br>";
                    echo "{$content}";
                } else {
                    echo "<center><b>" . _ADMNOTSUB . "</b><br><br>";
                }
            }
        }
        if (is_user($user) and $cookie[1] == "{$username}" or is_admin($admin)) {
            $numpoints = $db->sql_fetchrow($db->sql_query("SELECT points FROM " . $user_prefix . "_users WHERE username='******'1']}'"));
            echo "" . _YOUHAVEPOINTS . " <b>{$numpoints['points']}</b><br>";
        }
        if (is_active("Journal") and $cookie[1] != $username) {
            $sql3 = "SELECT jid FROM " . $prefix . "_journal WHERE aid='{$username}' AND status='yes' ORDER BY pdate,jid DESC LIMIT 0,1";
            $result3 = $db->sql_query($sql3);
            $row3 = $db->sql_fetchrow($result3);
            $jid = intval($row3[jid]);
            if ($jid != "" and isset($jid)) {
                echo "[ <a href=\"modules.php?name=Journal&amp;file=search&amp;bywhat=aid&amp;forwhat={$username}\">" . _READMYJOURNAL . "</a> ]<br>";
            }
        }
        if (is_admin($admin)) {
            echo "<br>";
            OpenTable2();
            if ($userinfo[last_ip] != 0) {
                echo "<center>" . _LASTIP . " <b>{$userinfo['last_ip']}</b><br><br>";
                echo "[ <a href='admin.php?op=ipban&ip={$userinfo['last_ip']}'>" . _BANTHIS . "</a> | <a href=\"admin.php?op=modifyUser&chng_uid={$userinfo['user_id']}\">" . _EDITUSER . "</a> ]</center>";
            } else {
                echo "<center>[ <a href=\"admin.php?op=modifyUser&chng_uid={$userinfo['user_id']}\">" . _EDITUSER . "</a> ]</center>";
            }
            CloseTable2();
        }
        if ((is_user($user) and $cookie[1] != $username or is_admin($admin)) and is_active("Private_Messages")) {
            echo "<br>[ <a href=\"modules.php?name=Private_Messages&amp;mode=post&amp;u={$userinfo['user_id']}\">" . _USENDPRIVATEMSG . " {$username_pm}</a> ]<br>\n";
        }
        echo "</center></font>";
    } else {
        echo "<center>" . _NOINFOFOR . " {$username}</center>";
    }
    CloseTable();
    if ($my_headlines == 1 and $username == $cookie[1] and $userinfo[user_password] == $cookie[2]) {
        echo "<br>";
        OpenTable();
        echo "<center><b>" . _MYHEADLINES . "</b><br><br>" . "" . _SELECTASITE . "<br><br>" . "<form action=\"modules.php?name={$module_name}\" method=\"post\">" . "<input type=\"hidden\" name=\"op\" value=\"userinfo\">" . "<input type=\"hidden\" name=\"username\" value=\"{$username}\">" . "<input type=\"hidden\" name=\"bypass\" value=\"{$bypass}\">" . "<input type=\"hidden\" name=\"url\" value=\"0\">" . "<select name=\"hid\" onChange='submit()'>\n" . "<option value=\"0\">" . _SELECTASITE2 . "</option>";
        $sql4 = "SELECT hid, sitename FROM " . $prefix . "_headlines ORDER BY sitename";
        $headl = $db->sql_query($sql4);
        while ($row4 = $db->sql_fetchrow($headl)) {
            $nhid = intval($row4[hid]);
            $hsitename = $row4[sitename];
            if ($hid == $nhid) {
                $sel = "selected";
            } else {
                $sel = "";
            }
            echo "<option value=\"{$nhid}\" {$sel}>{$hsitename}</option>\n";
        }
        echo "</select></form>" . "" . _ORTYPEURL . "<br><br>" . "<form action=\"modules.php?name={$module_name}\" method=\"post\">" . "<input type=\"hidden\" name=\"op\" value=\"userinfo\">" . "<input type=\"hidden\" name=\"username\" value=\"{$username}\">" . "<input type=\"hidden\" name=\"bypass\" value=\"{$bypass}\">" . "<input type=\"hidden\" name=\"hid\" value=\"0\">" . "<input type=\"text\" name=\"url\" size=\"40\" maxlength=\"200\" value=\"http://\">&nbsp;&nbsp;" . "<input type=\"submit\" value=\"" . _GO . "\"></form>" . "</center><br>";
        if ($hid != 0 or $hid == 0 and $url != "0" and $url != "http://" and $url != "") {
            if ($hid != 0) {
                $sql5 = "SELECT sitename, headlinesurl FROM " . $prefix . "_headlines WHERE hid='{$hid}'";
                $result5 = $db->sql_query($sql5);
                $row5 = $db->sql_fetchrow($result5);
                $nsitename = $row5[sitename];
                $url = $row5[headlinesurl];
                $title = stripslashes(check_html($nsitename, "nohtml"));
                $siteurl = eregi_replace("http://", "", $url);
                $siteurl = explode("/", $siteurl);
            } else {
                if (!ereg("http://", $url)) {
                    $url = "http://{$url}";
                }
                $siteurl = eregi_replace("http://", "", $url);
                $siteurl = explode("/", $siteurl);
                $title = "http://{$siteurl['0']}";
            }
            $rdf = parse_url($url);
            $fp = fsockopen($rdf['host'], 80, $errno, $errstr, 15);
            if (!$fp) {
                $content = "<center><font class=\"content\">" . _RSSPROBLEM . "</font></center>";
            }
            if ($fp) {
                fputs($fp, "GET " . $rdf['path'] . "?" . $rdf['query'] . " HTTP/1.0\r\n");
                fputs($fp, "HOST: " . $rdf['host'] . "\r\n\r\n");
                $string = "";
                while (!feof($fp)) {
                    $pagetext = fgets($fp, 300);
                    $string .= chop($pagetext);
                }
                fputs($fp, "Connection: close\r\n\r\n");
                fclose($fp);
                $items = explode("</item>", $string);
                $content = "<font class=\"content\">";
                for ($i = 0; $i < 10; $i++) {
                    $link = ereg_replace(".*<link>", "", $items[$i]);
                    $link = ereg_replace("</link>.*", "", $link);
                    $title2 = ereg_replace(".*<title>", "", $items[$i]);
                    $title2 = ereg_replace("</title>.*", "", $title2);
                    if ($items[$i] == "" and $cont != 1) {
                        $content = "<center>" . _RSSPROBLEM . "</center>";
                    } else {
                        if (strcmp($link, $title2) and $items[$i] != "") {
                            $cont = 1;
                            $content .= "<img src=\"images/arrow.gif\" border=\"0\" hspace=\"5\"><a href=\"{$link}\" target=\"new\">{$title2}</a><br>\n";
                        }
                    }
                }
            }
            if ($content != "") {
                OpenTable2();
                echo "<center><b>" . _HEADLINESFROM . " <a href=\"http://{$siteurl['0']}\" target=\"new\">{$title}</a></b></center><br>";
                echo "{$content}";
                CloseTable2();
            } elseif ($cont == 0 or $content == "") {
                OpenTable2();
                echo "<center>" . _RSSPROBLEM . "</center><br>";
                CloseTable2();
            }
            echo "<br>";
        }
        CloseTable();
    }
    if ($broadcast_msg == 1 and $username == $cookie[1] and $userinfo[user_password] == $cookie[2]) {
        echo "<br>";
        OpenTable();
        echo "<center><b>" . _BROADCAST . "</b><br><br>" . _BROADCASTTEXT . "<br><br>" . "<form action=\"modules.php?name={$module_name}\" method=\"post\">" . "<input type=\"hidden\" name=\"who\" value=\"{$username}\">" . "<input type=\"hidden\" name=\"op\" value=\"broadcast\">" . "<input type=\"text\" size=\"60\" maxlength=\"255\" name=\"the_message\">&nbsp;&nbsp;<input type=\"submit\" value=\"" . _SEND . "\">" . "</form></center>";
        CloseTable();
    }
    if (is_active("Private_Messages") and $username == $cookie[1] and $userinfo[user_password] == $cookie[2]) {
        echo "<br>";
        OpenTable();
        echo "<center><b>" . _PRIVATEMESSAGES . "</b><br><br>";
        $numrow = $db->sql_numrows($db->sql_query("SELECT * FROM " . $prefix . "_bbprivmsgs WHERE privmsgs_to_userid='{$userinfo['user_id']}' AND (privmsgs_type='1' OR privmsgs_type='5' OR privmsgs_type='0')"));
        if (is_active("Members_List")) {
            $mem_list = "<a href=\"modules.php?name=Members_List\">" . _BROWSEUSERS . "</a>";
        } else {
            $mem_list = "";
        }
        if (is_active("Search")) {
            $mod_search = "<a href=\"modules.php?name=Search&amp;type=users\">" . _SEARCHUSERS . "</a>";
        } else {
            $mod_search = "";
        }
        if ($mem_list != "" and $mod_search != "") {
            $a = " | ";
        } else {
            $a = "";
        }
        if ($mem_list != "" or $mod_search != "") {
            $links = "[ {$mem_list} {$a} {$mod_search} ]";
        } elseif ($mem_list == "" and $mod_search == "") {
            $links = "";
        }
        echo "" . _YOUHAVE . " <a href=\"modules.php?name=Private_Messages\"><b>{$numrow}</b></a> " . _PRIVATEMSG . "<br><br>" . "<form action=\"modules.php?name=Private_Messages\" method=\"post\">" . "" . _USENDPRIVATEMSG . ": <input type=\"text\" name=\"pm_uname\" size=\"20\">&nbsp;&nbsp;{$links}" . "<input type=\"hidden\" name=\"send\" value=\"1\">" . "</form></center>";
        CloseTable();
    }
    if ($articlecomm == 1) {
        echo "<br>";
        OpenTable();
        echo "<b>" . _LAST10COMMENTS . " {$userinfo['username']}:</b><br>";
        $sql6 = "SELECT tid, sid, subject FROM " . $prefix . "_comments WHERE name='{$userinfo['username']}' ORDER BY tid DESC LIMIT 0,10";
        $result6 = $db->sql_query($sql6);
        while ($row6 = $db->sql_fetchrow($result6)) {
            $tid = intval($row6[tid]);
            $sid = intval($row6[sid]);
            $subject = stripslashes(check_html($row6[subject], "nohtml"));
            echo "<li><a href=\"modules.php?name=News&file=article&thold=-1&mode=flat&order=0&sid={$sid}#{$tid}\">{$subject}</a><br>";
        }
        CloseTable();
    }
    echo "<br>";
    OpenTable();
    echo "<b>" . _LAST10SUBMISSIONS . " {$userinfo['username']}:</b><br>";
    $sql7 = "SELECT sid, title FROM " . $prefix . "_stories WHERE informant='{$userinfo['username']}' ORDER BY sid DESC LIMIT 0,10";
    $result7 = $db->sql_query($sql7);
    while ($row7 = $db->sql_fetchrow($result7)) {
        $sid = intval($row7[sid]);
        $title = stripslashes(check_html($row7['title'], "nohtml"));
        echo "<li><a href=\"modules.php?name=News&file=article&sid={$sid}\">{$title}</a><br>";
    }
    CloseTable();
    include "footer.php";
}
Example #12
0
 function block_show($bid)
 {
     global $prefix, $db;
     include "header.php";
     GraphicAdmin();
     title("" . _BLOCKSADMIN . "");
     OpenTable2();
     $bid = intval($bid);
     $row = $db->sql_fetchrow($db->sql_query("select bid, bkey, title, content, url, bposition, blockfile from " . $prefix . "_blocks where bid='{$bid}'"));
     $bid = intval($row['bid']);
     $bkey = $row['bkey'];
     $title = $row['title'];
     $content = $row['content'];
     $url = $row['url'];
     $bposition = $row['bposition'];
     $blockfile = $row['blockfile'];
     if ($bkey == main) {
         mainblock();
     } elseif ($bkey == admin) {
         adminblock();
     } elseif ($bkey == modules) {
         modules_block();
     } elseif ($bkey == category) {
         category();
     } elseif ($bkey == userbox) {
         userblock();
     } elseif ($bkey == "") {
         if ($url == "") {
             if ($blockfile == "") {
                 if ($bposition == "c") {
                     themecenterbox($title, $content);
                 } else {
                     themesidebox($title, $content);
                 }
             } else {
                 if ($bposition == "c") {
                     blockfileinc($title, $blockfile, 1);
                 } else {
                     blockfileinc($title, $blockfile);
                 }
             }
         } else {
             headlines($bid);
         }
     }
     CloseTable2();
     echo "<br>";
     OpenTable();
     echo "<center><font class=\"option\"><b>" . _BLOCKSADMIN . ": " . _FUNCTIONS . "</b></font><br><br>" . "[ <a href=\"admin.php?op=ChangeStatus&bid={$bid}\">" . _ACTIVATE . "</a> | <a href=\"admin.php?op=BlocksEdit&bid={$bid}\">" . _EDIT . "</a> | ";
     if ($bkey == "") {
         echo "<a href=\"admin.php?op=BlocksDelete&bid={$bid}\">" . _DELETE . "</a> | ";
     } else {
         echo "" . _DELETE . " | ";
     }
     echo "<a href=\"admin.php?op=BlocksAdmin\">" . _BLOCKSADMIN . "</a> ]</center>";
     CloseTable();
     include "footer.php";
 }
Example #13
0
function viewdownload()
{
    global $downloadsprefix, $db, $perpage, $module_name, $bgcolor1, $bgcolor3, $show_links_num;
    $cid = intval($_GET['cid']);
    $min = isset($_GET['min']) ? intval($_GET['min']) : 0;
    $orderby = convertorderbyin($_GET['orderby']);
    $max = $min + $perpage;
    include "header.php";
    $result = $db->sql_query("SELECT title,cdescription,ldescription,parentid FROM " . $downloadsprefix . "_categories WHERE cid={$cid}");
    list($title, $cdescription, $ldescription, $parentid) = $db->sql_fetchrow($result);
    $title = getparentlink($parentid, $title);
    $title = "<a href=" . getlink() . ">" . _MAIN . "</a>/{$title}";
    downl_menu_tpl(1);
    echo '<br />';
    if ($ldescription != '') {
        OpenTable2();
        echo "{$ldescription}";
        CloseTable2();
        echo '<br />';
    }
    OpenTable();
    if ($cdescription != '') {
        $cdescription = "<br />" . $cdescription;
    }
    echo "<center><font class=\"title\"><b>" . _CATEGORY . ": {$title}</b></font>{$cdescription}</center>";
    echo "<table border=\"0\" cellspacing=\"10\" cellpadding=\"0\" align=\"center\"><tr>";
    $result2 = $db->sql_query("SELECT cid, title, cdescription FROM " . $downloadsprefix . "_categories WHERE parentid={$cid} order by title");
    $count = 0;
    while (list($cid2, $title2, $cdescription2) = $db->sql_fetchrow($result2)) {
        if ($show_links_num == 1) {
            $cresult = $db->sql_query("SELECT * FROM " . $downloadsprefix . "_downloads WHERE cid={$cid2}");
            $cnumrows = $db->sql_numrows($cresult);
            $cnumm = " ({$cnumrows})";
        } else {
            $cnum = "";
        }
        if ($cnumrows > 0) {
            $folder = "modules/Downloads/images/openfolder.gif";
        } else {
            $folder = "modules/Downloads/images/closedfolder.gif";
        }
        if (can_admin('downloads')) {
            $folderImg = "<A HREF=\"" . adminlink("{$module_name}&mode=DownloadsModCat&amp;cat={$cid2}") . "\"><IMG SRC=\"{$folder}\" BORDER=0 ALT=\"" . _EDIT . "\"></A>";
        } else {
            $folderImg = "<IMG SRC=\"{$folder}\" BORDER=0 ALT=\"{$title2}\">";
        }
        echo "<td valign=\"top\"><font class=\"title\">{$folderImg} <a href=\"" . getlink("&amp;d_op=viewdownload&amp;cid={$cid2}") . "\"><b>{$title2}</b></a></font>{$cnumm}";
        categorynewdownloadgraphic($cid2);
        if ($cdescription2) {
            echo "<br /><font class=\"content\">{$cdescription2}</font><br />";
        } else {
            echo '<br />';
        }
        $result3 = $db->sql_query("SELECT cid, title FROM " . $downloadsprefix . "_categories WHERE parentid={$cid2} order by title limit 0,3");
        $space = 0;
        while (list($cid3, $title3) = $db->sql_fetchrow($result3)) {
            if ($space > 0) {
                echo ",&nbsp;";
            }
            if ($show_links_num == 1) {
                $cresult2 = $db->sql_query("SELECT * FROM " . $downloadsprefix . "_downloads WHERE cid={$cid3}");
                $cnumrows2 = $db->sql_numrows($cresult2);
                $cnum = " ({$cnumrows2})";
            } else {
                $cnum = "";
            }
            echo "<font class=\"content\"><a href=\"" . getlink("&amp;d_op=viewdownload&amp;cid={$cid3}") . "\">{$title3}</a></font>{$cnum}";
            $space++;
        }
        if ($count < 1) {
            echo "</td><td>&nbsp;&nbsp;&nbsp;&nbsp;</td>";
            $dum = 1;
        }
        $count++;
        if ($count == 2) {
            echo "</td></tr><tr>";
            $count = 0;
            $dum = 0;
        }
    }
    if ($dum == 1) {
        echo "</tr></table>";
    } elseif ($dum == 0) {
        echo "<td></td></tr></table>";
    }
    echo "<hr noshade size=\"1\">";
    $orderbyTrans = convertorderbytrans($orderby);
    echo "<center><font class=\"content\">" . _SORTDOWNLOADSBY . ": " . _TITLE . " (<a href=\"" . getlink("&amp;d_op=viewdownload&amp;cid={$cid}&amp;orderby=titleA") . "\">A</a>\\<a href=\"" . getlink("&amp;d_op=viewdownload&amp;cid={$cid}&amp;orderby=titleD") . "\">D</a>) " . _DATE . " (<a href=\"" . getlink("&amp;d_op=viewdownload&amp;cid={$cid}&amp;orderby=dateA") . "\">A</a>\\<a href=\"" . getlink("&amp;d_op=viewdownload&amp;cid={$cid}&amp;orderby=dateD") . "\">D</a>) " . _RATING . " (<a href=\"" . getlink("&amp;d_op=viewdownload&amp;cid={$cid}&amp;orderby=ratingA") . "\">A</a>\\<a href=\"" . getlink("&amp;d_op=viewdownload&amp;cid={$cid}&amp;orderby=ratingD") . "\">D</a>) " . _POPULARITY . " (<a href=\"" . getlink("&amp;d_op=viewdownload&amp;cid={$cid}&amp;orderby=hitsA") . "\">A</a>\\<a href=\"" . getlink("&amp;d_op=viewdownload&amp;cid={$cid}&amp;orderby=hitsD") . "\">D</a>)" . "<br /><b>" . _RESSORTED . ": {$orderbyTrans}</b></font></center>";
    echo "<hr noshade size=\"1\">";
    $result = $db->sql_query("SELECT lid, title, url, description, date, hits, downloadratingsummary, totalvotes, totalcomments, filesize, version, homepage FROM " . $downloadsprefix . "_downloads WHERE cid={$cid} order by {$orderby} limit {$min},{$perpage} ");
    $fullcountresult = $db->sql_query("SELECT lid FROM " . $downloadsprefix . "_downloads WHERE cid={$cid}");
    $totalselecteddownloads = $db->sql_numrows($fullcountresult);
    echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"10\" border=\"0\"><tr><td><font class=\"content\">";
    $x = 0;
    $color = $bgcolor3;
    while (list($lid, $title, $url, $description, $time, $hits, $downloadratingsummary, $totalvotes, $totalcomments, $filesize, $version, $homepage) = $db->sql_fetchrow($result)) {
        $downloadratingsummary = number_format($downloadratingsummary, $mainvotedecimal);
        $color = $color == $bgcolor3 ? $bgcolor1 : $bgcolor3;
        echo "<TABLE BORDER=0 CELLPADDING=2 CELLSPACING=0 WIDTH=100%><TR BGCOLOR=\"{$color}\"><TD>";
        if (can_admin('downloads')) {
            if (eregi("http", $url)) {
                echo "<a href=\"" . adminlink("{$module_name}&mode=DownloadsModDownload&amp;lid={$lid}") . "\"><img src=\"modules/{$module_name}/images/icon30.gif\" border=\"0\" alt=\"" . _EDIT . "\"></a>";
            } else {
                echo "<a href=\"" . adminlink("{$module_name}&mode=DownloadsModDownload&amp;lid={$lid}") . "\"><img src=\"modules/{$module_name}/images/download.gif\" border=\"0\" alt=\"" . _EDIT . "\"></a>";
            }
        } else {
            if (eregi("http", $url)) {
                echo "<img src=\"modules/{$module_name}/images/icon30.gif\" border=\"0\" alt=\"\">";
            } else {
                echo "<img src=\"modules/{$module_name}/images/download.gif\" border=\"0\" alt=\"\">";
            }
        }
        echo "</td><td width=\"100%\" class=\"title\" valign=\"top\"><a href=\"" . getlink("&amp;d_op=getit&amp;lid={$lid}") . "\"><B>{$title}</b></a>";
        $datetime = formatDateTime($time . ' 00:00:00', _DATESTRING3);
        newdownloadgraphic($datetime);
        popgraphic($hits);
        detecteditorial($lid, 1);
        echo "</td></tr><TR BGCOLOR=\"{$color}\"><TD COLSPAN=2>";
        echo "<DIV ALIGN=\"JUSTIFY\"><b>" . _DESCRIPTION . ":</b> {$description}</td></tr><TR BGCOLOR=\"{$color}\"><TD COLSPAN=2>";
        echo "<b>" . _VERSION . ":</b> {$version} <b>" . _FILESIZE . ":</b> " . CoolSize($filesize) . "<br />";
        echo "<b>" . _ADDEDON . ":</b> {$datetime} <b>" . _UDOWNLOADS . ":</b> {$hits}";
        $transfertitle = str_replace(" ", "_", $title);
        /* voting & comments stats */
        if ($totalvotes == 1) {
            $votestring = _VOTE;
        } else {
            $votestring = _VOTES;
        }
        if ($downloadratingsummary != "0" || $downloadratingsummary != "0.0") {
            echo " <b>" . _RATING . ":</b> {$downloadratingsummary} ({$totalvotes} {$votestring})";
        }
        if ($homepage == "") {
            echo '<br />';
        } else {
            echo "<br /><a href=\"{$homepage}\" target=\"new\">" . _HOMEPAGE . "</a> | ";
        }
        echo "<a href=\"" . getlink("&amp;d_op=ratedownload&amp;lid={$lid}") . "\">" . _RATERESOURCE . "</a>";
        if (is_user()) {
            echo " | <a href=\"" . getlink("&amp;d_op=brokendownload&amp;lid={$lid}") . "\">" . _REPORTBROKEN . "</a>";
        }
        echo " | <a href=\"" . getlink("&amp;d_op=viewdownloaddetails&amp;lid={$lid}") . "\">" . _DETAILS . "</a>";
        if ($totalcomments != 0) {
            echo " | <a href=\"" . getlink("&amp;d_op=viewdownloadcomments&amp;lid={$lid}") . "\">" . _SCOMMENTS . " ({$totalcomments})</a>";
        }
        detecteditorial($lid, 0);
        echo "</div></td></tr></table><br />";
        $x++;
    }
    echo "</font>";
    $orderby = convertorderbyout($orderby);
    /* Calculates how many pages exist. Which page one should be on, etc... */
    $downloadpagesint = $totalselecteddownloads / $perpage;
    $downloadpageremainder = $totalselecteddownloads % $perpage;
    if ($downloadpageremainder != 0) {
        $downloadpages = ceil($downloadpagesint);
        if ($totalselecteddownloads < $perpage) {
            $downloadpageremainder = 0;
        }
    } else {
        $downloadpages = $downloadpagesint;
    }
    /* Page Numbering */
    if ($downloadpages != 1 && $downloadpages != 0) {
        echo "<br /><br />";
        echo _SELECTPAGE . ": ";
        $prev = $min - $perpage;
        if ($prev >= 0) {
            echo "&nbsp;&nbsp;<b>[ <a href=\"" . getlink("&amp;d_op=viewdownload&amp;cid={$cid}&amp;min={$prev}&amp;orderby={$orderby}") . "\">";
            echo " &lt;&lt; " . _PREVIOUSPAGE . "</a> ]</b> ";
        }
        $counter = 1;
        $currentpage = $max / $perpage;
        while ($counter <= $downloadpages) {
            $cpage = $counter;
            $mintemp = $perpage * $counter - $perpage;
            if ($counter == $currentpage) {
                echo "<b>{$counter}</b>&nbsp";
            } else {
                echo "<a href=\"" . getlink("&amp;d_op=viewdownload&amp;cid={$cid}&amp;min={$mintemp}&amp;orderby={$orderby}") . "\">{$counter}</a> ";
            }
            $counter++;
        }
        $next = $min + $perpage;
        if ($x >= $perpage) {
            echo "&nbsp;&nbsp;<b>[ <a href=\"" . getlink("&amp;d_op=viewdownload&amp;cid={$cid}&amp;min={$max}&amp;orderby={$orderby}") . "\">" . _NEXTPAGE . " >></a> ]</b> ";
        }
    }
    echo "</td></tr></table>";
    CloseTable();
    include "footer.php";
}
Example #14
0
function viewlinkeditorial($lid, $ttitle)
{
    global $linksprefix, $db, $module_name;
    require_once 'header.php';
    menu(1);
    $result = $db->sql_query("SELECT adminid, editorialtimestamp, editorialtext, editorialtitle FROM " . $linksprefix . "_editorials WHERE linkid = {$lid}");
    $recordexist = $db->sql_numrows($result);
    $transfertitle = ereg_replace('_', ' ', $ttitle);
    $displaytitle = $transfertitle;
    echo '<br />';
    OpenTable();
    echo '<div style="text-align:center;"><span class="option"><b>' . _LINKPROFILE . ': ' . $displaytitle . '</b></span><br />';
    linkinfomenu($lid, $ttitle);
    if ($recordexist != 0) {
        while (list($adminid, $editorialtimestamp, $editorialtext, $editorialtitle) = $db->sql_fetchrow($result)) {
            ereg('([0-9]{4})-([0-9]{1,2})-([0-9]{1,2}) ([0-9]{1,2}):([0-9]{1,2}):([0-9]{1,2})', $editorialtimestamp, $editorialtime);
            $editorialtime = strftime('%F', mktime($editorialtime[4], $editorialtime[5], $editorialtime[6], $editorialtime[2], $editorialtime[3], $editorialtime[1]));
            $date_array = explode('-', $editorialtime);
            $timestamp = mktime(0, 0, 0, $date_array['1'], $date_array['2'], $date_array['0']);
            $formatted_date = date('F j, Y', $timestamp);
            echo '<br /><br />';
            OpenTable2();
            echo '<span class="option"><b>' . $editorialtitle . '</b></span><br />' . '<span class="tiny">' . _EDITORIALBY . ' ' . $adminid . ' - ' . $formatted_date . '</span><br /><br />' . $editorialtext;
            CloseTable2();
        }
    } else {
        echo '<br /><br /><span class="option"><b>' . _NOEDITORIAL . '</b></span>';
    }
    echo '<br /><br />';
    linkfooter($lid, $ttitle);
    echo '</div>';
    CloseTable();
}
Example #15
0
function index()
{
    global $prefix, $db, $module_name, $show_links_num, $show_links_info, $show_links_inum, $admin;
    include "header.php";
    $maindownload = 0;
    menu($maindownload);
    echo "<br>";
    OpenTable();
    echo "<center><font class=\"title\"><b>" . _DOWNLOADSMAINCAT . "</b></font></center><br>";
    echo "<table border=\"0\" cellspacing=\"10\" cellpadding=\"0\" align=\"center\"><tr>";
    $sql = "SELECT cid, title, cdescription FROM " . $prefix . "_downloads_categories WHERE parentid='0' ORDER BY title";
    $result = $db->sql_query($sql);
    $count = 0;
    while ($row = $db->sql_fetchrow($result)) {
        $cid = $row[cid];
        $title = $row[title];
        $cdescription = $row[cdescription];
        if ($show_links_num == 1) {
            $cnumrows = $db->sql_numrows($db->sql_query("SELECT * FROM " . $prefix . "_downloads_downloads WHERE cid='{$cid}'"));
            $cnumm = " ({$cnumrows})";
        } else {
            $cnumm = "";
        }
        if ($cnumrows > 0) {
            $folder = "modules/Downloads/images/openfolder.gif";
        } else {
            $folder = "modules/Downloads/images/closedfolder.gif";
        }
        if (is_admin($admin)) {
            $folderImg = "<A HREF=\"admin.php?op=DownloadsModCat&amp;cat={$cid}\"><IMG SRC=\"{$folder}\" BORDER=0 ALT=\"" . _EDIT . "\"></A>";
        } else {
            $folderImg = "<IMG SRC=\"{$folder}\" BORDER=0 ALT=\"{$title}\">";
        }
        echo "<td><font class=\"title\">{$folderImg} <a href=\"modules.php?name={$module_name}&d_op=viewdownload&amp;cid={$cid}\"><b>{$title}</b></a></font>{$cnumm}";
        categorynewdownloadgraphic($cid);
        if ($cdescription) {
            echo "<br><font class=\"content\">{$cdescription}</font><br>";
        } else {
            echo "<br>";
        }
        $sql2 = "SELECT cid, title FROM " . $prefix . "_downloads_categories WHERE parentid='{$cid}' ORDER BY title LIMIT 0,3";
        $result2 = $db->sql_query($sql2);
        $space = 0;
        while ($row2 = $db->sql_fetchrow($result2)) {
            $cid = $row2[cid];
            $stitle = $row2[title];
            if ($space > 0) {
                echo ",&nbsp;";
            }
            if ($show_links_num == 1) {
                $cnumrows2 = $db->sql_numrows($db->sql_query("SELECT * FROM " . $prefix . "_downloads_downloads WHERE cid='{$cid}'"));
                $cnum = " ({$cnumrows2})";
            } else {
                $cnumrows2 = "";
            }
            echo "<font class=\"content\"><a href=\"modules.php?name={$module_name}&d_op=viewdownload&amp;cid={$cid}\">{$stitle}</a>{$cnum}</font>";
            $space++;
        }
        if ($count < 1) {
            echo "</td><td>&nbsp;&nbsp;&nbsp;&nbsp;</td>";
            $dum = 1;
        }
        $count++;
        if ($count == 2) {
            echo "</td></tr><tr>";
            $count = 0;
            $dum = 0;
        }
    }
    if ($dum == 1) {
        echo "</tr></table>";
    } elseif ($dum == 0) {
        echo "<td></td></tr></table>";
    }
    $numrows = $db->sql_numrows($db->sql_query("SELECT * FROM " . $prefix . "_downloads_downloads"));
    $catnum = $db->sql_numrows($db->sql_query("SELECT * FROM " . $prefix . "_downloads_categories"));
    echo "<center><font class=\"content\">" . _THEREARE . " <b>{$numrows}</b> " . _DOWNLOADS . " " . _AND . " <b>{$catnum}</b> " . _CATEGORIES . " " . _INDB . "</font></center>";
    CloseTable();
    if ($show_links_info == 1) {
        echo "<BR>";
        OpenTable();
        echo "<TABLE BORDER=0 CELLPADDING=0 CELLSPACING=3 WIDTH=100%>" . "<TR><TD WIDTH=50% VALIGN=TOP ALIGN=CENTER>";
        //		OpenTable2();
        echo "<DIV ALIGN=CENTER CLASS=\"title\">" . _NEWDOWNLOADS . "</DIV>";
        //		CloseTable2();
        echo "</TD><TD WIDTH=50% VALIGN=TOP ALIGN=CENTER>";
        //		OpenTable2();
        echo "<DIV ALIGN=CENTER CLASS=\"title\">" . _MOSTPOPULAR . " {$show_links_inum}</DIV>";
        //		CloseTable2();
        echo "</TD></TR>" . "<TR><TD WIDTH=50% VALIGN=TOP ALIGN=CENTER>";
        OpenTable2();
        $content = "";
        $content .= "<TABLE BORDER=0 WIDTH=\"100%\">";
        $color = $bgcolor3;
        $sql = "SELECT lid, title, hits FROM " . $prefix . "_downloads_downloads ORDER BY date DESC LIMIT 0, {$show_links_inum}";
        $result = $db->sql_query($sql);
        while ($row = $db->sql_fetchrow($result)) {
            $title2 = ereg_replace("_", " ", $row[title]);
            $color = switchColor($color);
            $content .= "<TR><TD BGCOLOR=\"{$color}\" ALIGN=LEFT><a href=\"modules.php?name=Downloads&amp;d_op=viewdownloaddetails&amp;lid={$row['lid']}&amp;title={$row['title']}\">{$title2}</a></TD>";
            $content .= "<TD BGCOLOR=\"{$color}\" ALIGN=CENTER WIDTH=\"20\">{$row['hits']}</TD></TR>";
        }
        echo "{$content}</TABLE>";
        CloseTable2();
        echo "|[ <A HREF=\"modules.php?name=Downloads&d_op=NewDownloads\">" . _NEWDOWNLOADS . "</A> ]|";
        echo "</TD><TD WIDTH=50% VALIGN=TOP ALIGN=CENTER>";
        OpenTable2();
        $content = "";
        $content .= "<TABLE BORDER=0 WIDTH=\"100%\">";
        $color = $bgcolor3;
        $sql = "SELECT lid, title, hits FROM " . $prefix . "_downloads_downloads ORDER BY hits DESC LIMIT 0, {$show_links_inum}";
        $result = $db->sql_query($sql);
        while ($row = $db->sql_fetchrow($result)) {
            $title2 = ereg_replace("_", " ", $row[title]);
            $color = switchColor($color);
            $content .= "<TR><TD BGCOLOR=\"{$color}\" ALIGN=LEFT><a href=\"modules.php?name=Downloads&amp;d_op=viewdownloaddetails&amp;lid={$row['lid']}&amp;title={$row['title']}\">{$title2}</a></TD>";
            $content .= "<TD BGCOLOR=\"{$color}\" ALIGN=CENTER WIDTH=\"20\">{$row['hits']}</TD></TR>";
        }
        echo "{$content}</TABLE>";
        CloseTable2();
        echo "|[ <A HREF=\"modules.php?name=Downloads&d_op=MostPopular\">" . _MOSTPOPULAR . " " . _DOWNLOADS . "</A> ]|";
        echo "</TD></TR>" . "</TABLE>";
        CloseTable();
    }
    include "footer.php";
}