Mysql little problem
#4

This is a exemple when the dialog response

pawn Код:
new
                query[256],
                playerName[MAX_PLAYER_NAME],
                escapedName[MAX_PLAYER_NAME],
                escapedPassword[129];

            GetPlayerName(playerid, playerName, MAX_PLAYER_NAME);      
            WP_Hash(escapedPassword, sizeof(escapedPassword), inputtext);
            mysql_real_escape_string(inputtext, escapedPassword);
           
            mysql_real_escape_string(playerName, escapedName);

            format(query, sizeof(query), "SELECT * FROM `[YourAccounts]` WHERE [yourfield]= '%s' AND [passfield] = '%s'", escapedName, escapedPassword);
            mysql_query(query, [YourQuery], playerid);
NOTE: YOU HAVE TO CHANGE THE PARAMS IN [ ]
Reply


Messages In This Thread
Mysql little problem - by Tigerkiller - 10.08.2011, 22:31
Re: Mysql little problem - by Vince - 10.08.2011, 22:37
Re: Mysql little problem - by Tigerkiller - 10.08.2011, 22:40
Re: Mysql little problem - by TheArcher - 10.08.2011, 23:28

Forum Jump:


Users browsing this thread: 1 Guest(s)