Recent Topics, Posts and Global Announcments 1.1.1

[Rafterman]

seems like the populous is interested in knowing, I'm going to try it on my test board, I'll report back with what my results are in RC1

thx a lot

[Nemo]

seems like the populous is interested in knowing, I'm going to try it on my test board, I'll report back with what my results are in RC1

thx a lot

No one has given you a positive reply on wheter this works on RC1 or not ... well I can tell you that it does. Just remember to copy the .htm file to the new styles (it says to copy it into the subsilver folder which wont work since you need it in subsilver2 and prosilver). The same goes for the subsilver editing.

[triskaidekapit]

This mod is very cool and usefull !
It seems like the mod "At the glance" on phpBB which were wroten by blulegend.

It is still working on phpBB 3 RC2, so it's really cool !

But I would like to know if it could be possible to add the author and the date and time of the last topic and last post ?
It would be really perfect...

Please, could you...?

[emielvenlo]

I Can't get it to work here.

I have installed it a good as i can and i have added the part in overall header here:

Code: Select all

         <span class="corners-bottom"><span></span></span></div>
      </div>

   </div>
         <!-- INCLUDE recent_panel.html -->
   <a name="start_here"></a>

And i have executed the sql lines. But the problem is in the acp when i go to ".MODs" i get the following error:

Code: Select all

General Error
SQL ERROR [ mysql4 ]

Table 'phpbb3.RECENT_PANEL_MODULES' doesn't exist [1146]

SQL

SELECT * FROM RECENT_PANEL_MODULES ORDER BY module_order ASC

BACKTRACE

FILE: includes/db/mysql.php
LINE: 133
CALL: dbal->sql_error()

FILE: includes/acp/acp_recent_panel.php
LINE: 115
CALL: dbal_mysql->sql_query()

FILE: includes/functions_module.php
LINE: 460
CALL: acp_recent_panel->main()

FILE: adm/index.php
LINE: 80
CALL: p_master->load_active()

It looks like i miss some things in the database, but i really have executed the sql code and i have a table from this mod in my database.

Does anyone know what the problem is.

I really would like it if this mod would be actively maintained. There are a lot of people looking for a mod like this one. Look at the mod requests @ phpbb.com

[triskaidekapit]

Ok, I don't know why, but maybe you changed the prefixe of your phpBB database.
Maybe because you had already a first installation of phpBB 2 which use the prefixe phpbb_ and so you put the prefixe phpbb3. (did you ? with the point ?).

I say that because I do the same.
And this message seems to be the reason of the problem I'm describing to you.

Table 'phpbb3.RECENT_PANEL_MODULES' doesn't exist [1146]

So, you're going to execute those new SQL lines :

Code: Select all

DROP TABLE IF EXISTS phpbb3.recent_panel_modules;

CREATE TABLE phpbb3.recent_panel_modules (
  module_name varchar(255) DEFAULT '' NOT NULL,
  module_active smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
  module_order smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
  check_permissions tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
  PRIMARY KEY  (module_name),
  KEY module_order (module_order)
);

INSERT INTO phpbb3.recent_panel_modules VALUES ('recent_topics', 1, 0, 1);
INSERT INTO phpbb3.recent_panel_modules VALUES ('global_announcments', 1, 1, 0);
INSERT INTO phpbb3.recent_panel_modules VALUES ('recent_posts', 1, 2, 1);

INSERT INTO phpbb3.config (config_name, config_value) VALUES ('recent_panel_on', '1');
INSERT INTO phpbb3.config (config_name, config_value) VALUES ('recent_panel_module_width', '300');
INSERT INTO phpbb3.config (config_name, config_value) VALUES ('recent_panel_max_rows', '5');
INSERT INTO phpbb3.config (config_name, config_value) VALUES ('recent_panel_require_read', '1');
INSERT INTO phpbb3.config (config_name, config_value) VALUES ('recent_panel_exclude_forums', '');

Try it...
Hope will help you.

If you really changed this prefixe like me, you are going to have problems each time you'll try to install a MOD that recquire a DATA BASE modification...
So good luck...

[emielvenlo]

@triskaidekapit

My prefix is just phpbb_, my databasename is phpbb3.
You sql code is the same as the one in the mod.

[cotp]

Anyone tried it on RC5 ? Suprised to not see more people on this thread...

Seems like a great mod

Cotp

[stitch626]

Anyone tried it on RC5 ? Suprised to not see more people on this thread...

Seems like a great mod

Cotp

I Just now noticed this thread I agree...sounds like a cool mod. Any screen shot or demo?

[cotp]

I didn't install it finally but I installed ACP Announcement Centre 0.1.0 which I found really cool

Cotp

[topdown]

I have had it on my RC5 for a while now.
Works great.
Here is a screenshot for those who requested one