source: contrib/ProjectManager/inc/class.soinfolog_sql.inc.php @ 3594

<?php
  /**************************************************************************\
  * eGroupWare - infolog                                                    *
  * http://www.eGroupWare.org                                                *
  * Maintained and further developed by RalfBecker@outdoor-training.de       *
  * Based on Webinfolog by Craig Knudsen <cknudsen@radix.net>               *
  *          http://www.radix.net/~cknudsen                                  *
  * Originaly modified by Mark Peters <skeeter@phpgroupware.org>             *
  * --------------------------------------------                             *
  *  This program is free software; you can redistribute it and/or modify it *
  *  under the terms of the GNU General Public License as published by the   *
  *  Free Software Foundation; either version 2 of the License, or (at your  *
  *  option) any later version.                                              *
  \**************************************************************************/


        if (@$GLOBALS['phpgw_info']['flags']['included_classes']['soinfolog_'])
        {
                return;
        }

        $GLOBALS['phpgw_info']['flags']['included_classes']['soinfolog_'] = True;

        class soinfolog_ extends soinfolog__
        {
                var $deleted_events = Array();

                var $cal_event;
                var $today = Array('raw','day','month','year','full','dow','dm','bd');


                function soinfolog_()
                {
                        $this->soinfolog__();

                        if (!is_object($GLOBALS['phpgw']->asyncservice))
                        {
                                $GLOBALS['phpgw']->asyncservice = CreateObject('phpgwapi.asyncservice');
                        }
                        $this->async = &$GLOBALS['phpgw']->asyncservice;
                }

                function get_event_ids()
                {
                        $from = $where = ' ';
                        

                        $sql = 'SELECT DISTINCT  info_id, info_type,
info_from,info_subject,info_owner,info_datemodified,info_startdate, info_enddate,info_uid,
info_priority  '
                                        . 'FROM phpgw_infolog';
                                        //. $from;
                                        //. 'WHERE (phpgw_cal_user.info_id = phpgw_cal.info_id) '
                                        //. $where . $extra;

//echo "SQL : ".$sql ."<br>\n";

                        if($this->debug)
                        {
                                echo "FULL SQL : ".$sql."<br>\n";
                        }

                        $this->stream->query($sql,__LINE__,__FILE__);

                        $retval = Array();
                        if($this->stream->num_rows() == 0)
                        {
                                if($this->debug)
                                {
                                        echo "No records found!<br>\n";
                                }
                                return $retval;
                        }

                        while($this->stream->next_record())
                        {
                                $retval[] = (int)$this->stream->f('info_id');
                        }
                        if($this->debug)
                        {
                                echo "Records found!<br>\n";
                        }
                        return $retval;
                }

        }