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

Database command

Sort by date Sort by votes
yy.. :d

I don't want to do Top Frags at my website.

1. What database mySQL command i have to write to create column named "FRAGS"
2. I want to use script like:

When you click LOOK at any player, it says: You see Player (Level 99). He is Knight. He has xx frags
 
Upvote 0 Downvote
Great, it works.

Last one:
It counts only FRAGS, unjustified kills. I want to do that it will counts every killed player! Please help last time, of course reputation + for Damadger.
 
Upvote 0 Downvote
Code: 
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")	
	end
	return true
end
 
Upvote 0 Downvote
change for
LUA: 
local function getPlayerFrags(cid)
   
	local res = db.getResult("SELECT `frags` FROM `players` WHERE `id` = '"..getPlayerGUID(cid).."' ;")
	local value = 0
	if(res:getID() ~= -1) then
		value = res:getDataInt("frags")
		res:free()
	end
	return value
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")	
	end
	return true
end
 
Upvote 0 Downvote
Back
Top