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)

sitka 03-05-2005 06:30 PM

Code:

$game = $DB_site->query("SELECT * FROM " . TABLE_PREFIX . "games A, gamescat B WHERE A.categoryID = B.categoryID ORDER BY gameid ");
I have no problem with any other area of the arcade. I can even change the game categories around in the "Game Categories" link in the admincp "Add Game Category" works too.

BUT when i click on the "game settings" in the admincp I get this ERROR

I have the correct names these are just x'd out.
xxxxxx = my prefix
xxxxxx_xxxxxx = database name

Database error in vBulletin 3.0.x:

Invalid SQL: SELECT * FROM xxxxxx_games A, gamescat B WHERE A.categoryID = B.categoryID ORDER BY gameid
mysql error: Table 'xxxxxx_xxxxxxx.gamescat' doesn't exist

mysql error number: 1146

Date: Saturday 05th of March 2005 03:27:29 PM
Script: http://www.xxxxxx.com/forum/admincp/...n.php?do=games
Referer: http://www.xxxxxx.com/forum/admincp/index.php?do=nav
Username: Me
IP Address: xxx.xxx.xxx.xxx

do i need to modify that line of code?
There shouldn't be a . between the prefix and the table name. This isn't the only hack that has issues w/ prefixes. I wish someone could explain how to prevent issues like this.

Mijae 03-05-2005 06:34 PM

So, anyone uploaded the 800+ games zip? I can mirror.

lucabosurgi 03-06-2005 01:58 AM

For $1,99 you get them here http://www.internetjunkie.org/showthread.php?t=717

lucabosurgi 03-06-2005 02:03 AM

I get the "non loged in" window when I click the return link from the playgame page to the main arcade page.
I'm on 3.0.7 any suggestions? The rest works beautifully!!!
Thank you

J.C. 03-06-2005 08:58 AM

I also need new/more games ASAP for my new forums... but I dont know when v3arcade.com will open :( so, if anyone have a collection pack, I'd be grateful if you can upload it to my FTP. (Please PM me)

Thanks.. :)

Chrissicom 03-06-2005 09:32 AM

I have like 800 games on my FTP all from that other FTP that has gone offline. Although I have a 100 MBit stand-up line and I think if I would publicly post the server here you guys would suck up my traffic pretty quickly. Please send $5 or 4 EUR by PayPal to chrissicom@sandrabullock.ws and I give you a private FTP account to access and download all the games with no bandwidth or speed limit :-)

WiseOwl 03-06-2005 10:34 PM

werd I hear ya

nighteyes 03-06-2005 11:15 PM

It seems like everyone is in the business of trying to profit from selling access to copyrighted games now. This is software piracy, pure and simple, and of the very worst kind.

The moderators of this board should crack down on this practice immediately.... otherwise this could get very messy for all those involved.

Chrissicom 03-07-2005 06:12 AM

Asking for $5 to download so many games is no profit! It's less than I pay for the traffic generated so I still loose money when I rech my bandwidth limit and too many people download the games. I don't even have a website up where I say contact me to buy games or anything like that! It's just on a personal basis. I study law in Europe and I know that this kind of business is not illegal over here, maybe in the US don't know their laws.

Brent H 03-08-2005 04:38 AM

Charging to download ANYTHING that's not owned by you for ANY amount of money is illegal, and breaks various copyright laws (and I suspect international laws as well). Even if you don't make any kind of monetary profit from it by charging less than what it costs you to operate the server, you're still getting some sort of compensation by having the bill for your server be padded by these 5 dollar "donations".

If anyone needs the space, I have a webhosting account I'm not using that I can upload any and all games to. PM me and I'll get it going.


All times are GMT. The time now is 01:02 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.04020 seconds
  • Memory Usage 1,740KB
  • 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
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (6)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