chamilo / chamilo-lms

            $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

            // 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

                            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);

                    }

                }

            }

        }