Ir para conteúdo

kaiomagnu1993

Membro
  • Registro em

  • Última visita

Histórico de Curtidas

  1. Gostei
    kaiomagnu1993 deu reputação a tiagoduuarte em Quem vai fazer meu novo avatar?   
    Ainda? kkkkkkk
  2. Gostei
    kaiomagnu1993 deu reputação a tiagoduuarte em [PEDIDO] Adicionar Tempo No Comando !buyvip   
    Va em data / talkactions / scripts / e ponha o nome de algum arquivo para buyvipname e ponha isto tudo la dentro




    dps em talkactions.xml add isto la



    Creditos: Skyligh
  3. Gostei
    kaiomagnu1993 deu reputação a tiagoduuarte em [PEDIDO] Script Vip com 5% de xp   
    Double exp para o Perfect Vip System:

    Em Creaturescript/script Crie um arquivo.lua e renomeie para :

    vipexp.lua



    Em Creaturescript/script/login.lua adicione:


    em Creaturescript.xml adicione a tag:


    Creditos: ~Test~
  4. Gostei
    kaiomagnu1993 deu reputação a tiagoduuarte em Versão de OT mais jogada   
    Os servidores mais cheios usam a 8.60
  5. Gostei
    kaiomagnu1993 deu reputação a tiagoduuarte em [Pedido] deletar chars inativos   
    Global Event:
    <globalevent name="dbcleaner" type="startup" event="script" value="dbcleaner.lua"/>

    dbcleaner.lua:

    ------------------------------------------------------------------------------*
    ----- [[> Automated Database Cleanup 1.1 Structure //By Cybermaster <]] ------|
    -------------- [[> System 2.0 Revamped by Teh Maverick <3 <]] ----------------|
    ------------- [[> Removal of empty accounts by darkaos <]] ---------------|
    --------------- [[> Function getDBPlayersCount() by Elf <]] ------------------|
    ------------------------------------------------------------------------------|
    ------------------------------------------------------------------------------|
    --- ~!READ THIS!~ ------------------------------------------------------------|
    --- Be sure to back up your database and test this on your server first, -----|
    --- I(Teh Maverick) cannot guarantee it will work the same for every core. ---|
    --- It is very easy to test, with the log file and values that are printed ---|
    -----------------------------------Enjoy!-------------------------------------|
    ------------------------------------------------------------------------------*

    function countRowsWhereInTable(table, field, condition)
    local result = db.getResult("SELECT COUNT(" .. field .. ") as count FROM " .. table .. " WHERE " .. field .. " = '" .. condition .. "';")
    local tmp = result:getDataInt("count")
    result:free()
    return tmp
    end

    function getDBPlayersCount()
    local result = db.getResult("SELECT COUNT(id) as count FROM `players`;")
    local tmp = result:getDataInt("count")
    result:free()
    return tmp
    end

    function getDBAccountsCount()
    local result = db.getResult("SELECT COUNT(id) as count FROM `accounts`;")
    local tmp = result:getDataInt("count")
    result:free()
    return tmp
    end

    function onstartup()
    local DB_BEFORE = {players = getDBPlayersCount(), accounts = getDBAccountsCount()}
    local result,result1, ii, numPlayersToDelete, numAccountsDeleted, tmp = 0, 0, 0, 0, 0
    local pid, aid = {}, {}
    local dropCount = {players={},accounts={}}

    local config = {
    deleteAccountWithNoPlayers = true,
    cleanChildTables = true,
    printResult = true,
    saveResultToFile = true,
    logFileName = 'db_cleanup.txt'
    }

    --In each table, players with below specified level, and days of inactivity will be deleted from db on server startup
    local cleanup = {
    [1] = {level = 11, time = 5 * 24 * 60 * 60},
    [2] = {level = 20, time = 15 * 24 * 60 * 60},
    [3] = {level = 50, time = 30 * 24 * 60 * 60},
    [4] = {level = 100, time = 60 * 24 * 60 * 60},
    [5] = {level = 130, time = 90 * 24 * 60 * 60}
    }

    local childAttributeTables = {
    players = {
    [1] = {table = "`player_viplist`", idField = "`player_id`"},
    [2] = {table = "`player_storage`", idField = "`player_id`"},
    [3] = {table = "`player_spells`", idField = "`player_id`"},
    [4] = {table = "`player_skills`", idField = "`player_id`"},
    [5] = {table = "`player_namelocks`", idField = "`player_id`"},
    [6] = {table = "`player_items`", idField = "`player_id`"},
    [7] = {table = "`player_depotitems`", idField = "`player_id`"},
    [8] = {table = "`houses`", idField = "`owner`"},
    [9] = {table = "`house_auctions`", idField = "`player_id`"},
    [10] = {table = "`players`", idField = "`id`"} -- Keep this as the last item in the array
    --Note: `houses` and `bans` are in the DB triggers for TFS so don't worry about them.
    --Also I did not want to put killers, or deaths on here because that is historic data,
    --do so at your own risk.
    },
    accounts = {
    [1] = {table = "`accounts`", idField = "`id`"},
    [2] = {table = "`account_viplist`", idField = "`account_id`"}
    }
    }

    --Clean up all the players and player data
    for i = 1, #cleanup do
    result = db.getResult("SELECT `id`,`name`,`account_id` FROM `players` WHERE `level` < ".. cleanup.level .." AND `name` NOT IN('Account Manager', 'Sorcerer Sample', 'Druid Sample', 'Paladin Sample', 'Knight Sample', 'Rook Sample') AND `group_id` < 2 AND `lastlogin` < UNIX_TIMESTAMP() - ".. cleanup.time ..";")
    if(result:getID() ~= -1) then
    ii = 1
    repeat
    pid[ii] = result:getDataInt("id") -- list the players id into an array
    aid[ii] = result:getDataInt("account_id") -- list the account id of each player being removed into an array
    ii = ii + 1
    until not(result:next())
    result:free()
    end
    numPlayersToDelete = ii - 1

    --Drop players and their child table attribute data such as skills, items, etc.
    for j = 1, numPlayersToDelete do

    if(config.cleanChildTables) then
    for k = 1, #childAttributeTables.players do
    if childAttributeTables.players[k].table == "houses" then
    house = getHouseByPlayerGUID(pid[j])
    if house ~= 0 or house ~= nil then
    doCleanHouse(house)
    doUpdateHouseAuctions()
    end
    else
    dropCount.players[k] = ((dropCount.players[k] or 0) + countRowsWhereInTable(childAttributeTables.players[k].table, childAttributeTables.players[k].idField, pid[j]))
    db.executeQuery("DELETE FROM " .. childAttributeTables.players[k].table .. " WHERE " .. childAttributeTables.players[k].idField .. " = '" .. pid[j] .. "';")
    end
    end
    else
    db.executeQuery("DELETE FROM `players` WHERE `id` = '" .. pid[j] .. "';")
    end
    end
    end

    --Drop all the accounts that have 0 players linked to them (at the moment its only checking from the list of players removed)
    if config.deleteAccountWithNoPlayers then
    --This part was scripted by Darkhaos, modified/fixed by Teh Maverick --[[
    for acc = 1, #aid do
    result1 = db.getResult("SELECT `id` FROM `accounts` WHERE `id` = '" .. aid[acc] .. "';")
    if result1:getID() ~= -1 then -- check to make sure the account exists
    result1:free()
    for i = 1, #childAttributeTables.accounts do
    --Make sure there are no other players on the account
    result1 = db.getResult("SELECT COUNT(id) as count FROM `players` WHERE `account_id` = '" .. aid[acc] .. "';")
    tmp = result1:getDataInt("count")
    if(tmp <= 0) then
    --Remove accounts
    dropCount.accounts = ((dropCount.accounts or 0) + countRowsWhereInTable(childAttributeTables.accounts.table, childAttributeTables.accounts.idField, aid[acc]))
    db.executeQuery("DELETE FROM " .. childAttributeTables.accounts.table .. " WHERE " .. childAttributeTables.accounts.idField .. " = '" .. aid[acc] .. "';")
    end
    end
    end
    end
    end
    --]]

    --Print and Save results (configurable)
    local DB_NOW = {players = DB_BEFORE.players - getDBPlayersCount(), accounts = DB_BEFORE.accounts - getDBAccountsCount()}
    if DB_NOW.players > 0 or DB_NOW.accounts > 0 then
    local text = ">> [DBCLEANUP] " .. DB_NOW.players .. " inactive players" .. (config.deleteAccountWithNoPlayers and " and " .. DB_NOW.accounts .. " empty accounts" or "") .. " have been deleted from the database."

    --Write to console
    if config.printResult then
    print("")
    print(text)
    if config.cleanChildTables then
    --Write player info
    for i = 1,#dropCount.players do
    print("[!] --> Dropped: " .. dropCount.players .. " from " .. childAttributeTables.players.table .. " table")
    end
    --Write account info
    if config.deleteAccountWithNoPlayers then
    for i = 1,#dropCount.accounts do
    print("[!] --> Dropped: " .. dropCount.accounts .. " from " .. childAttributeTables.accounts.table .. " table")
    end
    end
    print("")
    end
    end

    --Write to file
    if config.saveResultToFile then

    local file = io.open("data/logs/"..config.logFileName, "a")
    file:write("[" .. os.date("%d %B %Y %X ", os.time()) .. "] " .. text .. "\n")

    if config.cleanChildTables then
    --Write player info
    for i = 1, #dropCount.players do
    file:write("[!] --> Dropped: " .. dropCount.players .. " from " .. childAttributeTables.players.table .. " table\n")
    end
    --Write account info
    if config.deleteAccountWithNoPlayers then
    for i = 1, #dropCount.accounts do
    file:write("[!] --> Dropped: " .. dropCount.accounts .. " from " .. childAttributeTables.accounts.table .. " table\n")
    end
    end
    file:write("\n")
    end
    file:close()
    end
    end
    return true
    end


    espero ter ajudado.

    Creditos:
    Dudu Ruller

  6. Gostei
    kaiomagnu1993 deu reputação a tiagoduuarte em Npc Não Vende Rod   
    Tenta esse aqui:
    NPC:


    Script:

  7. Gostei
    kaiomagnu1993 deu reputação a tiagoduuarte em Bot para TibiaMe   
    TibiaME MC:
    http://tibiameajuda.blogspot.com.br/2012/07/tibiame-sandboxie.html

    Tirar LAG:
    http://tibiameajuda.blogspot.com.br/2012/07/tirar-lag-tibiame.html

    Bom o bot acessa lá o tibiameajuda que em breve eu postarei...
  8. Gostei
    kaiomagnu1993 deu reputação a tiagoduuarte em BUG Stamina   
    Estou com um problema com stamina ela está subindo de forma errada, estou usando tfs 0.4...
    Seguinte acabei de testar a exp e tal fui deslogar e testar a stamina então minha stamina

    estava assim: 27:40stamina ~~ 21:30hrs , fui logar novamente depois de umas duas horas mais

    ou menos: 27:42stamina ~~ 23:02hrs, o que era pra encher quase duas horas encheu dois

    minutos, alguem consegue me ajudar?




    27:40stamina ~~ 21:30hrs
    27:42stamina ~~ 23:02hrs
    ------------------------
    00:02stamina ~~ 01:72hrs


    CONFIG.LUA

    rateStaminaLoss = 1
    rateStaminaGain = 29
    rateStaminaThresholdGain = 48
    staminaRatingLimitTop = 10 * 60
    staminaRatingLimitBottom = 14 * 60
    staminaLootLimit = 14 * 60
    rateStaminaAboveNormal = 1.0
    rateStaminaUnderNormal = 0.5
    staminaThresholdOnlyPremium = true


    obs: se isso muda alguma coisa, tive que mudar meus globalevents que funcionavam assim:
    <globalevent name="animatedtext" interval="2" script="texto.lua"/>
    com interval de 2 ficava aparecendo o texto de dois em dois segundos, mas agora eu tenho que

    usar assim:
    <globalevent name="animatedtext" interval="2000" script="texto.lua"/>
    pra ficar de dois em dois segundos caso contrario fica exageradamente rapido.
  9. Gostei
    kaiomagnu1993 deu reputação a tiagoduuarte em [Pedido] Mapa global tps   
    Então pessoal eu procurei muito, mas não achei esse server, só achei outro global com tps(compatco) queria esse com esse templo:
    http://loja.chaitosoft.com/media/catalog/product/cache/1/image/9df78eab33525d08d6e5fb8d27136e95/g/l/globaltps.png

    e as hunts são em um barco, tem d lair venore, alguem tem ele ou sabe onde tem?

    +rep ai pra qm conseguir.

Informação Importante

Confirmação de Termo