Skip to content

Instantly share code, notes, and snippets.

View utopianfool's full-sized avatar

Philip Porter utopianfool

View GitHub Profile
@utopianfool
utopianfool / detect-browsers.js
Created August 28, 2020 11:50
Detect user's browser and run related example functions
/**
* Detect Browsers functions
*/
/* Get IE or Edge browser version */
var version = detectIE();
if (version === false) {
document.getElementById('result').innerHTML = '<s>IE/Edge</s>';
@utopianfool
utopianfool / update-linux-servers.md
Created August 28, 2020 11:41
Update linux servers - the basics

Update Servers

Log in to servers with admin@ then switch users "su" before running following commands:

Find what updates are available

apt-get update

Upgrade the found updates

@utopianfool
utopianfool / update-wordpress-urls.sql
Created August 28, 2020 11:38
Update WordPress URLs in the database instead of find and replace in a text editor
/* Update WordPress URLs in database */
UPDATE wp_options SET option_value = replace(option_value, 'http://www.old-domain.com', 'http://www.new-domain.com') WHERE option_name = 'home' OR option_name = 'siteurl';
UPDATE wp_posts SET guid = replace(guid, 'http://www.old-domain.com','http://www.new-domain.com');
UPDATE wp_posts SET post_content = replace(post_content, 'http://www.old-domain.com', 'http://www.new-domain.com');
UPDATE wp_postmeta SET meta_value = replace(meta_value, 'http://www.old-domain.com', 'http://www.new-domain.com');
@utopianfool
utopianfool / add-new-user-to-wordpress-database.sql
Last active August 28, 2020 11:27
Add a new user to WordPress database in SQL
/* Add new user to wordpress database */
/*
* Replace the number "4" with an available number in the user_id field
* Only user name and email address is necessary to create a new user
*/
INSERT INTO `databasename`.`wp_users` (`ID`, `user_login`, `user_pass`, `user_nicename`, `user_email`, `user_url`, `user_registered`, `user_activation_key`, `user_status`, `display_name`) VALUES ('4', 'demo', MD5('demo'), 'Your Name', 'test@yourdomain.com', 'http://www.test.com/', '2011-06-07 00:00:00', '', '0', 'Your Name');
INSERT INTO `databasename`.`wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, '4', 'wp_capabilities', 'a:1:{s:13:"administrator";s:1:"1";}');
@utopianfool
utopianfool / tar-zip-everything.md
Last active November 4, 2023 12:44
Tar zip everything keeping permissions and including hidden files

Tar Zip Everything

Keeping permissions and hidden files inside the root folder

Run this from the command line inside the main folder you want to zip:

shopt -s dotglob && tar -czvpf websitename.tar.gz . && shopt -u dotglob
@utopianfool
utopianfool / .htaccess
Created August 28, 2020 10:41
Force https in .htaccess file
# Force https
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteCond %{SERVER_PORT} 80
RewriteRule ^(.*)$ https://%{HTTP_HOST}/$1 [R=301,L]
</IfModule>
@utopianfool
utopianfool / hide-api-keys-from-github.md
Last active August 27, 2020 20:38
Hide API keys from github using Javascript