Baza Danych

[boomx]

Witam mam Problem mam w Bazie Danych (PHPMYADMIN) Groups-
1.Player
2.Gamemaster
3.GoD
Jak Dodac Tutora i Senior Tutora? Help! Potrzebne do tego sa jakies "Flagi"

 

[sputerkarol]

Odp: Baza Danych

Wpisz w bazie danych w sql :

CREATE TABLE IF NOT EXISTS `groups` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL COMMENT 'group name',
  `flags` bigint(20) unsigned NOT NULL default '0',
  `customflags` bigint(20) unsigned NOT NULL default '0',
  `access` int(11) NOT NULL,
  `violationaccess` int(11) NOT NULL,
  `maxdepotitems` int(11) NOT NULL,
  `maxviplist` int(11) NOT NULL,
  `outfit` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

a nast?pnie :

INSERT INTO `groups` (`id`, `name`, `flags`, `customflags`, `access`, `violationaccess`, `maxdepotitems`, `maxviplist`, `outfit`) VALUES
(1, 'Player', 0, 0, 0, 0, 0, 0, 0),
(2, 'Tutor', 16809984, 524291, 1, 0, 0, 0, 0),
(3, 'Senior Tutor', 68736352256, 524303, 2, 1, 0, 0, 0),
(4, 'Gamemaster', 510024081247, 4189375, 3, 3, 4000, 200, 75),
(5, 'Community Manager', 542239465466, 4189695, 4, 4, 6000, 300, 302),
(6, 'God', 546534563834, 4194303, 5, 4, 8000, 400, 266),
(7, 'VIP', 510024081247, 4189375, 3, 2, 5000, 250, 75),
(8, 'Senior Gamemasters', 542239465466, 4189695, 3, 3, 4500, 225, 75);

Powinno pom?c.