Mysql based configuration?

jchamb2010

I was just going through the files in MAM, and noticed that there is a file called mod_mysql.class.php. Basically what this file looks like it's doing is getting the configuration information out of a MySQL database.

How do I go about enabling this? This would be greatly helpful as our server is managed remotely and I could then create a PHP based front end to manage the admins, permissions, and other settings.

Thanks,
Jchamb2010

jchamb2010

I figured out how to enable it through the command line (i think), now I just need the SQL files to be able to populate the database :).

manu

I can only give you the mysql code for the structure. I do not have any data for it. But I think you can easily add it by yourself

Spoiler anzeigen

Code

-- phpMyAdmin SQL Dump
-- version 3.1.3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Erstellungszeit: 25. Juli 2010 um 17:05
-- Server Version: 5.1.32
-- PHP-Version: 5.2.9-1




SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";




--
-- Datenbank: `mam`
--




-- --------------------------------------------------------




--
-- Tabellenstruktur für Tabelle `admins`
--




CREATE TABLE IF NOT EXISTS `admins` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `guid` varchar(32) NOT NULL,
  `group` varchar(50) NOT NULL,
  `protected` tinyint(1) NOT NULL,
  `names` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `guid` (`guid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1;




-- --------------------------------------------------------




--
-- Tabellenstruktur für Tabelle `config`
--




CREATE TABLE IF NOT EXISTS `config` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `section` varchar(50) NOT NULL,
  `name` varchar(50) NOT NULL,
  `value` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1;




-- --------------------------------------------------------




--
-- Tabellenstruktur für Tabelle `groups`
--




CREATE TABLE IF NOT EXISTS `groups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `group` varchar(50) NOT NULL,
  `name` varchar(50) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `group` (`group`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1;




-- --------------------------------------------------------




--
-- Tabellenstruktur für Tabelle `groups_commands`
--




CREATE TABLE IF NOT EXISTS `groups_commands` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `group` int(11) NOT NULL,
  `command` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1;




-- --------------------------------------------------------




--
-- Tabellenstruktur für Tabelle `maps`
--




CREATE TABLE IF NOT EXISTS `maps` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `shortname` varchar(50) NOT NULL,
  `longname` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1;




-- --------------------------------------------------------




--
-- Tabellenstruktur für Tabelle `reasons`
--




CREATE TABLE IF NOT EXISTS `reasons` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `reason` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1;

Alles anzeigen