vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Beta Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=5)
-   -   vbProArcade Beta 2 (https://vborg.vbsupport.ru/showthread.php?t=42880)

sk187 09-17-2002 12:58 AM

its vbb 2.27

the board is at www.btnhboard.com/portal/board

if you need to log in you can use

l/test
p/test

It says "video arcade" right under the banner

no one is reporting any problems - just vbb is sending me the sql error messages

Link14716 09-17-2002 01:04 AM

To tell you the truth, I dunno what the problem is. *Nudges futureal*

Dark Shogun 09-17-2002 01:43 AM

Never mind

Dark Shogun

futureal 09-17-2002 03:05 AM

Quote:

Originally posted by sk187
This is an amazing hack and it seems to work perfect for most of my 700 users but vbulletin has been emailing me about sql errors.

Like this

Database error in vBulletin 2.2.6:

Invalid SQL: SELECT sessionhash,userid,host,useragent,styleid FROM session WHERE lastactivity>1032214124 AND sessionhash='de0056fe406cbbd965a806bbd71f3dde' AND (host='198.81.26.175' OR (althash='' AND althash<>'')) AND useragent='Mozilla/4.0 (compatible; MSIE 6.0; AOL 7.0; Window'
mysql error: Unknown column 'althash' in 'where clause'

mysql error number: 1054

This error is unrelated to my hack. You have apparently inadvertently installed some sort of vBulletin 2.2.7 code into your vBulletin 2.2.6 -- the althash field is something that was introduced in 2.2.7.

Quote:


and

Database error in vBulletin 2.2.7:

Invalid SQL: SELECT max(score) as maxscore FROM arcade WHERE game='pacman' AND username='TL's De La Hoya'
mysql error: You have an error in your SQL syntax near 's De La Hoya'' at line 1

mysql error number: 1064

This is a known bug having to do with the ' character in a user's name. It has been FIXED for Beta 2. For Beta 1, find this line in proarcade.php:

PHP Code:

$userscore_q $DB_site->query_first("SELECT max(score) as maxscore FROM arcade WHERE game='$gamename' AND username='$username'"); 

And change it to this:

PHP Code:

$theusername addslashes($username);
$userscore_q $DB_site->query_first("SELECT max(score) as maxscore FROM arcade WHERE game='$gamename' AND username='$theusername'"); 

That should fix the error.

Audionuts 09-17-2002 07:00 AM

ok so for games to keep score we need the fla source right?
otherwise we can add but it wont keep score?

Well futureal, here is a zip with 18 games in it :) fla source...some better then others, let me know what you think...

Games Zip

mewgood 09-17-2002 07:08 AM

Quote:

Originally posted by Audionuts
ok so for games to keep score we need the fla source right?
otherwise we can add but it wont keep score?

Well futureal, here is a zip with 18 games in it :) fla source...some better then others, let me know what you think...

Games Zip

the zip has some problems..

Audionuts 09-17-2002 07:11 AM

you might have tryed to download before i finished the upload i didnt realize it would be so big :)

the file size is 13.8 megs

if you still have problems let me know...

Lilac 09-17-2002 11:42 AM

When will the final version be released?

Ninth Dimension 09-17-2002 12:25 PM

when it's done - I think :D

sk187 09-17-2002 02:45 PM

Quote:

Originally posted by futureal


This error is unrelated to my hack. You have apparently inadvertently installed some sort of vBulletin 2.2.7 code into your vBulletin 2.2.6 -- the althash field is something that was introduced in 2.2.7.


I updated from 2.2.6 to 2.2.7 before I installed your arcade hack.

Was that a bad thing?

futureal 09-17-2002 05:58 PM

Quote:

Originally posted by sk187
I updated from 2.2.6 to 2.2.7 before I installed your arcade hack.

Was that a bad thing?

No, it shouldn't be. Everything works fine in 2.2.7 as far as I know. Could you tell me where that althash error is being generated?

I don't directly address the sessionhash stuff at all in vbProArcade, other than passing it from page to page, so there shouldn't ever be a time where I am pulling it from the DB.

Since you're getting an "unknown column althash" error, it almost seems like one of the ALTER queries in the 2.2.7 upgrade did not work. Did you run the upgrade script and all that?

futureal 09-17-2002 06:11 PM

Quote:

Originally posted by Lilac
When will the final version be released?
There is no real timeframe yet. I am adding new stuff every couple of days right now, and then there will be a Beta 2, which will turn into a Release Candidate and then into a Final Release.

My biggest goal is to finalize the SQL table structure in Beta 2 so that future installs will be easy to upgrade. I already have a SQL conversion script for Beta 1 -> Beta 2.

Audionuts 09-17-2002 06:47 PM

very nice!! this is an awsome hack :)
were you able to d/l the game zip i attached without any problems?

Steve Machol 09-17-2002 06:53 PM

Quote:

Originally posted by sk187
I updated from 2.2.6 to 2.2.7 before I installed your arcade hack.

Was that a bad thing?

You didn't run upgrade20.php which *was* a bad thing. ;)

sk187 09-17-2002 10:23 PM

I did run update20 before installing the hack.

Anyway for some strang reason im not gettin any more errors. There are a few hundred people on the arcade with no problems.

Very odd

Anyway thanks for the help - cant wait to see more of this hack

futureal 09-17-2002 10:50 PM

Quote:

Originally posted by Audionuts
very nice!! this is an awsome hack :)
were you able to d/l the game zip i attached without any problems?

Yup, I got it. I will check it out as soon as I finish a few more things on the arcade.

If anybody has seen the more recent pages on Shadows, you will see some of the new features that I've moved over from my test site. :)

Audionuts 09-17-2002 10:52 PM

cool deal, i'll keep an eye out for any more cool games i can get my hands on :)

looking foward to beta 2 :)

garoboldy 09-18-2002 04:21 AM

has anyone gotten any new games modded for use with this arcade....

if not does anyone know how to go about this. If you do let me know. I will do what I can to get some more games out for use. thanks again.

later

Audionuts 09-18-2002 04:27 AM

well i just gave futureal 18 game sources, i'm sure if you find any good ones he would do his best :)

Craigr 09-18-2002 11:37 AM

Quote:

Originally posted by Audionuts
well i just gave futureal 18 game sources, i'm sure if you find any good ones he would do his best :)
Wow, excellent, what ones were included?

Craig

Apok2002 09-18-2002 10:14 PM

Guys, read a few pages back where he talks about putting more game integrations on hold as he wants to concentrate on other areas of the hack first.

Futureal, another request/question though...

How about having the option to reset the scores via the admin cp? This way we can have a bit more control over it. As it is now, we must go into mysql to clean up.

futureal 09-19-2002 04:28 AM

Yup, that is one of the planned additions. :)

Audionuts 09-19-2002 04:47 AM

very cool! i already have tournament for prizes lined up :)

BrAinZ 09-19-2002 07:02 AM

How stable is this hack at the moment?
I'm thinking of installing, but am not sure whether to do it now.. or wait for the final release.

futureal 09-19-2002 05:05 PM

It is perfectly stable right now -- I am not aware of any bugs that have not been solved.

The next Beta will basically be expanding it with a lot of new features. I still have no release date in mind as I'm only about 50% done with what I want to do with it.

Tigga 09-19-2002 07:02 PM

Quote:

Originally posted by Audionuts
very cool! i already have tournament for prizes lined up :)
Hehe... I do too actually. :) I promote club events and we're doing one October 5th where we're setting up a video game tournament and having projectors + 4 huge screens for the games to be played on. I'm giving away free tickets to the top scorers for each game, so it worked out rather nicely that this was released when it was. :)

BloodThirsty229 09-19-2002 08:58 PM

I installed everything manually like three times. Everything works except when I go to the arcade and I click one of the games it shoes the box but it sits there and loads nothing. However it will show the outline of the game just nothing inside the box. I uploaded the games folder in both the public_html and forums folder. I'm lost on what to do.

BloodThirsty229 09-19-2002 09:46 PM

nevermind I got it to work ^_^ amazing hack btw

Audionuts 09-19-2002 10:05 PM

yup futureal deserves mad credit for this one :)

situledi 09-19-2002 10:44 PM

BloodThirsty229 > don't forget to activate the game via the admin cp.... lol

so futureal, thanx for ur hack.. great one... thanx to make my members happy...

waiting for the next release, and hope to have the possibility to upgrade this one to the next release...

i just traduce it in french and everything is ok...

regards

Apok2002 09-19-2002 11:08 PM

Quote:

yup futureal deserves mad credit for this one
Yup, I'm forseeing a popularity that rival's Lesane's Store Hack. ;)

Go Futureal!

(btw...don't let him play on your arcade though....he'll put an impossible Pacman score on it that just can't be beat...which is why the real reason I want the admin cp ability to reset the scores.) :)

Audionuts 09-19-2002 11:36 PM

hehe..true his record still stands in my forum...lol

mewgood 09-20-2002 12:39 AM

great
finally it works for php safe mode
GReat JOB:D

futureal 09-20-2002 01:12 AM

Quote:

Originally posted by Audionuts
hehe..true his record still stands in my forum...lol
Yea I finally got the top spot back at my own site, 85K or so. :)

Angelus1753 09-20-2002 12:19 PM

This is an awesome hack.... can't wait for the full version :D

Tigga 09-20-2002 05:39 PM

I'll challenge anyone in Tetris. I've got 577,000 on my board. :D

Dark Jim 09-20-2002 08:39 PM

Lol you think that's much, on my forums someone got 1.5 million. :D

Tigga 09-21-2002 02:49 AM

Yah... I thought I was doing good since the next highest score was about 166,000... Then of course someone else comes on there and scores 871,000. Guess I've got my work cut out for me. :)

futureal 09-21-2002 02:49 AM

I think the top score on mine is 1.67 million by someone.

The problem is that after the game hits 1000 lines on level 10, it resets. I've had a few unhappy users from that.

Once the hack itself is done and released, then we'll start worrying about getting all the games in order.

Tigga 09-21-2002 08:33 AM

Does anyone know how secure the script is and how hard it would be to edit the high scores? As I said above, I'm using this to make a little contest on my site and giving away free tickets to an event we're doing (worth $25 each) to whoever has the highest score in each game. One member has the highest score on each game and there's a couple of things that look a little suspicious... Ex - making a high score in one game, then another 4 minutes later... He beat my original Tetris high score of 127,000 by a few thousand, then when I managed to get 577,000 he came back and beat it by almost 300,000 4 hours later. He also doesn't appear to have played the games much, so that's why I'm a little suspicious. Is there a way I could maybe check my log files or something and see if someone other than myself has been in the server? Also, one of my users pointed this out on the board... "there's a problem inherant with having the game and the score-reporting client-side". Anyways, if anyone can help with this it would be much appreciated.


All times are GMT. The time now is 01:37 PM.

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.03183 seconds
  • Memory Usage 1,826KB
  • 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_php_printable
  • (12)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)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