vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Major Additions - ibProArcade - professional Arcade System (https://vborg.vbsupport.ru/showthread.php?t=101554)

Ohiosweetheart 02-03-2006 08:09 PM

IS there a way to delete, or turn off, the left and right colums (New games, most played games) ?? I have my games set by permission... you have to have a certain # of posts to be able to play the games in that category. But my members see the other games and try to play them, getting upset when they can't.

Is there a way to do this? thanks

juanchi 02-03-2006 10:27 PM

Everything was working fine but now when I try to enter the arcade I'm getting this mysql error:

Quote:

mySQL query error: SELECT DISTINCT GID, MID, name, COUNT(DISTINCT(GID)) as total FROM vbb_games_scores GROUP BY name ORDER BY total DESC LIMIT 3

mySQL error: Got error 28 from table handler
mySQL error code:
Can anyone help me with this, thanks.

BTW, I'm running 3.5.3

MortysTW 02-03-2006 10:39 PM

Well, something is goofy with your DB request. Cuz the table should be called VB_ not VBB_

not really sure how else to help you. Not good with errors myself. :(

MortysTW 02-03-2006 10:41 PM

Quote:

Originally Posted by Ohiosweetheart
IS there a way to delete, or turn off, the left and right colums (New games, most played games) ?? I have my games set by permission... you have to have a certain # of posts to be able to play the games in that category. But my members see the other games and try to play them, getting upset when they can't.

Is there a way to do this? thanks


Go into the arcade templates and comment that stuff out.

Or are you trying to make it with group permissions for visibility?

|Jordan| 02-03-2006 11:04 PM

Are the tournaments real-time multiplayer? (like counter-strike) or are they individual and the scores are compared at the end.

MortysTW 02-03-2006 11:09 PM

Individual scores are compared. But you get paired up against someone

So an 8 person tournament has 3 tiers. 1 on 1 is Tier 3, Tier 2 has 4 players of 1 on 1 from the winner of user1 & 2 against winner of user 3 & 4 and so forth. Tier 1 is the 1 on 1 to win Tournament. Again, best 2 out of 3 games. Best score wins.

Ohiosweetheart 02-04-2006 12:17 AM

Quote:

Originally Posted by MortysTW
Go into the arcade templates and comment that stuff out.

Or are you trying to make it with group permissions for visibility?

nope I don't want them in there at all... I want members to have to access the games that are visible for their group only. THAT I have set up. But I need to get rid of those left (newst games) and right (games most played) columns.

um.................. what do you mean, comment them out?

Desesperao 02-04-2006 12:32 AM

Hi!

When I beginning a turnament with 8 players it reports a error.

it happens to him more to somebody?

PD: sorry, my English is very little.

bspiller82 02-04-2006 12:52 AM

Quote:

Originally Posted by slicebogey
where do you get games from? and how much are the games?

I have a bunch on my site.
http://www.247xtreme.com/downloads/arcade/

juanchi 02-04-2006 07:14 AM

It was not an ibproarcade issue, this error have to do with hard disk space problem, in my case the /tmp directory was full.

Quote:

Originally Posted by juanchi
Everything was working fine but now when I try to enter the arcade I'm getting this mysql error:

Quote:

mySQL query error: SELECT DISTINCT GID, MID, name, COUNT(DISTINCT(GID)) as total FROM vbb_games_scores GROUP BY name ORDER BY total DESC LIMIT 3

mySQL error: Got error 28 from table handler
mySQL error code:
Can anyone help me with this, thanks.

BTW, I'm running 3.5.3


CrazyShooter 02-04-2006 10:46 AM

How can i make it so that we dont get any private messages when the highscore gets beaten.

TTG 02-04-2006 11:11 AM

Quote:

Originally Posted by CrazyShooter
How can i make it so that we dont get any private messages when the highscore gets beaten.

Arcade > your settings

MortysTW 02-04-2006 01:32 PM

Quote:

Originally Posted by TTG
Arcade > your settings

Plus besides the settings in teh AdminCP, users can choose that option for themselves if they are a member in their own personal settings.

On almost any arcade webpage, across the top, they can click YOUR SETTINGS.

MrZeropage 02-04-2006 07:12 PM

Currently there is just the setting for each User in his Arcade-Settings, but I already implemented a global Notification-Setting in the AdminCP for ibProArcade v2.5.5+ :)

Carl Anderson 02-05-2006 12:57 AM

Is there a checkers or chess for this and can users play each other live time? If there is where can I get it...

Cool Mod Thanks - clicks install

MissKalunji 02-05-2006 01:13 AM

Quote:

Originally Posted by Carl Anderson
Is there a checkers or chess for this and can users play each other live time? If there is where can I get it...

Cool Mod Thanks - clicks install


that would be nice if you find out let me know plz!

oloringandalf 02-05-2006 10:50 PM

Quote:

Originally Posted by Carl Anderson
Is there a checkers or chess for this and can users play each other live time? If there is where can I get it...

Cool Mod Thanks - clicks install

That would be great if there are chess and checkers games for ibproarcade. Let me know if you find them.

MrZeropage 02-06-2006 05:17 PM

I have a Chess-Game but it does not submit any Score. So just playing for Fun, no Highscores... and yet just SinglePlayer :)

Annie^.^ 02-06-2006 06:41 PM

I'm not sure if this has been asked, but I already installed V3 Arcade and I also lik eto add this one. Once I install this will I lose the scores that it's V3 Arcade or how is the two works together?

cyberhypnotic 02-06-2006 06:51 PM

From what I've seen myself, you can't use both ibproarcade and v3arcade at the same time. They both use some of the same phrases and such.

MissKalunji 02-06-2006 07:32 PM

Quote:

Originally Posted by MrZeropage
I have a Chess-Game but it does not submit any Score. So just playing for Fun, no Highscores... and yet just SinglePlayer :)

can i have it?

Annie^.^ 02-06-2006 07:59 PM

Ok thanks ...

GamerJunk.net 02-07-2006 12:47 AM

Does anyone know what phrase is used to tell people their usergroup is not able to play games? I want to modify it to leave a register link since only guests on my board can not play games.

Areku 02-07-2006 08:17 AM

Hi!

I installed a V3Arcade game onto my ibProArcade installation, manually, filling the GNAME field with the gamename field of the V3Arcade game set up...

Everything ran fine: icons load fine, game loads fine... but when saving scores, it saves them onto a total different game scoreboard!

Why??

kylek 02-07-2006 08:31 AM

Mr Zeropage or anyone;

CMX_CMGSCCC has recently coded a fantastic and operational points and store system (Ebux / Estore 1.0.7 ) like ucash in under a week and I am wondering if you or someone could take a look at it and see if this could be incorporated into Ibproarcade. It would be nice to be able to charge 1 point per game to play.

evesve 02-07-2006 10:40 AM

Quote:

Originally Posted by Synth
Cool, thanks. I upgraded and everything went fine and the tounament works now:) The only problem I have now is that when I confirm the tounament i get this error on a white page after the redirect:

mySQL query error: SELECT userid, username FROM user WHERE userid IN() ORDER BY userid

mySQL error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY userid' at line 1
mySQL error code:
Date: Saturday 28th of January 2006 09:35:30 AM


But the tournament is still created and works fine.

Thanks for the help:)

Same for me...
Quote:

mySQL query error: SELECT userid, username FROM vb3_user WHERE userid IN() ORDER BY userid

mySQL error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY userid' at line 1
mySQL error code:
Date: Tuesday 07th of February 2006 12:44:27 PM
Tournament works fine!
Why this error?

boatswife 02-07-2006 11:48 AM

Thank you so much for taking the time to upgrade the Arcade and especially for adding the "reset scores" button.

I appreciate it! :classic:

oloringandalf 02-07-2006 03:05 PM

Quote:

Originally Posted by MrZeropage
I have a Chess-Game but it does not submit any Score. So just playing for Fun, no Highscores... and yet just SinglePlayer :)

Cool. Can I have it.

Ohiosweetheart 02-07-2006 07:15 PM

After having this arcade for a few weeks and really enjoying it, I was forced to uninstall it today. My site started going down... the database was being corrupted. I had to do multiple repairs. ALL database errors were concerning the arcade.

The following error was just one of many:
mySQL query error: SELECT * FROM vb_games_settings mySQL error: mySQL error code: Date: Tuesday 07th of February 2006 03:38:55 PM


I hope I can reinstall it in the near future, but not for now

fly 02-07-2006 07:20 PM

Quote:

Originally Posted by Ohiosweetheart
After having this arcade for a few weeks and really enjoying it, I was forced to uninstall it today. My site started going down... the database was being corrupted. I had to do multiple repairs. ALL database errors were concerning the arcade.

The following error was just one of many:
mySQL query error: SELECT * FROM vb_games_settings mySQL error: mySQL error code: Date: Tuesday 07th of February 2006 03:38:55 PM


I hope I can reinstall it in the near future, but not for now

I have not installed this arcade, but can pretty much guess that it wasn't the arcade. In a 99 page thread, that problem probably would have surfaced on page 30.

Good luck tho.

Ohiosweetheart 02-07-2006 07:25 PM

Quote:

Originally Posted by Ohiosweetheart
After having this arcade for a few weeks and really enjoying it, I was forced to uninstall it today. My site started going down... the database was being corrupted. I had to do multiple repairs. ALL database errors were concerning the arcade.

The following error was just one of many:
mySQL query error: SELECT * FROM vb_games_settings mySQL error: mySQL error code: Date: Tuesday 07th of February 2006 03:38:55 PM


I hope I can reinstall it in the near future, but not for now

Quote:

Originally Posted by flypaper
I have not installed this arcade, but can pretty much guess that it wasn't the arcade. In a 99 page thread, that problem probably would have surfaced on page 30.

Good luck tho.

oh no? I got several database errors and they were all related to the arcade... the one I posted was just one of many.

AND... since I uninstalled it, there's been no more errors and I've not been down once. It was the arcade in one way or another

trilljester 02-08-2006 01:53 PM

Thanks again for this Mr. Zeropage, it really is one of my favorite mods, been using this arcade system since it was a beta for IPB 1.3, and to be able to use it again with VBulletin has been awesome.

Question: Are there any plans to integrate the arcade with any of these "shop" and "cash" mods that are popping up everywhere?

trilljester 02-08-2006 01:59 PM

Quote:

Originally Posted by Ohiosweetheart
After having this arcade for a few weeks and really enjoying it, I was forced to uninstall it today. My site started going down... the database was being corrupted. I had to do multiple repairs. ALL database errors were concerning the arcade.

The following error was just one of many:
mySQL query error: SELECT * FROM vb_games_settings mySQL error: mySQL error code: Date: Tuesday 07th of February 2006 03:38:55 PM

Where's the mySQL error code? How many users do you normally get hitting your site/arcade? I had a zerg rush of users once in my arcade of close to 75 users, and it never had any database problems. Who's doing your database hosting? It's possible that the mySQL server can't handle large amounts of traffic. It's one of the many reasons no large companies use mySQL for their database solution.

Thieutje 02-08-2006 02:04 PM

Quote:

Originally Posted by trilljester
Who's doing your database hosting? It's possible that the mySQL server can't handle large amounts of traffic. It's one of the many reasons no large companies use mySQL for their database solution.

Can you please give a good webhosting website who can handle heavy traffic and is superior in SQL database implementation.

Grtz
Thieutje

Ohiosweetheart 02-08-2006 03:45 PM

Quote:

Originally Posted by trilljester
Where's the mySQL error code? How many users do you normally get hitting your site/arcade? I had a zerg rush of users once in my arcade of close to 75 users, and it never had any database problems. Who's doing your database hosting? It's possible that the mySQL server can't handle large amounts of traffic. It's one of the many reasons no large companies use mySQL for their database solution.

NO larger companies use MySQL for their database solution? I'm not sure where you get your information, but nearly every single large host that I know of uses mySQL.

I don't have a large site, and there were only 3 people in the arcade when the database went down.

Anyway, the situation has been corrected and I may try this arcade again.

fly 02-08-2006 03:57 PM

Quote:

Originally Posted by Ohiosweetheart
NO larger companies use MySQL for their database solution? I'm not sure where you get your information, but nearly every single large host that I know of uses mySQL.

I don't have a large site, and there were only 3 people in the arcade when the database went down.

Anyway, the situation has been corrected and I may try this arcade again.

What was the problem?

trilljester 02-08-2006 05:14 PM

Quote:

Originally Posted by Ohiosweetheart
NO larger companies use MySQL for their database solution? I'm not sure where you get your information, but nearly every single large host that I know of uses mySQL.

I don't have a large site, and there were only 3 people in the arcade when the database went down.

Anyway, the situation has been corrected and I may try this arcade again.

Not going to get into a database war here, I just know there's a reason why so many large companies choose Oracle or other commercial offerings over mySQL. If your hosting offered mySQL or Oracle, which would you take?

Anyways, good to see you got your problem solved. What was the issue?

Ohiosweetheart 02-08-2006 06:54 PM

Quote:

Originally Posted by trilljester
Not going to get into a database war here, I just know there's a reason why so many large companies choose Oracle or other commercial offerings over mySQL. If your hosting offered mySQL or Oracle, which would you take?

Anyways, good to see you got your problem solved. What was the issue?

LOL... there is no database war. I have no idea what Oracle is, as every single host I've checked into offers mySQL, so I wouldn't know anything about Oracle.

Actually my problem isn't solved.... I just tried to install this arcade again and my site crashed again. SO this is out for me.

trilljester 02-08-2006 06:56 PM

Yeah, it's not a bad idea for hosting companies to offer mySQL to their customers. It's free and works for most of their customer's applications. Hell, I use it on my site for that very reason. I'd only go to a commercial solution if the traffic on my site got to the point where mySQL can't handle it anymore. Not that it would ever happen, but if it does, there's that option.

Can you post the full error message so we can help troubleshoot? I'm not sure what's going on, it might be a simple setup issue.

Ohiosweetheart 02-08-2006 06:57 PM

Quote:

Originally Posted by flypaper
What was the problem?

no idea... as I just tried to install the arcade again and my site crashed again. Obviously there's something about the arcade that's conflicting with my databases


All times are GMT. The time now is 05:14 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.06193 seconds
  • Memory Usage 1,846KB
  • 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
  • (24)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
  • (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