Arcade - Leader Board (v1.4)

This addon provides you with a Leader Board for v3arcade. Currently, it cannot be used for ibProArcade - if you adapt it, please share the code so that it can be added to the zip. You'll be credited for the work.

Dechevious has written a similar addon to this, but this code has been written from scratch and is far more optimized.. Currently, it is not fully phrased - but then again neither is v3arcade itself. Thanks to DRJ for his contributions toward v1.4. Enjoy!


Version History:
? [high]1.0[/high] - Original mod released.
? [high]1.1[/high] - Cached 2 previously uncached templates.
? [high]1.2[/high] - Query changed, orders count by DESC and userid by ASC.
? [high]1.3[/high] - *CRITICAL UPDATE* - Optimized query, improved performance.
? [high]1.4[/high] - arcade.php code block and arcade_kings_bit template changed.


Please click install if you find this useful..

[Oblivion Knight]

That's good to hear.!

M1th, if you want the updated layout (check the new screenshot) - update the 2 added templates.

[TTG]

Thanks for the hack ..
Clicked install

[M1th]

Originally Posted by Oblivion Knight

That's good to hear.!

M1th, if you want the updated layout (check the new screenshot) - update the 2 added templates.

<img src="$stylevar[imgdir_arcade]/king$row.gif" alt="" />

Good one, though I'd suggest changing the image src to the above... mostly for those who remote host images.

[SVTOA]

Well.. after doing the latest version, now I have 4 uncached templates. Will have to manually edit I guess...

[SVTOA]

Originally Posted by Oblivion Knight

I can't imagine the query being overly intensive, but then again I'm no expert..

My board only has 300 members, and the microstats didn't show anything out of the ordinary.
Page generated in 0.09496593 seconds (42.80% PHP - 57.20% MySQL) with 7 queries

After manually editing the latest update, I get no uncached templates and
Page generated in 0.08542895 seconds (91.42% PHP - 8.58% MySQL) with 7 queries.

How come your ratio of php-to-MYSQL is so much different? Isn't 57% MYSQL kind of high???

[Oblivion Knight]

Whoops.! As mentioned earlier in this thread, my arcade.php file is significantly different to the default. All of my templates are cached at the beginning of the file and I added a block of code to the arcade.php file to cater for the default arcade.php file, I just forgot to re-add it in the new version of the zip.. :ermm:

The zip has now been updated.

Originally Posted by SVTOA

After manually editing the latest update, I get no uncached templates and
Page generated in 0.08542895 seconds (91.42% PHP - 8.58% MySQL) with 7 queries.

How come your ratio of php-to-MYSQL is so much different? Isn't 57% MYSQL kind of high???

Those statistics were from 1.2.. - It's now running at:
Page generated in 0.04567409 seconds (88.21% PHP - 11.79% MySQL) with 7 queries

[Vevina]

Sweet installed .... Really easy for a blonde too

[djjeffa]

Originally Posted by M1th

Big boards... stay away from this hack, it kills your server.

question how do you tell what hacks kill your boards and whick dont?




PS great hack installed I have 13,000 members is that big lol

[M1th]

Originally Posted by djjeffa

question how do you tell what hacks kill your boards and whick dont?




PS great hack installed I have 13,000 members is that big lol

You needn't worry about this hack anymore. The query has been greatly improved and it'll run good on any board.


As for your question, you can install the microstats hack to check the query stats on every page.

[djjeffa]

Originally Posted by M1th

You needn't worry about this hack anymore. The query has been greatly improved and it'll run good on any board.


As for your question, you can install the microstats hack to check the query stats on every page.

thanks fo rthe info

now to try to solve this other problem but i dont think its from this hack, the leaded list is not right but nor is the post bit here is what i have:
here it says im the champ http://www.djjeffa.com/vb//arcade.ph...=spaceinvaders
but in my profile it says im not http://www.djjeffa.com/vb/arcade.php?do=stats&userid=3
now the thing is I did get the high score in a chalange so do you guys have any ideal why its not showing up?

the screen shoots are here https://vborg.vbsupport.ru/showpost....postcount=3149