Get rid of Disqus

Recently I read an article on HN (Hacker News) Replacing Disqus with Github Comments and decided to drop the Disqus commenting system on this site. A long time ago I’ve added Disqus to my page because of it was easy to use and had out-of-the-box spam prevention. The cost of it as I see now was a heavy breach in privacy and site performance. When I read the article mentioned above I was shocked what I was forcing on people visiting my site. Just to give you an idea what’s going on:

Continue reading “Get rid of Disqus”

Create WordPress admin user with sql only

If you don’t have access to you WordPress website anymore, but still can update the MySQL database. You can easily add a new admin user with this sql script:

USE <database>;
 
SET @username = '<username>';
SET @password = MD5('<password>');
SET @fullname = '<Firstname Lastname>';
SET @email = '<login@example.com>';
SET @url = '<http://example.com/>';
 
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";s:1:"1";}');
INSERT INTO `wp_usermeta` (`user_id`, `meta_key`, `meta_value`) VALUES (@userid, 'wp_user_level', '10');

Get the latest version of this snippet here: https://gist.github.com/25d9f243fc20532cb1b5

Manage multiple WordPress sites with Jetpack

Hurray, WordPress 4.1 and the Jetpack Plugin 3.3 has been released.
Jetpack is a must have plugin for your WordPress site, it offers tons of new functions and integrates your blog neatly with your WordPress.com account. If you haven’t already installed it, head right now to your plugin manager!
With the last Update the developer have added a great feature. It’s now possible to manage the plugins for multiple WordPress sites at one location.
Here’s a screenshot, which shows the plugins admin panel of WordPress.com.
Continue reading “Manage multiple WordPress sites with Jetpack”