source: trunk/news_admin/inc/class.soexport.inc.php @ 45

<?php
        /**************************************************************************\
        * eGroupWare - News                                                        *
        * http://www.egroupware.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.                                              *
        * --------------------------------------------                             *
        \**************************************************************************/

        /* $Id$ */

        class soexport
        {
                var $db;

                function soexport()
                {
                        $this->db = $GLOBALS['phpgw']->db;
                }

                function readconfig($cat_id)
                {
                        $sql = "SELECT * FROM phpgw_news_export where cat_id = $cat_id";
                        $this->db->query($sql,__LINE__,__FILE__);
                        if ($this->db->next_record())
                        {
                                $result = array();
                                foreach (array('type','itemsyntax','title','link','description','img_title','img_url','img_link') as $config)
                                {
                                        $result[$config] = $this->db->f('export_'.$config);
                                }
                                return $result;
                        }
                        else
                        {
                                return false;
                        }
                }

                function saveconfig($cat_id,$config)
                {
                        $sql = "DELETE FROM phpgw_news_export where cat_id = $cat_id";
                        $this->db->query($sql,__LINE__,__FILE__);
                        $sql = "INSERT INTO phpgw_news_export " . 
                                "(cat_id,export_type,export_itemsyntax,export_title,export_link,export_description,export_img_title,export_img_url,export_img_link) " .
                                "VALUES ($cat_id,'" . $config['type']  . "','" . $config['itemsyntax'] . "','" . $config['title'] . 
                                "','" . $config['link'] . "','" . $config['description'] . "','" . $config['img_title'] . 
                                "','" . $config['img_url'] . "','" . $config['img_link'] . "')";
                        $this->db->query($sql,__LINE__,__FILE__);
                }

        }