thistehneisen/mysql_bot_core

Base for MySQL bot running on mIRC

mysql_bot_core

Base for MySQL bot running on mIRC

MODULES:

• Seen System - https://github.com/thistehneisen/mysql_bot_core_seen_system
• Stats System - https://github.com/thistehneisen/mysql_bot_stats_system
• Live Status - http://www.hawkee.com/snippet/8962/
• Channel Peak - http://www.hawkee.com/snippet/9025/
• Human Verification - http://www.hawkee.com/snippet/9042/ (search everything, including 3rd party) http://www.hawkee.com/mirc/snippets/search/MySQL+MBC/

DOCUMENTATION:

[] - optional
$m.sqlb() - wraps text into `these`, which is useful in mysql queries
$m.sqle() - escapes string
$m.sqlq() - wraps text into 'quotes', which is useful in mysql queries
$m.dbres(field,database,where,value[,where2,value2]) - returns db result
$m.dbdel(database,where,value) - deletes entry from database
$m.user(field,id/username,value) - returns user information from `users` database
$m.logged(nickname) - returns user id if specified nickname is logged in
- 1.00 STABLE
$m.setting(setting) - returns setting value from `general` database
m.setting setting value - sets setting value in `general` database
$m.encrypt - variable that encrypts sensitive data (must be static, when active users exists)
- 1.12 STABLE
m.modules Module Name|!command|admin(int0/1)

COMMANDS:

!help - no description needed here
!register username password - create an account
!login username password - log in to account
!logout - log out from an account
!profile /nickname/ - profile info about specified nickname or yourself if not specified
!settings password|signature - sets your profile settings
!admin debug|restart|sesdel - administration options (by default level 5+)

• /something/ - optional setting
• Note: you can change command prefix in local $command aliases

REQUIREMENTS:

• http://reko.tiira.net/mmysql/ (mIRC MySQL by Reko Tiira)
• MySQL database with structure that's below.

Database structure:

CREATE TABLE `messages` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `sender` int(10) unsigned NOT NULL,
  `receiver` int(10) unsigned NOT NULL,
  `message` text COLLATE utf8_latvian_ci NOT NULL,
  `time` datetime DEFAULT NULL,
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_latvian_ci;

CREATE TABLE `sessions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(10) unsigned NOT NULL,
  `status` tinyint(3) unsigned NOT NULL,
  `address` varchar(50) NOT NULL,
  `nickname` varchar(45) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(45) NOT NULL,
  `password` varchar(45) NOT NULL,
  `registered` datetime NOT NULL,
  `active` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `group` smallint(10) unsigned NOT NULL DEFAULT '0',
  `level` int(10) unsigned NOT NULL DEFAULT '0',
  `points` int(10) unsigned NOT NULL,
  `signature` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `channels` (
  `channel` varchar(50) NOT NULL,
  `users` smallint(5) unsigned NOT NULL,
  `regulars` smallint(5) unsigned NOT NULL,
  `voices` smallint(5) unsigned NOT NULL,
  `halfops` smallint(5) unsigned NOT NULL,
  `operators` smallint(5) unsigned NOT NULL,
  `topic` varchar(255) CHARACTER SET utf8 COLLATE utf8_latvian_ci NOT NULL,
  `mode` varchar(20) CHARACTER SET latin1 NOT NULL,
  PRIMARY KEY (`channel`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `general` (
  `setting` varchar(255) NOT NULL,
  `value` varchar(255) NOT NULL,
  PRIMARY KEY (`setting`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;