UPWORK/ODESK guru: Tips and Tricks for clients

skype: upwork.link , email: info@upwork.link

Archive for June, 2014

How do I set Skype status before login in

without comments

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.

Read the rest of this entry »

Written by spectre

June 8th, 2014 at 12:18 pm

Posted in Tips and Tricks

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

without comments

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');

Written by spectre

June 6th, 2014 at 9:54 pm

Posted in Mysql