`idnewsrcp` int(10) NOT NULL DEFAULT "0",
`idclient` int(10) NOT NULL DEFAULT "0",
`idlang` int(10) NOT NULL DEFAULT "0",
`email` varchar(255) DEFAULT NULL,
`confirmed` tinyint(1) NOT NULL DEFAULT "0",
`confirmeddate` datetime NOT NULL DEFAULT "0000-00-00 00:00:00",
`lastaction` varchar(32) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`hash` varchar(32) NOT NULL,
`deactivated` tinyint(1) NOT NULL DEFAULT "0",
`news_type` tinyint(1) NOT NULL DEFAULT "0",
`author` varchar(32) NOT NULL,
`created` datetime NOT NULL DEFAULT "0000-00-00 00:00:00",
`lastmodified` datetime NOT NULL DEFAULT "0000-00-00 00:00:00",
`modifiedby` varchar(32) NOT NULL,
PRIMARY KEY (`idnewsrcp`)
)';
$db->query($sql);
}
if (!$db) {
$db = new DB_Contenido();
}
#$sql = 'SELECT idnews
# FROM ' . $cfg['sql']['sqlprefix'] . '_news
# LIMIT 0, 1';
#if (!$db->query($sql)) {
$sql = 'SHOW TABLES LIKE "' . $cfg['sql']['sqlprefix'] . '_news"';
$db->query($sql);
if (!$db->num_rows()) {
pinlCreateDbTables($db, $cfg);
}