Help Mysql?[+REP]
#5

Sure it won't save because this part specially. '%d/%d/%d %d:%d:%d', bad way to do this. you can easily get the date and time from your data base using the following steps:



now you won't update your query, it will automatically get the date and time of the day.
pawn Код:
format(query, sizeof(query), "INSERT INTO `Bans` (`Nick`, `UserIP`, `Admin`, `Reason`, `Unix`) VALUES('%e', '%s', '%s', '%s', '%d', '%d', '%d', '%s', '%d')", receivername, receiverip, sendername,, reason, 999999999999999999999999);
Try this codes if you still have problems check your mysql.logs and post them here.
Reply


Messages In This Thread
Help Mysql?[+REP] - by PAF - 13.06.2014, 00:45
Re: Help Mysql?[+REP] - by SilentSoul - 13.06.2014, 01:29
Re: Help Mysql?[+REP] - by PAF - 13.06.2014, 01:38
Re: Help Mysql?[+REP] - by PAF - 13.06.2014, 01:43
Re: Help Mysql?[+REP] - by SilentSoul - 13.06.2014, 01:52
Re: Help Mysql?[+REP] - by PAF - 13.06.2014, 01:56

Forum Jump:


Users browsing this thread: 1 Guest(s)