New Races Query

[Akkadius]

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!



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;

[Tabasco]

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.

[robinreg]

with comments on which races


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.