# Table backup from FREE PHP VX GUESTBOOK # Creation date: 19-May-2012 04:43 # Database: _phpvxguestbook_2729 # MySQL Server version: 5.2.12-MariaDB-mariadb115-log DROP TABLE IF EXISTS vxg_config; CREATE TABLE vxg_config ( vid int(11) unsigned NOT NULL auto_increment, variable varchar(30) DEFAULT '0' NOT NULL, value text NOT NULL, req tinyint(4) unsigned DEFAULT '1' NOT NULL, name varchar(40) DEFAULT '0' NOT NULL, PRIMARY KEY (vid), KEY ivariable (variable) ); INSERT INTO vxg_config VALUES ('2','admin_name','admin','0','0'); INSERT INTO vxg_config VALUES ('3','admin_pass','f92d46875f02206a92180d663811e912','0','0'); INSERT INTO vxg_config VALUES ('4','word_censor','1','0','0'); INSERT INTO vxg_config VALUES ('5','captcha','1','0','0'); INSERT INTO vxg_config VALUES ('6','admin_valid','1','0','0'); INSERT INTO vxg_config VALUES ('7','allow_html','0','0','0'); INSERT INTO vxg_config VALUES ('8','allowed_tags','','0','0'); INSERT INTO vxg_config VALUES ('9','poster_name','0','1','0'); INSERT INTO vxg_config VALUES ('10','poster_mail','1','1','0'); INSERT INTO vxg_config VALUES ('11','poster_location','1','0','0'); INSERT INTO vxg_config VALUES ('12','msn','1','0','0'); INSERT INTO vxg_config VALUES ('13','aim','1','0','0'); INSERT INTO vxg_config VALUES ('14','yim','1','0','0'); INSERT INTO vxg_config VALUES ('15','homepage','1','0','0'); INSERT INTO vxg_config VALUES ('16','icq','1','0','0'); INSERT INTO vxg_config VALUES ('17','gender','1','0','0'); INSERT INTO vxg_config VALUES ('18','age','1','1','0'); INSERT INTO vxg_config VALUES ('19','c_field_1','1','0','tdaxwjmsh'); INSERT INTO vxg_config VALUES ('20','c_field_2','1','0','tdaxwjmsh'); INSERT INTO vxg_config VALUES ('21','c_field_3','1','0','tdaxwjmsh'); INSERT INTO vxg_config VALUES ('22','c_field_4','1','0','tdaxwjmsh'); INSERT INTO vxg_config VALUES ('23','c_field_5','1','0','tdaxwjmsh'); INSERT INTO vxg_config VALUES ('24','template','bluetheme','0','0'); INSERT INTO vxg_config VALUES ('25','lang','english','0','0'); INSERT INTO vxg_config VALUES ('26','gzip','1','0','0'); INSERT INTO vxg_config VALUES ('27','min_len','10','0','0'); INSERT INTO vxg_config VALUES ('28','max_len','1024','0','0'); INSERT INTO vxg_config VALUES ('29','max_word_lenght','40','0','0'); INSERT INTO vxg_config VALUES ('30','flood_time','60','0','0'); INSERT INTO vxg_config VALUES ('31','per_page','10','0','0'); INSERT INTO vxg_config VALUES ('32','max_visitors_online','6','0','1333794572'); INSERT INTO vxg_config VALUES ('33','gb_title','M & D Creative Concepts LLC Guestbook','0','0'); INSERT INTO vxg_config VALUES ('34','gb_webpath','http://mndwebdesign.com/guestbook/','0','0'); INSERT INTO vxg_config VALUES ('35','copy','Powered by Free PHP VX Guestbook | Counter Widget','0','1337491534'); INSERT INTO vxg_config VALUES ('36','tzone','-06','1','0'); INSERT INTO vxg_config VALUES ('37','enot','1','0','0'); INSERT INTO vxg_config VALUES ('38','admin_mail','dmishle@gmail.com','0','0'); DROP TABLE IF EXISTS vxg_smilies; CREATE TABLE vxg_smilies ( sid smallint(5) unsigned NOT NULL auto_increment, code varchar(50), smile_url varchar(100), emoticon varchar(75), PRIMARY KEY (sid) ); INSERT INTO vxg_smilies VALUES ('1',':D','http://bggrhbvshkya.com/','Very Happy'); INSERT INTO vxg_smilies VALUES ('4',':)','http://bggrhbvshkya.com/','Smile'); INSERT INTO vxg_smilies VALUES ('7',':(','http://bggrhbvshkya.com/','Sad'); INSERT INTO vxg_smilies VALUES ('10',':o)','http://bggrhbvshkya.com/','Surprised'); INSERT INTO vxg_smilies VALUES ('12',':eek:','http://bggrhbvshkya.com/','Surprised'); INSERT INTO vxg_smilies VALUES ('13',':shock:','http://bggrhbvshkya.com/','Shocked'); INSERT INTO vxg_smilies VALUES ('14',':?','http://bggrhbvshkya.com/','Confused'); INSERT INTO vxg_smilies VALUES ('17','8)','http://bggrhbvshkya.com/','Cool'); INSERT INTO vxg_smilies VALUES ('20',':lol:','http://bggrhbvshkya.com/','Laughing'); INSERT INTO vxg_smilies VALUES ('21',':x','http://bggrhbvshkya.com/','Mad'); INSERT INTO vxg_smilies VALUES ('24',':P','http://bggrhbvshkya.com/','Razz'); INSERT INTO vxg_smilies VALUES ('27',':oops:','http://bggrhbvshkya.com/','Embarassed'); INSERT INTO vxg_smilies VALUES ('28',':cry:','http://bggrhbvshkya.com/','Crying or Very sad'); INSERT INTO vxg_smilies VALUES ('29',':evil:','http://bggrhbvshkya.com/','Evil or Very Mad'); INSERT INTO vxg_smilies VALUES ('30',':twisted:','http://bggrhbvshkya.com/','Twisted Evil'); INSERT INTO vxg_smilies VALUES ('31',':roll:','http://bggrhbvshkya.com/','Rolling Eyes'); INSERT INTO vxg_smilies VALUES ('33',';)','http://bggrhbvshkya.com/','Wink'); INSERT INTO vxg_smilies VALUES ('35',':!:','http://bggrhbvshkya.com/','Exclamation'); INSERT INTO vxg_smilies VALUES ('36',':?:','http://bggrhbvshkya.com/','Question'); INSERT INTO vxg_smilies VALUES ('37',':idea:','http://bggrhbvshkya.com/','Idea'); INSERT INTO vxg_smilies VALUES ('38',':arrow:','http://bggrhbvshkya.com/','Arrow'); INSERT INTO vxg_smilies VALUES ('39',':|','http://bggrhbvshkya.com/','Neutral'); INSERT INTO vxg_smilies VALUES ('42',':mrgreen:','http://bggrhbvshkya.com/','Mr. Green'); DROP TABLE IF EXISTS vxg_posts; CREATE TABLE vxg_posts ( pid int(11) unsigned NOT NULL auto_increment, date int(11) unsigned DEFAULT '0' NOT NULL, text text NOT NULL, poster varchar(240) NOT NULL, location varchar(130) NOT NULL, posteremail varchar(240) NOT NULL, msn varchar(25) NOT NULL, aim varchar(70) NOT NULL, yim varchar(25) NOT NULL, homepage varchar(240) NOT NULL, icq int(11) unsigned, useragent varchar(240) NOT NULL, gender char(1) NOT NULL, age varchar(40) NOT NULL, validated tinyint(1) unsigned DEFAULT '1' NOT NULL, c_field_1 varchar(100) NOT NULL, c_field_2 varchar(100) NOT NULL, c_field_3 varchar(100) NOT NULL, c_field_4 varchar(100) NOT NULL, c_field_5 varchar(100) NOT NULL, pip varchar(16) DEFAULT '0' NOT NULL, PRIMARY KEY (pid) ); INSERT INTO vxg_posts VALUES ('5','1206853954','I\'ve been a happy customer for years, you get the best of the best when dealing with M&D','Joe Bennett','US, UT, SSL','j_l_bennett@comcast.net','','','','firemountainnetwork.com','0','Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; HbTools 4.7.1; Alexa Toolbar)','M','50','1','','','','','','76.27.54.182'); INSERT INTO vxg_posts VALUES ('4','1201633959','Just another grateful customer - a small business owner with a problem solved. :D :D ','Darrell','Palisade, MN','dmishle@frontiernet.net','','','','www.mndcreativeconcepts.biz','0','Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.11) Gecko/20071127 Firefox/2.0.0.11','M','56','1','','','','','','70.100.84.82'); INSERT INTO vxg_posts VALUES ('6','1213050098','Boy, you\'re not kidding when you say \"best of the best\" when dealing w/ this group. They Rock! Thank U from moi\' & Erik! :) ','Pam','USA, CA, Norwalk','poneil1361@yahoo.com','','','','','0','Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; InfoPath.1; .NET CLR 2.0.50727)','F','46','1','','','','','','165.254.210.3'); DROP TABLE IF EXISTS vxg_sessions; CREATE TABLE vxg_sessions ( ip varchar(16), stime int(11) unsigned DEFAULT '0' NOT NULL, sname varchar(10) DEFAULT '0' NOT NULL, sval varchar(15) DEFAULT '0' NOT NULL, PRIMARY KEY (stime), KEY ip_stime_sname (ip, stime, sname) ); INSERT INTO vxg_sessions VALUES ('38.107.179.227','1337418659','online','0');