Mysql Not Saving
#7

Quote:
Originally Posted by Eth
Посмотреть сообщение
which mysql version are u using?
also try this:
pawn Код:
format(tquery, sizeof(tquery), "INSERT INTO `accounts` (`Username`, `Password`, `IP`, `Skin`, `Cash`, `Bank`, `Gold` ,`Level`, `Respect`, `Admin`, `Helper`, `VIP`, `Tutorial`, `X`, `Y`, `Z`, `A`, `INT`, `VW`, `Health`) VALUES ('%s', '%s', '%s', '26', '5000', '10000', '1', '1', '0', '0', '0', '0','0', '0.0', '0.0', '0.0', '0.0', '0', '0', '100.0')", RPNU(playerid), hashpass, PlayerInfo[playerid][pIP]);
try to delete the other format(tquary but save it in a notepad and if u got no errors in this one, then add one ' at the start and one ' at the end of every variable
You have been told several times that ' ' are only for strings, and ` ` aren't necessary at all.



OT: Remove the ` ` and the ' ' on integers. ' ' is only for string specifiers (%s).

Btw: if you are updating, like saving why are you use an INSERT statement?
Reply


Messages In This Thread
Mysql Not Saving - by trapstar2020 - 21.09.2014, 01:05
Re: Mysql Not Saving - by Eth - 21.09.2014, 01:20
Re: Mysql Not Saving - by trapstar2020 - 21.09.2014, 01:29
Re: Mysql Not Saving - by Eth - 21.09.2014, 01:32
Re: Mysql Not Saving - by trapstar2020 - 21.09.2014, 01:54
Re: Mysql Not Saving - by Eth - 21.09.2014, 04:50
Re: Mysql Not Saving - by Ox1gEN - 21.09.2014, 05:33
Re: Mysql Not Saving - by trapstar2020 - 21.09.2014, 08:48

Forum Jump:


Users browsing this thread: 1 Guest(s)