chamilo / chamilo-lms

                            attendance_id = '$attendance_id' ";

                $rs_check_result = Database::query($sql);

                if (Database::num_rows($rs_check_result) > 0) {

                    // update result

                    $sql = "UPDATE $tbl_attendance_result SET

                            score = '$count_presences'

                            WHERE

                                c_id = $course_id AND

                                user_id='$uid' AND

                                attendance_id='$attendance_id'";

                    Database::query($sql);

                } else {

                    // insert new result

                    $sql = "INSERT INTO $tbl_attendance_result SET

                            c_id = $course_id ,

                            user_id			= '$uid',

                            attendance_id 	= '$attendance_id',

                            score			= '$count_presences'";

                    Database::query($sql);

                    $insertId = Database::insert_id();

                    if ($insertId) {

                        $sql = "UPDATE $tbl_attendance_result SET id = iid WHERE iid = $insertId";

                        Database::query($sql);

                    }

                }

            }

        }

                    session_id = $session_id ";

        $result = Database::query($sql);

        if (Database::num_rows($result)) {

            $view = Database::fetch_array($result, 'ASSOC');

            $lp_view_id = $view['id'];

            $sql = "DELETE FROM $lp_item_view_table

                    WHERE c_id = $course_id AND lp_view_id = $lp_view_id ";

            Database::query($sql);

            $sql = "DELETE FROM $lpInteraction

                    WHERE c_id = $course_id AND lp_iv_id = $lp_view_id ";

            Database::query($sql);

            $sql = "DELETE FROM $lpObjective

                    WHERE c_id = $course_id AND lp_iv_id = $lp_view_id ";

            Database::query($sql);

        }

        $sql = "DELETE FROM $lp_view_table

            WHERE