Save location via SavedVariables

[Hubb777]

Originally Posted by Fizzlemizz That looks OK. The only thing is that you have a deDE for a only one entry in addon.db where tinsert(data, {item.announce[GetLocale()], item.icon, item.name}) will cause an error if the entry is missing in any single entry for the users locale return from GetLocale(). Have Fun!

That is, if the player’s game client is in French, and my addon does not support lines with frFR, then the player will have an error?

[Fizzlemizz]

If french (frFR) didn't exists then

tinsert(data, {item.announce[GetLocale()], item.icon, item.name})

would be the same as

tinsert(data, {item.announce["frFR"], item.icon, item.name})

which in the end would be

tinsert(data, {nil, item.icon, item.name})

Inserting nil will cause tinsert to error.

You could use something like the following that will test if the users locale announce field is in addon.db and if not, default to using the enUS text.

local locale = GetLocale() -- get the current locale eg. "frFR"
local function updateData()
    wipe(data)
    for _, item in ipairs(addon.db) do
        local announceText = item.announce[locale] or item.announce.enUS -- default to enUS if the locale text doesn't exist.
        tinsert(data, {announceText, item.icon, item.name})
    end
end

This assumes there will be a enUS field in EVERY announce table.

You could of course, if you prefer, default to .frFR or .deDE whichever locale oocures in every entry.

[Hubb777]

Originally Posted by Fizzlemizz local locale = GetLocale() -- get the current locale eg. "frFR" local function updateData()     wipe(data)     for _, item in ipairs(addon.db) do         local announceText = item.announce[locale] or item.announce.enUS -- default to enUS if the locale text doesn't exist.         tinsert(data, {announceText, item.icon, item.name})     end end

Yes, this option is ideal (after all, I don’t know what languages the players who install the addon speak, but many speak English)

local addonName, addon = ...
addon.db = {
    {
        name = {
            enUS = "Herb-Infused Water",
            deDE = "Mit Kräutern aromatisiertes Wasser"
        },
        questID = 75612,
        icon = "interface/icons/inv_mushroom_11",
        item = 210399,
        item = 210400,
        item = 210401,
        item = 210402,
        item = 210403,
        item = 210404,
        announce = {
             enUS = "Awarded for %ss outstanding service %sss to Dragonkind.\n%s\nBring it to Theozhaklos the Curious at the Wellspring \nOverlook in the Emerald %ssss Dream to receive powerful \nequipment for your efforts",
        }
    },
    {
        name = "Emerald Mark of Mastery",
        questID = 75624,
        icon = "interface/icons/inv_mushroom_11",
        item = 20897,
        announce = {
             enUS = "Awarded for outstanding service to Dragonkind.\n%s\nBring it to Theozhaklos the Curious at the Wellspring \nOverlook in the Emerald Dream to receive powerful \nequipment for your efforts"
        }
    },
    {
        name = "Emerald Mark of Mastery",
        questID = 74352,
        icon = "interface/icons/inv_mushroom_11",
        item = 193440,
        announce = {
             enUS = "Awarded for outstanding service to Dragonkind.\n%s\nBring it to Theozhaklos the Curious at the Wellspring \nOverlook in the Emerald Dream to receive powerful \nequipment for your efforts"
        }
    }
}
---------------------------------------------------------------------------------------------------
-- Code to replace %s in announce texts with item links. Replaces the GetItemLinkById(...) function
local function LoadItem(item)
    for k, v in pairs(addon.db[item.dbID].announce) do -- replace the %s with the itemlink in eal locale in the .announce key
        addon.db[item.dbID].announce[k] = format(v, item:GetItemLink())
    end
end
for i, v in ipairs(addon.db) do
    local item = Item:CreateFromItemID(v.item) 
    item.dbID = i
    item:ContinueOnItemLoad(function() LoadItem(item) end)
end

During the creation of the addon, a question arose. One link to a item in the text is missing; you need to insert 2,3 or more links into one text. As I understand it, you need to set different variables, for example %ss or %sss or %d, so that each one is tied to a specific position of the link to the item.

[Fizzlemizz]

/run print(format("%s %s %s", "Replace", "with", text"))

Each %s is replaced left-to-right with the corresponding argument after the text string ("Replace", "with", text"). There are tokens other than %s various data types/formatting see the docs for format for more information.

[Hubb777]

Originally Posted by Fizzlemizz /run print(format("%s %s %s", "Replace", "with", text")) Each %s is replaced left-to-right with the corresponding argument after the text string ("Replace", "with", text"). There are tokens other than %s various data types/formatting see the docs for format for more information.

local addonName, addon = ...
addon.db = {
    {
        name = {
            enUS = "Herb-Infused Water",
        },
        questID = 75612,
        icon = "interface/icons/inv_mushroom_11",
        item = 210399, 210400, 210401,
        announce = {
             enUS = format("Awarded for %s outstanding service %s to Dragonkind.\n%s\nBring it to Theozhaklos the Curious at the Wellspring"),
        }
    },
    {
        name = "Emerald Mark of Mastery",
        questID = 74352, 
        icon = "interface/icons/inv_mushroom_11",
        item = 193440, 193441, 193442,
        announce = {
             enUS = format("Awarded for %s outstanding service to Dragonkind.\n%s\nBring it to Theozhaklos the Curious at the %s Wellspring)"
        }
    }
}
---------------------------------------------------------------------------------------------------
-- Code to replace %s in announce texts with item links. Replaces the GetItemLinkById(...) function
local function LoadItem(item)
    for k, v in pairs(addon.db[item.dbID].announce) do -- replace the %s with the itemlink in eal locale in the .announce key
        addon.db[item.dbID].announce[k] = format(v, item:GetItemLink())
    end
end
for i, v in ipairs(addon.db) do
    local item = Item:CreateFromItemID(v.item) 
    item.dbID = i
    item:ContinueOnItemLoad(function() LoadItem(item) end)
end

I tried this but it didn't work

[Fizzlemizz]

This makes it a bit more complicated as you're getting mutiple items for each row so you have to have them all cached before you can do the format().

I have to head out so I'll look at it in the morning.

[Hubb777]

Originally Posted by Fizzlemizz This makes it a bit more complicated as you're getting mutiple items for each row so you have to have them all cached before you can do the format(). I have to head out so I'll look at it in the morning.

Thank you very much, good luck in your business. Maybe this code will help you

local Item = Class('Item', Reward)
 
function Item:Initialize(attrs)
    Reward.Initialize(self, attrs)
 
    if not self.item then
        error('Item() reward requires an item id to be set')
    end
    self.itemLink = L['retrieving']
    self.itemIcon = 'Interface\\Icons\\Inv_misc_questionmark'
    local item = _G.Item:CreateFromItemID(self.item)
    if not item:IsItemEmpty() then
        item:ContinueOnItemLoad(function()
            self.itemLink = item:GetItemLink()
            self.itemIcon = item:GetItemIcon()
        end)
    end
end
 
function Item:Prepare() ns.PrepareLinks(self.note) end
 
function Item:IsObtained()
    if self.quest then return C_QuestLog.IsQuestFlaggedCompleted(self.quest) end
    if self.bag then return ns.PlayerHasItem(self.item) end
    return true
end
 
function Item:GetText()
    local text = self.itemLink
    if self.type then -- mount, pet, toy, etc
        text = text .. ' (' .. self.type .. ')'
    end
    if self.count then
        text = text .. string.format(' (%sx)', BreakUpLargeNumbers(self.count))
    end
    if self.note then -- additional info
        text = text .. ' (' .. ns.RenderLinks(self.note, true) .. ')'
    end
    return Icon(self.itemIcon) .. text
end
 
function Item:GetStatus()
    if self.bag then
        local collected = ns.PlayerHasItem(self.item)
        return collected and Green(L['completed']) or Red(L['incomplete'])
    elseif self.status then
        return format('(%s)', self.status)
    elseif self.quest then
        local completed = C_QuestLog.IsQuestFlaggedCompleted(self.quest)
        return completed and Green(L['completed']) or Red(L['incomplete'])
    elseif self.weekly then
        local completed = C_QuestLog.IsQuestFlaggedCompleted(self.weekly)
        return completed and Green(L['weekly']) or Red(L['weekly'])
    end
end

And an additional question. - https://www.wowinterface.com/forums/...t=59795&page=2

In the last topic you helped me make a timer.
I plan to make another addon in the future that also uses this timer. The problem is that if a player installs 2 of these addons, the timer will not work correctly. I thought it was enough to fix ZAMROTimer to ZAMRO1Timer, but it looks like something else needs to be done?

[Xrystal]

Double check that you have no common non local functions or variables. These would overwrite each other and thus cause one to not work properly.

If you can't see anything like this in both addons then, perhaps you can describe what you are seeing happen ? And if you don't have bugsack or buggrabber installed to catch any errors it might be worth doing to help pinpoint where it's breaking.


Looking at the last code block Fizzle posted in that thread, just changing the frame name should be enough to make it work.

[Hubb777]

Originally Posted by Xrystal Double check that you have no common non local functions or variables. These would overwrite each other and thus cause one to not work properly. If you can't see anything like this in both addons then, perhaps you can describe what you are seeing happen ? And if you don't have bugsack or buggrabber installed to catch any errors it might be worth doing to help pinpoint where it's breaking. Looking at the last code block Fizzle posted in that thread, just changing the frame name should be enough to make it work.

My second timer starts flickering periodically and at this moment data from the first timer appears there.

[Xrystal]

Did you make sure that each display has it's own location ?

You will need to adjust the anchor if you want them both displayed at the same time.

If you notice in Fizzle's example code:

f:SetPoint("CENTER",UIParent,"CENTER",frame_x,frame_y)

If both addons have the same anchor point their information will overlay each other on the screen.
If you notice there is a frame_x and frame_y value there. If you are using the same code for your addon you can have each addon have different frame_x/frame_y values so that the frame will not overlay each other.

[Hubb777]

Originally Posted by Xrystal Did you make sure that each display has it's own location ? You will need to adjust the anchor if you want them both displayed at the same time. If you notice in Fizzle's example code: f:SetPoint("CENTER",UIParent,"CENTER",frame_x,frame_y) If both addons have the same anchor point their information will overlay each other on the screen. If you notice there is a frame_x and frame_y value there. If you are using the same code for your addon you can have each addon have different frame_x/frame_y values so that the frame will not overlay each other.

I'm a newbie so would appreciate a visual example based on my code

local addonName, addon = ...
local Backdrop = {
    bgFile = "Interface\\DialogFrame\\UI-DialogBox-Background",
}
 
local frame_x = 0     
local frame_y = -200    
f = CreateFrame("Button", "ZAMTimer", UIParent, "BackdropTemplate")
f:SetWidth(255)                                          
f:SetHeight(30)
f:SetBackdrop(Backdrop)
f.text = f:CreateFontString(nil,"OVERLAY","GameTooltipText")
f.text:SetTextHeight(15)
f.text:SetPoint("CENTER")
f:SetClampedToScreen(true)
f:SetPoint("CENTER",UIParent,"CENTER",frame_x,frame_y)
f:EnableMouse(true)
f:SetMovable(true)
f:RegisterForDrag("LeftButton")
f:RegisterForClicks("AnyUp")
f:Show()
f:RegisterEvent("PLAYER_ENTERING_WORLD")
f:SetScript("OnDragStart",function(this) 
    this:StartMoving()
end)
f:SetScript("OnDragStop",function(this)  
    this:StopMovingOrSizing()
    frame_x,frame_y = this:GetRIGHT()
    frame_x = frame_x - GetScreenWidth() / 2
    frame_y = frame_y - GetScreenHeight() / 2
    this:ClearAllPoints()
    this:SetPoint("CENTER",UIParent,"CENTER",frame_x,frame_y)
end)
-- first %s is replaced by the color. The second is replaced by the time. |r resets the color back to default
local Localizations = {
    enUS = {
        Waiting = "|c1C7BCEFFResearchers Under Fire:\nbefore the start: %s%s|r",
        Running = "|cFF35BE21Researchers Under Fire:\n%s%s until completion|r",
    },
}
 
local locale = GetLocale()
local L = Localizations[locale] or Localizations.enUS -- Default to enUS if locale doesn't exist in the table
 
------------------------------------------------------------------------------------------------------ 
-- These might be converted to Saved Variables so each character can determine
-- wether or not to play a sound, the alert times and colors and sound to play.
-- If so then most of the code below will have to move into an event handler for 
-- the PLAYER_LOGIN or PLAYER_ENTERING_WORLD event.
local useColor = true
local useSound = true
local alert1 = 600 -- Alarm 1 set to 10 minutes before event
local alert1Color = "|cffffff00" -- Yellow
local alert2 = 300 -- Alarm 2 set to 5 minutes before event
local alert2Color = "|cffff0000" -- Red
local soundKit = 32585 -- Alarm sound
------------------------------------------------------------------------------------------------------ 
 
local function printTime(timetotrun, inevent)
    local hideSeconds = timetotrun >= 120
    local msg = L.Waiting
    local msgColor = "|cffffffff"
    if inevent then
        msg = L.Running
    else
        if useColor and timetotrun <= alert2 then
            msgColor = alert2Color
        elseif timetotrun <= alert1 then
            if useSound and not ZAMTimer.Alerted then
                ZAMTimer.Alerted = true
                PlaySound(soundKit, "Master")
            end
            if useColor then
                msgColor = alert1Color
            end
        end
    end
    f.text:SetText(format(msg, msgColor, SecondsToTime(timetotrun, hideSeconds)))
end
 
regionEventStartTime = {
    [1] = { -- eu
        starttime = 1708756200,
        eventDuration = 1500,
        eventIntervalInSeconds = 3600,
        enable = true,
        datablock = {}
    },
}
 
local inEvent, timeToRun
local eventTime = regionEventStartTime[1].eventDuration -- Time the event runs in seconds(15 mins)
local waitTime = regionEventStartTime[1].eventIntervalInSeconds -- Time between events in seconds (90 mins)
local startTime = regionEventStartTime[1].starttime -- Start time from the table
local serverTime = GetServerTime()
local timeToEvent = (startTime - serverTime) % waitTime -- Remaining time before next event starts
 
if timeToEvent > (waitTime - eventTime) then -- Is there between 1:15 and 1:30 to go? If so, we're in the event
    inEvent = true
    timeToRun = eventTime - (waitTime - timeToEvent)
else                    -- Otherwise, set the ticker timer to time to next event
    inEvent = false
    timeToRun = timeToEvent
end
local ticker = C_Timer.NewTicker(1, function() 
    if timeToRun > 0 then
        timeToRun = timeToRun - 1
        printTime(timeToRun, inEvent)
        return
    end
    ZAMTimer.Alerted = false
    if inEvent then -- The event just finished
        inEvent = false
        timeToRun = waitTime - eventTime -- Reset ticker timer to 90 minutes wait time minus 15 mins event time
    else  -- Waiting for the next event just expired
        inEvent = true
        timeToRun = eventTime -- And the event is running
    end
    printTime(timeToRun, inEvent)
end)
printTime(timeToRun, inEvent)

[Xrystal]

Assuming you have the same file in each of the addons. Simply changing the frame name on line 8 as well as setting f to be local not global ( that would mess things up there ) and the frame_x and frame_y values on lines 6 and 7 might be all you need to do. Assuming the rest of the code does what the addon was designed to do.

So..

Addon 1

local frame_x = 0     
local frame_y = -200    
local f = CreateFrame("Button", "ZAMTimer1", UIParent, "BackdropTemplate")

Addon 2

local frame_x = 0     
local frame_y = -250    
local f = CreateFrame("Button", "ZAMTimer2", UIParent, "BackdropTemplate")

Although I see you have the frame dragging code set up to re-arrange as needed. So, the above should work well enough to make both frames separate and accessible and not overidden by the other one.

I think having the f - CreateFrame line not be local was the main issue.

[Fizzlemizz]

Probably best to make separate threads for each question as the code is getting pretty messy even for just one (hopefully Xrystal has answered your timer question).

Having multiple item links and locales in your addon.db texts complicates things because the order you want the links to display might be different in german to the order displayed in french and might be different again for english.

This requires identifying the order each link needs to be in for every locale text. With that in mind, the structure of addon.db needs to change so this is one way you could do it (my german in non-existant so it didn't even try):

NOTE: the number if items in each itemOrder should be the same as the number of %s tokens that are in the corresponding text field.
(This is probably overkill as it's replacing all the locale texts and you probably only need the ones that will be actually be used but that depends on what the end addon requires so...)

local addonName, addon = ...
addon.db = {
    {
        name = {
            enUS = "Herb-Infused Water",
            deDE = "Mit Kräutern aromatisiertes Wasser"
        },
        questID = 75612,
        icon = "interface/icons/inv_mushroom_11",
        announce = {
             enUS = { -- the text to display for english
                 text = "Awarded for %s outstanding service %s to Dragonkind.\n%s\nBring it to Theozhaklos the Curious at the Wellspring \nOverlook in the Emerald %s Dream to receive powerful \nequipment for your efforts",
                 itemOrder = { -- the order to display the items in english
                     210399,
                     210400,
                     210401,
                     210402,
                 },
             },
             deDE = { -- the text to display for german
                 text = "The items %s might be %s in a different %s order of items %s in german",
                 itemOrder = { -- the order to display the items in german
                     210401,
                     210402,
                     210399,
                     210400,
                 },
             },
        },
    },
    {
        name = "Emerald Mark of Mastery",
        questID = 75624,
        icon = "interface/icons/inv_mushroom_11",
        announce = {
            enUS = { -- the text to display for english
                text = "Awarded for outstanding service to Dragonkind.\n%s\nBring it to Theozhaklos the Curious at the Wellspring \nOverlook in the Emerald Dream to receive powerful \nequipment for your efforts",
                itemOrder = { -- the order to display the items in english
                    20897,
                },
            },
            deDE = { -- the text to display for german
                text = "Only one %s in this entry",
                itemOrder = { -- the order to display the items in german
                    20897,
                },
            },
        }
    },
}
---------------------------------------------------------------------------------------------------
-- Code to replace %s in announce texts with item links. Replaces the GetItemLinkById(...) function
 
local itemList = {} -- table to save the itsmID to
 
for index, v in ipairs(addon.db) do -- get/save every itmeID in addon.db announce 
   for k, itemID in pairs(v.announce.enUS.itemOrder) do -- assumes all announce entries will use all the same itemIDs
      if not itemList[itemID] then
         itemList[itemID] = true
      end
   end
end
 
local function FormatTexts() -- fill addon.db with the item links
   for index, v in ipairs(addon.db) do
      for locale, settings in pairs(v.announce) do
         local order = {}   
         for i, link in ipairs(settings.itemOrder) do -- get the links in order from addon.db
            order[i] = itemList[link] -- and save them into a tmporary table
         end
         settings.text = format(settings.text, unpack(order)) -- replace %s with the ordered item links (unpack(table) returns a number keyed tables entries in order eg. order[1], order[2], order[3] etc.)
      end
   end
 
end
 
local function LoadItem(item) -- Get the links for all the saved itemIDs
   if item then
      itemList[item:GetItemID()] = item:GetItemLink()
   end
   local key = next(itemList, item and item.Next or nil)
   if not key then -- when we have all the links for all the items
      FormatTexts() -- Run FormatTexts() to do the text replacements
      return
   end
   local nextItem = Item:CreateFromItemID(key)
   nextItem.Next = key
   nextItem:ContinueOnItemLoad(function() LoadItem(nextItem) end)
end
LoadItem()

[Hubb777]

Originally Posted by Fizzlemizz Probably best to make separate threads for each question as the code is getting pretty messy even for just one (hopefully Xrystal has answered your timer question). Having multiple item links and locales in your addon.db texts complicates things because the order you want the links to display might be different in german to the order displayed in french and might be different again for english. This requires identifying the order each link needs to be in for every locale text. With that in mind, the structure of addon.db needs to change so this is one way you could do it (my german in non-existant so it didn't even try): NOTE: the number if items in each itemOrder should be the same as the number of %s tokens that are in the corresponding text field. (This is probably overkill as it's replacing all the locale texts and you probably only need the ones that will be actually be used but that depends on what the end addon requires so...) local addonName, addon = ... addon.db = {     {         name = {             enUS = "Herb-Infused Water",             deDE = "Mit Kräutern aromatisiertes Wasser"         },         questID = 75612,         icon = "interface/icons/inv_mushroom_11",         announce = {              enUS = { -- the text to display for english                  text = "Awarded for %s outstanding service %s to Dragonkind.\n%s\nBring it to Theozhaklos the Curious at the Wellspring \nOverlook in the Emerald %s Dream to receive powerful \nequipment for your efforts",                  itemOrder = { -- the order to display the items in english                      210399,                      210400,                      210401,                      210402,                  },              },              deDE = { -- the text to display for german                  text = "The items %s might be %s in a different %s order of items %s in german",                  itemOrder = { -- the order to display the items in german                      210401,                      210402,                      210399,                      210400,                  },              },         },     },     {         name = "Emerald Mark of Mastery",         questID = 75624,         icon = "interface/icons/inv_mushroom_11",         announce = {             enUS = { -- the text to display for english                 text = "Awarded for outstanding service to Dragonkind.\n%s\nBring it to Theozhaklos the Curious at the Wellspring \nOverlook in the Emerald Dream to receive powerful \nequipment for your efforts",                 itemOrder = { -- the order to display the items in english                     20897,                 },             },             deDE = { -- the text to display for german                 text = "Only one %s in this entry",                 itemOrder = { -- the order to display the items in german                     20897,                 },             },         }     }, } --------------------------------------------------------------------------------------------------- -- Code to replace %s in announce texts with item links. Replaces the GetItemLinkById(...) function   local itemList = {} -- table to save the itsmID to   for index, v in ipairs(addon.db) do -- get/save every itmeID in addon.db announce    for k, itemID in pairs(v.announce.enUS.itemOrder) do -- assumes all announce entries will use all the same itemIDs       if not itemList[itemID] then          itemList[itemID] = true       end    end end   local function FormatTexts() -- fill addon.db with the item links    for index, v in ipairs(addon.db) do       for locale, settings in pairs(v.announce) do          local order = {}            for i, link in ipairs(settings.itemOrder) do -- get the links in order from addon.db             order[i] = itemList[link] -- and save them into a tmporary table          end          settings.text = format(settings.text, unpack(order)) -- replace %s with the ordered item links (unpack(table) returns a number keyed tables entries in order eg. order[1], order[2], order[3] etc.)       end    end   end   local function LoadItem(item) -- Get the links for all the saved itemIDs    if item then       itemList[item:GetItemID()] = item:GetItemLink()    end    local key = next(itemList, item and item.Next or nil)    if not key then -- when we have all the links for all the items       FormatTexts() -- Run FormatTexts() to do the text replacements       return    end    local nextItem = Item:CreateFromItemID(key)    nextItem.Next = key    nextItem:ContinueOnItemLoad(function() LoadItem(nextItem) end) end LoadItem()

Hello thank you very much. After this, the table call button stopped working.

local addonName, addon = ...
 
-- function to show the item tooltip when a hyperlink is clicked
local function OnHyperlinkClick(self, link, text, region, left, bottom, width, heigh) -- Show the hyperling tooltip when clicked
    SetItemRef(link, text, nil, self);
end
 
local CELL_WIDTH = 400
local CELL_HEIGHT = 80
local NUM_CELLS = 2
 
local data = {}
 
local f = CreateFrame("Frame", "SimpleScrollFrameTableDemo", UIParent, "BasicFrameTemplateWithInset")
 
-- Create the button here
local btn = CreateFrame("Button", nil, UIParent, "UIPanelButtonTemplate")
 
local locale = GetLocale() -- get the current locale eg. "frFR"
local function updateData()
    wipe(data)
    for _, item in ipairs(addon.db) do
        local announceText = item.announce[locale] or item.announce.enUS -- default to enUS if the locale text doesn't exist.
        tinsert(data, {announceText, item.icon, item.name})
    end
end
 
f:SetSize(CELL_WIDTH * NUM_CELLS + 80, 600)
f:SetPoint("CENTER")
f:Hide()
f:SetMovable(true)
f:SetScript("OnMouseDown", f.StartMoving)
f:SetScript("OnMouseUp", f.StopMovingOrSizing)
 
-- I added this OnHide script
f:SetScript("OnHide", function()
    btn:Show()
end)
 
f.scrollFrame = CreateFrame("ScrollFrame", nil, f, "UIPanelScrollFrameTemplate")
f.scrollFrame:SetPoint("TOPLEFT", 12, -32)
f.scrollFrame:SetPoint("BOTTOMRIGHT", -34, 8)
 
f.scrollFrame.scrollChild = CreateFrame("Frame", nil, f.scrollFrame)
f.scrollFrame.scrollChild:SetSize(100, 100)
f.scrollFrame.scrollChild:SetPoint("TOPLEFT", 5, -5)
f.scrollFrame:SetScrollChild(f.scrollFrame.scrollChild)
 
local content = f.scrollFrame.scrollChild
content.rows = {}
 
local function updateList()
    for i = 1, #data do
        if not content.rows[i] then
            local button = CreateFrame("Button", nil, content)
            button:SetSize(CELL_WIDTH * NUM_CELLS, CELL_HEIGHT)
            button:SetPoint("TOPLEFT", 0, -(i - 1) * CELL_HEIGHT)
            button.columns = {}
 
---------------------------------------------------------------------------------------------------
-- code to make item links work
            button:SetHyperlinksEnabled(true) -- Setup hyperlinking for each row
            button:SetScript("OnHyperlinkClick", OnHyperlinkClick) -- What to do when a link is clicked
---------------------------------------------------------------------------------------------------
 
            button.columns[1] = button:CreateFontString(nil, "ARTWORK", "GameFontHighlight")
            button.columns[1]:SetPoint("LEFT", (0) * CELL_WIDTH, 0)
 
            button.columns[2] = button:CreateTexture()
            button.columns[2]:SetPoint("LEFT", 410, 0, (1) * CELL_WIDTH, 0)
 
            button.columns[3] = button:CreateFontString(nil, "ARTWORK", "GameFontHighlight")
            button.columns[3]:SetPoint("LEFT", 480, 0, (2) * CELL_WIDTH, 0)
 
            content.rows[i] = button
        end
 
        content.rows[i].columns[1]:SetText(data[i][1])
        content.rows[i].columns[2]:SetTexture(data[i][2])
        content.rows[i].columns[3]:SetText(data[i][3])
 
        content.rows[i]:Show()
    end
 
    for i = #data + 1, #content.rows do
        content.rows[i]:Hide()
    end
end
 
 
-- Set your button options here
local btn = CreateFrame("Button", "Hubb777MovingButton", UIParent, "UIPanelButtonTemplate") 
btn:SetPoint("CENTER")
btn:SetSize(100, 40)
btn:SetText("Rewards")
btn:SetMovable(true)
btn:RegisterForDrag('LeftButton')
btn:RegisterForClicks("AnyDown", "AnyUp")
btn:SetUserPlaced(true)
btn:SetScript('OnDragStart', function(self, button, down)
    if button == "LeftButton" and IsShiftKeyDown() then
        self:StartMoving()
    end
end)
btn:SetScript('OnDragStop', function(self)
    self:StopMovingOrSizing()
end)
btn:SetScript("OnMouseUp", function(self, button, ...)
    if (button == "RightButton" and self:IsVisible()) then
        self:Hide()
    elseif button == "LeftButton" and not IsShiftKeyDown() then
        updateData()
        updateList()
        f:Show()
    end
end)
 
SLASH_HUBB1 = "/hubb"
SlashCmdList["HUBB"] = function(msg)
    if strupper(strtrim(msg)) == "BTN" then -- toggle the shown state of the button if the type /hubb btn
        btn:SetShown(not btn:IsShown()) -- show the button
        return
    end
    updateData()
    updateList()
    f:Show()
end

[Fizzlemizz]

At some point along the line the addon .db table go messed up and the name field in the first first entry became a table instead of a string.

The 2 files

data (addon.db)

local addonName, addon = ...
addon.db = {
    {
        name = "Emerald Mark of Mastery",
        questID = 75612,
        icon = "interface/icons/inv_mushroom_11",
        announce = {
             enUS = { -- the text to display for english
                 text = "Awarded for %s outstanding service %s to Dragonkind.\n%s\nBring it to Theozhaklos the Curious at the Wellspring \nOverlook in the Emerald %s Dream to receive powerful \nequipment for your efforts",
                 itemOrder = { -- the order to display the items in english
                     210399,
                     210400,
                     210401,
                     210402,
                 },
             },
             deDE = { -- the text to display for german
                 text = "The items %s might be %s in a different %s order of items %s in german",
                 itemOrder = { -- the order to display the items in german
                     210401,
                     210402,
                     210399,
                     210400,
                 },
             },
        },
    },
    {
        name = "Emerald Mark of Mastery",
        questID = 75624,
        icon = "interface/icons/inv_mushroom_11",
        announce = {
            enUS = { -- the text to display for english
                text = "Awarded for outstanding service to Dragonkind.\n%s\nBring it to Theozhaklos the Curious at the Wellspring \nOverlook in the Emerald Dream to receive powerful \nequipment for your efforts",
                itemOrder = { -- the order to display the items in english
                    20897,
                },
            },
            deDE = { -- the text to display for german
                text = "Only one %s in this entry",
                itemOrder = { -- the order to display the items in german
                    20897,
                },
            },
        }
    },
}
---------------------------------------------------------------------------------------------------
-- Code to replace %s in announce texts with item links. Replaces the GetItemLinkById(...) function
 
local itemList = {} -- table to save the itsmID to
 
for index, v in ipairs(addon.db) do -- get/save every itmeID in addon.db announce 
   for k, itemID in pairs(v.announce.enUS.itemOrder) do -- assumes all announce entries will use all the same itemIDs
      if not itemList[itemID] then
         itemList[itemID] = true
      end
   end
end
 
local function FormatTexts() -- fill addon.db with the item links
   for index, v in ipairs(addon.db) do
      for locale, settings in pairs(v.announce) do
         local order = {}   
         for i, link in ipairs(settings.itemOrder) do -- get the links in order from addon.db
            order[i] = itemList[link] -- and save them into a tmporary table
         end
         settings.text = format(settings.text, unpack(order)) -- replace %s with the ordered item links (unpack(table) returns a number keyed tables entries in order eg. order[1], order[2], order[3] etc.)
      end
   end
 
end
 
local function LoadItem(item) -- Get the links for all the saved itemIDs
   if item then
      itemList[item:GetItemID()] = item:GetItemLink()
   end
   local key = next(itemList, item and item.Next or nil)
   if not key then -- when we have all the links for all the items
      FormatTexts() -- Run FormatTexts() to do the text replacements
      return
   end
   local nextItem = Item:CreateFromItemID(key)
   nextItem.Next = key
   nextItem:ContinueOnItemLoad(function() LoadItem(nextItem) end)
end
LoadItem()

Code (everything else)

local addonName, addon = ...
 
-- function to show the item tooltip when a hyperlink is clicked
local function OnHyperlinkClick(self, link, text, region, left, bottom, width, heigh) -- Show the hyperling tooltip when clicked
    SetItemRef(link, text, nil, self);
end
 
local CELL_WIDTH = 400
local CELL_HEIGHT = 80
local NUM_CELLS = 2
 
local data = {}
 
local f = CreateFrame("Frame", "SimpleScrollFrameTableDemo", UIParent, "BasicFrameTemplateWithInset")
 
-- Create the button here
local btn = CreateFrame("Button", nil, UIParent, "UIPanelButtonTemplate")
 
local locale = GetLocale() -- get the current locale eg. "frFR"
local function updateData()
    wipe(data)
    for _, item in ipairs(addon.db) do
        local announceText = item.announce[locale].text or item.announce.enUS.text -- default to enUS if the locale text doesn't exist.
        tinsert(data, {announceText, item.icon, item.name})
    end
end
 
f:SetSize(CELL_WIDTH * NUM_CELLS + 80, 600)
f:SetPoint("CENTER")
f:Hide()
f:SetMovable(true)
f:SetScript("OnMouseDown", f.StartMoving)
f:SetScript("OnMouseUp", f.StopMovingOrSizing)
 
-- I added this OnHide script
f:SetScript("OnHide", function()
    btn:Show()
end)
 
f.scrollFrame = CreateFrame("ScrollFrame", nil, f, "UIPanelScrollFrameTemplate")
f.scrollFrame:SetPoint("TOPLEFT", 12, -32)
f.scrollFrame:SetPoint("BOTTOMRIGHT", -34, 8)
 
f.scrollFrame.scrollChild = CreateFrame("Frame", nil, f.scrollFrame)
f.scrollFrame.scrollChild:SetSize(100, 100)
f.scrollFrame.scrollChild:SetPoint("TOPLEFT", 5, -5)
f.scrollFrame:SetScrollChild(f.scrollFrame.scrollChild)
 
local content = f.scrollFrame.scrollChild
content.rows = {}
 
local function updateList()
    for i = 1, #data do
        if not content.rows[i] then
            local button = CreateFrame("Button", nil, content)
            button:SetSize(CELL_WIDTH * NUM_CELLS, CELL_HEIGHT)
            button:SetPoint("TOPLEFT", 0, -(i - 1) * CELL_HEIGHT)
            button.columns = {}
 
---------------------------------------------------------------------------------------------------
-- code to make item links work
            button:SetHyperlinksEnabled(true) -- Setup hyperlinking for each row
            button:SetScript("OnHyperlinkClick", OnHyperlinkClick) -- What to do when a link is clicked
---------------------------------------------------------------------------------------------------
 
            button.columns[1] = button:CreateFontString(nil, "ARTWORK", "GameFontHighlight")
            button.columns[1]:SetPoint("TOPLEFT", (0) * CELL_WIDTH, 0)
            button.columns[1]:SetPoint("BOTTOMRIGHT", button, "BOTTOMLEFT", CELL_WIDTH, 0)
 
            button.columns[2] = button:CreateTexture()
            button.columns[2]:SetPoint("LEFT", 410, 0, (1) * CELL_WIDTH, 0)
 
            button.columns[3] = button:CreateFontString(nil, "ARTWORK", "GameFontHighlight")
            button.columns[3]:SetPoint("LEFT", 480, 0, (2) * CELL_WIDTH, 0)
 
            content.rows[i] = button
        end
 
        content.rows[i].columns[1]:SetText(data[i][1])
        content.rows[i].columns[2]:SetTexture(data[i][2])
        content.rows[i].columns[3]:SetText(data[i][3])
 
        content.rows[i]:Show()
    end
 
    for i = #data + 1, #content.rows do
        content.rows[i]:Hide()
    end
end
 
 
-- Set your button options here
local btn = CreateFrame("Button", "Hubb777MovingButton", UIParent, "UIPanelButtonTemplate") 
btn:SetPoint("CENTER")
btn:SetSize(100, 40)
btn:SetText("Rewards")
btn:SetMovable(true)
btn:RegisterForDrag('LeftButton')
btn:RegisterForClicks("AnyDown", "AnyUp")
btn:SetUserPlaced(true)
btn:SetScript('OnDragStart', function(self, button, down)
    if button == "LeftButton" and IsShiftKeyDown() then
        self:StartMoving()
    end
end)
btn:SetScript('OnDragStop', function(self)
    self:StopMovingOrSizing()
end)
btn:SetScript("OnMouseUp", function(self, button, ...)
    if (button == "RightButton" and self:IsVisible()) then
        self:Hide()
    elseif button == "LeftButton" and not IsShiftKeyDown() then
        updateData()
        updateList()
        f:Show()
    end
end)
 
SLASH_HUBB1 = "/hubb"
SlashCmdList["HUBB"] = function(msg)
    if strupper(strtrim(msg)) == "BTN" then -- toggle the shown state of the button if the type /hubb btn
        btn:SetShown(not btn:IsShown()) -- show the button
        return
    end
    updateData()
    updateList()
    f:Show()
end

[Hubb777]

Yes it works. Thank you very much. And the last question (with your help I have already figured out a lot)
I replaced

name = "Emerald Mark of Mastery",

on

name = {
            enUS = "Herb-Infused Water",
            deDE = "Mit Kräutern aromatisiertes Wasser"
        },

and the button stopped working =(

[Fizzlemizz]

Because the original table wasn't set up with localised names, we were just dealing with the announce texts.

To add localise names you woud have to convert ALL the name entried to tables:

Data

local addonName, addon = ...
addon.db = {
    {
        name = {
            enUS = "Emerald Mark of Mastery",
            deDE = "German for Emerald Mark of Mastery",
        }
        questID = 75612,
        icon = "interface/icons/inv_mushroom_11",
        announce = {
             enUS = { -- the text to display for english
                 text = "Awarded for %s outstanding service %s to Dragonkind.\n%s\nBring it to Theozhaklos the Curious at the Wellspring \nOverlook in the Emerald %s Dream to receive powerful \nequipment for your efforts",
                 itemOrder = { -- the order to display the items in english
                     210399,
                     210400,
                     210401,
                     210402,
                 },
             },
             deDE = { -- the text to display for german
                 text = "The items %s might be %s in a different %s order of items %s in german",
                 itemOrder = { -- the order to display the items in german
                     210401,
                     210402,
                     210399,
                     210400,
                 },
             },
        },
    },
    {
        name = {
            enUS = "Name number 2",
            deDE = "German for Name number 2",
        }
        questID = 75624,
        icon = "interface/icons/inv_mushroom_11",
        announce = {
            enUS = { -- the text to display for english
                text = "Awarded for outstanding service to Dragonkind.\n%s\nBring it to Theozhaklos the Curious at the Wellspring \nOverlook in the Emerald Dream to receive powerful \nequipment for your efforts",
                itemOrder = { -- the order to display the items in english
                    20897,
                },
            },
            deDE = { -- the text to display for german
                text = "Only one %s in this entry",
                itemOrder = { -- the order to display the items in german
                    20897,
                },
            },
        }
    },
}

And change the tinsert line in the updateData() function to reflect the change

Code

local addonName, addon = ...
 
-- function to show the item tooltip when a hyperlink is clicked
local function OnHyperlinkClick(self, link, text, region, left, bottom, width, heigh) -- Show the hyperling tooltip when clicked
    SetItemRef(link, text, nil, self);
end
 
local CELL_WIDTH = 400
local CELL_HEIGHT = 80
local NUM_CELLS = 2
 
local data = {}
 
local f = CreateFrame("Frame", "SimpleScrollFrameTableDemo", UIParent, "BasicFrameTemplateWithInset")
 
-- Create the button here
local btn = CreateFrame("Button", nil, UIParent, "UIPanelButtonTemplate")
 
local locale = GetLocale() -- get the current locale eg. "frFR"
local function updateData()
    wipe(data)
    for _, item in ipairs(addon.db) do
        local announceText = item.announce[locale].text or item.announce.enUS.text -- default to enUS if the locale text doesn't exist.
        tinsert(data, {announceText, item.icon, item.name[locale] or item.name.enUS})
    end
end
 
f:SetSize(CELL_WIDTH * NUM_CELLS + 80, 600)
f:SetPoint("CENTER")
f:Hide()
f:SetMovable(true)
f:SetScript("OnMouseDown", f.StartMoving)
f:SetScript("OnMouseUp", f.StopMovingOrSizing)
 
-- I added this OnHide script
f:SetScript("OnHide", function()
    btn:Show()
end)
 
f.scrollFrame = CreateFrame("ScrollFrame", nil, f, "UIPanelScrollFrameTemplate")
f.scrollFrame:SetPoint("TOPLEFT", 12, -32)
f.scrollFrame:SetPoint("BOTTOMRIGHT", -34, 8)
 
f.scrollFrame.scrollChild = CreateFrame("Frame", nil, f.scrollFrame)
f.scrollFrame.scrollChild:SetSize(100, 100)
f.scrollFrame.scrollChild:SetPoint("TOPLEFT", 5, -5)
f.scrollFrame:SetScrollChild(f.scrollFrame.scrollChild)
 
local content = f.scrollFrame.scrollChild
content.rows = {}
 
local function updateList()
    for i = 1, #data do
        if not content.rows[i] then
            local button = CreateFrame("Button", nil, content)
            button:SetSize(CELL_WIDTH * NUM_CELLS, CELL_HEIGHT)
            button:SetPoint("TOPLEFT", 0, -(i - 1) * CELL_HEIGHT)
            button.columns = {}
 
---------------------------------------------------------------------------------------------------
-- code to make item links work
            button:SetHyperlinksEnabled(true) -- Setup hyperlinking for each row
            button:SetScript("OnHyperlinkClick", OnHyperlinkClick) -- What to do when a link is clicked
---------------------------------------------------------------------------------------------------
 
            button.columns[1] = button:CreateFontString(nil, "ARTWORK", "GameFontHighlight")
            button.columns[1]:SetPoint("TOPLEFT", (0) * CELL_WIDTH, 0)
            button.columns[1]:SetPoint("BOTTOMRIGHT", button, "BOTTOMLEFT", CELL_WIDTH, 0)
 
            button.columns[2] = button:CreateTexture()
            button.columns[2]:SetPoint("LEFT", 410, 0, (1) * CELL_WIDTH, 0)
 
            button.columns[3] = button:CreateFontString(nil, "ARTWORK", "GameFontHighlight")
            button.columns[3]:SetPoint("LEFT", 480, 0, (2) * CELL_WIDTH, 0)
 
            content.rows[i] = button
        end
 
        content.rows[i].columns[1]:SetText(data[i][1])
        content.rows[i].columns[2]:SetTexture(data[i][2])
        content.rows[i].columns[3]:SetText(data[i][3])
 
        content.rows[i]:Show()
    end
 
    for i = #data + 1, #content.rows do
        content.rows[i]:Hide()
    end
end
 
 
-- Set your button options here
local btn = CreateFrame("Button", "Hubb777MovingButton", UIParent, "UIPanelButtonTemplate") 
btn:SetPoint("CENTER")
btn:SetSize(100, 40)
btn:SetText("Rewards")
btn:SetMovable(true)
btn:RegisterForDrag('LeftButton')
btn:RegisterForClicks("AnyDown", "AnyUp")
btn:SetUserPlaced(true)
btn:SetScript('OnDragStart', function(self, button, down)
    if button == "LeftButton" and IsShiftKeyDown() then
        self:StartMoving()
    end
end)
btn:SetScript('OnDragStop', function(self)
    self:StopMovingOrSizing()
end)
btn:SetScript("OnMouseUp", function(self, button, ...)
    if (button == "RightButton" and self:IsVisible()) then
        self:Hide()
    elseif button == "LeftButton" and not IsShiftKeyDown() then
        updateData()
        updateList()
        f:Show()
    end
end)
 
SLASH_HUBB1 = "/hubb"
SlashCmdList["HUBB"] = function(msg)
    if strupper(strtrim(msg)) == "BTN" then -- toggle the shown state of the button if the type /hubb btn
        btn:SetShown(not btn:IsShown()) -- show the button
        return
    end
    updateData()
    updateList()
    f:Show()
end

[Hubb777]

Originally Posted by Fizzlemizz Because the original table wasn't set up with localised names, we were just dealing with the announce texts. To add localise names you woud have to convert ALL the name entried to tables: Data local addonName, addon = ... addon.db = {     {         name = {             enUS = "Emerald Mark of Mastery",             deDE = "German for Emerald Mark of Mastery",         }         questID = 75612,         icon = "interface/icons/inv_mushroom_11",         announce = {              enUS = { -- the text to display for english                  text = "Awarded for %s outstanding service %s to Dragonkind.\n%s\nBring it to Theozhaklos the Curious at the Wellspring \nOverlook in the Emerald %s Dream to receive powerful \nequipment for your efforts",                  itemOrder = { -- the order to display the items in english                      210399,                      210400,                      210401,                      210402,                  },              },              deDE = { -- the text to display for german                  text = "The items %s might be %s in a different %s order of items %s in german",                  itemOrder = { -- the order to display the items in german                      210401,                      210402,                      210399,                      210400,                  },              },         },     },     {         name = {             enUS = "Name number 2",             deDE = "German for Name number 2",         }         questID = 75624,         icon = "interface/icons/inv_mushroom_11",         announce = {             enUS = { -- the text to display for english                 text = "Awarded for outstanding service to Dragonkind.\n%s\nBring it to Theozhaklos the Curious at the Wellspring \nOverlook in the Emerald Dream to receive powerful \nequipment for your efforts",                 itemOrder = { -- the order to display the items in english                     20897,                 },             },             deDE = { -- the text to display for german                 text = "Only one %s in this entry",                 itemOrder = { -- the order to display the items in german                     20897,                 },             },         }     }, } And change the tinsert line in the updateData() function to reflect the change Code local addonName, addon = ...   -- function to show the item tooltip when a hyperlink is clicked local function OnHyperlinkClick(self, link, text, region, left, bottom, width, heigh) -- Show the hyperling tooltip when clicked     SetItemRef(link, text, nil, self); end   local CELL_WIDTH = 400 local CELL_HEIGHT = 80 local NUM_CELLS = 2   local data = {}   local f = CreateFrame("Frame", "SimpleScrollFrameTableDemo", UIParent, "BasicFrameTemplateWithInset")   -- Create the button here local btn = CreateFrame("Button", nil, UIParent, "UIPanelButtonTemplate")   local locale = GetLocale() -- get the current locale eg. "frFR" local function updateData()     wipe(data)     for _, item in ipairs(addon.db) do         local announceText = item.announce[locale].text or item.announce.enUS.text -- default to enUS if the locale text doesn't exist.         tinsert(data, {announceText, item.icon, item.name[locale] or item.name.enUS})     end end   f:SetSize(CELL_WIDTH * NUM_CELLS + 80, 600) f:SetPoint("CENTER") f:Hide() f:SetMovable(true) f:SetScript("OnMouseDown", f.StartMoving) f:SetScript("OnMouseUp", f.StopMovingOrSizing)   -- I added this OnHide script f:SetScript("OnHide", function()     btn:Show() end)   f.scrollFrame = CreateFrame("ScrollFrame", nil, f, "UIPanelScrollFrameTemplate") f.scrollFrame:SetPoint("TOPLEFT", 12, -32) f.scrollFrame:SetPoint("BOTTOMRIGHT", -34, 8)   f.scrollFrame.scrollChild = CreateFrame("Frame", nil, f.scrollFrame) f.scrollFrame.scrollChild:SetSize(100, 100) f.scrollFrame.scrollChild:SetPoint("TOPLEFT", 5, -5) f.scrollFrame:SetScrollChild(f.scrollFrame.scrollChild)   local content = f.scrollFrame.scrollChild content.rows = {}   local function updateList()     for i = 1, #data do         if not content.rows[i] then             local button = CreateFrame("Button", nil, content)             button:SetSize(CELL_WIDTH * NUM_CELLS, CELL_HEIGHT)             button:SetPoint("TOPLEFT", 0, -(i - 1) * CELL_HEIGHT)             button.columns = {}   --------------------------------------------------------------------------------------------------- -- code to make item links work             button:SetHyperlinksEnabled(true) -- Setup hyperlinking for each row             button:SetScript("OnHyperlinkClick", OnHyperlinkClick) -- What to do when a link is clicked ---------------------------------------------------------------------------------------------------               button.columns[1] = button:CreateFontString(nil, "ARTWORK", "GameFontHighlight")             button.columns[1]:SetPoint("TOPLEFT", (0) * CELL_WIDTH, 0)             button.columns[1]:SetPoint("BOTTOMRIGHT", button, "BOTTOMLEFT", CELL_WIDTH, 0)               button.columns[2] = button:CreateTexture()             button.columns[2]:SetPoint("LEFT", 410, 0, (1) * CELL_WIDTH, 0)               button.columns[3] = button:CreateFontString(nil, "ARTWORK", "GameFontHighlight")             button.columns[3]:SetPoint("LEFT", 480, 0, (2) * CELL_WIDTH, 0)               content.rows[i] = button         end           content.rows[i].columns[1]:SetText(data[i][1])         content.rows[i].columns[2]:SetTexture(data[i][2])         content.rows[i].columns[3]:SetText(data[i][3])           content.rows[i]:Show()     end       for i = #data + 1, #content.rows do         content.rows[i]:Hide()     end end     -- Set your button options here local btn = CreateFrame("Button", "Hubb777MovingButton", UIParent, "UIPanelButtonTemplate") btn:SetPoint("CENTER") btn:SetSize(100, 40) btn:SetText("Rewards") btn:SetMovable(true) btn:RegisterForDrag('LeftButton') btn:RegisterForClicks("AnyDown", "AnyUp") btn:SetUserPlaced(true) btn:SetScript('OnDragStart', function(self, button, down)     if button == "LeftButton" and IsShiftKeyDown() then         self:StartMoving()     end end) btn:SetScript('OnDragStop', function(self)     self:StopMovingOrSizing() end) btn:SetScript("OnMouseUp", function(self, button, ...)     if (button == "RightButton" and self:IsVisible()) then         self:Hide()     elseif button == "LeftButton" and not IsShiftKeyDown() then         updateData()         updateList()         f:Show()     end end)   SLASH_HUBB1 = "/hubb" SlashCmdList["HUBB"] = function(msg)     if strupper(strtrim(msg)) == "BTN" then -- toggle the shown state of the button if the type /hubb btn         btn:SetShown(not btn:IsShown()) -- show the button         return     end     updateData()     updateList()     f:Show() end

I used your example but it still didn't work

[Fizzlemizz]

Missing commas, mayube this time.

local addonName, addon = ...
addon.db = {
    {
        name = {
            enUS = "Emerald Mark of Mastery",
            deDE = "German for Emerald Mark of Mastery",
        },
        questID = 75612,
        icon = "interface/icons/inv_mushroom_11",
        announce = {
             enUS = { -- the text to display for english
                 text = "Awarded for %s outstanding service %s to Dragonkind.\n%s\nBring it to Theozhaklos the Curious at the Wellspring \nOverlook in the Emerald %s Dream to receive powerful \nequipment for your efforts",
                 itemOrder = { -- the order to display the items in english
                     210399,
                     210400,
                     210401,
                     210402,
                 },
             },
             deDE = { -- the text to display for german
                 text = "The items %s might be %s in a different %s order of items %s in german",
                 itemOrder = { -- the order to display the items in german
                     210401,
                     210402,
                     210399,
                     210400,
                 },
             },
        },
    },
    {
        name = {
            enUS = "Name number 2",
            deDE = "German for Name number 2",
        },
        questID = 75624,
        icon = "interface/icons/inv_mushroom_11",
        announce = {
            enUS = { -- the text to display for english
                text = "Awarded for outstanding service to Dragonkind.\n%s\nBring it to Theozhaklos the Curious at the Wellspring \nOverlook in the Emerald Dream to receive powerful \nequipment for your efforts",
                itemOrder = { -- the order to display the items in english
                    20897,
                },
            },
            deDE = { -- the text to display for german
                text = "Only one %s in this entry",
                itemOrder = { -- the order to display the items in german
                    20897,
                },
            },
        }
    },
}
    ---------------------------------------------------------------------------------------------------
-- Code to replace %s in announce texts with item links. Replaces the GetItemLinkById(...) function
 
local itemList = {} -- table to save the itsmID to
 
for index, v in ipairs(addon.db) do -- get/save every itmeID in addon.db announce 
   for k, itemID in pairs(v.announce.enUS.itemOrder) do -- assumes all announce entries will use all the same itemIDs
      if not itemList[itemID] then
         itemList[itemID] = true
      end
   end
end
 
local function FormatTexts() -- fill addon.db with the item links
   for index, v in ipairs(addon.db) do
      for locale, settings in pairs(v.announce) do
         local order = {}   
         for i, link in ipairs(settings.itemOrder) do -- get the links in order from addon.db
            order[i] = itemList[link] -- and save them into a tmporary table
         end
         settings.text = format(settings.text, unpack(order)) -- replace %s with the ordered item links (unpack(table) returns a number keyed tables entries in order eg. order[1], order[2], order[3] etc.)
      end
   end
 
end
 
local function LoadItem(item) -- Get the links for all the saved itemIDs
   if item then
      itemList[item:GetItemID()] = item:GetItemLink()
   end
   local key = next(itemList, item and item.Next or nil)
   if not key then -- when we have all the links for all the items
      FormatTexts() -- Run FormatTexts() to do the text replacements
      return
   end
   local nextItem = Item:CreateFromItemID(key)
   nextItem.Next = key
   nextItem:ContinueOnItemLoad(function() LoadItem(nextItem) end)
end
LoadItem()

local addonName, addon = ...
 
-- function to show the item tooltip when a hyperlink is clicked
local function OnHyperlinkClick(self, link, text, region, left, bottom, width, heigh) -- Show the hyperling tooltip when clicked
    SetItemRef(link, text, nil, self);
end
 
local CELL_WIDTH = 400
local CELL_HEIGHT = 80
local NUM_CELLS = 2
 
local data = {}
 
local f = CreateFrame("Frame", "SimpleScrollFrameTableDemo", UIParent, "BasicFrameTemplateWithInset")
 
-- Create the button here
local btn = CreateFrame("Button", nil, UIParent, "UIPanelButtonTemplate")
 
local locale = GetLocale() -- get the current locale eg. "frFR"
local function updateData()
    wipe(data)
    for _, item in ipairs(addon.db) do
        local announceText = item.announce[locale].text or item.announce.enUS.text -- default to enUS if the locale text doesn't exist.
        tinsert(data, {announceText, item.icon, item.name[locale] or item.name.enUS})
    end
end
 
f:SetSize(CELL_WIDTH * NUM_CELLS + 80, 600)
f:SetPoint("CENTER")
f:Hide()
f:SetMovable(true)
f:SetScript("OnMouseDown", f.StartMoving)
f:SetScript("OnMouseUp", f.StopMovingOrSizing)
 
-- I added this OnHide script
f:SetScript("OnHide", function()
    btn:Show()
end)
 
f.scrollFrame = CreateFrame("ScrollFrame", nil, f, "UIPanelScrollFrameTemplate")
f.scrollFrame:SetPoint("TOPLEFT", 12, -32)
f.scrollFrame:SetPoint("BOTTOMRIGHT", -34, 8)
 
f.scrollFrame.scrollChild = CreateFrame("Frame", nil, f.scrollFrame)
f.scrollFrame.scrollChild:SetSize(100, 100)
f.scrollFrame.scrollChild:SetPoint("TOPLEFT", 5, -5)
f.scrollFrame:SetScrollChild(f.scrollFrame.scrollChild)
 
local content = f.scrollFrame.scrollChild
content.rows = {}
 
local function updateList()
    for i = 1, #data do
        if not content.rows[i] then
            local button = CreateFrame("Button", nil, content)
            button:SetSize(CELL_WIDTH * NUM_CELLS, CELL_HEIGHT)
            button:SetPoint("TOPLEFT", 0, -(i - 1) * CELL_HEIGHT)
            button.columns = {}
 
---------------------------------------------------------------------------------------------------
-- code to make item links work
            button:SetHyperlinksEnabled(true) -- Setup hyperlinking for each row
            button:SetScript("OnHyperlinkClick", OnHyperlinkClick) -- What to do when a link is clicked
---------------------------------------------------------------------------------------------------
 
            button.columns[1] = button:CreateFontString(nil, "ARTWORK", "GameFontHighlight")
            button.columns[1]:SetPoint("TOPLEFT", (0) * CELL_WIDTH, 0)
            button.columns[1]:SetPoint("BOTTOMRIGHT", button, "BOTTOMLEFT", CELL_WIDTH, 0)
 
            button.columns[2] = button:CreateTexture()
            button.columns[2]:SetPoint("LEFT", 410, 0, (1) * CELL_WIDTH, 0)
 
            button.columns[3] = button:CreateFontString(nil, "ARTWORK", "GameFontHighlight")
            button.columns[3]:SetPoint("LEFT", 480, 0, (2) * CELL_WIDTH, 0)
 
            content.rows[i] = button
        end
 
        content.rows[i].columns[1]:SetText(data[i][1])
        content.rows[i].columns[2]:SetTexture(data[i][2])
        content.rows[i].columns[3]:SetText(data[i][3])
 
        content.rows[i]:Show()
    end
 
    for i = #data + 1, #content.rows do
        content.rows[i]:Hide()
    end
end
 
 
-- Set your button options here
local btn = CreateFrame("Button", "Hubb777MovingButton", UIParent, "UIPanelButtonTemplate") 
btn:SetPoint("CENTER")
btn:SetSize(100, 40)
btn:SetText("Rewards")
btn:SetMovable(true)
btn:RegisterForDrag('LeftButton')
btn:RegisterForClicks("AnyDown", "AnyUp")
btn:SetUserPlaced(true)
btn:SetScript('OnDragStart', function(self, button, down)
    if button == "LeftButton" and IsShiftKeyDown() then
        self:StartMoving()
    end
end)
btn:SetScript('OnDragStop', function(self)
    self:StopMovingOrSizing()
end)
btn:SetScript("OnMouseUp", function(self, button, ...)
    if (button == "RightButton" and self:IsVisible()) then
        self:Hide()
    elseif button == "LeftButton" and not IsShiftKeyDown() then
        updateData()
        updateList()
        f:Show()
    end
end)
 
SLASH_HUBB1 = "/hubb"
SlashCmdList["HUBB"] = function(msg)
    if strupper(strtrim(msg)) == "BTN" then -- toggle the shown state of the button if the type /hubb btn
        btn:SetShown(not btn:IsShown()) -- show the button
        return
    end
    updateData()
    updateList()
    f:Show()
end

[Hubb777]

Originally Posted by Fizzlemizz Missing commas, mayube this time. local addonName, addon = ... addon.db = {     {         name = {             enUS = "Emerald Mark of Mastery",             deDE = "German for Emerald Mark of Mastery",         },         questID = 75612,         icon = "interface/icons/inv_mushroom_11",         announce = {              enUS = { -- the text to display for english                  text = "Awarded for %s outstanding service %s to Dragonkind.\n%s\nBring it to Theozhaklos the Curious at the Wellspring \nOverlook in the Emerald %s Dream to receive powerful \nequipment for your efforts",                  itemOrder = { -- the order to display the items in english                      210399,                      210400,                      210401,                      210402,                  },              },              deDE = { -- the text to display for german                  text = "The items %s might be %s in a different %s order of items %s in german",                  itemOrder = { -- the order to display the items in german                      210401,                      210402,                      210399,                      210400,                  },              },         },     },     {         name = {             enUS = "Name number 2",             deDE = "German for Name number 2",         },         questID = 75624,         icon = "interface/icons/inv_mushroom_11",         announce = {             enUS = { -- the text to display for english                 text = "Awarded for outstanding service to Dragonkind.\n%s\nBring it to Theozhaklos the Curious at the Wellspring \nOverlook in the Emerald Dream to receive powerful \nequipment for your efforts",                 itemOrder = { -- the order to display the items in english                     20897,                 },             },             deDE = { -- the text to display for german                 text = "Only one %s in this entry",                 itemOrder = { -- the order to display the items in german                     20897,                 },             },         }     }, }     --------------------------------------------------------------------------------------------------- -- Code to replace %s in announce texts with item links. Replaces the GetItemLinkById(...) function   local itemList = {} -- table to save the itsmID to   for index, v in ipairs(addon.db) do -- get/save every itmeID in addon.db announce    for k, itemID in pairs(v.announce.enUS.itemOrder) do -- assumes all announce entries will use all the same itemIDs       if not itemList[itemID] then          itemList[itemID] = true       end    end end   local function FormatTexts() -- fill addon.db with the item links    for index, v in ipairs(addon.db) do       for locale, settings in pairs(v.announce) do          local order = {}            for i, link in ipairs(settings.itemOrder) do -- get the links in order from addon.db             order[i] = itemList[link] -- and save them into a tmporary table          end          settings.text = format(settings.text, unpack(order)) -- replace %s with the ordered item links (unpack(table) returns a number keyed tables entries in order eg. order[1], order[2], order[3] etc.)       end    end   end   local function LoadItem(item) -- Get the links for all the saved itemIDs    if item then       itemList[item:GetItemID()] = item:GetItemLink()    end    local key = next(itemList, item and item.Next or nil)    if not key then -- when we have all the links for all the items       FormatTexts() -- Run FormatTexts() to do the text replacements       return    end    local nextItem = Item:CreateFromItemID(key)    nextItem.Next = key    nextItem:ContinueOnItemLoad(function() LoadItem(nextItem) end) end LoadItem() local addonName, addon = ...   -- function to show the item tooltip when a hyperlink is clicked local function OnHyperlinkClick(self, link, text, region, left, bottom, width, heigh) -- Show the hyperling tooltip when clicked     SetItemRef(link, text, nil, self); end   local CELL_WIDTH = 400 local CELL_HEIGHT = 80 local NUM_CELLS = 2   local data = {}   local f = CreateFrame("Frame", "SimpleScrollFrameTableDemo", UIParent, "BasicFrameTemplateWithInset")   -- Create the button here local btn = CreateFrame("Button", nil, UIParent, "UIPanelButtonTemplate")   local locale = GetLocale() -- get the current locale eg. "frFR" local function updateData()     wipe(data)     for _, item in ipairs(addon.db) do         local announceText = item.announce[locale].text or item.announce.enUS.text -- default to enUS if the locale text doesn't exist.         tinsert(data, {announceText, item.icon, item.name[locale] or item.name.enUS})     end end   f:SetSize(CELL_WIDTH * NUM_CELLS + 80, 600) f:SetPoint("CENTER") f:Hide() f:SetMovable(true) f:SetScript("OnMouseDown", f.StartMoving) f:SetScript("OnMouseUp", f.StopMovingOrSizing)   -- I added this OnHide script f:SetScript("OnHide", function()     btn:Show() end)   f.scrollFrame = CreateFrame("ScrollFrame", nil, f, "UIPanelScrollFrameTemplate") f.scrollFrame:SetPoint("TOPLEFT", 12, -32) f.scrollFrame:SetPoint("BOTTOMRIGHT", -34, 8)   f.scrollFrame.scrollChild = CreateFrame("Frame", nil, f.scrollFrame) f.scrollFrame.scrollChild:SetSize(100, 100) f.scrollFrame.scrollChild:SetPoint("TOPLEFT", 5, -5) f.scrollFrame:SetScrollChild(f.scrollFrame.scrollChild)   local content = f.scrollFrame.scrollChild content.rows = {}   local function updateList()     for i = 1, #data do         if not content.rows[i] then             local button = CreateFrame("Button", nil, content)             button:SetSize(CELL_WIDTH * NUM_CELLS, CELL_HEIGHT)             button:SetPoint("TOPLEFT", 0, -(i - 1) * CELL_HEIGHT)             button.columns = {}   --------------------------------------------------------------------------------------------------- -- code to make item links work             button:SetHyperlinksEnabled(true) -- Setup hyperlinking for each row             button:SetScript("OnHyperlinkClick", OnHyperlinkClick) -- What to do when a link is clicked ---------------------------------------------------------------------------------------------------               button.columns[1] = button:CreateFontString(nil, "ARTWORK", "GameFontHighlight")             button.columns[1]:SetPoint("TOPLEFT", (0) * CELL_WIDTH, 0)             button.columns[1]:SetPoint("BOTTOMRIGHT", button, "BOTTOMLEFT", CELL_WIDTH, 0)               button.columns[2] = button:CreateTexture()             button.columns[2]:SetPoint("LEFT", 410, 0, (1) * CELL_WIDTH, 0)               button.columns[3] = button:CreateFontString(nil, "ARTWORK", "GameFontHighlight")             button.columns[3]:SetPoint("LEFT", 480, 0, (2) * CELL_WIDTH, 0)               content.rows[i] = button         end           content.rows[i].columns[1]:SetText(data[i][1])         content.rows[i].columns[2]:SetTexture(data[i][2])         content.rows[i].columns[3]:SetText(data[i][3])           content.rows[i]:Show()     end       for i = #data + 1, #content.rows do         content.rows[i]:Hide()     end end     -- Set your button options here local btn = CreateFrame("Button", "Hubb777MovingButton", UIParent, "UIPanelButtonTemplate") btn:SetPoint("CENTER") btn:SetSize(100, 40) btn:SetText("Rewards") btn:SetMovable(true) btn:RegisterForDrag('LeftButton') btn:RegisterForClicks("AnyDown", "AnyUp") btn:SetUserPlaced(true) btn:SetScript('OnDragStart', function(self, button, down)     if button == "LeftButton" and IsShiftKeyDown() then         self:StartMoving()     end end) btn:SetScript('OnDragStop', function(self)     self:StopMovingOrSizing() end) btn:SetScript("OnMouseUp", function(self, button, ...)     if (button == "RightButton" and self:IsVisible()) then         self:Hide()     elseif button == "LeftButton" and not IsShiftKeyDown() then         updateData()         updateList()         f:Show()     end end)   SLASH_HUBB1 = "/hubb" SlashCmdList["HUBB"] = function(msg)     if strupper(strtrim(msg)) == "BTN" then -- toggle the shown state of the button if the type /hubb btn         btn:SetShown(not btn:IsShown()) -- show the button         return     end     updateData()     updateList()     f:Show() end

It also didn't work. The button is not pressed.

1x ZamTEST/table.lua:78: bad argument #1 to 'SetText' (Usage: self:SetText([text]))
[string "=[C]"]: in function `SetText'
[string "@ZamTEST/table.lua"]:78: in function <ZamTEST/table.lua:52>
[string "@ZamTEST/table.lua"]:113: in function <ZamTEST/table.lua:108>
 
Locals:
(*temporary) = FontString {
 0 = <userdata>
}
(*temporary) = <table> {
 itemOrder = <table> {
 }
 text = "Awarded for %s outstanding service %s to Dragonkind.
%s
Bring it to Theozhaklos the Curious at the Wellspring 
Overlook in the Emerald %s Dream to receive powerful 
equipment for your efforts"
}