Index: casetracker.module
===================================================================
RCS file: /cvs/drupal/contributions/modules/casetracker/casetracker.module,v
retrieving revision 1.68.2.2
diff -u -r1.68.2.2 casetracker.module
--- casetracker.module	5 Sep 2006 16:57:02 -0000	1.68.2.2
+++ casetracker.module	29 Nov 2006 18:12:55 -0000
@@ -1203,7 +1203,7 @@
     '#collapsible' => FALSE,
     '#collapsed' => TRUE);
   $result = db_query("SELECT * FROM {%s}", $table);
-  while ($row = mysql_fetch_array($result)) {
+  while ($row = db_fetch_array($result)) {
     $field_values[$row['0']] = $row['1'];
   }
   $form['casetracker_edit_form']['casetracker_old_values'] = array(
@@ -1649,7 +1649,7 @@
   switch($op) {
     case 'insert':
       db_query("INSERT INTO {casetracker_comment} (cid) values(%d)", $comment['cid']);
-      $sid = mysql_insert_id();
+      $sid = db_next_id('casetracker_comment_status');
       db_query("INSERT INTO {casetracker_comment_status} (sid, project_term_id, assign_to, case_priority_id, case_type_id, case_status_id, state, title)
    VALUES(%d, %d, '%d', %d, %d, '%d', %d, '%s')", $sid, $data['old']->p_id, $data['old']->assign_to, $data['old']->case_priority_id, $data['old']->case_type_id, $data['old']->case_status_id, 0, $data['old']->case_title );
       db_query("INSERT INTO {casetracker_comment_status} (sid, project_term_id, assign_to, case_priority_id, case_type_id, case_status_id, state, title)
@@ -2559,7 +2559,7 @@
   array('data' => t('Case state realm')));
   $result = db_query("SELECT * FROM {casetracker_case_states}");
   $result1 = db_query("select distinct case_state_realm from {casetracker_case_states}");
-  while ($row1 = mysql_fetch_array($result1)) {
+  while ($row1 = db_fetch_array($result1)) {
     $field_values[$row1['case_state_realm']] = $row1['case_state_realm'];
   }
   $form = array();
@@ -2637,7 +2637,7 @@
     '#default_value' => '',
     '#size' => 40);
   $result = db_query("select distinct case_state_realm from {casetracker_case_states}");
-  while ($row = mysql_fetch_array($result)) {
+  while ($row = db_fetch_array($result)) {
     $field_values[$row['case_state_realm']] = $row['case_state_realm'];
   }
   $form['casetracker_state']['casetracker_state_realm'] = array(