Forum Index » PHP + MySQL » Adding 1 per minute
| Posted on Tuesday 28th October 2008 at 02:40 PM | |
jambomb Junior Member |
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 Senior Member |
I would try: PHP Code
1 2 3 4 5 6 7 8
<?php
|
| Posted on Tuesday 28th October 2008 at 03:14 PM | |
| ShadowMage Senior Member |
ALso forgot :S Dont run cron jobs every minute ;) |
| Posted on Tuesday 28th October 2008 at 03:41 PM | |
| jambomb Junior Member |
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 20 at 03:03 PM | |
| ShadowMage Senior Member |
YOu could just add it to the website itself :3 |
| Posted on Friday 31st October 2008 at 09:58 PM | |
| jambomb Junior Member |
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 Senior Member |
timestamp? |
| Posted on Monday 3rd November 2008 at 06:49 PM | |
| jambomb Junior Member |
I dont have a clue how to do that :/ or use it :S =[ |
| Posted on Tuesday 4th November 2008 at 12:54 AM | |
| ShadowMage Senior Member |
time() http://php.net/time |
| Posted on Tuesday 4th November 2008 at 03:14 AM | |
| Matt Newbie |
PHP Code
1 2 3 4 5 6 7 8 9
<?// this is the current time with one minute added onto it.
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. |