już se poradziłem dla wszystkich, którzy chcą urzywać gm 1.6
<?php
/*
AMXBans v6.0
Copyright 2009, 2010 by SeToY & |PJ|ShOrTy
This file is part of AMXBans.
AMXBans is free software, but it's licensed under the
Creative Commons - Attribution-NonCommercial-ShareAlike 2.0
AMXBans is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
You should have received a copy of the cc-nC-SA along with AMXBans.
If not, see <http://creativecommons.org/licenses/by-nc-sa/2.0/>.
*/
// AMXBans DB structure v6.0
//_admins_servers
$table_create[$_SESSION["dbprefix"]."_admins_servers"]="
admin_id int(11) ,
server_id int(11) ,
custom_flags varchar(32) NOT NULL ,
use_static_bantime enum('yes','no') NOT NULL DEFAULT 'yes'
";
//_amxadmins -tworzy
$table_create[$_SESSION["dbprefix"]."_amxadmins"]="
id int(12) auto_increment,
username varchar(32) ,
password varchar(50) ,
access varchar(32) ,
flags varchar(32) ,
steamid varchar(32) ,
nickname varchar(32) ,
icq int(9) ,
ashow int(11) ,
created int(11) ,
expired int(11) ,
days int(11) ,
PRIMARY KEY (id),
KEY steamid (steamid)
";
//_bans --tworzy
$table_create[$_SESSION["dbprefix"]."_bans"]="
bid int(11) auto_increment,
player_ip varchar(32) ,
player_id varchar(35) ,
player_nick varchar(100) NOT NULL DEFAULT 'Unknown',
admin_ip varchar(32) ,
admin_id varchar(35) NOT NULL DEFAULT 'Unknown',
admin_nick varchar(100) NOT NULL DEFAULT 'Unknown',
ban_type varchar(10) NOT NULL DEFAULT 'S',
ban_reason varchar(100) ,
cs_ban_reason varchar(100) ,
ban_created int(11) ,
ban_length int(11) ,
server_ip varchar(32) ,
server_name varchar(100) NOT NULL 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)
";
//_bans_edits--tworzy
$table_create[$_SESSION["dbprefix"]."_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`)
";
//_bbcode-tworzy
$table_create[$_SESSION["dbprefix"]."_bbcode"]="
id int(11) auto_increment,
open_tag varchar(32) ,
close_tag varchar(32) ,
url varchar(32) ,
name varchar(32) ,
PRIMARY KEY (id)
";
//_comments-tworzy
$table_create[$_SESSION["dbprefix"]."_comments"]="
id int(11) auto_increment,
name varchar(35) ,
comment text ,
email varchar(100) ,
addr varchar(32) ,
date int(11) ,
bid int(11) ,
PRIMARY KEY (id)
";
//_files--tworzy
$table_create[$_SESSION["dbprefix"]."_files"]="
id int(11) auto_increment,
upload_time int(11) ,
down_count int(11) ,
bid int(11) ,
demo_file varchar(100) ,
demo_real varchar(100) ,
file_size int(11) ,
comment text ,
name varchar(64) ,
email varchar(64) ,
addr varchar(32) ,
PRIMARY KEY (id)
";
//_levels--tworzy
$table_create[$_SESSION["dbprefix"]."_levels"]="
level int(12) ,
bans_add enum('yes','no') NOT NULL DEFAULT 'no',
bans_edit enum('yes','no','own') NOT NULL DEFAULT 'no',
bans_delete enum('yes','no','own') NOT NULL DEFAULT 'no',
bans_unban enum('yes','no','own') NOT NULL DEFAULT 'no',
bans_import enum('yes','no') NOT NULL DEFAULT 'no',
bans_export enum('yes','no') NOT NULL DEFAULT 'no',
amxadmins_view enum('yes','no') NOT NULL DEFAULT 'no',
amxadmins_edit enum('yes','no') NOT NULL DEFAULT 'no',
webadmins_view enum('yes','no') NOT NULL DEFAULT 'no',
webadmins_edit enum('yes','no') NOT NULL DEFAULT 'no',
websettings_view enum('yes','no') NOT NULL DEFAULT 'no',
websettings_edit enum('yes','no') NOT NULL DEFAULT 'no',
permissions_edit enum('yes','no') NOT NULL DEFAULT 'no',
prune_db enum('yes','no') NOT NULL DEFAULT 'no',
servers_edit enum('yes','no') NOT NULL DEFAULT 'no',
ip_view enum('yes','no') NOT NULL DEFAULT 'no',
PRIMARY KEY (level)
";
//_logs--tworzy
$table_create[$_SESSION["dbprefix"]."_logs"]="
id int(11) auto_increment,
timestamp int(11) ,
ip varchar(32) ,
username varchar(32) ,
action varchar(64) ,
remarks varchar(256) ,
PRIMARY KEY (id)
";
//_modulconfig--tworzy
$table_create[$_SESSION["dbprefix"]."_modulconfig"]="
id int(11) auto_increment,
menuname varchar(32) ,
name varchar(32) ,
`index` varchar(32) ,
activ int(1) NOT NULL DEFAULT '1',
PRIMARY KEY (id)
";
//_reasons--tworzy
$table_create[$_SESSION["dbprefix"]."_reasons"]="
id int(11) auto_increment,
reason varchar(100) ,
static_bantime int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (id)
";
//_reasons_set--tworzy
$table_create[$_SESSION["dbprefix"]."_reasons_set"]="
id int(11) auto_increment,
setname varchar(32) ,
PRIMARY KEY (id)
";
//_reasons_to_set--tworzy
$table_create[$_SESSION["dbprefix"]."_reasons_to_set"]="
id int(11) auto_increment,
setid int(11) NOT NULL ,
reasonid int(11) NOT NULL ,
PRIMARY KEY (id)
";
//_serverinfo--tworzy
$table_create[$_SESSION["dbprefix"]."_serverinfo"]="
id int(11) auto_increment,
timestamp int(11) ,
hostname varchar(100) NOT NULL DEFAULT 'Unknown',
address varchar(100) ,
gametype varchar(32) ,
rcon varchar(32) ,
amxban_version varchar(32) ,
amxban_motd varchar(250) ,
motd_delay int(10) NOT NULL DEFAULT '10',
amxban_menu int(10) NOT NULL DEFAULT '1',
reasons int(10) ,
timezone_fixx int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (id)
";
//_smilies--tworzy
$table_create[$_SESSION["dbprefix"]."_smilies"]="
id int(5) auto_increment,
code varchar(32) ,
url varchar(32) ,
name varchar(32) ,
PRIMARY KEY (id)
";
//_usermenu--tworzy
$table_create[$_SESSION["dbprefix"]."_usermenu"]="
id int(11) auto_increment,
pos int(11) ,
activ tinyint(1) NOT NULL DEFAULT '1',
lang_key varchar(64) ,
url varchar(64) ,
lang_key2 varchar(64) ,
url2 varchar(64) ,
PRIMARY KEY (id)
";
//_webadmins --tworzy
$table_create[$_SESSION["dbprefix"]."_webadmins"]="
id int(12) auto_increment,
username varchar(32) ,
password varchar(32) ,
level int(11) NOT NULL DEFAULT '99',
logcode varchar(64) ,
email varchar(64) ,
last_action int(11) ,
try int(1) NOT NULL DEFAULT '0',
PRIMARY KEY (id),UNIQUE (username,email)
";
//_webconfig
$table_create[$_SESSION["dbprefix"]."_webconfig"]="
id int(11) auto_increment,
cookie varchar(32) NOT NULL,
bans_per_page int(11) NOT NULL,
design varchar(32) NOT NULL,
banner varchar(64) NOT NULL,
banner_url varchar(128) NOT NULL,
default_lang varchar(32) NOT NULL,
start_page varchar(64) NOT NULL,
show_comment_count int(1) NOT NULL DEFAULT '1',
show_demo_count int(1) NOT NULL DEFAULT '1',
show_kick_count int(1) NOT NULL DEFAULT '1',
demo_all int(1) NOT NULL DEFAULT '0',
comment_all int(1) NOT NULL DEFAULT '0',
use_capture int(1) NOT NULL DEFAULT '1',
max_file_size int(11) NOT NULL DEFAULT '2',
file_type varchar(64) NOT NULL DEFAULT 'dem,zip,rar,jpg,gif',
auto_prune int(1) NOT NULL DEFAULT '0',
`max_offences` SMALLINT NOT NULL DEFAULT '10',
`max_offences_reason` VARCHAR( 128 ) NOT NULL DEFAULT 'max offences reached',
use_demo int(1) NOT NULL DEFAULT '1',
use_comment int(1) NOT NULL DEFAULT '1',
PRIMARY KEY (id)
";
//_flagged--tworzy
$table_create[$_SESSION["dbprefix"]."_flagged"]="
`fid` int(11) NOT NULL auto_increment,
`player_ip` varchar(32) ,
`player_id` varchar(35) ,
`player_nick` varchar(100) NOT NULL DEFAULT 'Unknown',
`admin_ip` varchar(32) ,
`admin_id` varchar(35) ,
`admin_nick` varchar(100) NOT NULL DEFAULT 'Unknown',
`reason` varchar(100) ,
`created` int(11) ,
`length` int(11) ,
`server_ip` varchar(100) ,
PRIMARY KEY (`fid`),
KEY `player_id` (`player_id`)
";
?>
wystarczy to podmienić w install/tables.inc