How to save Windows 10 Lockscreen wallpaper image in laptop?

Windows 10 lockscreen feature is called spotlight and you see new beautiful pictures on your window 10 when ever it is locked.
These pics are present in Microsoft.Windows.ContentDeliveryManager_cw5n1h2txyewy folder and are not having correct extensions as these are raw images and probably microsoft doesnt want them to be indexed in your gallery.
So, the process is simple, open Command Prompt
For opening command prompt, press windows button and then type cmd and click/enter on first result

OR Press Windows + R and then type cmd followed by Enter key.
After you see command prompt’s black screen,, copy and paste the following code in it and that is it.
You can find the lock screen pictures inside you “My Pictures” > “Lockscreenwallpapers” Folder.

mkdir "%userprofile%\Pictures\Lockscreenwallpapers"
copy "%userprofile%\AppData\Local\Packages\Microsoft.Windows.ContentDeliveryManager_cw5n1h2txyewy\LocalState\Assets\*" "%userprofile%\Pictures\Lockscreenwallpapers\"
C:
cd "%userprofile%\Pictures\Lockscreenwallpapers\"
ren *.* *.jpg
exit
 

How to add colon separated hours in PHP using explode function twice?

Problem Statement

Tracking hours for multiple days are available in HH:MM:SS format separated by tab element. Add all the time to show total hours worked/tracked.

<?php
$a="03:23:28	03:58:54	00:00:00	03:10:49	02:17:33	03:56:38	02:18:23	06:15:42	00:00:00	00:00:00	06:04:51	07:41:09	03:23:15	06:12:59	03:51:27	00:00:00	04:30:06	05:00:23	00:00:00	04:34:25	05:17:02	01:36:21	00:00:00	03:53:20	06:30:52	06:21:47	04:54:16	03:22:28	03:10:35	00:00:00	06:37:11	02:14:22	03:06:49	03:05:44	02:35:54	04:03:22	00:00:00
";
#$a="04:05:21	06:25:39	03:02:36	04:01:17	03:03:21	02:00:36	04:21:54	04:21:35	00:00:00	00:00:00	03:39:21	04:19:17	03:08:14	01:44:48	03:28:11	00:00:00	03:05:53	03:05:34	00:00:00	02:09:17	05:01:13	01:02:20	00:00:00	04:30:51	06:03:49	06:36:35	02:14:01	03:06:38	04:02:09	00:00:00	02:34:29	03:36:30	05:10:17	06:46:19	07:48:08	09:13:34	00:00:00
#";
$a="07:28:49	10:24:33	03:02:36	07:12:06	05:20:54	05:57:14	06:40:17	10:37:17	00:00:00	00:00:00	09:44:12	12:00:26	06:31:29	07:57:47	07:19:38	00:00:00	07:35:59	08:05:57	00:00:00	06:43:42	10:18:15	02:38:41	00:00:00	08:24:11	12:34:41	12:58:22	07:08:17	06:29:06	07:12:44	00:00:00	09:11:40	05:50:52	08:17:06	09:52:03	10:24:02	13:16:56	00:00:00
";
$f=explode("\t",$a);
$th=$tm=$ts=0;
foreach($f as $ele){
	
	$ht=explode(":",$ele);
	$hours=intval($ht[0]);
	$minutes=intval($ht[1]);
	$seconds=intval($ht[2]);
	$th+=$hours;
	$tm+=$minutes;
	$ts+=$seconds;
}
$mm=intval($ts/60);
$ts=$ts%60;
$tm+=$mm;
$hh=intval($tm/60);
$tm=$tm%60;
$th+=$hh;

echo "$th:$tm:$ts";
?>

Extracting names from given list of URLs (using regex)

let us extract name form the URL
https://www.google.com/name?=rajiv
paste the URL in the notepad and press crtl+f , and select ‘regular expressions ‘ from search mode

find in notepad

now, enter the regex in the find tab to fetch names
.*?\?=(\w+)$

Now, the selected name will be fetched form regex as (\1).

it can work on numerous links like:-

https://www.google.com/name?=rajiv/
http://www.example.com/asdas?=borde/id=?
http://www.example.com/asdasd?=bordex
http://www.example.com/name?=bordet
http://www.example.com/asdasd?=border
http://www.example.com/jsciloji?=bordeeeee
http://www.example.com/name?=bordee
http://www.example.com/name?=bordeeeeeee
http://www.example.com/09328e?=bordeeee
http://www.example.com/name?=borde
http://www.example.com/lpaosd?=borde

And only the part after first “?=” will be fetched

MySQL error 1449: The user specified as a definer does not exist

Why this error happens?

Most of the times, reason is that your database dump through command line or PhpMyAdmin or even other libraries can have SQL’s Definer statements. Now, as per MySQL’s Official Documentation:

The DEFINER clause specifies the MySQL account to be used when checking access privileges at routine execution time for routines that have the SQL SECURITY DEFINER characteristic.

MySQL Reference Manual v8.0

Solution: MySQL mysqldump create a safe backup to ensure no corruption

Use the following command to create backup of your mysql database. Put the command in terminal

mysqldump -hHOST -uUSERNAME -p DATABASE_NAME | sed -e 's/DEFINER[ ]*=[ ]*[^*]*\*/\*/' > BACKUP_NAME.sql

With gzip compression > backup

mysqldump -hHOST -uUSERNAME -p DATABASE_NAME | sed -e 's/DEFINER[ ]*=[ ]*[^*]*\*/\*/' | gzip > BACKUP_NAME.sql

Reference: https://stackoverflow.com/a/9447215/2229148

Magento 2 all cli commands

[~/www]# php bin/magento list
Magento CLI version 2.2.4
Usage:
command [options] [arguments]
Options:
-h, --help            Display this help message
-q, --quiet           Do not output any message
-V, --version         Display this application version
--ansi            Force ANSI output
--no-ansi         Disable ANSI output
-n, --no-interaction  Do not ask any interactive question
-v|vv|vvv, --verbose  Increase the verbosity of messages: 1 for normal output, 2 for more verbose output and 3 for debug
Available commands:
help                                     Displays help for a command
list                                     Lists commands
admin
admin:user:create                        Creates an administrator
admin:user:unlock                        Unlock Admin Account
app
app:config:dump                          Create dump of application
app:config:import                        Import data from shared configuration files to appropriate data storage
cache
cache:clean                              Cleans cache type(s)
cache:disable                            Disables cache type(s)
cache:enable                             Enables cache type(s)
cache:flush                              Flushes cache storage used by cache type(s)
cache:status                             Checks cache status
catalog
catalog:images:resize                    Creates resized product images
catalog:product:attributes:cleanup       Removes unused product attributes.
config
config:sensitive:set                     Set sensitive configuration values
config:set                               Change system configuration
config:show                              Shows configuration value for given path. If path is not specified, all saved values will be shown
cron
cron:install                             Generates and installs crontab for current user
cron:remove                              Removes tasks from crontab
cron:run                                 Runs jobs by schedule
customer
customer:hash:upgrade                    Upgrade customer's hash according to the latest algorithm
deploy
deploy:mode:set                          Set application mode.
deploy:mode:show                         Displays current application mode.
dev
dev:di:info                              Provides information on Dependency Injection configuration for the Command.
dev:profiler:disable                     Disable the profiler.
dev:profiler:enable                      Enable the profiler.
dev:query-log:disable                    Disable DB query logging
dev:query-log:enable                     Enable DB query logging
dev:source-theme:deploy                  Collects and publishes source files for theme.
dev:template-hints:disable               Disable frontend template hints. A cache flush might be required.
dev:template-hints:enable                Enable frontend template hints. A cache flush might be required.
dev:tests:run                            Runs tests
dev:urn-catalog:generate                 Generates the catalog of URNs to *.xsd mappings for the IDE to highlight xml.
dev:xml:convert                          Converts XML file using XSL style sheets
i18n
i18n:collect-phrases                     Discovers phrases in the codebase
i18n:pack                                Saves language package
i18n:uninstall                           Uninstalls language packages
import
import:categories                        Run category importer script
indexer
indexer:info                             Shows allowed Indexers
indexer:reindex                          Reindexes Data
indexer:reset                            Resets indexer status to invalid
indexer:set-mode                         Sets index mode type
indexer:show-mode                        Shows Index Mode
indexer:status                           Shows status of Indexer
info
info:adminuri                            Displays the Magento Admin URI
info:backups:list                        Prints list of available backup files
info:currency:list                       Displays the list of available currencies
info:dependencies:show-framework         Shows number of dependencies on Magento framework
info:dependencies:show-modules           Shows number of dependencies between modules
info:dependencies:show-modules-circular  Shows number of circular dependencies between modules
info:language:list                       Displays the list of available language locales
info:timezone:list                       Displays the list of available timezones
maintenance
maintenance:allow-ips                    Sets maintenance mode exempt IPs
maintenance:disable                      Disables maintenance mode
maintenance:enable                       Enables maintenance mode
maintenance:status                       Displays maintenance mode status
module
module:disable                           Disables specified modules
module:enable                            Enables specified modules
module:status                            Displays status of modules
module:uninstall                         Uninstalls modules installed by composer
sampledata
sampledata:deploy                        Deploy sample data modules
sampledata:remove                        Remove all sample data packages from composer.json
setup
setup:backup                             Takes backup of Magento Application code base, media and database
setup:config:set                         Creates or modifies the deployment configuration
setup:cron:run                           Runs cron job scheduled for setup application
setup:db-data:upgrade                    Installs and upgrades data in the DB
setup:db-schema:upgrade                  Installs and upgrades the DB schema
setup:db:status                          Checks if DB schema or data requires upgrade
setup:di:compile                         Generates DI configuration and all missing classes that can be auto-generated
setup:install                            Installs the Magento application
setup:performance:generate-fixtures      Generates fixtures
setup:rollback                           Rolls back Magento Application codebase, media and database
setup:static-content:deploy              Deploys static view files
setup:store-config:set                   Installs the store configuration. Deprecated since 2.2.0. Use config:set instead
setup:uninstall                          Uninstalls the Magento application
setup:upgrade                            Upgrades the Magento application, DB data, and schema
store
store:list                               Displays the list of stores
store:website:list                       Displays the list of websites
theme
theme:uninstall                          Uninstalls theme
varnish
varnish:vcl:generate                     Generates Varnish VCL and echos it to the command line

RPM repo not found connection errors on Centos Redhat duplicate problems

yum -y update command failing

Command line will show messages like

xxx is outdated and v abc will be installed
but at the end it shows duplicate binary, please remove duplicate first.

Process

Backup first
Integrity Check
Find Problems
Identify duplicates
Clean duplicates
re build conf cache
update command
remove backup file .prev if successfully solved

\cp -r /var/lib/rpm /var/lib/rpm.prev
yum-complete-transaction
package-cleanup --problems
package-cleanup --dupes
package-cleanup --cleandupes
yum clean all
rpm --rebuilddb
yum update
# if all went OK run 'rm -rf /var/lib/rpm.prev'

Other possible solution

1. Update DNS to google dns 8.8.8.8 and 8.8.4.4 or freenom dns 80.80.80.80 and 80.80.81.81

system-config-network

2. Restart internet while maintaining SSH session (you wont be logged out)

/etc/init.d/network restart

How to stop SPAM in gmail account permanently? A guide to creating filters in Google Mail [no third party app]

SPAM, don’t we hate it when our inbox is full of credit card offers, insurance policies and billions of pounds that some rich dude left for you in his will? Everyone wants to get rid of them but somehow, some stupid website out there keeps leaking on our email address and we keep receiving stupid junk emails.

We all know that SPAM or Junk Email means unsolicited messages that you receive by email. But here is a fun fact:

Spam is named after Spam luncheon meat by way of a Monty Python sketch in which Spam in the sketch is ubiquitous, unavoidable and repetitive.

Go to Latest update of this article

UPDATE
The new filter guide is on https://github.com/harshvardhanmalpani/Spam-List
You can directly use the file filter_import_for_gmail.xml from github repository and add filters.
———

let us get started with the guide, Please be aware that this guide will remove and block the SPAM addresses permanently.

Step 1: Log in to your Gmail account

Step 2: Go to Settings

Gmail settings

Step 3: Under Filters and Blocked Addresses, Click on Create a new filter

Step 4: In the new FROM field, enter the Email addresses you want to block separated with

" OR "
quotations not required, just [space]OR[space]

and finally click Create filter with this search

Step 5: Check Delete it and Never send it to spam and Save the filter by choosing Create filter


Ready to import gmail filters now available

download here

file contents:

<?xml version='1.0' encoding='UTF-8'?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:apps='http://schemas.google.com/apps/2006'>
<title>Mail Filters</title>
<id>
tag:mail.google.com,2008:filters:1536425906073,1536425906073,1536425906074,1536425906074,1536425906075,1536425906075,1536425906075,1536425906076,1536425906076</id><updated>2018-09-08T22:28:26Z</updated><author>
<name>Harshvardhan Malpani</name>
<email>[email protected]</email>
</author><entry><category term='filter'></category>
<title>Mail Filter</title>
<id>tag:mail.google.com,2008:filter:1536425906073</id><updated>2018-09-08T22:28:26Z</updated><content></content><apps:property name='from' value='[email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected]'/><apps:property name='shouldTrash' value='true'/>
<apps:property name='shouldNeverSpam' value='true'/>
<apps:property name='sizeOperator' value='s_sl'/>
<apps:property name='sizeUnit' value='s_smb'/> </entry><entry><category term='filter'></category>
<title>Mail Filter</title>
<id>tag:mail.google.com,2008:filter:1536425906073</id><updated>2018-09-08T22:28:26Z</updated><content></content><apps:property name='from' value='[email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected]'/><apps:property name='shouldTrash' value='true'/>
<apps:property name='shouldNeverSpam' value='true'/>
<apps:property name='sizeOperator' value='s_sl'/>
<apps:property name='sizeUnit' value='s_smb'/> </entry><entry><category term='filter'></category>
<title>Mail Filter</title>
<id>tag:mail.google.com,2008:filter:1536425906074</id><updated>2018-09-08T22:28:26Z</updated><content></content><apps:property name='from' value='[email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected]'/><apps:property name='shouldTrash' value='true'/>
<apps:property name='shouldNeverSpam' value='true'/>
<apps:property name='sizeOperator' value='s_sl'/>
<apps:property name='sizeUnit' value='s_smb'/> </entry><entry><category term='filter'></category>
<title>Mail Filter</title>
<id>tag:mail.google.com,2008:filter:1536425906074</id><updated>2018-09-08T22:28:26Z</updated><content></content><apps:property name='from' value='[email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected]'/><apps:property name='shouldTrash' value='true'/>
<apps:property name='shouldNeverSpam' value='true'/>
<apps:property name='sizeOperator' value='s_sl'/>
<apps:property name='sizeUnit' value='s_smb'/> </entry><entry><category term='filter'></category>
<title>Mail Filter</title>
<id>tag:mail.google.com,2008:filter:1536425906075</id><updated>2018-09-08T22:28:26Z</updated><content></content><apps:property name='from' value='[email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected]'/><apps:property name='shouldTrash' value='true'/>
<apps:property name='shouldNeverSpam' value='true'/>
<apps:property name='sizeOperator' value='s_sl'/>
<apps:property name='sizeUnit' value='s_smb'/> </entry><entry><category term='filter'></category>
<title>Mail Filter</title>
<id>tag:mail.google.com,2008:filter:1536425906075</id><updated>2018-09-08T22:28:26Z</updated><content></content><apps:property name='from' value='[email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected]'/><apps:property name='shouldTrash' value='true'/>
<apps:property name='shouldNeverSpam' value='true'/>
<apps:property name='sizeOperator' value='s_sl'/>
<apps:property name='sizeUnit' value='s_smb'/> </entry><entry><category term='filter'></category>
<title>Mail Filter</title>
<id>tag:mail.google.com,2008:filter:1536425906075</id><updated>2018-09-08T22:28:26Z</updated><content></content><apps:property name='from' value='[email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected]'/><apps:property name='shouldTrash' value='true'/>
<apps:property name='shouldNeverSpam' value='true'/>
<apps:property name='sizeOperator' value='s_sl'/>
<apps:property name='sizeUnit' value='s_smb'/> </entry><entry><category term='filter'></category>
<title>Mail Filter</title>
<id>tag:mail.google.com,2008:filter:1536425906076</id><updated>2018-09-08T22:28:26Z</updated><content></content><apps:property name='from' value='[email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR va.loan.#[email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected]'/><apps:property name='shouldTrash' value='true'/>
<apps:property name='shouldNeverSpam' value='true'/>
<apps:property name='sizeOperator' value='s_sl'/>
<apps:property name='sizeUnit' value='s_smb'/> </entry><entry><category term='filter'></category>
<title>Mail Filter</title>
<id>tag:mail.google.com,2008:filter:1536425906076</id><updated>2018-09-08T22:28:26Z</updated><content></content><apps:property name='from' value='[email protected]'/><apps:property name='shouldTrash' value='true'/>
<apps:property name='shouldNeverSpam' value='true'/>
<apps:property name='sizeOperator' value='s_sl'/>
<apps:property name='sizeUnit' value='s_smb'/> </entry></feed>

Some of the spam email addresses in my filter list:

Note: You might have to create multiple filters because one search can not contain more than 1000 characters

Whole list of spammers

[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
adrian.smith[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]ions.online
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
va.loan.#[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]

September Update

Latest way to be followed for SPAM blocking is as follows:

Do NOT follow both the procedures, only one of these is enough

Step 1: Log in to your Gmail account

Step 2: Go to Settings

Gmail settings

Step 3: Delete all previous filters if any, and then click on Import Filters

Click on Import Filters

Step 4: Upload the xml file that you downloaded from here: Link to filters in xml
choose xml file to import

Step 5: Click on open file and then you will see that all filters are loaded. Make sure you tick Apply new filters to existing email. and then click on Create Filters

Create Filters

Step 6: There is no step 6, wait and watch. All those filters will get created and will make you rid of SPAM

Linux Bash – How to change all filenames to uppercase leaving the file extension unchanged

use this simple code in bash shell. The following code will change all xxx.jpg files to XXX.jpg in any particular working directory.

for i in *.jpg; do 
ext=${i##*.}; 
name=$(basename "$i" ".$ext" | tr '[a-z]' '[A-Z]').$ext; 
if [ "$i" != "$name" ] 
then 
mv $i $name;
fi
done;

How to update Magento community edition using CLI

composer require magento/product-community-edition 2.2.6 --no-update
composer update
rm -rf var/di var/generation var/cache var/view_preprocessed generated/*
php bin/magento cache:clean
php bin/magento cache:flush
php bin/magento setup:upgrade
php bin/magento setup:di:compile
php bin/magento indexer:reindex
php bin/magento deploy:mode:set production

if you receive any errors post installation, try this hard fix

rm -rf app/code/Magento/ var/* vendor/*
chmod 777 -R *
composer update && composer install
php -f bin/magento setup:static-content:deploy
find . -type d -exec chmod 775 {}
find . -type f -exec chmod 660 {}
chmod u+x bin/magento
bin/magento maintenance:disable
bin/magento cache:clean

CORS policy for subdomains – htaccess – apache server

Works for Magento 2.2x

Cross-Origin Resource Sharing header for Access-Control-Allow-Origin for Subdomains

SetEnvIf Origin "^(.*\.yourdomain\.com)$" OSD=$1
Header set Access-Control-Allow-Origin "%{OSD}e" env=OSD
Header set Access-Control-Allow-Methods: "*"
Header set Access-Control-Allow-Headers: "*"

or a general format for simple copy paste:

SetEnvIf Origin "^(.*)$" OSD=$1
Header set Access-Control-Allow-Origin "%{OSD}e" env=OSD
Header set Access-Control-Allow-Methods: "*"
Header set Access-Control-Allow-Headers: "*"