• TibiaFace

    Tibiaface | Una comunidad Open Tibia donde encontras : mapas, scripts, Otserver, npc y amigos etc ...

    .
    demo menumenu

    Afiliados



    Votar:

    [Html] sms items/sms shop

    Compartir:

    Ver el tema anterior Ver el tema siguiente Ir abajo  Mensaje (Página 1 de 1.)

    1default [Html] sms items/sms shop el Dom Jun 10, 2018 10:43 am

    Deget92

    avatar
    Miembro
    Miembro
    hola, ayuda
    config:
    useCapSystem = false

    Código:

    https://imgur.com/a/O5FzCCR

    Código:


    -- ### CONFIG ###

    -- message send to player by script "type" (types you can check in "global.lua")

    SHOP_MSG_TYPE = 5

    -- time (in seconds) between connections to SQL database by shop script

    SQL_interval = 10

    -- ### 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

    Ver perfil de usuario

    2default Re: [Html] sms items/sms shop el Mar Jun 12, 2018 12:05 am

    [Admin] God Maya

    avatar
    Administrador
    Administrador
    Código:
    -- ### 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



    Ver perfil de usuario http://www.tibiaface.com

    3default Re: [Html] sms items/sms shop el Mar Jun 12, 2018 2:07 pm

    Deget92

    avatar
    Miembro
    Miembro
    sin cambio;/ pocos items venir, y uno y solo un error es suficiente, ..un artículo tal como lo compra inhabilita el servidor .. pero cómo creará por gm es bueno

    Ver perfil de usuario

    4default Re: [Html] sms items/sms shop el Mar Jun 12, 2018 2:12 pm

    [Admin] God Maya

    avatar
    Administrador
    Administrador
    [Tienes que estar registrado y conectado para ver este vínculo] escribió:sin cambio;/ pocos items venir, y uno y solo un error es suficiente, ..un artículo tal como lo compra inhabilita el servidor .. pero cómo creará por gm es bueno

    Usted esta comprando item en la tienda por x cantidad y le causa ese problema

    Enviado desde Topic'it



    Ver perfil de usuario http://www.tibiaface.com

    5default Re: [Html] sms items/sms shop el Mar Jun 12, 2018 2:47 pm

    Deget92

    avatar
    Miembro
    Miembro
    [Tienes que estar registrado y conectado para ver este vínculo]



    [Tienes que estar registrado y conectado para ver este vínculo]



    crash

    Ver perfil de usuario

    6default Re: [Html] sms items/sms shop el Miér Jun 13, 2018 10:50 am

    [Admin] God Maya

    avatar
    Administrador
    Administrador
    intente

    Código:
    -- ### CONFIG ###
    -- message send to player by script "type" (types you can check in "global.lua")
    local SHOP_MSG_TYPE = MESSAGE_INFO_DESCR
    -- 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



    Ver perfil de usuario http://www.tibiaface.com

    Contenido patrocinado


    Ver el tema anterior Ver el tema siguiente Volver arriba  Mensaje (Página 1 de 1.)

    Permisos de este foro:
    No puedes responder a temas en este foro.

     

    BienvenidosTibiaFace es una comunidad de Open Tibia. Para participar debes estar registrado (click para Regístrate).