Discover Habbo's history
Treat yourself with a Secret Santa gift.... of a random Wiki page for you to start exploring Habbo's history!
Happy holidays!
Celebrate with us at Habbox on the hotel, on our Forum and right here!
Join Habbox!
One of us! One of us! Click here to see the roles you could take as part of the Habbox community!


Page 2 of 2 FirstFirst 12
Results 11 to 18 of 18
  1. #11
    Join Date
    Apr 2006
    Location
    Leamington Spa
    Posts
    1,375
    Tokens
    72

    Latest Awards:

    Default

    No, Simon just e-bullies me.
    PHP Code:
    $time date("H:i");
    if(
    $time == "00:00"){
    $query mysql_query("TRUNCATE TABLE `table_name` ;");

    May've got that wrong.
    Last edited by lolwut; 01-11-2007 at 08:00 PM.
    i've been here for over 8 years and i don't know why

  2. #12
    Join Date
    May 2007
    Location
    Nebo, NC, USA
    Posts
    2,517
    Tokens
    0

    Latest Awards:

    Default

    <?php
    include "config.php"; // config file

    $query = mysql_query("TRUNCATE TABLE `table_name` ;");

    ?>

    go into cPanel.
    Go to cron jobs, put the command as:
    wget http://www.site.com/myfile.php

    Then set the time to everyday at 00:00 of every week of every month of every year.

  3. #13

    Default

    Quote Originally Posted by Dentafrice, View Post
    <?php
    include "config.php"; // config file

    $query = mysql_query("TRUNCATE TABLE `table_name` ;");

    ?>

    go into cPanel.
    Go to cron jobs, put the command as:
    wget http://www.site.com/myfile.php

    Then set the time to everyday at 00:00 of every week of every month of every year.
    Humm, how do you do it so it deletes say:
    the data in 00:00 etc..?

  4. #14
    Join Date
    Oct 2007
    Location
    Luton, England
    Posts
    1,548
    Tokens
    388
    Habbo
    DeejayMachoo

    Latest Awards:

    Default

    you set the cron to run the file at the time you want it delete and also

    Simon why are u so up your self?
    Just because someone else helped more then you.


  5. #15
    Join Date
    Jul 2005
    Location
    -
    Posts
    2,995
    Tokens
    0

    Latest Awards:

    Default

    Quote Originally Posted by Mattx.org View Post
    you set the cron to run the file at the time you want it delete and also

    Simon why are u so up your self?

    Just because someone else helped more then you.
    :| there is no need to be so rude.

  6. #16
    Join Date
    Apr 2006
    Location
    Leamington Spa
    Posts
    1,375
    Tokens
    72

    Latest Awards:

    Default

    Yeah, just ignore me. ('ere.)
    i've been here for over 8 years and i don't know why

  7. #17

    Default

    I made it so that it deletes them, but also re adds them at the same time

  8. #18
    Join Date
    Sep 2006
    Location
    Hobart, Australia
    Posts
    593
    Tokens
    0

    Default

    Re-adds the table structure? That's exactly what TRUNCATE does, anyway

Page 2 of 2 FirstFirst 12

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •