-- MySQL dump 10.9
--
-- Host: localhost Database: jodyf_vgb2
-- ------------------------------------------------------
-- Server version 4.1.22-standard-log
/*!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 */;
/*!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 `VGB_ACTION`
--
DROP TABLE IF EXISTS `VGB_ACTION`;
CREATE TABLE `VGB_ACTION` (
`VID` int(11) NOT NULL default '0',
`TSTAMP` datetime NOT NULL default '0000-00-00 00:00:00',
`ACTION` int(11) NOT NULL default '0',
`DETAILS` varchar(255) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `VGB_ACTION`
--
LOCK TABLES `VGB_ACTION` WRITE;
/*!40000 ALTER TABLE `VGB_ACTION` DISABLE KEYS */;
INSERT INTO `VGB_ACTION` VALUES (232,'2007-07-02 20:23:09',1,'1'),(223,'2007-06-30 03:24:44',18,'Rooster'),(224,'2007-06-30 04:42:12',18,'Rooster'),(226,'2007-06-30 18:03:38',1,'1'),(229,'2007-07-01 16:41:54',1,'1'),(231,'2007-07-02 09:43:40',1,'1'),(228,'2007-07-01 08:44:57',1,'1'),(234,'2007-07-03 19:31:27',1,'1'),(233,'2007-07-03 09:52:59',1,'1'),(225,'2007-06-30 07:03:00',18,'Hayd'),(227,'2007-06-30 22:17:30',1,'1'),(230,'2007-07-01 20:19:24',1,'1');
/*!40000 ALTER TABLE `VGB_ACTION` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `VGB_ADMIN`
--
DROP TABLE IF EXISTS `VGB_ADMIN`;
CREATE TABLE `VGB_ADMIN` (
`ID` int(11) NOT NULL auto_increment,
`NAME` varchar(255) NOT NULL default '',
`PASSWORD` varchar(30) NOT NULL default '',
`LASTLOGIN` datetime NOT NULL default '0000-00-00 00:00:00',
`LOGINS` int(10) unsigned NOT NULL default '0',
`COMMENTNAME` varchar(255) NOT NULL default '',
`COMMENTEMAIL` varchar(127) NOT NULL default '',
`ACCEPT` tinyint(1) NOT NULL default '0',
`REJECT` tinyint(1) NOT NULL default '0',
`EDIT` tinyint(1) NOT NULL default '0',
`COMMENT` tinyint(1) NOT NULL default '0',
`DEL` tinyint(1) NOT NULL default '0',
`CLOSE` tinyint(1) NOT NULL default '0',
`BANUSER` tinyint(1) NOT NULL default '0',
`ENTRYSENT` tinyint(1) NOT NULL default '0',
`COMMENTSENT` tinyint(1) NOT NULL default '0',
`EMAILSENT` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `VGB_ADMIN`
--
LOCK TABLES `VGB_ADMIN` WRITE;
/*!40000 ALTER TABLE `VGB_ADMIN` DISABLE KEYS */;
/*!40000 ALTER TABLE `VGB_ADMIN` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `VGB_CACHE`
--
DROP TABLE IF EXISTS `VGB_CACHE`;
CREATE TABLE `VGB_CACHE` (
`ID` int(11) default NULL,
`DATE` date NOT NULL default '0000-00-00',
`NAME` text,
`ENTRY` text NOT NULL,
`COMMENT` text,
`COUNTRY` int(11) default NULL,
`EMAIL` varchar(128) default NULL,
`HOMEPAGE` text,
`ICQ` int(10) unsigned default NULL,
`AIM` text,
`MSN` text,
`YAHOO` text,
`IP` varchar(16) NOT NULL default '',
`BROWSER` varchar(255) NOT NULL default '',
`HOSTNAME` varchar(128) NOT NULL default '',
`SIGNTIME` time default NULL,
`PICTURE` varchar(32) default NULL,
`PICTEXT` text,
`PRIVATE` varchar(20) default NULL,
`HIDEEMAIL` tinyint(1) NOT NULL default '0',
`UNMODERATED` tinyint(1) NOT NULL default '0',
`SKYPE` text,
`JABBER` text,
`GADUGADU` int(10) unsigned default NULL,
`GENDER` tinyint(3) unsigned NOT NULL default '0',
`CLOSED` tinyint(1) NOT NULL default '0',
`STICKY` tinyint(3) unsigned NOT NULL default '0',
`RATINGS` varchar(60) default NULL,
`CUSTOMS` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `VGB_CACHE`
--
LOCK TABLES `VGB_CACHE` WRITE;
/*!40000 ALTER TABLE `VGB_CACHE` DISABLE KEYS */;
INSERT INTO `VGB_CACHE` VALUES (14,'2007-06-20','Chris','2 muppets. Perfect Name! 
\r
\r
Maybe I could meet you someone along the skeleton coast with a case of stella and a bbq?\r
\r
For three and a half years I've been been living a blissful life in NZ, ignorant of the big wide world outside. \r
\r
Now my feet are itchier than your m...\r
\r
Anyway, good luck guys. Maybe I can meet you en route somewhere with much needed supplies?',NULL,190,'chris.lindley@rev-id.com','www.rev-id.com/',NULL,NULL,NULL,NULL,'125.239.30.169','Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.2; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; FDM)','125-239-30-169.jetstream.xtra.co.nz','09:40:25',NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0,'',''),(13,'2007-06-17','Juan Valdez',' 
\r
\r
Muppets',NULL,67,'lbellemore@gmail.com',NULL,NULL,NULL,NULL,NULL,'201.224.69.12','Mozilla/5.0 (Windows; U; Windows NT 5.1; es-AR; rv:1.8.1.3) Gecko/20070309 Firefox/2.0.0.3','201.224.69.12','17:17:21',NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0,'',''),(12,'2007-06-14','Rooster','Dan... I didn't understand a word of your upgrade story but you are going to have the flashest bike in all of Africa. That is some bad sh*t!',NULL,190,'rory.cuthbert@asbgroup.co.nz',NULL,NULL,NULL,NULL,NULL,'210.55.180.44','Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)','210-55-180-44.netgate.net.nz','20:58:02',NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0,'',''),(11,'2007-04-29','Rooster','Dan,Jody.... Bloody Marvelous effort just thinking about doing this. It will live with you forever as the biggest accomplishment I'm sure. I am certifiably jealous and horrifically scared for you both. Jody obviously you will be the level headed one that has to look after the over-excited one so stay focussed at all times! Just Remember not to put any moro wrappers in Dans pack!I have heard such mad stories from other such adventures and look forward to following yours. Did I mention Jealous? Anyway,, so proud of you boys...GO FORTH AND CONQUER!\r
P.S dont pat the Hippos!',NULL,190,'rory.cuthbert@asbgroup.co.nz',NULL,NULL,NULL,NULL,NULL,'210.55.180.44','Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)','210-55-180-44.netgate.net.nz','20:00:23',NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0,'',''),(10,'2007-04-20','Nix','Hey guys\r
I had my first taste of your trip this morning with the collection of Ernie - man I'm excited for you 2!!! 
\r
Very happy about all the research you guys are doing and the mods to the bikes – you seem to be teaching the KTM peeps a bit about the usage of their own stock!!! Good one!!!\r
Good luck with the rest of the prep!! xxx',NULL,175,'nicolaf@nedbank.co.za',NULL,NULL,NULL,NULL,NULL,'196.36.217.137','Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)','mm.nedcor.com','13:05:28',NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0,'',''),(9,'2007-04-16','Hayd','I couldn't see in the pic, was it a John Deer or Massy Fergison? \r
\r
PS don't wear loose clothing when looking at the PTO.',NULL,88,'htuck2@lambeth.gov.uk',NULL,NULL,NULL,NULL,NULL,'217.33.8.36','Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.1.4322)','departing.lambeth.gov.uk','17:54:16',NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0,'',''),(8,'2007-03-20','Conor','Hey Dan,\r
\r
Best of luck...\r
I've seen you try and change the toner in a printer in an office, how will you fix a bike in the jungle?\r
\r
Conor',NULL,44,'odonovancon@gmail.com',NULL,NULL,NULL,NULL,NULL,'57.66.51.74','Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; VNIE60; .NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.1)','gwlon.paconsulting.com','11:31:09',NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0,'',''),(7,'2007-03-14','Mom','I realy dont know which of you guys is the more crazy!!! I am very proud of you both though and feel so much better because you have proved -Everest- that you support each other so much.You two muppets seem to have gaurdian angels on each shoulder.Dan,we do expect to see your bike in Shepperton soon - maybe a frostie will lure you!Good luck with all the prep.The old lady. 
',NULL,44,'forresters@cinet.co.za',NULL,NULL,NULL,NULL,NULL,'82.71.3.206','Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR 3.0.04506)','82-71-3-206.dsl.in-addr.zen.co.uk','14:24:29',NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0,'',''),(6,'2007-03-13','Dave','When are you two going to grow up....\r
\r
Good luck boys, be sure to post loads of stories as I will be living vicariously through you when im sitting at my desk in Wellington looking down the Terrace at another gloomy Wellington day.',NULL,190,'david.j.anderson@nz.pwc.com',NULL,NULL,NULL,NULL,NULL,'166.179.23.87','Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)','166-179-23-87.jamamobile.co.nz','20:59:33',NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0,'',''),(5,'2007-03-13','Aline Shuttleworth','All the best for the ride. Have a super time!',NULL,175,'a.shuttleworth@bowman.co.za',NULL,NULL,NULL,NULL,NULL,'69.67.41.67','Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; www.bowman.co.za; .NET CLR 1.1.4322; .NET CLR 2.0.50727)','bowman-jhb.ilan','12:49:04',NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0,'',''),(4,'2007-03-13','frosty','howbo! Looking forward to catching up along route. better get some practice in da gym for picking up those bikes. hope you have a jol and beware the night fighters!! 
',NULL,175,'careyf@telkomsa.net',NULL,NULL,NULL,NULL,NULL,'198.54.202.195','Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)','ctb-cache5-vif1.saix.net','08:59:23',NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0,'',''),(3,'2007-03-09','Cat','Man you guys are mad and surely at least a little bit crazy. Part of me is incredibly jealous though. Good luck with the prep, make sure you know those bikes inside out! xxx',NULL,190,'cmorgan@expressdata.co.nz',NULL,NULL,NULL,NULL,NULL,'125.237.11.194','Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727)','125-237-11-194.jetstream.xtra.co.nz','00:50:44',NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0,'',''),(2,'2007-03-04','Nik','good luck guys!!! you crazy kids. x 
',NULL,44,NULL,'www.aldworthjames.co.uk',NULL,NULL,NULL,NULL,'81.153.83.134','Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)','host81-153-83-134.range81-153.btcentralplus.com','16:35:54',NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0,'',''),(1,'2007-02-24','Jody','Testing the guestbook....\r
\r
',NULL,175,NULL,'www.jodyforrester.com',NULL,NULL,NULL,NULL,'196.25.255.194','Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)','ctb-cache4-vif0.saix.net','17:50:06',NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0,'','');
/*!40000 ALTER TABLE `VGB_CACHE` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `VGB_COMMENT`
--
DROP TABLE IF EXISTS `VGB_COMMENT`;
CREATE TABLE `VGB_COMMENT` (
`ID` int(11) NOT NULL auto_increment,
`ENTRYID` int(11) NOT NULL default '0',
`NAME` varchar(120) NOT NULL default '',
`EMAIL` varchar(40) default NULL,
`TEXT` text NOT NULL,
`IP` varchar(16) NOT NULL default '',
`HOSTNAME` varchar(128) NOT NULL default '',
`DATE` date NOT NULL default '0000-00-00',
`SIGNTIME` time NOT NULL default '00:00:00',
`ADMIN` tinyint(1) NOT NULL default '0',
`UNMODERATED` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `VGB_COMMENT`
--
LOCK TABLES `VGB_COMMENT` WRITE;
/*!40000 ALTER TABLE `VGB_COMMENT` DISABLE KEYS */;
/*!40000 ALTER TABLE `VGB_COMMENT` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `VGB_COMMENTSPAM`
--
DROP TABLE IF EXISTS `VGB_COMMENTSPAM`;
CREATE TABLE `VGB_COMMENTSPAM` (
`IP` varchar(16) NOT NULL default '',
`TSTAMP` datetime NOT NULL default '0000-00-00 00:00:00',
`ENTRYID` int(11) NOT NULL default '0',
PRIMARY KEY (`IP`,`TSTAMP`,`ENTRYID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `VGB_COMMENTSPAM`
--
LOCK TABLES `VGB_COMMENTSPAM` WRITE;
/*!40000 ALTER TABLE `VGB_COMMENTSPAM` DISABLE KEYS */;
/*!40000 ALTER TABLE `VGB_COMMENTSPAM` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `VGB_COUNTRY`
--
DROP TABLE IF EXISTS `VGB_COUNTRY`;
CREATE TABLE `VGB_COUNTRY` (
`ID` int(11) NOT NULL auto_increment,
`NAME` varchar(255) NOT NULL default '',
`FLAGICON` varchar(127) NOT NULL default '',
`TRANSLATE` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=198 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `VGB_COUNTRY`
--
LOCK TABLES `VGB_COUNTRY` WRITE;
/*!40000 ALTER TABLE `VGB_COUNTRY` DISABLE KEYS */;
INSERT INTO `VGB_COUNTRY` VALUES (1,'0','empty.gif',1),(2,'AL','al.gif',1),(3,'AD','ad.gif',1),(4,'AM','am.gif',1),(5,'AT','at.gif',1),(6,'BY','by.gif',1),(7,'BE','be.gif',1),(8,'BA','ba.gif',1),(9,'BG','bg.gif',1),(10,'CV','cv.gif',1),(11,'HR','hr.gif',1),(12,'CZ','cz.gif',1),(13,'DK','dk.gif',1),(14,'EE','ee.gif',1),(15,'FI','fi.gif',1),(16,'FR','fr.gif',1),(17,'GE','ge.gif',1),(18,'DE','de.gif',1),(19,'GR','gr.gif',1),(20,'HU','hu.gif',1),(21,'IS','is.gif',1),(22,'IE','ie.gif',1),(23,'IT','it.gif',1),(24,'LV','lv.gif',1),(25,'LI','li.gif',1),(26,'LT','lt.gif',1),(27,'LU','lu.gif',1),(28,'MK','mk.gif',1),(29,'MT','mt.gif',1),(30,'MD','md.gif',1),(31,'MC','mc.gif',1),(32,'NL','nl.gif',1),(33,'NO','no.gif',1),(34,'PL','pl.gif',1),(35,'PT','pt.gif',1),(36,'RO','ro.gif',1),(37,'SM','sm.gif',1),(38,'SK','sk.gif',1),(39,'SI','si.gif',1),(40,'ES','es.gif',1),(41,'SE','se.gif',1),(42,'CH','ch.gif',1),(43,'UA','ua.gif',1),(44,'ENG','eng.gif',1),(45,'SCO','sco.gif',1),(46,'NIR','nir.gif',1),(47,'WAL','wal.gif',1),(48,'VA','va.gif',1),(49,'YU','yu.gif',1),(50,'AG','ag.gif',1),(51,'BS','bs.gif',1),(52,'BB','bb.gif',1),(53,'BZ','bz.gif',1),(54,'CA','ca.gif',1),(55,'CR','cr.gif',1),(56,'CU','cu.gif',1),(57,'DM','dm.gif',1),(58,'DO','do.gif',1),(59,'SV','sv.gif',1),(60,'GD','gd.gif',1),(61,'GT','gt.gif',1),(62,'HT','hi.gif',1),(63,'HN','hn.gif',1),(64,'JM','jm.gif',1),(65,'MX','mx.gif',1),(66,'NI','ni.gif',1),(67,'PA','pa.gif',1),(68,'KN','kn.gif',1),(69,'LC','lc.gif',1),(70,'VC','vc.gif',1),(71,'TT','tt.gif',1),(72,'US','us.gif',1),(73,'AR','ar.gif',1),(74,'BO','bo.gif',1),(75,'BR','br.gif',1),(76,'CL','cl.gif',1),(77,'CO','co.gif',1),(78,'EC','ec.gif',1),(79,'GY','gy.gif',1),(80,'PY','py.gif',1),(81,'PE','pe.gif',1),(82,'SR','sr.gif',1),(83,'UY','uy.gif',1),(84,'VE','ve.gif',1),(85,'CY','cy.gif',1),(86,'RU','ru.gif',1),(87,'TR','tr.gif',1),(88,'AF','af.gif',1),(89,'AZ','az.gif',1),(90,'BH','bh.gif',1),(91,'BD','bd.gif',1),(92,'BT','bt.gif',1),(93,'BN','bn.gif',1),(94,'MM','mm.gif',1),(95,'KH','kh.gif',1),(96,'CN','cn.gif',1),(97,'TP','tp.gif',1),(98,'IN','in.gif',1),(99,'ID','id.gif',1),(100,'IR','ir.gif',1),(101,'IQ','iq.gif',1),(102,'IL','il.gif',1),(103,'JP','jp.gif',1),(104,'JO','jo.gif',1),(105,'KZ','kz.gif',1),(106,'KP','kp.gif',1),(107,'KR','kr.gif',1),(108,'KW','kw.gif',1),(109,'KG','kg.gif',1),(110,'LA','la.gif',1),(111,'LB','lb.gif',1),(112,'MY','my.gif',1),(113,'MV','mv.gif',1),(114,'MN','mn.gif',1),(115,'NP','np.gif',1),(116,'OM','om.gif',1),(117,'PK','pk.gif',1),(118,'PH','ph.gif',1),(119,'QR','qr.gif',1),(120,'SA','sa.gif',1),(121,'SG','sg.gif',1),(122,'LK','lk.gif',1),(123,'SY','sy.gif',1),(124,'TW','tw.gif',1),(125,'TJ','tj.gif',1),(126,'TH','th.gif',1),(127,'TM','tm.gif',1),(128,'AE','ae.gif',1),(129,'UZ','uz.gif',1),(130,'VN','vn.gif',1),(131,'YE','ye.gif',1),(132,'DZ','dz.gif',1),(133,'AO','ao.gif',1),(134,'BJ','bj.gif',1),(135,'BW','bw.gif',1),(136,'BF','bf.gif',1),(137,'BI','bi.gif',1),(138,'CM','cm.gif',1),(139,'CF','cf.gif',1),(140,'TD','td.gif',1),(141,'KM','km.gif',1),(142,'CG','cg.gif',1),(143,'CD','cd.gif',1),(144,'CI','ci.gif',1),(145,'DJ','dj.gif',1),(146,'EG','eg.gif',1),(147,'GQ','gq.gif',1),(148,'ER','er.gif',1),(149,'ET','et.gif',1),(150,'GA','ga.gif',1),(151,'GM','gm.gif',1),(152,'GH','gh.gif',1),(153,'GN','gn.gif',1),(154,'GW','gw.gif',1),(155,'KE','ke.gif',1),(156,'LS','ls.gif',1),(157,'LR','lr.gif',1),(158,'LY','ly.gif',1),(159,'MG','mg.gif',1),(160,'MW','mw.gif',1),(161,'ML','ml.gif',1),(162,'MR','mr.gif',1),(163,'MU','mu.gif',1),(164,'MA','ma.gif',1),(165,'MZ','mz.gif',1),(166,'NA','na.gif',1),(167,'NE','ne.gif',1),(168,'NG','ng.gif',1),(169,'RW','rw.gif',1),(170,'ST','st.gif',1),(171,'SN','sn.gif',1),(172,'SC','sc.gif',1),(173,'SL','sl.gif',1),(174,'SO','so.gif',1),(175,'ZA','za.gif',1),(176,'SD','sd.gif',1),(177,'SZ','sz.gif',1),(178,'TZ','tz.gif',1),(179,'TG','tg.gif',1),(180,'TN','tn.gif',1),(181,'UG','ug.gif',1),(182,'ZM','zm.gif',1),(183,'ZW','zw.gif',1),(184,'AU','au.gif',1),(185,'FJ','fj.gif',1),(186,'KI','ki.gif',1),(187,'MH','mh.gif',1),(188,'FM','fm.gif',1),(189,'NR','nr.gif',1),(190,'NZ','nz.gif',1),(191,'PW','pw.gif',1),(192,'PG','pg.gif',1),(193,'WS','ws.gif',1),(194,'SB','sb.gif',1),(195,'TO','to.gif',1),(196,'TV','tv.gif',1),(197,'VU','vu.gif',1);
/*!40000 ALTER TABLE `VGB_COUNTRY` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `VGB_COUNTRYORDER`
--
DROP TABLE IF EXISTS `VGB_COUNTRYORDER`;
CREATE TABLE `VGB_COUNTRYORDER` (
`LANG` varchar(127) NOT NULL default '',
`SORTEDIDS` text NOT NULL,
PRIMARY KEY (`LANG`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `VGB_COUNTRYORDER`
--
LOCK TABLES `VGB_COUNTRYORDER` WRITE;
/*!40000 ALTER TABLE `VGB_COUNTRYORDER` DISABLE KEYS */;
INSERT INTO `VGB_COUNTRYORDER` VALUES ('#','88 2 132 3 133 50 73 4 184 5 89 51 90 91 52 6 7 53 134 92 74 8 135 75 93 9 136 137 95 138 54 10 139 140 76 96 77 141 55 11 56 85 12 143 13 145 58 57 97 78 146 59 44 147 148 14 149 185 15 16 150 151 17 18 152 19 60 61 154 153 79 62 48 63 20 21 98 99 100 101 22 102 23 144 64 103 104 105 155 186 108 109 110 24 111 156 157 158 25 26 27 28 159 160 112 113 161 29 187 162 163 65 188 30 31 114 164 165 94 166 189 115 32 190 66 168 167 106 46 33 116 117 191 67 192 80 81 118 34 35 119 142 36 86 169 68 69 70 37 170 120 45 171 49 172 173 121 38 39 194 174 175 107 40 122 176 82 177 41 42 123 124 125 178 126 179 195 71 180 87 127 196 181 43 128 72 83 129 197 84 130 47 193 131 182 183 1');
/*!40000 ALTER TABLE `VGB_COUNTRYORDER` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `VGB_CUSTOMENTRY`
--
DROP TABLE IF EXISTS `VGB_CUSTOMENTRY`;
CREATE TABLE `VGB_CUSTOMENTRY` (
`ENTRY_ID` int(11) NOT NULL default '0',
`FIELD_ID` tinyint(3) unsigned NOT NULL default '0',
`CONTENT` varchar(255) default NULL,
PRIMARY KEY (`ENTRY_ID`,`FIELD_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `VGB_CUSTOMENTRY`
--
LOCK TABLES `VGB_CUSTOMENTRY` WRITE;
/*!40000 ALTER TABLE `VGB_CUSTOMENTRY` DISABLE KEYS */;
/*!40000 ALTER TABLE `VGB_CUSTOMENTRY` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `VGB_CUSTOMFIELD`
--
DROP TABLE IF EXISTS `VGB_CUSTOMFIELD`;
CREATE TABLE `VGB_CUSTOMFIELD` (
`ID` tinyint(3) unsigned NOT NULL auto_increment,
`NAME` varchar(255) NOT NULL default '',
`TYPE` tinyint(4) NOT NULL default '0',
`RULES` text NOT NULL,
`PRIORITY` tinyint(3) unsigned NOT NULL default '0',
`FRCE` tinyint(1) NOT NULL default '0',
`STATS` tinyint(1) NOT NULL default '0',
`LIMITSTATS` int(11) NOT NULL default '0',
`FORMTEXT` varchar(255) NOT NULL default '',
`FILTER` tinyint(1) NOT NULL default '0',
`PREALLOCATE` varchar(255) default NULL,
`USEWORDWRAP` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `VGB_CUSTOMFIELD`
--
LOCK TABLES `VGB_CUSTOMFIELD` WRITE;
/*!40000 ALTER TABLE `VGB_CUSTOMFIELD` DISABLE KEYS */;
/*!40000 ALTER TABLE `VGB_CUSTOMFIELD` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `VGB_CUSTOMUSER`
--
DROP TABLE IF EXISTS `VGB_CUSTOMUSER`;
CREATE TABLE `VGB_CUSTOMUSER` (
`USER_ID` int(11) NOT NULL default '0',
`FIELD_ID` tinyint(3) unsigned NOT NULL default '0',
`CONTENT` varchar(255) NOT NULL default '',
PRIMARY KEY (`USER_ID`,`FIELD_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `VGB_CUSTOMUSER`
--
LOCK TABLES `VGB_CUSTOMUSER` WRITE;
/*!40000 ALTER TABLE `VGB_CUSTOMUSER` DISABLE KEYS */;
/*!40000 ALTER TABLE `VGB_CUSTOMUSER` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `VGB_EMAIL`
--
DROP TABLE IF EXISTS `VGB_EMAIL`;
CREATE TABLE `VGB_EMAIL` (
`ID` int(11) NOT NULL auto_increment,
`ACTIVE` tinyint(1) NOT NULL default '0',
`SUBJECT` varchar(127) default NULL,
`MESSAGE` text,
`HTML` tinyint(1) NOT NULL default '0',
`UNCHECKED` tinyint(1) NOT NULL default '0',
`IP` varchar(16) NOT NULL default '',
`HOSTNAME` varchar(128) NOT NULL default '',
`TSTAMP` datetime NOT NULL default '0000-00-00 00:00:00',
`SENDTO` varchar(127) NOT NULL default '',
`REPLYTO` varchar(127) NOT NULL default '',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `VGB_EMAIL`
--
LOCK TABLES `VGB_EMAIL` WRITE;
/*!40000 ALTER TABLE `VGB_EMAIL` DISABLE KEYS */;
INSERT INTO `VGB_EMAIL` VALUES (1,0,NULL,NULL,0,0,'','','2007-02-24 17:41:39','',''),(2,0,NULL,NULL,0,0,'','','2007-02-24 17:41:39','',''),(3,0,NULL,NULL,0,0,'','','2007-02-24 17:41:39','',''),(4,0,NULL,NULL,0,0,'','','2007-02-24 17:41:39','',''),(5,0,NULL,NULL,0,0,'','','2007-02-24 17:41:39','',''),(6,0,NULL,NULL,0,0,'','','2007-02-24 17:41:39','',''),(7,0,NULL,NULL,0,0,'','','2007-02-24 17:41:39','',''),(8,0,NULL,NULL,0,0,'','','2007-02-24 17:41:39','',''),(9,0,NULL,NULL,0,0,'','','2007-02-24 17:41:39','',''),(10,0,NULL,NULL,0,0,'','','2007-02-24 17:41:39','',''),(11,0,NULL,NULL,0,0,'','','2007-02-24 17:41:39','',''),(12,0,NULL,NULL,0,0,'','','2007-02-24 17:41:39','',''),(20,0,NULL,NULL,0,0,'','','2007-02-24 17:41:39','','');
/*!40000 ALTER TABLE `VGB_EMAIL` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `VGB_EMOTICON`
--
DROP TABLE IF EXISTS `VGB_EMOTICON`;
CREATE TABLE `VGB_EMOTICON` (
`ID` int(11) NOT NULL auto_increment,
`CODE` varchar(32) NOT NULL default '',
`FILENAME` varchar(127) NOT NULL default '',
`PRIORITY` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `VGB_EMOTICON`
--
LOCK TABLES `VGB_EMOTICON` WRITE;
/*!40000 ALTER TABLE `VGB_EMOTICON` DISABLE KEYS */;
INSERT INTO `VGB_EMOTICON` VALUES (1,':-)','smile.gif',20),(2,':-D','laugh.gif',25),(3,';-)','wink.gif',30),(4,':-(','sad.gif',35),(5,':-/','angry.gif',40),(6,':-*','sick.gif',45),(7,'8-)','cool.gif',50),(8,':-0','ohmy.gif',55),(9,'8-0','love.gif',60),(10,':-|','unsure.gif',65),(11,':-!','important.gif',70),(12,':-?','question.gif',75),(13,'#-)','crazy.gif',80),(14,':-U','special1.gif',85),(15,':-B','special2.gif',90),(16,':-}','tongue.gif',95);
/*!40000 ALTER TABLE `VGB_EMOTICON` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `VGB_ENTRY`
--
DROP TABLE IF EXISTS `VGB_ENTRY`;
CREATE TABLE `VGB_ENTRY` (
`ID` int(11) NOT NULL auto_increment,
`DATE` date NOT NULL default '0000-00-00',
`NAME` varchar(120) default NULL,
`ENTRY` text NOT NULL,
`COMMENT` text,
`COUNTRY` int(11) default NULL,
`EMAIL` varchar(40) default NULL,
`HOMEPAGE` varchar(40) default NULL,
`ICQ` int(10) unsigned default NULL,
`AIM` varchar(40) default NULL,
`MSN` varchar(40) default NULL,
`YAHOO` varchar(40) default NULL,
`IP` varchar(16) NOT NULL default '',
`BROWSER` varchar(255) NOT NULL default '',
`HOSTNAME` varchar(128) NOT NULL default '',
`SIGNTIME` time default NULL,
`PICTURE` varchar(32) default NULL,
`PICTEXT` varchar(255) default NULL,
`PRIVATE` varchar(20) default NULL,
`HIDEEMAIL` tinyint(1) NOT NULL default '0',
`UNMODERATED` tinyint(1) NOT NULL default '0',
`SKYPE` varchar(40) default NULL,
`JABBER` varchar(40) default NULL,
`GADUGADU` int(10) unsigned default NULL,
`GENDER` tinyint(3) unsigned NOT NULL default '0',
`CLOSED` tinyint(1) NOT NULL default '0',
`STICKY` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `VGB_ENTRY`
--
LOCK TABLES `VGB_ENTRY` WRITE;
/*!40000 ALTER TABLE `VGB_ENTRY` DISABLE KEYS */;
INSERT INTO `VGB_ENTRY` VALUES (1,'2007-02-24','Jody','Testing the guestbook....\r\n\r\n:-)',NULL,175,NULL,'www.jodyforrester.com',NULL,NULL,NULL,NULL,'196.25.255.194','Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)','ctb-cache4-vif0.saix.net','17:50:06',NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0),(2,'2007-03-04','Nik','good luck guys!!! you crazy kids. x#-):-U:-B:-}:-?:-!:-|:-/:-*8-):-0:-(;-):-D:-)8-0',NULL,44,NULL,'www.aldworthjames.co.uk',NULL,NULL,NULL,NULL,'81.153.83.134','Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)','host81-153-83-134.range81-153.btcentralplus.com','16:35:54',NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0),(3,'2007-03-09','Cat','Man you guys are mad and surely at least a little bit crazy. Part of me is incredibly jealous though. Good luck with the prep, make sure you know those bikes inside out! xxx',NULL,190,'cmorgan@expressdata.co.nz',NULL,NULL,NULL,NULL,NULL,'125.237.11.194','Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727)','125-237-11-194.jetstream.xtra.co.nz','00:50:44',NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0),(4,'2007-03-13','frosty','howbo! Looking forward to catching up along route. better get some practice in da gym for picking up those bikes. hope you have a jol and beware the night fighters!!:-!',NULL,175,'careyf@telkomsa.net',NULL,NULL,NULL,NULL,NULL,'198.54.202.195','Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)','ctb-cache5-vif1.saix.net','08:59:23',NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0),(5,'2007-03-13','Aline Shuttleworth','All the best for the ride. Have a super time!',NULL,175,'a.shuttleworth@bowman.co.za',NULL,NULL,NULL,NULL,NULL,'69.67.41.67','Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; www.bowman.co.za; .NET CLR 1.1.4322; .NET CLR 2.0.50727)','bowman-jhb.ilan','12:49:04',NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0),(6,'2007-03-13','Dave','When are you two going to grow up....\r\n\r\nGood luck boys, be sure to post loads of stories as I will be living vicariously through you when im sitting at my desk in Wellington looking down the Terrace at another gloomy Wellington day.',NULL,190,'david.j.anderson@nz.pwc.com',NULL,NULL,NULL,NULL,NULL,'166.179.23.87','Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)','166-179-23-87.jamamobile.co.nz','20:59:33',NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0),(7,'2007-03-14','Mom','I realy dont know which of you guys is the more crazy!!! I am very proud of you both though and feel so much better because you have proved -Everest- that you support each other so much.You two muppets seem to have gaurdian angels on each shoulder.Dan,we do expect to see your bike in Shepperton soon - maybe a frostie will lure you!Good luck with all the prep.The old lady.8-0',NULL,44,'forresters@cinet.co.za',NULL,NULL,NULL,NULL,NULL,'82.71.3.206','Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR 3.0.04506)','82-71-3-206.dsl.in-addr.zen.co.uk','14:24:29',NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0),(8,'2007-03-20','Conor','Hey Dan,\r\n\r\nBest of luck...\r\nI\'ve seen you try and change the toner in a printer in an office, how will you fix a bike in the jungle?\r\n\r\nConor',NULL,44,'odonovancon@gmail.com',NULL,NULL,NULL,NULL,NULL,'57.66.51.74','Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; VNIE60; .NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.1)','gwlon.paconsulting.com','11:31:09',NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0),(9,'2007-04-16','Hayd','I couldn\'t see in the pic, was it a John Deer or Massy Fergison? \r\n\r\nPS don\'t wear loose clothing when looking at the PTO.',NULL,88,'htuck2@lambeth.gov.uk',NULL,NULL,NULL,NULL,NULL,'217.33.8.36','Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.1.4322)','departing.lambeth.gov.uk','17:54:16',NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0),(10,'2007-04-20','Nix','Hey guys\r\nI had my first taste of your trip this morning with the collection of Ernie - man I\'m excited for you 2!!! :-}\r\nVery happy about all the research you guys are doing and the mods to the bikes – you seem to be teaching the KTM peeps a bit about the usage of their own stock!!! Good one!!!\r\nGood luck with the rest of the prep!! xxx',NULL,175,'nicolaf@nedbank.co.za',NULL,NULL,NULL,NULL,NULL,'196.36.217.137','Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)','mm.nedcor.com','13:05:28',NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0),(11,'2007-04-29','Rooster','Dan,Jody.... Bloody Marvelous effort just thinking about doing this. It will live with you forever as the biggest accomplishment I\'m sure. I am certifiably jealous and horrifically scared for you both. Jody obviously you will be the level headed one that has to look after the over-excited one so stay focussed at all times! Just Remember not to put any moro wrappers in Dans pack!I have heard such mad stories from other such adventures and look forward to following yours. Did I mention Jealous? Anyway,, so proud of you boys...GO FORTH AND CONQUER!\r\nP.S dont pat the Hippos!',NULL,190,'rory.cuthbert@asbgroup.co.nz',NULL,NULL,NULL,NULL,NULL,'210.55.180.44','Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)','210-55-180-44.netgate.net.nz','20:00:23',NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0),(12,'2007-06-14','Rooster','Dan... I didn\'t understand a word of your upgrade story but you are going to have the flashest bike in all of Africa. That is some bad sh*t!',NULL,190,'rory.cuthbert@asbgroup.co.nz',NULL,NULL,NULL,NULL,NULL,'210.55.180.44','Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)','210-55-180-44.netgate.net.nz','20:58:02',NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0),(13,'2007-06-17','Juan Valdez',':-?\r\n\r\nMuppets',NULL,67,'lbellemore@gmail.com',NULL,NULL,NULL,NULL,NULL,'201.224.69.12','Mozilla/5.0 (Windows; U; Windows NT 5.1; es-AR; rv:1.8.1.3) Gecko/20070309 Firefox/2.0.0.3','201.224.69.12','17:17:21',NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0),(14,'2007-06-20','Chris','2 muppets. Perfect Name! :-D\r\n\r\nMaybe I could meet you someone along the skeleton coast with a case of stella and a bbq?\r\n\r\nFor three and a half years I\'ve been been living a blissful life in NZ, ignorant of the big wide world outside. \r\n\r\nNow my feet are itchier than your m...\r\n\r\nAnyway, good luck guys. Maybe I can meet you en route somewhere with much needed supplies?',NULL,190,'chris.lindley@rev-id.com','www.rev-id.com/',NULL,NULL,NULL,NULL,'125.239.30.169','Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.2; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; FDM)','125-239-30-169.jetstream.xtra.co.nz','09:40:25',NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0);
/*!40000 ALTER TABLE `VGB_ENTRY` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `VGB_LANGUAGE`
--
DROP TABLE IF EXISTS `VGB_LANGUAGE`;
CREATE TABLE `VGB_LANGUAGE` (
`ID` int(11) NOT NULL auto_increment,
`NAME` varchar(255) NOT NULL default '',
`LANGDIR` varchar(127) NOT NULL default '',
`SKINDIR` varchar(127) NOT NULL default '',
`PRIORITY` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `VGB_LANGUAGE`
--
LOCK TABLES `VGB_LANGUAGE` WRITE;
/*!40000 ALTER TABLE `VGB_LANGUAGE` DISABLE KEYS */;
/*!40000 ALTER TABLE `VGB_LANGUAGE` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `VGB_LOGIN`
--
DROP TABLE IF EXISTS `VGB_LOGIN`;
CREATE TABLE `VGB_LOGIN` (
`IP` varchar(16) NOT NULL default '',
`TSTAMP` datetime NOT NULL default '0000-00-00 00:00:00',
`ENTRYID` int(11) NOT NULL default '0',
`TRY` tinyint(4) default NULL,
`SESSIONID` varchar(20) default NULL,
PRIMARY KEY (`IP`,`TSTAMP`,`ENTRYID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `VGB_LOGIN`
--
LOCK TABLES `VGB_LOGIN` WRITE;
/*!40000 ALTER TABLE `VGB_LOGIN` DISABLE KEYS */;
/*!40000 ALTER TABLE `VGB_LOGIN` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `VGB_MAILSPAM`
--
DROP TABLE IF EXISTS `VGB_MAILSPAM`;
CREATE TABLE `VGB_MAILSPAM` (
`IP` varchar(16) NOT NULL default '',
`TSTAMP` datetime NOT NULL default '0000-00-00 00:00:00',
`EMAIL` varchar(127) NOT NULL default '',
PRIMARY KEY (`IP`,`TSTAMP`,`EMAIL`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `VGB_MAILSPAM`
--
LOCK TABLES `VGB_MAILSPAM` WRITE;
/*!40000 ALTER TABLE `VGB_MAILSPAM` DISABLE KEYS */;
/*!40000 ALTER TABLE `VGB_MAILSPAM` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `VGB_RATING`
--
DROP TABLE IF EXISTS `VGB_RATING`;
CREATE TABLE `VGB_RATING` (
`ENTRY_ID` int(11) NOT NULL default '0',
`BOX_ID` tinyint(3) unsigned NOT NULL default '0',
`RATING` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`ENTRY_ID`,`BOX_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `VGB_RATING`
--
LOCK TABLES `VGB_RATING` WRITE;
/*!40000 ALTER TABLE `VGB_RATING` DISABLE KEYS */;
/*!40000 ALTER TABLE `VGB_RATING` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `VGB_RATINGBOX`
--
DROP TABLE IF EXISTS `VGB_RATINGBOX`;
CREATE TABLE `VGB_RATINGBOX` (
`ID` tinyint(3) unsigned NOT NULL auto_increment,
`NAME` varchar(255) NOT NULL default '',
`PRIORITY` tinyint(3) unsigned NOT NULL default '0',
`FRCE` tinyint(1) NOT NULL default '0',
`STATS` tinyint(1) NOT NULL default '0',
`FORMTEXT` varchar(255) NOT NULL default '',
`MAXVALUE` int(11) NOT NULL default '5',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `VGB_RATINGBOX`
--
LOCK TABLES `VGB_RATINGBOX` WRITE;
/*!40000 ALTER TABLE `VGB_RATINGBOX` DISABLE KEYS */;
/*!40000 ALTER TABLE `VGB_RATINGBOX` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `VGB_SESSION`
--
DROP TABLE IF EXISTS `VGB_SESSION`;
CREATE TABLE `VGB_SESSION` (
`IP` varchar(16) NOT NULL default '',
`TSTAMP` datetime NOT NULL default '0000-00-00 00:00:00',
`SESSIONID` varchar(20) NOT NULL default '',
`TRY` tinyint(4) default NULL,
`ADMIN` int(11) default NULL,
`VERSIONS` varchar(127) NOT NULL default '',
PRIMARY KEY (`IP`,`TSTAMP`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `VGB_SESSION`
--
LOCK TABLES `VGB_SESSION` WRITE;
/*!40000 ALTER TABLE `VGB_SESSION` DISABLE KEYS */;
INSERT INTO `VGB_SESSION` VALUES ('139.92.100','2007-03-14 16:51:55','9507cf8c2753e84a308a',1,NULL,'');
/*!40000 ALTER TABLE `VGB_SESSION` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `VGB_SETTINGS`
--
DROP TABLE IF EXISTS `VGB_SETTINGS`;
CREATE TABLE `VGB_SETTINGS` (
`VERSION` varchar(127) NOT NULL default '',
`ONLINEDATE` date NOT NULL default '0000-00-00',
`ADMINPASSWORD` varchar(127) NOT NULL default '',
`ADMINEMAIL` varchar(127) default NULL,
`ACTIVESKIN` varchar(255) NOT NULL default '',
`SENDNOTICE` tinyint(1) NOT NULL default '0',
`USEFRAMES` tinyint(1) NOT NULL default '0',
`USEUSDATE` tinyint(1) NOT NULL default '0',
`USEEMOTICONS` tinyint(1) NOT NULL default '0',
`PASTENTRIES` int(11) NOT NULL default '0',
`MAXSPAMTIME` int(11) NOT NULL default '0',
`MAXENTRIES` int(11) NOT NULL default '0',
`MAXENTRIESPERPAGE` int(11) NOT NULL default '0',
`MAXLENENTRY` int(11) NOT NULL default '0',
`MAXLENNAME` tinyint(3) unsigned NOT NULL default '0',
`MAXLENEMAIL` tinyint(3) unsigned NOT NULL default '0',
`MAXLENHOMEPAGE` tinyint(3) unsigned NOT NULL default '0',
`MAXLENAIM` tinyint(3) unsigned NOT NULL default '0',
`MAXLENMSN` tinyint(3) unsigned NOT NULL default '0',
`MAXLENYAHOO` tinyint(3) unsigned NOT NULL default '0',
`FORCEBREAK` tinyint(3) unsigned NOT NULL default '0',
`ACTIVATELINKS` tinyint(1) NOT NULL default '0',
`ASKEMAIL` tinyint(1) NOT NULL default '0',
`ASKHOMEPAGE` tinyint(1) NOT NULL default '0',
`ASKICQ` tinyint(1) NOT NULL default '0',
`ASKAIM` tinyint(1) NOT NULL default '0',
`ASKMSN` tinyint(1) NOT NULL default '0',
`ASKYAHOO` tinyint(1) NOT NULL default '0',
`ASKCOUNTRY` tinyint(1) NOT NULL default '0',
`FORCECOUNTRY` tinyint(1) NOT NULL default '0',
`HIDEIP` tinyint(3) unsigned NOT NULL default '0',
`HIDEHOST` tinyint(3) unsigned NOT NULL default '0',
`HIDESTATS` tinyint(1) NOT NULL default '0',
`LIMITBROWSER` int(11) NOT NULL default '0',
`LIMITOS` int(11) NOT NULL default '0',
`LIMITCOUNTRY` int(11) NOT NULL default '0',
`USEFILTER` int(11) NOT NULL default '0',
`BADWORDSTRING` varchar(255) NOT NULL default '',
`ASKPICTURE` tinyint(1) NOT NULL default '0',
`MINX` int(11) NOT NULL default '0',
`MAXX` int(11) NOT NULL default '0',
`MINY` int(11) NOT NULL default '0',
`MAXY` int(11) NOT NULL default '0',
`VISITORS` int(11) NOT NULL default '0',
`VISITORSSINCE` date NOT NULL default '0000-00-00',
`INDEXURL` varchar(127) default NULL,
`FORCEEMAIL` tinyint(1) NOT NULL default '0',
`USEBBCODE` tinyint(1) NOT NULL default '0',
`STRIPCODE` tinyint(1) NOT NULL default '0',
`SIZEMIN` tinyint(3) unsigned NOT NULL default '0',
`SIZEMAX` tinyint(3) unsigned NOT NULL default '0',
`USERCOLORS` text NOT NULL,
`USERFONTS` text NOT NULL,
`ASKPICTEXT` tinyint(1) NOT NULL default '0',
`FILTERNAME` tinyint(1) NOT NULL default '0',
`FILTEREMAIL` tinyint(1) NOT NULL default '0',
`FILTERHOMEPAGE` tinyint(1) NOT NULL default '0',
`FILTERAIM` tinyint(1) NOT NULL default '0',
`FILTERMSN` tinyint(1) NOT NULL default '0',
`FILTERYAHOO` tinyint(1) NOT NULL default '0',
`FILTERPICTEXT` tinyint(1) NOT NULL default '0',
`ASKPRIVATE` tinyint(1) NOT NULL default '0',
`PRIVPARAMETER` varchar(30) default NULL,
`ASKHIDEEMAIL` tinyint(1) NOT NULL default '0',
`USEMAILER` tinyint(3) unsigned NOT NULL default '0',
`USEADMINEMO` tinyint(1) NOT NULL default '0',
`USEIFRAME` tinyint(1) NOT NULL default '0',
`PRECOUNTRY` int(11) default NULL,
`ALLOWCOMMENTS` tinyint(1) NOT NULL default '0',
`ADDHOURS` int(11) NOT NULL default '0',
`ADDMINUTES` int(11) NOT NULL default '0',
`ADDSECONDS` int(11) NOT NULL default '0',
`COMMENTNAME` varchar(120) NOT NULL default '',
`COMMENTEMAIL` varchar(40) NOT NULL default '',
`MODERATEDMODE` tinyint(1) NOT NULL default '0',
`DEACTIVATED` tinyint(1) NOT NULL default '0',
`BACKURL` varchar(127) default NULL,
`ALLOWSEARCH` tinyint(1) NOT NULL default '0',
`USEQUOTE` tinyint(1) NOT NULL default '0',
`BANLIST` text NOT NULL,
`BANROBOTS` tinyint(1) NOT NULL default '0',
`MAXEMPTYLINES` int(11) NOT NULL default '0',
`EMAILTOOLTIP` varchar(255) NOT NULL default '',
`EMAILFROM` varchar(127) NOT NULL default '',
`FIRSTENTRY` tinyint(1) NOT NULL default '0',
`FIRSTCOMMENT` tinyint(1) NOT NULL default '0',
`ENTRYSENT` tinyint(1) NOT NULL default '0',
`COMMENTSENT` tinyint(1) NOT NULL default '0',
`PASSPREFIX` varchar(20) NOT NULL default '',
`THUMBNAILX` int(11) NOT NULL default '0',
`THUMBNAILY` int(11) NOT NULL default '0',
`ENCODING` varchar(30) NOT NULL default '',
`HOSTRESOLVING` tinyint(1) NOT NULL default '0',
`AMPMTIME` tinyint(1) NOT NULL default '0',
`REDIRECTSHOW` tinyint(1) NOT NULL default '0',
`EMAILMETHOD` tinyint(1) NOT NULL default '0',
`RETURNPATH` varchar(127) NOT NULL default '',
`MAILCHARSET` varchar(30) NOT NULL default '',
`CMDLINEPARAM` varchar(60) NOT NULL default '',
`CRLFHEADER` tinyint(1) NOT NULL default '0',
`SMTPHOST` varchar(127) NOT NULL default '',
`SMTPPORT` int(10) unsigned NOT NULL default '0',
`SMTPUSERNAME` varchar(60) NOT NULL default '',
`SMTPPASSWORD` varchar(60) NOT NULL default '',
`INSERTSKINNAME` tinyint(1) NOT NULL default '0',
`ASKSKYPE` tinyint(1) NOT NULL default '0',
`ASKJABBER` tinyint(1) NOT NULL default '0',
`ASKGADUGADU` tinyint(1) NOT NULL default '0',
`MAXLENSKYPE` tinyint(3) unsigned NOT NULL default '0',
`MAXLENJABBER` tinyint(3) unsigned NOT NULL default '0',
`FILTERSKYPE` tinyint(1) NOT NULL default '0',
`FILTERJABBER` tinyint(1) NOT NULL default '0',
`ASKGENDER` tinyint(1) NOT NULL default '0',
`FORCEGENDER` tinyint(1) NOT NULL default '0',
`MAXFILESIZE` int(10) unsigned NOT NULL default '0',
`DEFAULTNAME` varchar(255) NOT NULL default '',
`ADMINLINK` tinyint(1) NOT NULL default '0',
`USECOOKIES` tinyint(1) NOT NULL default '0',
`USETICKETS` tinyint(1) NOT NULL default '0',
`BBCODEMASK` int(10) unsigned NOT NULL default '0',
`QUOTESTYLE` varchar(127) NOT NULL default '',
`CODESTYLE` varchar(127) NOT NULL default '',
`USETOOLBAR` tinyint(4) NOT NULL default '0',
`SAVEACTIONS` int(11) NOT NULL default '0',
`MAILLIMIT` int(11) NOT NULL default '0',
`CHECKMAILS` tinyint(1) NOT NULL default '0',
`VERSIONCHECK` tinyint(1) NOT NULL default '0',
`FIRSTEMAIL` tinyint(1) NOT NULL default '0',
`EMAILSENT` tinyint(1) NOT NULL default '0',
`USECACHE` tinyint(1) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `VGB_SETTINGS`
--
LOCK TABLES `VGB_SETTINGS` WRITE;
/*!40000 ALTER TABLE `VGB_SETTINGS` DISABLE KEYS */;
INSERT INTO `VGB_SETTINGS` VALUES ('X1.1','2007-02-24','IjBsW2SXgU.DQ','jodyforrester@gmail.com','Standard_Skin',0,0,0,1,0,5,0,20,10000,40,40,40,40,40,40,28,1,1,1,0,0,0,0,1,1,0,0,0,0,0,0,0,'-BADWORD-',0,10,200,10,200,179,'2007-02-24','www.2muppets.com/guestbook/index.php',0,0,0,1,3,'black=#000000\ngray=#808080\nred=#FF0000\nlime=#00FF00\nyellow=#FFFF00\nblue=#0000FF\nfuchsia=#FF00FF\naqua=#00FFFF\nwhite=#FFFFFF\nmaroon=#800000\ngreen=#008000\nolive=#808000\nnavy=#000080\npurple=#800080\nteal=#008080\nsilver=#C0C0C0','',0,0,0,0,0,0,0,0,0,NULL,0,1,0,0,NULL,0,11,22,0,'','',0,0,'www.2muppets.com',1,0,'',0,0,'::user::(a+)::domain::.::tld::','',0,0,1,0,'pass=',100,0,'utf-8',1,0,1,0,'jodyforrester@gmail.com','iso-8859-1','-fjodyforrester@gmail.com',0,'localhost',25,'','',1,0,0,0,40,40,0,0,0,0,0,'Default',0,0,0,0,'border: 1px dotted #808080; padding: 3px','border: 1px inset ; margin: 0px; padding: 3px; height: 100px; overflow: auto',0,10,0,0,0,0,0,1);
/*!40000 ALTER TABLE `VGB_SETTINGS` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `VGB_SPAM`
--
DROP TABLE IF EXISTS `VGB_SPAM`;
CREATE TABLE `VGB_SPAM` (
`IP` varchar(16) NOT NULL default '',
`TSTAMP` datetime NOT NULL default '0000-00-00 00:00:00',
`TRIES` tinyint(4) default NULL,
PRIMARY KEY (`IP`,`TSTAMP`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `VGB_SPAM`
--
LOCK TABLES `VGB_SPAM` WRITE;
/*!40000 ALTER TABLE `VGB_SPAM` DISABLE KEYS */;
INSERT INTO `VGB_SPAM` VALUES ('125.239.30.169','2007-06-20 09:40:27',NULL);
/*!40000 ALTER TABLE `VGB_SPAM` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `VGB_TICKET`
--
DROP TABLE IF EXISTS `VGB_TICKET`;
CREATE TABLE `VGB_TICKET` (
`ID` int(11) NOT NULL auto_increment,
`IP` varchar(16) NOT NULL default '',
`TSTAMP` datetime NOT NULL default '0000-00-00 00:00:00',
`TICKET` varchar(5) NOT NULL default '',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `VGB_TICKET`
--
LOCK TABLES `VGB_TICKET` WRITE;
/*!40000 ALTER TABLE `VGB_TICKET` DISABLE KEYS */;
/*!40000 ALTER TABLE `VGB_TICKET` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `VGB_USER`
--
DROP TABLE IF EXISTS `VGB_USER`;
CREATE TABLE `VGB_USER` (
`ID` int(11) NOT NULL auto_increment,
`NAME` varchar(120) NOT NULL default '',
`RESERVED` tinyint(1) NOT NULL default '0',
`PASSWORD` varchar(30) NOT NULL default '',
`SIGNATURE` text NOT NULL,
`EMAIL` varchar(40) NOT NULL default '',
`HIDEEMAIL` tinyint(1) NOT NULL default '0',
`HOMEPAGE` varchar(40) NOT NULL default '',
`ICQ` int(10) unsigned NOT NULL default '0',
`AIM` varchar(40) NOT NULL default '',
`MSN` varchar(40) NOT NULL default '',
`YAHOO` varchar(40) NOT NULL default '',
`COUNTRY` int(11) NOT NULL default '0',
`PICTEXT` varchar(255) NOT NULL default '',
`PICTURE` varchar(32) NOT NULL default '',
`SKYPE` varchar(40) NOT NULL default '',
`JABBER` varchar(40) NOT NULL default '',
`GADUGADU` int(10) unsigned NOT NULL default '0',
`GENDER` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `VGB_USER`
--
LOCK TABLES `VGB_USER` WRITE;
/*!40000 ALTER TABLE `VGB_USER` DISABLE KEYS */;
/*!40000 ALTER TABLE `VGB_USER` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `VGB_VISITOR`
--
DROP TABLE IF EXISTS `VGB_VISITOR`;
CREATE TABLE `VGB_VISITOR` (
`ID` int(11) NOT NULL auto_increment,
`IP` varchar(16) NOT NULL default '',
`TSTAMP` datetime NOT NULL default '0000-00-00 00:00:00',
`HOSTNAME` varchar(128) NOT NULL default '',
`BROWSER` varchar(255) NOT NULL default '',
`ACTIVE` tinyint(1) NOT NULL default '0',
`ACTIONS` int(11) NOT NULL default '0',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=235 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `VGB_VISITOR`
--
LOCK TABLES `VGB_VISITOR` WRITE;
/*!40000 ALTER TABLE `VGB_VISITOR` DISABLE KEYS */;
INSERT INTO `VGB_VISITOR` VALUES (234,'198.54.202.195','2007-07-03 19:31:24','ctb-cache5-vif1.saix.net','Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.0.3705; .NET CLR 1.1.4322)',1,1),(223,'65.55.212.217','2007-06-30 03:24:44','livebot-65-55-212-217.search.live.com','msnbot-media/1.0 (+http://search.msn.com/msnbot.htm)',0,1),(227,'74.6.17.167','2007-06-30 22:17:30','rz502593.inktomisearch.com','Mozilla/5.0 (compatible; Yahoo! Slurp; http://help.yahoo.com/help/us/ysearch/slurp)',0,1),(229,'198.54.202.195','2007-07-01 16:41:52','ctb-cache5-vif1.saix.net','Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.0.3705; .NET CLR 1.1.4322)',0,1),(231,'87.194.36.118','2007-07-02 09:43:40','87-194-36-118.bethere.co.uk','Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; InfoPath.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727)',0,1),(226,'196.25.255.195','2007-06-30 18:03:37','ctb-cache5-vif0.saix.net','Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)',0,1),(230,'196.25.255.195','2007-07-01 20:19:22','ctb-cache5-vif0.saix.net','Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.0.3705; .NET CLR 1.1.4322)',0,1),(224,'65.55.212.217','2007-06-30 04:42:12','livebot-65-55-212-217.search.live.com','msnbot-media/1.0 (+http://search.msn.com/msnbot.htm)',0,1),(232,'196.25.255.195','2007-07-02 20:23:07','ctb-cache5-vif0.saix.net','Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)',0,1),(233,'196.36.217.137','2007-07-03 09:52:59','mm.nedcor.com','Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)',0,1),(225,'65.55.212.217','2007-06-30 07:03:00','livebot-65-55-212-217.search.live.com','msnbot-media/1.0 (+http://search.msn.com/msnbot.htm)',0,1),(228,'74.6.23.105','2007-07-01 08:44:57','lj511845.crawl.yahoo.net','Mozilla/5.0 (compatible; Yahoo! Slurp; http://help.yahoo.com/help/us/ysearch/slurp)',0,1);
/*!40000 ALTER TABLE `VGB_VISITOR` ENABLE KEYS */;
UNLOCK TABLES;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;