[Tipp] phpBB2 - subSilver Style wiederherstellen und aktivieren

[Mahony]

Hallo

Lade (falls nicht vorhanden) den subsilver Style nach templates hoch.
Führe die folgenden Befehle im phpmyadmin aus

Code: Alles auswählen

DROP TABLE IF EXISTS `phpbb_themes`;
CREATE TABLE `phpbb_themes` (
  `themes_id` mediumint(8) unsigned NOT NULL auto_increment,
  `template_name` varchar(30) NOT NULL default '',
  `style_name` varchar(30) NOT NULL default '',
  `head_stylesheet` varchar(100) default NULL,
  `body_background` varchar(100) default NULL,
  `body_bgcolor` varchar(6) default NULL,
  `body_text` varchar(6) default NULL,
  `body_link` varchar(6) default NULL,
  `body_vlink` varchar(6) default NULL,
  `body_alink` varchar(6) default NULL,
  `body_hlink` varchar(6) default NULL,
  `tr_color1` varchar(6) default NULL,
  `tr_color2` varchar(6) default NULL,
  `tr_color3` varchar(6) default NULL,
  `tr_class1` varchar(25) default NULL,
  `tr_class2` varchar(25) default NULL,
  `tr_class3` varchar(25) default NULL,
  `th_color1` varchar(6) default NULL,
  `th_color2` varchar(6) default NULL,
  `th_color3` varchar(6) default NULL,
  `th_class1` varchar(25) default NULL,
  `th_class2` varchar(25) default NULL,
  `th_class3` varchar(25) default NULL,
  `td_color1` varchar(6) default NULL,
  `td_color2` varchar(6) default NULL,
  `td_color3` varchar(6) default NULL,
  `td_class1` varchar(25) default NULL,
  `td_class2` varchar(25) default NULL,
  `td_class3` varchar(25) default NULL,
  `fontface1` varchar(50) default NULL,
  `fontface2` varchar(50) default NULL,
  `fontface3` varchar(50) default NULL,
  `fontsize1` tinyint(4) default NULL,
  `fontsize2` tinyint(4) default NULL,
  `fontsize3` tinyint(4) default NULL,
  `fontcolor1` varchar(6) default NULL,
  `fontcolor2` varchar(6) default NULL,
  `fontcolor3` varchar(6) default NULL,
  `span_class1` varchar(25) default NULL,
  `span_class2` varchar(25) default NULL,
  `span_class3` varchar(25) default NULL,
  `img_size_poll` smallint(5) unsigned default NULL,
  `img_size_privmsg` smallint(5) unsigned default NULL,
  PRIMARY KEY  (`themes_id`)
) TYPE=MyISAM AUTO_INCREMENT=2;

Code: Alles auswählen

INSERT INTO `phpbb_themes` (`themes_id`,`template_name`,`style_name`,
`head_stylesheet`,`body_background`,`body_bgcolor`,`body_text`,`body_link`,`body_vlink`,
`body_alink`,`body_hlink`,`tr_color1`,`tr_color2`,`tr_color3`,`tr_class1`,`tr_class2`,`tr_class3`,
`th_color1`,`th_color2`,`th_color3`,`th_class1`,`th_class2`,`th_class3`,`td_color1`,`td_color2`,
`td_color3`,`td_class1`,`td_class2`,`td_class3`,`fontface1`,`fontface2`,`fontface3`,`fontsize1`,
`fontsize2`,`fontsize3`,`fontcolor1`,`fontcolor2`,`fontcolor3`,`span_class1`,`span_class2`,
`span_class3`,
`img_size_poll`,`img_size_privmsg`) VALUES ('1','subSilver','subSilver','subSilver.css','','E5E5E5','000000','006699','5493B4','',
'DD6900','EFEFEF','DEE3E7',
'D1D7DC','','','','98AAB1','006699','FFFFFF','cellpic1.gif','cellpic3.gif','cellpic2.jpg',
'FAFAFA','FFFFFF','','row1','row2','','Verdana, Arial, Helvetica, sans-serif','Trebuchet MS','Courier, 'Courier New', sans-serif','10','11','12','444444','006600','FFA34F','','','',NULL,NULL);

Code: Alles auswählen

DROP TABLE IF EXISTS `phpbb_themes_name`;
CREATE TABLE `phpbb_themes_name` (
  `themes_id` smallint(5) unsigned NOT NULL default '0',
  `tr_color1_name` char(50) default NULL,
  `tr_color2_name` char(50) default NULL,
  `tr_color3_name` char(50) default NULL,
  `tr_class1_name` char(50) default NULL,
  `tr_class2_name` char(50) default NULL,
  `tr_class3_name` char(50) default NULL,
  `th_color1_name` char(50) default NULL,
  `th_color2_name` char(50) default NULL,
  `th_color3_name` char(50) default NULL,
  `th_class1_name` char(50) default NULL,
  `th_class2_name` char(50) default NULL,
  `th_class3_name` char(50) default NULL,
  `td_color1_name` char(50) default NULL,
  `td_color2_name` char(50) default NULL,
  `td_color3_name` char(50) default NULL,
  `td_class1_name` char(50) default NULL,
  `td_class2_name` char(50) default NULL,
  `td_class3_name` char(50) default NULL,
  `fontface1_name` char(50) default NULL,
  `fontface2_name` char(50) default NULL,
  `fontface3_name` char(50) default NULL,
  `fontsize1_name` char(50) default NULL,
  `fontsize2_name` char(50) default NULL,
  `fontsize3_name` char(50) default NULL,
  `fontcolor1_name` char(50) default NULL,
  `fontcolor2_name` char(50) default NULL,
  `fontcolor3_name` char(50) default NULL,
  `span_class1_name` char(50) default NULL,
  `span_class2_name` char(50) default NULL,
  `span_class3_name` char(50) default NULL,
  PRIMARY KEY  (`themes_id`)
) TYPE=MyISAM;

Code: Alles auswählen

INSERT INTO `phpbb_themes_name` (`themes_id`,`tr_color1_name`,`tr_color2_name`,`tr_color3_name`,`tr_class1_name`,`tr_class2_name`,
`tr_class3_name`,`th_color1_name`,`th_color2_name`,`th_color3_name`,`th_class1_name`,
`th_class2_name`,`th_class3_name`,`td_color1_name`,`td_color2_name`,`td_color3_name`,
`td_class1_name`,`td_class2_name`,`td_class3_name`,`fontface1_name`,`fontface2_name`,
`fontface3_name`,`fontsize1_name`,`fontsize2_name`,`fontsize3_name`,`fontcolor1_name`,
`fontcolor2_name`,`fontcolor3_name`,`span_class1_name`,`span_class2_name`,`span_class3_name`) VALUES ('1','Die hellste Zeilen-Farbe','Die mittlere Zeilen-Farbe','Die dunkelste Zeilen-Farbe','','','','Rahmen um die ganze Seite','Rahmen der äußeren Tabelle','Rahmen der inneren Tabelle','Silbernes Verlaufbild','Blaues Verlaufbild','Übergangsbild auf der Hauptseite','Hintergrund für Zitate','Alle weissen Flächen','','Hintergrund für Themenbeiträge #1','Hintergrund für Themenbeiträge #2','','Hauptschriften','Zusätzliche Schrift für die Thementitel','Formularschriften','Kleinste Schriftgröße','Mittlere Schriftgröße','Standard-Schriftgröße','Zitat- und Copyrighthinweis','Schriftfarbe für code-BBCode','Textfarbe der Haupttabelle','','','');

Code: Alles auswählen

UPDATE phpbb_config SET config_value = "1" WHERE config_name="default_style";

Code: Alles auswählen

UPDATE phpbb_config SET config_value = "1" WHERE config_name="override_user_style";

Grüße: Mahony