|
|
Features
wStats puts all kinds of statistics about your IRC network into a MySQL database,
primairely we do not supply the webscripts to pull these statistics, but there may
be some scripts you can use in the scripts/ directory.
This is the current layout of the database:
bans:
- banmask - The actual ban (nick!username@host)
- cname - The channel the ban resides
- setby - The person who set the ban
- seton - Timestamp of when the ban was set
channels:
- cname - The channel's name
- modes - Modes of the channel
- climit - Channel limit (+l, 0 if none)
- ckey - Channel key (+k)
- topic - Channel topic
- topicby - Setter of the topic
- topicon - Timestamp of when the topic was set
- issecret - 1 if the channel is +s, otherwise 0
- isprivate - 1 if the channel is +p, otherwise 0
- users - Number of users
glines:
- expiring - Timestamp of when the G-line is too expire
- issued - Timestamp of when the G-line was issued
- issuer - Name of who set the G-line (nick, or server)
- reason - Reason of the G-line
- target - G-line mask (username@host)
history:
- timestamp - Timestamp of when the snapshot was taken
- users - Total users at that time
- servers - Total servers at that time
- channels - Total channels at that time
- opers - Total opers at that time
misc:
- servers - Current ammount of servers
- channels - Current ammount of channels
- users - Current ammount of users
- authedusers - Current ammount of users that are authed to a service
- bans - Current ammount of channel bans
- record_users - Record of users, since the booting of wStats
- glines - Current ammount of G-lines
- opers - Current ammount of IRC Operators
seen:
- nickname - Nickname
- lastused - Timestamp of when the nickname was last used
serverlinks:
- server1 - Server 1 linked to..
- server2 - Server 2
servers:
- num - Server's numeric
- mask - The hostname of the server
- hops - Ammount of hops
- description - Server description
- userpeak - Server's record users
- clients - Current ammount of users
- uplink - Uplink's name
- boot - Timestamp of boot (may be 0 if it's not wStats uplink)
- linked - Timestamp of when the server linked to the network
splits:
- id - ID of the split, can be used to sort
- ts - Timestamp of when the split occurred
- split_server - Name of the splitted server
- reason - Reason for netsplit
- hub - Name of uplink
userlists:
- cname - Channelname
- nickname - Nickname
- status - Status inside channel (2 for opped, 1 for voiced and 0 for regular)
users:
- num - User's numeric
- nickname - Nickname
- ident - Username
- account - If authed, accountname
- hostname - Hostname
- modes - Modes
- connected - Timestamp of when the user connected
- ip - User's IP
- userinfo - Realname
- away - 1 for marked as away, otherwise 0
- server - Name of the server the user resides on
- isoper - 1 for being a global IRC operator, otherwise 0
|
|
