<?php
    /*
        @filename:      describeusers.php
        @author:        George Petsagourakis
        @email:         petsagouris@hotmail.com
        @date:          18 Dec 2004
        @license:       GPL
        @todo:          Suggestions welcome ...
            @description:   it displays all the users and lists the WikiPages they own.
                            also displays the percentages of comments and pages they own in the wiki.
                        owned pages count and own comments count is also diaplayed.
        @usage:         insert {{describeusers}} any where in a wakka page.
                        Example : {{describeusers cellpadding="5" cellspacing="3" border="1" columns="2"}}
                        You may use the above syntax to customise the layout of the output.
                        Any of the attributes may be mentioned or not ;)
    */
    $row = 1;
    $cellpadding = 1;
    $cellspacing = 1;
    $border = 0;
    $columns = 3;

    if (is_array($vars)){
        foreach ($vars as $att => $v){
            if ($att == 'columns') $columns=$v;
            if ($att == 'cellpadding') $cellpadding=$v;
            if ($att == 'cellspacing') $cellspacing=$v;
            if ($att == 'border') $border=$v;
        }
        // Getting the comments count ...
        $total_wikicomments = 0;
        $res = $this->LoadAll("SELECT Count(*) FROM ".$this->config['table_prefix']."comments GROUP BY page_tag");
        foreach($res as $i => $arr) {
            foreach($arr as $t => $c){
                $total_wikicomments += $c;
            }
        }
        // Getting the pages count ...
        $total_wikipages = 0;
        $res = $this->LoadAll("SELECT Count(*) from ".$this->config['table_prefix']."pages WHERE latest ='Y' GROUP BY tag");
        foreach($res as $i => $arr) {
            foreach($arr as $t => $c){
                $total_wikipages += $c;
            }
        }
        //print $total_wikipages." -- \n";
        // Lets get all the usernames in an array...
        $all_usernames = array();
        $res = $this->LoadAll("SELECT name from ".$this->config['table_prefix']."users");
        foreach($res as $i => $arr) {
            foreach ($arr as $t => $name){
                $res_pagenames = $this->LoadAll("SELECT tag,datediff(time, now()) as last_edit FROM ".$this->config['table_prefix']."pages WHERE owner='$name' and latest ='Y' GROUP BY tag");
                $temp = array();
                foreach($res_pagenames as $i => $page) {
                    $le = abs($page['last_edit']+0) ;
                    if ($le > 1) { $le = "$le days ago"; }
                    else if ($le == 1) { $le = "yesterday"; }
                    else {$le = "today";}
                    $temp['pages'][$page['tag']] = "$le";
                }
                $temp['commentscount'] = count($this->LoadAll("SELECT Count(*) FROM ".$this->config['table_prefix']."comments WHERE user='$name' GROUP BY id"));
            }
            $all_usernames[$name] = $temp;
        }

        $the_big_one = array();
        foreach($all_usernames as $name => $arr){
           
            $name = $this->Format($name);

            $row_one = "$name | Pages: ".count($arr['pages'])." | Comments: ".$arr['commentscount'];

            $row_two = "Owns ".round( ( ((count($arr['pages']))*100)/$total_wikipages ), 2)."% of all the pages and <br />".round( ( (($arr['commentscount'])*100)/$total_wikicomments ), 2)."% of all comments in this wiki";

            $row_three = '<table width="100%" border="0" cellpadding="1">';
            $row_three .= '<tr><td>Page</td><td align=\"left\">| Last Edit</td></tr>';
            if (!count($arr['pages'])) {
                $row_three .= "<tr><td>none</td><td align=\"left\">| <em>never</em></td></tr>";
            }
            else {
                foreach($arr['pages'] as $p => $l){
                    //print "$p - $l\n";
                    $row_three .= "<tr><td align=\"left\">".$this->Format($p)."</td><td align=\"left\">| <em>$l</em></td></tr>";
                }
            }
            $row_three .= "</table>";

            $out = "<table border=\"0\" cellpadding=\"3\">";
            $out .= "<tr><td>$row_one</td></tr>";
            $out .= "<tr><td>$row_two</td></tr>";
            $out .= "<tr><td>$row_three</td></tr>";
            $out .= "</table>";
            // print $out;
            $the_big_one[] = $out;
        }
        $fin = "<hr />";
        //var_dump($the_big_one);
        foreach($the_big_one as $i => $cell){
            if ($row == 1) $fin .= "<table width=\"100%\" border=\"$border\" cellspacing=\"$cellspacing\" cellpadding=\"$cellpadding\">\n   <tr>\n";
            $fin .= "<td width=\"".(100/$columns)."%\"valign=\"top\" align=\"center\">$cell</td>\n";
            $row++;
            if ($row > $columns) {
                $row = 1;
                $fin .= "   </tr>\n</table>\n<hr />";
            }
        }
        echo $this->ReturnSafeHTML($fin);
    }
?>

$res_pagenames = $this->LoadAll("SELECT tag,TO_DAYS(now())-TO_DAYS(time) AS last_edit FROM ".$this->config['table_prefix']."pages WHERE owner='$name' and latest ='Y' GROUP BY tag");

// CORRECTION OF DIVISION-BY-ZERO ERROR
if($total_wikipages>0)
    $percent_pages = round( ( ((count($arr['pages']))*100)/$total_wikipages ), 2);
else
    $percent_pages = 0;
if($total_wikicomments>0)
    $percent_comments = round( ( (($arr['commentscount'])*100)/$total_wikicomments ), 2);
else
    $percent_comments = 0;
$row_two = "Owns ".$percent_pages."% of all the pages and <br />".$percent_comments."% of all comments in this wiki";