mysql syntax error in function but works in navicat

[Invictus 24]

edit - its now returning a value ingame ( the value 256 :S) but its saying there's a syntax error in the code but in navicat it returns the correct value as it should :/

putty error

function

function max_level(x)
    local ranking = os.execute("mysql -u root --execute='SELECT `name` FROM player.player WHERE `name` NOT LIKE '[%]%' ORDER BY `level` DESC, `exp` DESC LIMIT 0,1'")
    
    local topp1 = ranking
    
   
    if pc.get_name() == topp1 then
        return topp1
    else
        return topp1         --to test if its actually got any value in topp1
    end
end

 

quest

quest ranking begin
    state start begin

        when 52003.use begin
            local max = max_level()
            notice_all(max) --always returns an empty value, in the chat just shows up empty.
            
        end
    end
end

Edited August 15, 2022 by Metin2 Dev
Core X - External 2 Internal

[RoxaLyssa 301]

Why do you use os.execute if you could use the mysql_query function too?