[kurta999]

Hi.

I want to run this result for all players in the table, but I don't know how to do it.

Here's the result, this works, but I only can run it for one row and this is doesn't works with multipie rows.

UPDATE players SET maths = (SELECT COUNT( winner_id) FROM maths)

This will update all data for same value in players table, and this is the problem.

[Mellnik]

sorry i dont understand what you mean

[kurta999]

Shit, sorry for my bad english.

I want to update the "maths" in `players` table for number of rows for the player reg id from math table, but this will count all reg id in maths table and will update the players table for same value.

Example:

Code:

for(new i; i < MaxPlayerIDInPlayersTable; i++)
{
"UPDATE players SET maths = (SELECT COUNT( winner_id) FROM maths WHERE winner_id = i) WHERE id = i"
}

If there will no idea, i will run similar query with mysql plugin from samp server.. This is not the best idea, but I don't know another result now

[Mellnik]

Now I understand i think....

first tell me which plugin you use

[kurta999]

Quote:

Originally Posted by Mellnik Now I understand i think.... first tell me which plugin you use

BlueG's R7 plugin, but after some calculations run this query in cicle in samp server is impossible, because i have ~90k players..

[Mellnik]

Quote:

Originally Posted by kurta999 BlueG's R7 plugin, but after some calculations run this query in cicle in samp server is impossible, because i have ~90k players..

LOL

Quote:

I want to update the "maths" in `players` table for number of rows for the player reg id from math table, but this will count all reg id in maths table and will update the players table for same value.

Did i understand that:

1. you want to get the count of all rows in table "math"
2 then you wan to insert received number into "maths" from the table players
?

[AndreT]

UPDATE players SET maths=(SELECT COUNT(winner_id) FROM maths WHERE maths.winner_id=players.id)
What about this one?

[kurta999]

Quote:

Originally Posted by AndreT UPDATE players SET maths=(SELECT COUNT(winner_id) FROM maths WHERE maths.winner_id=players.id) What about this one?

I'm idiot.. LoL
Thanks!

Very nice, this works!

I now searched for while loop in mysql, and other shits, but this solved my problem.
(I was gave rep for you before few monts, so i don't know now give for this )

[TwisT3R]

kurta lбtom szenvedsz angollal