[cooper1988]

<?php
/**
* MyBB 1.0
* Copyright © 2005 MyBulletinBoard Group, All Rights Reserved
*
* Website: http://www.mybboard.com
* License: http://www.mybboard.com/eula.html
*
* $Id: stats.php 897 2005-11-13 20:08:05Z dennis $
*/
define("KILL_GLOBALS", 1);

$templatelist = "stats,stats_thread";
require "./global.php";
require "./inc/functions_post.php";

// Load global language phrases
$lang->load("stats");

addnav($lang->nav_stats);

$stats = $cache->read("stats");

if($stats['numthreads'] < 1 || $stats['numposts'] < 1)
{
error($lang->not_enough_info_stats);
}

$plugins->run_hooks("stats_start");

$repliesperthread = mynumberformat(round((($stats['numposts'] - $stats['numthreads']) / $stats['numthreads']), 2));
$postspermember = mynumberformat(round(($stats['numposts'] / $stats['numusers']), 2));

// Get number of days since board start (might need improvement)
$query = $db->query("SELECT regdate FROM ".TABLE_PREFIX."users ORDER BY regdate LIMIT 1");
$result = $db->fetch_array($query);
$days = (time() - $result['regdate']) / 86400;

// Get "per day" things
$postsperday = mynumberformat(round(($stats['numposts'] / $days), 2));
$threadsperday = mynumberformat(round(($stats['numthreads'] / $days), 2));
$membersperday = mynumberformat(round(($stats['numusers'] / $days), 2));

// Get forum permissions
$unviewableforums = getunviewableforums();
if($unviewableforums)
{
$fidnot = " AND fid NOT IN ($unviewableforums)";
}

// Most replied-to threads
$query = $db->query("SELECT tid, subject, replies FROM ".TABLE_PREFIX."threads WHERE 1=1 $fidnot ORDER BY replies DESC LIMIT 0, ".$mybb->settings[statslimit]);
while($thread = $db->fetch_array($query))
{
$thread['subject'] = htmlspecialchars_uni(stripslashes(dobadwords($thread['subject'])));
$numberbit = mynumberformat($thread['replies']);
$numbertype = $lang->replies;
eval("\$mostreplies .= \"".$templates->get("stats_thread")."\";");
}

// Most viewed threads
$query = $db->query("SELECT tid, subject, views FROM ".TABLE_PREFIX."threads WHERE 1=1 $fidnot ORDER BY views DESC LIMIT 0, ".$mybb->settings[statslimit]);
while($thread = $db->fetch_array($query))
{
$thread['subject'] = htmlspecialchars_uni(stripslashes(dobadwords($thread['subject'])));
$numberbit = mynumberformat($thread['views']);
$numbertype = $lang->views;
eval("\$mostviews .= \"".$templates->get("stats_thread")."\";");
}

// Top forum
$query = $db->query("SELECT fid, name, threads, posts FROM ".TABLE_PREFIX."forums WHERE 1=1 $fidnot AND type='f' ORDER BY posts DESC LIMIT 1");
$forum = $db->fetch_array($query);
if(!$forum['posts'])
{
$topforum = $lang->none;
$topforumposts = $lang->no;
$topforumthreads = $lang->no;
}
else
{
$forum['name'] = htmlspecialchars_uni(stripslashes($forum['name']));
$topforum = "<a href=\"forumdisplay.php?fid=$forum[fid]\">$forum[name]</a>";
$topforumposts = $forum['posts'];
$topforumthreads = $forum['threads'];
}

// Today's top poster
$timesearch = time() - 86400;
$query = $db->query("SELECT u.uid, u.username, COUNT(*) AS poststoday FROM ".TABLE_PREFIX."posts p LEFT JOIN ".TABLE_PREFIX."users u ON (p.uid=u.uid) WHERE p.dateline > $timesearch GROUP BY p.uid ORDER BY poststoday DESC LIMIT 1");
$user = $db->fetch_array($query);
if(!$user['poststoday'])
{
$topposter = $lang->nobody;
$topposterposts = $lang->no_posts;
}
else
{
if(!$user['uid'])
{
$topposter = $lang->guest;
}
else
{
$topposter = "<a href=\"member.php?action=profile&uid=$user[uid]\">$user[username]</a>";
}

//Eldest Member
$rt = $db->query("SELECT uid, username, birthday FROM ".TABLE_PREFIX."users ORDER BY birthday DESC LIMIT 0,1");
while($nt = $db->fetch_array($rt)){
$usr = $nt['username'];

$aged = "<a href=\"member.php?action=profile&uid=$nt[uid]\">$usr</a>";
$agedd = $nt['birthday'];
}

//youngest Member
$rt = $db->query("SELECT uid, username, birthday FROM ".TABLE_PREFIX."users WHERE birthday != '' ORDER BY birthday ASC LIMIT 0,1");
while($nt = $db->fetch_array($rt)){
$usr = $nt['username'];

$youngest = "<a href=\"member.php?action=profile&uid=$nt[uid]\">$usr</a>";
$youngestd = $nt['birthday'];
}
//First Member
$rt = $db->query("SELECT uid, username, regdate FROM ".TABLE_PREFIX."users ORDER BY regdate ASC LIMIT 0,2");
while($nt = $db->fetch_array($rt)){
$usr = $nt['username'];

$ftreg = "<a href=\"member.php?action=profile&uid=$nt[uid]\">$usr</a>";
$ftregd= $nt['regdate'];
}

//last visit
$rt = $db->query("SELECT uid, username, lastvisit FROM ".TABLE_PREFIX."users ORDER BY lastvisit DESC LIMIT 0,2");
while($nt = $db->fetch_array($rt)){
$usr = $nt['username'];
$lastvisitor = "<a href=\"member.php?action=profile&uid=$nt[uid]\">$usr</a>";
$lastvisitord= $nt['lastvisit'];
}
//total males
$rt = $db->query("SELECT count( * ) AS fid FROM ".TABLE_PREFIX."userfields WHERE fid3 = 'Male'");
while($nt = $db->fetch_array($rt)){
$tm = $nt['fid'];

$tmale = "$tm";
}
//total Undisclosed
$rt = $db->query("SELECT count( * ) AS fid FROM ".TABLE_PREFIX."userfields WHERE fid3 = 'Undisclosed'");
while($nt = $db->fetch_array($rt)){
$tu = $nt['fid'];
$tundi = "$tu";
}
//total Females
$rt = $db->query("SELECT count( * ) AS fid FROM ".TABLE_PREFIX."userfields WHERE fid3 = 'Female'");
while($nt = $db->fetch_array($rt)){
$tf = $nt['fid'];
$tfem = "$tf";
}
//top poster
$rt = $db->query("SELECT uid, username, postnum FROM ".TABLE_PREFIX."users ORDER BY postnum DESC LIMIT 0,1");
while($nt = $db->fetch_array($rt)){
$usr = $nt['username'];

$tpost = "<a href=\"member.php?action=profile&uid=$nt[uid]\">$usr</a>";
$tpost2 = $nt['postnum'];
}



// What percent of members have posted?
$query = $db->query("SELECT COUNT(*) FROM ".TABLE_PREFIX."users WHERE postnum > 0");
$posters = $db->result($query, 0);
$havepostedpercent = round((($posters / $stats['numusers']) * 100), 2) . "%";

$lang->todays_top_poster = sprintf($lang->todays_top_poster, $topposter, mynumberformat($topposterposts));
$lang->popular_forum = sprintf($lang->popular_forum, $topforum, mynumberformat($topforumposts), mynumberformat($topforumthreads));

$stats['numposts'] = mynumberformat($stats['numposts']);
$stats['numthreads'] = mynumberformat($stats['numthreads']);
$stats['numusers'] = mynumberformat($stats['numusers']);

eval("\$stats = \"".$templates->get("stats")."\";");
$plugins->run_hooks("stats_end");
outputpage($stats);
?>

[Michael]

Ist das die originale stats.php, die du hochgeladen hast?

[cooper1988]

ja is die originale stats.php

[Michael]

Nein ist sie nicht, du hast eine falsche (modifizierte) Datei übertragen.

[cooper1988]

ne hab ich net das is die originale so wie ichs gesaugt habe poste ma die originale

[cooper1988]

gut hab es schon kann ma das auch irgendwie auch auf die startseite bringen so das es ganz unten zu sehn ist

[Michael]

Dazu musst du das entsprechende Template durch den gewünschten Code ergänzen und den PHP-Code in die index.php einfügen, bevor das entsprechende Template geladen wird.

[cooper1988]

wenn du mir noch sagst wie das geht bin ich zufrieden mit dir(euch)

[Garlant]

Hallo Cooper1988,
Unten ist etwas weit gefächert(unter der useronlineanzeige, unter dem headder,...).
Wo genau willst du das denn einbauen? Dann können wir dir auch sagen was du suchen kannst

[cooper1988]

schau ma in mein forum unten steht schon ein bsp Forenstatistik dort hätte ichs gern hin gegen das alte system Forenstatistik soll nun das neue dort sein siehe bild

[Bild: http://img97.imageshack.us/img97/3113/test9cd.th.jpg]