

/** BW_Downloads *********************************************/
$result9 = $db->sql_query("SELECT COUNT(*) AS numrows FROM ".$prefix."_downloads_newdownload_bw");
$row9 = $db->sql_fetchrow($result9);
$db->sql_freeresult($result9);
$num = $row9['numrows'];
$result10 = $db->sql_query("SELECT COUNT(*) AS numrows FROM ".$prefix."_downloads_modrequest_bw WHERE brokendownload='1'");
$row10 = $db->sql_fetchrow($result10);
$db->sql_freeresult($result10);
$brokend = $row10['numrows'];
$result11 = $db->sql_query("SELECT COUNT(*) AS numrows FROM ".$prefix."_downloads_modrequest_bw WHERE brokendownload='0'");
$row11 = $db->sql_fetchrow($result11);
$db->sql_freeresult($result11);
$modreqd = $row11['numrows'];;
$content .= "<strong><big>·</big></strong> <a href=\"".UN_FILENAME_ADMIN."?op=DownloadNew\">BW:"._UDOWNLOADS."</a>: ".$num."<br>";
$content .= "<strong><big>·</big></strong> <a href=\"".UN_FILENAME_ADMIN."?op=DownloadModifyRequests\">BW:"._MODREQDOWN."</a>: ".$modreqd."<br>";
$content .= "<strong><big>·</big></strong> <a href=\"".UN_FILENAME_ADMIN."?op=DownloadBroken\">BW:"._BROKENDOWN."</a>: ".$brokend."<br></font>";


themesidebox($title, $content);
}
} 



//
// Display admins tools in block
//


function adminblock() {
global $admin, $db, $prefix;

if (is_admin($admin)) {
$result = $db->sql_query("SELECT title, content FROM ".UN_TABLENAME_BLOCKS." WHERE bkey='admin'");
while ($row = $db->sql_fetchrow($result)) {
$content = "<font class=\"content\">".$row['content']."</font>";
themesidebox($row['title'], str_replace("admin.php",UN_FILENAME_ADMIN, stripslashes($row['content'])));
}
$db->sql_freeresult($result);
$title = _WAITINGCONT;
$result1 = $db->sql_query("SELECT COUNT(*) AS numrows FROM ".UN_TABLENAME_QUEUE);
$row1 = $db->sql_fetchrow($result1);
$db->sql_freeresult($result1);
$num = $row1['numrows'];
$content = "<font class=\"content\">";
$content .= "<strong><big>·</big></strong> <a href=\"".UN_FILENAME_ADMIN."?op=submissions\">"._SUBMISSIONS."</a>: ".$num."<br>";
$result2 = $db->sql_query("SELECT COUNT(*) AS numrows FROM ".UN_TABLENAME_REVIEWS_ADD);
$row2 = $db->sql_fetchrow($result2);
$db->sql_freeresult($result2);
$num = $row2['numrows'];
$content .= "<strong><big>·</big></strong> <a href=\"".UN_FILENAME_ADMIN."?op=reviews\">"._WREVIEWS."</a>: ".$num."<br>";
$result3 = $db->sql_query("SELECT COUNT(*) AS numrows FROM ".UN_TABLENAME_LINKS_NEWLINK);
$row3 = $db->sql_fetchrow($result3);
$db->sql_freeresult($result3);
$num = $row3['numrows'];
$result4 = $db->sql_query("SELECT COUNT(*) AS numrows FROM ".UN_TABLENAME_LINKS_MODREQUEST." WHERE brokenlink='1'");
$row4 = $db->sql_fetchrow($result4);
$db->sql_freeresult($result4);
$brokenl = $row4['numrows'];
$result5 = $db->sql_query("SELECT COUNT(*) AS numrows FROM ".UN_TABLENAME_LINKS_MODREQUEST." WHERE brokenlink='0'");
$row5 = $db->sql_fetchrow($result5);
$db->sql_freeresult($result5);
$modreql = $row5['numrows'];
$content .= "<strong><big>·</big></strong> <a href=\"".UN_FILENAME_ADMIN."?op=Links\">"._WLINKS."</a>: ".$num."<br>";
$content .= "<strong><big>·</big></strong> <a href=\"".UN_FILENAME_ADMIN."?op=LinksListModRequests\">"._MODREQLINKS."</a>: ".$modreql."<br>";
$content .= "<strong><big>·</big></strong> <a href=\"".UN_FILENAME_ADMIN."?op=LinksListBrokenLinks\">"._BROKENLINKS."</a>: ".$brokenl."<br>";
$result6 = $db->sql_query("SELECT COUNT(*) AS numrows FROM ".UN_TABLENAME_DOWNLOADS_NEWDOWNLOAD);
$row6 = $db->sql_fetchrow($result6);
$db->sql_freeresult($result6);
$num = $row6['numrows'];
$result7 = $db->sql_query("SELECT COUNT(*) AS numrows FROM ".UN_TABLENAME_DOWNLOADS_MODREQUEST." WHERE brokendownload='1'");
$row7 = $db->sql_fetchrow($result7);
$db->sql_freeresult($result7);
$brokend = $row7['numrows'];
$result8 = $db->sql_query("SELECT COUNT(*) AS numrows FROM ".UN_TABLENAME_DOWNLOADS_MODREQUEST." WHERE brokendownload='0'");
$row8 = $db->sql_fetchrow($result8);
$db->sql_freeresult($result8);
$modreqd = $row8['numrows'];;
$content .= "<strong><big>·</big></strong> <a href=\"".UN_FILENAME_ADMIN."?op=downloads\">"._UDOWNLOADS."</a>: ".$num."<br>";
$content .= "<strong><big>·</big></strong> <a href=\"".UN_FILENAME_ADMIN."?op=DownloadsListModRequests\">"._MODREQDOWN."</a>: ".$modreqd."<br>";
$content .= "<strong><big>·</big></strong> <a href=\"".UN_FILENAME_ADMIN."?op=DownloadsListBrokenDownloads\">"._BROKENDOWN."</a>: ".$brokend."<br></font>";


/** BW_Downloads *********************************************/
$result9 = $db->sql_query("SELECT COUNT(*) AS numrows FROM ".$prefix."_downloads_newdownload_bw");
$row9 = $db->sql_fetchrow($result9);
$db->sql_freeresult($result9);
$num = $row9['numrows'];
$result10 = $db->sql_query("SELECT COUNT(*) AS numrows FROM ".$prefix."_downloads_modrequest_bw WHERE brokendownload='1'");
$row10 = $db->sql_fetchrow($result10);
$db->sql_freeresult($result10);
$brokend = $row10['numrows'];
$result11 = $db->sql_query("SELECT COUNT(*) AS numrows FROM ".$prefix."_downloads_modrequest_bw WHERE brokendownload='0'");
$row11 = $db->sql_fetchrow($result11);
$db->sql_freeresult($result11);
$modreqd = $row11['numrows'];;
$content .= "<strong><big>·</big></strong> <a href=\"".UN_FILENAME_ADMIN."?op=downloads2\">BW:"._UDOWNLOADS."</a>: ".$num."<br>";
$content .= "<strong><big>·</big></strong> <a href=\"".UN_FILENAME_ADMIN."?op=DownloadsListModRequests2\">BW:"._MODREQDOWN."</a>: ".$modreqd."<br>";
$content .= "<strong><big>·</big></strong> <a href=\"".UN_FILENAME_ADMIN."?op=DownloadsListBrokenDownloads2\">BW:"._BROKENDOWN."</a>: ".$brokend."<br></font>";


themesidebox($title, $content);
}
}



global $admin, $db, $prefix;




//
// Display admins tools in block
//


function adminblock() {
global $admin, $admin_file, $module_name, $prefix, $db, $textcolor1, $bgcolor1, $bgcolor2;
$brokendownloads = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_nsngd_mods WHERE brokendownload='1'"));
$modrequests = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_nsngd_mods WHERE brokendownload='0'"));
$newdownloads = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_nsngd_new"));

if (is_admin($admin)) {
$result = $db->sql_query("SELECT title, content FROM ".UN_TABLENAME_BLOCKS." WHERE bkey='admin'");
while ($row = $db->sql_fetchrow($result)) {
$content = "<font class=\"content\">".$row['content']."</font>";
themesidebox($row['title'], str_replace("admin.php",UN_FILENAME_ADMIN, stripslashes($row['content'])));
}
$db->sql_freeresult($result);
$title = _WAITINGCONT;
$result1 = $db->sql_query("SELECT COUNT(*) AS numrows FROM ".UN_TABLENAME_QUEUE);
$row1 = $db->sql_fetchrow($result1);
$db->sql_freeresult($result1);
$num = $row1['numrows'];
$content = "<font class=\"content\">";
$content .= "<strong><big>·</big></strong> <a href=\"".UN_FILENAME_ADMIN."?op=submissions\">"._SUBMISSIONS."</a>: ".$num."<br>";
$result2 = $db->sql_query("SELECT COUNT(*) AS numrows FROM ".UN_TABLENAME_REVIEWS_ADD);
$row2 = $db->sql_fetchrow($result2);
$db->sql_freeresult($result2);
$num = $row2['numrows'];
$content .= "<strong><big>·</big></strong> <a href=\"".UN_FILENAME_ADMIN."?op=reviews\">"._WREVIEWS."</a>: ".$num."<br>";
$result3 = $db->sql_query("SELECT COUNT(*) AS numrows FROM ".UN_TABLENAME_LINKS_NEWLINK);
$row3 = $db->sql_fetchrow($result3);
$db->sql_freeresult($result3);
$num = $row3['numrows'];
$result4 = $db->sql_query("SELECT COUNT(*) AS numrows FROM ".UN_TABLENAME_LINKS_MODREQUEST." WHERE brokenlink='1'");
$row4 = $db->sql_fetchrow($result4);
$db->sql_freeresult($result4);
$brokenl = $row4['numrows'];
$result5 = $db->sql_query("SELECT COUNT(*) AS numrows FROM ".UN_TABLENAME_LINKS_MODREQUEST." WHERE brokenlink='0'");
$row5 = $db->sql_fetchrow($result5);
$db->sql_freeresult($result5);
$modreql = $row5['numrows'];
$content .= "<strong><big>·</big></strong> <a href=\"".UN_FILENAME_ADMIN."?op=Links\">"._WLINKS."</a>: ".$num."<br>";
$content .= "<strong><big>·</big></strong> <a href=\"".UN_FILENAME_ADMIN."?op=LinksListModRequests\">"._MODREQLINKS."</a>: ".$modreql."<br>";
$content .= "<strong><big>·</big></strong> <a href=\"".UN_FILENAME_ADMIN."?op=LinksListBrokenLinks\">"._BROKENLINKS."</a>: ".$brokenl."<br>";
$result6 = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_nsngd_new"));


$num = $result6;
$result7 = $db->sql_query("SELECT COUNT(*) AS numrows FROM ".UN_TABLENAME_DOWNLOADS_MODREQUEST." WHERE brokendownload='1'");
$row7 = $db->sql_fetchrow($result7);
$db->sql_freeresult($result7);
$brokend = $row7['numrows'];
$result8 = $db->sql_query("SELECT COUNT(*) AS numrows FROM ".UN_TABLENAME_DOWNLOADS_MODREQUEST." WHERE brokendownload='0'");
$row8 = $db->sql_fetchrow($result8);
$db->sql_freeresult($result8);
$modreqd = $row8['numrows'];;
$content .= "<strong><big>·</big></strong> <a href=\"".UN_FILENAME_ADMIN."?op=DownloadNew\">"._UDOWNLOADS."</a>: ".$num."<br>";
$content .= "<strong><big>·</big></strong> <a href=\"".UN_FILENAME_ADMIN."?op=DownloadModifyRequests\">"._MODREQDOWN."</a>: ".$modrequests."<br>";
$content .= "<strong><big>·</big></strong> <a href=\"".UN_FILENAME_ADMIN."?op=DownloadBroken\">"._BROKENDOWN."</a>: ".$brokendownloads."<br></font>";
themesidebox($title, $content);
}
}

Obsah fóra BLASSENweb » BW Downloads
![]() |
|