vb.org Archive
Page 41 of 195 « First 313940 41 42435191141 Last »
Show 40 post(s) from this thread on one page

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?


All times are GMT. The time now is 12:24 PM.
Page 41 of 195 « First 313940 41 42435191141 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.04078 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
  • (2)bbcode_php_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