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