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

REb problem

D

Deger99

New Member
Joined
Apr 5, 2016
Messages
38
Reaction score
1
Location
Sweden
Hello i added this reborn system! (all the codes i used are in the link)
https://otland.net/threads/best-reborn-system.226181/

login.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 ###
SQL_COMUNICATION_INTERVAL = SQL_interval * 1000
function onLogin(cid)
    local loss = getConfigValue('deathLostPercent')
   if(loss ~= nil) then
     doPlayerSetLossPercent(cid, PLAYERLOSS_EXPERIENCE, loss * 10)
    end
    if(InitShopComunication == 0) then
        local eventServ = addEvent(sql_communication, SQL_COMUNICATION_INTERVAL, {})
        InitShopComunication = eventServ
    end
 
 
    registerCreatureEvent(cid, "ZombieAttack")
    registerCreatureEvent(cid, "PlayerDeath")
    registerCreatureEvent(cid, "Ushuriel")
    registerCreatureEvent(cid, "Zugurosh")
    registerCreatureEvent(cid, "Madareth")
    registerCreatureEvent(cid, "Golgordan")
    registerCreatureEvent(cid, "Annihilon")
    registerCreatureEvent(cid, "Hellgorak")
    registerCreatureEvent(cid, "createTeleport")
    registerCreatureEvent(cid, "rebirth")
    registerCreatureEvent(cid, "pointsforlvl2")
    registerCreatureEvent(cid, "pointsforlvl3")
    registerCreatureEvent(cid, "LevelReward")
    registerCreatureEvent(cid, "levelup")
    registerCreatureEvent(cid, "blessings")
    registerCreatureEvent(cid, "pointsforlvl")
    return TRUE
end




function sql_communication(parameters)
    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 = getPlayerByName(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
    local eventServ = addEvent(sql_communication, SQL_COMUNICATION_INTERVAL, parameters)
end


But when i try to look on myself i get a error in console:
Code: 
-- ### CONFIG ###
[Error - CreatureScript Interface]
data/creaturescripts/scripts/reblook.lua:onLook
Description:
data/lib/050-function.lua:3: attempt to call field 'getResult' (a nil value)
stack traceback:
          data/lib/050-function.lua:3: in function 'getRebornsDone'
          data/creaturescripts/scripts/reblook.lua:3: in function <data/creaturescripts/scripts/reblook.lua:1>
 
Last edited:
Sort by date Sort by votes
The error isn't in login.lua it is in reblook.lua on line 3.
See
Code: 
data/lib/050-function.lua:3: in function 'getRebirnsDone'
 
Upvote 0 Downvote
Code: 
function onLook(cid, thing, position, lookDistance)
    if isPlayer(thing.uid) then
        doPlayerSetSpecialDescription(thing.uid, (getPlayerSex(thing.uid) == 0 and "\nShe" or "\nHe") .. " has: ["..getRebornsDone(thing.uid).."] Rebirths.")
            return true
    end
 
    if(thing.uid == cid) then
        doPlayerSetSpecialDescription(thing.uid, "\nYou have done: ["..getRebornsDone(thing.uid).."] Rebirths.")
    end
        return true
end
 
Upvote 0 Downvote
Code: 
data/lib/050-function.lua:3: in function 'getRebirnsDone'

Code: 
doPlayerSetSpecialDescription(thing.uid, (getPlayerSex(thing.uid) == 0 and "\nShe" or "\nHe") .. " has: ["..getRebornsDone(thing.uid).."] Rebirths.")

"getRebirnsDone"
 
Upvote 0 Downvote
Cade said:
Code: 
data/lib/050-function.lua:3: in function 'getRebirnsDone'

Code: 
doPlayerSetSpecialDescription(thing.uid, (getPlayerSex(thing.uid) == 0 and "\nShe" or "\nHe") .. " has: ["..getRebornsDone(thing.uid).."] Rebirths.")

"getRebirnsDone"
Click to expand...
I totally missed that hehe
 
Upvote 0 Downvote
Maybe you don't have the reborn table in database?

Code: 
function getRebornsDone(cid)
local Info = db.getResult("SELECT `reborns` FROM `players` WHERE `id` = " .. getPlayerGUID(cid) .. " LIMIT 1")
it says "reborns" in the function and the sql that you insert is called "rebirth"
Code: 
ALTER TABLE `players` ADD `rebirth` int(10) unsigned NOT NULL DEFAULT '0';

So try to either edit the function to select `rebirth` instead of `reborns` or add the table reborns

Codex NG said:
I totally missed that hehe
Click to expand...
Even tho it was not the case this time, typos' have got to be the most annoying kind of errors :p
 
Upvote 0 Downvote
Back
Top