Wykryto wyłączony javascript

Aktualnie masz wyłączony javascript. Kilka funkcji może nie działać. Włącz ponownie javascript, aby korzystać z pełnej funkcjonalności.

Witamy w Nieoficjalnym polskim support'cie AMX Mod X

Witamy w Nieoficjalnym polskim support'cie AMX Mod X, jak w większości społeczności internetowych musisz się zarejestrować aby móc odpowiadać lub zakładać nowe tematy, ale nie bój się to jest prosty proces w którym wymagamy minimalnych informacji.

Rozpoczynaj nowe tematy i odpowiedaj na inne
Zapisz się do tematów i for, aby otrzymywać automatyczne uaktualnienia
Dodawaj wydarzenia do kalendarza społecznościowego
Stwórz swój własny profil i zdobywaj nowych znajomych
Zdobywaj nowe doświadczenia

Guest Message by DevFuse

GmAMXBans

Problem z tworzeniem tabel w php podczas instalacji

Temat rozp. PANDA_2zl, 29.11.2019 14:39

gmamxbans

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

Edytowany pod nowszą wersje MySQL plik tables.inc

Spoiler

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

Przejdź do postu

Nie możesz napisać tematu
Zaloguj się, aby dodać odpowiedź

6 odpowiedzi w tym temacie

#1 PANDA_2zl

Guru

Power User

Reputacja: 174

Profesjonalista

Postów:722
Imię:Michał
Lokalizacja:Kraków

Offline

Napisano 29.11.2019 14:39

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

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

Do góry

#2 DarkGL

Nie oddam ciasteczka !

Administrator

Reputacja: 6 555

Godlike

Postów:11 980
GG:
Steam:
Imię:Rafał
Lokalizacja:Warszawa

Online

Napisano 29.11.2019 19:14

Wersja mysql na serwerze ?

DarkGL Blog - Programowanie Python , Pawn , C++ i Webdeveloping

Kontakt https://darkgl.pl/kontakt/

Do góry

#3 PANDA_2zl

Guru

Autor tematu
Power User

Reputacja: 174

Profesjonalista

Postów:722
Imię:Michał
Lokalizacja:Kraków

Offline

Napisano 29.11.2019 19:26

PHP Version

5.2.17 MySQL Version

5.7.27

Do góry

#4 PANDA_2zl

Guru

Autor tematu
Power User

Reputacja: 174

Profesjonalista

Postów:722
Imię:Michał
Lokalizacja:Kraków

Offline

Napisano 02.12.2019 21:34 Najlepsza odpowiedź

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

Edytowany pod nowszą wersje MySQL plik tables.inc

Spoiler

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

Do góry

#5 maska1

Życzliwy

Użytkownik

Reputacja: 4

Nowy

Postów:29
Imię:mateusz
Lokalizacja:tychy

Offline

Napisano 10.12.2019 11:20

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

Cos tam lepiej ale nadal to nie dziala wiesz jak to ogarnac?

Do góry

#6 maska1

Życzliwy

Użytkownik

Reputacja: 4

Nowy

Postów:29
Imię:mateusz
Lokalizacja:tychy

Offline

Napisano 10.12.2019 11:20

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

Cos tam lepiej ale nadal to nie dziala wiesz jak to ogarnac?

Załączone miniatury

Do góry

#7 PANDA_2zl

Guru

Autor tematu
Power User

Reputacja: 174

Profesjonalista

Postów:722
Imię:Michał
Lokalizacja:Kraków

Offline

Napisano 12.12.2019 18:39

maska1

Przed instalacją wyczyść baze danych z poprzednimi plikami ktore sie utworzyły, musisz mieć czystą baze do instalacji

Do góry

Wróć do Problemy

Również z jednym lub większą ilością słów kluczowych: gmamxbans

GmAMXBans [KOSZ] cheater Napisany przez Anonimowy09, 29.03.2024 gmamxbans	2 odpowiedzi 268 Odwiedzin	dasiek 02.04.2024
GmAMXBans Pytanie zwiazne z automatycznym banowaniem graczy przez serwer Napisany przez LuxiStudioPL, 02.03.2024 gmamxbans	3 odpowiedzi 306 Odwiedzin	Anonymuss 03.03.2024
GmAMXBans Problem z łączeniem Napisany przez Mareczek Powrócił, 02.03.2024 gmamxbans	0 odpowiedzi 251 Odwiedzin	Mareczek Powrócił 02.03.2024
GmAMXBans [KOSZ] Problem Napisany przez LuxiStudioPL, 31.01.2024 gmamxbans	1 odpowiedź 406 Odwiedzin	dasiek 01.02.2024
GmAMXBans Powód "Wstaw" przy zrobieniu SS'ów Napisany przez Upoś, 21.01.2024 gmamxbans	4 odpowiedzi 354 Odwiedzin	PANDA_2zl 26.01.2024

Użytkownicy przeglądający ten temat: 0

0 użytkowników, 0 gości, 0 anonimowych

Coinsy CSGOPolygon Za SMS, PSC , Przelew - CoinSell.pro
Skiny do CS:GO za SMS, PSC, Przelew - CSGOPaka.com
Automatyczny Bot Levelowania Steam - LVLUPSteam.com
CSGO Gambling Sites and Free Betting Codes - DreamCodes.gg

Kod LaTeX

Witamy w Nieoficjalnym polskim support'cie AMX Mod X

Problem z tworzeniem tabel w php podczas instalacji

Załączone miniatury

Również z jednym lub większą ilością słów kluczowych: gmamxbans

Użytkownicy przeglądający ten temat: 0

Logowanie