Problem z tworzeniem tabel w php podczas i...
Najlepsza odpowiedź
PANDA_2zl
02.12.2019 21:34
No to tak dla tych co będą mieć z tym problem, trzeba przerobić plik tables.inc, który znajduje sie w folderze install
oryginalny plik tables.inc
Spoiler
<?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://creativecommo...by-nc-sa/2.0/>.
*/
// AMXBans DB structure v6.0
//_admins_servers
$table_create[$_SESSION["dbprefix"]."_admins_servers"]="
admin_id int(11) NULL,
server_id int(11) NULL,
custom_flags varchar(32) NOT NULL,
use_static_bantime enum('yes','no') NOT NULL DEFAULT 'yes'
";
//_amxadmins
$table_create[$_SESSION["dbprefix"]."_amxadmins"]="
id int(12) NULL auto_increment,
username varchar(32) NULL,
password varchar(50) NULL,
access varchar(32) NULL,
flags varchar(32) NULL,
steamid varchar(32) NULL,
nickname varchar(32) NULL,
icq int(9) NULL,
ashow int(11) NULL,
created int(11) NULL,
expired int(11) NULL,
days int(11) NULL,
PRIMARY KEY (id),
KEY steamid (steamid)
";
//_bans
$table_create[$_SESSION["dbprefix"]."_bans"]="
bid int(11) NULL auto_increment,
player_ip varchar(32) NULL,
player_id varchar(35) NULL,
player_nick varchar(100) NULL DEFAULT 'Unknown',
admin_ip varchar(32) NULL,
admin_id varchar(35) DEFAULT 'Unknown',
admin_nick varchar(100) NULL DEFAULT 'Unknown',
ban_type varchar(10) NULL DEFAULT 'S',
ban_reason varchar(100) NULL,
cs_ban_reason varchar(100) NULL,
ban_created int(11) NULL,
ban_length int(11) NULL,
server_ip varchar(32) NULL,
server_name varchar(100) 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
$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
$table_create[$_SESSION["dbprefix"]."_bbcode"]="
id int(11) NULL auto_increment,
open_tag varchar(32) NULL,
close_tag varchar(32) NULL,
url varchar(32) NULL,
name varchar(32) NULL,
PRIMARY KEY (id)
";
//_comments
$table_create[$_SESSION["dbprefix"]."_comments"]="
id int(11) NULL auto_increment,
name varchar(35) NULL,
comment text NULL,
email varchar(100) NULL,
addr varchar(32) NULL,
date int(11) NULL,
bid int(11) NULL,
PRIMARY KEY (id)
";
//_files
$table_create[$_SESSION["dbprefix"]."_files"]="
id int(11) NULL auto_increment,
upload_time int(11) NULL,
down_count int(11) NULL,
bid int(11) NULL,
demo_file varchar(100) NULL,
demo_real varchar(100) NULL,
file_size int(11) NULL,
comment text NULL,
name varchar(64) NULL,
email varchar(64) NULL,
addr varchar(32) NULL,
PRIMARY KEY (id)
";
//_levels
$table_create[$_SESSION["dbprefix"]."_levels"]="
level int(12) NULL,
bans_add enum('yes','no') NULL DEFAULT 'no',
bans_edit enum('yes','no','own') NULL DEFAULT 'no',
bans_delete enum('yes','no','own') NULL DEFAULT 'no',
bans_unban enum('yes','no','own') NULL DEFAULT 'no',
bans_import enum('yes','no') NULL DEFAULT 'no',
bans_export enum('yes','no') NULL DEFAULT 'no',
amxadmins_view enum('yes','no') NULL DEFAULT 'no',
amxadmins_edit enum('yes','no') NULL DEFAULT 'no',
webadmins_view enum('yes','no') NULL DEFAULT 'no',
webadmins_edit enum('yes','no') NULL DEFAULT 'no',
websettings_view enum('yes','no') NULL DEFAULT 'no',
websettings_edit enum('yes','no') NULL DEFAULT 'no',
permissions_edit enum('yes','no') NULL DEFAULT 'no',
prune_db enum('yes','no') NULL DEFAULT 'no',
servers_edit enum('yes','no') NULL DEFAULT 'no',
ip_view enum('yes','no') NULL DEFAULT 'no',
PRIMARY KEY (level)
";
//_logs
$table_create[$_SESSION["dbprefix"]."_logs"]="
id int(11) NULL auto_increment,
timestamp int(11) NULL,
ip varchar(32) NULL,
username varchar(32) NULL,
action varchar(64) NULL,
remarks varchar(256) NULL,
PRIMARY KEY (id)
";
//_modulconfig
$table_create[$_SESSION["dbprefix"]."_modulconfig"]="
id int(11) NULL auto_increment,
menuname varchar(32) NULL,
name varchar(32) NULL,
`index` varchar(32) NULL,
activ int(1) NOT NULL DEFAULT '1',
PRIMARY KEY (id)
";
//_reasons
$table_create[$_SESSION["dbprefix"]."_reasons"]="
id int(11) NULL auto_increment,
reason varchar(100) NULL,
static_bantime int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (id)
";
//_reasons_set
$table_create[$_SESSION["dbprefix"]."_reasons_set"]="
id int(11) NULL auto_increment,
setname varchar(32) NULL,
PRIMARY KEY (id)
";
//_reasons_to_set
$table_create[$_SESSION["dbprefix"]."_reasons_to_set"]="
id int(11) NULL auto_increment,
setid int(11) NOT NULL,
reasonid int(11) NOT NULL,
PRIMARY KEY (id)
";
//_serverinfo
$table_create[$_SESSION["dbprefix"]."_serverinfo"]="
id int(11) NULL auto_increment,
timestamp int(11) NULL,
hostname varchar(100) NULL DEFAULT 'Unknown',
address varchar(100) NULL,
gametype varchar(32) NULL,
rcon varchar(32) NULL,
amxban_version varchar(32) NULL,
amxban_motd varchar(250) NULL,
motd_delay int(10) NULL DEFAULT '10',
amxban_menu int(10) NOT NULL DEFAULT '1',
reasons int(10) NULL,
timezone_fixx int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (id)
";
//_smilies
$table_create[$_SESSION["dbprefix"]."_smilies"]="
id int(5) NULL auto_increment,
code varchar(32) NULL,
url varchar(32) NULL,
name varchar(32) NULL,
PRIMARY KEY (id)
";
//_usermenu
$table_create[$_SESSION["dbprefix"]."_usermenu"]="
id int(11) NULL auto_increment,
pos int(11) NULL,
activ tinyint(1) NOT NULL DEFAULT '1',
lang_key varchar(64) NULL,
url varchar(64) NULL,
lang_key2 varchar(64) NULL,
url2 varchar(64) NULL,
PRIMARY KEY (id)
";
//_webadmins
$table_create[$_SESSION["dbprefix"]."_webadmins"]="
id int(12) NULL auto_increment,
username varchar(32) NULL,
password varchar(32) NULL,
level int(11) NULL DEFAULT '99',
logcode varchar(64) NULL,
email varchar(64) NULL,
last_action int(11) NULL,
try int(1) NOT NULL default '0',
PRIMARY KEY (id),UNIQUE (username,email)
";
//_webconfig
$table_create[$_SESSION["dbprefix"]."_webconfig"]="
id int(11) NULL auto_increment,
cookie varchar(32) NULL,
bans_per_page int(11) NULL,
design varchar(32) NULL,
banner varchar(64) NULL,
banner_url varchar(128) NOT NULL,
default_lang varchar(32) NULL,
start_page varchar(64) NULL,
show_comment_count int(1) NULL DEFAULT '1',
show_demo_count int(1) NULL DEFAULT '1',
show_kick_count int(1) NULL DEFAULT '1',
demo_all int(1) NOT NULL DEFAULT '0',
comment_all int(1) NOT NULL DEFAULT '0',
use_capture int(1) NULL DEFAULT '1',
max_file_size int(11) NULL DEFAULT '2',
file_type varchar(64) 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) NULL DEFAULT '1',
use_comment int(1) NULL DEFAULT '1',
PRIMARY KEY (id)
";
//_flagged
$table_create[$_SESSION["dbprefix"]."_flagged"]="
`fid` 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 NULL,
`admin_nick` varchar(100) default 'Unknown',
`reason` varchar(100) default NULL,
`created` int(11) default NULL,
`length` int(11) default NULL,
`server_ip` varchar(100) default NULL,
PRIMARY KEY (`fid`),
KEY `player_id` (`player_id`)
";
?>
Edytowany pod nowszą wersje MySQL plik tables.inc
Spoiler
<?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://creativecommo...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,
use_static_bantime enum('yes','no') NOT DEFAULT 'yes'
";
//_amxadmins
$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
$table_create[$_SESSION["dbprefix"]."_bans"]="
bid int(11) auto_increment,
player_ip varchar(32),
player_id varchar(35),
player_nick varchar(100) DEFAULT 'Unknown',
admin_ip varchar(32),
admin_id varchar(35) DEFAULT 'Unknown',
admin_nick varchar(100) DEFAULT 'Unknown',
ban_type varchar(10) 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) DEFAULT 'Unknown',
ban_kicks int(11) NOT DEFAULT '0',
expired int(1) NOT DEFAULT '0',
imported int(1) NOT DEFAULT '0',
PRIMARY KEY (bid),
KEY player_id (player_id)
";
//_bans_edits
$table_create[$_SESSION["dbprefix"]."_bans_edit"]="
`id` int(11) NOT auto_increment,
`bid` int(11) NOT,
`edit_time` int(11) NOT,
`admin_nick` varchar(32) NOT DEFAULT 'unknown',
`edit_reason` varchar(255) NOT,
PRIMARY KEY (`id`)
";
//_bbcode
$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
$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
$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
$table_create[$_SESSION["dbprefix"]."_levels"]="
level int(12) auto_increment,
bans_add enum('yes','no') DEFAULT 'no',
bans_edit enum('yes','no','own') DEFAULT 'no',
bans_delete enum('yes','no','own') DEFAULT 'no',
bans_unban enum('yes','no','own') DEFAULT 'no',
bans_import enum('yes','no') DEFAULT 'no',
bans_export enum('yes','no') DEFAULT 'no',
amxadmins_view enum('yes','no') DEFAULT 'no',
amxadmins_edit enum('yes','no') DEFAULT 'no',
webadmins_view enum('yes','no') DEFAULT 'no',
webadmins_edit enum('yes','no') DEFAULT 'no',
websettings_view enum('yes','no') DEFAULT 'no',
websettings_edit enum('yes','no') DEFAULT 'no',
permissions_edit enum('yes','no') DEFAULT 'no',
prune_db enum('yes','no') DEFAULT 'no',
servers_edit enum('yes','no') DEFAULT 'no',
ip_view enum('yes','no') DEFAULT 'no',
PRIMARY KEY (level)
";
//_logs
$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
$table_create[$_SESSION["dbprefix"]."_modulconfig"]="
id int(11) auto_increment,
menuname varchar(32),
name varchar(32),
`index` varchar(32),
activ int(1) NOT DEFAULT '1',
PRIMARY KEY (id)
";
//_reasons
$table_create[$_SESSION["dbprefix"]."_reasons"]="
id int(11) auto_increment,
reason varchar(100),
static_bantime int(11) NOT DEFAULT '0',
PRIMARY KEY (id)
";
//_reasons_set
$table_create[$_SESSION["dbprefix"]."_reasons_set"]="
id int(11) auto_increment,
setname varchar(32),
PRIMARY KEY (id)
";
//_reasons_to_set
$table_create[$_SESSION["dbprefix"]."_reasons_to_set"]="
id int(11) auto_increment,
setid int(11) NOT,
reasonid int(11) NOT,
PRIMARY KEY (id)
";
//_serverinfo
$table_create[$_SESSION["dbprefix"]."_serverinfo"]="
id int(11) auto_increment,
timestamp int(11),
hostname varchar(100) DEFAULT 'Unknown',
address varchar(100),
gametype varchar(32),
rcon varchar(32),
amxban_version varchar(32),
amxban_motd varchar(250),
motd_delay int(10) DEFAULT '10',
amxban_menu int(10) NOT DEFAULT '1',
reasons int(10),
timezone_fixx int(11) NOT DEFAULT '0',
PRIMARY KEY (id)
";
//_smilies
$table_create[$_SESSION["dbprefix"]."_smilies"]="
id int(5) auto_increment,
code varchar(32),
url varchar(32),
name varchar(32),
PRIMARY KEY (id)
";
//_usermenu
$table_create[$_SESSION["dbprefix"]."_usermenu"]="
id int(11) auto_increment,
pos int(11),
activ tinyint(1) NOT DEFAULT '1',
lang_key varchar(64),
url varchar(64),
lang_key2 varchar(64),
url2 varchar(64),
PRIMARY KEY (id)
";
//_webadmins
$table_create[$_SESSION["dbprefix"]."_webadmins"]="
id int(12) auto_increment,
username varchar(32),
password varchar(32),
level int(11) DEFAULT '99',
logcode varchar(64),
email varchar(64),
last_action int(11),
try int(1) NOT default '0',
PRIMARY KEY (id),UNIQUE (username,email)
";
//_webconfig
$table_create[$_SESSION["dbprefix"]."_webconfig"]="
id int(11) auto_increment,
cookie varchar(32),
bans_per_page int(11),
design varchar(32),
banner varchar(64),
banner_url varchar(128) NOT,
default_lang varchar(32),
start_page varchar(64),
show_comment_count int(1) DEFAULT '1',
show_demo_count int(1) DEFAULT '1',
show_kick_count int(1) DEFAULT '1',
demo_all int(1) NOT DEFAULT '0',
comment_all int(1) NOT DEFAULT '0',
use_capture int(1) DEFAULT '1',
max_file_size int(11) DEFAULT '2',
file_type varchar(64) DEFAULT 'dem,zip,rar,jpg,gif',
auto_prune int(1) NOT DEFAULT '0',
`max_offences` SMALLINT NOT DEFAULT '10',
`max_offences_reason` VARCHAR( 128 ) NOT DEFAULT 'max offences reached',
use_demo int(1) DEFAULT '1',
use_comment int(1) DEFAULT '1',
PRIMARY KEY (id)
";
//_flagged
$table_create[$_SESSION["dbprefix"]."_flagged"]="
`fid` int(11) NOT auto_increment,
`player_ip` varchar(32) default,
`player_id` varchar(35) default,
`player_nick` varchar(100) default 'Unknown',
`admin_ip` varchar(32) default,
`admin_id` varchar(35) default,
`admin_nick` varchar(100) default 'Unknown',
`reason` varchar(100) default,
`created` int(11) default,
`length` int(11) default,
`server_ip` varchar(100) default,
PRIMARY KEY (`fid`),
KEY `player_id` (`player_id`)
";
?>
Zmiana polega na usunięciu w poszczególnych linijkach słowa "NULL" np.
bid int(11) NULL auto_increment,
po zmianie
bid int(11) auto_increment,
Dla porównania wyżej obie wersje 
-
-
PANDA_2zl
29.11.2019
Już widziałem temat założony niedawno w tym dziale z tym problemem, ale nie podano rozwiązania. Baza utworzona prawidłowo, użytkownik z wszystkimi uprawnieniami, połączenie z bazą podczas instalacji jest, klikając dalej przy tworzeniu konta przy instalacji wychodzi wpis
Spoiler
Tworzenie struktur tabeli.
amx_admins_servers Stworzono
amx_amxadmins All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
amx_bans All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
amx_bans_edit Stworzono
Tworzenie struktur tabeli.
amx_admins_servers Stworzono
amx_amxadmins All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
amx_bans All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
amx_bans_edit Stworzono
amx_bbcode All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
amx_comments All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
amx_files All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
amx_levels All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
amx_logs All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
amx_modulconfig All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
amx_reasons All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
amx_reasons_set All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
amx_reasons_to_set All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
amx_serverinfo All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
amx_smilies All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
amx_usermenu All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
amx_webadmins All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
amx_webconfig All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
amx_flagged Stworzono
Podawanie wymaganych danych
amx_bbcode Niepowodzenie
amx_smilies Niepowodzenie
Wprowadzanie ustawień
Strona www Niepowodzenie
Ustawianie Menu użytkownika
Menu użytkownika Niepowodzenie
Instalacja modułu
iexport Niepowodzenie
Tworzenie Konta Głównego
Poziom Głównego Konta Niepowodzenie
Dane Głównego konta Niepowodzenie
- Zmiana wersji PHP, nadal ten sam błąd
- Testowanie kilku paczek AmxBans, wciąż to samo
Sprawdzałem już chyba wszystkie możliwości i zero rezultatów
Ktoś mógłby powiedzieć jak temu zaradzić?
Użytkownik SezonowyGracz edytował ten post 29.11.2019 14:45
-
-
Najlepsza odpowiedź
PANDA_2zl
02.12.2019
No to tak dla tych co będą mieć z tym problem, trzeba przerobić plik tables.inc, który znajduje sie w folderze install
oryginalny plik tables.inc
Spoiler
<?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://creativecommo...by-nc-sa/2.0/>.
*/
// AMXBans DB structure v6.0
//_admins_servers
$table_create[$_SESSION["dbprefix"]."_admins_servers"]="
admin_id int(11) NULL,
server_id int(11) NULL,
custom_flags varchar(32) NOT NULL,
use_static_bantime enum('yes','no') NOT NULL DEFAULT 'yes'
";
//_amxadmins
$table_create[$_SESSION["dbprefix"]."_amxadmins"]="
id int(12) NULL auto_increment,
username varchar(32) NULL,
password varchar(50) NULL,
access varchar(32) NULL,
flags varchar(32) NULL,
steamid varchar(32) NULL,
nickname varchar(32) NULL,
icq int(9) NULL,
ashow int(11) NULL,
created int(11) NULL,
expired int(11) NULL,
days int(11) NULL,
PRIMARY KEY (id),
KEY steamid (steamid)
";
//_bans
$table_create[$_SESSION["dbprefix"]."_bans"]="
bid int(11) NULL auto_increment,
player_ip varchar(32) NULL,
player_id varchar(35) NULL,
player_nick varchar(100) NULL DEFAULT 'Unknown',
admin_ip varchar(32) NULL,
admin_id varchar(35) DEFAULT 'Unknown',
admin_nick varchar(100) NULL DEFAULT 'Unknown',
ban_type varchar(10) NULL DEFAULT 'S',
ban_reason varchar(100) NULL,
cs_ban_reason varchar(100) NULL,
ban_created int(11) NULL,
ban_length int(11) NULL,
server_ip varchar(32) NULL,
server_name varchar(100) 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
$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
$table_create[$_SESSION["dbprefix"]."_bbcode"]="
id int(11) NULL auto_increment,
open_tag varchar(32) NULL,
close_tag varchar(32) NULL,
url varchar(32) NULL,
name varchar(32) NULL,
PRIMARY KEY (id)
";
//_comments
$table_create[$_SESSION["dbprefix"]."_comments"]="
id int(11) NULL auto_increment,
name varchar(35) NULL,
comment text NULL,
email varchar(100) NULL,
addr varchar(32) NULL,
date int(11) NULL,
bid int(11) NULL,
PRIMARY KEY (id)
";
//_files
$table_create[$_SESSION["dbprefix"]."_files"]="
id int(11) NULL auto_increment,
upload_time int(11) NULL,
down_count int(11) NULL,
bid int(11) NULL,
demo_file varchar(100) NULL,
demo_real varchar(100) NULL,
file_size int(11) NULL,
comment text NULL,
name varchar(64) NULL,
email varchar(64) NULL,
addr varchar(32) NULL,
PRIMARY KEY (id)
";
//_levels
$table_create[$_SESSION["dbprefix"]."_levels"]="
level int(12) NULL,
bans_add enum('yes','no') NULL DEFAULT 'no',
bans_edit enum('yes','no','own') NULL DEFAULT 'no',
bans_delete enum('yes','no','own') NULL DEFAULT 'no',
bans_unban enum('yes','no','own') NULL DEFAULT 'no',
bans_import enum('yes','no') NULL DEFAULT 'no',
bans_export enum('yes','no') NULL DEFAULT 'no',
amxadmins_view enum('yes','no') NULL DEFAULT 'no',
amxadmins_edit enum('yes','no') NULL DEFAULT 'no',
webadmins_view enum('yes','no') NULL DEFAULT 'no',
webadmins_edit enum('yes','no') NULL DEFAULT 'no',
websettings_view enum('yes','no') NULL DEFAULT 'no',
websettings_edit enum('yes','no') NULL DEFAULT 'no',
permissions_edit enum('yes','no') NULL DEFAULT 'no',
prune_db enum('yes','no') NULL DEFAULT 'no',
servers_edit enum('yes','no') NULL DEFAULT 'no',
ip_view enum('yes','no') NULL DEFAULT 'no',
PRIMARY KEY (level)
";
//_logs
$table_create[$_SESSION["dbprefix"]."_logs"]="
id int(11) NULL auto_increment,
timestamp int(11) NULL,
ip varchar(32) NULL,
username varchar(32) NULL,
action varchar(64) NULL,
remarks varchar(256) NULL,
PRIMARY KEY (id)
";
//_modulconfig
$table_create[$_SESSION["dbprefix"]."_modulconfig"]="
id int(11) NULL auto_increment,
menuname varchar(32) NULL,
name varchar(32) NULL,
`index` varchar(32) NULL,
activ int(1) NOT NULL DEFAULT '1',
PRIMARY KEY (id)
";
//_reasons
$table_create[$_SESSION["dbprefix"]."_reasons"]="
id int(11) NULL auto_increment,
reason varchar(100) NULL,
static_bantime int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (id)
";
//_reasons_set
$table_create[$_SESSION["dbprefix"]."_reasons_set"]="
id int(11) NULL auto_increment,
setname varchar(32) NULL,
PRIMARY KEY (id)
";
//_reasons_to_set
$table_create[$_SESSION["dbprefix"]."_reasons_to_set"]="
id int(11) NULL auto_increment,
setid int(11) NOT NULL,
reasonid int(11) NOT NULL,
PRIMARY KEY (id)
";
//_serverinfo
$table_create[$_SESSION["dbprefix"]."_serverinfo"]="
id int(11) NULL auto_increment,
timestamp int(11) NULL,
hostname varchar(100) NULL DEFAULT 'Unknown',
address varchar(100) NULL,
gametype varchar(32) NULL,
rcon varchar(32) NULL,
amxban_version varchar(32) NULL,
amxban_motd varchar(250) NULL,
motd_delay int(10) NULL DEFAULT '10',
amxban_menu int(10) NOT NULL DEFAULT '1',
reasons int(10) NULL,
timezone_fixx int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (id)
";
//_smilies
$table_create[$_SESSION["dbprefix"]."_smilies"]="
id int(5) NULL auto_increment,
code varchar(32) NULL,
url varchar(32) NULL,
name varchar(32) NULL,
PRIMARY KEY (id)
";
//_usermenu
$table_create[$_SESSION["dbprefix"]."_usermenu"]="
id int(11) NULL auto_increment,
pos int(11) NULL,
activ tinyint(1) NOT NULL DEFAULT '1',
lang_key varchar(64) NULL,
url varchar(64) NULL,
lang_key2 varchar(64) NULL,
url2 varchar(64) NULL,
PRIMARY KEY (id)
";
//_webadmins
$table_create[$_SESSION["dbprefix"]."_webadmins"]="
id int(12) NULL auto_increment,
username varchar(32) NULL,
password varchar(32) NULL,
level int(11) NULL DEFAULT '99',
logcode varchar(64) NULL,
email varchar(64) NULL,
last_action int(11) NULL,
try int(1) NOT NULL default '0',
PRIMARY KEY (id),UNIQUE (username,email)
";
//_webconfig
$table_create[$_SESSION["dbprefix"]."_webconfig"]="
id int(11) NULL auto_increment,
cookie varchar(32) NULL,
bans_per_page int(11) NULL,
design varchar(32) NULL,
banner varchar(64) NULL,
banner_url varchar(128) NOT NULL,
default_lang varchar(32) NULL,
start_page varchar(64) NULL,
show_comment_count int(1) NULL DEFAULT '1',
show_demo_count int(1) NULL DEFAULT '1',
show_kick_count int(1) NULL DEFAULT '1',
demo_all int(1) NOT NULL DEFAULT '0',
comment_all int(1) NOT NULL DEFAULT '0',
use_capture int(1) NULL DEFAULT '1',
max_file_size int(11) NULL DEFAULT '2',
file_type varchar(64) 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) NULL DEFAULT '1',
use_comment int(1) NULL DEFAULT '1',
PRIMARY KEY (id)
";
//_flagged
$table_create[$_SESSION["dbprefix"]."_flagged"]="
`fid` 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 NULL,
`admin_nick` varchar(100) default 'Unknown',
`reason` varchar(100) default NULL,
`created` int(11) default NULL,
`length` int(11) default NULL,
`server_ip` varchar(100) default NULL,
PRIMARY KEY (`fid`),
KEY `player_id` (`player_id`)
";
?>
Edytowany pod nowszą wersje MySQL plik tables.inc
Spoiler
<?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://creativecommo...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,
use_static_bantime enum('yes','no') NOT DEFAULT 'yes'
";
//_amxadmins
$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
$table_create[$_SESSION["dbprefix"]."_bans"]="
bid int(11) auto_increment,
player_ip varchar(32),
player_id varchar(35),
player_nick varchar(100) DEFAULT 'Unknown',
admin_ip varchar(32),
admin_id varchar(35) DEFAULT 'Unknown',
admin_nick varchar(100) DEFAULT 'Unknown',
ban_type varchar(10) 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) DEFAULT 'Unknown',
ban_kicks int(11) NOT DEFAULT '0',
expired int(1) NOT DEFAULT '0',
imported int(1) NOT DEFAULT '0',
PRIMARY KEY (bid),
KEY player_id (player_id)
";
//_bans_edits
$table_create[$_SESSION["dbprefix"]."_bans_edit"]="
`id` int(11) NOT auto_increment,
`bid` int(11) NOT,
`edit_time` int(11) NOT,
`admin_nick` varchar(32) NOT DEFAULT 'unknown',
`edit_reason` varchar(255) NOT,
PRIMARY KEY (`id`)
";
//_bbcode
$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
$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
$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
$table_create[$_SESSION["dbprefix"]."_levels"]="
level int(12) auto_increment,
bans_add enum('yes','no') DEFAULT 'no',
bans_edit enum('yes','no','own') DEFAULT 'no',
bans_delete enum('yes','no','own') DEFAULT 'no',
bans_unban enum('yes','no','own') DEFAULT 'no',
bans_import enum('yes','no') DEFAULT 'no',
bans_export enum('yes','no') DEFAULT 'no',
amxadmins_view enum('yes','no') DEFAULT 'no',
amxadmins_edit enum('yes','no') DEFAULT 'no',
webadmins_view enum('yes','no') DEFAULT 'no',
webadmins_edit enum('yes','no') DEFAULT 'no',
websettings_view enum('yes','no') DEFAULT 'no',
websettings_edit enum('yes','no') DEFAULT 'no',
permissions_edit enum('yes','no') DEFAULT 'no',
prune_db enum('yes','no') DEFAULT 'no',
servers_edit enum('yes','no') DEFAULT 'no',
ip_view enum('yes','no') DEFAULT 'no',
PRIMARY KEY (level)
";
//_logs
$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
$table_create[$_SESSION["dbprefix"]."_modulconfig"]="
id int(11) auto_increment,
menuname varchar(32),
name varchar(32),
`index` varchar(32),
activ int(1) NOT DEFAULT '1',
PRIMARY KEY (id)
";
//_reasons
$table_create[$_SESSION["dbprefix"]."_reasons"]="
id int(11) auto_increment,
reason varchar(100),
static_bantime int(11) NOT DEFAULT '0',
PRIMARY KEY (id)
";
//_reasons_set
$table_create[$_SESSION["dbprefix"]."_reasons_set"]="
id int(11) auto_increment,
setname varchar(32),
PRIMARY KEY (id)
";
//_reasons_to_set
$table_create[$_SESSION["dbprefix"]."_reasons_to_set"]="
id int(11) auto_increment,
setid int(11) NOT,
reasonid int(11) NOT,
PRIMARY KEY (id)
";
//_serverinfo
$table_create[$_SESSION["dbprefix"]."_serverinfo"]="
id int(11) auto_increment,
timestamp int(11),
hostname varchar(100) DEFAULT 'Unknown',
address varchar(100),
gametype varchar(32),
rcon varchar(32),
amxban_version varchar(32),
amxban_motd varchar(250),
motd_delay int(10) DEFAULT '10',
amxban_menu int(10) NOT DEFAULT '1',
reasons int(10),
timezone_fixx int(11) NOT DEFAULT '0',
PRIMARY KEY (id)
";
//_smilies
$table_create[$_SESSION["dbprefix"]."_smilies"]="
id int(5) auto_increment,
code varchar(32),
url varchar(32),
name varchar(32),
PRIMARY KEY (id)
";
//_usermenu
$table_create[$_SESSION["dbprefix"]."_usermenu"]="
id int(11) auto_increment,
pos int(11),
activ tinyint(1) NOT DEFAULT '1',
lang_key varchar(64),
url varchar(64),
lang_key2 varchar(64),
url2 varchar(64),
PRIMARY KEY (id)
";
//_webadmins
$table_create[$_SESSION["dbprefix"]."_webadmins"]="
id int(12) auto_increment,
username varchar(32),
password varchar(32),
level int(11) DEFAULT '99',
logcode varchar(64),
email varchar(64),
last_action int(11),
try int(1) NOT default '0',
PRIMARY KEY (id),UNIQUE (username,email)
";
//_webconfig
$table_create[$_SESSION["dbprefix"]."_webconfig"]="
id int(11) auto_increment,
cookie varchar(32),
bans_per_page int(11),
design varchar(32),
banner varchar(64),
banner_url varchar(128) NOT,
default_lang varchar(32),
start_page varchar(64),
show_comment_count int(1) DEFAULT '1',
show_demo_count int(1) DEFAULT '1',
show_kick_count int(1) DEFAULT '1',
demo_all int(1) NOT DEFAULT '0',
comment_all int(1) NOT DEFAULT '0',
use_capture int(1) DEFAULT '1',
max_file_size int(11) DEFAULT '2',
file_type varchar(64) DEFAULT 'dem,zip,rar,jpg,gif',
auto_prune int(1) NOT DEFAULT '0',
`max_offences` SMALLINT NOT DEFAULT '10',
`max_offences_reason` VARCHAR( 128 ) NOT DEFAULT 'max offences reached',
use_demo int(1) DEFAULT '1',
use_comment int(1) DEFAULT '1',
PRIMARY KEY (id)
";
//_flagged
$table_create[$_SESSION["dbprefix"]."_flagged"]="
`fid` int(11) NOT auto_increment,
`player_ip` varchar(32) default,
`player_id` varchar(35) default,
`player_nick` varchar(100) default 'Unknown',
`admin_ip` varchar(32) default,
`admin_id` varchar(35) default,
`admin_nick` varchar(100) default 'Unknown',
`reason` varchar(100) default,
`created` int(11) default,
`length` int(11) default,
`server_ip` varchar(100) default,
PRIMARY KEY (`fid`),
KEY `player_id` (`player_id`)
";
?>
Zmiana polega na usunięciu w poszczególnych linijkach słowa "NULL" np.
bid int(11) NULL auto_increment,
po zmianie
bid int(11) auto_increment,
Dla porównania wyżej obie wersje
Użytkownik SezonowyGracz edytował ten post 02.12.2019 21:35
-
-
maska1
10.12.2019
No to tak dla tych co będą mieć z tym problem, trzeba przerobić plik tables.inc, który znajduje sie w folderze install
oryginalny plik tables.inc
Spoiler<?php/*AMXBans v6.0Copyright 2009, 2010 by SeToY & |PJ|ShOrTyThis file is part of AMXBans.AMXBans is free software, but it's licensed under theCreative Commons - Attribution-NonCommercial-ShareAlike 2.0AMXBans is distributed in the hope that it will be useful,but WITHOUT ANY WARRANTY; without even the implied warranty ofMERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.You should have received a copy of the cc-nC-SA along with AMXBans.If not, see <http://creativecommo...by-nc-sa/2.0/>.*/// AMXBans DB structure v6.0//_admins_servers$table_create[$_SESSION["dbprefix"]."_admins_servers"]="admin_id int(11) NULL,server_id int(11) NULL,custom_flags varchar(32) NOT NULL,use_static_bantime enum('yes','no') NOT NULL DEFAULT 'yes'";//_amxadmins$table_create[$_SESSION["dbprefix"]."_amxadmins"]="id int(12) NULL auto_increment,username varchar(32) NULL,password varchar(50) NULL,access varchar(32) NULL,flags varchar(32) NULL,steamid varchar(32) NULL,nickname varchar(32) NULL,icq int(9) NULL,ashow int(11) NULL,created int(11) NULL,expired int(11) NULL,days int(11) NULL,PRIMARY KEY (id),KEY steamid (steamid)";//_bans$table_create[$_SESSION["dbprefix"]."_bans"]="bid int(11) NULL auto_increment,player_ip varchar(32) NULL,player_id varchar(35) NULL,player_nick varchar(100) NULL DEFAULT 'Unknown',admin_ip varchar(32) NULL,admin_id varchar(35) DEFAULT 'Unknown',admin_nick varchar(100) NULL DEFAULT 'Unknown',ban_type varchar(10) NULL DEFAULT 'S',ban_reason varchar(100) NULL,cs_ban_reason varchar(100) NULL,ban_created int(11) NULL,ban_length int(11) NULL,server_ip varchar(32) NULL,server_name varchar(100) 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$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$table_create[$_SESSION["dbprefix"]."_bbcode"]="id int(11) NULL auto_increment,open_tag varchar(32) NULL,close_tag varchar(32) NULL,url varchar(32) NULL,name varchar(32) NULL,PRIMARY KEY (id)";//_comments$table_create[$_SESSION["dbprefix"]."_comments"]="id int(11) NULL auto_increment,name varchar(35) NULL,comment text NULL,email varchar(100) NULL,addr varchar(32) NULL,date int(11) NULL,bid int(11) NULL,PRIMARY KEY (id)";//_files$table_create[$_SESSION["dbprefix"]."_files"]="id int(11) NULL auto_increment,upload_time int(11) NULL,down_count int(11) NULL,bid int(11) NULL,demo_file varchar(100) NULL,demo_real varchar(100) NULL,file_size int(11) NULL,comment text NULL,name varchar(64) NULL,email varchar(64) NULL,addr varchar(32) NULL,PRIMARY KEY (id)";//_levels$table_create[$_SESSION["dbprefix"]."_levels"]="level int(12) NULL,bans_add enum('yes','no') NULL DEFAULT 'no',bans_edit enum('yes','no','own') NULL DEFAULT 'no',bans_delete enum('yes','no','own') NULL DEFAULT 'no',bans_unban enum('yes','no','own') NULL DEFAULT 'no',bans_import enum('yes','no') NULL DEFAULT 'no',bans_export enum('yes','no') NULL DEFAULT 'no',amxadmins_view enum('yes','no') NULL DEFAULT 'no',amxadmins_edit enum('yes','no') NULL DEFAULT 'no',webadmins_view enum('yes','no') NULL DEFAULT 'no',webadmins_edit enum('yes','no') NULL DEFAULT 'no',websettings_view enum('yes','no') NULL DEFAULT 'no',websettings_edit enum('yes','no') NULL DEFAULT 'no',permissions_edit enum('yes','no') NULL DEFAULT 'no',prune_db enum('yes','no') NULL DEFAULT 'no',servers_edit enum('yes','no') NULL DEFAULT 'no',ip_view enum('yes','no') NULL DEFAULT 'no',PRIMARY KEY (level)";//_logs$table_create[$_SESSION["dbprefix"]."_logs"]="id int(11) NULL auto_increment,timestamp int(11) NULL,ip varchar(32) NULL,username varchar(32) NULL,action varchar(64) NULL,remarks varchar(256) NULL,PRIMARY KEY (id)";//_modulconfig$table_create[$_SESSION["dbprefix"]."_modulconfig"]="id int(11) NULL auto_increment,menuname varchar(32) NULL,name varchar(32) NULL,`index` varchar(32) NULL,activ int(1) NOT NULL DEFAULT '1',PRIMARY KEY (id)";//_reasons$table_create[$_SESSION["dbprefix"]."_reasons"]="id int(11) NULL auto_increment,reason varchar(100) NULL,static_bantime int(11) NOT NULL DEFAULT '0',PRIMARY KEY (id)";//_reasons_set$table_create[$_SESSION["dbprefix"]."_reasons_set"]="id int(11) NULL auto_increment,setname varchar(32) NULL,PRIMARY KEY (id)";//_reasons_to_set$table_create[$_SESSION["dbprefix"]."_reasons_to_set"]="id int(11) NULL auto_increment,setid int(11) NOT NULL,reasonid int(11) NOT NULL,PRIMARY KEY (id)";//_serverinfo$table_create[$_SESSION["dbprefix"]."_serverinfo"]="id int(11) NULL auto_increment,timestamp int(11) NULL,hostname varchar(100) NULL DEFAULT 'Unknown',address varchar(100) NULL,gametype varchar(32) NULL,rcon varchar(32) NULL,amxban_version varchar(32) NULL,amxban_motd varchar(250) NULL,motd_delay int(10) NULL DEFAULT '10',amxban_menu int(10) NOT NULL DEFAULT '1',reasons int(10) NULL,timezone_fixx int(11) NOT NULL DEFAULT '0',PRIMARY KEY (id)";//_smilies$table_create[$_SESSION["dbprefix"]."_smilies"]="id int(5) NULL auto_increment,code varchar(32) NULL,url varchar(32) NULL,name varchar(32) NULL,PRIMARY KEY (id)";//_usermenu$table_create[$_SESSION["dbprefix"]."_usermenu"]="id int(11) NULL auto_increment,pos int(11) NULL,activ tinyint(1) NOT NULL DEFAULT '1',lang_key varchar(64) NULL,url varchar(64) NULL,lang_key2 varchar(64) NULL,url2 varchar(64) NULL,PRIMARY KEY (id)";//_webadmins$table_create[$_SESSION["dbprefix"]."_webadmins"]="id int(12) NULL auto_increment,username varchar(32) NULL,password varchar(32) NULL,level int(11) NULL DEFAULT '99',logcode varchar(64) NULL,email varchar(64) NULL,last_action int(11) NULL,try int(1) NOT NULL default '0',PRIMARY KEY (id),UNIQUE (username,email)";//_webconfig$table_create[$_SESSION["dbprefix"]."_webconfig"]="id int(11) NULL auto_increment,cookie varchar(32) NULL,bans_per_page int(11) NULL,design varchar(32) NULL,banner varchar(64) NULL,banner_url varchar(128) NOT NULL,default_lang varchar(32) NULL,start_page varchar(64) NULL,show_comment_count int(1) NULL DEFAULT '1',show_demo_count int(1) NULL DEFAULT '1',show_kick_count int(1) NULL DEFAULT '1',demo_all int(1) NOT NULL DEFAULT '0',comment_all int(1) NOT NULL DEFAULT '0',use_capture int(1) NULL DEFAULT '1',max_file_size int(11) NULL DEFAULT '2',file_type varchar(64) 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) NULL DEFAULT '1',use_comment int(1) NULL DEFAULT '1',PRIMARY KEY (id)";//_flagged$table_create[$_SESSION["dbprefix"]."_flagged"]="`fid` 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 NULL,`admin_nick` varchar(100) default 'Unknown',`reason` varchar(100) default NULL,`created` int(11) default NULL,`length` int(11) default NULL,`server_ip` varchar(100) default NULL,PRIMARY KEY (`fid`),KEY `player_id` (`player_id`)";?>Edytowany pod nowszą wersje MySQL plik tables.incSpoiler<?php/*AMXBans v6.0Copyright 2009, 2010 by SeToY & |PJ|ShOrTyThis file is part of AMXBans.AMXBans is free software, but it's licensed under theCreative Commons - Attribution-NonCommercial-ShareAlike 2.0AMXBans is distributed in the hope that it will be useful,but WITHOUT ANY WARRANTY; without even the implied warranty ofMERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.You should have received a copy of the cc-nC-SA along with AMXBans.If not, see <http://creativecommo...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,use_static_bantime enum('yes','no') NOT DEFAULT 'yes'";//_amxadmins$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$table_create[$_SESSION["dbprefix"]."_bans"]="bid int(11) auto_increment,player_ip varchar(32),player_id varchar(35),player_nick varchar(100) DEFAULT 'Unknown',admin_ip varchar(32),admin_id varchar(35) DEFAULT 'Unknown',admin_nick varchar(100) DEFAULT 'Unknown',ban_type varchar(10) 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) DEFAULT 'Unknown',ban_kicks int(11) NOT DEFAULT '0',expired int(1) NOT DEFAULT '0',imported int(1) NOT DEFAULT '0',PRIMARY KEY (bid),KEY player_id (player_id)";//_bans_edits$table_create[$_SESSION["dbprefix"]."_bans_edit"]="`id` int(11) NOT auto_increment,`bid` int(11) NOT,`edit_time` int(11) NOT,`admin_nick` varchar(32) NOT DEFAULT 'unknown',`edit_reason` varchar(255) NOT,PRIMARY KEY (`id`)";//_bbcode$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$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$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$table_create[$_SESSION["dbprefix"]."_levels"]="level int(12) auto_increment,bans_add enum('yes','no') DEFAULT 'no',bans_edit enum('yes','no','own') DEFAULT 'no',bans_delete enum('yes','no','own') DEFAULT 'no',bans_unban enum('yes','no','own') DEFAULT 'no',bans_import enum('yes','no') DEFAULT 'no',bans_export enum('yes','no') DEFAULT 'no',amxadmins_view enum('yes','no') DEFAULT 'no',amxadmins_edit enum('yes','no') DEFAULT 'no',webadmins_view enum('yes','no') DEFAULT 'no',webadmins_edit enum('yes','no') DEFAULT 'no',websettings_view enum('yes','no') DEFAULT 'no',websettings_edit enum('yes','no') DEFAULT 'no',permissions_edit enum('yes','no') DEFAULT 'no',prune_db enum('yes','no') DEFAULT 'no',servers_edit enum('yes','no') DEFAULT 'no',ip_view enum('yes','no') DEFAULT 'no',PRIMARY KEY (level)";//_logs$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$table_create[$_SESSION["dbprefix"]."_modulconfig"]="id int(11) auto_increment,menuname varchar(32),name varchar(32),`index` varchar(32),activ int(1) NOT DEFAULT '1',PRIMARY KEY (id)";//_reasons$table_create[$_SESSION["dbprefix"]."_reasons"]="id int(11) auto_increment,reason varchar(100),static_bantime int(11) NOT DEFAULT '0',PRIMARY KEY (id)";//_reasons_set$table_create[$_SESSION["dbprefix"]."_reasons_set"]="id int(11) auto_increment,setname varchar(32),PRIMARY KEY (id)";//_reasons_to_set$table_create[$_SESSION["dbprefix"]."_reasons_to_set"]="id int(11) auto_increment,setid int(11) NOT,reasonid int(11) NOT,PRIMARY KEY (id)";//_serverinfo$table_create[$_SESSION["dbprefix"]."_serverinfo"]="id int(11) auto_increment,timestamp int(11),hostname varchar(100) DEFAULT 'Unknown',address varchar(100),gametype varchar(32),rcon varchar(32),amxban_version varchar(32),amxban_motd varchar(250),motd_delay int(10) DEFAULT '10',amxban_menu int(10) NOT DEFAULT '1',reasons int(10),timezone_fixx int(11) NOT DEFAULT '0',PRIMARY KEY (id)";//_smilies$table_create[$_SESSION["dbprefix"]."_smilies"]="id int(5) auto_increment,code varchar(32),url varchar(32),name varchar(32),PRIMARY KEY (id)";//_usermenu$table_create[$_SESSION["dbprefix"]."_usermenu"]="id int(11) auto_increment,pos int(11),activ tinyint(1) NOT DEFAULT '1',lang_key varchar(64),url varchar(64),lang_key2 varchar(64),url2 varchar(64),PRIMARY KEY (id)";//_webadmins$table_create[$_SESSION["dbprefix"]."_webadmins"]="id int(12) auto_increment,username varchar(32),password varchar(32),level int(11) DEFAULT '99',logcode varchar(64),email varchar(64),last_action int(11),try int(1) NOT default '0',PRIMARY KEY (id),UNIQUE (username,email)";//_webconfig$table_create[$_SESSION["dbprefix"]."_webconfig"]="id int(11) auto_increment,cookie varchar(32),bans_per_page int(11),design varchar(32),banner varchar(64),banner_url varchar(128) NOT,default_lang varchar(32),start_page varchar(64),show_comment_count int(1) DEFAULT '1',show_demo_count int(1) DEFAULT '1',show_kick_count int(1) DEFAULT '1',demo_all int(1) NOT DEFAULT '0',comment_all int(1) NOT DEFAULT '0',use_capture int(1) DEFAULT '1',max_file_size int(11) DEFAULT '2',file_type varchar(64) DEFAULT 'dem,zip,rar,jpg,gif',auto_prune int(1) NOT DEFAULT '0',`max_offences` SMALLINT NOT DEFAULT '10',`max_offences_reason` VARCHAR( 128 ) NOT DEFAULT 'max offences reached',use_demo int(1) DEFAULT '1',use_comment int(1) DEFAULT '1',PRIMARY KEY (id)";//_flagged$table_create[$_SESSION["dbprefix"]."_flagged"]="`fid` int(11) NOT auto_increment,`player_ip` varchar(32) default,`player_id` varchar(35) default,`player_nick` varchar(100) default 'Unknown',`admin_ip` varchar(32) default,`admin_id` varchar(35) default,`admin_nick` varchar(100) default 'Unknown',`reason` varchar(100) default,`created` int(11) default,`length` int(11) default,`server_ip` varchar(100) default,PRIMARY KEY (`fid`),KEY `player_id` (`player_id`)";?>Zmiana polega na usunięciu w poszczególnych linijkach słowa "NULL" np.bid int(11) NULL auto_increment,po zmianiebid int(11) auto_increment,Dla porównania wyżej obie wersje
Cos tam lepiej ale nadal to nie dziala wiesz jak to ogarnac?
-
-
maska1
10.12.2019
No to tak dla tych co będą mieć z tym problem, trzeba przerobić plik tables.inc, który znajduje sie w folderze install
oryginalny plik tables.inc
Spoiler<?php/*AMXBans v6.0Copyright 2009, 2010 by SeToY & |PJ|ShOrTyThis file is part of AMXBans.AMXBans is free software, but it's licensed under theCreative Commons - Attribution-NonCommercial-ShareAlike 2.0AMXBans is distributed in the hope that it will be useful,but WITHOUT ANY WARRANTY; without even the implied warranty ofMERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.You should have received a copy of the cc-nC-SA along with AMXBans.If not, see <http://creativecommo...by-nc-sa/2.0/>.*/// AMXBans DB structure v6.0//_admins_servers$table_create[$_SESSION["dbprefix"]."_admins_servers"]="admin_id int(11) NULL,server_id int(11) NULL,custom_flags varchar(32) NOT NULL,use_static_bantime enum('yes','no') NOT NULL DEFAULT 'yes'";//_amxadmins$table_create[$_SESSION["dbprefix"]."_amxadmins"]="id int(12) NULL auto_increment,username varchar(32) NULL,password varchar(50) NULL,access varchar(32) NULL,flags varchar(32) NULL,steamid varchar(32) NULL,nickname varchar(32) NULL,icq int(9) NULL,ashow int(11) NULL,created int(11) NULL,expired int(11) NULL,days int(11) NULL,PRIMARY KEY (id),KEY steamid (steamid)";//_bans$table_create[$_SESSION["dbprefix"]."_bans"]="bid int(11) NULL auto_increment,player_ip varchar(32) NULL,player_id varchar(35) NULL,player_nick varchar(100) NULL DEFAULT 'Unknown',admin_ip varchar(32) NULL,admin_id varchar(35) DEFAULT 'Unknown',admin_nick varchar(100) NULL DEFAULT 'Unknown',ban_type varchar(10) NULL DEFAULT 'S',ban_reason varchar(100) NULL,cs_ban_reason varchar(100) NULL,ban_created int(11) NULL,ban_length int(11) NULL,server_ip varchar(32) NULL,server_name varchar(100) 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$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$table_create[$_SESSION["dbprefix"]."_bbcode"]="id int(11) NULL auto_increment,open_tag varchar(32) NULL,close_tag varchar(32) NULL,url varchar(32) NULL,name varchar(32) NULL,PRIMARY KEY (id)";//_comments$table_create[$_SESSION["dbprefix"]."_comments"]="id int(11) NULL auto_increment,name varchar(35) NULL,comment text NULL,email varchar(100) NULL,addr varchar(32) NULL,date int(11) NULL,bid int(11) NULL,PRIMARY KEY (id)";//_files$table_create[$_SESSION["dbprefix"]."_files"]="id int(11) NULL auto_increment,upload_time int(11) NULL,down_count int(11) NULL,bid int(11) NULL,demo_file varchar(100) NULL,demo_real varchar(100) NULL,file_size int(11) NULL,comment text NULL,name varchar(64) NULL,email varchar(64) NULL,addr varchar(32) NULL,PRIMARY KEY (id)";//_levels$table_create[$_SESSION["dbprefix"]."_levels"]="level int(12) NULL,bans_add enum('yes','no') NULL DEFAULT 'no',bans_edit enum('yes','no','own') NULL DEFAULT 'no',bans_delete enum('yes','no','own') NULL DEFAULT 'no',bans_unban enum('yes','no','own') NULL DEFAULT 'no',bans_import enum('yes','no') NULL DEFAULT 'no',bans_export enum('yes','no') NULL DEFAULT 'no',amxadmins_view enum('yes','no') NULL DEFAULT 'no',amxadmins_edit enum('yes','no') NULL DEFAULT 'no',webadmins_view enum('yes','no') NULL DEFAULT 'no',webadmins_edit enum('yes','no') NULL DEFAULT 'no',websettings_view enum('yes','no') NULL DEFAULT 'no',websettings_edit enum('yes','no') NULL DEFAULT 'no',permissions_edit enum('yes','no') NULL DEFAULT 'no',prune_db enum('yes','no') NULL DEFAULT 'no',servers_edit enum('yes','no') NULL DEFAULT 'no',ip_view enum('yes','no') NULL DEFAULT 'no',PRIMARY KEY (level)";//_logs$table_create[$_SESSION["dbprefix"]."_logs"]="id int(11) NULL auto_increment,timestamp int(11) NULL,ip varchar(32) NULL,username varchar(32) NULL,action varchar(64) NULL,remarks varchar(256) NULL,PRIMARY KEY (id)";//_modulconfig$table_create[$_SESSION["dbprefix"]."_modulconfig"]="id int(11) NULL auto_increment,menuname varchar(32) NULL,name varchar(32) NULL,`index` varchar(32) NULL,activ int(1) NOT NULL DEFAULT '1',PRIMARY KEY (id)";//_reasons$table_create[$_SESSION["dbprefix"]."_reasons"]="id int(11) NULL auto_increment,reason varchar(100) NULL,static_bantime int(11) NOT NULL DEFAULT '0',PRIMARY KEY (id)";//_reasons_set$table_create[$_SESSION["dbprefix"]."_reasons_set"]="id int(11) NULL auto_increment,setname varchar(32) NULL,PRIMARY KEY (id)";//_reasons_to_set$table_create[$_SESSION["dbprefix"]."_reasons_to_set"]="id int(11) NULL auto_increment,setid int(11) NOT NULL,reasonid int(11) NOT NULL,PRIMARY KEY (id)";//_serverinfo$table_create[$_SESSION["dbprefix"]."_serverinfo"]="id int(11) NULL auto_increment,timestamp int(11) NULL,hostname varchar(100) NULL DEFAULT 'Unknown',address varchar(100) NULL,gametype varchar(32) NULL,rcon varchar(32) NULL,amxban_version varchar(32) NULL,amxban_motd varchar(250) NULL,motd_delay int(10) NULL DEFAULT '10',amxban_menu int(10) NOT NULL DEFAULT '1',reasons int(10) NULL,timezone_fixx int(11) NOT NULL DEFAULT '0',PRIMARY KEY (id)";//_smilies$table_create[$_SESSION["dbprefix"]."_smilies"]="id int(5) NULL auto_increment,code varchar(32) NULL,url varchar(32) NULL,name varchar(32) NULL,PRIMARY KEY (id)";//_usermenu$table_create[$_SESSION["dbprefix"]."_usermenu"]="id int(11) NULL auto_increment,pos int(11) NULL,activ tinyint(1) NOT NULL DEFAULT '1',lang_key varchar(64) NULL,url varchar(64) NULL,lang_key2 varchar(64) NULL,url2 varchar(64) NULL,PRIMARY KEY (id)";//_webadmins$table_create[$_SESSION["dbprefix"]."_webadmins"]="id int(12) NULL auto_increment,username varchar(32) NULL,password varchar(32) NULL,level int(11) NULL DEFAULT '99',logcode varchar(64) NULL,email varchar(64) NULL,last_action int(11) NULL,try int(1) NOT NULL default '0',PRIMARY KEY (id),UNIQUE (username,email)";//_webconfig$table_create[$_SESSION["dbprefix"]."_webconfig"]="id int(11) NULL auto_increment,cookie varchar(32) NULL,bans_per_page int(11) NULL,design varchar(32) NULL,banner varchar(64) NULL,banner_url varchar(128) NOT NULL,default_lang varchar(32) NULL,start_page varchar(64) NULL,show_comment_count int(1) NULL DEFAULT '1',show_demo_count int(1) NULL DEFAULT '1',show_kick_count int(1) NULL DEFAULT '1',demo_all int(1) NOT NULL DEFAULT '0',comment_all int(1) NOT NULL DEFAULT '0',use_capture int(1) NULL DEFAULT '1',max_file_size int(11) NULL DEFAULT '2',file_type varchar(64) 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) NULL DEFAULT '1',use_comment int(1) NULL DEFAULT '1',PRIMARY KEY (id)";//_flagged$table_create[$_SESSION["dbprefix"]."_flagged"]="`fid` 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 NULL,`admin_nick` varchar(100) default 'Unknown',`reason` varchar(100) default NULL,`created` int(11) default NULL,`length` int(11) default NULL,`server_ip` varchar(100) default NULL,PRIMARY KEY (`fid`),KEY `player_id` (`player_id`)";?>Edytowany pod nowszą wersje MySQL plik tables.incSpoiler<?php/*AMXBans v6.0Copyright 2009, 2010 by SeToY & |PJ|ShOrTyThis file is part of AMXBans.AMXBans is free software, but it's licensed under theCreative Commons - Attribution-NonCommercial-ShareAlike 2.0AMXBans is distributed in the hope that it will be useful,but WITHOUT ANY WARRANTY; without even the implied warranty ofMERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.You should have received a copy of the cc-nC-SA along with AMXBans.If not, see <http://creativecommo...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,use_static_bantime enum('yes','no') NOT DEFAULT 'yes'";//_amxadmins$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$table_create[$_SESSION["dbprefix"]."_bans"]="bid int(11) auto_increment,player_ip varchar(32),player_id varchar(35),player_nick varchar(100) DEFAULT 'Unknown',admin_ip varchar(32),admin_id varchar(35) DEFAULT 'Unknown',admin_nick varchar(100) DEFAULT 'Unknown',ban_type varchar(10) 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) DEFAULT 'Unknown',ban_kicks int(11) NOT DEFAULT '0',expired int(1) NOT DEFAULT '0',imported int(1) NOT DEFAULT '0',PRIMARY KEY (bid),KEY player_id (player_id)";//_bans_edits$table_create[$_SESSION["dbprefix"]."_bans_edit"]="`id` int(11) NOT auto_increment,`bid` int(11) NOT,`edit_time` int(11) NOT,`admin_nick` varchar(32) NOT DEFAULT 'unknown',`edit_reason` varchar(255) NOT,PRIMARY KEY (`id`)";//_bbcode$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$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$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$table_create[$_SESSION["dbprefix"]."_levels"]="level int(12) auto_increment,bans_add enum('yes','no') DEFAULT 'no',bans_edit enum('yes','no','own') DEFAULT 'no',bans_delete enum('yes','no','own') DEFAULT 'no',bans_unban enum('yes','no','own') DEFAULT 'no',bans_import enum('yes','no') DEFAULT 'no',bans_export enum('yes','no') DEFAULT 'no',amxadmins_view enum('yes','no') DEFAULT 'no',amxadmins_edit enum('yes','no') DEFAULT 'no',webadmins_view enum('yes','no') DEFAULT 'no',webadmins_edit enum('yes','no') DEFAULT 'no',websettings_view enum('yes','no') DEFAULT 'no',websettings_edit enum('yes','no') DEFAULT 'no',permissions_edit enum('yes','no') DEFAULT 'no',prune_db enum('yes','no') DEFAULT 'no',servers_edit enum('yes','no') DEFAULT 'no',ip_view enum('yes','no') DEFAULT 'no',PRIMARY KEY (level)";//_logs$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$table_create[$_SESSION["dbprefix"]."_modulconfig"]="id int(11) auto_increment,menuname varchar(32),name varchar(32),`index` varchar(32),activ int(1) NOT DEFAULT '1',PRIMARY KEY (id)";//_reasons$table_create[$_SESSION["dbprefix"]."_reasons"]="id int(11) auto_increment,reason varchar(100),static_bantime int(11) NOT DEFAULT '0',PRIMARY KEY (id)";//_reasons_set$table_create[$_SESSION["dbprefix"]."_reasons_set"]="id int(11) auto_increment,setname varchar(32),PRIMARY KEY (id)";//_reasons_to_set$table_create[$_SESSION["dbprefix"]."_reasons_to_set"]="id int(11) auto_increment,setid int(11) NOT,reasonid int(11) NOT,PRIMARY KEY (id)";//_serverinfo$table_create[$_SESSION["dbprefix"]."_serverinfo"]="id int(11) auto_increment,timestamp int(11),hostname varchar(100) DEFAULT 'Unknown',address varchar(100),gametype varchar(32),rcon varchar(32),amxban_version varchar(32),amxban_motd varchar(250),motd_delay int(10) DEFAULT '10',amxban_menu int(10) NOT DEFAULT '1',reasons int(10),timezone_fixx int(11) NOT DEFAULT '0',PRIMARY KEY (id)";//_smilies$table_create[$_SESSION["dbprefix"]."_smilies"]="id int(5) auto_increment,code varchar(32),url varchar(32),name varchar(32),PRIMARY KEY (id)";//_usermenu$table_create[$_SESSION["dbprefix"]."_usermenu"]="id int(11) auto_increment,pos int(11),activ tinyint(1) NOT DEFAULT '1',lang_key varchar(64),url varchar(64),lang_key2 varchar(64),url2 varchar(64),PRIMARY KEY (id)";//_webadmins$table_create[$_SESSION["dbprefix"]."_webadmins"]="id int(12) auto_increment,username varchar(32),password varchar(32),level int(11) DEFAULT '99',logcode varchar(64),email varchar(64),last_action int(11),try int(1) NOT default '0',PRIMARY KEY (id),UNIQUE (username,email)";//_webconfig$table_create[$_SESSION["dbprefix"]."_webconfig"]="id int(11) auto_increment,cookie varchar(32),bans_per_page int(11),design varchar(32),banner varchar(64),banner_url varchar(128) NOT,default_lang varchar(32),start_page varchar(64),show_comment_count int(1) DEFAULT '1',show_demo_count int(1) DEFAULT '1',show_kick_count int(1) DEFAULT '1',demo_all int(1) NOT DEFAULT '0',comment_all int(1) NOT DEFAULT '0',use_capture int(1) DEFAULT '1',max_file_size int(11) DEFAULT '2',file_type varchar(64) DEFAULT 'dem,zip,rar,jpg,gif',auto_prune int(1) NOT DEFAULT '0',`max_offences` SMALLINT NOT DEFAULT '10',`max_offences_reason` VARCHAR( 128 ) NOT DEFAULT 'max offences reached',use_demo int(1) DEFAULT '1',use_comment int(1) DEFAULT '1',PRIMARY KEY (id)";//_flagged$table_create[$_SESSION["dbprefix"]."_flagged"]="`fid` int(11) NOT auto_increment,`player_ip` varchar(32) default,`player_id` varchar(35) default,`player_nick` varchar(100) default 'Unknown',`admin_ip` varchar(32) default,`admin_id` varchar(35) default,`admin_nick` varchar(100) default 'Unknown',`reason` varchar(100) default,`created` int(11) default,`length` int(11) default,`server_ip` varchar(100) default,PRIMARY KEY (`fid`),KEY `player_id` (`player_id`)";?>Zmiana polega na usunięciu w poszczególnych linijkach słowa "NULL" np.bid int(11) NULL auto_increment,po zmianiebid int(11) auto_increment,Dla porównania wyżej obie wersje
Cos tam lepiej ale nadal to nie dziala wiesz jak to ogarnac?
Załączone miniatury
-
-
PANDA_2zl
12.12.2019
maska1
Przed instalacją wyczyść baze danych z poprzednimi plikami ktore sie utworzyły, musisz mieć czystą baze do instalacji
