Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Bug when user deleted !

Status
Not open for further replies.
Newbie Spellweaver
Joined
Jul 29, 2011
Messages
41
Reaction score
13
When a player's account will be deleted
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");
		}
	}
 
Elite Diviner
Joined
Sep 3, 2011
Messages
404
Reaction score
100
My problem too

Does anyone knows how can completely remove an account with it's village and information ?
 
Status
Not open for further replies.
Back
Top