AMXBansi andmebaasi struktuur.

[Külaline misterx]

Hei!

 

Oleks siis vaja teada, millised näevad välja AMXBans 5.1b, 1.6GM ja 6 tabelid, kus hoitakse infot adminnide ja bännide kohta.

[HeiTch 0]

Äkki tõmbad ja testid ära ning saad teada?

[Külaline misterx]

Või äkki ma vaatan, kas vahvlis on mõni piisavalt abivalmis inimene?

[MartL 0]

5.1:

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

CREATE TABLE IF NOT EXISTS `amx_amxadmins` (
 `id` int(12) NOT NULL AUTO_INCREMENT,
 `username` varchar(32) DEFAULT NULL,
 `password` varchar(32) DEFAULT NULL,
 `access` varchar(32) DEFAULT NULL,
 `flags` varchar(32) DEFAULT NULL,
 `steamid` varchar(32) DEFAULT NULL,
 `nickname` varchar(32) NOT NULL DEFAULT '',
 `ashow` int(11) NOT NULL,
 `added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `endtime` int(20) DEFAULT '0',
 `new_endtime` int(20) DEFAULT '0',
 `new_access` varchar(45) DEFAULT NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;

CREATE TABLE IF NOT EXISTS `amx_banhistory` (
 `bhid` int(11) NOT NULL AUTO_INCREMENT,
 `player_ip` varchar(100) DEFAULT NULL,
 `player_id` varchar(50) NOT NULL DEFAULT '0',
 `player_nick` varchar(100) NOT NULL DEFAULT 'Unknown',
 `admin_ip` varchar(100) DEFAULT NULL,
 `admin_id` varchar(50) NOT NULL DEFAULT '0',
 `admin_nick` varchar(100) NOT NULL DEFAULT 'Unknown',
 `ban_type` varchar(10) NOT NULL DEFAULT 'S',
 `ban_reason` varchar(255) NOT NULL DEFAULT '',
 `ban_created` int(11) NOT NULL DEFAULT '0',
 `ban_length` varchar(100) NOT NULL DEFAULT '',
 `server_ip` varchar(100) NOT NULL DEFAULT '',
 `server_name` varchar(100) NOT NULL DEFAULT 'Unknown',
 `unban_created` int(11) NOT NULL DEFAULT '0',
 `unban_reason` varchar(255) NOT NULL DEFAULT 'tempban expired',
 `unban_admin_nick` varchar(100) NOT NULL DEFAULT 'Unknown',
 PRIMARY KEY (`bhid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2349 ;

CREATE TABLE IF NOT EXISTS `amx_banreasons` (
 `id` int(12) NOT NULL AUTO_INCREMENT,
 `address` varchar(32) NOT NULL,
 `reason` varchar(250) NOT NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `amx_bans` (
 `bid` int(11) NOT NULL AUTO_INCREMENT,
 `player_ip` varchar(100) DEFAULT NULL,
 `player_id` varchar(50) NOT NULL DEFAULT '0',
 `player_nick` varchar(100) NOT NULL DEFAULT 'Unknown',
 `admin_ip` varchar(100) DEFAULT NULL,
 `admin_id` varchar(50) NOT NULL DEFAULT '0',
 `admin_nick` varchar(100) NOT NULL DEFAULT 'Unknown',
 `ban_type` varchar(10) NOT NULL DEFAULT 'S',
 `ban_reason` varchar(255) NOT NULL DEFAULT '',
 `ban_created` int(11) NOT NULL DEFAULT '0',
 `ban_length` varchar(100) NOT NULL DEFAULT '',
 `server_ip` varchar(100) NOT NULL DEFAULT '',
 `server_name` varchar(100) NOT NULL DEFAULT 'Unknown',
 PRIMARY KEY (`bid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3722 ;

 

 

6.x (1.6 GM)

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

CREATE TABLE IF NOT EXISTS `amx_admins_servers` (
 `admin_id` int(11) DEFAULT NULL,
 `server_id` int(11) DEFAULT NULL,
 `custom_flags` varchar(32) NOT NULL,
 `use_static_bantime` enum('yes','no') NOT NULL DEFAULT 'yes'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `amx_admins_swap` (
 `admin_id` int(11) NOT NULL,
 `old_nick` varchar(32) NOT NULL,
 `new_nick` varchar(32) NOT NULL,
 `timestamp` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `amx_amxadmins` (
 `id` int(12) NOT NULL AUTO_INCREMENT,
 `username` varchar(32) DEFAULT NULL,
 `password` varchar(50) DEFAULT NULL,
 `access` varchar(32) DEFAULT NULL,
 `flags` varchar(32) DEFAULT NULL,
 `steamid` varchar(32) DEFAULT NULL,
 `nickname` varchar(32) DEFAULT NULL,
 `ashow` int(11) DEFAULT NULL,
 `created` int(11) DEFAULT NULL,
 `expired` int(11) DEFAULT NULL,
 `days` int(11) DEFAULT NULL,
 `icq` int(9) DEFAULT NULL,
 `muudetud` int(11) NOT NULL DEFAULT '0',
 `nicks` text CHARACTER SET latin1 NOT NULL,
 `days1` int(11) NOT NULL,
 PRIMARY KEY (`id`),
 KEY `steamid` (`steamid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2485 ;

CREATE TABLE IF NOT EXISTS `amx_bans` (
 `bid` int(11) NOT NULL AUTO_INCREMENT,
 `player_ip` varchar(32) DEFAULT NULL,
 `player_id` varchar(35) DEFAULT NULL,
 `player_nick` varchar(100) DEFAULT 'Unknown',
 `admin_ip` varchar(32) DEFAULT NULL,
 `admin_id` varchar(35) DEFAULT 'Unknown',
 `admin_nick` varchar(100) DEFAULT 'Unknown',
 `ban_type` varchar(10) DEFAULT 'S',
 `ban_reason` varchar(100) DEFAULT NULL,
 `cs_ban_reason` varchar(100) DEFAULT NULL,
 `ban_created` int(11) DEFAULT NULL,
 `ban_length` int(11) DEFAULT NULL,
 `server_ip` varchar(32) DEFAULT NULL,
 `server_name` varchar(100) DEFAULT 'Unknown',
 `ban_kicks` int(11) NOT NULL DEFAULT '0',
 `expired` int(1) NOT NULL DEFAULT '0',
 `imported` int(1) NOT NULL DEFAULT '0',
 PRIMARY KEY (`bid`),
 KEY `player_id` (`player_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3178 ;

CREATE TABLE IF NOT EXISTS `amx_bans_edit` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `bid` int(11) NOT NULL,
 `edit_time` int(11) NOT NULL,
 `admin_nick` varchar(32) NOT NULL DEFAULT 'unknown',
 `edit_reason` varchar(255) NOT NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=222 ;

[Külaline misterx]

Suur tänu!