[type="radio"]:checked + label:before {
background: #bc6060;
box-shadow: 0 0 0 0.25em #000;
}
[type="radio"]:focus + label:after {
content: '[type="radio"]:checked + label:before {
background: #bc6060;
box-shadow: 0 0 0 0.25em #000;
}
[type="radio"]:focus + label:after {
content: '\0020\2190';
font-size: 1.5em;
line-height: 1;
vertical-align: -0.125em;
}
[type="radio"] {
border: 0;
clip: rect(0 0 0 0);
height: 1px; margin: -1px;
overflow: hidden;
padding: 0;
position: absolute;
width: 1px;
}
label {
display: block;
cursor: pointer;
line-height: 2;
font-size: 1.2em;
}
[type="radio"] + label {
display: block;
}
[type="radio"] + label:before {
content: '';
display: inline-block;
width: 1em;
height: 1em;
vertical-align: -0.25em;
border-radius: 1em;
border: 0.125em solid #fff;
box-shadow: 0 0 0 0.15em #000;
margin-right: 0.75em;
transition: 0.5s ease all;
}
2090';
font-size: 1.5em;
line-height: 1;
vertical-align: -0.125em;
}
[type="radio"] {
border: 0;
clip: rect(0 0 0 0);
height: 1px; margin: -1px;
overflow: hidden;
padding: 0;
position: absolute;
width: 1px;
}
label {
display: block;
cursor: pointer;
line-height: 2;
font-size: 1.2em;
}
[type="radio"] + label {
display: block;
}
[type="radio"] + label:before {
content: '';
display: inline-block;
width: 1em;
height: 1em;
vertical-align: -0.25em;
border-radius: 1em;
border: 0.125em solid #fff;
box-shadow: 0 0 0 0.15em #000;
margin-right: 0.75em;
transition: 0.5s ease all;
}
Author: Harshvardhan Malpani
PHP Developer based in New Delhi, India. Working as a freelance web developer providing server deployment, website development and maintenance services.
This unique date 02 02 2020 will come after 1010 years – WRONG MATH
In dd/mm/yyyy format, 2nd February 2020 (02 02 2020) is a palindrome
In really common beliefs, whatsapp forwards were filled with this number being so rare and unique. However it would be stupid to say that such a rare date will occur only after 1010 years.
Here is how:
In whole millennium (1000 years), first few years of first few centuries have many of such dates. Even if you consider MM/DD/YYYY format, you can find a lot of such numbers in first few centuries.
Here are all of such dates in this century (2000 – 2099) in DD/MM/YYYY format
10/02/2001 20/02/2002 01/02/2010 11/02/2011 21/02/2012 02/02/2020 12/02/2021 22/02/2022 03/02/2030 13/02/2031 23/02/2032 04/02/2040 14/02/2041 24/02/2042 05/02/2050 15/02/2051 25/02/2052 06/02/2060 16/02/2061 26/02/2062 07/02/2070 17/02/2071 27/02/2072 08/02/2080 18/02/2081 28/02/2082 09/02/2090 19/02/2091 29/02/2092
10 tips for better freelancing
How to improve yourself as a freelancer? Here are 10 points to take care of:
- Communication Skills – convincing power
- Make yourself a brand, your ethics will define your future in freelancing. This will help you in scaling also
- Consistency, Focus and Dedication
- Productivity is Gold, know your value, do math and target for a monthly number
- Read!! know clients requirements in depth, if it is small task, fix already without getting the project. This approach will consume time without paying, but would probably make you better
- keep challenging yourself, keep improving
- Stay away from template bids, no body wants to know which app you did 4 years ago if the project not about an app
- Keep your portfolio updated
- Take care of clock, predict and quote project timelines intelligently
- Exceed expectations of your Client, under-promise and over-deliver
How to migrate Customers from Magento2 to WordPress?
Lets break it into 2 parts:
a. Migrate Customer data
b. Migrate Customer Passwords
1) Migrate Customer Data from Magento2 to WordPress
This is rather easy to be honest, there are several plugins for importing data from CSV and then mapping the CSV fields.
My recommended plugin is Customer/Order/Coupon CSV Import Suite by SkyVerge
It basically does everything from customer email to customer address data. It also provides column mapping and custom attribute import for all users. Also comes with multiple configuration options.
Best Free Alternative is https://wordpress.org/plugins/import-users-from-csv-with-meta
But in this one, you can not import magento2 passwords as of v 1.15.0.1
I will update about the solution very soon. So as of now only paid option is there.
2) Migrate Customer Password from Magento2 to WordPress
This wordpress plugin checks and updates passwords of users migrated from Magento2 to WordPress
Plugin Link: https://github.com/harshvardhanmalpani/migrate-password-from-magento2-to-wordpress
Requirements:
user_passcolumn will have this kind data from Magento2dcbdc524f215fd054502dcad5a23a702ec029c02ff8d7051d049f76e29927f8b:C8yVqeuPfkHWvkmipx0iKLPtOUGETpLL:1usermetatable must have ameta_key“migrated_cs” for this user,meta_valuecan be anything positive- This plugin file password-migrator.php should be in wp-content/plugins and must be an active plugin
What is does?
For new wordpress based users which dont have anything to do with magento2, it doesnt do anything
For all migrated users (those have the key “migrated_cs”), this plugin checks if input password matches old password from magento2 or not, if matched, it clears the key migrated_cs and updates the password using wordpress’ algorithm ; else results false.
How to solve MySQL server gone away error Maria Db update on cPanel and WHM?
This is related to new MariaDb upgrade from 10.1.41 to 10.1.42 and also for servers which were updated from 10.2.27 to 10.2.28
Go to solution ( Special Thanks to @Valetia )
You will see errors in following formats/messages:
- No file or input found
- MySQL Server has gone away
- Connection to MySQL Server failed
- sqlstate[hy000]: general error: 2013 lost connection to mysql server during query
- General error: 2006 MySQL server has gone away
- ERROR 2006 (HY000): MySQL server has gone away
- ERROR 2013 (HY000): Lost connection to MySQL server during query
Log files (/var/lib/mysql/$hostname.err) will have or can have any of these errors:
- assertion fail /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.28/storage/innobase/dict/dict0dict.cc line 1467
- the resulting row size is greater than maximum allowed size (8126) for a record on index leaf page
- stack_bottom = 0x0 thread_stack 0x49000 mysys/stacktrace.c:268(my_print_stacktrace)[0x5564e62807bb] sql/signal_handler.cc:209(handle_fatal_signal)[0x5564e5d4b4f5]
Other Symptoms:
/etc/init.d/mysql start
Starting MySQL/etc/init.d/mysql: line 159: kill: (10704) – No such process
[FAILED]
Solution:
yum downgrade MariaDB-* -y whmapi1 update_updateconf RPMUP=manual UPDATES=manual
(run as root #)
This will downgrade MariaDb installation to previous version
Line 2 will cancel automatic update on WHM/CPanel installations
If you are not using WHM, use line 1 only OR you can downgrade the repository individually too
yum downgrade MariaDB-server MariaDB-common MariaDB-shared MariaDB-client MariaDB-compat MariaDB-devel
References:
A basic time difference calculator in google script js
In your Google Sheet, Click “Tools” and then choose “Script Editor“. Put the code given below. Don’t forget to use function in your result column as “=dodiff(cell1,cell2)“
function dodiff(a, b) {
if (a)
a = fix(a);
if (b)
b = fix(b);
if (Array.isArray(a) && Array.isArray(b)) {
if (b[1] > a[1]) m = b[1] - a[1];
else {
m = b[1] - a[1] + 60;
b[0]--;
}
if (b[0] >= a[0]) h = b[0] - a[0];
else {
h = b[0] - a[0] + 12;
}
m = m / 60;
return (h + m).toPrecision(4);
}
}
function fix(a) {
if (a)
x = a.toString().replace(" ", '').replace("am", "").replace("pm", "").replace("PM", "").replace("AM", "");
x = x.split(":");
x[0] = parseInt(x[0]);
x[1] = parseInt(x[1]);
return x;
}
How to add Facebook Messenger for live chat on your website?
How to add facebook messenger in website so that users can chat live to your page?
Requirements:
- Page ID – you need to know what is your page id
- Whitelisted Domain – you need to add website on which you want show widget in your page’s whitelist
- Access to add/edit code in your website
1 – Getting Page ID
Go to your page, click on about, scroll down a bit and you will see Page ID
The url will look like https://www.facebook.com/pg/YOURPAGENAME/about/?ref=page_internal
The page id will look like
Alternatively, you can use tools like Find My Facebook ID – https://findmyfbid.com/
2 – Whitelisting your domain
There are 2 ways to do this, A and B both mentioned below
A) For Page Admins, the Messenger Platform also provides an easy setup tool for customizing your customer chat plugin. To use the setup tool, do the following:
- Go to Page Settings > Messenger Platform
- In the ‘Customer Chat Plugin’ section, click the ‘Set Up’ Button.
The url will look like https://www.facebook.com/YOURPAGEUSERNAME/settings/?tab=messenger_platform
OR
B) Go to Page Settings > Messenger Platform and Jump to Whitelisted Domains section
3 – Add Code in your website
Replace PAGEID with your page id obtained in step 1
HTML CODE (includes js code also)
<div id="fb-root"></div>
<div class="fb-customerchat" attribution="setup_tool" page_id="PAGEID" logged_in_greeting="Hi! How can I help you?" greeting_dialog_display="hide" logged_out_greeting="Hi! How can I help you?" theme_color="#0084ff">
</div>
<script>
window.fbAsyncInit = function() {FB.init({xfbml: true,
version: 'v4.0'});};
(function(d, s, id) {var js, fjs = d.getElementsByTagName(s)[0];
if (d.getElementById(id)) return;
js = d.createElement(s); js.id = id;
js.src = 'https://connect.facebook.net/en_US/sdk/xfbml.customerchat.js';
fjs.parentNode.insertBefore(js, fjs);
}(document, 'script', 'facebook-jssdk'));
</script>
Customization Notes:
Add or edit these common attribute value pairs
greeting_dialog_display="hide"
theme_color="#0084ff"
Details about customization: https://developers.facebook.com/docs/messenger-platform/discovery/customer-chat-plugin#customization
References:
https://developers.facebook.com/docs/messenger-platform/discovery/customer-chat-plugin
Convert dropdown attribute to text swatch in Magento2 Admin Panel
Run the following code in console:
$=new jQuery.noConflict();
$("#swatch-text-options-panel tr td:nth-child(4) input").each(function (e,el) {
$(this).parent().parent().find("td:nth-child(3) input").val($(this).val());});
How to change attribute dropdown type to multi-select in Magento 2?
Short Answer:
Not possible via Magento2 Admin Backend.
Solution:
You need to update eav_attribute table and edit information about backend_source, frontend_input etc.
Simple query for that is:
UPDATE `eav_attribute` SET `backend_model`="Magento\\Eav\\Model\\Entity\\Attribute\\Backend\\ArrayBackend", `backend_type`="varchar", `frontend_input`="multiselect", `source_model`=NULL WHERE `attribute_id`=YOUR_ATTRIBUTE_ID_INTEGER LIMIT 1
Replace YOUR_ATTRIBUTE_ID_INTEGER with your attribute_id like 355