vb.org Archive - v3arcade reduce scores to keep arcade competitive

Page 2 of 2

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)

- - v3arcade reduce scores to keep arcade competitive (https://vborg.vbsupport.ru/showthread.php?t=124879)

bairy

10-07-2006 02:09 PM

Quote:

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 :D

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*

bairy

10-07-2006 03:30 PM

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.

Blittz

10-07-2006 03:46 PM

Code:

Database error in vBulletin 3.6.1:



Invalid SQL:



        UPDATE arcade_games SET highscore = CEIL(highscore - ((highscore / 100) * 15)) WHERE gameid NOT IN ();



MySQL Error  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1

Error Number : 1064

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

bairy

10-07-2006 04:29 PM

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

Blittz

10-07-2006 04:31 PM

Ding! yup that fixed it, yay! Thanks again for a usefull script.

lazydesis

10-08-2006 10:18 PM

u named the file as arcadereducescores.php while the previous file was arcadescores.php

u might want to change the code for the cron or rename the file :)

bairy

10-09-2006 08:07 AM

Oops. Thanks! Renamed the upload.

WhyDoesItMatter

02-03-2007 11:39 AM

Could never get this to work properly.. seems to want to run 3 times instead of once for some weird season.

Deadly Assassin

04-06-2007 06:04 AM

Works like a charm, cheers m8 :up:

All times are GMT. The time now is 11:28 AM.

Page 2 of 2

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01106 seconds Memory Usage 1,730KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (9)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: