Basic conversion to POE::Component::IRC

[NDIRC.git] / database / roles.sql

diff --git a/database/roles.sql b/database/roles.sql
index b91fa58d0ef17989bd94eb26b840c0637900a8e2..0470abd0ff9bd5c5ea830a46726a45da606f6dd1 100644 (file)
--- a/database/roles.sql
+++ b/database/roles.sql
@@ -11,6 +11,32 @@ INSERT INTO roles VALUES('irc_points_others');
 INSERT INTO roles VALUES('irc_sms');
 INSERT INTO roles VALUES('irc_adduser');
 INSERT INTO roles VALUES('irc_deactivateuser');
+INSERT INTO roles VALUES('irc_chattr');
+INSERT INTO roles VALUES('irc_whois');
+INSERT INTO roles VALUES('irc_flag');
+INSERT INTO roles VALUES('irc_laston');
+INSERT INTO roles VALUES('irc_lastseen');
+INSERT INTO roles VALUES('irc_getships');
+INSERT INTO roles VALUES('irc_getfleet');
+INSERT INTO roles VALUES('irc_sethost');
+INSERT INTO roles VALUES('irc_setpnick');
+INSERT INTO roles VALUES('irc_a');
+INSERT INTO roles VALUES('irc_d');
+INSERT INTO roles VALUES('irc_s');
+INSERT INTO roles VALUES('irc_h');
+INSERT INTO roles VALUES('irc_sethostile');
+INSERT INTO roles VALUES('irc_setnick');
+INSERT INTO roles VALUES('irc_setally');
+INSERT INTO roles VALUES('irc_setchannel');
+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 group_roles (gid,role) VALUES(1,'irc_p_nick');
 INSERT INTO group_roles (gid,role) VALUES(1,'irc_p_intel');
@@ -23,6 +49,32 @@ 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(1,'irc_setcalc');
+INSERT INTO group_roles (gid,role) VALUES(1,'irc_getcalc');
+INSERT INTO group_roles (gid,role) VALUES(1,'irc_sendsms');
+INSERT INTO group_roles (gid,role) VALUES(1,'irc_smsstatus');
+INSERT INTO group_roles (gid,role) VALUES(1,'irc_forum_others');
 
 INSERT INTO group_roles (gid,role) VALUES(2,'irc_gs');
 INSERT INTO group_roles (gid,role) VALUES(2,'irc_scan');
@@ -37,15 +89,58 @@ 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(3,'irc_setcalc');
+INSERT INTO group_roles (gid,role) VALUES(3,'irc_getcalc');
+INSERT INTO group_roles (gid,role) VALUES(3,'irc_sendsms');
+INSERT INTO group_roles (gid,role) VALUES(3,'irc_smsstatus');
+INSERT INTO group_roles (gid,role) VALUES(3,'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(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(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(6,'irc_setcalc');
+INSERT INTO group_roles (gid,role) VALUES(6,'irc_getcalc');
+INSERT INTO group_roles (gid,role) VALUES(6,'irc_sendsms');
+INSERT INTO group_roles (gid,role) VALUES(6,'irc_smsstatus');
 
 INSERT INTO group_roles (gid,role) VALUES(8,'irc_scanreqs');
 INSERT INTO group_roles (gid,role) VALUES(8,'irc_anonscan');
@@ -53,5 +148,23 @@ INSERT INTO group_roles (gid,role) VALUES(8,'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(18,'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(19,'irc_points_others');
+INSERT INTO group_roles (gid,role) VALUES(19,'irc_sms');
+INSERT INTO group_roles (gid,role) VALUES(19,'irc_getships');
+INSERT INTO group_roles (gid,role) VALUES(19,'irc_getfleet');
+INSERT INTO group_roles (gid,role) VALUES(19,'irc_d');
+INSERT INTO group_roles (gid,role) VALUES(19,'irc_sethostile');
+INSERT INTO group_roles (gid,role) VALUES(19,'irc_anondef');
+INSERT INTO group_roles (gid,role) VALUES(19,'irc_defcall');
+INSERT INTO group_roles (gid,role) VALUES(19,'irc_settype');
+INSERT INTO group_roles (gid,role) VALUES(19,'irc_calltake');
+INSERT INTO group_roles (gid,role) VALUES(19,'irc_setcalc');
+INSERT INTO group_roles (gid,role) VALUES(19,'irc_getcalc');