Vergleich install/resources/upgrade13.php - 1.8.6 - 1.8.16

  Keine Änderungen   Hinzugefügt   Modifiziert   Entfernt
Zeile 43Zeile 43
			$db->write_query("ALTER TABLE ".TABLE_PREFIX."users DROP KEY username");
		}


 
			$db->write_query("ALTER TABLE ".TABLE_PREFIX."users DROP KEY username");
		}


		$query = $db->simple_select("users", "username, uid", "1=1 GROUP BY username HAVING count(*) > 1");

		$query = $db->simple_select("users", "username, uid", "1=1 GROUP BY uid, username HAVING count(*) > 1");

		while($user = $db->fetch_array($query))
		{
			$db->update_query("users", array('username' => $user['username']."_dup".$user['uid']), "uid='{$user['uid']}'", 1);

		while($user = $db->fetch_array($query))
		{
			$db->update_query("users", array('username' => $user['username']."_dup".$user['uid']), "uid='{$user['uid']}'", 1);