chamilo / chamilo-lms

            // calculates time

            if ($count_row_lp > 0) {

                while ($row_lp = Database::fetch_array($res_row_lp)) {

                    $lp_id = intval($row_lp['id']);

                    $sql = 'SELECT SUM(total_time)

                            FROM '.$t_lpiv.' AS item_view

                            INNER JOIN '.$t_lpv.' AS view

                            ON (

                                item_view.lp_view_id = view.id AND 

                                item_view.c_id = view.c_id

                            )

                            WHERE

                                item_view.c_id = '.$course_id.' AND

                                view.c_id = '.$course_id.' AND

                                view.lp_id = '.$lp_id.' AND 

                                view.user_id = '.$student_id.' AND

                                session_id = '.$session_id;

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

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

                        $total_time += Database :: result($rs, 0, 0);

                    }

                }

            $sql = 'SELECT survey_id FROM ' . $table_course_survey . ' WHERE course_code="' . $codeFiltered . '"';

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

            while ($surveys = Database::fetch_array($result_surveys)) {

                $survey_id = $surveys[0];

                $sql = 'DELETE FROM ' . $table_course_survey_question . ' WHERE survey_id="' . $survey_id . '"';

                Database::query($sql);

                $sql = 'DELETE FROM ' . $table_course_survey_question_option . ' WHERE survey_id="' . $survey_id . '"';

                Database::query($sql);

                $sql = 'DELETE FROM ' . $table_course_survey . ' WHERE survey_id="' . $survey_id . '"';

                Database::query($sql);

            }

            // Delete the course from the stats tables

            $sql = "DELETE FROM $table_stats_hotpots WHERE c_id = $courseId";