[Sitr-general] Announcement FIx

[Dominik K. <Dom...@Fe...>]

Hi,

announcement modification seemed to be a bit buggy.

2.02 could not even create more than one, although it suggested to add one.
Just installed 2.06 - now it seems one can actually create more than one 
announcement, but when modifying, in any case the first one's text is 
displayed in the textbox.

You can correct this by modifying the SQL Statement in 
form_modify_announcement.php
All you have to do is add this line:
AND sys_announcement.announcement_id = ".$announcement_id."

This will get you the correct text into the textbox when editing an 
announcement because now you take reference to the announcement you 
actually want to modify.

The complete statement here looks like this now:

############
$query = "SELECT * FROM sys_announcement, sys_announcement_group, 
sys_account, sys_account_group WHERE 
sys_announcement.announcement_id = 
sys_announcement_group.announcement_group_announcement_id
AND sys_account.account_id = sys_account_group.account_group_account_id 
AND   sys_announcement_group.announcement_group_group_id = 
sys_account_group.account_group_group_id
AND sys_announcement.announcement_creator = sys_account.account_id 
           AND sys_announcement.announcement_id = ".$announcement_id." 
                    GROUP BY announcement_id";
############

Regards,
Dominik