SA-MP Forums Archive
SQLite database problem. - 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: SQLite database problem. (/showthread.php?tid=586677)


SQLite database problem. - DarkLored - 24.08.2015

Hello everyone, I have been trying to store the IP of a player upon register but it gets mixed up with the password and the username so It's impossible to login.

here is my code

pawn Код:
new Query[500];
            GetPlayerIp(playerid, dAdmin[playerid][USER_IP], 16);
            WP_Hash(dAdmin[playerid][USER_PASSWORD], 129, inputtext);
            format(Query, sizeof(Query), "INSERT INTO users (username, password, ip) VALUES ('%s', '%s', '%s')", DB_Escape(dAdmin[playerid][USER_NAME]), DB_Escape(dAdmin[playerid][USER_PASSWORD]), DB_Escape(dAdmin[playerid][USER_IP]));
            db_query(AdminSys, Query);