16.07.2012, 09:44
Personally with the latest version, I get an error when using mysql_format.
with code:
Code:
[12:34:08] [debug] Server crashed while executing newegDB.amx [12:34:08] [debug] AMX backtrace: [12:34:08] [debug] #0 native mysql_format () [007fc5e0] from mysql.so [12:34:08] [debug] #1 000909c0 in MySQLConnectAccount (playerid=14) at I:\_eGaming\samp\_new_mysql-0.3d\__CORECTAT0.3c\pawno-3\include\eG_functii/eG_xan_mysql_func.inc:130
pawn Code:
stock MySQLConnectAccount(playerid)
{
new query[220], plname[MAX_PLAYER_NAME];
GetPlayerName(playerid, plname, sizeof(plname));
line130 ---> mysql_format(connectionHandle, query, "SELECT players.id,coalesce(players_logins.time ,UNIX_TIMESTAMP(NOW())) FROM players LEFT JOIN players_logins ON players.id=players_logins.userid WHERE LOWER(players.Name) = LOWER('%e')", plname);
mysql_function_query(connectionHandle, query, true, "ConnectThread", "d", playerid);
return 1;
}