Please move this to The Webmaster Bat-Cave, I put this in the wrong section, sorry!
( I may figure this out on my own :P ) Note: This isn't very related to the adoptable script, I'm making a game that is using the adoptable script as a... template you might say to run the game.
Okay, I am trying to make it so a user gets 100 Cash every five minutes, I've got it so the script/file will run every five minutes, I just can't get all the users getting 100 Cash. Only one user at a time, I'm trying to take the "User list" and have that update the user accounts resources, but, that doesn't seem to be working. :/ Here is the code that is suppose to be updating the users' resources:
PHP Code:
$query = "SELECT * FROM ".$prefix."users";
$result = mysql_query($query);
//Loop out code
$i=0;
while ($i < $num2) {
$user=@mysql_result($result,$i,"username");
$cash=@mysql_result($result,$i,"cash");
$metal=@mysql_result($result,$i,"metal");
$power=@mysql_result($result,$i,"power");
$fuel=@mysql_result($result,$i,"fuel");
$cashs = $cash + 100;
$metals = $metal + 75;
$powers = $power + 25;
$fuels = $fuel + 50;
$query = "UPDATE ".$prefix."users SET cash='".$cashs."' WHERE username='".$user."'";
mysql_query($query);
$query = "UPDATE ".$prefix."users SET metal='".$metals."' WHERE username='".$user."'";
mysql_query($query);
$query = "UPDATE ".$prefix."users SET fuel='".$fuels."' WHERE username='".$user."'";
mysql_query($query);
$query = "UPDATE ".$prefix."users SET power='".$powers."' WHERE username='".$user."'";
mysql_query($query);
$i++;
}
Any ideas? ( I know it says fuel, metal, power, and cash and that stuff, but as I said before, this is for a game that isn't related to adoptables. ;) )