CreatureEvent Store Deaths

[Sync]

These simple Scripts store Total Deaths, Can be used to modify onLook to show how many deaths a player has, on website, Etc.

ALTER TABLE players ADD deaths bigint(11) NOT NULL

050-function.lua

function doPlayerAddDeaths(cid, add)
	return db.executeQuery("UPDATE `players` SET `deaths` = `deaths` + "..add.." WHERE `name` = '"..getCreatureName(cid).."';")
end

function getPlayerDeaths(cid)
	local DB_points = db.getResult("SELECT `deaths` FROM `players` WHERE `name` = '"..getCreatureName(cid).."';")
	points = DB_points:getDataInt("deaths")
	DB_points:free()
	return points
end

addDeath.lua

function onPrepareDeath(cid, deathList)
         doPlayerAddDeaths(cid, 1)
        return true
end

Heres a base script to show total Deaths of cid.

function onSay(cid, words, param, channel)
	doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "You have a total of " .. getPlayerDeaths(cid) .. " deaths.")
	return true
end

 

[Nerkoerko]

Screens plx ;d

 

[nsanee]

It would be much more efficient if you were to use player storage instead of raw database queries.

 

[Fallen]

It would be much more efficient if you were to use player storage instead of raw database queries.

or like this;

function doPlayerAddDeaths(d)
	local q = 0
	q = q + d
	return d
end

 

[JDB]

or like this;

function doPlayerAddDeaths(d)
	local q = 0
	q = q + d
	return q
end

Stop trying to be cool.

 

[Fallen]

stop trying to be cool.

you

 

[hodleo]

or like this;

function doPlayerAddDeaths(d)
    local q = 0
    q = q + d
    return d
end

:ninja:that will always return '1' or the same value
replace q with getPlayerStorageValue
and where's the player? (cid)
oh right, that's all unnecessary!

sqless

function doPlayerAddDeath(cid) return doPlayerSetStorageValue(cid, storage, getPlayerStorageValue(cid, storage)+1) end

 

[Sync]

I did it in DB querys so its easier to get the information for Website Scripts and what not. Feel free to change it if you desire.