-- phpMyAdmin SQL Dump -- version 2.10.0.2 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Sep 17, 2007 at 12:43 PM -- Server version: 4.1.22 -- PHP Version: 4.4.4 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- Database: `animalli_talkback` -- -- -------------------------------------------------------- -- -- Table structure for table `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` -- INSERT INTO `VGB_ACTION` VALUES (215, '2007-04-15 22:00:31', 1, '1'); INSERT INTO `VGB_ACTION` VALUES (222, '2007-07-25 12:59:36', 1, '1'); INSERT INTO `VGB_ACTION` VALUES (218, '2007-06-04 13:04:35', 1, '1'); INSERT INTO `VGB_ACTION` VALUES (221, '2007-07-16 18:55:16', 1, '1'); INSERT INTO `VGB_ACTION` VALUES (217, '2007-05-04 06:24:38', 1, '1'); INSERT INTO `VGB_ACTION` VALUES (216, '2007-04-23 20:45:40', 1, '1'); INSERT INTO `VGB_ACTION` VALUES (219, '2007-06-28 04:39:59', 1, '1'); INSERT INTO `VGB_ACTION` VALUES (212, '2007-04-03 02:17:15', 1, '1'); INSERT INTO `VGB_ACTION` VALUES (212, '2007-04-03 02:17:08', 1, '1'); INSERT INTO `VGB_ACTION` VALUES (213, '2007-04-03 14:47:44', 1, '1'); INSERT INTO `VGB_ACTION` VALUES (214, '2007-04-12 15:11:05', 1, '1'); INSERT INTO `VGB_ACTION` VALUES (220, '2007-07-06 15:09:19', 1, '1'); INSERT INTO `VGB_ACTION` VALUES (223, '2007-09-15 20:30:33', 1, '1'); INSERT INTO `VGB_ACTION` VALUES (213, '2007-04-03 14:44:47', 1, '1'); -- -------------------------------------------------------- -- -- Table structure for table `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 AUTO_INCREMENT=1 ; -- -- Dumping data for table `VGB_ADMIN` -- -- -------------------------------------------------------- -- -- Table structure for table `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` -- INSERT INTO `VGB_CACHE` VALUES (1, '2007-02-03', 'ann', 'Testing the guestbook', NULL, 44, 'annxtberlin@gmail.com', 'www.animalliberationfront.com', NULL, NULL, NULL, NULL, '208.200.80.214', 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727)', '208.200.80.214', '06:21:01', NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''); -- -------------------------------------------------------- -- -- Table structure for table `VGB_COMMENT` -- CREATE TABLE `VGB_COMMENT` ( `ID` int(11) NOT NULL auto_increment, `ENTRYID` int(11) NOT NULL default '0', `NAME` varchar(40) 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 AUTO_INCREMENT=1 ; -- -- Dumping data for table `VGB_COMMENT` -- -- -------------------------------------------------------- -- -- Table structure for table `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` -- -- -------------------------------------------------------- -- -- Table structure for table `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 DEFAULT CHARSET=latin1 AUTO_INCREMENT=198 ; -- -- Dumping data for table `VGB_COUNTRY` -- INSERT INTO `VGB_COUNTRY` VALUES (1, '0', 'empty.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (2, 'AL', 'al.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (3, 'AD', 'ad.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (4, 'AM', 'am.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (5, 'AT', 'at.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (6, 'BY', 'by.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (7, 'BE', 'be.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (8, 'BA', 'ba.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (9, 'BG', 'bg.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (10, 'CV', 'cv.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (11, 'HR', 'hr.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (12, 'CZ', 'cz.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (13, 'DK', 'dk.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (14, 'EE', 'ee.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (15, 'FI', 'fi.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (16, 'FR', 'fr.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (17, 'GE', 'ge.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (18, 'DE', 'de.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (19, 'GR', 'gr.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (20, 'HU', 'hu.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (21, 'IS', 'is.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (22, 'IE', 'ie.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (23, 'IT', 'it.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (24, 'LV', 'lv.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (25, 'LI', 'li.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (26, 'LT', 'lt.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (27, 'LU', 'lu.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (28, 'MK', 'mk.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (29, 'MT', 'mt.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (30, 'MD', 'md.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (31, 'MC', 'mc.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (32, 'NL', 'nl.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (33, 'NO', 'no.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (34, 'PL', 'pl.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (35, 'PT', 'pt.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (36, 'RO', 'ro.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (37, 'SM', 'sm.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (38, 'SK', 'sk.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (39, 'SI', 'si.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (40, 'ES', 'es.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (41, 'SE', 'se.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (42, 'CH', 'ch.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (43, 'UA', 'ua.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (44, 'ENG', 'eng.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (45, 'SCO', 'sco.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (46, 'NIR', 'nir.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (47, 'WAL', 'wal.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (48, 'VA', 'va.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (49, 'YU', 'yu.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (50, 'AG', 'ag.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (51, 'BS', 'bs.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (52, 'BB', 'bb.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (53, 'BZ', 'bz.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (54, 'CA', 'ca.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (55, 'CR', 'cr.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (56, 'CU', 'cu.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (57, 'DM', 'dm.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (58, 'DO', 'do.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (59, 'SV', 'sv.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (60, 'GD', 'gd.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (61, 'GT', 'gt.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (62, 'HT', 'hi.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (63, 'HN', 'hn.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (64, 'JM', 'jm.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (65, 'MX', 'mx.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (66, 'NI', 'ni.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (67, 'PA', 'pa.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (68, 'KN', 'kn.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (69, 'LC', 'lc.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (70, 'VC', 'vc.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (71, 'TT', 'tt.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (72, 'US', 'us.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (73, 'AR', 'ar.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (74, 'BO', 'bo.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (75, 'BR', 'br.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (76, 'CL', 'cl.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (77, 'CO', 'co.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (78, 'EC', 'ec.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (79, 'GY', 'gy.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (80, 'PY', 'py.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (81, 'PE', 'pe.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (82, 'SR', 'sr.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (83, 'UY', 'uy.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (84, 'VE', 've.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (85, 'CY', 'cy.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (86, 'RU', 'ru.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (87, 'TR', 'tr.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (88, 'AF', 'af.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (89, 'AZ', 'az.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (90, 'BH', 'bh.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (91, 'BD', 'bd.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (92, 'BT', 'bt.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (93, 'BN', 'bn.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (94, 'MM', 'mm.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (95, 'KH', 'kh.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (96, 'CN', 'cn.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (97, 'TP', 'tp.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (98, 'IN', 'in.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (99, 'ID', 'id.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (100, 'IR', 'ir.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (101, 'IQ', 'iq.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (102, 'IL', 'il.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (103, 'JP', 'jp.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (104, 'JO', 'jo.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (105, 'KZ', 'kz.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (106, 'KP', 'kp.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (107, 'KR', 'kr.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (108, 'KW', 'kw.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (109, 'KG', 'kg.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (110, 'LA', 'la.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (111, 'LB', 'lb.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (112, 'MY', 'my.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (113, 'MV', 'mv.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (114, 'MN', 'mn.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (115, 'NP', 'np.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (116, 'OM', 'om.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (117, 'PK', 'pk.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (118, 'PH', 'ph.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (119, 'QR', 'qr.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (120, 'SA', 'sa.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (121, 'SG', 'sg.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (122, 'LK', 'lk.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (123, 'SY', 'sy.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (124, 'TW', 'tw.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (125, 'TJ', 'tj.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (126, 'TH', 'th.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (127, 'TM', 'tm.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (128, 'AE', 'ae.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (129, 'UZ', 'uz.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (130, 'VN', 'vn.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (131, 'YE', 'ye.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (132, 'DZ', 'dz.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (133, 'AO', 'ao.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (134, 'BJ', 'bj.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (135, 'BW', 'bw.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (136, 'BF', 'bf.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (137, 'BI', 'bi.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (138, 'CM', 'cm.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (139, 'CF', 'cf.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (140, 'TD', 'td.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (141, 'KM', 'km.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (142, 'CG', 'cg.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (143, 'CD', 'cd.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (144, 'CI', 'ci.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (145, 'DJ', 'dj.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (146, 'EG', 'eg.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (147, 'GQ', 'gq.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (148, 'ER', 'er.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (149, 'ET', 'et.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (150, 'GA', 'ga.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (151, 'GM', 'gm.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (152, 'GH', 'gh.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (153, 'GN', 'gn.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (154, 'GW', 'gw.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (155, 'KE', 'ke.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (156, 'LS', 'ls.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (157, 'LR', 'lr.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (158, 'LY', 'ly.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (159, 'MG', 'mg.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (160, 'MW', 'mw.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (161, 'ML', 'ml.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (162, 'MR', 'mr.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (163, 'MU', 'mu.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (164, 'MA', 'ma.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (165, 'MZ', 'mz.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (166, 'NA', 'na.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (167, 'NE', 'ne.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (168, 'NG', 'ng.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (169, 'RW', 'rw.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (170, 'ST', 'st.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (171, 'SN', 'sn.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (172, 'SC', 'sc.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (173, 'SL', 'sl.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (174, 'SO', 'so.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (175, 'ZA', 'za.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (176, 'SD', 'sd.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (177, 'SZ', 'sz.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (178, 'TZ', 'tz.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (179, 'TG', 'tg.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (180, 'TN', 'tn.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (181, 'UG', 'ug.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (182, 'ZM', 'zm.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (183, 'ZW', 'zw.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (184, 'AU', 'au.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (185, 'FJ', 'fj.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (186, 'KI', 'ki.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (187, 'MH', 'mh.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (188, 'FM', 'fm.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (189, 'NR', 'nr.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (190, 'NZ', 'nz.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (191, 'PW', 'pw.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (192, 'PG', 'pg.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (193, 'WS', 'ws.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (194, 'SB', 'sb.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (195, 'TO', 'to.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (196, 'TV', 'tv.gif', 1); INSERT INTO `VGB_COUNTRY` VALUES (197, 'VU', 'vu.gif', 1); -- -------------------------------------------------------- -- -- Table structure for table `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` -- 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'); -- -------------------------------------------------------- -- -- Table structure for table `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` -- -- -------------------------------------------------------- -- -- Table structure for table `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 AUTO_INCREMENT=1 ; -- -- Dumping data for table `VGB_CUSTOMFIELD` -- -- -------------------------------------------------------- -- -- Table structure for table `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` -- -- -------------------------------------------------------- -- -- Table structure for table `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 DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ; -- -- Dumping data for table `VGB_EMAIL` -- INSERT INTO `VGB_EMAIL` VALUES (1, 0, NULL, NULL, 0, 0, '', '', '2007-02-03 05:43:45', '', ''); INSERT INTO `VGB_EMAIL` VALUES (2, 0, NULL, NULL, 0, 0, '', '', '2007-02-03 05:43:45', '', ''); INSERT INTO `VGB_EMAIL` VALUES (3, 0, NULL, NULL, 0, 0, '', '', '2007-02-03 05:43:45', '', ''); INSERT INTO `VGB_EMAIL` VALUES (4, 0, NULL, NULL, 0, 0, '', '', '2007-02-03 05:43:45', '', ''); INSERT INTO `VGB_EMAIL` VALUES (5, 0, NULL, NULL, 0, 0, '', '', '2007-02-03 05:43:45', '', ''); INSERT INTO `VGB_EMAIL` VALUES (6, 0, NULL, NULL, 0, 0, '', '', '2007-02-03 05:43:45', '', ''); INSERT INTO `VGB_EMAIL` VALUES (7, 0, NULL, NULL, 0, 0, '', '', '2007-02-03 05:43:45', '', ''); INSERT INTO `VGB_EMAIL` VALUES (8, 0, NULL, NULL, 0, 0, '', '', '2007-02-03 05:43:45', '', ''); INSERT INTO `VGB_EMAIL` VALUES (9, 0, NULL, NULL, 0, 0, '', '', '2007-02-03 05:43:45', '', ''); INSERT INTO `VGB_EMAIL` VALUES (10, 0, NULL, NULL, 0, 0, '', '', '2007-02-03 05:43:45', '', ''); INSERT INTO `VGB_EMAIL` VALUES (11, 0, NULL, NULL, 0, 0, '', '', '2007-02-03 05:43:45', '', ''); INSERT INTO `VGB_EMAIL` VALUES (12, 0, NULL, NULL, 0, 0, '', '', '2007-02-03 05:43:45', '', ''); INSERT INTO `VGB_EMAIL` VALUES (20, 0, NULL, NULL, 0, 0, '', '', '2007-02-03 05:43:45', '', ''); -- -------------------------------------------------------- -- -- Table structure for table `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 DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ; -- -- Dumping data for table `VGB_EMOTICON` -- INSERT INTO `VGB_EMOTICON` VALUES (1, ':-)', 'smile.gif', 20); INSERT INTO `VGB_EMOTICON` VALUES (2, ':-D', 'laugh.gif', 25); INSERT INTO `VGB_EMOTICON` VALUES (3, ';-)', 'wink.gif', 30); INSERT INTO `VGB_EMOTICON` VALUES (4, ':-(', 'sad.gif', 35); INSERT INTO `VGB_EMOTICON` VALUES (5, ':-/', 'angry.gif', 40); INSERT INTO `VGB_EMOTICON` VALUES (6, ':-*', 'sick.gif', 45); INSERT INTO `VGB_EMOTICON` VALUES (7, '8-)', 'cool.gif', 50); INSERT INTO `VGB_EMOTICON` VALUES (8, ':-0', 'ohmy.gif', 55); INSERT INTO `VGB_EMOTICON` VALUES (9, '8-0', 'love.gif', 60); INSERT INTO `VGB_EMOTICON` VALUES (10, ':-|', 'unsure.gif', 65); INSERT INTO `VGB_EMOTICON` VALUES (11, ':-!', 'important.gif', 70); INSERT INTO `VGB_EMOTICON` VALUES (12, ':-?', 'question.gif', 75); INSERT INTO `VGB_EMOTICON` VALUES (13, '#-)', 'crazy.gif', 80); INSERT INTO `VGB_EMOTICON` VALUES (14, ':-U', 'special1.gif', 85); INSERT INTO `VGB_EMOTICON` VALUES (15, ':-B', 'special2.gif', 90); INSERT INTO `VGB_EMOTICON` VALUES (16, ':-}', 'tongue.gif', 95); -- -------------------------------------------------------- -- -- Table structure for table `VGB_ENTRY` -- CREATE TABLE `VGB_ENTRY` ( `ID` int(11) NOT NULL auto_increment, `DATE` date NOT NULL default '0000-00-00', `NAME` varchar(40) 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(127) 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 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -- Dumping data for table `VGB_ENTRY` -- INSERT INTO `VGB_ENTRY` VALUES (1, '2007-02-03', 'ann', 'Testing the guestbook', NULL, 44, 'annxtberlin@gmail.com', 'www.animalliberationfront.com', NULL, NULL, NULL, NULL, '208.200.80.214', 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727)', '208.200.80.214', '06:21:01', NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, 0, 0, 0); -- -------------------------------------------------------- -- -- Table structure for table `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 AUTO_INCREMENT=1 ; -- -- Dumping data for table `VGB_LANGUAGE` -- -- -------------------------------------------------------- -- -- Table structure for table `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` -- -- -------------------------------------------------------- -- -- Table structure for table `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` -- -- -------------------------------------------------------- -- -- Table structure for table `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` -- -- -------------------------------------------------------- -- -- Table structure for table `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 AUTO_INCREMENT=1 ; -- -- Dumping data for table `VGB_RATINGBOX` -- -- -------------------------------------------------------- -- -- Table structure for table `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` -- INSERT INTO `VGB_SESSION` VALUES ('88.136.166', '2007-02-19 03:20:29', '3e44599dbffdeeadffcd', 1, NULL, ''); -- -------------------------------------------------------- -- -- Table structure for table `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(127) 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(40) 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(127) 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` -- INSERT INTO `VGB_SETTINGS` VALUES ('X1.2', '2007-02-03', 'jyNHf6sgAb4LU', 'annxtberlin@yahoo.co.uk', 'Standard_Skin', 0, 0, 0, 1, 0, 5, 0, 25, 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, 28, '2007-02-03', 'jnj001.ipnames.net/~animalli/gb/guestbook.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, 2, 0, 0, 0, '', '', 1, 0, NULL, 1, 0, '', 0, 3, '::user::.a+t.::domain::.::tld::', '', 0, 0, 0, 0, 'pass=', 100, 0, 'iso-8859-1', 1, 0, 1, 0, 'webmaster@JNJ001.ipnames.net', 'iso-8859-1', '-fwebmaster@JNJ001.ipnames.net', 0, 'localhost', 25, '', '', 0, 0, 0, 0, 40, 40, 0, 0, 0, 0, 0, 'Default', 1, 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); -- -------------------------------------------------------- -- -- Table structure for table `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` -- INSERT INTO `VGB_SPAM` VALUES ('208.200.80.214', '2007-02-03 06:21:01', NULL); -- -------------------------------------------------------- -- -- Table structure for table `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 AUTO_INCREMENT=1 ; -- -- Dumping data for table `VGB_TICKET` -- -- -------------------------------------------------------- -- -- Table structure for table `VGB_USER` -- CREATE TABLE `VGB_USER` ( `ID` int(11) NOT NULL auto_increment, `NAME` varchar(40) 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(127) 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 AUTO_INCREMENT=1 ; -- -- Dumping data for table `VGB_USER` -- -- -------------------------------------------------------- -- -- Table structure for table `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 DEFAULT CHARSET=latin1 AUTO_INCREMENT=224 ; -- -- Dumping data for table `VGB_VISITOR` -- INSERT INTO `VGB_VISITOR` VALUES (212, '62.163.80.205', '2007-04-03 02:17:18', 'a80205.upc-a.chello.nl', 'Java/1.6.0-oem', 0, 2); INSERT INTO `VGB_VISITOR` VALUES (215, '66.249.72.130', '2007-04-15 22:00:31', 'crawl-66-249-72-130.googlebot.com', 'Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)', 0, 1); INSERT INTO `VGB_VISITOR` VALUES (217, '66.249.72.205', '2007-05-04 06:24:38', 'crawl-66-249-72-205.googlebot.com', 'Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)', 0, 1); INSERT INTO `VGB_VISITOR` VALUES (219, '66.249.65.44', '2007-06-28 04:39:58', 'crawl-66-249-65-44.googlebot.com', 'Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)', 0, 1); INSERT INTO `VGB_VISITOR` VALUES (218, '66.249.72.237', '2007-06-04 13:04:35', 'crawl-66-249-72-237.googlebot.com', 'Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)', 0, 1); INSERT INTO `VGB_VISITOR` VALUES (221, '66.249.65.44', '2007-07-16 18:55:16', 'crawl-66-249-65-44.googlebot.com', 'Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)', 0, 1); INSERT INTO `VGB_VISITOR` VALUES (216, '66.249.72.75', '2007-04-23 20:45:40', 'crawl-66-249-72-75.googlebot.com', 'Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)', 0, 1); INSERT INTO `VGB_VISITOR` VALUES (223, '66.249.66.170', '2007-09-15 20:30:32', 'crawl-66-249-66-170.googlebot.com', 'Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)', 1, 1); INSERT INTO `VGB_VISITOR` VALUES (222, '66.249.65.44', '2007-07-25 12:59:35', 'crawl-66-249-65-44.googlebot.com', 'Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)', 0, 1); INSERT INTO `VGB_VISITOR` VALUES (220, '66.249.65.44', '2007-07-06 15:09:19', 'crawl-66-249-65-44.googlebot.com', 'Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)', 0, 1); INSERT INTO `VGB_VISITOR` VALUES (213, '209.145.87.37', '2007-04-03 14:47:44', 'cpe-209-145-87-37.wb.hsw.ntelos.net', 'Java/1.5.0_06', 0, 2); INSERT INTO `VGB_VISITOR` VALUES (214, '74.6.86.78', '2007-04-12 15:11:04', 'ct501164.inktomisearch.com', 'Mozilla/5.0 (compatible; Yahoo! Slurp; http://help.yahoo.com/help/us/ysearch/slurp)', 0, 1);