CREATE TABLE `randtext` (
`nrid` int(8) unsigned NOT NULL default 0,
`type` tinyint(3) unsigned NOT NULL default 0,
`id` mediumint(8) unsigned NOT NULL default 0,
`chan` varchar(32) default NULL,
`data` text default NULL,
PRIMARY KEY (`nrid`, `type`, `id`, `chan`)
) TYPE=MyISAM;
Chan field won't be always used. and in some cases possibly not data. esp for autojoin.
Meanwhile we need to start registering types. I'm thinking we use RTF for the prefix.
- NTF_QUIT 1
- takes place of nickreg.quit
- NTF_GREET 2
- NTF_JOIN 3
- AutoJoin list
- NTF_AUTH 4
- to make NS AUTH work
- NTF_MODE 5
- set certain umodes, unset certain others, upon identify
- Obv needs to be restricted in which umodes can be set.
- NTF_VACATION 6
- Track last usage of VACATION mode
- NTF_EMAIL_VALIDATE 7
- for validating nickreg.email
