Information > DNN Blog
DotNetNuke Blog

Current Articles | | Search |

Events Module - LastUpdatedBy

Just been through and added the userid of the user who last update an event to the Events table. I needed this for my RSS feed, since it kept showing the creator had posted a change, when they hadn't. So, useful for me, but probably also useful for others.

The data is stored in LastUpdatedID, but the EventsSave, EventsGet and EventsGetByRange sprocs also return LastUpdatedBy which is the DisplayName of the user. I did this because this is what is returned for the CreatedBy user. So just for consistency.

Required changes:

  • Events Table - where I set the initial value equal to the CreatedBy field. Done via SQLDataprovider 4.1.0
  • SPROCS - Updated EventsSave, EventsGet and EventsGetByRange. Done via SQLDataprovider 4.1.0
  • SQLDataProvider.vb - to add the two columns
  • DataProvider.vb - to add the two columns
  • EventInfo.vb - to add the two attritbutes to EventInfo Class
  • EventController.vb - to add the two columns
  • EditEvents.vb - to allocated current user userid to LastUpdatedID when saving

posted @ 07 August 2008 11:39 by Roger Selwyn

Previous Page | Next Page

COMMENTS

Name (required)

Email (required)

Website

CAPTCHA image
Enter the code shown above in the box below