[PLUGIN] Motorcycles attributes Ver. 1.2.2 Update: Sept. 11, 2013

[gnoe]

  Great job. Thanks.

[kweku]

Who has the car plugin.?  and it shows detail on item???   I NEED IT>

[chewyluke]

Have you checked the market? It's right there.

[fezanna]

Hi, I have2 question:
1._ when I change the search from car to motorcycles, the make remains the value of research of the car.
2._ when I do a search for motorcycles does not maintain brand - model - type of the previous search

Someone has already encountered this problem and could help me?

[Bla Bla Annunci]

I have a problem with the models
During the insert ads I'm going to select the Make.
You do not see models
somebody help me
thanks

[martymcgivern77]

Hi alexgr,

I would like to thank you for your persistence.

Please check the plugin on the first post and if everything looks good I will update "Yachts" plugin asap.

version 1.2.2
Update: Sep. 11, 2013
Motorcycles attributes

1. Corrected conflict with cars plugin when searching "make", "model" and "type".

Download from first post.

David

Hi mmcsus, I know this is an old post but did you get round to doing a yachts plugin? If not, is there much involved in me modifying motorcycles plugin myself?

Thanks

[arcsales]

Plugin couldn't be installed because of: Error importSQL::Modelmotorcycles
motorcycles_attributes/basic_data.sql

Any help?
Im using 3.5.9 version

[Loriby87]

Hi i tryed to install so many times i deleted all the for tabbles from the database and i dont know why is failing to install this plugin.Please help me to solve this problem first time if i trying to install the plugin is have problem with basic data sql and after if i trying again it have problem with struct sql
i tryed to import the struct sql file in database but i got this error Error
SQL query:

CREATE TABLE /*TABLE_PREFIX*/t_item_motorcycle_motorcycle_type_attr(

pk_i_id INT( 2 ) UNSIGNED NOT NULL ,
fk_c_locale_codeCHAR( 5 ) NOT NULL ,
s_name VARCHAR( 255 ) ,
PRIMARY KEY ( pk_i_id, fk_c_locale_code ) ,
FOREIGN KEY ( fk_c_locale_code ) REFERENCES /*TABLE_PREFIX*/t_locale(
pk_c_code
)
) ENGINE = INNODB DEFAULT CHARACTER SET  'UTF8' COLLATE  'UTF8_GENERAL_CI';

MySQL said: Documentation

#1005 - Can't create table 'petfinde_gsale.t_item_motorcycle_motorcycle_type_attr' (errno: 150)

[ysalim]

I installed and it worked, only however, I really do need to be able to search by year min and max, can anyone please help ?

[BC-TEAM]

index:

Code: [Select]

switch($key) {
    ...
    case 'min_year':
        if (is_numeric($value)) {
            Search::newInstance()->addConditions(sprintf("%st_item_motorcycle_attr.i_year >= %d", DB_TABLE_PREFIX, $value));
            $has_conditions = true;
        }
        break;
    case 'max_year':
        if (is_numeric($value)) {
            Search::newInstance()->addConditions(sprintf("%st_item_motorcycle_attr.i_year <= %d", DB_TABLE_PREFIX, $value));
            $has_conditions = true;
        }
        break;
    default:
    break;
}
form:

Code: [Select]

<div class="row one_input">
    <h6><?php _e('Year', 'motorcycles_attributes'); ?></h6>
    <select name="min_year" id="min_year">
        <option value=""><?php _e('Min Year', 'motorcycles_attributes'); ?></option>
        <?php
            
            $minYr = array();
            for ($a = 2016; $a > 1970; $a--) {
                $minYr['id'] = $a;
                $minYr['name'] = $a;
            ?>
            <option value="<?php echo $minYr['id']; ?>" <?php if ($min_yr == $minYr['id']) { echo 'selected'; } ?>><?php echo $minYr['name'] ?></option>
        <?php } ?>
    </select>
    <select name="max_year" id="max_year">
        <option value=""><?php _e('Max Year', 'motorcycles_attributes'); ?></option>
        <?php
                
            $maxYr = array();
            for ($b = 2016; $b > 1970; $b--) {
                $maxYr['id'] = $b;
                $maxYr['name'] = $b;
            ?>
            <option value="<?php echo $maxYr['id']; ?>" <?php if ($max_yr == $maxYr['id']) { echo 'selected'; } ?>><?php echo $maxYr['name'] ?></option>
        <?php } ?>
    </select>
</div>