Need "!rank frags" command

[ffriozi]

like the title say... i tried search here and cant find!

anyone can help?

 

[Doggynub]

and this get only the players online or?

 

[ffriozi]

all players ... like the "!rank magic" and etc

 

[ffriozi]

@Top!

 

[hodleo]

local exhaust = 3435 
local exhaustionTime = 60

function onSay(cid, words, param, channel)
    if exhaustion.check(cid, exhaust) then
        doPlayerSendCancel(cid, 'You can\'t use this command yet['..exhaustion.get(cid, exhaust)..'].')
        return true
    else
        exhaustion.set(cid, exhaust, exhaustionTime)
    end
    
    local str = '[#]-[Name]-[Frags]'
    result = db.getResult('SELECT `p`.`name` AS `name`, COUNT(`p`.`name`) as `frags` FROM `killers` k LEFT JOIN `player_killers` pk ON `k`.`id` = `pk`.`kill_id` LEFT JOIN `players` p ON `pk`.`player_id` = `p`.`id`WHERE `k`.`unjustified` = 1 AND `k`.`final_hit` = 1 GROUP BY `name` ORDER BY `frags` DESC, `name` ASC LIMIT 0,10;')
    
    if isInArray({-1,nil,false,''},result:getID()) then
        doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, 'No results were found.')
        return true
    end
    
    local i = 1
    while true do
        str = str .. '\n ' .. i .. '. ' .. result:getDataString('name') .. ' - [' .. result:getDataInt('frags') .. ']'
        i = i + 1
        if not(result:next()) then
            break
        end
    end
    result:free()
    doPlayerPopupFYI(cid, str)
    return true
end

<talkaction words="!frag" event="script" value="fragscore.lua"/>

 

[ffriozi]

Cyber s2 XD

error in console:

btw i sent u a Private msg...

[Error - TalkAction Interface]
data/talkactions/scripts/fragscore.lua:onSay
Description:
data/lib/004-database.lua:75: attempt to index local 'self' (a number value)
stack traceback:
        data/lib/004-database.lua:75: in function <data/lib/004-database.lua:74>

        (tail call): ?
        data/talkactions/scripts/fragscore.lua:22: in function <data/talkactions
/scripts/fragscore.lua:4>

going sleep cya tomorrow ppl

 

[ffriozi]

@Top!

 

[ffriozi]

@go to the sky!

 

[ffriozi]

@YoHelpMeAndWinA....

 

[ffriozi]

@top

 

[Luciano]

you can only bump each 24h

 

[Doggynub]

I think cycotitan have this one released before.

 

[Cykotitan]

but it's fail?
no it worked one time i tested it

 

[hodleo]

I think cycotitan have this one released before.

huH? post it

 

[Cykotitan]

Afa, it's only for online players.
http://otland.net/f16/bug-top-5-fragers-online-73909/#post757269
& it's globalevent. =//

 

[Doggynub]

Ye i wanted to know how to get all table(db) results but no luck .... I donno why doesnt it work like in php.

 

[ffriozi]

Afa, it's only for online players.
http://otland.net/f16/bug-top-5-fragers-online-73909/#post757269
& it's globalevent. =//

Thanks bro! i will use that script for only online players!

 

[Cykotitan]

but it's fail =/

 

[ffriozi]

but it's fail =/

Oh Sh!TZ haha ;D Ty anyway to try !