[kh99]

So, 3 or more dots other than the one in 'gmail.com'? Maybe this:

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

and this

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

To be honest I'm not sure if trailing spaces are removed from emails addresses or not, so I don't know if you need a trailing '%'.

[giaguaro]

well this work great for registered users.
Will it work also for the quert in user awaiting email confirmation?

One more problem: it doesnt let me erase the users in the new group i created ("eliminare")

[kh99]

Originally Posted by giaguaro

well this work great for registered users.
Will it work also for the quert in user awaiting email confirmation?

You just need to add "AND usergroupid=3" to the end.

One more problem: it doesnt let me erase the users in the new group i created ("eliminare")

What are you trying to do exactly?

[giaguaro]

i go to the erase/move users in the admincp, choose "eliminare" , it list about 5000 users, i flag them all but when i flag "erase" it says "action specified is not valid" and go back to the panel

--------------- Added 07 Feb 2015 at 16:32 ---------------

well to tell the truth it doesnt allow me to move or erase the members of the group i created

[kh99]

Maybe it's too many to delete at one time. Maybe you can use the 'Join Date is Before' to try to select fewer at a time.

[giaguaro]

thanks it worked less users, everything ok!

[giaguaro]

that did work again.. so i want to thanks again for the help!

--------------- Added 24 Jan 2021 at 23:03 ---------------

a new request: code to erase directly from query php? thanks in advance