Pet Change Name System

[MrLibya 538]

Hallo

 

I Am Try To Make Pet Change Name System .

 

Function:

function pet_name_read()
    local mysql_read = mysql_query("SELECT pet_name FROM player.player where id = ('".. pc.get_player_id() .."')")
    return mysql_read.pet_name[1]
end
 

 

MySql Function:

mysql_query = function(query)
    if not pre then
        local rt = io.open('CONFIG', 'r'):read('*all')
        pre = string.gsub(rt, '.+PLAYER_SQL:%s(%S+)%s(%S+)%s(%S+)%s(%S+).+', '-h%1 -u%2 -p%3 -D%4')
    end

    math.randomseed(os.time())

    local fi, t, out = 'mysql_data_'..math.random(10^9)+math.random(2^4,2^10),{},{}
    os.execute('mysql '..pre..' --e='..string.format('%q', query)..' > '..fi)

    for av in io.open(fi, 'r'):lines() do table.insert(t,split(av, 't')) end; os.remove(fi);
    for i = 2, table.getn(t) do table.foreach(t[i],function(a, 
        out[i-1]               = out[i-1] or {}
        out[i-1][a]            = tonumber( or b
        out[t[1][a]]           = out[t[1][a]] or {}
        out[t[1][a]][i-1]      = tonumber( or b
    end) end
    return out
end

function split(str, delim, maxNb)
    if str == nil then
        return str
    end

    if string.find(str, delim) == nil then
        return { str }
    end

    if maxNb == nil or maxNb < 1 then maxNb = 0 end

    local result = {}
    local pat = "(.-)" .. delim .. "()"
    local nb = 0
    local lastPos

    for part, pos in string.gfind(str, pat) do
        nb = nb + 1
        result[nb] = part
        lastPos = pos
        if nb == maxNb then break end
    end

    if nb ~= maxNb then result[nb + 1] = string.sub(str, lastPos)
    end
    return result
end

 

Quest

[53001]     = { 34001, pet_name_read() ,0},

 

https://metin2.download/picture/uaNgYxX5c3aG1YNMm7Ibnvg8nq5m7bwS/.png

 

 

Edited August 30, 2022 by Metin2 Dev
Core X - External 2 Internal

[ahlamm 1]

thank you for the system and good luck in making other systems

[MrLibya 538]

Plz Close . I Used The Mysql Driet in quest And WOrk

 

I Will Relase The system soon