Hourly Event code

mishrathium

Hello all,

I have a code that knows when 1 hour has passed.

When this event occurs I need to create some code to do the following.

Database has many users with these fields.
name - mishrathium
number - 10
hourly_total

I have a static number, lets say 5.

I need this code to multiply the database number (10 in the above example) by 5 for every username then save the number it created asa running total.

I am not sure if I need to create a loop to do this for every user (load user info, multiple it, save it, loop it) or if there is an easier way to do that.

Thanks in advance,
~mish~

thorpe

wrote:

you might want to take a look and see if your host supports cron jobs. i think that would be your best solution.
how does the script you have now know when an hour has passed?

mishrathium

negative on the cron. However I've solved that.

[code=php]// HOUR routine //

	if (!$conn) die ("Could not connect MySQL");  
mysql_select_db($database,$conn) or die ("Could not open database"); 
$query = "SELECT game_time FROM users_online WHERE online_name = 'host' LIMIT 1";  
$result = mysql_query($query); $numrows = mysql_num_rows($result);   
while($row = mysql_fetch_array($result))
{			
$game_time = $row[game_time]; 
}

$test_time =  (time() - $game_time) - 3600 ;

$harvest_time = time() - 3600; // 60 Minute time out. 60 * 60 = 3600
$test_harvest = 3600 - $test_time ; 
$test_harvest = round($test_harvest) ;

if($test_harvest <= 0)
{
 if (!$conn) die ("Could not connect MySQL");
 mysql_select_db($database,$conn) or die(mysql_error());
 $insert = "INSERT INTO user_test (test_msg) VALUES ('a hourly event has occured')";
 mysql_query($insert)or mysql_error("Could not insert into database");
}[/code]

so the above insert into the user_test has info, showing it works, I havent actually timed it out exactly, but it appears close enough for me. Now I need to update my entire DB with the first question I asked. I dont need the time routine. I need some help with updating the entire DB but the fields would be using different numbers multipled by a static number then that new number saved anc accrued.

thanks again in advance!

mishrathium

reading the above maybe I posted my question poorly.

I need a way to update 1 field in my database by taking one field multiplying by 5 and saving the result.

example.

user | to_be_mult | result
a 10
b 5
c 15
d 20

So I need to load each users $to_be_mult and * that by 5. Then save the result by adding it to any result.

[EDIT]

getting closer.. So I have a Field called ID, which is unique and auto_incremented. Although there are gaps in the numbers where people where deleted.

I can loop from 0 to the Max id.. if it finds info, do my formula and save it until reaching max ID number... I think.. going to try that.

Thanks again in advance!