IN locallib.php i added this code in 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();
$id = insert_record('scorm_scoes_track',$track);
My COde:i want retrive same values from scorm_scoes_track table then i added five field extra
so i want insert into
if (strstr($element, '.cmi.core.lesson_status')) {
$scormstatus = get_record('scorm_scoes_track', 'id', $value);
}
if(strstr($element,'cmi.core.score.raw')){
$score=get_record('scorm_scoes_track', 'id', $value);
}
$track1 = new stdClass;
$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');
$id=insert_record('grade_report',$track1);