New Years resolutions anyone?

sfisque · #1 01-01-2007, 11:19 AM

Fix or find a work-around for bind-zone-disconnect-on-death bug

This one irritates me to no end. i've poured through the code for days on end, down several dead ends and finally back to start. i'll get it sooner or later.

Split the database imports

The database imports need to be split into specific tables so that people can "update" or "diff" specific sections if they have custom mods they do not want to whack. a good example, importing the faction fixes from wildcardx would be great without having to whack the entire database.

== sfisque

Angelox · #2 01-01-2007, 01:57 PM

I didn't mean to harp on anyone here with my post. I know a lot of you all out there are doing what you can, and have helped me out a lot. I really appreciate that.

ArChron · #3 01-02-2007, 06:20 AM

New Years Resolutions?

Get off my butt and finally put together the Rails project that has been stewing around in my head since I found EQEmu, and wanted to figure out the database.

I use MySQL 5, and have a few trivial items constructed to help make sense of the DB... like adding a classes table and a races table so that I can see real names of values in a query...

Code:

USE `ax_peq`;
CREATE TABLE `ax_peq`.`classes` (
  `class_id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `class_name` CHAR(30) DEFAULT 'Un-named' COMMENT 'Class Name',
  PRIMARY KEY(`class_id`)
)
ENGINE = MYISAM;

USE `ax_peq`;
INSERT INTO `classes` (`class_id`,`class_name`) VALUES ( 1, 'Warrior');
INSERT INTO `classes` (`class_id`,`class_name`) VALUES ( 2, 'Cleric');
INSERT INTO `classes` (`class_id`,`class_name`) VALUES ( 3, 'Paladin');
INSERT INTO `classes` (`class_id`,`class_name`) VALUES ( 4, 'Ranger');
INSERT INTO `classes` (`class_id`,`class_name`) VALUES ( 5, 'Shadow Knight');
INSERT INTO `classes` (`class_id`,`class_name`) VALUES ( 6, 'Druid');
INSERT INTO `classes` (`class_id`,`class_name`) VALUES ( 7, 'Monk');
INSERT INTO `classes` (`class_id`,`class_name`) VALUES ( 8, 'Bard');
INSERT INTO `classes` (`class_id`,`class_name`) VALUES ( 9, 'Rogue');
INSERT INTO `classes` (`class_id`,`class_name`) VALUES (10, 'Shaman');
INSERT INTO `classes` (`class_id`,`class_name`) VALUES (11, 'Necromancer');
INSERT INTO `classes` (`class_id`,`class_name`) VALUES (12, 'Wizard');
INSERT INTO `classes` (`class_id`,`class_name`) VALUES (13, 'Magician');
INSERT INTO `classes` (`class_id`,`class_name`) VALUES (14, 'Enchanter');
INSERT INTO `classes` (`class_id`,`class_name`) VALUES (15, 'Beastlord');
INSERT INTO `classes` (`class_id`,`class_name`) VALUES (16, 'Berserker');
INSERT INTO `classes` (`class_id`,`class_name`) VALUES (20, 'GM Warrior');
INSERT INTO `classes` (`class_id`,`class_name`) VALUES (21, 'GM Cleric');
INSERT INTO `classes` (`class_id`,`class_name`) VALUES (22, 'GM Paladin');
INSERT INTO `classes` (`class_id`,`class_name`) VALUES (23, 'GM Ranger');
INSERT INTO `classes` (`class_id`,`class_name`) VALUES (24, 'GM Shadow Knight');
INSERT INTO `classes` (`class_id`,`class_name`) VALUES (25, 'GM Druid');
INSERT INTO `classes` (`class_id`,`class_name`) VALUES (26, 'GM Monk');
INSERT INTO `classes` (`class_id`,`class_name`) VALUES (27, 'GM Bard');
INSERT INTO `classes` (`class_id`,`class_name`) VALUES (28, 'GM Rogue');
INSERT INTO `classes` (`class_id`,`class_name`) VALUES (29, 'GM Shaman');
INSERT INTO `classes` (`class_id`,`class_name`) VALUES (30, 'GM Necromancer');
INSERT INTO `classes` (`class_id`,`class_name`) VALUES (31, 'GM Wizard');
INSERT INTO `classes` (`class_id`,`class_name`) VALUES (32, 'GM Magician');
INSERT INTO `classes` (`class_id`,`class_name`) VALUES (33, 'GM Enchanter');
INSERT INTO `classes` (`class_id`,`class_name`) VALUES (34, 'GM Beastlord');
INSERT INTO `classes` (`class_id`,`class_name`) VALUES (35, 'GM Berserker');
INSERT INTO `classes` (`class_id`,`class_name`) VALUES (40, 'Banker');
INSERT INTO `classes` (`class_id`,`class_name`) VALUES (41, 'Shopkeeper');
INSERT INTO `classes` (`class_id`,`class_name`) VALUES (60, 'Adventure Recruiter');
INSERT INTO `classes` (`class_id`,`class_name`) VALUES (61, 'Adventure Merchant');
INSERT INTO `classes` (`class_id`,`class_name`) VALUES (63, 'Tribute Master');

and you can create some views out of SELECTs that are useful as well...

Code:

SELECT s.id, s.race, r.race_desc, s.class, c.class_name, s.zoneid, 
  z.long_name, s.itemid, i.Name, i.filename FROM starting_items s 
  INNER JOIN classes c ON s.class=c.class_id 
  INNER JOIN races r ON s.race=r.race_id 
  INNER JOIN items i ON s.itemid=i.id 
  INNER JOIN zone z ON s.zoneid=z.zoneidnumber 
  ORDER BY s.race, s.class;

and

SELECT l.id, l.name, e.item_id, i.Name AS itemName, e.chance FROM lootdrop l
  INNER JOIN lootdrop_entries e ON l.id=e.lootdrop_id
  INNER JOIN items i ON e.item_id=i.id
  ORDER BY l.id;

I can build stuff as I have time, but there's a fairly steep curve for the database, so it's largely hunt and peck thus far.

ArChron · #4 01-02-2007, 06:24 AM

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.

Code:

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 · #5 01-02-2007, 06:25 AM

And here's the third half...

Code:

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 · #6 01-02-2007, 06:26 AM

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?

Code:

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 · #7 01-02-2007, 07:29 AM

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