New Years resolutions anyone?

[rojadruid]

On a personal note I plan to try to quit smoking.

[CrabClaw]

Resolution #1: to help write as many quests as I can, now that I have learned a simple knowledge of *.pl quest coding (I helped I did know Java).

Resolution #2: Don't make resolutions(hehe - joking).

Yes! By all means! You have to accept you can never be 100% live like. So it is far batter to have more zones well spawned, and organized to be playable then being by the book about things. Besides it opens the door to make some improvements to things as well (EQ-Live still has a ton of unfinished stuff and broken quests). Even on Live they re-shuffled and re-did zones so all the old world content (Freeport, Oasis, Commonlands, Nek, and the like. Even the PoN was re-balanced back in just-pre-OoW days), and is really open for reinterpretation. So I say make the old zones a good inspired-by-live play re-do, and give yourself some license for creative additions (more modern drops and updated quests, new Nameds and such).

Oh and by the way,

Happy new Year!

[John Adams]

What I'd like to see for EQEmu'2007:
-- Drive a stake in the ground and name a new "stable" build. I propose focused, organized testing by the Emulator community players and admins. There are test plans posted in the Wiki (which are in dire need of updating), everyone should take a chunk and go to town, report bugs, get them fixed. If a dev or two knows that for a month, community members will be posting details on specific bugs, maybe they will offer their time to help stablize the code.

-- Wikiwakkawoo my gods, please start updating the Wiki! This is my personal resolution, because this is absolutely something any of us are capable of doing. If we see posted info that might help others, let's start adding it to the wiki. We've preached it, now let's do it.

-- Bring the spawns for newer zone layouts up to Titanium standards. If you are going to say "Titanium only", the data should support that client, not just 6.2. Renaming lavastorm.eqg is not moving forward, nor supporting the only "legal" client for this emulator.

-- A repository for fixes that isn't a VBulletin code tag! If we make Diffs, I'd like to see a file upload area where we can stick these raw snippets of text. A forum is no place to paste code fixes. Many people have pointed links back to their own shares, but those go inactive almost as quickly as they appear. History lost. This goes for databases, too. God forbid, what if Angelox or GeorgeS got pissed off and closed their sites? A year from now, we'd be begging someone to post their database or tools from the archives.

-- Quest Helpers. So much effort is being put into making quests more stable, add missing ones, or create custom ones to aid lower population servers. I'd like to see more dev help (or maybe a nice tutorial how to add functionality to the questmgr) so quest writers lives will be easier. While the current system works quite well, there are some things you simply cannot do... yet. Also, finding someone dedicated to incorporating all this quest work into an official package would ensure 1) acknowledgement and 2) preservation of effort. The PEQ /quests site is perfect for this, but seems understaffed (?)

-- More awareness that community input IS acknowledged. It seems there is this cloud that pops up once in a while, members posting that no one but a small handful do anything. If you shovel through the archives over the past 3 years, it would become evident how many people offer their time, expertise, and solutions, but vanish after burnout or feeling ignored. People contribute here, daily. It's time we notice that and be happy it's as good as it is. However...

-- And finally, to go along with the theme of this thread, more community members who CAN code, helping with the base effort and not just their own server(s). Customizing is great, but if you fix a core bug while customizing your server, please share the core fix it so this project continues to move forward. Like Boats. How many times has this been fixed, then re-broken?

Ok, flame away. And yes, Mattmeck - I volunteer to do EVERYTHING myself ~yawn~

[sfisque]

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]

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]

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...

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...

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]

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...