Hi all,
I need to generate total registered user statistics in the main page(header or footer). I find in this forum a code like this:
"Not an answer, but on the front page - in that part (of your theme) header.html - you could insert:
<?php echo " <i><font size=-1 color=green>already<font color=red>$usercount</font>Moodle users on this site</font></i>";?>"
but, it doesnt help it seems like this code doesnt work.
If someone knows any code like this please help.
Thanks a lot.
Fazil.
Thank you for your answer. But that code doesnt work, I think here is mistake:
<?php
# get the full directory name of where moodle is installed
$moodle_dir = dirname(dirname(__FILE__));
# include the config.php file
require_once($moodle_dir.'/config.php');
#connect database
$dbconnect=mysql_connect ("$CFG->dbhost", "$CFG->dbuser", "$CFG->dbpass");
mysql_select_db ("$CFG->dbname") or die ("Could not connect!");
#select table 'user'
$dbtable = $CFG->prefix . 'user';
#data selection
$query= 'SELECT * FROM ' . $dbtable;
$result = mysql_query($query);
$rows = mysql_num_rows($result);
#data output
echo 'Moodle users on this site: ' . $rows;
#close connection
mysql_close($dbconnect);
?>
Because the cod seems to end at that bold stage. Itried to correct it but cant when I place this code to header the page doesnt open correctly.
Fazil.
Dietmar,
Your code does not work. Actually it can be done in 1 line only!
The following will work (tested on moodle 1.9.11 and the stardard theme) Insert the line in blue in your the footer.html file of your current site's theme. Might be slightly different in other themes.
<?php }
echo $loggedinas;
echo $homelink;
echo 'Moodle users on this site: ' . count_records_sql("SELECT COUNT(*) FROM ".$CFG->prefix . 'user'." WHERE deleted = 0 AND confirmed = 1");
if (!empty($performanceinfo)) {
echo $performanceinfo;
}
Joseph
EDIT.- You had already posted your new code while I was trying out a new solution! Fazil had mentioned he was using moodle 1.9.
