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.. :)

It only took me around 3 minutes to add and it seems to work fine. Thanks!

I'm installing now, but I have had a hard time finding any of the hacks done by Dechevious or anyone else over at www.v3arcade.com :( I really need the a-z navigation hack, as well as the scrolling news hack. If you have any ideas were to find them let me know!

http://www.v3arcadegames.com/forums/...splay.php?f=13

I believe the addons are free to all.. :)

Wow, that was quick! I didn't know they had a different site up now...or maybe I was just going to the wrong place ;) THX!!!

It's an unofficial v3arcade "fansite". There's a membership fee if you wish to download the games there..

Like I say, I'm fairly sure Dechevious said that the addons are free to all though.

Nice work Andy. Quick and easy.

thanks, will do the switch ;)

installed thank you that worked well :D

Nice addon :)

Uncached templates: ARCADE (1)
Uncached templates: arcade_header (1)

Change:

$globaltemplates = array(
'arcade_kings',
'arcade_kings_bit'
);

To:

$globaltemplates = array(
'ARCADE',
'arcade_header',
'arcade_kings',
'arcade_kings_bit'
);

Whoops, sorry about that.. :o

I've modified my arcade.php file significantly, and all templates are called at the beginning of my file - so I added that bit of code purely for this release and never tested it. I'll update the zip shortly.


[high][EDIT][/high]
Zip updated.

Done that DR€@M W€@V€R , but what exactly does it do lol ?

Uncached templates add unnecessary queries to the addon. Instead of performing 7 queries, it runs 9. This has now been fixed in the zip.. :)

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

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

Total Time Spent Playing: 3m 2w 6d 19h 32m 43s
Total Plays: 33458

With around 200+ games.

It put too much pressure on my server, taking about 10 seconds for the results to show up.

can you show us what comes in your footer?

Page generated ....................

Err... dont have microstats installed and I've removed the hack. Sorry.

v1.3 has now been released, which should hopefully fix the issue with running this addon on large boards.. It was sent to M1th for him to test, but I never got a response - it has been tested on 2 other fairly active forums, both with positive results.

Sorry, was busy with things.

I have it installed as well and working great. :)

Good work, Andy!

That's good to hear.! :D

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

Thanks for the hack ..
Clicked install

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

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

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???

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.


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

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

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.

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

If it is only Space Invaders that does this, try removing the game and re-installing it.. It's a strange issue indeed, and I've never come across it before.

thanks for the latest update... the hacks is really promising and stable...

Thanks for the hack, very nice work.

Page generated in 0.13486290 seconds (91.03% PHP - 8.97% MySQL) with 9 queries

one quick question, Are you planning on coding this for non vB pages? I installed webtemplates (https://vborg.vbsupport.ru/showthread.php?t=76422), and can't seem to get it to work right.

http://www.nemesisforums.net/view.php?pg=arcade_leader

I don't plan on doing this personally, since I don't have webtemplates installed..

Anyone else is free to adapt it though - and hopefully they'll share the code. :)

I'll figure it out eventually. I usually just stublem apon things.

I was just wondering if you were possibly going to code it for a non vB page, then all i'd have to do is fill in theblanks. No worries though.. :)

Very Nice work on this. :)

GJ, i love it

I installed this mod... the templates are really good, it blends in really well with the whole arcade... good job :)

is there a way of clearing the Top Scorers on the leader board .. ive set all my games score settings back to Zero but need to clear Top Scorers too ????

its ok finaly worked it out d'oh!

sweet hack I installed it :-)