X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=database%2Froles.sql;h=0470abd0ff9bd5c5ea830a46726a45da606f6dd1;hb=e8c94cdebefdc428ea92fde6db63f18d3e8399b2;hp=999ae1feade38ac7caa9abfdaae94c89236d422a;hpb=c8e65de85f3c2724a5290e0ee612b83e7f63aea0;p=NDIRC.git diff --git a/database/roles.sql b/database/roles.sql index 999ae1f..0470abd 100644 --- a/database/roles.sql +++ b/database/roles.sql @@ -5,12 +5,76 @@ INSERT INTO roles VALUES('irc_masterinvite'); INSERT INTO roles VALUES('irc_gs'); INSERT INTO roles VALUES('irc_scanreqs'); INSERT INTO roles VALUES('irc_scan'); +INSERT INTO roles VALUES('irc_anonscan'); +INSERT INTO roles VALUES('irc_delquote'); +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'); 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(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'); @@ -19,15 +83,88 @@ 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(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'); 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');