Hola estoy intentando importar esta base de datos, para un script tipo autohits.dk, me da error y no me la importa ¿que es lo que falla?
$create_banner = mysql_query("CREATE TABLE `banners` (
`id` int(255) NOT NULL auto_increment,
`user_id` varchar(255) NOT NULL default '',
`banner_url` varchar(255) NOT NULL default '',
`forward_url` varchar(255) NOT NULL default '',
`status` varchar(255) NOT NULL default '',
`credits` decimal(250,1) NOT NULL default '0.0',
`views` int(255) NOT NULL default '0',
`clicks` int(255) NOT NULL default '0',
`date_added` date NOT NULL default '0000-00-00',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1");
$create_config = mysql_query("CREATE TABLE `config` (
`id` int(255) NOT NULL default '0',
`site_name` varchar(255) NOT NULL default '',
`site_url` varchar(255) NOT NULL default '',
`admin_email` varchar(255) NOT NULL default '',
`send_from_email` varchar(255) NOT NULL default '',
`credit_earn` decimal(250,1) NOT NULL default '0.0',
`credit_cost` decimal(250,1) NOT NULL default '0.0',
`timer` int(255) NOT NULL default '0',
`start_credits` varchar(255) NOT NULL default '',
`last_banner` int(255) NOT NULL default '0',
`h_limit` int(255) NOT NULL default '0',
`w_limit` int(255) NOT NULL default '0',
`keywords` text NOT NULL,
`description` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM");
$create_sessions = mysql_query("CREATE TABLE `sessions` (
`id` int(255) NOT NULL auto_increment,
`session_id` varchar(255) NOT NULL default '',
`user_id` varchar(255) NOT NULL default '',
`user_email` varchar(255) NOT NULL default '',
`credits_earned` decimal(250,1) NOT NULL default '0.0',
`cheat` varchar(255) NOT NULL default '',
`next_view` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1");
$create_abuse = mysql_query("CREATE TABLE `abuse_report` (
`id` int(255) NOT NULL auto_increment,
`user_id` varchar(255) NOT NULL default '',
`url_id` varchar(255) NOT NULL default '',
`url_reported` varchar(255) NOT NULL default '',
`reason` text NOT NULL,
`date_time` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1");
$create_urls = mysql_query("CREATE TABLE `urls` (
`id` int(255) NOT NULL auto_increment,
`user_id` varchar(255) NOT NULL default '',
`display` varchar(255) NOT NULL default '',
`status` varchar(255) NOT NULL default '',
`credits` decimal(250,1) NOT NULL default '0.0',
`views` int(255) NOT NULL default '0',
`date_added` date NOT NULL default '0000-00-00',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1");
$create_users = mysql_query("CREATE TABLE `users` (
`id` int(255) NOT NULL auto_increment,
`email` varchar(255) NOT NULL default '',
`password` varchar(255) NOT NULL default '',
`contact` varchar(255) NOT NULL default '',
`status` varchar(255) NOT NULL default '',
`confirmkey` varchar(255) NOT NULL default '',
`credits` decimal(250,1) NOT NULL default '0.0',
`last_banner` int(255) NOT NULL default '0',
`last_url` int(255) NOT NULL default '0',
`date_joined` date NOT NULL default '0000-00-00',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1");
$add_config = mysql_query("INSERT INTO `config` VALUES (1, 'Test Auto Surf Exchange', '$site_url', '
[email protected]', '
[email protected]', 0.6, 1.0, 10, '1000', 1, 60, 468, 'autosurf,traffic,excahnge', 'My autosurf traffic exchange')");
$action = "step_3";