Anope MySQL

From Base de connaissances eggdrops & TCL
Jump to: navigation, search

This list was compiled by iScripters. It is aimed at stripping down the Anope MySQL Database Structure into normal language (It tells what field is used for what).

If you find any incorrect data or you know where a field is used for which is marked as Unknown, feel free to update the page, if you belive a description can be fixed use this page's talk page to address it.

anope_bs_core

Column Description
bs_id This field is used to store the ID number of a bot created in BotServ.
nick This field contains the nickname for the created bot.
user This field containts the username for the created bot.
host This field contains the hostname for the created bot.
rname This field contains the real name for the created bot.
flags This field contains the flags given to a created bot.
created This field contains a timestamp which indicates when the bot was created.
chancount This field contains the number of channels a bot is assigned to.
user This field containts the username for the created bot.

anope_cs_access

Column Description
ca_id This field contains an ID number for every access entry of all channels.
in_use This field shows if it is in use or not (1 or 0).
level This field containts the access level a user has got.
display This field contains the nickname belonging to an access level.
channel This field contains the channel where the access level is used on.
last_seen This field contains a timestamp which indicates when display was last seen on channel.

anope_cs_akicks

Table of automatic kicks set on a channel

Column Description
ck_id The ID number for the akick
channel The channel where the akick is used on (FK)
flags Flags assigned to the akick
dmask Mask for the akick
reason The reason why the akick has been set
creator The nickname of the user that set the akick
addtime A timestamp which indicates when the akick has been set

anope_cs_badwords

Table of badwords set on a channel

Column Description
cw_id The ID number for the badword
channel The channel where the badword is used on (FK)
word The badword itself
type The type flag which tells anope what to look for
         ANY 		0
SINGLE 1
START 2
END 3

anope_cs_info

Informations about a channel

Primary table for others using channel as FK (relation with name)

Column Description
ci_id The ID number of a channel
name The channel name
founder The channel founder
successor The channel successor
founderpass The founderpass used to log in as channel founder
descr The channel description
url The url assigned to the channel
email The email address assigned to the channel
time_registered A timestamp indicating when the channel was registered
last_used A timestamp indicating when the channel was last used
last_topic The last known topic
last_topic_setter The nickname of the user that was seen setting the last topic
last_topic_time A timestamp indicating when the last topic seen has been set
flags No information known yet.
forbidby The user that has made this channel fobidden, if the channel is forbidden at all
forbidreason The reason why the channel has been forbidden, if the channel has been forbidden at all
bantype The bantype services will use when placing bans
accesscount No information known yet. (Current users in channel, or entries on access list?)
akickcount Number of akicks active on this channel
mlock_on Modes enable with + flag
mlock_off Modes enable with - flag
mlock_limit User limit (NULL = no +l flag)
mlock_key Key for the channel (NULL = no +k flag)
mlock_flood Flood ratio for the channel (NULL = no +f flag)
mlock_redirect The link (L) enforced when the limit (l) has been reached
entry_message The entry message for this channel, displayed when any user joins
memomax The maximum number of memo's a channel can recieve
botnick The nickname of the bot assigned to this channel, if there is a bot assigned at all
botflags The flags given to the bot assigned to this channel. if there is a bot assigned at all
ttb Time To Ban
bwcount The number of badwords active on this channel
capsmin The minimum number of caps in a line to consider it's shouting
capspercent The minimum percent of caps in a line to consider it's shouting
floodlines The maximum number of lines within X seconds (see below) before it's assumed to be flood
floodsecs See above
repeattimes The maximum number of repeated lines before a user gets kicked
active Wether the channel is active (1) or not (0)

anope_cs_levels

Column Description
cl_id The ID number for each access level
channel The channel where the access level is used on
position No information known yet.
level No information known yet.

anope_hs_core

Column Description
bs_id The ID number for a vhost
nick The nickname where the vhost is applied to
vident The virtual-ident for the nickname
vhost The virtual-host for the nickname
creator The creator of the vhost
time A timestamp indicating when the vhost was created

anope_info

This table is only updated when mydbgen is used, otherwise this is blank

Column Description
version No information known yet.
date No information known yet.

anope_ms_info

Column Description
nm_id The ID number of a memo
reciever The recipent of the memo
number The number of the memo
flags The flags assigned to a memo
time A timestamp indicating when the memo has been sent
sender The sender of the memo
text The memo itself
serv No information known yet.

anope_ns_access

Column Description
na_id No information known yet.
display No information known yet.
access No information known yet.

anope_ns_alias

Column Description
na_id No information known yet.
display No information known yet.
nick No information known yet.
time_registered Time stamp of when the registered.
last_seen Time stamp of the last time the nick was seen in use.
status No information known yet.
last_usermask Last ident seen by services for the given nick.
last_realname Last host address seen by services for the given nick.
last_quit The last /quit message as stored by services. This can always be the suspend or forbid reason
active No information known yet.

anope_ns_core

Column Description
nc_id Unique ID of this row.
display Nick's primary display name.
pass Password; can be encrypted if specified in Anope config
email E-mail provided by the user
icq ICQ contact number provided by the user
url Website URL provided by the user
flags Stores option flags for this nickname.
language No information known yet.
accesscount No information known yet.
memocount Number of memos stored for this nickname.
memomax No information known yet.
channelcount Number of channels registered by this nickname.
channelmax No information known yet.
greet Nick's greet message.
active Whether the nick is suspended or not.

anope_ns_request

Column Description
nr_id No information known yet.
nick No information known yet.
passcode No information known yet.
password No information known yet.
email No information known yet.
requested No information known yet.
active No information known yet.

anope_os_akills

Column Description
ok_id No information known yet.
user No information known yet.
host No information known yet.
xby No information known yet.
reason No information known yet.
seton No information known yet.
expire No information known yet.

anope_os_core

Column Description
oc_id No information known yet.
maxusercnt The max user count (minus services bots).
maxusertime The time stamp when the max user count was reached.
akills_count The number of akills.
sglines_count The number of sglines.
sqlines_count The number of sqlines.
szlines_count The number of szlines.

anope_os_exceptions

Column Description
oe_id No information known yet.
mask No information known yet.
lim No information known yet.
who No information known yet.
reason No information known yet.
time No information known yet.
expires No information known yet.

anope_os_hcache

This table is no longer used due to the proxy detector has been removed

Column Description
oh_id No information known yet.
mask No information known yet.
status No information known yet.
used No information known yet.

anope_os_news

Column Description
on_id No information known yet.
type No information known yet.
num No information known yet.
ntext No information known yet.
who No information known yet.
time No information known yet.

anope_os_sglines

Column Description
og_id No information known yet.
mask No information known yet.
xby No information known yet.
reason No information known yet.
seton No information known yet.
expire No information known yet.

anope_os_sqlines

Column Description
og_id index number.
mask The qline nick (mask) which is banned.
xby qline set by.
reason Reason for the qline.
seton Time stamp of when the qline was set.
expire Time stamp of when the qline will be removed.

anope_os_status

Column Description
os_id No information known yet.
host No information known yet.
status No information known yet.
used No information known yet.

anope_os_szlines

Column Description
og_id index number.
mask The zline address (mask) which is banned.
xby zline set by.
reason Reason for the zline.
seton Time stamp of when the zline was set.
expire Time stamp of when the zline will be removed.