rights.txt

来自「一个C语言的聊天室源代码」· 文本 代码 · 共 54 行

#usage mysql -u socketchat -psocketchat socketchat < rights.txt
CREATE TABLE rights (
	cmd char(40) default '' not null,
	level15 enum('Y','N') default 'N' not null,
	level14 enum('Y','N') default 'N' not null,
	level13 enum('Y','N') default 'N' not null,
	level12 enum('Y','N') default 'N' not null,
	level11 enum('Y','N') default 'N' not null,
	level10 enum('Y','N') default 'N' not null,
	level09 enum('Y','N') default 'N' not null,
	level08 enum('Y','N') default 'N' not null,
	level07 enum('Y','N') default 'N' not null,
	level06 enum('Y','N') default 'N' not null,
	level05 enum('Y','N') default 'N' not null,
	level04 enum('Y','N') default 'N' not null,
	level03 enum('Y','N') default 'N' not null,
	level02 enum('Y','N') default 'N' not null,
	level01 enum('Y','N') default 'N' not null,
	level00 enum('Y','N') default 'N' not null,

	PRIMARY KEY (cmd)
	);

# admin cmd
insert into rights (level15,level14,level13,level12,level11,cmd) values ("Y","Y","Y","Y","N","");
insert into rights (level15,level14,level13,level12,level11,cmd) values ("Y","Y","Y","Y","Y","ip");
insert into rights (level15,level14,level13,level12,level11,cmd) values ("Y","Y","Y","Y","Y","kickip");
insert into rights (level15,level14,level13,level12,level11,cmd) values ("Y","Y","Y","Y","Y","kicklist");
insert into rights (level15,level14,level13,level12,level11,cmd) values ("Y","Y","Y","Y","Y","kick");
insert into rights (level15,level14,level13,level12,level11,cmd) values ("Y","Y","N","N","N","unkick");
insert into rights (level15,level14,level13,level12,level11,cmd) values ("Y","Y","Y","Y","Y","filterlist");
insert into rights (level15,level14,level13,level12,level11,cmd) values ("Y","Y","Y","Y","Y","filter");
insert into rights (level15,level14,level13,level12,level11,cmd) values ("Y","Y","Y","Y","Y","modlist");
insert into rights (level15,level14,level13,level12,level11,cmd) values ("Y","Y","Y","Y","Y","adminlist");
insert into rights (level15,level14,level13,level12,level11,cmd) values ("Y","Y","Y","Y","Y","unfilter");
insert into rights (level15,level14,level13,level12,level11,cmd) values ("Y","Y","Y","Y","N","msg");
insert into rights (level15,level14,level13,level12,level11,cmd) values ("Y","Y","N","N","N","grant");
insert into rights (level15,level14,level13,level12,level11,cmd) values ("Y","Y","N","N","N","revoke");
insert into rights (level15,level14,level13,level12,level11,cmd) values ("Y","Y","N","N","N","hidden");
insert into rights (level15,level14,level13,level12,level11,cmd) values ("Y","Y","N","N","N","appear");
insert into rights (level15,level14,level13,level12,level11,cmd) values ("Y","Y","N","N","N","kill");
insert into rights (level15,level14,level13,level12,level11,cmd) values ("Y","N","N","N","N","bcast");
insert into rights (level15,level14,level13,level12,level11,cmd) values ("Y","N","N","N","N","seeall");
insert into rights (level15,level14,level13,level12,level11,cmd) values ("Y","N","N","N","N","hereall");

# user cmd
insert into rights (level15,level14,level13,level12,level11,level10,level09,level08,level07,level06,level05,level04,level03,level02,level01,level00,cmd) values ("Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","del");
insert into rights (level15,level14,level13,level12,level11,level10,level09,level08,level07,level06,level05,level04,level03,level02,level01,level00,cmd) values ("Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","add");
insert into rights (level15,level14,level13,level12,level11,level10,level09,level08,level07,level06,level05,level04,level03,level02,level01,level00,cmd) values ("Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","list");
insert into rights (level15,level14,level13,level12,level11,level10,level09,level08,level07,level06,level05,level04,level03,level02,level01,level00,cmd) values ("Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","status");
insert into rights (level15,level14,level13,level12,level11,level10,level09,level08,level07,level06,level05,level04,level03,level02,level01,level00,cmd) values ("Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","N","alert");
insert into rights (level15,level14,level13,level12,level11,level10,level09,level08,level07,level06,level05,level04,level03,level02,level01,level00,cmd) values ("Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","N","music");
insert into rights (level15,level14,level13,level12,level11,level10,level09,level08,level07,level06,level05,level04,level03,level02,level01,level00,cmd) values ("Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","roomid");