Good morning, I have an unsolved problem when making a query with SQLite, in the DB Browser for SQLite program the query returns normally with all the information, but when trying to perform the query in the game I get the following error:
Code:
Error: near "(": syntax error
The querie
PHP Code:
SELECT ROW_NUMBER() OVER (ORDER BY 1.0 * kills / deaths DESC) Pos, kills, deaths, auth FROM tablename WHERE enabled = 1 AND kills > 0 AND deaths > 0 AND kills > 100;
PHP Code:
#define SQL_QUERY_CATCH_UPDATED_RANK "SELECT ROW_NUMBER() OVER (ORDER BY 1.0 * kills / deaths DESC) Pos, kills, deaths, auth FROM %s WHERE enabled = 1 AND kills > 0 AND deaths > 0 AND kills > 100;"
public UpdatedRank(id)
{
new szQuery[180]
formatex
(
szQuery,
charsmax(szQuery),
SQL_QUERY_CATCH_UPDATED_RANK,
SQL_TABLE
)
new szData[2]
szData[0] = QUERY_UPDATE_RANK
szData[1] = id
SQL_ThreadQuery(g_hTuple,"SQL_HandleGlobal",szQuery,szData,sizeof(szData))
return PLUGIN_HANDLED
}
public SQL_HandleGlobal(iState,Handle:hResult,szError[],iError,szData[],iSize)
{
if(iState == TQUERY_SUCCESS)
{
switch(szData[0])
{
case QUERY_UPDATE_RANK:
{
if(is_user_connected(szData[1]))
{
if(SQL_NumRows(hResult))
{
new szSteamid[MAX_AUTHID_LENGTH]
new iPos
while(SQL_MoreResults(hResult))
{
iPos = SQL_ReadResult(hResult, 0)
SQL_ReadResult(hResult, 3, szSteamid, charsmax(szSteamid))
if(equal(szSteamid, userData[szData[1]][szAuth]))
{
userData[szData[1]][Rank] = iPos
}
SQL_NextRow(hResult)
}
}
}
}
}
}
else
{
log_amx("Error: %s", szError)
}
}
__________________