Need someone to check a simple SQL code will +rep

[dude891]

Hi I barely know anything about SQL and I need help. Since theres so much mass spawns on this gm server I play on I needed a code to delete them all. Here is the code:

Delete from creature_spawns WHERE entry = '23863', map = '1'

I'm guessing that may look very stupid to some people on this website. What I want the code to do is delete every spawn of Zul'jin from The Eastern Kingdoms. I'm just asking you guys since I don't want to mess up the server. If you tell me if its right, or if you tell me its wrong and give me the correct code, its +Rep either way.

Edit: Dangit! forgot to put a tag! Sorry guys. Hope I don't get an infraction

[Juicyz]

U could always just make a macro that does .npc delete then .cheat fly plus .mod speed (x) and click on every npc and use the marco. Incase if you want that npc there.

[dude891]

Yes but I'm theres a bug that won't let you do that on the private server I'm on. But if you donate you get access to the database. Sorry I forgot to post a tag.

[Juicyz]

wow really that must be one messed up server.... almost every one would have the db access...... u can delete the things fomr the creature_spawns maybe if you know which are which

[Juicyz]

I dont know if that code would work... never had to do that

[latruwski]

Hi I barely know anything about SQL and I need help. Since theres so much mass spawns on this gm server I play on I needed a code to delete them all. Here is the code:

Delete from creature_spawns WHERE entry = '23863', map = '1'

I'm guessing that may look very stupid to some people on this website. What I want the code to do is delete every spawn of Zul'jin from The Eastern Kingdoms. I'm just asking you guys since I don't want to mess up the server. If you tell me if its right, or if you tell me its wrong and give me the correct code, its +Rep either way.

Edit: Dangit! forgot to put a tag! Sorry guys. Hope I don't get an infraction

delete from creature_spawns where entry = 23863 and map = 0

will delete all creatures with ID=23863 on map = 0
istn eastern kingdoms 0 ?

note: an important thing to do before you make changes to your DB is make a backup

grtz

[dude891]

The thing is It won't let me see the creature spawns I want and the only way to delete them is through queries. (I think)

[Juicyz]

O... "The Candy Leet" Just gave you a solution O well i tried

[latruwski]

The thing is It won't let me see the creature spawns I want and the only way to delete them is through queries. (I think)

if you wnt to see the spawns you can use query too to filter them

select from creature_spawns where entry = xxx

will show all spawns of creature with entryID xxx for example... queries are easy to make ... check my usefull database queries... you can make a lot out of them if you wnt

http://www.mmowned.com/forums/emulat...tabase+queries
http://www.mmowned.com/forums/emulat...tabase+queries


grtz

[dude891]

Thanks +Rep

Edit: It says I need to spread reputation around first

[latruwski]

Thanks +Rep

Edit: It says I need to spread reputation around first

hahahah you need to rep 10 other people before you can rep me again :P but a "thanks" is ok for me