West, Jeff | 2 Feb 16:18 2010

Tracking Deletions for database

Is there any way I could tell through the system whether or not someone deleted a record?    We had a reservation for a room and it suddenly went missing.   Right now, I have 5 people that can make changes to the system.    The rest of my faculty and staff must make requests for room reservations via e-mail to these 5 people.

 

 

------------------------------------------------------------------------------
The Planet: dedicated and managed hosting, cloud storage, colocation
Stay online with enterprise data centers and the best network in the business
Choose flexible plans and management services without long-term contracts
Personal 24x7 support from experience hosting pros just a phone call away.
http://p.sf.net/sfu/theplanet-com
_______________________________________________
mrbs-general mailing list
mrbs-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mrbs-general
Want to unsubscribe: mailto:mrbs-general-request <at> lists.sourceforge.net?subject=unsubscribe
Campbell Morrison | 2 Feb 22:44 2010
Picon

Re: Tracking Deletions for database

Not retrospectively, no.     Even if you had email notifications enabled, you still wouldn’t know as the system doesn’t tell you who actually deleted an entry.   But it would be easy to add that detail to the delete notification email.

 

Campbell

 

 

 

From: West, Jeff [mailto:jwest <at> mail.barry.edu]
Sent: 02 February 2010 15:18
To: mrbs-general <at> lists.sourceforge.net
Subject: [MRBS-general] Tracking Deletions for database

 

Is there any way I could tell through the system whether or not someone deleted a record?    We had a reservation for a room and it suddenly went missing.   Right now, I have 5 people that can make changes to the system.    The rest of my faculty and staff must make requests for room reservations via e-mail to these 5 people.

 

 

------------------------------------------------------------------------------
The Planet: dedicated and managed hosting, cloud storage, colocation
Stay online with enterprise data centers and the best network in the business
Choose flexible plans and management services without long-term contracts
Personal 24x7 support from experience hosting pros just a phone call away.
http://p.sf.net/sfu/theplanet-com
_______________________________________________
mrbs-general mailing list
mrbs-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mrbs-general
Want to unsubscribe: mailto:mrbs-general-request <at> lists.sourceforge.net?subject=unsubscribe
West, Jeff | 2 Feb 23:03 2010

Tracking Deletions for database

Campbell,

 

Thanks for your response.   If we turned on e-mail notification, would it be possible for the person who originally created the reservation to receive an e-mail when another user deleted the reservation, along with the name of the person that deleted it?

 

 

From: Campbell Morrison [mailto:mail <at> campbellmorrison.co.uk]
Sent: Tuesday, February 02, 2010 4:45 PM
To: 'General purpose list (support/developers/users)'
Subject: Re: [MRBS-general] Tracking Deletions for database

 

Not retrospectively, no.     Even if you had email notifications enabled, you still wouldn’t know as the system doesn’t tell you who actually deleted an entry.   But it would be easy to add that detail to the delete notification email.

 

Campbell

 

 

 

From: West, Jeff [mailto:jwest <at> mail.barry.edu]
Sent: 02 February 2010 15:18
To: mrbs-general <at> lists.sourceforge.net
Subject: [MRBS-general] Tracking Deletions for database

 

Is there any way I could tell through the system whether or not someone deleted a record?    We had a reservation for a room and it suddenly went missing.   Right now, I have 5 people that can make changes to the system.    The rest of my faculty and staff must make requests for room reservations via e-mail to these 5 people.

 

 

------------------------------------------------------------------------------
The Planet: dedicated and managed hosting, cloud storage, colocation
Stay online with enterprise data centers and the best network in the business
Choose flexible plans and management services without long-term contracts
Personal 24x7 support from experience hosting pros just a phone call away.
http://p.sf.net/sfu/theplanet-com
_______________________________________________
mrbs-general mailing list
mrbs-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mrbs-general
Want to unsubscribe: mailto:mrbs-general-request <at> lists.sourceforge.net?subject=unsubscribe
Anselm Martin Hoffmeister | 2 Feb 22:54 2010
Picon

Re: Tracking Deletions for database

Hi Jeff,

Am Dienstag, den 02.02.2010, 15:18 +0000 schrieb West, Jeff:
> Is there any way I could tell through the system whether or not
> someone deleted a record?    We had a reservation for a room and it
> suddenly went missing.   Right now, I have 5 people that can make
> changes to the system.    The rest of my faculty and staff must make
> requests for room reservations via e-mail to these 5 people.

you might find out when and amongst which other actions it happened if
you have a webserver access log. This might be quite boring to track
down, but I think you should be able to find out there. You might create
a fake record and delete that to see which strings to "grep" for...

BR
Anselm

------------------------------------------------------------------------------
The Planet: dedicated and managed hosting, cloud storage, colocation
Stay online with enterprise data centers and the best network in the business
Choose flexible plans and management services without long-term contracts
Personal 24x7 support from experience hosting pros just a phone call away.
http://p.sf.net/sfu/theplanet-com
_______________________________________________
mrbs-general mailing list
mrbs-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mrbs-general
Want to unsubscribe: mailto:mrbs-general-request <at> lists.sourceforge.net?subject=unsubscribe

Campbell Morrison | 2 Feb 23:29 2010
Picon

Re: Tracking Deletions for database

Not as MRBS stands at the moment, but it’s a very simple change (one or two lines).   If you’ve any knowledge of PHP you should be able to do it – the code that needs to be changed is in the function notifyAdminOnDelete() in functions_mail.inc.    Just add a line along the lines of

 

$user = getUserName();

$body .= "Deleted by: $user\n";

 

In the section where it says “Displays deleted entry details”.

 

I’ll check a proper enhancement that worries about internationalisation into the trunk next week.   But in the meantime the above should do what you want and the deleter’s name will appear in the message details that are sent to whoever normally gets email notifications.

 

Campbell

 

 

From: West, Jeff [mailto:jwest <at> mail.barry.edu]
Sent: 02 February 2010 22:03
To: mail <at> campbellmorrison.co.uk; General purpose list (support/developers/users)
Cc: Debbarh, Brigitte; Ahlers, Glen-Peter
Subject: [MRBS-general] Tracking Deletions for database

 

Campbell,

 

Thanks for your response.   If we turned on e-mail notification, would it be possible for the person who originally created the reservation to receive an e-mail when another user deleted the reservation, along with the name of the person that deleted it?

 

 

From: Campbell Morrison [mailto:mail <at> campbellmorrison.co.uk]
Sent: Tuesday, February 02, 2010 4:45 PM
To: 'General purpose list (support/developers/users)'
Subject: Re: [MRBS-general] Tracking Deletions for database

 

Not retrospectively, no.     Even if you had email notifications enabled, you still wouldn’t know as the system doesn’t tell you who actually deleted an entry.   But it would be easy to add that detail to the delete notification email.

 

Campbell

 

 

 

From: West, Jeff [mailto:jwest <at> mail.barry.edu]
Sent: 02 February 2010 15:18
To: mrbs-general <at> lists.sourceforge.net
Subject: [MRBS-general] Tracking Deletions for database

 

Is there any way I could tell through the system whether or not someone deleted a record?    We had a reservation for a room and it suddenly went missing.   Right now, I have 5 people that can make changes to the system.    The rest of my faculty and staff must make requests for room reservations via e-mail to these 5 people.

 

 

------------------------------------------------------------------------------
The Planet: dedicated and managed hosting, cloud storage, colocation
Stay online with enterprise data centers and the best network in the business
Choose flexible plans and management services without long-term contracts
Personal 24x7 support from experience hosting pros just a phone call away.
http://p.sf.net/sfu/theplanet-com
_______________________________________________
mrbs-general mailing list
mrbs-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mrbs-general
Want to unsubscribe: mailto:mrbs-general-request <at> lists.sourceforge.net?subject=unsubscribe
Hansen, Frances V | 2 Feb 23:33 2010
Picon

re changing times in meeting room booking system

Hi

 

We have altered the period times here but I don’t know how to alter the times in the program. Could you please send me documentation that will help me alter these times?

 

Regards

 

 

Frances Hansen

ICT Support

Maryborough Education Centre

102 Balaclava Rd  Maryborough 3465

Phone: (03) 54617900

Direct: (03) 54617985

Fax: (03) 54613508

Email: hansen.frances.v <at> edumail.vic.gov.au

 

Important - This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education and Early Childhood Development.

------------------------------------------------------------------------------
The Planet: dedicated and managed hosting, cloud storage, colocation
Stay online with enterprise data centers and the best network in the business
Choose flexible plans and management services without long-term contracts
Personal 24x7 support from experience hosting pros just a phone call away.
http://p.sf.net/sfu/theplanet-com
_______________________________________________
mrbs-general mailing list
mrbs-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mrbs-general
Want to unsubscribe: mailto:mrbs-general-request <at> lists.sourceforge.net?subject=unsubscribe
Stringham, Steven | 2 Feb 23:32 2010

Re: Tracking Deletions for database

Any chance of adding a transaction log to the project? Any add/moves/deletes/changes to the transaction log. It need not be a log that is able to be replayed, but just reviewed by the administrator. Who, what IP, transaction type, description of change....
 

From: Campbell Morrison [mailto:mail <at> campbellmorrison.co.uk]
Sent: Tuesday, February 02, 2010 3:30 PM
To: 'General purpose list (support/developers/users)'
Cc: 'Debbarh, Brigitte'; 'Ahlers,Glen-Peter'
Subject: Re: [MRBS-general] Tracking Deletions for database

Not as MRBS stands at the moment, but it’s a very simple change (one or two lines).   If you’ve any knowledge of PHP you should be able to do it – the code that needs to be changed is in the function notifyAdminOnDelete() in functions_mail.inc.    Just add a line along the lines of

 

$user = getUserName();

$body .= "Deleted by: $user\n";

 

In the section where it says “Displays deleted entry details”.

 

I’ll check a proper enhancement that worries about internationalisation into the trunk next week.   But in the meantime the above should do what you want and the deleter’s name will appear in the message details that are sent to whoever normally gets email notifications.

 

Campbell

 

 

From: West, Jeff [mailto:jwest <at> mail.barry.edu]
Sent: 02 February 2010 22:03
To: mail <at> campbellmorrison.co.uk; General purpose list (support/developers/users)
Cc: Debbarh, Brigitte; Ahlers, Glen-Peter
Subject: [MRBS-general] Tracking Deletions for database

 

Campbell,

 

Thanks for your response.   If we turned on e-mail notification, would it be possible for the person who originally created the reservation to receive an e-mail when another user deleted the reservation, along with the name of the person that deleted it?

 

 

From: Campbell Morrison [mailto:mail <at> campbellmorrison.co.uk]
Sent: Tuesday, February 02, 2010 4:45 PM
To: 'General purpose list (support/developers/users)'
Subject: Re: [MRBS-general] Tracking Deletions for database

 

Not retrospectively, no.     Even if you had email notifications enabled, you still wouldn’t know as the system doesn’t tell you who actually deleted an entry.   But it would be easy to add that detail to the delete notification email.

 

Campbell

 

 

 

From: West, Jeff [mailto:jwest <at> mail.barry.edu]
Sent: 02 February 2010 15:18
To: mrbs-general <at> lists.sourceforge.net
Subject: [MRBS-general] Tracking Deletions for database

 

Is there any way I could tell through the system whether or not someone deleted a record?    We had a reservation for a room and it suddenly went missing.   Right now, I have 5 people that can make changes to the system.    The rest of my faculty and staff must make requests for room reservations via e-mail to these 5 people.

 

 


----
For more information about Lewis and Roca LLP, please go to
www.lewisandroca.com.

Phoenix (602) 262-5311
Tucson (520) 622-2090
Las Vegas (702) 949-8200
Reno (775) 823-2900
Minden (775) 586-9500
Albuquerque (505) 764-5400
Silicon Valley (650) 391-1380

This message is intended only for the use of the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the sender of this E-Mail by return E-Mail or by telephone.

In accordance with Internal Revenue Service Circular 230, we advise you that if this email contains any tax advice, such tax advice was not intended or written to be used, and it cannot be used, by any taxpayer for the purpose of avoiding penalties that may be imposed on the taxpayer.

------------------------------------------------------------------------------
The Planet: dedicated and managed hosting, cloud storage, colocation
Stay online with enterprise data centers and the best network in the business
Choose flexible plans and management services without long-term contracts
Personal 24x7 support from experience hosting pros just a phone call away.
http://p.sf.net/sfu/theplanet-com
_______________________________________________
mrbs-general mailing list
mrbs-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mrbs-general
Want to unsubscribe: mailto:mrbs-general-request <at> lists.sourceforge.net?subject=unsubscribe
hamada Caspy | 3 Feb 10:53 2010
Picon

log off time out


Hey
is there a way to set the log off time out coz everytime i start the mrbs on my computer i find myself logged in.

Hotmail: Free, trusted and rich email service. Get it now.
------------------------------------------------------------------------------
The Planet: dedicated and managed hosting, cloud storage, colocation
Stay online with enterprise data centers and the best network in the business
Choose flexible plans and management services without long-term contracts
Personal 24x7 support from experience hosting pros just a phone call away.
http://p.sf.net/sfu/theplanet-com
_______________________________________________
mrbs-general mailing list
mrbs-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mrbs-general
Want to unsubscribe: mailto:mrbs-general-request <at> lists.sourceforge.net?subject=unsubscribe
Picon
Picon

Re: re changing times in meeting room booking system

On 02/02/10 22:33, Hansen, Frances V wrote:
> Hi
> 
>  
> 
> We have altered the period times here but I don’t know how to alter the
> times in the program. Could you please send me documentation that will
> help me alter these times?

You only need to change the entries in config.inc.php that start
$periods[]. Beware that changing the period names or number of periods
will change all bookings in the past.

Cheers,

John.

--

-- 
John Beranek - MRBS Developer <http://mrbs.sourceforge.net/>

To generalise is to be an idiot.
  -- William Blake

------------------------------------------------------------------------------
The Planet: dedicated and managed hosting, cloud storage, colocation
Stay online with enterprise data centers and the best network in the business
Choose flexible plans and management services without long-term contracts
Personal 24x7 support from experience hosting pros just a phone call away.
http://p.sf.net/sfu/theplanet-com
_______________________________________________
mrbs-general mailing list
mrbs-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mrbs-general
Want to unsubscribe: mailto:mrbs-general-request <at> lists.sourceforge.net?subject=unsubscribe
Picon
Picon

Re: log off time out

On 03/02/10 09:53, hamada Caspy wrote:
> 
> Hey
> is there a way to set the log off time out coz everytime i start the
> mrbs on my computer i find myself logged in.

You've failed at error/problem reporting.

No mention of which version of MRBS you are using. No mention of which
session scheme you are using. No mention of which authentication scheme
you are using.

If you're using MRBS 1.4.x and the 'cookie' session scheme, you'll need
to change $auth["session_cookie"]["session_expire_time"]. If you're
using the 'php' session scheme, you'll need to change
$auth["session_php"]["session_expire_time"].

Cheers,

John.

--

-- 
John Beranek - MRBS Developer <http://mrbs.sourceforge.net/>

To generalise is to be an idiot.
  -- William Blake

------------------------------------------------------------------------------
The Planet: dedicated and managed hosting, cloud storage, colocation
Stay online with enterprise data centers and the best network in the business
Choose flexible plans and management services without long-term contracts
Personal 24x7 support from experience hosting pros just a phone call away.
http://p.sf.net/sfu/theplanet-com
_______________________________________________
mrbs-general mailing list
mrbs-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mrbs-general
Want to unsubscribe: mailto:mrbs-general-request <at> lists.sourceforge.net?subject=unsubscribe


Gmane