I have problems about MySQL Plugins
#1

Hi Boyz, i have searched a good MySQL Plugin but i don't found no one that was good. I have read more topics and the 90% of the links for downloads plugins are corrupted, so i have tryed to use R33 mysql plugin and all works good but when i try to INSERT a Whirlpool cripted string in some field (like password field for each user) it is not written. I show this example:

pawn Код:
new query[160], hashpwrd[129], nome_player[MAX_PLAYER_NAME];
            GetPlayerName(playerid,nome_player,sizeof(nome_player));
            WP_Hash(hashpwrd,129,inputtext);
            mysql_format(connessione_db,query,sizeof(query),"INSERT INTO `accounts_gm`(`gm_ID`, `gm_account`, `gm_pwrd`) VALUES ('','%e','%s')",nome_player,hashpwrd);
            mysql_query(connessione_db,query);
           
            printf(hashpwrd); //just for debuging and works
            SendClientMessage(playerid,-1,hashpwrd); //same...
in a users password field on my database nothing is written, but the ID and the name of the player yes is written inside owns fields... someone can help me, thanks.
Reply
#2

The ID is automaticly written inside mysql, so remove the gm_ID part, and the gm_account part use %s specifier and in the gm_pwrd part use the %e specifier.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)