Managing members waiting for email confirmation

[giaguaro]

thanks a lot again. I am really a beginner.. and i am italian

[kh99]

Originally Posted by giaguaro

well, i need the ID of the group "users awaiting email confirmation" to tell the truth

I misunderstood this. "users awaiting email confirmation" is different than "users awaiting moderation". And I see you found the id in the admincp. Sorry, I thought you were confused, but it was me.

[giaguaro]

lol as i told you i am definitely a beginner and have a poor english.

Now:
UPDATE user SET usergroupid=eliminare WHERE usergroupid=3 AND email LIKE %sina.com%

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '%sina.com%' at line 1

what happened?

[kh99]

Originally Posted by giaguaro

lol as i told you i am definitely a beginner and have a poor english.

Now:
UPDATE user SET usergroupid=eliminare WHERE usergroupid=3 AND email LIKE %sina.com%

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '%sina.com%' at line 1

what happened?

Sorry, that's my fault. You need that in quotes, like:

UPDATE user SET usergroupid=eliminare WHERE usergroupid=3 AND email LIKE '%sina.com%'

But also, you can't have 'eliminare' there, because the usergroupid must be a number.

[giaguaro]

great! It worked.
Now i will want to go deeper...
Can i state something like "move all gmail.com account with more than 3 dots in the address"?

--------------- Added [DATE]1423324121[/DATE] at [TIME]1423324121[/TIME] ---------------

or like "everything with .pl suffix"?

[kh99]

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

SELECT username FROM user WHERE email LIKE '%.%.%.%gmail.com'

and this

SELECT username FROM user WHERE email LIKE '%.pl'

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 [DATE]1423326747[/DATE] at [TIME]1423326747[/TIME] ---------------

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.