Icy Phoenix

Old Support Topics - Number Of News In Portal

zankyw [ Sat 21 Oct, 2006 01:21 ]
Post subject: Number Of News In Portal

Hi!

I would like to limit the number of news showed in Portal. I've gone to ACP >> Portal >> Portal Configuration, but there are some options in blank and I don't see the correspondent option.

Can I change the number of shown news in PhpMyAdmin or there is any other solution? Thx!

moreteavicar [ Sat 21 Oct, 2006 14:27 ]
Post subject: Re: Number Of News In Portal

That looks to me like the config parameters are actually missing from your database. The way the admin index for portal config works is that all the options are pulled from the database, rather than being "hard-coded" in the php file... so, for it to be missing in ACP suggests its not there in the database.

With phpMyAdmin, the place to look is phpbb_portal_config. You should have these in the table (listed in order of id)

5 md_news_length
6 md_news_forum_id
7 md_num_news

If they are not there, you can add them with this:

Code: [Hide] [Select]

INSERT INTO `phpbb_portal_config` VALUES (5, 'md_news_length', '250');

INSERT INTO `phpbb_portal_config` VALUES (6, 'md_news_forum_id', '2,8');

INSERT INTO `phpbb_portal_config` VALUES (7, 'md_num_news', '3');

zankyw [ Sat 21 Oct, 2006 15:07 ]
Post subject: Re: Number Of News In Portal

Thanks for your help!
There were some missing values in the database.
I've done the query, and now all the values appear in phpMyAdmin, but I continue having the same problem in the ACP.

At the moment, there are 10 news published in the first page of my portal, but I don't see this value (10) in the table "phpbb_portal_config", so, I'm a bit confused.

...Where can I change the number of shown news in the portal?

moreteavicar [ Sun 22 Oct, 2006 00:54 ]
Post subject: Re: Number Of News In Portal

I think this is to do with caching - because a change was made in SQL (changes made directly in SQL are not reflected in cached files). So.. I think clearing cache will solve it. (Can be done via Styles >> Manage Cache in ACP)

moreteavicar [ Sun 22 Oct, 2006 01:13 ]
Post subject: Re: Number Of News In Portal

Forgot to ask, how may items in phpbb_portal_config? If not 42, then perhaps you could run this script. You need to be logged in first! It won't change anything thats already there (you'll see some errors saying such and such already exists).

zankyw [ Tue 24 Oct, 2006 02:56 ]
Post subject: Re: Number Of News In Portal

I've only 35 items.

I'll test tomorrow. Thanks

I'll keep you informed.

moreteavicar [ Tue 24 Oct, 2006 13:28 ]
Post subject: Re: Number Of News In Portal

I think some things were removed in XS portal config because certain IMportal features were removed - like having a site-wide left nav bar. The above script install all the config for a full install of importal (which I converted to full in my own version of XS), so some settings may have no effect, but that will be harmless. Good luck;)

PS Does the correct number of news items display now?

zankyw [ Tue 24 Oct, 2006 14:27 ]
Post subject: Re: Number Of News In Portal

The script gave me the following message:

Spoiler: [ Show ]

Code: [Hide] [Select]

Updating the database

    * INSERT INTO `phpbb_portal_config` VALUES (1, 'default_portal', '1')

      +++ Error: Duplicate entry '1' for key 1

    * INSERT INTO `phpbb_portal_config` VALUES (2, 'portal_header', '1')

      +++ Error: Duplicate entry '2' for key 1

    * INSERT INTO `phpbb_portal_config` VALUES (3, 'portal_tail', '0')

      +++ Error: Duplicate entry '3' for key 1

    * INSERT INTO `phpbb_portal_config` VALUES (4, 'cache_enabled', '1')

      +++ Error: Duplicate entry '4' for key 1

    * INSERT INTO `phpbb_portal_config` VALUES (5, 'md_news_length', '250')

      +++ Error: Duplicate entry '5' for key 1

    * INSERT INTO `phpbb_portal_config` VALUES (6, 'md_news_forum_id', '2,8')

      +++ Error: Duplicate entry '6' for key 1

    * INSERT INTO `phpbb_portal_config` VALUES (7, 'md_num_news', '3')

      +++ Error: Duplicate entry '7' for key 1

    * INSERT INTO `phpbb_portal_config` VALUES (8, 'md_search_option_text', 'IM Portal')

      +++ Error: Duplicate entry '8' for key 1

    * INSERT INTO `phpbb_portal_config` VALUES (41, 'md_approve_mod_installed', '0')

      +++ Successfull

    * INSERT INTO `phpbb_portal_config` VALUES (40, 'md_num_recent_topics', '10')

      +++ Successfull

    * INSERT INTO `phpbb_portal_config` VALUES (39, 'md_poll_display', '0')

      +++ Successfull

    * INSERT INTO `phpbb_portal_config` VALUES (38, 'md_poll_bar_length', '125')

      +++ Successfull

    * INSERT INTO `phpbb_portal_config` VALUES (15, 'header_width', '175')

      +++ Error: Duplicate entry '15' for key 1

    * INSERT INTO `phpbb_portal_config` VALUES (16, 'footer_width', '')

      +++ Error: Duplicate entry '16' for key 1

    * INSERT INTO `phpbb_portal_config` VALUES (17, 'md_cache_file_locking', '1')

      +++ Error: Duplicate entry '17' for key 1

    * INSERT INTO `phpbb_portal_config` VALUES (18, 'md_cache_write_control', '1')

      +++ Error: Duplicate entry '18' for key 1

    * INSERT INTO `phpbb_portal_config` VALUES (19, 'md_cache_read_control', '1')

      +++ Error: Duplicate entry '19' for key 1

    * INSERT INTO `phpbb_portal_config` VALUES (20, 'md_cache_read_type', 'md5')

      +++ Error: Duplicate entry '20' for key 1

    * INSERT INTO `phpbb_portal_config` VALUES (21, 'md_cache_filename_protect', '0')

      +++ Error: Duplicate entry '21' for key 1

    * INSERT INTO `phpbb_portal_config` VALUES (22, 'md_cache_serialize', '1')

      +++ Error: Duplicate entry '22' for key 1

    * INSERT INTO `phpbb_portal_config` VALUES (23, 'md_hours_track_users', '6')

      +++ Error: Duplicate entry '23' for key 1

    * INSERT INTO `phpbb_portal_config` VALUES (24, 'md_scroll_delay', '100')

      +++ Error: Duplicate entry '24' for key 1

    * INSERT INTO `phpbb_portal_config` VALUES (42, 'md_recent_topics_style', '1')

      +++ Successfull

    * INSERT INTO `phpbb_portal_config` VALUES (25, 'md_cat_id', '0')

      +++ Error: Duplicate entry '25' for key 1

    * INSERT INTO `phpbb_portal_config` VALUES (26, 'md_pics_number', '4')

      +++ Error: Duplicate entry '26' for key 1

    * INSERT INTO `phpbb_portal_config` VALUES (27, 'md_pics_sort', '0')

      +++ Error: Duplicate entry '27' for key 1

    * INSERT INTO `phpbb_portal_config` VALUES (28, 'md_pics_all', '0')

      +++ Error: Duplicate entry '28' for key 1

    * INSERT INTO `phpbb_portal_config` VALUES (29, 'md_display_not_visit', '0')

      +++ Error: Duplicate entry '29' for key 1

    * INSERT INTO `phpbb_portal_config` VALUES (37, 'md_poll_forum_id', '2')

      +++ Successfull

    * INSERT INTO `phpbb_portal_config` VALUES (9, 'md_num_recent_topics', '10')

      +++ Error: Duplicate entry '9' for key 1

    * INSERT INTO `phpbb_portal_config` VALUES (10, 'md_approve_mod_installed', '0')

      +++ Error: Duplicate entry '10' for key 1

    * INSERT INTO `phpbb_portal_config` VALUES (11, 'md_recent_topics_style', '1')

      +++ Error: Duplicate entry '11' for key 1

    * INSERT INTO `phpbb_portal_config` VALUES (12, 'md_poll_bar_length', '125')

      +++ Error: Duplicate entry '12' for key 1

    * INSERT INTO `phpbb_portal_config` VALUES (13, 'md_poll_forum_id', '2')

      +++ Error: Duplicate entry '13' for key 1

    * INSERT INTO `phpbb_portal_config` VALUES (14, 'md_cache_file_locking', '1')

      +++ Error: Duplicate entry '14' for key 1

    * INSERT INTO `phpbb_portal_config` VALUES (30, 'cm_total_articles', '5')

      +++ Error: Duplicate entry '30' for key 1

    * INSERT INTO `phpbb_portal_config` VALUES (31, 'cm_recent_articles_style', '1')

      +++ Error: Duplicate entry '31' for key 1

After updating, I went to the ACP, I deleted Xtreme Styles cache, and after that, to the ACP >> Portal >> Portal Configuration but there are the same missing lines than before.

Moreover, I've been looking the table, but I can't see the item 36.

moreteavicar wrote: [View Post]
PS Does the correct number of news items display now?

No, there are 10 news displayed, but in the table, I have selected 3:

id config_name config_value
7 md_num_news 3

I don't know what to do. Here it is the table:

Spoiler: [ Show ]

Code: [Hide]

-- phpMyAdmin SQL Dump
 
-- version 2.8.2.4
 
-- http://www.phpmyadmin.net
 
-- 
 
-- Servidor: localhost
 
-- Tiempo de generación: 24-10-2006 a las 07:25:16
 
-- Versión del servidor: 4.1.21
 
-- Versión de PHP: 4.4.2
 
-- 
 
-- Base de datos: `***`
 
-- 
 
-- --------------------------------------------------------
 
-- 
 
-- Estructura de tabla para la tabla `phpbb_portal_config`
 
-- 
 
DROP TABLE IF EXISTS `phpbb_portal_config`;
 
CREATE TABLE `phpbb_portal_config` (
 
  `id` int(10) unsigned NOT NULL auto_increment,
 
  `config_name` varchar(255) NOT NULL default '',
 
  `config_value` varchar(255) NOT NULL default '',
 
  PRIMARY KEY  (`id`)
 
) ENGINE=MyISAM AUTO_INCREMENT=43 DEFAULT CHARSET=latin1 AUTO_INCREMENT=43 ;
 
-- 
 
-- Volcar la base de datos para la tabla `phpbb_portal_config`
 
-- 
 
INSERT INTO `phpbb_portal_config` (`id`, `config_name`, `config_value`) VALUES (1, 'default_portal', '3'),
 
(2, 'portal_header', '1'),
 
(3, 'portal_tail', '0'),
 
(4, 'cache_enabled', '1'),
 
(6, 'md_news_forum_id', '1'),
 
(7, 'md_num_news', '3'),
 
(8, 'md_search_option_text', 'LphantES'),
 
(9, 'md_num_recent_topics', '3'),
 
(10, 'md_approve_mod_installed', '0'),
 
(11, 'md_recent_topics_style', '0'),
 
(12, 'md_poll_bar_length', '40'),
 
(13, 'md_poll_forum_id', '4'),
 
(14, 'md_cache_file_locking', '1'),
 
(15, 'md_cache_write_control', '1'),
 
(16, 'md_cache_read_control', '1'),
 
(17, 'md_cache_read_type', 'md5'),
 
(18, 'md_cache_filename_protect', '0'),
 
(19, 'md_cache_serialize', '1'),
 
(20, 'md_cat_id', '0'),
 
(21, 'md_pics_number', '0'),
 
(22, 'md_pics_sort', '1'),
 
(23, 'md_pics_all', '0'),
 
(24, 'md_total_poster', '3'),
 
(25, 'md_avatar_height', '80'),
 
(26, 'md_links_style', '1'),
 
(27, 'md_links_own1', '1'),
 
(28, 'md_links_own2', '0'),
 
(29, 'md_links_code', '1'),
 
(30, 'cm_total_articles', '1'),
 
(31, 'cm_recent_articles_style', '1'),
 
(32, 'md_wordgraph_count', '0'),
 
(33, 'md_wordgraph_words', '12'),
 
(34, 'md_num_new_downloads', '4'),
 
(35, 'md_num_top_downloads', '4'),
 
(5, 'md_news_length', '150'),
 
(41, 'md_approve_mod_installed', '0'),
 
(40, 'md_num_recent_topics', '10'),
 
(39, 'md_poll_display', '0'),
 
(38, 'md_poll_bar_length', '125'),
 
(42, 'md_recent_topics_style', '1'),
 
(37, 'md_poll_forum_id', '2');

That's all

moreteavicar [ Tue 24 Oct, 2006 14:42 ]
Post subject: Re: Number Of News In Portal

Ah yes... 36 doesn't exist!

The script message looks about right - I remember things like poll bar length missing.

Hmmm... I'm not sure why the rest isn't working properly... I'll have to think about it...

You could try using the original IMPortal portal admin script included here... (rename the XS one first, then clear cache and upload this)...

moreteavicar [ Tue 24 Oct, 2006 14:53 ]
Post subject: Re: Number Of News In Portal

Another thing - does the news messages actually correspond to the news topics?

And... if its not displaying correct number of news despite SQL, check the portal page news block - I think the selected block file might be the cause here. Does it have news block file instead of forum?

zankyw [ Tue 24 Oct, 2006 15:19 ]
Post subject: Re: Number Of News In Portal

I renamed the admin_portal.php in /adm to admin_portal2.php

Then, I deleted the eXtreme Styles Cache and the Portal Cache

Finally, I uploaded to the /adm folder the attached file. I don't have seen differences, and the ACP is the same.

I've compared the 2 php files, and there are not to much differences (only 5 lines with differences).

Thx for your help

Edit: I'll check what you've written now.

moreteavicar [ Tue 24 Oct, 2006 21:20 ]
Post subject: Re: Number Of News In Portal

Sorry I just realised something (based on my last question) - I normally use the portal news block (based on the forum block file), but most probably, if yours in default XS setup - it will be the XS modified news block, called "news", this parses news from includes/news.php (which is totally different to the standard IMPortal news system). This has its own configuration independent from IMPortal!

Go into ACP>>News Configuration, there you will see "Number of Items To Display", set to 10!

Sorry once again, I forgot about this!

Mighty Gorgon [ Wed 25 Oct, 2006 00:14 ]
Post subject: Re: Number Of News In Portal

The number of News in Portal must be changed in the News section.

The number of News that you can set in IM Portal section are related to FORUM and FORUM_ATTACH blocks...

Try to believe!

max_ossa [ Tue 17 Apr, 2007 06:31 ]
Post subject: Re: Number Of News In Portal

Mighty Gorgon wrote: [View Post]
The number of News that you can set in IM Portal section are related to FORUM and FORUM_ATTACH blocks...

Try to believe!

How i change this in the block ?? (NO IN THE DATABASE)

I can change the number of news in portal.php in blocks_imp_news.php ??

(With the Acp i set the numbers of news of news.php)

Example. In Portal.php i want only ONE new
In news.php i want TEN news.

You can help me ??. Thanks

Mighty Gorgon [ Wed 25 Apr, 2007 01:50 ]
Post subject: Re: Number Of News In Portal

At the moment it is not possible... this feature is still to be coded.