Hello, i have a problem, but can't resolve it.
Code:
public OnPluginStart()
{
...
SQL_TConnect(GotDatabase, "vote_vs");
}
public GotDatabase(Handle:owner, Handle:hndl, const String:error[], any:data)
{
if (hndl == INVALID_HANDLE)
{
SetFailState("Error connecting to database. %s", error);
} else {
Database = hndl;
}
}
public OnMapStart()
{
g_VoteNum = 0;
s_VoteNumFirst = 0;
s_VoteNumSecond = 0;
s_VoteNameFirst = "";
s_VoteNameSecond = "";
new String:query[255];
Format(query, sizeof(query), "SELECT * FROM vote ORDER BY id DESC LIMIT 1");
new Handle:query_r = SQL_Query(Database, query);
if(SQL_FetchRow(query_r) == false) {
PrintToServer("[Votes] Can't fetch row.");
} else {
PrintToServer("[Votes] Fetched row");
g_VoteNum = SQL_FetchInt(query_r, 0);
s_VoteNumFirst = SQL_FetchInt(query_r, 1);
s_VoteNumSecond = SQL_FetchInt(query_r, 2);
SQL_FetchString(query_r, 3, s_VoteNameFirst, 256);
SQL_FetchString(query_r, 4, s_VoteNameSecond, 256);
}
CloseHandle(query_r);
}
It give me an error
Code:
Native "SQL_Query" reported: Invalid database Handle 0 (error: 4)
Database setting is all okey!