dublado

(pv -n /dev/sda | dd of=/dev/sdb bs=128M conv=notrunc,noerror) 2>&1 | dialog --gauge "Running dd command (cloning), please wait..." 10 70 0

dublado

import os
import sys

with open("names.txt", "r") as fp:
    for file_num, line in enumerate(fp):

        if line.strip() != 'id3tagger.py':
                artist = line.strip().split('-')[0]
                title = line.strip().split('-')[1]
                line = line.strip()

dublado

sudo netstat -lpn |grep :8080

dublado

FROM     ubuntu:14.04
MAINTAINER Dublado "thiago@dubla.do"

RUN apt-get update && apt-get install -y openssh-server
RUN mkdir /var/run/sshd
RUN echo 'root:screencast' | chpasswd
RUN sed -i 's/PermitRootLogin without-password/PermitRootLogin yes/' /etc/ssh/sshd_config

EXPOSE 22
CMD ["/usr/sbin/sshd", "-D"]

dublado

sudo netstat -lpn | grep :8080

dublado

select * from eav_attribute where frontend_label like '%price%' 
select * from eav_entity_attribute where attribute_id=202;
select * from eav_attribute_option where attribute_id=202 ;
select * from eav_attribute_option_value where option_id = 95;
select * from catalog_eav_attribute where attribute_id=202;
select * from catalog_product_entity_int where attribute_id=202 and entity_id=18;

dublado

SELECT `m`.* FROM `enterprise_url_rewrite` AS `m` WHERE (m.request_path IN ('cadeira-uma-vermelha-1', 'cadeira-uma-vermelha-1') ) ORDER BY `m`.`store_id` DESC

dublado

/*preco de*/
="update catalog_product_entity_decimal set value = '"&E4&"' where entity_type_id = 4 and store_id = 0 and attribute_id = 191 and entity_id = "&A4&";"

/*preco por*/
="update catalog_product_entity_decimal set value = '"&E4&"' where entity_type_id = 4 and store_id = 0 and attribute_id = 67 and entity_id = "&A4&";"


/* Special Price Begin Date*/
="update catalog_product_entity_datetime set value = '2013-02-28' where entity_type_id = 4 and store_id = 0 and attribute_id = 69 and entity_id = "&A4&";"

dublado

UPDATE admin_user SET password=CONCAT(MD5('qXleadmin2012'), ':qX') WHERE username='admin';

dublado

select * from catalog_product_entity_int  
where entity_type_id = 4 and store_id = 0 and entity_id = 32
/*limit 10;*/
select * from catalog_product_entity limit 0,10;

update catalog_product_entity_decimal set value ='1099' where entity_type_id = 4 and store_id = 0 and attribute_id = 191 and entity_id = 12; 	
update catalog_product_entity_decimal set value ='899' where entity_type_id = 4 and store_id = 0 and attribute_id = 67 and entity_id = 12;
update catalog_product_entity_varchar set value = '' where entity_type_id and store_id = 0 and entity_id = 32 and attirbute_id=206
/*
191 - preco de