Increasing Turns

Posted: Sat Jan 25, 2003 2:22 pm (21 years, 2 months ago)

Hi,

I am currently writing an online game in PHP every 3 minutes I am going to run a cron that increases every user's turns by one unless they have 2000 turns already.

My database has the fields:

uid (a integer that is the unique user number. This starts from 1 and goes up although some numbers may be missing if a user has been deleted)

turns (The number of thurens the user has. Each user may have different numbers of turns)

My database table currently looks like this:

uid turns
1 1500
2 500
3 275
5 167
6 1335

The table is caled warrior_turns

Thanks,

Team Member Joined: 06 Jan 2002 Posts: 2564

So what's the question? Very Happy

Posted: Sat Jan 25, 2003 2:26 pm (21 years, 2 months ago)

Daniel wrote:

So what's the question? Very Happy

oops.

Spent all that time typing and forgot to ask the question. I'm having a bad day Wink

The question is... Does anyone know how I can do this?

Thanks,

Team Member Joined: 06 Jan 2002 Posts: 2564

What exactly do you need help with? The cron? Adding the turns?

Posted: Sat Jan 25, 2003 2:29 pm (21 years, 2 months ago)

Daniel wrote:

What exactly do you need help with? The cron? Adding the turns?

The SQL/PHP code to add the turns if the user doesn't allready have 2000.
My Host will set up the cron for me Smile

Team Member Joined: 06 Jan 2002 Posts: 2564

Try this:

Code:

$sql = "UPDATE warrior_turns
SET turns = turns +
WHERE turns != 2000";

Posted: Sat Jan 25, 2003 2:34 pm (21 years, 2 months ago)

Daniel wrote:

Try this:

Code:

$sql = "UPDATE warrior_turns
SET turns = turns +
WHERE turns != 2000";

Thanks

Looks hopeful, I will give it a go and report back.

Posted: Sat Jan 25, 2003 2:44 pm (21 years, 2 months ago)

Daniel wrote:

$sql = "UPDATE warrior_turns
SET turns = turns +1
WHERE turns != 2000";

Yup! It works Smile

thanks a lot (I just had to make a minor alteration which is in bold above)

Posted: Sun Jan 26, 2003 4:22 pm (21 years, 2 months ago)

Daniel wrote:

Try this:

Code:

$sql = "UPDATE warrior_turns
SET turns = turns +
WHERE turns != 2000";

I personally would use this:

Code:

$sql = "UPDATE warrior_turns
SET turns = turns +1
WHERE turns < 2000";

Team Member Joined: 06 Jan 2002 Posts: 2564

It really depends if there's a chance that a record might accidentally get more than 2000 turns. In that case they could have, for example, 2005 turns and you wouldn't want to give them anymore.

Posted: Sun Jan 26, 2003 4:28 pm (21 years, 2 months ago)

even if you think there isn't a chance, something you didn't think of could happen so it's a good idea to just play it safe