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