Problem with mysql + ban system.
#1

I'm trying to make a temporary ban system on my gm

The problem is that the function INSERT INTO not inserting the correct value. Are entering "49"

Code:
pawn Код:
new Str[398] tmp3[25];
    format(tmp3, 25,"%i",gettime());
    print(tmp3); //Just to check .. printed 1383943912
    format(Str, 148, "INSERT INTO `banlist`(`IP`, `Nome`, `Nick`, `Admin`, `Motivo`, `TempoBan`, `DataBan`, `HoraBan`, `TempoUnban`, `Pic1`, `Pic2`, `Pic3`, `Detalhes`)");
    format(Str, 398, "%s VALUES ('%s','%s','%s','%s','%s','%i','%s','%s','%i','---','---','---','In-Game')", Str, ip, PlayerName(playerid),PlayerName(playerid), string2, string, string3, tmp, tmp2, tmp3);
    mysql_function_query(Connect, Str, false, "", "");
Result:
pawn Код:
INSERT INTO `banlist`(`IP`, `Nome`, `Nick`, `Admin`, `Motivo`, `TempoBan`, `DataBan`, `HoraBan`, `TempoUnban`, `Pic1`, `Pic2`, `Pic3`, `Detalhes`) VALUES ('127.0.0.1','ViNi_TensO','ViNi_TensO','ViNi_TensO','asdf','2','8/11/2013','18:51:52','49','---','---','---','In-Game')
Was to enter "1383943912" and not 49, I've tried several ways most do not find the solution please help me !
Reply


Messages In This Thread
Problem with mysql + ban system. - by iryston - 08.11.2013, 20:18
Re: Problem with mysql + ban system. - by MyLife - 08.11.2013, 20:27
Re: Problem with mysql + ban system. - by -Prodigy- - 08.11.2013, 20:32
Re: Problem with mysql + ban system. - by iryston - 08.11.2013, 20:34

Forum Jump:


Users browsing this thread: 1 Guest(s)