auto donate castle system error

[magista]

hey men i have this error

when i use this script
http://otland.net/threads/donation-castle-system-automatic.193348/

also need to know where to get character id
thx
plz any 1 help me !!

 

[Xikini]

You'll need to have the 'castles' in town 4, or change the town it checks for them.
the character ID will be in your database. (localhost website thing) Find your god character, and look for it's characters ID.

 

[magista]

there is no character id it's account id ....... and i already change town

 

[Xikini]

are you looking in accounts, or players?
It should show the 'id' of the player before clicking on it to see more details.

 

[magista]

aha thx

 

[magista]

1- is that character id
2- the script don't work

 

[Cronox]

¿What Version TFS are you using?
and what ID is your admin?
give me your admin char id.
NO in your accounts ,in your table players

try this:

function onThink()
    local castles = db.getResult('SELECT id FROM houses WHERE town=4')
    if castles:getID() == -1 then
        return true
    end

    local p = getPlayersOnline()[1]
    local idadmn = ... 
    repeat
        local hid = castles:getDataInt('id')
        local h = getHouseInfo(hid)
        if h.owner == idadmn then
            setHouseOwner(hid, idadmn)
        elseif p then
            local n = tonumber(h.name:sub(-2)) or 0
            h.entry.x = h.entry.x + (n % 2 == 0 and 3 or -3)
            doCreatureSay(p, getPlayerNameByGUID(h.owner), TALKTYPE_ORANGE_1, false, 0, h.entry)
        end
    until not castles:next()
    castles:free()

    return true
end

edit here:
local idadmn = ... <-- add your admin ID..

 

[Xikini]

1- is that character id
2- the script don't work

If it wasn't that id, I was misleading you then.
I don't know where it is

 

[kafo]

Try This

function onThink()
local castles = db.getResult('SELECT id FROM houses WHERE town=20')
if castles:getID() == -1 then
return true
end

local p = getPlayersOnline()[1]
repeat
local hid = castles:getDataInt('id')
local h = getHouseInfo(hid)
if h.owner == 0 then
setHouseOwner(hid, 1954)
elseif p then
local n = tonumber(h.name:sub(-2)) or 0
h.entry.x = h.entry.x + (n % 2 == 0 and 3 or -3)
end
until not castles:next()
castles:free()

return true
end
[code=lua]

 

[magista]

¿What Version TFS are you using?
and what ID is your admin?
give me your admin char id.
NO in your accounts ,in your table players

try this:

function onThink()
    local castles = db.getResult('SELECT id FROM houses WHERE town=4')
    if castles:getID() == -1 then
        return true
    end

    local p = getPlayersOnline()[1]
    local idadmn = ...
    repeat
        local hid = castles:getDataInt('id')
        local h = getHouseInfo(hid)
        if h.owner == idadmn then
            setHouseOwner(hid, idadmn)
        elseif p then
            local n = tonumber(h.name:sub(-2)) or 0
            h.entry.x = h.entry.x + (n % 2 == 0 and 3 or -3)
            doCreatureSay(p, getPlayerNameByGUID(h.owner), TALKTYPE_ORANGE_1, false, 0, h.entry)
        end
    until not castles:next()
    castles:free()

    return true
end

edit here:
local idadmn = ... <-- add your admin ID..

look at the pic i posted bro is that the char id ??

Try This

function onThink()
local castles = db.getResult('SELECT id FROM houses WHERE town=20')
if castles:getID() == -1 then
return true
end

local p = getPlayersOnline()[1]
repeat
local hid = castles:getDataInt('id')
local h = getHouseInfo(hid)
if h.owner == 0 then
setHouseOwner(hid, 1954)
elseif p then
local n = tonumber(h.name:sub(-2)) or 0
h.entry.x = h.entry.x + (n % 2 == 0 and 3 or -3)
end
until not castles:next()
castles:free()

return true
end
[code=lua][/QUOTE]
thx for the script but i want to know which one is player id in the pic i posted comment number 6

 

[kafo]

Choose Your Admin ID!!

 

[magista]

Choose Your Admin ID!!

oki thx
another question plz when i trying to write somthings on the ot have a cancel message " you cannot send this message " how to fix this ??