Max number

[xiao]

Hi, I'm making an RPG script.
Players need Turns to kill monsters, attack other players, buy stuff, etc.
I made a script which ads 15 turns to all players and used a cronjob to run it every 15 minutes.
Now is it possible to make a max amount of turns?
For example a 2000. So when a player has 1999 turns and the script runs, he gets 2000 and he doesn't get any more turns until his number is below 2000 again.

Current script:

<?php

include "../connect.php";

$getturns="Update km_users set numturns=numturns+15";

$getturns2=mysql_query($getturns) or die("Could not get turns");

?>

[Houdini]

Just an idea

$test ="SELECT numturns FROM km_users WHERE  somecondition ";
if($test + 15 =<  2000){
$addturns = "UPDATE km_users SET numturns + 15 WHERE  somecondition":
}
else {
// Do something different
}

[laserlight]

For a non-negative integer num, num % 2001 is always no more than 2000, where % is a modulo operator.

With that, you can do it in a single SQL statement.

[xiao]

Houdini wrote:

Just an idea

$test ="SELECT numturns FROM km_users WHERE  somecondition ";
if($test + 15 =<  2000){
$addturns = "UPDATE km_users SET numturns + 15 WHERE  somecondition":
}
else {
// Do something different
}

That's a start, but 1990 + 15 is >2000, so the person wouldn't get anything, while he should get 10. But thanks 🙂

@: How would this look in the script?

Someone came with this idea:

update km_users 
   set numturns 
     = numturns +
         case when numturns between 1985 and 2000
              then 2000 - numturns
              else 15 end

But I don't know exactly how to code that

[laserlight]

More like:

UPDATE km_users SET numturns=(numturns+15)%2001;

[xiao]

What would this exactly do? :$

% is for 'rest' right?

[laserlight]

The % operator in SQL is the same as in PHP.
x % y returns the remainder of the integer division of x by y.

[xiao]

thanks

[xiao]

So this should work?

<?php
include "www/rpg/connect.php";

$test ="SELECT numturns FROM km_users";
if($test + 15 =<  2000){
$addturns = "UPDATE km_users SET numturns=(numturns+15)%2001;":
}
else {
$getturns="Update km_users set numturns=numturns+15";

$getturns2=mysql_query($getturns) or die("Could not get turns");
} 

[laserlight]

Just do a:

include "www/rpg/connect.php";

$addturns = "UPDATE km_users SET numturns=(numturns+15)%2001";
mysql_query($addturns);

[xiao]

I tried that with 1990 turns and instead of entering 2000, it entered 4 🙂

[xiao]

I think I got it:

<?php

include "rpg/connect.php";

$addturns = "UPDATE km_users SET numturns=(numturns+15)";
mysql_query($addturns); 


$addturns2 = "UPDATE km_users SET numturns=2000 WHERE numturns>1985";
mysql_query($addturns2); 


?>

I tested it and it seems to work. See any mistakes maybe?

[laserlight]

I tried that with 1990 turns and instead of entering 2000, it entered 4

hmm... yeah, my reasoning is incorrect.

There is another solution:

UPDATE km_users SET numturns=numturns+15 WHERE numturns<1985;

[laserlight]

I tested it and it seems to work. See any mistakes maybe?

That isnt quite correct, since a user with numturns=1980 will get it set (correctly) to 1995, and then set (incorrectly) to 2000.

My version is problematic too, in the same way. You may end up doing two queries:

UPDATE km_users SET numturns=numturns+15;
UPDATE km_users SET numturns=2000 WHERE numturns>2000;

Though I suspect that just imposing a constraint on the column would be simpler.

[xiao]

Think this works:

<?php

include "rpg/connect.php";

$addturns = " UPDATE km_users SET `numturns`=2000 WHERE numturns>1985 AND numturns != 2000";
mysql_query($addturns); 


$addturns2 = "UPDATE km_users SET `numturns`=numturns+15 WHERE numturns<=1985";
mysql_query($addturns2); 

mysql_close();


?>

[laserlight]

Yes, that should work.