if ($sys_database_type == 'mysql') { $sql .= "SELECT ranking,100-(100*((ranking-1)/{$counts})),group_id "; } else { $sql .= "SELECT ranking,100-(100*((ranking::float-1)/{$counts})),group_id "; } $sql .= "\nFROM project_metric_weekly_tmp1\nORDER BY ranking ASC"; $rel = db_query($sql); if (!$rel) { $err .= "\n\n***ERROR: {$sql}\n\n" . db_error(); } // // Now archive the metric // db_query("DELETE FROM stats_project_metric WHERE month='{$this_year}{$this_month}' AND day='{$this_day}'"); $sql = "INSERT INTO stats_project_metric (month,day,group_id,ranking,percentile) "; if ($sys_database_type == 'mysql') { $sql .= "SELECT '{$this_year}{$this_month}', '{$this_day}',group_id,ranking,percentile "; } else { $sql .= "SELECT '{$this_year}{$this_month}'::int, '{$this_day}'::int,group_id,ranking,percentile "; } $sql .= "\n\tFROM project_weekly_metric"; $rel = db_query($sql); if (!$rel) { $err .= "\n\n***ERROR: {$sql}\n\n" . db_error(); } $err .= db_error(); db_drop_sequence_if_exists("project_metric_weekly_seq"); db_drop_table_if_exists("project_counts_weekly_tmp"); db_drop_table_if_exists("project_metric_weekly_tmp1"); db_drop_sequence_if_exists("project_metric_week_ranking_seq"); cron_entry(8, $err);
if (!$res || db_affected_rows($res) < 1) { $err .= "Error in round {$i} setting importance factor: "; $err .= '<p>' . $sql . '<p>'; $err .= db_error(); exit; } } } db_commit(); db_query("DELETE FROM user_metric;"); db_query("INSERT INTO user_metric SELECT * FROM user_metric" . ($i - 1) . ";"); //$err .= '<p>'.db_error().'<p>'; /* Now run through and drop the tmp tables */ // $err .= "<p>Cleaning up tables<p>"; for ($i = 1; $i < 9; $i++) { db_drop_table_if_exists("user_metric_tmp1_" . $i); db_drop_sequence_if_exists("user_metric_tmp1_" . $i . "_ranking_seq"); db_drop_table_if_exists("user_metric" . $i); } $err .= db_error(); $t = time(); $ts_month = date('Ym', $t); $ts_day = date('d', $t); db_begin(); db_query("DELETE FROM user_metric_history WHERE month='{$ts_month}' AND day='{$ts_day}'"); db_query("\n\tINSERT INTO user_metric_history\n\tSELECT '{$ts_month}','{$ts_day}',user_id,ranking,metric\n\tFROM user_metric\n"); $err .= db_error(); cron_entry(1, $err); db_commit();