Not Update
#1

Код HTML:
mysql_format(MySQL, query, sizeof(query), "UPDATE `players` SET `Admin`=%d WHERE `ID`=%d", pInfo[id][pAdmin], pInfo[id][pID]);
mysql_tquery(MySQL, query, "", "");
print(query); //Debug
Debug Log:
Код HTML:
[08:26:54] (null)
Reply
#2

Are you sure that query is a string ?
Код:
query[60];
Код:
This forum requires that you wait 120 seconds between posts. Please try again in 37 seconds.
I don't want to come to this planet anymore.
Reply
#3

Yes, "query" is string.
Код HTML:
new query[254];
Reply
#4

It'd print "(null)" only if both functions failed which is your case. Check the mysql logs because either the connection to mysql server was not successful or invalid connection handle.
Reply
#5

MYSQL ERROR:
Reply
#6

Yeah, it's an invalid connection handle. In On GameMode/FilterScript Init:
pawn Код:
MySQL = mysql_connect(...);
Reply
#7

Код HTML:
[09:05:47] Successfully connected to MySQL database.
Reply
#8

Solved.
@Konstantinos: Thank you.
Reply


Forum Jump:


Users browsing this thread: 3 Guest(s)