Testing and QA

function scorm_insert_track($userid,$scormid,$scoid,$attempt,$element,$value) {
  
 if ($track = get_record_select('scorm_scoes_track'," userid=$userid AND scormid='$scormid' AND scoid='$scoid' AND attempt='$attempt' AND element='$element'")) {
        $track->value = $value;
        $track->timemodified = time();
        $track->userid = $USER->username;
        $id = update_record('scorm_scoes_track',$track);
    } else {
         
        $track->userid = $userid;
        $track->scormid = $scormid;
 
        $track->scoid = $scoid;
        $track->attempt = $attempt;
        $track->element = $element;
        $track->value = addslashes($value);
        $track->timemodified = time();
       print_r($track);
    exit();
    $id = insert_record('scorm_scoes_track',$track);
      
    //for  new table insert code 

    // global $USER, $CFG;
       //$track=get_record('Scorm','id',$scorm->name);
    // $track=$USER->username;
    //$track->username=$uname;
    // $track->name=$sname;
    if (strstr($element, '.cmi.core.lesson_status')) {
       $scormstatus = get_record('scorm_scoes_track', 'id', $value);
   
   
    }
    print_r($scormstatus);
    exit();
    if(strstr($element,'cmi.core.score.raw')){
    $score=get_record('scorm_scoes_track', 'id', $value);
    }
   
    $track1= $scormstatus->scormstatus;
    $track1=$score->score;
    $track1=$USER->username;
    $track1->userid = $userid;
       $track1=get_record('Scorm','id',$scorm->name);
 
        $track1->scoid = $scoid;
        $track1->attempt = $attempt;
        $track1->element = $element;
        $track1->value = addslashes($value);
        $track1->timemodified = time();
   
   // $track1=array('userid','scormid','username','scormname','attempt','timemodified','score','scormstatus');
    //errorlog($track1);
    $id=insert_record('grade_report',$track1);

    
 note:   'grade_report'  new table is in moodle db it was not inserted recorded into 'grade_report'
    
  }
  
 // MDL-9552, update the gradebook everything raw score is sent
    if (strstr($element, '.score.raw')) {
        $scorm = get_record('scorm', 'id', $scormid);
              
    include_once('lib.php');
        scorm_update_grades($scorm, $userid);   
    }
   
    return $id;
}