function pdp_render_downs(&$downs, $rowstart, $per_page, $count, $link)
{
global $locale;
foreach ($downs as $data) {
if ($data['is_new']) {
$new = " <img src='icons/new.gif'" . " alt='" . $locale['pdp_new'] . "' />";
} else {
$new = "";
}
echo "<hr>\n<table border='0' width='100%'>\n<tr>\n\t<td width='1%'><img src='icons/project.gif' alt='' /></td>\n\t<td><b><a href='" . $data['href'] . "'>" . $data['name'] . "</a></b>{$new}<br />" . "<span class='small2'>" . ($data['user_id'] ? $locale['PDP214'] . " <a href='profile.php?id=" . $data['user_id'] . "'>" . $data['user_name'] . "</a> " : "") . showdate("shortdate", $data['mtime']) . "</span>" . "</td>\n\t<td align='right' style='white-space:nowrap;'>" . $locale['pdp_downloads'] . ": " . $data['downloads'] . "<br />" . $locale['PDP021'] . ": " . $data['comments'] . "</td>\n</tr>\n<tr>\n\t<td colspan='3'>" . $data['desc'] . "</td>\n</tr>\n</table>";
}
if ($count > $per_page) {
echo '
<p>
<div style="text-align:center;">' . makePageNav($rowstart, $per_page, $count, 3, $link) . '
</div>';
}
}
static function listbyaccount($AccountID, $pagenum = 1)
{
global $DB, $LANG;
$page_posts = 25;
$spos = ($pagenum - 1) * $page_posts;
$result = $DB->query_adv("SELECT SQL_CALC_FOUND_ROWS * FROM `History` LEFT JOIN `Users` USING (`UserID`) WHERE `AccountID`={$AccountID} ORDER BY `HistoryID` DESC LIMIT {$spos},{$page_posts}");
$FOUND_ROWS = $DB->row($DB->query_adv('SELECT FOUND_ROWS()'));
$count = $FOUND_ROWS['FOUND_ROWS()'];
$show = beginTable($LANG['History'] . ' ' . $count . ' записей');
$show .= makeTH($LANG['Actions'], $LANG['Description'], $LANG['User'], 'Время', 'IP');
while ($row = $DB->row($result)) {
$show .= makeTD($row['action'], '<pre>' . $row['text'] . '</pre>', empty($row['username']) ? '---' : $row['username'], $row['time'], $row['ip']);
}
$show .= '<tr><td colspan="3" class="nob">';
$show .= makePageNav($pagenum, $page_posts, $count, iSELF . '?object=account&action=history&AccountID=' . $AccountID . '&');
$show .= '</td></tr>';
$show .= endTable();
return $show;
}
echo "<p>\n<form action='include/do_did.php?did=" . $download->id . "' method='post'>\n<div align='center'>" . $locale['PDP210'] . ": <b>" . $locale['PDP205'][$data['vote_opt']] . "</b><br />\n\t<input type='submit' name='del_vote' class='button'" . " value='" . $locale['PDP209'] . "' />\n</div>\n</form>\n";
}
} elseif (dbrows($res) == 0) {
echo "<p>" . $locale['PDP208'];
}
closetable();
/****************************************************************************
* COMMENTS
*/
echo '<a name="comments"></a>';
opentable($locale['PDP021']);
$cstart = isset($_GET['rowstart']) && isNum($_GET['rowstart']) ? $_GET['rowstart'] : 0;
$order = isset($_GET['order']) && $_GET['order'] == 'desc' ? 'desc' : 'asc';
$navi = '';
if ($download->data['count_comments'] > $pdp->settings['comments_per_page']) {
$navi = makePageNav($cstart, $pdp->settings['comments_per_page'], $download->data['count_comments'], 3, FUSION_SELF . '?did=' . $download->id . '&order=' . $order . '&');
// FIXME add #comments
}
$res = dbquery("SELECT comment_user_name, comment_smileys,\n\tcomment_text, user_id, comment_id, comment_timestamp\n\tFROM " . DB_PDP_COMMENTS . "\n\tWHERE download_id='" . $download->id . "'\n\tORDER BY comment_timestamp " . $order . "\n\tLIMIT " . $cstart . ", " . $pdp->settings['comments_per_page']);
$count = dbrows($res);
/*FIXME
if($order=='asc') {
echo '<a href="'.FUSION_SELF.'?did='.$download->id.'&order=desc#comments">'
.$locale['pdp_latest_first'].'</a>';
} else {
echo '<strong>'.$locale['pdp_latest_first'].'</strong>
<a href="'.FUSION_SELF.'?did='.$download->id.'#comments">'
.$locale['pdp_off'].'</a>';
}
*/
echo $navi;
renderNav(false, $announcementCheck);
echo "<table cellpadding='0' cellspacing='0' width='100%'>\n";
echo "<tr>";
if ($rows > $posts_per_page || ($can_post || $can_reply)) {
echo "<td align='left' style='padding:0px 0px 4px 5px;white-space:nowrap;' width='1%'>\n";
if (iMEMBER && ($can_post || $can_reply)) {
if (!$fdata['thread_locked'] && $can_reply) {
echo "<a href='post.php?action=reply&forum_id=" . $fdata['forum_id'] . "&thread_id=" . $_GET['thread_id'] . "'><img src='" . get_image("reply") . "' alt='" . $locale['565'] . "' style='border:0px' /></a> \n";
}
if ($can_post) {
echo "<nobr><a href='post.php?action=newthread&forum_id=" . $fdata['forum_id'] . "'><img src='" . get_image("newthread") . "' alt='" . $locale['566'] . "' style='border:0px' /></a> \n";
}
echo "</td><td>";
}
if ($rows > $posts_per_page) {
echo "<nobr>" . makePageNav($_GET['rowstart'], $posts_per_page, $rows, 3, FUSION_SELF . "?thread_id=" . $_GET['thread_id'] . "&") . "";
}
echo "</td>";
}
echo "<td style='text-align:right;'>";
renderTools();
echo "</td>\n</tr></table><br />";
if ($rows != 0) {
if ($_GET['rowstart'] == 0 && $fdata['thread_poll'] == "1") {
if (iMEMBER) {
$presult = dbquery("SELECT tfp.*, tfv.forum_vote_user_id FROM " . DB_FORUM_POLLS . " tfp \n\t\t\t\tLEFT JOIN " . DB_FORUM_POLL_VOTERS . " tfv\n\t\t\t\tON tfp.thread_id=tfv.thread_id AND forum_vote_user_id='" . $userdata['user_id'] . "'\n\t\t\t\tWHERE tfp.thread_id='" . $_GET['thread_id'] . "'");
} else {
$presult = dbquery("SELECT tfp.* FROM " . DB_FORUM_POLLS . " tfp\n\t\t\t\tWHERE tfp.thread_id='" . $_GET['thread_id'] . "'");
}
if (dbrows($presult)) {
$pdata = dbarray($presult);
opentable($locale['global_056']);
$result = dbquery("SELECT tn.thread_id FROM " . DB_THREAD_NOTIFY . " tn\n\tINNER JOIN " . DB_THREADS . " tt ON tn.thread_id = tt.thread_id\n\tINNER JOIN " . DB_FORUMS . " tf ON tt.forum_id = tf.forum_id\n\tWHERE tn.notify_user="******" AND " . groupaccess('forum_access') . " AND tt.thread_hidden='0'");
$rows = dbrows($result);
if ($rows) {
$result = dbquery("\n\t\tSELECT tf.forum_access, tn.thread_id, tn.notify_datestamp, tn.notify_user,\n\t\ttt.thread_subject, tt.forum_id, tt.thread_lastpost, tt.thread_lastuser, tt.thread_postcount,\n\t\ttu.user_id AS user_id1, tu.user_name AS user_name1, tu.user_status AS user_status1, \n\t\ttu2.user_id AS user_id2, tu2.user_name AS user_name2, tu2.user_status AS user_status2\n\t\tFROM " . DB_THREAD_NOTIFY . " tn\n\t\tINNER JOIN " . DB_THREADS . " tt ON tn.thread_id = tt.thread_id\n\t\tINNER JOIN " . DB_FORUMS . " tf ON tt.forum_id = tf.forum_id\n\t\tLEFT JOIN " . DB_USERS . " tu ON tt.thread_author = tu.user_id\n\t\tLEFT JOIN " . DB_USERS . " tu2 ON tt.thread_lastuser = tu2.user_id\n\t\tINNER JOIN " . DB_POSTS . " tp ON tt.thread_id = tp.thread_id\n\t\tWHERE tn.notify_user="******" AND " . groupaccess('forum_access') . " AND tt.thread_hidden='0'\n\t\tGROUP BY tn.thread_id\n\t\tORDER BY tn.notify_datestamp DESC\n\t\tLIMIT " . $_GET['rowstart'] . ",10\n\t");
echo "<table class='tbl-border' cellpadding='0' cellspacing='1' width='100%'>\n<tr>\n";
echo "<td class='tbl2'><strong>" . $locale['global_044'] . "</strong></td>\n";
echo "<td class='tbl2' style='text-align:center;white-space:nowrap'><strong>" . $locale['global_050'] . "</strong></td>\n";
echo "<td class='tbl2' style='text-align:center;white-space:nowrap'><strong>" . $locale['global_047'] . "</strong></td>\n";
echo "<td class='tbl2' style='text-align:center;white-space:nowrap'><strong>" . $locale['global_046'] . "</strong></td>\n";
echo "<td class='tbl2' style='text-align:center;white-space:nowrap'><strong>" . $locale['global_057'] . "</strong></td>\n";
echo "</tr>\n";
$i = 0;
while ($data = dbarray($result)) {
$row_color = $i % 2 == 0 ? "tbl1" : "tbl2";
echo "<tr>\n<td class='" . $row_color . "'><a href='" . FORUM . "viewthread.php?thread_id=" . $data['thread_id'] . "'>" . $data['thread_subject'] . "</a></td>\n";
echo "<td class='" . $row_color . "' style='text-align:center;white-space:nowrap'>" . profile_link($data['user_id1'], $data['user_name1'], $data['user_status1']) . "</td>\n";
echo "<td class='" . $row_color . "' style='text-align:center;white-space:nowrap'>" . profile_link($data['user_id2'], $data['user_name2'], $data['user_status2']) . "<br />\n\t\t" . showdate("forumdate", $data['thread_lastpost']) . "</td>\n";
echo "<td class='" . $row_color . "' style='text-align:center;white-space:nowrap'>" . ($data['thread_postcount'] - 1) . "</td>\n";
echo "<td class='" . $row_color . "' style='text-align:center;white-space:nowrap'><a href='" . FUSION_SELF . "?delete=" . $data['thread_id'] . "' onclick=\"return confirm('" . $locale['global_060'] . "');\">" . $locale['global_058'] . "</a></td>\n";
echo "</tr>\n";
$i++;
}
echo "</table>\n";
closetable();
echo "<div align='center' style='margin-top:5px;'>" . makePageNav($_GET['rowstart'], 10, $rows, 3, FUSION_SELF . "?") . "</div>\n";
} else {
echo "<div style='text-align:center;'>" . $locale['global_059'] . "</div>\n";
closetable();
}
require_once THEMES . "templates/footer.php";
}
echo "<tr>\n<td colspan='2' class='tbl1'>\n";
echo "<div class='btn-group'>\n";
echo "<a class='btn btn-primary' href='#' onclick=\"javascript:setChecked('rem_users_form','rem_check_mark[]',1);return false;\">" . $locale['448'] . "</a>\n";
echo "<a class='btn btn-primary' href='#' onclick=\"javascript:setChecked('rem_users_form','rem_check_mark[]',0);return false;\">" . $locale['449'] . "</a>\n";
echo "</div>\n";
echo "</td>\n</tr>\n<tr>\n<td align='center' colspan='3' class='tbl'>\n";
echo form_button($locale['461'], 'remove_sel', 'remove_sel', $locale['461'], array('class' => 'btn-primary m-r-10'));
echo form_button($locale['462'], 'remove_all', 'remove_all', $locale['462'], array('class' => 'btn-primary'));
echo "</td>\n</tr>\n";
} else {
echo "<tr>\n<td align='center' colspan='2' class='tbl1'>" . $locale['463'] . "</td>\n</tr>\n";
}
echo "</table>\n</form>\n";
if ($rows > 20) {
echo "<div align='center' style='margin-top:5px;'>\n" . makePageNav($_GET['rowstart'], 20, $rows, 3, FUSION_SELF . $aidlink . "&group_id=" . $_GET['group_id'] . "&") . "\n</div>\n";
}
closetable();
echo "<script type='text/javascript'>\n";
echo "/* <![CDATA[ */\n";
echo "function setChecked(frmName,chkName,val) {" . "\n";
echo "dml=document.forms[frmName];" . "\n" . "len=dml.elements.length;" . "\n" . "for(i=0;i < len;i++) {" . "\n";
echo "if(dml.elements[i].name == chkName) {" . "\n" . "dml.elements[i].checked = val;" . "\n";
echo "}\n}\n}\n";
echo "/* ]]>*/\n";
echo "</script>\n";
}
echo "<script type='text/javascript'>\n";
echo "/* <![CDATA[ */\n";
echo "function DeleteGroup() {\n";
echo "return confirm('" . $locale['423'] . "');\n}\n";
echo "<table align='center' width='55%' cellspacing='0'>\n<td class='tbl2' width='30%'><b>" . $locale['VARC351'] . "</b></td>\n<td class='tbl2' align='right' width='10%'><b>" . $locale['VARC352'] . "</b></td>\n</tr>\n";
if (!isset($sortby) || !preg_match("/^[0-9A-Z]\$/", $sortby)) {
$sortby = "all";
}
$orderby = $sortby == "all" ? "" : " WHERE name LIKE '{$sortby}%'";
$result = dbquery("SELECT * FROM " . DB_UBERPETS_PET_SPECIES . "" . $orderby . "");
$rows = dbrows($result);
if (!isset($rowstart) || !isNum($rowstart)) {
$rowstart = 0;
}
if ($rows != 0) {
$result = dbquery("SELECT * FROM " . DB_UBERPETS_PET_SPECIES . "" . $orderby . " ORDER BY name ASC, name LIMIT {$rowstart},25");
echo "<br><img src='" . PETS . ($folder != '' ? $folder : "") . "/Normal.gif' name='folder_preview' alt=''>";
while ($data = dbarray($result)) {
echo "<table align='center' width='55%' cellspacing='0'>";
echo "<tr><td class='small' width='30%'><img src='" . THEME . "images/bullet.gif' alt=''> <a href='admin.php?a_page=pet_species&step=edit&species_id=" . $data['sid'] . "'><b>" . $data['name'] . "</b></a></td>\n";
echo "<td class='small' align='right' width='30%'><a href='admin.php?a_page=pet_species&step=delete&species_id=" . $data['sid'] . "'>Delete</a></td></tr>";
echo "</table>\n";
}
echo "<div align='center' style='margin-top:5px;'>" . makePageNav($rowstart, 25, $rows, 3, "{$FUSION_SELF}?a_page=pet_species&sortby={$sortby}&") . "\n</div>\n";
} else {
echo "<center><br>" . $locale['VARC354'] . " <b>{$sortby}<b><br></center>\n";
}
$search = array("A", "B", "C", "D", "E", "F", "G", "H", "I", "J", "K", "L", "M", "N", "O", "P", "Q", "R", "S", "T", "U", "V", "W", "X", "Y", "Z", "0", "1", "2", "3", "4", "5", "6", "7", "8", "9");
echo "<hr><table align='center' cellpadding='0' cellspacing='1' class='tbl-border'>\n<tr>\n";
echo "<td rowspan='2' class='tbl2'><a href='" . UBP_BASE . "admin/admin.php?a_page=pet_species&sortby=all'>" . $locale['VARC353'] . "</a></td>";
for ($i = 0; $i < 36 != ""; $i++) {
echo "<td align='center' class='tbl1'><div class='small'><a href='" . UBP_BASE . "admin/admin.php?a_page=pet_species&sortby=" . $search[$i] . "'>" . $search[$i] . "</a></div></td>";
echo $i == 17 ? "<td rowspan='2' class='tbl2'><a href='" . UBP_BASE . "admin/admin.php?a_page=pet_species&sortby=all'>" . $locale['VARC353'] . "</a></td>\n</tr>\n<tr>\n" : "\n";
}
echo "</table>\n";
opentable($locale['global_056']);
$result = dbquery("SELECT tn.thread_id FROM " . DB_FORUM_THREAD_NOTIFY . " tn\r\n\tINNER JOIN " . DB_FORUM_THREADS . " tt ON tn.thread_id = tt.thread_id\r\n\tINNER JOIN " . DB_FORUMS . " tf ON tt.forum_id = tf.forum_id\r\n\t" . (multilang_table("FO") ? "WHERE tf.forum_language='" . LANGUAGE . "' AND" : "WHERE") . " tn.notify_user="******" AND " . groupaccess('forum_access') . " AND tt.thread_hidden='0'");
$rows = dbrows($result);
if ($rows) {
$result = dbquery("\r\n\t\tSELECT tf.forum_access, tn.thread_id, tn.notify_datestamp, tn.notify_user,\r\n\t\ttt.thread_subject, tt.forum_id, tt.thread_lastpost, tt.thread_lastuser, tt.thread_postcount,\r\n\t\ttu.user_id AS user_id1, tu.user_name AS user_name1, tu.user_status AS user_status1, \r\n\t\ttu2.user_id AS user_id2, tu2.user_name AS user_name2, tu2.user_status AS user_status2\r\n\t\tFROM " . DB_FORUM_THREAD_NOTIFY . " tn\r\n\t\tINNER JOIN " . DB_FORUM_THREADS . " tt ON tn.thread_id = tt.thread_id\r\n\t\tINNER JOIN " . DB_FORUMS . " tf ON tt.forum_id = tf.forum_id\r\n\t\tLEFT JOIN " . DB_USERS . " tu ON tt.thread_author = tu.user_id\r\n\t\tLEFT JOIN " . DB_USERS . " tu2 ON tt.thread_lastuser = tu2.user_id\r\n\t\tINNER JOIN " . DB_FORUM_POSTS . " tp ON tt.thread_id = tp.thread_id\r\n\t\t" . (multilang_table("FO") ? "WHERE tf.forum_language='" . LANGUAGE . "' AND" : "WHERE") . " tn.notify_user="******" AND " . groupaccess('forum_access') . " AND tt.thread_hidden='0'\r\n\t\tGROUP BY tn.thread_id\r\n\t\tORDER BY tn.notify_datestamp DESC\r\n\t\tLIMIT " . $_GET['rowstart'] . ",10\r\n\t");
echo "<table class='tbl-border' cellpadding='0' cellspacing='1' width='100%'>\n<tr>\n";
echo "<td class='tbl2'><strong>" . $locale['global_044'] . "</strong></td>\n";
echo "<td class='tbl2' style='text-align:center;white-space:nowrap'><strong>" . $locale['global_050'] . "</strong></td>\n";
echo "<td class='tbl2' style='text-align:center;white-space:nowrap'><strong>" . $locale['global_047'] . "</strong></td>\n";
echo "<td class='tbl2' style='text-align:center;white-space:nowrap'><strong>" . $locale['global_046'] . "</strong></td>\n";
echo "<td class='tbl2' style='text-align:center;white-space:nowrap'><strong>" . $locale['global_057'] . "</strong></td>\n";
echo "</tr>\n";
$i = 0;
while ($data = dbarray($result)) {
$row_color = $i % 2 == 0 ? "tbl1" : "tbl2";
echo "<tr>\n<td class='" . $row_color . "'><a href='" . FORUM . "viewthread.php?thread_id=" . $data['thread_id'] . "'>" . $data['thread_subject'] . "</a></td>\n";
echo "<td class='" . $row_color . "' style='text-align:center;white-space:nowrap'>" . profile_link($data['user_id1'], $data['user_name1'], $data['user_status1']) . "</td>\n";
echo "<td class='" . $row_color . "' style='text-align:center;white-space:nowrap'>" . profile_link($data['user_id2'], $data['user_name2'], $data['user_status2']) . "<br />\r\n\t\t" . showdate("forumdate", $data['thread_lastpost']) . "</td>\n";
echo "<td class='" . $row_color . "' style='text-align:center;white-space:nowrap'>" . ($data['thread_postcount'] - 1) . "</td>\n";
echo "<td class='" . $row_color . "' style='text-align:center;white-space:nowrap'><a href='" . INFUSIONS . "forum_threads_list_panel/my_tracked_threads.php?delete=" . $data['thread_id'] . "' onclick=\"return confirm('" . $locale['global_060'] . "');\">" . $locale['global_058'] . "</a></td>\n";
echo "</tr>\n";
$i++;
}
echo "</table>\n";
closetable();
echo "<div align='center' style='margin-top:5px;'>" . makePageNav($_GET['rowstart'], 10, $rows, 3, INFUSIONS . "forum_threads_list_panel/my_tracked_threads.php?") . "</div>\n";
} else {
echo "<div style='text-align:center;'>" . $locale['global_059'] . "</div>\n";
closetable();
}
require_once THEMES . "templates/footer.php";
$help = $locale['urg_a_config_183'];
}
if ($i % 2 == 0) {
$row_color = "tbl1";
} else {
$row_color = "tbl2";
}
echo "<tr class='" . $row_color . "'>\n";
echo "<td>" . $data['name'] . "</td>\n";
echo "<td>" . $data['value'] . "</td>\n";
echo "<td align='right' valign='top'>\n";
//echo "<img src='".INFUSIONS."user_gold/images/help.png' style='border: 0; cursor:help;' title='".$help."' alt='".$help."' />\n";
ug_adminhelp($data['name'], $data['name'], '400', '100');
echo " \n";
echo "<a href='" . FUSION_SELF . $aidlink . "&op=config&pre=" . $_REQUEST['pre'] . "&step=edit&name=" . $data['name'] . "'>\n";
echo "<img src='../images/edit.png' alt='" . $locale['urg_a_config_185'] . "' title='" . $locale['urg_a_config_185'] . "' style='border: 0;' /></a>\n";
echo "</td>\n";
echo "</tr>\n<tr>\n";
echo "<td colspan='3'><hr /></td>\n";
echo "</tr>\n";
$i++;
}
echo "</table>\n";
$total_rows = dbcount("(*)", DB_UG3_SETTINGS, $and);
if ($total_rows > 20) {
echo "<div align='center' style='margin-top:5px;'>\n" . makePageNav($rowstart, 20, $total_rows, 3, FUSION_SELF . $aidlink . "&op=config&pre=" . $_REQUEST['pre'] . "&") . "\n</div>\n";
}
} else {
echo "<tr><td align='center'>" . $locale['urg_a_config_186'] . "</td></tr></table>\n";
}
closetable();
makelist();
echo "</td>\n";
$counter++;
$k++;
}
echo "</tr>\n</table>\n";
if ($rows > $kroaxsettings['kroax_set_thumbs_per_page']) {
echo "<div align='center' style='margin-top:5px;'>\n" . makePageNav($rowstart, $kroaxsettings['kroax_set_thumbs_per_page'], $rows, 3, FUSION_SELF . "?category=" . $category . "&") . "\n</div>\n";
}
//thumb view end
} else {
$result = dbquery("Select * from " . $db_prefix . "kroax WHERE " . groupaccess('kroax_access') . " AND kroax_cat='{$category}' AND kroax_approval='' ORDER by kroax_id DESC LIMIT {$rowstart}," . $kroaxsettings['kroax_set_pre'] . " ");
while ($data = dbarray($result)) {
makelist();
}
echo "<div align='center' style='margin-top:5px;'>\n" . makePageNav($rowstart, $kroaxsettings['kroax_set_pre'], $rows, 3, FUSION_SELF . "?category=" . $category . "&") . "\n</div>\n";
}
}
}
}
if ($kroaxsettings['kroax_set_thumb'] == '1') {
if (isset($category) && isNum($category)) {
$category = cleanurl_kroax($category);
} else {
//Album view start
$result = dbquery("SELECT * FROM " . $db_prefix . "kroax_kategori WHERE " . groupaccess('access') . " AND status='1' AND parentid='0' ORDER BY title ASC");
$rows = dbrows($result);
$counter = 0;
$r = 0;
$k = 1;
echo "<table cellpadding='0' cellspacing='1' width='100%'>\n<tr>\n";
}
if (!$rows) {
?>
<tr>
<td class="tbl1"><?php
echo isset($addon_cat_id) || isset($version) || isset($type) ? $locale['addondb424'] : $locale['addondb422'];
?>
</td>
</tr>
<?php
}
?>
</table>
<?php
if ($rows > $settings_global['addons_per_page']) {
echo "<div align='center' style='margin-top:5px;'>\n" . makePageNav($_GET['rowstart'], $settings_global['addons_per_page'], $rows, 3, $get_vars ? FUSION_SELF . "" . $get_vars . "&" : "") . "\n</div>\n";
}
closetable();
opentable($locale['addondb500']);
$total_addon = dbcount("(addon_id)", DB_ADDONS, "addon_status = '0'");
$total_infus = dbcount("(addon_id)", DB_ADDONS, "addon_status = '0' && addon_type = '1'");
$total_panel = dbcount("(addon_id)", DB_ADDONS, "addon_status = '0' && addon_type = '3'");
$total_theme = dbcount("(addon_id)", DB_ADDONS, "addon_status = '0' && addon_type = '2'");
$total_other = dbcount("(addon_id)", DB_ADDONS, "addon_status = '0' && addon_type = '4'");
$total_trans = dbcount("(trans_id)", DB_ADDON_TRANS, "trans_active = '0'");
$total = dbarray(dbquery("SELECT SUM(addon_download_count) download_count, COUNT(addon_id) FROM " . DB_ADDONS . " WHERE addon_status = '0'"));
$total_count = $total['download_count'];
echo "<table class='tbl-border' align='center' width='100%'><tr>\n\r\n <th class='forum-caption' width='20%'><b>" . $locale['addondb501'] . "</b></th>\r\n <th class='forum-caption' width='20%'>" . $locale['addondb502'] . "</th>\r\n <th class='forum-caption' width='20%'>" . $locale['addondb503'] . "</th>\r\n <th class='forum-caption' width='20%'>" . $locale['addondb504'] . "</th>\r\n <th class='forum-caption' width='20%'>" . $locale['addondb505'] . "</th>\n";
echo "<tr></tr>\n\r\n <td class='tbl2' align='center'>" . $total_addon . "</td>\r\n <td class='tbl2' align='center'>" . $total_infus . "</td>\r\n <td class='tbl2' align='center'>" . $total_panel . "</td>\r\n <td class='tbl2' align='center'>" . $total_theme . "</td>\r\n <td class='tbl2' align='center'>" . $total_other . "</td>\n\r\n </tr>\n<table>\n";
echo "<table class='tbl-border' align='center' width='100%'><tr>\n";
if (iMEMBER) {
$r = 0;
$k = 1;
echo "<table cellpadding='0' cellspacing='0' width='100%' style='margin: 0 auto;'>\n<tr>\n";
while ($data = dbarray($result)) {
if ($counter != 0 && $counter % $varcsettings['thumbs_per_row'] == 0) {
echo "</tr>\n<tr>\n";
}
echo "<td align='center' valign='top' class='tbl'>\n";
makelist();
echo "</td>\n";
$counter++;
$k++;
}
echo "</tr>\n</table>\n";
if ($rows > $varcsettings['thumbs_per_page']) {
echo "<div align='center' style='margin-top:5px;'>\n" . makePageNav($rowstart, $varcsettings['thumbs_per_page'], $rows, 3, FUSION_SELF . "?category=" . $category . "&") . "\n</div>\n";
}
} else {
echo "<table width='100%' border='0' cellspacing='2' cellpadding='3' align='left'>";
$result = dbquery("select * from " . $db_prefix . "varcade_cats WHERE " . groupaccess('access') . "");
$numrows = dbrows($result);
if ($numrows > 0) {
$numrows % 2 ? $numrows += 1 : $numrows;
$rows = $numrows / 2;
//left main cats
echo "<td width=50%>";
$result1 = dbquery("select * from " . $db_prefix . "varcade_cats WHERE " . groupaccess('access') . " ORDER BY title LIMIT {$rows}");
while ($data1 = dbarray($result1)) {
$count1 = "" . dbcount("(lid)", "" . $db_prefix . "varcade_games", "cid='" . $data1['cid'] . "' AND status='2'") . "";
echo '<table cellspacing="2" cellpadding="2" border="0"><tr><td rowspan="2">';
echo "<a href='" . FUSION_SELF . "?category=" . $data1['cid'] . "'><img src='" . INFUSIONS . "varcade/categoryimg/" . $data1['image'] . "' alt='" . $data1['title'] . "' border='0'></a></td>";
$r = 0;
$k = 1;
echo "<table cellpadding='0' cellspacing='0' width='100%'>\n<tr>\n";
while ($data = dbarray($result)) {
if ($counter != 0 && $counter % $uberpets_settings['pound_pets_per_row'] == 0) {
echo "</tr>\n<tr>\n";
}
echo "<td align='center' valign='top' class='tbl'>\n";
makelist();
echo "</td>\n";
$counter++;
$k++;
}
echo "</tr>\n</table>\n";
if ($rows > $varcsettings['pound_pets_per_page']) {
echo "<div align='center' style='margin-top:5px;'>\n" . makePageNav($rowstart, $uberpets_settings['pound_pets_per_page'], $rows, 3, BASEDIR . "game/" . url31("cat", $category, $category['title']) . "&") . "\n</div>\n";
}
closetable();
//If the page is abandon
} elseif ($page == "abandon") {
if (!$step || $step == 1) {
opentable("Abandon");
$petno = $pets_of_user;
if ($petno == 1) {
$tdwidth = "84%";
} elseif ($petno == 2 || 4) {
$tdwidth = "42%";
} elseif ($petno == 3) {
$tdwidth = "42%";
}
echo "<br /><center>Which pet will you abandon today?<br /><br />";
$rowstart = 0;
}
opentable($locale['apdev036']);
$result = dbquery("SELECT a.addon_id, \r\n\t\t\t\t a.addon_name, \r\n\t\t\t\t a.addon_author_name, \r\n\t\t\t\t a.addon_author_status,\r\n\t\t\t\t a.addon_date,\r\n\t\t\t\t a.addon_download_count, \r\n\t\t\t\t u.user_id, \r\n\t\t\t\t u.user_name,\r\n\t\t\t\t u.user_joined, \r\n\t\t\t\t u.user_lastvisit, \r\n\t\t\t\t u.user_status \r\n\t\t\t\t FROM " . DB_ADDONS . " a\r\n\t\t\t\t LEFT JOIN " . DB_USERS . " u \r\n\t\t\t\t ON a.addon_submitter_id=u.user_id \r\n\t\t\t\t WHERE a.addon_status = '0' \r\n\t\t\t\t AND a.addon_author_status = '2' \r\n\t\t\t\t ORDER BY a.addon_date DESC\r\n\t\t\t\t ");
echo "<table cellpadding='0' cellspacing='0' align='center' width='100%' class='tbl-border'>\n<tr>\n";
echo "<th colspan='4' class='forum-caption'>" . $locale['apdev030'] . "</th>\n";
echo "</tr>\n<tr>\n";
echo "<td class='tbl1' colspan='4'> </td>\n";
echo "</tr>\n<tr>\n";
if (dbrows($result) != 0) {
echo "<td class='tbl1'>" . $locale['apdev003'] . "</td>\n";
echo "<td class='tbl1'>" . $locale['apdev037'] . "</td>\n";
echo "<td class='tbl1'>" . $locale['apdev038'] . "</td>\n";
echo "<td class='tbl1' align='center'>" . $locale['apdev039'] . "</td>\n";
echo "</tr>\n";
while ($data = dbarray($result)) {
echo "<tr>\n<td class='tbl1'><a href='" . ADDON . "view.php?addon_id=" . $data['addon_id'] . "'>" . $data['addon_name'] . "</a></td>";
echo "<td class='tbl1'>" . profile_link($data['user_id'], $data['user_name'], $data['user_status']) . "</td>";
echo "<td class='tbl1'>" . showdate("shortdate", $data['addon_date']) . "</td>";
echo "<td class='tbl1' align='center'>" . $data['addon_download_count'] . "</td>";
echo "</tr>\n";
}
echo "</table>\n";
} else {
echo "<td class='tbl1' align='center' colspan='4'>" . $locale['apdev040'] . "</td>\n</tr>\n</table>\n";
}
closetable();
if ($counter > $settings_global['addons_per_page']) {
echo "<div align='center' style='margin-top:5px;'>\n" . makePageNav($rowstart, $settings_global['addons_per_page'], $counter, 3, FUSION_SELF . $aidlink . "&") . "</div>";
}
require_once THEMES . "templates/footer.php";
echo "<a href='" . GIFT_SYSTEM . "give_gift.php?gift_id=" . $data['gift_id'] . "'>";
echo "<img src='" . GIFT_IMAGES . $data['gift_image'] . "' alt='" . $data['gift_image'] . "' style='border:0px;' border='0' alt='' />\n";
echo "</a>\n";
}
echo "<br />" . $locale['sfgift822'] . " " . $data['gift_price'] . " " . $locale['sfgift823'] . "<br />" . $locale['sfgift824'] . " " . ($data['gift_stock'] - $data['gift_bought']) . "\n";
echo "</td>\n";
$counter++;
}
echo "</tr>\n</table>\n";
} else {
echo "<center><br />\n" . $locale['sfgift802'] . "<br /><br />\n</center>\n";
}
echo "</td>\n</tr>\n</table>\n";
closetable();
$total_rows = dbcount("(*)", DB_GIFT);
if ($total_rows > 10) {
echo "<div align='center' style='margin-top:5px;'>\n" . makePageNav($_GET['rowstart'], 16, $total_rows, 3, FUSION_SELF . "?" . $nav_user . "orderby=" . $orderby . "&sortby=" . $sortby . "&") . "\n</div>\n";
}
} else {
if ($userdata['user_id'] == $_GET['user_id']) {
opentable($locale['sfgift830']);
echo $locale['sfgift831'];
closetable();
} else {
opentable($locale['sfgift830']);
echo $locale['sfgift832'];
closetable();
}
}
require_once GIFT_SYSTEM . "footer.php";
require_once THEMES . "templates/footer.php";
$list .= "<form name='spam_form' action='" . FUSION_SELF . "?pagefile=spamlist&action=update_system' method=post>";
$list .= "<fieldset><legend>" . $locale['SYS166'] . "</legend>\n<table width=100% border='0' cellspacing='2' cellpadding='3'>\n<tr>";
$count = 0;
$spalte = 4;
$listnum = 0;
$list .= "<td colspan='" . $spalte * 2 . "'>\n<table border='0' class='textbox' cellspacing='0' cellpadding='0' width='100%'>\n<tr>\n<td>" . $locale['SYS114'] . " " . ($rowstart + 1) . " - " . ($rowstart + dbrows($result)) . " " . $locale['SYS117'] . " <b>{$rows}</b> " . $locale['SYS115'] . "</td>\n<td align='right'>" . $locale['SYS113'] . ": <a href='" . FUSION_SELF . "?pagefile=spamlist&rowstart=0&limits=10'>10</a> <a href='" . FUSION_SELF . "?pagefile=spamlist&rowstart=0&limits=25'>25</a> <a href='" . FUSION_SELF . "?pagefile=spamlist&rowstart=0&limits=50'>50</a> <a href='" . FUSION_SELF . "?pagefile=spamlist&rowstart=0&limits={$rows}'>" . $locale['SYS116'] . "</a></td>\n</tr></table><br>\n</td>\n</tr><tr>\n";
while ($row = dbarray($result)) {
if ($count == $spalte) {
$list .= "</tr><tr>\n";
$count = 0;
}
if ($count < $spalte) {
$list .= "<td valign='top' width=1%><input class='textbox' type='checkbox' id='delete_spam' name='delete_spamword[]' value='" . $row['spam_id'] . "'></td><td valign='middle'>" . $row['spam_word'] . "</td>\n";
$count++;
}
$listnum++;
}
$list .= "</tr><tr>\n<td colspan='" . $spalte * 2 . "' valign='top'><center>\n";
if ($rows > 0) {
$list .= "<table border='0' cellspacing='0' cellpading='3'>\n <tr>\n <td valign='top'>\n <input class='textbox' type='checkbox' onClick='this.value=AllActivate(this.form.delete_spam);'></td>\n <td> " . $locale['SYS123'] . "</td>\n </tr></table>\n ";
$list .= "<input class='button' type='submit' value='" . $locale['SYS110'] . "' name='del_spam' onClick='return DeleteSpam();'>\n </center>";
} else {
$list .= $locale['SYS167'] . "</center>\n";
}
if ($rows > $limits) {
$list .= "<br><div align='center' style='margin-top:5px;'>\n" . makePageNav($rowstart, $limits, $rows, 3, "?pagefile=spamlist&limits={$limits}&") . "\n</div>\n";
}
$list .= "</td></tr>\n</table>\n</fieldset></form>";
echo $list;
echo "<script type='text/javascript'>\nfunction DeleteSpam() {\n\treturn confirm('" . $locale['SYS164'] . "');\n}\n</script>\n";
closetable();
}
echo "<tr> <td colspan='5' class='forum-caption'><b>" . $data['kroax_titel'] . "</b></td> </tr>\n<tr> <td align='center' width='20%' class='tbl2'><span class='small'> " . $showimg . " ";
echo "<td align='center' width='60%' class='tbl2'><span class='small'>" . nl2br(parseubb($data['kroax_description'])) . "</span><br><br></td>\n<td align='center' width='20%' class='tbl2'>";
if ($kroaxsettings['kroax_set_show'] == "1") {
echo "<input style='cursor:pointer;' style='width: 80px;' type=\"button\" class=\"button\" onClick=\"self.location='embed.php?url=" . $data['kroax_id'] . "'\" value=\"" . $locale['FKROAX108'] . "\">";
} else {
echo "<input style='cursor:pointer;' style='width: 80px;' type=\"button\" class=\"button\" onclick=window.open('" . INFUSIONS . "the_kroax/embed.php?p=1&url=" . $data['kroax_id'] . "','Click','scrollbars=yes,resizable=yes,width=800,height=700') value=\"" . $locale['FKROAX108'] . "\">";
}
echo "<br><input style='cursor:pointer;' style='width: 80px;' type=\"button\" class=\"button\" onclick=window.open('" . INFUSIONS . "the_kroax/embed.php?p=1&url=" . $data['kroax_id'] . "','Click','scrollbars=yes,resizable=yes,width=800,height=700') value=\"" . $locale['FKROAX112'] . "\">";
echo "<br><input style='cursor:pointer;' style='width: 80px;' type=\"button\" class=\"button\" onClick=\"self.location='favourites.php?fav_id=" . $data['fav_id'] . "&removefav'\" value=\"" . $locale['FKROAX110'] . "\"></td>\n</tr><br>";
}
echo "</table>";
if ($kroaxsettings['kroax_set_allowplaylist'] == "1" && iMEMBER) {
echo "<center><a href='#' onclick=window.open('" . INFUSIONS . "the_kroax/playlist.php','playlist','scrollbars=yes,resizable=yes,width=770,height=350')><b>Launch this in my playlist</b></a></center>";
}
} else {
echo "<br><center><b>" . $locale['FKROAX104'] . "</b></center><br>";
}
echo "<div align='center' style='margin-top:5px;'>" . makePageNav($rowstart, 5, @$numRecords, 3, FUSION_SELF . "?") . "\n</div>\n";
closetable();
} else {
redirect("" . BASEDIR . "index.php");
closetable();
}
require_once "footer.php";
if (!isset($p)) {
require_once THEMES . "templates/footer.php";
}
?>
$result = dbquery("SELECT * FROM " . $db_prefix . "kroax" . $orderby . "");
$rows = dbrows($result);
if (!isset($rowstart) || !isNum($rowstart)) {
$rowstart = 0;
}
if ($rows != 0) {
echo "<table align='center' width='100%' cellspacing='0'>\n<tr>\n<td align='left' class='tbl2' width='30%'><b>" . $locale['KROAX212'] . "</b></td>\n<td align='center' class='tbl2' width='35%'><b>" . $locale['KROAX213'] . "</b></td>\n\n<td align='center' class='tbl2' width='30%'><b>" . $locale['KROAX210'] . "</b></td>\n<td align='right' class='tbl2' width='5%'><b>" . $locale['KROAX207'] . "</b></td>\n</tr>\n";
$result = dbquery("SELECT * FROM " . $db_prefix . "kroax" . $orderby . " ORDER BY kroax_id DESC, kroax_cat LIMIT {$rowstart},10");
while ($data = dbarray($result)) {
$cdata = dbarray(dbquery("SELECT * FROM " . $db_prefix . "kroax_kategori WHERE cid='" . $data['kroax_cat'] . "' "));
echo "<tr>\n<td class='small' width='22%'><img src='" . THEME . "images/bullet.gif' alt=''> <a href='" . INFUSIONS . "the_kroax/admin/admin.php?a_page=main&step=edit&id=" . $data['kroax_id'] . "'><b>" . $data['kroax_titel'] . "</b></a></td>\n";
echo "<td class='small' align='center' width='12%'>" . $data['kroax_url'] . "</td>";
echo "<td class='small' align='center' width='5%'>" . $cdata['title'] . "</td>";
echo "</td>";
echo "<td class='small' align='right' width='7%'><a href='" . INFUSIONS . "the_kroax/admin/admin.php?a_page=main&step=delete&id=" . $data['kroax_id'] . "' onClick='return confirmdelete();'>" . $locale['KROAX207'] . "</a></td></tr>";
}
echo "</table>\n";
echo "<hr>";
echo "<div align='center' style='margin-top:5px;'>" . makePageNav($rowstart, 10, $rows, 3, FUSION_SELF . "?sortby={$sortby}&") . "\n</div>\n";
} else {
echo "<center><br>\n" . $locale['KROAX208'] . " <b>{$sortby}<b><br><br>\n</center>\n";
}
echo "</div>";
$search = array("A", "B", "C", "D", "E", "F", "G", "H", "I", "J", "K", "L", "M", "N", "O", "P", "Q", "R", "S", "T", "U", "V", "W", "X", "Y", "Z", "0", "1", "2", "3", "4", "5", "6", "7", "8", "9");
echo "<hr><table align='center' cellpadding='0' cellspacing='1' class='tbl-border'>\n<tr>\n";
echo "<td rowspan='2' class='tbl2'><a href='" . INFUSIONS . "the_kroax/admin/admin.php?a_page=main&sortby=all'>" . $locale['KROAX202'] . "</a></td>";
for ($i = 0; $i < 36 != ""; $i++) {
echo "<td align='center' class='tbl1'><div class='small'><a href='" . INFUSIONS . "the_kroax/admin/admin.php?a_page=main&sortby=" . $search[$i] . "'>" . $search[$i] . "</a></div></td>";
echo $i == 17 ? "<td rowspan='2' class='tbl2'><a href='" . INFUSIONS . "the_kroax/admin/admin.php?a_page=main&sortby=all'>" . $locale['KROAX202'] . "</a></td>\n</tr>\n<tr>\n" : "\n";
}
echo "</table>\n";
echo "<td class='tbl1' align='center'><b>" . $locale['sfgift211'] . "</b></td>\n";
echo "<td class='tbl1' align='center'><b>" . $locale['sfgift212'] . "</b></td>\n";
echo "<td class='tbl1' align='center'><b>" . $locale['sfgift213'] . "</b></td>\n";
echo "<td class='tbl1' align='center'><b>" . $locale['sfgift216'] . "</b></td>\n";
echo "<td class='tbl1' align='center'><b>" . $locale['sfgift214'] . "</b></td>\n";
echo "</tr>\n";
while ($data = dbarray($result)) {
echo "<tr>\n";
echo "<td class='tbl1' align='center'>" . $data['gift_id'] . "</td>\n";
echo "<td class='tbl1' align='center'>\n";
echo "<img src='" . INFUSIONS . "sf_gift_system/images/" . $data['gift_image'] . "' alt='" . $data['gift_image'] . "' alt='' />\n";
echo "</td>\n";
echo "<td class='tbl1' align='center'>" . $data['gift_price'] . " " . $locale['sfgift217'] . "</td>\n";
echo "<td class='tbl1' align='center'>" . $data['gift_bought'] . "/" . $data['gift_stock'] . "</td>\n";
echo "<td class='tbl1' align='center'>\n";
echo "<a href='" . FUSION_SELF . $aidlink . "&edit=" . $data['gift_id'] . "'>" . $locale['sfgift230'] . "</a><br />\n";
echo "<a href='" . FUSION_SELF . $aidlink . "&del=" . $data['gift_id'] . "'>" . $locale['sfgift215'] . "</a>\n";
echo "</td>\n";
echo "</tr>\n";
}
echo "</table>\n</center>\n";
} else {
echo "<center><b>" . $locale['sfgift222'] . "</b></center>\n";
}
closetable();
$total_rows = dbcount("(*)", DB_GIFT);
if ($total_rows > 10) {
echo "<div align='center' style='margin-top:5px;'>\n" . makePageNav($rowstart, 10, $total_rows, 3, FUSION_SELF . "?lookup={$lookup}&") . "\n</div>\n";
}
require_once GIFT_SYSTEM . "footer.php";
require_once THEMES . "templates/footer.php";
<blockquote style="margin:40px">
<p><?php
echo preg_replace('/\\[\\/?[a-z(=|#)?0-9]+\\]/si', '', $text);
?>
</p>
<cite>– <?php
echo profile_link($data['user_id'], $data['user_name'], $data['user_status']);
?>
</cite>
</blockquote>
<?php
}
?>
<?php
if ($counter > $limit) {
echo "<div align='center' style='margin-top:5px;'>\n" . makePageNav($rowstart, $limit, $counter, 3) . "</div>";
}
?>
</div>
<?php
}
closetable();
if (iMEMBER) {
$status = "0";
$entry_check = dbcount("(m4n_id)", DB_CONDOLENCES, "m4n_user ='******'user_id'] . "'");
if (!$entry_check) {
if (isset($_POST['cond_send'])) {
if (isset($_POST['m4n_text'])) {
$text = stripinput($_POST['m4n_text']);
$result = dbquery("INSERT INTO " . DB_CONDOLENCES . " (m4n_user, m4n_status, m4n_admin, m4n_text, m4n_datestamp) VALUES ('" . $userdata['user_id'] . "', '0', '0', '" . $text . "', '" . time() . "')");
}
echo "<tr>\n";
echo "<td class='tbl2'><strong>" . $locale['ugly_215'] . "</strong></td>\n";
echo "<td class='tbl2'><strong>" . $locale['ugly_216'] . "</strong></td>\n";
echo "<td class='tbl2'><strong>" . $locale['ugly_217'] . "</strong></td>\n";
echo "</tr>\n";
$c = 0;
//color
while ($prev_data = dbarray($result)) {
if ($c % 2 == 0) {
$row_color = 'tbl1';
} else {
$row_color = 'tbl2';
}
echo "<tr class='" . $row_color . "'>\n";
echo "<td>" . goldmod_user($prev_data['prize_winner_id'], $prev_data['prize_winner_name']) . "</td>\n";
echo "<td>" . $prev_data['prize'] . "</td>\n";
echo "<td>" . ucwords(showdate("longdate", $prev_data['endtime'])) . "</td>\n";
echo "</tr>\n";
$c++;
}
$i++;
} else {
echo "<tr><td style='text-align: center;' class='tbl'>" . $locale['ugly_218'] . "</td></tr>\n";
}
echo "</table>\n";
echo "<div align='center' style='margin-top: 5px;'>\n" . makePageNav($_GET['rowstart'], 20, $rows, 3, FUSION_SELF . "?op=prev_drawings&") . "\n</div>\n";
closetable();
//Start Copywrite Link removal is NOT ALLOWED.
echo "<div align='center' class='small'>" . $locale['ugly_title'] . " " . $locale['ugly_version'] . " © 2008 <a href='http://www.starglowone.com'>Stars Heaven</a></div>\n";
//END Copywrite Link removal is NOT ALLOWED.
require_once THEMES . "templates/footer.php";
$r = 0;
$k = 1;
echo "<table cellpadding='0' cellspacing='0' width='100%'>\n<tr>\n";
while ($data = dbarray($result)) {
if ($counter != 0 && $counter % $uberpets_settings['inventory_items_per_row'] == 0) {
echo "</tr>\n<tr>\n";
}
echo "<td align='center' valign='top' class='tbl'>\n";
show_item($data['iid'], "inventory");
echo "</td>\n";
$counter++;
$k++;
}
echo "</tr>\n</table>\n";
if ($rows > $uberpets_settings['inventory_items_per_page']) {
echo "<div align='center' style='margin-top:5px;'>\n";
makePageNav($rowstart, $uberpets_settings['pound_pets_per_page'], $rows, 3, BASEDIR . "uberpets/inventory");
echo "\n</div>\n";
}
######ITEMS END
echo "</center>";
closetable();
#####
//BOTTOM PAGE INCLUDES
if (preg_match("/^[6]./", $settings['version'])) {
require_once UBP_BASE . "includes/side_right.php";
require_once BASEDIR . "footer.php";
} elseif (preg_match("/^[7]./", $settings['version'])) {
require_once THEMES . "templates/footer.php";
}
//END
echo "<td align='center' class='tbl'>" . $files[$i] . "<br><br>\n";
echo "<img src='" . $name . "' width='100' height='100'><br><br>";
//if(!verify_image($name)) echo "<br>".stripinput(file_get_contents($name))."<br>";
//if (!verify_image($name)) echo $locale['imc205']."<br><br>";
echo "<a href='" . FUSION_SELF . $aidlink . "§ion=a_imagecheck&action=view&imgname={$imgname}&imgext={$imgext}&rowstart={$rowstart}'>" . $locale['imc206'] . "</a> |\n";
echo "<a href='" . FUSION_SELF . $aidlink . "§ion=a_imagecheck&action=delete&imgname={$imgname}&imgext={$imgext}&rowstart={$rowstart}'>" . $locale['imc207'] . "</a></br>\n";
echo "</td>\n";
$counter++;
}
}
if ($rows == 0) {
echo "<td align='center' class='tbl'><br />" . $locale['imc209'] . "</td>\n";
}
echo "</tr>\n</table>\n";
if ($rows > 12) {
echo "<div align='center' style='margin-top:5px;'>\n" . makePageNav($rowstart, 12, $rows, 3, FUSION_SELF . $aidlink . "§ion=a_imagecheck&") . "\n</div>\n";
}
}
echo "<br /><a href=\"http://www.php-fusion.co.uk\" target=\"_blank\">Code by Digitanium</a>";
break;
case "usersearch":
require INFUSIONS . "user_control_center/ucc_usersearch.php";
break;
case "postrecount":
opentable($locale['ucc_650']);
if (isset($_GET['step']) and $_GET['step'] == "recount") {
$type = $_POST['recount_type'];
$type_obj1 = $_POST['recount_name_t'];
$type_obj2 = $_POST['recount_id_t'];
echo $locale['ucc_654'] . "<br /><br /><hr size='5'>";
//--
echo "<div align='center'><br />" . $locale['grhl119'] . "</div><br />\n";
} elseif (iMEMBER && isset($_GET['error']) && $_GET['error'] == 1) {
add_to_title($locale['global_200'] . $locale['grhl122']);
opentable($locale['grhl122']);
echo "<div align='center'><br />" . $locale['grhl120'] . "</div><br />\n";
} else {
add_to_title($locale['global_200'] . $locale['grhl102']);
opentable($locale['grhl102']);
echo "<div align='center'>" . $locale['grhl110'] . "<br /><br />\n";
$result = dbquery("SELECT * FROM " . DB_GR_HOERERLIST . " WHERE hl_free=0 LIMIT " . $rowstart . ",20");
if (dbrows($result)) {
$counter = 0;
$columns = 4;
$rowsend = dbrows(dbquery("SELECT * FROM " . DB_GR_HOERERLIST . " WHERE hl_free=0"));
echo "<table align='center' cellpadding='0' cellspacing='1' width='100%' class='tbl-border'>\n<tr>\n<td colspan='4' align='center' class='tbl1'>\n";
echo makePageNav($rowstart, 20, $rowsend, 3) . "<table cellpadding='0' cellspacing='0' width='100%'>\n<tr>\n";
while ($data = dbarray($result)) {
if ($counter != 0 && $counter % $columns == 0) {
echo "</tr>\n<tr>\n";
}
$user_result = dbquery("SELECT user_id,user_name,user_avatar FROM " . DB_USERS . " WHERE user_id='" . $data['hl_user_id'] . "'");
if (dbrows($user_result)) {
$user_data = dbarray($user_result);
if ($user_data['user_avatar'] != "" && file_exists(IMAGES . "avatars/" . $user_data['user_avatar'])) {
$user_image = $user_data['user_avatar'];
} else {
$user_image = "nopic.jpg";
}
echo "<td align='left' width='25%' class='tbl'>\n<img src='" . IMAGES . "avatars/" . $user_image . "' border='0' alt='" . $user_data['user_name'] . "' width='100' height='100' /><br />\n<strong><a href='" . BASEDIR . "profile.php?lookup=" . $user_data['user_id'] . "'>" . $user_data['user_name'] . "</a></strong><br /><br />\n</td>\n";
$counter++;
} else {
}
echo "</div>\n</td>\n</tr>\n";
$current_row++;
}
}
echo "</table><!--sub_forum_thread_table-->\n";
if (iMOD) {
echo "<table cellspacing='0' cellpadding='0' width='100%'>\n<tr>\n<td style='padding-top:5px'>";
echo "<a href='#' onclick=\"javascript:setChecked('mod_form','delete_post[]',1);return false;\">" . $locale['460'] . "</a> ::\n";
echo "<a href='#' onclick=\"javascript:setChecked('mod_form','delete_post[]',0);return false;\">" . $locale['461'] . "</a></td>\n";
echo "<td align='right' style='padding-top:5px'><input type='submit' name='delete_posts' value='" . $locale['517'] . "' class='button' onclick=\"return confirm('" . $locale['518'] . "');\" /></td>\n";
echo "</tr>\n</table>\n</form>\n";
}
if ($rows > $posts_per_page) {
echo "<div align='center' style='padding-top:5px'>\n";
echo makePageNav($_GET['rowstart'], $posts_per_page, $rows, 3, FUSION_SELF . "?thread_id=" . $_GET['thread_id'] . (isset($_GET['highlight']) ? "&highlight=" . urlencode($_GET['highlight']) : "") . "&") . "\n";
echo "</div>\n";
}
$forum_list = "";
$current_cat = "";
$result = dbquery("SELECT f.forum_id, f.forum_name, f2.forum_name AS forum_cat_name\n\tFROM " . DB_FORUMS . " f\n\tINNER JOIN " . DB_FORUMS . " f2 ON f.forum_cat=f2.forum_id\n\tWHERE " . groupaccess('f.forum_access') . " AND f.forum_cat!='0' ORDER BY f2.forum_order ASC, f.forum_order ASC");
while ($data = dbarray($result)) {
if ($data['forum_cat_name'] != $current_cat) {
if ($current_cat != "") {
$forum_list .= "</optgroup>\n";
}
$current_cat = $data['forum_cat_name'];
$forum_list .= "<optgroup label='" . $data['forum_cat_name'] . "'>\n";
}
$sel = $data['forum_id'] == $fdata['forum_id'] ? " selected='selected'" : "";
$forum_list .= "<option value='" . $data['forum_id'] . "'{$sel}>" . $data['forum_name'] . "</option>\n";
$where_show = "";
$show = "";
}
}
// FIXME
$res = dbquery("SELECT SQL_CALC_FOUND_ROWS" . " dl_mtime, dl_status, pd.review_id, dl_name," . " pd.cat_id, tu.user_name, pd.user_id, pdc.cat_name" . " FROM " . DB_PRP_DOWNLOADS . " AS pd" . " LEFT JOIN " . DB_USERS . " AS tu ON pd.user_id=tu.user_id" . " LEFT JOIN " . DB_PRP_CATS . " AS pdc ON pd.cat_id=pdc.cat_id" . (!empty($where_show) ? " WHERE {$where_show}" : "") . " ORDER BY dl_name ASC" . " LIMIT {$rowstart}," . $prp->settings['per_page']);
$all_reviews = dbarray(dbquery("SELECT FOUND_ROWS()"));
$all_reviews = array_shift($all_reviews);
if (!dbrows($res)) {
echo "<p><b>" . $locale['PRP022'] . "</b>\n";
} else {
echo "\n<table width='100%' cellspacing='1' class='tbl-border'>\n<thead>\n<tr>\n\t<th class='tbl2' width='1%'>" . $locale['prp_status'] . "</th>\n\t<th class='tbl2' width='16'></th>\n\t<th class='tbl2'>" . $locale['PRP002'] . "</th>\n\t<th class='tbl2'>" . $locale['PRP012'] . "</th>\n\t<th class='tbl2'>" . $locale['PRP052'] . "</th>\n\t<th class='tbl2' width='16'></th>\n</tr>\n</thead>\n<tbody>\n";
}
$count = 1;
while ($data = dbarray($res)) {
$id = $data['review_id'];
$tbl = "tbl" . (++$count % 2 + 1);
echo "\n<tr>\n\t<td class='" . $tbl . "'>" . $locale['PRP904'][$data['dl_status']] . "</td>\n\t<td class='" . $tbl . "'><a href='../edit_desc.php?did={$id}'><img" . " src='../icons/edit.png' alt='" . $locale['prp_edit'] . "'" . " title='" . $locale['prp_edit'] . "' class='noborder'></a></td>\n\t<td class='" . $tbl . "'><a href='../review.php?did={$id}'>" . $data['dl_name'] . "</a></td>\n\t<td class='" . $tbl . "'>" . $data['cat_name'] . "</td>\n\t<td class='" . $tbl . "' align='center'>" . "<a href='../profile.php?id=" . $data['user_id'] . "'>" . $data['user_name'] . "</a><br>" . showdate("shortdate", $data['dl_mtime']) . "</td>\n\t<td class='" . $tbl . "'><a href='del_review.php?did={$id}'><img" . " src='../icons/editdelete.png' alt='" . $locale['prp_delete'] . "'" . " title='" . $locale['prp_delete'] . "' class='noborder'></a>" . "</td>\n</tr>\n";
}
if (dbrows($res)) {
echo "</tbody>\n</table>\n";
}
if ($all_reviews > $prp->settings['per_page']) {
$link = FUSION_SELF . "?show={$show}&";
if (($show == "cat" || $show == "license") && isset($_GET['id']) && isNum($_GET['id'])) {
$link .= "id=" . $_GET['id'] . "&";
}
echo "<div align='center'>" . makePageNav($rowstart, $prp->settings['per_page'], $all_reviews, $all_reviews, $link) . "</div>";
}
closetable();
require_once '../include/die.php';
echo "<a href='#' onclick=\"javascript:setChecked('mod_form','check_mark[]',0);return false;\">" . $locale['461'] . "</a></td>\n";
echo "<td align='right' style='padding-top:5px'><input type='submit' name='delete_threads' value='" . $locale['462'] . "' class='button' onclick=\"return confirm('" . $locale['463'] . "');\" /></td>\n";
echo "</tr>\n</table>\n";
}
echo "</form>\n";
if ($threadcount || $rows) {
echo "<script type='text/javascript'>\n" . "function setChecked(frmName,chkName,val) {\n";
echo "dml=document.forms[frmName];\n" . "len=dml.elements.length;\n" . "for(i=0;i < len;i++) {\n";
echo "if(dml.elements[i].name == chkName) {\n" . "dml.elements[i].checked = val;\n}\n}\n}\n";
echo "</script>\n";
}
}
if ($rows > $threads_per_page || iMEMBER && $can_post) {
echo "<table cellspacing='0' cellpadding='0' width='100%'>\n<tr>\n";
if ($rows > $threads_per_page) {
echo "<td style='padding-top:5px'>" . makePageNav($_GET['rowstart'], $threads_per_page, $rows, 3, FUSION_SELF . "?forum_id=" . $_GET['forum_id'] . "&") . "</td>\n";
}
if (iMEMBER && $can_post) {
echo "<td align='right' style='padding-top:5px'><a href='post.php?action=newthread&forum_id=" . $_GET['forum_id'] . "'><img src='" . get_image("newthread") . "' alt='" . $locale['566'] . "' style='border:0px;' /></a></td>\n";
}
echo "</tr>\n</table>\n";
}
$forum_list = "";
$current_cat = "";
$result = dbquery("SELECT f.forum_id, f.forum_name, f2.forum_name AS forum_cat_name\r\n\tFROM " . DB_FORUMS . " f\r\n\tINNER JOIN " . DB_FORUMS . " f2 ON f.forum_cat=f2.forum_id\r\n\tWHERE " . groupaccess('f.forum_access') . " AND f.forum_cat!='0' ORDER BY f2.forum_order ASC, f.forum_order ASC");
while ($data2 = dbarray($result)) {
if ($data2['forum_cat_name'] != $current_cat) {
if ($current_cat != "") {
$forum_list .= "</optgroup>\n";
}
$current_cat = $data2['forum_cat_name'];
$where_show = "";
$show = "";
}
}
// FIXME
$res = dbquery("SELECT SQL_CALC_FOUND_ROWS" . " dl_mtime, dl_status, pd.download_id, dl_name," . " pd.cat_id, tu.user_name, pd.user_id, pdc.cat_name" . " FROM " . DB_PDP_DOWNLOADS . " AS pd" . " LEFT JOIN " . DB_USERS . " AS tu ON pd.user_id=tu.user_id" . " LEFT JOIN " . DB_PDP_CATS . " AS pdc ON pd.cat_id=pdc.cat_id" . (!empty($where_show) ? " WHERE {$where_show}" : "") . " ORDER BY dl_name ASC" . " LIMIT {$rowstart}," . $pdp->settings['per_page']);
$all_downloads = dbarray(dbquery("SELECT FOUND_ROWS()"));
$all_downloads = array_shift($all_downloads);
if (!dbrows($res)) {
echo "<p><b>" . $locale['PDP022'] . "</b>\n";
} else {
echo "\n<table width='100%' cellspacing='1' class='tbl-border'>\n<thead>\n<tr>\n\t<th class='tbl2' width='1%'>" . $locale['pdp_status'] . "</th>\n\t<th class='tbl2' width='16'></th>\n\t<th class='tbl2'>" . $locale['PDP002'] . "</th>\n\t<th class='tbl2'>" . $locale['PDP012'] . "</th>\n\t<th class='tbl2'>" . $locale['PDP052'] . "</th>\n\t<th class='tbl2' width='16'></th>\n</tr>\n</thead>\n<tbody>\n";
}
$count = 1;
while ($data = dbarray($res)) {
$id = $data['download_id'];
$tbl = "tbl" . (++$count % 2 + 1);
echo "\n<tr>\n\t<td class='" . $tbl . "'>" . $locale['PDP904'][$data['dl_status']] . "</td>\n\t<td class='" . $tbl . "'><a href='../edit_desc.php?did={$id}'><img" . " src='../icons/edit.png' alt='" . $locale['pdp_edit'] . "'" . " title='" . $locale['pdp_edit'] . "' class='noborder'></a></td>\n\t<td class='" . $tbl . "'><a href='../download.php?did={$id}'>" . $data['dl_name'] . "</a></td>\n\t<td class='" . $tbl . "'>" . $data['cat_name'] . "</td>\n\t<td class='" . $tbl . "' align='center'>" . "<a href='../profile.php?id=" . $data['user_id'] . "'>" . $data['user_name'] . "</a><br>" . showdate("shortdate", $data['dl_mtime']) . "</td>\n\t<td class='" . $tbl . "'><a href='del_download.php?did={$id}'><img" . " src='../icons/editdelete.png' alt='" . $locale['pdp_delete'] . "'" . " title='" . $locale['pdp_delete'] . "' class='noborder'></a>" . "</td>\n</tr>\n";
}
if (dbrows($res)) {
echo "</tbody>\n</table>\n";
}
if ($all_downloads > $pdp->settings['per_page']) {
$link = FUSION_SELF . "?show={$show}&";
if (($show == "cat" || $show == "license") && isset($_GET['id']) && isNum($_GET['id'])) {
$link .= "id=" . $_GET['id'] . "&";
}
echo "<div align='center'>" . makePageNav($rowstart, $pdp->settings['per_page'], $all_downloads, $all_downloads, $link) . "</div>";
}
closetable();
require_once '../include/die.php';
function search_navigation($rows)
{
global $site_search_count, $composevars;
$site_search_count += $rows;
$navigation_result = "<div align='center' style='margin-top:5px;'>\n" . makePageNav($_GET['rowstart'], 10, $site_search_count > 100 || search_globalarray("") ? 100 : $site_search_count, 3, FUSION_SELF . "?stype=" . $_GET['stype'] . "&stext=" . urlencode($_GET['stext']) . "&" . $composevars) . "\n</div>\n";
return $navigation_result;
}
}
$counter = dbcount("(user_id)", DB_USERS, "user_approve !='1' && user_testimonial != '' && user_status = '0'");
if (isset($_GET['rowstart']) && isnum($_GET['rowstart'])) {
$rowstart = $_GET['rowstart'];
} else {
$rowstart = 0;
}
$limit = "20";
$result = dbquery("\r\n SELECT \r\n user_id, \r\n user_name, \r\n user_status, \r\n user_testimonial \r\n FROM " . DB_USERS . " \r\n WHERE user_status = '0' \r\n AND user_testimonial !='' \r\n AND user_approve !='1' \r\n ORDER BY user_lastvisit \r\n DESC LIMIT {$rowstart},{$limit}\r\n ");
echo "<table border='0' width='100%' class='tbl-border'>\n<tr>\n";
echo "<th class='forum-caption' colspan='2'>" . $locale['ltp_003'] . "</th>\n";
echo "</tr>\n<tr>\n";
echo "<td colspan='2'> </td>\n";
echo "</tr>\n";
if (dbrows($result)) {
while ($data = dbarray($result)) {
echo "<tr>\n<td class='tbl1'>" . profile_link($data['user_id'], $data['user_name'], $data['user_status']) . "</td>\n";
echo "<td class='tbl2'>";
$text = nl2br(parseubb(censorwords($data['user_testimonial'])));
echo isset($text) ? $text : "";
echo "</td>\n</tr>\n";
}
} else {
echo "<tr>\n<td class='tbl1'>" . $locale['ltp_005'] . "</td>\n</tr>\n";
}
echo "</table>\n";
closetable();
if ($counter > $limit) {
echo "<div align='center' style='margin-top:5px;'>\n" . makePageNav($rowstart, $limit, $counter, 3, FUSION_SELF . $aidlink . "&") . "</div>";
}
require_once THEMES . "templates/footer.php";
