Wykonałem zapytanie,ale wydaje mi się że w instrukcji jakiegoś zapytania brak .Mam tylko w
ale nie można tam zaznaczyć zezwoleń pozatym nigdzie niema pola aby te zezwolenia dodać oczywiście mam na mysli
Kod: Zaznacz cały
INSERT INTO `phpbb_config` VALUES (0x66696c65626173655f616c6c6f77656473697a65, 0x34, 0);
INSERT INTO `phpbb_config` ( `config_name` , `config_value` , `is_dynamic` )
VALUES ('filebase_statistics', '1', '0');
INSERT INTO `phpbb_acl_options` (`auth_option_id`, `auth_option`, `is_global`, `is_local`, `founder_only`) VALUES (NULL, 0x755f766965775f66696c6562617365, 1, 0, 0);
INSERT INTO `phpbb_acl_options` (`auth_option_id`, `auth_option`, `is_global`, `is_local`, `founder_only`) VALUES (NULL, 0x755f6d616e6167655f66696c6562617365, 1, 0, 0);
INSERT INTO `phpbb_acl_options` (`auth_option_id`, `auth_option`, `is_global`, `is_local`, `founder_only`) VALUES (NULL, 0x755f75706c6f61645f66696c6562617365, 1, 0, 0);
CREATE TABLE `phpbb_filebase` (
`id` int(5) unsigned NOT NULL auto_increment,
`name` text character set utf8 collate utf8_unicode_ci NOT NULL,
`type` varchar(20) NOT NULL default '',
`size` bigint(15) NOT NULL default '0',
`downloads` int(5) NOT NULL default '0',
`cat` int(3) NOT NULL default '0',
`datum` timestamp NOT NULL default CURRENT_TIMESTAMP,
`fullname` varchar(100) NOT NULL default '',
`defekt` tinyint(1) NOT NULL default '0',
`ok` tinyint(1) NOT NULL default '0',
`uploader` varchar(50) NOT NULL default '',
`password` varchar(32) NOT NULL default '',
`approved` tinyint(1) NOT NULL default '1',
`server` int(3) NOT NULL default '1',
`abstractname` varchar(200) character set utf8 collate utf8_unicode_ci NOT NULL default '',
`maxprevnumber` int(4) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `phpbb_filebase_cats` (
`id` int(5) unsigned NOT NULL auto_increment,
`name` varchar(40) NOT NULL,
`text` text NOT NULL,
`what` int(1) NOT NULL,
`sup` int(5) NOT NULL,
`active` tinyint(1) NOT NULL default '1',
`ordered` INT( 3 ) NOT NULL,
PRIMARY KEY (`name`, `sup`),
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `phpbb_filebase_types` (
`id` int(5) unsigned NOT NULL auto_increment,
`type` varchar(10) NOT NULL,
`active` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`type`),
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `phpbb_filebase_uf` (
`id` int(3) unsigned NOT NULL auto_increment,
`name` varchar(100) collate utf8_unicode_ci NOT NULL,
`active` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`name`),
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
CREATE TABLE `phpbb_filebase_uf_data` (
`field_id` INT( 3 ) UNSIGNED NOT NULL ,
`file_id` INT( 5 ) UNSIGNED NOT NULL ,
`value` VARCHAR( 200 ) NOT NULL ,
PRIMARY KEY ( `field_id` , `file_id` )
) TYPE = MYISAM CHARACTER SET utf8 ;
CREATE TABLE `phpbb_filebase_comments` (
`id` INT( 6 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
`author` VARCHAR( 60 ) NOT NULL ,
`comment` TEXT NOT NULL ,
`time` INT( 40 ) NOT NULL ,
`file_id` INT( 5 ) NOT NULL ,
PRIMARY KEY ( `id` )
) TYPE = MYISAM CHARACTER SET utf8 ;
CREATE TABLE `phpbb_filebase_rating` (
`file_id` INT( 5 ) NOT NULL ,
`user_id` INT( 5 ) NOT NULL ,
`rating` INT( 1 ) NOT NULL ,
PRIMARY KEY ( `file_id` , `user_id` )
) TYPE = MYISAM CHARACTER SET utf8 ;
INSERT INTO `phpbb_config` (`config_name`, `config_value`, `is_dynamic`)
VALUES ('filebase_dateformat', '1', '0');
INSERT INTO `phpbb_config` (`config_name`, `config_value`, `is_dynamic`)
VALUES ('filebase_order', '1', '1');
INSERT INTO `phpbb_config` (`config_name`, `config_value`, `is_dynamic`)
VALUES ('filebase_update', '0', '1');
INSERT INTO `phpbb_config` (`config_name`, `config_value`, `is_dynamic`)
VALUES ('filebase_target', '1', 0);
INSERT INTO `phpbb_config` (`config_name`, `config_value`, `is_dynamic`)
VALUES ('filebase_password', '1', '1');
INSERT INTO `phpbb_config` (`config_name`, `config_value`, `is_dynamic`)
VALUES ('filebase_pagination', '5', '1');
CREATE TABLE `phpbb_filebase_quota` (
`id` mediumint(5) unsigned NOT NULL auto_increment,
`user_id` mediumint(8) NOT NULL,
`allowedsize` bigint(15) NOT NULL default '0',
`uploadedsize` bigint(15) NOT NULL default '0',
`allowedamount` mediumint(4) NOT NULL default '0',
`uploadedamount` mediumint(4) NOT NULL default '0',
`kind` tinyint(1) NOT NULL default '0',
`u_or_g` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`user_id`,`u_or_g`),
KEY `id` (`id`)
) ENGINE=MyISAM CHARACTER SET utf8 ;
CREATE TABLE `phpbb_filebase_server` (
`id` INT( 3 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`name` VARCHAR( 255 ) NOT NULL ,
`f_path` VARCHAR( 100 ) NOT NULL ,
`p_path` VARCHAR( 100 ) NOT NULL ,
`username` VARCHAR( 100 ) NOT NULL ,
`password` VARCHAR( 100 ) NOT NULL
) ENGINE = MYISAM CHARACTER SET utf8 ;
INSERT INTO `phpbb_filebase_server` (`id`, `name`, `f_path`, `p_path`, `username`, `password`) VALUES
(NULL, '', '', '', '', '');
DELETE FROM `phpbb_filebase_server`;
INSERT INTO `phpbb_acl_options` (`auth_option_id`, `auth_option`, `is_global`, `is_local`, `founder_only`) VALUES
(NULL, 'u_comment_filebase', 1, 0, 0),
(NULL, 'u_download_filebase', 1, 0, 0),
(NULL, 'u_password_filebase', 1, 0, 0);
INSERT INTO `phpbb_acl_options` (`auth_option_id` , `auth_option`, `is_global`, `is_local`, `founder_only`)
VALUES (NULL , 'u_approve_filebase', '1', '0', '0');
INSERT INTO `phpbb_acl_options` (`auth_option_id`, `auth_option`, `is_global`, `is_local`, `founder_only`) VALUES
(NULL, 'u_mcp_filebase', 1, 0, 0);
prefiks tabel.
Pozdrawiam.