| update | |
| `catalog_product_entity_int` | |
| set | |
| `value` = 1 | |
| where | |
| `attribute_id`=(select `attribute_id` from `eav_attribute` where `attribute_code` = 'visibility') | |
| and | |
| `entity_id` in (select `product_id` from `catalog_product_super_link`); |
For inctance, we need to convert all .gif to .jpg
Execute next commands in teminal
> cd /vaw/www/media/catalog/product/
> for i in $(find $(pwd) -name \*.gif -print); do convert $i $(echo $i.jpg | sed s/.gif//g); done
> rm -r cache/
Then, run these sql-statements in DB
| INSERT INTO `directory_country_region` (`region_id`,`country_id`,`code`,`default_name`) VALUES | |
| (Null,'RU','RU-AD','Республика Адыгея (Адыгея)'), | |
| (Null,'RU','RU-BA','Республика Башкортостан'), | |
| (Null,'RU','RU-BU','Республика Бурятия'), | |
| (Null,'RU','RU-AL','Республика Алтай'), | |
| (Null,'RU','RU-DA','Республика Дагестан'), | |
| (Null,'RU','RU-IN','Республика Ингушетия'), | |
| (Null,'RU','RU-KB','Кабардино-Балкарская Республика'), | |
| (Null,'RU','RU-KL','Республика Калмыкия'), | |
| (Null,'RU','RU-KC','Карачаево-Черкесская Республика'), |
| <?php | |
| require "app/Mage.php"; | |
| umask(0); | |
| Mage::init('admin', 'store'); | |
| $attrCode = 'model'; //your attribute code here | |
| $attrId = (int) Mage::getModel('eav/entity_attribute')->getIdByCode(Mage_Catalog_Model_Product::ENTITY, $attrCode); | |
| $resource = Mage::getSingleton('core/resource')->getConnection('core_write'); | |
| try { |
| <?php | |
| public function getPlaceInArray(&$array, &$ri, &$rj, $di = 1, $dj = 1, $t = null) | |
| { | |
| $ri = 0; | |
| $rj = 0; | |
| while (1) { | |
| $ri = rand(0, Mage::getStoreConfig('project/config/lines') - $di); | |
| $rj = rand(0, Mage::getStoreConfig('project/config/columns') - $dj); |
| Validation.addAllThese([ | |
| ['validate-filesize','The file size should not exceed 100 kb.',function(v, elm){ | |
| var maxSize = 102400; | |
| if (navigator.appName == "Microsoft Internet Explorer") { | |
| if (elm.value) { | |
| var oas = new ActiveXObject("Scripting.FileSystemObject"); | |
| var e = oas.getFile(elm.value); | |
| var size = e.size; | |
| } | |
| } else { |