$title = _WAITINGCONT;
$num = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_queue"));
$content = "";
$content .= "· "._SUBMISSIONS.": $num
";
$num = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_reviews_add"));
$content .= "· "._WREVIEWS.": $num
";
$num = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_links_newlink"));
$brokenl = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_links_modrequest WHERE brokenlink='1'"));
$modreql = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_links_modrequest WHERE brokenlink='0'"));
$content .= "· "._WLINKS.": $num
";
$content .= "· "._MODREQLINKS.": $modreql
";
$content .= "· "._BROKENLINKS.": $brokenl
";
$num = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_downloads_newdownload"));
$brokend = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_downloads_modrequest WHERE brokendownload='1'"));
$modreqd = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_downloads_modrequest WHERE brokendownload='0'"));
$content .= "· "._UDOWNLOADS.": $num
";
$content .= "· "._MODREQDOWN.": $modreqd
";
$content .= "· "._BROKENDOWN.": $brokend
";
themesidebox($title, $content);
$result = $db->sql_query('SELECT COUNT(*) FROM ' . $prefix . '_gcal_event WHERE approved = 0'; $row = $db->sql_fetchrow($result); $content .= "ยท Calendar Events: {$row[0]}
";