11.02.2012, 16:03
make sure your MySQL connection collation is utf8_unicode_ci . Some databases won't work on others. Also under OnPlayerConnect:
Ip is Column inside table, not SQL Syntax so it has to be inside ``.
pawn Код:
format(query, sizeof(query), "SELECT IP FROM `playerdata` WHERE user = '%s' LIMIT 1", pname);
mysql_query(query);
pawn Код:
format(query, sizeof(query), "SELECT `IP` FROM `playerdata` WHERE `user` = '%s' LIMIT 1", pname);
mysql_query(query);