MYSQL insert type text
#1

Код:
new string[130], insertlog[sizeof(message)];
			mysql_escape_string(message, insertlog);
			mysql_format(SQLHandle,string, sizeof(string), "INSERT INTO `admin_log`(`logs`) VALUES ('%s')", insertlog);
			mysql_tquery(SQLHandle, string, "", "");
if there is something wrong ?, in empty logs are not filled.
Reply
#2

Hello!

So it is good:
PHP код:
new string[130];
mysql_format(SQLHandle,string,sizeof string,"INSERT INTO `admin_log` (`logs`) VALUES ('%e')",insertlog);
mysql_tquery(SQLHandle,string,"",""); 
Reply
#3

same problem
Reply
#4

PHP код:
format(messagesizeof(message), "[ADMIN LOG]ID:<%d>(%s) have changed ID:<%d>(%s) VIP to level (%d) With (%s).",g_PlayerInfo[playerid][pSQLid],GetPlayerNameEx(playerid),g_PlayerInfo[target][pSQLid],GetPlayerNameEx(target), level,log_option);
            
printf(message);
            new 
string[130];
            
mysql_format(SQLHandle,stringsizeof string"INSERT INTO `admin_log` (`logs`) VALUES ('%e')"message);
            
mysql_tquery(SQLHandle,string,"",""); 
Here code
Reply
#5

Is the string "message" shown in your console?
Also, have you tried to increase the "string" length ?
Reply
#6

yes, it's shown
Reply
#7

Try to increase your string length. Otherwise, can you show your phpMyAdmin table structure?
Reply
#8

Reply
#9

What does mysql_log.txt say?
Reply
#10

Nothing,
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)