qwNFyqWk

1user = mail-user
2password = PASSWD
3dbname = mail-db
4hosts = sql3.ne0.pl
5
6query = SELECT `domain` FROM `mailbox` WHERE `domain` = 'ne0.pl' AND `actived` = '1' GROUP BY `domain`
7
8-----------------------
9table mailbox:
10
11CREATE TABLE IF NOT EXISTS `mailbox` (
12  `username` varchar(255) NOT NULL,
13  `password` varchar(255) NOT NULL,
14  `name` varchar(255) character set utf8 NOT NULL,
15  `maildir` varchar(255) NOT NULL,
16  `domain` varchar(255) NOT NULL,
17  `actived` tinyint(1) NOT NULL default '1',
18  PRIMARY KEY  (`username`),
19  KEY `domain` (`domain`)
20) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Postfix Admin - Virtual Mailboxes';
21
22INSERT INTO `mailbox` (`username`, `password`, `name`, `maildir`, `domain`, `actived`) VALUES
23('dupa', '2qLV1Y4k7g9y6', 'dupa', '', 'ne0.pl', 1);