SQL Query help

[lerxst2112]

You should probably do a query with what you think you want to change and look at the results to make sure there's nothing in it you don't want to change first.

Something like this:

SELECT `id`,`name`,`hp` FROM `npc_types` WHERE `level` = 50 && `merchant_id` = 0 && `name` NOT LIKE "Guard%" AND `id` NOT IN (SELECT `npcid` FROM `pets`) ORDER BY `hp` DESC;

It looks like you might want to exclude Priest of Discord, some bankers, maybe the defenders, boats, spires, bouncers, etc. You could probably limit it to not change anything over a particular hp value except there's some fabled mobs mixed in with the high hp stuff that you might want to change. *shrug*

The method I used to exclude pets is exact but a little less efficient that the id range. It also may not be what you want since there's a few NPC pets "#Pixtt_%" in the table that would get skipped. My pet table appears to have all of the player pets in the range of 500 to 685, but my database is a little old. You can check yours like this:

SELECT `type`,`npcid` FROM `pets` ORDER BY `npcid` DESC;

There's not that many, so you can just scroll through the list and see where to start and stop, or if there are any you do want to reduce in that range. I'm not entirely sure how some of them are summoned.

[reddogut]

I wanted to take a moment and thank everyone for helping me with my mysql questions.... Now, how about this one?

When I run

UPDATE npc_types SET STR = AVG(STR) WHERE LEVEL = 50;

I get a MYSQL error 1111, invalid use of group function

I scoured the internet to try to figure out why and I can't seem to find it.

Thanks again,

Mike

[Raewan]

Originally Posted by reddogut

I wanted to take a moment and thank everyone for helping me with my mysql questions.... Now, how about this one?

When I run

UPDATE npc_types SET STR = AVG(STR) WHERE LEVEL = 50;

I get a MYSQL error 1111, invalid use of group function

I scoured the internet to try to figure out why and I can't seem to find it.

Thanks again,

Mike

instead of LEVEL , make it `LEVEL`, its looking at the word level like a command not a column name so you have to surround it with the grave accent (backtick) symbol.

[reddogut]

Tried that... no joy.