vb.org Archive - Add-On Releases - v3 Arcade - Professional vBulletin Gaming (vB4)

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

- vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)

- - Add-On Releases - v3 Arcade - Professional vBulletin Gaming (vB4) (https://vborg.vbsupport.ru/showthread.php?t=253211)

Quote:

Originally Posted by FF|Skyrider (Post 2264024)

By the way. Is there any "new post/thread" function on beating highscores?

I believe it is being worked on - http://www.v3arcade.com/forums/showthread.php?t=3854

So far, everything works as a charm. Though I do have to admit that I dislike the fact that if you add a mochi game and you lost/won and the highscore isn't above the one you already had and you wish to re-play the game, the ads has to be shown again. Which is quite annoying if the game is a fast game. You keep have to see the ads if you wish to reload the game.

I also think that the tournament needs to be a bit improved. Sharing that you can play the tournament when all slots has been filled and that you have to play xx rounds in order to complete your round to advance. Some people just play 1 game / round out of multiple.

Quote:

Originally Posted by FF|Skyrider (Post 2264379)

Yeah that is the one downside of Mochi Games but a lot of sites require legal games and this was the best way to go, of course you can still run IPB type games

Quote:

Originally Posted by FF|Skyrider (Post 2264432)

I'm not really a fan of the tournament system, partly for the reason you state and also most people sign up then forget or you get x amount signed up but still need slots to fill so sometimes the tournament never sees the light of day. I tend just to play one-off challenges - which I think is a much better system

Guess I'll disable tournaments then :). Though, if I may ask. Could you add to the private messages when your highscore has been beaten that links the user directly to the game?

Hi,

i have a problem with one particular game where it doesn't show the highscores in the "arcade.php?do=scores&gameid=" part. I checked in the database, everything is saved correctly. And the game does know which score is the highest and which user is ranked one.

But in arcade.php line 2648 onwords the $score query fails. I threw in some var_dumps and echos to compare it with other games, where it does work and found only one difference:
in this query:

Code:

                        $scores = $db->query_read("

                                SELECT arcade_sessions.*, user.username

                                FROM " . TABLE_PREFIX . "v3arcade_sessions AS arcade_sessions

                                LEFT JOIN " . TABLE_PREFIX . "user AS user ON (user.userid = arcade_sessions.userid)

                                WHERE arcade_sessions.valid = 1

                                        AND arcade_sessions.gameid = $game[gameid]

                                        " . iif(!empty($scorecache), 'AND (' . implode(' OR ', $scorecache) . ')') . "

                                GROUP BY userid

                                ORDER BY score $scoreorder, arcade_sessions.finish DESC

                                LIMIT " . $vbulletin->options['scoresperpage']

                        );

(which results in beeing empty, for that game, not for the others)
it creates a line as following:

Code:

AND ((arcade_sessions.score = '1618.080' AND

now this game is the only game we have so far where the last 3 scoredigits are not 000.

I confirmed it by manually changeing the score via phpmyadmin to '1618.000' and now that score does show up in the highscore list.

Any idea how i can fix that issue, so that this game has a highscorelist?

Can you send me a copy of the game or a link to where I can download it so I can do a quick test?

Small issue report:

I've set the games so you can only get 1 score. However, within the profiles (Arcade Statistics) under "Latest Scores (30)" It still shows all the scores you gained in a single game.

@Gemma
linked you to a download via pm

And found the cause i think
http://dev.mysql.com/doc/refman/5.0/...ith-float.html

Quote:

The result is correct. Although the first five records look like they should not satisfy the comparison (the values of a and b do not appear to be different), they may do so because the difference between the numbers shows up around the tenth decimal or so, depending on factors such as computer architecture or the compiler version or optimization level. For example, different CPUs may evaluate floating-point numbers differently.

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (4)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)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:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01907 seconds Memory Usage 1,747KB 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 (2)bbcode_code_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (4)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)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: