MyACC How can i make my highscores update faster

[henkas]

Hello,
im using older myacc version and please dont say just update your myacc. Answer is i cant. But is it possible to make my highscores load faster because now it updates only if server saves so it can be only every one hour or more. Dream is to update it instantly or at least every few minutes. TFS 1.2
MyACC 0.7.9

<?php/** * Highscores * * @package MyAAC * @author Gesior <jerzys - Pastebin.com

Pastebin.com is the number one paste tool since 2002. Pastebin is a website where you can store text online for a set period of time.

pastebin.com

 

[lukatxd]

Wouldn't it be related more to your server than the website? Because the characters data isnt being sent all the time to the database. As far as I've seen while testing my small server, the characters are saved on logout/death and now as you mentioned, server save.

I'm not familiar with all the website structure, but the file you shared hold only the queries to the databases, meaning they actually run every time you refresh the page, it's just that the players data haven't been updated on the database.

 

[henkas]

Wouldn't it be related more to your server than the website? Because the characters data isnt being sent all the time to the database. As far as I've seen while testing my small server, the characters are saved on logout/death and now as you mentioned, server save.

I'm not familiar with all the website structure, but the file you shared hold only the queries to the databases, meaning they actually run every time you refresh the page, it's just that the players data haven't been updated on the database.

So how to update them on the database it could be every skill advance too it would solve everything if it wont cause any lags

 

[Loney]

Try

MyACC increase reload time and more

Hi, so myacc have annoying problem it takes ages to reload people skills, level from highscores or top player menu, overall its so slow but it reloads if you put like comment in 'news' but sometimes it takes hours if it does automatically. And second question how to increase 'last kills'...

otland.net

 

[henkas]

Try

MyACC increase reload time and more

Hi, so myacc have annoying problem it takes ages to reload people skills, level from highscores or top player menu, overall its so slow but it reloads if you put like comment in 'news' but sometimes it takes hours if it does automatically. And second question how to increase 'last kills'...

otland.net

This guy have same myacc version and you can see solution is not possible because of version its possible only in latest myacc

 

[lukatxd]

So how to update them on the database it could be every skill advance too it would solve everything if it wont cause any lags

This thread in another Tibia forum from brazil might give you some hints. There is a lua function that saves your character.

[Pedido] Save Character, !save

Oi Galera Blz? Estou Fazendo Um Ot, Esta Super Editado PDA = Pokemon Dash Advansed. Mas Antes De Por On Queria Um Script Que Possa Salvar O Char Sem Ter Que Logar. Por Que Nao Quero Ver Reclamaçoes !!! Quem Tiver o Script Poderia Me Mandar? REP+ Pra Quem Ajuda xD

tibiaking.com

You might want to take a loot at what the "doSavePlayer" function is calling in the source code and implement it when your characters level up/skill up.
Or you just use the script and tell your users to use the talk action to appear on the highscores.

 

[henkas]

This thread in another Tibia forum from brazil might give you some hints. There is a lua function that saves your character.

[Pedido] Save Character, !save

Oi Galera Blz? Estou Fazendo Um Ot, Esta Super Editado PDA = Pokemon Dash Advansed. Mas Antes De Por On Queria Um Script Que Possa Salvar O Char Sem Ter Que Logar. Por Que Nao Quero Ver Reclamaçoes !!! Quem Tiver o Script Poderia Me Mandar? REP+ Pra Quem Ajuda xD

tibiaking.com

You might want to take a loot at what the "doSavePlayer" function is calling in the source code and implement it when your characters level up/skill up.
Or you just use the script and tell your users to use the talk action to appear on the highscores.

Using talkactions is kinda 2004 years old stuff. About implementing doSavePlayer on skill advance/level up wouldnt it cause like a huge lag with bigger amount of player base?

 

[lukatxd]

Using talkactions is kinda 2004 years old stuff. About implementing doSavePlayer on skill advance/level up wouldnt it cause like a huge lag with bigger amount of player base?

I didnt tell you to use it. I told you to look how it is implemented and do your thing.
And I wouldnt worry about huge lag spikes because your players are constantly dying and/or logging off, plus, it's not like 300 players are going to level up at the exact same time isnt it?

 

[henkas]

I didnt tell you to use it. I told you to look how it is implemented and do your thing.
And I wouldnt worry about huge lag spikes because your players are constantly dying and/or logging off, plus, it's not like 300 players are going to level up at the exact same time isnt it?

Actually it is possibility if everyone levels up because of events and similar shit

 

[henkas]

Actually it is possibility if everyone levels up because of events and similar shit

Need experienced person to tell me how much it would effect performance

 

[henkas]

Need experienced person to tell me how much it would effect performance

bump

 

[Loney]

Wouldn’t recommend doSavePlayer


As you said, reloads will happen only in server saves, so u need make server save often or update ur aac (Ik u said you will not, but maybe it’s the solution)

 

[henkas]

Wouldn’t recommend doSavePlayer


As you said, reloads will happen only in server saves, so u need make server save often or update ur aac (Ik u said you will not, but maybe it’s the solution)

But is there a way to save player without using doSavePlayer?

 

[Loney]

My bad, I wouldn't recommend doSavePlayer via talkaction. You should add it to player advance or something like that. Found this:

local config = {
    savePlayersOnAdvance = true
}

function onAdvance(cid, skill, oldLevel, newLevel)
    if(config.savePlayersOnAdvance) then
        Player(cid):save()
    end
    return true
end