<?xml version="1.0" encoding="utf-8" ?>
<plugin name="youtube_video">
    <title>YouTube video</title>
    <description>Create field for YouTube video</description>
    <author>Viktor S.</author>
    <owner>reefLESS Classifieds Software</owner>
    <version>1.1.1</version>
    <date>05.01.2009</date>
    <instruction />
    <notice><![CDATA[]]></notice>
    <files></files>

    <install><![CDATA[
        global $rlDb;

        $listing_fields = "INSERT INTO `".RL_DBPREFIX."listing_fields` (`Key` , `Type` , `Details_page` , `Add_page` , `Required` , `Map` , `Status` )
            VALUES ('youtubevideo', 'text', '1', '1', '0', '0', 'active')";
        $rlDb -> query($listing_fields);

        $listing_fields_id = mysql_insert_id();

        $listing_groups = "INSERT INTO `".RL_DBPREFIX."listing_groups` (`Key` , `Display` , `Status` )
            VALUES ('youtubevideo', '1', 'active')";
        $rlDb -> query($listing_groups);

        $listing_groups_id = mysql_insert_id();

        $sql = "SELECT MAX(`Position`) AS `max` FROM `".RL_DBPREFIX."listing_relations`";
        $last_position = $rlDb -> getRow($sql);
        $last_position = (int)$last_position['max']+1;

        if($GLOBALS['config']['general_category'])
            $sql = "SELECT `ID` FROM `".RL_DBPREFIX."categories` WHERE `ID` = '{$GLOBALS['config']['general_category']}' AND `Status` <> 'trash'";
        else
            $sql = "SELECT `ID` FROM `".RL_DBPREFIX."categories` WHERE `Status` <> 'trash'";

        $categories_ids = $rlDb -> getAll($sql);

        foreach ($categories_ids as $key => $val)
        {
            $query = $rlDb-> getOne('Fields', "`Kind_ID` = '{$val['ID']}'", 'listing_relations');
            if($query)
            {
                $sql = "INSERT INTO `".RL_DBPREFIX."listing_relations` (`Position` , `Kind_ID` , `Group_ID` , `Fields` )
                    VALUES ('{$last_position}', '{$val['ID']}', '{$listing_groups_id}', '{$listing_fields_id}')";
                $rlDb -> query($sql);
            }
        }
        $sql = "ALTER TABLE `".RL_DBPREFIX."listings` ADD `youtubevideo` varchar(50) NOT NULL default '' AFTER `Status`";
        $rlDb -> query($sql);
    ]]>
    </install>

    <hooks>
        <hook name="listingsmodifyfield">
            <![CDATA[global $sql;

            $sql .= " `T1`.`youtubevideo`,";]]>
        </hook>
        <hook name="addListingAdditionalInfo">
            <![CDATA[if ($GLOBALS['config']['YouTube_module'])
                {
                    global $data, $category_fields;
                    preg_match('^v=(.*)^', $data['youtubevideo'], $youtube_url);
                    $data['youtubevideo'] = $youtube_url[1];
                    $category_fields[] = array('Key' => 'youtubevideo',  'Type' => 'text', 'Condition' => '', 'Required' => 1, 'Default' => '', 'name' => 'YouTube video');
                }]]>
        </hook>
        <hook name="editListingPostSimulation">
            <![CDATA[if (!empty($_POST['f']['youtubevideo']))
            {
                $_POST['f']['youtubevideo'] = 'http://www.youtube.com/watch?v='.$_POST['f']['youtubevideo'];
            }]]>
        </hook>
        <hook name="editListingAdditionalInfo">
            <![CDATA[if ($GLOBALS['config']['YouTube_module'])
                {
                    global $data, $category_fields;
                    preg_match('^v=(.*)^', $data['youtubevideo'], $youtube_url);
                    $data['youtubevideo'] = $youtube_url[1];
                }]]>
        </hook>
        <hook name="listingDetailsPreAssign">
            <![CDATA[global $listing;
            foreach( $listing as $ukey=>$uval )
            {
                if( is_array($listing[$ukey]['Fields']) )
                {
                    foreach( $listing[$ukey]['Fields'] as $vKey => $vVal )
                    {
                        if ( $vVal['Key'] == 'youtubevideo' )
                        {
                            $listing[$ukey]['Fields'][$vKey]['value'] = strip_tags($listing[$ukey]['Fields'][$vKey]['value']);
                            $listing[$ukey]['Fields'][$vKey]['value'] = "<object width='".$GLOBALS['config']['YouTube_width']."' height='".$GLOBALS['config']['YouTube_height']."'>
                                <param name='movie' value='http://www.youtube.com/v/".$vVal['value']."&hl=en&fs=1'></param>
                                <param name='allowFullScreen' value='true'></param>
                                <param name='allowscriptaccess' value='always'></param>
                                <embed src='http://www.youtube.com/v/".$vVal['value']."&hl=en&fs=1' type='application/x-shockwave-flash' allowscriptaccess='always' allowfullscreen='true' width='".$GLOBALS['config']['YouTube_width']."' height='".$GLOBALS['config']['YouTube_height']."'></embed>
                            </object>";
                        }
                    }
                }
            }
            ]]>
        </hook>
    </hooks>


    <phrases>
        <phrase key="listing_groups+name+youtubevideo" module="common"><![CDATA[YouTube video]]></phrase>
        <phrase key="listing_fields+name+youtubevideo" module="common"><![CDATA[YouTube]]></phrase>
    </phrases>
    <configs key="YouTube" name="YouTube video">
        <![CDATA[]]>
        <config key="YouTube_module" name="YouTube module" description="" values="" type="bool" validate=""><![CDATA[1]]></config>
        <config key="YouTube_width" name="YouTube player width" description="in pixels" values="" type="text" validate="int"><![CDATA[425]]></config>
        <config key="YouTube_height" name="YouTube player height" description="in pixels" values="" type="text" validate="int"><![CDATA[344]]></config>
    </configs>
    <uninstall>
        <![CDATA[global $rlDb;

                $field_id = "SELECT `ID` FROM `".RL_DBPREFIX."listing_fields` WHERE `Key` = 'youtubevideo'";
                $field_id = $rlDb -> getRow($field_id);

                $group_id = "SELECT `ID` FROM `".RL_DBPREFIX."listing_groups` WHERE `Key` = 'youtubevideo'";
                $group_id = $rlDb -> getRow($group_id);

                $sql = "ALTER TABLE `".RL_DBPREFIX."listings` DROP `youtubevideo`";
                $rlDb -> query($sql);

                $sql = "DELETE FROM `".RL_DBPREFIX."listing_fields` WHERE `Key` = 'youtubevideo' LIMIT 1";
                $rlDb -> query($sql);

                $sql = "DELETE FROM `".RL_DBPREFIX."listing_groups` WHERE `Key` = 'youtubevideo' LIMIT 1;";
                $rlDb -> query($sql);

                $sql = "DELETE FROM `".RL_DBPREFIX."listing_relations` WHERE `Group_ID` = '{$group_id['ID']}' AND `Fields` = '{$field_id['ID']}'";
                $rlDb -> query($sql);
                ]]>
    </uninstall>
</plugin>