Author Topic: MySQL Admin web interface  (Read 4939 times)

Paradox

  • Posts: 2612
  • Turrets: +253/-250
    • Paradox Designs
MySQL Admin web interface
« on: June 06, 2009, 06:49:13 am »
Since the start of the MySQL admin.dat replacement project, one thing that has been mentioned was a web interface to view admins, bans, and other similar server admin info.

I have been developing one for the past few days. Anyone hanging out in IRC already knows of this, but many people do not know about it.

A beta will be coming along in a few days.

http://paradoxdgn.com/tremysql

NONE OF THAT DATA IS REAL. ITS 100% FAKE. EVEN THE GUIDS ARE FAKE

Features currently:
  • Sorting
  • Searching
  • Theme changes
  • Pagination
  • Admin view
  • Levels view

Features that should be here by b1
  • Bans list
  • About box
  • Info/Credits pane

Eventual features
  • Admin listing will show both named and numbered level, instead of just number
  • Commands listing
  • Online editing (maybe)
  • Custom themes

Feedback is nice.

∧OMG ENTROPY∧

Asvarox

  • Posts: 573
  • Turrets: +41/-35
Re: MySQL Admin web interface
« Reply #1 on: June 06, 2009, 08:36:29 am »
Theme changes? It's useful for boards and blogs, not for administration tools. It's really annoying when I have to download phpmyadmin with all those 'cool' themes just to delete them.
I MINE FULL WEREWOLFES
NOT SUCH HIPPIE THINGS  >:(

David

  • Spam Killer
  • *
  • Posts: 3543
  • Turrets: +249/-273
Re: MySQL Admin web interface
« Reply #2 on: June 06, 2009, 02:11:01 pm »
Doesn't do anything with no JS, and scrolling eats 100% cpu and lags like a bitch.
Any maps not in the MG repo?  Email me or come to irc.freenode.net/#mg.
--
My words are mine and mine alone.  I can't speak for anyone else, and there is no one who can speak for me.  If I ever make a post that gives the opinions or positions of other users or groups, then they will be clearly labeled as such.
I'm disappointed that people's past actions have forced me to state what should be obvious.
I am not a dev.  Nothing I say counts for anything.

Thorn

  • Guest
Re: MySQL Admin web interface
« Reply #3 on: June 06, 2009, 06:59:53 pm »
Yeah, really slow here too

Paradox

  • Posts: 2612
  • Turrets: +253/-250
    • Paradox Designs
Re: MySQL Admin web interface
« Reply #4 on: June 06, 2009, 07:37:10 pm »
First off, themes ARE NOT downloaded. They are loaded via Google CDN. Everything but the grid is loaded via google CDN. Considering MANY websites use google CDN for their themes, there is very high chance you already have some of the packages loaded.

Second, i can use this on a shitty windows xp box thats 6 years old with no ram upgrades, and yet it runs just fine.


But frankly, seeing the WARM response any effort to advance the community has been met with, its no surprise that the community is dying. This type of behavior just drives people away.
« Last Edit: June 06, 2009, 07:43:23 pm by Paradox »

∧OMG ENTROPY∧

UniqPhoeniX

  • Spam Killer
  • *
  • Posts: 1376
  • Turrets: +66/-32
Re: MySQL Admin web interface
« Reply #5 on: June 06, 2009, 07:44:47 pm »
Looks nice, but also lags horribly while scrolling, 50% cpu on dual core (Ubuntu 8.10 intrepid, Firefox 3.0.10).

Archangel

  • Guest
Re: MySQL Admin web interface
« Reply #6 on: June 06, 2009, 07:54:46 pm »
sounds like you are rendering it on your cpu :O

Asvarox

  • Posts: 573
  • Turrets: +41/-35
Re: MySQL Admin web interface
« Reply #7 on: June 06, 2009, 08:03:16 pm »
1) Lol I haven't noticed the link...
2) Yes, scrolling lags
3) It doesn't load under IE7
4) at 1280xX resolution, useless horizontal bar appears.
5) AJAX and kewl themes from google are nice, but it's administration tool. So it should be really light-weight and fast. It goes to server admins, not to "end users" (or rather server admins are end users).

btw. Why not expand it, from "MySQL Admin web interface" to "Server Admin web interface"? Admins can log in and do what they want, until their level and flags allow them to, special-password protected rcon etc? And mobile phones support so server admins will be able to administrate server from everywhere ;)
I MINE FULL WEREWOLFES
NOT SUCH HIPPIE THINGS  >:(

David

  • Spam Killer
  • *
  • Posts: 3543
  • Turrets: +249/-273
Re: MySQL Admin web interface
« Reply #8 on: June 06, 2009, 09:33:51 pm »
But frankly, seeing the WARM response any effort to advance the community has been met with, its no surprise that the community is dying. This type of behavior just drives people away.

You asked for feedback, I gave you honest feedback.  On my computer it lags a lot.  If you wanted meaningless "it's great" feedback then you should have asked for that.
Any maps not in the MG repo?  Email me or come to irc.freenode.net/#mg.
--
My words are mine and mine alone.  I can't speak for anyone else, and there is no one who can speak for me.  If I ever make a post that gives the opinions or positions of other users or groups, then they will be clearly labeled as such.
I'm disappointed that people's past actions have forced me to state what should be obvious.
I am not a dev.  Nothing I say counts for anything.

Paradox

  • Posts: 2612
  • Turrets: +253/-250
    • Paradox Designs
Re: MySQL Admin web interface
« Reply #9 on: June 06, 2009, 11:18:49 pm »
Perhaps i failed to make the point that this is as much for server admins as TremStats is. It is a way for a server to run an online ban log or something similar.

In later versions, i will code up a “dumb mode” that is just plain tables.

∧OMG ENTROPY∧

David

  • Spam Killer
  • *
  • Posts: 3543
  • Turrets: +249/-273
Re: MySQL Admin web interface
« Reply #10 on: June 07, 2009, 12:43:30 am »
Drop the background images and it works fine.  One is just flat grey and the other just has a tiny unnoticeable gradient at the bottom.
Any maps not in the MG repo?  Email me or come to irc.freenode.net/#mg.
--
My words are mine and mine alone.  I can't speak for anyone else, and there is no one who can speak for me.  If I ever make a post that gives the opinions or positions of other users or groups, then they will be clearly labeled as such.
I'm disappointed that people's past actions have forced me to state what should be obvious.
I am not a dev.  Nothing I say counts for anything.

Lachu

  • Posts: 36
  • Turrets: +2/-20
Re: MySQL Admin web interface
« Reply #11 on: June 07, 2009, 10:49:01 am »
I think there should be global building queue to team. He only have limited buildings number in it. Team can increase number of queue by built special structures.

Effects:
- Builder have only planing. When plan is ready he change suit to rifle.
- More action.

You should also add aliens ability to morf into several structure. Not to all, but defense only. After that player can destroy structure and respawn. It's not so stupid, IMHO.

CreatureofHell

  • Posts: 2422
  • Turrets: +430/-126
    • Tremtopia
Re: MySQL Admin web interface
« Reply #12 on: June 07, 2009, 11:26:03 am »
Building had nothing to do with this. gtfo
{NoS}StalKer
Quote
<Timbo> posting on the trem forums rarely results in anything good

Baconizer

  • Posts: 221
  • Turrets: +80/-52
    • Barking Frogs
Re: MySQL Admin web interface
« Reply #13 on: June 08, 2009, 07:26:45 am »
But frankly, seeing the WARM response any effort to advance the community has been met with, its no surprise that the community is dying. This type of behavior just drives people away.

You asked for feedback, I gave you honest feedback.  On my computer it lags a lot.  If you wanted meaningless "it's great" feedback then you should have asked for that.

I think what he wants is some recognition of what's good as well as what's bad, not just complaints.

Paradox: It is rather slow. It probably should be a little more light.

But it does look useful, and will probably be very nice once it's finished.
Why will you folk not ban me? :'(

FisherP

  • Posts: 295
  • Turrets: +31/-32
Re: MySQL Admin web interface
« Reply #14 on: June 09, 2009, 08:28:19 am »
Replacing the admin.dat with something a bit more extensible is good idea.

The web site looks fairly clean at the moment. I didn't see any ban information, but I expect that the look and feel of that would not be any different. I would also expect that bans would be a separate page.

It would be good for the interface to have authentication so that administrators can get in and update information when required. I don't know how you feel about this, but obviously there would need to be some sense applied to what can or cannot be changed and by whom.

If this is what you can knock up in a few days I'd like to see what can be put together with a month of coding.