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, |
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 |
NewerOlder