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)

John 01-22-2004 11:53 AM

Run this query:

Code:

DELETE FROM gamesessions WHERE gamename='maeda'

NyCwill 01-22-2004 01:15 PM

how do you uninstall a game?

corsacrazy 01-22-2004 01:25 PM

Quote:

Originally Posted by NyCwill
how do you uninstall a game?

goto admincp and goto arcae game settins click the game and unactivate it (set show game to NO)

GamerzWorld 01-22-2004 01:52 PM

Didnt work only got error

An error occurred while attempting to execute your query. The following information was returned.
error number: 1065
error desc: Query was empty

Detomah 01-22-2004 02:01 PM

Another serious Maeda Wall bug/exploit found by one of my users.

This one is so seriously easy and obvious really. >.<

When you start each level, you start off by scrolling the mouse onto the arrow, all you have to do is basically scroll back out of the game area and wait till the finish arrow appears, then scroll onto that, level done.

You don't score points for the blocks, but you get the bonus at the end of the level and can basically continue doing that forver or till you get bored.

Anyway, thought I better report this one too, to see if you can fix it.

Damn my users and their devious minds. >.<

corsacrazy 01-22-2004 02:07 PM

n e one got chopper challenge cheats LOL

Nam 01-22-2004 02:09 PM

I got a real quick question, for some reasons the game MiniClip Snake appear twice in the homepage forum and inside and admin panel, I guess I accidently ran the installtion file twice.

Now how do I remove one of them? Thanks for great hack.

GamerzWorld 01-22-2004 02:41 PM

Working now

Oblivion Knight 01-22-2004 03:53 PM

Hi John,

Any news of a ProArcade upgrade script yet.?
I'd hate to lose already existent high scores.. ;)

John 01-22-2004 03:56 PM

Can you send me an example of a typical proArcade score record?

Oblivion Knight 01-22-2004 04:09 PM

PM sent.. :)

SRozhon 01-22-2004 04:27 PM

Awesome! Great Work!

Rampag33 01-22-2004 04:34 PM

Installed in about 5 minutes. Great job.

Updating settings this phrases can't be found when updating settings on the admincp
---> arcade_cp_settingssaved

The phrases has been added but it wont find it.

Didi_gt 01-22-2004 04:47 PM

Awesome work ...top http://www.granturismo.de/forums/ima...es/applaus.gif

John 01-22-2004 05:04 PM

Quote:

Originally Posted by Rampag33
Installed in about 5 minutes. Great job.

Updating settings this phrases can't be found when updating settings on the admincp
---> arcade_cp_settingssaved

The phrases has been added but it wont find it.


You've probably added it to GLOBAL group. (Read the instructions carefully.)

Mickie D 01-22-2004 05:11 PM

this hack is fantastic the install instructions i am gonna base mine of as they are the easiest instructions to follow i have used :)

i have to say i have added many hacks and coded a few of my own also... and this hack is superb its the best looking and wonderful to keep members on site at the same time

on a different note:

the last game miniclip snake (gr8 game i am addicted) i got to level 5 and the bugger crashed :(

PS... i own a chalet in stalhem about 25 or more miles of norwich and what a lovely place i love the broads ;)

Regards
Mickie

Schorsch 01-22-2004 05:11 PM

a small shoutbox inside the arcade main page would be great, so the people could chat about the games and scores etc...

Briboy923 01-22-2004 05:13 PM

Does anybody know how I could manually change someones score?

Rampag33 01-22-2004 05:49 PM

Quote:

Originally Posted by John
You've probably added it to GLOBAL group. (Read the instructions carefully.)

Alright yeah I missed placed 2 of them. Everything works fine now, thx.

Any way to make the postbit champion icons appear smaller and in a straight line instead of up and down. Could make postbits very huge.

John 01-22-2004 06:20 PM

Quote:

Originally Posted by Briboy923
Does anybody know how I could manually change someones score?

The only way is to change the value in the database.

Didn't bother including any such feature, as I couldn't think of a legitimate reason for having it.

John 01-22-2004 06:41 PM

Quote:

Originally Posted by Rampag33
Alright yeah I missed placed 2 of them. Everything works fine now, thx.

Any way to make the postbit champion icons appear smaller and in a straight line instead of up and down. Could make postbits very huge.

Remove the <br> from the arcade_awards_bit template

John 01-22-2004 06:51 PM

Quote:

Originally Posted by Mickie D
PS... i own a chalet in stalhem about 25 or more miles of norwich and what a lovely place i love the broads ;)

Regards
Mickie

Heh, small world. :p

monstergamer 01-22-2004 07:04 PM

Quote:

Originally Posted by monstergamer
EDIT: one of my staff has asked me some thing..
i am going to turn on the auto pruning on for every 30 days

and they asked if there is was a way to have it post the top 5 socore for each game in a certin thread or forum id before it prunes the scores

is there any way when you get time to add this to you new features list ?

Xyphen 01-22-2004 08:05 PM

Can you tell us how/what to do to a .fla file to make it work with the arcade? Maybe I would release a few games here... :)

John 01-22-2004 08:14 PM

Quote:

Originally Posted by AViO 07
Can you tell us how/what to do to a .fla file to make it work with the arcade? Maybe I would release a few games here... :)

I'll send you a PM. :)

DuffMan 01-22-2004 08:18 PM

I just installed this at http://www.activegaming.net/forums/arcade.php? and it works great; my members love it. Thanks a lot!

MaDCaT75 01-22-2004 08:34 PM

Quote:

Originally Posted by AViO 07
Can you tell us how/what to do to a .fla file to make it work with the arcade? Maybe I would release a few games here... :)

I wanna know too!

Gio Takahashi 01-22-2004 08:58 PM

ditto >.>

Gio Takahashi 01-22-2004 09:13 PM

One thing. How easily can Maeda be cheated, as in. how can one easily get 600,000 points in 800 seconds?

John 01-22-2004 09:20 PM

Quote:

Originally Posted by Gio Takahashi
One thing. How easily can Maeda be cheated, as in. how can one easily get 600,000 points in 800 seconds?

Did you overwrite the old swf with the new one?

Martyjp 01-22-2004 09:24 PM

Installed perfectly first time, great work :)

MaDCaT75 01-22-2004 09:39 PM

John please talk to me on aim when you get the chance!

Alien 01-22-2004 09:50 PM

Hmm this is weird, a few minutes ago I just got 2 mysql server errors e-mails like this:

Database error in vBulletin 3.0.0 Release Candidate 3:
Invalid SQL:
SELECT COUNT(*) + 1 AS scoresAbove
FROM gamesessions
WHERE score > AND valid=1 AND gamename=''

mysql error: You have an error in your SQL syntax near 'AND valid=1 AND gamename=''
' at line 4
mysql error number: 1064
Date: Thursday 22nd of January 2004 06:40:04 PM
Script: http://forums.aliensoup.com/arcade.php

Any ideas? All I've installed since installation of the arcade (which has worked perfectly so far) was the "Total Number of Users Online Now on Every Page" hack located here:

https://vborg.vbsupport.ru/showthread.php?t=59722

Anything you can decipher?

-Jason

Detomah 01-22-2004 09:54 PM

Quote:

Originally Posted by John
Did you overwrite the old swf with the new one?

Sorry John, I think you must have missed my latest exploit find for Maede, I think that would easily explain people getting huge scores, even after you fixed that last bug...

https://vborg.vbsupport.ru/showpost....&postcount=605

John 01-22-2004 10:33 PM

Quote:

Originally Posted by Alien
Hmm this is weird, a few minutes ago I just got 2 mysql server errors e-mails like this:

Database error in vBulletin 3.0.0 Release Candidate 3:
Invalid SQL:
SELECT COUNT(*) + 1 AS scoresAbove
FROM gamesessions
WHERE score > AND valid=1 AND gamename=''

mysql error: You have an error in your SQL syntax near 'AND valid=1 AND gamename=''
' at line 4
mysql error number: 1064
Date: Thursday 22nd of January 2004 06:40:04 PM
Script: http://forums.aliensoup.com/arcade.php

Any ideas? All I've installed since installation of the arcade (which has worked perfectly so far) was the "Total Number of Users Online Now on Every Page" hack located here:

https://vborg.vbsupport.ru/showthread.php?t=59722

Anything you can decipher?

-Jason

Download the latest arcade.php. :)

Alien 01-22-2004 11:07 PM

Done! Did I actually find something legitimate? lol...

I've been keeping up with each new update, & you're doing an astounding job with keeping up with all this!

I'll let you know if I see any other errors. :D

Alien 01-22-2004 11:10 PM

Btw, the user who had this occur responded with:

Quote:

There was a few MySQL problems regarding the sessions with the arcade. This is because during game play and when the game ends it re-directs to the stats page. However as this wastes time I pressed the back button when it was re-directing which caused *something* to happen and created the errors. I can re-create the error again quite easily.

Not sure if there is a way for the hack creator to fix the problem or not, if not then I will just let the page re-direct then click the link again ;) .

Alien 01-22-2004 11:16 PM

I just received a message after I asked him to try it again, and so far he can't reproduce the problem. :) Nice work!

John 01-22-2004 11:20 PM

Quote:

Originally Posted by Alien
Done! Did I actually find something legitimate? lol...

I've been keeping up with each new update, & you're doing an astounding job with keeping up with all this!

I'll let you know if I see any other errors. :D

'fraid not, I think this one came up about 7 pages ago! ;)

CampusCrawler 01-23-2004 12:31 AM

Heya, I am having this error emailed to me. But everything seems to work fine on the front end.

Invalid SQL:
SELECT user.userid AS userid, gamesessions.score AS score, games.shortname AS shortname FROM vb3_gamesessions
LEFT JOIN vb3_user AS user ON user.userid = gamesessions.userid
LEFT JOIN vb3_games AS games ON gamesessions.gamename = games.shortname
WHERE (gamename='breakout' AND score='9750') OR (gamename='chopper' AND score='444') OR (gamename='simon' AND score='8') OR (gamename='snake' AND score='160') OR (gamename='spaceinvaders' AND score='6830') OR (gamename='target' AND score='390') OR (gamename='tetris' AND score='2055') AND sessiontype=1 ORDER BY gamesessions.gamename DESC

mysql error: Unknown table 'gamesessions' in field list

mysql error number: 1109

Any Ideas

-ADistantBox


All times are GMT. The time now is 11:02 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.03032 seconds
  • Memory Usage 1,825KB
  • 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
  • (14)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