How remove all un verified users?

Plugin does not have such feature.
You can do it from DB side.

Is that also need for free plugin or purchased plugin?

No, you go to database and remove data from t_user table based on specified criteria

No, you go to database and remove data from t_user table based on specified criteria

How find in t_user table is verified or not ?

Plugin use own table t_sms_verification, s_status = 'VERIFIED'

Plugin use own table t_sms_verification, s_status = 'VERIFIED'

Do you think is possible? 5000+ unverified users


check one table is verified or not then find that user in another table


can you create function for this

Something like this could work.
Test well before using.
Use on your own risk.
You may need to change foreign key on t_user_description to cascade (or disable)

DELETE FROM oc_t_user
where
  s_phone_mobile <> ''
  and dt_user_reg_date < '2023-01-01'
  and s_phone_mobile in (select s_phone from oc_t_sms_verification where  s_status <> 'VERIFIED')

Something like this could work.
Test well before using.
Use on your own risk.
You may need to change foreign key on t_user_description to cascade (or disable)

Code: [Select]

DELETE FROM oc_t_user
where
  s_phone_mobile <> ''
  and dt_user_reg_date < '2023-01-01'
  and s_phone_mobile in (select s_phone from oc_t_sms_verification where  s_status <> 'VERIFIED')

its work.

issue if someone not click send otp then not update status verified or not


How solve this?

Sorry did not get your question.

Sorry did not get your question.

If user click SEND OTP only update VERIFIED OR NOT

Please check

I am still not sure what are you talkiing about

Something like this could work.
Test well before using.
Use on your own risk.
You may need to change foreign key on t_user_description to cascade (or disable)

Code: [Select]

DELETE FROM oc_t_user
where
  s_phone_mobile <> ''
  and dt_user_reg_date < '2023-01-01'
  and s_phone_mobile in (select s_phone from oc_t_sms_verification where  s_status <> 'VERIFIED')

This code not working fully.

not removed all unverified users

Try to put coalesce funtion on status.