• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!
  • 2026 staff recruitment is open! Check it out and consider applying!

Problem with script

Z

Zonkill

Banned User
Joined
Oct 10, 2010
Messages
102
Reaction score
1
Hey.
I have error, when i turn on my OTS it is:
Code: 
[14:6:21.048] [Error - GlobalEvent Interface] 
[14:6:21.049] data/globalevents/scripts/demon_castle.lua:onThink
[14:6:21.049] Description: 
[14:6:21.049] data/globalevents/scripts/demon_castle.lua:4: attempt to call field 'executeQuery' (a nil value)
[14:6:21.049] stack traceback:
[14:6:21.049] 	data/globalevents/scripts/demon_castle.lua:4: in function <data/globalevents/scripts/demon_castle.lua:1>
[14:6:21.049] [Error - GlobalEvents::think] Couldn't execute event: DemonCastle

demoncastle.lua:
Code: 
  function onThink(interval, lastExecution) 
local timeToClose = 300 --in seconds(5 minutes)
local timeToKickPlayers = 1020 --time to kick the players from the castle(1020 = 17 minutes)
        db.executeQuery("UPDATE `players` SET `event` = 1;")
        doBroadcastMessage("Demon Castle otwarty! Wejscie zostanie zamkniete za 5 minut.")
        addEvent(closeCastle, (1000*timeToClose))
        addEvent(kickPlayersFromCastle, (1000*timeToKickPlayers))
        return TRUE
end
function closeCastle()
        db.executeQuery("UPDATE `players` SET `event` = 0;")
        doBroadcastMessage("Demon castle zamkniety!")
        return TRUE
end
function kickPlayersFromCastle()
local position =
{
        fromPosCastle1 = {x=1036, y=1391, z=11},
        toPosCastle1 = {x=1144, y=1428, z=11},
        fromPosCastle2 = {x=1036, y=1391, z=11},
        toPosCastle2 = {x=1144, y=1428, z=11},
        fromPosCastle3 = {x=1036, y=1391, z=11},
        toPosCastle3 = {x=1144, y=1428, z=11},
        fromPosCastle4 = {x=1036, y=1391, z=11},
        toPosCastle4 = {x=1144, y=1428, z=11},
        newPos = {x=1000, y=1000, z=7}
}
local weapon = {
        sword = 11393, --Divine sword of the archangel
        staff = 11394, --Divine staff of the archangel
        crossbow = 11395 --Divine crossbow of the archangel
}
local playersOnline = getPlayersOnline()
        for _, pid in ipairs(playersOnline) do
                if isInArea(getCreaturePosition(pid), position.fromPosCastle1, position.toPosCastle1) then
                        doTeleportThing(pid, position.newPos)
                        doPlayerRemoveItem(pid, weapon.sword, getPlayerItemCount(pid, weapon.sword))
                        doPlayerRemoveItem(pid, weapon.staff, getPlayerItemCount(pid, weapon.staff))
                        doPlayerRemoveItem(pid, weapon.crossbow, getPlayerItemCount(pid, weapon.crossbow))
                elseif isInArea(getCreaturePosition(pid), position.fromPosCastle2, position.toPosCastle2) then
                        doTeleportThing(pid, position.newPos)
                        doPlayerRemoveItem(pid, weapon.sword, getPlayerItemCount(pid, weapon.sword))
                        doPlayerRemoveItem(pid, weapon.staff, getPlayerItemCount(pid, weapon.staff))
                        doPlayerRemoveItem(pid, weapon.crossbow, getPlayerItemCount(pid, weapon.crossbow))
                elseif isInArea(getCreaturePosition(pid), position.fromPosCastle3, position.toPosCastle3) then
                        doTeleportThing(pid, position.newPos)
                        doPlayerRemoveItem(pid, weapon.sword, getPlayerItemCount(pid, weapon.sword))
                        doPlayerRemoveItem(pid, weapon.staff, getPlayerItemCount(pid, weapon.staff))
                        doPlayerRemoveItem(pid, weapon.crossbow, getPlayerItemCount(pid, weapon.crossbow))
                elseif isInArea(getCreaturePosition(pid), position.fromPosCastle4, position.toPosCastle4) then
                        doTeleportThing(pid, position.newPos)
                        doPlayerRemoveItem(pid, weapon.sword, getPlayerItemCount(pid, weapon.sword))
                        doPlayerRemoveItem(pid, weapon.staff, getPlayerItemCount(pid, weapon.staff))
                        doPlayerRemoveItem(pid, weapon.crossbow, getPlayerItemCount(pid, weapon.crossbow))
                end
        end
        return TRUE
end

edit:
I added to database and still error. players > 'event'
Code: 
ALTER TABLE `players` ADD COLUMN `event` INT( 11 ) NOT NULL DEFAULT '0'
i dalej.
 
Sort by date Sort by votes
Dont need update to 1 or not.
dont have any query looking for event ?

Code: 
function onThink(interval, lastExecution) 
local timeToClose = 300 --in seconds(5 minutes)
local timeToKickPlayers = 1020 --time to kick the players from the castle(1020 = 17 minutes)
      --  db.executeQuery("UPDATE `players` SET `event` = 1;")
        doBroadcastMessage("Demon Castle otwarty! Wejscie zostanie zamkniete za 5 minut.")
        addEvent(closeCastle, (1000*timeToClose))
        addEvent(kickPlayersFromCastle, (1000*timeToKickPlayers))
        return TRUE
end
function closeCastle()
    --   db.executeQuery("UPDATE `players` SET `event` = 0;")
        doBroadcastMessage("Demon castle zamkniety!")
        return TRUE
end
function kickPlayersFromCastle()
local position =
{
        fromPosCastle1 = {x=1036, y=1391, z=11},
        toPosCastle1 = {x=1144, y=1428, z=11},
        fromPosCastle2 = {x=1036, y=1391, z=11},
        toPosCastle2 = {x=1144, y=1428, z=11},
        fromPosCastle3 = {x=1036, y=1391, z=11},
        toPosCastle3 = {x=1144, y=1428, z=11},
        fromPosCastle4 = {x=1036, y=1391, z=11},
        toPosCastle4 = {x=1144, y=1428, z=11},
        newPos = {x=1000, y=1000, z=7}
}
local weapon = {
        sword = 11393, --Divine sword of the archangel
        staff = 11394, --Divine staff of the archangel
        crossbow = 11395 --Divine crossbow of the archangel
}
local playersOnline = getPlayersOnline()
        for _, pid in ipairs(playersOnline) do
                if isInArea(getCreaturePosition(pid), position.fromPosCastle1, position.toPosCastle1) then
                        doTeleportThing(pid, position.newPos)
                        doPlayerRemoveItem(pid, weapon.sword, getPlayerItemCount(pid, weapon.sword))
                        doPlayerRemoveItem(pid, weapon.staff, getPlayerItemCount(pid, weapon.staff))
                        doPlayerRemoveItem(pid, weapon.crossbow, getPlayerItemCount(pid, weapon.crossbow))
                elseif isInArea(getCreaturePosition(pid), position.fromPosCastle2, position.toPosCastle2) then
                        doTeleportThing(pid, position.newPos)
                        doPlayerRemoveItem(pid, weapon.sword, getPlayerItemCount(pid, weapon.sword))
                        doPlayerRemoveItem(pid, weapon.staff, getPlayerItemCount(pid, weapon.staff))
                        doPlayerRemoveItem(pid, weapon.crossbow, getPlayerItemCount(pid, weapon.crossbow))
                elseif isInArea(getCreaturePosition(pid), position.fromPosCastle3, position.toPosCastle3) then
                        doTeleportThing(pid, position.newPos)
                        doPlayerRemoveItem(pid, weapon.sword, getPlayerItemCount(pid, weapon.sword))
                        doPlayerRemoveItem(pid, weapon.staff, getPlayerItemCount(pid, weapon.staff))
                        doPlayerRemoveItem(pid, weapon.crossbow, getPlayerItemCount(pid, weapon.crossbow))
                elseif isInArea(getCreaturePosition(pid), position.fromPosCastle4, position.toPosCastle4) then
                        doTeleportThing(pid, position.newPos)
                        doPlayerRemoveItem(pid, weapon.sword, getPlayerItemCount(pid, weapon.sword))
                        doPlayerRemoveItem(pid, weapon.staff, getPlayerItemCount(pid, weapon.staff))
                        doPlayerRemoveItem(pid, weapon.crossbow, getPlayerItemCount(pid, weapon.crossbow))
                end
        end
        return TRUE
end
 
Upvote 0 Downvote
Back
Top