Форум Donate Engine

Eriour

Пользователь

Ошибка при покупке привилегий

При покупке любой из привилегий, выдаёт такое: "3840 Unknown column 'default' in 'field list'"

Online

Administrator

Re: Ошибка при покупке привилегий

в таблице permissions_entity не хватает колонки default.

Eriour

Пользователь

Re: Ошибка при покупке привилегий

А с какими параметрами нужно добавлять эту колонку?

Online

Administrator

Re: Ошибка при покупке привилегий

DROP TABLE IF EXISTS permissions;
CREATE TABLE permissions (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `type` tinyint(1) NOT NULL,
  `permission` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `world` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `value` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique` (`name`,`permission`,`world`,`type`),
  KEY `user` (`name`,`type`),
  KEY `world` (`world`,`name`,`type`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

DROP TABLE IF EXISTS permissions_entity;
CREATE TABLE permissions_entity (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `type` tinyint(1) NOT NULL,
  `prefix` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `suffix` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `default` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`),
  KEY `default` (`default`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

DROP TABLE IF EXISTS permissions_inheritance;
CREATE TABLE permissions_inheritance (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `child` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `parent` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `type` tinyint(1) NOT NULL,
  `world` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `child` (`child`,`parent`,`type`,`world`),
  KEY `child_2` (`child`,`type`),
  KEY `parent` (`parent`,`type`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO permissions VALUES(1, 'default', 0, 'modifyworld.*', '', '');
INSERT INTO permissions VALUES(6, 'default', 0, 'commandbook.spawn', '', '');
INSERT INTO permissions VALUES(26, 'default', 0, 'iConomy.payment', '', '');
INSERT INTO permissions VALUES(49, 'Admin', 0, '*', '', '');
INSERT INTO permissions VALUES(12, 'default', 0, 'iConomy.access', '', '');
INSERT INTO permissions VALUES(25, 'default', 0, 'iConomy.list', '', '');
INSERT INTO permissions VALUES(41, 'default', 0, 'myhome.home.basic.delete', '', '');
INSERT INTO permissions VALUES(23, 'default', 0, 'iConomy.admin.stats', '', '');
INSERT INTO permissions VALUES(39, 'default', 0, 'myhome.home.basic.home', '', '');
INSERT INTO permissions VALUES(40, 'default', 0, 'myhome.home.basic.set', '', '');
INSERT INTO permissions VALUES(27, 'default', 0, 'commandbook.who', '', '');
INSERT INTO permissions VALUES(28, 'default', 0, 'lwc.protect', '', '');
INSERT INTO permissions VALUES(29, 'default', 0, 'worldguard.region.remove.own.*', '', '');
INSERT INTO permissions VALUES(30, 'default', 0, 'worldguard.region.removemember.own.*', '', '');
INSERT INTO permissions VALUES(31, 'default', 0, 'worldguard.region.addmember.own.*', '', '');
INSERT INTO permissions VALUES(32, 'default', 0, 'worldguard.region.claim', '', '');
INSERT INTO permissions VALUES(33, 'default', 0, 'worldguard.heal', '', '');
INSERT INTO permissions VALUES(34, 'default', 0, 'worldedit.selection.pos', '', '');
INSERT INTO permissions VALUES(35, 'default', 0, 'worldedit.selection.hpos', '', '');
INSERT INTO permissions VALUES(36, 'default', 0, 'worldedit.wand', '', '');
INSERT INTO permissions VALUES(37, 'default', 0, 'worldedit.selection.expand', '', '');
INSERT INTO permissions VALUES(65, 'VIP', 0, 'scavenger.scavenge', '', '');
INSERT INTO permissions VALUES(61, 'VIP', 0, 'group-default-until', '', '');
INSERT INTO permissions VALUES(64, 'VIP', 0, 'flight.off', '', '');
INSERT INTO permissions VALUES(63, 'VIP', 0, 'flight.on', '', '');
INSERT INTO permissions VALUES(66, 'VIP', 0, 'scavenger.level', '', '');
INSERT INTO permissions VALUES(67, 'VIP', 0, 'scavenger.exp', '', '');
INSERT INTO permissions VALUES(69, 'VIP', 0, 'commandbook.spawn', '', '');
INSERT INTO permissions VALUES(70, 'VIP', 0, 'iConomy.payment', '', '');
INSERT INTO permissions VALUES(71, 'VIP', 0, 'iConomy.access', '', '');
INSERT INTO permissions VALUES(72, 'VIP', 0, 'iConomy.list', '', '');
INSERT INTO permissions VALUES(73, 'VIP', 0, 'myhome.home.basic.delete', '', '');
INSERT INTO permissions VALUES(74, 'VIP', 0, 'iConomy.admin.stats', '', '');
INSERT INTO permissions VALUES(75, 'VIP', 0, 'myhome.home.basic.home', '', '');
INSERT INTO permissions VALUES(76, 'VIP', 0, 'myhome.home.basic.set', '', '');
INSERT INTO permissions VALUES(77, 'VIP', 0, 'commandbook.who', '', '');
INSERT INTO permissions VALUES(78, 'VIP', 0, 'lwc.protect', '', '');
INSERT INTO permissions VALUES(79, 'VIP', 0, 'worldguard.region.remove.own.*', '', '');
INSERT INTO permissions VALUES(80, 'VIP', 0, 'worldguard.region.removemember.own.*', '', '');
INSERT INTO permissions VALUES(81, 'VIP', 0, 'worldguard.region.addmember.own.*', '', '');
INSERT INTO permissions VALUES(82, 'VIP', 0, 'worldguard.region.claim', '', '');
INSERT INTO permissions VALUES(83, 'VIP', 0, 'worldguard.heal', '', '');
INSERT INTO permissions VALUES(84, 'VIP', 0, 'worldedit.selection.pos', '', '');
INSERT INTO permissions VALUES(85, 'VIP', 0, 'worldedit.selection.hpos', '', '');
INSERT INTO permissions VALUES(86, 'VIP', 0, 'worldedit.wand', '', '');
INSERT INTO permissions VALUES(87, 'VIP', 0, 'worldedit.selection.expand', '', '');
INSERT INTO permissions VALUES(88, 'VIP', 0, 'commandbook.kit.kits.Vip', '', '');
INSERT INTO permissions VALUES(160, 'Online', 0, 'group-GlAdmin-until', '*', '1361184096');
INSERT INTO permissions VALUES(161, 'Online', 0, 'group-Moderator-until', '*', '1363791150');

INSERT INTO permissions_entity VALUES(1, 'default', 0, '&8', '&f', 1);
INSERT INTO permissions_entity VALUES(2, 'Admin', 0, '&c[Admin]&a', '&f', 0);
INSERT INTO permissions_entity VALUES(4, 'VIP', 0, '&c[VIP]&a', '&f', 0);
INSERT INTO permissions_entity VALUES(22, 'Moderator', 0, '&c[Moderator]&a', '&f', 0);
INSERT INTO permissions_entity VALUES(34, 'GlAdmin', 0, '[&cGlAdmin&f]&f', '&c', 0);

INSERT INTO permissions_inheritance VALUES(2, 'Vnlexa', 'Admin', 1, NULL);
INSERT INTO permissions_inheritance VALUES(7, 'Boomm', 'VIP', 1, NULL);
INSERT INTO permissions_inheritance VALUES(9, 'putin29', 'VIP', 1, NULL);
INSERT INTO permissions_inheritance VALUES(10, 'vovanik', 'Admin', 1, NULL);
INSERT INTO permissions_inheritance VALUES(12, 'spawn1', 'VIP', 1, NULL);
INSERT INTO permissions_inheritance VALUES(13, 'TheMaestro', 'Moderator', 1, NULL);
INSERT INTO permissions_inheritance VALUES(89, 'Online', 'GlAdmin', 1, NULL);
INSERT INTO permissions_inheritance VALUES(90, 'Online', 'Moderator', 1, NULL);