I see now that your using TP on the other site..... Nevermind, I took the original TP stats block and modified if to work with EzPortal 

Regards
Eddy

I have a problem with the Stats block I wrote for EzPortal - It worked fine under SMF 1.1.10, but now that I've upgraded to SMF 2.0 RC2 it just generates a fatal error:

Call to undefined function db_query() in smf/Sources/Load.php(2078) eval()'d code(1489): eval()'d code on line 27

I'm no programmer, so I'm sure it's something silly that I've done wrong - Can anyone help please?

<?xml version="1.0"?>
<!DOCTYPE block-info SYSTEM "http://www.ezportal.com/xml/block-info">
<block-info xmlns="http://www.ezportal.com/xml/block-info" xmlns:ezportal="http://www.ezportal.com/">
<id>eddymatthews:additionalstats</id>
<title>Additional Stats</title>
<version>1.1</version>
<blocktype>php</blocktype>
<forumversion>SMF 2.0.x</forumversion>
<author>Eddy Matthews</author>
<website>http://www.paddleducks.co.uk</website>
<editable>1</editable>
<can_cache>1</can_cache>


<blockdata><![CDATA[global $context, $boarddir, $settings, $options, $scripturl, $user_info, $modSettings;


require($boarddir.'/SSI.php');

    $bullet = '<img src="'.$settings['images_url'].'/icons/divider.gif" alt="" border="0" style="margin:0 2px 0 0;" />';
    $bullet2 = '<img src="'.$settings['images_url'].'/icons/divider2.gif" alt="" border="0" style="margin:0 2px 0 0;" />';
    $bullet3 = '<img src="'.$settings['images_url'].'/icons/divider3.gif" alt="" border="0" style="margin:0 2px 0 0;" />';
    $bullet4 = '<img src="'.$settings['images_url'].'/icons/goto.gif" alt="" border="0" style="margin:0 2px 0 0;" />';
    $bullet5 = '<img src="'.$settings['images_url'].'/icons/module2.gif" alt="" border="0" style="margin:0 2px 0 0;" />';

echo'
<div style="font-family: verdana, arial, sans-serif;">';

   // members stats
            echo '
                 <img src="'.$settings['images_url'].'/icons/members.gif" style="margin: 0;" align="bottom" alt="" />
                 <a href="'.$scripturl.'?action=mlist"><b>','Members','</b></a>
                 <br />'.$bullet,'Total Members',': ' , isset($modSettings['memberCount']) ? $modSettings['memberCount'] : $modSettings['totalMembers'] , '
                 <br />'.$bullet,'Latest',': <a href="', $scripturl, '?action=profile;u=', $modSettings['latestMember'], '"><b>', $modSettings['latestRealName'], '</b></a>';

global $db_prefix,$modSettings;
$today = strtotime("24 hours ago");
date('j') == 1 ? $thismonth = $today : $thismonth = strtotime(date('F') . ' 1');
date('l') == 'Sunday' ? $thisweek = $today : $thisweek = strtotime('last Sunday');
date('M') == 'January' ? $thisyear = $thismonth : $thisyear = strtotime('January 1');
$query = db_query("SELECT
COUNT(dateRegistered > $thisyear OR NULL) as year,
COUNT(dateRegistered > $thismonth OR NULL) as month,
COUNT(dateRegistered > $thisweek OR NULL) as week,
COUNT(dateRegistered > $today OR NULL) as today
FROM {$db_prefix}members
WHERE is_activated = 1", __FILE__, __LINE__);
$row = mysql_fetch_assoc($query);

settype($row['today'], "integer");
settype($row['week'], "integer");
settype($row['month'], "integer");

echo '<br />',$bullet,'New This Month: ', $row['month'],'<br />';
echo $bullet,'New This Week: ', $row['week'],'<br />';
echo $bullet,'New Today: ', $row['today'];

   // more stats
            echo '
                  <hr /><img src="'.$settings['images_url'].'/icons/info.gif" style="margin: 0;" align="bottom" alt="" />
                 <a href="'.$scripturl.'?action=stats"><b>','Stats','</b></a>
                 <br />'.$bullet,'Total Posts',': '.$modSettings['totalMessages']. '
                                  <br />'.$bullet,'Total Topics',': '.$modSettings['totalTopics']. '
                                  <br />'.$bullet,'Most Online Today',': '.$modSettings['mostOnlineToday'].'
                                  <br />'.$bullet,'Most Online Ever',': '.$modSettings['mostOnline'].'<br />
  ('.timeformat($modSettings['mostDate']).')
  ';

   // add online users
            echo '<hr /><img src="'.$settings['images_url'].'/icons/online.gif" style="margin: 0;" align="bottom" alt="" />
                 <a href="'.$scripturl.'?action=who"><b>','Users Online','</b></a><br />';

            $online = ssi_whosOnline('array');
           echo $bullet,'Members',': '.$online['num_users'];
           echo '<br />'.$bullet,'Guests',': '.$online['guests'];
           echo '<br />'.$bullet,'Spiders: ', $online['num_spiders'];
           echo '<br />'.$bullet,'Total',': '.$online['total_users'].'<hr />
<div style="width: 100%; ' , $online['num_users']>14 ? 'height: 23ex;overflow: auto;' : '' ,'">';

      foreach($online['users'] as $user){
echo $bullet2 , $user['hidden'] ? '<i>' . $user['link'] . '</i>' : $user['link'];
echo '<br />';
echo '</div>';
                }
        echo '</div>';]]></blockdata>

</block-info>

Regards
Eddy

Thanks vbgamer,

That's got it all working again.... Just one minor tweak needed, the lines that do the COUNT query need to be altered slightly...

For example,

COUNT(dateRegistered > $today OR NULL) as today

Needs to be changed to:

COUNT(date_registered >$today OR NULL) as today

Once that is done to each of the COUNT queries it works fine...

Regards
Eddy

I'm new to ezblock and i was looking for a stats block, i was wondering if i could borrow this code.

thank you, i will let you know if i make any changes.

Question, I am using a modified version of the stats block above that only shows the following:

Members: 266
Posts: 20514
Topics: 970

However, I would like it to look like:

Members: 266
Posts: 20514 (76915
since May 12th 2005)
Topics: 970

As you might guess, I want to display both my current board post count, then in parhentesis I want to display the total including the 56401 posts from an old board we had until we shutted down for a while). However, after doing 2 hours of Google search on PHP variables and the like, I could not figure out how to echo the sum of both (the 56401 being a fixed number). I was wondering if anyone could tell me how I would do it? That might actually help me if I wanted to do something similar in the future on other forums or pages. Here is the code I have right now (not cleaned up yet):

global $context, $boarddir, $settings, $options, $scripturl, $user_info, $modSettings;


require($boarddir.'/SSI.php');

echo'
<div style="font-family: verdana, arial, sans-serif;">';

   // more stats
            echo '<b>Members</b>',': ' , isset($modSettings['memberCount']) ?

$modSettings['memberCount'] : $modSettings['totalMembers'] , '

<br /><b>Posts</b>',': '.$modSettings['totalMessages']. '
                                  <br /><b>Topics</b>',': '.$modSettings['totalTopics']. '';

Thanks in advance!