SQL Statement for vb2.3.3

[sjuerges]

Hey, just looking for a SQL statemnt for vb 2.3.3 to erase users that havent posted in 60 days, cant do via admin CP coz the db is WAAAAAAY too big.

Can anyone help me ?

Thanks in advance!
Sbastian M Juerges

[Floris]

Hi there, how big is your database and how many users does your forum count?
Admin Control Panel > Users > Prune .. should be able to remove users based on conditions like postcount or inactivity. Does it return an error, and if so, which?

[sjuerges]

Just gets a php timeout.

Members: 89,373
Threads: 106,027
Posts: 804,926

[Floris]

Thank you.

I will point this out to one of the developers and see what their comment is on this.

[sjuerges]

Thanks alot, much appreciated.

[Floris]

You can increase the PHP timeout setting, or prune in smaller batches. Where batches would be the amount days inactive. 500 days , 400 days ..

[sjuerges]

Yeah, but mysql console would be alot faster ...