symphonycms / symphony-2

         * @param  integer $parent_field_id

         * @return array

         */

        public function findRelatedEntries($entry_id, $parent_field_id)

        {

            try {

                $ids = Symphony::Database()->fetchCol('entry_id', sprintf("

                SELECT `entry_id`

                FROM `tbl_entries_data_%d`

                WHERE `relation_id` = %d

                AND `entry_id` IS NOT NULL

            ", $this->get('id'), $entry_id));

            } catch (Exception $e) {

                return array();

            }

            return $ids;

        }

        /**

         * Find related entries for the current field. Default implementation uses

         * @param  integer $entry_id

         * @return array

         */

        public function findParentRelatedEntries($field_id, $entry_id)

        {

            try {

                $ids = Symphony::Database()->fetchCol('relation_id', sprintf("

                SELECT `relation_id`

                FROM `tbl_entries_data_%d`

                WHERE `entry_id` = %d

                AND `relation_id` IS NOT NULL

            ", $field_id, $entry_id));

            } catch (Exception $e) {

                return array();

            }

            return $ids;

        }

    }