XF 1.5 Delete IP of multiple members

[Bob_R]

I know how to change the IP of a member. I know how to delete all members IP's. I know how to delete a single IP of a member.

My question is can multiple members IP's be deleted? Not all members but more than one member at a time?

 

[Paul B]

There is no option to selectively delete IP records.

 

[Bob_R]

So, I can only do one at a time?

DELETE
FROM xf_ip
WHERE user_id = 1

 

[Paul B]

You could use an array or write a small script to loop through.

 

[Bob_R]

OK, thanks there are only 18. I'll just do it one at a time. I thought you could seperate the user id's by comma.

DELETE
FROM xf_ip
WHERE user_id = 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18

 

[wang]

Use IN instead of = in the query to select multiple users.

 

[SevgiForum]

HOW TO DO !

Sample
multiple
DELETE FROM m WHERE user_id IN (3,1.5.7)

complete