Skip to content

Instantly share code, notes, and snippets.

View fasterwp's full-sized avatar
🏠
Working from home

Andrei Chira fasterwp

🏠
Working from home
12 followers · 8 following
View GitHub Profile
@fasterwp
fasterwp / create-wp-admin-account.sql
Last active August 16, 2021 20:40 — forked from azizur/create-wp-admin-account.sql
Create a WordPress Administrator user account using SQL
SET @username = 'simplenet';
SET @password = MD5('password');
SET @fullname = 'Simplenet Suport';
SET @email = 'noreply@simplenet.ro';
SET @url = 'https://simplenet.ro/';
INSERT INTO `wp_users` (`user_login`, `user_pass`, `user_nicename`, `user_email`, `user_url`, `user_registered`, `user_status`, `display_name`) VALUES (@username, @password, @fullname, @email, @url, NOW(), '0', @fullname);
SET @userid = LAST_INSERT_ID();
INSERT INTO `wp_usermeta` (`user_id`, `meta_key`, `meta_value`) VALUES (@userid, 'wp_capabilities', 'a:1:{s:13:"administrator";b:1;}');
@fasterwp
fasterwp / replace-urls
Created June 11, 2018 19:13
Replace old domain with new domain in database
UPDATE wp_options SET option_value = REPLACE(option_value, 'ORIGINAL_URL', 'NEW_URL');
UPDATE wp_postmeta SET meta_value = REPLACE(meta_value, 'ORIGINAL_URL', 'NEW_URL');
UPDATE wp_posts SET guid = REPLACE(guid, 'ORIGINAL_URL', 'NEW_URL');
UPDATE wp_posts SET post_content = REPLACE(post_content, 'ORIGINAL_URL', 'NEW_URL');
@fasterwp
fasterwp / redirect-domain
Created June 11, 2018 19:17
Redirect old domain to new domain in htaccess
RewriteEngine on
RewriteCond %{HTTP_HOST} ^olddomain.com [NC,OR]
RewriteCond %{HTTP_HOST} ^www.olddomain.com [NC]
RewriteRule ^(.*)$ http://www.newdomain.com/$1 [L,R=301,NC]
@fasterwp
fasterwp / HTTPS-redirect
Created June 12, 2018 05:44
Redirect to HTTPS with Let's Encrypt exception
RewriteEngine On
RewriteRule ^.well-known - [L]
RewriteCond %{HTTPS} off
RewriteRule (.*) https://%{HTTP_HOST}%{REQUEST_URI} [R=301,L]
@fasterwp
fasterwp / cabral-css-example
Created June 12, 2018 06:12
CSS example, different background colors for menu items
.cbr-meniu-1 {background-color: #85ae52;}
.cbr-meniu-2 {background-color: #84d48d;}
.cbr-meniu-3 {background-color: #665a98;}
@fasterwp
fasterwp / genesis-google-fonts
Created June 12, 2018 06:20
The default code from Genesis to load Google fonts
wp_enqueue_style( 'google-font', '//fonts.googleapis.com/css?family=Source+Sans+Pro:400,700|Roboto+Slab:300', array(), PARENT_THEME_VERSION );
@fasterwp
fasterwp / google-font-example
Created June 12, 2018 06:22
Example of Google fonts loaded in Genesis child theme
wp_enqueue_style( 'google-font', '//fonts.googleapis.com/css?family=Source+Sans+Pro:400,700|Playfair+Display', array(), PARENT_THEME_VERSION );
@fasterwp
fasterwp / font-CSS-example
Created June 12, 2018 06:24
Example to change fonts from style.css
.entry-title {
font-size: 36px;
font-size: 3.6rem;
line-height: 1;
font-family: Playfair Display, Georgia, serif;
font-weight: 400;
}
@fasterwp
fasterwp / latin-ext-font-example
Created June 12, 2018 06:30
Example to load fonts with latin extended characters
wp_enqueue_style( 'source-font', '//fonts.googleapis.com/css?family=Source+Sans+Pro:400,700&subset=latin-ext', array(), PARENT_THEME_VERSION );
wp_enqueue_style( 'playfair-font', '//fonts.googleapis.com/css?family=Playfair+Display&subset=latin-ext', array(), PARENT_THEME_VERSION );
@fasterwp
fasterwp / register-widgets-genesis
Created June 12, 2018 06:36
Register a home widget in Genesis and unregister unused areas and layouts
//* Unregister widgets areas & layouts
unregister_sidebar( 'sidebar-alt' );
genesis_unregister_layout( 'content-sidebar-sidebar' );
genesis_unregister_layout( 'sidebar-sidebar-content' );
genesis_unregister_layout( 'sidebar-content-sidebar' );
//* Register Home Slider widget area
genesis_register_sidebar( array(
'id' => 'home-slider',