Support » Plugin: Namaste! LMS » How to Restrict to Complete Lessons?

  • Resolved sanketzalak


    Hi, Sorry But I am Again Here….

    I want to Restrict Students to Complete Only 1 Lesson Per Day, Can you help me with some scratch code?

    I have tried as Follows :
    Query : $mydate = $wpdb->get_var( “SELECT completion_date FROM wp_namaste_student_lessons WHERE lesson_id=’$prepost'” // 2013-09-30

    $pfx_date = get_the_date( $d ); //Current Date 2013-10-01

    $datetime1 = $mydate;
    $datetime2 = $pfx_date;
    $interval = $datetime1->diff($datetime2);
    echo $interval->format(‘%R%a days’);

    But got error that First Value should be DateTime.

    What to Do Now?


Viewing 7 replies - 1 through 7 (of 7 total)
  • I want to Restrict Students to Complete Only 1 Lesson Per Day, How?

    Plugin Author prasunsen


    You’d better do this:

    $exists = $wpdb->get_var(“SELECT id FROM wp_namaste_student_lessons WHERE lesson_id=’$prepost’ AND completion_date=CURDATE() and student_id=’$user_ID'”);

    if($exists) – means that the student already has a completed lesson today.

    How to Get Previous Lesson Id of Same Course, Out of Multiple Courses? If I tried to Get Previous Post Id it takes Garbage Values Some time.

    I have Logic, On Loading of the Lesson If we check previous lesson completion date and compare with current date we can redirect user or display error message.

    Required Fields/ Values :
    1. Current Date
    2. Previous Lesson Id
    3. Completion Date of Previous Lesson Id which is Required Value of point 2.

    Plugin Author prasunsen


    You need to join by wp_post_meta table to find the course ID

    There is a Function in to Short Code of Namaste LMS, Called // selects the previous lesson in the course if any. Can we use its query or Mechanism for Getting previous lesson details


    Previous Lesson Completed on which date?
    Previous Lesson Id?

    Plugin Author prasunsen


    yes, you can

    Done with if($exists).

    My Suggestion : Should Add Per Day Lesson Limitation or Pass Control into this Plugin.
    1. No User / Student is Capable to Complete Course in Shorter Time then it will take.
    2. Limit Less Per Day Lessons into Course will end as Confusing or No Result.
    3. Last – All School & Universities require some 60% Attendance, so this Limiting also Solve attendance problem.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘How to Restrict to Complete Lessons?’ is closed to new replies.