Recent content by flam0r

  1. F

    Getting Rid of old players

    put your query between those statements: SET FOREIGN_KEY_CHECKS=0; SET FOREIGN_KEY_CHECKS = 1; and it will work.
  2. F

    Getting Rid of old players

    MyPHPadmin or whatever tool you use to manage your database (Navicat, heidiSQL, ...). Then use it as a MySQL-query. If you are totally new to this you might want to read some SQL-tutorials before you start messing with the database ;)
  3. F

    Getting Rid of old players

    Or if you just want to delete all players older than X (14 in the example below) days including those that own deployables use: SET FOREIGN_KEY_CHECKS=0; DELETE FROM `survivor` WHERE `is_dead`='1' AND `last_updated` < now() - interval 14 day; SET FOREIGN_KEY_CHECKS = 1;
Back
Top