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!

Newbie, Need help with simple script =)

Discussion in 'Database Discussion' started by Orsenfelt, Aug 7, 2008.

  1. Orsenfelt

    Orsenfelt Registered

    Joined:
    Aug 7, 2008
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    51
    Hi all, Let me start by saying that I am pretty much a total newbie when it comes to scripting etc, SO I think what I am trying to do is most likely very simple, I just can't get my head around it :D

    So, here is the situation.
    I'm working on a website idea of mine that is similar to the likes of Digg/Reddit in that the content is 'rated' up or down by the users.

    What I want to do is this.
    Create an automated script/cron job that will check the database for any content with a rating lower than say.. -25 and delete it. This will hopefully mean that any trash that gets voted way down will just get deleted =)

    The problem, I have no idea where to begin with this script.

    I think I am right in saying that I can set up the cron job in cPanel, I just point it to the script and set the time, right?
    After that.. I have no idea.


    Some extra info..

    The database is set up like so :

    table : DBName --> rash_quotes --> rating

    Thanks in advance for any help :D
     
    #1 Orsenfelt, Aug 7, 2008
  2. Infopro

    Infopro cPanel Sr. Product Evangelist Staff Member

    Joined:
    May 20, 2003
    Messages:
    16,736
    Likes Received:
    456
    Trophy Points:
    583
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    Indeed. Other than that, as far as the scripting of what you want to do, you'll do better on some other site that supports this sort of thing. cPanel forums is not the place for this though. What you want to do has nothing to do with cPanel other than the cron you can setup in your cPanel.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 Infopro, Aug 7, 2008
  3. phatrik

    phatrik Member

    Joined:
    Jul 27, 2008
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    51
    Location:
    Toronto, ON



    Plain and simple you need to learn SQL. I've never scripted SQL personally, but just from seeing a few examples, you need to look at something like:


    Select * from TABLE_NAME_CONTAINING_RATINGS where NAME_OF_ROW_CONTAINING_RATING < 25; COMMAND TO DELETE SELECTION


    I'm sure the above is no where near being accurate but what you're asking sounds pretty basic.


    Select MATCH_PATTERN from TABLENAME where CONDITION


    Is a pretty basic thing in MySQL. Once you've figured out the select query, you'll then have to figure out a way to delete the results. Good luck :)
     
    #3 phatrik, Aug 11, 2008
(You must log in or sign up to post here.)
Loading...
Similar Threads - Newbie Need help
  1. Roberto Lito

    SOLVED Need to access a website without entering domain

    Roberto Lito, Mar 17, 2019 at 10:32 PM, in forum: General Discussion
    Replies:
    3
    Views:
    130
    Roberto Lito
    Mar 18, 2019 at 9:38 PM
  2. OzyPhil

    Need help with removing hidden domain

    OzyPhil, Mar 8, 2019, in forum: General Discussion
    Replies:
    6
    Views:
    341
    OzyPhil
    Mar 11, 2019
  3. Kirsty Brown

    Email Migration - really need some advice!

    Kirsty Brown, Mar 7, 2019, in forum: E-mail Discussion
    Replies:
    1
    Views:
    296
    cPanelLauren
    Mar 8, 2019
  4. Forcerdj

    Unable to terminate account: API failure: Need “_removed_tls” set!

    Forcerdj, Feb 28, 2019, in forum: General Discussion
    Replies:
    1
    Views:
    219
    cPanelLauren
    Mar 1, 2019
  5. rupert49

    Do I need a server to hos a wordpress site or does that come with C-panel

    rupert49, Feb 22, 2019, in forum: General Discussion
    Replies:
    2
    Views:
    115
    cPanelLauren
    Feb 22, 2019

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.
    Accept Learn More...
    Dismiss Notice