Problem with saving chatlogs in MySQL
#1

This is what happens at OnPlayerText:

Код:
    static query[168 + 50];
    format(query, sizeof(query), "INSERT INTO chatlogs(acc_dbid, acc_name, playerid, time, text) VALUES('%i', '%e', '%i', UTC_TIMESTAMP(), '%e')", PlayerInfo[playerid][pDBID], ReturnName(playerid), playerid, text);
    mysql_tquery(g_SQL, query);
this is what happens in the database:



The only working lines are the database ID and the time. What did I do wrong here? I can't see it.
Reply
#2

%e only works with `mysql_format` function.
Reply
#3

Quote:
Originally Posted by Calisthenics
Посмотреть сообщение
%e only works with `mysql_format` function.
Cheers mate!
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)