RE: [Mrbs-general] Problems with editing events

[John S. <js...@lc...>]

> -----Original Message-----
> From: mrb...@li... 
> [mailto:mrb...@li...] On Behalf 
> Of John Stein
> Sent: Friday, July 19, 2002 9:02 AM
> To: mrb...@li...
> Subject: [Mrbs-general] Problems with editing events
> 
> 
> If I try to edit an event that occurs in a room that is not 
> in the first
> area, edit_entry.php does not list the rooms for that area.  
> Thus, when
> I make the changes and click "Save," I get the following error and the
> event is lost (probably hiding in the database without a room number):
> 
> Warning: Invalid argument supplied for foreach() in
> /var/www/html/mrbs/edit_entry_handler.php on line 112
> 
> Warning: Invalid argument supplied for foreach() in
> /var/www/html/mrbs/edit_entry_handler.php on line 140
> 
> Warning: Cannot add header information - headers already sent 
> by (output
> started at /var/www/html/mrbs/edit_entry_handler.php:112) in
> /var/www/html/mrbs/edit_entry_handler.php on line 169
> 
> >From what I can tell, when going to edit_entry.php from 
> view_entry.php,
> the $area id gets lost, so it looks for get_default_area(), which
> happens to be the first on my list.  I saw a posting in the message
> archives concerning this problem, but I can't find the area 
> of the code
> referenced.
> 
> Any ideas how to fix this?
> 
> John Stein
> Webmaster
> Lincoln Christian College and Seminary
> http://www.lccs.edu
> 100 Campus View Dr.
> Lincoln IL 62656

I fixed it after playing with the SQL and such.  In edit_event.php, I
changed the SQL statement beginning with line 42 to read:
          $sql = "select mrbs_entry.name, mrbs_entry.create_by,
mrbs_entry.description,
          mrbs_entry.start_time, mrbs_entry.end_time -
mrbs_entry.start_time,
          mrbs_entry.type, mrbs_entry.room_id, mrbs_entry.entry_type,
          mrbs_entry.repeat_id, mrbs_room.area_id from mrbs_entry,
mrbs_room
          where mrbs_entry.id=$id and mrbs_room.id=mrbs_entry.room_id";

This allows the SQL to pull the area id from the table as well.

I then added a new line (now at line 71) after $rep_id = $row[8];:

  $area = $row[9];

To have the current room selected automatically, I changed $room to
$room_id on what is now line 245.

Now, it all seems to work!

John Stein
Webmaster
Lincoln Christian College and Seminary
http://www.lccs.edu
100 Campus View Dr.
Lincoln IL 62656