[ILUG] it must exist...

[John P. Looney]

On Mon, Jul 12, 2004 at 10:34:29AM -0700, Rick Moen mentioned:
> Quoting John P. Looney (valen at tuatha.org):
> 
> >  It's nice, but in this case, I'm looking for a web skeleton that'll talk
> > to an MSSQL server. Hmm. Maybe I'll write one :)
> 
> I should have paid greater attention to your requirements list, for
> which lapse I apologise -- but do I guess correctly that phpmyadmin
> doesn't suffice?  It's often handy.

 Well, i'm looking to make up a tool that'll allow multiple users manage
multiple tables, all interlinked. A subset of it's functionality would be
to let me have a list of servers, with their IPs/operating systems etc. on
them. This would be linked to our IP address list, so you could find out
what ips are on what boxes, or what IPs are allocated to any box. A third
table would be a list of locations, so I could tell where boxes were.

 So, I'd have three tables...
    boxes:  id, room_id, description
    ips:    id, number, netmask, box_id
    rooms:  id, description

 So, I want a screen that showed:

    Box number $id:
        $room_id
        $description
        click here for IPs for box $i

 etc. But, rather than seeing $room_id as "2", I'd want that to
automatically show up as "upstairs", the description in the room table.
I've done most of such a system, but I'm running into design problems
making it as generic as possible (too many exceptions), and hoped someone
else had surmounted such problems before.

John