WordPress.org

Support

Support » Plugins and Hacks » [Resolved] How to Restrict User Visit on Lesson?

[Resolved] How to Restrict User Visit on Lesson?

  • sanketzalak

    @sanketzalak

    I want to Restrict Users to Total Visit Per Lesson 5 Times?

    How can I do that?

    With This WP Query, I can get the Total Visits.
    $myset = $wpdb->get_results( “SELECT visits FROM wp_namaste_visitsWHEREuser_id=’$u_id’ ANDlesson_id=’$postid'” );

    with ‘echo print_r($myset);’

    Output is as Require.

    Array
    (
        [0] => stdClass Object
            (
                [visits] => 1
            )
    
        [1] => stdClass Object
            (
                [visits] => 7
            )
    
        [2] => stdClass Object
            (
                [visits] => 62
            )
    
    )

    Now What I can’t Solve is How to Sum – All Values Got from Query?

    If (sum of visits <= 5)
    			{
    			// Do This
    			|
    			else
    			{
    			//
    			}
    		}

    http://wordpress.org/plugins/namaste-lms/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author prasunsen

    @prasunsen

    There is one record for each date, so you need a SUM() query.

    sanketzalak

    @sanketzalak

    May Be it’s what I look for, My Basic Requirement is to Check that if User have access the lesson less than five times if condition triggers.

    Or if User have access the lesson more than five times else part of condition will be triggered.

    No Matter for How Many Days user takes.

    Thanks

    sanketzalak

    @sanketzalak

    @prasunsen : Ok, Sir the Query is Solved as per Your Suggestion.

    Thanks . . . .

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘[Resolved] How to Restrict User Visit on Lesson?’ is closed to new replies.