<?php
/**
 * @package DJ-Classifieds
 * @copyright Copyright (C) DJ-Extensions.com, All rights reserved.
 * @license http://www.gnu.org/licenses GNU/GPL
 * @author url: http://dj-extensions.com
 * @author email contact@dj-extensions.com
 */

defined('_JEXEC') or die;

class DJClassifiedsControllerApi extends JControllerLegacy
{
    public static function getSchema($print = true)
	{
		$db = JFactory::getDBO();
		$query = "SELECT s.* FROM #__schemas s INNER JOIN #__extensions e ON s.extension_id=e.extension_id WHERE e.type='component' AND e.name='com_djclassifieds'";
		$db->setQuery($query);
		$schema = $db->loadObject();
        if($print){
            echo '<pre>'; print_r($schema); echo '</pre>';
        }
		
        return $schema;
	}

	function setSchema()
	{
        $app = JFactory::getApplication();
        $user = JFactory::getUser();
        $db = JFactory::getDBO();

        if($user->authorise('core.admin', 'com_djclassifieds')){
            $ver = $app->input->getVar('ver');
            if($ver){
                $oldver = self::getSchema(false)->version_id;

                if($oldver ==$ver){
                    echo 'schema versions match';
                }else{
                    $query = "UPDATE #__schemas s INNER JOIN #__extensions e ON s.extension_id=e.extension_id SET s.version_id=".$db->q($ver)." WHERE e.type='component' AND e.name='com_djclassifieds'";
                    $db->setQuery($query);
                    $db->execute();
                    
                    echo 'schema updated: '.$oldver.' -> '.$ver;
                }
            }else{
                echo 'no ver provided';
            }
        }else{
            echo 'no access';
        }
    }
}