[MODDB] ACP Announcement Centre 1.2.0

A place for MOD Authors to post and receive feedback on MODs still in development. No MODs within this forum should be used within a live environment!
Suggested Hosts
Locked
baloo
Registered User
Posts: 70
Joined: Mon Feb 11, 2008 12:32 pm

Re: [Beta] ACP Announcement Centre 1.1.3

Post by baloo »

OK, I'll give that another shot then, thanks
gardensgrey
Registered User
Posts: 21
Joined: Sat Sep 22, 2007 5:15 am

Re: [Beta] ACP Announcement Centre 1.1.3

Post by 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!! :mrgreen:', 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!! :wink:', 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!!
User avatar
lefty74
Registered User
Posts: 3649
Joined: Wed Sep 14, 2005 8:26 pm
Location: NL
Contact:

Re: [Beta] ACP Announcement Centre 1.1.3

Post by lefty74 »

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

can you see the column 'announcement_forum_id' in the database?
lefty74
zoocrew.eu - help us save our wildlife
My MODS | Due to lack of time I unfortunately am unable to work on my mods anymore, anyone who has ideas to improve them and would like to take any of them over, please PM me.
gardensgrey
Registered User
Posts: 21
Joined: Sat Sep 22, 2007 5:15 am

Re: [Beta] ACP Announcement Centre 1.1.3

Post by 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!
User avatar
lefty74
Registered User
Posts: 3649
Joined: Wed Sep 14, 2005 8:26 pm
Location: NL
Contact:

Re: [Beta] ACP Announcement Centre 1.1.3

Post by 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...
lefty74
zoocrew.eu - help us save our wildlife
My MODS | Due to lack of time I unfortunately am unable to work on my mods anymore, anyone who has ideas to improve them and would like to take any of them over, please PM me.
gardensgrey
Registered User
Posts: 21
Joined: Sat Sep 22, 2007 5:15 am

Re: [Beta] ACP Announcement Centre 1.1.3

Post by 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!
User avatar
lefty74
Registered User
Posts: 3649
Joined: Wed Sep 14, 2005 8:26 pm
Location: NL
Contact:

Re: [Beta] ACP Announcement Centre 1.1.3

Post by lefty74 »

you are welcome, glad its working for you now :)
lefty74
zoocrew.eu - help us save our wildlife
My MODS | Due to lack of time I unfortunately am unable to work on my mods anymore, anyone who has ideas to improve them and would like to take any of them over, please PM me.
Artack
Registered User
Posts: 312
Joined: Thu Feb 07, 2008 11:26 pm

Re: [Beta] ACP Announcement Centre 1.1.3

Post by Artack »

If announcments turn on, in profile , under avatar appear image Image
What's wrong?)
User avatar
lefty74
Registered User
Posts: 3649
Joined: Wed Sep 14, 2005 8:26 pm
Location: NL
Contact:

Re: [Beta] ACP Announcement Centre 1.1.3

Post by lefty74 »

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

thanks
lefty74
zoocrew.eu - help us save our wildlife
My MODS | Due to lack of time I unfortunately am unable to work on my mods anymore, anyone who has ideas to improve them and would like to take any of them over, please PM me.
pieterbas
Registered User
Posts: 106
Joined: Mon Feb 04, 2008 7:39 pm

Re: [Beta] ACP Announcement Centre 1.1.3

Post by 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
User avatar
lefty74
Registered User
Posts: 3649
Joined: Wed Sep 14, 2005 8:26 pm
Location: NL
Contact:

Re: [Beta] ACP Announcement Centre 1.1.3

Post by lefty74 »

pieterbas wrote: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
lefty74
zoocrew.eu - help us save our wildlife
My MODS | Due to lack of time I unfortunately am unable to work on my mods anymore, anyone who has ideas to improve them and would like to take any of them over, please PM me.
Artack
Registered User
Posts: 312
Joined: Thu Feb 07, 2008 11:26 pm

Re: [Beta] ACP Announcement Centre 1.1.3

Post by Artack »

lefty74 wrote: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... :roll:

If choose show only index, everything ok
If on all pages, in profile under avatar (not viewtopic) appear that image :)
User avatar
lefty74
Registered User
Posts: 3649
Joined: Wed Sep 14, 2005 8:26 pm
Location: NL
Contact:

Re: [Beta] ACP Announcement Centre 1.1.3

Post by 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
lefty74
zoocrew.eu - help us save our wildlife
My MODS | Due to lack of time I unfortunately am unable to work on my mods anymore, anyone who has ideas to improve them and would like to take any of them over, please PM me.
User avatar
DragonMaster1
Registered User
Posts: 994
Joined: Tue Aug 17, 2004 11:04 am
Name: Terry
Contact:

Re: [Beta] ACP Announcement Centre 1.1.3

Post by 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 :idea:
User avatar
lefty74
Registered User
Posts: 3649
Joined: Wed Sep 14, 2005 8:26 pm
Location: NL
Contact:

Re: [Beta] ACP Announcement Centre 1.1.3

Post by 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);
 
lefty74
zoocrew.eu - help us save our wildlife
My MODS | Due to lack of time I unfortunately am unable to work on my mods anymore, anyone who has ideas to improve them and would like to take any of them over, please PM me.
Locked

Return to “[3.0.x] MODs in Development”