[RC] Multi-Race Rank Themes mod AKA Ranking Sets (1.3.6)

[mluffy]

Thanks!

[Jessica]

EDIT: did you do the SQL queries?

Code: Select all

ALTER TABLE phpbb_users ADD user_rank_theme INT DEFAULT 1 NOT NULL ;
ALTER TABLE phpbb_ranks ADD rank_theme INT DEFAULT 1 NOT NULL ;

UPDATE phpbb_ranks SET rank_theme = -1 WHERE rank_special = 1;

CREATE TABLE phpbb_rank_themes (
  rtheme_id smallint(5) NOT NULL auto_increment,
  rtheme_title varchar(50) default NULL,
  rtheme_public tinyint(1) default '0',
  PRIMARY KEY  (rtheme_id)
) CHARSET=utf8 COLLATE=utf8_bin;

INSERT INTO phpbb_rank_themes VALUES (-1, 'Special', 0);
INSERT INTO phpbb_rank_themes VALUES (1, 'Default', 1);