When a player's account will be deleted
Her village still remains
Please check
Not Working this function in Automation.php !!!!
Her village still remains
Please check
Not Working this function in Automation.php !!!!
Code:
private function clearDeleting() {
global $database;
$ourFileHandle = fopen("GameEngine/Prevention/cleardeleting.txt", 'w');
fclose($ourFileHandle);
$needDelete = $database->getNeedDelete();
if(count($needDelete) > 0) {
foreach($needDelete as $need) {
$needVillage = $database->getVillagesID($need['uid']); //wref
foreach($needVillage as $village) {
$q = "DELETE FROM ".TB_PREFIX."abdata where wref = ".$village['wref'];
$database->query($q);
$q = "DELETE FROM ".TB_PREFIX."bdata where wid = ".$village['wref'];
$database->query($q);
$q = "DELETE FROM ".TB_PREFIX."enforcement where vref = ".$village['wref'];
$database->query($q);
$q = "DELETE FROM ".TB_PREFIX."fdata where vref = ".$village['wref'];
$database->query($q);
$q = "DELETE FROM ".TB_PREFIX."market where vref = ".$village['wref'];
$database->query($q);
$q = "DELETE FROM ".TB_PREFIX."movement where to = ".$village['wref']." or from = ".$village['wref'];
$database->query($q);
$q = "DELETE FROM ".TB_PREFIX."odata where wref = ".$village['wref'];
$database->query($q);
$q = "DELETE FROM ".TB_PREFIX."research where vref = ".$village['wref'];
$database->query($q);
$q = "DELETE FROM ".TB_PREFIX."tdata where vref = ".$village['wref'];
$database->query($q);
$q = "DELETE FROM ".TB_PREFIX."training where vref =".$village['wref'];
$database->query($q);
$q = "DELETE FROM ".TB_PREFIX."units where vref =".$village['wref'];
$database->query($q);
$q = "DELETE FROM ".TB_PREFIX."vdata where wref = ".$village['wref'];
$database->query($q);
$q = "UPDATE ".TB_PREFIX."wdata set occupied = 0 where id = ".$village['wref'];
$database->query($q);
}
$q = "DELETE FROM ".TB_PREFIX."mdata where target = ".$need['uid']." or owner = ".$need['uid'];
$database->query($q);
$q = "DELETE FROM ".TB_PREFIX."ndata where uid = ".$need['uid'];
$database->query($q);
$q = "DELETE FROM ".TB_PREFIX."users where id = ".$need['uid'];
$database->query($q);
}
}
if(file_exists("GameEngine/Prevention/cleardeleting.txt")) {
unlink("GameEngine/Prevention/cleardeleting.txt");
}
}