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

[GESIOR] Shop System Bugged

Spratt

Spratt

New Member
Joined
Jun 26, 2011
Messages
106
Reaction score
1
Hey all,

So I was testing my Shop System on my website and when you buy an item with your points it keeps giving the item and the script does not recognize that the player has already received said item.

I get this error in the Console...
Code: 
[30/01/2013 10:33:00] [Error - GlobalEvent Interface] 
[30/01/2013 10:33:00] data/globalevents/scripts/shop.lua:onThink
[30/01/2013 10:33:00] Description: 
[30/01/2013 10:33:00] data/globalevents/scripts/shop.lua:43: attempt to call field 'executeQuery' (a nil value)
[30/01/2013 10:33:00] stack traceback:
[30/01/2013 10:33:00] 	data/globalevents/scripts/shop.lua:43: in function <data/globalevents/scripts/shop.lua:7>
[30/01/2013 10:33:00] [Error - GlobalEvents::think] Couldn't execute event: shop
 
Sort by date Sort by votes
Here is the Shop.lua
Code: 
-- ### 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
                    full_weight = getItemWeightById(itemtogive_id, 1)
                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 .. ";")
						doPlayerSave(cid)
					else
                        doPlayerSendTextMessage(cid, SHOP_MSG_TYPE, '>> The item '.. add_item_name ..' << that you just bought on the website couldnt be added. Han error has ocurred, please wait '.. SQL_interval ..' seconds.. Shop ID: '.. id ..'')
                    end
                else
                        doPlayerSendTextMessage(cid, SHOP_MSG_TYPE, '>> The item '.. add_item_name ..' << that you just bought on the website couldnt be added. Han error has ocurred, please wait '.. SQL_interval ..' seconds.. Shop ID: '.. id ..'')
                end
            end
            if not(result_plr:next()) then
                break
            end
        end
        result_plr:free()
    end
    return TRUE
end
 
Upvote 0 Downvote
Execute this query in your database

Code: 
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 ;
 
Upvote 0 Downvote
Xavicrak said:
Execute this query in your database

Code: 
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 ;
Click to expand...

Still getting error
Code: 
[30/01/2013 15:47:00] [Error - GlobalEvent Interface] 
[30/01/2013 15:47:00] data/globalevents/scripts/shop.lua:onThink
[30/01/2013 15:47:00] Description: 
[30/01/2013 15:47:00] data/globalevents/scripts/shop.lua:43: attempt to call field 'query' (a nil value)
[30/01/2013 15:47:00] stack traceback:
[30/01/2013 15:47:00] 	data/globalevents/scripts/shop.lua:43: in function <data/globalevents/scripts/shop.lua:7>
[30/01/2013 15:47:00] [Error - GlobalEvents::think] Couldn't execute event: shop
 
Upvote 0 Downvote
Lua: 
-- ### 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
                    full_weight = getItemWeightById(itemtogive_id, 1)
                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, 'Usted ha recibido >> '.. add_item_name ..' << desde la tienda de NecroveN. Porfavor logea y vuelve a conectar para que se guarden tus items.. Gracias por utilizar nuestra Tienda de NecroveN.')
                        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, '>> El articulo '.. add_item_name ..' << comprado desde la tienda de NecroveN, no se ha podido entregar. Ha ocurrido un error desconocido. Espere unos '.. SQL_interval ..' segundos. Si el error continua por favor envie un email a support.necroven[arroba]gmail.com. El ID  de esta compra es: '.. id ..'')
                    end
                else
                    doPlayerSendTextMessage(cid, SHOP_MSG_TYPE, '>> El articulo '.. add_item_name ..' << comprado desde la tienda Sick Dream, no se ha podido entregar. Ha ocurrido un error desconocido. Espere unos '.. SQL_interval ..' segundos. Si el error continua por favor envie un email a support.necroven[arroba]gmail.com. El ID  de esta compra es: '.. id ..'')
                end
            end
            if not(result_plr:next()) then
                break
            end
        end
        result_plr:free()
    end
    return TRUE
end
 
Upvote 0 Downvote
Cronox said:
Lua: 
-- ### 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
                    full_weight = getItemWeightById(itemtogive_id, 1)
                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, 'Usted ha recibido >> '.. add_item_name ..' << desde la tienda de NecroveN. Porfavor logea y vuelve a conectar para que se guarden tus items.. Gracias por utilizar nuestra Tienda de NecroveN.')
                        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, '>> El articulo '.. add_item_name ..' << comprado desde la tienda de NecroveN, no se ha podido entregar. Ha ocurrido un error desconocido. Espere unos '.. SQL_interval ..' segundos. Si el error continua por favor envie un email a support.necroven[arroba]gmail.com. El ID  de esta compra es: '.. id ..'')
                    end
                else
                    doPlayerSendTextMessage(cid, SHOP_MSG_TYPE, '>> El articulo '.. add_item_name ..' << comprado desde la tienda Sick Dream, no se ha podido entregar. Ha ocurrido un error desconocido. Espere unos '.. SQL_interval ..' segundos. Si el error continua por favor envie un email a support.necroven[arroba]gmail.com. El ID  de esta compra es: '.. id ..'')
                end
            end
            if not(result_plr:next()) then
                break
            end
        end
        result_plr:free()
    end
    return TRUE
end
Click to expand...

Again I'm getting an error in my console and its still duplicating item
Code: 
[31/01/2013 08:00:24] [Error - GlobalEvent Interface] 
[31/01/2013 08:00:24] data/globalevents/scripts/shop.lua:onThink
[31/01/2013 08:00:24] Description: 
[31/01/2013 08:00:24] data/globalevents/scripts/shop.lua:43: attempt to call field 'query' (a nil value)
[31/01/2013 08:00:24] stack traceback:
[31/01/2013 08:00:24] 	data/globalevents/scripts/shop.lua:43: in function <data/globalevents/scripts/shop.lua:7>
[31/01/2013 08:00:24] [Error - GlobalEvents::think] Couldn't execute event: shop
 
Upvote 0 Downvote

Similar threads

J
  • Question
events timer
Replies
1
Views
439
Mateus Robeerto
Mateus Robeerto
potinho
  • Question
OTClient Errors when open client
Replies
1
Views
285
pelek2002
P
H
  • Question
TFS 1.X+ SQL considered slow? 10-17ms range for tile_store
Replies
0
Views
166
henkas
H
J
  • Question
Cast System Problem
Replies
0
Views
332
jareczekjsp
J
L
  • Question
TFS 0.X My server doesn't recognize the MOD
Replies
1
Views
294
tobi132
T
D
  • Question
[warning] [loadLuaMapBookDocument] - Tile not found! Index: 1, position: x: 32063 y: 31884 z: 4
Replies
2
Views
412
danielheringer
D
J
  • Question
Auto Blessing problem
Replies
3
Views
529
jareczekjsp
J
Back
Top