Outdated New Public DB Link can be found in this topic

[tegstewart]

Very good job... time for me to create a brand new DOLSetup.exe with the most up to date Database

Yes please! :-p

[tegstewart]

100 downloads and no more appeals

Alas, I've found a few.

First, the Mentalist charms give an error stating I cannot charm mobs of that type, even with the top rank which should be able to charm everything. Maybe there's a mismatch between what reference numbers the spell is looking for and the actual mob types?

Second, I can't open and close the gates in and out of the frontiers. The switch and there and selectable, but the event to make the door open must not be firing.

I'm running version 1.9.7.3273, so that might be a factor as well. What version are you using on your end?

Outstanding job. I'm really missing SniperWolf's teleport NPCs, but everything here is nice and polished.

[PlanarChaosRvrtwo]

For the charm this topic can help you:
http://www.dolserver.net/viewtopic.php?f=59&t=21619

Amnesia chance may be the issue.


the gates out of frontiers are very simple go ingame type /door show
then go next to the button to open it and click it then a window pops to add door and then hit accept
and then the door issue is solved currently im to busy to update it^^

(if the doors exist the combat window shows you door id then you can delete em from door table in db and do it via /door show)

(im sure there still a few issues but the thing is most of things are easy to fix so some peeps just dont appeal em and that is ok i gonna develope this db while i setup my server but afterwards the db will be undeveloped and its up to other staff members to continue the developement)

[tegstewart]

The only place where I've found renegades to be a problem thus far is in Tir Na Nog, where there shouldn't be any keep guards. Jordheim and Camelot both seem fine.

I ran around with an admin character using target nearest and a macro for /mob remove, and that seemed to do the trick.

[tegstewart]

I've found a few more oddities that I've been exploring.

I'm seeing duplicate NPCs and mobs. The ones I spot checked had different PackageIDs, so it should be possible to delete them based on which sources you think are higher quality. I'm also seeing differences in stats and equipment templates. Here's a script I wrote five years back to identify them by locs and name. Hilariously, there are six Barkeep Prugars.

Code: Select all

SELECT `mob`.`Name` AS `Name`,`mob`.`X` AS `X`,`mob`.`Y` AS `Y`,`mob`.`Z` AS `Z`,`mob`.`Mob_ID` AS `mob_ID`,COUNT(0) AS `cnt` FROM `mob` GROUP BY `mob`.`Name`,`mob`.`X`,`mob`.`Y`,`mob`.`Z` HAVING (COUNT(0) > 1)

So I did a quick check to see what distinct PackageIDs there are in the mobs table, and that led to something interesting. Here is the list of mobs and npctemplate counts for each distinct PackageID

• Public_DB: 57576 mobs 1546 npctemplates
  dolpubdb: 37595 mobs, 0 npctemplates
  "": 434 mobs, 78 npctemplates
  NULL: 31435 mobs, 33 npctemplates
  Toa_Hib: 12732 mobs, 0 npctemplates, but most of the mob entires list an npctemplate

I'm wondering if the Toa_Hib npctemplates got lost in the transition. My SQL fu is too weak to see if there are other mobs with assigned npctemplates that don't exist.

I also noticed that the high level npcs in the Hall of Heroes were set to Realm 0 and were running around murdering everything. They're also set to be NPCs rather than merchants but don't have item lists anyway so it doesn't matter. Easy fix:

Code: Select all

SELECT * FROM mob WHERE NAME IN ("Mnosus", "Demyphon", "Zosyne", "Aphaestia")

I'll keep playing around with it and let you know what I find.

[PlanarChaosRvrtwo]

If you fix something please share with me i add to public db.

[tegstewart]

Absolutely. Right now I'm improving my old solo-server additions, but once that's finished I'll start working on it.

[tegstewart]

This is an odd one I stumbled across when fiddling with champion levels. The paladin strength buffs use effectgroup 5, which is already used by damage buffs. As a result, the pallie str buff and dmg shield buffs were mutully exclusive. Here's the fix:

Code: Select all

update spell set effectgroup=41 where spellid between 1074 and 1080;

The PackageID for all these spells is Public_DB, so I suspect this is an issue with the core DB and will report it as a bug as well.

[tegstewart]

Rather than posting any more of the little things I find wrong, I'm making a .sql file of them, but this one is a doozy.

The Viking career gave the staves weapon ability twice, and didn't give the swords ability, so classes like Warriors and Thanes couldn't use swords. Here's the fix:

Code: Select all

UPDATE specxability SET Abilitykey="Weaponry: Swords" WHERE specxabilityID=32;

[PlanarChaosRvrtwo]

Your appeals and queries has been done and topic entrace message has been updated.

[PlanarChaosRvrtwo]

I'm wondering if the Toa_Hib npctemplates got lost in the transition. My SQL fu is too weak to see if there are other mobs with assigned npctemplates that don't exist.

I look into that currently

[PlanarChaosRvrtwo]

A thing you should know about xp and database settings:
http://www.dolserver.net/viewtopic.php? ... 96#p158796

[PlanarChaosRvrtwo]

Read first message in this topic first 2 lines

[tegstewart]

Following things are supposed to not working if you use it (to make sure not everyone can one click making server and get alot of money by donates just to close it after)

It saddens me that this is necessary. People suck.

[PlanarChaosRvrtwo]

Following things are supposed to not working if you use it (to make sure not everyone can one click making server and get alot of money by donates just to close it after)

It saddens me that this is necessary. People suck.

Maybe but you can decide how you handle it it was my way to ensure that