Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Send an Email to a user after a specific time passes?

Discussion in 'Database Discussion' started by Majid Abu Rmelah, Apr 29, 2019.

  1. Majid Abu Rmelah

    Majid Abu Rmelah Member

    Joined:
    Apr 29, 2019
    Messages:
    5
    Likes Received:
    1
    Trophy Points:
    1
    Location:
    Kfar Yasif, Israel
    cPanel Access Level:
    Website Owner
    Hello everyone and best regards,

    To clarify the question, I have a table of users in my database on phpMyAdmin. Each time the user logs in, a column that is called "UserActivity" type DATETIME is updated in the table to the current date that the user logged in. Now, if the user did not log in for 15 days (half a month), he would receive an Email informing him to be active on my web site.

    How is this possible? Is it with using MySQL Scheduled Event? Or by using a web service?

    I would be really appreciated if you help me with this.

    Much Love,

    Majid Abu Rmelah.
     
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,331
    Likes Received:
    2,159
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello @Majid Abu Rmelah,

    This is likely a function built into the PHP script itself (or you may have a cron job setup to run a PHP script at set intervals). I recommend contacting the developer or support team for the specific script to ask about the exact method they use.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. Majid Abu Rmelah

    Majid Abu Rmelah Member

    Joined:
    Apr 29, 2019
    Messages:
    5
    Likes Received:
    1
    Trophy Points:
    1
    Location:
    Kfar Yasif, Israel
    cPanel Access Level:
    Website Owner
    Hey there, thank you for your replay.
    Where can I contact the developer or support team to help me with this?
     
  4. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,331
    Likes Received:
    2,159
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello @Majid Abu Rmelah,

    Do you know where you purchased or downloaded the script from? What is the script name? Was it a custom script that someone developed for you?

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. Majid Abu Rmelah

    Majid Abu Rmelah Member

    Joined:
    Apr 29, 2019
    Messages:
    5
    Likes Received:
    1
    Trophy Points:
    1
    Location:
    Kfar Yasif, Israel
    cPanel Access Level:
    Website Owner
    I use phpMyAdmin through WampServer. I downloaded it for free from their website.
     
  6. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,331
    Likes Received:
    2,159
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    phpMyAdmin is used to manage your MySQL databases and should already be available from within the cPanel UI (cPanel >> Home >> Databases >> phpMyAdmin).

    What's the name of the script you installed on your website that makes use of a MySQL database?

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  7. Majid Abu Rmelah

    Majid Abu Rmelah Member

    Joined:
    Apr 29, 2019
    Messages:
    5
    Likes Received:
    1
    Trophy Points:
    1
    Location:
    Kfar Yasif, Israel
    cPanel Access Level:
    Website Owner
    I have a localhost phpmyadmin through WampServer application.
     
  8. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,331
    Likes Received:
    2,159
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello @Majid Abu Rmelah,

    phpMyAdmin is used to manage your MySQL databases. You will need to identify the name of the script that utilizes the MySQL database (e.g. WordPress, Joomla), as opposed to identifying how the database is managed (e.g. phpMyAdmin).

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  9. Majid Abu Rmelah

    Majid Abu Rmelah Member

    Joined:
    Apr 29, 2019
    Messages:
    5
    Likes Received:
    1
    Trophy Points:
    1
    Location:
    Kfar Yasif, Israel
    cPanel Access Level:
    Website Owner
    After searching and digging on the internet, it seems like I asked the wrong question. What I need is Windows Task Scheduler.
    Thank you for your time and effort.

    Regards,
    Majid Abu Rmelah.
     
    cPanelMichael likes this.
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice