getGuildCreationDate(guildname)

[Scooty]

hi, i need this function:

getGuildCreationDate(guildname)

can someone write it?

thank you

 

[TGYoshi]

function getGuildCreationDate(n) -- public int
local r = db.getResult("SELECT creationdata FROM guilds WHERE `name` = '"..db.escapeString(n).."';")
local d;
if(r:getID() ~= -1) then
d = getDataInt("creationdata")
result:free()
end
return d or -1
end