SA-MP Forums Archive
Mysql - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Mysql (/showthread.php?tid=636784)


Mysql - Loinal - 03.07.2017

PHP код:
CMD:setpassword(playerid, params[])
{
    if(pData[playerid][Admin] >= 7)
    {
        new query[320], name[24], newpass[34], hash1[34],query1[320];
        if(sscanf(params, "s[24]s[34]", name, newpass)) return SendClientMessage(playerid, COLOR_YELLOW, "USAGE: /setpassword <PlayerName> <NewPassword>");
        if(!AccountExists(name)) return SendClientMessage(playerid, red, "Account does not exists");
        format(query1, sizeof(query1), "You have changed %s's password to %s", name, newpass);
        SendClientMessage(playerid, COLOR_GREEN, query1);
        new IRC[130];
        format(IRC, sizeof(IRC), "1,8* Admin %s (ID: %d) changed %s's password.",GetName(playerid), playerid, name);
        IRC_GroupSay(groupID, "&#ZoneX", IRC);
        IRC_GroupSay(groupID, IRC_aCHANNEL, IRC);
        WP_Hash(hash1, 129, newpass);
        mysql_format(mysql, query, sizeof(query), "UPDATE `players` SET `Password` = '%s' WHERE `Username` = '%e'", hash1, name);
        mysql_tquery(mysql, query);
        return 1;
    }
    else return ShowMessage(playerid, COLOR_YELLOW, 1, 7);
} 
In game when i try to set some one password he can also use the old one how?

Re: Mysql - Meller - 03.07.2017

PHP код:
CMD:setpassword(playerid, params[]) 
{ 
    if(pData[playerid][Admin] >= 7) 
    { 
        new query[320], name[24], newpass[34], hash1[34],query1[320]; 
        if(sscanf(params, "s[24]s[34]", name, newpass)) return SendClientMessage(playerid, COLOR_YELLOW, "USAGE: /setpassword <PlayerName> <NewPassword>"); 
        if(!AccountExists(name)) return SendClientMessage(playerid, red, "Account does not exists"); 
        format(query1, sizeof(query1), "You have changed %s's password to %s", name, newpass); 
        SendClientMessage(playerid, COLOR_GREEN, query1); 
        new IRC[130]; 
        format(IRC, sizeof(IRC), "1,8* Admin %s (ID: %d) changed %s's password.",GetName(playerid), playerid, name); 
        IRC_GroupSay(groupID, "&#ZoneX", IRC); 
        IRC_GroupSay(groupID, IRC_aCHANNEL, IRC); 
        WP_Hash(hash1, 129, newpass); 
        mysql_format(mysql, query, sizeof(query), "UPDATE `players` SET `Password` = '%s' WHERE `Username` = '%e'", hash1, name); 
        mysql_tquery(mysql, query); 
        new name2[MAX_PLAYER_NAME];
        for(new targetid = 0, maxid = GetPlayerPoolSize(); targetid <= maxid; targetid++) {
            if(IsPlayerConnected(targetid)) {
                GetPlayerName(targetid, name2, MAX_PLAYER_NAME);
                if(!strcmp(name, name2)) {
                    //Player is online, set his password variable to new password, example:
                    format(pData[playerid][Password], sizeof(Password), "%s", hash1);
                    break;
                }
            }
        }
        return 1; 
    } 
    else return ShowMessage(playerid, COLOR_YELLOW, 1, 7); 
} 
You must set his variable to the new has aswell if he's online, otherwise when he log out, it'll save the old one.

Re: Mysql - Loinal - 03.07.2017

Quote:
Originally Posted by Meller
Посмотреть сообщение
PHP код:
CMD:setpassword(playerid, params[]) 
{ 
    if(pData[playerid][Admin] >= 7) 
    { 
        new query[320], name[24], newpass[34], hash1[34],query1[320]; 
        if(sscanf(params, "s[24]s[34]", name, newpass)) return SendClientMessage(playerid, COLOR_YELLOW, "USAGE: /setpassword <PlayerName> <NewPassword>"); 
        if(!AccountExists(name)) return SendClientMessage(playerid, red, "Account does not exists"); 
        format(query1, sizeof(query1), "You have changed %s's password to %s", name, newpass); 
        SendClientMessage(playerid, COLOR_GREEN, query1); 
        new IRC[130]; 
        format(IRC, sizeof(IRC), "1,8* Admin %s (ID: %d) changed %s's password.",GetName(playerid), playerid, name); 
        IRC_GroupSay(groupID, "&#ZoneX", IRC); 
        IRC_GroupSay(groupID, IRC_aCHANNEL, IRC); 
        WP_Hash(hash1, 129, newpass); 
        mysql_format(mysql, query, sizeof(query), "UPDATE `players` SET `Password` = '%s' WHERE `Username` = '%e'", hash1, name); 
        mysql_tquery(mysql, query); 
        new name2[MAX_PLAYER_NAME];
        for(new targetid = 0, maxid = GetPlayerPoolSize(); targetid <= maxid; targetid++) {
            if(IsPlayerConnected(targetid)) {
                GetPlayerName(targetid, name2, MAX_PLAYER_NAME);
                if(!strcmp(name, name2)) {
                    //Player is online, set his password variable to new password, example:
                    format(pData[playerid][Password], sizeof(Password), "%s", hash1);
                    break;
                }
            }
        }
        return 1; 
    } 
    else return ShowMessage(playerid, COLOR_YELLOW, 1, 7); 
} 
You must set his variable to the new has aswell if he's online, otherwise when he log out, it'll save the old one.
Could you explain the last part you have added also iam getting error

Код:
format(pData[playerid][Password], sizeof(Password), "%s", hash1);

D:\samp folder\ZoneX - ZX\gamemodes\ZoneX.pwn(3058) : error 039: constant symbol has no size


Re: Mysql - Meller - 03.07.2017

Replace sizeof(Password) with the cell usage of Password, it should be easy to find if you actually know what you're doing:

Go to the enum you're storing the player variables at and look for Password[cells], take that cell number and replace it with sizeof(..)

Re: Mysql - Loinal - 03.07.2017

Quote:
Originally Posted by Meller
Посмотреть сообщение
Replace sizeof(Password) with the cell usage of Password, it should be easy to find if you actually know what you're doing:

Go to the enum you're storing the player variables at and look for Password[cells], take that cell number and replace it with sizeof(..)
done, also the same problem password doesn't change

Re: Mysql - Sew_Sumi - 03.07.2017

Or create a define MAX_PASS_SIZE and use that for any and all of your password strings.


Just rather than putting in [34] in to code, to find out later you need to change it somewhere and because you hardcoded the value rather than making something like this, you have more bugs and confusion.


I'm just gonna say, are you sure the password set feature is actually working?

Re: Mysql - Loinal - 03.07.2017

Quote:
Originally Posted by Sew_Sumi
Посмотреть сообщение
Or create a define MAX_PASS_SIZE and use that for any and all of your password strings.


Just rather than putting in [34] in to code, to find out later you need to change it somewhere and because you hardcoded the value rather than making something like this, you have more bugs and confusion.


I'm just gonna say, are you sure the password set feature is actually working?
I'm just gonna say, are you sure the password set feature is actually working?
No.

Re: Mysql - Sew_Sumi - 04.07.2017

What I'm more hinting at, is the login system actually accepting all passwords, and not just the ones you are using here.

The first 2 lines of my response were in response to Mellers suggestion to use hardcoded sizes for the string. (Make define of MAX_PASS_SIZE)