[Lua] GUID range finder

TrinityCore Development TrinityCore Code Discussion
1

Finally got annoyed enough to write a thing that finds unused GUID ranges for me. Someone told me to post it on forums so here you go.

Requirements:

[ol][li]Command-line Lua interpreter[/li]
[li]mysql in your path[/li]
[/ol]
Usage: [FONT=courier new]lua findguid.lua

[ [ []]][/FONT]

[ul][li]Username defaults to [FONT=courier new]trinity[/FONT], host defaults to [FONT=courier new]127.0.0.1[/FONT], world-schema defaults to [FONT=courier new]world[/FONT].[/li]
[li]num can be negative, in which case the script will terminate on the first exact match (so -2 will terminate on the first empty range of exactly 2 guids). Use it for small nums.[/li]
[li]table is the table name of any TC table that has a ‘guid’ auto-increment (creature, gameobject etc.)[/li]
[/ul]
https://gist.github.com/Treeston/1dbfc6a22d59ea625485

2

You know, this exists for a long time too https://github.com/TrinityCore/TC-Unused-Guid-Search

3

:smiley:

4

It is also integrated in Keira2 and in TC-JSON-API