Deleting Objects

[FuzzyPillow]

So i'm running a mangos server on ytdb and some gm on my server thought that it would be a good idea to spawn a whole bunch of candles all over gm island.There has to be over 2k of them i know i can do .gobject target then .gobject delete. But there is way too many to do that is there a way for me just to delete it out of the db?. Another question how can a edit what gm levels allow.

+Rep To anyone that can help me.

[Kiev]

Well go into gobject_spawns i would presume, or what the table is named, and go to the last page and look for the ones with the same ID, and then delete all that.

And im not sure how to on MaNGOS

[FuzzyPillow]

Yea i tryed that but couldent find it.

[leonne]

The table should be called gameobject. Also to edit wht a gm can do. Theres a table called commands. There you can set what rank of gm can use what command.

[RyeRye]

Go into your Gameobject_spawns (or whatever it is for mangos), and then go to the very last page, and it'll show the recently spawned gameobjects.

[Confucius]

If that doesn't work, just make a macro, .go sel .go del and spam the hell out of it

[kreegoth]

Well if the candles arent supposed to be there at all you could run a query in navicat or whichever program you use something to the effect of

Select * from gameobject where id = IDofCandle and map = Mapidtheyareon

Having found the objects then just change it to

Delete from gameobject where id = IDofCandle and map = Mapidtheyareon

As always with DB work though backup first.