[SithNet-Patches] [CVS] Module gnuworld-sithnet: Change committed
Brought to you by:
darthsidious_
Menu
▾
▴
[SithNet-Patches] [CVS] Module gnuworld-sithnet: Change committed
|
From: Tim I. <dar...@us...> - 2003-10-24 20:30:10
|
Committer : Tim Ireland <dar...@us...>
CVSROOT : /cvsroot/sithnet-dev
Module : gnuworld-sithnet
Commit time: 2003-10-24 20:28:34 UTC
Added files:
doc/uworld.commands.sql doc/uworld.sql doc/uworld.addme.sql
Log message:
Added mod.uworld SQL schema
---------------------- diff included ----------------------
Index: gnuworld-sithnet/doc/uworld.addme.sql
diff -u /dev/null gnuworld-sithnet/doc/uworld.addme.sql:1.1
--- /dev/null Fri Oct 24 13:28:34 2003
+++ gnuworld-sithnet/doc/uworld.addme.sql Fri Oct 24 13:28:23 2003
@@ -0,0 +1,6 @@
+-- Add level 1000 admin
+-- ULtimaTe_ <ult...@wo...> 02/02/2002
+-- $Id: uworld.addme.sql,v 1.1 2003/10/24 20:28:23 darthsidious_ Exp $
+
+INSERT INTO users (user_name,password,access)
+VALUES ('Spike','07d976a29bdb3ff42e19c102852151b28097bbad',1000);
Index: gnuworld-sithnet/doc/uworld.commands.sql
diff -u /dev/null gnuworld-sithnet/doc/uworld.commands.sql:1.1
--- /dev/null Fri Oct 24 13:28:34 2003
+++ gnuworld-sithnet/doc/uworld.commands.sql Fri Oct 24 13:28:23 2003
@@ -0,0 +1,131 @@
+--commands db
+
+-- Zap everything!
+DELETE FROM commands;
+
+INSERT INTO commands (command,shortdesc,level,longdesc)
+VALUES('ACCESS','returns the bots access list',0,'This command returns the bots access list');
+
+INSERT INTO commands (command,shortdesc,level,longdesc)
+VALUES ('LOGIN','Authenticates you with the bot',0,'');
+
+INSERT INTO commands (command,shortdesc,level,longdesc)
+VALUES ('NEWPASS','sets a new password for you',0,'');
+
+INSERT INTO commands (command,shortdesc,level,longdesc)
+VALUES('INVITE','invites you to a channel',100,'This command invites you to a channel');
+
+INSERT INTO commands (command,shortdesc,level,longdesc)
+VALUES('SERVLIST','returns the list of currently linked servers',100,'This returns the list of currently linked servers');
+
+INSERT INTO commands (command,shortdesc,level,longdesc)
+VALUES('WHOIS','gives more info on a nick',100,'');
+
+INSERT INTO commands (command,shortdesc,level,longdesc)
+VALUES('CHANINFO','gives you info about a chan',100,'');
+
+INSERT INTO commands (command,shortdesc,level,longdesc)
+VALUES('TRANSLATE','translates a numeric into a nickname',100,'');
+
+INSERT INTO commands (command,shortdesc,level,longdesc)
+VALUES('MODE','set mode thru the bot',400,'');
+
+INSERT INTO commands (command,shortdesc,level,longdesc)
+VALUES('CLEARCHAN','reset a channel modes',400,'');
+
+INSERT INTO commands (command,shortdesc,level,longdesc)
+VALUES('SCAN','search a certain hostname on the network',400,'');
+
+INSERT INTO commands (command,shortdesc,level,longdesc)
+VALUES('ADDUSER','adds a user to my database',700,'');
+
+INSERT INTO commands (command,shortdesc,level,longdesc)
+VALUES('REMUSER','removes a user from my database',700,'');
+
+INSERT INTO commands (command,shortdesc,level,longdesc)
+VALUES('MODUSER','modifies a user in my database',700,'');
+
+INSERT INTO commands (command,shortdesc,level,longdesc)
+VALUES('SAY','make the bot talk',800,'');
+
+INSERT INTO commands (command,shortdesc,level,longdesc)
+VALUES('JOIN','make the bot join a channel',800,'');
+
+INSERT INTO commands (command,shortdesc,level,longdesc)
+VALUES('PART','make the bot leave a channel',800,'');
+
+INSERT INTO commands (command,shortdesc,level,longdesc)
+VALUES('INVME','invites you to console channel',900,'');
+
+INSERT INTO commands (command,shortdesc,level,longdesc)
+VALUES('QUOTE','a coder toy',950,'');
+
+INSERT INTO commands (command,shortdesc,level,longdesc)
+VALUES('GODLIKE','for my special god',1000,'');
+
+INSERT INTO commands (command,shortdesc,level,longdesc)
+VALUES('DEAUTH','deauthenticates you',0,'');
+
+INSERT INTO commands (command,shortdesc,level,longdesc)
+VALUES('FDEAUTH','force a user to deauthenticate',600,'');
+
+INSERT INTO commands (command,shortdesc,level,longdesc)
+VALUES('OPCHAN','ops a user in an opless channel',100,'');
+
+INSERT INTO commands (command,shortdesc,level,longdesc)
+VALUES('WALLOPS','sends a wallusers message',700,'');
+
+INSERT INTO commands (command,shortdesc,level,longdesc)
+VALUES('GLOBAL','sends a global notice',600,'');
+
+INSERT INTO commands (command,shortdesc,level,longdesc)
+VALUES('SHUTDOWN','shuts bot and server down',900,'');
+
+INSERT INTO commands (command,shortdesc,level,longdesc)
+VALUES('JUPE','adds a server jupe',600,'');
+
+INSERT INTO commands (command,shortdesc,level,longdesc)
+VALUES('GLINE','adds a gline',400,'');
+
+INSERT INTO commands (command,shortdesc,level,longdesc)
+VALUES('REMGLINE','removes a gline',400,'');
+
+INSERT INTO commands (command,shortdesc,level,longdesc)
+VALUES('LIST','lists glines,badchans,agl,...',400,'');
+
+INSERT INTO commands (command,shortdesc,level,longdesc)
+VALUES('UPTIME','gives the bots uptime',100,'');
+
+INSERT INTO commands (command,shortdesc,level,longdesc)
+VALUES('OMSG','Uworlds Private Operator club',400,'');
+
+INSERT INTO commands (command,shortdesc,level,longdesc)
+VALUES('SUSPEND','suspends a user',700,'');
+
+INSERT INTO commands (command,shortdesc,level,longdesc)
+VALUES('UNSUSPEND','unsuspends a user',700,'');
+
+INSERT INTO commands (command,shortdesc,level,longdesc)
+VALUES('BADCHAN','adds a banchan',600,'');
+
+INSERT INTO commands (command,shortdesc,level,longdesc)
+VALUES('REMBADCHAN','removes a banchan',600,'');
+
+INSERT INTO commands (command,shortdesc,level,longdesc)
+VALUES('DELSERVER','deletes a server from the memory',800,'');
+
+INSERT INTO commands (command,shortdesc,level,longdesc)
+VALUES('LEARNNET','gets to know the network again',900,'');
+
+INSERT INTO commands (command,shortdesc,level,longdesc)
+VALUES('CHECKNET','checks for missing servers',400,'');
+
+INSERT INTO commands (command,shortdesc,level,longdesc)
+VALUES('LASTCOMM','shows the last commands i received',100,'');
+
+INSERT INTO commands (command,shortdesc,level,longdesc)
+VALUES('AGL', 'modifies the AGL-table', 700, '');
+
+INSERT INTO commands (command,shortdesc,level,longdesc)
+VALUES('STATUS', 'shows the internal status', 100, '');
+
Index: gnuworld-sithnet/doc/uworld.sql
diff -u /dev/null gnuworld-sithnet/doc/uworld.sql:1.1
--- /dev/null Fri Oct 24 13:28:34 2003
+++ gnuworld-sithnet/doc/uworld.sql Fri Oct 24 13:28:23 2003
@@ -0,0 +1,48 @@
+-- cyclebot database script ;)
+-- ULtimaTe_ <ult...@wo...> 02/02/2002 (all those 2's ;))
+-- $Id: uworld.sql,v 1.1 2003/10/24 20:28:23 darthsidious_ Exp $
+
+CREATE TABLE users (
+
+ id SERIAL,
+ user_name TEXT NOT NULL,
+ password VARCHAR (40) NOT NULL,
+ access INT4 NOT NULL DEFAULT '0',
+ flags INT2 NOT NULL DEFAULT '0',
+ suspend_expires INT4,
+ suspend_level INT4
+);
+
+CREATE TABLE glines (
+ Id SERIAL,
+ Host VARCHAR(128) UNIQUE NOT NULL,
+ AddedBy VARCHAR(128) NOT NULL,
+ AddedOn INT4 NOT NULL,
+ AddedLevel INT4 NOT NULL DEFAULT '100',
+ ExpiresAt INT4 NOT NULL,
+ Reason VARCHAR(255)
+ );
+
+CREATE TABLE commands (
+ command TEXT UNIQUE NOT NULL,
+ shortdesc VARCHAR (128) NOT NULL,
+ level INT4 NOT NULL DEFAULT '0',
+ longdesc VARCHAR (512)
+);
+
+CREATE TABLE logs (
+ Id SERIAL,
+ username TEXT NOT NULL,
+ nickuserhost VARCHAR(128) NOT NULL,
+ ts INT4 NOT NULL,
+ log VARCHAR(255)
+ );
+
+CREATE TABLE AGL (
+ AGL_Host VARCHAR(128) UNIQUE NOT NULL,
+ Connections INT4 NOT NULL,
+ AddedBy VARCHAR(128) NOT NULL,
+ AddedOn INT4 NOT NULL
+ );
+
+
----------------------- End of diff -----------------------
|
