Page 1 of 1

DOL 2.0 database

PostPosted: Thu Feb 08, 2007 12:18 pm
by Holly
Folks, please put down list of your requirements/wishes considering DOL2.0 databases, utilities for editation and ingame modifications/updating/inserting of records.

PostPosted: Tue Aug 21, 2007 2:49 pm
by arcsalin
please refer to my latest bug report and get started on that :p

PostPosted: Tue Aug 21, 2007 3:20 pm
by ZioRed
please refer to my latest bug report and get started on that :p
Your bug report is only a bug report, nothing to do with a potential new database structure for DOL 2.0... or at least I didn't found any suggestion of changes.

Please stay on topic in the team forums.

PostPosted: Wed Aug 22, 2007 12:01 am
by Troglart
I dont know if someone put something like this.. but

A tool which will access your database out of game connection through the mysql DB with data editing, export to .sql files, update databases during gameplay (that would be great for testing things especially spell creation / testing) and just send the player packet updates during gametime too

PostPosted: Wed Aug 22, 2007 1:07 pm
by ZioRed
uhhh navicat? and db reloading is a cheap ass thing meant for developers who wish to develop on a running server.....No :)
I'm quite sure that it could be done in game with a custom NPC, new GM commands and change something in the Load Skills and Spells logic: i.e. for styles we may take the code to add a skill apart from SkillBase.LoadSkills, so you can create at runtime new styles or update one directly from m_styleLists. The custom NPC may "fix" the players currently online doing a refresh of the skills.

Hard work, but I think it's possible.

PostPosted: Wed Aug 22, 2007 1:16 pm
by arcsalin
please refer to my latest bug report and get started on that :p
Your bug report is only a bug report, nothing to do with a potential new database structure for DOL 2.0... or at least I didn't found any suggestion of changes.

Please stay on topic in the team forums.
Indeed, but you may notice that my bug report is not yet finished, and boy last night i found some bad stuff :( so much so that I aint gonna get the damned thing finished by tonight probably.

There are suggestions in the final report that will aim to cure stuff. And in a way it was on topic, in 1.89 after what I've seen, the dol db got royally f'cked over by mythic :(

PostPosted: Wed Aug 22, 2007 4:46 pm
by Batlas
arcsalin what he meant was this is in regards to the whole DOL 2.0 DB.. Your issues lie w/i the dol 1.9 framework. Therefore posting them here has nothing todo with the current topic. They were looking for suggestions on improves on the DB structure for DOL 2.0.

PostPosted: Wed Aug 22, 2007 11:38 pm
by mgX
currently rewriting how mobs are handled dbwise...they need to only have heading, region, x,y,z and mobtemplate stored in the mobdb and the rest of the info stored in the npctemplates....