-- MySQL dump 10.11
--
-- Host: localhost Database: help_trio_newest
-- ------------------------------------------------------
-- Server version 5.0.77
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `acp_globalauth`
--
DROP TABLE IF EXISTS `acp_globalauth`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `acp_globalauth` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(64) collate latin1_general_ci NOT NULL default '',
`password` varchar(32) collate latin1_general_ci NOT NULL default '',
`first_name` text collate latin1_general_ci,
`last_name` text collate latin1_general_ci,
`email` text collate latin1_general_ci,
`last_login` timestamp NULL default NULL,
`sourceid` int(10) unsigned NOT NULL default '0',
`sourceupdated` datetime default NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `acp_globalauth`
--
LOCK TABLES `acp_globalauth` WRITE;
/*!40000 ALTER TABLE `acp_globalauth` DISABLE KEYS */;
INSERT INTO `acp_globalauth` VALUES (1,'admin','e7a8b5521fc4728ce86e4ca8abc58d45','Prefix','Management','supporttrioadmin@prefix.co.za','0000-00-00 00:00:00',4,'2010-01-12 11:32:58'),(2,'josh','409e20b35c3f825ead6f339910e0eba8','Josh','Adler','josh@prefix.co.za',NULL,4,'2010-01-17 07:10:05'),(3,'graham','1a1dc91c907325c69271ddf0c944bc72','Graham','Cherrington','graham@prefix.co.za',NULL,0,NULL),(4,'sam','87dd9ce404eaaf442714f62ebe60fa26','Sam','Hutchinson','sam@prefix.co.za',NULL,4,'2009-11-16 12:00:46'),(5,'vince','704e37e9acaf328e78a07fcc30149cd5','Vince','Kruger','vincent@prefix.co.za',NULL,0,NULL),(6,'keith','1a1dc91c907325c69271ddf0c944bc72','Keith','Thompson','keith@prefix.co.za',NULL,4,'2009-08-05 13:01:14'),(7,'tanya','4aa5594056356e2ddc7b9d2803103859','Tanya','Lourens','tanya@prefix.co.za',NULL,0,NULL),(8,'reception','1da95b279fc0d21024cece2c68a4c200','Gillian','M Biggar','reception@prefix.co.za',NULL,4,'2010-01-12 08:14:36'),(9,'taryn','1a1dc91c907325c69271ddf0c944bc72','Taryn-Lee','Biggar','taryn@prefix.co.za',NULL,0,NULL),(10,'phathu','04e2b654d6f02eaf95cf1ff9e4f4afff','Phathu','Ratshilumela','phathu@mio.co.za',NULL,0,NULL),(11,'gerhard','b05a51147113adbe5d87dad8702edb8d','Gerhard','van der Walt','gerhard@prefix.co.za',NULL,0,NULL),(12,'given','45d07b00b0188a892509950ff919e14e','Given','Moila','given@prefix.co.za',NULL,4,'2009-09-07 11:26:58'),(13,'richard','ea3596139530b2abe7089082ab57ecbd','Richard','Rumney','richard@mio.co.za',NULL,0,NULL),(14,'jacques','1a1dc91c907325c69271ddf0c944bc72','Jacques','Hechter','jacques@prefix.co.za',NULL,4,'2010-01-11 11:01:40'),(15,'paulo','f9c1fa62f0088fe6ad5b9082f99c008a','Paulo','Moreira','paulo@prefix.co.za',NULL,4,'2010-01-14 01:55:18'),(16,'abubakr','6d2ff74bdff6185f2e53793adce069f9','Abubakr','Snyders','abubakr@prefix.co.za',NULL,4,'2009-06-19 08:06:53'),(17,'andries','2c09049f71d24b729849384d1fd71af3','Andries','Mashile','andries@prefix.co.za',NULL,0,NULL),(18,'martin','dc563bf86d935cc5eab71abf726c9bc1','Martin','Schuch','martin@prefix.co.za',NULL,4,'2009-08-20 11:42:36'),(19,'brian','f3c1a9d108829c4546f1c133beb813d8','Brian','Gouws','brian@prefix.co.za',NULL,4,'2010-01-19 02:12:12'),(20,'gerharde','7466458f66057ea6f84b341cec9322c7','Gerhard','Engelbrecht','gerhard@prefix.co.za',NULL,4,'2010-01-19 23:59:31'),(21,'etienne','2c0070c0d7af7f34190b02669aa14b9f','Etienne','Stemmet','etienne@prefix.co.za',NULL,4,'2009-10-27 08:39:12'),(22,'lidia','a871a85ccefea13d5ccfecb02f656a04','Lidia','Mentz','lidia.m@prefix.co.za',NULL,4,'2009-10-29 08:58:07'),(23,'lydia','37fae78f51338091b7c73d2a011b46a1','Lydia','Byarugaba','lydia.b@prefix.co.za',NULL,4,'2010-01-11 14:23:54');
/*!40000 ALTER TABLE `acp_globalauth` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tt_address_entry`
--
DROP TABLE IF EXISTS `tt_address_entry`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tt_address_entry` (
`id` int(10) NOT NULL auto_increment,
`fname` varchar(250) collate latin1_general_ci NOT NULL default '',
`lname` varchar(250) collate latin1_general_ci NOT NULL default '',
`email` varchar(250) collate latin1_general_ci NOT NULL default '',
`company` varchar(250) collate latin1_general_ci NOT NULL default '',
`address` varchar(250) collate latin1_general_ci NOT NULL default '',
`city` varchar(250) collate latin1_general_ci NOT NULL default '',
`state` varchar(100) collate latin1_general_ci NOT NULL default '',
`zip` varchar(100) collate latin1_general_ci NOT NULL default '',
`country` varchar(150) collate latin1_general_ci NOT NULL default '',
`phone` varchar(150) collate latin1_general_ci NOT NULL default '',
`fax` varchar(150) collate latin1_general_ci NOT NULL default '',
`mobile` varchar(150) collate latin1_general_ci NOT NULL default '',
`url` varchar(250) collate latin1_general_ci NOT NULL default '',
`comments` text collate latin1_general_ci NOT NULL,
`adminid` int(10) NOT NULL default '0',
`groupid` int(10) NOT NULL default '0',
`private` int(1) NOT NULL default '0',
PRIMARY KEY (`id`),
FULLTEXT KEY `address` (`address`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tt_address_entry`
--
LOCK TABLES `tt_address_entry` WRITE;
/*!40000 ALTER TABLE `tt_address_entry` DISABLE KEYS */;
INSERT INTO `tt_address_entry` VALUES (1,'Gabi','','gabi@cssa.org.za','CSSA','','','','','','','','','','',5,0,0),(2,'Sam','Hutchinson','sam@prefix.co.za','','','','','','','','','','','',8,0,0),(3,'Josh','Adler','josh@prefix.co.za','','','','','','','','','','','------------------------------------------------------------------------\r\nJosh Adler @ Prefix Technologies \r\nTel: +27 11 447 6147 :: fax. +27 11 880 0994 \r\njosh@prefix.co.za :: http://www.prefix.co.za ',8,0,0),(4,'Vince','Kruger','vincent@prefix.co.za','','','','','','','','','','','---------------------------------------------------------\r\nVince Kruger\r\n:: office. 0027114476147\r\n:: email. vincent@prefix.co.za :: skype. vince.kruger ::\r\n---------------------------------------------------------',8,0,0),(5,'Taryn-Lee','Biggar','taryn@prefix.co.za','','','','','','','','','','','Taryn-Lee Biggar :: Prefix Technologies :: Tel. +27 11 447 6147 :: fax. +27 11 880 0994 :: support@prefix.co.za :: http://www.prefix.co.za ',8,0,0),(6,'Tanya','Lourens','tanya@prefix.co.za','','','','','','','','','','','Tanya Lourens :: Prefix Technologies \r\nTel: +27 11 447 6147 :: fax. +27 11 880 0994 \r\nsupport@prefix.co.za :: http://www.prefix.co.za ',8,0,0),(7,'Gerhard','van der Walt','gerhard@prefix.co.za','','','','','','','','','','','',8,0,0);
/*!40000 ALTER TABLE `tt_address_entry` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tt_admin`
--
DROP TABLE IF EXISTS `tt_admin`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tt_admin` (
`id` int(10) NOT NULL auto_increment,
`absid` int(10) unsigned NOT NULL default '0',
`user` varchar(250) collate latin1_general_ci NOT NULL default '',
`pass` varchar(250) collate latin1_general_ci NOT NULL default '',
`name` varchar(250) collate latin1_general_ci NOT NULL default '',
`email` varchar(250) collate latin1_general_ci NOT NULL default '',
`title` varchar(250) collate latin1_general_ci NOT NULL default '',
`date_added` date NOT NULL default '0000-00-00',
`auth` int(5) NOT NULL default '0',
`l_date` date NOT NULL default '0000-00-00',
`l_time` time NOT NULL default '00:00:00',
`sig` text collate latin1_general_ci NOT NULL,
`disp_1` int(1) NOT NULL default '1',
`disp_2` int(1) NOT NULL default '1',
`disp_3` int(1) NOT NULL default '1',
`disp_4` int(1) NOT NULL default '1',
`disp_5` int(1) NOT NULL default '1',
`disp_6` int(1) NOT NULL default '1',
`disp_7` int(1) NOT NULL default '1',
`disp_ref` int(10) NOT NULL default '60',
`assign_m` int(10) NOT NULL default '15',
`dep_range` text collate latin1_general_ci NOT NULL,
`tic_1` int(1) NOT NULL default '1',
`tic_2` int(1) NOT NULL default '1',
`tic_3` int(1) NOT NULL default '1',
`dep_1` int(1) NOT NULL default '1',
`dep_2` int(1) NOT NULL default '1',
`dep_3` int(1) NOT NULL default '1',
`dep_4` int(1) NOT NULL default '1',
`dep_5` int(1) NOT NULL default '1',
`dep_6` int(1) NOT NULL default '1',
`usr_1` int(1) NOT NULL default '1',
`usr_2` int(1) NOT NULL default '1',
`usr_3` int(1) NOT NULL default '1',
`oth_1` int(1) NOT NULL default '1',
`oth_2` int(1) NOT NULL default '1',
`oth_3` int(1) NOT NULL default '1',
`oth_4` int(1) NOT NULL default '1',
`oth_5` int(1) NOT NULL default '1',
`disp_num` int(10) NOT NULL default '15',
`notify_1` int(1) NOT NULL default '1',
`notify_2` int(1) NOT NULL default '1',
`notify_3` int(3) NOT NULL default '1',
`ticket_view` int(1) NOT NULL default '0',
`t_offset` int(10) NOT NULL default '0',
`t_offset_o` varchar(5) collate latin1_general_ci NOT NULL default '',
`lang` varchar(250) collate latin1_general_ci NOT NULL default '',
`tic_4` int(1) NOT NULL default '1',
`tic_5` int(1) NOT NULL default '1',
`tic_6` int(1) NOT NULL default '1',
`tic_7` int(1) NOT NULL default '1',
`tic_8` int(1) NOT NULL default '1',
`oth_6` char(1) collate latin1_general_ci NOT NULL default '1',
`oth_7` char(1) collate latin1_general_ci NOT NULL default '1',
`oth_8` int(5) NOT NULL default '1',
`cal` varchar(10) collate latin1_general_ci NOT NULL default '',
`sort` int(5) NOT NULL default '0',
`oth_9` int(5) NOT NULL default '1',
`oth_10` int(1) NOT NULL default '1',
`oth_11` int(1) NOT NULL default '1',
`related_tickets` int(1) NOT NULL default '1',
`related_kb` int(1) NOT NULL default '1',
`replyredirect` int(1) NOT NULL default '0',
`reverseposts` int(1) NOT NULL default '0',
`adm_1` int(1) NOT NULL default '1',
`adm_2` int(1) NOT NULL default '1',
`adm_3` int(1) NOT NULL default '1',
`disp_8` int(1) NOT NULL default '0',
`notify_4` int(1) NOT NULL default '0',
`disp_fields` text collate latin1_general_ci,
`disp_9` int(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tt_admin`
--
LOCK TABLES `tt_admin` WRITE;
/*!40000 ALTER TABLE `tt_admin` DISABLE KEYS */;
INSERT INTO `tt_admin` VALUES (1,1,'admin','e7a8b5521fc4728ce86e4ca8abc58d45','Prefix Management','supporttrioadmin@prefix.co.za','','0000-00-00',0,'2009-06-18','15:44:51','Kind Regards,\r\n\r\nAdmin Team\r\nOffice: +27 11 447 6147\r\nFax: +27 11 880 0994\r\nWeb: www.prefix.co.za',1,1,1,1,1,1,1,60,15,'',1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,50,0,1,1,0,0,'+','english',1,1,1,1,1,'1','1',1,'',0,1,1,1,1,1,0,0,1,1,1,1,0,NULL,0),(2,2,'josh','409e20b35c3f825ead6f339910e0eba8','Josh Adler','josh@prefix.co.za','Director','2007-01-19',0,'2009-11-11','17:44:45','Kind Regards,\r\n\r\nJosh Adler\r\nOffice: +27 11 447 6147\r\nFax: +27 11 880 0994\r\nWeb: www.prefix.co.za',1,1,1,1,1,1,1,600,30,'',1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,30,1,1,1,0,0,'+','english',1,1,1,1,1,'1','1',1,'',0,1,1,1,1,1,0,0,1,1,1,1,0,'',1),(18,18,'martin','dc563bf86d935cc5eab71abf726c9bc1','Martin Schuch','martin@prefix.co.za','','2007-11-02',0,'2009-08-20','11:43:03','Kind Regards,\r\n\r\nMartin Schuch\r\nOffice: +27 11 447 6147\r\nFax: +27 11 880 0994\r\nWeb: www.prefix.co.za',1,1,1,1,1,1,1,60,15,'',1,1,1,0,0,0,0,0,0,1,1,1,1,1,1,0,0,15,0,1,1,0,0,'','',1,1,1,1,1,'1','1',0,'',0,0,0,0,1,1,0,0,0,0,0,0,0,NULL,0),(4,4,'sam','87dd9ce404eaaf442714f62ebe60fa26','Sam Hutchinson','sam@prefix.co.za','Chief Architect','2007-01-19',0,'2009-11-16','12:51:38','Kind Regards,\r\n\r\nSam Hutchinson\r\nOffice: +27 11 447 6147\r\nFax: +27 11 880 0994\r\nWeb: www.prefix.co.za',1,1,1,1,1,1,1,60,15,'',1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,15,0,1,1,0,0,'+','english',1,1,1,1,1,'1','1',1,'',0,1,1,1,1,1,0,0,1,1,1,0,0,NULL,0),(19,19,'brian','f3c1a9d108829c4546f1c133beb813d8','Brian Gouws','brian@prefix.co.za','Developer','2007-11-02',0,'2009-10-23','12:50:53','Kind Regards,\r\n\r\nBrian Gouws\r\nOffice: +27 11 447 6147\r\nFax: +27 11 880 0994\r\nWeb: www.prefix.co.za',1,1,1,1,1,1,1,60,15,'',1,1,1,0,0,0,0,0,0,1,1,1,1,1,1,0,0,15,0,0,1,0,0,'','',1,1,1,1,1,'1','1',0,'',0,0,0,0,1,1,0,0,0,0,0,0,0,NULL,0),(6,6,'keith','1a1dc91c907325c69271ddf0c944bc72','Keith Thompson','keith@prefix.co.za','','2007-01-19',0,'2009-08-05','14:14:33','Kind Regards,\r\n\r\nKeith Thompson\r\nOffice: +27 11 447 6147\r\nFax: +27 11 880 0994\r\nWeb: www.prefix.co.za',1,1,1,1,1,1,1,60,15,'',1,1,1,0,0,0,0,0,0,1,1,1,1,1,1,1,1,15,0,1,1,0,0,'','',1,1,1,1,1,'1','1',1,'',0,1,1,1,1,1,0,0,0,0,0,0,0,NULL,0),(16,16,'abubakr','6d2ff74bdff6185f2e53793adce069f9','Abubakr Snyders','abubakr@prefix.co.za','Mr','2007-09-26',0,'2009-06-19','08:08:15','Kind Regards,\r\n\r\nAbubakr Snyders\r\nOffice: +27 11 447 6147\r\nFax: +27 11 880 0994\r\nWeb: www.prefix.co.za',1,1,1,1,1,1,1,60,15,'',1,1,1,0,0,0,0,0,0,1,1,1,1,1,0,0,0,15,1,1,1,0,0,'+','english',1,1,1,1,1,'1','0',0,'',0,0,0,0,1,1,0,0,0,0,0,0,0,NULL,0),(8,8,'reception','1da95b279fc0d21024cece2c68a4c200','Gillian M Biggar','reception@prefix.co.za','Office Manager','2007-01-19',0,'2009-11-20','15:19:00','Kind Regards,\r\n\r\nPrefix Technologies Accounts\r\nOffice: +27 11 447 6147\r\nFax: +27 11 880 0994\r\nWeb: www.prefix.co.za',1,1,1,1,1,1,1,600,25,'',1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,50,1,1,1,0,0,'+','english',1,1,1,1,1,'1','1',1,'',0,1,1,1,1,1,1,0,1,1,1,1,1,'',0),(23,20,'gerharde','7466458f66057ea6f84b341cec9322c7','Gerhard Engelbrecht','gerhard@prefix.co.za','Mr','2008-02-26',0,'2009-11-23','07:18:14','Kind Regards,\r\n\r\nGerhard Engelbrecht\r\nOffice: +27 11 447 6147\r\nFax: +27 11 880 0994\r\nWeb: www.prefix.co.za',1,1,1,1,1,1,1,60,15,'',1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,15,1,1,1,0,0,'+','english',1,1,1,1,1,'1','1',1,'',0,1,1,1,1,1,0,0,1,1,1,0,1,NULL,0),(12,12,'given','45d07b00b0188a892509950ff919e14e','Given Moila','given@prefix.co.za','','2007-01-19',0,'2009-09-07','12:27:26','Kind Regards,\r\n\r\nGiven Moila\r\nOffice: +27 11 447 6147\r\nFax: +27 11 880 0994\r\nWeb: www.prefix.co.za',1,1,1,1,1,1,1,60,15,'',1,1,1,0,0,0,0,0,0,1,1,1,1,1,1,1,1,15,0,1,1,1,0,'+','english',1,1,1,1,1,'0','1',1,'',0,1,1,1,1,1,0,0,0,0,0,0,0,NULL,0),(14,14,'jacques','1a1dc91c907325c69271ddf0c944bc72','Jacques Hechter','jacques@prefix.co.za','Sales & Marketing','2007-04-19',0,'2009-11-19','13:35:12','Kind Regards,\r\n\r\nJacques Hechter\r\nOffice: +27 11 447 6147\r\nFax: +27 11 880 0994\r\nWeb: www.prefix.co.za',1,1,1,1,1,1,1,60,15,'',1,1,1,0,0,0,0,0,0,1,1,1,1,1,1,1,1,25,1,1,1,0,0,'+','english',1,1,1,1,1,'1','1',1,'',0,1,1,1,1,1,1,0,0,0,0,1,1,NULL,0),(15,15,'paulo','f9c1fa62f0088fe6ad5b9082f99c008a','Paulo Moreira','paulo@prefix.co.za','','2007-05-28',0,'2009-11-13','09:51:08','Kind Regards,\r\n\r\nPaulo Moreira\r\nOffice: +27 11 447 6147\r\nFax: +27 11 880 0994\r\nWeb: www.prefix.co.za',1,1,1,1,1,1,1,60,15,'',1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,15,1,1,1,0,0,'','',1,1,1,1,1,'1','1',1,'',0,1,1,1,1,1,0,0,0,0,0,0,1,NULL,0),(24,21,'etienne','2c0070c0d7af7f34190b02669aa14b9f','Etienne Stemmet','etienne@prefix.co.za','','2009-01-30',0,'2009-10-29','09:03:18','Kind Regards,\r\n\r\nEtienne Stemmet\r\nOffice: +27 11 447 6147\r\nFax: +27 11 880 0994\r\nWeb: www.prefix.co.za',1,1,1,1,1,1,1,60,15,'',1,1,1,0,0,0,0,0,0,0,0,0,1,1,0,0,0,15,0,0,1,0,0,'','',1,1,1,1,1,'0','0',0,'',0,0,0,0,1,1,0,0,0,0,0,0,0,NULL,0),(25,22,'lidia','a871a85ccefea13d5ccfecb02f656a04','Lidia Mentz','lidia.m@prefix.co.za','','2009-01-30',0,'2009-11-02','11:00:55','Kind Regards,\r\n\r\nLidia Mentz\r\nOffice: +27 11 447 6147\r\nFax: +27 11 880 0994\r\nWeb: www.prefix.co.za',1,1,1,1,1,1,1,60,15,'',1,1,1,0,0,0,0,0,0,0,0,0,1,1,0,0,0,15,0,1,1,0,0,'','',1,1,1,1,1,'0','0',0,'',0,0,0,0,1,1,0,0,0,0,0,0,0,NULL,0),(26,23,'lydia','37fae78f51338091b7c73d2a011b46a1','Lydia Byarugaba','lydia.b@prefix.co.za','','2009-01-30',0,'2009-11-20','12:28:34','Kind Regards,\r\n\r\nLydia Byarugaba\r\nOffice: +27 11 447 6147\r\nFax: +27 11 880 0994\r\nWeb: www.prefix.co.za',1,1,1,1,1,1,1,60,15,'',1,1,1,1,1,1,1,1,1,0,0,0,1,1,0,0,0,15,1,1,1,0,0,'','',1,1,1,1,1,'0','0',0,'',0,0,0,0,1,1,0,0,0,0,0,0,0,NULL,0);
/*!40000 ALTER TABLE `tt_admin` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tt_admin_b_log`
--
DROP TABLE IF EXISTS `tt_admin_b_log`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tt_admin_b_log` (
`id` int(10) NOT NULL auto_increment,
`user` varchar(250) collate latin1_general_ci NOT NULL default '',
`pass` varchar(250) collate latin1_general_ci NOT NULL default '',
`ip` varchar(250) collate latin1_general_ci NOT NULL default '',
`host` varchar(250) collate latin1_general_ci NOT NULL default '',
`time` time NOT NULL default '00:00:00',
`date` date NOT NULL default '0000-00-00',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=288 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tt_admin_b_log`
--
LOCK TABLES `tt_admin_b_log` WRITE;
/*!40000 ALTER TABLE `tt_admin_b_log` DISABLE KEYS */;
INSERT INTO `tt_admin_b_log` VALUES (1,'josh','am9zaDAx','192.168.10.12','jlaptop.prefix.local','15:46:49','2007-01-18'),(2,'admin','cGFzc3M=','192.168.10.12','jlaptop.prefix.local','15:46:55','2007-01-18'),(3,'admin','am9zaDAx','192.168.10.12','jlaptop.prefix.local','18:32:04','2007-01-18'),(4,'vince','cGFzcw==','192.168.10.15','graham.prefix.local','10:03:15','2007-01-19'),(5,'josh','am9zaDAx','192.168.10.12','jlaptop.prefix.local','08:03:17','2007-01-23'),(6,'josh','am9zaDAx','192.168.10.12','jlaptop.prefix.local','11:35:38','2007-01-23'),(7,'admin','cFthc3M=','41.243.72.56','dsl-243-72-56.telkomadsl.co.za','13:12:04','2007-02-02'),(8,'admin','cGFzcw==','41.243.72.56','dsl-243-72-56.telkomadsl.co.za','17:37:51','2007-02-02'),(9,'admin','cEB0cmlv','196.2.124.252','wbs-196-2-124-252.wbs.co.za','17:33:41','2007-02-04'),(10,'admin','cEB0cmlv','196.2.124.252','wbs-196-2-124-252.wbs.co.za','17:33:48','2007-02-04'),(11,'richardr','cmljaG1pbw==','41.243.72.56','dsl-243-72-56.telkomadsl.co.za','11:39:54','2007-02-05'),(12,'Richard','aGFtbGV0','41.243.72.56','dsl-243-72-56.telkomadsl.co.za','11:44:55','2007-02-05'),(13,'recption','cmVjZXB0aW9u','41.243.72.56','dsl-243-72-56.telkomadsl.co.za','11:58:12','2007-02-05'),(14,'tanya','cGFzcw==','41.243.72.56','dsl-243-72-56.telkomadsl.co.za','09:27:48','2007-02-06'),(15,'tanya','cGFzcw==','41.243.72.56','dsl-243-72-56.telkomadsl.co.za','09:55:58','2007-02-06'),(16,'taryn','cGFzcw==','41.243.88.213','dsl-243-88-213.telkomadsl.co.za','10:08:35','2007-02-06'),(17,'taryn','cGFzcw==','41.243.88.213','dsl-243-88-213.telkomadsl.co.za','10:09:07','2007-02-06'),(18,'taryn','cGFzc3dvcmQ=','41.243.88.213','dsl-243-88-213.telkomadsl.co.za','10:09:28','2007-02-06'),(19,'taryn','cGFzcw==','41.243.88.213','dsl-243-88-213.telkomadsl.co.za','10:09:33','2007-02-06'),(20,'vince','cGFzcw==','41.243.73.111','dsl-243-73-111.telkomadsl.co.za','16:01:26','2007-02-06'),(21,'sam','czFtcGwz','196.2.124.252','wbs-196-2-124-252.wbs.co.za','21:07:35','2007-02-07'),(22,'taryn','cGFzc3dvcmQ=','41.241.217.2','dsl-241-217-02.telkomadsl.co.za','15:33:50','2007-02-08'),(23,'taryn','cGFzc3dvcmQ=','41.241.217.2','dsl-241-217-02.telkomadsl.co.za','15:33:59','2007-02-08'),(24,'reception','cmVjZXB0b24=','41.243.245.249','dsl-243-245-249.telkomadsl.co.za','10:14:18','2007-02-12'),(25,'sam','cGFzc3A=','196.38.237.131','isadsltwo.engineeringnews.co.za','10:52:03','2007-02-12'),(26,'recepton','cmVjZXB0b24=','41.243.245.249','dsl-243-245-249.telkomadsl.co.za','11:32:55','2007-02-12'),(27,'admin','cGFzcw==','196.2.124.252','wbs-196-2-124-252.wbs.co.za','20:48:22','2007-02-12'),(28,'sam','cGFzc3A=','196.2.124.252','wbs-196-2-124-252.wbs.co.za','20:48:24','2007-02-12'),(29,'sam','cGFzc3A=','196.2.124.252','wbs-196-2-124-252.wbs.co.za','21:03:49','2007-02-12'),(30,'caroline@totalexposure.co.za','NDk1OTU1Nw==','41.243.245.249','dsl-243-245-249.telkomadsl.co.za','11:24:20','2007-02-13'),(31,'gerhard','Z2VyaGFyZDAx','41.243.245.249','dsl-243-245-249.telkomadsl.co.za','12:27:16','2007-02-13'),(32,'reception','','41.243.245.249','dsl-243-245-249.telkomadsl.co.za','11:02:11','2007-02-14'),(33,'reeception','cmVjZXB0aW9u','41.243.245.249','dsl-243-245-249.telkomadsl.co.za','13:30:04','2007-02-14'),(34,'reception','cmVjZXB0b24=','41.243.245.249','dsl-243-245-249.telkomadsl.co.za','13:30:18','2007-02-14'),(35,'josh','cGFzcw==','41.243.245.249','dsl-243-245-249.telkomadsl.co.za','16:24:46','2007-02-14'),(36,'tanya','cGFzcw==','41.243.245.249','dsl-243-245-249.telkomadsl.co.za','15:03:20','2007-02-15'),(37,'given','cGFzcw==','41.243.245.249','dsl-243-245-249.telkomadsl.co.za','08:46:10','2007-02-19'),(38,'given','cGFzcw==','41.243.245.249','dsl-243-245-249.telkomadsl.co.za','14:02:59','2007-02-19'),(39,'tanya','cGFzcw==','41.243.245.249','dsl-243-245-249.telkomadsl.co.za','11:09:59','2007-02-20'),(40,'reception','cmVjZXB0b24=','41.243.245.249','dsl-243-245-249.telkomadsl.co.za','12:35:41','2007-02-20'),(41,'admin','cHIzZml4Iw==','41.243.245.249','dsl-243-245-249.telkomadsl.co.za','13:21:56','2007-02-21'),(42,'given','','41.243.245.249','dsl-243-245-249.telkomadsl.co.za','13:25:36','2007-02-21'),(43,'gerhard','Z2VyaGFyZDAx','41.243.245.249','dsl-243-245-249.telkomadsl.co.za','14:08:08','2007-02-22'),(44,'given','','41.243.245.249','dsl-243-245-249.telkomadsl.co.za','11:19:51','2007-02-23'),(45,'given','cGFzcw==','41.243.193.227','dsl-243-193-227.telkomadsl.co.za','09:01:47','2007-02-27'),(46,'given','','41.243.193.227','dsl-243-193-227.telkomadsl.co.za','11:06:23','2007-02-27'),(47,'josh','am9zaDAx','41.243.202.126','dsl-243-202-126.telkomadsl.co.za','10:31:48','2007-02-28'),(48,'josh','TVJfQ09MIQ==','41.243.199.160','dsl-243-199-160.telkomadsl.co.za','09:26:58','2007-03-02'),(49,'tanya','cGFzcw==','41.243.199.160','dsl-243-199-160.telkomadsl.co.za','15:26:28','2007-03-02'),(50,'given','cGFzcw==','41.243.216.40','dsl-243-216-40.telkomadsl.co.za','08:31:50','2007-03-05'),(51,'josh','am9zaDAx','41.243.216.40','dsl-243-216-40.telkomadsl.co.za','11:05:36','2007-03-05'),(52,'josh','bXJfY29vbEAh','41.243.216.40','dsl-243-216-40.telkomadsl.co.za','11:05:40','2007-03-05'),(53,'given','cGFzcw==','41.243.220.83','dsl-243-220-83.telkomadsl.co.za','08:27:47','2007-03-08'),(54,'Richard','cG9vZGxl','41.243.220.83','dsl-243-220-83.telkomadsl.co.za','13:57:07','2007-03-09'),(55,'Richard','aGFtbGV0','41.243.220.83','dsl-243-220-83.telkomadsl.co.za','13:57:15','2007-03-09'),(56,'Richard','cGFzcw==','41.243.220.83','dsl-243-220-83.telkomadsl.co.za','13:57:20','2007-03-09'),(57,'richardr','cG9vZGxlMw==','41.243.220.83','dsl-243-220-83.telkomadsl.co.za','13:58:03','2007-03-09'),(58,'richardr','cmljaG1pbw==','41.243.220.83','dsl-243-220-83.telkomadsl.co.za','14:05:49','2007-03-09'),(59,'Richard','SGFtbGV0','41.243.220.83','dsl-243-220-83.telkomadsl.co.za','14:06:01','2007-03-09'),(60,'Richard','UG9vZGxl','41.243.220.83','dsl-243-220-83.telkomadsl.co.za','14:06:08','2007-03-09'),(61,'Richard','UG9vZGxl','41.243.220.83','dsl-243-220-83.telkomadsl.co.za','10:36:26','2007-03-12'),(62,'Richard','cGFzcw==','41.243.220.83','dsl-243-220-83.telkomadsl.co.za','10:38:27','2007-03-12'),(63,'Richard','UG9vZGxl','41.243.220.83','dsl-243-220-83.telkomadsl.co.za','10:38:34','2007-03-12'),(64,'RIchard','UG9vZGxl','41.243.220.83','dsl-243-220-83.telkomadsl.co.za','10:38:43','2007-03-12'),(65,'Richard','SGFtbGV0','41.243.220.83','dsl-243-220-83.telkomadsl.co.za','10:52:33','2007-03-12'),(66,'Richard','aGFtbGV0','41.243.220.83','dsl-243-220-83.telkomadsl.co.za','11:31:59','2007-03-12'),(67,'admin','cGFzcw==','41.243.220.83','dsl-243-220-83.telkomadsl.co.za','11:50:22','2007-03-12'),(68,'josh','am9zaDAx','41.243.220.83','dsl-243-220-83.telkomadsl.co.za','11:50:30','2007-03-12'),(69,'Richard','cGFzcw==','41.243.220.83','dsl-243-220-83.telkomadsl.co.za','11:50:41','2007-03-12'),(70,'Richard','cGFzcw==','41.243.220.83','dsl-243-220-83.telkomadsl.co.za','11:53:53','2007-03-12'),(71,'Richard','d3Jvbmc=','41.243.220.83','dsl-243-220-83.telkomadsl.co.za','12:26:11','2007-03-12'),(72,'Richard','d3Jvbmc=','41.243.220.83','dsl-243-220-83.telkomadsl.co.za','12:30:09','2007-03-12'),(73,'richard','cGFzcw==','41.243.220.83','dsl-243-220-83.telkomadsl.co.za','12:31:11','2007-03-12'),(74,'richard','cGFzcw==','41.243.220.83','dsl-243-220-83.telkomadsl.co.za','12:31:24','2007-03-12'),(75,'josh','am9zaDAx','41.208.223.225','wbs-41-208-223-225.wbs.co.za','22:19:35','2007-03-12'),(76,'gerhard','Z2VyaGFyZDAx','41.243.244.141','dsl-243-244-141.telkomadsl.co.za','15:02:38','2007-03-26'),(77,'gerhard','Z2VyaGFyZDAx','41.243.244.141','dsl-243-244-141.telkomadsl.co.za','15:02:46','2007-03-26'),(78,'given','cGFzcw==','41.243.244.141','dsl-243-244-141.telkomadsl.co.za','16:59:35','2007-04-02'),(79,'gerhard','Z2VyaGFyZDAx','41.243.244.141','dsl-243-244-141.telkomadsl.co.za','13:37:43','2007-04-03'),(80,'gerhard','Z2VyaGFyZDAx','41.243.216.216','dsl-243-216-216.telkomadsl.co.za','12:02:33','2007-04-13'),(81,'given','cGFzcw==','41.243.207.45','dsl-243-207-45.telkomadsl.co.za','11:46:55','2007-04-17'),(82,'taryn','cGFzc3dvcmQ=','41.243.219.58','dsl-243-219-58.telkomadsl.co.za','08:25:54','2007-04-18'),(83,'jacques','bWFsbGFnaGVy','41.243.219.58','dsl-243-219-58.telkomadsl.co.za','13:39:32','2007-04-19'),(84,'jacques','bWFsbGFnaGVy','41.243.219.58','dsl-243-219-58.telkomadsl.co.za','13:40:23','2007-04-19'),(85,'jacques','amFjcXVlczAx','41.243.219.58','dsl-243-219-58.telkomadsl.co.za','13:44:01','2007-04-19'),(86,'jacques','amFjcXVlczAx','41.243.229.67','dsl-243-229-67.telkomadsl.co.za','08:16:41','2007-04-20'),(87,'jacques','amFjcXVlczAx','41.243.229.67','dsl-243-229-67.telkomadsl.co.za','08:17:22','2007-04-20'),(88,'given','cGFzcw==','41.243.229.67','dsl-243-229-67.telkomadsl.co.za','08:58:04','2007-04-24'),(89,'josh','bV9jb29sIQ==','41.243.229.67','dsl-243-229-67.telkomadsl.co.za','07:22:09','2007-04-26'),(90,'jacquers','','41.243.229.67','dsl-243-229-67.telkomadsl.co.za','09:21:42','2007-05-03'),(91,'jacques','amFjcXVlczAx','41.243.229.67','dsl-243-229-67.telkomadsl.co.za','09:21:53','2007-05-03'),(92,'jacques','ZGVtbw==','41.243.229.67','dsl-243-229-67.telkomadsl.co.za','09:22:03','2007-05-03'),(93,'jacques','','41.243.254.127','dsl-243-254-127.telkomadsl.co.za','08:43:44','2007-05-07'),(94,'r','','41.243.254.127','dsl-243-254-127.telkomadsl.co.za','18:42:22','2007-05-07'),(95,'richard','cG9vZGxl','41.243.254.127','dsl-243-254-127.telkomadsl.co.za','18:42:29','2007-05-07'),(96,'given','cGFzcw==','41.243.223.61','dsl-243-223-61.telkomadsl.co.za','09:26:47','2007-05-10'),(97,'admin','cGFzcw==','41.243.223.61','dsl-243-223-61.telkomadsl.co.za','10:15:42','2007-05-14'),(98,'josh','bWFraW5nX3R1bmVzIQ==','41.243.223.61','dsl-243-223-61.telkomadsl.co.za','10:24:58','2007-05-16'),(99,'reception','','41.243.252.193','dsl-243-252-193.telkomadsl.co.za','08:36:42','2007-05-18'),(100,'josh','am9zaDAx','41.243.252.193','dsl-243-252-193.telkomadsl.co.za','17:25:12','2007-05-22'),(101,'josh','am9zaDAx','41.243.252.193','dsl-243-252-193.telkomadsl.co.za','09:27:59','2007-05-23'),(102,'jacques01','','41.243.252.54','dsl-243-252-54.telkomadsl.co.za','14:59:46','2007-05-25'),(103,'jacques','','41.243.252.54','dsl-243-252-54.telkomadsl.co.za','12:02:23','2007-05-31'),(104,'jacques','cGFz','41.243.248.61','dsl-243-248-61.telkomadsl.co.za','10:58:10','2007-06-01'),(105,'josh','bXJfY29vbCEgIA==','41.243.248.61','dsl-243-248-61.telkomadsl.co.za','11:34:05','2007-06-01'),(106,'jacques01','cGFzcw==','41.243.248.61','dsl-243-248-61.telkomadsl.co.za','16:10:24','2007-06-04'),(107,'given0522','','41.243.248.61','dsl-243-248-61.telkomadsl.co.za','09:18:27','2007-06-08'),(108,'paulo','cGFzcw==','41.243.248.61','dsl-243-248-61.telkomadsl.co.za','10:31:38','2007-06-11'),(109,'given','cGFzcw==','41.243.248.61','dsl-243-248-61.telkomadsl.co.za','10:37:06','2007-06-11'),(110,'given','cGFzcw==','41.243.248.61','dsl-243-248-61.telkomadsl.co.za','12:03:33','2007-06-12'),(111,'phash','ODMwNDIy','41.243.236.204','dsl-243-236-204.telkomadsl.co.za','08:38:45','2007-06-19'),(112,'jacques','YXNzcw==','41.243.236.204','dsl-243-236-204.telkomadsl.co.za','15:43:23','2007-06-19'),(113,'paulo','cGFzcw==','41.243.236.204','dsl-243-236-204.telkomadsl.co.za','16:41:32','2007-06-19'),(114,'jacques01','cGFzcw==','41.243.238.228','dsl-243-238-228.telkomadsl.co.za','12:33:14','2007-06-27'),(115,'josh','am9zaDAx','196.212.16.178','196.212.16.178','10:16:32','2007-06-28'),(116,'given','cGFzc3M=','41.243.219.145','dsl-243-219-145.telkomadsl.co.za','15:36:55','2007-07-02'),(117,'jacques','','41.243.219.145','dsl-243-219-145.telkomadsl.co.za','15:43:40','2007-07-06'),(118,'paulo','cGFzcw==','41.243.219.145','dsl-243-219-145.telkomadsl.co.za','13:40:32','2007-07-12'),(119,'given','cGFzcw==','41.243.201.156','dsl-243-201-156.telkomadsl.co.za','09:14:19','2007-07-18'),(120,'given','bTAxNzg0','41.243.201.156','dsl-243-201-156.telkomadsl.co.za','09:14:35','2007-07-18'),(121,'jacques','cGFzc3M=','41.243.201.156','dsl-243-201-156.telkomadsl.co.za','11:51:40','2007-07-18'),(122,'given','cGFzcw==','41.243.201.156','dsl-243-201-156.telkomadsl.co.za','09:08:04','2007-07-20'),(123,'paulo','cGFzcw==','41.243.201.156','dsl-243-201-156.telkomadsl.co.za','17:00:40','2007-07-23'),(124,'josh','bXJfY29vbCFtcl9jb29sIQ==','41.243.238.85','dsl-243-238-85.telkomadsl.co.za','14:57:04','2007-07-25'),(125,'paulo','cHVsbzAx','41.243.238.85','dsl-243-238-85.telkomadsl.co.za','15:49:59','2007-07-25'),(126,'paulo','cGFzcw==','41.243.225.129','dsl-243-225-129.telkomadsl.co.za','16:01:57','2007-08-06'),(127,'paulo','cGFzcw==','41.243.225.129','dsl-243-225-129.telkomadsl.co.za','08:53:20','2007-08-07'),(128,'thyhy','Z3RidHlueXRieXRybg==','41.243.225.129','dsl-243-225-129.telkomadsl.co.za','14:23:28','2007-08-08'),(129,'gerhard','cGFzc1xc','41.243.225.129','dsl-243-225-129.telkomadsl.co.za','15:48:05','2007-08-15'),(130,'josh','bXJfY29vbCFtcl9jb29sIQ==','41.243.249.159','dsl-243-249-159.telkomadsl.co.za','13:25:07','2007-08-17'),(131,'paulo','cGFzcw==','41.243.213.128','dsl-243-213-128.telkomadsl.co.za','10:34:34','2007-08-29'),(132,'paulo','cGF1bG8wMg==','41.243.192.48','dsl-243-192-48.telkomadsl.co.za','10:31:17','2007-08-30'),(133,'sa','','196.2.124.253','wbs-196-2-124-253.wbs.co.za','21:07:14','2007-09-03'),(134,'admin','cHRyaW8h','41.243.222.214','dsl-243-222-214.telkomadsl.co.za','22:13:20','2007-09-06'),(135,'admin','cFRyaW8h','41.243.222.214','dsl-243-222-214.telkomadsl.co.za','22:13:33','2007-09-06'),(136,'paulo01','','41.243.192.48','dsl-243-192-48.telkomadsl.co.za','08:59:42','2007-09-10'),(137,'paulo','cGFpbG8wMQ==','41.243.255.223','dsl-243-255-223.telkomadsl.co.za','09:02:06','2007-09-11'),(138,'ADMIN','UCFUUklP','41.243.255.223','dsl-243-255-223.telkomadsl.co.za','13:18:52','2007-09-20'),(139,'sam','c2FtMDE=','41.243.255.223','dsl-243-255-223.telkomadsl.co.za','13:46:57','2007-09-21'),(140,'sam','c2FtMDE=','41.243.255.223','dsl-243-255-223.telkomadsl.co.za','13:47:12','2007-09-21'),(141,'sam','c2FtMDE=','41.243.255.223','dsl-243-255-223.telkomadsl.co.za','13:54:14','2007-09-21'),(142,'sam','czFtcGwz','41.243.255.223','dsl-243-255-223.telkomadsl.co.za','13:54:22','2007-09-21'),(143,'sam','c2FtMDE=','41.243.255.223','dsl-243-255-223.telkomadsl.co.za','13:54:34','2007-09-21'),(144,'jacques','aGVjaHRlcg==','41.243.255.223','dsl-243-255-223.telkomadsl.co.za','14:18:14','2007-09-21'),(145,'jacques','cGFz','41.243.255.223','dsl-243-255-223.telkomadsl.co.za','14:18:19','2007-09-21'),(146,'jacques','UEFTUw==','41.243.255.223','dsl-243-255-223.telkomadsl.co.za','11:17:08','2007-09-25'),(147,'josh','am9zaDAx','41.243.255.223','dsl-243-255-223.telkomadsl.co.za','17:03:34','2007-09-26'),(148,'josh','am9zaDAx','41.243.255.223','dsl-243-255-223.telkomadsl.co.za','19:05:59','2007-09-26'),(149,'josh','am9zaDAx','41.243.225.87','dsl-243-225-87.telkomadsl.co.za','11:28:02','2007-09-27'),(150,'given','cGFzcw==','41.243.240.157','dsl-243-240-157.telkomadsl.co.za','10:08:55','2007-09-28'),(151,'sd','','41.243.240.157','dsl-243-240-157.telkomadsl.co.za','10:57:39','2007-09-28'),(152,'','','41.243.240.157','dsl-243-240-157.telkomadsl.co.za','10:57:43','2007-09-28'),(153,'me','','41.243.240.157','dsl-243-240-157.telkomadsl.co.za','10:57:47','2007-09-28'),(154,'login afj','','41.243.240.157','dsl-243-240-157.telkomadsl.co.za','10:57:52','2007-09-28'),(155,'andries','YW5kaXJlczAx','41.243.240.157','dsl-243-240-157.telkomadsl.co.za','09:13:09','2007-10-02'),(156,'andries','YW5kaXJlczAx','41.243.240.157','dsl-243-240-157.telkomadsl.co.za','09:13:18','2007-10-02'),(157,'paulo','cGF1bG8wMg==','41.243.229.78','dsl-243-229-78.telkomadsl.co.za','11:18:53','2007-10-03'),(158,'paulo','cGFzcw==','41.243.222.242','dsl-243-222-242.telkomadsl.co.za','16:12:30','2007-10-09'),(159,'paulo','cGFzcw==','41.243.222.242','dsl-243-222-242.telkomadsl.co.za','10:44:29','2007-10-15'),(160,'andries','YW5kcmllcw==','41.243.222.242','dsl-243-222-242.telkomadsl.co.za','12:20:56','2007-10-15'),(161,'jacques','b2Fzcw==','41.243.222.242','dsl-243-222-242.telkomadsl.co.za','12:34:12','2007-10-15'),(162,'andries','YW1kcm9lczAx','41.243.246.88','dsl-243-246-88.telkomadsl.co.za','09:45:54','2007-10-16'),(163,'sam','cGFzcw==','41.243.236.144','dsl-243-236-144.telkomadsl.co.za','16:32:03','2007-10-25'),(164,'sam','cGFzcw==','41.243.236.144','dsl-243-236-144.telkomadsl.co.za','16:32:07','2007-10-25'),(165,'sam','cGFzcw==','41.243.236.144','dsl-243-236-144.telkomadsl.co.za','16:32:14','2007-10-25'),(166,'andries','YW5kcmlkczAx','41.243.205.10','dsl-243-205-10.telkomadsl.co.za','09:00:21','2007-11-02'),(167,'keith','a2VpdGgwMQ==','41.243.224.6','dsl-243-224-06.telkomadsl.co.za','13:23:39','2007-11-07'),(168,'given','MDUy','41.243.224.6','dsl-243-224-06.telkomadsl.co.za','08:43:30','2007-11-08'),(169,'','','41.243.233.9','dsl-243-233-09.telkomadsl.co.za','13:23:23','2007-11-16'),(170,'reception','cmVjZXB0aW9ucmVjZXB0aW9u','41.243.219.189','dsl-243-219-189.telkomadsl.co.za','11:24:26','2007-11-20'),(171,'paulo01','','41.243.218.225','dsl-243-218-225.telkomadsl.co.za','10:43:30','2007-11-22'),(172,'admin','','196.2.124.253','wbs-196-2-124-253.wbs.co.za','22:46:05','2007-11-29'),(173,'admin','cCF0cmlvIQ==','41.243.242.53','dsl-243-242-53.telkomadsl.co.za','12:51:49','2008-01-03'),(174,'paulo','cGF1bG8w','41.243.241.111','dsl-243-241-111.telkomadsl.co.za','11:34:52','2008-01-15'),(175,'sam','cGFzcw==','41.243.226.80','dsl-243-226-80.telkomadsl.co.za','10:47:34','2008-01-31'),(176,'given','MDUyNTI=','41.243.207.0','dsl-243-207-00.telkomadsl.co.za','16:55:42','2008-02-06'),(177,'paulo','cGFzcw==','41.243.207.0','dsl-243-207-00.telkomadsl.co.za','09:49:57','2008-02-11'),(178,'keith','a2VpdGgwMQ==','41.243.207.0','dsl-243-207-00.telkomadsl.co.za','14:07:52','2008-02-12'),(179,'given','','41.243.207.0','dsl-243-207-00.telkomadsl.co.za','10:05:50','2008-02-14'),(180,'given','MDUyMjM=','41.243.244.224','dsl-243-244-224.telkomadsl.co.za','10:18:39','2008-02-18'),(181,'reception','cmVjZXB0aW9t','41.243.244.224','dsl-243-244-224.telkomadsl.co.za','12:29:10','2008-02-18'),(182,'reception','cmVjZXB0aW9t','41.243.244.224','dsl-243-244-224.telkomadsl.co.za','12:29:19','2008-02-18'),(183,'jacques','cGFz','41.243.244.224','dsl-243-244-224.telkomadsl.co.za','13:28:58','2008-02-25'),(184,'gerhard','Z2VyaGFyZDAx','41.243.244.224','dsl-243-244-224.telkomadsl.co.za','08:35:54','2008-02-26'),(185,'gerhard','Z2VyaGFyZDAx','41.243.244.224','dsl-243-244-224.telkomadsl.co.za','08:36:58','2008-02-26'),(186,'admin','cGFzcw==','41.243.244.224','dsl-243-244-224.telkomadsl.co.za','08:42:48','2008-02-26'),(187,'admin','cGFzcw==','41.243.244.224','dsl-243-244-224.telkomadsl.co.za','08:42:53','2008-02-26'),(188,'given','','41.243.244.224','dsl-243-244-224.telkomadsl.co.za','12:02:50','2008-02-26'),(189,'given','MDUy','41.243.244.224','dsl-243-244-224.telkomadsl.co.za','12:02:57','2008-02-26'),(190,'gerharde','Z2VyaGFyZGU5MDE=','41.243.244.224','dsl-243-244-224.telkomadsl.co.za','12:15:59','2008-02-26'),(191,'given','YDA1MjI=','41.243.244.224','dsl-243-244-224.telkomadsl.co.za','13:52:13','2008-02-26'),(192,'admin','cGFzcw==','41.243.244.224','dsl-243-244-224.telkomadsl.co.za','15:27:26','2008-02-26'),(193,'gerharde','Z2FlcmhhcmRlMDE=','41.243.244.224','dsl-243-244-224.telkomadsl.co.za','15:29:58','2008-02-26'),(194,'admin','cGFzcw==','196.2.124.253','wbs-196-2-124-253.wbs.co.za','21:50:31','2008-02-26'),(195,'admin','cGFzcw==','196.2.124.253','wbs-196-2-124-253.wbs.co.za','17:46:49','2008-03-02'),(196,'given','MDUy','41.243.210.32','dsl-243-210-32.telkomadsl.co.za','10:24:38','2008-03-11'),(197,'given','cGFzcw==','41.243.210.32','dsl-243-210-32.telkomadsl.co.za','16:39:47','2008-03-14'),(198,'admin','cGFzcw==','41.243.252.102','dsl-243-252-102.telkomadsl.co.za','09:13:33','2008-03-19'),(199,'given','cGFzcw==','41.243.252.102','dsl-243-252-102.telkomadsl.co.za','16:47:15','2008-03-19'),(200,'gerharde01','Z2VyaGFyZGUwMQ==','41.243.226.149','dsl-243-226-149.telkomadsl.co.za','07:19:53','2008-03-31'),(201,'gerhard','Z2VyaHJhZDAx','41.243.226.149','dsl-243-226-149.telkomadsl.co.za','07:20:04','2008-03-31'),(202,'gerharde','Z2VyaGFyZDAx','41.243.226.149','dsl-243-226-149.telkomadsl.co.za','07:20:44','2008-03-31'),(203,'paulopaulo01','cGF1bG8wMQ==','196.207.47.60','vc-196-207-47-60.3g.vodacom.co.za','17:32:59','2008-04-05'),(204,'admin','cGFzcw==','41.243.192.231','dsl-243-192-231.telkomadsl.co.za','10:46:56','2008-04-07'),(205,'admin','cCF0bm8=','41.243.199.142','dsl-243-199-142.telkomadsl.co.za','09:00:26','2008-05-06'),(206,'admin','cGFzcw==','196.2.124.254','wbs-196-2-124-254.wbs.co.za','21:40:28','2008-05-06'),(207,'admin','dWIzcm1hMWwzcg==','41.243.199.142','dsl-243-199-142.telkomadsl.co.za','14:59:20','2008-05-08'),(208,'sam','czFtcGwz','41.243.212.213','dsl-243-212-213.telkomadsl.co.za','17:25:07','2008-05-12'),(209,'gerharde','Z2VyaGFyZDAx','41.243.212.213','dsl-243-212-213.telkomadsl.co.za','10:16:36','2008-05-14'),(210,'paulo','cGFzcw==','41.243.218.236','dsl-243-218-236.telkomadsl.co.za','16:21:50','2008-05-23'),(211,'paulo','cGFzcw==','41.243.218.236','dsl-243-218-236.telkomadsl.co.za','16:21:56','2008-05-23'),(212,'given','bW9pbGE=','41.243.196.252','dsl-243-196-252.telkomadsl.co.za','09:23:50','2008-06-17'),(213,'admin','cGFzcw==','196.2.124.254','wbs-196-2-124-254.wbs.co.za','08:06:05','2008-07-03'),(214,'paulo','cGFzcw==','41.243.203.227','dsl-243-203-227.telkomadsl.co.za','09:38:26','2008-07-10'),(215,'paulo','cGF1bG96YXE=','41.243.252.67','dsl-243-252-67.telkomadsl.co.za','09:55:25','2008-09-11'),(216,'\\','','41.243.251.226','dsl-243-251-226.telkomadsl.co.za','10:00:21','2008-09-18'),(217,'\\','','41.243.251.226','dsl-243-251-226.telkomadsl.co.za','10:00:21','2008-09-18'),(218,'','','41.243.251.226','dsl-243-251-226.telkomadsl.co.za','10:00:24','2008-09-18'),(219,'','','41.243.251.226','dsl-243-251-226.telkomadsl.co.za','10:00:24','2008-09-18'),(220,'admin','','41.243.209.35','dsl-243-209-35.telkomadsl.co.za','12:23:30','2008-09-19'),(221,'sam','czFtcGwz','41.243.209.35','dsl-243-209-35.telkomadsl.co.za','12:23:39','2008-09-19'),(222,'sam','cGFzcw==','41.243.198.102','dsl-243-198-102.telkomadsl.co.za','13:47:22','2008-09-29'),(223,'sam','cGFzcw==','196.2.124.252','wbs-196-2-124-252.wbs.co.za','23:25:23','2008-09-29'),(224,'sam','cGFzcw==','196.2.124.252','wbs-196-2-124-252.wbs.co.za','23:25:30','2008-09-29'),(225,'gerharde','Z2VyaGFyZDAx','41.243.198.102','dsl-243-198-102.telkomadsl.co.za','07:16:34','2008-10-21'),(226,'given','cGFzc3M=','41.243.222.158','dsl-243-222-158.telkomadsl.co.za','10:58:38','2008-11-11'),(227,'given','cGFzcw==','41.243.222.158','dsl-243-222-158.telkomadsl.co.za','10:58:45','2008-11-11'),(228,'admin','cGFzcw==','41.243.222.158','dsl-243-222-158.telkomadsl.co.za','09:53:00','2008-11-18'),(229,'brian','YnJpYW4x','41.177.11.181','181.11.177.41-get-oneprice-adsl-for-only-R169.cybersmart.co.za','11:02:22','2009-01-05'),(230,'given','','41.177.11.21','21.11.177.41-get-oneprice-adsl-for-only-R169.cybersmart.co.za','08:03:10','2009-01-26'),(231,'brian','Y2p+cDkxMQ==','41.177.11.21','21.11.177.41-get-oneprice-adsl-for-only-R169.cybersmart.co.za','09:56:22','2009-01-30'),(232,'brian','Y2p+cDkxMQ==','41.177.11.21','21.11.177.41-get-oneprice-adsl-for-only-R169.cybersmart.co.za','09:56:35','2009-01-30'),(233,'brian01','YnJpYW4=','41.177.11.21','21.11.177.41-get-oneprice-adsl-for-only-R169.cybersmart.co.za','09:56:51','2009-01-30'),(234,'brian1','Y2p+cDkxMQ==','41.177.11.111','111.11.177.41-get-oneprice-adsl-for-only-R169.cybersmart.co.za','09:07:04','2009-02-03'),(235,'brian','YnJpYW4x','41.177.11.111','111.11.177.41-get-oneprice-adsl-for-only-R169.cybersmart.co.za','09:07:14','2009-02-03'),(236,'brian','YnJpYW4x','41.177.11.111','111.11.177.41-get-oneprice-adsl-for-only-R169.cybersmart.co.za','09:07:22','2009-02-03'),(237,'brian','Y2p+cDkxMQ==','41.177.11.111','111.11.177.41-get-oneprice-adsl-for-only-R169.cybersmart.co.za','09:07:30','2009-02-03'),(238,'gerharde','aGVyaGFyZDAx','41.243.193.10','dsl-243-193-10.telkomadsl.co.za','08:48:04','2009-04-06'),(239,'gerharde','aGVyaGFyZGUwMQ==','41.243.193.10','dsl-243-193-10.telkomadsl.co.za','08:48:13','2009-04-06'),(240,'Lidia.m','bGlkaWEwMQ==','41.243.210.165','dsl-243-210-165.telkomadsl.co.za','15:29:26','2009-04-15'),(241,'Lidia.m','TGlkaWEubQ==','41.243.210.165','dsl-243-210-165.telkomadsl.co.za','15:29:35','2009-04-15'),(242,'Lidia.m','bGlkaWEubQ==','41.243.210.165','dsl-243-210-165.telkomadsl.co.za','15:29:44','2009-04-15'),(243,'Lidia.m','bGlkaWEwMQ==','41.243.210.165','dsl-243-210-165.telkomadsl.co.za','15:29:53','2009-04-15'),(244,'admin','dWIzcm1hMWwzcg==','41.213.13.104','iburst-41-213-13-104.iburst.co.za','17:38:48','2009-05-13'),(245,'','','41.243.206.28','dsl-243-206-28.telkomadsl.co.za','05:34:31','2009-05-14'),(246,'admin','cCF0cmlvIQ==','41.243.206.28','dsl-243-206-28.telkomadsl.co.za','23:49:26','2009-05-18'),(247,'Lidia.m','bGlkaWEwMQ==','41.243.206.28','dsl-243-206-28.telkomadsl.co.za','09:35:01','2009-05-19'),(248,'gerharde','Z2VyaHJkZTAx','41.243.241.130','dsl-243-241-130.telkomadsl.co.za','07:38:18','2009-06-01'),(249,'admin','cGFzcw==','41.243.222.213','dsl-243-222-213.telkomadsl.co.za','16:14:35','2009-06-02'),(250,'admin','cCF0cm9p','41.243.251.95','dsl-243-251-95.telkomadsl.co.za','18:09:02','2009-06-04'),(251,'jacques@prefix.co.za','amFjcXVlczAx','41.243.251.95','dsl-243-251-95.telkomadsl.co.za','13:11:54','2009-06-05'),(252,'jacques@prefix.co.za','cGFzcw==','41.243.251.95','dsl-243-251-95.telkomadsl.co.za','13:12:03','2009-06-05'),(253,'admin','cGFzcw==','41.243.251.95','dsl-243-251-95.telkomadsl.co.za','16:46:30','2009-06-10'),(254,'Lidia.m','bGlkaWEwMQ==','41.243.251.95','dsl-243-251-95.telkomadsl.co.za','10:34:55','2009-06-11'),(255,'Lidia.m','TGlkaWEubQ==','41.243.251.95','dsl-243-251-95.telkomadsl.co.za','10:35:06','2009-06-11'),(256,'Lidia','bGlkaWEwMQ==','41.243.251.95','dsl-243-251-95.telkomadsl.co.za','10:35:16','2009-06-11'),(257,'Lidia','bGlkaWE=','41.243.251.95','dsl-243-251-95.telkomadsl.co.za','10:35:24','2009-06-11'),(258,'lidia.m','bGlkaWEubTAx','41.243.251.95','dsl-243-251-95.telkomadsl.co.za','12:00:10','2009-06-11'),(259,'keith','a2VpdGgwMQ==','41.243.251.95','dsl-243-251-95.telkomadsl.co.za','13:29:05','2009-06-12'),(260,'josh','am9zaDAx','41.243.251.95','dsl-243-251-95.telkomadsl.co.za','16:43:51','2009-06-14'),(261,'sam','czFtcGwz','41.243.251.95','dsl-243-251-95.telkomadsl.co.za','19:15:40','2009-06-14'),(262,'admin','cCF0cmlvXFw=','41.243.251.95','dsl-243-251-95.telkomadsl.co.za','10:53:49','2009-06-15'),(263,'Lisa@seventeen.co.za','bGlzYTAx','41.243.251.95','dsl-243-251-95.telkomadsl.co.za','14:46:35','2009-06-18'),(264,'paulo','cGF1bG96YXE=','41.243.251.95','dsl-243-251-95.telkomadsl.co.za','10:14:15','2009-06-22'),(265,'josh','cGFzcw==','41.243.251.95','dsl-243-251-95.telkomadsl.co.za','10:26:49','2009-06-23'),(266,'jacques','amFjcXVlczAx','41.243.208.112','dsl-243-208-112.telkomadsl.co.za','16:10:54','2009-06-30'),(267,'jacques','amFjcXVlcw==','41.243.208.112','dsl-243-208-112.telkomadsl.co.za','16:11:06','2009-06-30'),(268,'jacques','cGFz','41.243.208.112','dsl-243-208-112.telkomadsl.co.za','16:11:31','2009-06-30'),(269,'Josh','bXJfY29vbCE=','91.203.96.57','f96-057.opera-mini.net','20:26:31','2009-07-03'),(270,'paulo','cGF1bG96YXE=','41.243.208.112','dsl-243-208-112.telkomadsl.co.za','15:04:24','2009-07-07'),(271,'paulo','cGFzcw==','41.243.208.112','dsl-243-208-112.telkomadsl.co.za','15:04:29','2009-07-07'),(272,'paulo','cGF1bG96YXE=','41.243.208.112','dsl-243-208-112.telkomadsl.co.za','08:19:16','2009-07-10'),(273,'sam','czFtcGwz','41.243.253.51','dsl-243-253-51.telkomadsl.co.za','11:52:34','2009-08-03'),(274,'sam','czFtcGwz','41.243.253.51','dsl-243-253-51.telkomadsl.co.za','12:45:57','2009-08-03'),(275,'sam','czFtcGwz','41.213.126.7','iburst-41-213-126-7.iburst.co.za','14:57:23','2009-08-16'),(276,'sam','c2FtMDFcXA==','41.213.126.7','iburst-41-213-126-7.iburst.co.za','14:57:33','2009-08-16'),(277,'sam','czFtcGwz','41.243.223.118','dsl-243-223-118.telkomadsl.co.za','11:14:42','2009-08-19'),(278,'sam','czFtcGwz','41.243.223.118','dsl-243-223-118.telkomadsl.co.za','10:26:06','2009-08-25'),(279,'sam','czFtcGwz','41.243.247.11','dsl-243-247-11.telkomadsl.co.za','15:35:13','2009-09-09'),(280,'sam','cGFzcw==','41.243.247.11','dsl-243-247-11.telkomadsl.co.za','15:35:20','2009-09-09'),(281,'a','','41.243.247.11','dsl-243-247-11.telkomadsl.co.za','10:57:43','2009-09-15'),(282,'sam','czFtcGwz','41.243.247.11','dsl-243-247-11.telkomadsl.co.za','10:57:52','2009-09-15'),(283,'sam','c2FtMDkx','41.243.247.11','dsl-243-247-11.telkomadsl.co.za','10:58:00','2009-09-15'),(284,'admin','cGFzcw==','41.243.242.146','dsl-243-242-146.telkomadsl.co.za','07:16:40','2009-10-01'),(285,'Lidia.m','bGlkaWEwMQ==','41.243.202.113','dsl-243-202-113.telkomadsl.co.za','14:34:54','2009-10-23'),(286,'lydia.b','bHlkaWEwMQ==','41.243.252.81','dsl-243-252-81.telkomadsl.co.za','13:51:04','2009-11-06'),(287,'lydia.b','bHlkaWEwMQ==','41.243.252.81','dsl-243-252-81.telkomadsl.co.za','15:17:39','2009-11-11');
/*!40000 ALTER TABLE `tt_admin_b_log` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tt_admin_p`
--
DROP TABLE IF EXISTS `tt_admin_p`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tt_admin_p` (
`id` int(10) NOT NULL auto_increment,
`aid` int(10) NOT NULL default '0',
`cat` int(10) NOT NULL default '0',
`perm` int(10) NOT NULL default '0',
`notify_1` int(1) NOT NULL default '1',
`notify_2` int(1) NOT NULL default '1',
`notify_3` int(1) NOT NULL default '1',
`notify_4` int(1) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `aid` (`aid`),
KEY `cat` (`cat`)
) ENGINE=MyISAM AUTO_INCREMENT=953 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tt_admin_p`
--
LOCK TABLES `tt_admin_p` WRITE;
/*!40000 ALTER TABLE `tt_admin_p` DISABLE KEYS */;
INSERT INTO `tt_admin_p` VALUES (727,4,37,0,1,1,1,0),(2,1,2,0,0,1,1,0),(8,1,8,0,0,1,1,0),(9,1,9,0,0,1,1,0),(10,1,10,0,0,1,1,0),(11,2,10,0,0,1,1,0),(13,2,8,0,0,1,1,0),(15,2,2,0,0,1,1,0),(18,2,9,0,0,1,1,0),(726,8,37,0,0,1,1,0),(268,16,2,0,1,1,1,0),(725,15,37,0,0,0,0,0),(266,16,8,0,1,1,1,0),(265,16,14,0,1,1,1,0),(264,16,10,2,1,1,1,0),(263,16,9,0,1,1,1,0),(31,4,10,0,0,1,1,0),(179,4,14,0,1,1,1,0),(33,4,8,0,0,1,1,0),(35,4,2,0,0,1,1,0),(38,4,9,0,0,1,1,0),(724,18,37,0,0,1,1,0),(470,23,15,0,0,0,0,0),(464,23,2,0,1,1,1,1),(51,6,10,2,0,0,0,0),(177,8,14,0,0,1,1,1),(53,6,8,0,0,1,1,0),(55,6,2,0,0,1,1,0),(58,6,9,0,0,1,1,0),(723,26,37,0,1,1,1,0),(294,1,20,0,1,1,1,0),(293,16,20,0,1,1,1,0),(292,2,20,0,0,1,1,0),(722,25,37,0,0,1,1,0),(462,23,8,0,1,1,1,1),(461,23,14,0,1,1,1,1),(460,23,10,0,0,0,0,0),(459,23,9,0,0,0,0,0),(71,8,10,0,1,1,1,1),(175,6,14,0,0,1,1,0),(73,8,8,0,0,1,1,1),(75,8,2,0,0,1,1,1),(78,8,9,0,0,1,1,1),(721,6,37,0,0,1,1,0),(174,2,14,0,0,1,1,0),(310,6,21,0,0,1,1,0),(309,14,21,0,1,1,1,1),(308,12,21,0,0,1,1,0),(457,23,21,0,0,0,0,0),(305,1,21,0,1,1,1,0),(304,16,21,0,1,1,1,0),(303,2,21,0,0,1,1,0),(302,4,20,0,1,1,1,0),(232,4,16,0,1,1,1,0),(231,8,16,0,0,1,1,1),(230,15,16,0,1,1,1,1),(229,6,16,0,0,1,1,0),(228,14,16,0,1,1,1,1),(227,12,16,0,0,1,1,0),(301,8,20,0,0,1,1,1),(172,12,14,0,0,1,1,0),(300,15,20,0,1,1,1,1),(122,12,10,2,0,0,0,0),(124,12,8,0,0,0,1,0),(126,12,2,0,0,1,1,0),(129,12,9,0,0,0,1,0),(720,2,37,0,1,1,1,0),(299,6,20,0,0,1,1,0),(170,1,14,0,1,1,1,0),(298,14,20,0,1,1,1,1),(313,4,21,0,1,1,1,0),(261,16,16,0,1,1,1,0),(225,1,16,0,1,1,1,0),(455,23,16,0,0,0,0,0),(273,16,15,0,1,1,1,0),(183,2,15,0,0,1,1,0),(184,1,15,0,1,1,1,0),(186,12,15,0,0,1,1,0),(188,6,15,0,0,1,1,0),(224,2,16,0,0,1,1,0),(190,8,15,0,1,1,1,1),(192,4,15,0,1,1,1,0),(454,23,20,0,0,0,0,0),(196,14,9,0,1,1,1,1),(197,14,10,0,0,0,0,0),(198,14,8,0,0,0,0,0),(719,14,37,0,1,1,1,1),(312,8,21,0,0,1,1,1),(201,14,14,0,1,1,1,1),(203,14,2,0,1,1,1,1),(207,14,15,0,1,0,0,0),(297,12,20,0,0,1,1,0),(210,15,9,0,1,1,1,1),(211,15,10,0,0,0,0,0),(212,15,8,0,0,0,0,0),(718,12,37,0,0,1,1,0),(311,15,21,0,1,1,1,1),(215,15,14,0,1,1,1,1),(217,15,2,0,1,1,1,1),(221,15,15,0,0,0,0,0),(326,18,20,0,0,1,1,0),(327,18,16,0,0,1,1,0),(328,18,21,0,0,1,1,0),(330,18,9,0,0,1,1,0),(331,18,10,2,0,0,0,0),(332,18,14,0,0,1,1,0),(333,18,8,0,0,1,1,0),(717,23,37,0,0,0,0,0),(335,18,2,0,0,1,1,0),(341,18,15,0,0,1,1,0),(345,19,20,0,0,0,1,0),(346,19,16,0,0,0,1,0),(347,19,21,0,0,0,1,0),(349,19,9,0,0,0,1,0),(350,19,10,2,0,0,0,0),(351,19,14,0,0,0,1,0),(352,19,8,0,0,0,1,0),(716,24,37,0,0,0,1,0),(354,19,2,0,0,0,1,0),(360,19,15,0,0,0,1,0),(712,4,36,0,1,1,1,0),(711,8,36,0,0,1,1,0),(710,15,36,0,0,0,0,0),(709,18,36,0,0,1,1,0),(708,26,36,0,1,1,1,0),(707,25,36,0,0,1,1,0),(706,6,36,0,0,1,1,0),(705,2,36,0,1,1,1,0),(704,14,36,0,0,0,0,0),(703,12,36,0,0,1,1,0),(702,23,36,0,0,0,0,0),(701,24,36,0,0,0,1,0),(697,4,35,0,1,1,1,0),(696,8,35,0,0,1,1,0),(695,15,35,0,1,1,1,1),(694,18,35,0,0,1,1,0),(693,26,35,0,1,1,1,0),(692,25,35,0,0,1,1,0),(691,6,35,0,0,1,1,0),(690,2,35,0,1,1,1,0),(689,14,35,0,0,0,0,0),(688,12,35,0,0,1,1,0),(687,23,35,0,0,0,0,0),(686,24,35,0,0,0,1,0),(667,4,33,0,1,1,1,0),(666,8,33,0,0,1,1,0),(665,15,33,0,1,1,1,1),(664,18,33,0,0,1,1,0),(663,26,33,0,1,1,1,0),(662,25,33,0,0,1,1,0),(661,6,33,0,0,1,1,0),(660,2,33,0,1,1,1,0),(659,14,33,0,1,1,1,1),(658,12,33,0,0,1,1,0),(657,23,33,0,0,0,0,0),(656,24,33,0,0,0,1,0),(682,4,34,0,1,1,1,0),(681,8,34,0,0,1,1,0),(680,15,34,0,1,1,1,1),(679,18,34,0,0,1,1,0),(678,26,34,0,1,1,1,0),(677,25,34,0,0,1,1,0),(676,6,34,0,0,1,1,0),(675,2,34,0,1,1,1,0),(674,14,34,0,0,0,0,0),(673,12,34,0,0,1,1,0),(672,23,34,0,0,0,0,0),(671,24,34,0,0,0,1,0),(545,4,31,0,1,1,1,0),(546,16,31,0,1,1,1,0),(547,1,31,0,1,1,1,0),(548,19,31,0,0,0,1,0),(549,23,31,0,1,1,1,1),(550,12,31,0,0,1,1,0),(551,14,31,0,0,0,0,0),(552,2,31,0,0,1,1,0),(553,6,31,0,0,1,1,0),(554,18,31,0,0,1,1,0),(555,15,31,0,1,0,1,1),(556,8,31,0,0,1,1,0),(570,24,31,0,0,0,1,0),(685,19,35,0,0,0,1,0),(670,19,34,0,0,0,1,0),(655,19,33,0,0,0,1,0),(576,24,20,0,0,0,1,0),(577,24,16,0,0,0,1,0),(578,24,21,0,0,0,1,0),(700,19,36,0,0,0,1,0),(584,24,9,0,0,0,1,0),(585,24,10,2,0,0,0,0),(586,24,14,0,0,0,1,0),(587,24,8,0,0,0,1,0),(715,19,37,0,0,0,1,0),(589,24,2,0,0,0,1,0),(595,24,15,0,0,0,1,0),(598,25,31,0,0,1,1,0),(684,16,35,0,1,1,1,0),(669,16,34,0,1,1,1,0),(654,16,33,0,1,1,1,0),(604,25,20,0,0,1,1,0),(605,25,16,0,0,1,1,0),(606,25,21,0,0,1,1,0),(699,16,36,0,1,1,1,0),(612,25,9,0,0,1,1,0),(613,25,10,2,0,0,0,0),(614,25,14,0,0,1,1,0),(615,25,8,0,0,1,1,0),(714,16,37,0,1,1,1,0),(617,25,2,0,0,1,1,0),(623,25,15,0,0,1,1,0),(626,26,31,0,0,1,1,0),(683,1,35,0,1,1,1,0),(668,1,34,0,1,1,1,0),(653,1,33,0,1,1,1,0),(632,26,20,0,0,1,1,0),(633,26,16,0,0,1,1,0),(634,26,21,0,0,1,1,0),(698,1,36,0,1,1,1,0),(640,26,9,0,0,1,1,0),(641,26,10,0,0,1,1,0),(642,26,14,0,0,1,1,0),(643,26,8,0,0,1,1,0),(713,1,37,0,1,1,1,0),(645,26,2,0,0,1,1,0),(651,26,15,0,0,1,1,0),(728,23,38,0,1,1,1,1),(729,16,38,2,1,1,1,0),(730,1,38,2,1,1,1,0),(731,19,38,2,1,1,1,0),(732,24,38,2,1,1,1,0),(733,12,38,2,1,1,1,0),(734,14,38,0,1,1,1,0),(735,2,38,0,1,1,1,0),(736,6,38,2,1,1,1,0),(737,25,38,2,1,1,1,0),(738,26,38,2,1,1,1,0),(739,18,38,2,1,1,1,0),(740,15,38,0,1,1,1,0),(741,8,38,0,1,1,1,0),(742,4,38,0,1,1,1,0),(743,23,39,0,1,1,1,1),(744,16,39,0,1,1,1,0),(745,1,39,0,1,1,1,0),(746,19,39,0,1,1,1,0),(747,24,39,0,1,1,1,0),(748,12,39,0,1,1,1,0),(749,14,39,0,1,1,1,0),(750,2,39,0,1,1,1,0),(751,6,39,0,1,1,1,0),(752,25,39,0,1,1,1,0),(753,26,39,0,1,1,1,0),(754,18,39,0,1,1,1,0),(755,15,39,0,1,1,1,0),(756,8,39,0,1,1,1,0),(757,4,39,0,1,1,1,0),(758,23,40,0,1,1,1,0),(759,16,40,0,1,1,1,0),(760,1,40,0,1,1,1,0),(761,19,40,0,1,1,1,0),(762,24,40,0,1,1,1,0),(763,12,40,0,1,1,1,0),(764,14,40,0,1,1,1,0),(765,2,40,0,1,1,1,0),(766,6,40,0,1,1,1,0),(767,25,40,0,1,1,1,0),(768,26,40,0,1,1,1,0),(769,18,40,0,1,1,1,0),(770,15,40,0,1,1,1,0),(771,8,40,0,1,1,1,0),(772,4,40,0,1,1,1,0),(773,23,41,0,1,1,1,0),(774,16,41,0,1,1,1,0),(775,1,41,0,1,1,1,0),(776,19,41,0,1,1,1,0),(777,24,41,0,1,1,1,0),(778,12,41,0,1,1,1,0),(779,14,41,0,1,1,1,0),(780,2,41,0,1,1,1,0),(781,6,41,0,1,1,1,0),(782,25,41,0,1,1,1,0),(783,26,41,0,1,1,1,0),(784,18,41,0,1,1,1,0),(785,15,41,0,1,1,1,0),(786,8,41,0,1,1,1,0),(787,4,41,0,1,1,1,0),(788,23,42,0,1,1,1,0),(789,16,42,0,1,1,1,0),(790,1,42,0,1,1,1,0),(791,19,42,0,1,1,1,0),(792,24,42,0,1,1,1,0),(793,12,42,0,1,1,1,0),(794,14,42,0,1,1,1,0),(795,2,42,0,1,1,1,0),(796,6,42,0,1,1,1,0),(797,25,42,0,1,1,1,0),(798,26,42,0,1,1,1,0),(799,18,42,0,1,1,1,0),(800,15,42,0,1,1,1,0),(801,8,42,0,1,1,1,0),(802,4,42,0,1,1,1,0),(803,23,43,0,1,1,1,0),(804,16,43,0,1,1,1,0),(805,1,43,0,1,1,1,0),(806,19,43,0,1,1,1,0),(807,24,43,0,1,1,1,0),(808,12,43,0,1,1,1,0),(809,14,43,0,1,1,1,0),(810,2,43,0,1,1,1,0),(811,6,43,0,1,1,1,0),(812,25,43,0,1,1,1,0),(813,26,43,0,1,1,1,0),(814,18,43,0,1,1,1,0),(815,15,43,0,1,1,1,0),(816,8,43,0,1,1,1,0),(817,4,43,0,1,1,1,0),(818,23,44,0,1,1,1,0),(819,16,44,0,1,1,1,0),(820,1,44,0,1,1,1,0),(821,19,44,0,1,1,1,0),(822,24,44,0,1,1,1,0),(823,12,44,0,1,1,1,0),(824,14,44,0,1,1,1,0),(825,2,44,0,1,1,1,0),(826,6,44,0,1,1,1,0),(827,25,44,0,1,1,1,0),(828,26,44,0,1,1,1,0),(829,18,44,0,1,1,1,0),(830,15,44,0,1,1,1,0),(831,8,44,0,1,1,1,0),(832,4,44,0,1,1,1,0),(833,23,45,0,1,1,1,0),(834,16,45,0,1,1,1,0),(835,1,45,0,1,1,1,0),(836,19,45,0,1,1,1,0),(837,24,45,0,1,1,1,0),(838,12,45,0,1,1,1,0),(839,14,45,0,1,1,1,0),(840,2,45,0,1,1,1,0),(841,6,45,0,1,1,1,0),(842,25,45,0,1,1,1,0),(843,26,45,0,1,1,1,0),(844,18,45,0,1,1,1,0),(845,15,45,0,1,1,1,0),(846,8,45,0,1,1,1,0),(847,4,45,0,1,1,1,0),(848,23,46,0,1,1,1,0),(849,16,46,0,1,1,1,0),(850,1,46,0,1,1,1,0),(851,19,46,0,1,1,1,0),(852,24,46,0,1,1,1,0),(853,12,46,0,1,1,1,0),(854,14,46,0,1,1,1,0),(855,2,46,0,1,1,1,0),(856,6,46,0,1,1,1,0),(857,25,46,0,1,1,1,0),(858,26,46,0,1,1,1,0),(859,18,46,0,1,1,1,0),(860,15,46,0,1,1,1,0),(861,8,46,0,1,1,1,0),(862,4,46,0,1,1,1,0),(863,23,47,0,1,1,1,0),(864,16,47,0,1,1,1,0),(865,1,47,0,1,1,1,0),(866,19,47,0,1,1,1,0),(867,24,47,0,1,1,1,0),(868,12,47,0,1,1,1,0),(869,14,47,0,1,1,1,0),(870,2,47,0,1,1,1,0),(871,6,47,0,1,1,1,0),(872,25,47,0,1,1,1,0),(873,26,47,0,1,1,1,0),(874,18,47,0,1,1,1,0),(875,15,47,0,1,1,1,0),(876,8,47,0,1,1,1,0),(877,4,47,0,1,1,1,0),(878,23,48,0,1,1,1,0),(879,16,48,0,1,1,1,0),(880,1,48,0,1,1,1,0),(881,19,48,0,1,1,1,0),(882,24,48,0,1,1,1,0),(883,12,48,0,1,1,1,0),(884,14,48,0,1,1,1,0),(885,2,48,0,1,1,1,0),(886,6,48,0,1,1,1,0),(887,25,48,0,1,1,1,0),(888,26,48,0,1,1,1,0),(889,18,48,0,1,1,1,0),(890,15,48,0,1,1,1,0),(891,8,48,0,1,1,1,0),(892,4,48,0,1,1,1,0),(893,23,49,0,1,1,1,0),(894,16,49,0,1,1,1,0),(895,1,49,0,1,1,1,0),(896,19,49,0,1,1,1,0),(897,24,49,0,1,1,1,0),(898,12,49,0,1,1,1,0),(899,14,49,0,1,1,1,0),(900,2,49,0,1,1,1,0),(901,6,49,0,1,1,1,0),(902,25,49,0,1,1,1,0),(903,26,49,0,1,1,1,0),(904,18,49,0,1,1,1,0),(905,15,49,0,1,1,1,0),(906,8,49,0,1,1,1,0),(907,4,49,0,1,1,1,0),(908,23,50,0,1,1,1,0),(909,16,50,0,1,1,1,0),(910,1,50,0,1,1,1,0),(911,19,50,0,1,1,1,0),(912,24,50,0,1,1,1,0),(913,12,50,0,1,1,1,0),(914,14,50,0,1,1,1,0),(915,2,50,0,1,1,1,0),(916,6,50,0,1,1,1,0),(917,25,50,0,1,1,1,0),(918,26,50,0,1,1,1,0),(919,18,50,0,1,1,1,0),(920,15,50,0,1,1,1,0),(921,8,50,0,1,1,1,0),(922,4,50,0,1,1,1,0),(923,23,51,0,1,1,1,0),(924,16,51,0,1,1,1,0),(925,1,51,0,1,1,1,0),(926,19,51,0,1,1,1,0),(927,24,51,0,1,1,1,0),(928,12,51,0,1,1,1,0),(929,14,51,0,1,1,1,0),(930,2,51,0,1,1,1,0),(931,6,51,0,1,1,1,0),(932,25,51,0,1,1,1,0),(933,26,51,0,1,1,1,0),(934,18,51,0,1,1,1,0),(935,15,51,0,1,1,1,0),(936,8,51,0,1,1,1,0),(937,4,51,0,1,1,1,0),(938,23,52,0,1,1,1,0),(939,16,52,0,1,1,1,0),(940,1,52,0,1,1,1,0),(941,19,52,0,1,1,1,0),(942,24,52,0,1,1,1,0),(943,12,52,0,1,1,1,0),(944,14,52,0,1,1,1,0),(945,2,52,0,1,1,1,0),(946,6,52,0,1,1,1,0),(947,25,52,0,1,1,1,0),(948,26,52,0,1,1,1,0),(949,18,52,0,1,1,1,0),(950,15,52,0,1,1,1,0),(951,8,52,0,1,1,1,0),(952,4,52,0,1,1,1,0);
/*!40000 ALTER TABLE `tt_admin_p` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tt_announce`
--
DROP TABLE IF EXISTS `tt_announce`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tt_announce` (
`id` int(100) NOT NULL auto_increment,
`cat` int(25) NOT NULL default '0',
`adminid` int(25) NOT NULL default '0',
`title` varchar(250) collate latin1_general_ci NOT NULL default '',
`contents` longtext collate latin1_general_ci NOT NULL,
`cutoff` date NOT NULL default '0000-00-00',
`start` date NOT NULL default '0000-00-00',
PRIMARY KEY (`id`),
FULLTEXT KEY `title` (`title`),
FULLTEXT KEY `contents` (`contents`)
) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tt_announce`
--
LOCK TABLES `tt_announce` WRITE;
/*!40000 ALTER TABLE `tt_announce` DISABLE KEYS */;
INSERT INTO `tt_announce` VALUES (21,2,2,'pMailer goes green with new interface','pMailer has launched with an all-new green interface. We\'re soon to competely re-launch the pMailer brand with a dedicated pMailer website, so look out for it.
Along with the new interface are new, clearer icons on the pMailer dashboard, and we\'ve upgraded the pMailer sending engine to even further improve delivery performance.
- The pMailer Team','2007-10-28','2007-09-28'),(22,2,2,'pMailer migrates to new server cluster','After months of testing, pMailer has moved to a new server cluster to enable future growth and keep pace with client demand. The new servers are all packed with Dual-Woodcrest processor configurations and significant memory resources available to the cluster to ensure the databases are quick and effective for our users. With this new infrastructure, we expect to be able to deliver millions of emails per day reliable to the network. We\'ve also improved our relationships with the relevant Internet Service Providers (ISPs) to ensure we remain the web\'s most trusted email delivery engine.
There was a scheduled downtime of a few minutes during the migration and everything went according to plan. A massive task that was well-executed by the pMailer technical team.','2007-10-28','2007-09-28'),(11,0,2,'Connectivity Outage - Verizon Network','Prefix web/mail servers were innaccessible for a few hours today due to a SAIX/Verizon network peering issue. The pMailer service was unaffected.
This was caused by a network circuit going down between SAIX (telkom) and Verizon (UUnet).
The network issue has been attended and access is now restored.
We apologise for any inconvenience.','2007-10-01','2007-08-31');
/*!40000 ALTER TABLE `tt_announce` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tt_backend`
--
DROP TABLE IF EXISTS `tt_backend`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tt_backend` (
`id` int(5) NOT NULL auto_increment,
`sname` varchar(250) collate latin1_general_ci NOT NULL default '',
`logo` text collate latin1_general_ci NOT NULL,
`levels` text collate latin1_general_ci NOT NULL,
`serial` varchar(250) collate latin1_general_ci NOT NULL default '',
`version` varchar(25) collate latin1_general_ci NOT NULL default '',
`av` text collate latin1_general_ci NOT NULL,
`avo` text collate latin1_general_ci NOT NULL,
`kb_mod` int(1) NOT NULL default '0',
`kb_mod_av` text collate latin1_general_ci NOT NULL,
`prefix` varchar(100) collate latin1_general_ci NOT NULL default '',
`op_1` int(1) NOT NULL default '1',
`op_2` int(1) NOT NULL default '0',
`op_3` int(1) NOT NULL default '1',
`op_4` int(1) NOT NULL default '0',
`op_5` int(1) NOT NULL default '1',
`op_6` int(1) NOT NULL default '0',
`op_7` int(1) NOT NULL default '1',
`p_link` varchar(250) collate latin1_general_ci NOT NULL default '',
`a_link` varchar(250) collate latin1_general_ci NOT NULL default '',
`em_from` varchar(250) collate latin1_general_ci NOT NULL default '',
`show_rtime` int(1) NOT NULL default '0',
`force_graph` int(1) NOT NULL default '0',
`stype` int(1) NOT NULL default '0',
`smhost` varchar(250) collate latin1_general_ci NOT NULL default '',
`smuser` varchar(250) collate latin1_general_ci NOT NULL default '',
`smport` varchar(250) collate latin1_general_ci NOT NULL default '',
`smpass` varchar(250) collate latin1_general_ci NOT NULL default '',
`ac` text collate latin1_general_ci NOT NULL,
`em_bounce` varchar(250) collate latin1_general_ci NOT NULL default 'none@localhost',
`lang` varchar(250) collate latin1_general_ci NOT NULL default 'english',
`mb_uri` varchar(250) collate latin1_general_ci NOT NULL default '',
`incpatho` int(1) NOT NULL default '0',
`incpathd` varchar(250) collate latin1_general_ci NOT NULL default '.:/usr/share/pear',
`maxfilesize` int(5) NOT NULL default '3',
`maxticperpage` int(5) NOT NULL default '15',
`speller` int(1) NOT NULL default '0',
`imageverify` int(1) NOT NULL default '0',
`rss` int(1) NOT NULL default '0',
`avatars` int(1) NOT NULL default '0',
`spamnotify` int(1) NOT NULL default '1',
`updatecheck` int(1) NOT NULL default '1',
`updatedate` date NOT NULL default '0000-00-00',
`updateversion` varchar(250) collate latin1_general_ci NOT NULL default '',
`regconfirm` int(1) NOT NULL default '1',
`t_offset` int(10) NOT NULL default '0',
`t_offset_o` enum('-','+') collate latin1_general_ci NOT NULL default '+',
`lockdown` int(1) NOT NULL default '0',
`whostyping` int(1) NOT NULL default '1',
`whosviewing` int(1) NOT NULL default '1',
`confirmemail` varchar(250) collate latin1_general_ci NOT NULL default '',
`emailtickets` int(10) NOT NULL default '0',
`dfltdateformat` varchar(128) collate latin1_general_ci NOT NULL default 'm/d/Y H:i',
`imageverifyt` int(1) NOT NULL default '0',
`hidepublic` int(1) NOT NULL default '0',
`dflt_priority` int(1) NOT NULL default '2',
`close_msgsrc` tinyint(1) NOT NULL default '1',
`floodlevel` int(1) NOT NULL default '1',
`swift_url` varchar(150) collate latin1_general_ci default NULL,
`swift_id` int(10) NOT NULL default '0',
`grouptickets` tinyint(1) NOT NULL default '0',
`notifyccs` tinyint(1) NOT NULL default '1',
`brand_copyright` int(1) NOT NULL default '1',
`brand_links` int(1) NOT NULL default '1',
`brand_editorw` varchar(32) collate latin1_general_ci NOT NULL default '',
`brand_editorh` varchar(32) collate latin1_general_ci NOT NULL default '',
`brand_version` int(1) NOT NULL default '1',
`brand_demo` int(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tt_backend`
--
LOCK TABLES `tt_backend` WRITE;
/*!40000 ALTER TABLE `tt_backend` DISABLE KEYS */;
INSERT INTO `tt_backend` VALUES (1,'Prefix Customer Service Center','http://helpdesk.prefix.co.za/media/prefixlogo.jpg','','STF-I09X3293Q64K9BPQULAAQU4S7830R0','2.66.2','ZGNjZTg4N2FlOGM3ZmRiNWIzODJmYmU5OWFmNGQxMjMwMTJkZmUwZjViYjRiYzUxNDJiMTgzZjQwNTA5MWYxN2QyNjRjNDEyZTlkZDZhYTBhYTFlODRhMmNiMGIzODc2NDNjMTVjMzM1NmUzMWZmZGM0NmVlODQ4ZmMyNzAxOTI=','TWpBeE1DMHdNaTB3Tmc9PQ==',0,'','',0,0,0,0,1,0,1,'http://helpdesk.prefix.co.za','http://helpdesk.prefix.co.za/admin','support@prefix.co.za',1,0,0,'','','25','','15538404bb4d9c04400590342aca7dbf','helpdesk_bounces@prefix.co.za','english','',0,'.:/usr/share/pear',0,50,0,0,0,0,0,0,'2009-01-13','2.66.5',0,0,'+',0,1,1,'josh@prefix.co.za',1,'m/d/Y H:i',1,0,2,1,1,'http://projects.prefix.co.za',3,1,1,0,0,'0px','0px',1,0);
/*!40000 ALTER TABLE `tt_backend` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tt_blocked`
--
DROP TABLE IF EXISTS `tt_blocked`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tt_blocked` (
`id` int(10) NOT NULL auto_increment,
`value` varchar(255) collate latin1_general_ci NOT NULL default '',
`type` int(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tt_blocked`
--
LOCK TABLES `tt_blocked` WRITE;
/*!40000 ALTER TABLE `tt_blocked` DISABLE KEYS */;
INSERT INTO `tt_blocked` VALUES (1,'napm20vr@citiz.net',1),(2,'jfp@wcpm.com',1),(5,'info@prefix.co.za',1);
/*!40000 ALTER TABLE `tt_blocked` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tt_calendar`
--
DROP TABLE IF EXISTS `tt_calendar`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tt_calendar` (
`id` int(10) NOT NULL auto_increment,
`sdate` date NOT NULL default '0000-00-00',
`edate` date NOT NULL default '0000-00-00',
`stime` time NOT NULL default '00:00:00',
`etime` time NOT NULL default '00:00:00',
`title` varchar(250) collate latin1_general_ci NOT NULL default '',
`contents` text collate latin1_general_ci NOT NULL,
`tid` varchar(250) collate latin1_general_ci NOT NULL default '',
`user_id` varchar(250) collate latin1_general_ci NOT NULL default '',
`user_cre_id` int(10) NOT NULL default '0',
`type` int(5) NOT NULL default '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tt_calendar`
--
LOCK TABLES `tt_calendar` WRITE;
/*!40000 ALTER TABLE `tt_calendar` DISABLE KEYS */;
/*!40000 ALTER TABLE `tt_calendar` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tt_can_response`
--
DROP TABLE IF EXISTS `tt_can_response`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tt_can_response` (
`id` int(10) NOT NULL auto_increment,
`dep` int(10) NOT NULL default '0',
`title` varchar(250) collate latin1_general_ci NOT NULL default '',
`contents` longtext collate latin1_general_ci NOT NULL,
`date` date NOT NULL default '0000-00-00',
`time` time NOT NULL default '00:00:00',
`adminid` int(25) NOT NULL default '0',
`attached` varchar(250) collate latin1_general_ci default NULL,
`deptmirror` varchar(250) collate latin1_general_ci default NULL,
PRIMARY KEY (`id`),
KEY `dep` (`dep`),
KEY `deptmirror` (`deptmirror`)
) ENGINE=MyISAM AUTO_INCREMENT=45 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tt_can_response`
--
LOCK TABLES `tt_can_response` WRITE;
/*!40000 ALTER TABLE `tt_can_response` DISABLE KEYS */;
INSERT INTO `tt_can_response` VALUES (5,14,'Resolved by Prefix','The problem described has been solved from our perspective/understanding and the client informed. ','2007-09-07','17:42:50',1,NULL,NULL),(6,14,'Resolved by client','The client has resolved it on their own or with telephonic support from a prefix technician. ','2007-09-07','17:43:53',1,NULL,NULL),(7,14,'No further response','A ticket that has not been responded to by a client within a reasonable of time for the query/problem concerned. In this case, we assume the client has resolved the problem.','2007-09-07','17:45:29',1,NULL,NULL),(8,14,'Could not be solved','When the problem or feature cannot be solved/implemented. These tickets are escalated to the developer department and a feature request or bug are added to the product tracker.','2007-09-07','17:47:16',1,NULL,NULL),(21,2,'Could not be solved','When the problem or feature cannot be solved/implemented. These tickets are escalated to the developer department and a feature request or bug are added to the product tracker.','2007-09-10','12:26:46',1,NULL,NULL),(22,2,'No further response','A ticket that has not been responded to by a client within a reasonable of time for the query/problem concerned. In this case, we assume the client has resolved the problem.','2007-09-10','12:27:07',1,NULL,NULL),(23,2,'Resolved by client','The client has resolved it on their own or with telephonic support from a prefix technician. ','2007-09-10','12:27:26',1,NULL,NULL),(24,2,'Resolved by Prefix','The problem described has been solved from our perspective/understanding and the client informed. ','2007-09-10','12:27:44',1,NULL,NULL),(33,16,'Customer Not interested','Direct \"not interested\" result after sales process. A dead lead.','2007-09-10','12:35:22',1,NULL,NULL),(34,16,'Deal closed / sale made','Yay! Sales has been made and is in the roll-out / fullfillment phase.','2007-09-10','12:35:55',1,NULL,NULL),(35,16,'Did not confirm/respond','Contact has not responded / confirmed with both telephonic and/or mail communications. Considered a dead lead.','2007-09-10','12:36:11',1,NULL,NULL),(36,16,'Requires Follow-up','Either not interested right now or busy making comparative quotes/queries with competing solutions. sales dept to create their own reminder process to follow up with this lead.','2007-09-10','12:36:29',1,NULL,NULL),(41,9,'Customer Not interested','Direct \"not interested\" result after sales process. A dead lead.','2007-09-10','12:39:05',1,NULL,NULL),(42,9,'Deal closed / sale made','Yay! Sales has been made and is in the roll-out / fullfillment phase.','2007-09-10','12:39:32',1,NULL,NULL),(43,9,'Did not confirm/respond','Contact has not responded / confirmed with both telephonic and/or mail communications. Considered a dead lead.','2007-09-10','12:39:50',1,NULL,NULL),(44,9,'Requires Follow-up','Either not interested right now or busy making comparative quotes/queries with competing solutions. sales dept to create their own reminder process to follow up with this lead.','2007-09-10','12:40:07',1,NULL,NULL);
/*!40000 ALTER TABLE `tt_can_response` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tt_category`
--
DROP TABLE IF EXISTS `tt_category`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tt_category` (
`id` int(10) NOT NULL auto_increment,
`title` varchar(250) collate latin1_general_ci NOT NULL default '',
`capt` text collate latin1_general_ci NOT NULL,
`loc` int(10) NOT NULL default '0',
`autoclose` int(5) NOT NULL default '0',
`autoclose_field` int(1) NOT NULL default '0',
`dorder` int(10) NOT NULL default '0',
`dredir` varchar(250) collate latin1_general_ci NOT NULL default '',
`adminid` int(10) NOT NULL default '0',
`hideps` int(1) NOT NULL default '0',
`showcounts` int(1) NOT NULL default '0',
`fromem` varchar(250) collate latin1_general_ci NOT NULL default '',
`fromname` varchar(250) collate latin1_general_ci NOT NULL default '',
`emf` int(1) NOT NULL default '0',
`em1s` varchar(250) collate latin1_general_ci NOT NULL default '',
`em1c` text collate latin1_general_ci NOT NULL,
`em2s` varchar(250) collate latin1_general_ci NOT NULL default '',
`em2c` text collate latin1_general_ci NOT NULL,
`em3s` varchar(250) collate latin1_general_ci NOT NULL default '',
`em3c` text collate latin1_general_ci NOT NULL,
`em4s` varchar(250) collate latin1_general_ci NOT NULL default '',
`em4c` text collate latin1_general_ci NOT NULL,
`em5s` varchar(250) collate latin1_general_ci NOT NULL default 'NONE',
`em5c` text collate latin1_general_ci NOT NULL,
`em1sa` text collate latin1_general_ci NOT NULL,
`em1ca` longtext collate latin1_general_ci NOT NULL,
`em2sa` text collate latin1_general_ci NOT NULL,
`em2ca` longtext collate latin1_general_ci NOT NULL,
`em5sa` varchar(250) collate latin1_general_ci NOT NULL default 'NONE',
`em5ca` text collate latin1_general_ci NOT NULL,
`em1smail` varchar(255) collate latin1_general_ci NOT NULL default '',
`em1cmail` text collate latin1_general_ci NOT NULL,
`autoclose_msgsrc` tinyint(1) NOT NULL default '0',
`attachments` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`id`),
KEY `loc` (`loc`)
) ENGINE=MyISAM AUTO_INCREMENT=53 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tt_category`
--
LOCK TABLES `tt_category` WRITE;
/*!40000 ALTER TABLE `tt_category` DISABLE KEYS */;
INSERT INTO `tt_category` VALUES (2,'pMailer Support','',0,0,0,1,'',1,0,0,'support@pmailer.co.za','pMailer Support',1,'NONE','','# [%TICKETID%]: %SUBJECT%','\r\n%LASTPOST%\r\n
\r\n','NONE','','NONE','',0,0),(10,'Bill For This!','Work to be billed for from development/support staff to accounts admins.',31,0,0,2,'',1,1,0,'','Prefix Billings System',1,'NONE','','# [%TICKETID%]: %SUBJECT%','\r\n%LASTPOST%\r\n
\r\n','NONE','','NONE','',0,1),(33,'Preditor SLA','',0,0,0,7,'',1,0,0,'services@preditor.co.za','Preditor Services',1,'# [%TICKETID%]: %SUBJECT%','Thank you for contacting Prefix Support\r\n
\r\nYour ticket reference number is %TICKETID%.\r\n \r\nTo check the status of this ticket Click Here \r\n \r\nOne of our consultants will reply to you shortly to assist you with your query.\r\n
\r\nFor our comprehensive online support articles and resources, visit http://helpdesk.prefix.co.za/index.php?action=kb\r\n
\r\nTo view this ticket, visit: Click Here ','# [%TICKETID%]: %SUBJECT%','Thank you for contacting Prefix Support\r\n
\r\nYour ticket reference number is %TICKETID%.\r\n \r\nTo check the status of this ticket Click Here \r\n \r\nOne of our consultants will reply to you shortly to assist you with your query.\r\n
\r\nFor our comprehensive online support articles and resources, visit http://helpdesk.prefix.co.za/index.php?action=kb\r\n
\r\nThank you for your continued support.\r\n
\r\nYour Prefix Team\r\n
\r\n',0,1),(34,'8INK Media','',33,0,0,1,'',1,1,0,'8ink@preditor.co.za','Preditor Services (8ink)',1,'# [%TICKETID%]: %SUBJECT%','Thank you for contacting Prefix Support\r\n
\r\nYour ticket reference number is %TICKETID%.\r\n \r\nTo check the status of this ticket Click Here \r\n \r\nOne of our consultants will reply to you shortly to assist you with your query.\r\n
\r\nFor our comprehensive online support articles and resources, visit http://helpdesk.prefix.co.za/index.php?action=kb\r\n
\r\nTo view this ticket, visit: Click Here ','# [%TICKETID%]: %SUBJECT%','Thank you for contacting Prefix Support\r\n
\r\nYour ticket reference number is %TICKETID%.\r\n \r\nTo check the status of this ticket Click Here \r\n \r\nOne of our consultants will reply to you shortly to assist you with your query.\r\n
\r\nFor our comprehensive online support articles and resources, visit http://helpdesk.prefix.co.za/index.php?action=kb\r\n
\r\nThank you for your continued support.\r\n
\r\nYour Prefix Team\r\n
\r\n',0,1),(35,'Ramsay Media','',33,0,0,0,'',1,1,0,'ramsaymedia@preditor.co.za','Preditor Services (Ramsay)',1,'# [%TICKETID%]: %SUBJECT%','Thank you for contacting Prefix Support\r\n
\r\nYour ticket reference number is %TICKETID%.\r\n \r\nTo check the status of this ticket Click Here \r\n \r\nOne of our consultants will reply to you shortly to assist you with your query.\r\n
\r\nFor our comprehensive online support articles and resources, visit http://helpdesk.prefix.co.za/index.php?action=kb\r\n
\r\nTo view this ticket, visit: Click Here ','# [%TICKETID%]: %SUBJECT%','Thank you for contacting Prefix Support\r\n
\r\nYour ticket reference number is %TICKETID%.\r\n \r\nTo check the status of this ticket Click Here \r\n \r\nOne of our consultants will reply to you shortly to assist you with your query.\r\n
\r\nFor our comprehensive online support articles and resources, visit http://helpdesk.prefix.co.za/index.php?action=kb\r\n
\r\nThank you for your continued support.\r\n
\r\nYour Prefix Team\r\n
\r\n',0,1),(36,'Creamer Media','',33,0,0,0,'',1,1,0,'creamermedia@preditor.co.za','Preditor Services (Creamer)',1,'# [%TICKETID%]: %SUBJECT%','Thank you for contacting Prefix Support\r\n
\r\nYour ticket reference number is %TICKETID%.\r\n \r\nTo check the status of this ticket Click Here \r\n \r\nOne of our consultants will reply to you shortly to assist you with your query.\r\n
\r\nFor our comprehensive online support articles and resources, visit http://helpdesk.prefix.co.za/index.php?action=kb\r\n
\r\n','# [%TICKETID%]: %SUBJECT%','Thank you for contacting Prefix Support\r\n
\r\nYour ticket reference number is %TICKETID%.\r\n \r\nTo check the status of this ticket Click Here \r\n \r\nOne of our consultants will reply to you shortly to assist you with your query.\r\n
\r\nFor our comprehensive online support articles and resources, visit http://helpdesk.prefix.co.za/index.php?action=kb\r\n
\r\nThank you for your continued support.\r\n
\r\nYour Prefix Team\r\n
\r\n',0,1),(31,'Legacy / Archives','Just in case we need this stuff. Will be deleted later.',0,0,0,16,'',4,1,0,'','',1,'NONE','','# [%TICKETID%]: %SUBJECT%','\r\n%LASTPOST%\r\n
\r\n','NONE','','NONE','',0,1),(37,'Gender Links','',33,0,0,0,'',1,1,0,'genderlinks@preditor.co.za','Preditor Services (Gender Links)',1,'# [%TICKETID%]: %SUBJECT%','Thank you for contacting Prefix Support\r\n
\r\nYour ticket reference number is %TICKETID%.\r\n \r\nTo check the status of this ticket Click Here \r\n \r\nOne of our consultants will reply to you shortly to assist you with your query.\r\n
\r\nFor our comprehensive online support articles and resources, visit http://helpdesk.prefix.co.za/index.php?action=kb\r\n
\r\nTo view this ticket, visit: Click Here ','# [%TICKETID%]: %SUBJECT%','Thank you for contacting Prefix Support\r\n
\r\nYour ticket reference number is %TICKETID%.\r\n \r\nTo check the status of this ticket Click Here \r\n \r\nOne of our consultants will reply to you shortly to assist you with your query.\r\n
\r\nFor our comprehensive online support articles and resources, visit http://helpdesk.prefix.co.za/index.php?action=kb\r\n
\r\nThank you for your continued support.\r\n
\r\nYour Prefix Team\r\n
\r\n',0,1),(38,'pMailer Abuse','',0,0,0,0,'',23,1,0,'abuse@pmailer.net','abuse@pmailer.net',0,'Ticket: [%TICKETID%]','This message is to notify you that your ticket has been submitted.\n\nTicket ID: %TICKETID%\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','RE: Ticket: [%TICKETID%]','This message is to notify you that your ticket has been updated.\n\nTicket ID: %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','Ticket: [%TICKETID%] Assigned','This message is to notify you that you have been assigned a ticket.\n\nTicket ID# %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo check the status of this ticket, visit: \n%TICKETLINK%','FW: Ticket: [%TICKETID%]','This message is to notify you that you have been forwarded a ticket.\n\nTicket ID %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo view this ticket, visit:\n%TICKETLINK%','FW: Ticket: [%TICKETID%]','This message is to notify you that a ticket has been closed.\n\nTicket ID %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo view this ticket, visit:\n%TICKETLINK%','Ticket: [%TICKETID%]','This message is to notify you that your ticket has been submitted.\n\nTicket ID: %TICKETID%\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','RE: Ticket: [%TICKETID%]','This message is to notify you that your ticket has been updated.\n\nTicket ID: %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','FW: Ticket: [%TICKETID%]','This message is to notify you that a ticket has been closed.\n\nTicket ID %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo view this ticket, visit:\n%TICKETLINK%','Ticket: [%TICKETID%]','This message is to notify you that your ticket has been submitted.\n\nTicket ID: %TICKETID%\n\nTo check the status of this ticket, visit:\n%TICKETLINK%',0,0),(39,'pMailer Enterprise','',0,0,0,0,'',23,0,0,'enterprise-support@pmailer.co.za','Enterprise Support',1,'# [%TICKETID%]: %SUBJECT%','Thank you for contacting Prefix Support\r\n
\r\nYour ticket reference number is %TICKETID%.\r\n \r\nTo check the status of this ticket Click Here \r\n \r\nOne of our consultants will reply to you shortly to assist you with your query.\r\n
\r\nFor our comprehensive online support articles and resources, visit http://helpdesk.prefix.co.za/index.php?action=kb\r\n
\r\n','# [%TICKETID%]: %SUBJECT%','Thank you for contacting Prefix Support\r\n
\r\nYour ticket reference number is %TICKETID%.\r\n \r\nTo check the status of this ticket Click Here \r\n \r\nOne of our consultants will reply to you shortly to assist you with your query.\r\n
\r\nFor our comprehensive online support articles and resources, visit http://helpdesk.prefix.co.za/index.php?action=kb\r\n
\r\nThank you for your continued support.\r\n
\r\nYour Prefix Team\r\n
\r\n',0,1),(40,'axiz','',39,0,0,0,'',23,1,0,'','',0,'Ticket: [%TICKETID%]','This message is to notify you that your ticket has been submitted.\n\nTicket ID: %TICKETID%\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','RE: Ticket: [%TICKETID%]','This message is to notify you that your ticket has been updated.\n\nTicket ID: %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','Ticket: [%TICKETID%] Assigned','This message is to notify you that you have been assigned a ticket.\n\nTicket ID# %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo check the status of this ticket, visit: \n%TICKETLINK%','FW: Ticket: [%TICKETID%]','This message is to notify you that you have been forwarded a ticket.\n\nTicket ID %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo view this ticket, visit:\n%TICKETLINK%','FW: Ticket: [%TICKETID%]','This message is to notify you that a ticket has been closed.\n\nTicket ID %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo view this ticket, visit:\n%TICKETLINK%','Ticket: [%TICKETID%]','This message is to notify you that your ticket has been submitted.\n\nTicket ID: %TICKETID%\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','RE: Ticket: [%TICKETID%]','This message is to notify you that your ticket has been updated.\n\nTicket ID: %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','FW: Ticket: [%TICKETID%]','This message is to notify you that a ticket has been closed.\n\nTicket ID %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo view this ticket, visit:\n%TICKETLINK%','Ticket: [%TICKETID%]','This message is to notify you that your ticket has been submitted.\n\nTicket ID: %TICKETID%\n\nTo check the status of this ticket, visit:\n%TICKETLINK%',0,1),(41,'dlamini','',39,0,0,0,'',23,1,0,'','',0,'Ticket: [%TICKETID%]','This message is to notify you that your ticket has been submitted.\n\nTicket ID: %TICKETID%\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','RE: Ticket: [%TICKETID%]','This message is to notify you that your ticket has been updated.\n\nTicket ID: %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','Ticket: [%TICKETID%] Assigned','This message is to notify you that you have been assigned a ticket.\n\nTicket ID# %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo check the status of this ticket, visit: \n%TICKETLINK%','FW: Ticket: [%TICKETID%]','This message is to notify you that you have been forwarded a ticket.\n\nTicket ID %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo view this ticket, visit:\n%TICKETLINK%','FW: Ticket: [%TICKETID%]','This message is to notify you that a ticket has been closed.\n\nTicket ID %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo view this ticket, visit:\n%TICKETLINK%','Ticket: [%TICKETID%]','This message is to notify you that your ticket has been submitted.\n\nTicket ID: %TICKETID%\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','RE: Ticket: [%TICKETID%]','This message is to notify you that your ticket has been updated.\n\nTicket ID: %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','FW: Ticket: [%TICKETID%]','This message is to notify you that a ticket has been closed.\n\nTicket ID %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo view this ticket, visit:\n%TICKETLINK%','Ticket: [%TICKETID%]','This message is to notify you that your ticket has been submitted.\n\nTicket ID: %TICKETID%\n\nTo check the status of this ticket, visit:\n%TICKETLINK%',0,1),(42,'fnb','',39,0,0,0,'',23,1,0,'','',0,'Ticket: [%TICKETID%]','This message is to notify you that your ticket has been submitted.\n\nTicket ID: %TICKETID%\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','RE: Ticket: [%TICKETID%]','This message is to notify you that your ticket has been updated.\n\nTicket ID: %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','Ticket: [%TICKETID%] Assigned','This message is to notify you that you have been assigned a ticket.\n\nTicket ID# %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo check the status of this ticket, visit: \n%TICKETLINK%','FW: Ticket: [%TICKETID%]','This message is to notify you that you have been forwarded a ticket.\n\nTicket ID %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo view this ticket, visit:\n%TICKETLINK%','FW: Ticket: [%TICKETID%]','This message is to notify you that a ticket has been closed.\n\nTicket ID %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo view this ticket, visit:\n%TICKETLINK%','Ticket: [%TICKETID%]','This message is to notify you that your ticket has been submitted.\n\nTicket ID: %TICKETID%\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','RE: Ticket: [%TICKETID%]','This message is to notify you that your ticket has been updated.\n\nTicket ID: %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','FW: Ticket: [%TICKETID%]','This message is to notify you that a ticket has been closed.\n\nTicket ID %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo view this ticket, visit:\n%TICKETLINK%','Ticket: [%TICKETID%]','This message is to notify you that your ticket has been submitted.\n\nTicket ID: %TICKETID%\n\nTo check the status of this ticket, visit:\n%TICKETLINK%',0,1),(43,'fsp','',39,0,0,0,'',23,1,0,'','',0,'Ticket: [%TICKETID%]','This message is to notify you that your ticket has been submitted.\n\nTicket ID: %TICKETID%\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','RE: Ticket: [%TICKETID%]','This message is to notify you that your ticket has been updated.\n\nTicket ID: %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','Ticket: [%TICKETID%] Assigned','This message is to notify you that you have been assigned a ticket.\n\nTicket ID# %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo check the status of this ticket, visit: \n%TICKETLINK%','FW: Ticket: [%TICKETID%]','This message is to notify you that you have been forwarded a ticket.\n\nTicket ID %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo view this ticket, visit:\n%TICKETLINK%','FW: Ticket: [%TICKETID%]','This message is to notify you that a ticket has been closed.\n\nTicket ID %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo view this ticket, visit:\n%TICKETLINK%','Ticket: [%TICKETID%]','This message is to notify you that your ticket has been submitted.\n\nTicket ID: %TICKETID%\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','RE: Ticket: [%TICKETID%]','This message is to notify you that your ticket has been updated.\n\nTicket ID: %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','FW: Ticket: [%TICKETID%]','This message is to notify you that a ticket has been closed.\n\nTicket ID %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo view this ticket, visit:\n%TICKETLINK%','Ticket: [%TICKETID%]','This message is to notify you that your ticket has been submitted.\n\nTicket ID: %TICKETID%\n\nTo check the status of this ticket, visit:\n%TICKETLINK%',0,1),(44,'fusion','',39,0,0,0,'',23,1,0,'','',0,'Ticket: [%TICKETID%]','This message is to notify you that your ticket has been submitted.\n\nTicket ID: %TICKETID%\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','RE: Ticket: [%TICKETID%]','This message is to notify you that your ticket has been updated.\n\nTicket ID: %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','Ticket: [%TICKETID%] Assigned','This message is to notify you that you have been assigned a ticket.\n\nTicket ID# %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo check the status of this ticket, visit: \n%TICKETLINK%','FW: Ticket: [%TICKETID%]','This message is to notify you that you have been forwarded a ticket.\n\nTicket ID %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo view this ticket, visit:\n%TICKETLINK%','FW: Ticket: [%TICKETID%]','This message is to notify you that a ticket has been closed.\n\nTicket ID %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo view this ticket, visit:\n%TICKETLINK%','Ticket: [%TICKETID%]','This message is to notify you that your ticket has been submitted.\n\nTicket ID: %TICKETID%\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','RE: Ticket: [%TICKETID%]','This message is to notify you that your ticket has been updated.\n\nTicket ID: %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','FW: Ticket: [%TICKETID%]','This message is to notify you that a ticket has been closed.\n\nTicket ID %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo view this ticket, visit:\n%TICKETLINK%','Ticket: [%TICKETID%]','This message is to notify you that your ticket has been submitted.\n\nTicket ID: %TICKETID%\n\nTo check the status of this ticket, visit:\n%TICKETLINK%',0,1),(45,'is','',39,0,0,0,'',23,1,0,'','',0,'Ticket: [%TICKETID%]','This message is to notify you that your ticket has been submitted.\n\nTicket ID: %TICKETID%\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','RE: Ticket: [%TICKETID%]','This message is to notify you that your ticket has been updated.\n\nTicket ID: %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','Ticket: [%TICKETID%] Assigned','This message is to notify you that you have been assigned a ticket.\n\nTicket ID# %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo check the status of this ticket, visit: \n%TICKETLINK%','FW: Ticket: [%TICKETID%]','This message is to notify you that you have been forwarded a ticket.\n\nTicket ID %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo view this ticket, visit:\n%TICKETLINK%','FW: Ticket: [%TICKETID%]','This message is to notify you that a ticket has been closed.\n\nTicket ID %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo view this ticket, visit:\n%TICKETLINK%','Ticket: [%TICKETID%]','This message is to notify you that your ticket has been submitted.\n\nTicket ID: %TICKETID%\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','RE: Ticket: [%TICKETID%]','This message is to notify you that your ticket has been updated.\n\nTicket ID: %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','FW: Ticket: [%TICKETID%]','This message is to notify you that a ticket has been closed.\n\nTicket ID %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo view this ticket, visit:\n%TICKETLINK%','Ticket: [%TICKETID%]','This message is to notify you that your ticket has been submitted.\n\nTicket ID: %TICKETID%\n\nTo check the status of this ticket, visit:\n%TICKETLINK%',0,1),(46,'itec','',39,0,0,0,'',23,1,0,'','',0,'Ticket: [%TICKETID%]','This message is to notify you that your ticket has been submitted.\n\nTicket ID: %TICKETID%\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','RE: Ticket: [%TICKETID%]','This message is to notify you that your ticket has been updated.\n\nTicket ID: %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','Ticket: [%TICKETID%] Assigned','This message is to notify you that you have been assigned a ticket.\n\nTicket ID# %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo check the status of this ticket, visit: \n%TICKETLINK%','FW: Ticket: [%TICKETID%]','This message is to notify you that you have been forwarded a ticket.\n\nTicket ID %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo view this ticket, visit:\n%TICKETLINK%','FW: Ticket: [%TICKETID%]','This message is to notify you that a ticket has been closed.\n\nTicket ID %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo view this ticket, visit:\n%TICKETLINK%','Ticket: [%TICKETID%]','This message is to notify you that your ticket has been submitted.\n\nTicket ID: %TICKETID%\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','RE: Ticket: [%TICKETID%]','This message is to notify you that your ticket has been updated.\n\nTicket ID: %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','FW: Ticket: [%TICKETID%]','This message is to notify you that a ticket has been closed.\n\nTicket ID %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo view this ticket, visit:\n%TICKETLINK%','Ticket: [%TICKETID%]','This message is to notify you that your ticket has been submitted.\n\nTicket ID: %TICKETID%\n\nTo check the status of this ticket, visit:\n%TICKETLINK%',0,1),(47,'mailservice','',39,0,0,0,'',23,1,0,'','',0,'Ticket: [%TICKETID%]','This message is to notify you that your ticket has been submitted.\n\nTicket ID: %TICKETID%\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','RE: Ticket: [%TICKETID%]','This message is to notify you that your ticket has been updated.\n\nTicket ID: %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','Ticket: [%TICKETID%] Assigned','This message is to notify you that you have been assigned a ticket.\n\nTicket ID# %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo check the status of this ticket, visit: \n%TICKETLINK%','FW: Ticket: [%TICKETID%]','This message is to notify you that you have been forwarded a ticket.\n\nTicket ID %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo view this ticket, visit:\n%TICKETLINK%','FW: Ticket: [%TICKETID%]','This message is to notify you that a ticket has been closed.\n\nTicket ID %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo view this ticket, visit:\n%TICKETLINK%','Ticket: [%TICKETID%]','This message is to notify you that your ticket has been submitted.\n\nTicket ID: %TICKETID%\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','RE: Ticket: [%TICKETID%]','This message is to notify you that your ticket has been updated.\n\nTicket ID: %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','FW: Ticket: [%TICKETID%]','This message is to notify you that a ticket has been closed.\n\nTicket ID %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo view this ticket, visit:\n%TICKETLINK%','Ticket: [%TICKETID%]','This message is to notify you that your ticket has been submitted.\n\nTicket ID: %TICKETID%\n\nTo check the status of this ticket, visit:\n%TICKETLINK%',0,1),(48,'nowmedia','',39,0,0,0,'',23,1,0,'','',0,'Ticket: [%TICKETID%]','This message is to notify you that your ticket has been submitted.\n\nTicket ID: %TICKETID%\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','RE: Ticket: [%TICKETID%]','This message is to notify you that your ticket has been updated.\n\nTicket ID: %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','Ticket: [%TICKETID%] Assigned','This message is to notify you that you have been assigned a ticket.\n\nTicket ID# %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo check the status of this ticket, visit: \n%TICKETLINK%','FW: Ticket: [%TICKETID%]','This message is to notify you that you have been forwarded a ticket.\n\nTicket ID %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo view this ticket, visit:\n%TICKETLINK%','FW: Ticket: [%TICKETID%]','This message is to notify you that a ticket has been closed.\n\nTicket ID %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo view this ticket, visit:\n%TICKETLINK%','Ticket: [%TICKETID%]','This message is to notify you that your ticket has been submitted.\n\nTicket ID: %TICKETID%\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','RE: Ticket: [%TICKETID%]','This message is to notify you that your ticket has been updated.\n\nTicket ID: %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','FW: Ticket: [%TICKETID%]','This message is to notify you that a ticket has been closed.\n\nTicket ID %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo view this ticket, visit:\n%TICKETLINK%','Ticket: [%TICKETID%]','This message is to notify you that your ticket has been submitted.\n\nTicket ID: %TICKETID%\n\nTo check the status of this ticket, visit:\n%TICKETLINK%',0,1),(49,'retailtribe','',39,0,0,0,'',23,1,0,'','',0,'Ticket: [%TICKETID%]','This message is to notify you that your ticket has been submitted.\n\nTicket ID: %TICKETID%\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','RE: Ticket: [%TICKETID%]','This message is to notify you that your ticket has been updated.\n\nTicket ID: %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','Ticket: [%TICKETID%] Assigned','This message is to notify you that you have been assigned a ticket.\n\nTicket ID# %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo check the status of this ticket, visit: \n%TICKETLINK%','FW: Ticket: [%TICKETID%]','This message is to notify you that you have been forwarded a ticket.\n\nTicket ID %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo view this ticket, visit:\n%TICKETLINK%','FW: Ticket: [%TICKETID%]','This message is to notify you that a ticket has been closed.\n\nTicket ID %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo view this ticket, visit:\n%TICKETLINK%','Ticket: [%TICKETID%]','This message is to notify you that your ticket has been submitted.\n\nTicket ID: %TICKETID%\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','RE: Ticket: [%TICKETID%]','This message is to notify you that your ticket has been updated.\n\nTicket ID: %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','FW: Ticket: [%TICKETID%]','This message is to notify you that a ticket has been closed.\n\nTicket ID %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo view this ticket, visit:\n%TICKETLINK%','Ticket: [%TICKETID%]','This message is to notify you that your ticket has been submitted.\n\nTicket ID: %TICKETID%\n\nTo check the status of this ticket, visit:\n%TICKETLINK%',0,1),(50,'totalexposure','',39,0,0,0,'',23,1,0,'','',0,'Ticket: [%TICKETID%]','This message is to notify you that your ticket has been submitted.\n\nTicket ID: %TICKETID%\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','RE: Ticket: [%TICKETID%]','This message is to notify you that your ticket has been updated.\n\nTicket ID: %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','Ticket: [%TICKETID%] Assigned','This message is to notify you that you have been assigned a ticket.\n\nTicket ID# %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo check the status of this ticket, visit: \n%TICKETLINK%','FW: Ticket: [%TICKETID%]','This message is to notify you that you have been forwarded a ticket.\n\nTicket ID %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo view this ticket, visit:\n%TICKETLINK%','FW: Ticket: [%TICKETID%]','This message is to notify you that a ticket has been closed.\n\nTicket ID %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo view this ticket, visit:\n%TICKETLINK%','Ticket: [%TICKETID%]','This message is to notify you that your ticket has been submitted.\n\nTicket ID: %TICKETID%\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','RE: Ticket: [%TICKETID%]','This message is to notify you that your ticket has been updated.\n\nTicket ID: %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','FW: Ticket: [%TICKETID%]','This message is to notify you that a ticket has been closed.\n\nTicket ID %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo view this ticket, visit:\n%TICKETLINK%','Ticket: [%TICKETID%]','This message is to notify you that your ticket has been submitted.\n\nTicket ID: %TICKETID%\n\nTo check the status of this ticket, visit:\n%TICKETLINK%',0,1),(51,'velocity','',39,0,0,0,'',23,1,0,'','',0,'Ticket: [%TICKETID%]','This message is to notify you that your ticket has been submitted.\n\nTicket ID: %TICKETID%\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','RE: Ticket: [%TICKETID%]','This message is to notify you that your ticket has been updated.\n\nTicket ID: %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','Ticket: [%TICKETID%] Assigned','This message is to notify you that you have been assigned a ticket.\n\nTicket ID# %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo check the status of this ticket, visit: \n%TICKETLINK%','FW: Ticket: [%TICKETID%]','This message is to notify you that you have been forwarded a ticket.\n\nTicket ID %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo view this ticket, visit:\n%TICKETLINK%','FW: Ticket: [%TICKETID%]','This message is to notify you that a ticket has been closed.\n\nTicket ID %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo view this ticket, visit:\n%TICKETLINK%','Ticket: [%TICKETID%]','This message is to notify you that your ticket has been submitted.\n\nTicket ID: %TICKETID%\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','RE: Ticket: [%TICKETID%]','This message is to notify you that your ticket has been updated.\n\nTicket ID: %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','FW: Ticket: [%TICKETID%]','This message is to notify you that a ticket has been closed.\n\nTicket ID %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo view this ticket, visit:\n%TICKETLINK%','Ticket: [%TICKETID%]','This message is to notify you that your ticket has been submitted.\n\nTicket ID: %TICKETID%\n\nTo check the status of this ticket, visit:\n%TICKETLINK%',0,1),(52,'virtualworks','',39,0,0,0,'',23,1,0,'','',0,'Ticket: [%TICKETID%]','This message is to notify you that your ticket has been submitted.\n\nTicket ID: %TICKETID%\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','RE: Ticket: [%TICKETID%]','This message is to notify you that your ticket has been updated.\n\nTicket ID: %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','Ticket: [%TICKETID%] Assigned','This message is to notify you that you have been assigned a ticket.\n\nTicket ID# %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo check the status of this ticket, visit: \n%TICKETLINK%','FW: Ticket: [%TICKETID%]','This message is to notify you that you have been forwarded a ticket.\n\nTicket ID %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo view this ticket, visit:\n%TICKETLINK%','FW: Ticket: [%TICKETID%]','This message is to notify you that a ticket has been closed.\n\nTicket ID %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo view this ticket, visit:\n%TICKETLINK%','Ticket: [%TICKETID%]','This message is to notify you that your ticket has been submitted.\n\nTicket ID: %TICKETID%\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','RE: Ticket: [%TICKETID%]','This message is to notify you that your ticket has been updated.\n\nTicket ID: %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo check the status of this ticket, visit:\n%TICKETLINK%','FW: Ticket: [%TICKETID%]','This message is to notify you that a ticket has been closed.\n\nTicket ID %TICKETID%\n\nLast Post:\n----------------------------------\n%LASTPOST%\n----------------------------------\n\nTo view this ticket, visit:\n%TICKETLINK%','Ticket: [%TICKETID%]','This message is to notify you that your ticket has been submitted.\n\nTicket ID: %TICKETID%\n\nTo check the status of this ticket, visit:\n%TICKETLINK%',0,1);
/*!40000 ALTER TABLE `tt_category` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tt_cport`
--
DROP TABLE IF EXISTS `tt_cport`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tt_cport` (
`id` int(10) NOT NULL auto_increment,
`active` int(1) NOT NULL default '0',
`host` varchar(250) collate latin1_general_ci NOT NULL default '',
`admin_email` varchar(250) collate latin1_general_ci NOT NULL default '',
`hdesc` text collate latin1_general_ci NOT NULL,
`dns` varchar(255) collate latin1_general_ci NOT NULL default '',
`horder` int(10) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tt_cport`
--
LOCK TABLES `tt_cport` WRITE;
/*!40000 ALTER TABLE `tt_cport` DISABLE KEYS */;
INSERT INTO `tt_cport` VALUES (1,1,'usuk.prefix.co.za','josh@prefix.co.za','International Web Server Cluster','',2),(3,1,'africa.prefix.co.za','josh@prefix.co.za','SA/ZA Web Server Cluster','',2),(7,1,'www.pmailer.co.za','josh@prefix.co.za','The pMailer server cluster.','',0),(5,1,'pdigital.co.za','josh@prefix.co.za','pDigitalAssets/Fileshare high-speed network','',4);
/*!40000 ALTER TABLE `tt_cport` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tt_cport_d`
--
DROP TABLE IF EXISTS `tt_cport_d`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tt_cport_d` (
`id` int(10) NOT NULL auto_increment,
`sid` int(10) NOT NULL default '0',
`name` varchar(250) collate latin1_general_ci NOT NULL default '',
`pnumber` varchar(25) collate latin1_general_ci NOT NULL default '',
`timeout` int(10) NOT NULL default '0',
`last_check` timestamp NOT NULL default '0000-00-00 00:00:00',
`last_status` int(5) NOT NULL default '0',
`porder` int(10) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `sid` (`sid`)
) ENGINE=MyISAM AUTO_INCREMENT=36 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tt_cport_d`
--
LOCK TABLES `tt_cport_d` WRITE;
/*!40000 ALTER TABLE `tt_cport_d` DISABLE KEYS */;
INSERT INTO `tt_cport_d` VALUES (1,1,'Web Server','80',10,'2008-03-13 15:00:02',0,1),(2,1,'FTP','21',10,'2008-03-13 15:00:02',0,2),(3,1,'Telnet','23',10,'2008-03-13 15:00:02',0,3),(4,1,'SMTP','25',10,'2008-03-13 15:00:02',0,4),(5,1,'POP','110',10,'2008-03-13 15:00:02',0,5),(34,7,'Outgoing Mail','25',10,'2008-03-13 15:00:02',0,4),(35,7,'Bounces Handler','110',10,'2008-03-13 15:00:02',0,5),(11,3,'Web Server','80',10,'2008-03-13 15:00:02',0,1),(12,3,'FTP','21',10,'2008-03-13 15:00:02',0,2),(13,3,'Telnet','23',10,'2008-03-13 15:00:02',0,3),(14,3,'SMTP','25',10,'2008-03-13 15:00:02',0,4),(15,3,'POP','110',10,'2008-03-13 15:00:02',0,5),(31,7,'Website & Tools','80',10,'2008-03-13 15:00:02',0,1),(21,5,'Web Server','80',10,'2008-03-13 15:00:02',0,1),(22,5,'FTP','21',10,'2008-03-13 15:00:02',0,2),(23,5,'Telnet','23',10,'2008-03-13 15:00:02',0,3),(24,5,'SMTP','25',10,'2008-03-13 15:00:02',0,4),(25,5,'POP','110',10,'2008-03-13 15:00:02',0,5);
/*!40000 ALTER TABLE `tt_cport_d` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tt_cpriority`
--
DROP TABLE IF EXISTS `tt_cpriority`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tt_cpriority` (
`id` int(10) NOT NULL auto_increment,
`title` varchar(255) collate latin1_general_ci NOT NULL default '',
`imgpath` varchar(255) collate latin1_general_ci NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tt_cpriority`
--
LOCK TABLES `tt_cpriority` WRITE;
/*!40000 ALTER TABLE `tt_cpriority` DISABLE KEYS */;
INSERT INTO `tt_cpriority` VALUES (1,'Low','media/priority_low.gif'),(2,'Normal',''),(3,'High / Urgent','media/priority_high.gif');
/*!40000 ALTER TABLE `tt_cpriority` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tt_cstatus`
--
DROP TABLE IF EXISTS `tt_cstatus`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tt_cstatus` (
`id` int(10) NOT NULL auto_increment,
`title` varchar(255) collate latin1_general_ci NOT NULL default '',
`sticky` int(1) NOT NULL default '0',
`startup` int(1) NOT NULL default '1',
`duration` int(1) NOT NULL default '1',
`showopen_a` tinyint(1) unsigned NOT NULL default '0',
`showopen_p` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tt_cstatus`
--
LOCK TABLES `tt_cstatus` WRITE;
/*!40000 ALTER TABLE `tt_cstatus` DISABLE KEYS */;
INSERT INTO `tt_cstatus` VALUES (1,'New / Submitted',0,1,1,1,1),(2,'Viewed / Pre-action',0,1,1,1,1),(3,'Assigned / In Progress',0,1,1,1,1),(4,'Closed',0,0,1,0,0),(5,'Resolved / Completed',0,0,1,0,1),(6,'Re-Opened',0,1,1,1,1),(9,'Resolved / For Billing',0,1,1,0,1);
/*!40000 ALTER TABLE `tt_cstatus` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tt_desk`
--
DROP TABLE IF EXISTS `tt_desk`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tt_desk` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(250) collate latin1_general_ci NOT NULL default '',
`announce` longtext collate latin1_general_ci NOT NULL,
`kb` longtext collate latin1_general_ci NOT NULL,
`departments` text collate latin1_general_ci NOT NULL,
`files` longtext collate latin1_general_ci NOT NULL,
`portscanner` text collate latin1_general_ci NOT NULL,
`troubleshooter` text collate latin1_general_ci NOT NULL,
`showan` int(1) NOT NULL default '1',
`showkb` int(1) NOT NULL default '1',
`showfi` int(1) NOT NULL default '1',
`showpo` int(1) NOT NULL default '1',
`showtr` int(1) NOT NULL default '1',
`showti` int(1) NOT NULL default '1',
`lang` varchar(250) collate latin1_general_ci NOT NULL default 'english',
`showla` int(1) NOT NULL default '1',
`layout` text collate latin1_general_ci NOT NULL,
`logo` text collate latin1_general_ci,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tt_desk`
--
LOCK TABLES `tt_desk` WRITE;
/*!40000 ALTER TABLE `tt_desk` DISABLE KEYS */;
INSERT INTO `tt_desk` VALUES (3,'hosting',' , 9 , , 1 , , 4 , , 15 , ',' , 1 , , 8 , , 9 , , 10 , ',' , 9 , , 15 , ','',' , 3 , , 1 , ','',1,1,0,1,0,1,'english',1,' , 19 , ','../media/logo-2.jpg'),(4,'pmailer','',' , 2 , , 27 , , 29 , , 32 , , 34 , , 35 , , 36 , , 37 , ',' , 2 , , 16 , , 15 , ','',' , 7 , ','',0,1,0,0,0,1,'english',0,'-','http://helpdesk.prefix.co.za/desk/pmailer/media/banner.jpg'),(5,'preditor','','','','','','',0,1,0,0,0,1,'english',0,'-','http://helpdesk.prefix.co.za/media/preditor_desk.png');
/*!40000 ALTER TABLE `tt_desk` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tt_em_actions`
--
DROP TABLE IF EXISTS `tt_em_actions`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tt_em_actions` (
`id` varchar(75) collate latin1_general_ci NOT NULL default '',
`val` varchar(75) collate latin1_general_ci NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tt_em_actions`
--
LOCK TABLES `tt_em_actions` WRITE;
/*!40000 ALTER TABLE `tt_em_actions` DISABLE KEYS */;
INSERT INTO `tt_em_actions` VALUES ('CLOSE','CLOSE'),('COMMENT','COMMENT'),('DELETE','DELETE'),('RESOLVE','RESOLVE'),('SPAM','SPAM'),('STICK','STICK'),('UNSTICK','UNSTICK');
/*!40000 ALTER TABLE `tt_em_actions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tt_em_filter`
--
DROP TABLE IF EXISTS `tt_em_filter`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tt_em_filter` (
`id` int(50) NOT NULL auto_increment,
`popid` int(10) NOT NULL default '0',
`catcha` int(1) NOT NULL default '0',
`name` varchar(250) collate latin1_general_ci NOT NULL default '',
`arg1` varchar(250) collate latin1_general_ci NOT NULL default '',
`arg2` varchar(250) collate latin1_general_ci NOT NULL default '',
`arg3` varchar(250) collate latin1_general_ci NOT NULL default '',
`dep` int(25) NOT NULL default '0',
`assign` varchar(250) collate latin1_general_ci NOT NULL default '',
`status` int(10) NOT NULL default '1',
`priority` int(10) NOT NULL default '0',
`fdelete` int(1) NOT NULL default '0',
`forder` int(10) NOT NULL default '0',
`mailsubject` int(10) NOT NULL default '0',
`recipient` varchar(255) collate latin1_general_ci NOT NULL default '_sender_',
`desk` varchar(128) collate latin1_general_ci NOT NULL default '',
PRIMARY KEY (`id`),
KEY `popid` (`popid`)
) ENGINE=MyISAM AUTO_INCREMENT=57 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tt_em_filter`
--
LOCK TABLES `tt_em_filter` WRITE;
/*!40000 ALTER TABLE `tt_em_filter` DISABLE KEYS */;
INSERT INTO `tt_em_filter` VALUES (13,7,1,'','','','',8,'0',1,3,0,1234554321,5,'josh@prefix.co.za',''),(14,7,0,'coza tickets','sender','contains','ticketman@co.za',8,'',1,0,0,0,5,'josh@prefix.co.za',''),(10,6,1,'','','','',15,'',1,0,0,1234554321,0,'_sender_',''),(50,21,1,'','','','',35,'26',1,0,0,1234554321,0,'_sender_',''),(51,22,1,'','','','',34,'23',1,0,0,1234554321,0,'_sender_',''),(52,23,1,'','','','',36,'26',1,0,0,1234554321,0,'_sender_',''),(53,24,1,'','','','',37,'26',1,0,0,1234554321,0,'_sender_',''),(54,25,1,'','','','',14,'0',1,0,0,1234554321,0,'_sender_',''),(55,26,1,'','','','',9,'0',1,0,0,1234554321,0,'_sender_',''),(56,27,1,'','','','',16,'0',1,0,0,1234554321,0,'_sender_',''),(40,0,0,'','subject','contains','%pMailer Online Order%',0,'',1,0,0,0,0,'_sender_','');
/*!40000 ALTER TABLE `tt_em_filter` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tt_em_filter_mails`
--
DROP TABLE IF EXISTS `tt_em_filter_mails`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tt_em_filter_mails` (
`id` int(50) NOT NULL auto_increment,
`sender` varchar(255) collate latin1_general_ci NOT NULL default '',
`subject` varchar(255) collate latin1_general_ci NOT NULL default '',
`content` text collate latin1_general_ci NOT NULL,
`html` int(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tt_em_filter_mails`
--
LOCK TABLES `tt_em_filter_mails` WRITE;
/*!40000 ALTER TABLE `tt_em_filter_mails` DISABLE KEYS */;
INSERT INTO `tt_em_filter_mails` VALUES (6,'pMailer Activations','Your pMailer order is being processed','Welcome to pMailer & Thank you for your order!\r\n\r\nA sales representative will be in touch shortly and our system will provide you with your account details as soon as your account has been verified by our team.\r\n\r\nWe look forward to you being apart of our pMailer email marketing family.\r\n\r\n- Prefix Technologies / pMailer.co.za\r\n\r\nOrder/Ticket ID: %TICKETID%\r\nStatus: %STATUS%\r\n',0),(5,'do-not-reply@prefix.co.za','Urgent: DNS update request has been recieved!','Hello Prefix Team,\r\n\r\nA DNS update request has been recieved and requires attention. Please check the following before accepting / denying the request:\r\n\r\n1. That a cancellation or move request has been recieved by admin/sales.\r\n2. That the account/arrears is not more than 30 days overdue with billing. We cannot move unpaid accounts.\r\n\r\nDeny requests that fail either of these two tests.\r\n\r\nJosh (DNS-Super-Admin!)\r\n\r\n--\r\nTicket ID: %TICKETID%\r\nFrom: %CLIENT-EMAIL%\r\nDepartment: %DEPARTMENT%\r\nhttp://helpdesk.prefix.co.za/admin/main.php?action=view_ticket&id=%TICKETID%',0);
/*!40000 ALTER TABLE `tt_em_filter_mails` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tt_faqadmin`
--
DROP TABLE IF EXISTS `tt_faqadmin`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tt_faqadmin` (
`id` int(50) NOT NULL auto_increment,
`user_id` int(11) NOT NULL default '0',
`m_users` int(5) NOT NULL default '0',
`m_lists` int(5) NOT NULL default '0',
`m_cre_del` int(5) NOT NULL default '0',
`send` int(5) NOT NULL default '0',
`lists` text collate latin1_general_ci,
`p_cata` int(10) NOT NULL default '0',
`p_arta` int(10) NOT NULL default '0',
`p_com` int(10) NOT NULL default '0',
`p_catd` int(10) NOT NULL default '0',
`p_artd` int(10) NOT NULL default '0',
`p_catm` int(10) NOT NULL default '0',
`p_gm` int(1) NOT NULL default '0',
`p_ga` int(1) NOT NULL default '0',
`p_apart` int(10) NOT NULL default '0',
`profile` text collate latin1_general_ci,
`admin` int(10) NOT NULL default '0',
`super_admin` int(11) NOT NULL default '0',
`p_index` int(1) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tt_faqadmin`
--
LOCK TABLES `tt_faqadmin` WRITE;
/*!40000 ALTER TABLE `tt_faqadmin` DISABLE KEYS */;
INSERT INTO `tt_faqadmin` VALUES (1,1,0,0,0,0,'full',1,1,1,1,1,1,1,1,1,NULL,0,1,1),(2,2,0,0,0,0,'full',1,1,1,1,1,1,1,1,1,NULL,0,0,0),(3,3,0,0,0,0,'full',1,1,1,1,1,1,1,1,1,NULL,0,0,0),(4,4,0,0,0,0,'full',1,1,1,1,1,1,1,1,1,NULL,0,0,0),(5,5,0,0,0,0,'full',1,1,1,1,1,1,1,1,1,NULL,0,0,0),(6,6,0,0,0,0,'full',1,1,1,1,1,1,1,1,1,NULL,0,0,0),(7,7,0,0,0,0,'full',1,1,1,1,1,1,1,1,1,NULL,0,0,0),(8,8,0,0,0,0,'full',1,1,1,1,1,1,1,1,1,NULL,0,0,0),(9,9,0,0,0,0,'full',1,1,1,1,1,1,1,1,1,NULL,0,0,0),(10,10,0,0,0,0,'full',1,1,1,1,1,1,1,1,1,NULL,0,0,0),(11,11,0,0,0,0,'full',1,1,1,1,1,1,1,1,1,NULL,0,0,0),(12,12,0,0,0,0,'full',1,1,1,1,1,1,1,1,1,NULL,0,0,0),(13,14,0,0,0,0,'full',1,1,1,1,1,1,1,1,1,NULL,0,0,0),(14,15,0,0,0,0,'full',1,1,1,1,1,1,1,1,1,NULL,0,0,0),(15,16,0,0,0,0,'full',1,1,1,1,1,1,1,1,1,NULL,0,0,0),(16,17,0,0,0,0,'full',1,1,1,1,1,1,1,1,1,NULL,0,0,0),(17,18,0,0,0,0,'full',1,1,1,1,1,1,1,1,1,NULL,0,0,0),(18,19,0,0,0,0,'full',1,1,1,1,1,1,1,1,1,NULL,0,0,0),(19,20,0,0,0,0,'full',1,1,1,1,1,1,1,1,1,NULL,0,0,0),(20,21,0,0,0,0,'full',1,1,1,1,1,1,1,1,1,NULL,0,0,0),(21,22,0,0,0,0,'full',1,1,1,1,1,1,1,1,1,NULL,0,0,0),(22,23,0,0,0,0,'full',1,1,1,1,1,1,1,1,1,NULL,0,0,0);
/*!40000 ALTER TABLE `tt_faqadmin` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tt_faqarticles`
--
DROP TABLE IF EXISTS `tt_faqarticles`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tt_faqarticles` (
`id` int(20) NOT NULL auto_increment,
`cat` varchar(250) collate latin1_general_ci NOT NULL default '',
`question` text collate latin1_general_ci,
`content` longtext collate latin1_general_ci,
`keywords` text collate latin1_general_ci,
`approved` int(1) NOT NULL default '0',
`mirror` text collate latin1_general_ci,
`user` varchar(250) collate latin1_general_ci NOT NULL default '',
`date` date NOT NULL default '0000-00-00',
`mdate` date NOT NULL default '0000-00-00',
`numview` int(10) NOT NULL default '0',
`numemail` int(10) NOT NULL default '0',
`numsave` int(10) NOT NULL default '0',
`numprint` int(10) NOT NULL default '0',
`aname` varchar(250) collate latin1_general_ci NOT NULL default '',
`aemail` varchar(250) collate latin1_general_ci NOT NULL default '',
`path` text collate latin1_general_ci,
`lockf` int(10) NOT NULL default '0',
`sync` int(10) NOT NULL default '0',
PRIMARY KEY (`id`),
FULLTEXT KEY `content` (`content`),
FULLTEXT KEY `keywords` (`keywords`),
FULLTEXT KEY `question` (`question`)
) ENGINE=MyISAM AUTO_INCREMENT=87 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tt_faqarticles`
--
LOCK TABLES `tt_faqarticles` WRITE;
/*!40000 ALTER TABLE `tt_faqarticles` DISABLE KEYS */;
INSERT INTO `tt_faqarticles` VALUES (1,'8','The Prefix Server Network','Prefix Technologies manages a growing network infrastructure for our hosted solutions and direct relationships with key suppliers of the technology and data services we require as business.
The Prefix Network now has web, database, mail and backup servers co-located at four first-class facilities globally - Cape Town (South Africa), Johannesburg (South Africa), San-Francisco (USA) and Bayern (Germany). These locations allow us to provide the required redundancy, scale and choice to our diverse client base. All Prefix servers run on the Linux platform, and we offer customer-focused and targeted solutions that go far beyond traditional hosting. Clients can elect dedicated or shared/virtual server hosting arrangements, along with geographical location to best meet their requirements.
We procure bandwidth and connectivity via these data centres and have redundant connections through Verizon Business (SA), Internet Solutions (SA), Telkom (SA), AboveNet (Intl), MCI (Intl), Level3 (Intl, NTT/Verio (Intl) and AT&T (Intl).','',0,'','1','2007-01-18','2007-05-06',1985,21,395,656,'','',', 1 ,, 8 ,',0,0),(3,'9','How do I FTP into my account?','FTP (File Transfer Protocol) is a way to move files between computers on the Internet. FTP is commonly used to transfer web page files from your web-designers computer to our servers, and of course downloading in the other direction.
An FTP client is the desktop application in your computer that actually does the transferring of data (or files). Using an FTP client is relatively simple. We recommend the free FileZilla FTP programme, which can be downloaded from the downloads area of the Prefix Support Centre.
The following server details should be used when connecting to your hosting account via FTP:
\r\n
\r\n
FTP Host: your-domain.co.za
\r\n
FTP username: <as provided to you>
\r\n
FTP password: <as provided to you>
\r\n
Remote path (optional): /public_html/
\r\n
\r\nTake care to use simple filenames, and try to remove funny characters and spaces (rather use under-scores).','',0,'','1','2007-01-18','2007-05-06',1693,4,222,600,'','',', 1 ,, 9 ,',0,0),(4,'9','How do I access my website visitor statistics?','You can access your website\'s web-stats as follows:
Click on the "Website Stats" icon in the top nav bar.
\r\n
Fill in the form with your:
\r\n \r\n
[domain_name] = the domain of your website (eg. mycompany.co.za)
\r\n
[ftp_username] = the FTP/account username provided to you when you signed up for your account.
\r\n \r\n
A window will pop-up asking for your FTP user/account and password.
\r\n
Login to view your statistics.
\r\n\r\nPrefix Technologies\' uses AWStats to log and measure visitor traffic on our clients hosting accounts. AWStats is short for Advanced Web Statistics. AWStats is powerful log analyzer which creates advanced web, ftp, mail and streaming server statistics reports based on the rich data contained in server logs. Data is graphically presented in easy to read web pages.
AWStats\' reports include a wide range of information on your web site usage: \r\n
\r\n
Number of Visits, and number of Unique visitors.
\r\n
Visit duration and latest visits.
\r\n
Authenticated Users, and latest authenticated visits.
\r\n
Usage by Months, Days of week and Hours of the day (pages, hits, KB).
\r\n
Domains/countries (and regions, cities and ISP with Maxmind proprietary geo databases) of visitor\'s hosts (pages, hits, KB, 269 domains/countries detected).
\r\n
Hosts list, latest visits and unresolved IP addresses list.
\r\n
Most viewed, Entry and Exit pages.
\r\n
Most commonly requested File types.
\r\n
Web Compression statistics (for Apache servers using mod_gzip or mod_deflate modules).
\r\n
Visitor\'s Browsers (pages, hits, KB for each browser, each version, 123 browsers detected:
\r\n
Visitor\'s Operating Systems (pages, hits, KB for each OS, 45 OS detected).
\r\n
Robots visits, including search engine crawlers (381 robots detected).
\r\n
Search engines, Keywords and Phrases used to find your site (The 122 most famous search engines are detected like Yahoo, Google, Altavista, etc...)
\r\n
HTTP Errors (Page Not Found with latest referrer, ...).
\r\n
\r\nNote: Legacy clients can still access their old web-stats (webalizer) by going to www.your-domain.co.za/webalizer and logging in with your old username and password details. Please contact support for assistance in this regard.','',0,'','1','2007-01-18','2007-06-03',2344,4,400,667,'','',', 1 ,, 9 ,',0,0),(5,'9','How do I acess phpMyAdmin to manage my mySQL database?','','',1,'','1','2007-01-18','2007-01-18',1,0,0,0,'','',', 1 ,, 9 ,',0,0),(6,'10','Accessing my e-mail via Outlook (or other desktop e-mail client)','
Here are the details to use when creating a new e-mail account inside Outlook. Other e-mail clients such as Eudora, Evolution, MS Mail and thunderbird will be very similar.
\r\n
Main settings you need:
\r\n
\r\n
Incoming POP Server: pop.your-domain.com (port 110)
Username: email address (of the mailbox you wish to access)
\r\n
Password: your email account\'s password
\r\n
\r\n
Note: You can use our outgoing mail server (SMTP) settings if your e-mail programm (eg. Outlook) supported SMTP authentication. Please remember however that we strongly recommend that you use your own ISP’s outgoing SMTP server to send your mail to reduce your ISP and Hosting related costs. [Why? Read here]
\r\n
Outlook e-mail account setup instruction to collect e-mail from Prefix Technologies server accounts.
\r\n\r\n
Launch Microsoft Outlook/Express
\r\n
Select \'Tools\' from the top menu bar
\r\n
Select \'Accounts\'
\r\n
Select the \'Mail\' tab
\r\n
Click the \'Add\' button; Select \'Mail\'; The Internet Connection Wizard will appear
\r\n
Enter your name (to appear in your emails)
\r\n
Enter your email address
\r\n
Enter the email server names information as per sample configuration above
Your Outlook/Express mail program should now be setup
\r\n\r\n
Enabling SMTP Authentication:
\r\n\r\n
Select \'Tools\' from the top menu bar
\r\n
Select \'Accounts\'
\r\n
Select the \'Mail\' tab
\r\n
Double click on the mail account to open \'Properties\'
\r\n
Select the second tab \'Servers\'
\r\n
Select \'My server requires authentication\' under the \'Outgoing Mail Server\' section
\r\n
Click on \'Settings\' and ensure that the \'Use same settings as my incoming mail server\' checkbox is selected
\r\n
Select the \'Advanced\' tab
\r\n
Set the Outgoing Server (SMTP) port to 587
\r\n
The Incoming Server (POP) port should be set to the default setting, 110
\r\n
Select \'OK\' to complete the change
\r\n\r\n
Note: If SMTP authentication is not catered for by your mail program, please use the SMTP server delegated by your Internet Service Provider instead (smtp.your-isp.co.za).
','',0,'','1','2007-01-18','2007-05-06',3935,54,736,798,'','',', 1 ,, 10 ,',0,0),(9,'10','How to add a Auto-responder (vacation message) to your e-mail?','
If you are adding a vacation message to your own e-mail account:
Click on the MailAdmin icon at the top of the page.
\r\n
Login with your domain (NOT a specific e-mail address) your account/ftp password that was provided to you on account activation.
\r\n
The main window will display all e-mail accounts on the domain with action links to manage them.
\r\n
Click on the “Autoreply” link next to the e-mail address of the person you wish to leave a vacation message for. (a pop-window will appear)
\r\n
Turn the Autoreply status to “On
\r\n
Edit the message as you feel appropriate.
\r\n
Click on \'Submit\'
\r\n\r\n
When the user returns from holiday, simply login with the sample process and set the AutoReply status to “off” for that e-mail address.
\r\n
','',0,'','1','2007-01-18','2007-06-03',3032,32,436,843,'','',', 1 ,, 10 ,',0,0),(21,'9','How do I manage / access my mySQL database?','Prefix Technologies provides free access to a tool called PHPMyAdmin to administor and manage your mySQL databases.
You can access PHPMyAdmin for a specific database from the Hosting Control Panel as follows.
Login with your domain and the details for the specific database you want to manage. These details were provided in your welcome letter.
\r\n
You can now use PHPmyAdmin to upload, export and manipulate your SQL data.
\r\n','',0,'','2','2007-07-02','2007-07-02',1129,0,22,486,'','',', 1 ,, 9 ,',0,0),(22,'10','Outgoing SMTP servers - why you should use your ISP\'s to save money!','Prefix does not provide connectivity (ie. ADSL or dial-up accounts). For this you use your ISP (eg. Mweb, IS, Iburst, Telkom) and you connect to the internet through these companies before using Prefix\'s mail or web servers.
In South Africa, ISP\'s charge you for the ammnt of data you transfer on their networks. To avoid being charged unecessarily, we recommend that you use your ISP\'s outgoing mail servers (smtp servers) to send your e-mail from Outlook (or other e-mail programme). You can set your outgoing mailserver for each mail account in the "accounts" settings area of MS-Outlook.
Why? When you send a mail of 10MB, your ISP charges you for the 10MB sent as you connect to the internet through them. If you use our mail servers, we also charge you for the 10MB as you\'ve now passed through our network before the e-mail gets delivered to the recipient.
If you use your ISP\'s outgoing mailserver (eg. smpt.mweb.co.za) you will not be charged again for your usage of the Prefix mailserver for outgoing mail.
Remeber that your account with Prefix has an allocated bandwidth quote (eg. 3GB p/month). By using your ISP\'s SMTP servers, your quota with Prefix will be reached slower, allowing you to use your bandwidth quota for extra incoming mail and service website traffic without incurring extra charges should you exceed your limits.','',0,'','2','2007-07-09','2007-07-27',1367,0,40,533,'','',', 1 ,, 10 ,',0,0),(19,'10','How to access & use your webmail?','To access your webmail, head to the Prefix Hosting Control Panel @ http://www.prefix.co.za/hosting
\r\n\r\n
Click on the Webmail icon (top)
\r\n
Login with your e-mail address and password
\r\n
Your Inbox will appear, and you can use it like any other e-mail programme to view, compose and send e-mail messages.
\r\n\r\nOur webmail tools are very powerful, and allow you to create folders and organise your mail.
Your webmail is also where you can access your Spam-Bucket. This is where e-mail that our anti-spam systems store e-mail that we think is spam. Please read more about the Spam Bucket in our spam articles in this section.
there is a comprehensive HELP menu, accessible when you login to your webmail, from the top menu. Access for assistance on using the webmail interface with issues like attachments and other topics.','',0,'','2','2007-07-02','2007-07-02',1326,0,27,505,'','',', 1 ,, 10 ,',0,0),(20,'10','How does Prefix manage Spam and how do I access my Spam Bucket?','Prefix Technologies uses a well-known suite of anti-spam tools called SpamAssassin to reduce as far as possible th spam recieved by our e-mail users. Every e-mail that is recieved by Prefix Technologies mail servers is scanned and give a score. If the score is above certain threshold (eg: 5), the e-mail is marked as spam, and sent to the users Spam Bucket.
The Spam threshold is set for each domain, and you can request that your threshold is moved up or down as per your company requirements. To do this, simpl e-mail support@prefix.co.za and request that your spam threshold be increased or decreased. If you are recieving too much spam, ask for the threshold to decrease. If you feel too many legitimate e-mails are being caught in your spam-bucket, then ask for your threshold to be increased. Threshold scores range from 1 to 10 - the default and recommended is 5.
You can access your spam-bucket by logging into your webmail. Once logged in, click on the folder drop-down at the top right, and select the spam bucket folder. If you see emails that should not be spam in the bucket, tick the box next to these emails and "move" them to your inbox. They will then be available for download the next time you send/recieve.
The last tool we have to assist in managing spam is our blacklist and whitelist feature. Again, this is a per-domain setting, and requests for changes can be requested by sending an e-mail to support@prefix.co.za. If you consistently get e-mail from an abusive party, ask for that e-mail address or domain to be blacklisted on your account. These e-mails will automatically then be deleted. Similarly, if e-mail from an important client or colleage consistently gets trapped in your spam-bucket, you can ask for that address or domain to be white-listed. This will ensure any mail from this person is placed directly in your inbox.
Please feel free to ask our support staff further questions about Spam and e-mail. We work hard to manage spam as best as we can to enable you to focus on your real work.
[keywords: blacklist, whitelist, black-list, white-list]','',0,'','2','2007-07-02','2007-08-29',1204,0,23,469,'','',', 1 ,, 10 ,',0,0),(18,'10','How to change your e-mail password?','Changing your e-mail password is very easy. Follow these steps.
Fill in your e-mail address and current e-mail password
\r\n
Your e-mail account details will appear.
\r\n
Click on the "Edit" link in the action column next to your e-mail address.
\r\n
A pop-up window will appear.
\r\n
Fill in your new passwod in the first password field.
\r\n
Repeat the password in the second password field.
\r\n
Leave the "Fwd" fields as they are. These are only used if you want your incoming mail forwarded to another account.
\r\n
Click "Submit"
\r\n
Wait for the confirmation message.
\r\n
Close the pop-up window or click "menu" to go back to the hosting control panel.
\r\n\r\nYour password is now updated. Remember to change your password in your e-mail client (eg. Outlook or Thunderbird) so your mail downloads with your new password settings.','',0,'','2','2007-07-02','2007-07-02',1510,2,31,568,'','',', 1 ,, 10 ,',0,0),(16,'10','Definition: What is an e-mail alias?','
An email alias is a “pointer” e-mail address to another e-mail account. In essence, it forwards any/all email it receives to another email account.
\r\n
Aliases are most used for common services. For example, if you have regularly changing sales staff, then sales@yourdomain.com would be created as an alias to the current salesperson (eg. john@yourdomain.com). When a new salesperson is hired, you simply change the account to which sales@ is aliased to the new person’s email account.
\r\n
\r\n
Extra info:
\r\n
\r\n
\r\n
You can also set-up an email alias to forward to an account outside of your domain name as well. For example, you can set-up info@your-domain.com to go to myemail@prefix.co.za
\r\n
Want to point an alias to more than one account? No problem. You can also set-up an email alias to forward to multiple usernames or another alias.
\r\n
By using aliases cleverly, you can reduce the number of e-mail accounts you need to use, and save on the cost of your hosting account with Prefix Technologies by managing your growth effectively.
\r\n
','',0,'','2','2007-05-06','2007-05-06',1858,1,117,620,'','',', 1 ,, 10 ,',0,0),(17,'10','How to add extra e-mail accounts or e-mail aliases to your domain?','
Each hosting account with Prefix Technologies has a certain number of e-mail accounts allocated to it. The number of e-mail accounts depends on the package type you purchased. If you have not used up your allocated quota of e-mail accounts for your domain, adding new accounts or managing existing e-mail accounts is very simple.
Click on the MailAdmin icon at the top of the page.
\r\n
Login with your domain name (eg. mycompany.co.za) and the account/FTP password that was provided to you.
\r\n
The main window will display all the active email accounts already in use for your domain
\r\n
Select \'New Mailbox\' to create a pop mail account or \'New Mail Alias\' to create an email alias
\r\n
Complete the information requested. Only the username and password are required, the rest are optional and generally for advanced users only.
\r\n
Click on \'Submit\'
\r\n\r\nShould you have run out of e-mail accounts (you quota), please contact our sales team to upgrade. Alternatively, ensure that all the mail accounts listed are in use, and manage your account for maximum benefit.\r\n
\r\n
','',0,'','2','2007-06-03','2007-06-03',2938,26,122,687,'','',', 1 ,, 10 ,',0,0),(23,'root','Why are my images not showing?','If you upload images or create folders with spaces in the names, some email programs cannot understand the links.','',1,'','2','2007-08-30','2008-01-16',6,0,0,3,'','','',0,0),(25,'27','How am I billed & what are the costs for a self managed service?','
There is an initial once-off set-up fee and monthly fee for the maximum number of emails you may send from your account in a calendar month. To determine which package will suit you best please refer to our pricelist
pMaler is billed in advance and an invoice is issued on (or close to) the 25th of each month for the next month’s pMailer services.
','',0,'','14','2007-09-19','2007-09-20',1080,0,2,451,'','',', 2 ,, 27 ,',0,0),(26,'27','How do I make payment?','
A monthly debit order is required for all self-managed services. Bank transfer (EFT) is also accepted in certain circumstances and must be arranged with our sales team. Credit card facilities will be available soon.
','',0,'','14','2007-09-19','2007-09-20',1073,0,3,433,'','',', 2 ,, 27 ,',0,0),(43,'32','Can I add Headers and Footers to my mails?','You can add Text or HTML headers and footers to the top and bottom of your mailings, respectively.
This is how you do it:
Select Presets-Headers and Footers from the main menu bar,
Name the Template
Select either HTML or text Header/Footer
Select Header or Footer
Insert your HTML or Text footer into the window provided
Follow the same steps to insert a Footer if required.
Then create your message and select the Header/Footer drop down menu suited at the bottom of the WYSIWUYG editor
Select the header/footer you saved
Select ‘Preview message” Button
Or, ‘Send now” to initiate the send','',0,'','13','2007-10-05','2007-10-05',1297,0,0,519,'','',', 2 ,, 32 ,',0,0),(27,'27','What if the amount of emails I use differs from month to month, which package would suit me?','
We would suggest that you select a lower base email package that you expect to use on a monthly basis and when required purchase additional emails. You can use our top-up service for this.
','',0,'','14','2007-09-19','2007-09-20',943,0,3,442,'','',', 2 ,, 27 ,',0,0),(28,'27','How do I top-up and how does it work?','
Very easily complete the top-up form on-line and your request will be dealt with within 24 hours. A top-up is valid for that month only and you will be invoiced accordingly.
','',0,'','14','2007-09-19','2007-09-20',954,0,2,422,'','',', 2 ,, 27 ,',0,0),(29,'27','How does the billing work for once-off/managed sends?','
Please note that managed service orders must be paid for up-front before your email shot will be delivered. As such, you are billed in advance and you will be invoiced accordingly.
For orders where the total value of the service is R3000 or more, a 50% deposit is required before your email shot will be delivered and the remainder due once your reports have been delivered to you.
','',0,'','14','2007-09-19','2007-09-20',887,0,2,411,'','',', 2 ,, 27 ,',0,0),(42,'32','How Can I personalize my email?','
By adding what is called a personalization tag. This allows your email to be more relevant to the addressee, giving them a reason to examine the contents of your mailing.
\r\n
You can add personalization tags to either to your HTML or Text mailings.
\r\n
If you are adding personalization tags to your HTML mailing you would simply need to click on Personalize Mailing within the WYSIWYG editor.
\r\n
For Text mailings, you would simply use the Personalize Message drop down menu.
','',0,'','13','2007-10-05','2007-10-05',1602,0,0,632,'','',', 2 ,, 32 ,',0,0),(30,'27','What does the once-off fee for a managed service email shot include?','
ï?§ The setup of a managed send account ï?§ The importing of your mailing list ï?§ Uploading of email/template content provided by customer
Alternatively,
ï?§ The use of one of our ready for content email templates and your content ï?§ The provision of analytic and statistical reports including bounces, reads, links clicked on and successful sends
','',0,'','14','2007-09-19','2007-09-20',978,0,1,429,'','',', 2 ,, 27 ,',0,0),(31,'29','What is the difference between managed and self-managed services?','
Self-managed accounts, is where you control and manage your own lists, sends, template uploads and email creations.
Managed accounts, or once off email shots is, where we manage, upload lists, import templates send bulk email shots on your behalf!
','',0,'','14','2007-09-19','2007-09-20',973,0,2,405,'','',', 2 ,, 29 ,',0,0),(32,'29','Do you provide mailing lists or databases that I can use?','
No we do not! We only provide the engine that allows you to send out email to people from whom you have already received permission to send to. Please read our terms and conditions and anti-spam/abuse policies.
However, pMailer allows you to begin building your own database with simple tools to create subscription forms for your website and other methods of opt-in database building. Please see the article on “how to add a subscription form to my website” for more.
','',0,'','14','2007-09-19','2007-09-20',1166,0,2,545,'','',', 2 ,, 29 ,',0,0),(41,'32','How do I Create/Compose or import a mailing template/email?','Part1
Create a mail by clicking on the create mail icon
Choose between:
* HTML and Text (Create a Text Version if needed) * HTML Only (Used most Often) * Text Only (Used in select cases)
**Click on the list/list you would like to mail to, and then click submit/next, (Templates and filters will be explained in part 2)
You can create the mail using the WYSIWYG editor or even copy paste the code from another program with the source option, pmailer automatically generates the template,
There are three more options paste from word, plain text and paste as is.
Part 2
You can add and edit your preset message templates under Presets->Templates.
Message templates can be either plain text or HTML; pMailer built-in WYSIWYG editor is available for use in creating and modifying HTML templates. Each template can also be limited either to the particular list you are working with, or to the user account that you are logged in under.
**remember in part one the Templates and filters, this is how you would have selected a template for future re-use and re-editing.','',0,'','13','2007-10-05','2008-01-16',1296,0,0,499,'','',', 2 ,, 32 ,',0,0),(33,'29','How large can my emails be?','
We don’t limit the size of our customers’ emails. However, you should always keep them as small as possible to ensure they are delivered quickly and are easy to download by your subscribers. Should you have the attachments option on your account, there is a limit of 2MB per attachment, which can be increased should you require it in special cases by speaking to our sales team.
','',0,'','14','2007-09-19','2007-09-20',1019,0,2,454,'','',', 2 ,, 29 ,',0,0),(34,'29','Does pMailer have unsubscribe functionality? Can people choose to no longer receive emails from me?','
Yes, pMailer helps you be a good netizen and comply with legislation by automatically places an unsubscribe link at the end of your emails, you can additionally place the unsubscribe link where you would prefer it using the personalization tools.
','',0,'','14','2007-09-19','2007-09-20',896,0,2,587,'','',', 2 ,, 29 ,',0,0),(35,'29','How long does it take for a person to receive a email sent from the system?','
pMailer sits on a tremendously powerful server cluster that is able to send millions of emails. A number of issues can hamper delivery that are beyond our control like connectivity problems at major ISPs. Small lists are delivered to recipients within a few minutes. The larger your database, the longer it will take to deliver these emails to the entire list. Companies depend on pMailer to deliver breaking news and urgent announcements, so you can be assured that we send out your emails as quickly as possible.
','',0,'','14','2007-09-19','2007-09-20',975,0,3,439,'','',', 2 ,, 29 ,',0,0),(36,'29','What reporting tools are there?','
pMailer has a number of tools designed to enable the user to manage and analyze their marketing campaign more effectively. A report on the amount of emails sent, read, bounced and link click tracking can be accessed via the Archive/Stats menu after sending out your email.
','',0,', 29 ,','14','2007-09-19','2007-09-20',1055,0,1,496,'','',', 2 ,, 29 ,',0,0),(37,'29','What is a bounce?','
(see blog)\r\n
\r\n
\r\n
\r\n
','',1,'','14','2007-09-19','2007-09-19',0,0,0,0,'','',', 2 ,, 29 ,',0,0),(38,'29','What is an embedded image?','
Embedded images are a part of the email as opposed to linked images which usually reside on a remote server. In other words the subscriber is able to view the image if he/she is off-line or on-line. We recommend that you do not embed your images in most cases, as it does reduce your delivery penetration in some cases. However, there are instances where it is important to embed emails depending on your subscriberbase. Contact our sales team if you require additional information.
','',0,'','14','2007-09-19','2007-09-20',1109,0,2,462,'','',', 2 ,, 29 ,',0,0),(39,'29','Which attachment formats does pMailer accept and what size can they be?','
Attachments can be almost any file type from jpeg’s, spreadsheets, PDF’s, word documents and more. Attached files can be a maximum size of 2MB and we recommend you keep your attachments as small as possible.
','',0,'','14','2007-09-19','2007-09-20',996,0,2,433,'','',', 2 ,, 29 ,',0,0),(40,'32','How do I get my mail lists in?','Importing Via CSV file
Once you have selected a list that you have created or used before, select the import subscriber’s option or click on the icon under popular tasks,
Select the “Import from a File” tab, browse to the CSV file you would like to upload select it and upload.
Once the file is uploaded, you will be prompted to assign names to each column, e.g. assign “name” to column one and “email” to column two depending on your spreadsheets layout!
The upload of the list will start after you say next, pMailer will automatically remove all duplicates and mail address with mistakes (duplicate removals can be removed if requested)
You can now select the list after logging in or by selecting the list in the top right corner, create a mail and send away!
Alternatively,
Copy the names and addresses into the “Import using copy/paste” box.','',0,'','13','2007-10-05','2007-10-05',1340,0,0,501,'','',', 2 ,, 32 ,',0,0),(65,'37','How do Sending Filters Work?','If you only want to send up to 30 specific e-mails in your list you can create a sending filter. Check the e-mails you wish to send to and when composing a mailing you would select that sending filter. Also, you can create sending filters based on name, email, subscription date, and any optional fields you may have. For instance, you can create a sending filter that only includes subscribers who have signed up after a particular date or a filter that includes everyone with bob in their name or .com in their e-mail address.
To begin adding sending filters select “Sending Filters.” To add a new filter, click on the “Add a new custom filter” link at the bottom of the page. Set parameters for the sending filter based on name, email, and signup date. You have the option to make it a universal template [user admin only or all users] - used by all current and future lists. Click “Submit” to add your filter to the list. Once you have created sending filters you can click on “View matching email addresses” below one of your filter for a list of email addresses matching the parameters specified by that filter. Easily delete any filter by clicking the red circle with the “x.” When you click on “Create New Message” there is a “Sending Filters” drop down menu so that you can begin applying that filter to the message.','',0,'','13','2007-10-05','2007-10-05',1622,0,0,646,'','',', 2 ,, 37 ,',0,0),(69,'32','Common Bounces Error Explained','A rather common error with bounced messages is that the bounced mail will be received by pMailer, but pMailer does not properly process the bounced message for a particular subscriber.
You can identify a symptom of this problem when you see an error message like this, while checking for bounces:
e.g. 5 messages were processed and 0 were bounces.
When pMailer sends out an email, it creates a unique mail header and adds it to each message, which contains the subscriber\'s email address, message ID, and more.
Below is an example of such a header found in the message’s source (code):
X-mid: a2VudEBhY3RpdmVjYW1wYWlnbi5jb20gLCBtMjA=
What happens when a message bounces, it that it is, returned to pMailer’s bounce-catcher inbox, and usually contains this header. pMailer must be able to read this header in order to process bounced messages. If this header is absent or been stripped from an email received, one or two things could be the culprit. One: the message did not originate from the pMailer software (this would be the case if you sent/forward an email directly to this address from your Outlook, etc...). Two: the mail server stripped out this mail header. pMailer cannot stop servers for doing this that are configured to do this. Additionally if this is the case on your system, you may need to talk to your IT administrator or ISP provider handeling your mail server and ask them why this is happening; you should then be able to take the necessary steps to allow the header to remain.
Please note that this could happen to certain emails with a particular domain name but not others. This also depends on the mail server that is accepting or rejecting the email from pMailer. If pMailer is not processing bounced mail for ANY domain, then it is likely that your mail server is the culprit.','',0,'','13','2007-10-25','2007-10-25',1419,1,0,588,'','',', 2 ,, 32 ,',0,0),(44,'32','Can I add Headers and Footers to my mails?','You can add Text or HTML headers and footers to the top and bottom of your mailings, respectively.
This is how you do it:
Select Presets-Headers and Footers from the main menu bar,
Name the Template
Select either HTML or text Header/Footer
Select Header or Footer
Insert your HTML or Text footer into the window provided
Follow the same steps to insert a Footer if required.
Then create your message and select the Header/Footer drop down menu suited at the bottom of the WYSIWUYG editor
Select the header/footer you saved
Select ‘Preview message” Button
Or, ‘Send now” to initiate the send','',0,', 24 ,','13','2007-10-05','2007-10-05',1234,0,0,533,'','',', 2 ,, 32 ,',0,0),(67,'37','Cloning Lists?','The Clone list feature allows you to easily copy either the list settings or the list subscribers to a new list. Or copy both the list settings and the list subscribers to a new list. Click on “Clone” to shortcut to clone under general settings','',0,'','13','2007-10-05','2007-10-05',1201,0,0,482,'','',', 2 ,, 37 ,',0,0),(68,'37','How do I remove Duplicates?','Click on “Remove Duplicates” to have the system check your list for duplicates. Any duplicates will be removed when you run this page and the results will be shown on screen.
Please note: At time of sending the system automatically checks for duplicates. This function is for cleaning up the list, but is not required to be run.','',0,'','13','2007-10-05','2007-10-05',1101,0,0,437,'','',', 2 ,, 37 ,',0,0),(45,'32','How to setup a â??Back Toâ? Link/Anchor?','So you have a long newsletter and want to make it easy to navigate?
Here is how you do it!
In the Create Message Page (HTML Editor), you will have a blank mail in front of you or a mail template you have already created.
At the top of the Newsletter/Mail, or anywhere else in the newsletter you can click at a point near the text or highlight the text you would like the “Back to Top” link to take you “back to” here you will insert your anchor.
Click on the small anchor icon on the text editor tool bar, give the anchor a name and click OK
Now go the part of the newsletter where you would like the “Back to link” to be, type the text “directions” (Back to Top), highlight the text (or image) and click on the insert link button,
Under Link Type, select “Anchor in this page”, the option “Select an Anchor by Anchor Name” will appear and you can select the anchor you want the link to take you too!
Now your long newsletter is a little simpler and easier to navigate, remember these anchors and links to them can be anywhere in the newsletter! So make the newsletter perform the way you want it to!','',0,'','13','2007-10-05','2007-10-05',1325,0,0,493,'','',', 2 ,, 32 ,',0,0),(58,'34','What is the benefit of changing general List settings?','To name the newsletter, set a default sender’s email address, or enter a reply email address subscribers could reply on or even choose the language. ','',0,'','13','2007-10-05','2007-10-05',1226,0,0,536,'','',', 2 ,, 34 ,',0,0),(59,'34','What is and how do you use Opt-In?','Opt-In settings allow you to confirm that the email address attempting to subscribe actually is the owner of the address. When turned on a message [that you specify] will be sent to the potential subscriber’s email address. This email contains a link that the subscriber must click on for the email address to be subscribed. If the link is not clicked on the email will not be part of the list. You are able to enter the email address it is from, subject, and customise the entire message the user receives for users to opt into.
To turn this on/off click on “Opt-In e-mail confirmation” under “List” on the administrative main page.
To turn them on select “Yes” or turn them off selecting “No.” The WYSIWG text editor on the page allows you to customize your Opt-In message. Click on “Personalize” to easily enter tags to a number of fields: “Subscriber’s Name”, “Subscriber’s Email”, “Subscriber’s IP, “Update Profile Link”, and “Unsubscribe Link. When your messages are specified to your liking, click on “Save Change” to update your mailing list.','',0,'','13','2007-10-05','2009-06-04',2391,0,0,868,'','',', 2 ,, 34 ,',0,0),(71,'10','The mail I have received from pMailer is not formatted correctly - It just displays code.','
My mail is not formatting correctly - It just displays code.
\r\n
Starting with Microsoft Office 2003 Service Pack 2, Outlook will try to protect you from SPAM.
\r\n
All messages that you receive are scanned by Outlook and if thought to be suspicious they are moved to the Junk E-mail folder.
\r\n
All messages that are moved to the Junk Email folder are automatically converted to plain text format, as well as links, images and other HTML elements that they contain are disabled. This is why you email looks like code / text.
\r\n
Any message that you move out of the Junk E-mail folder will be automatically reverted to their original format, unless the message is considered by the Junk E-mail Filter to contain suspicious links. In that case, even if you move it out of the Junk E-mail folder, the links in the message remain disabled by default.
\r\n
If you receive consistently receive newsletters you may want to mark the person as a safe sender. You can do this by –
\r\n\r\n
Right click the message you want to add to the Safe Senders List.
\r\n
Go down to the Junk Email.
\r\n
Select Add Sender To Safe Senders List.
\r\n
A dialog box will appear – click OK.
\r\n
Move the message out of your Junk Mail folder and into your inbox.
\r\n\r\n
And now all the messages from this user / mail address will bypass the spam filter and go straight into your inbox.
\r\n
Best Wishes,
\r\nPrefix Support Team','',0,'','19','2008-05-06','2008-05-12',810,0,0,342,'','',', 1 ,, 10 ,',0,0),(60,'34','What if? I would like additional fields, for my imported mailing list other than the ones already available.','You can get additional subscriber information from your subscription forms by adding additional subscriber fields. These subscriber fields are used to gather additional information beyond name and email. You can gather subscriber information using radio buttons, check boxes, text fields, text boxes, and drop downs. You can specify a default value and choose whether or not to require your subscribers to enter in the additional information. You can even apply these subscribers to other lists that you have set up. Select all the lists you want to apply subscriber fields to by holding down on the “Ctrl” button. You can add any number of these optional fields. Click on “Subscriber Fields” under “List Settings on the menu at the top. Use the drop down menu under “Add a new field” to add subscriber fields that include text box fields, text fields, check box fields, radio button fields, and drop down fields.','',0,'','13','2007-10-05','2007-10-05',1990,0,0,619,'','',', 2 ,, 34 ,',0,0),(46,'32','How do I Insert Links?','Simply type the text you would like to be a link,
Highlight the text/image and click on the insert link icon in the WYSIWYG editor
Select a link type URL, Email or Anchor
Type in the URL you would like the person clicking on, to go to Click Okay and you are done.','',0,'','13','2007-10-05','2008-01-16',1189,0,0,461,'','',', 2 ,, 32 ,',0,0),(63,'36','Where can I look at the statistics of the mails I sent out?','
Click on “Message Archive” to view a list of sent messages. Once there click on “i” to view a host of details including: who it was sent to; how many times it bounced; percentage of successful transmissions; who read it, clicked on links, and how many times; current status; date and time; who it was from and what the subject was; along with an html and a text version of the message.
\r\n
Click on “T” to take an old message and use it as a template [see using a message as a template for additional details]. Click on “X” to delete the message from the archives.
','',0,'','13','2007-10-05','2007-10-05',1149,0,0,537,'','',', 2 ,, 36 ,',0,0),(64,'37','How and why would I use Headers and Footers?','Headers/Footers are another form of presets beyond templates. Unlike the templates feature, the headers/footers may not be modified during the sending process. The header and footer are ideal for standard information at the beginning or end of your mailing, such as your standard unsubscribe link. Select “Headers/Footers” on the menu at the top to add a new header or footer. Type in a name and select “Header” or “Footer.” Type or paste the header or footer content in the text field provided. You can use HTML tags; include images, etc. if you plan on using this header or footer in an HTML mailing. Click on “Submit” when you are done. The next time you click on “Headers/Footers” your header or footer appears in a list. Easily delete [x] or modify [e] items in this list by clicking on the appropriate icons to the left of them. Please note: Headers/footers are currently added to both html and text versions.','',0,'','13','2007-10-05','2007-10-05',1134,0,0,501,'','',', 2 ,, 37 ,',0,0),(47,'32','How does the Uploading and Inserting of Images Work?','Please remember that if you want to insert any images they need to be uploaded into pMailer first, this is because a person’s outlook would need to know where to go an fetch the image’s when you send mails out,
Important Points:
Pictures need to be jpg’s with no spaces between their names.
Examples are pictureofflowers.jpg or picture_of_flowers.jpg
You can upload these images into pmailer with the option,
Then select the image from inside the system with the Insert/Edit Image option again,
To embed the image simply click embed images tick-box','',0,'','13','2007-10-05','2007-10-05',1162,0,0,514,'','',', 2 ,, 32 ,',0,0),(61,'34','How does blocking Addresses work?','By blocking any address from subscribing to your list. Click on “Blocked Addresses” to view a list of any blocked addresses. Add to this list by typing new addresses into the text field and clicking on “Save Changes.” Addresses should be separated with a return / new line. This feature is useful for keeping out unwanted subscribers.','',0,'','13','2007-10-05','2007-10-08',1293,0,0,629,'','',', 2 ,, 34 ,',0,0),(48,'32','How do I send a message','Very easily by following these simple steps:
After selecting, your list of choice when you log in,
Click on the Message menu tab and Select ‘Create Message’
Then Select what type of format you would like your message to appear as, either HTML or text or both
Select the list that you would like to send to,
Click ‘Submit and Next,’
Next page is where you compose your message
You can create your message in the WYSIWYG window or select a message template edit and then send or copy paste the code in that you have designed elsewhere,
When completed click on the ’Preview Message” button
You can either send a test to yourself/colleague or save for later
To finish off click on the ‘Send Now’ button to send the message','',0,'','13','2007-10-05','2007-10-05',1072,0,0,461,'','',', 2 ,, 32 ,',0,0),(62,'36','What is the message queue for? ','The visual message queue allows you to view your message sending status and re- queue your message as needed. You can view the number and percent of emails complete along with the number left to go. If sending stalls over 5 minutes you can click on the Re-Queue Message link to re-start your sending. Do NOT click on this message unless it stops sending for 5 minutes. Easily pause, stop, or resume your mailings in progress. Anytime you have a message queued click on “Message Queue” to view your message in progress. A bar graph displays the progress of your mailings','',0,'','13','2007-10-05','2007-10-05',1152,0,0,527,'','',', 2 ,, 36 ,',0,0),(49,'32','Can I Schedule mailings or save messages to be used at later stage?','Yes and this is how you do it:
In order to schedule mailings ensure that ability to schedule mailings has been, selected in your list settings. After you create your message, you will have the option to schedule mailings on the last page. The time is set on the server.
You can view your scheduled mailing at anytime by clicking on Messages and then Scheduled Mailings on the left. Here you can either Force Send Now, to begin the sending process immediately or you can delete it from your scheduled queue.','',0,'','13','2007-10-05','2007-10-05',958,0,0,463,'','',', 2 ,, 32 ,',0,0),(66,'37','What are batch removals?','Batch Removal allows you to clear all addresses from the list you are currently working on.
All list settings will be retained even as you remove all addresses that are subscribed to the list. Click on “Batch Removal” under “Utilities” on the menu at the top. You can remove specific email addresses using the batch removal page. Paste the email addresses to be removed into the text box and click on “Submit”. To remove all addresses click on “delete all addresses in this list.”
Warning: once you remove all addresses using “delete all addresses in this list” it can not be undone. ','',0,'','13','2007-10-05','2007-10-05',1075,0,0,474,'','',', 2 ,, 37 ,',0,0),(50,'32','Does pMailer have a tool that will enable me to determine if my email will be flagged as spam?','Yes, pmailer has a spam filter that gives you a spam count. The higher this number is the greater the probability that your mailing will be flagged as spam.
Along with a spam count number, you will receive a detailed break down of every item that was found in your mailing that may indicate your mailing as being spam. You can then adjust your mailing as needed to improve your spam count and thus reduce the likelihood that mailing will be misidentified as spam.\r\n
','',0,'','13','2007-10-05','2007-10-05',1064,0,0,456,'','',', 2 ,, 32 ,',0,0),(51,'35','Where can I view my subscribers?','By selecting view subscribers, under the subscribers tab you would be able to view all your subscribers and edit or delete subscribers (if someone calls in to be removed you can easily remove them from the list),','',0,'','13','2007-10-05','2007-10-05',1055,0,0,470,'','',', 2 ,, 35 ,',0,0),(56,'35','How would I keep my own Database Up-to-date?\r\n\r\n','
pMailer will provide you with a report on the amount of bounces that have occurred and the bounce type (hard or soft) and this will allow you to either export to CSV file or export it to unsubscribe list within pmailer enabling you to keep your database clean and optimizing your email marketing campaign.
','',0,'','13','2007-10-05','2007-10-05',1116,0,0,520,'','',', 2 ,, 35 ,',0,0),(52,'35','How do I find a specific subscriber that I would like to edit or remove?','Select search subscribers under the same tab, enter the person’s name or email address and search. If you have only partial information it will recall results as close to your query as possible.','',0,'','13','2007-10-05','2007-10-05',1006,0,0,444,'','',', 2 ,, 35 ,',0,0),(53,'35','How would I add and individual subscriber or a few without importing a CSV file?','Under the subscriber tab, select add subscriber, add name and email address and the person will be added to the list you are in.','',0,'','13','2007-10-05','2007-10-05',904,0,0,415,'','',', 2 ,, 35 ,',0,0),(54,'35','How would I monitor the people who have unsubscribed?','Under the subscriber tab, select Unsubscribed list, and remove those individuals form the lists, to avoid complaints from people who feel their privacy has been invaded, it is always good practice you to follow this for various legal reasons,','',0,'','13','2007-10-05','2007-10-05',955,0,0,439,'','',', 2 ,, 35 ,',0,0),(55,'35','How do I Import/Export Large Subscriber Lists?','X) Importing Via CSV file
Once you have selected a list, you have created or used before, select the import subscriber’s option or click on the icon under popular tasks,
Select the “Import from a File” tab, browse to the CSV file you would like to upload.
Once the file is uploaded, you will be prompted to assign a name to each column, e.g. assign “name” to column one and “email” to column two depending on the spreadsheets layout.
The upload of the list will start after you say next, pMailer will automatically remove all duplicates and mail address with mistakes (duplicate removals can be removed if requested)
You can now select the list after logging in or by selecting the list in the top right corner, create a mail and send away!
Alternatively,
Copy the names and addresses into the “Import using copy/paste” box.
Y) Exporting Subscribers
This is even easier, select export subscribers from the subscribers tab
Chose the information you would like to export by column
Then either save to a file or display these results and copy/Paste them to a location at your discretion','',0,'','13','2007-10-05','2007-10-05',1230,0,0,533,'','',', 2 ,, 35 ,',0,0),(57,'35','How do I put a subscription form on my website with pMailer?\r\n','With these simple steps:
Firstly, you need to create the fields that must appear in the subscription form:
Select\\Create a list that is for an intended market to subscribe to, Select the drop down menu option ‘lists’ and click on the “Custom Subscriber Field” Select the type of field that needs to appear in your Subscription Form, there are four options namely: Text Field, Text Box, Check Box, Radio button, Drop down field or hidden field and click next. Populate the form with the required fields excluding name and email address as pMailer includes these fields automatically.
Secondly, you need to create the subscription form:
Select ‘integration” from the main menu bar and click on “Subscription Forms” Click on the “Create new Form” button Select the list to include from the list provided. Tick all the fields in the “Additional fields to Request” Select the Radio button “Force user to subscribe to or unsubscribe from all lists selected above.” Enter the title of the subscription form in the label field; please note this is not visible to the public. Click on the ‘Generate’ button Copy and Paste the code into the website and your subscription form is complete.','',0,', 9 ,','13','2007-10-05','2008-01-16',1820,0,0,683,'','',', 2 ,, 35 ,',0,0),(70,'35','Understanding Bounce Codes','
The following list contains enhanced SMTP reply codes used by some mail servers. It also contains some notes and recommendations regarding Microsoft Exchange Server.
Type Code and Explanation
Hard 4.2.1 Service not available, closing transmission channel. Hard 4.2.2 The recipient has exceeded their mailbox limit.
\r\n
It could also be that the delivery directory on the Virtual server has exceeded its limit (default varies from 0-22mb).
\r\n
Hard 4.3.1 Not enough disk space on the delivery server.
\r\n
Microsoft says this NDR may be reported as an out-of-memory error.
\r\n
Hard 4.3.2 Classic temporary problem: the Administrator has frozen the queue. Hard 4.4.1 Intermittent network connection.
\r\n
The server has not yet responded. Classic temporary problem. If it persists, you will also receive a 5.4.x status code.
\r\n
Hard 4.4.2 The server started to deliver the message but the connection was broken. Hard 4.4.6 Too many hops. The message is likely looping. Hard 4.4.7 Problem with a timeout. Check receiving server connectors.
\r\n
Hard 4.4.9 A DNS problem. Check your smart host setting on the SMTP connector.
\r\n
\r\n
For example, verify that the SMTP format is correct. Also, use square brackets in the IP address [197.89.1.4]. You can get this same NDR error if you have been deleting routing groups.
\r\n
\r\n
Hard 4.5.0 Requested mail action not taken: mailbox unavailable. Hard 4.5.1 Requested action aborted: local error in processing. Hard 4.5.2 Requested action not taken: insufficient system storage. Hard 4.6.5 Multi-language situation. Your server does not have the correct language code page installed.
\r\n
Hard 5.0.0 Syntax error, command unrecognized.
\r\n
\r\n
You receive this NDR when you try to send email via telnet and make a typing mistake. More likely, a routing-group error, no routing connector, or no suitable address space in the connector. (Try adding * in the address space.)
\r\n
\r\n
Hard 5.0.1 Syntax error in parameters or arguments. Hard 5.0.2 Command not implemented. Hard 5.0.3 Bad sequence of commands. Hard 5.0.4 Command parameter not implemented. Hard 5.1.x Problem with email address. Hard 5.1.0 Often seen with contacts. Check the recipient address. Hard 5.1.1 Another problem with the recipient address.
\r\n
Possibly the user was moved to another server in Active Directory. Maybe an Outlook client replied to a message while offline.
\r\n
Hard 5.1.3 Another problem with contacts. Address field maybe empty. Check the address information. Hard 5.1.4 Two objects have the same address, which confuses the categorizer. Hard 5.1.5 Destination mailbox address invalid.
\r\n
Hard 5.1.6 Problem with homeMDB or msExchHomeServerName - check how many users are affected.
\r\n
\r\n
Sometimes running RUS (Recipient Update Service) cures this problem. Mailbox may have moved.
\r\n
\r\n
Hard 5.1.7 Problem with senders mail attribute, check properties sheet in ADUC. Soft 5.2.x NDR caused by a problem with the large size of the email. Soft 5.2.1 The message is too large. Else it could be a permissions problem. Check the recipient’s mailbox. Soft 5.2.2 Sadly, the recipient has exceeded their mailbox limit. Hard 5.2.3 Recipient cannot receive messages this big. Server or connector limit exceeded. Hard 5.2.4 Most likely, a distribution list or group is trying to send an email. Check where the expansion server is situated. Hard 5.3.0 Problem with MTA. Someone may have been editing the registry to disable the MTA / Store driver. Soft 5.3.1 Mail system full. Possibly a Standard edition of Exchange reached the 16 GB limit. Hard 5.3.2 System not accepting network messages. Look outside Exchange for a connectivity problem. Hard 5.3.3 Remote server has insufficient disk space to hold email. Check SMTP log. Hard 5.3.4 Message too big. Check limits, System Policy, connector, virtual server. Hard 5.3.5 Multiple Virtual Servers are using the same IP address and port.
\r\n
See Microsoft TechNet article: 321721 Sharing SMTP. Email probably looping.
\r\n
Hard 5.4.0 DNS Problem. Check the Smart host, or check your DNS.
\r\n
It means that there is no DNS server that can resolve this email address. Could be a Virtual Server SMTP address.
\r\n
Hard 5.4.1 No answer from host. Not Exchange’s fault, check connections. Hard 5.4.2 Bad connection. Hard 5.4.3 Routing server failure. No available route. Hard 5.4.4 Cannot find the next hop. Check the Routing Group Connector.
\r\n
Perhaps you have Exchange servers in different Routing Groups, but no connector.
\r\n
Soft 5.4.5 Network congestion
\r\n
Hard 5.4.6 Looping problem A contact has the same email address as an Active Directory user.
\r\n
\r\n
One user is probably using an Alternate Recipient with the same email address as a contact.
\r\n
\r\n
Hard 5.4.7 Delivery time-out. Message is taking too long to be delivered. Hard 5.4.8 Microsoft advises to check your recipient policy. SMTP address should be cp.com NOT server.cp.com.
\r\n
Hard 5.5.0 Requested action not taken: mailbox unavailable.
\r\n
\r\n
Underlying SMTP 500 error. Sending server tried EHLO, the recipient’s server did not understand and returned a 550 or 500 error. Set up SMTP logging.
\r\n
\r\n
Hard 5.5.2 Possibly the disk holding the operating system is full.
\r\n
Or "Requested mail action aborted: exceeded storage allocation" if you are executing an SMTP.
\r\n
Soft 5.5.3 More than 5,000 recipients. Check the Global Settings, Message Delivery properties.
\r\n
Or "Requested action not taken: mailbox name not allowed" if you are executing an SMTP.
\r\n
Hard 5.5.4 Transaction failed. Hard 5.5.5 Wrong protocol version. Hard 5.6.3 More than 250 attachments.
\r\n
Hard 5.7.1 Permissions problem.
\r\n
For some reason the sender is not allowed to email this account. Perhaps an anonymous user is trying to send mail to a distribution list.Check SMTP. Virtual Server Access Tab. Allow computers that successfully authenticate to relay. User may have a manually created email address that does not match a System Policy. Exchange 2003 SBS gives this error if IMF is set to "reject" and the message falls into that top threshold. Click System Manager > Global Settings > Message Delivery (right click > Properties) > Intelligent Message Filtering; Then set "When blocking messages", to No Action, and see if that message goes away. The threshold might need to be set higher if it\'s happening a lot.
\r\n
Hard 5.7.2 Distribution list cannot expand and so is unable to deliver its messages. Hard 5.7.3 Check external IP address of ISA server. Make sure it matches the SMTP publishing rule. Hard 5.7.4 Extra security features not supported. Check delivery server settings. Hard 5.7.5 Cryptographic failure. Try a plain message with encryption. Hard 5.7.6 Certificate problem, encryption level maybe to high. Hard 5.7.7 Message integrity problem.
','',0,', 32 ,','13','2007-10-29','2009-07-13',2417,1,0,562,'','',', 2 ,, 35 ,',0,0),(72,'10','How to check out webmail for large files.','How to check out webmail for large files\r\n
Enter your Email address and password as follows –
\r\n
\r\n
\r\n
\r\n
And then click on Submit.
\r\n
\r\n
\r\n
You will be presented with the following, please proceed by clicking on skip maintenance.
\r\n
\r\n
\r\n
\r\n
Now you can review you mail and delete the large ones.
\r\n
\r\n
\r\n
Look at the mail size.
\r\n
Delete the largest ones first.
\r\n
Select the check box next to the mail.
\r\n
Click Delete button .
\r\n
\r\nNow you can download you emails, if problems persists please repeat step above.For further information, please do not hesatate to contact prefix support.
Regards Prefix Support Team. ','',0,', 9 ,','19','2008-05-06','2008-05-09',642,0,0,324,'','',', 1 ,, 10 ,',0,0),(85,'32','How pMailer\'s read stats determines how many messages are read.','
If you have enabled the "track reads" feature when sending a message then pMailer can track how many reads a message may have had.
\r\n
While this feature is useful it is not 100% accurate and is usually a lesser reflection of the amount of reads a message of yours may have had.
\r\n
A message read is tracked when the recipient opens the message and their email client allows a small external image to be loaded.
\r\n
Since it is the loading of this image that triggers the read tracking, and some recipients will not allow the loading of external images or might not be online at the time of reading the message, your read statistics in pMailer will be lower than the actual number of people who read the message.
\r\n
Reasons read stats don’t show correctly:
\r\n
\r\n
Corporate mail policy might block all images (mail server automatically converts the entire mail to text).
\r\n
Firewalls might be blocking the image from being loaded.
\r\n
Mail client by default wont show all the images, and when prompted to download images the user might decline.
\r\n
The recipient might use a anti-spam software that blocks this image from being loaded.
\r\n
The user might not be online when image is downloaded (e.g. a Laptop user).
\r\n
','',0,'','19','2008-05-22','2009-06-04',1181,0,0,484,'','',', 2 ,, 32 ,',0,0),(86,'34','Auto Responders','You cab easily add any number of time-sensitive auto responders to any of your lists. For instance, you can have an instant auto responder that welcomes a new subscriber, have a message automatically sent 24 hrs after their subscription, and have another mailing sent a week later. Add html or text auto responders to any of your lists with ease.
To add a responder, click on "Auto Responders" under "Presets" on the menu at the top. Choose the type of Auto Responder: HTML or Text. Set the Timing: Number of hours after this responder is set to send (0 sends this responder instantly). Click on "Submit/Next."','',0,', 37 ,','13','2008-09-08','2009-06-04',1350,0,0,504,'','',', 2 ,, 34 ,',0,0);
/*!40000 ALTER TABLE `tt_faqarticles` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tt_faqattachdata`
--
DROP TABLE IF EXISTS `tt_faqattachdata`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tt_faqattachdata` (
`id` int(10) NOT NULL auto_increment,
`fileid` int(10) NOT NULL default '0',
`sequence` int(10) NOT NULL default '0',
`data` mediumblob,
PRIMARY KEY (`id`),
KEY `fileid` (`fileid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tt_faqattachdata`
--
LOCK TABLES `tt_faqattachdata` WRITE;
/*!40000 ALTER TABLE `tt_faqattachdata` DISABLE KEYS */;
/*!40000 ALTER TABLE `tt_faqattachdata` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tt_faqattachinfo`
--
DROP TABLE IF EXISTS `tt_faqattachinfo`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tt_faqattachinfo` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(255) collate latin1_general_ci NOT NULL default '',
`size` int(10) NOT NULL default '0',
`mimetype` varchar(128) collate latin1_general_ci NOT NULL default '',
`article` int(10) NOT NULL default '0',
`link` int(10) default NULL,
PRIMARY KEY (`id`),
KEY `article` (`article`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tt_faqattachinfo`
--
LOCK TABLES `tt_faqattachinfo` WRITE;
/*!40000 ALTER TABLE `tt_faqattachinfo` DISABLE KEYS */;
/*!40000 ALTER TABLE `tt_faqattachinfo` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tt_faqbackend`
--
DROP TABLE IF EXISTS `tt_faqbackend`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tt_faqbackend` (
`id` int(20) NOT NULL auto_increment,
`title` text collate latin1_general_ci,
`head` text collate latin1_general_ci,
`foot` text collate latin1_general_ci,
`cset` int(10) NOT NULL default '0',
`serial` text collate latin1_general_ci,
`av` varchar(250) collate latin1_general_ci NOT NULL default '',
`version` varchar(250) collate latin1_general_ci NOT NULL default '',
`lang` varchar(25) collate latin1_general_ci NOT NULL default '',
`char_encoding` varchar(25) collate latin1_general_ci NOT NULL default 'utf8',
`template` varchar(25) collate latin1_general_ci NOT NULL default '0',
`activeedit` int(5) NOT NULL default '0',
`color1` varchar(250) collate latin1_general_ci NOT NULL default '',
`color2` varchar(250) collate latin1_general_ci NOT NULL default '',
`color3` varchar(250) collate latin1_general_ci NOT NULL default '',
`color4` varchar(250) collate latin1_general_ci NOT NULL default '',
`color5` varchar(250) collate latin1_general_ci NOT NULL default '',
`q_ability` int(10) NOT NULL default '0',
`q_notify` int(10) NOT NULL default '0',
`q_notifyem` varchar(250) collate latin1_general_ci NOT NULL default '',
`theme` varchar(25) collate latin1_general_ci NOT NULL default '',
`s1` int(1) NOT NULL default '0',
`s2` int(1) NOT NULL default '0',
`s3` int(1) NOT NULL default '0',
`s4` int(1) NOT NULL default '0',
`s5` int(1) NOT NULL default '0',
`s6` int(1) NOT NULL default '0',
`s7` int(1) NOT NULL default '0',
`s8` int(1) NOT NULL default '0',
`s9` int(1) NOT NULL default '0',
`s10` int(1) NOT NULL default '0',
`s11` int(1) NOT NULL default '0',
`s12` int(1) NOT NULL default '0',
`s13` int(1) NOT NULL default '0',
`s14` int(1) NOT NULL default '0',
`s15` int(1) NOT NULL default '0',
`s16` tinyint(4) NOT NULL default '0',
`s17` tinyint(4) NOT NULL default '1',
`stype` int(1) NOT NULL default '0',
`smhost` varchar(250) collate latin1_general_ci NOT NULL default '',
`smuser` varchar(250) collate latin1_general_ci NOT NULL default '',
`smport` varchar(250) collate latin1_general_ci NOT NULL default '',
`smpass` varchar(250) collate latin1_general_ci NOT NULL default '',
`d_av` text collate latin1_general_ci,
`d_avo` text collate latin1_general_ci,
`new_article_approved` int(1) NOT NULL default '0',
`notification_from_email` varchar(250) collate latin1_general_ci NOT NULL default '',
`export_pdf` int(1) NOT NULL default '1',
`export_html` int(1) NOT NULL default '1',
`imageverify` int(1) NOT NULL default '1',
`notifyadmins_addarticle` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tt_faqbackend`
--
LOCK TABLES `tt_faqbackend` WRITE;
/*!40000 ALTER TABLE `tt_faqbackend` DISABLE KEYS */;
INSERT INTO `tt_faqbackend` VALUES (1,'KnowledgeBuilder',NULL,NULL,1,NULL,'','2.61.14','English','utf-8','Default',1,'','','','','',0,0,'','Default',0,0,1,0,1,1,1,0,0,0,0,1,0,1,1,0,0,0,'','','','',NULL,NULL,0,'',0,1,0,1);
/*!40000 ALTER TABLE `tt_faqbackend` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tt_faqcategory`
--
DROP TABLE IF EXISTS `tt_faqcategory`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tt_faqcategory` (
`id` int(20) NOT NULL auto_increment,
`loc` varchar(250) collate latin1_general_ci NOT NULL default '',
`name` text collate latin1_general_ci,
`description` text collate latin1_general_ci,
`user` varchar(250) collate latin1_general_ci NOT NULL default '',
`sdate` date NOT NULL default '0000-00-00',
`path` text collate latin1_general_ci,
`corder` int(10) NOT NULL default '0',
`aorder` varchar(250) collate latin1_general_ci NOT NULL default '',
`lockf` int(10) NOT NULL default '0',
`inv` int(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=40 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tt_faqcategory`
--
LOCK TABLES `tt_faqcategory` WRITE;
/*!40000 ALTER TABLE `tt_faqcategory` DISABLE KEYS */;
INSERT INTO `tt_faqcategory` VALUES (1,'root','Web / Mail Hosting','','Sam Hutchinson','2007-01-18',', 0001 ,',0,'date',0,0),(2,'root','pMailer','','Sam Hutchinson','2007-01-18',', 0002 ,',0,'date',0,0),(27,'2','Billing & Ordering','','Paulo Moreira','2007-09-19',', 0002 ,, 0027 ,',0,'date',0,0),(8,'1','General Network Information','','Sam Hutchinson','2007-01-18',', 0001 ,, 0008 ,',0,'date',0,0),(9,'1','Hosting How-to\'s & FAQs','','Sam Hutchinson','2007-01-18',', 0001 ,, 0009 ,',0,'date',0,0),(10,'1','E-Mail How-to\'s & FAQ\'s','','Sam Hutchinson','2007-01-18',', 0001 ,, 0010 ,',0,'date',0,0),(37,'2','Presets, Integration Tools and Utilities','','Prefix Management','2007-10-08',', 0002 ,, 0037 ,',0,'date',0,0),(32,'2','Importing, Creating, Editing and Sending','','Jacques','2007-10-05',', 0002 ,, 0032 ,',0,'date',0,0),(35,'2','Managing your Subscribers','','Prefix Management','2007-10-08',', 0002 ,, 0035 ,',0,'date',0,0),(34,'2','Understanding List Options','','Jacques','2007-10-05',', 0002 ,, 0034 ,',0,'date',0,0),(36,'2','Understanding Message Options','','Jacques','2007-10-05',', 0002 ,, 0036 ,',0,'date',0,0),(29,'2','Pre-sales FAQ\'s','','Paulo Moreira','2007-09-19',', 0002 ,, 0029 ,',0,'date',0,0),(39,'root','8 Ink','','Gerhard Engelbrecht','2009-08-04',', 0039 ,',0,'date',1,0);
/*!40000 ALTER TABLE `tt_faqcategory` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tt_faqcomment`
--
DROP TABLE IF EXISTS `tt_faqcomment`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tt_faqcomment` (
`id` int(20) NOT NULL auto_increment,
`art` varchar(250) collate latin1_general_ci NOT NULL default '',
`sip` varchar(250) collate latin1_general_ci NOT NULL default '',
`sdate` date NOT NULL default '0000-00-00',
`name` varchar(250) collate latin1_general_ci NOT NULL default '',
`email` varchar(250) collate latin1_general_ci NOT NULL default '',
`comments` text collate latin1_general_ci,
`subject` text collate latin1_general_ci,
`approved` int(10) NOT NULL default '0',
`cat` varchar(25) collate latin1_general_ci NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tt_faqcomment`
--
LOCK TABLES `tt_faqcomment` WRITE;
/*!40000 ALTER TABLE `tt_faqcomment` DISABLE KEYS */;
/*!40000 ALTER TABLE `tt_faqcomment` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tt_faqfields`
--
DROP TABLE IF EXISTS `tt_faqfields`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tt_faqfields` (
`id` int(10) NOT NULL auto_increment,
`categoryid` int(10) NOT NULL default '0',
`title` varchar(250) collate latin1_general_ci NOT NULL default '',
`description` varchar(255) collate latin1_general_ci default NULL,
PRIMARY KEY (`id`),
KEY `categoryid` (`categoryid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tt_faqfields`
--
LOCK TABLES `tt_faqfields` WRITE;
/*!40000 ALTER TABLE `tt_faqfields` DISABLE KEYS */;
/*!40000 ALTER TABLE `tt_faqfields` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tt_faqfieldsdata`
--
DROP TABLE IF EXISTS `tt_faqfieldsdata`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tt_faqfieldsdata` (
`id` int(10) NOT NULL auto_increment,
`articleid` int(10) NOT NULL default '0',
`fieldid` int(10) NOT NULL default '0',
`contents` text collate latin1_general_ci,
PRIMARY KEY (`id`),
KEY `articleid` (`articleid`),
KEY `fieldid` (`fieldid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tt_faqfieldsdata`
--
LOCK TABLES `tt_faqfieldsdata` WRITE;
/*!40000 ALTER TABLE `tt_faqfieldsdata` DISABLE KEYS */;
/*!40000 ALTER TABLE `tt_faqfieldsdata` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tt_faqindexes`
--
DROP TABLE IF EXISTS `tt_faqindexes`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tt_faqindexes` (
`id` int(10) unsigned NOT NULL auto_increment,
`word` varchar(255) collate latin1_general_ci NOT NULL default '',
`created` date NOT NULL default '0000-00-00',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tt_faqindexes`
--
LOCK TABLES `tt_faqindexes` WRITE;
/*!40000 ALTER TABLE `tt_faqindexes` DISABLE KEYS */;
/*!40000 ALTER TABLE `tt_faqindexes` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tt_faqrate`
--
DROP TABLE IF EXISTS `tt_faqrate`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tt_faqrate` (
`id` int(20) NOT NULL auto_increment,
`art` varchar(250) collate latin1_general_ci NOT NULL default '',
`decision` varchar(250) collate latin1_general_ci NOT NULL default '',
`sip` varchar(250) collate latin1_general_ci NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tt_faqrate`
--
LOCK TABLES `tt_faqrate` WRITE;
/*!40000 ALTER TABLE `tt_faqrate` DISABLE KEYS */;
/*!40000 ALTER TABLE `tt_faqrate` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tt_faqsearch`
--
DROP TABLE IF EXISTS `tt_faqsearch`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tt_faqsearch` (
`id` int(100) NOT NULL auto_increment,
`term` varchar(250) collate latin1_general_ci NOT NULL default '',
`cat` int(20) NOT NULL default '0',
`results` int(20) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `term` (`term`),
KEY `cat` (`cat`)
) ENGINE=MyISAM AUTO_INCREMENT=8369 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tt_faqsearch`
--
LOCK TABLES `tt_faqsearch` WRITE;
/*!40000 ALTER TABLE `tt_faqsearch` DISABLE KEYS */;
INSERT INTO `tt_faqsearch` VALUES (1,'e-mail',0,3),(2,'I am sorry...\r\nmhj flldh c\r\nairport ohare ufo*[url=http://ufo.ueuo.com/airport-ohare-ufo.html]airport ohare ufo[/url]*ohare ufo*[url=http://ufo.',0,3),(3,'link page',0,0),(4,'link',0,0),(5,'I will be back!\r\npdspjr \r\ndripping wet pussy*[url=http://wet-pussy.iespana.es/dripping-wet-pussy.html]dripping wet pussy[/url]*wet pussy*[url',0,3),(6,'Good job...\r\nagvubd \r\npic playboy torrie wilson*[url=http://torrie-wilson.iespana.es/pic-playboy-torrie-wilson.html]pic playboy torrie wilson[/url]*download free porn movie*[url=http://video-finder.iespana.es/download-free-porn-movie.html]download free porn movie[/url]*gay mike18*[url=http://erotica-search.iespana.es/gay-mike18.html]gay mike18[/url]*clip mike18 vid',0,3),(10,'Just want to say Hello, today a cool day ;)\r\ndnkppp \r\ncbs daytime soap opera*[url=http://opera-finder.iespana.es/cbs-daytime-soap-opera.html]cbs daytime soap opera[/url]*eli girlfriend manning*[url=http://eli-girlfriend-manning.hostuju.cz/]eli girlfriend manning[/url]*keihin carburetor*[url=http://motor-finder.hostuju.cz/keihin-carburetor.html]keihin carburetor[/url]*suzuki samurai carburetor*[url=http://motor-finder.hostuju.cz/suzuki-samurai-carburetor.html]suzuki samurai carbureto',0,3),(14,'Cool site. Thanks:-)\r\ngfxnbb nro\r\nrochester quadrajet carburetor*[url=http://motor-finder.hostuju.cz/rochester-quadrajet-carburetor.html]rochester quadrajet carburetor[/',0,3),(15,'Nice page ;)\r\nrqaimp qsr\r\npropane carburetor*[url=http://motor-finder.iespana.es/propane-carburetor.html]propane carburetor[/url]*suzuki samurai carburetor*[url=http://motor-finder.iespana.es/suzuki-samurai-carburetor.html]suzuki samurai carburetor[/url]*marine carburetor*[url=http://motor-finder.iespana.es/marine-carburetor.html]marine carburetor[/url]*hydromorphone hcl*[url=http://narcotics-online.hostuju.cz/hydromorphone-hcl.html]hydromorphone hcl[/url]*ephedra*[url=http://ephedra.forospace.com/forum.php]ephedra[/url]*\r\nEphedra iyb sini',0,3),(20,'fih narcotics zk\r\ndosages maximum pethidine*[url=http://narcotics-online.hostuju.cz/dosages-maximum-pethidine.html]dosages maximum pethidine[/url]*gun paintball pistol*[url=http://paintball-search.hostuju.cz/gun-paintball-pistol.html]gun p',0,3),(22,'game rt airline ferata involves agj opposing teams seeking delta ced eliminate xvemgg\r\ndelta song airline*[url=http://delta-airline.hostuju.cz/delta-song-airline.html]delta song ai',0,3),(23,'wood burning stoves',0,0),(24,' [url=http://buytramadolsnow.iphorum.com/ buy tramadol now\r\n][/url] [url=http://buyceaptramadol.iphorum.com/',0,3),(25,' [url=http://hometown.aol.com/thepage26/18emily2.html 18 emily\r\n][/url] [url=http',0,3),(26,' [url=http://www.eas.asu.edu/~chir/publications/documents/old/post31876.html buy phentermine\r\n][/url] [url=http://www.eas.asu.edu/~chir/publications/documents/old/post31876.html buy phentermine\r\n][/url] gun paintball skirmish*[url=http://cheap-gun-paintball.blogest.org/gun-paintball-skirmish.html]gun paintball skirmish[/url]*gun paintball sniper*[url=http://cheap-gun-paintball.blogest.org/gun-paintball-sniper.html]gun paintball sniper[/url]*asoan ts*[url=http://asoan.webmast.org/asoan-ts.html]asoan ts[/url]*asoan orgasm*[url=http://asoan.web',0,3),(31,' [url=http://montesdetoledo.info/lolana lolana\r\n][/url] [url=http://montesdetoledo.info/miou-miou miou miou\r\n][/url] mypay a*[url=http://mypay-a.dollar4u.info/]mypay a[/url]*dfas mil mypay*[url=http://dfas-mil-mypay.dollar4u.info/]dfa',0,3),(33,'Really great page ! Thanks!\r\nmnineb \r\ngun paintball tipman*[url=http://gun-paintball-tipman.dollar4u.info/]gun paintball tipman[/url]*angle g',0,3),(34,' [url=http://cyberbuzz.gatech.edu/4sale/old/4846462.html buy phentermine\r\n][/url] average cost lumineers*[url=http://average-cost-lumineers.capital2u.info/]average cost lumineers[',0,3),(36,'I\'m really sorry but i need it...\r\nvktahs \r\nfemjoy*[url=http://femjoy-search.capital2u.info/]femjoy[/url]*ask jolene*[url=http://ask-jolene.capital2u.i',0,3),(37,'I will be back!\r\ntgkxji \r\ncorinna femjoy*[url=http://corinna-femjoy.capital2u.info/]corinna femjoy[/url]*renamon*[url=http://renamon.capital2u.info/]rena',0,3),(38,'Hello, nice site look this:Thenks You!\r\nzkjvps \r\nasoan hardcore*[url=http://asian-erotic.hostuju.cz/asoan-hardcore.html]asoan hardcore[/url]* [url=http://www.tcnj.edu/~boyd8/mylife/school/page7775.html generic tramadol\r\n][/url] mike18*[url=http://gay-movies.hostuju.cz/mike18.html]mike18[/url]*',0,3),(41,'mike18*[url=http://gay-movies.hostuju.cz/mike18.html]mike18[/url]*',0,3),(42,' [url=http://www.tcnj.edu/~boyd8/mylife/school/page4826.html cheap tramadol\r\n][/url] asiah*[url=http://asian-private.hostuju.cz/asiah.html]asiah[/url]*aasian*[url=http://asian-private.hostuju.cz/aasian.html]aasian[/url]*',0,3),(44,'asiah*[url=http://asian-private.hostuju.cz/asiah.html]asiah[/url]*asiwn*[url=http://asian-private.hostuju.cz/asiwn.html]asiwn[/url]*britney hair spear [url=http://linesoma.info/britney-hair-spear]britney hair spear[/url] britney picture spear [url=http://linesoma.info/br',0,3),(46,'xsian*[url=http://asian-private.hostuju.cz/xsian.html]xsian[/url]*asoan*[url=http://asian-private.hostuju.cz/asoan.html]asoan[/url]*battle of thermopylae*[url=http://battle-of-thermopylae.thetrendy.info/]battle of thermopylae[/url]*jean petra phillipson*[url=http:',0,3),(48,'kellys secret gallery*[url=http://kellys-secret-gallery.thetrendy.info/]kellys secret gallery[/url]*michael giacchino*[url=http://michae',0,3),(49,'michael bubl*[url=http://michael-bubl.thetrendy.info/]michael bubl[/url]*layout myspace stealer*[url=http://layout-myspace-stealer.thetrendy',0,3),(50,'bobs discount furniture*[url=http://bobs-discount-furniture.thetrendy.info/]bobs discount furniture[/url]*jenna and barbara bush',0,3),(51,'linda dano*[url=http://linda-dano.thetrendy.info/]linda dano[/url]*linda onn*[url=http://linda-onn.thetrendy.info/]linda onn[/url]*jenna and barbara bush pic*[url=http://jenna-and-barbara-bush-pic.thetrendy.info/]jenna and barbara bush pic[/url]*bobs discount',0,3),(53,'game vstre4a [url=http://hostmybl.info/game-vstre4a]game vstre4a[/url] addicting game [url=http://hostmybl.info/addicting-game]addicting game[/url] terry callier*[url=http://terry-callier.thetrendy.info/]terry callier[/url]*lindstrom newscaster*[url=http://lindstrom-newscaster.thetrendy.i',0,3),(55,'layout snatcher*[url=http://layout-snatcher.thetrendy.info/]layout snatcher[/url]*crazy dumper*[url=http://crazy-dumper.thetrendy.info/]crazy dumpe',0,3),(56,'bennis warren*[url=http://bennis-warren.thetrendy.info/]bennis warren[/url]*macgowan shane*[url=http://macgowan-shane.thetrendy.info/]macgowan shan',0,3),(57,'derek sherinian*[url=http://derek-sherinian.thetrendy.info/]derek sherinian[/url]*jody babydol gibson*[url=http://jody-babydol-gibson.thetre',0,3),(58,'derek sherinian*[url=http://derek-sherinian.thetrendy.info/]derek sherinian[/url]*macgowan shane*[url=http://macgowan-shane.thetrendy.info/]macgo',0,3),(59,' [url=http://iciar-bollain.trade-impex.info iciar bollain\r\n][/url] [url=http://sarah-biasini.trade-impex.info sar',0,3),(60,'laura nubiles*[url=http://mypay.hostuju.cz/laura-nubiles.html]laura nubiles[/url]*corinna femjoy*[url=http://mypay.hostuju.cz/corinna-f',0,3),(61,'ask jolene*[url=http://mypay.hostuju.cz/ask-jolene.html]ask jolene[/url]*military mypay*[url=http://mypay.hostuju.cz/military-mypay.html]m',0,3),(62,'military mypay*[url=http://mypay.hostuju.cz/military-mypay.html]military mypay[/url]*belinda nubiles*[url=http://mypay.hostuju.cz/bel',0,3),(63,'michelle baena*[url=http://michelle-baena.thetrendy.info/]michelle baena[/url]*dana dearmond*[url=http://dana-dearmond.thetrendy.info/]dana dearmon',0,3),(64,'amy poehler*[url=http://amy-poehler.thetrendy.info/]amy poehler[/url]*john shirley quirk*[url=http://john-shirley-quirk.thetrendy.info/]john shir',0,3),(65,'cristina scabbia*[url=http://cristina-scabbia.thetrendy.info/]cristina scabbia[/url]*restless spoiler toni young*[url=http://restle',0,3),(66,'karen millen*[url=http://karen-millen.thetrendy.info/]karen millen[/url]*dana vachon*[url=http://dana-vachon.thetrendy.info/]dana vachon[/url]*sympathy flower [url=http://blogikho.info/sympathy-flower]sympathy flower[/url] mujra youtube [url=http://blogikho.info/mujra-youtube]mujra youtube[/u',0,3),(68,'karen lancaume*[url=http://karen-lancaume.thetrendy.info/]karen lancaume[/url]*chatty cathy doll*[url=http://chatty-cathy-doll.thetrendy.info/]',0,3),(69,'michelle sagara*[url=http://michelle-sagara.thetrendy.info/]michelle sagara[/url]*gail kruvand*[url=http://gail-kruvand.thetrendy.info/]gail kruvan',0,3),(70,'keith ferrazzi*[url=http://keith-ferrazzi.thetrendy.info/]keith ferrazzi[/url]*dana delany nude*[url=http://dana-delany-nude-.thetrendy.info/]d',0,3),(71,'bleach hentia*[url=http://hentai-world.hostuju.cz/bleach-hentia.html]bleach hentia[/url]*free hentia game*[url=http://h',0,3),(72,'love hina hentia*[url=http://hentai-world.hostuju.cz/love-hina-hentia.html]love hina hentia[/url]*sakura hentia*[url=ht',0,3),(73,'free hentia game*[url=http://hentai-world.hostuju.cz/free-hentia-game.html]free hentia game[/url]*hentia plaza*[url=http',0,3),(74,'army mypay*[url=http://army-mypay.bang-bro.org/]army mypay[/url]*how much do lumineers cost*[url=http://how-much-do-lumineers-cost.bang-bro.or',0,3),(75,' [url=http://mardi-gras-boob.blackteenpussy.info mardi gras boob\r\n][/url] [url=http://capri-kayla.blackteen',0,3),(76,'loren',23,0),(77,'moster',23,0),(78,'ideepthroat*[url=http://ideepthroat.bang-bro.org/]ideepthroat[/url]*ask jolene*[url=http://ask-jolene.bang-bro.org/]ask jolene[/url]*young nubiles*[url=http://young-nubiles.bang-bro.org/]young nubiles[/url]*laura nubiles*[url=http://laura-nubiles.bang-bro.org/]laura nubiles[/url]*mypay*[url=http://mypay.bang-bro.org/]mypay[/url]*how much do lumineers cost*[url=http://how-much-do-lumineers-cost.bang-bro.org/]how much do lumin',0,3),(81,'abigail and brittany hensel*[url=http://abigail-and-brittany-hensel.bang-bro.org/]abigail and brittany hensel[/url]*akira bubba love',0,3),(82,'akane sakura*[url=http://akane-sakura.bang-bro.org/]akane sakura[/url]*abigail mead*[url=http://abigail-mead.bang-bro.org/]abigail mead[/url]*princess aiko*[url=http://princess-aiko.bang-bro.org/]princess aiko[/url]*aika miura*[url=http://aika-miura.bang-bro.org/]aika miura[/url]* [url=http://rubmyboob-exanti.blackteenpussy.info rubmyboob exanti\r\n][/url] [url=http://fergie',0,3),(85,'chie esmet*[url=http://akiko-hinagata.bang-bro.org/chie-esmet.html]chie esmet[/url]*asuka sakamaki*[url=http://akiko',0,3),(86,' [url=http://kane-kimberly-pic.blackteenpussy.info kane kimberly pic\r\n][/url] [url=http://drama-my',0,3),(87,'arisu hoshi*[url=http://akiko-hinagata.bang-bro.org/arisu-hoshi.html]arisu hoshi[/url]*chiyo okumura*[url=http://aki',0,3),(88,'aya shirayuki*[url=http://akiko-hinagata.bang-bro.org/aya-shirayuki.html]aya shirayuki[/url]*eiko hosoe*[url=http://a',0,3),(89,'corinna femjoy*[url=http://corinna-femjoy.datinghost.info/]corinna femjoy[/url]*ask jolene*[url=http://ask-jolene.datinghost.info/]ask jolene[/url]*',0,3),(90,' [url=http://heroldsmuehle.info/adobe adobe\r\n][/url] [url=http://heroldsmuehle.info/celebs celebs\r\n][/url] [url=http://heroldsmuehle.info/adobe adobe\r\n][/url] [url=http://heroldsmuehle.info/celebs celebs\r\n][/url] paintball*[url=http://paintball.datinghost.info/]paintball[/url]*army mypay*[url=http://army-mypay.datinghost.info/]army mypay[/url]*lumineers*[url=http://lumineers.datinghost.info/]lumineers[/url]*ideepthroat*[url=http://ideepthroat.datinghost.info/]ideepthroat[/url]* [url=http://heroldsmuehle.info/adobe adobe\r\n][/url] [url=http://heroldsmuehle.info/celebs celebs\r\n][/url] [url=http://zajimavamesta.info/premarin-for-male premarin for male\r\n][/url] <',0,3),(96,' [url=http://academic.amc.edu.au/forums/PES/posts/372.html buy viagra\r\n][/url] [url=h',0,3),(97,' [url=http://academic.amc.edu.au/forums/PES/posts/373.html natural viagra\r\n][/url] [url',0,3),(98,' [url=http://academic.amc.edu.au/forums/PES/posts/373.html generic viagra\r\n][/url] [url',0,3),(99,'1',0,4),(100,'8412115153081',0,0),(101,'1',0,4),(102,'1',0,4),(103,'1',0,4),(104,'1',0,4),(105,'1',0,4),(106,'1',0,4),(107,'1',0,4),(108,'1',0,4),(109,'1',0,4),(110,'1',0,4),(111,'1',0,4),(112,'\"> irwof',0,7),(113,'\"> irwof',0,7),(114,'\"> irwof',0,7),(115,'\"> irwof',0,7),(116,'\"> irwof',0,7),(117,'\"> irwof',0,7),(118,'\"> irwof',0,7),(119,'\"> irwof',0,7),(120,'\"> irwof',0,7),(121,'\"> irwof',0,7),(122,'1',0,4),(123,'1',0,4),(124,'bupropion',0,0),(125,'bupropion',0,0),(126,'bupropion',0,0),(127,'bupropion',0,0),(128,'1',0,4),(129,'vacation message',0,1),(130,'vacation message',0,1),(131,'Free Cingular Ringtones [url=http://musicguild.bc.edu/message.asp?MessageID=1471]Free Cingular Ringtones[/url] Free motoro',0,7),(132,'Free Cingular Ringtones [url=http://musicguild.bc.edu/message.asp?MessageID=1471]Free Cingular Ringtones[/url] Free motoro',0,7),(133,'Hi, this is nice site!!!\n[url=http://totalpharmacyonline.info/Finasteride/index.html]Finasteride[/url]\n[url=http://totalpharmacyonline.info/Colchicine/index.html]Colchicine[/url]\n[url=http://totalpharmacyonline.info/Atorvastatin/index.html]Atorvastat',0,6),(134,'Hi! Good site respect! nubiles Visit nubiles Thanks!',0,6),(135,'Hi!',0,0),(136,'Good',0,0),(137,'site',0,2),(138,'Hi, 100$ per click!!!\nsouth carolina car insurance rate\n[url=http://newautoinsurance.info/cheap-insurance/car-cheap-company-insurance-quote-uk.html]car c',0,8),(139,'Hi! Good site respect! nubiles Visit nubiles Thanks!',0,6),(140,'Hi!',0,0),(141,'Good',0,0),(142,'site',0,2),(143,'error 404',0,0),(144,'404',0,0),(145,'error 404',0,0),(146,'lo392l',0,0),(147,'lo392l',5,0),(148,'lo392l',0,0),(149,'lo392l',5,0),(150,'lo129l',0,0),(151,'lo129l',5,0),(152,'lo129l',0,0),(153,'lo129l',5,0),(154,'lo143l',0,0),(155,'lo143l',5,0),(156,'lo143l',0,0),(157,'lo143l',5,0),(158,'\"> uitis',0,5),(159,'\"> uitis',0,5),(160,'\"> uitis',0,5),(161,'\"> uitis',0,5),(162,'\"> uitis',0,5),(163,'\"> uitis',0,5),(164,'\"> uitis',0,5),(165,'\"> uitis',0,5),(166,'\"> uitis',0,5),(167,'\"> uitis',0,5),(168,'\"> uatol',0,5),(169,'\"> uatol',0,5),(170,'\"> uatol',0,5),(171,'\"> uatol',0,5),(172,'\"> uatol',0,5),(173,'\"> uatol',0,5),(174,'\"> uatol',0,5),(175,'\"> uatol',0,5),(176,'\"> uatol',0,5),(177,'\"> uatol',0,5),(178,'\"> tatia',0,5),(179,'\"> tatia',0,5),(180,'\"> tatia',0,5),(181,'\"> tatia',0,5),(182,'\"> tatia',0,5),(183,'\"> tatia',0,5),(184,'\"> tatia',0,5),(185,'\"> tatia',0,5),(186,'\"> tatia',0,5),(187,'\"> tatia',0,5),(188,'\"> ption',0,5),(189,'\"> ption',0,5),(190,'\"> ption',0,5),(191,'\"> ption',0,5),(192,'\"> ption',0,5),(193,'\"> ption',0,5),(194,'\"> ption',0,5),(195,'\"> ption',0,5),(196,'\"> ption',0,5),(197,'\"> ption',0,5),(198,'Hi, 100$ per click!!!\nlone star ford houston\n[url=http://ford2007.freehostia.com/ford-tacoma.html]ford tacoma[/url]\n',0,6),(199,'dec',0,0),(200,'Hi! Good site respect! freeones Visit freeones and welivetogether.com and davis chevrolet in houston\nchevrolet orlando\n',0,6),(206,'lo217l',0,0),(207,'lo217l',5,0),(208,'lo217l',0,0),(209,'lo217l',5,0),(210,'lo763l',0,0),(211,'lo763l',5,0),(212,'lo763l',0,0),(213,'lo763l',5,0),(214,'lo512l',0,0),(215,'lo512l',5,0),(216,'lo512l',0,0),(217,'lo512l',5,0),(218,'lo512l',0,0),(219,'lo512l',5,0),(220,'lo512l',0,0),(221,'lo512l',5,0),(222,'lo512l',0,0),(223,'lo512l',5,0),(224,'lo512l',0,0),(225,'lo512l',5,0),(226,'lo512l',0,0),(227,'lo512l',5,0),(228,'lo512l',0,0),(229,'lo512l',5,0),(230,'lo512l',0,0),(231,'lo512l',5,0),(232,'lo512l',0,0),(233,'lo512l',5,0),(234,'lo512l',0,0),(235,'lo512l',5,0),(236,'lo512l',0,0),(237,'lo512l',5,0),(238,'Unknown',0,0),(239,'Unknown',0,0),(240,'Unknown',0,0),(241,'Unknown',0,0),(242,'Hi! Good site respect! Visit beyonce nude and nude beaches and beyonce nude and car classic insurance car cheap insurance ratecar compare insurancecar in insurancecar in insurancecar comparison insurancecar compare',0,11),(249,'Good site \r\ncar insurance ratcar insurance pricecar cheap insurance ratecar insurance',0,11),(250,'Good site \r\naffordable car insurancecar insurance nycar cheap insurance rateb',0,12),(263,'Good site \r\nDragonballz\r\nFree Cingular Ringtones, music tones and polyphonic ringtones\r\nCar donation\r\nTravel reward credit card\r\nBluetooth headset cingular accessory\r\nFree Cingular Ringtones, music',0,15),(1221,'Bite the bulletadult novelty home partyadult diaper chatadult novelty home partyadult diaper chatadult friend finder gold passworduk adult swingerarena loan quicken ticketfederal limit loan studenttraveler insurance citigroupunemployment insur',0,21),(1226,'Baby fathercar elephant insurance quote8016 automotive burlington',0,20),(1227,'bucket',0,2),(1228,'Life of Rileydental georgia insurance plangeico direct auto insurancefree vigra samplecheapest place buy vigra onlinedrug levitra viagaraviagara sale onlinedirect student loan consolidationfaxless loan online paydaybuy watson soma online blog cheap soma trackback urladult friend finer ukadult novelty home partycompared levitra viagaradiscount retail viagrracompared levitra viagaradiscount retail viagrracar donation infocommercial insurance trave',0,20),(1237,'We are a grandmotherbuy viagra in canadabuy online viaagraallstate insurancecar geico insurancetraveler renters insuranceallstate insurance careercompared levitra viagarahardcore super xenadrinedebt consolidationcoop manhattan mortgage rate refinance',0,24),(1247,'hosting',0,10),(1248,'Best sites for you!:\r\nHome owner insurance online quote, Home Insurance Rates\r\n0 balance transfer credit card,apply for a credit card\r\nTooth Whitening\r\nBuy Tramadol, Buy Online, Cheap Tramadol\r\nNightmare Before',0,11),(1250,'17954-8530102101',0,0),(1251,'za',0,13),(1252,'bucket',0,2),(1253,'profweb@webmail',0,3),(1254,'za',0,13),(1255,'mysql',0,3),(1256,'templates',0,4),(1257,'stack',0,2),(1258,'aliases',0,2),(1259,'za',0,13),(1260,'Best sites for you!:\r\nCandy Vending Machines\r\nFree Cingular Ringtones, music tones and polyphonic ringtones\r\nMother of the bride dress',0,12),(1261,'Best sites for you!:\r\nNightmare Before Christmas\r\nFree Cingular Ringtones, music tones and polyphonic ringtones\r\nBang gang gr',0,12),(1262,'hosting',0,10),(1263,'za',0,13),(1264,'bounces',0,3),(1265,'Bag and baggageadult friend fineradult dvdadult vibratoradult noveltiesimage online optional post.html soma ticket urladult buffetauto insurancetraveler insurance agencypayday loanmortgage calculator refinancecar donationst pauls traveler insuranceconsolidation debtfaxless payday loanauto insuranceadult entertainmentxenadrinevigraviagrabuy somaadult acneadult noveltiescheap somavigra side effectsadult acneadult swingersadult dvdcar insuranceconsolidate debtconsolidation debt loanviagravigravigra for womanorder vigra onlinebuy viagara online ukviagara online pharmacybuy generic somabuy viiagra wherecheap soma order onlinevigra online pharmacyviagara online pharmacyviagra onlinelow price vigra picture prescription drugvigra side effectslow price vigra picture prescription drugvigra side effectsmail order vaigracom vaigrafake online viagarageneric-somabuy com lvivhost online viagarafemale uk viagarabuy cheap vigra in ukdrug prescription vigraonline sale vaigra100mg vaigracialis compare levitra vaigrageneric brand of viagara onlinebuy prescription vigrabuy here.is somapurchase viiagra onlineonline vigra salescheap vigra onlinebuying online risk vigracheap vigra onlinebuying online risk vigrabest consolidation loan student [url=http://users3.nofeehost.com/inform/arena-loan-quicken/site_map.html]best consolidation loan student[/url] how vaigra works [url=http://users3.nofeehost.com/sideeffects/vaigra-side-effects/index.html]how vaigra works[/url] how vaigra works [url=http://users3.nofeehost.com/sideeffects/vaigra-side-effects/index.html]how vaigra works[/url] vigra sample [url=http://users3.nofeehost.com/sideeffects/vigra-for-women/index.html]vigra sample[/url] how does viaagra work [url=http://sextoyfilm.info/pharma/viaagra/index.html]how does viaagra work[/url] prescription viaa',0,27),(1326,'discount generic viaggra [url=http://sextoyfilm.info/pharma/viaggra/index.html]discount generic viaggra[/url] jack nichol',0,25),(1327,'buy vigra on line [url=http://sextoyfilm.info/pharma/vigra-side-effects/index.html]buy vigra on line[/url] generic online pharmacy vigra [url=http://sextoyfilm.info/pharma/vigra-pills/index.html]generic online pharmacy vigra[/url] generic online pharmacy vigra [url=http://sextoyfilm.info/pharma/vigra-pills/index.html]generic online pharmacy vigra[/url] dodge dart wheels [url=http://do',0,10),(1331,'chiropractic consolidation debt loan student No-brainer\r\n',0,11),(1332,'auto insurance number phone usaa Devil to pay - The\r\n',0,18),(1333,'unemployment insurance program In your face\r\n',0,12),(1334,'unemployment insurance program In your face\r\n',0,12),(1335,'Best sites for you!:\r\nóÅËÓÛÏÐ - íÁÇÁÚÉÎ ÉÎÔÉÍÎÙÈ ÐÏËÕÐÏË\r\nGuiding light opera soap\r\nCar donation\r\n\r\nEnd ^) Goodbye.',0,11),(1336,'Best sites for you!:\r\nKirby vacuum cleaner\r\nSouth beach diet, South beach diet online, About south beach diet\r\nBrowning gun safe\r\n\r\nEn',0,13),(1337,'auto insurance adjuster jobs No man is an island\r\n',0,11),(1338,'traveler insurance A sight for sore eyes\r\n',0,11),(1339,'cash faxing loan no payday Double whammy\r\n',0,11),(1340,'cancer car donation Mutt\'s nuts - The\r\n',0,11),(1341,'saint paul traveler insurance Trouble and strife\r\n',0,11),(1342,'saint paul traveler insurance Trouble and strife\r\n',0,11),(1343,'traveler insurance Know your onions\r\n',0,11),(1344,'traveler insurance Know your onions\r\n',0,11),(1345,'automotive de insurance wilmington High and dry\r\n',0,11),(1346,'automotive de insurance wilmington High and dry\r\n',0,11),(1347,'Needs must\r\n',0,1),(1348,'As fit as a fiddle\r\n',0,0),(1349,'Bog standard\r\n',0,1),(1350,'Teflon president\r\n',0,0),(1351,'Play it again Sam\r\n',0,0),(1352,'Jump the shark\r\n',0,0),(1353,'In a pickle\r\n',0,0),(1354,'technologies',0,8),(1355,'Reduplication\r\n',0,0),(1356,'Red tape\r\n',0,0),(1357,'Beer and skittles\r\n',0,0),(1358,'za',0,13),(1359,'Bob\'s your uncle\r\n',0,0),(1360,'(The) unkindest cut of all\r\n',0,0),(1361,'(The) unkindest cut of all\r\n',0,0),(1362,'We are a grandmother\r\n',0,0),(1363,'http://tamatjita.com/elearn/task/riseb/avej/',0,8),(1364,'http://www.slda.info/images/lebun/isexopo/',0,12),(1365,'mweb',0,1),(1366,'managing',0,3),(1367,'adsl',0,1),(1368,'accessing',0,1),(1369,'http://www.polarflug.de/iltgen/admin/csv/inako/upuciz/',0,9),(1370,'http://www.fabcraft.co.uk/forum/lovuqo/zil/',0,8),(1371,'za',0,13),(1372,'za',0,13),(1373,'How are things?\r\n2fphenterminesearchers.com [url=http://buyphentermine.awardspace.co.uk/2fphenterminesearchers.com/index.html]2fphenterminesearchers.com[/url]',0,9),(1374,'Best sites for you!:\r\nhttp://tone1.hit.bg\r\nhttp://buy-valium.awardspace.com\r\nhttp://suzukigrandvitara.tripod.com\r\nhttp://suzukigrandvitara.tripod.com\r\n\r\nEnd ^) Goodbye.',0,8),(1375,'Best sites for you!:\r\nhttp://southbeachdiet.741.com\r\nhttp://lumberwood.tripod.com\r\nhttp://toothwhitening.freewebspace.com\r\nhttp://megasexshop.bka.ru\r\n\r\nEnd ^) Goodbye.',0,8),(1376,'bucket',0,2),(1377,'subscribers',0,9),(1378,'technologies',0,8),(1379,'adsl',0,1),(1380,'za',0,13),(1381,'ftp',0,4),(1382,'accessing',0,1),(1383,'mweb',0,1),(1384,'managing',0,3),(1385,'adsl',0,1),(1386,' Other or undefined network or routing status',0,8),(1387,'I couldn\'t ever imagine...\r\n2fphenterminesearchers.com [url=http://buyphentermine.awardspace.co.uk/2fphenterminesearchers.com/index.html]2fphenterminesearchers',0,9),(1388,'2.1.0',0,0),(1389,'2.1.0',0,0),(1390,'2.1.0',0,0),(1391,'I didn\'t think I\'ll be meeting you here.\r\n2fphenterminesearchers.com [url=http://buyphentermine.awardspace.co.uk/2fphenterminesearchers.com/index.html]2fphente',0,9),(1392,'alias',0,2),(1393,'Best sites for you!:\r\nhttp://cosmetology-school.blogggest.com\r\nhttp://buy-tramadol-1.100webspace.net\r\nhttp://cosmetology-school.blogggest.com\r\nhttp://dragonballz1.freewebspace.com\r\n\r\nEnd ^) Goodbye.',0,8),(1394,'Best sites for you!:\r\nhttp://rhodiola.angelcities.com\r\nhttp://vendingcandy.tripod.com\r\nhttp://balancecred.bravehost.com\r\nhttp://zipo1.741.com\r\n\r\nEnd ^) Goodbye.',0,8),(1395,'iburst',0,1),(1396,'responder',0,1),(1397,'Best sites for you!:\r\nhttp://tone4.741.com\r\nhttp://zipo1.741.com\r\nhttp://hotelinvenice.freewebspace.com\r\nhttp://cheapfuton.freewebspace.com\r\nhttp://transcred.freehostia.com\r\n\r\nEnd ^) Goodbye.',0,8),(1398,'Best sites for you!:\r\nhttp://toothwhitening.freewebspace.com\r\nhttp://zipo3.hit.bg\r\nhttp://toothwhitening.freewebspace.com\r\nhttp://hertzcarrental.250free.com\r\nhttp://buy-valium.awardspace.com\r\n\r\nEnd ^) Goodbye.',0,8),(1399,'supprt center',0,0),(1400,'suppt center',0,0),(1401,'scanned',0,1),(1402,'client',0,6),(1403,'za',0,13),(1404,'za',0,13),(1405,'hosting',0,10),(1406,'mailadmin',0,3),(1407,'za',0,13),(1408,'liebfamily',0,0),(1409,'liebfamily',0,0),(1410,'5.4.0',0,1),(1411,'webmail',0,3),(1412,'spamassassin',0,1),(1413,'pass',0,8),(1414,'hosting',0,10),(1415,'templates',0,4),(1416,'mysql',0,3),(1417,'adsl',0,1),(1418,'za',0,13),(1419,'technologies',0,8),(1420,'aliases',0,2),(1421,'alias',0,2),(1422,'responder',0,1),(1423,'client',0,6),(1424,'scanned',0,1),(1425,'attachments',0,2),(1426,'attachment cost',0,2),(1427,'za',0,13),(1428,'za',0,13),(1429,'za',0,13),(1430,'forwards',0,1),(1431,'mailadmin',0,3),(1432,'accounts',0,7),(1433,'pass',0,8),(1434,'webmail',0,3),(1435,'eudora',0,1),(1436,'export',0,3),(1437,'technologies',0,8),(1438,'adsl',0,1),(1439,'za',0,13),(1440,'1 casino free hour online play \r\n 10 best casino image online optiona',0,25),(1441,'1 casino free hour online play \r\n 10 best casino image online optiona',0,25),(1442,'recieved',0,1),(1443,'stack',0,2),(1444,'alias',0,2),(1445,'responder',0,1),(1446,'scanned',0,1),(1447,'scanned',0,1),(1448,'responder',0,1),(1449,'mailadmin',0,3),(1450,'pass',0,8),(1451,'webmail',0,3),(1452,'technologies',0,8),(1453,'za',0,13),(1454,'alias',0,2),(1455,'mailadmin',0,3),(1456,'pass',0,8),(1457,'how to place a password on email',0,34),(1458,'za',0,13),(1459,'bucket',0,2),(1460,'eudora',0,1),(1461,'za',0,13),(1462,'http://www.hitquarters.com/images/cafohu/uqato/',0,11),(1463,'Hello! I\'m Brandon! I like your site! Pretty design, convinient navigation! Very good!',0,4),(1464,'subscribers',0,9),(1465,'managing',0,3),(1466,'mweb',0,1),(1467,'viagra, buy cheap viagra [url=http://www.uc.fas.harvard.edu/tmp/viagra/buy-cheap-viagra.html]buy cheap viagra[/url] , pills for men, buy viagra\r\n',0,19),(1468,'viagra, buy cheap viagrahttp://www.uc.fas.harvard.edu/tmp/viagra/viagra-online-cheap.html [url=http://www.uc.fas.harvard.edu/tmp/viagra/buy-cheap-viagra.html]buy cheap via',0,19),(1469,'discount viagra [url=http://www.uc.fas.harvard.edu/tmp/viagra/discount-viagra.html]discount viagra[/url] \r\n',0,19),(1470,'discount viagra [url=http://www.uc.fas.harvard.edu/tmp/viagra/discount-viagra.html]discount viagra[/url] \r\n',0,19),(1471,'5.4.0',0,1),(1472,'viagra sale onlinehttp://www.uc.fas.harvard.edu/tmp/viagra/purchase-viagra.html [url=http://www.uc.fas.harvard.edu/tmp/viagra/viagra-sale-online.html]viagra sale onlineh',0,20),(1473,'za',0,13),(1474,'generic cialis [url=http://www.uc.fas.harvard.edu/temp/cialis/generic-cialis.html]generic cialis[/url] viagra sale online [url=http://www.uc.fas.harvard.edu/temp/viagra/viagra-sale-online.html]viagra sale online[/url] viagra sale online [url=http://www.uc.fas.harvard.edu/temp/viagra/viagra-sale-online.html]viagra sale online[/url] brutal anal fisting\r\nnatural big tit\r\ncancun mexico vacation [url=http://myvacationo.info/cancun-mexico-vacation.html]cancun mexico vacation[/url] califor',0,22),(1501,'responder',0,1),(1502,'client',0,6),(1503,'scanned',0,1),(1504,'za',0,13),(1505,'Your site is amazing, thank you !\r\nRegards, ufdnbsu',0,2),(1506,'vacation [url=http://travelvacation.741.comsitemap0.html]vacation[/url] vacation [url=http://gotvacation.freehostia.com/sitem',0,19),(1507,'hosting',0,10),(1508,'mailadmin',0,3),(1509,'za',0,13),(1510,'spamassassin',0,1),(1511,'access psite',0,2),(1512,'za',0,13),(1513,'snakehead fish [url=http://carnaval91.happyhost.org/index4.html]snakehead fish[/url] average breast size [url=http://carnaval94.9f.com/',0,23),(1514,'help unscramble words [url=http://carnaval94.freehostia.com/index7.html]help unscramble words[/url] pre employment background screening',0,20),(1515,'za',0,13),(1516,'client',0,6),(1517,'za',0,13),(1518,'las vagas vacation [url=http://maui-vacation.yourdieto.info/index.html]las vagas vacation[/url] flordia keys vacation [url',0,19),(1519,'michigan vacation rental [url=http://maui-vacation.yourdieto.info/index.html]michigan vacation rental[/url] flordia keys vacatio',0,19),(1520,'Hi! I\'m John Strass and i like your site!\r\nThank you!',0,3),(1521,'spamassassin',0,1),(1522,'za',0,13),(1523,'za',0,13),(1524,'za',0,13),(1525,'aliases',0,2),(1526,'responder',0,1),(1527,'client',0,6),(1528,'scanned',0,1),(1529,'Your site is amazing, thank you !\r\nRegards, The Train',0,11),(1530,'bounces',0,3),(1531,'bounces',0,3),(1532,'bounce types',0,3),(1533,'hard bounce',0,3),(1534,'5.4.2 hard Bad connection',0,4),(1535,'workshops dates',0,0),(1536,'5.4.7',0,1),(1537,'bounce',0,3),(1538,'hosting',0,10),(1539,'Zola 7',0,0),(1540,'Zola',0,0),(1541,'Zola 7',0,0),(1542,'Zola 7',0,0),(1543,'Zola 7',0,0),(1544,'5.3.0 hard Other or undefined mail system status',0,26),(1545,'export',0,3),(1546,'adsl',0,1),(1547,'za',0,13),(1548,'4.1.1',0,0),(1549,'5.4.3',0,1),(1550,'Failed; 5.7.0 (other or undefined security status)',0,4),(1551,'5.7.0',0,1),(1552,'Failed; 5.7.0 (other or undefined security status)',0,4),(1553,'Hi! I\'m Dr. Phillips! I love your site - it\'s really good!\r\n buy viagra buy viagra \r\n[url=http://www.answerbag.com/profile/?id=284536&u=buy-viagra] buy viagra [/url]\r\nThank you!',0,14),(1554,'Hi! I\'m Dr. Phillips! I love your site - it\'s really good!\r\n buy viagra online buy viagra online\r\n[url=http://digg.com/world_news/Buy_Viagra_Online_THE_LOWEST_PRIC',0,13),(1555,'Hi! I\'m Dr. Phillips! I love your site - it\'s really good!\r\n buy viagra online buy viagra online\r\n[url=http://www.blinklist.com/Buy_Viagra_Online/]buy viagra[/url]\r\nThank you!',0,13),(1556,'ntshebe vol5',0,0),(1557,'ntshebe vol5',0,0),(1558,'ntshebe vol5',0,0),(1559,'Hi! I\'m Dr. Santana! I love your site! Looking for Viagra?\r\n order viagra order viagra\r\nhttp://www.blinklist.com/_-ORDER-VIAGRA-ONLINE-CHEAP!-_/]order viagra[/url]\r\nThank you!',0,14),(1560,'Hi! I\'m Dr. Santana! I love your site! Looking for Viagra?\r\n order viagra order viagra\r\nhttp://www.blinklist.com/_-ORDER-VIAGRA-ONLINE-CHEAP!-_/]order viagra[/url]\r\nThank you!',0,14),(1561,'forwards',0,1),(1562,'opt-out',0,1),(1563,'opt',0,13),(1564,'opt',0,13),(1565,'Hi! I\'m Dr. Santana! I love your site!\r\n buy cialis buy cialis \r\n[url=http://www.blinklist.com/Buy_Cialis_Online_-_US_Drugstore_/]buy cialis[/url]\r\nThank you!',0,11),(1566,'accounts',0,7),(1567,'za',0,13),(1568,'technologies',0,8),(1569,'mweb',0,1),(1570,'Hello! I\'m Dr. Richardson! Check my Cialis profile: \r\n cheap cialis cheap cialis \r\n[url=http://www.blinklist.com/Cheap_Cialis_Online_Dr.Phillip/]cheap cialis[/url]\r\nThank you!',0,16),(1571,'za',0,13),(1572,'stack',0,2),(1573,'recieved',0,1),(1574,'meaning of customer centre',0,3),(1575,'za',0,13),(1576,'Your site is super, thank you !\r\nRegards, youporn',0,11),(1577,'za',0,13),(1578,'za',0,13),(1579,'za',0,13),(1580,'templates',0,4),(1581,'mysql',0,3),(1582,'bounce',0,3),(1583,'za',0,13),(1584,'scanned',0,1),(1585,'Failed; 5.4.0 (other or undefined network or routing status)',0,8),(1586,'5.4.0',0,1),(1587,'5.4.0',0,1),(1588,'Failed; 5.4.0 (other or undefined network or routing status)',0,8),(1589,'bounce',0,3),(1590,'za',0,13),(1591,'Hello! I\'m Dr.Richardson! I like your site - lots of useful tips! If you\'re looking for \r\n buy viagra online buy viagra online [url=http://www.answerbag.com/profile/?id=29',0,12),(1592,'Hello! I\'m Dr.Richardson! I like your site - lots of useful tips! If you\'re looking for \r\n generic viagra generic viagra [url=http://www.blinklist.com/Order_Generic_Viagra_Online/]',0,11),(1593,'Hello! I\'m Dr.Richardson! I like your site - lots of useful tips! If you\'re looking for \r\n generic viagra generic viagra [url=http://www.blinklist.com/Order_Generic_Viagra_Online/]',0,11),(1594,'Your site is super, thank you !\r\nRegards, Mike Kalazi',0,2),(1595,'Hello! I\'m Dr.Richardson! I like your site - lots of useful tips! If you\'re looking for \r\n generic viagra generic viagra [url=http://www.blinklist.com/_-CHEAP-VIAGRA-O',0,11),(1596,'Hello! I\'m Dr.Richardson! I like your site - lots of useful tips! If you\'re looking for \r\n generic viagra generic viagra [url=http://www.blinklist.com/_-CHEAP-VIAGRA-O',0,11),(1597,'pass',0,8),(1598,'hosting',0,10),(1599,'hosting',0,10),(1600,'Hello! I\'m Dr.Richardson! I like your site - lots of useful tips! If you\'re looking for \r\n generic viagra generic viagra [url=http://www.blinklist.com/_-CHEAP-VIAGRA-O',0,11),(1601,'Your site is good, thank you !\r\nRegards, Michel Gawayan',0,4),(1602,'webmail',0,3),(1603,'download',0,0),(1604,'download',0,0),(1605,'download',0,0),(1606,'Your site is the best of all world, thank you !\r\nRegards, Minendo Kuchevo',0,3),(1607,'adsl',0,1),(1608,'pass',0,8),(1609,'hosting',0,10),(1610,'za',0,13),(1611,'Your site is the really best of i saw, thank you for interesting time !\r\nRegards, Makoreno Kakozhe',0,8),(1612,'Your site is the really best of i saw, thank you for interesting time !\r\nmy sites youporn about different movies and pictures, redtube about milkiway production and c',0,17),(1613,'za',0,13),(1614,'Your site is the really best of i saw, thank you for interesting time !\r\nmy sites youporn about different movies and pictures, redtube about milkiway production and c',0,17),(1615,'Your site is the really best of i saw, thank you for interesting time !\r\nmy sites youporn about different movies and pictures, redtube about milkiway production and c',0,17),(1616,'spamassassin',0,1),(1617,'bucket',0,2),(1618,'eudora',0,1),(1619,'technologies',0,8),(1620,'za',0,13),(1621,'5.5.0 hard Other or undefined protocol status',0,7),(1622,'alias',0,2),(1623,'aliases',0,2),(1624,'client',0,6),(1625,'mailadmin',0,3),(1626,'bounce',0,3),(1627,'Hi! I\'m Dr. Jhonatan Wildes and cheap vi',0,11),(1628,'Hi! I\'m Dr. Jhonatan Wildes and cheap vi',0,11),(1629,'Hi! I\'m Dr. Jhonatan Wildes and cheap vi',0,11),(1630,'bounce',0,3),(1631,'Hi! I\'m Dr. Jhonatan Wildes and generic viagra generic viagra [url=http://genericviagrafda.blinklist.com/] generic viagra [/url] Thank you!',0,11),(1632,'Hi! I\'m Dr. Jhonatan Wildes and generic viagra generic viagra [url=http://genericviagrafda.blinklist.com/] generic viagra [/url] Thank you!',0,11),(1633,'bounce',0,3),(1634,'Your site is good for me and my friends, thank you for super articles and discuisses !\r\nmy forums and sites tube8 about wallpapers to desktop, redtube about airplan',0,14),(1635,'It is the best what i saw, 4ever !!!',0,0),(1636,'za',0,13),(1637,'pass',0,8),(1638,'managing',0,3),(1639,'export',0,3),(1640,'recieved',0,1),(1641,'Hi! I\'m Dr. Jhonatan Wildes and generic viagra generic viagra [url=http://genericviagrafda.blinklist.com/] generic viagra [/url] Thank you!',0,11),(1642,'4.1.1',0,0),(1643,'Hi! I\'m Dr. Jhonatan Wildes and i like your site! \r\n buy xanax without prescription in usa buy xanax without prescription in usa [url=http://cheapxanaxusa.blinklist.com/] buy xanax without prescripti',0,11),(1644,'responder',0,1),(1645,'integrated',0,0),(1646,'embed',0,2),(1647,'cid',0,0),(1648,'mysql',0,3),(1649,'templates',0,4),(1650,'za',0,13),(1651,'hosting',0,10),(1652,'5.1.2',0,1),(1653,'scanned',0,1),(1654,'forwards',0,1),(1655,'erms',0,1),(1656,'accounts',0,7),(1657,'nICKY bIGGAR',0,0),(1658,'nICKY bIGGAR',0,0),(1659,'nICKY bIGGAR',0,0),(1660,'5.7.2 hard Mailing list expansion prohibited',0,28),(1661,'5.7.2 hard Mailing list expansion prohibited',0,28),(1662,'5.7.2',0,1),(1663,'mweb',0,1),(1664,'subscribers',0,9),(1665,'adsl',0,1),(1666,'technologies',0,8),(1667,'stack',0,2),(1668,'za',0,13),(1669,'http://66.77.165.68/list.txt?',0,32),(1670,'za',0,13),(1671,'za',0,13),(1672,'5.1.2',0,1),(1673,'autoresponder',0,0),(1674,'auto',0,6),(1675,'reports',0,2),(1676,'read',0,4),(1677,'za',0,13),(1678,'accessing',0,1),(1679,'ftp',0,4),(1680,'export',0,3),(1681,'5.6.5',0,1),(1682,'5.4.0',0,1),(1683,'5.4.0',0,1),(1684,'Application forms',0,6),(1685,'bucket',0,2),(1686,'za',0,13),(1687,'aliases',0,2),(1688,'recieved',0,1),(1689,'stack',0,2),(1690,'za',0,13),(1691,'za',0,13),(1692,'t116t',0,0),(1693,'t116t',0,0),(1694,'t116t',0,0),(1695,'t116t',0,0),(1696,'t116t',0,0),(1697,'t116t',0,0),(1698,'t116t',0,0),(1699,'t116t',0,0),(1700,'t116t',0,0),(1701,'t116t',0,0),(1702,'t116t',0,0),(1703,'t116t',0,0),(1704,'t116t',0,0),(1705,'t116t',0,0),(1706,'t116t',0,0),(1707,'t116t',0,0),(1708,'t874t',0,0),(1709,'t874t',0,0),(1710,'t874t',0,0),(1711,'t874t',0,0),(1712,'t874t',0,0),(1713,'t874t',0,0),(1714,'t874t',0,0),(1715,'t874t',0,0),(1716,'t874t',0,0),(1717,'t874t',0,0),(1718,'t874t',0,0),(1719,'t874t',0,0),(1720,'t874t',0,0),(1721,'t874t',0,0),(1722,'spamassassin',0,1),(1723,'za',0,13),(1724,'security',0,1),(1726,'t875t',0,0),(1727,'t875t',0,0),(1728,'t964t',0,0),(1729,'t964t',0,0),(1730,'t875t',0,0),(1731,'t875t',0,0),(1732,'t964t',0,0),(1733,'t875t',0,0),(1734,'t964t',0,0),(1735,'t964t',0,0),(1736,'t964t',0,0),(1737,'t48t',0,0),(1738,'t48t',0,0),(1739,'t48t',0,0),(1740,'t85t',0,0),(1741,'t85t',0,0),(1742,'t48t',0,0),(1743,'t85t',0,0),(1744,'t48t',0,0),(1745,'t85t',0,0),(1746,'t85t',0,0),(1747,'managing',0,3),(1748,'eudora',0,1),(1749,'za',0,13),(1750,'mysql',0,3),(1751,'templates',0,4),(1752,'mweb',0,1),(1753,'adsl',0,1),(1754,'subscribers',0,9),(1755,'technologies',0,8),(1756,'accessing',0,1),(1757,'ftp',0,4),(1758,'export',0,3),(1759,'bucket',0,2),(1760,'za',0,13),(1761,'za',0,13),(1762,'pass',0,8),(1763,'alias',0,2),(1764,'webmail',0,3),(1765,'za',0,13),(1766,'za',0,13),(1767,'scanned',0,1),(1768,'za',0,13),(1769,'za',0,13),(1770,'free emails',0,9),(1771,'free emails',35,0),(1772,'free',35,0),(1773,'responder',0,1),(1774,'XML',0,0),(1775,'XML',0,0),(1776,'XML',0,0),(1777,'.XML',0,0),(1778,'XML',0,0),(1779,'XML',0,0),(1780,'za',0,23),(1781,'za',0,23),(1782,'outlook',0,6),(1783,'uploading',0,2),(1784,'za',0,25),(1785,'za',0,25),(1786,'za',0,25),(1787,'za',0,25),(1788,'za',0,25),(1789,'za',0,25),(1790,'za',0,25),(1791,'za',0,25),(1792,'za',0,25),(1793,'za',0,25),(1794,'za',0,25),(1795,'za',0,25),(1796,'scanned',0,2),(1797,'za',0,25),(1798,'za',0,25),(1799,'za',0,25),(1800,'za',0,25),(1801,'za',0,25),(1802,'za',0,25),(1803,'za',0,25),(1804,'forwards',0,1),(1805,'list members in categories',0,24),(1806,'send mail to spesific persons',0,20),(1807,'za',0,25),(1808,'za',0,25),(1809,'za',0,25),(1810,'za',0,25),(1811,'za',0,25),(1812,'za',0,25),(1813,'za',0,25),(1814,'za',0,25),(1815,'za',0,25),(1816,'za',0,25),(1817,'za',0,25),(1818,'za',0,25),(1819,'za',0,25),(1820,'za',0,25),(1821,'za',0,25),(1822,'za',0,25),(1823,'za',0,25),(1824,'za',0,25),(1825,'za',0,25),(1826,'za',0,25),(1827,'5.4.7',0,1),(1828,'5.4.7',0,1),(1829,'5.4.7',0,1),(1830,'za',0,25),(1831,'za',0,25),(1832,'set up mail',0,10),(1833,'set up mail',0,10),(1834,'create mail',0,17),(1835,'wher is the create mail icon',0,18),(1836,'wher is the create mail icon',0,18),(1837,'wher is the create mail icon',0,18),(1838,'za',0,25),(1839,'templates',0,4),(1840,'free templates',0,4),(1841,'za',0,25),(1842,'za',0,25),(1843,'za',0,25),(1844,'za',0,25),(1845,'za',0,25),(1846,'za',0,25),(1847,'za',0,25),(1848,'za',0,25),(1849,'za',0,25),(1850,'mysql',0,3),(1851,'adsl',0,1),(1852,'bucket',0,2),(1853,'technologies',0,9),(1854,'templates',0,4),(1855,'za',0,25),(1856,'za',0,25),(1857,'za',0,25),(1858,'NUMTEC FORM',0,7),(1859,'NUMTEC FORM',0,7),(1860,'NUMTEC FORM',0,7),(1861,'NUMTEC FORM',0,7),(1862,'stall',0,1),(1863,'stall',0,1),(1864,'spam',0,3),(1865,'spam',0,3),(1866,'spam',0,3),(1867,'video player',0,0),(1868,'video player',0,0),(1869,'youtube',0,0),(1870,'youtube',0,0),(1871,'video',0,0),(1872,'flash',0,0),(1873,'Da lastest issue',0,0),(1874,'embedding',0,0),(1875,'za',0,25),(1876,'za',0,25),(1877,'za',0,25),(1878,'stack',0,2),(1879,'za',0,25),(1880,'za',0,25),(1881,'za',0,25),(1882,'responder',0,1),(1883,'I found a lot of information about gmc envoy here.',0,8),(1884,'I',0,48),(1885,'found',0,2),(1886,'a',0,48),(1887,'I found a lot of information about gmc envoy here.',0,29),(1888,'I found a lot of information about
![\"\"](\"http://helpdesk.prefix.co.za/modules/KB/Image/Image/knowlidge_base_pics/deleting_mails_via_webmail/webmail)
![\"\"](\"http://helpdesk.prefix.co.za/modules/KB/Image/Image/knowlidge_base_pics/deleting_mails_via_webmail/logon.JPG\")
![\"\"](\"http://helpdesk.prefix.co.za/modules/KB/Image/Image/knowlidge_base_pics/deleting_mails_via_webmail/maintenance.JPG\")