[Think]

[15:38:33] DEBUG OnPlayerLogin(0) (lol)
[15:38:33] Error in mysql_query: Unknown column 'Gangstah' in 'where clause'
[15:38:33] Error in mysql_store_result: Unknown column 'Gangstah' in 'where clause'

pawn Код:

format(query, sizeof(query), "SELECT * FROM users WHERE name='%s' AND password='%s'", playername2, string);
    samp_mysql_query(query);
    samp_mysql_store_result();

thats the code wuts wrong?

[MenaceX^]

'Gangstah' is?

[Think]

Quote:

Originally Posted by MenaceX^ 'Gangstah' is?

the account name of the person who tested this

[MenaceX^]

Is he registered?

[Think]

Quote:

Originally Posted by MenaceX^ Is he registered?

he is in the database:

[MenaceX^]

I dunno in your way.
In my codes I have a varieble to check the player registation ID, each registation adds one more ID.
So I can select it like

pawn Код:

format(string,sizeof(string),"SELECT * FROM `users` WHERE `id`='%d'",pInfo[playerid][registeredid]);
samp_mysql_query(string);

I never tried it with names..

[Think]

i got those ID's but if i do onplayerlogin i dont know his ID yet do i?

[MenaceX^]

I guess you didn't define it...
in ONPlayerRegister the player should get an id +1.
Like, you were registered with ID 55. Someone else registers with 56 (+1)

[Think]

yes but how would i know his ID if i dont know how to bind it to a variable when joining? ¬¬

[Jack_Fox]

Just put user_id on auto_increcement and then use INSERT