mySQL saving
#10

There is a problem with the query to insert the account, see this line:
Код:
 mysql_format(mysql, query, sizeof(query), "INSERT INTO accounts (Name, Password, IP, Admin, VIP, Money, Group, GroupRank, Kills, Deaths, Score, HighKS) VALUES('%e','%e','%e',0,0,0,0,0)", GetName(playerid), PlayerInfo[playerid][Password],playerip,PlayerInfo[playerid][Kills],PlayerInfo[playerid][Deaths],
                        PlayerInfo[playerid][Score],PlayerInfo[playerid][HighKS]);
It will be giving you an error in the MySQL log. You are inserting into 12 columns (Name, Password, IP, Admin, VIP, Money, Group, GroupRank, Kills, Deaths, Score, HighKS) but only providing 8 values (VALUES('%e','%e','%e',0,0,0,0,0)). Thus the query is not successful and OnAccountRegister will never be called.
Reply


Messages In This Thread
mySQL saving - by NealPeteros - 02.01.2018, 09:57
Re: mySQL saving - by MEW273 - 02.01.2018, 10:00
Re: mySQL saving - by NealPeteros - 02.01.2018, 10:14
Re: mySQL saving - by NealPeteros - 02.01.2018, 21:50
Re: mySQL saving - by GTLS - 03.01.2018, 07:44
Re: mySQL saving - by NealPeteros - 03.01.2018, 09:56
Re: mySQL saving - by NealPeteros - 05.01.2018, 09:21
Re: mySQL saving - by NealPeteros - 06.01.2018, 07:53
Re: mySQL saving - by NealPeteros - 06.01.2018, 08:09
Re: mySQL saving - by MEW273 - 06.01.2018, 08:10

Forum Jump:


Users browsing this thread: 2 Guest(s)