(Resolvido)Memorial

[luanluciano93 1996]

local storage = 9999

function onUse(cid, item, frompos, item2, topos)
	local result = db.getResult("SELECT `player_id` FROM `player_storage` WHERE `key` = " .. storage .. " AND `value` = 1;")
	if(result:getID() ~= -1) then
		local message = "Em memória de:\n\n"
		repeat
			local playerId = result:getDataInt("player_id")
			local database = db.getResult("SELECT `name` FROM `players` WHERE `id` = " .. db.escapeString(playerId) .. ";")
			if(database:getID() ~= -1) then
				local playerName = database:getDataString("name")
				message = ""..message.."".. playerName ..".\n"
				database:free()
			end
		until not(result:next())
		result:free()
		doPlayerPopupFYI(cid, message)
	else
		doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Não existe nenhum nome gravado.")
	end

	return true
end

 

[Thornes 0]

Boa tarde amigo teria como modifica esse scripter pra funciona em tfs 1.2??

[luanluciano93 1996]

@Thornes 

local storage = 9999
 
function onUse(player, item, fromPosition, target, toPosition, isHotkey)
    local resultId = db.storeQuery("SELECT `player_id` FROM `player_storage` WHERE `key` = " .. storage .. " AND `value` = 1;")
    if resultId ~= false then
        local message = "Em memória de:\n\n"
        repeat
            local resultId2 = db.storeQuery("SELECT `name` FROM `players` WHERE `id` = " .. result.getDataInt(resultId, "player_id") .. ";")
            if resultId2 ~= false then
                local playerName = result.getString(resultId2, "name")
                message = ""..message.."".. playerName ..".\n"
                result.free(resultId2)
            end
        until not result.next(resultId)
        result.free(resultId)
        player:popupFYI(message)
    else
        player:sendTextMessage(MESSAGE_STATUS_CONSOLE_BLUE, "Não existe nenhum nome gravado.")
    end
    return true
end