[IKnowWhatIAmDoing]

Hello,

I want to know how can I check if a user exists at the mysql db or not.

table name = players
player name column = username
mysql plugin version: r39-2

I want to have a function which I can use like

if(!DoesUserExist(name)) return SendClientMessage(playerid,"No user was found.");

Can anyone help me please?

[Suicidal.Banana]

https://sampwiki.blast.hk/wiki/MySQL#mysql_num_rows
if 0, no user was found, see example code on the above link
(do a select query to fetch user, then do the mysql_num_rows on the result of that query)

[IKnowWhatIAmDoing]

Quote:

Originally Posted by Suicidal.Banana https://sampwiki.blast.hk/wiki/MySQL#mysql_num_rows if 0, no user was found, see example code on the above link (do a select query to fetch user, then do the mysql_num_rows on the result of that query)

These functions are outdated for r39-2, free_result etc. these were all removed.

Which is exactly why I'm asking this question today.

[Suicidal.Banana]

derp, my bad

[SpikeSpigel]

I do something like this . I have an UCP and player need to register on it first, I accept/refuse their accounts and then when they connect to the server my MySQL data base works like this.
SELECT * from 'USERID' and SELECT * from 'Accepted' = 1 . You can do the same !