mysql problem
#1

the print is correct but... it doesnt input it into the database, it inputs id 0 unbandate 0 and nothing else

pawn Код:
[17:02:04] INSERT INTO Bans (`Banid`,`Name`,`IP`,`UnbanDate`,`Reason`) VALUES (1,'Nerd','192.168.1.10',20,'Auto Speed Hack Ban')
pawn Код:
new bEscape[3][80];
    mysql_real_escape_string(Playername(playerid),bEscape[0]);
    mysql_real_escape_string(ip,bEscape[1]);
    mysql_real_escape_string(reason,bEscape[2]);
    format(GlobalQuery1, sizeof(GlobalQuery1), "INSERT INTO Bans (`Banid`,`Name`,`IP`,`UnbanDate`,`Reason`) VALUES (%d,'%s','%s',%d,'%s')",TempBans[s][Banid],bEscape[0],bEscape[1],TempBans[s][UnbanDate],bEscape[2]);
    printf(GlobalQuery1);
    mysql_query(GlobalQuery1);
Reply


Messages In This Thread
mysql problem - by The_Gangstas - 05.12.2010, 20:04
Re: mysql problem - by Think - 05.12.2010, 20:07
Re: mysql problem - by The_Gangstas - 05.12.2010, 20:11
Re: mysql problem - by Think - 05.12.2010, 20:13
Re: mysql problem - by The_Gangstas - 05.12.2010, 20:14
Re: mysql problem - by Think - 05.12.2010, 20:16
Re: mysql problem - by The_Gangstas - 05.12.2010, 20:21
Re: mysql problem - by Think - 05.12.2010, 20:28
Re: mysql problem - by The_Gangstas - 05.12.2010, 20:33

Forum Jump:


Users browsing this thread: 1 Guest(s)