General developer forum

Hi All,

Somehow i find out way to prevent multiple login with same id.

Below are Steps to follows:

Step 1:

Create Table in Moodle database

SELECT c.fullname Course_Name,sc.name as Assessment_Title,st.attempt Attempt, st.VALUE,FROM_UNIXTIME(st.timemodified,"%m-%d-%Y") Attempt_Date,FROM_UNIXTIME(mcc.timecompleted,"%m-%d-%Y") Completion_Date,

(CASE WHEN mcc.timecompleted IS NULL THEN 'Not Completed' ELSE 'Completed'

END) AS 'status'

FROM mdl_course_completions mcc

JOIN mdl_course AS c ON c.id=mcc.course

JOIN mdl_scorm AS sc ON sc.course=c.id

JOIN mdl_user AS u

JOIN mdl_scorm_scoes_track AS st on st.scormid = sc.id AND st.userid = u.id

============================================================================

Step 2: 

Add Below code into file lib.php of your theme directory.

function theme_klass_page_init(moodle_page $page) {

    global $DB, $CFG, $SESSION, $USER;

    $userid = $USER->id;

    $sessKey = $USER->sesskey;

    $rs = $DB->get_record_sql("SELECT count(*)AS count FROM `mdl_sessions` WHERE `userid` = '" . $userid . "'");

    echo "count===><br>";

    echo $rs->count;

    echo "<br>user id===><br>";

    echo $userid;

    if ($userid != 0) {

        if ($rs->count > 1) {

            echo "inside";//die('kasjhfskja');

            //if user login from another browser we have to logout that old user

             //$CFG->logoutredirect;

            $var =  $CFG->wwwroot."/login/logout.php?sesskey=".$sessKey;

            header( 'Location: ' . $var );

        }

    }

    $page->requires->jquery();

    $page->requires->jquery_plugin('migrate');

    $page->requires->js('/theme/klass/javascript/theme.js');

}