Skip to content

Instantly share code, notes, and snippets.

Devert.net DevertNet

Block or report user

Report or block DevertNet

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
@DevertNet
DevertNet / Shopware Database Clean.sql
Last active Apr 2, 2020
Shopware Database Clean: Remove Customers and Orders.
View Shopware Database Clean.sql
#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`;
View Magento Convert Dropdown Attribute to Multiselect.sql
/*
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;
View Magento Database Query.php
<?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
DevertNet / Magento Delete Credit Memo in Database
Created Mar 7, 2017
Delete credit memo in magento. Tested with 1.7.0.2
View Magento Delete Credit Memo in Database
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
View ROAR Helper
/*
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];
View Magento: Get all Mail Templates used in Config
<?php
$dir = dirname(__FILE__);
chdir($dir);
require $dir.'/app/Mage.php';
Mage::app()->setCurrentStore(Mage_Core_Model_App::ADMIN_STORE_ID);
$configSections = Mage::getSingleton('adminhtml/config')->getSections();
// look for node entries in all system.xml that use source_model=adminhtml/system_config_source_email_template
// they are will be templates, what we try find
View Let Encrypt
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
View tt_news pagetitle
[globalVar = GP:tx_news_pi1|news > 0]
temp.newsTitle = RECORDS
temp.newsTitle {
source = {GP:tx_news_pi1|news}
source.insertData = 1
tables = tx_news_domain_model_news
select.languageField = sys_language_uid
conf {
tx_news_domain_model_news >
tx_news_domain_model_news = TEXT
View Magento Cronjob
*/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
View Magento Country Codes
Country 2 Digit Code 3 Digit Code
Afghanistan AF AFG
Albania AL ALB
Algeria DZ DZA
American Samoa AS ASM
Andorra AD AND
Angola AO AGO
Anguilla AI AIA
Antarctica AQ ATA
Antigua and Barbuda AG ATG
You can’t perform that action at this time.