[TheSy]

Good morning.

I have a system of planting weed.
All this is stored in a table and I have a column 'planter'

So I want to compare the planters of the table with the nickname of the player and if he has already made more than three plants can no longer do.

Thank you!

[S4t3K]

strcmp + cache_get_field_content

[TheSy]

I use MySQL R5

[iRaiDeN]

i don't understand what you need?

[TheSy]

I want a SQL query that compares the nickname of the player with my column "Planter" and then if the player's name as "Planter" appears more than 5 times does not allow planting

I'm not english ^^

[S4t3K]

So strcmp + mysql_fetch_field_row will do the job I think.

[TheSy]

pawn Код:

mysql_query("SELECT COUNT(Planteurs) FROM srp_players_weed");
                mysql_store_result();
                if(!mysql_num_rows()) return mysql_free_result(), 1;
                new field[256], entry;
                while(mysql_retrieve_row())
                {
                    mysql_get_field("Planteur", WeedInfo[entry][Planteur]);
                    entry++;
                }
                mysql_free_result();

And then?

How can I do to compare with the nickname of the player who wants to plant and that of the Planter column for obstructing him if he has three plantations in progress?

[TheSy]

upppp