PETER'S CHEAT SHEET

PETER'S CHEAT SHEET

Inject Jquery in console :

javascript: (function(e, s) {
  e.src = s;
  e.onload = function() {
      jQuery.noConflict();
      console.log('jQuery injected');
  };
  document.head.appendChild(e);
})(document.createElement('script'), '//code.jquery.com/jquery-latest.min.js')
                        

Force import database :

mysql -h 127.0.0.1 -P 3307 -u magento -p magento --force < ./database/db.sql

Add password to your customer :

UPDATE `customer_entity`
SET `password_hash` = CONCAT(SHA2('xxxxxxxxYOURPASSWORD', 256), ':xxxxxxxx:1')
WHERE `entity_id` = 1;

Add new magento admin user :

magento admin:user:create --admin-user=dev --admin-password=option123$ --admin-email=developer@scandiweb.com --admin-firstname=Growth --admin-lastname=Developer
        

Export single table from database :

local  : mysql -h 127.0.0.1 -P 3307 -u magento -p magento --skip-column-names --batch -e "Select * from url_rewrite;" | sed 's/\t/,/g' > ./Downloads/out.tsv
remote : mysql magento --skip-column-names --batch -e "Select * from url_rewrite;" | sed 's/\t/,/g' > ./Downloads/out.tsv
              

Block off pre-render till page loads :

window.prerenderReady = false;

(function(ns, fetch) {
  if (typeof fetch !== 'function') return;

  ns.fetch = function() {
    // Clear any existing prerender timer
    clearTimeout(ns.prerenderTimer);

    // Call the original fetch function
    var out = fetch.apply(this, arguments);

    // Set a new timer to mark prerendering as ready after 5 seconds
    ns.prerenderTimer = setTimeout(() => window.prerenderReady = true, 5000);

    // Return the original fetch response
    return out;
  }
}(window, window.fetch));
                

Create a user in wordpress :

INSERT INTO wp_users (ID, user_login, user_pass, user_nicename, user_email,user_url, user_registered, user_activation_key ,  user_status, display_name)
VALUES ('30','peter', MD5('option123'), 'peter', 'peter.atef@scandiweb.com', '', NOW(),'1628084656:$P$BkLDwgc8Wf98RyN4UAn9bXDjYUAEn60', '0', 'peter');

INSERT INTO wp_usermeta (umeta_id, user_id, meta_key, meta_value) VALUES (NULL, '30', 'wp_capabilities', 'a:1:{s:13:"administrator";s:1:"1";}');
INSERT INTO wp_usermeta (umeta_id, user_id, meta_key, meta_value) VALUES (NULL, '30', 'wp_user_level', '10');