New Years resolutions anyone?

[ArChron]

Here's half of the the races table, which made the last post too long to, well, post, so combine this code segment with the next code segment for the full SQL.

USE `ax_peq`;
CREATE TABLE `races` (
  `race_id` INTEGER NOT NULL COMMENT 'ID',
  `race_desc` CHAR(60) NOT NULL DEFAULT 'Un-named' COMMENT 'Description',
  PRIMARY KEY(`race_id`)
)
ENGINE = MYISAM;

INSERT INTO `races` VALUES (0,'Soldier')
INSERT INTO `races` VALUES (1,'Human')
INSERT INTO `races` VALUES (2,'Barbarian')
INSERT INTO `races` VALUES (3,'Erudite')
INSERT INTO `races` VALUES (4,'Wood Elf')
INSERT INTO `races` VALUES (5,'High Elf')
INSERT INTO `races` VALUES (6,'Dark Elf')
INSERT INTO `races` VALUES (7,'Half Elf')
INSERT INTO `races` VALUES (8,'Dwarf')
INSERT INTO `races` VALUES (9,'Troll')
INSERT INTO `races` VALUES (10,'Ogre')
INSERT INTO `races` VALUES (11,'Halfling')
INSERT INTO `races` VALUES (12,'Gnome')
INSERT INTO `races` VALUES (13,'Aviak')
INSERT INTO `races` VALUES (14,'Were Wolf')
INSERT INTO `races` VALUES (15,'Brownie')
INSERT INTO `races` VALUES (16,'Centaur')
INSERT INTO `races` VALUES (17,'Golem')
INSERT INTO `races` VALUES (18,'Giant / Cyclops')
INSERT INTO `races` VALUES (19,'Trakenon')
INSERT INTO `races` VALUES (20,'Doppleganger')
INSERT INTO `races` VALUES (21,'Evil Eye')
INSERT INTO `races` VALUES (22,'Beetle')
INSERT INTO `races` VALUES (23,'Kerra')
INSERT INTO `races` VALUES (24,'Fish')
INSERT INTO `races` VALUES (25,'Fairy')
INSERT INTO `races` VALUES (26,'Froglok')
INSERT INTO `races` VALUES (27,'Froglok Ghoul')
INSERT INTO `races` VALUES (28,'Fungusman')
INSERT INTO `races` VALUES (29,'Gargoyle')
INSERT INTO `races` VALUES (30,'Gasbag')
INSERT INTO `races` VALUES (31,'Gelatinous Cube')
INSERT INTO `races` VALUES (32,'Ghost')
INSERT INTO `races` VALUES (33,'Ghoul')
INSERT INTO `races` VALUES (34,'Giant Bat')
INSERT INTO `races` VALUES (35,'Giant Eel')
INSERT INTO `races` VALUES (36,'Giant Rat')
INSERT INTO `races` VALUES (37,'Giant Snake')
INSERT INTO `races` VALUES (38,'Giant Spider')
INSERT INTO `races` VALUES (39,'Gnoll')
INSERT INTO `races` VALUES (40,'Goblin')
INSERT INTO `races` VALUES (41,'Gorilla')
INSERT INTO `races` VALUES (42,'Wolf')
INSERT INTO `races` VALUES (43,'Bear')
INSERT INTO `races` VALUES (44,'Freeport Guards')
INSERT INTO `races` VALUES (45,'Demi Lich')
INSERT INTO `races` VALUES (46,'Imp')
INSERT INTO `races` VALUES (47,'Griffin')
INSERT INTO `races` VALUES (48,'Kobold')
INSERT INTO `races` VALUES (49,'Lava Dragon')
INSERT INTO `races` VALUES (50,'Lion');
INSERT INTO `races` VALUES (51,'Lizard Man')
INSERT INTO `races` VALUES (52,'Mimic')
INSERT INTO `races` VALUES (53,'Minotaur')
INSERT INTO `races` VALUES (54,'Orc')
INSERT INTO `races` VALUES (55,'Human Beggar')
INSERT INTO `races` VALUES (56,'Pixie')
INSERT INTO `races` VALUES (57,'Dracnid')
INSERT INTO `races` VALUES (58,'Solusek Ro')
INSERT INTO `races` VALUES (59,'Bloodgills')
INSERT INTO `races` VALUES (60,'Skeleton')
INSERT INTO `races` VALUES (61,'Shark')
INSERT INTO `races` VALUES (62,'Tunare')
INSERT INTO `races` VALUES (63,'Tiger')
INSERT INTO `races` VALUES (64,'Treant')
INSERT INTO `races` VALUES (65,'Vampire')
INSERT INTO `races` VALUES (66,'Rallos Zek')
INSERT INTO `races` VALUES (67,'Highpass Citizen')
INSERT INTO `races` VALUES (68,'Tentacle')
INSERT INTO `races` VALUES (69,'Will O Wisp')
INSERT INTO `races` VALUES (70,'Zombie')
INSERT INTO `races` VALUES (71,'Qeynos Citizen')
INSERT INTO `races` VALUES (72,'Ship')
INSERT INTO `races` VALUES (73,'Launch')
INSERT INTO `races` VALUES (74,'Piranha')
INSERT INTO `races` VALUES (75,'Elemental')
INSERT INTO `races` VALUES (76,'Puma')
INSERT INTO `races` VALUES (77,'Neriak Citizen')
INSERT INTO `races` VALUES (78,'Erudite Citizen')
INSERT INTO `races` VALUES (79,'Bixie')
INSERT INTO `races` VALUES (80,'Reanimated Hand')
INSERT INTO `races` VALUES (81,'Rivervale Citizen')
INSERT INTO `races` VALUES (82,'Scarecrow')
INSERT INTO `races` VALUES (83,'Skunk')
INSERT INTO `races` VALUES (84,'Snake Elemental')
INSERT INTO `races` VALUES (85,'Spectre')
INSERT INTO `races` VALUES (86,'Sphinx')
INSERT INTO `races` VALUES (87,'Armadillo')
INSERT INTO `races` VALUES (88,'Clockwork Gnome')
INSERT INTO `races` VALUES (89,'Drake')
INSERT INTO `races` VALUES (90,'Halas Citizen')
INSERT INTO `races` VALUES (91,'Alligator')
INSERT INTO `races` VALUES (92,'Grobb Citizen')
INSERT INTO `races` VALUES (93,'Oggok Citizen')
INSERT INTO `races` VALUES (94,'Kaladim Citizen')
INSERT INTO `races` VALUES (95,'Cazic Thule')
INSERT INTO `races` VALUES (96,'Cockatrice')
INSERT INTO `races` VALUES (97,'Daisy Man')
INSERT INTO `races` VALUES (98,'Elf Vampire')
INSERT INTO `races` VALUES (99,'Denizen')
INSERT INTO `races` VALUES (100,'Dervish');
INSERT INTO `races` VALUES (101,'Efreeti')
INSERT INTO `races` VALUES (102,'Froglok Tadpole')
INSERT INTO `races` VALUES (103,'Kedge')
INSERT INTO `races` VALUES (104,'Leech')
INSERT INTO `races` VALUES (105,'Swordfish')
INSERT INTO `races` VALUES (106,'Felguard')
INSERT INTO `races` VALUES (107,'Mammoth')
INSERT INTO `races` VALUES (108,'Eye of Zomm')
INSERT INTO `races` VALUES (109,'Wasp')
INSERT INTO `races` VALUES (110,'Mermaid')
INSERT INTO `races` VALUES (111,'Harpie')
INSERT INTO `races` VALUES (112,'Fayguard')
INSERT INTO `races` VALUES (113,'Drixie')
INSERT INTO `races` VALUES (114,'Ghost Ship')
INSERT INTO `races` VALUES (115,'Clam')
INSERT INTO `races` VALUES (116,'Sea Horse')
INSERT INTO `races` VALUES (117,'Ghost Dwarf')
INSERT INTO `races` VALUES (118,'Erudite Ghost')
INSERT INTO `races` VALUES (119,'Sabertooth Cat')
INSERT INTO `races` VALUES (120,'Wolf Elemental')
INSERT INTO `races` VALUES (121,'Gorgon')
INSERT INTO `races` VALUES (122,'Dragon Skeleton')
INSERT INTO `races` VALUES (123,'Innoruuk')
INSERT INTO `races` VALUES (124,'Unicorn')
INSERT INTO `races` VALUES (125,'Pegasus')
INSERT INTO `races` VALUES (126,'Djinn')
INSERT INTO `races` VALUES (127,'Invisible Man')
INSERT INTO `races` VALUES (128,'Iksar')
INSERT INTO `races` VALUES (129,'Scorpion')
INSERT INTO `races` VALUES (130,'Vah Shir')
INSERT INTO `races` VALUES (131,'Sarnak')
INSERT INTO `races` VALUES (132,'Draglock')
INSERT INTO `races` VALUES (133,'Lycanthrope')
INSERT INTO `races` VALUES (134,'Mosquito')
INSERT INTO `races` VALUES (135,'Rhino')
INSERT INTO `races` VALUES (136,'Xalgoz')
INSERT INTO `races` VALUES (137,'Kunark Goblin')
INSERT INTO `races` VALUES (138,'Yeti')
INSERT INTO `races` VALUES (139,'Iksar Citizen')
INSERT INTO `races` VALUES (140,'Forest Giant')
INSERT INTO `races` VALUES (141,'Boat')
INSERT INTO `races` VALUES (142,'Nearest Doodad (Rock, torch, rug, etc.) in sight.')
INSERT INTO `races` VALUES (143,'Nearest Tree in sight.')
INSERT INTO `races` VALUES (144,'Burynai')
INSERT INTO `races` VALUES (145,'Goo')
INSERT INTO `races` VALUES (146,'Spectral Sarnak')
INSERT INTO `races` VALUES (147,'Spectral Iksar')
INSERT INTO `races` VALUES (148,'Kunark Fish')
INSERT INTO `races` VALUES (149,'Iksar Scorpion')
INSERT INTO `races` VALUES (150,'Erollisi');
INSERT INTO `races` VALUES (151,'Tribunal')
INSERT INTO `races` VALUES (152,'Bertoxxulous')
INSERT INTO `races` VALUES (153,'Bristlebane')
INSERT INTO `races` VALUES (154,'Fay Drake')
INSERT INTO `races` VALUES (155,'Sarnak Skeleton')
INSERT INTO `races` VALUES (156,'Ratman')
INSERT INTO `races` VALUES (157,'Wyvern')
INSERT INTO `races` VALUES (158,'Wurm')
INSERT INTO `races` VALUES (159,'Devourer')
INSERT INTO `races` VALUES (160,'Iksar Golem')
INSERT INTO `races` VALUES (161,'Iksar Skeleton')
INSERT INTO `races` VALUES (162,'Man Eating Plant')
INSERT INTO `races` VALUES (163,'Raptor')
INSERT INTO `races` VALUES (164,'Sarnak Golem')
INSERT INTO `races` VALUES (165,'Water Dragon')
INSERT INTO `races` VALUES (166,'Iksar Hand')
INSERT INTO `races` VALUES (167,'Succulent')
INSERT INTO `races` VALUES (168,'Flying Monkey')
INSERT INTO `races` VALUES (169,'Brontotherium')
INSERT INTO `races` VALUES (170,'Snow Dervish')
INSERT INTO `races` VALUES (171,'Dire Wolf')
INSERT INTO `races` VALUES (172,'Manticore')
INSERT INTO `races` VALUES (173,'Totem')
INSERT INTO `races` VALUES (174,'Cold Spectre')
INSERT INTO `races` VALUES (175,'Enchanted Armor')
INSERT INTO `races` VALUES (176,'Snow Bunny')
INSERT INTO `races` VALUES (177,'Walrus')
INSERT INTO `races` VALUES (178,'Rock-gem Men')
INSERT INTO `races` VALUES (181,'Yak Man')
INSERT INTO `races` VALUES (182,'Faun')
INSERT INTO `races` VALUES (183,'Coldain')
INSERT INTO `races` VALUES (184,'Velious Dragons')
INSERT INTO `races` VALUES (185,'Hag')
INSERT INTO `races` VALUES (186,'Hippogriff')
INSERT INTO `races` VALUES (187,'Siren')
INSERT INTO `races` VALUES (188,'Frost Giant')
INSERT INTO `races` VALUES (189,'Storm Giant')
INSERT INTO `races` VALUES (190,'Ottermen')
INSERT INTO `races` VALUES (191,'Walrus Man')
INSERT INTO `races` VALUES (192,'Clockwork Dragon')
INSERT INTO `races` VALUES (193,'Abhorent')
INSERT INTO `races` VALUES (194,'Sea Turtle')
INSERT INTO `races` VALUES (195,'Black and White Dragons')
INSERT INTO `races` VALUES (196,'Ghost Dragon')
INSERT INTO `races` VALUES (197,'Ronnie Test')
INSERT INTO `races` VALUES (198,'Prismatic Dragon')
INSERT INTO `races` VALUES (199,'ShikNar')

There are more efficient ways to write these big data INSERTs, but this is eminently more editable for my likes...

[ArChron]

And here's the third half...

INSERT INTO `races` VALUES (200,'Rockhopper');
INSERT INTO `races` VALUES (201,'Underbulk')
INSERT INTO `races` VALUES (202,'Grimling')
INSERT INTO `races` VALUES (203,'Vacuum Worm')
INSERT INTO `races` VALUES (204,'Evan Test')
INSERT INTO `races` VALUES (205,'Kahli Shah')
INSERT INTO `races` VALUES (206,'Owlbear')
INSERT INTO `races` VALUES (207,'Rhino Beetle,')
INSERT INTO `races` VALUES (208,'Vampyre')
INSERT INTO `races` VALUES (209,'Earth Elemental')
INSERT INTO `races` VALUES (210,'Air Elemental')
INSERT INTO `races` VALUES (211,'Water Elemental')
INSERT INTO `races` VALUES (212,'Fire Elemental')
INSERT INTO `races` VALUES (213,'Wetfang Minnow')
INSERT INTO `races` VALUES (214,'Thought Horror')
INSERT INTO `races` VALUES (215,'Tegi')
INSERT INTO `races` VALUES (216,'Horse')
INSERT INTO `races` VALUES (217,'Shissar')
INSERT INTO `races` VALUES (218,'Fungal Fiend')
INSERT INTO `races` VALUES (219,'Vampire Volatalis')
INSERT INTO `races` VALUES (220,'StoneGrabber')
INSERT INTO `races` VALUES (221,'Scarlet Cheetah')
INSERT INTO `races` VALUES (222,'Zelniak')
INSERT INTO `races` VALUES (223,'Lightcrawler')
INSERT INTO `races` VALUES (224,'Shade')
INSERT INTO `races` VALUES (225,'Sunflower')
INSERT INTO `races` VALUES (226,'Sun Revenant')
INSERT INTO `races` VALUES (227,'Shrieker')
INSERT INTO `races` VALUES (228,'Galorian')
INSERT INTO `races` VALUES (229,'Netherbian')
INSERT INTO `races` VALUES (230,'Akheva')
INSERT INTO `races` VALUES (231,'Spire Spirit')
INSERT INTO `races` VALUES (232,'Sonic Wolf')
INSERT INTO `races` VALUES (233,'Ground Shaker')
INSERT INTO `races` VALUES (234,'Vah Shir Skeleton')
INSERT INTO `races` VALUES (235,'Mutant Humanoid')
INSERT INTO `races` VALUES (236,'Seru')
INSERT INTO `races` VALUES (237,'Recuso')
INSERT INTO `races` VALUES (238,'Vah Shir King')
INSERT INTO `races` VALUES (239,'Vah Shir Guard')
INSERT INTO `races` VALUES (240,'Teleport Man')
INSERT INTO `races` VALUES (241,'Lujein')
INSERT INTO `races` VALUES (242,'Naiad')
INSERT INTO `races` VALUES (243,'Nymph')
INSERT INTO `races` VALUES (244,'Ent')
INSERT INTO `races` VALUES (245,'Wrinnfly')
INSERT INTO `races` VALUES (246,'Tarew Marr')
INSERT INTO `races` VALUES (247,'Solusek Ro')
INSERT INTO `races` VALUES (248,'Clockwork Golem')
INSERT INTO `races` VALUES (249,'Clockwork Brain')
INSERT INTO `races` VALUES (250,'Spectral Banshee');
INSERT INTO `races` VALUES (251,'Guard of Justice')
INSERT INTO `races` VALUES (252,'PoM Castle')
INSERT INTO `races` VALUES (253,'Disease Boss')
INSERT INTO `races` VALUES (254,'Solusek Ro Guard')
INSERT INTO `races` VALUES (255,'Bertoxxulous')
INSERT INTO `races` VALUES (256,'New Tribunal')
INSERT INTO `races` VALUES (257,'Terris Thule')
INSERT INTO `races` VALUES (258,'Vegerog')
INSERT INTO `races` VALUES (259,'Crocodile')
INSERT INTO `races` VALUES (260,'Bat')
INSERT INTO `races` VALUES (261,'Slarghilug')
INSERT INTO `races` VALUES (262,'Tranquilion')
INSERT INTO `races` VALUES (263,'Tin Soldier')
INSERT INTO `races` VALUES (264,'Nightmare Wraith')
INSERT INTO `races` VALUES (265,'Malarian')
INSERT INTO `races` VALUES (266,'Knight of Pestilence')
INSERT INTO `races` VALUES (267,'Lepertoloth')
INSERT INTO `races` VALUES (268,'Bubonian Boss')
INSERT INTO `races` VALUES (269,'Bubonian Underling')
INSERT INTO `races` VALUES (270,'Pusling')
INSERT INTO `races` VALUES (271,'Water Mephit')
INSERT INTO `races` VALUES (272,'Stormrider')
INSERT INTO `races` VALUES (273,'Junk Beast')
INSERT INTO `races` VALUES (274,'Broken Clockwork')
INSERT INTO `races` VALUES (275,'Giant Clockwork')
INSERT INTO `races` VALUES (276,'Clockwork Beetle')
INSERT INTO `races` VALUES (277,'Nightmare Goblin')
INSERT INTO `races` VALUES (278,'Karana')
INSERT INTO `races` VALUES (279,'Blood Raven')
INSERT INTO `races` VALUES (280,'Nightmare Gargoyle')
INSERT INTO `races` VALUES (281,'Mouths of Insanity')
INSERT INTO `races` VALUES (282,'Skeletal Horse')
INSERT INTO `races` VALUES (283,'Saryn')
INSERT INTO `races` VALUES (284,'Fennin Ro')
INSERT INTO `races` VALUES (285,'Tormentor')
INSERT INTO `races` VALUES (286,'Necromancer Priest')
INSERT INTO `races` VALUES (287,'Nightmare')
INSERT INTO `races` VALUES (288,'New Rallos Zek')
INSERT INTO `races` VALUES (289,'Tallon Zek')
INSERT INTO `races` VALUES (290,'Vallon Zek')
INSERT INTO `races` VALUES (291,'Air Mephit')
INSERT INTO `races` VALUES (292,'Earth Mephit')
INSERT INTO `races` VALUES (293,'Fire Mephit')
INSERT INTO `races` VALUES (294,'Nightmare Mephit')
INSERT INTO `races` VALUES (295,'Zebuxoruk')
INSERT INTO `races` VALUES (296,'Mithaniel Marr')
INSERT INTO `races` VALUES (297,'Knightmare Rider')
INSERT INTO `races` VALUES (298,'The Rathe')
INSERT INTO `races` VALUES (299,'Xegony')
INSERT INTO `races` VALUES (300,'Balrog');
INSERT INTO `races` VALUES (301,'Unknown')
INSERT INTO `races` VALUES (302,'Lobster Monster')
INSERT INTO `races` VALUES (303,'Pheonix')
INSERT INTO `races` VALUES (304,'Tiamat')
INSERT INTO `races` VALUES (305,'Bear (new)')
INSERT INTO `races` VALUES (306,'Earth Golem')
INSERT INTO `races` VALUES (307,'Iron Golem')
INSERT INTO `races` VALUES (308,'Storm Golem')
INSERT INTO `races` VALUES (309,'Air Golem')
INSERT INTO `races` VALUES (310,'Wood Golem')
INSERT INTO `races` VALUES (311,'Fire Golem')
INSERT INTO `races` VALUES (312,'Water Golem')
INSERT INTO `races` VALUES (313,'Veiled Gargoyle')
INSERT INTO `races` VALUES (314,'Lynx')
INSERT INTO `races` VALUES (315,'Squid')
INSERT INTO `races` VALUES (316,'Frog')
INSERT INTO `races` VALUES (317,'Flying Serpent')
INSERT INTO `races` VALUES (318,'Tactics Soldier')
INSERT INTO `races` VALUES (319,'Armored Boar')
INSERT INTO `races` VALUES (320,'Djinni')
INSERT INTO `races` VALUES (321,'Boar')
INSERT INTO `races` VALUES (322,'Knight of Marr')
INSERT INTO `races` VALUES (323,'Black Armor')
INSERT INTO `races` VALUES (324,'Knightmare Knight')
INSERT INTO `races` VALUES (325,'Rallos Ogre')
INSERT INTO `races` VALUES (326,'Arachnid')
INSERT INTO `races` VALUES (327,'Crystal Arachnid')
INSERT INTO `races` VALUES (328,'Tower Model')
INSERT INTO `races` VALUES (330,'Froglok(LoY)')
INSERT INTO `races` VALUES (335,'Troll Pirate')
INSERT INTO `races` VALUES (336,'Troll Shaman?')
INSERT INTO `races` VALUES (337,'Troll Pirate #2')
INSERT INTO `races` VALUES (345,'Luggald')
INSERT INTO `races` VALUES (346,'Armored Luggald')
INSERT INTO `races` VALUES (347,'Robed Luggald')
INSERT INTO `races` VALUES (348,'Drogmor')
INSERT INTO `races` VALUES (349,'Froglok Skeleton')
INSERT INTO `races` VALUES (350,'Froglok Zombie')
INSERT INTO `races` VALUES (353,'Unarmored DnD-Style Kobold?')
INSERT INTO `races` VALUES (354,'Lightly Armored DnD-Style Kobold?')
INSERT INTO `races` VALUES (355,'Heavily Armored DnD-Style Kobold?')
INSERT INTO `races` VALUES (356,'Scaled Wolf (Neutral Gender)')
INSERT INTO `races` VALUES (357,'Undead Drogmor')
INSERT INTO `races` VALUES (365,'Valdoon Kel`Novar')
INSERT INTO `races` VALUES (367,'New Skeleton Model')
INSERT INTO `races` VALUES (372,'Evil Whirlwind')
INSERT INTO `races` VALUES (378,'Treasure Chest')
INSERT INTO `races` VALUES (379,'Clay Vase')
INSERT INTO `races` VALUES (381,'Weapons Rack')
INSERT INTO `races` VALUES (382,'Coffin')
INSERT INTO `races` VALUES (383,'Skull Mounted on Bone Triangle');
INSERT INTO `races` VALUES (384,'Jester')
INSERT INTO `races` VALUES (387,'Construct')
INSERT INTO `races` VALUES (388,'Hynid')
INSERT INTO `races` VALUES (389,'Turepta')
INSERT INTO `races` VALUES (390,'Cragbeast')
INSERT INTO `races` VALUES (391,'Mite')
INSERT INTO `races` VALUES (392,'Ukun')
INSERT INTO `races` VALUES (393,'Ixt')
INSERT INTO `races` VALUES (394,'Ikaav')
INSERT INTO `races` VALUES (395,'Aneuk')
INSERT INTO `races` VALUES (396,'Kyv')
INSERT INTO `races` VALUES (397,'Noc')
INSERT INTO `races` VALUES (398,'Ra`Tuk')
INSERT INTO `races` VALUES (399,'Tunat muram cuu`Vauax')

[ArChron]

And the fourth half... I guess that makes two whole posts...

What was that someone said about a forum being the wrong place to store code stuff?

INSERT INTO `races` VALUES (400,'Huvul')
INSERT INTO `races` VALUES (402,'Mastruq')
INSERT INTO `races` VALUES (403,'Male Trusik--Lacks Shawl')
INSERT INTO `races` VALUES (404,'Ship')
INSERT INTO `races` VALUES (405,'OoW golem type')
INSERT INTO `races` VALUES (406,'Overlord Mata Muram')
INSERT INTO `races` VALUES (407,'Lighting warrior models')
INSERT INTO `races` VALUES (408,'Pirylien fire mob (RSS)')
INSERT INTO `races` VALUES (410,'Feran')
INSERT INTO `races` VALUES (411,'Pirylien fire mob (RSS)')
INSERT INTO `races` VALUES (412,'Chimera')
INSERT INTO `races` VALUES (413,'Dragorn')
INSERT INTO `races` VALUES (414,'Murkglider')
INSERT INTO `races` VALUES (415,'New Rat Model')
INSERT INTO `races` VALUES (416,'New Bat Model')
INSERT INTO `races` VALUES (417,'Frost Pyrilien')
INSERT INTO `races` VALUES (418,'Discordling')
INSERT INTO `races` VALUES (419,'Girplan')
INSERT INTO `races` VALUES (420,'Hanvar / arch magus model')
INSERT INTO `races` VALUES (425,'Crystal Model')
INSERT INTO `races` VALUES (427,'Large Purse Model')
INSERT INTO `races` VALUES (430,'New Dracolich')
INSERT INTO `races` VALUES (431,'Green halo with green smoke')
INSERT INTO `races` VALUES (432,'DoN regular drake')
INSERT INTO `races` VALUES (433,'Goblin (DoN model)')
INSERT INTO `races` VALUES (434,'Dragon-Horse...thing.')
INSERT INTO `races` VALUES (435,'Lava Dragon')
INSERT INTO `races` VALUES (436,'Basilisk (new model)')
INSERT INTO `races` VALUES (437,'East-Asian Gold Dragon (Snake-like)')
INSERT INTO `races` VALUES (438,'Storm(?) Dragon Model')
INSERT INTO `races` VALUES (439,'Puma')
INSERT INTO `races` VALUES (440,'Normal Spider (new model, tutorial, don)')
INSERT INTO `races` VALUES (441,'Large-abdomen Normal Spider')
INSERT INTO `races` VALUES (442,'Guardian of the Sands')
INSERT INTO `races` VALUES (445,'Dragon Egg (from Vishimtar event, etc..)')
INSERT INTO `races` VALUES (446,'East-Asian Crystal Dragon (Statue?)')
INSERT INTO `races` VALUES (447,'Smoldering bluish-purple ball (look into this)');
INSERT INTO `races` VALUES (448,'Statue, sparkly hands; similar to 442, no anims.')
INSERT INTO `races` VALUES (449,'Pile of (Spider?) Eggs')
INSERT INTO `races` VALUES (450,'Lava Spider')
INSERT INTO `races` VALUES (451,'Large-abdomen Lava Spider')
INSERT INTO `races` VALUES (452,'Shadow(?) Dragon')
INSERT INTO `races` VALUES (453,'Burly Ancient-Rome-Looking Warrior')
INSERT INTO `races` VALUES (454,'werewolf (new model)')
INSERT INTO `races` VALUES (455,'kobold (new model)')
INSERT INTO `races` VALUES (456,'Sporali')
INSERT INTO `races` VALUES (457,'Gnomework')
INSERT INTO `races` VALUES (458,'New Orc')
INSERT INTO `races` VALUES (459,'Corathus')
INSERT INTO `races` VALUES (460,'Coral(?) Model')
INSERT INTO `races` VALUES (462,'a cocoon')
INSERT INTO `races` VALUES (464,'gargoyle (new type)')
INSERT INTO `races` VALUES (465,'witheran')
INSERT INTO `races` VALUES (467,'Shilskin')
INSERT INTO `races` VALUES (469,'new evil eye model (same as OoW one)')
INSERT INTO `races` VALUES (470,'Hanvar looking mob (without axe)')
INSERT INTO `races` VALUES (472,'mech boar mount model')
INSERT INTO `races` VALUES (473,'fairy (new model)')
INSERT INTO `races` VALUES (433,'Goblin, new')
INSERT INTO `races` VALUES (436,'Basilisk')
INSERT INTO `races` VALUES (454,'Werewolf')
INSERT INTO `races` VALUES (455,'Kobold')
INSERT INTO `races` VALUES (456,'Sporali')
INSERT INTO `races` VALUES (458,'Orc')
INSERT INTO `races` VALUES (464,'Gargoyle')
INSERT INTO `races` VALUES (469,'Evil eye (with teeths and tentacles)')
INSERT INTO `races` VALUES (470,'Hanvar without axe')
INSERT INTO `races` VALUES (472,'Mecha boar')
INSERT INTO `races` VALUES (473,'Unknown');

[Angelox]

Very nice , and needed!
Although you got much more than I ever found, I attached my "data.php" which I've been building on , I already added a bunch of yours, but it also has corrections and a few more "unknowns" added;
http://www.nahunta.org/~angelox/files/data.php.txt

[Aerewen]

Part of the problem with the lack of a public database is the fact that we don't have a common numbering system for anyone to modify from...

think about it... someone gives you a SQL file that adds say 200 doors to your database that populate pok, abyssmal sea, and say uh shadowhaven as an example... those doors will auto increment their id field so the doors that might be numbered 200-400 on your database might be 500-700 on someone else's

now yeah i know doors dont really matter because the id means nothing really, but think about the npc_types table, the spawngroups spawn2 spawnentry etc etc

we have no default numbering system for those ID's that *DO* matter...

a while back the concept of zonenumber * 1000 was applies to the npc_types table... but it's not consistent. some older zones still have npc's with numbers out of that scope. and the other problem is that we cant do a mass modify script using names extracted from spawn lists because there are a ton of different rat, bat, orc, goblin, giant, etc etc mobs in different zones and i can only hope that they all have different npc_type values in the existing database or we're a lot worse off than i thought we were lol

If we were to take the time to mod the database to a default numbering scheme... then we could start adding to a larger database because we would know that every door, spawngroup, spawn entry, etc etc in the plane of knowledge has an id value between x and y which means that if I make a perfect copy of the live servers' POK i can make 2 SQL files to distribute it.

one does DELETE FROM `blah` WHERE `id` >= 202000 AND `id` < 203000 etc etc

and the other adds my new stuff

reboot and tadaa. but the way it is now... i had to create a new table which was a copy of the npc_types table, then delete 3 rows from it to fit the insert query for the newest pok i found to start working from. then after the inster was done, add those rows back in to make it work with the latest db version, export it all to sql, delete all the npc types entries for pok, delete all the spawn groups etc etc etc, then reinsert my sql file into npc types with all the new values for the merchantlists etc.

difference? took me about 3 hours to source it in, VS about 5 minutes if we had a global setup for the database that everyone used.

im a php/mysql programmer so im actually working on a php system that will go through and revamp my entire database using a numbering scheme of 1000*zoneid on auto increment.

so far the past couple attempts have screwed up loot, merchants, pets, spells etc... so it's still a work in progress, but once i have it finished i will release the new database, not the utility.

if i put out the utility then everyone who has their own custom database work will just use it to mod their db and continue to mooch our releases without any contributions of their own. but by releasing the database only we force them to conform if they want to use our db updates :p

[CrabClaw]

The above example reminds me of what they did when Total Annihilation (a little RTS game with robots) modding was popular. The database was open ended on IDs but to avoid overwriting each other's work they agreed upon ranges of data IDs for each mod out there. So the basic live-like data went from 1 to X and then in blocks of 1000's people reserved space for custom content.

But, over my years watching and trying to contribute what I can to this project, I can say it's like having a overloaded garage full of content with no one really wanting to dig and clean it. But yes there is redundancy in the npc_types database there are 14 same level Snow Dervishes, and 17 'a stonegazer cockatrice''s, when there should only be two stonegazer cockatrices (a level 33-35-ish for the OT, and a level 37-40-ish for the DL and TT).

It is doable bite by byte though.

*looks at his garage*

*hides*

[eq4me]

The big problem is that some of the tables that need to be loaded into shared memory are memory hogs. Right now you just cant space IDs out for further addons without wasting huge ammounts of Memory.

More discussion is here:
http://www.eqemulator.net/forums/sho...0&page=1&pp=15
and here:
http://www.eqemulator.net/forums/showthread.php?t=21466

Angelox: Since PEQ picked up tremendous speed in the last few weeks did you consider joining up with em? I am pretty sure the rigid policies of the last Maintainer are somewhat loosened and the guys from PEQ might be happy to implement many of your additions and corrections. They may stop at purely handspawned zones though. Provided that PEQ Database releases will be more frequent i am sure this would prevent alot of double work as both you and the PEQ Team are prone to fix the same bugs, just look the bug submissions and resolves on the PEQ board ...

Well, back to lurking for now.