focusoft

I made a backup. And this working.

I found the solution:

BE SURE TO BACK UP YOUR DATABASE FIRST!!

To select users who have no posts or comments, you can use this:

——————————–

SELECT *
FROM wp_users
WHERE ID NOT IN
(SELECT post_author FROM wp_posts
UNION SELECT user_id FROM wp_comments)

——————————–

Then, replace ‘SELECT *’ with ‘DELETE’ to actually delete the records.
You will then have some ‘orphan’ records in wp_usermeta. Select them with this:

——————————–

SELECT *
FROM wp_usermeta
WHERE user_id NOT IN
(SELECT ID FROM wp_users)

——————————–

Then, replace ‘SELECT *’ with ‘DELETE’ to actually delete the records.

I see already a post like this but no recommendations or solutions if really working

www.ads-software.com/support/topic/confirmation-on-how-to-mass-delete-0-post-registered-users?replies=3

I think you must add or change in admin-settings.php:

array(
‘name’ => __( ‘Currency’, ‘wpdeals’ ),
‘desc’ => __(“This controls what currency prices are listed at in the deals and which currency gateways will take payments in.”, ‘wpdeals’ ),
‘tip’ => ”,
‘id’ => ‘wpdeals_currency’,
‘css’ => ‘min-width:300px;’,
‘std’ => ‘GBP’,
‘type’ => ‘select’,
‘class’ => ‘chosen_select’,
‘options’ => array_unique(apply_filters(‘wpdeals_currencies’, array(
‘USD’ => __( ‘US Dollars ($)’, ‘wpdeals’ ),
‘EUR’ => __( ‘Euros (€)’, ‘wpdeals’ ),
‘GBP’ => __( ‘Pounds Sterling (￡)’, ‘wpdeals’ ),
‘AUD’ => __( ‘Australian Dollars ($)’, ‘wpdeals’ ),
‘BRL’ => __( ‘Brazilian Real ($)’, ‘wpdeals’ ),
‘CAD’ => __( ‘Canadian Dollars ($)’, ‘wpdeals’ ),
‘CZK’ => __( ‘Czech Koruna (K?)’, ‘wpdeals’ ),
‘DKK’ => __( ‘Danish Krone’, ‘wpdeals’ ),
‘HKD’ => __( ‘Hong Kong Dollar ($)’, ‘wpdeals’ ),
‘HUF’ => __( ‘Hungarian Forint’, ‘wpdeals’ ),
‘IDR’ => __( ‘Indonesia (IDR)’, ‘wpdeals’ ),
‘ILS’ => __( ‘Israeli Shekel’, ‘wpdeals’ ),
‘JPY’ => __( ‘Japanese Yen (￥)’, ‘wpdeals’ ),
‘MYR’ => __( ‘Malaysian Ringgits’, ‘wpdeals’ ),
‘MXN’ => __( ‘Mexican Peso ($)’, ‘wpdeals’ ),
‘NZD’ => __( ‘New Zealand Dollar ($)’, ‘wpdeals’ ),
‘NOK’ => __( ‘Norwegian Krone’, ‘wpdeals’ ),
‘PHP’ => __( ‘Philippine Pesos’, ‘wpdeals’ ),
‘PLN’ => __( ‘Polish Zloty’, ‘wpdeals’ ),
‘SGD’ => __( ‘Singapore Dollar ($)’, ‘wpdeals’ ),
‘SEK’ => __( ‘Swedish Krona’, ‘wpdeals’ ),
‘CHF’ => __( ‘Swiss Franc’, ‘wpdeals’ ),
‘TWD’ => __( ‘Taiwan New Dollars’, ‘wpdeals’ ),
‘THB’ => __( ‘Thai Baht’, ‘wpdeals’ ),
‘TRY’ => __( ‘Turkish Lira (TL)’, ‘wpdeals’ ),
‘ZAR’ => __( ‘South African rand (R)’, ‘wpdeals’ ),

I think you must add or change in admin-settings.php:

array(
‘name’ => __( ‘Currency’, ‘wpdeals’ ),
‘desc’ => __(“This controls what currency prices are listed at in the deals and which currency gateways will take payments in.”, ‘wpdeals’ ),
‘tip’ => ”,
‘id’ => ‘wpdeals_currency’,
‘css’ => ‘min-width:300px;’,
‘std’ => ‘GBP’,
‘type’ => ‘select’,
‘class’ => ‘chosen_select’,
‘options’ => array_unique(apply_filters(‘wpdeals_currencies’, array(
‘USD’ => __( ‘US Dollars ($)’, ‘wpdeals’ ),
‘EUR’ => __( ‘Euros (€)’, ‘wpdeals’ ),
‘GBP’ => __( ‘Pounds Sterling (£)’, ‘wpdeals’ ),
‘AUD’ => __( ‘Australian Dollars ($)’, ‘wpdeals’ ),
‘BRL’ => __( ‘Brazilian Real ($)’, ‘wpdeals’ ),
‘CAD’ => __( ‘Canadian Dollars ($)’, ‘wpdeals’ ),
‘CZK’ => __( ‘Czech Koruna (Kč)’, ‘wpdeals’ ),
‘DKK’ => __( ‘Danish Krone’, ‘wpdeals’ ),
‘HKD’ => __( ‘Hong Kong Dollar ($)’, ‘wpdeals’ ),
‘HUF’ => __( ‘Hungarian Forint’, ‘wpdeals’ ),
‘IDR’ => __( ‘Indonesia (IDR)’, ‘wpdeals’ ),
‘ILS’ => __( ‘Israeli Shekel’, ‘wpdeals’ ),
‘JPY’ => __( ‘Japanese Yen (¥)’, ‘wpdeals’ ),
‘MYR’ => __( ‘Malaysian Ringgits’, ‘wpdeals’ ),
‘MXN’ => __( ‘Mexican Peso ($)’, ‘wpdeals’ ),
‘NZD’ => __( ‘New Zealand Dollar ($)’, ‘wpdeals’ ),
‘NOK’ => __( ‘Norwegian Krone’, ‘wpdeals’ ),
‘PHP’ => __( ‘Philippine Pesos’, ‘wpdeals’ ),
‘PLN’ => __( ‘Polish Zloty’, ‘wpdeals’ ),
‘SGD’ => __( ‘Singapore Dollar ($)’, ‘wpdeals’ ),
‘SEK’ => __( ‘Swedish Krona’, ‘wpdeals’ ),
‘CHF’ => __( ‘Swiss Franc’, ‘wpdeals’ ),
‘TWD’ => __( ‘Taiwan New Dollars’, ‘wpdeals’ ),
‘THB’ => __( ‘Thai Baht’, ‘wpdeals’ ),
‘TRY’ => __( ‘Turkish Lira (TL)’, ‘wpdeals’ ),
‘ZAR’ => __( ‘South African rand (R)’, ‘wpdeals’ ),