Ok, so how do I do these?

I must say I'm frustrated with the answering from the Dotnetnuke Forums. They do not understand what someone wants. What they care is that the answer is as short and as vague as possible. I think you're the only one who answers our questions with real attention.

Ok, so here are my 2 questions:

1. Regarding validation: (I was told to create a custom validation but I don't know how to create it at all)

• Disallow users to use space in their usernames. That means username "Peter Parker" is not permitted.
• Allow symbols such as "_", "-", "." in Child Portal's aliases. I think restricting these is nonsense since a lot of people name their website "john_woo" or "john.woo"...

2. Regarding Reports module:

          I want to display the total page views of the current portal. The code must be dynamically generated based on the portal it is on.

Best regards, John. I appreciate your commitment.

Duc Le

I've found the solution for #1:

In Signup.ascx.vb, change to these (modifications are yellow highlighted):

For intCounter = 1 To txtPortalName.Text.Length
                            If InStr(1, "abcdefghijklmnopqrstuvwxyz0123456789-_.", Mid(txtPortalName.Text, intCounter, 1)) = 0 Then
                                strMessage &= "
" & Localization.GetString("InvalidName", Me.LocalResourceFile)
                            End If

and

Dim strValidChars As String = "abcdefghijklmnopqrstuvwxyz0123456789-_."
                        If Not blnChild Then
                            strValidChars += "./:"
                        End If

You'll be able to create aliases such as "spider_man" or "spider.man"

That's ok, John. I understand your situation.

I'm trying to use SQL View from DnnStuff. It allows [dnn:portalid] to be used in the reports. Can you give me a query to get the REQUEST count for the current portal? I really suck at SQL.

1 more thing. The {objectQualifier}Portals.PortalName only returns the portal titles. Is there a way to return portal aliases?

Here's a query that will give you the name and the number of Requests recorded in the SiteLog for Portal 0

SELECT     COUNT(SiteLog.SiteLogId) AS RequestCount , Portals.PortalName
FROM         SiteLog INNER JOIN
                      Portals ON SiteLog.PortalId = Portals.PortalID
WHERE     (SiteLog.PortalId = 0)
GROUP BY Portals.PortalName

To use your Token it would be

SELECT     COUNT(SiteLog.SiteLogId) AS RequestCount , Portals.PortalName
FROM         SiteLog INNER JOIN
                      Portals ON SiteLog.PortalId = Portals.PortalID
WHERE     (SiteLog.PortalId = [dnn:portalid])
GROUP BY Portals.PortalName

Thanks man! Works like a charm.