Cleaning Stats

[MrDalle]

Hey!

i want to "clean" the stats page on map.fswire.net

Any good idea how to do this?

[Ysurac]

You need to TRUNCATE all stats_* table and delete the last_update_stats in config table.

 TRUNCATE TABLE stats_aircraft; TRUNCATE TABLE stats_airline; TRUNCATE TABLE stats_airport; TRUNCATE TABLE stats_callsign; TRUNCATE TABLE stats_country; TRUNCATE TABLE stats_flight; TRUNCATE TABLE stats_marine; TRUNCATE TABLE stats_marine_country; TRUNCATE TABLE stats_marine_type; TRUNCATE TABLE stats_owner; TRUNCATE TABLE stats_pilot; TRUNCATE TABLE stats_registration; TRUNCATE TABLE stats_source; TRUNCATE TABLE stats_tracker; TRUNCATE TABLE stats_tracker_country; TRUNCATE TABLE stats_tracker_type; DELETE FROM config WHERE name = 'last_update_stats'; DELETE FROM config WHERE name = 'last_update_stats_marine'; DELETE FROM config WHERE name = 'last_update_stats_tracker';