Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
v3arcade reduce scores to keep arcade competitive Details »
v3arcade reduce scores to keep arcade competitive
Mod Version: 1.02, by bairy (Member) bairy is offline
Developer Last Online: Aug 2014 I like it Show Printable Version Email this Page

This modification is in the archives.
vB Version: 3.5.5 Rating: (1 vote - 5.00 average) Installs: 31
Released: 25 Aug 2006 Last Update: 09 Oct 2006 Downloads: 136
Not Supported Additional Files  

After my arcade had been installed for while I found that all the high scores were practically unbeatable.
I wanted a way to make them beatable again.

I thought about the possibility of just removing the top 5 high scores, but that wouldn't be fair on the winners.
I thought about resetting all the scores but that wouldn't be fair on any of the players.
Then I came to a perfect compromise: Reduce the scores. All the ranks are kept in tact but the high scores are achievable again. As a bonus, it increases competitiveness when the previous top scorers get beaten.


It's all done by a single cron job.

Upload arcadescores.php to /includes/cron
Set a new scheduled task. This one runs on the first of each month:
Day of week: *
Day of month: 1
Hour: 0
Minute: 4
Log: up to you
Filename: ./includes/cron/arcadescores.php


By default the scores are reduced by 15%. If you want to change this percentage, change the 15 to whatever you like on lines 11, 15 and 19 of the script.

Important note: This script will reduce the scores by 15% each time you run it manually or on cron. That means if you install it and want to play around with it, you might want to make a backup of the arcade_games, arcade_sessions and arcade_news tables.


Version 1.01
- Updated to account for games that have reverse scoring
- Now includes table_prefix
- Made the change percentage easier to change

Version 1.02
- Fixed a tiny bug I created in 1.01: If you had no reverse-scoring games it errored.

Download Now

Only licensed members can download files, Click Here for more information.

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Similar Mod
Mod Developer Type Replies Last Post
Add-On Releases ibProArcade reduce scores to keep arcade competitive. stangger5 vBulletin 3.6 Add-ons 36 09 Jan 2011 17:26
Add-On Releases Reduce ibproArcade best scores of all time.. stangger5 vBulletin 3.6 Add-ons 12 13 Jul 2008 12:52
v3Arcade - Add Clear All Scores Button tcs Modification Graveyard 11 02 Jan 2006 08:30

Comments
  #2  
Old 27 Aug 2006, 02:47
MissKalunji's Avatar
MissKalunji MissKalunji is offline
 
Join Date: Aug 2003
Real name: Mj Bain
i dont get it !?!?
__________________
____________
BossLady
Reply With Quote
  #3  
Old 27 Aug 2006, 09:50
bairy bairy is offline
 
Join Date: Oct 2005
Real name: Chris
Once a month (or whenever the cron is run), all the scores that people have acheived are reduced by 15%
Reply With Quote
  #4  
Old 27 Aug 2006, 17:17
HuntrCkr HuntrCkr is offline
 
Join Date: Nov 2005
Excellent mod! I installed this on my arcade and it works flawless. Great work.
Reply With Quote
  #5  
Old 27 Aug 2006, 23:02
MissKalunji's Avatar
MissKalunji MissKalunji is offline
 
Join Date: Aug 2003
Real name: Mj Bain
Originally Posted by bairy
Once a month (or whenever the cron is run), all the scores that people have acheived are reduced by 15%

ohhh smart move!

Thanks
__________________
____________
BossLady
Reply With Quote
  #6  
Old 30 Aug 2006, 17:56
Snake's Avatar
Snake Snake is offline
 
Join Date: Mar 2005
Location: Cleveland, OH
Real name: Josh
Thanks for the hack! I'll install it right away...
Reply With Quote
  #7  
Old 07 Oct 2006, 00:04
Breaker's Avatar
Breaker Breaker is offline
 
Join Date: Jan 2002
great mod/idea... just one problem though. I haven't looked at the code yet, but it appears that all this does is lower the score which is great for all games but ones with reverse scoring which will, over time make it impossible to beat the scores
Reply With Quote
  #8  
Old 07 Oct 2006, 03:58
lazydesis lazydesis is offline
 
Join Date: Sep 2006
i get this error ...and have no clue why

Database error in vBulletin 3.6.1:

Invalid SQL:

UPDATE arcade_games SET highscore = CEIL(highscore - ((highscore / 100) * 15));

MySQL Error : Table 'lazyindi_comm.arcade_games' doesn't exist
__________________
http://www.lazydesis.com
Reply With Quote
  #9  
Old 07 Oct 2006, 05:53
lazydesis lazydesis is offline
 
Join Date: Sep 2006
juz realised in the arcadescores.php
instead of

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

u need to have

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

or watever they have there for the prefix
__________________
http://www.lazydesis.com
Reply With Quote
  #10  
Old 07 Oct 2006, 05:53
lazydesis lazydesis is offline
 
Join Date: Sep 2006
great hack thanx meanwhile
__________________
http://www.lazydesis.com
Reply With Quote
  #11  
Old 07 Oct 2006, 16:09
bairy bairy is offline
 
Join Date: Oct 2005
Real name: Chris
Originally Posted by Breaker
great mod/idea... just one problem though. I haven't looked at the code yet, but it appears that all this does is lower the score which is great for all games but ones with reverse scoring which will, over time make it impossible to beat the scores
Oops. You're right, it will.

I'll update it later today or tomorrow so that it lowers normal games and raises reversed games.
I'll also add the table prefix in *slaps wrist*
Reply With Quote
  #12  
Old 07 Oct 2006, 17:30
bairy bairy is offline
 
Join Date: Oct 2005
Real name: Chris
Version 1.01
- Updated to account for games that have reverse scoring.
- Now includes table_prefix
- Made the change percentage easier to change.

To upgrade, just replace the includes/cron/arcadereducescores.php with the new one.


Version 1.02 (released very shortly after 1.01)
- Fixed a tiny bug I created in 1.01: If you had no reverse-scoring games it errored.

Last edited by bairy; 07 Oct 2006 at 18:29.
Reply With Quote
  #13  
Old 07 Oct 2006, 17:46
Blittz Blittz is offline
 
Join Date: Feb 2005

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

I just downloaded and installed the script, it seems that $reversegames never got populated, and caused that error.

also... just a tiny suggestion.. put some comments in, at least containing the version number so people know if they have the latest, and perhaps a reminder of where to go to get any updates, etc... Also give yourself credit!

Last edited by Blittz; 07 Oct 2006 at 18:00.
Reply With Quote
  #14  
Old 07 Oct 2006, 18:29
bairy bairy is offline
 
Join Date: Oct 2005
Real name: Chris
You know when I uploaded it I just had this hunch something was gonna error. And yes, I forgot to test without any reversed games.

Sorted, tested and reuploaded.

With the comments, I've dropped in the version and thread number, good idea
Reply With Quote
  #15  
Old 07 Oct 2006, 18:31
Blittz Blittz is offline
 
Join Date: Feb 2005
Ding! yup that fixed it, yay! Thanks again for a usefull script.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 01:44.

Layout Options | Width: Wide Color: