ACP Announcement Centre

[ChriZathens]

Hi, lefty..
I tried to upgrade in my test forum and got this error:

Fatal error: Call to undefined method phpbb_db_tools::sql_table_drop() in C:\xampp\htdocs\snl\install\index.php on line 206

Seems like my db_tools.php is not up to date, but it does not make sense...
EDIT: Looks like my mistake - I guess at the process of cloning my live forum I failed to also get the db folder...

[pittda01]

thanks for your response. ive found this comment:

^ Login to your forum first before running install file.

i've tried this - unfortunately it hasn't worked.

If that doesn't help, then go through this topic, Lefty has mentioned a way to bypass the Admin authorization check.

apologies but i didn't see this comment - so ill now go through topic and see if i can find the bit he refers to.

[pittda01]

on the subject of reading through the post ... i full understand why you say this but in my defence ..

i've searched for 'Admin authorization check' .. and get nothing ... and sitting and reading through 123 pages is a little unrealistic i think.

i'll keep trying to find the existing answer to my question - but any additional help you can give would be gratefully appreciated.

[ChriZathens]

In install/index.php find

Code: Select all

// Before we do anything, lets see if an Admin is calling this file
if (!$auth->acl_get('a_'))
{
	trigger_error('NO_ADMIN');
}

Replace with

Code: Select all

// Before we do anything, lets see if an Admin is calling this file
// if (!$auth->acl_get('a_'))
// {
// 	trigger_error('NO_ADMIN');
// }

[zkaraca]

How can we show polls on index as announcement when showing a topic/post?

[Cebar]

How can i post an annoucement in a specific section only?

[orionstarman]

Has anyone got this to work with the prosilver_se template?
Thanks in advance.

[lefty74]

How can we show polls on index as announcement when showing a topic/post?

You can't, sorry. it can only show the post.

How can i post an annoucement in a specific section only?

it is only possible to either show everywhere or on index only. To show it only in a specific section, you would need to take the code from index.php and move it to the section you would want it displayed instead. that should work but i have not tested it.

Has anyone got this to work with the prosilver_se template?
Thanks in advance.

yes, that should be fairly straight forward, first install this mod on prosilver, then make the prosilver edit in the overall_header.html file of prosilver SE. afterwards, upload the prosilver announcement_centre.html to the prosilver SE folder. again, not really tested but i think thats what i did at the time.

[dickporter]

I think I discovered a bug in v1.2.1

Installing the mod went smoothly, until I set an announcement. I then got the following error:

Code: Select all

General Error
SQL ERROR [ postgres ]

ERROR: invalid input syntax for integer: "" []

SQL

SELECT * FROM phpbb_user_group WHERE group_id = '' AND user_id = 2

BACKTRACE

FILE: includes/db/postgres.php
LINE: 177
CALL: dbal->sql_error()

FILE: includes/functions_announcements.php
LINE: 131
CALL: dbal_postgres->sql_query()

FILE: index.php
LINE: 168
CALL: get_announcement_data()

Looking at get_announcement_data() it does this (the sql_query() is the line mentioned in the backtrace):

Code: Select all

        $selected_groups = array();
        $selected_groups = explode(",", $config['announcement_show_group']);

        $sql = 'SELECT *
                FROM ' . USER_GROUP_TABLE . '
                WHERE ' . $db->sql_in_set('group_id', $selected_groups) . '
                        AND user_id = ' . $user->data['user_id'];
        $db->sql_query($sql);

However, in my configuration I set "Show Site Announcement to:" Everyone and the groups list had nothing selected by default.

The workaround was to select a group even though it was not applicable.

- Dick

[Voyeurette]

I've installed the mod successfully with automod. I cannot find it. ( the tab )

I searched other posts that had similar problem but did not find a direct answer.

Is there something else I need to do?

I am using current versions.

[iftitaj]

I've installed the mod successfully with automod. I cannot find it. ( the tab )

I searched other posts that had similar problem but did not find a direct answer.

Is there something else I need to do?

I am using current versions.

You have to run included install.php from your browser and then select INSTALL.

[ChriZathens]

Hello, Lefty...
Until last week I had the old version (1.0.3a) installed on my forum, so decided to upgrade. I gave a notice to my admins that they do not need to enter the ACP anymore to update the announcements on our board - they can now do it via their MCP.
But after using it for a while they told me that they still prefer to do it via ACP because it has the preview and they can easily see what they have written before they post it. I thought that it makes perfect sense, since the preview mode is indeed very useful.
So I have a feature request for a future release:
Could you please add a preview option of the announcement in the MCP, too?

[mrmax79]

Just installed ACP Announcement Centre 1.2.0,
All went smooth, no errors, the ACP Announcement Centre 1.2.0 GPI is under .MODS Tab in ACP.

PROBLEM IT DOESN'T SHOW ANYTHING ON MAIN PAGE.

i HAVE REVIEWED EVERYTHING BUT AM SERIOUSLY TIRED. So errors are possible.

Here is a list of the files edits (click on them to verify they are correct..

common.php
constants.php
functions.php
functions_posting.php
index_php.txt

Announcement Centre
Configuration

/phpbb/language/en/posting.php didn't have the "find" parts so did not edit

Update: I just installed this in a clean new install of 3.0.5, no other mods no hacks.
I can't even get the .Mod to show like i did with my install above. These installs are on two different hosts.
The 2nd that doesn't even show .MOD, is with a subsilver2 style. I am using that one since it is the base for Getaway-Green my preferred style. I don't get why there are several edits necessary for prosilver but no edits required for subsilver2, asside from copying the subsilver2 files provided in the mod pack.

** Sorry for the bad links, I was half asleep with I created this post**

[Voyeurette]

Thank you iftitaj. I FINALLY got it working ( not exactly sure how - trial and error and your help ).

I was under the impression that if you used the "automod" feature, then you did not have to go into the browser and complete any installation.

What exactly does the automod do then? Does it only do partial installs for some things?

I'm just curious to know. Am new to all this.

[iftitaj]

What exactly does the automod do then? Does it only do partial installs for some things?.

Automod will only edit files .......... it can't run SQL & DIY part of the installation instruction as far as I know ..... though haven't tried it yet. I guess it can purge cache, etc though.
Its Lefty's niceness that he made install.php script which do the ACP integration part and run SQL also. Other option is to do it manually from the DIY part of the installation instructions. I did that manually since when I installed this MOD, no such script exists.