• 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!

Weird error(s) in console

Luka Trklja

Luka Trklja

Member
Joined
Jul 8, 2016
Messages
121
Solutions
5
Reaction score
8
Location
Croatia
TFS 0.3.6

Been trying a new server and i keep getting this errors in my console, dunno whats triggering it and/or what is it for

Code: 
[27/02/2017 01:09:33] [Error - GlobalEvent Interface]
[27/02/2017 01:09:33] data/globalevents/scripts/shop.lua:onThink
[27/02/2017 01:09:33] Description:
[27/02/2017 01:09:33] data/globalevents/scripts/shop.lua:8: attempt to call field 'getResult' (a nil value)
[27/02/2017 01:09:33] stack traceback:
[27/02/2017 01:09:33]     data/globalevents/scripts/shop.lua:8: in function <data/globalevents/scripts/shop.lua:7>
[27/02/2017 01:09:33] [Error - GlobalEvents::think] Couldn't execute event: shop

Code: 
[27/02/2017 01:08:20] [Error - CreatureScript Interface]
[27/02/2017 01:08:20] data/creaturescripts/scripts/points.lua:onAdvance
[27/02/2017 01:08:20] Description:
[27/02/2017 01:08:20] data/creaturescripts/scripts/points.lua:16: attempt to compare table with number
[27/02/2017 01:08:20] stack traceback:
[27/02/2017 01:08:20]     data/creaturescripts/scripts/points.lua:16: in function <data/creaturescripts/scripts/points.lua:10>

Lua: 
local t, storage = {
-- level -- amount points (delete this line)..
{350, 50},
{450, 50},
{550, 75},
{700, 100},
{900, 125}
}, 259

function onAdvance(cid, skill, oldLevel, newLevel)
if skill ~= SKILL__LEVEL then
return true
end
for i = 1, #t do
local v = t
if newLevel >= v[1] and getCreatureStorage(cid, storage) < i then
db.executeQuery('UPDATE accounts SET premium_points=premium_points+'.. v[2] ..' WHERE id=' .. getPlayerAccountId(cid))
doCreatureSetStorage(cid, storage, i)
doPlayerSendTextMessage(cid, MESSAGE_STATUS_WARNING, 'Congratulations! You have advanced to level ' .. v[1] .. ' and you have earned '.. v[2] ..' Premium Points!')
end
end
return true
end

Lua: 
-- ### CONFIG ###
-- message send to player by script "type" (types you can check in "data/lib/000-constants.lua")
SHOP_MSG_TYPE = MESSAGE_STATUS_CONSOLE_BLUE
-- time (in seconds) between queries to MySQL database by shop script
SQL_interval = 30
-- ### END OF CONFIG ###
function onThink(interval, lastExecution)
local result_plr = db.getResult("SELECT * FROM `z_ots_comunication` WHERE `type` = 'login';")
if(result_plr:getID() ~= -1) then
while(true) do
id = tonumber(result_plr:getDataInt("id"))
action = tostring(result_plr:getDataString("action"))
delete = tonumber(result_plr:getDataInt("delete_it"))
cid = getCreatureByName(tostring(result_plr:getDataString("name")))
if isPlayer(cid) == TRUE then
local itemtogive_id = tonumber(result_plr:getDataInt("param1"))
local itemtogive_count = tonumber(result_plr:getDataInt("param2"))
local container_id = tonumber(result_plr:getDataInt("param3"))
local container_count = tonumber(result_plr:getDataInt("param4"))
local add_item_type = tostring(result_plr:getDataString("param5"))
local add_item_name = tostring(result_plr:getDataString("param6"))
local received_item = 0
local full_weight = 0
if add_item_type == 'container' then
container_weight = getItemWeightById(container_id, 1)
if isItemRune(itemtogive_id) == TRUE then
items_weight = container_count * getItemWeightById(itemtogive_id, 1)
else
items_weight = container_count * getItemWeightById(itemtogive_id, itemtogive_count)
end
full_weight = items_weight + container_weight
else
full_weight = getItemWeightById(itemtogive_id, itemtogive_count)
if isItemRune(itemtogive_id) == TRUE then
full_weight = getItemWeightById(itemtogive_id, 1)
else
full_weight = getItemWeightById(itemtogive_id, itemtogive_count)
end
end
local free_cap = getPlayerFreeCap(cid)
if full_weight <= free_cap then
if add_item_type == 'container' then
local new_container = doCreateItemEx(container_id, 1)
doItemSetAttribute(new_container, "description", 'Bought by ' .. getCreatureName(cid) .. ' [ID:' .. id .. '].')
doItemSetAttribute(new_container, "tid", id)
local iter = 0
while iter ~= container_count do
local new_item = doCreateItemEx(itemtogive_id, itemtogive_count)
doItemSetAttribute(new_item, "description", 'Bought by ' .. getCreatureName(cid) .. ' [ID:' .. id .. '].')
doItemSetAttribute(new_item, "tid", id)
doAddContainerItemEx(new_container, new_item)
iter = iter + 1
end
received_item = doPlayerAddItemEx(cid, new_container)
else
local new_item = doCreateItemEx(itemtogive_id, itemtogive_count)
doItemSetAttribute(new_item, "description", 'Bought by ' .. getCreatureName(cid) .. ' [ID:' .. id .. '].')
doItemSetAttribute(new_item, "tid", id)
received_item = doPlayerAddItemEx(cid, new_item)
end
if received_item == RETURNVALUE_NOERROR then
doPlayerSendTextMessage(cid, SHOP_MSG_TYPE, 'You received >> '.. add_item_name ..' << from OTS shop.')
doPlayerSave(cid)
db.executeQuery("DELETE FROM `z_ots_comunication` WHERE `id` = " .. id .. ";")
db.executeQuery("UPDATE `z_shop_history_item` SET `trans_state`='realized', `trans_real`=" .. os.time() .. " WHERE id = " .. id .. ";")
else
doPlayerSendTextMessage(cid, SHOP_MSG_TYPE, '>> '.. add_item_name ..' << from OTS shop is waiting for you. Please make place for this item in your backpack/hands and wait about '.. SQL_interval ..' seconds to get it.')
end
else
doPlayerSendTextMessage(cid, SHOP_MSG_TYPE, '>> '.. add_item_name ..' << from OTS shop is waiting for you. It weight is '.. full_weight ..' oz., you have only '.. free_cap ..' oz. free capacity. Put some items in depot and wait about '.. SQL_interval ..' seconds to get it.')
end
end
if not(result_plr:next()) then
break
end
end
result_plr:free()
end
return true
end
 
Last edited:
Sort by date Sort by votes
Luka Trklja said:
TFS 0.3.6

Been trying a new server and i keep getting this errors in my console, dunno whats triggering it and/or what is it for

Code: 
[27/02/2017 01:09:33] [Error - GlobalEvent Interface]
[27/02/2017 01:09:33] data/globalevents/scripts/shop.lua:onThink
[27/02/2017 01:09:33] Description:
[27/02/2017 01:09:33] data/globalevents/scripts/shop.lua:8: attempt to call field 'getResult' (a nil value)
[27/02/2017 01:09:33] stack traceback:
[27/02/2017 01:09:33]     data/globalevents/scripts/shop.lua:8: in function <data/globalevents/scripts/shop.lua:7>
[27/02/2017 01:09:33] [Error - GlobalEvents::think] Couldn't execute event: shop

Code: 
[27/02/2017 01:08:20] [Error - CreatureScript Interface]
[27/02/2017 01:08:20] data/creaturescripts/scripts/points.lua:onAdvance
[27/02/2017 01:08:20] Description:
[27/02/2017 01:08:20] data/creaturescripts/scripts/points.lua:16: attempt to compare table with number
[27/02/2017 01:08:20] stack traceback:
[27/02/2017 01:08:20]     data/creaturescripts/scripts/points.lua:16: in function <data/creaturescripts/scripts/points.lua:10>

I uploaded both shop.lua and points.lua in case someone needs it?
MEGA
Click to expand...
You should either post it using code tags:
How to display CODE properly in your post

Or if the code is too long you can post it on pastebin:
Pastebin.com - #1 paste tool since 2002!
 
Upvote 0 Downvote
The bump time on OTLand is 24h, not 1 min.

First check if you got z_ots_comunication in your database, if not import this;
SQL: 
CREATE TABLE IF NOT EXISTS `z_ots_comunication` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `action` varchar(255) NOT NULL,
  `param1` varchar(255) NOT NULL,
  `param2` varchar(255) NOT NULL,
  `param3` varchar(255) NOT NULL,
  `param4` varchar(255) NOT NULL,
  `param5` varchar(255) NOT NULL,
  `param6` varchar(255) NOT NULL,
  `param7` varchar(255) NOT NULL,
  `delete_it` int(2) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=230 ;

And for the other script use this;
Lua: 
local t, storage = {
    -- level -- amount points (delete this line)..
    {350, 50},
    {450, 50},
    {550, 75},
    {700, 100},
    {900, 125}
}, 259

function onAdvance(cid, skill, oldLevel, newLevel)
    if skill ~= SKILL__LEVEL then
        return true
    end

    for i = 1, #t do
        local v = t[i]
        if newLevel >= v[1] and getCreatureStorage(cid, storage) < i then
            db.executeQuery('UPDATE accounts SET premium_points=premium_points+'.. v[2] ..' WHERE id=' .. getPlayerAccountId(cid))
            doCreatureSetStorage(cid, storage, i)
            doPlayerSendTextMessage(cid, MESSAGE_STATUS_WARNING, 'Congratulations! You have advanced to level ' .. v[1] .. ' and you have earned '.. v[2] ..' Premium Points!')
        end
    end

    return true
end

You forgot to add at local v = t
 
Upvote 0 Downvote
WibbenZ said:
The bump time on OTLand is 24h, not 1 min.

First check if you got z_ots_comunication in your database, if not import this;
SQL: 
CREATE TABLE IF NOT EXISTS `z_ots_comunication` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `action` varchar(255) NOT NULL,
  `param1` varchar(255) NOT NULL,
  `param2` varchar(255) NOT NULL,
  `param3` varchar(255) NOT NULL,
  `param4` varchar(255) NOT NULL,
  `param5` varchar(255) NOT NULL,
  `param6` varchar(255) NOT NULL,
  `param7` varchar(255) NOT NULL,
  `delete_it` int(2) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=230 ;

And for the other script use this;
Lua: 
local t, storage = {
    -- level -- amount points (delete this line)..
    {350, 50},
    {450, 50},
    {550, 75},
    {700, 100},
    {900, 125}
}, 259

function onAdvance(cid, skill, oldLevel, newLevel)
    if skill ~= SKILL__LEVEL then
        return true
    end

    for i = 1, #t do
        local v = t[i]
        if newLevel >= v[1] and getCreatureStorage(cid, storage) < i then
            db.executeQuery('UPDATE accounts SET premium_points=premium_points+'.. v[2] ..' WHERE id=' .. getPlayerAccountId(cid))
            doCreatureSetStorage(cid, storage, i)
            doPlayerSendTextMessage(cid, MESSAGE_STATUS_WARNING, 'Congratulations! You have advanced to level ' .. v[1] .. ' and you have earned '.. v[2] ..' Premium Points!')
        end
    end

    return true
end

You forgot to add at local v = t
Click to expand...

Looks like the 2nd one works now, but shop.lua still same error
 
Upvote 0 Downvote
Luka Trklja said:
Same error
Click to expand...
do you actually know what it's for, are you using it?
if you have no idea what it is or what it's used for you most likely don't needed
that shop script is with like every 0.3.6 and no one uses it but wants to fix the errors
you can just simply remove it from the globalevents.xml line and youll stop getting the errors
 
Upvote 0 Downvote
Xeraphus said:
do you actually know what it's for, are you using it?
if you have no idea what it is or what it's used for you most likely don't needed
that shop script is with like every 0.3.6 and no one uses it but wants to fix the errors
you can just simply remove it from the globalevents.xml line and youll stop getting the errors
Click to expand...

Nah I said i dont know what is it for, aight that'll work for me, thanks.
 
Upvote 0 Downvote

Similar threads

G
  • Question
erro script shop
Replies
0
Views
279
Gaber Zen
G
Czorcik
  • Question
Gesior sms shop spaming items
Replies
1
Views
249
Czorcik
Czorcik
Back
Top