aur3

Will be all good, but just to be secure make a copy of database if something happens ( but will be all good ) - I prefer to run automatically and there is no issue. - But in your case I suggest buy better VPS or Dedicated server where you can store Database of your forum. Because if you using WEB hosting loading times it's rough I assume.

Yes I use this plugin but I need for "Profile cover" I mean this section in profile page ( where I need photo example ) :

That doesn't change anything so it's the same. - You can set cron where it's will be delete every setted time. ( full simple example below) - Or you can set schedule for it ( full example below ) - Or you can play manually like this ( below example with how many ) Here is cron where its will be deleting every 1 hour php file delete_topics.php , so what's left to do is just add database info in to this and set up cron properly ( to set up cron you can via your hosting provider ( if the provider is not old you can do via dashboard easy.. ) but if the hosting provider do not have this function then you need to make manually <?php function deleteOldTopics() { $servername = "localhost"; $username = ""; $password = ""; $dbname = ""; try { $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password); $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $sql = "DELETE FROM forums_topics WHERE start_date < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 2 YEAR)) LIMIT 100"; $stmt = $conn->prepare($sql); $stmt->execute(); echo "[Success]"; } catch(PDOException $e) { echo "[ERROR] : " . $e->getMessage(); } $conn = null; } deleteOldTopics(); ?> Here is example of deleting 100 topics in phpmyadmin: DELETE FROM forums_topics WHERE start_date < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 2 YEAR)) LIMIT 100; Here is simple (in phpmyadmin) example of setting up schedule for deleting posts here every 1 hour will be deleting 100 topics ( or how many you want if needed change it ) and you can keep it forever ) I personally have similar schedule for my large databases where I delete over 20k rows every 7 minutes and it works perfectly without any crashes or something like that. CREATE EVENT delete_old_topics ON SCHEDULE EVERY 1 HOUR DO BEGIN DECLARE rows_affected INT; START TRANSACTION; DELETE FROM forums_topics WHERE start_date < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 2 YEAR)) LIMIT 100; SELECT ROW_COUNT() INTO rows_affected; COMMIT; IF rows_affected > 0 THEN SELECT CONCAT(rows_affected, ' topics deleted.') AS Message; ELSE SELECT 'No topics deleted.' AS Message; END IF; END;

Hello, - I was wondering is there a plugin or other way somehow to make a list or something like ( avatar hub ) where you are able to choose pre uploaded cover photos? - Cover photo in profile page. Thank you for your answers!

Hey, easy solution. This SQL command delete topics older than 2 years. DELETE FROM forums_topics WHERE start_date < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 2 YEAR)); If your table related with topics change as well, and if start_date different change it as well because this code is based w/ ips 4.7.15 version. If you don't really now let me know here I will help you P.S Always make back-up of your database to keep it safe before doing big changes.

Simple reason because they are discontinue this type of stuff. And I assume is because Invision 5 is coming out soon. And when Invision 5 will be realised it's will everything different starting from applications, plugins and of course UI