dropped cubecart blocker

[slic535]

i was in my phpadmin and i accidentaly pushed the dropped category section for cubecart blocker. does anyone know how to get it back. i am unable to login to my admin to the cc3.

[bsmither]

i have no idea what you mean by 'dropped category section'. do you mean that you accidentally deleted the table 'cubecart_blocker'? (in sql language, that means 'drop table'.)

[slic535]

i have no idea what you mean by 'dropped category section'. do you mean that you accidentally deleted the table 'cubecart_blocker'? (in sql language, that means 'drop table'.)

yes i was in my phpadmin and i accidentaly pushed the red x on it. do you know how i can get it back?

[bsmither]

phpadmin has a place where you can enter a sql statement:

CREATE TABLE `prefix_CubeCart_blocker` (

`id` int(11) NOT NULL auto_increment,

`browser` text,

`ip` varchar(15) NOT NULL,

`username` varchar(50) NOT NULL,

`blockTime` int(10) NOT NULL default '0',

`blockLevel` int(1) NOT NULL default '0',

`loc` char(1) NOT NULL,

`lastTime` int(10) NOT NULL,

KEY `id` (`id`)

) ENGINE=MyISAM AUTO_INCREMENT=1;

pay attention to prefix_ and make it what all the other tables have as your prefix.

the above is taken from the install folder of cubecart 3.0.20