statistieken scriptje.

<?PHP
// CONTROLE CRONJOB
if($_GET['cronpass'] != "somepassword here") {
exit;
} else {}

include('../../includes/db.inc.php');

// TIJD
	$tijd = time();

// AANTAL BERICHTEN IN SYSTEEM //
	$msg_prive = mysql_num_rows(mysql_query("SELECT id FROM dt_pm WHERE prive = '1'"));
	$msg_public = mysql_num_rows(mysql_query("SELECT id FROM dt_pm WHERE prive = '0'"));

	$msg_gelezen = mysql_num_rows(mysql_query("SELECT id FROM dt_pm WHERE gezien = '1'"));
	$msg_ongelezen = mysql_num_rows(mysql_query("SELECT id FROM dt_pm WHERE gezien = '0'"));

	$msg_total = $msg_prive + $msg_public;


// AANTAL FORUM TOPICS / POSTS
	$forum_topics = mysql_num_rows(mysql_query("SELECT id FROM dt_topic"));
	$forum_posts = mysql_num_rows(mysql_query("SELECT id FROM dt_posts"));

// AANTAL SHOUTS
	$shout_total = mysql_num_rows(mysql_query("SELECT id FROM shoutbalk"));

// INVOEREN DATABASE 
	mysql_query("INSERT INTO statistieken (id, datum, berichten, berichten_prive, berichten_publiek, berichten_gelezen, berichten_ongelezen, forum_topics, forum_posts) VALUES ('', '".$tijd."', '".$msg_total."', '".$msg_prive."', '".$msg_public."', '".$msg_gelezen."', '".$msg_ongelezen."', '".$forum_topics."', '".$forum_posts."')");

?>

<?PHP
// CONTROLE CRONJOB
if($_GET['cronpass'] != "somepassword here") {
exit;
} else {}
 
include('../../includes/db.inc.php');
 
// TIJD
	$tijd = time();
 
// AANTAL BERICHTEN IN SYSTEEM //
	$msg_prive = mysql_num_rows(mysql_query("SELECT id FROM dt_pm WHERE prive = '1'"));
	$msg_public = mysql_num_rows(mysql_query("SELECT id FROM dt_pm WHERE prive = '0'"));
 
	$msg_gelezen = mysql_num_rows(mysql_query("SELECT id FROM dt_pm WHERE gezien = '1'"));
	$msg_ongelezen = mysql_num_rows(mysql_query("SELECT id FROM dt_pm WHERE gezien = '0'"));
 
	$msg_total = $msg_prive + $msg_public;
 
 
// AANTAL FORUM TOPICS / POSTS
	$forum_topics = mysql_num_rows(mysql_query("SELECT id FROM dt_topic"));
	$forum_posts = mysql_num_rows(mysql_query("SELECT id FROM dt_posts"));
 
// AANTAL SHOUTS
	$shout_total = mysql_num_rows(mysql_query("SELECT id FROM shoutbalk"));
 
// INVOEREN DATABASE 
	mysql_query("INSERT INTO statistieken (id, datum, berichten, berichten_prive, berichten_publiek, berichten_gelezen, berichten_ongelezen, forum_topics, forum_posts) VALUES ('', '".$tijd."', '".$msg_total."', '".$msg_prive."', '".$msg_public."', '".$msg_gelezen."', '".$msg_ongelezen."', '".$forum_topics."', '".$forum_posts."')");
 
?>

CREATE TABLE `statistieken` (
  `id` int(11) NOT NULL auto_increment,
  `datum` varchar(10) NOT NULL default '',
  `berichten` int(11) NOT NULL default '0',
  `berichten_prive` int(11) NOT NULL default '0',
  `berichten_publiek` int(11) NOT NULL default '0',
  `berichten_gelezen` int(11) NOT NULL default '0',
  `berichten_ongelezen` int(11) NOT NULL default '0',
  `forum_topics` int(11) NOT NULL default '0',
  `forum_posts` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

CREATE TABLE `statistieken` (
  `id` int(11) NOT NULL auto_increment,
  `datum` varchar(10) NOT NULL default '',
  `berichten` int(11) NOT NULL default '0',
  `berichten_prive` int(11) NOT NULL default '0',
  `berichten_publiek` int(11) NOT NULL default '0',
  `berichten_gelezen` int(11) NOT NULL default '0',
  `berichten_ongelezen` int(11) NOT NULL default '0',
  `forum_topics` int(11) NOT NULL default '0',
  `forum_posts` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;