Can someone help me with the syntax on a couple MySQL commands?
I want to reset the hit points on all mobs/NPC's within a set level range. For example all mobs/NPC's between levels 1 and 10 get set to 10 hit points.
UPDATE npc_types SET HP = 10 WHERE LEVEL ??????
I want to be able to search the items table for all items containing a set of characters. For example, I want to search for all items with the word 'boots' in the name.
SELECT * FROM items WHERE NAME = 'boots';
But I know that = doesn't work unless I have the exact name, like 'steel toed boots'.
Now this is UNTESTED and since I don't have the table definitions in front of me I can't guarantee that this is correct. This is the syntax for updating a range.
UPDATE npc_types SET HP = 10 WHERE LEVEL >= 1 and LEVEL <= 10;
The % act as wildcards. Also note that if your mysql db is on a linux system, the names will be case sensitive (so boots would match 'Journeyman's boots' but not 'Journeyman's Boots' for example).
Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.