Thanks tinker!

Vanama wrote:
2JGB:

Always leaderboard not work for me
30s timeout

Have you tried removing the indexes we mentioned? I don't believe there are part of the core deployment and as such could degrade the performance.

Also - are you using any other 3rd party modules which are referring to the arcade's core tables?

I need not solution for this now. I was create a best solution (function for write and update places, points and first places when score is saved to new table jos_puarcade_leaders) for a leaderboard and this is really good and work great with other cool features.

Look at http://www.zabava-online.cz/online-hry-2.html

I was created a "played time" system too. When score is saved, write to DB played time from run game to save score and write to DB game time played.

It's cool! For example my users play 14d 11h 0m 0s in yesterday

For example look at http://www.zabava-online.cz/domu/strateg...stro-yum-burger.html

When You, Pragma or anybody wish, I will post my codes, but at own risk, I am not programmer.

Hi Vanama,

Check out the latest entry I wrote...

www.pragmaticutopia.com/component/option...iew/id,7852/catid,4/

Looks like we're thinking the same thing. Code is with Pragma, and so we should hopefully be able to get it in soon.



*EDIT*

Vanama - apologies - your solution is even better, I'll look to get something similiar into the SVN as well.

If you have your code ready, can you zip and email it to me? It would be good to get this type of stuff in.

Will You send full my modify PUArcade component (It's based on SVN 338, but with too much my modifies) or only some codes of my solution of leaderboard?

Hi Vanama,

If you send as much as you like - that would be great.

Thanks,
James.

Email with some informations was send.

James, receive You email from me?

There are obviously a number of different ways this can be done. One is for this processing to be done inside the core processing or another way is to extend the PUArcade system plugin to listen for new highscores events and process the leaderboard that way.

What I was thinking of was..

1. plugin is extended to include this functionality based on the highscore event

2. admin control panel has a button which can completely rebuild the leaderboard if necessary.

Not sure about the timing element yet, because there are potentials here to further enhance the security from false scores.

Also, as Pragma is the boss - I think I need to discuss this all with him first!!

I Am happy, Leaderboard work great for me, but script, which I wrote for rebuild all leaderboard items is slow and I have 30s time out.

I have updates some functions (fix function StartPlayingTime) and new feature. Show players usernames which playing current game based on time played feature.

Vanama wrote:
I Am happy, Leaderboard work great for me, but script, which I wrote for rebuild all leaderboard items is slow and I have 30s time out.

I have updates some functions (fix function StartPlayingTime) and new feature. Show players usernames which playing current game based on time played feature.

Is it a php execution timeout or a MySQL query timeout?

If it were a php execution timeout we could run the SQL query outside of PHP.

If it is a MySQL query timeout, we would need to break it up into multiple separate queries somehow.

its a mysql query time out. (hence breaking it up as they save a highscore would work).

This script could be rewrite for smaller count of games, but I not needed this script, I have build leaderboard now.
I think option something as: Rebuild from game id: xx