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)

Littlebit 07-26-2004 06:59 PM

weird. And all the other vB pages are fine?

amykhar 07-26-2004 07:00 PM

Quote:

Originally Posted by Littlebit
weird. And all the other vB pages are fine?

Yep. And she's not having problems when she uses a Windows computer.

Celtic_Mad 07-27-2004 06:32 PM

I had arcade working on 3.0.1. I upgraded to 3.0.3 and was making changes to the files until I got to functions_showthread.php, there is no '// ###################### Start getreputationimage #######################' What do I do?

Malacia 07-28-2004 12:18 AM

Edit : Sorry, i'm an idiot.

Ordovicium 07-28-2004 10:00 PM

I just update to vb3.0.3 and I get an error when I will start the arcade:
Code:

Database error in vBulletin 3.0.3:

Invalid SQL: UPDATE games SET bse=88000,bseid=3344,bsefinish=1085163162 WHERE shortname='ablast'
mysql error: Unknown column 'bse' in 'field list'

mysql error number: 1054

Date: Thursday 29th of July 2004 12:59:59 AM
Script: http://www.informatik-forum.at/arcade.php?
Referer: http://www.informatik-forum.at/
Username: Ordovicium
IP Address: **********

I hope you can help me
Thanks a lot.

flstreetscene 07-29-2004 03:50 AM

Arcade still not working...

Could you double check if I'm doing everything right?

I've deleted all my template additions, and reverted all documents to original 3.0.3 settings. As the instruction on v3arcade.com say I've deleted the following tables from my database (zeno_forums):

==========================================
gamechallenges
gamenews
games
gamesessions

the database table "datastore", browse it and find the titles "arcadesettings" and "scoresettings" - delete them both.
==========================================

I've also updated my install_arcade.php document where it asks me to change the '$styleid=' value to the proper style id (in this case $styleid=10;)

I then proceed to the 'http://www.floridastreetscene.com/forums/admincp/install_arcade.php' page to start installing the arcade. When I get to the 'Database Modifications' step I get the following...

==========================================
Database error in vBulletin 3.0.3:

Invalid SQL:
CREATE TABLE gamechallenges (
challengeid int(10) unsigned NOT NULL auto_increment,
type tinyint(1) unsigned NOT NULL default '0',
challengerid int(10) unsigned NOT NULL default '0',
challengedid int(10) unsigned NOT NULL default '0',
game varchar(30) NOT NULL default '',
status tinyint(1) unsigned NOT NULL default '0',
datestamp int(13) unsigned NOT NULL default '0',
challengersession int(20) unsigned NOT NULL default '0',
challengedsession int(20) unsigned NOT NULL default '0',
PRIMARY KEY (challengeid)
) TYPE=MyISAM

mysql error: Table 'gamechallenges' already exists

mysql error number: 1050

Date: Thursday 29th of July 2004 04:40:45 AM
Script: http://www.floridastreetscene.com/fo...all_arcade.php
Referer:
Username: zeno
IP Address: 64.8.219.569
==========================================

...but I am certain that those table were dropped. It seems they are restored or not deleted properly?

Once I figure this out I guess I've fixed my arcade.

Thanks!

EDIT: Ok it seems eventhough the installation didn't seem to go through completly my arcade (http://www.floridastreetscene.com/forums/arcade.php?) is still up and functioning... however as you can see the image path's are screwed as they are pointing to my forums root. I am pretty sure why this is happening; I've skipped the modification to my i'ncludes/functions.php' as that caused my forums stop responding. Is there any way to get around this conflict?

dina 07-30-2004 10:37 AM

I'm waiting to upgrade to 3.0.3 until most of the mods I use have been upgraded. I've read through the last pages of this thread and notice a few problems.
Can we get any hints on when the author is going to update the mod to work for 3.0.3? As in, realise an official installation file for 3.0.3.

SnowBot 07-30-2004 10:47 AM

Quote:

Originally Posted by dina
I'm waiting to upgrade to 3.0.3 until most of the mods I use have been upgraded. I've read through the last pages of this thread and notice a few problems.
Can we get any hints on when the author is going to update the mod to work for 3.0.3? As in, realise an official installation file for 3.0.3.

I run the arcade on 3.0.3 and had no probs at all, if its installed correctly then your fine. As for John updating it, well he has been away and not active on his own site due to work load so dont expect it soon.

SK 07-30-2004 11:52 AM

Quote:

Originally Posted by SnowBot
I run the arcade on 3.0.3 and had no probs at all, if its installed correctly then your fine. As for John updating it, well he has been away and not active on his own site due to work load so dont expect it soon.

Read the top two posts. This is the only thing thats wrong in 3.0.3 I found.

https://vborg.vbsupport.ru/showthrea...page=171&pp=15

MissKalunji 07-30-2004 04:40 PM

Quote:

Originally Posted by dina
I'm waiting to upgrade to 3.0.3 until most of the mods I use have been upgraded. I've read through the last pages of this thread and notice a few problems.
Can we get any hints on when the author is going to update the mod to work for 3.0.3? As in, realise an official installation file for 3.0.3.


YEp i installed it on vb 3.0.3 and it works perfectly....too

Warlord 07-31-2004 01:44 AM

Ok, after I read up on the last few pages I got it to work (seemingly) perfect on 3.0.3.

Great hack folks!

palerider 07-31-2004 07:50 AM

Quote:

Originally Posted by MaDCaT75
would you miss me if I killed myself too?

Nope, but go for it anyway Antioch

Barrikin 07-31-2004 02:17 PM

I'm running it on Vb303 Everything works good but the postbit.

Any clue why?

sarge0087 07-31-2004 02:57 PM

Does anyone have a solution to my problem?

sarge0087 08-02-2004 03:44 AM

What does extendsession do?

John 08-02-2004 06:45 PM

Updated the instructions to work with vBulletin 3.0.3, for those installing for the first time.

sarge0087 - extendsession prolongs the session of a user in vBulletin during gameplay, to stop them from being logged out automatically after they've been playing a game. (Which happens if a user isn't using cookies, for example.)

sarge0087 08-03-2004 12:14 AM

What exactly changed in the instructions?

Limey-YMR 08-03-2004 03:31 AM

Quote:

Originally Posted by eskay
Read the top two posts. This is the only thing thats wrong in 3.0.3 I found.

https://vborg.vbsupport.ru/showthrea...page=171&pp=15

I had a post to fix that prob the day after 3.0.3 came out -
https://vborg.vbsupport.ru/showpost....postcount=2448
(I installed 3.0.3 on a 900+ user live forum 1 hour after release!) <-- sucker for punishment!

Coyote75 08-03-2004 08:01 AM

how does one create the table?

lierduh 08-07-2004 03:22 AM

A mini hack to have the trophies displayed in two columns. With more and more games added, the forum members who have a lot of trophies can cause plenty of vertical space in the post header area, especially for forums using the new postbit. This mini-hack will display the trophies in two columns, put into consideration of even or odd number of trophies.


includes/functions_showthread.php

Find this

PHP Code:

    if ($arcadegeneral['awardson']==1) {
        foreach (
$awards as $key => $award) {
            if (
$award['userid']==$post['userid']) {
                eval(
'$post[\'arcadeawards\'] .= "' fetch_template('arcade_awards_bit') . '";');
            }
        }
    } 

Above code was inserted as the standard installation, replace it with

PHP Code:

        if ($arcadegeneral['awardson']==1) {
                if (!empty(
$awards))
                {
                        
$c 1;
                        
$post['arcadeawards'] = '<td width="100%"><table>';
                        foreach (
$awards as $key => $award) {
                                if (
$award['userid']==$post['userid']) {
                                        eval(
'$post[\'arcadeawards\'] .= "' fetch_template('arcade_awards_bit') . '";');
                                        
$c++;
                                }

                        }
                        
$c++;
                        if (
$c 2) {
                                
$post['arcadeawards'] .= "<td>&nbsp;</td></tr>";
                        }
                        
$post['arcadeawards'] = $post['arcadeawards'] . "</table></td>";
                }
        } 

(note the above code includes html tags, they should really be put into a template. So please regard this mini-hack as the quick and dirty hack)

Change arcade_awards_bit template to:

PHP Code:

<if condition="$c % 2"><tr>
<
td><if condition="$award[icon]!=''"><a href="arcade.php?do=play&gameid=$award[gameid]"><img src="$stylevar[imgdir_arcade]/$award[icon]alt="High Score: $award[highscore]align="absmiddle" border=0></a> </if><span class="smallfont">$award[gametitleChampion!</span></td>
<else />
<
td><if condition="$award[icon]!=''"><a href="arcade.php?do=play&gameid=$award[gameid]"><img src="$stylevar[imgdir_arcade]/$award[icon]alt="High Score: $award[highscore]align="absmiddle" border=0></a> </if><span class="smallfont">$award[gametitleChampion!</span></td></tr></if> 

Have I missed anything? I forgot about the way I implemented originally after upgrading to v3.0.3, so I had to restart again. Above are the notes I put down. I hope I have not missed anything.

armkbdotcom 08-07-2004 08:36 AM

I wonder if there is some modification to make Arcade main page game listing in two columns. Most of the people do not actually notice page navigation down there and thinking that the first page is all we have.

Cheers!

jpt62089 08-07-2004 09:40 AM

just installed on my fresh VB... I dont have permission to access the arcade... I checked the group settings and they are go...

Please be easy on my :p this is my first VB mod! :ninja:

trackpads 08-07-2004 09:59 AM

Quote:

Originally Posted by armkbdotcom
I wonder if there is some modification to make Arcade main page game listing in two columns. Most of the people do not actually notice page navigation down there and thinking that the first page is all we have.

Cheers!

That is a great idea! I like this better than the category mod. Shouldnt be more than a template edit right?

lierduh 08-08-2004 05:29 AM

Quote:

Originally Posted by trackpads
That is a great idea! I like this better than the category mod. Shouldnt be more than a template edit right?

Herhaps adding a navigation bar at the top of the game list can be more effecitve.

Just modify "arcade_main" template.

Add these two lines before the block of code below:

<span class="smallfont"><br></span>
$pagenav
PHP Code:

<!-- small space --> 
<
span class="smallfont"><br
</
span
<!-- /
small space --> 
<!-- 
games  --> 
<
table cellpadding="$stylevar[outerborderwidth]cellspacing="0" 


jpt62089 08-08-2004 06:57 AM

Quote:

Originally Posted by jpt62089
just installed on my fresh VB... I dont have permission to access the arcade... I checked the group settings and they are go...

Please be easy on my :p this is my first VB mod! :ninja:

Bump :)

armkbdotcom 08-08-2004 07:04 AM

Quote:

Originally Posted by lierduh
Herhaps adding a navigation bar at the top of the game list can be more effecitve.

Just modify "arcade_main" template.

Add these two lines before the block of code below:

<span class="smallfont"><br></span>
$pagenav
PHP Code:

<!-- small space --> 
<
span class="smallfont"><br
</
span
<!-- /
small space --> 
<!-- 
games  --> 
<
table cellpadding="$stylevar[outerborderwidth]cellspacing="0" 


Still not what we wanted. Lot of space from the right is wasted.

Spinball 08-08-2004 10:16 AM

Hi Folks,
I have just upgraded from vbulletin 3.0.1 to 3.0.3.
Having previously had 1.0.0 of this hack installed, I am slightly confused as to what I need to do to bring it up to 1.0.2.
I have gone through and put all the code changes in.
All the templates seem to be the same so I haven't changed any of those.
But I'm worried about running forumroot/admincp/install_arcade.php incase it overwrites any database information allready there.
Can you please confirm whether I need to run this again or not?

Also I have several tables in the database from the vB2 installation :

arcadeconfig, arcadegames, arcadescoregroups, arcadescores and arcadetopscores

am I right in assuming these are no longer used and I can delete all of them?
Thanks

dethfire 08-08-2004 03:06 PM

this hack worked great for a few months , now suddendly I get this error everytime members visit the arcade:

Code:


Database error in vBulletin 3.0.1:

Invalid SQL:
                                        SELECT games.title, games.gameid AS gameid, gamesessions.*,user.username FROM gamesessions AS gamesessions
                                        LEFT JOIN user AS user ON gamesessions.userid = user.userid
                                        LEFT JOIN games AS games ON gamesessions.gamename = games.shortname
                                        WHERE gamesessions.valid=1 AND gamesessions.sessiontype=1 ORDER BY gamesessions.finish DESC
                               
mysql error: Got error 127 from table handler

mysql error number: 1030

Script: http://www.cool-teens.com/forum/arcade.php?


Pseudomizer 08-08-2004 03:09 PM

Quote:

Originally Posted by dethfire
this hack worked great for a few months , now suddendly I get this error everytime members visit the arcade:

Code:


Database error in vBulletin 3.0.1:

Invalid SQL:
                                        SELECT games.title, games.gameid AS gameid, gamesessions.*,user.username FROM gamesessions AS gamesessions
                                        LEFT JOIN user AS user ON gamesessions.userid = user.userid
                                        LEFT JOIN games AS games ON gamesessions.gamename = games.shortname
                                        WHERE gamesessions.valid=1 AND gamesessions.sessiontype=1 ORDER BY gamesessions.finish DESC
                               
mysql error: Got error 127 from table handler

mysql error number: 1030

Script: http://www.cool-teens.com/forum/arcade.php?


Perhaps your table has been corrupted. Try to repair the table and it should work again.

Cheers,

evilTone 08-10-2004 08:56 PM

Code:

Database error in vBulletin 3.0.3:

Invalid SQL:
                SELECT gamesessions.*, user.username, user.userid, games.*, games.title AS title FROM gamesessions AS gamesessions
                LEFT JOIN user AS user ON user.userid = gamesessions.userid
                LEFT JOIN games AS games ON gamesessions.gamename = games.shortname
                WHERE (gamename='asteroids' AND score='7210') AND sessiontype=1 ORDER BY gamesessions.gamename DESC
       
mysql error: Column: 'score' in where clause is ambiguous

mysql error number: 1052

any ideas ?
if i clear the table 'gamesessions', then it works for a short time, around 2-3 games then this error comes back.
error also goes away if i 'reset public scores'

i tried the "repair table" option mentioned above also :/

trackpads 08-11-2004 01:13 AM

Quote:

Originally Posted by armkbdotcom
Still not what we wanted. Lot of space from the right is wasted.

**bump** :-)

Areku 08-11-2004 10:34 AM

176 pages! Holy cow!

Has any1 work around a "bug"? that displays "g:ia M j" on the TIME column (not the LENGTH one) instead of the time?

Thanks!

Areku 08-12-2004 05:59 AM

I've just installed this AWESOMELYGREAT hack and I'd like to make note to John about certain things we'd love to see in the package:

- Game setup instructions: once you have arcade up and running, how do you add new games? that's not covered on the .txts on the package ;)

- the fact of multilingual boards, ie. ease of translations, ie. keep languages off of the arcade.php file ;)

- some way of challenge your users from profile or list of members or direct input of some sort. If u set it up with default values, the arcade won't let you challenge any1 unless he has played on some game before, righT?

Areku 08-12-2004 06:00 AM

Quote:

Originally Posted by Socrate
hello all :)

everything works well except only one thing, I have always the date like this in the scores:

PHP Code:

g:ia M J 

it is not posted, have an idea please?


Same problem here, and i just installed it!

Did u solve it Socrate?

Any1?

Thanks!

jpt62089 08-12-2004 06:28 PM

Quote:

Originally Posted by jpt62089
just installed on my fresh VB... I dont have permission to access the arcade... I checked the group settings and they are go...

Please be easy on my :p this is my first VB mod! :ninja:

nvm i got it fixed...

Battle_Ring 08-13-2004 03:37 AM

Very Easily Installed...Great Hack...

Areku 08-13-2004 05:10 AM

Quote:

Originally Posted by jpt62089
nvm i got it fixed...

how did u fix it, jpt62089?

trackpads 08-15-2004 09:13 AM

I had an idea about adding regular (unconverted) games to the arcade. I think this would be a great idea and would open the Arcade to thousands of legal games like the ones from miniclip which cant be converted.

http://www.v3arcade.com/play/showthread.php?p=12045

What do you guys think?

Swanny231 08-15-2004 08:09 PM

I am having problems with the group premissions
here is what I did.
(Parse error: parse error in /var/www/html/forums/admincp/usergroup.php on line 846)
usergroup.php
PHP Code:

print_table_header($vbphrase['general_permissions']);
    
print_yes_no_row($vbphrase['can_see_invisible_users'], 'usergroup[canseehidden]'$ug_bitfield['canseehidden']);
    
print_yes_no_row($vbphrase['can_view_member_info'], 'usergroup[canviewmembers]'$ug_bitfield['canviewmembers']);
    
print_yes_no_row($vbphrase['can_edit_own_profile'], 'usergroup[canmodifyprofile]'$ug_bitfield['canmodifyprofile']);
    
print_yes_no_row($vbphrase['can_set_self_invisible'], 'usergroup[caninvisible]'$ug_bitfield['caninvisible']);
    
print_yes_no_row($vbphrase['show_edited_by_note_on_edited_messages'], 'usergroup[showeditedby]'$ug_bitfield['showeditedby']);
    
print_yes_no_row($vbphrase['can_use_custom_title'], 'usergroup[canusecustomtitle]'$ug_bitfield['canusecustomtitle']);
    
print_yes_no_row($vbphrase['can_use_signatures'], 'usergroup[canusesignature]'$ug_bitfield['canusesignature']);
    
print_yes_no_row($vbphrase['can_view_others_profile_pictures'], 'usergroup[canseeprofilepic]'$ug_bitfield['canseeprofilepic']);
    
print_yes_no_row($vbphrase['can_view_hidden_custom_fields'], 'usergroup[canseehiddencustomfields]'$ug_bitfield['canseehiddencustomfields']);
    
print_table_break();
    
print_column_style_code(array('width: 70%''width: 30%'));

    
print_table_header("Arcade Permissions");
    
print_yes_no_row("Can View the Arcade? <dfn>Allows usergroup to view the arcade, including high scores and leaderboards</dfn>"'usergroup[canviewarcade]'$ug_bitfield['canviewarcade']);
    
print_yes_no_row("Can Play Games in the Arcade? <dfn>Allows usergroup to play arcade games</dfn>"'usergroup[canplayarcade]'$ug_bitfield['canplayarcade']);
    
print_yes_no_row("Can Post Comments? <dfn>Allows usergroup to post comments when they achieve a high score</dfn>"'usergroup[canmakecomments]'$ug_bitfield['canmakecomments']);
    
print_yes_no_row("Can Edit Leaderboard Comments? <dfn>Allows usergroup to edit comments left by other members</dfn>"'usergroup[caneditscores]'$ug_bitfield['caneditscores']);
    
print_yes_no_row("Can Delete Leaderboard Scores? <dfn>Allows usergroup to delete scores and comments left by other members</dfn>"'usergroup[candelscores]'$ug_bitfield['candelscores']);
    
print_table_break();
        
print_column_style_code(array('width: 70%''width: 30%'));

    
print_table_header($vbphrase['forum_viewing_permissions']);
    
print_yes_no_row($vbphrase['can_view_board'], 'usergroup[canview]'$ug_bitfield['canview']);
    
print_yes_no_row($vbphrase['can_view_others_threads'], 'usergroup[canviewothers]'$ug_bitfield['canviewothers']);
    
print_yes_no_row($vbphrase['can_see_deletion_notices'], 'usergroup[canseedelnotice]'$ug_bitfield['canseedelnotice']);
    
print_yes_no_row($vbphrase['can_search_forums'], 'usergroup[cansearch]'$ug_bitfield['cansearch']);
    
print_yes_no_row($vbphrase['can_use_email_to_friend'], 'usergroup[canemail]'$ug_bitfield['canemail']);
    
print_yes_no_row($vbphrase['can_download_attachments'], 'usergroup[cangetattachment]'$ug_bitfield['cangetattachment']);
    
print_table_break();
    
print_column_style_code(array('width: 70%''width: 30%')); 


Swanny231 08-15-2004 09:39 PM

How to install new games ????? I dont have the install games tab in the arcade settings ?

As for my above post I just removed the hack on the usergroup and went into my sql and did the permissions manually :(


All times are GMT. The time now is 09:35 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.03967 seconds
  • Memory Usage 1,922KB
  • 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_code_printable
  • (7)bbcode_php_printable
  • (15)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