This script dont work for me???

[Lucifer]

Why do this script dont work for my ot?
I have client 10.98 and TFS 1.2

local function getHighestPlayer()
     local result = db.getResult("SELECT `name` FROM `players` WHERE `group_id` < 4 ORDER BY `level` DESC, `experience` DESC LIMIT 1")
     return result.getDataString(result, "name")
end

function onThink(interval)
    if getHouseOwner(2801) ~= getPlayerGUIDByName(getHighestPlayer()) then
    doBroadcastMessage("Congratulations "..getHighestPlayer().."! You're now the highest level, and have been rewarded with the TP house right next to bridge.")
    setHouseOwner(2801, getPlayerGUIDByName(getHighestPlayer()))
    end
    return true
end

<globalevent name="Bridgehouse" interval="10000" event="script" value="houseowner.lua"/>

Can someone help me?

 

[hodleo]

function getPlayerNameByGUID(guid)
    local resultId, name = db.storeQuery("SELECT `name` FROM `players` WHERE `id` = " .. guid), "Unknown"
    if resultId then
        name = result.getDataString(resultId, 'name')
        result.free(resultId)
    end
    return name
end

local function getHighestPlayer()
    local resultId, v = db.storeQuery("SELECT `id` FROM `players` WHERE `group_id` < 4 ORDER BY `level` DESC, `experience` DESC LIMIT 1;"), 0
    if resultId then
        v = result.getDataInt(resultId, 'id')
        result.free(resultId)
    end   
    return v
end

function onThink(interval)
    local v = getHighestPlayer()
    if(v > 0) and (getHouseOwner(2801) ~= v) then
        doBroadcastMessage("Congratulations ".. getPlayerNameByGUID(v) .."! You're now the highest level, and have been rewarded with the TP house right next to bridge.")
        setHouseOwner(2801, v)
    end
    return true
end

 

[Lucifer]

I Hate this, forgot the code is not same from 0.36 tfs and 1.2 xD

Thank you Cbrm <3

Edit: but the script dont work... It dont show nothing. NO bug and dont working...
@cbrm