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

GlobalEvent Sms shop 8.42 problem!!! Help me!!

P

pikarashi

New Member
Joined
Apr 18, 2009
Messages
10
Reaction score
0
Hi,
I have problem witch Sms shop:


[30/11/2009 19:11:57] Lua Script Error: [GlobalEvent Interface]
[30/11/2009 19:11:57] data/globalevents/scripts/shop.lua:eek:nThink

[30/11/2009 19:11:57] luaResultGetDataInt(). Result not found.

[30/11/2009 19:11:57] Lua Script Error: [GlobalEvent Interface]
[30/11/2009 19:11:57] data/globalevents/scripts/shop.lua:eek:nThink

[30/11/2009 19:11:57] luaResultGetDataString(). Result not found.

[30/11/2009 19:11:57] Lua Script Error: [GlobalEvent Interface]
[30/11/2009 19:11:57] data/globalevents/scripts/shop.lua:eek:nThink

[30/11/2009 19:11:57] luaResultGetDataInt(). Result not found.

[30/11/2009 19:11:57] Lua Script Error: [GlobalEvent Interface]
[30/11/2009 19:11:57] data/globalevents/scripts/shop.lua:eek:nThink

[30/11/2009 19:11:57] luaResultGetDataString(). Result not found.

[30/11/2009 19:11:57] Lua Script Error: [GlobalEvent Interface]
[30/11/2009 19:11:57] data/globalevents/scripts/shop.lua:eek:nThink

[30/11/2009 19:11:57] luaResultNext(). Result not found.

[30/11/2009 19:11:57] Lua Script Error: [GlobalEvent Interface]
[30/11/2009 19:11:57] data/globalevents/scripts/shop.lua:eek:nThink

[30/11/2009 19:11:57] luaResultFree(). Result not found.
 
And maybe show the script so we know what's wrong?
We can't fix anything we can't see.
 
My Shop. ...globalevents/sctipts/shop

PHP: 
-- ### CONFIG ###
-- message send to player by script "type" (types you can check in "global.lua")
SHOP_MSG_TYPE = 19
-- time (in seconds) between connections to SQL 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)
local iter = 0
while iter ~= container_count do
doAddContainerItem(new_container, itemtogive_id, itemtogive_count)
iter = iter + 1
end
received_item = doPlayerAddItemEx(cid, new_container)
else
local new_item = doCreateItemEx(itemtogive_id, itemtogive_count)
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.')
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
 
pikarashi said:
and??
What is wrong??
Click to expand...
Next time, you make a request in request section, this is for releases only.

Warning for requesting support! (Be sure to read this)
Since ever the LUA/XML was created there were lots of people requesting scripts or asking for some help. When we saw this we made a special request board for this, but as you can see nobody notices it or doesn't want to use it. Myself I already moved like hundreds of threads that do not belong in the forum they were.

This is a official warning!

From now on we The Otland Staff will give out warnings and infractions to people who do request stuff and ask for support in the wrong board!

(Note that the members who did post in the wrong board before this warning will not be punished!)
If you haven't seen this board, you can find it by clicking this >link<!

Thank you for taking your time to read this.

Regards,


Xenios
Click to expand...

You even aren't telling us which distro are you using <.<
 
My:
shop.lua (globalevents/scripts/shop.lua)
PHP: 
-- ### CONFIG ###
-- message send to player by script "type" (types you can check in "global.lua")
SHOP_MSG_TYPE = 19
-- time (in seconds) between connections to SQL 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)
                        local iter = 0
                        while iter ~= container_count do
                            doAddContainerItem(new_container, itemtogive_id, itemtogive_count)
                            iter = iter + 1
                        end
                        received_item = doPlayerAddItemEx(cid, new_container)
                    else
                        local new_item = doCreateItemEx(itemtogive_id, itemtogive_count)
                        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.')
                        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

globalevents.xml
PHP: 
	<globalevent name="shop" interval="30" event="script" value="shop.lua"/>


in data/lib/constant.lua
PHP: 
	InitShopComunication = 0


and I have problem:
PHP: 
[30/11/2009 19:11:57] Lua Script Error: [GlobalEvent Interface] 
[30/11/2009 19:11:57] data/globalevents/scripts/shop.luanThink

[30/11/2009 19:11:57] luaResultGetDataInt(). Result not found.

[30/11/2009 19:11:57] Lua Script Error: [GlobalEvent Interface] 
[30/11/2009 19:11:57] data/globalevents/scripts/shop.luanThink

[30/11/2009 19:11:57] luaResultGetDataString(). Result not found.

[30/11/2009 19:11:57] Lua Script Error: [GlobalEvent Interface] 
[30/11/2009 19:11:57] data/globalevents/scripts/shop.luanThink

[30/11/2009 19:11:57] luaResultGetDataInt(). Result not found.

[30/11/2009 19:11:57] Lua Script Error: [GlobalEvent Interface] 
[30/11/2009 19:11:57] data/globalevents/scripts/shop.luanThink

[30/11/2009 19:11:57] luaResultGetDataString(). Result not found.

[30/11/2009 19:11:57] Lua Script Error: [GlobalEvent Interface] 
[30/11/2009 19:11:57] data/globalevents/scripts/shop.luanThink

[30/11/2009 19:11:57] luaResultNext(). Result not found.

[30/11/2009 19:11:57] Lua Script Error: [GlobalEvent Interface] 
[30/11/2009 19:11:57] data/globalevents/scripts/shop.luanThink

[30/11/2009 19:11:57] luaResultFree(). Result not found.
 

Similar threads

J
  • Question
events timer
Replies
1
Views
406
Mateus Robeerto
Mateus Robeerto
D
  • Question
TFS 1.X+ The Forgotten Server - Version 1.5 (Nekiro's 8.60 downgrade & Movie Updates) Script Errors
Replies
1
Views
521
Vintage ROX
V
Michcol94
  • Question
opcode instalation doSendPlayerExtendedOpcode 1.5 Nekiro downgrade 8.6
Replies
7
Views
728
Michcol94
Michcol94
Back
Top