local achievs = {
    [1] = {name = "Noob Adventure", qt = 20, pt = 1},
    [2] = {name = "Amateur Adventurer", qt = 50, pt = 1},
    [3] = {name = "Good Adventurer", qt = 100, pt = 1},
    [4] = {name = "Great Adventurer", qt = 150, pt = 1},
    [5] = {name = "Expert Adventurer", qt = 200, pt = 1},
    [6] = {name = "Ultimate Adventurer", qt = 250, pt = 1},
    [7] = {name = "The Greatest Adventurer", qt = 300, pt = 2},
    [8] = {name = "Game Addicted", qt = 50000, pt = 3},
    [9] = {name = "Are You A Trickster?", qt = 99999, pt = 3},
    [10] = {name = "Deforester", qt = 50, pt = 2},
    [11] = {name = "Dream Team", qt = 6, pt = 5},
    [12] = {name = "Want a coconut?", qt = 100, pt = 1},
    [13] = {name = "To infinity... and beyond!", qt = 1, pt = 1},
    [14] = {name = "In the depths of the whirlpool.", qt = 1, pt = 2},
    [15] = {name = "Cheating the Death", qt = 1, pt = 2},
    [16] = {name = "Fly or Surf, this's the question!", qt = 1, pt = 2},
    [17] = {name = "I love you trainer!", qt = 1, pt = 2},
    [18] = {name = "Happy Harves", qt = 100, pt = 4},
    [19] = {name = "Poke Master", qt = 100, pt = 2},
    [20] = {name = "The Elite Four", qt = 100, pt = 2},
    [21] = {name = "Helping Hands", qt = 1, pt = 2},
    [22] = {name = "The First One", qt = 1, pt = 2},
    [23] = {name = "Who's that Pokemon?", qt = 1, pt = 2},
    [24] = {name = "First Step", qt = 1, pt = 2},
    [25] = {name = "Keep calm and..play PokeBrO!", qt = 1, pt = 1},
    [26] = {name = "You belong in a museum!", qt = 1, pt = 4},
    [27] = {name = "A Nightmare on Elm Stree", qt = 1, pt = 1},
    [28] = {name = "Better you eat this...", qt = 1, pt = 2},
    [29] = {name = "Miau,that's right!", qt = 1, pt = 3},
    [30] = {name = "Brain Freeze", qt = 100, pt = 2},
    [31] = {name = "Maybe Next Time", qt = 1000, pt = 2},
    [32] = {name = "Rock Smasher", qt = 250, pt = 2},
    [33] = {name = "Gardener", qt = 250, pt = 2},
    [34] = {name = "Growing stronger", qt = 1, pt = 2},
    [35] = {name = "Don't give up!", qt = 1, pt = 2},
    [36] = {name = "Broadcaster", qt = 1, pt = 2},
    [37] = {name = "Spectator", qt = 1, pt = 2},
    [38] = {name = "Ouch, my head!", qt = 1, pt = 2},
    [39] = {name = "Cowboy", qt = 1, pt = 2},
    [40] = {name = "Legitimate Pokemon Trainer", qt = 1, pt = 2},
    [41] = {name = "Elite Pokemon Trainer", qt = 1, pt = 3},
    [42] = {name = "Master Pokemon Trainer", qt = 1, pt = 4},
    [43] = {name = "Legendary Pokemon Trainer", qt = 1, pt = 5},
    [44] = {name = "Almost a radar!", qt = 1, pt = 1},
    [45] = {name = "Home sweet home", qt = 1, pt = 1},
    [46] = {name = "Day Guard", qt = 1, pt = 1},
    [47] = {name = "Night Guard", qt = 1, pt = 1},
    [48] = {name = "No bugs here!", qt = 1, pt = 1},
    [49] = {name = "Electrified", qt = 1, pt = 1},
    [50] = {name = "Is that a dragon ?", qt = 1, pt = 1},
    [51] = {name = "It's time to rest!", qt = 1, pt = 1},
    [52] = {name = "It's all in the cards", qt = 1, pt = 1},
    [53] = {name = "Can u read my Poker face?", qt = 1, pt = 1},
    [55] = {name = "It's not your lucky day", qt = 1, pt = 1},
    [56] = {name = "Social life? WTH is that ?", qt = 1, pt = 5},
    [57] = {name = "U mad bro?", qt = 1, pt = 1},
    [58] = {name = "Me obrigue!", qt = 1, pt = 1},
    }


function getPlayerAchievById(cid, achievid)
    local pid = getPlayerGUID(cid)
    local t = db.getResult("SELECT `value` FROM `achievements` WHERE `player_id` ="..pid.." AND `achievement_id` ="..achievid.."")
    local value = t:getDataString('value')
    if not value then
        db.executeQuery("INSERT INTO `achievements` (`player_id`, `achievement_id`, `value`) VALUES ('"..pid.."', '"..achievid.."', '1');")
        t:free()
        return 1
    else
        t:free()
        return value
    end
end

function doPlayerAddAchiev(cid, achievid)
    local pid = getPlayerGUID(cid)
    local value = tonumber(getPlayerAchievById(cid, achievid))
    if value == -1 then return 'done' end
    db.executeQuery("UPDATE `achievements` SET `value` = "..(value + 1) .." WHERE `player_id`= " .. pid .. " AND `achievement_id`= " .. achievid .. ";")
    if (tonumber(getPlayerAchievById(cid, achievid)) >= achievs[achievid].qt) then
        doPlayerSendTextMessage(cid,22, "You earned the achiev '"..achievs[achievid].name.."'.")
        db.executeQuery("UPDATE `achievements` SET `value` = ".. -1 .." WHERE `player_id`= " .. pid .. " AND `achievement_id`= " .. achievid .. ";")
        setPlayerStorageValue(cid, 57423, getPlayerStorageValue(cid, 57432) + achievs[achievid].pt)
    end
    doPlayerSave(cid)
    return true
end