Devert.net DevertNet
DevertNet
/ Shopware Database Clean.sql
Last active
May 18, 2022 17:42
Shopware Database Clean: Remove Customers and Orders.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #https://docs.shopware.com/de/shopware-5-de/tutorials-und-faq/sql-tipps-tricks | |
| SET foreign_key_checks = 0; | |
| TRUNCATE `s_user`; | |
| TRUNCATE `s_user_addresses`; | |
| TRUNCATE `s_user_addresses_attributes`; | |
| TRUNCATE `s_user_attributes`; | |
| TRUNCATE `s_user_billingaddress`; | |
| TRUNCATE `s_user_billingaddress_attributes`; | |
| TRUNCATE `s_user_shippingaddress`; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # Compress and Exclude! | |
| tar -pczf MyBackup.tar.gz /home/user/public_html/ --exclude "/home/user/public_html/tmp" | |
| tar -pczf backup_xxx.tar.gz ./public_html --exclude "./public_html/media" --exclude "./public_html/var/cache" --exclude "./public_html/var/log" | |
| # RYSNC | |
| Muss auf dem Zielsystem ausgeführt werden z.B. Lokal. | |
| rsync --progress --exclude=var/cache --exclude=var/log --exclude=var/session --exclude=/media --exclude=/tmp -aze ssh bauchemie24@bauchemie24.web.mageprofis.de:/home/bauchemie24/htdocs/ /home/leon/htdocs/bauchemie24/ | |
| # Uncompress |
DevertNet
/ Magento Cronjob
Created
June 13, 2016 12:28
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| */5 * * * * php /home/bender/htdocs/cron.php -malways 1 > /dev/null | |
| */5 * * * * php /home/bender/htdocs/cron.php -mdefault 1 > /dev/null | |
| * * * * * ! test -e /home/bender/htdocs_dev/www/maintenance.flag && /bin/bash /home/bender/htdocs_dev/www/scheduler_cron.sh --mode always | |
| * * * * * ! test -e /home/bender/htdocs_dev/www/maintenance.flag && /bin/bash /home/bender/htdocs_dev/www/scheduler_cron.sh --mode default |
DevertNet
/ Magento How to get the customer login, logout, register and checkout urls.php
Last active
September 12, 2019 18:39
— forked from thagxt/Magento How to get the customer login, logout, register and checkout urls.php
Magento How to get the customer login, logout, register and checkout urls
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| login url | |
| <?php echo Mage::getUrl('customer/account/login'); ?> | |
| logout url | |
| <?php echo Mage::getUrl('customer/account/logout'); ?> | |
| My Account url | |
| <?php echo Mage::getUrl('customer/account'); ?> | |
| Register url |
DevertNet
/ Let Encrypt
Last active
September 2, 2019 10:05
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 1. Im Root-Verzeichnis (/home/root) folgendes ausführen: | |
| git clone https://github.com/letsencrypt/letsencrypt.git | |
| cd letsencrypt | |
| ./letsencrypt-auto -h | |
| service nginx stop | |
| ./letsencrypt-auto certonly --standalone -d www.beispiel.de -d beispiel.de | |
| service nginx start | |
| 2. Keys werden hier abgelegt: | |
| /etc/letsencrypt/live/www.beispiel.de |
DevertNet
/ ROAR Helper
Last active
January 14, 2019 12:21
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| Bericht für den heutigen Tag exportieren. | |
| Porjekt öffnen, in den Tab "Tickets" wechseln, Datum in Code Ändern und in der Konsole abfeuern... | |
| */ | |
| var today = 0; | |
| var all = ''; | |
| jQuery('.issuecalendar').each(function(e) { | |
| if (typeof jQuery(this).attr('data-date') == 'undefined') return; | |
| var date = new Date(parseInt(jQuery(this).attr('data-date')) * 1000); | |
| var day = date.toISOString().split('T')[0].split('-')[2]; |
DevertNet
/ Magento Convert Dropdown Attribute to Multiselect.sql
Created
May 5, 2017 06:36
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| Important! Change attribute_id ;) | |
| */ | |
| insert into catalog_product_entity_varchar (entity_type_id, attribute_id, store_id, entity_id, value) select entity_type_id, attribute_id, store_id, entity_id, value from catalog_product_entity_int where attribute_id = 165; | |
| DELETE FROM catalog_product_entity_int WHERE attribute_id = 165; | |
| UPDATE eav_attribute SET backend_type='varchar', frontend_input='multiselect', backend_model='eav/entity_attribute_backend_array' WHERE attribute_id = 165; |
DevertNet
/ test.attr.php
Created
October 15, 2015 12:41
Magento Adding existing attribute to all attribute sets
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| /* | |
| replace show_in_price_search_engine with your attr code | |
| replace General with antoher Tab | |
| */ | |
| $dir = dirname(__FILE__); | |
| chdir($dir); |
DevertNet
/ Magento Database Query.php
Last active
March 22, 2017 08:16
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| //There is a more proper way to do this. | |
| $resource = Mage::getSingleton('core/resource'); | |
| $write = $resource->getConnection('core_write'); | |
| $table = $resource->getTableName('your/model'); | |
| //You can Create: | |
| $write->insert( | |
| $table, |
DevertNet
/ Magento Delete Credit Memo in Database
Created
March 7, 2017 08:46
Delete credit memo in magento. Tested with 1.7.0.2
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| DELETE FROM sales_flat_creditmemo WHERE entity_id=123; | |
| UPDATE sales_flat_order_item SET qty_refunded='0.0000', amount_refunded='0.0000', base_amount_refunded='0.0000', hidden_tax_refunded=NULL, base_hidden_tax_refunded=NULL, tax_refunded=NULL, discount_refunded=NULL, base_discount_refunded=NULL WHERE order_id=54255; | |
| UPDATE sales_flat_order SET state='complete', status='complete', base_discount_refunded=NULL, base_shipping_refunded=NULL, base_shipping_tax_refunded=NULL, base_subtotal_refunded=NULL, base_tax_refunded=NULL, base_total_offline_refunded=NULL, base_total_refunded=NULL, discount_refunded=NULL, shipping_refunded=NULL, shipping_tax_refunded=NULL, subtotal_refunded=NULL, tax_refunded=NULL, total_offline_refunded=NULL, total_refunded=NULL, adjustment_negative=NULL, adjustment_positive=NULL, base_adjustment_negative=NULL, base_adjustment_positive=NULL, base_total_due=NULL, total_due=NULL, hidden_tax_refunded=NULL, base_hidden_tax_refunded=NULL WHERE entity_id=54255; | |
| UPDATE sales_flat_order_grid SET st |
NewerOlder