chamilo / chamilo-lms

            $row = Database::fetch_array($result);

            $id = $row['id'];

            $email_page_name = $row['title'];

            if ($row['visibility'] == 1) {

                $allow_send_mail = true; //if visibility off - notify off

                $sql = 'SELECT * FROM '.$tbl_wiki_mailcue.'

                        WHERE

                            c_id = '.$course_id.' AND

                            id="'.$id.'" AND

                            type="'.$type.'" OR

                            type="F" AND

                            group_id="'.$groupId.'" AND

                            session_id="'.$session_id.'"';

                //type: P=page, D=discuss, F=full.

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

                $emailtext = get_lang('EmailWikipageModified').' <strong>'.$email_page_name.'</strong> '.get_lang('Wiki');

            }

        } elseif ($type == 'D') {

            //if added a post to discuss

            //first, current author and time

            $row = Database::fetch_array($result);

            $email_page_name = $row['title'];

            if ($row['visibility_disc'] == 1) {

                $allow_send_mail = true; //if visibility off - notify off

                $sql = 'SELECT * FROM '.$tbl_wiki_mailcue.'

                        WHERE

                            c_id = '.$course_id.' AND

                            id="'.$id.'" AND

                            type="'.$type.'" OR

                            type="F" AND

                            group_id="'.$groupId.'" AND

                            session_id="'.$session_id.'"';

                //type: P=page, D=discuss, F=full

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

                $emailtext = get_lang('EmailWikiPageDiscAdded').' <strong>'.$email_page_name.'</strong> '.get_lang('Wiki');

            }

        } elseif ($type == 'A') {

            //for added pages

            $id = 0; //for tbl_wiki_mailcue