How do I set a certain value but not pass it?

Asked Oct 31 '19 at 11:47

Active Oct 31 '19 at 12:18

Viewed 48 times

I have a game, every 10 minutes the game is updated, now I want to limit the players to the amount of resources they have, which will not pass for some value in SQL

I tried lots of things but nobody does the work

if ($ud == $def_gold) {
        $db->query("UPDATE `resources` SET gold=gold=".$gold.", wood=wood=".$wood.", iron=iron=".$iron.", food=food=".$food." WHERE ID='".$ud['wk']['ID']."'");
    } else {
    $db->query("UPDATE `resources` SET gold=gold+".$gold.", wood=wood+".$wood.", iron=iron+".$iron.", food=food+".$food." WHERE ID='".$ud['wk']['ID']."'");
    $db->query("UPDATE `civ` SET untrained=untrained+".$untrained." WHERE ID='".$ud['wk']['ID']."'");
    }

This value: $ def_gold Should be limited in SQL to a certain amount (already limited)

This value: $ ud Indicates resources

I need to limit players by $ def_gold

edited Oct 31 '19 at 12:18

Martin Dimitrov

1,304
1
11
25

asked Oct 31 '19 at 11:47

Kfir Ben SHimon

2

It's not clear to me what you are asking – jrswgtr Oct 31 '19 at 12:12
I want to limit some value in SQL .. – Kfir Ben SHimon Oct 31 '19 at 12:32
I'm not sure if it is even possible in SQL. You could use PHP however, but than you will have to do a query to get the current values first. – jrswgtr Oct 31 '19 at 12:45
Also don't use string concatenation for your query parameters. Use the PDO `prepare` method. Read here why: https://stackoverflow.com/a/28473802/8108407 – jrswgtr Oct 31 '19 at 12:48
_I want to limit some value in SQL_ - what does this mean? Looks like you're trying to increment the values in some cases. – waterloomatt Oct 31 '19 at 13:37
@waterloomatt I think he wants to increment the values up to a certain maximum value. – jrswgtr Oct 31 '19 at 14:01

How do I set a certain value but not pass it?

0 Answers0