Hello there,
i have a small script where players can register their name with a password, which is then stored in a database. so every name is unique. you than can login with your name and password.
the problem now is, that after a mapchange the name is resetted to the original one.
how can i make the namechange persistent till the client logs out?
i tried it with setting the name to an array, because i read that this will persist, but i am not able to read that one on map start.
i tried it this way:
Code:
public OnPluginStart()
{
new String:Error[70];
DB = SQL_Connect("login-system", true, Error, sizeof(Error));
if (DB == INVALID_HANDLE)
{
PrintToServer("Cannot connect to MySQL Server: %s", Error);
}
else
{
PrintToServer("Connection Successful");
}
RegConsoleCmd("login", Command_Login);
RegConsoleCmd("register", Command_Register);
}
public Action Command_Login(int client, int args)
{
char arg1[32]
char arg2[32]
/* By default, we set damage = 0 */
if (args < 1)
{
ReplyToCommand(client, "[SM] You need to enter a name!");
return Plugin_Handled;
}
else if (args < 2)
{
ReplyToCommand(client, "[SM] You need to enter a password!");
return Plugin_Handled;
}
new String:query[150];
Format(query, sizeof(query), "SELECT passwort FROM hlstats_logins WHERE name='%s'", arg1);
decl String:new_name[MAXPLAYERS+1][64];
new Handle:queryH = SQL_Query(DB, query);
if(queryH != INVALID_HANDLE)
{
if(SQL_FetchRow(queryH))
{
new String:passwort[120];
new String:md5pass[256];
SQL_FetchString(queryH, 0,passwort, sizeof(passwort));
Crypt_MD5(arg2,md5pass,256)
if(StrEqual(md5pass,passwort))
{
SetClientName(client, arg1);
ReplyToCommand(client, "[SM] Your new name is %s", arg1);
new_name[client] = arg1;
}
else
{
ReplyToCommand(client, "[SM] Your password is wrongh! ");
}
}
else
{
ReplyToCommand(client, "[SM] The name %s is already taken!", arg1);
}
}
else
{
ReplyToCommand(client, "error with mysql");
}
return Plugin_Handled;
}
Linear Mode
