handler.php File Reference

Go to the source code of this file.

Namespaces
namespace	MythWeb
Variables
	$where = ' WHERE 1'
	$limit = 'LIMIT 10'
	$sh = $db->query('SELECT DISTINCT title FROM oldrecorded'.$where)
	$title_count = $sh->num_rows()
	$show_count
	$first
	$last
	$time
	exit

---

Variable Documentation

$where = ' WHERE 1'

Definition at line 24 of file stats/handler.php.

Referenced by if().

$limit = 'LIMIT 10'

Definition at line 35 of file stats/handler.php.

$sh = $db->query('SELECT DISTINCT title FROM oldrecorded'.$where)

Definition at line 47 of file stats/handler.php.

$title_count = $sh->num_rows()

Definition at line 48 of file stats/handler.php.

$show_count

Initial value:

 $db->query_col('SELECT COUNT(title)
                                    FROM oldrecorded '.$where)

Definition at line 52 of file stats/handler.php.

$first

Initial value:

 $db->query_col('SELECT UNIX_TIMESTAMP(starttime)
                               FROM oldrecorded '.$where
                        .' ORDER BY starttime ASC LIMIT 1')

Definition at line 56 of file stats/handler.php.

$last

Initial value:

 $db->query_col('SELECT UNIX_TIMESTAMP(endtime)
                              FROM oldrecorded '.$where
                       .' ORDER BY endtime DESC LIMIT 1')

Definition at line 61 of file stats/handler.php.

$time

Initial value:

 $db->query_col('SELECT SUM(UNIX_TIMESTAMP(endtime) - UNIX_TIMESTAMP(starttime))
                              FROM oldrecorded '
                         .$where.' AND endtime > starttime')

Definition at line 66 of file stats/handler.php.

exit

Definition at line 100 of file stats/handler.php.