Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

AspDotNetStoreFront
  Ads  
 


  Sponsors  

Meet Our Sponsors

CrystalTech Web Hosting™
Webhost4life, specialists in DNN hosting
Mad Development is a full service interactive agency focusing on the merge of design, technology, e-commerce, and affiliate marketing by providing total website solutions.
AspDotNetStoreFront - E-Commerce by Design - The Leading ASP.NET shopping cart platform for developers!
SteadyRain
DataSprings - Great Ideas. Always Flowing.
 


DotNetNuke Forums
 
  Forum  DotNetNuke® Pro...  Users Online Mo...  GetUsersOnline in DNN 4.3.4
Previous Previous
 
Next Next
New Post 8/3/2006 3:35 PM
User is offline Mariette Knap
795 posts
www.smallbizserver.net
7th Ranked




GetUsersOnline in DNN 4.3.4 

I had such a nice solution to get the FirstName and LastName listed in the UsersOnline module in DNN 4.3.3:

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[GetOnlineUsers]

@PortalID int
AS
select
UsersOnline.UserID, Users.Firstname + ' ' + Users.LastName AS UserName
from UsersOnline, Users
where UsersOnline.PortalID = @PortalID
and UsersOnline.UserID = Users.UserID

And now in DNN 4.3.4 it is:

set ANSI_NULLS ON
set
QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[GetOnlineUsers]

@PortalID int
AS
SELECT

*
FROM UsersOnline UO
INNER JOIN vw_Users U ON UO.UserID = U.UserID
INNER JOIN UserPortals UP ON U.UserID = UP.UserId
WHERE UP.PortalID = @PortalID

How do I get the FirstName, LastName back?


Subscribe for great articles and howtos. Get unlimited access to all content.Mariëtte Knap
www.smallbizserver.net
 
New Post 8/3/2006 3:55 PM
User is offline Sebastian Leupold
15055 posts
www.deutschnetnuke.de
1st Ranked












Re: GetUsersOnline in DNN 4.3.4 
Modified By Sebastian Leupold  on 8/3/2006 6:25:16 PM)

To achieve your aim, run the following code from the sql interface in host menu (check execute script):

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE {DatabaseOwner}[{objectqualifier}GetOnlineUsers]

@PortalID int
AS
SELECT
TabID, CreationDate, LastActiveDate, U.UserID, U.PortalID, FirstName, LastName, Displayname, Displayname AS USerName, IsSuperUser, EMail, Authorised
FROM {objectqualifier}UsersOnline UO
INNER JOIN {objectqualifier}vw_Users U ON UO.UserID = U.UserID
WHERE UP.PortalID = @PortalID


Sebastian Leupold

DeutschNetNuke dnnWerk - The DotNetNuke Experts German DotNetNuke User-Group

DotNetNuke Project UserDefinedTable
DotNetNuke Project Release Tracker
 
New Post 8/3/2006 4:02 PM
User is offline Mariette Knap
795 posts
www.smallbizserver.net
7th Ranked




Re: GetUsersOnline in DNN 4.3.4 
That does not change anything ? Strange
Subscribe for great articles and howtos. Get unlimited access to all content.Mariëtte Knap
www.smallbizserver.net
 
New Post 8/3/2006 4:21 PM
User is offline Sebastian Leupold
15055 posts
www.deutschnetnuke.de
1st Ranked












Re: GetUsersOnline in DNN 4.3.4 
Please notice, that there is a risk in altering core sprocs, as they might be used in other places as well...
Sebastian Leupold

DeutschNetNuke dnnWerk - The DotNetNuke Experts German DotNetNuke User-Group

DotNetNuke Project UserDefinedTable
DotNetNuke Project Release Tracker
 
New Post 8/3/2006 4:29 PM
User is offline Mariette Knap
795 posts
www.smallbizserver.net
7th Ranked




Re: GetUsersOnline in DNN 4.3.4 
Yes, that procedure is also used in UserOnline in Admin -> UserAccounts. Your script does cause it to fail.
Subscribe for great articles and howtos. Get unlimited access to all content.Mariëtte Knap
www.smallbizserver.net
 
Previous Previous
 
Next Next
  Forum  DotNetNuke® Pro...  Users Online Mo...  GetUsersOnline in DNN 4.3.4
 


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, please observe the following posting guidelines:

1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.

 


Smart-Thinker
DNN Modules for Social Networks for as low as $69 for 6 modules! We also maintain the DotNetNuke Directory - http://DNNDir.com
www.smart-thinker.com
DNN Photo Gallery
Complete Photo Gallery Management!
www.dnnPhotoGallery.com
R2i - Delivering Serious DNN Services & Solutions
Award Winning Design, Skin construction, Custom Modules and Consulting Services for the Enterprise organization. R2i is the DNN:Map module Project Lead and one of the largest DNN service providers with offices in New York City, Virginia and Baltimore.
www.bi4ce.com

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP