Not working code

Code:

public iRegister(id, name, password)
{
    new buffer[512] = format(buffer, sizeof(buffer), "INSERT INTO irp_users(ip, name, password) VALUES %s, %s, %s", getPlayerIP(id) ,getPlayerName(id), password)
    gTmp = samp_mysql_query(buffer)
   
    samp_mysql_real_escape_string(gTmp, gTmp) // This stops SQL injection.
   
    if(!gTmp)
    {
        format(gTmp, sizeof(gTmp), "[InevitaRP] Failed to register user '%s.' (Reason: Unable to execute query. [Line 18]", getPlayerName(id))
       
        print(gTmp)
        SendClientMessage(id, 0xFF0000, gTmp)
    }
}

Any ideas?

What you using as server name?

Paddy_Collins wrote:What you using as server name?

What has the server name got to do with it?

I meant the name u use to login in with

Jonathon_Cruscoe, but it's fixed now.

The real_escape() simply converts invalid characters (eg. ', ` and ; which are most commonly used for SQL injection(password: lol'; DROP TABLE irp_users --)) to their ascii/utf8 codes.

duh...

I knew that...

LOL