X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=database%2Froles.sql;h=7cfa563293681682cec1d4e15010382567798b45;hb=bab20f6b99ddd4d7bdcab215ae75386c5bd40564;hp=4e1fa63764408571fa32c897a0e5956397d8629c;hpb=5e02deb33fbdb994d72da23e8de85e633ec6654c;p=NDIRC.git

diff --git a/database/roles.sql b/database/roles.sql
index 4e1fa63..7cfa563 100644
--- a/database/roles.sql
+++ b/database/roles.sql
@@ -32,107 +32,149 @@ INSERT INTO roles VALUES('irc_anondef');
 INSERT INTO roles VALUES('irc_defcall');
 INSERT INTO roles VALUES('irc_settype');
 INSERT INTO roles VALUES('irc_calltake');
+INSERT INTO roles VALUES('irc_setcalc');
+INSERT INTO roles VALUES('irc_getcalc');
+INSERT INTO roles VALUES('irc_sendsms');
+INSERT INTO roles VALUES('irc_smsstatus');
+INSERT INTO roles VALUES('irc_forum_others');
+INSERT INTO roles VALUES('irc_newtag');
+INSERT INTO roles VALUES('irc_addtag');
+INSERT INTO roles VALUES('irc_deltag');
+INSERT INTO roles VALUES('irc_say');
+INSERT INTO roles VALUES('irc_cmd');
 
-INSERT INTO group_roles (gid,role) VALUES(1,'irc_p_nick');
-INSERT INTO group_roles (gid,role) VALUES(1,'irc_p_intel');
-INSERT INTO group_roles (gid,role) VALUES(1,'irc_masterop');
-INSERT INTO group_roles (gid,role) VALUES(1,'irc_masterinvite');
-INSERT INTO group_roles (gid,role) VALUES(1,'irc_scanreqs');
-INSERT INTO group_roles (gid,role) VALUES(1,'irc_anonscan');
-INSERT INTO group_roles (gid,role) VALUES(1,'irc_delquote');
-INSERT INTO group_roles (gid,role) VALUES(1,'irc_points_others');
-INSERT INTO group_roles (gid,role) VALUES(1,'irc_sms');
-INSERT INTO group_roles (gid,role) VALUES(1,'irc_adduser');
-INSERT INTO group_roles (gid,role) VALUES(1,'irc_deactivateuser');
-INSERT INTO group_roles (gid,role) VALUES(1,'irc_chattr');
-INSERT INTO group_roles (gid,role) VALUES(1,'irc_whois');
-INSERT INTO group_roles (gid,role) VALUES(1,'irc_flag');
-INSERT INTO group_roles (gid,role) VALUES(1,'irc_laston');
-INSERT INTO group_roles (gid,role) VALUES(1,'irc_lastseen');
-INSERT INTO group_roles (gid,role) VALUES(1,'irc_getships');
-INSERT INTO group_roles (gid,role) VALUES(1,'irc_getfleet');
-INSERT INTO group_roles (gid,role) VALUES(1,'irc_sethost');
-INSERT INTO group_roles (gid,role) VALUES(1,'irc_setpnick');
-INSERT INTO group_roles (gid,role) VALUES(1,'irc_a');
-INSERT INTO group_roles (gid,role) VALUES(1,'irc_d');
-INSERT INTO group_roles (gid,role) VALUES(1,'irc_s');
-INSERT INTO group_roles (gid,role) VALUES(1,'irc_h');
-INSERT INTO group_roles (gid,role) VALUES(1,'irc_sethostile');
-INSERT INTO group_roles (gid,role) VALUES(1,'irc_setnick');
-INSERT INTO group_roles (gid,role) VALUES(1,'irc_setally');
-INSERT INTO group_roles (gid,role) VALUES(1,'irc_setchannel');
-INSERT INTO group_roles (gid,role) VALUES(1,'irc_anondef');
-INSERT INTO group_roles (gid,role) VALUES(1,'irc_defcall');
-INSERT INTO group_roles (gid,role) VALUES(1,'irc_settype');
-INSERT INTO group_roles (gid,role) VALUES(1,'irc_calltake');
+INSERT INTO group_roles (gid,role) VALUES('T','irc_p_nick');
+INSERT INTO group_roles (gid,role) VALUES('T','irc_p_intel');
+INSERT INTO group_roles (gid,role) VALUES('T','irc_masterop');
+INSERT INTO group_roles (gid,role) VALUES('T','irc_masterinvite');
+INSERT INTO group_roles (gid,role) VALUES('T','irc_scanreqs');
+INSERT INTO group_roles (gid,role) VALUES('T','irc_anonscan');
+INSERT INTO group_roles (gid,role) VALUES('T','irc_delquote');
+INSERT INTO group_roles (gid,role) VALUES('T','irc_points_others');
+INSERT INTO group_roles (gid,role) VALUES('T','irc_sms');
+INSERT INTO group_roles (gid,role) VALUES('T','irc_adduser');
+INSERT INTO group_roles (gid,role) VALUES('T','irc_deactivateuser');
+INSERT INTO group_roles (gid,role) VALUES('T','irc_chattr');
+INSERT INTO group_roles (gid,role) VALUES('T','irc_whois');
+INSERT INTO group_roles (gid,role) VALUES('T','irc_flag');
+INSERT INTO group_roles (gid,role) VALUES('T','irc_laston');
+INSERT INTO group_roles (gid,role) VALUES('T','irc_lastseen');
+INSERT INTO group_roles (gid,role) VALUES('T','irc_getships');
+INSERT INTO group_roles (gid,role) VALUES('T','irc_getfleet');
+INSERT INTO group_roles (gid,role) VALUES('T','irc_sethost');
+INSERT INTO group_roles (gid,role) VALUES('T','irc_setpnick');
+INSERT INTO group_roles (gid,role) VALUES('T','irc_a');
+INSERT INTO group_roles (gid,role) VALUES('T','irc_d');
+INSERT INTO group_roles (gid,role) VALUES('T','irc_s');
+INSERT INTO group_roles (gid,role) VALUES('T','irc_h');
+INSERT INTO group_roles (gid,role) VALUES('T','irc_sethostile');
+INSERT INTO group_roles (gid,role) VALUES('T','irc_setnick');
+INSERT INTO group_roles (gid,role) VALUES('T','irc_setally');
+INSERT INTO group_roles (gid,role) VALUES('T','irc_setchannel');
+INSERT INTO group_roles (gid,role) VALUES('T','irc_anondef');
+INSERT INTO group_roles (gid,role) VALUES('T','irc_defcall');
+INSERT INTO group_roles (gid,role) VALUES('T','irc_settype');
+INSERT INTO group_roles (gid,role) VALUES('T','irc_calltake');
+INSERT INTO group_roles (gid,role) VALUES('T','irc_setcalc');
+INSERT INTO group_roles (gid,role) VALUES('T','irc_getcalc');
+INSERT INTO group_roles (gid,role) VALUES('T','irc_sendsms');
+INSERT INTO group_roles (gid,role) VALUES('T','irc_smsstatus');
+INSERT INTO group_roles (gid,role) VALUES('T','irc_forum_others');
+INSERT INTO group_roles (gid,role) VALUES('T','irc_say');
+INSERT INTO group_roles (gid,role) VALUES('T','irc_cmd');
 
-INSERT INTO group_roles (gid,role) VALUES(2,'irc_gs');
-INSERT INTO group_roles (gid,role) VALUES(2,'irc_scan');
+INSERT INTO group_roles (gid,role) VALUES('M','irc_gs');
+INSERT INTO group_roles (gid,role) VALUES('M','irc_scan');
+INSERT INTO group_roles (gid,role) VALUES('M','irc_newtag');
+INSERT INTO group_roles (gid,role) VALUES('M','irc_addtag');
+INSERT INTO group_roles (gid,role) VALUES('M','irc_deltag');
 
-INSERT INTO group_roles (gid,role) VALUES(3,'irc_p_nick');
-INSERT INTO group_roles (gid,role) VALUES(3,'irc_masterop');
-INSERT INTO group_roles (gid,role) VALUES(3,'irc_masterinvite');
-INSERT INTO group_roles (gid,role) VALUES(3,'irc_scanreqs');
-INSERT INTO group_roles (gid,role) VALUES(3,'irc_anonscan');
-INSERT INTO group_roles (gid,role) VALUES(3,'irc_delquote');
-INSERT INTO group_roles (gid,role) VALUES(3,'irc_points_others');
-INSERT INTO group_roles (gid,role) VALUES(3,'irc_sms');
-INSERT INTO group_roles (gid,role) VALUES(3,'irc_adduser');
-INSERT INTO group_roles (gid,role) VALUES(3,'irc_deactivateuser');
-INSERT INTO group_roles (gid,role) VALUES(3,'irc_chattr');
-INSERT INTO group_roles (gid,role) VALUES(3,'irc_whois');
-INSERT INTO group_roles (gid,role) VALUES(3,'irc_flag');
-INSERT INTO group_roles (gid,role) VALUES(3,'irc_laston');
-INSERT INTO group_roles (gid,role) VALUES(3,'irc_lastseen');
-INSERT INTO group_roles (gid,role) VALUES(3,'irc_getships');
-INSERT INTO group_roles (gid,role) VALUES(3,'irc_getfleet');
-INSERT INTO group_roles (gid,role) VALUES(3,'irc_sethost');
-INSERT INTO group_roles (gid,role) VALUES(3,'irc_setpnick');
-INSERT INTO group_roles (gid,role) VALUES(3,'irc_a');
-INSERT INTO group_roles (gid,role) VALUES(3,'irc_d');
-INSERT INTO group_roles (gid,role) VALUES(3,'irc_s');
-INSERT INTO group_roles (gid,role) VALUES(3,'irc_h');
-INSERT INTO group_roles (gid,role) VALUES(3,'irc_sethostile');
-INSERT INTO group_roles (gid,role) VALUES(3,'irc_setnick');
-INSERT INTO group_roles (gid,role) VALUES(3,'irc_setally');
-INSERT INTO group_roles (gid,role) VALUES(3,'irc_setchannel');
-INSERT INTO group_roles (gid,role) VALUES(3,'irc_anondef');
-INSERT INTO group_roles (gid,role) VALUES(3,'irc_defcall');
-INSERT INTO group_roles (gid,role) VALUES(3,'irc_settype');
-INSERT INTO group_roles (gid,role) VALUES(3,'irc_calltake');
+INSERT INTO group_roles (gid,role) VALUES('H','irc_p_nick');
+INSERT INTO group_roles (gid,role) VALUES('H','irc_masterop');
+INSERT INTO group_roles (gid,role) VALUES('H','irc_masterinvite');
+INSERT INTO group_roles (gid,role) VALUES('H','irc_scanreqs');
+INSERT INTO group_roles (gid,role) VALUES('H','irc_anonscan');
+INSERT INTO group_roles (gid,role) VALUES('H','irc_delquote');
+INSERT INTO group_roles (gid,role) VALUES('H','irc_points_others');
+INSERT INTO group_roles (gid,role) VALUES('H','irc_sms');
+INSERT INTO group_roles (gid,role) VALUES('H','irc_adduser');
+INSERT INTO group_roles (gid,role) VALUES('H','irc_deactivateuser');
+INSERT INTO group_roles (gid,role) VALUES('H','irc_chattr');
+INSERT INTO group_roles (gid,role) VALUES('H','irc_whois');
+INSERT INTO group_roles (gid,role) VALUES('H','irc_flag');
+INSERT INTO group_roles (gid,role) VALUES('H','irc_laston');
+INSERT INTO group_roles (gid,role) VALUES('H','irc_lastseen');
+INSERT INTO group_roles (gid,role) VALUES('H','irc_getships');
+INSERT INTO group_roles (gid,role) VALUES('H','irc_getfleet');
+INSERT INTO group_roles (gid,role) VALUES('H','irc_sethost');
+INSERT INTO group_roles (gid,role) VALUES('H','irc_setpnick');
+INSERT INTO group_roles (gid,role) VALUES('H','irc_a');
+INSERT INTO group_roles (gid,role) VALUES('H','irc_d');
+INSERT INTO group_roles (gid,role) VALUES('H','irc_s');
+INSERT INTO group_roles (gid,role) VALUES('H','irc_h');
+INSERT INTO group_roles (gid,role) VALUES('H','irc_sethostile');
+INSERT INTO group_roles (gid,role) VALUES('H','irc_setnick');
+INSERT INTO group_roles (gid,role) VALUES('H','irc_setally');
+INSERT INTO group_roles (gid,role) VALUES('H','irc_setchannel');
+INSERT INTO group_roles (gid,role) VALUES('H','irc_anondef');
+INSERT INTO group_roles (gid,role) VALUES('H','irc_defcall');
+INSERT INTO group_roles (gid,role) VALUES('H','irc_settype');
+INSERT INTO group_roles (gid,role) VALUES('H','irc_calltake');
+INSERT INTO group_roles (gid,role) VALUES('H','irc_setcalc');
+INSERT INTO group_roles (gid,role) VALUES('H','irc_getcalc');
+INSERT INTO group_roles (gid,role) VALUES('H','irc_sendsms');
+INSERT INTO group_roles (gid,role) VALUES('H','irc_smsstatus');
+INSERT INTO group_roles (gid,role) VALUES('H','irc_forum_others');
 
-INSERT INTO group_roles (gid,role) VALUES(4,'irc_points_others');
-INSERT INTO group_roles (gid,role) VALUES(4,'irc_a');
+INSERT INTO group_roles (gid,role) VALUES('B','irc_points_others');
+INSERT INTO group_roles (gid,role) VALUES('B','irc_a');
 
-INSERT INTO group_roles (gid,role) VALUES(5,'irc_p_nick');
-INSERT INTO group_roles (gid,role) VALUES(5,'irc_p_intel');
-INSERT INTO group_roles (gid,role) VALUES(5,'irc_sethostile');
-INSERT INTO group_roles (gid,role) VALUES(5,'irc_setnick');
-INSERT INTO group_roles (gid,role) VALUES(5,'irc_setally');
-INSERT INTO group_roles (gid,role) VALUES(5,'irc_setchannel');
+INSERT INTO group_roles (gid,role) VALUES('I','irc_p_nick');
+INSERT INTO group_roles (gid,role) VALUES('I','irc_p_intel');
+INSERT INTO group_roles (gid,role) VALUES('I','irc_sethostile');
+INSERT INTO group_roles (gid,role) VALUES('I','irc_setnick');
+INSERT INTO group_roles (gid,role) VALUES('I','irc_setally');
+INSERT INTO group_roles (gid,role) VALUES('I','irc_setchannel');
 
-INSERT INTO group_roles (gid,role) VALUES(6,'irc_p_intel');
-INSERT INTO group_roles (gid,role) VALUES(6,'irc_points_others');
-INSERT INTO group_roles (gid,role) VALUES(6,'irc_sms');
-INSERT INTO group_roles (gid,role) VALUES(6,'irc_getships');
-INSERT INTO group_roles (gid,role) VALUES(6,'irc_getfleet');
-INSERT INTO group_roles (gid,role) VALUES(6,'irc_d');
-INSERT INTO group_roles (gid,role) VALUES(6,'irc_sethostile');
-INSERT INTO group_roles (gid,role) VALUES(6,'irc_anondef');
-INSERT INTO group_roles (gid,role) VALUES(6,'irc_defcall');
-INSERT INTO group_roles (gid,role) VALUES(6,'irc_settype');
-INSERT INTO group_roles (gid,role) VALUES(6,'irc_calltake');
+INSERT INTO group_roles (gid,role) VALUES('D','irc_p_intel');
+INSERT INTO group_roles (gid,role) VALUES('D','irc_points_others');
+INSERT INTO group_roles (gid,role) VALUES('D','irc_sms');
+INSERT INTO group_roles (gid,role) VALUES('D','irc_getships');
+INSERT INTO group_roles (gid,role) VALUES('D','irc_getfleet');
+INSERT INTO group_roles (gid,role) VALUES('D','irc_d');
+INSERT INTO group_roles (gid,role) VALUES('D','irc_sethostile');
+INSERT INTO group_roles (gid,role) VALUES('D','irc_anondef');
+INSERT INTO group_roles (gid,role) VALUES('D','irc_defcall');
+INSERT INTO group_roles (gid,role) VALUES('D','irc_settype');
+INSERT INTO group_roles (gid,role) VALUES('D','irc_calltake');
+INSERT INTO group_roles (gid,role) VALUES('D','irc_setcalc');
+INSERT INTO group_roles (gid,role) VALUES('D','irc_getcalc');
+INSERT INTO group_roles (gid,role) VALUES('D','irc_sendsms');
+INSERT INTO group_roles (gid,role) VALUES('D','irc_smsstatus');
 
-INSERT INTO group_roles (gid,role) VALUES(8,'irc_scanreqs');
-INSERT INTO group_roles (gid,role) VALUES(8,'irc_anonscan');
+INSERT INTO group_roles (gid,role) VALUES('S','irc_scanreqs');
+INSERT INTO group_roles (gid,role) VALUES('S','irc_anonscan');
 
-INSERT INTO group_roles (gid,role) VALUES(18,'irc_p_nick');
-INSERT INTO group_roles (gid,role) VALUES(18,'irc_p_intel');
-INSERT INTO group_roles (gid,role) VALUES(18,'irc_points_others');
-INSERT INTO group_roles (gid,role) VALUES(18,'irc_whois');
-INSERT INTO group_roles (gid,role) VALUES(18,'irc_flag');
-INSERT INTO group_roles (gid,role) VALUES(18,'irc_laston');
-INSERT INTO group_roles (gid,role) VALUES(18,'irc_lastseen');
+INSERT INTO group_roles (gid,role) VALUES('R','irc_p_nick');
+INSERT INTO group_roles (gid,role) VALUES('R','irc_p_intel');
+INSERT INTO group_roles (gid,role) VALUES('R','irc_points_others');
+INSERT INTO group_roles (gid,role) VALUES('R','irc_whois');
+INSERT INTO group_roles (gid,role) VALUES('R','irc_flag');
+INSERT INTO group_roles (gid,role) VALUES('R','irc_laston');
+INSERT INTO group_roles (gid,role) VALUES('R','irc_lastseen');
+INSERT INTO group_roles (gid,role) VALUES('R','irc_forum_others');
 
-INSERT INTO group_roles (gid,role) VALUES(19,'irc_p_intel');
-INSERT INTO group_roles (gid,role) VALUES(19,'irc_h');
+INSERT INTO group_roles (gid,role) VALUES('s','irc_p_intel');
+INSERT INTO group_roles (gid,role) VALUES('s','irc_h');
+INSERT INTO group_roles (gid,role) VALUES('s','irc_points_others');
+INSERT INTO group_roles (gid,role) VALUES('s','irc_sms');
+INSERT INTO group_roles (gid,role) VALUES('s','irc_getships');
+INSERT INTO group_roles (gid,role) VALUES('s','irc_getfleet');
+INSERT INTO group_roles (gid,role) VALUES('s','irc_d');
+INSERT INTO group_roles (gid,role) VALUES('s','irc_sethostile');
+INSERT INTO group_roles (gid,role) VALUES('s','irc_anondef');
+INSERT INTO group_roles (gid,role) VALUES('s','irc_defcall');
+INSERT INTO group_roles (gid,role) VALUES('s','irc_settype');
+INSERT INTO group_roles (gid,role) VALUES('s','irc_calltake');
+INSERT INTO group_roles (gid,role) VALUES('s','irc_setcalc');
+INSERT INTO group_roles (gid,role) VALUES('s','irc_getcalc');