Einstellungen aller Artikel und Bereiche via SQL-Query verändern

[Mystics]

Hinweis: Diese Querys können entweder mit phpMyAdmin (http://www.vbulletin-germany.com/forum/showthread.php?t=5294) oder direkt im Admin-Kontrollzentrum (siehe hier (http://www.vbulletin-germany.com/forum/showpost.php?p=304353), Frage 8) ausgeführt werden.

Jedes dieser Querys ändert die angegebene Einstellung für alle Artikel bzw. alle Bereiche.

Wichtig: Falls ein Tabellen-Präfix für die vBulletin-Tabellen verwendet wird, muss der Tabellenname entsprechend angepasst werden (z.B. vb_cms_node statt cms_node).

Wichtig: Nach dem Ausführen der Querys muss noch der CMS-Cache geleert werden:
Administrator-Kontrollzentrum -> vBulletin-CMS -> CMS-Cache leeren

_________________________________________________

Querys für Artikel

Veröffentlicht
Ja: UPDATE cms_node SET setpublish = 1 WHERE contenttypeid = (SELECT contenttypeid FROM contenttype WHERE class = 'Article');
Nein: UPDATE cms_node SET setpublish = 0 WHERE contenttypeid = (SELECT contenttypeid FROM contenttype WHERE class = 'Article');

Kommentare
Ja: UPDATE cms_node SET comments_enabled = 1 WHERE contenttypeid = (SELECT contenttypeid FROM contenttype WHERE class = 'Article');
Nein: UPDATE cms_node SET comments_enabled = 0 WHERE contenttypeid = (SELECT contenttypeid FROM contenttype WHERE class = 'Article');

Vorschau ohne Leseberechtigung anzeigen
Ja: UPDATE cms_node SET publicpreview = 1 WHERE contenttypeid = (SELECT contenttypeid FROM contenttype WHERE class = 'Article');
Nein: UPDATE cms_node SET publicpreview = 0 WHERE contenttypeid = (SELECT contenttypeid FROM contenttype WHERE class = 'Article');

Titel anzeigen
Ja: UPDATE cms_node SET showtitle = 1 WHERE contenttypeid = (SELECT contenttypeid FROM contenttype WHERE class = 'Article');
Nein: UPDATE cms_node SET showtitle = 0 WHERE contenttypeid = (SELECT contenttypeid FROM contenttype WHERE class = 'Article');

Autor anzeigen
Ja: UPDATE cms_node SET showuser = 1 WHERE contenttypeid = (SELECT contenttypeid FROM contenttype WHERE class = 'Article');
Nein: UPDATE cms_node SET showuser = 0 WHERE contenttypeid = (SELECT contenttypeid FROM contenttype WHERE class = 'Article');

Veröffentlichungsdatum anzeigen
Ja: UPDATE cms_node SET showpublishdate = 1 WHERE contenttypeid = (SELECT contenttypeid FROM contenttype WHERE class = 'Article');
Nein: UPDATE cms_node SET showpublishdate = 0 WHERE contenttypeid = (SELECT contenttypeid FROM contenttype WHERE class = 'Article');

Kompletten Artikel im Bereich anzeigen
Ja: UPDATE cms_node SET showpreviewonly = 0 WHERE contenttypeid = (SELECT contenttypeid FROM contenttype WHERE class = 'Article');
Nein: UPDATE cms_node SET showpreviewonly = 1 WHERE contenttypeid = (SELECT contenttypeid FROM contenttype WHERE class = 'Article');

Letzte Aktualisierung anzeigen
Ja: UPDATE cms_node SET showupdated = 1 WHERE contenttypeid = (SELECT contenttypeid FROM contenttype WHERE class = 'Article');
Nein: UPDATE cms_node SET showupdated = 0 WHERE contenttypeid = (SELECT contenttypeid FROM contenttype WHERE class = 'Article');

Seitenaufrufe anzeigen
Ja: UPDATE cms_node SET showviewcount = 1 WHERE contenttypeid = (SELECT contenttypeid FROM contenttype WHERE class = 'Article');
Nein: UPDATE cms_node SET showviewcount = 0 WHERE contenttypeid = (SELECT contenttypeid FROM contenttype WHERE class = 'Article');

Bewertung möglich
Ja: UPDATE cms_node SET showrating = 1 WHERE contenttypeid = (SELECT contenttypeid FROM contenttype WHERE class = 'Article');
Nein: UPDATE cms_node SET showrating = 0 WHERE contenttypeid = (SELECT contenttypeid FROM contenttype WHERE class = 'Article');

Im Bereich anzeigen
Ja: UPDATE cms_node SET hidden = 0 WHERE contenttypeid = (SELECT contenttypeid FROM contenttype WHERE class = 'Article');
Nein: UPDATE cms_node SET hidden = 1 WHERE contenttypeid = (SELECT contenttypeid FROM contenttype WHERE class = 'Article');

Anzeige in Navigationsleiste möglich
Ja: UPDATE cms_node SET shownav = 1 WHERE contenttypeid = (SELECT contenttypeid FROM contenttype WHERE class = 'Article');
Nein: UPDATE cms_node SET shownav = 0 WHERE contenttypeid = (SELECT contenttypeid FROM contenttype WHERE class = 'Article');

Durchsuchbar
Ja: UPDATE cms_node SET nosearch = 0 WHERE contenttypeid = (SELECT contenttypeid FROM contenttype WHERE class = 'Article');
Nein: UPDATE cms_node SET nosearch = 1 WHERE contenttypeid = (SELECT contenttypeid FROM contenttype WHERE class = 'Article');


_________________________________________________

Querys für Bereiche

Veröffentlicht
Ja: UPDATE cms_node SET setpublish = 1 WHERE contenttypeid = (SELECT contenttypeid FROM contenttype WHERE class = 'Section');
Nein: UPDATE cms_node SET setpublish = 0 WHERE contenttypeid = (SELECT contenttypeid FROM contenttype WHERE class = 'Section');

Style
Vererbt: UPDATE cms_node SET styleid = -1 WHERE contenttypeid = (SELECT contenttypeid FROM contenttype WHERE class = 'Section');
Standard-Style des Forums: UPDATE cms_node SET styleid = 0 WHERE contenttypeid = (SELECT contenttypeid FROM contenttype WHERE class = 'Section');
Anderer Style: UPDATE cms_node SET styleid = X WHERE contenttypeid = (SELECT contenttypeid FROM contenttype WHERE class = 'Section');
(X = ID des Styles)


Wichtig: Die folgenden Querys funktionieren nur bei Bereichen, bei denen diese Einstellungen bereits geändert wurden. Ansonsten gibt es die Einträge in der Tabelle 'cms_nodeconfig' noch nicht.

Seitennavigation anzeigen
Ja: UPDATE cms_nodeconfig SET value = 1 WHERE name = 'pagination_links';
Nein: UPDATE cms_nodeconfig SET value = 0 WHERE name = 'pagination_links';

Anzeigereihenfolge
Auswahl, dann nach Datum: UPDATE cms_nodeconfig SET value = 1 WHERE name = 'section_priority';
Nur ausgewählte Artikel: UPDATE cms_nodeconfig SET value = 5 WHERE name = 'section_priority';
Neue Artikel zuerst: UPDATE cms_nodeconfig SET value = 2 WHERE name = 'section_priority';
Neuester Artikel pro Bereich: UPDATE cms_nodeconfig SET value = 3 WHERE name = 'section_priority';
Alphabetisch: UPDATE cms_nodeconfig SET value = 4 WHERE name = 'section_priority';

Artikel anzeigen
Nur aus diesem Bereich: UPDATE cms_nodeconfig SET value = 1 WHERE name = 'contentfrom';
Auch aus Unterbereichen: UPDATE cms_nodeconfig SET value = 2 WHERE name = 'contentfrom';

Layout des Inhalts
1 Spalte: UPDATE cms_nodeconfig SET value = 1 WHERE name = 'content_layout';
2 Spalten: UPDATE cms_nodeconfig SET value = 2 WHERE name = 'content_layout';
3 Spalten: UPDATE cms_nodeconfig SET value = 3 WHERE name = 'content_layout';
1x2 Spalten: UPDATE cms_nodeconfig SET value = 4 WHERE name = 'content_layout';
2x1 Spalte: UPDATE cms_nodeconfig SET value = 5 WHERE name = 'content_layout';

Pro Seite
X Artikel: UPDATE cms_nodeconfig SET value = X WHERE name = 'items_perhomepage';