Esempio n. 1
0
    function _display_state_table($stats, $prefix) {
?>
<table border=1>
<?
        $t = array();
        $types = array();
        $state_totals = array();
        $type_totals = array();
        global $state_help_notes_map;
        foreach ($stats as $k=>$v) {
            if (stristr($k, $prefix)) {
                list($type, $state) = explode(" ", str_replace($prefix, "", $k));
                $t[$state][$type] = $v;
                if (!array_key_exists($state, $state_totals)) $state_totals[$state] = 0;
                if (!array_key_exists($type, $type_totals)) $type_totals[$type] = 0;
                $state_totals[$state] += $v;
                $type_totals[$type] += $v;
                if (!array_key_exists($state, $state_help_notes_map))
                    die("missing entry from state_help_notes_map '$state'");
                $types[$type] = 1;
            }
        }
        $states = array_keys($state_help_notes_map);
        $types = array_keys($types);
        sort($types);
        print "<tr><td>&nbsp;</td>";
        foreach ($states as $state) {
            print "<td><b>";
            print add_tooltip($state, $this->state_help_notes($state));
            print "</b></td>";
        }
        print "<td><b>Total</b></td>";
        print "</tr>";
        global $va_type_name, $va_inside;
        foreach ($types as $type) {
            print "<tr>";
            print "<td><b>";
            if (array_key_exists($type, $va_inside))
                print $va_type_name[$va_inside[$type]];
            print " (".$type.")";
            print "</b></td>";
            foreach ($states as $state) {
                print "<td style=\"text-align: right\">";
                if (array_key_exists($state, $t)) {
                    if (array_key_exists($type, $t[$state])) {
                        print $t[$state][$type];
                    }
                }
                print "</td>";
            }
            print "<td style=\"text-align: right\"><b>";
            print $type_totals[$type];
            print "</b></td>";
            print "</tr>\n";
        }
        print "<tr><td><b>Total:</b></td>";
        foreach ($states as $state) {
            print "<td style=\"text-align: right\"><b>";
            if (array_key_exists($state, $state_totals))
                print $state_totals[$state];
            else
                print "&nbsp;";
            print "</b></td>";
        }
        $type_grand_total = array_sum(array_values($type_totals));
        $state_grand_total = array_sum(array_values($state_totals));
        if ($type_grand_total != $state_grand_total)
            die("type_grand_total != state_grand_total");
        print "<td><b>".$type_grand_total."</b></td>";
        print "</tr>";
?>
</table>
<?
    }
| This program is released as free software under the Affero GPL license.
| You can redistribute it and/or modify it under the terms of this license
| which you can read by viewing the included agpl.txt or online
| at www.gnu.org/licenses/agpl.html. Removal of this copyright header is
| strictly prohibited without written permission from the original author(s).
+---------------------------------------------------------------------------*/
if (!defined("PIMPED_FUSION")) {
    die("Access Denied");
}
if (!isset($lastvisited) || !isnum($lastvisited)) {
    $lastvisited = time();
}
$display_more = 10;
add_to_head("<script type='text/javascript'>\r\n<!--\r\nfunction show_more_threads() {\r\n\tvar smt = document.getElementById('show_more_threads');\r\n\tvar smttxt = document.getElementById('show_more_threads_text');\r\n\tif (smt.style.display == 'none') {\r\n\tsmt.style.display = 'block';\r\n\tsmttxt.innerHTML = '" . $locale['global_063'] . "';\r\n\t} else {\r\n\tsmt.style.display = 'none';\r\n\tsmttxt.innerHTML = '" . $locale['global_062'] . "';\r\n\t}\r\n}\r\n//-->\r\n</script>");
// Add Tooltip-JavaScript
add_tooltip();
#$data = dbarray(dbquery("SELECT tt.thread_lastpost
#	FROM ".DB_FORUMS." tf
#	INNER JOIN ".DB_THREADS." tt ON tf.forum_id = tt.forum_id
#	WHERE ".groupaccess('tf.forum_access')."
#	ORDER BY tt.thread_lastpost DESC LIMIT ".($settings['numofthreads']-1).", ".$settings['numofthreads']));
#
#$timeframe = empty($data['thread_lastpost']) ? 0 : $data['thread_lastpost'];
#
#What is this $timeframe for?
if (IF_MULTI_LANGUAGE_FORUM && iMEMBER && isset($userdata['user_forumpanellocale']) && $userdata['user_forumpanellocale'] != '') {
    $insert = $userdata['user_forumpanellocale'] == "all" ? "" : " AND tc.forum_language='" . $userdata['user_forumpanellocale'] . "' ";
} else {
    $insert = "";
}
$result = dbquery("SELECT tt.thread_id, tt.thread_subject, tt.thread_views, tt.thread_lastuser, tt.thread_lastpost,\r\n\ttt.thread_poll, tt.thread_lastpostid, tt.thread_postcount, tt.thread_resolved,\r\n\ttu.user_id, tu.user_name, tu.user_status,\r\n\ttp.post_message, tp.post_smileys,\r\n\ttf.forum_id, tf.forum_name, tf.forum_access, tf.forum_markresolved,\r\n\ttc.forum_language\r\n\tFROM " . DB_THREADS . " tt\r\n\tINNER JOIN " . DB_FORUMS . " tf ON tt.forum_id=tf.forum_id\r\n\tINNER JOIN " . DB_FORUMS . " tc ON tf.forum_cat=tc.forum_id\r\n\tINNER JOIN " . DB_POSTS . " tp ON tt.thread_lastpostid=tp.post_id\r\n\tINNER JOIN " . DB_USERS . " tu ON tt.thread_lastuser=tu.user_id\r\n\tWHERE " . groupaccess('tf.forum_access') . $insert . " AND thread_hidden='0' \r\n\tORDER BY tt.thread_lastpost DESC LIMIT 0," . ($settings['numofthreads'] + $display_more));