No announcement yet.

Subscriptionlog import data table question

  • Filter
  • Time
  • Show
Clear All
new posts

  • Subscriptionlog import data table question

    Im trying to rebuild my subscriptions as they were wiped out by a hacker. The number of subscriptions is there but the actual subscriptions are not.

    I was able to download the subscriptionlog table from the database which shows information including regdate and expiry date, but I cannot understand the data. Here's a sample below.

    I dont understand how to decipher what the subscription begin and end date is from those numbers. Im just looking for ANY way to restore the subscription, even if I have to manually re-enter them one at a time.

    Can you do a user lookup by userid too in the admincp?

                          subscriptionlogid    subscriptionid   userid   pusergroupid   status   regdate   expirydate   importsubscriptionlogid       1   1   1554   2   0   1141707480   1145678280   0   
          2   1   1569   2   1   1143760080   1145657280   0   
          3   1   3209   2   0   1144481040   1146036240   0
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.