somewhat like ldon

John Adams · #2 06-11-2008, 10:27 PM

It's possible, but that seems like more work than getting the existing code to work. I've made decent progress with LDoN stuff on my local server, and completed filling out the data for the adventure tables. I went through the code and fixed the horrible spelling errors that were driving me mad in the field names. I am hoping to get more progress done before I release anything more - but here's the 2 tables that work in conjunction with the current code:

Code:

CREATE TABLE `adventures` (
  `QuestID` int(11) NOT NULL default '0',
  `NPCID` int(11) NOT NULL default '0',
  `Type` tinyint(4) NOT NULL default '0',
  `Text` text NOT NULL,
  `Objetive` int(11) NOT NULL default '0',
  `ObjetiveValue` int(11) NOT NULL default '0',
  `Minutes` int(11) NOT NULL default '0',
  `Points` int(11) NOT NULL default '0',
  `ShowCompass` tinyint(1) NOT NULL default '0',
  `zoneid` int(11) NOT NULL default '0',
  `zonedungeonid` int(11) NOT NULL default '0',
  `X` float NOT NULL default '0',
  `Y` float NOT NULL default '0',
  `status` int(11) NOT NULL default '0',
  `char1` int(11) NOT NULL default '0',
  `char2` int(11) NOT NULL default '0',
  `char3` int(11) NOT NULL default '0',
  `char4` int(11) NOT NULL default '0',
  `char5` int(11) NOT NULL default '0',
  `char6` int(11) NOT NULL default '0',
  `in_use` tinyint(1) NOT NULL default '0'
) ENGINE=MyISAM;

CREATE TABLE `adventures_maintext` (
  `NPCID` int(11) NOT NULL default '0',
  `Text` text NOT NULL
) ENGINE=MyISAM;

This does NOT make LDoNs work, but it is the data structures behind the current code that could be used to complete SoTRichards idea. In Cofrubens original code, it appears he checked for in_use, and if the adventure was currently assigned to a group, the next one for that NPC was displayed. Etc. This is how you keep people from getting into the same zone.

Now in all my research, I have not found anything that dynamically spawns NPCs per your adventure level... so it's likely these zones (once upon a time) were merely assigned to a group per their avg level, and a-j LDoN zone spawns were static from levels 20-70. Dunno, there is no NPC data for LDON in PEQ-DB either.

I am still interested in "fixing" this, but time is not on my side. Still waiting for another torch bearer.