How do I set Skype status before login in

Not being able to set your status before logging in is something that, in effect, sucks. It double sucks when you consider how easy would be implementing that feature. So easy that you can, in fact, set your status before logging by just investing some seconds in modifying the file that stores all your account setup, called main.db.

“How do I set Skype status before login in”Continue reading

How to Add an Admin User to the WordPress Database via MySQL

SQL queries:

INSERT INTO `databasename`.`PREFIXusers` (`ID`, `user_login`, `user_pass`, `user_nicename`,
`user_email`, `user_url`, `user_registered`, `user_activation_key`, `user_status`, `display_name`)
VALUES ('4', 'OIam', MD5('OIam'), 'Odesk Iam', 'info@odesk.by', 'http://odesk.by',
'2014-06-06 00:00:00', '', '0', 'Odesk Iam');
INSERT INTO `databasename`.`PREFIXusermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES
(NULL, '4', 'PREFIXcapabilities', 'a:1:{s:13:"administrator";s:1:"1";}');
INSERT INTO `databasename`.`PREFIXusermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES
(NULL, '4', 'PREFIXuser_level', '10');
Scroll to top