[solved]

[ffriozi]

Solved

 

[cbrm]

bad english where?

<event name="insaneLvlUP" type="kill" event="script" value="levelForKilling.lua"/>
<event name="insaneLogin" type="login" event="script" value="levelForKilling.lua"/>

adds remaining exp to next lvl, if killer has skull:

function onLogin(cid)
    registerCreatureEvent(cid, "insaneLvlUP")
    return true
end

function onKill(cid, target, lastHit)
    if isPlayer(cid) and isPlayer(target) and lastHit and getCreatureSkullType(cid) > 2 then
        doPlayerAddExperience(cid, getExperienceForLevel(getPlayerLevel(cid)+1)-getPlayerExperience(cid))
    end
    return true
end

adds remaining exp to next lvl, if killer has frags:

function getPlayerFrags(cid)
    local time = os.time()
    local times = {today = (time - 86400), week = (time - (7 * 86400))}
 
    local contents, result = {day = {}, week = {}, month = {}}, db.getResult("SELECT `pd`.`date`, `pd`.`level`, `p`.`name` FROM `player_killers` pk LEFT JOIN `killers` k ON `pk`.`kill_id` = `k`.`id` LEFT JOIN `player_deaths` pd ON `k`.`death_id` = `pd`.`id` LEFT JOIN `players` p ON `pd`.`player_id` = `p`.`id` WHERE `pk`.`player_id` = " .. getPlayerGUID(cid) .. " AND `k`.`unjustified` = 1 AND `pd`.`date` >= " .. (time - (30 * 86400)) .. " ORDER BY `pd`.`date` DESC")
    if(result:getID() ~= -1) then
        repeat
            local content = {date = result:getDataInt("date")}
            if(content.date > times.today) then
                table.insert(contents.day, content)
            elseif(content.date > times.week) then
                table.insert(contents.week, content)
            else
                table.insert(contents.month, content)
            end
        until not result:next()
        result:free()
    end
 
    local size = {
        day = table.maxn(contents.day),
        week = table.maxn(contents.week),
        month = table.maxn(contents.month)
    }
    return size.day + size.week + size.month
end  

function onLogin(cid)
    registerCreatureEvent(cid, "insaneLvlUP")
    return true
end

function onKill(cid, target, lastHit)
    if isPlayer(cid) and isPlayer(target) and lastHit and getPlayerFrags(cid) > 0 then
        doPlayerAddExperience(cid, getExperienceForLevel(getPlayerLevel(cid)+1)-getPlayerExperience(cid))
    end
    return true
end

 

[ffriozi]

Thanks hehe... now how to reset his level when he dies? !!

Thanks again ++Rep

 

[Grehy]

change 'save' in db to 0

 

[ffriozi]

change 'save' in db to 0

Got it lol thanks ! +Rep !!

 

[ffriozi]

@Cybershot
Can you edit to the killer recive 50% of XP?

 

[cbrm]

@Cybershot
Can you edit to the killer recive 50% of XP?

frags one

function getPlayerFrags(cid)
    local time = os.time()
    local times = {today = (time - 86400), week = (time - (7 * 86400))}
 
    local contents, result = {day = {}, week = {}, month = {}}, db.getResult("SELECT `pd`.`date`, `pd`.`level`, `p`.`name` FROM `player_killers` pk LEFT JOIN `killers` k ON `pk`.`kill_id` = `k`.`id` LEFT JOIN `player_deaths` pd ON `k`.`death_id` = `pd`.`id` LEFT JOIN `players` p ON `pd`.`player_id` = `p`.`id` WHERE `pk`.`player_id` = " .. getPlayerGUID(cid) .. " AND `k`.`unjustified` = 1 AND `pd`.`date` >= " .. (time - (30 * 86400)) .. " ORDER BY `pd`.`date` DESC")
    if(result:getID() ~= -1) then
        repeat
            local content = {date = result:getDataInt("date")}
            if(content.date > times.today) then
                table.insert(contents.day, content)
            elseif(content.date > times.week) then
                table.insert(contents.week, content)
            else
                table.insert(contents.month, content)
            end
        until not result:next()
        result:free()
    end
 
    local size = {
        day = table.maxn(contents.day),
        week = table.maxn(contents.week),
        month = table.maxn(contents.month)
    }
    return size.day + size.week + size.month
end  
 
function onLogin(cid)
    registerCreatureEvent(cid, "insaneLvlUP")
    return true
end
 
function onKill(cid, target, lastHit)
    if isPlayer(cid) and isPlayer(target) and lastHit and getPlayerFrags(cid) > 0 then
        doPlayerAddExperience(cid, math.floor((getExperienceForLevel(getPlayerLevel(cid)+1)-getPlayerExperience(cid))/2))
    end
    return true
end

 

[ffriozi]

Awesome Thanks!!!

*Solved Again