can't get !deathlist work

[mikeware]

Hey,

I was trying to use the command !deathlist "name but its not working with me, im getting this error:

Lua Script Error: [TalkAction Interface] 
data/talkactions/scripts/deathlist.lua:onSay

data/talkactions/scripts/deathlist.lua:25: attempt to call global 'rows' (a nil value)

here's the deathlist.lua im using:

function onSay(cid, words, param)
	dofile("./config.lua")
	if sqlType == "mysql" then
		env = assert(luasql.mysql())
		con = assert(env:connect(mysqlDatabase, mysqlUser, mysqlPass, mysqlHost, mysqlPort))
	else -- sqlite
		env = assert(luasql.sqlite())
		con = assert(env:connect(sqliteDatabase))
	end
	cur = assert(con:execute("SELECT `name`, `id` FROM `players` WHERE `name` = '" .. escapeString(param) .. "';"))
	row = cur:fetch ({}, "a")
	local targetName = ""
	local targetGUID = 0
	while row do
		targetName = row.name
		targetGUID = row.id
		row = cur:fetch (row, "a")
	end
	cur:close()
	if targetName == "" then
		doPlayerSendCancel(cid, "A player with that name does not exist.")
	else
		local str = ""
		local breakline = ""
		for time, level, killed_by, is_player in rows(con, "SELECT `time`, `level`, `killed_by`, `is_player` FROM `player_deaths` WHERE `player_id` = " .. targetGUID .. " ORDER BY `time` DESC;") do
			if str ~= "" then
				breakline = "\n"
			end
			local date = os.date("*t", time)

			local article = ""
			if is_player ~= TRUE then
				killed_by = string.lower(killed_by)
				article = getArticle(killed_by) .. " "
			end

			if date.day < 10 then	date.day = "0" .. date.day	end
			if date.hour < 10 then	date.hour = "0" .. date.hour	end
			if date.min < 10 then	date.min = "0" .. date.min	end
			if date.sec < 10 then	date.sec = "0" .. date.sec	end
			str = str .. breakline .. " " .. date.day .. getMonthDayEnding(date.day) .. " " .. getMonthString(date.month) .. " " .. date.year .. " " .. date.hour .. ":" .. date.min .. ":" .. date.sec .. "   Died at Level " .. level .. " by " .. article .. killed_by .. "."
		end
		if str == "" then
			str = "No deaths."
		end
		doPlayerPopupFYI(cid, "Deathlist for player, " .. targetName .. ".\n\n" .. str)
	end
	con:close()
	env:close()
end

another thing, there is no deaths in the player_deaths table, this can be the reason of this error?

thanks

 

[JayBeee]

I don't think the deathlist works, if you check in the phpmyadmin, when you hold the mouse over the table it says: "not in use by server".

 

[Mark]

You forgot to update global.lua.

 

[mikeware]

You forgot to update global.lua.

Probaly is that so, the global.lua that came with 2.5 was not updated as i can see, ill check now if it's works and tell if I got any problems.

thanks

 

[mikeware]

its working, closed topic.

thanks