Статистика Jot

$today = getdate();
$m=date("t");
$tstart = mktime(0,0,0,$today['mon'],$today['mday'],$today['year']);
$tend = $tstart + $m*24*3600;

$today = getdate();
$m=idate("t");
$tstart = mktime(0,0,0,$today['mon'],1,$today['year']);
$tend = $tstart + $m*24*3600;

$output = '';


$table = $modx->getFullTableName( 'jot_content' );
//-------------Всего комментариев---------------------------------------
$result = $modx->db->query("SELECT * FROM ".$table." WHERE published='1'");
$total_rows = $modx->db->getRecordCount( $result );
echo '<b>Всего комментариев</b>--------<span class="stat">'.$total_rows.'</span><br>';
//----------------------------------------------------------------------
//-------------Сегодня---------------------------------------
$today = getdate();
$tstart = mktime(0,0,0,$today['mon'],$today['mday'],$today['year']);
$tend = $tstart + 24*3600;
$table = $modx->getFullTableName( 'jot_content' );
$result = $modx->db->query("SELECT count(*) as count FROM ".$table." jc WHERE jc.published='1' and jc.createdon>=".$tstart." and jc.createdon<=".$tend."");
if ($row= $modx->db->getRow( $result ))
{
echo "<b>Комменариев сегодня</b>--------<span class='stat'>".$row['count']."</span><br>";
}
//----------------------------------------------------------------------
//-------------За месяц---------------------------------------
$today = getdate();
$m=idate("t");
$tstart = mktime(0,0,0,$today['mon'],1,$today['year']);
$tend = $tstart + $m*24*3600;
$table = $modx->getFullTableName( 'jot_content' );
$result = $modx->db->query("SELECT count(*) as count FROM ".$table." jc WHERE jc.published='1' and jc.createdon>=".$tstart." and jc.createdon<=".$tend."");
if ($row= $modx->db->getRow( $result ))
{
echo "<b>Комменариев за месяц</b>--------<span class='stat'>".$row['count']."</span><br>";
}
//----------------------------------------------------------------------