Remember Remember...

[Ephemeral]

As I'm currently killing some XML with fire in a game..

Anyone else remember back when DOL was all XML database? And the unending hell it was to convert? (time wise I mean)

[tobz]

I remember the tools people wrote to import their XML databases to a SQL server, and how utterly slow they were. I also remember working on CamelLight/Fallen Realms where we thought it was a really good idea to use pretty much only stored procedures on SQL Server.

Data modeling and usage is hard sometimes, heh.

[Overdriven]

I very much remember those days. I also remember when Tobz was the most hated person in the DOL world

[tobz]

[Etaew]

I very much remember those days. I also remember when Tobz was the most hated person in the DOL world

Back in the early days we didn't really had much of an option for an out of the box standalone server, it was intended just for development modes but then it became commonplace. I certainly remember the half written tables and DB backups.

And the other thing, time passes and things become less important but being betrayed is never something that goes away.

[Ephemeral]

Hey, I was hated too.. They were some fun days

[Graveen]

time passes, yes !

[Tolakram]

Hey, I was hated too.. They were some fun days

Why are you using past tense?

[Ephemeral]

Funny Funny.

Pft I'd like to think having gained commit access was a step forward (One of these days I'll finish privilege system 2.0)

[tobz]

Funny Funny.

Pft I'd like to think having gained commit access was a step forward (One of these days I'll finish privilege system 2.0)

Does it have role-based permissions? If not, don't do it.

[Ephemeral]

https://svn.code.sf.net/p/dolserver/cod ... Privilege/

The gist of it.

I haven't worked on it in a while so i can't really tell you off the top of my head.

And it has full interop/backward compat with 0-3 privilege system (If I recall the only thing I didn't finish was the parameterized privileges, and the / commands for it)

Hot-reload of the privileges while playing (change the db, run a command and it doesn't require a full login).

Database wise
1 row per character
1 row per account
(So no single privilege where 1 cmd -> 1 row, etc and such)

Group based, but also you can add individual privileges to accounts/characters (Flagging/Tagging or whatever you want to call it)



As a side note, few of the fun parameterized binding things I had actually written for it..


Masquerade with a different username in public/private/commands (Okay the latter probably not used much as it could probably be abused)
Talk to servers in broad without a special command or w/e, without having to deal with getting spammed in PM's and such.
Masquerade Privilege


Allows people to be targetted differently under /who (So you could have helper rank, mod, gm, etc or w/e you want)
Who


Thread with original idea.
http://www.dolserver.net/viewtopic.php?f=5&t=21074

Post showing the only working /command on it, its actually fully working (except for parameterized)
http://www.dolserver.net/viewtopic.php? ... 15#p146539