====== CMS: Wordpress - SQL команды ======

==== Пароль пользователя ====

<code sql>
> update wp_users SET user_pass = MD5(‘VeryStr0ngPSWD’) WHERE user_login='username’ LIMIT 1;
</code>

==== Почта администратора ====

<code sql>
> UPDATE wp_options SET option_value = replace(option_value, 'old-email@foobar.com', 'vova@kermlin.ru') WHERE option_name = 'admin_email';
</code>

==== Адрес сайта ====

Изменить адрес сайта с oldurl.com на newulr.com

<code sql>
> SELECT * FROM wp_options WHERE option_name = 'home' OR option_name = 'siteurl';
> UPDATE wp_options  SET option_value = replace(option_value, 'http://oldurl.com', 'https://newurl.com') WHERE option_name = 'home' OR option_name = 'siteurl';
</code>

==== Ссылки в постах ====

<code sql>
> UPDATE wp_posts    SET guid = replace(guid, 'http://oldurl.com','https://newurl.com');
> UPDATE wp_posts    SET post_content = replace(post_content, 'http://oldurl.com', 'https://newurl.com');
> UPDATE wp_postmeta SET meta_value = replace(meta_value,'http://oldurl.com','https://newurl.com');
</code>

==== Meta, комментарии, ссылки ====

<code sql>
> UPDATE wp_usermeta SET meta_value = replace(meta_value, 'http://oldurl.com','https://newurl.com');
> UPDATE wp_comments SET comment_content = replace(comment_content , 'http://oldurl.com','https://newurl.com');
> UPDATE wp_links    SET link_url = replace(link_url, 'http://oldurl.com','https://newurl.com');
</code>

==== Изображдения ====

<code sql>
> UPDATE wp_posts SET post_content = replace(post_content, 'http://oldurl.com', 'https://newurl.com');
> UPDATE wp_links SET link_image = replace(link_image, 'http://oldurl.com','https://newurl.com');
> UPDATE wp_posts SET guid = replace(guid, 'http://oldurl.com','https://newurl.com');
</code>

==== Добавить администратора ====

<code sql>
INSERT INTO `wp_users` (`user_login`, `user_pass`, `user_nicename`, `user_email`, 
`user_status`)
 VALUES ('new-admin-name', MD5('new-admin-password'), 'firstname lastname', 'new-admin@email', '0');
 
 INSERT INTO `wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) 
 VALUES (NULL, (Select max(id) FROM wp_users), 
 'wp_capabilities', 'a:1:{s:13:"administrator";s:1:"1";}');
 
 INSERT INTO `wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) 
 VALUES (NULL, (Select max(id) FROM wp_users), 'wp_user_level', '10');
</code>