[MODDB] ACP Announcement Centre 1.2.0

[baloo]

OK, I'll give that another shot then, thanks

[gardensgrey]

I'm not sure what I did wrong, but I get this error when I try to submit an announcement:

General Error
SQL ERROR [ mysql4 ]

Unknown column 'announcement_forum_id' in 'field list' [1054]

SQL

UPDATE phpbb_announcement_centre SET announcement_forum_id = 0, announcement_topic_id = 0, announcement_post_id = 0, announcement_gopost = 0, announcement_first_last_post = '', announcement_title = 'test', announcement_text = 'test', announcement_text_bbcode_uid = '', announcement_text_bbcode_bitfield = '', announcement_text_bbcode_options = 7, announcement_draft = '[color=red:31pz4sdz][b:31pz4sdz]Draft Announcements[/b:31pz4sdz][/color:31pz4sdz] can be seen here!! ', announcement_draft_bbcode_uid = '31pz4sdz', announcement_draft_bbcode_bitfield = 'Qg==', announcement_draft_bbcode_options = 7, announcement_title_guests = 'Guest Announcements', announcement_text_guests = '[color=green:3nivc2ft][b:3nivc2ft]Guest Announcements[/b:3nivc2ft][/color:3nivc2ft] can be seen here!! ', announcement_text_guests_bbcode_uid = '3nivc2ft', announcement_text_guests_bbcode_bitfield = 'Qg==', announcement_text_guests_bbcode_options = 7

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal_mysql->sql_error()

FILE: includes/acp/acp_announcements_centre.php
LINE: 124
CALL: dbal_mysql->sql_query()

FILE: includes/acp/acp_announcements_centre.php
LINE: 46
CALL: acp_announcements_centre->announcements()

FILE: includes/functions_module.php
LINE: 507
CALL: acp_announcements_centre->main()

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

I can see the announcement on the board, I just can't edit it--it just shows the default text.

I've refreshed everything and purged the cache. Any ideas? Thanks so much!!

[lefty74]

you didnt get any error messages when running the install/index.php?

can you see the column 'announcement_forum_id' in the database?

[gardensgrey]

I received one error that said that the phpbb_announcement_centre already existed, so I dropped the table and re-did the install/index.php again with no errors.

I do not have that column in my database. Here's what I have:

announcement_show
announcement_enable_guests
announcement_show_birthdays
announcement_birthday_avatar
announcement_draft
announcement_draft_bbcode_uid
announcement_draft_bbcode_bitfield
announcement_draft_bbcode_options
announcement_text
announcement_text_bbcode_uid
announcement_text_bbcode_bitfield
announcement_text_bbcode_options
announcement_text_guests
announcement_text_guests_bbcode_uid
announcement_text_guests_bbcode_bitfield
announcement_text_guests_bbcode_options
announcement_title
announcement_title_guests
announcement_show_group

Thanks again for your help-I'm excited to get it working!

[lefty74]

may i ask you to download version 1.1.3 again and upload the install folder one more time.

it does contain the 'announcement_forum_id' column so i am really surprised it does not include it for you...

[gardensgrey]

That did the trick! Thanks so much for your help and not making me feel stupid! LOL I thought about trying the install folder again, but didn't want to cause any more issues since I don't really know what I'm doing.


I love this mod-it works GREAT!

Thanks again!

[lefty74]

you are welcome, glad its working for you now

[Artack]

If announcments turn on, in profile , under avatar appear image
What's wrong?)

[lefty74]

could you post a screenshot pse. also, what other birthday mods do you have installed?

thanks

[pieterbas]

Hello lefty74,

Thank you for making this mod.
I now have a longer use of the work is easy and looks great!
Thank you so gives free!
I had a question:
in the version 1.0.3 is a function that the communications board also appeared at the top of each topic in this version I can not find.
Is this simply is not there or I see something on the head?

groetjes,
pieterbas


Dutch:

Heey lefty74,

Bedankt voor het maken van deze mod.
Ik maak er nu al een poos gebruik van het werkt erg makkelijk en ziet er mooi uit!
Bedankt dat je dit zo gratis geeft!
Ik had een vraagje:
in de versie 1.0.3 zit een functie dat het mededelingen bord ook te zien is bij elk topic boven aan ik kan in deze versie die niet vinden.
Zit deze er simpel weg niet in of zie ik iets over het hoofd?

groetjes,
pieterbas

[lefty74]

Hello lefty74,

Thank you for making this mod.
I now have a longer use of the work is easy and looks great!
Thank you so gives free!
I had a question:
in the version 1.0.3 is a function that the communications board also appeared at the top of each topic in this version I can not find.
Is this simply is not there or I see something on the head?

groetjes,
pieterbas

hi pieterbas,
the only function in 1.0.3a was if you only want to show the announcements on the index page or on all pages. that function is still available in 1.1.3

Show Announcements only on Index page: Yes No

[Artack]

could you post a screenshot pse. also, what other birthday mods do you have installed?

thanks

Prime Birthdate Require
Viewtopic Birthday

May be second mod...

If choose show only index, everything ok
If on all pages, in profile under avatar (not viewtopic) appear that image

[lefty74]

looks like both, this and the viewtopic birthday mod use the same variable for the birthday image.

i will correct htat in the next version

[DragonMaster1]

I just LOVE this mod

A slight suggestion.....

Would it be possible to set preferences as to what birthdays are shown when the birthday feature is activated?

The reason I ask is that many boards get a lot of users who don’t participate too much, and so to feature their birthday on the board when they seldom are even there, seems like a wasted moment to show them off to the whole board. As it is now, I have to turn it on/off as per coming user birthday so the ones who DO participate on the board feel like they are Special

Just a thought

[lefty74]

i dont think i will include that in the package.

if you want to show only selected user's birthdays, you can try the following:
open includes/functions_announcements.php

find

Code: Select all

    $birthday_list = $announcement_text = $announcement_birthday_img = '';
    if ($config['load_birthdays'] && $config['allow_birthdays'])
    {
        // Generate birthday list if required ...
        $now = getdate(time() + $user->timezone + $user->dst - date('Z'));
        $sql = 'SELECT user_id, username, user_colour, user_birthday, user_avatar, user_avatar_type, user_avatar_width, user_avatar_height
            FROM ' . USERS_TABLE . "
            WHERE user_birthday LIKE '" . $db->sql_escape(sprintf('%2d-%2d-', $now['mday'], $now['mon'])) . "%'
                AND user_type IN (" . USER_NORMAL . ', ' . USER_FOUNDER . ')';
        $result = $db->sql_query($sql);

 

replace with

Code: Select all

    $announcement_bd_user_id_ary = array(2,3); // fill the array with the user_id's of the users whose birthday you would like to show as announcement
    $birthday_list = $announcement_text = $announcement_birthday_img = '';
    if ($config['load_birthdays'] && $config['allow_birthdays'])
    {
        // Generate birthday list if required ...
        $now = getdate(time() + $user->timezone + $user->dst - date('Z'));
        $sql = 'SELECT user_id, username, user_colour, user_birthday, user_avatar, user_avatar_type, user_avatar_width, user_avatar_height
            FROM ' . USERS_TABLE . "
            WHERE user_birthday LIKE '" . $db->sql_escape(sprintf('%2d-%2d-', $now['mday'], $now['mon'])) . "%'
                AND user_type IN (" . USER_NORMAL . ', ' . USER_FOUNDER . ')
                AND ' . $db->sql_in_set('user_id', $announcement_bd_user_id_ary);

        $result = $db->sql_query($sql);