Mysql not logging password
#2

First of all, you're using the "PlayerPos" field wrong. Execute these SQL queries:

pawn Код:
ALTER TABLE `Accounts`
    ADD COLUMN `PlayerX` FLOAT DEFAULT 0.0,
    ADD COLUMN `PlayerY` FLOAT DEFAULT 0.0,
    ADD COLUMN `PlayerZ` FLOAT DEFAULT 0.0;
And use this code instead:

pawn Код:
stock RegisterPlayer(playerid, regpass[])
{
    new query[256], EncryptedPass[130];
               
    WP_Hash(EncryptedPass, sizeof(EncryptedPass), regpass);
   
    format(query, sizeof(query), "INSERT INTO `accounts` (`Name`, `Password`, `PlayerX`, `PlayerY`, `PlayerZ`, `Skin`) VALUES ('%s', '%s', '1.0', '2.0', '3.0', 299)", GetName(playerid), EncryptedPass);
    mysql_query(query);
   
    LoginPlayer(playerid);
   
    return 1;
}
If that doesn't work, then you're improperly using the function in your code somewhere.
Reply


Messages In This Thread
Mysql not logging password - by Blademaster680 - 05.08.2013, 06:09
Re: Mysql not logging password - by Emmet_ - 05.08.2013, 06:13
Re: Mysql not logging password - by Blademaster680 - 05.08.2013, 06:50

Forum Jump:


Users browsing this thread: 1 Guest(s)