Pages: [1]   Go Down

Author Topic: Replace admin.dat with a MySQL table  (Read 6301 times)

Paradox

  • Posts: 2612
  • Turrets: +253/-250
    • Paradox Designs
Replace admin.dat with a MySQL table
« on: April 28, 2008, 07:52:27 pm »
There are many reasons why this would be a good idea, and i actually have some people working on it. What i propose is replacing admin.dat with a mysql table. Trem would reference into said table.

This would allow for many things, such as an online ban database viewer, online admin viewer, and easy searching.

Ideally, it would be an alternate solution, for those ops who dont know how to run MySQL, they could opt out and still use admin.dat.

Any feedback?
Logged

∧OMG ENTROPY∧

Rocinante

  • Posts: 642
  • Turrets: +252/-668
    • My Homepage
Re: Replace admin.dat with a MySQL table
« Reply #1 on: April 28, 2008, 08:04:56 pm »
Go with SQLite instead.  Same benefits of a RDB, but without the overhead of another daemon.
Logged
}MG{Mercenaries Guild
"On my ship, the Rocinante, wheeling through the galaxies, headed for the heart of Cygnus, headlong into mystery." -- Rush, "Cygnus X-1"

Paradox

  • Posts: 2612
  • Turrets: +253/-250
    • Paradox Designs
Re: Replace admin.dat with a MySQL table
« Reply #2 on: April 28, 2008, 11:37:24 pm »
Many of us are running a MySQL server on our server allready, and so SQLite would be yet another thing to use.
Logged

∧OMG ENTROPY∧

kevlarman

  • Posts: 2737
  • Turrets: +291/-295
Re: Replace admin.dat with a MySQL table
« Reply #3 on: April 29, 2008, 02:43:05 am »
Quote from: Paradox on April 28, 2008, 11:37:24 pm
Many of us are running a MySQL server on our server allready, and so SQLite would be yet another thing to use.
mysqld doesn't exactly play well with tremded, i would avoid running it on any servers that are used to host trem servers.
Logged
Quote from: Asvarox link=topic=8622.msg169333#msg169333
Ok let's plan it out. Asva, you are nub, go sit on rets, I will build, you two go feed like hell, you go pwn their asses, and everyone else camp in the hallway, roger?
the dretch bites.
-----
|..d| #
|.@.-##
-----

Paradox

  • Posts: 2612
  • Turrets: +253/-250
    • Paradox Designs
Re: Replace admin.dat with a MySQL table
« Reply #4 on: April 29, 2008, 07:40:17 pm »
You could always remote it out, that would be the beauty of such a system.
Logged

∧OMG ENTROPY∧

kevlarman

  • Posts: 2737
  • Turrets: +291/-295
Re: Replace admin.dat with a MySQL table
« Reply #5 on: April 29, 2008, 08:55:38 pm »
Quote from: Paradox on April 29, 2008, 07:40:17 pm
You could always remote it out, that would be the beauty of such a system.
that would make the lag much much worse.
Logged
Quote from: Asvarox link=topic=8622.msg169333#msg169333
Ok let's plan it out. Asva, you are nub, go sit on rets, I will build, you two go feed like hell, you go pwn their asses, and everyone else camp in the hallway, roger?
the dretch bites.
-----
|..d| #
|.@.-##
-----

kangounator

  • Posts: 35
  • Turrets: +2/-1
Re: Replace admin.dat with a MySQL table
« Reply #6 on: April 29, 2008, 10:13:43 pm »
I'd use SQLite for that, it is really light to use and as Rocinante said, you don't have to run a SQL server, only tremulous' binary. (that again some more syscalls :x )
Logged
Quote from: CitRoN
Muuuuuuuuuh ]={:}

Memorex >.<

  • Posts: 9
  • Turrets: +0/-0
    • http://www.sherdog.com
Re: Replace admin.dat with a MySQL table
« Reply #7 on: April 29, 2008, 10:23:32 pm »
i already coded something for that, but i didnt replace the admin.dat by sql, i just update a sql table with the admin.dat content

http://www.amsterdam-unlimited.net/page4/page5/page6/page6.html

it's of course still in developpement since i only worked 20min on it, so be lenient please, there is no filter yet, no design, trem color sheme isnt supported yet etc.. :)
Logged

Paradox

  • Posts: 2612
  • Turrets: +253/-250
    • Paradox Designs
Re: Replace admin.dat with a MySQL table
« Reply #8 on: May 01, 2008, 12:45:37 am »
Thats actually a good solution, while imperfect.
If at all possible, could i see the code?
Logged

∧OMG ENTROPY∧

Memorex >.<

  • Posts: 9
  • Turrets: +0/-0
    • http://www.sherdog.com
Re: Replace admin.dat with a MySQL table
« Reply #9 on: May 01, 2008, 11:59:46 am »
i sent you the code on your gmail address
Logged

Paradox

  • Posts: 2612
  • Turrets: +253/-250
    • Paradox Designs
Re: Replace admin.dat with a MySQL table
« Reply #10 on: May 02, 2008, 05:35:41 am »
Thanks
Logged

∧OMG ENTROPY∧

Le Compilateur

  • Posts: 315
  • Turrets: +14/-19
Re: Replace admin.dat with a MySQL table
« Reply #11 on: May 26, 2008, 03:36:30 pm »
It would take a bit of coding but yeah, good idea.
Logged
I'm a developer! If you'd like to contribute to the Equilibrium QVM project or download the latest version, please visit this thread.

QVMs now compile under Leopard; get the patch here. Requires SVN r1053 or later.

daenyth

  • Posts: 230
  • Turrets: +21/-26
Re: Replace admin.dat with a MySQL table
« Reply #12 on: May 28, 2008, 03:40:11 pm »
Not a bad idea, but I'd also say to either go with sqlite or have a system where the admin can connect it to any *sql db
Logged
Quote from: Bullislander05
It's like trying to take apple seeds out of a zebra to plant a giraffe tree.
Pages: [1]   Go Up