• 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 Shop system problem

J

jakiskoles

New Member
Joined
May 12, 2013
Messages
2
Reaction score
0
Hello sorry my english..
i have error

have this engine http://otland.net/threads/best-released-real-map-10-22-based-1-0.204514/
system linux
on website ?subtopic=show&trasaction
Transactions History


Item Transactions
To: From: Offer name Bought on page Received on OTS
Cascas Your account jack 23 December 2013, 12:34:47 Not realized yet.





[C]: in function 'getResult'
data/globalevents/scripts/shop.lua:7: in function
[Error - GlobalEvents::think] Failed to execute event: website_shop_item_delivery

Lua Script Error: [GlobalEvent Interface]
data/globalevents/scripts/shop.lua:eek:nThink
data/globalevents/scripts/shop.lua:7: attempt to call field 'getResult' (a nil value)
stack traceback:
[C]: in function 'getResult'
data/globalevents/scripts/shop.lua:7: in function
[Error - GlobalEvents::think] Failed to execute event: website_shop_item_delivery

Lua Script Error: [GlobalEvent Interface]
data/globalevents/scripts/shop.lua:eek:nThink
data/globalevents/scripts/shop.lua:7: attempt to call field 'getResult' (a nil value)
stack traceback:
[C]: in function 'getResult'
data/globalevents/scripts/shop.lua:7: in function
[Error - GlobalEvents::think] Failed to execute event: website_shop_item_delivery

Lua Script Error: [GlobalEvent Interface]
data/globalevents/scripts/shop.lua:eek:nThink
data/globalevents/scripts/shop.lua:7: attempt to call field 'getResult' (a nil value)
stack traceback:
[C]: in function 'getResult'
data/globalevents/scripts/shop.lua:7: in function
[Error - GlobalEvents::think] Failed to execute event: website_shop_item_delivery

Lua Script Error: [GlobalEvent Interface]
data/globalevents/scripts/shop.lua:eek:nThink
data/globalevents/scripts/shop.lua:7: attempt to call field 'getResult' (a nil value)
stack traceback:
[C]: in function 'getResult'
data/globalevents/scripts/shop.lua:7: in function
[Error - GlobalEvents::think] Failed to execute event: website_shop_item_delivery

Lua Script Error: [GlobalEvent Interface]
data/globalevents/scripts/shop.lua:eek:nThink
data/globalevents/scripts/shop.lua:7: attempt to call field 'getResult' (a nil value)
stack traceback:
[C]: in function 'getResult'
data/globalevents/scripts/shop.lua:7: in function
[Error - GlobalEvents::think] Failed to execute event: website_shop_item_delivery

Lua Script Error: [GlobalEvent Interface]
data/globalevents/scripts/shop.lua:eek:nThink
data/globalevents/scripts/shop.lua:7: attempt to call field 'getResult' (a nil value)
stack traceback:
[C]: in function 'getResult'
data/globalevents/scripts/shop.lua:7: in function
[Error - GlobalEvents::think] Failed to execute event: website_shop_item_delivery

Lua Script Error: [GlobalEvent Interface]
data/globalevents/scripts/shop.lua:eek:nThink
data/globalevents/scripts/shop.lua:7: attempt to call field 'getResult' (a nil value)
stack traceback:
[C]: in function 'getResult'
data/globalevents/scripts/shop.lua:7: in function
[Error - GlobalEvents::think] Failed to execute event: website_shop_item_delivery

Lua Script Error: [GlobalEvent Interface]
data/globalevents/scripts/shop.lua:eek:nThink
data/globalevents/scripts/shop.lua:7: attempt to call field 'getResult' (a nil value)
stack traceback:
[C]: in function 'getResult'
data/globalevents/scripts/shop.lua:7: in function
[Error - GlobalEvents::think] Failed to execute event: website_shop_item_delivery
Root has logged out.

Lua Script Error: [GlobalEvent Interface]
data/globalevents/scripts/shop.lua:eek:nThink
data/globalevents/scripts/shop.lua:7: attempt to call field 'getResult' (a nil value)
stack traceback:
[C]: in function 'getResult'
data/globalevents/scripts/shop.lua:7: in function
[Error - GlobalEvents::think] Failed to execute event: website_shop_item_delivery
Root has logged in.

Lua Script Error: [GlobalEvent Interface]
data/globalevents/scripts/shop.lua:eek:nThink
data/globalevents/scripts/shop.lua:7: attempt to call field 'getResult' (a nil value)
stack traceback:
[C]: in function 'getResult'
data/globalevents/scripts/shop.lua:7: in function
[Error - GlobalEvents::think] Failed to execute event: website_shop_item_delivery

Lua Script Error: [GlobalEvent Interface]
data/globalevents/scripts/shop.lua:eek:nThink
data/globalevents/scripts/shop.lua:7: attempt to call field 'getResult' (a nil value)
stack traceback:
[C]: in function 'getResult'
data/globalevents/scripts/shop.lua:7: in function
[Error - GlobalEvents::think] Failed to execute event: website_shop_item_delivery

Lua Script Error: [GlobalEvent Interface]
data/globalevents/scripts/shop.lua:eek:nThink
data/globalevents/scripts/shop.lua:7: attempt to call field 'getResult' (a nil value)
stack traceback:
[C]: in function 'getResult'
data/globalevents/scripts/shop.lua:7: in function
[Error - GlobalEvents::think] Failed to execute event: website_shop_item_delivery
Root has logged out.

Lua Script Error: [GlobalEvent Interface]
data/globalevents/scripts/shop.lua:eek:nThink
data/globalevents/scripts/shop.lua:7: attempt to call field 'getResult' (a nil value)
stack traceback:
[C]: in function 'getResult'
data/globalevents/scripts/shop.lua:7: in function
[Error - GlobalEvents::think] Failed to execute event: website_shop_item_delivery
Cascas has logged in.

Lua Script Error: [GlobalEvent Interface]
data/globalevents/scripts/shop.lua:eek:nThink
data/globalevents/scripts/shop.lua:7: attempt to call field 'getResult' (a nil value)
stack traceback:
[C]: in function 'getResult'
data/globalevents/scripts/shop.lua:7: in function
[Error - GlobalEvents::think] Failed to execute event: website_shop_item_delivery
Cascas has logged out.

Lua Script Error: [GlobalEvent Interface]
data/globalevents/scripts/shop.lua:eek:nThink
data/globalevents/scripts/shop.lua:7: attempt to call field 'getResult' (a nil value)
stack traceback:
[C]: in function 'getResult'
data/globalevents/scripts/shop.lua:7: in function
[Error - GlobalEvents::think] Failed to execute event: website_shop_item_delivery
Cascas has logged in.

Lua Script Error: [GlobalEvent Interface]
data/globalevents/scripts/shop.lua:eek:nThink
data/globalevents/scripts/shop.lua:7: attempt to call field 'getResult' (a nil value)
stack traceback:
[C]: in function 'getResult'
data/globalevents/scripts/shop.lua:7: in function
[Error - GlobalEvents::think] Failed to execute event: website_shop_item_delivery

Lua Script Error: [GlobalEvent Interface]
data/globalevents/scripts/shop.lua:eek:nThink
data/globalevents/scripts/shop.lua:7: attempt to call field 'getResult' (a nil value)
stack traceback:
[C]: in function 'getResult'
data/globalevents/scripts/shop.lua:7: in function
[Error - GlobalEvents::think] Failed to execute event: website_shop_item_delivery

Lua Script Error: [GlobalEvent Interface]
data/globalevents/scripts/shop.lua:eek:nThink
data/globalevents/scripts/shop.lua:7: attempt to call field 'getResult' (a nil value)
stack traceback:
[C]: in function 'getResult'
data/globalevents/scripts/shop.lua:7: in function
[Error - GlobalEvents::think] Failed to execute event: website_shop_item_delivery

Lua Script Error: [GlobalEvent Interface]
data/globalevents/scripts/shop.lua:eek:nThink
data/globalevents/scripts/shop.lua:7: attempt to call field 'getResult' (a nil value)
stack traceback:
[C]: in function 'getResult'
data/globalevents/scripts/shop.lua:7: in function
[Error - GlobalEvents::think] Failed to execute event: website_shop_item_delivery

Lua Script Error: [GlobalEvent Interface]
data/globalevents/scripts/shop.lua:eek:nThink
data/globalevents/scripts/shop.lua:7: attempt to call field 'getResult' (a nil value)
stack traceback:
[C]: in function 'getResult'
data/globalevents/scripts/shop.lua:7: in function
[Error - GlobalEvents::think] Failed to execute event: website_shop_item_delivery
 
Lua: 
-- ### CONFIG ###
-- message send to player by script "type" (types you can check in "global.lua")
SHOP_MSG_TYPE = 18
-- 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.storeQuery("SELECT * FROM z_ots_comunication")
if(result_plr ~= false) then
repeat
local id = tonumber(result.getDataInt(result_plr, "id"))
local action = tostring(result.getDataString(result_plr, "action"))
local delete = tonumber(result.getDataInt(result_plr, "delete_it"))
local cid = getPlayerByName(tostring(result.getDataString(result_plr, "name")))
if(cid) then
local itemtogive_id = tonumber(result.getDataInt(result_plr, "param1"))
local itemtogive_count = tonumber(result.getDataInt(result_plr, "param2"))
local container_id = tonumber(result.getDataInt(result_plr, "param3"))
local container_count = tonumber(result.getDataInt(result_plr, "param4"))
local add_item_type = tostring(result.getDataString(result_plr, "param5"))
local add_item_name = tostring(result.getDataString(result_plr, "param6"))
local received_item = 0
local full_weight = 0
if(add_item_type == 'container') then
container_weight = getItemWeight(container_id, 1)
if(isItemRune(itemtogive_id)) then
items_weight = container_count * getItemWeight(itemtogive_id, 1)
else
items_weight = container_count * getItemWeight(itemtogive_id, itemtogive_count)
end
full_weight = items_weight + container_weight
else
full_weight = getItemWeight(itemtogive_id, itemtogive_count)
if(isItemRune(itemtogive_id)) then
full_weight = getItemWeight(itemtogive_id, 1)
else
full_weight = getItemWeight(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(type(received_item) == "number" and received_item == RETURNVALUE_NOERROR) then
doPlayerSendTextMessage(cid, SHOP_MSG_TYPE, 'You received >> '.. add_item_name ..' << from OTS shop.')
db.query("DELETE FROM `z_ots_comunication` WHERE `id` = " .. id .. ";")
db.query("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
until not result.next(result_plr)
result.free(result_plr)
end
return true
end
 
biagitox said:
Lua: 
-- ### CONFIG ###
-- message send to player by script "type" (types you can check in "global.lua")
SHOP_MSG_TYPE = 18
-- 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.storeQuery("SELECT * FROM z_ots_comunication")
if(result_plr ~= false) then
repeat
local id = tonumber(result.getDataInt(result_plr, "id"))
local action = tostring(result.getDataString(result_plr, "action"))
local delete = tonumber(result.getDataInt(result_plr, "delete_it"))
local cid = getPlayerByName(tostring(result.getDataString(result_plr, "name")))
if(cid) then
local itemtogive_id = tonumber(result.getDataInt(result_plr, "param1"))
local itemtogive_count = tonumber(result.getDataInt(result_plr, "param2"))
local container_id = tonumber(result.getDataInt(result_plr, "param3"))
local container_count = tonumber(result.getDataInt(result_plr, "param4"))
local add_item_type = tostring(result.getDataString(result_plr, "param5"))
local add_item_name = tostring(result.getDataString(result_plr, "param6"))
local received_item = 0
local full_weight = 0
if(add_item_type == 'container') then
container_weight = getItemWeight(container_id, 1)
if(isItemRune(itemtogive_id)) then
items_weight = container_count * getItemWeight(itemtogive_id, 1)
else
items_weight = container_count * getItemWeight(itemtogive_id, itemtogive_count)
end
full_weight = items_weight + container_weight
else
full_weight = getItemWeight(itemtogive_id, itemtogive_count)
if(isItemRune(itemtogive_id)) then
full_weight = getItemWeight(itemtogive_id, 1)
else
full_weight = getItemWeight(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(type(received_item) == "number" and received_item == RETURNVALUE_NOERROR) then
doPlayerSendTextMessage(cid, SHOP_MSG_TYPE, 'You received >> '.. add_item_name ..' << from OTS shop.')
db.query("DELETE FROM `z_ots_comunication` WHERE `id` = " .. id .. ";")
db.query("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
until not result.next(result_plr)
result.free(result_plr)
end
return true
end
Click to expand...
You know I fcking love you <3
 
[15/12/2019 4:38:56] mysql_real_query(): SELECT * FROM z_ots_comunication - MYSQL ERROR: Table 'junglewars.z_ots_comunication' doesn't exist (1146)

I have 3 hours trying to fix this, i'm using ZNote acc and i tryed alot of scripts
 
Daubydogg said:
[15/12/2019 4:38:56] mysql_real_query(): SELECT * FROM z_ots_comunication - MYSQL ERROR: Table 'junglewars.z_ots_comunication' doesn't exist (1146)

I have 3 hours trying to fix this, i'm using ZNote acc and i tryed alot of scripts
Click to expand...
Read you error msg:
Table 'z_ots_comunication' doesn't exist
You trying to access a table that don't exist.
Run this SQL command to create the table that was missing:
SQL: 
CREATE TABLE "z_ots_comunication" (
   "id" INTEGER PRIMARY KEY NOT NULL,
   "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" INTEGER(2) NOT NULL DEFAULT '1'
)
otland.net

SQLITE ERROR: no such table: z_ots_comunication

otland.net otland.net
otland.net

Solved - Z_ots_comunication

Hi guys, im a new "mapper" and i realy need help with this problem i got here. When i try to open my map on Forgottenserver and this comes up popups mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login'; - M YSQL ERROR: Table 'forgottenserver.z_ots_comunication' doesn't...
otland.net otland.net
otland.net

Second problem!

Hello guys! I just opened my own server, but players cannot login, I just opened ports, and did fully things, and when my friend try to login, It says on Server LOG: [19/03/2012 23:15:36] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM...
otland.net otland.net
 

Similar threads

J
  • Question
Cast System Problem
Replies
0
Views
304
jareczekjsp
J
J
  • Question
events timer
Replies
1
Views
383
Mateus Robeerto
Mateus Robeerto
V
  • Solved
Solved When kill player i got Lua Script Error: [CreatureScript Interface]
Replies
9
Views
619
Xikini
Xikini
J
  • Solved
Problem with npc missions
Replies
4
Views
321
jareczekjsp
J
D
  • Question
TFS 1.X+ The Forgotten Server - Version 1.5 (Nekiro's 8.60 downgrade & Movie Updates) Script Errors
Replies
1
Views
496
Vintage ROX
V
Back
Top