SA-MP Forums Archive
I have problems about MySQL Plugins - 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: I have problems about MySQL Plugins (/showthread.php?tid=540090)


I have problems about MySQL Plugins - Galletziz - 02.10.2014

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.

Re: I have problems about MySQL Plugins - Ox1gEN - 02.10.2014

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.