Forgot Password • Register • Login

Adding 1 per minute

Posted on Tuesday 28th October 2008 at 02:40 PM

jambomb

Okay Im making a crime/gangster game! and i want to make it so you gain 1 nerve every minute!

here is my code i use for cjobs

Code

        <?php

include ("public_html/config.php");

$getmembers = mysql_query("SELECT * FROM `members` WHERE `nerveDown` = 'TRUE' ") or die(mysql_error());

$members = mysql_fetch_array($getmembers);

if($members[nerve] < $members[nerveTotal])

{

$i = "1";

$nerve = $i++;

$nerveUpdate = $members[nerve] + "1";

$insert_nerve = mysql_query("UPDATE `members` SET `nerve` = '$nerveUpdate'") or die(mysql_error());

}

?>

Some times it does add 1 but it sets it to 1 for everyone if u understand ?

hope u guys understand x

Posted on Tuesday 28th October 2008 at 03:11 PM

ShadowMage
ShadowMage's Avatar

I would try:

PHP Code

<?php
$getMembersandArray = mysql_fetch_array(mysql_query("SELECT * FROM `members` WHERE `nerveDown` = 'TRUE';"));
if($getMembersandArray[nerve] < $getMembersandArray[nerveTotal]){
$nerve = $getMembersandArray[nerve] + 1;
$update = mysql_query("UPDATE `members` SET `nerve` = '$nerve' WHERE `username` = '$getMembersandArray[username]';
}
?>

failure i sense

Posted on Tuesday 28th October 2008 at 03:14 PM

ShadowMage
ShadowMage's Avatar

ALso forgot :S Dont run cron jobs every minute ;)

failure i sense

Posted on Tuesday 28th October 2008 at 03:41 PM

jambomb

i dno how to make it every minute :P hehe coz im trying to make it so it adds 1 every min but not sure how else to do it :P

Posted on Wednesday 29th October 2008 at 03:03 PM

ShadowMage
ShadowMage's Avatar

YOu could just add it to the website itself :3

failure i sense

Posted on Friday 31st October 2008 at 09:58 PM

jambomb

But how could i make it so it does it every minute it adds 1 nerve ? :/

Posted on Monday 3rd November 2008 at 06:09 PM

DanielXP

timestamp?

Posted on Monday 3rd November 2008 at 06:49 PM

jambomb

I dont have a clue how to do that :/ or use it :S =[

Posted on Tuesday 4th November 2008 at 12:54 AM

ShadowMage
ShadowMage's Avatar

time()
https://php.net/time

failure i sense

Posted on Tuesday 4th November 2008 at 03:14 AM

Matt

PHP Code

<?// this is the current time with one minute added onto it.
$minute = time() + 60;
// if the gathered datas timestamp is greater than one minute ago, run the script.
if ($array[NerveTimestamp] > $minute)
{
// run script
}
?>

something like that should do it, i might have messed up by adding 60 seconds to the time, but your code should look somewhat like that.