vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   v3 Arcade - Games Arcade & Challenge System [vB 3.0.3] (https://vborg.vbsupport.ru/showthread.php?t=60377)

Smoker 03-29-2004 05:58 AM

Sorry, my english is very bad :(

I would like gladly that those Games Alphabetically are sorted.
As that can be done ?

Thanks
Smoker

ChuanSE 03-29-2004 06:11 AM

Smoker, read the previous posts and you will find the answer mate ;)

ChuanSE 03-29-2004 06:14 AM

Quote:

Originally Posted by CricketWeb
Any chance of some help with my problem in page 122?

page 122, we only have 37 pages (yet) in this thread :|

CricketWeb 03-29-2004 06:16 AM

Quote:

Originally Posted by ChuanSE
page 122, we only have 37 pages (yet) in this thread :|

I'm referring to my posts here - https://vborg.vbsupport.ru/showthrea...page=122&pp=15

Thanks for replying :)

ChuanSE 03-29-2004 06:28 AM

Quote:

Originally Posted by CricketWeb
I've managed to get rid of that message but now i get:



and yes I've run the install.php script.

Best thing you can do is completly start over with original files
you must have made a little typo or something :/

CricketWeb 03-29-2004 06:33 AM

Quote:

Originally Posted by ChuanSE
Best thing you can do is completly start over with original files
you must have made a little typo or something :/

It seems to have killed my test board, even with re-uploading the original files I get the same error :ermm: . Thank goodness it was just my test forum :disappointed:

ChuanSE 03-29-2004 06:56 AM

well, then i'm sure you made a typo or something
i installed it, and it works flawless...

Lemme know if you re-try don't work out ;)

CricketWeb 03-29-2004 07:01 AM

Quote:

Originally Posted by ChuanSE
well, then i'm sure you made a typo or something
i installed it, and it works flawless...

Lemme know if you re-try don't work out ;)

Cheers mate, you wouldn't happen to have MSN would you so I could ask you a few questions in the process? Mine is nixonja@hotmail.com

endless 03-29-2004 08:10 AM

I have installed the arcade and the extra's included with the zip, and am now getting an error:


Code:

Database error in vBulletin 3.0.0:

Invalid SQL:
                SELECT COUNT(*) AS plays, SUM(finish-start) as time
                FROM gamesessions
                WHERE valid=1
       
mysql error: Table 'greatfre_vbgames.gamesessions' doesn't exist

mysql error number: 1146

Date: Monday 29th of March 2004 04:31:40 AM
Script: http://www.greatfreegames.com/arcade.php?
Referer:
Username: geesh

Any idea on how I go about fixing this?

Boofo 03-29-2004 08:24 AM

Looks like you missed running a query during the installation of this hack to make that table. ;)

endless 03-29-2004 08:30 AM

yes i have been reading, and reading, and then i read some more, and have done some work to get the arcade working.

thanks!

Erwin 03-29-2004 09:48 AM

So many new games!!! :D

John 03-29-2004 10:10 AM

Just a little explanation on the game listings...

If you sort alphabetically, games which don't have any scores recorded will still appear at the bottom. A minor design flaw, lol - as games which have never been played are the most out of sight, and are the least likely to be played.

The solution? Make sure each of the games has at least one score recorded. :)

Smoker 03-29-2004 10:53 AM

Quote:

Originally Posted by ChuanSE
Smoker, read the previous posts and you will find the answer mate ;)

I do not find it unfortunately :(

bye
Smoker

chris frolic 03-29-2004 08:18 PM

How long do people generally let the high scores stay up?

obiwan8472 03-29-2004 08:47 PM

ok, im the only one who keeps getting a corrupted version of the zip file? Everytime i download it, it sez invalid archive. i tried it on my other computer aswell and it failed :(

MajorGeek 03-29-2004 09:59 PM

Asked the same question here:
https://vborg.vbsupport.ru/showthrea...507#post492507

No response yet, but even the latest Duck Hunt is corrupt, im wondering if its a board setting, or the server space is maxxed out. It just started today, was not a problem yesterday.


Quote:

Originally Posted by obiwan8472
ok, im the only one who keeps getting a corrupted version of the zip file? Everytime i download it, it sez invalid archive. i tried it on my other computer aswell and it failed :(


GovGaming 03-29-2004 10:04 PM

Any reason I'm not getting the awards listed in the postbit? I've edited all the templates like I should've. This is my second install of vB3 and the v3 arcade...neither time has worked.

corsacrazy 03-29-2004 10:39 PM

Quote:

Originally Posted by GovGaming
Any reason I'm not getting the awards listed in the postbit? I've edited all the templates like I should've. This is my second install of vB3 and the v3 arcade...neither time has worked.

edit options in admin cp set show awards in postbit to YES

BioVader 03-29-2004 11:12 PM

Quote:

Originally Posted by obiwan8472
ok, im the only one who keeps getting a corrupted version of the zip file? Everytime i download it, it sez invalid archive. i tried it on my other computer aswell and it failed :(

Same here.. I get a corrupted file too... Can someone post another like for the file....

Mr. HillBilly 03-29-2004 11:13 PM

These games:

? Altex - https://vborg.vbsupport.ru/show...5&postcount=403
? Enemy Shooting - https://vborg.vbsupport.ru/show...5&postcount=403
? Jail Break - https://vborg.vbsupport.ru/show...5&postcount=403
? Snow Paul - https://vborg.vbsupport.ru/show...5&postcount=403
? Space Hunter - https://vborg.vbsupport.ru/show...5&postcount=403
? Plasmanaut on Fire - https://vborg.vbsupport.ru/show...7&postcount=443
? Simpsons Shooter - https://vborg.vbsupport.ru/show...3&postcount=447
? Plasmanout V2 - https://vborg.vbsupport.ru/show...3&postcount=464

And some other ones have corrupt files... Please fix

ConqSoft 03-29-2004 11:15 PM

The files aren't corrupt. The download process is. They all download fine in Opera, but are corrupt if downloaded with IE.

MajorGeek 03-29-2004 11:37 PM

Good catch, Opera does work! Thanks!

Quote:

Originally Posted by ConqSoft
The files aren't corrupt. The download process is. They all download fine in Opera, but are corrupt if downloaded with IE.


Lissa 03-30-2004 01:35 AM

I had an idiot newbie register for my forum and hack all the games to get high scores with a program called artmoney.

Any way I can prevent this? I made it so that people couldn't play games on my forum unless they have 100 posts first, but I don't think that will stop anyone...

BarBeQue 03-30-2004 05:14 AM

Never heard of this program... I don't think naming it here was a good plan either, other peepz might get idea's :(

It's a memory change program... i doubt there is much or even anything that can be done against programs that adress the memory directly and change it's values :(

a43079 03-30-2004 06:00 AM

some games that have been posted need to be check cause i am getting corrupt files when extracting

kylek 03-30-2004 06:54 AM

As ConqSoft mentioned earlier, the game files are not corrupt, are you using IE to download? I had the same problem but they downloaded fine with Opera.

lasto 03-30-2004 03:44 PM

zip in first post wont download proper

Corrupt archive

I dont believe this is an IE problem cause if that was case then why has everyones copy suddenly corrupted when they where fine before ?

ConqSoft 03-30-2004 03:47 PM

Quote:

Originally Posted by lasto
zip in first post wont download proper

Corrupt archive

I dont believe this is an IE problem cause if that was case then why has everyones copy suddenly corrupted when they where fine before ?

It is a site prolem, related to IE. IE works fine on attachments on other vb3 sites. So, for now, use a different browser to download and you will be fine.

dstruct2k 03-30-2004 10:36 PM

I don't think the installer made my gamesessions table.
Code:

Database error in vBulletin 3.0.0:
 
Invalid SQL:
                SELECT COUNT(*) AS plays, SUM(finish-start) as time
                FROM gamesessions
                WHERE valid=1
 
mysql error: Table 'db87385808.gamesessions' doesn't exist
 
mysql error number: 1146

That doesn't look right though... "db87385808" is my database, not a table name...


[edit]Checked in phpmyadmin... the table is "vb3__gamesessions" so something's not working right.

[edit 2]Found the bug in arcade.php.... Most of you aren't using table prefixes, otherwise you'd have this bug too.
FIX:
Find:
Code:

$stats = $DB_site->query_first("
SELECT COUNT(*) AS plays, SUM(finish-start) as time
FROM gamesessions
WHERE valid=1
");


Replace with:
Code:

$stats = $DB_site->query_first("
SELECT COUNT(*) AS plays, SUM(finish-start) as time
FROM " . TABLE_PREFIX . "gamesessions
WHERE valid=1
");



ConqSoft 03-30-2004 10:41 PM

Worked fine for me, but I don't use a table prefix. So, might be an issue with the prefix code.

dstruct2k 03-30-2004 10:45 PM

Already fixed that. :) (Gotta love edits.)

SpankMe 03-31-2004 12:29 AM

Great hack. Now all we need is the .FLA source file for Xevious flash version to add to the game list.

OGT 03-31-2004 12:39 AM

Quote:

Originally Posted by HarryButt
FYI: Change the order of the games list :surprised:

In arcade.php

Code:

LEFT JOIN " . TABLE_PREFIX . "games AS games ON gamesessions.gamename = games.shortname
                $whereclause AND $sessionclause ORDER BY gamesessions.gamename DESC
        ");

change to

Code:

LEFT JOIN " . TABLE_PREFIX . "games AS games ON gamesessions.gamename = games.shortname
                $whereclause AND $sessionclause ORDER BY gamesessions.gamename ASC
        ");

EX: http://www.gzhq.net/forums/arcade.php?

to help those searching for alphabetized game list. searching alpha* does not bring up this post, and it took me an hour to find this. alphabet alphabetize alphabatize

KamuiX 03-31-2004 03:29 AM

Ah, thanks for the info ohgeetee :)

Dejavu 03-31-2004 07:11 AM

Quote:

Originally Posted by dstruct2k
I don't think the installer made my gamesessions table.
Code:

Database error in vBulletin 3.0.0:
 
Invalid SQL:
                SELECT COUNT(*) AS plays, SUM(finish-start) as time
                FROM gamesessions
                WHERE valid=1
 
mysql error: Table 'db87385808.gamesessions' doesn't exist
 
mysql error number: 1146

That doesn't look right though... "db87385808" is my database, not a table name...


[edit]Checked in phpmyadmin... the table is "vb3__gamesessions" so something's not working right.

[edit 2]Found the bug in arcade.php.... Most of you aren't using table prefixes, otherwise you'd have this bug too.
FIX:
Find:
Code:

$stats = $DB_site->query_first("
SELECT COUNT(*) AS plays, SUM(finish-start) as time
FROM gamesessions
WHERE valid=1
");


Replace with:
Code:

$stats = $DB_site->query_first("
SELECT COUNT(*) AS plays, SUM(finish-start) as time
FROM " . TABLE_PREFIX . "gamesessions
WHERE valid=1
");



I found the same problem with the mini-stats addon included with the release, didn't have a clue what was going on until i opened the file, and sure enough it didn't have the TABLE_PREFIX or whatever it is in its place :)

JamesFrost 03-31-2004 10:22 AM

John,

you mentioned previously a new version slated to appear after Gold came out. Do you have a current timescale and features list of what will be in it?

John 03-31-2004 10:25 AM

Quote:

Originally Posted by JamesFrost
John,

you mentioned previously a new version slated to appear after Gold came out. Do you have a current timescale and features list of what will be in it?

Check the "Site Survey" thread on v3arcade.com

maverick1236 03-31-2004 02:29 PM

is there a way to manually or automatically delete all high scores weekly?

i have one user hogging all the trophies-and it discourages everyone else...

Okiewan 03-31-2004 02:45 PM

Quote:

Originally Posted by maverick1236
is there a way to manually or automatically delete all high scores weekly?

i have one user hogging all the trophies-and it discourages everyone else...

In the admin cp.


All times are GMT. The time now is 09:31 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05345 seconds
  • Memory Usage 1,834KB
  • 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
  • (9)bbcode_code_printable
  • (15)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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