امتیازها
113
راهحلها
27
- محل سکونت
- England
- نوشتهها
- 26,276
- تاریخ ثبتنام
- ۱۳۹۹٫۰۴٫۰۶
- پسندها
- 3,286
- سن
- 29
- وب سایت
- xenforo.xyz
- نسخه PHP
- 7.3
- نسخه زنفورو
- xenforo 2.2
Anyone have a query that could prune the IP table selectively?
Specifically - keep only IPs for those in Banned Usergroup (usergroup x) AND keep ALL IPs for the last 1 year. Truncate the rest.
Our table is very very large, going back 17 years, but it's not needed for the most part. What is needed is a record of banned folks so that future research can be done if needed (rejoins, alt ids, etc). And then recent year or so for anything that may pop up new.
Specifically - keep only IPs for those in Banned Usergroup (usergroup x) AND keep ALL IPs for the last 1 year. Truncate the rest.
Our table is very very large, going back 17 years, but it's not needed for the most part. What is needed is a record of banned folks so that future research can be done if needed (rejoins, alt ids, etc). And then recent year or so for anything that may pop up new.