EQEmulator Forums - New Races Query

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Development::Database/World Building (https://www.eqemulator.org/forums/forumdisplay.php?f=596)

- - New Races Query (https://www.eqemulator.org/forums/showthread.php?t=34002)

This isn't groundbreaking by any means and there might be some other ones floating around there, but I threw this one together in 2 minutes to update races within the npc_types table. Here it is if you like, back up your database!

Code:

UPDATE npc_types SET race = 468 WHERE race = 37;

UPDATE npc_types SET race = 469 WHERE race = 108;

UPDATE npc_types SET race = 433 WHERE race = 40;

UPDATE npc_types SET race = 454 WHERE race = 14;

UPDATE npc_types SET race = 455 WHERE race = 48;

UPDATE npc_types SET race = 456 WHERE race = 28;

UPDATE npc_types SET race = 458 WHERE race = 54;

UPDATE npc_types SET race = 464 WHERE race = 29;

UPDATE npc_types SET race = 416 WHERE race = 34;

UPDATE npc_types SET race = 415 WHERE race = 36;

I've thought about doing this a time or two and never got around to it. It's handy to have it all in one place, thanks!

Those races are < 473 so it should also be Titanium safe.

with comments on which races

Code:

UPDATE npc_types SET race = 468 WHERE race = 37; --snake

UPDATE npc_types SET race = 469 WHERE race = 108; --eye

UPDATE npc_types SET race = 433 WHERE race = 40; --goblin

UPDATE npc_types SET race = 454 WHERE race = 14; --werewolf

UPDATE npc_types SET race = 455 WHERE race = 48; --kobold

UPDATE npc_types SET race = 456 WHERE race = 28; --Fungusman

UPDATE npc_types SET race = 458 WHERE race = 54; --orc

UPDATE npc_types SET race = 464 WHERE race = 29; --gargoyle

UPDATE npc_types SET race = 416 WHERE race = 34; --bat

UPDATE npc_types SET race = 415 WHERE race = 36; --rat



UPDATE npc_types SET race = 440 WHERE race = 38; --spider

I know that orc, goblin, kobold, bat and rat are upgradable for both Titatium and sof+. I tried the snake one but it shows up as human in titanium. Not sure about the others.