Adding 1 per minute

Posted on Wednesday 5th November 2008 at 07:05 AM

jambomb

Yeh i've done that and edited abit but still only works for some people and now the ones who actualy need it lol ?? :s

Posted on Thursday 6th November 2008 at 07:29 PM

jambomb

Okay this is my code so far, but at the moment it just still wont add 1 per minute :S:S::S!!!!

Code

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

$members_nerve = mysql_fetch_array($getmembers_nerve);

$minute = time() + 60;

if($members_nerve[nerveTime] > $minute)

{

$i = "1";

$nerveUpdate = $members_nerve[nerve] + $i;

$insert_nerve = mysql_query("UPDATE `members` SET `nerve` = '$nerveUpdate' WHERE `username` = '$members_nerve[username]';") or die(mysql_error());

}

else

{

$insert_nerve = mysql_query("UPDATE `members` SET `nerveTime` = '$minute' WHERE `username` = '$members_nerve[username]';") or die(mysql_error());

}

Posted on Thursday 6th November 2008 at 09:39 PM

Matt

okay, do you need WHERE `neverDown` = 'TRUE' in your query?

you have the query which is restricting your code to only grab data from users with nerveDown = true.

pretty much your code is only going to effect the users with nervedown = 'true', but then they will remain being the only ones who get effected by this code, since you don't set it to false inside the if statement.

so just try removing that part for now and tell me what happens.

Posted on Thursday 6th November 2008 at 11:49 PM

jambomb

okay man i tryd that and still doesnt dam work :S

this is the code now

Code

        $getmembers_nerve = mysql_query("SELECT * FROM `members`") or die(mysql_error());

$members_nerve = mysql_fetch_array($getmembers_nerve);

$minute = time() + 60;

if($members_nerve[nerveTime] > $minute)

{

$i = "1";

$nerveUpdate = $members_nerve[nerve] + $i;

$insert_nerve = mysql_query("UPDATE `members` SET `nerve` = '$nerveUpdate' WHERE `username` = '$members_nerve[username]';") or die(mysql_error());

}

else

{

$insert_nerve = mysql_query("UPDATE `members` SET `nerveTime` = '$minute' WHERE `username` = '$members_nerve[username]';") or die(mysql_error());

}

Posted on Friday 7th November 2008 at 03:37 PM

Matt

PHP Code

<?php
 
$nerverarray = mysql_query("SELECT * FROM `members`") or die(mysql_error());
$nerve= mysql_fetch_array($nerverarray);
 
$minute = time() + 60;
// if the timestamp has been more than one minute ago, run the code.
if($nerve[timestamp] > $minute)
{
	$nerveUpdate = $members_nerve[nerve]++;
	mysql_query("UPDATE `members` SET `nerve` = '$nerveUpdate' WHERE `username` = '$nerve[username]';") or die(mysql_error());
}
else
{
	mysql_query("UPDATE `members` SET `nerveTime` = '$minute' WHERE `username` = '$nerve[username]';") or die(mysql_error());
}
 
?>

okay, you had the queries set in variables, and never ran the variables, this is the code cleaned up, and should work, try it man.

Posted on Friday 7th November 2008 at 03:39 PM

Matt

sorry for the double post, but this:

PHP Code

$nerveUpdate = $members_nerve[nerve]++;

needs to be changed to

PHP Code

$nerveUpdate = $nerve[nerve]++;

Posted on Friday 7th November 2008 at 04:57 PM

jambomb

thanks mate but still doesnt dam work :S:S:S!! fucking soo dam confused mate =[=[=[

this is the code again dude,

Code

        $nerverarray = mysql_query("SELECT * FROM `members`") or die(mysql_error());

$nerve = mysql_fetch_array($nerverarray);

$minute = time() + 60;

if($nerve[nerveTime] >= $minute)

{

    $nerveUpdate = $nerve[nerve]++; 

    mysql_query("UPDATE `members` SET `nerve` = '$nerveUpdate' WHERE `username` = '$nerve[username]';") or die(mysql_error());

}

else

{

    mysql_query("UPDATE `members` SET `nerveTime` = '$minute' WHERE `username` = '$nerve[username]';") or die(mysql_error());

}

So not sure wat the hells happening !!

Posted on Friday 7th November 2008 at 05:57 PM

Matt

okay, so just the queries aren't being executed?
you could add me to msn so we can try to fix this a bit quicker.

Posted on Friday 7th November 2008 at 06:07 PM

jambomb

my msn highrizeservers@hotmail.com

=]

thanks alot