Running this code returns will always retrurn 1 even though the table has more than 1000 entries.
Code:
#include <amxmodx>
#include <sqlx>
new MYSQL_HOST[] = ""
new MYSQL_USER[] = ""
new MYSQL_PASSWORD[] = ""
new MYSQL_DATABASE[] = ""
new MYSQL_TABLE[] = ""
new Handle: MYSQL_CONNECTION
public plugin_init(){
register_srvcmd("CountEntries", "CountEntries")
}
public plugin_cfg(){
MYSQL_CONNECTION = SQL_MakeDbTuple(MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE)
}
public CountEntries(){
new query[64]
formatex(query, charsmax(query), "SELECT COUNT(*) FROM `%s`;", MYSQL_TABLE)
new entries = SQL_ThreadQuery(MYSQL_CONNECTION, "SQLCountEntries", query)
server_print("entries[%d]", entries)
}
public SQLCountEntries(failState, Handle:query, error[], errNum){
new entries = 0
if(SQL_NumResults(query)){
entries = SQL_ReadResult(query, 0)
}
return entries
}