Need a query for sql.. please

[andrewy3k]

Okay my subscriptions for vbulletin got screwed up.. by accident I set my server's time to 2008 instead of 2007.. long story.. but stupid mistake.. thus causing all my subscriptions to think they were expired..

long story short.. I used these 2 query's..

UPDATE subscriptionlog
SET status = 1
WHERE subscriptionid = 1

UPDATE subscriptionlog
SET status = 1
WHERE subscriptionid = 2

to reactivate all my subscriptions as active again.. But even though the date was properly set the subscriptions did not fix obviously and now ALL my paying members were downgraded from VIP to regular members..

now I know its probably unlikely I can get the subscriptions working properly again.. or is there?

but is there a query I can run to get my 1000 active subscription member over to VIP usergroup from member usergroup.. instead of doing it 1 by 1 ..

Please help, I am in need of this help seriously.. thanks..

[Andrew Green]

Did you try running the scheduled task "Subscriptions"?

(I've not really ever looked at the subscription system so you might need to do more, but that might do it)

[andrewy3k]

Okay I solved the issue.. by simply editing each user's subscription it fixed itself..