[Zafire1410]

Quote:

Originally Posted by JaTochNietDan Quote: Originally Posted by Joe Staff Shouldn't it be "SELECT * FROM mytable WHERE ..." ? I've made my own MySQL login system before and I think that doing "SELECT Whatever" would select a column called 'Whatever' whereas the '*' is all columns. You could also do "SELECT Username,Password FROM mytable ..." and that would get you the columns you're looking for anyway. Why would you use SELECT *? He doesn't need to retrieve every single column in the entire row just for logging someone in. Also, it was an example, I don't know what columns he has. Zafire are you using any type of encryption on the passwords? EDIT: I just noticed this.. pawn Code: if(!strcmp(cmdtext, "/login", true, 3)) // 3 is the length of /me 3 may be the length of /me but it's not the length of /login

Thx but that doesnt matters because my register works!! , but i change that, the problem the code you give me is usefull for "check if the player is registered" but the problem there, i need a code take "password" from the table "players" when "nombre" = %s ... and check if (sqldate) == (password used in /login)

I dont use encriptation of password