[DetoNater]

When ever a new player registers the Id of new one is replaced in the old one

this is my register cmd, I want a new Id to be created when a new player is registered.

Код:

 MySQLregister(playerid, params[])
{
	new password[130];
	mysql_escape_string(params,password);
	new str[128];
    mysql_format(mysql,str,sizeof(str),"INSERT INTO `users` (`Name`, `Pass`, `ID`) VALUES ('%s', '%s', '%s')",PlayerName(playerid),password, NewFieldID[playerid]);
	mysql_query(mysql,str);
	//--------------------------------------------------
	SendLangMessage(playerid, _COLOR_YELLOW, "Account wurde erstellt:","Account was created:","Tu cuenta ha sido creada:");
	switch(Sprache[playerid])
	{
		case 0: format(str, sizeof(str), "Passwort: \"%s\"",password);
		case 1: format(str, sizeof(str), "Password: \"%s\"",password);
		case 2: format(str, sizeof(str), "Contrasena: \"%s\"",password);
	}
	SendClientMessage(playerid, _COLOR_GREEN, str);
	SendLangMessage(playerid, _COLOR_GREEN, "Du wurdest eingeloggt!","You are logged in!","Has iniciado sesi鏮!");
	GivePlayerCash(playerid,10000);
	GiveClanCash(playerid,10000);
	LoggedIn[playerid] = 1;
	mysql_format(mysql,str, sizeof(str), "SELECT * FROM `users` WHERE Name = '%s'",PlayerName(playerid));
	mysql_query(mysql,str);
    NewFieldID[playerid] = cache_insert_id();
    return 1;
}

The mysql have the Id field

[DetoNater]

-bump- need help utmost!

[Kitten]

Create a new row and define it as AUTO_INCREMENT it'll just add itself up.

[CodeStyle175]

PHP код:

MySQLregister(playerid, password[])
{
    new query[128];
    mysql_format(mysql,query,sizeof(query),"INSERT INTO users(Name, Pass) VALUES ('%s', '%s')",
    PlayerName(playerid),password);
    new Cache:cquery=mysql_query(mysql,query);
    UserSQLID[playerid] = cache_insert_id();
    cache_delete(cquery);
    
    GivePlayerCash(playerid,10000);
    GiveClanCash(playerid,10000);
    LoggedIn[playerid] = 1;
    SCM(playerid,-1,"You successfully registered yourself.");
    return 1;
} 


[DetoNater]

can you give me an auto_increment for my code, I'm a bit confused.

[Konstantinos]

CodeStyle175's code inserts a new row and it retrieves the ID which is set with AUTO INCREMENT in the table structure. If you haven't set auto increment for "ID" field, then do it (phpMyAdmin or any other) and modify it because it's not something we can "give" you.

PS: At least use always cache as you don't use threaded queries which is something I'd suggest you to do.