<?php
/**
 * @package     Joomla.Platform
 * @subpackage  Database
 *
 * @copyright   Copyright (C) 2005 - 2011 Open Source Matters, Inc. All rights reserved.
 * @license     GNU General Public License version 2 or later; see LICENSE
 */

defined('JPATH_PLATFORM') or die;

jimport('joomla.database.table');

/**
 * Update table
 * Stores updates temporarily
 *
 * @package     Joomla.Platform
 * @subpackage  Table
 * @since       11.1
 */
class JTableUpdate extends JTable
{
    /**
     * Contructor
     *
     * @access protected
     * @param database A database connector object
     */
    function __construct( &$db ) {
        parent::__construct( '#__updates', 'update_id', $db );
    }

    /**
    * Overloaded check function
    *
    * @access public
    * @return boolean True if the object is ok
    * @see JTable:bind
    */
    function check()
    {
        // check for valid name
        if (trim( $this->name ) == '' || trim( $this->element ) == '') {
            $this->setError(JText::_('JLIB_DATABASE_ERROR_MUSTCONTAIN_A_TITLE_EXTENSION'));
            return false;
        }
        return true;
    }

    /**
    * Overloaded bind function
    *
    * @access public
    * @param array $hash named array
    * @return null|string   null is operation was satisfactory, otherwise returns an error
    * @see JTable:bind
    * @since 11.1
    */
    function bind($array, $ignore = '')
    {
        if (isset( $array['params'] ) && is_array($array['params']))
        {
            $registry = new JRegistry();
            $registry->loadArray($array['params']);
            $array['params'] = (string)$registry;
        }

        if (isset( $array['control'] ) && is_array( $array['control'] ))
        {
            $registry = new JRegistry();
            $registry->loadArray($array['control']);
            $array['control'] = (string)$registry;
        }

        return parent::bind($array, $ignore);
    }

    function find($options=Array()) {
        $dbo = JFactory::getDBO();
        $where = Array();
        foreach($options as $col=>$val) {
            $where[] = $col .' = '. $dbo->Quote($val);
        }
        $query = 'SELECT update_id FROM #__updates WHERE '. implode(' AND ', $where);
        $dbo->setQuery($query);
        return $dbo->loadResult();
    }
}