chamilo / chamilo-lms

                WHERE c_id = $course_id AND ".$groupfilter.$condition_session."";

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

        while ($row = Database::fetch_array($allpages)) {

            $total_words = $total_words + self::word_count($row['content']);

            $total_links = $total_links + substr_count($row['content'], "href=");

            $total_links_anchors = $total_links_anchors + substr_count($row['content'], 'href="#');

            $total_links_mail = $total_links_mail + substr_count($row['content'], 'href="mailto');

            $total_links_ftp = $total_links_ftp + substr_count($row['content'], 'href="ftp');

            $total_links_irc = $total_links_irc + substr_count($row['content'], 'href="irc');

            $total_links_news = $total_links_news + substr_count($row['content'], 'href="news');

            $total_wlinks = $total_wlinks + substr_count($row['content'], "[[");

            $total_images = $total_images + substr_count($row['content'], "<img");

            $clean_total_flash = preg_replace('/player.swf/', ' ', $row['content']);

            $total_flash = $total_flash + substr_count($clean_total_flash, '.swf"');

            //.swf" end quotes prevent insert swf through flvplayer (is not counted)

            $total_mp3 = $total_mp3 + substr_count($row['content'], ".mp3");

            $total_flv_p = $total_flv_p + substr_count($row['content'], ".flv");

            $total_flv = $total_flv_p / 5;

            $total_youtube = $total_youtube + substr_count($row['content'], "http://www.youtube.com");

            $total_multimedia = $total_multimedia + substr_count($row['content'], "video/x-msvideo");

            $total_tables = $total_tables + substr_count($row['content'], "<table");

        }

        // Check only last version of all pages (current page)

        $sql = ' SELECT *, COUNT(*) AS TOTAL_PAGES, SUM(hits) AS TOTAL_VISITS_LV

                )';

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

        while ($row = Database::fetch_array($allpages)) {

            $total_words_lv = $total_words_lv + self::word_count($row['content']);

            $total_links_lv = $total_links_lv + substr_count($row['content'], "href=");

            $total_links_anchors_lv = $total_links_anchors_lv + substr_count($row['content'], 'href="#');

            $total_links_mail_lv = $total_links_mail_lv + substr_count($row['content'], 'href="mailto');

            $total_links_ftp_lv = $total_links_ftp_lv + substr_count($row['content'], 'href="ftp');

            $total_links_irc_lv = $total_links_irc_lv + substr_count($row['content'], 'href="irc');

            $total_links_news_lv = $total_links_news_lv + substr_count($row['content'], 'href="news');

            $total_wlinks_lv = $total_wlinks_lv + substr_count($row['content'], "[[");

            $total_images_lv = $total_images_lv + substr_count($row['content'], "<img");

            $clean_total_flash_lv = preg_replace('/player.swf/', ' ', $row['content']);

            $total_flash_lv = $total_flash_lv + substr_count($clean_total_flash_lv, '.swf"');

            //.swf" end quotes prevent insert swf through flvplayer (is not counted)

            $total_mp3_lv = $total_mp3_lv + substr_count($row['content'], ".mp3");

            $total_flv_p_lv = $total_flv_p_lv + substr_count($row['content'], ".flv");

            $total_flv_lv = $total_flv_p_lv / 5;

            $total_youtube_lv = $total_youtube_lv + substr_count($row['content'], "http://www.youtube.com");

            $total_multimedia_lv = $total_multimedia_lv + substr_count($row['content'], "video/x-msvideo");

            $total_tables_lv = $total_tables_lv + substr_count($row['content'], "<table");

        }

        //Total pages edited at this time

        $total_editing_now = 0;