Vergleich install/resources/upgrade4.php - 1.00 - 1.11

  Keine Änderungen   Hinzugefügt   Modifiziert   Entfernt
Zeile 31Zeile 31

$db->query("UPDATE ".TABLE_PREFIX."users SET style='0' WHERE style='-1';");
$db->query("UPDATE ".TABLE_PREFIX."users SET displaygroup='0' WHERE displaygroup='-1';");


$db->query("UPDATE ".TABLE_PREFIX."users SET style='0' WHERE style='-1';");
$db->query("UPDATE ".TABLE_PREFIX."users SET displaygroup='0' WHERE displaygroup='-1';");

	$db->query("UPDATE ".TABLE_PREFIX."adminoptions SET uid='0' WHERE uid='-1';");

 
	$db->query("UPDATE ".TABLE_PREFIX."forums SET style='0' WHERE style='-1';");

	$db->query("UPDATE ".TABLE_PREFIX."forums SET style='0' WHERE style='-1';");

 
	$query = $db->query("SELECT * FROM ".TABLE_PREFIX."adminoptions WHERE uid='0'");
$test = $db->fetch_array($query);
if(!isset($test['uid']))
{
$db->query("UPDATE ".TABLE_PREFIX."adminoptions SET uid='0' WHERE uid='-1';");
}


$db->query("ALTER TABLE ".TABLE_PREFIX."threads DROP messageindex;");
$db->query("ALTER TABLE ".TABLE_PREFIX."threads DROP subjectindex;");


$db->query("ALTER TABLE ".TABLE_PREFIX."threads DROP messageindex;");
$db->query("ALTER TABLE ".TABLE_PREFIX."threads DROP subjectindex;");