[easy] Where to paste that script?

[mahant]

local 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 onLook(cid, thing, position, lookDistance) 
if isPlayer(thing.uid) then 
doPlayerSetSpecialDescription(thing.uid, (getPlayerSex(thing.uid) == 0 and ".\nShe" or ".\nHe") .." has "..getPlayerFrags(thing.uid).." frags") 
return true 
end 
return true 
end

Where to paste that script?

 

[Collz]

Not sure, it's most likely globalevents or creaturescripts.

 

[mahant]

globalevents:

[9:18:54.153] [Warning - Event::loadScript] Event onThink not found (data/globalevents/scripts/fraglicznik.lua)

creaturescript:

[9:15:30.630] [Warning - Event::loadScript] Event onKill not found (data/creaturescripts/scripts/fragcounter.lua)

Or maybe i do it wrong.. Help, then i will rep you

 

[mahant]

refresh xd Heeelp

 

[Collz]

Where did you originally get that script from?

 

[mahant]

One guy wrote that at this forum

 

[Collz]

One guy wrote that at this forum

Post the link to it.

 

[mahant]

http://otland.net/f16/looking-script-shows-how-much-frags-player-have-98224/

 

[andy1995]

Creaturescripts, to creaturescripts.xml add

<event type="look" name="Frags" event="script" value="script.lua"/>

 

[cirtaboy]

Creaturescripts, to creaturescripts.xml add

<event type="look" name="Frags" event="script" value="script.lua"/>

Well, I got ninjad. Was going to post this, but didn't see that you had.

 

[mahant]

hey i got this problem

[14:42:02.438] [Warning - Event::loadScript] Event onThink not found (data/globalevents/scripts/fraglicznik.lua)

[14:52:26.965] mysql_real_query(): UPDATE `players` SET `frags` = `frags` + 1 WHERE `id` = 10; - MYSQL ERROR: Unknown column 'frags' in 'field list' (1054)

 

[mahant]

At my database isn't any "Frags" / It is "killers" and "playerkillers" Which should it be?