<?php
function check()  {
    $db = mysql_connect("localhost", 'monkey_dbuser', 'xrWill0');
    mysql_select_db("monkey_monkeyquiz",$db);
    
    $result = mysql_query("SELECT day_of_month FROM current_day");
    if ($myrow = mysql_fetch_row($result)) {
        if ($myrow[0] != (int)date('d')) {

            $result = mysql_query("SELECT AVG(life), AVG(mind), AVG(body), AVG(spirit), AVG(friends), AVG(love), AVG(finance), COUNT(*) FROM life_results WHERE life != -1 AND mind != -1 AND body != -1 AND spirit != -1 AND friends != -1 AND love != -1 AND finance != -1");
            if ($row = mysql_fetch_row($result)) {
                mysql_query('UPDATE stats_calc SET value = '. $row[0] .' WHERE stats_calc_id = 1');
                mysql_query('UPDATE stats_calc SET value = '. $row[1] .' WHERE stats_calc_id = 2');
                mysql_query('UPDATE stats_calc SET value = '. $row[2] .' WHERE stats_calc_id = 3');
                mysql_query('UPDATE stats_calc SET value = '. $row[3] .' WHERE stats_calc_id = 4');
                mysql_query('UPDATE stats_calc SET value = '. $row[4] .' WHERE stats_calc_id = 5');
                mysql_query('UPDATE stats_calc SET value = '. $row[5] .' WHERE stats_calc_id = 6');
                mysql_query('UPDATE stats_calc SET value = '. $row[6] .' WHERE stats_calc_id = 7');
                mysql_query('UPDATE stats_numbers SET number_count = '. $row[7] .' WHERE stats_numbers_id = 1');
            }

            $result = mysql_query("SELECT a.name, a.disp_order, AVG(b.life) FROM life_results b, gender a WHERE a.gender_id=b.gender_id AND b.life != -1 GROUP BY a.name, a.disp_order ORDER BY a.disp_order");
            if ($row = mysql_fetch_row($result))
                mysql_query('UPDATE stats_calc SET value = '. $row[2] .' WHERE stats_calc_id = 8');
            if ($row = mysql_fetch_row($result))
                mysql_query('UPDATE stats_calc SET value = '. $row[2] .' WHERE stats_calc_id = 9');

            $result = mysql_query("SELECT a.name, a.disp_order, AVG(b.mind) FROM life_results b, gender a WHERE a.gender_id=b.gender_id AND b.mind != -1 GROUP BY a.name, a.disp_order ORDER BY a.disp_order");
            if ($row = mysql_fetch_row($result))
                mysql_query('UPDATE stats_calc SET value = '. $row[2] .' WHERE stats_calc_id = 10');
            if ($row = mysql_fetch_row($result))
                mysql_query('UPDATE stats_calc SET value = '. $row[2] .' WHERE stats_calc_id = 11');

            $result = mysql_query("SELECT a.name, a.disp_order, AVG(b.body) FROM life_results b, gender a WHERE a.gender_id=b.gender_id AND b.body != -1 GROUP BY a.name, a.disp_order ORDER BY a.disp_order");
            if ($row = mysql_fetch_row($result))
                mysql_query('UPDATE stats_calc SET value = '. $row[2] .' WHERE stats_calc_id = 12');
            if ($row = mysql_fetch_row($result))
                mysql_query('UPDATE stats_calc SET value = '. $row[2] .' WHERE stats_calc_id = 13');

            $result = mysql_query("SELECT a.name, a.disp_order, AVG(b.spirit) FROM life_results b, gender a WHERE a.gender_id=b.gender_id AND b.spirit != -1 GROUP BY a.name, a.disp_order ORDER BY a.disp_order");
            if ($row = mysql_fetch_row($result))
                mysql_query('UPDATE stats_calc SET value = '. $row[2] .' WHERE stats_calc_id = 14');
            if ($row = mysql_fetch_row($result))
                mysql_query('UPDATE stats_calc SET value = '. $row[2] .' WHERE stats_calc_id = 15');

            $result = mysql_query("SELECT a.name, a.disp_order, AVG(b.friends) FROM life_results b, gender a WHERE a.gender_id=b.gender_id AND b.friends != -1 GROUP BY a.name, a.disp_order ORDER BY a.disp_order");
            if ($row = mysql_fetch_row($result))
                mysql_query('UPDATE stats_calc SET value = '. $row[2] .' WHERE stats_calc_id = 16');
            if ($row = mysql_fetch_row($result))
                mysql_query('UPDATE stats_calc SET value = '. $row[2] .' WHERE stats_calc_id = 17');

            $result = mysql_query("SELECT a.name, a.disp_order, AVG(b.love) FROM life_results b, gender a WHERE a.gender_id=b.gender_id AND b.love != -1 GROUP BY a.name, a.disp_order ORDER BY a.disp_order");
            if ($row = mysql_fetch_row($result))
                mysql_query('UPDATE stats_calc SET value = '. $row[2] .' WHERE stats_calc_id = 18');
            if ($row = mysql_fetch_row($result))
                mysql_query('UPDATE stats_calc SET value = '. $row[2] .' WHERE stats_calc_id = 19');

            $result = mysql_query("SELECT a.name, a.disp_order, AVG(b.finance) FROM life_results b, gender a WHERE a.gender_id=b.gender_id AND b.finance != -1 GROUP BY a.name, a.disp_order ORDER BY a.disp_order");
            if ($row = mysql_fetch_row($result))
                mysql_query('UPDATE stats_calc SET value = '. $row[2] .' WHERE stats_calc_id = 20');
            if ($row = mysql_fetch_row($result))
                mysql_query('UPDATE stats_calc SET value = '. $row[2] .' WHERE stats_calc_id = 21');

            $result = mysql_query("SELECT a.name, a.disp_order, COUNT(*) FROM life_results b, gender a WHERE a.gender_id=b.gender_id GROUP BY a.name, a.disp_order ORDER BY a.disp_order");
            if ($row = mysql_fetch_row($result))
                mysql_query('UPDATE stats_numbers SET number_count = '. $row[2] .' WHERE stats_numbers_id = 2');
            if ($row = mysql_fetch_row($result))
                mysql_query('UPDATE stats_numbers SET number_count = '. $row[2] .' WHERE stats_numbers_id = 3');

            $num = 22;
            $result = mysql_query("SELECT a.name, a.disp_order, AVG(b.life) FROM life_results b, age_group a WHERE a.age_group_id=b.age_group_id AND b.life != -1 GROUP BY a.name, a.disp_order ORDER BY a.disp_order");
            while ($row = mysql_fetch_row($result)) {
                mysql_query('UPDATE stats_calc SET value = '. $row[2] .' WHERE stats_calc_id = '. $num);
                $num++;
            }

            $num = 28;
            $result = mysql_query("SELECT a.name, a.disp_order, AVG(b.mind) FROM life_results b, age_group a WHERE a.age_group_id=b.age_group_id AND b.mind != -1 GROUP BY a.name, a.disp_order ORDER BY a.disp_order");
            while ($row = mysql_fetch_row($result)) {
                mysql_query('UPDATE stats_calc SET value = '. $row[2] .' WHERE stats_calc_id = '. $num);
                $num++;
            }

            $num = 34;
            $result = mysql_query("SELECT a.name, a.disp_order, AVG(b.body) FROM life_results b, age_group a WHERE a.age_group_id=b.age_group_id AND b.body != -1 GROUP BY a.name, a.disp_order ORDER BY a.disp_order");
            while ($row = mysql_fetch_row($result)) {
                mysql_query('UPDATE stats_calc SET value = '. $row[2] .' WHERE stats_calc_id = '. $num);
                $num++;
            }

            $num = 40;
            $result = mysql_query("SELECT a.name, a.disp_order, AVG(b.spirit) FROM life_results b, age_group a WHERE a.age_group_id=b.age_group_id AND b.spirit != -1 GROUP BY a.name, a.disp_order ORDER BY a.disp_order");
            while ($row = mysql_fetch_row($result)) {
                mysql_query('UPDATE stats_calc SET value = '. $row[2] .' WHERE stats_calc_id = '. $num);
                $num++;
            }

            $num = 46;
            $result = mysql_query("SELECT a.name, a.disp_order, AVG(b.friends) FROM life_results b, age_group a WHERE a.age_group_id=b.age_group_id AND b.friends != -1 GROUP BY a.name, a.disp_order ORDER BY a.disp_order");
            while ($row = mysql_fetch_row($result)) {
                mysql_query('UPDATE stats_calc SET value = '. $row[2] .' WHERE stats_calc_id = '. $num);
                $num++;
            }

            $num = 52;
            $result = mysql_query("SELECT a.name, a.disp_order, AVG(b.love) FROM life_results b, age_group a WHERE a.age_group_id=b.age_group_id AND b.love != -1 GROUP BY a.name, a.disp_order ORDER BY a.disp_order");
            while ($row = mysql_fetch_row($result)) {
                mysql_query('UPDATE stats_calc SET value = '. $row[2] .' WHERE stats_calc_id = '. $num);
                $num++;
            }
            
            $num = 58;
            $result = mysql_query("SELECT a.name, a.disp_order, AVG(b.finance) FROM life_results b, age_group a WHERE a.age_group_id=b.age_group_id AND b.finance != -1 GROUP BY a.name, a.disp_order ORDER BY a.disp_order");
            while ($row = mysql_fetch_row($result)) {
                mysql_query('UPDATE stats_calc SET value = '. $row[2] .' WHERE stats_calc_id = '. $num);
                $num++;
            }

            $num = 4;
            $result = mysql_query("SELECT a.name, a.disp_order, COUNT(*) FROM life_results b, age_group a WHERE a.age_group_id=b.age_group_id GROUP BY a.name, a.disp_order ORDER BY a.disp_order");
            while ($row = mysql_fetch_row($result)) {
                mysql_query('UPDATE stats_numbers SET number_count = '. $row[2] .' WHERE stats_numbers_id = '. $num);
                $num++;
            }
        }
        mysql_query("UPDATE current_day set day_of_month = ". (int)date('d'));
    }
    mysql_close();
}
?>