[DiscordArchive] so I guess there isn't any interest in not having duplicate spawns in TDB?
[DiscordArchive] so I guess there isn't any interest in not having duplicate spawns in TDB?
Archived author: ZaDarkSide • Posted: 2023-04-15T00:37:08.508000+00:00
Original source
so I guess there isn't any interest in not having duplicate spawns in TDB?
Archived author: ZaDarkSide • Posted: 2023-04-15T00:37:45.712000+00:00
Original source
because even if my first query was faulty, the second kind of shows there are duplicates indeed
Archived author: ModoX • Posted: 2023-04-15T00:39:05.753000+00:00
Original source
<@429055059754483713> sure there is interest in not having duplicates, but those dups are kinda old and none bothered to clean them up yet (just like we still have several 335 spawns in master which are no longer present on retail)
Archived author: ZaDarkSide • Posted: 2023-04-15T00:40:02.506000+00:00
Original source
I want to make a query that checks the duplicates and deletes them
Archived author: ModoX • Posted: 2023-04-15T00:40:11.230000+00:00
Original source
you gotta delete them smart though
Archived author: ZaDarkSide • Posted: 2023-04-15T00:40:11.831000+00:00
Original source
keeps just 1 spawn
Archived author: ModoX • Posted: 2023-04-15T00:40:16.594000+00:00
Original source
keep in mind they could be used by other tables
Archived author: ZaDarkSide • Posted: 2023-04-15T00:40:27.217000+00:00
Original source
yeah I know
Archived author: ZaDarkSide • Posted: 2023-04-15T00:41:07.058000+00:00
Original source
but once we have a query that does that okay to a reasonable degree, we can run it on each TDB release
Archived author: ZaDarkSide • Posted: 2023-04-15T00:41:17.993000+00:00
Original source
and no more dupes