And the MySql data structure is at the moment like this if anyone wondered:
# phpMyAdmin MySQL-Dump
# version 2.4.0-rc1
# http://www.phpmyadmin.net/ (download page)
#
# Host: localhost
# Generation Time: Mar 04, 2003 at 06:07 PM
# Server version: 3.23.52
# PHP Version: 4.2.3
# Database : `odch`
# --------------------------------------------------------
#
# Table structure for table `clients`
#
CREATE TABLE clients (
client varchar(30) NOT NULL default '',
version varchar(40) NOT NULL default '',
add_client varchar(40) NOT NULL default '',
add_version varchar(30) NOT NULL default '',
bandwidth int(11) NOT NULL default '300',
allowed tinyint(4) NOT NULL default '1'
) TYPE=MyISAM COMMENT='Client-version controll';
# --------------------------------------------------------
#
# Table structure for table `ip_range`
#
CREATE TABLE ip_range (
low_ip varchar(40) NOT NULL default '',
high_ip varchar(40) NOT NULL default '',
prefix varchar(20) NOT NULL default '',
UNIQUE KEY prefix (prefix)
) TYPE=MyISAM COMMENT='Prefix for the hub';
# --------------------------------------------------------
#
# Table structure for table `messages`
#
CREATE TABLE messages (
type varchar(40) NOT NULL default '',
mess text NOT NULL
) TYPE=MyISAM COMMENT='Standard messages';
# --------------------------------------------------------
#
# Table structure for table `triggers`
#
CREATE TABLE triggers (
trigger varchar(40) NOT NULL default '',
text text NOT NULL,
UNIQUE KEY trigger (trigger)
) TYPE=MyISAM COMMENT='Bot triggers';
# --------------------------------------------------------
#
# Table structure for table `users`
#
CREATE TABLE users (
user varchar(40) NOT NULL default '',
ip varchar(40) NOT NULL default '0',
longip bigint(11) NOT NULL default '0',
online tinyint(4) NOT NULL default '0',
date timestamp(14) NOT NULL,
UNIQUE KEY user (user)
) TYPE=MyISAM COMMENT='All users in the hub, connected or not.';
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
First the bot is lightyears from finish as I said, haven't much time lately.
Bur the primary goal for me, as the hub we have, was to force clients to use specific prefix. for example, if you are inside the ip-range x.x.x.x - y.y.y.y you are force to use prefix [foo].
Mostly I tried to get the most inside the database instead of using text-files.
But a lot of the functions is not implemented or finished yet. This is mostly a structure for now.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I've made som changes/clean up, but I'm lightyears from finish. Please use it a you want, and I would like comments etc... :)
The script is on:
http://medlem.spray.se/brutalis/odchbot.html
And the MySql data structure is at the moment like this if anyone wondered:
# phpMyAdmin MySQL-Dump
# version 2.4.0-rc1
# http://www.phpmyadmin.net/ (download page)
#
# Host: localhost
# Generation Time: Mar 04, 2003 at 06:07 PM
# Server version: 3.23.52
# PHP Version: 4.2.3
# Database : `odch`
# --------------------------------------------------------
#
# Table structure for table `clients`
#
CREATE TABLE clients (
client varchar(30) NOT NULL default '',
version varchar(40) NOT NULL default '',
add_client varchar(40) NOT NULL default '',
add_version varchar(30) NOT NULL default '',
bandwidth int(11) NOT NULL default '300',
allowed tinyint(4) NOT NULL default '1'
) TYPE=MyISAM COMMENT='Client-version controll';
# --------------------------------------------------------
#
# Table structure for table `ip_range`
#
CREATE TABLE ip_range (
low_ip varchar(40) NOT NULL default '',
high_ip varchar(40) NOT NULL default '',
prefix varchar(20) NOT NULL default '',
UNIQUE KEY prefix (prefix)
) TYPE=MyISAM COMMENT='Prefix for the hub';
# --------------------------------------------------------
#
# Table structure for table `messages`
#
CREATE TABLE messages (
type varchar(40) NOT NULL default '',
mess text NOT NULL
) TYPE=MyISAM COMMENT='Standard messages';
# --------------------------------------------------------
#
# Table structure for table `triggers`
#
CREATE TABLE triggers (
trigger varchar(40) NOT NULL default '',
text text NOT NULL,
UNIQUE KEY trigger (trigger)
) TYPE=MyISAM COMMENT='Bot triggers';
# --------------------------------------------------------
#
# Table structure for table `users`
#
CREATE TABLE users (
user varchar(40) NOT NULL default '',
ip varchar(40) NOT NULL default '0',
longip bigint(11) NOT NULL default '0',
online tinyint(4) NOT NULL default '0',
date timestamp(14) NOT NULL,
UNIQUE KEY user (user)
) TYPE=MyISAM COMMENT='All users in the hub, connected or not.';
I keep on getting:
error while loading shared libraries: /usr/lib/perl5/site_perl/i386-linux/auto/DBD/mysql/mysql.so: undefined symbol: mysql_init
When i try to use your script, and i have DBI, DBD::mysql and DBD::mysql::Install compiled and ready ( even make installed em )
Nevermind... solved it after a few hours
Um, Could you tell a n00b like me what this bot do?=)
First the bot is lightyears from finish as I said, haven't much time lately.
Bur the primary goal for me, as the hub we have, was to force clients to use specific prefix. for example, if you are inside the ip-range x.x.x.x - y.y.y.y you are force to use prefix [foo].
Mostly I tried to get the most inside the database instead of using text-files.
But a lot of the functions is not implemented or finished yet. This is mostly a structure for now.