hide_errors();
echo 'Adding Table : nlp_notifications_thread
';vbflush();
$db->query_write("
CREATE TABLE `" . TABLE_PREFIX . "nlp_notifications_thread` (
`id` INT( 10 ) NOT NULL AUTO_INCREMENT ,
`threadid` INT( 10 ) NOT NULL ,
`dateline` INT( 10 ) NOT NULL,
`forumid` INT( 10 ) NOT NULL,
PRIMARY KEY ( `id`, `threadid` )
)ENGINE = MYISAM ;
");
$db->show_errors();
echo 'Adding Table : nlp_notifications_read ';vbflush();
$db->query_write("
CREATE TABLE `" . TABLE_PREFIX . "nlp_notifications_read` (
`userid` INT( 10 ) NOT NULL ,
`threadid` INT( 10 ) NOT NULL ,
`dateline` INT( 10 ) NOT NULL
)ENGINE = MYISAM ;
");
$db->show_errors();]]>
show_errors();
echo 'Remove Table : nlp_notifications_read, nlp_notifications_thread '; vbflush();
$db->query_write("
DROP TABLE `" . TABLE_PREFIX . "nlp_notifications_read` ,`" . TABLE_PREFIX . "nlp_notifications_thread`
");
$db->show_errors();]]>
hide_errors();
$sgmamet = $db->query_read("SELECT threadid FROM " . TABLE_PREFIX . "nlp_notifications_thread");
$db->show_errors();
while($gogo = $db->fetch_array($sgmamet))
{
$marone .= ', ' . $gogo['threadid'];
}
echo 'Fix errors in table "nlp_notifications_read" , by UPDATING ';
$db->hide_errors();
$db->query_write("
DELETE FROM " . TABLE_PREFIX . "nlp_notifications_read
WHERE threadid NOT IN (0$marone)
");
$db->show_errors();
vbflush();]]>
hide_errors();
echo 'ALTER Table : nlp_notifications_thread add : expired field ';vbflush();
$db->query_write("
ALTER TABLE `" . TABLE_PREFIX . "nlp_notifications_thread`
ADD `expired` INT( 10 ) NOT NULL DEFAULT '0'
");
$db->show_errors();]]>
| $vbphrase[nlp_notifications_threads] | |
$vbphrase[total] ($bbuserinfo[nlp_notifications_thread]) |
