|
|
|
|
| Author |
Messages |
|
Kevin Fabrizio
Registered Users
Ventrian Super Newbie
Posts:15
 |
| 3/26/2007 8:45 AM |
|
| Is there a way to manually change the End Date for a receipt? Better yet, is there a way to run a script (sql query?) to change the end date for all people within a certain date range? For exampe, I want to change all users with an end date of Oct 1 2007 or later to March 31 2008. I would also like to change the end date date of Sep 30 2007 or ealier to March 31 2007. |
|
|
|
|
Scott McCulloch
Administrators
Ventrian Master
Posts:17150
|
| 3/27/2007 7:14 AM |
|
Not currently through the screens, although it would be a simple script to do it.
The problem with allowing direct edit of a receipt, is if there are receipts after it, you would need adjust the start/end dates after it as well. |
|
Scott McCulloch
Site Administrator |
|
|
Kevin Fabrizio
Registered Users
Ventrian Super Newbie
Posts:15
|
| 3/27/2007 11:19 AM |
|
Since I am not familiar with building a SQL script (I am not a programmer) and it "would be a simple script to do it" could you or anyone else on these boards help me out?
Thanks! |
|
|
|
|
Scott McCulloch
Administrators
Ventrian Master
Posts:17150
|
| 3/27/2007 7:22 PM |
|
Sure, you would need to run 2 queries.
One that would run for the receipt table would be:-
UPDATE dnn_DnnForge_SubscriptionTools_Receipt SET DateEnd = [SOMEDATE] WHERE DateStart > [STARTDATE] and DateStart < [ENDDATE]
For the roles, it's a bit more trickier, as you will need to also update those for that range, but it would be something like:-
UPDATE dnn_UserRoles Set ExpiryDate = [NEWEXPIRYDATE] WHERE RoleID = [YOURROLE] |
|
Scott McCulloch
Site Administrator |
|
|
Scott McCulloch
Administrators
Ventrian Master
Posts:17150
|
| 3/27/2007 7:23 PM |
|
| One further thing, if your not that good at SQL, you may want to manually do it through the table |
|
Scott McCulloch
Site Administrator |
|
|
|
| You are not authorized to post a reply. |
|
|
|
ActiveForums 3.7
|
|
|