|
|
|
|
| Author |
Messages |
|
Lee Sykes
Gold Membership
Ventrian Active Member
Posts:48
 |
| 7/12/2007 12:14 AM |
|
Hello,
Here's one for you to check out and see if it is occurring on your site.
I have a handful of subscribers who have made one payment but the site has given them several years access. - The most is 4 years!
I've run the following query:
SELECT * FROM UserRoles
WHERE ExpiryDate > '2009-01-01 00:00:00.000'
and I have a couple that expire in 2011.
I've then run:
SELECT Users.UserID, Username, FirstName, LastName, Email, UserRoles.RoleID, Roles.RoleName
FROM Users INNER JOIN
UserRoles ON Users.UserID = UserRoles.UserID INNER JOIN
Roles ON UserRoles.RoleID = Roles.RoleID
WHERE (Users.UserID = 1000)
To extract the details and research the users who have these extended subscriptions. - They have only paid for one year, but somehow they have an extended expiry date.
It may be worth running these queries to see if you also have similar results.
Thanks,
Lee |
|
Lee Sykes - DNN Creative Magazine |
|
|
Scott McCulloch
Administrators
Ventrian Master
Posts:17204
|
| 7/12/2007 4:19 AM |
|
| Hmm, I have a few users who match this criteria, only a couple though. |
|
Scott McCulloch
Site Administrator |
|
|
|
| You are not authorized to post a reply. |
|
|
|
ActiveForums 3.7
|
|
|