Edit File by line
• /home/barbar84/www/wp-conte.../plugins/sujqvwi/AnonR/smanonr..../var/softacul.../vxgb
• File: vxgb.sql
--
[0] Fix | Delete
-- Database: `vxgb`
[1] Fix | Delete
--
[2] Fix | Delete
[3] Fix | Delete
-- --------------------------------------------------------
[4] Fix | Delete
[5] Fix | Delete
--
[6] Fix | Delete
-- Table structure for table `[[dbprefix]]ban`
[7] Fix | Delete
--
[8] Fix | Delete
[9] Fix | Delete
CREATE TABLE `[[dbprefix]]ban` (
[10] Fix | Delete
`bid` int(11) unsigned NOT NULL auto_increment,
[11] Fix | Delete
`type` tinyint(4) unsigned NOT NULL default '0',
[12] Fix | Delete
`value` varchar(250) NOT NULL default '0',
[13] Fix | Delete
PRIMARY KEY (`bid`),
[14] Fix | Delete
KEY `type` (`type`,`value`(1))
[15] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
[16] Fix | Delete
[17] Fix | Delete
--
[18] Fix | Delete
-- Dumping data for table `[[dbprefix]]ban`
[19] Fix | Delete
--
[20] Fix | Delete
[21] Fix | Delete
[22] Fix | Delete
-- --------------------------------------------------------
[23] Fix | Delete
[24] Fix | Delete
--
[25] Fix | Delete
-- Table structure for table `[[dbprefix]]config`
[26] Fix | Delete
--
[27] Fix | Delete
[28] Fix | Delete
CREATE TABLE `[[dbprefix]]config` (
[29] Fix | Delete
`vid` int(11) unsigned NOT NULL auto_increment,
[30] Fix | Delete
`variable` varchar(30) NOT NULL default '0',
[31] Fix | Delete
`value` text NOT NULL,
[32] Fix | Delete
`req` tinyint(4) unsigned NOT NULL default '1',
[33] Fix | Delete
`name` varchar(40) NOT NULL default '0',
[34] Fix | Delete
PRIMARY KEY (`vid`),
[35] Fix | Delete
KEY `ivariable` (`variable`)
[36] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
[37] Fix | Delete
[38] Fix | Delete
--
[39] Fix | Delete
-- Dumping data for table `[[dbprefix]]config`
[40] Fix | Delete
--
[41] Fix | Delete
[42] Fix | Delete
INSERT INTO `[[dbprefix]]config` VALUES (2, 'admin_name', '[[admin_username]]', 0, '0');
[43] Fix | Delete
INSERT INTO `[[dbprefix]]config` VALUES (3, 'admin_pass', '[[admin_pass]]', 0, '0');
[44] Fix | Delete
INSERT INTO `[[dbprefix]]config` VALUES (4, 'word_censor', '1', 0, '0');
[45] Fix | Delete
INSERT INTO `[[dbprefix]]config` VALUES (5, 'captcha', '0', 0, '0');
[46] Fix | Delete
INSERT INTO `[[dbprefix]]config` VALUES (6, 'admin_valid', '0', 0, '0');
[47] Fix | Delete
INSERT INTO `[[dbprefix]]config` VALUES (7, 'allow_html', '0', 0, '0');
[48] Fix | Delete
INSERT INTO `[[dbprefix]]config` VALUES (8, 'allowed_tags', '<i><font><b>', 0, '0');
[49] Fix | Delete
INSERT INTO `[[dbprefix]]config` VALUES (9, 'poster_name', '0', 1, '0');
[50] Fix | Delete
INSERT INTO `[[dbprefix]]config` VALUES (10, 'poster_mail', '1', 0, '0');
[51] Fix | Delete
INSERT INTO `[[dbprefix]]config` VALUES (11, 'poster_location', '1', 0, '0');
[52] Fix | Delete
INSERT INTO `[[dbprefix]]config` VALUES (12, 'msn', '1', 0, '0');
[53] Fix | Delete
INSERT INTO `[[dbprefix]]config` VALUES (13, 'aim', '1', 0, '0');
[54] Fix | Delete
INSERT INTO `[[dbprefix]]config` VALUES (14, 'yim', '1', 0, '0');
[55] Fix | Delete
INSERT INTO `[[dbprefix]]config` VALUES (15, 'homepage', '1', 0, '0');
[56] Fix | Delete
INSERT INTO `[[dbprefix]]config` VALUES (16, 'icq', '1', 0, '0');
[57] Fix | Delete
INSERT INTO `[[dbprefix]]config` VALUES (17, 'gender', '1', 0, '0');
[58] Fix | Delete
INSERT INTO `[[dbprefix]]config` VALUES (18, 'age', '1', 0, '0');
[59] Fix | Delete
INSERT INTO `[[dbprefix]]config` VALUES (19, 'c_field_1', '1', 0, 'field name');
[60] Fix | Delete
INSERT INTO `[[dbprefix]]config` VALUES (20, 'c_field_2', '1', 0, 'field name');
[61] Fix | Delete
INSERT INTO `[[dbprefix]]config` VALUES (21, 'c_field_3', '1', 0, 'field name');
[62] Fix | Delete
INSERT INTO `[[dbprefix]]config` VALUES (22, 'c_field_4', '1', 0, 'field name');
[63] Fix | Delete
INSERT INTO `[[dbprefix]]config` VALUES (23, 'c_field_5', '1', 0, 'field name');
[64] Fix | Delete
INSERT INTO `[[dbprefix]]config` VALUES (24, 'template', 'subsilver', 0, '0');
[65] Fix | Delete
INSERT INTO `[[dbprefix]]config` VALUES (25, 'lang', 'english', 0, '0');
[66] Fix | Delete
INSERT INTO `[[dbprefix]]config` VALUES (26, 'gzip', '0', 0, '0');
[67] Fix | Delete
INSERT INTO `[[dbprefix]]config` VALUES (27, 'min_len', '10', 0, '0');
[68] Fix | Delete
INSERT INTO `[[dbprefix]]config` VALUES (28, 'max_len', '1024', 0, '0');
[69] Fix | Delete
INSERT INTO `[[dbprefix]]config` VALUES (29, 'max_word_lenght', '40', 0, '0');
[70] Fix | Delete
INSERT INTO `[[dbprefix]]config` VALUES (30, 'flood_time', '60', 0, '0');
[71] Fix | Delete
INSERT INTO `[[dbprefix]]config` VALUES (31, 'per_page', '10', 0, '0');
[72] Fix | Delete
INSERT INTO `[[dbprefix]]config` VALUES (32, 'max_visitors_online', '1', 0, '1170642004');
[73] Fix | Delete
INSERT INTO `[[dbprefix]]config` VALUES (33, 'gb_title', '[[site_desc]]', 0, '0');
[74] Fix | Delete
INSERT INTO `[[dbprefix]]config` VALUES (34, 'gb_webpath', '[[softurl]]', 0, '0');
[75] Fix | Delete
INSERT INTO `[[dbprefix]]config` VALUES (35, 'copy', 'Powered by <a href="http://phpversion.com">Free PHP VX Guestbook</a>', 1, '1171770911');
[76] Fix | Delete
INSERT INTO `[[dbprefix]]config` VALUES (36, 'tzone', '0', 1, '0');
[77] Fix | Delete
INSERT INTO `[[dbprefix]]config` VALUES (37, 'enot', '0', 0, '0');
[78] Fix | Delete
INSERT INTO `[[dbprefix]]config` VALUES (38, 'admin_mail', '[[admin_email]]', 0, '0');
[79] Fix | Delete
[80] Fix | Delete
-- --------------------------------------------------------
[81] Fix | Delete
[82] Fix | Delete
--
[83] Fix | Delete
-- Table structure for table `[[dbprefix]]posts`
[84] Fix | Delete
--
[85] Fix | Delete
[86] Fix | Delete
CREATE TABLE `[[dbprefix]]posts` (
[87] Fix | Delete
`pid` int(11) unsigned NOT NULL auto_increment,
[88] Fix | Delete
`date` int(11) unsigned NOT NULL default '0',
[89] Fix | Delete
`text` text NOT NULL,
[90] Fix | Delete
`poster` varchar(240) NOT NULL default '',
[91] Fix | Delete
`location` varchar(130) NOT NULL default '',
[92] Fix | Delete
`posteremail` varchar(240) NOT NULL default '',
[93] Fix | Delete
`msn` varchar(25) NOT NULL default '',
[94] Fix | Delete
`aim` varchar(70) NOT NULL default '',
[95] Fix | Delete
`yim` varchar(25) NOT NULL default '',
[96] Fix | Delete
`homepage` varchar(240) NOT NULL default '',
[97] Fix | Delete
`icq` int(11) unsigned default NULL,
[98] Fix | Delete
`useragent` varchar(240) NOT NULL default '',
[99] Fix | Delete
`gender` char(1) NOT NULL default '',
[100] Fix | Delete
`age` varchar(40) NOT NULL default '',
[101] Fix | Delete
`validated` tinyint(1) unsigned NOT NULL default '1',
[102] Fix | Delete
`c_field_1` varchar(100) NOT NULL default '',
[103] Fix | Delete
`c_field_2` varchar(100) NOT NULL default '',
[104] Fix | Delete
`c_field_3` varchar(100) NOT NULL default '',
[105] Fix | Delete
`c_field_4` varchar(100) NOT NULL default '',
[106] Fix | Delete
`c_field_5` varchar(100) NOT NULL default '',
[107] Fix | Delete
`pip` varchar(16) NOT NULL default '0',
[108] Fix | Delete
PRIMARY KEY (`pid`)
[109] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
[110] Fix | Delete
[111] Fix | Delete
--
[112] Fix | Delete
-- Dumping data for table `[[dbprefix]]posts`
[113] Fix | Delete
--
[114] Fix | Delete
[115] Fix | Delete
INSERT INTO `[[dbprefix]]posts` VALUES (1, 1169100000, 'Thanks for using Free PHP VX Guestook', 'PHP VX Guestbook', 'USA', '', '', '', '', 'phpversion.com', NULL, '', 'M', '28', 1, '', '', '', '', '', '0');
[116] Fix | Delete
[117] Fix | Delete
-- --------------------------------------------------------
[118] Fix | Delete
[119] Fix | Delete
--
[120] Fix | Delete
-- Table structure for table `[[dbprefix]]sessions`
[121] Fix | Delete
--
[122] Fix | Delete
[123] Fix | Delete
CREATE TABLE `[[dbprefix]]sessions` (
[124] Fix | Delete
`ip` varchar(16) default NULL,
[125] Fix | Delete
`stime` int(11) unsigned NOT NULL default '0',
[126] Fix | Delete
`sname` varchar(10) NOT NULL default '0',
[127] Fix | Delete
`sval` varchar(15) NOT NULL default '0',
[128] Fix | Delete
PRIMARY KEY (`stime`),
[129] Fix | Delete
KEY `ip_stime_sname` (`ip`,`stime`,`sname`)
[130] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
[131] Fix | Delete
[132] Fix | Delete
--
[133] Fix | Delete
-- Dumping data for table `[[dbprefix]]sessions`
[134] Fix | Delete
--
[135] Fix | Delete
[136] Fix | Delete
[137] Fix | Delete
-- --------------------------------------------------------
[138] Fix | Delete
[139] Fix | Delete
--
[140] Fix | Delete
-- Table structure for table `[[dbprefix]]smilies`
[141] Fix | Delete
--
[142] Fix | Delete
[143] Fix | Delete
CREATE TABLE `[[dbprefix]]smilies` (
[144] Fix | Delete
`sid` smallint(5) unsigned NOT NULL auto_increment,
[145] Fix | Delete
`code` varchar(50) default NULL,
[146] Fix | Delete
`smile_url` varchar(100) default NULL,
[147] Fix | Delete
`emoticon` varchar(75) default NULL,
[148] Fix | Delete
PRIMARY KEY (`sid`)
[149] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
[150] Fix | Delete
[151] Fix | Delete
--
[152] Fix | Delete
-- Dumping data for table `[[dbprefix]]smilies`
[153] Fix | Delete
--
[154] Fix | Delete
[155] Fix | Delete
INSERT INTO `[[dbprefix]]smilies` VALUES (1, ':D', 'icon_biggrin.gif', 'Very Happy');
[156] Fix | Delete
INSERT INTO `[[dbprefix]]smilies` VALUES (4, ':)', 'icon_smile.gif', 'Smile');
[157] Fix | Delete
INSERT INTO `[[dbprefix]]smilies` VALUES (7, ':(', 'icon_sad.gif', 'Sad');
[158] Fix | Delete
INSERT INTO `[[dbprefix]]smilies` VALUES (10, ':o)', 'icon_surprised.gif', 'Surprised');
[159] Fix | Delete
INSERT INTO `[[dbprefix]]smilies` VALUES (12, ':eek:', 'icon_surprised.gif', 'Surprised');
[160] Fix | Delete
INSERT INTO `[[dbprefix]]smilies` VALUES (13, ':shock:', 'icon_eek.gif', 'Shocked');
[161] Fix | Delete
INSERT INTO `[[dbprefix]]smilies` VALUES (14, ':?', 'icon_confused.gif', 'Confused');
[162] Fix | Delete
INSERT INTO `[[dbprefix]]smilies` VALUES (17, '8)', 'icon_cool.gif', 'Cool');
[163] Fix | Delete
INSERT INTO `[[dbprefix]]smilies` VALUES (20, ':lol:', 'icon_lol.gif', 'Laughing');
[164] Fix | Delete
INSERT INTO `[[dbprefix]]smilies` VALUES (21, ':x', 'icon_mad.gif', 'Mad');
[165] Fix | Delete
INSERT INTO `[[dbprefix]]smilies` VALUES (24, ':P', 'icon_razz.gif', 'Razz');
[166] Fix | Delete
INSERT INTO `[[dbprefix]]smilies` VALUES (27, ':oops:', 'icon_redface.gif', 'Embarassed');
[167] Fix | Delete
INSERT INTO `[[dbprefix]]smilies` VALUES (28, ':cry:', 'icon_cry.gif', 'Crying or Very sad');
[168] Fix | Delete
INSERT INTO `[[dbprefix]]smilies` VALUES (29, ':evil:', 'icon_evil.gif', 'Evil or Very Mad');
[169] Fix | Delete
INSERT INTO `[[dbprefix]]smilies` VALUES (30, ':twisted:', 'icon_twisted.gif', 'Twisted Evil');
[170] Fix | Delete
INSERT INTO `[[dbprefix]]smilies` VALUES (31, ':roll:', 'icon_rolleyes.gif', 'Rolling Eyes');
[171] Fix | Delete
INSERT INTO `[[dbprefix]]smilies` VALUES (33, ';)', 'icon_wink.gif', 'Wink');
[172] Fix | Delete
INSERT INTO `[[dbprefix]]smilies` VALUES (35, ':!:', 'icon_exclaim.gif', 'Exclamation');
[173] Fix | Delete
INSERT INTO `[[dbprefix]]smilies` VALUES (36, ':?:', 'icon_question.gif', 'Question');
[174] Fix | Delete
INSERT INTO `[[dbprefix]]smilies` VALUES (37, ':idea:', 'icon_idea.gif', 'Idea');
[175] Fix | Delete
INSERT INTO `[[dbprefix]]smilies` VALUES (38, ':arrow:', 'icon_arrow.gif', 'Arrow');
[176] Fix | Delete
INSERT INTO `[[dbprefix]]smilies` VALUES (39, ':|', 'icon_neutral.gif', 'Neutral');
[177] Fix | Delete
INSERT INTO `[[dbprefix]]smilies` VALUES (42, ':mrgreen:', 'icon_mrgreen.gif', 'Mr. Green');
[178] Fix | Delete
[179] Fix | Delete
It is recommended that you Edit text format, this type of Fix handles quite a lot in one request
Function