vb.org Archive
Page 64 of 457 « First 14546263 64 656674114164 Last »
Show 40 post(s) from this thread on one page

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)

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 05:08 AM.
Page 64 of 457 « First 14546263 64 656674114164 Last »
Show 40 post(s) from this thread on one page

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