phpBB România

Cod: Selectaţi tot

##############################################################
# * ChangeLog phpBB Extra 1.0.1
##############################################################
## Schimbari:
##
##   - Reparat un bug in memberlist
##   - Mai multe campuri ignorate in CTracker
##   - Reparat un bug cu privire la crearea anunturilor globale
##   - Rezolvata o problema de design in profilul utilizatorului
##   - Modernizare completa a statisticilor
##   - Integrarea unor MODuri intre ele pentru un design mai placut
##   - Mai multe modificari in aspectul forumului
##   - Permiterea administratorului de a seta o imagine unui subforum
##
##############################################################
# *- modificarile de la versiunea precedenta (1.0.0)

Cod: Selectaţi tot

UPDATE `phpbb_config` SET `config_value` = '3' WHERE CONVERT( `phpbb_config`.`config_name` USING utf8 ) = 'top_posters' LIMIT 1 ;
DROP TABLE `phpbb_stats_config`;
DROP TABLE `phpbb_stats_modules`;

Cod: Selectaţi tot

CREATE TABLE phpbb_module_cache (
  module_id mediumint(8) NOT NULL default '0',
  module_cache_time int(12) NOT NULL default '0',
  db_cache text NOT NULL,
  priority mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (module_id)
);

CREATE TABLE phpbb_modules (
  module_id mediumint(8) unsigned NOT NULL auto_increment,
  short_name varchar(100) default NULL,
  update_time mediumint(8) NOT NULL default '0',
  module_order mediumint(8) NOT NULL default '0',
  active tinyint(2) NOT NULL default '0',
  perm_all tinyint(2) unsigned NOT NULL default '1',
  perm_reg tinyint(2) unsigned NOT NULL default '1',
  perm_mod tinyint(2) unsigned NOT NULL default '1',
  perm_admin tinyint(2) unsigned NOT NULL default '1',
  PRIMARY KEY  (module_id)
);

CREATE TABLE phpbb_module_info (
  module_id mediumint(8) NOT NULL default '0',
  long_name varchar(100) NOT NULL default '',
  author varchar(50) default NULL,
  email varchar(50) default NULL,
  url varchar(100) default NULL,
  version varchar(100) NOT NULL default '',
  update_site varchar(100) default NULL,
  extra_info longtext NOT NULL default '',
  PRIMARY KEY  (module_id)
);

CREATE TABLE phpbb_module_group_auth (
  module_id mediumint(8) unsigned NOT NULL default '0',
  group_id mediumint(8) unsigned NOT NULL default '0'
);

CREATE TABLE phpbb_stats_config (
  config_name varchar(100) NOT NULL default '',
  config_value varchar(100) NOT NULL default '',
  PRIMARY KEY  (config_name)
);

CREATE TABLE phpbb_module_admin_panel (
  module_id mediumint(8) unsigned NOT NULL default '0',
  config_name varchar(255) NOT NULL default '',
  config_value varchar(255) NOT NULL default '',
  config_type varchar(20) NOT NULL default '',
  config_title varchar(100) NOT NULL default '',
  config_explain varchar(100) default NULL,
  config_trigger varchar(20) NOT NULL default ''
);

CREATE TABLE stats_smilies_index (
  code varchar(50) default NULL,
  smile_url varchar(100) default NULL,
  smile_count mediumint(8) default '0'
);

CREATE TABLE stats_smilies_info (
  last_post_id mediumint(8) NOT NULL default '0',
  last_update_time int(12) NOT NULL default '0',
  update_time mediumint(8) NOT NULL default '10080'
);

INSERT INTO phpbb_stats_config (config_name, config_value) VALUES ('return_limit', '10');
INSERT INTO phpbb_stats_config (config_name, config_value) VALUES ('version', '4.2.3');
INSERT INTO phpbb_stats_config (config_name, config_value) VALUES ('page_views', '0');
INSERT INTO phpbb_stats_config (config_name, config_value) VALUES ('stat_index', '0');
INSERT INTO phpbb_stats_config (config_name, config_value) VALUES ('stat_all_or_one', '0');
INSERT INTO stats_smilies_info (last_post_id, last_update_time, update_time) VALUES (0, 0, 10080);