1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice

IMPORTANT Help needed

Discussion in 'Plesk for Linux - 8.x and Older' started by atomicmak, Jun 9, 2005.

  1. atomicmak

    atomicmak Guest

    I have one thing to know on Plesk Reloaded 7.5.3.

    the overall domains tab shows listing of domains with creation date. Can it possible to have expiry date also display there ?

    actually i more than 300 domains on my plesk and i would need to know the expiry date of all domins at once.

    can anyone help me out for this ?
  2. Gorgon@

    Gorgon@ Guest

    I don't see any way to do what you want in the CP. Maybe a direct query to the appropriate table in the database would get the info you want?

  3. atomicmak

    atomicmak Guest

    well i have downloaded sql of psa and looked for it but didnt find even
  4. jhobbs721

    jhobbs721 Guest

    SQL Statement to pull Domain Expirations

    The two main tables you need are 'domains' and 'Limits'. You'll need to join these guys in order to get the information you're after.

    The following SQL code will pull the Expiration entry for every domain in your domains table (whatever is configured). A value of -1 means there is no limit (i.e. Unlimited is checked!).
    select DOM.name, LIM.value
    from psa.domains DOM, psa.Limits LIM
    where (DOM.limits_id = LIM.id) and LIM.limit_name = 'expiration';
    This should get you the information you're after!

  5. atomicmak

    atomicmak Guest

    Thanks a lot buddy.

    | name | value |
    | domain1.com | 1174329000 |
    | domain2.com | 1142793000 |
    | domain3.com | 1128882600 |
    | domain4.com | 1128882600 |
    | domain5.biz | 1175365800 |
    | domain6.biz | 1175365800 |

    can you tell me why i see this kind of value ?

    does there any calculation to see the exact expiry date ?
  6. atomicmak

    atomicmak Guest

    domain1.com has this value set in controlpanel what it shows

    Resource Used Allowed
    Validity period June 10, 2005 Oct 1, 2005
  7. jhobbs721

    jhobbs721 Guest

    I'm not sure on that one, but I'd bet it is a timestamp of some sort. I'd be interested to find out myself...

    How about going into domain1.com, and extending their expiration date by 1 day? This would give you the delta for a full day, and would give you an idea of how much of a difference it makes.

    When I get back to my machine, I'll take a look myself...