v3 Arcade - Games Arcade System for 3.6.0

[Drix]

Still haven't found any solution to my problem. Can't fint the line

<td class="vbmenu_control"><a href="calendar.php$session[sessionurl_q]">$vbphrase[calendar]</a></td>

in my navbar template, I guess because navbar is already changed by the skin i am using, Indevor.

Is there a way to make it work with this skin, or do i have to remove it to make arcade work?

[ConqSoft]

You can add the link anywhere on your navbar that you like. That's just an example of where you can place it.

[midaph]

woah looks way better than ipb(no offense) but do i need to uninstall ibp to have this one or can i just disable ibp? Are the games for v3 .tar or .zip??

[Drix]

But in this style the navbar is completely changed, as you can se here https://vborg.vbsupport.ru/showthread.php?t=99450

so i don't know where to put it? This is how my navbar template looks now:

<script type="text/javascript">
<!--
function log_out()
{
ht = document.getElementsByTagName("html");
ht[0].style.filter = "progid:DXImageTransform.Microsoft.BasicImage(grays cale=1)";
if (confirm('$vbphrase[sure_you_want_to_log_out]'))
{
return true;
}
else
{
ht[0].style.filter = "";
return false;
}
}
//-->
</script>

<br />
<!--Table Border2-->
<table width="100%" border="0" cellspacing="0" cellpadding="0"><tr>
<td height="6" class="bg_tbfoot">
<img src="$stylevar[imgdir_misc]/images/spacer.gif" width="100%" height="6" alt="Indevor"></td>
</tr><tr><td>

<!-- breadcrumb, login, pm info -->
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
<td class="alt1" width="100%">
<if condition="is_array($navbits)">
<table cellpadding="0" cellspacing="0" border="0">
<tr valign="bottom">
<td><a href="#" onclick="history.back(1); return false;"><img src="$stylevar[imgdir_misc]/navbits_start.gif" alt="$vbphrase[go_back]" border="0" /></a></td>
<td>&nbsp;</td>
<td width="100%"><span class="navbar"><a href="$vboptions[forumhome].php$session[sessionurl_q]" accesskey="1">$vboptions[bbtitle]</a></span> $navbits[breadcrumb]</td>
</tr>
<tr>
<td class="navbar" style="font-size:10pt; padding-top:1px" colspan="3"><a href="$scriptpath"><img class="inlineimg" src="$stylevar[imgdir_misc]/navbits_finallink.gif" alt="$vbphrase[reload_this_page]" border="0" /></a> <strong>$navbits[lastelement]</strong></td>
</tr>
</table>
<else />
<div class="navbar" style="font-size:10pt"><a href="$vboptions[forumhome].php$session[sessionurl_q]" accesskey="1"><img class="inlineimg" src="$stylevar[imgdir_misc]/navbits_start.gif" alt="" border="0" /></a> <strong>$vboptions[bbtitle]</strong></div>
</if>
</td>

<if condition="$bbuserinfo['userid']">

<td class="alt2" valign="top" nowrap="nowrap">
<div class="smallfont">
<strong><phrase 1="$bbuserinfo[username]">$vbphrase[welcome_x]</phrase></strong><br />
<phrase 1="$pmbox[lastvisitdate]" 2="$pmbox[lastvisittime]">$vbphrase[last_visited_x_at_y]</phrase>
<if condition="$show['pmstats']"><br /><phrase 1="$vbphrase[unread_x_nav_compiled]" 2="$vbphrase[total_x_nav_compiled]" 3="$session[sessionurl_q]">$vbphrase[private_messages_nav]</phrase></if>
</div>
</td>

<else />

<td class="alt2" nowrap="nowrap" style="padding:0px">

<!-- login form -->
<form action="login.php" method="post" onsubmit="md5hash(vb_login_password, vb_login_md5password, vb_login_md5password_utf, $show[nopasswordempty])">
<script type="text/javascript" src="clientscript/vbulletin_md5.js"></script>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
<tr>
<td class="smallfont">$vbphrase[username]</td>
<td><input type="text" class="bginput" style="font-size: 11px" name="vb_login_username" id="navbar_username" size="10" accesskey="u" tabindex="101" value="$vbphrase[username]" onfocus="if (this.value == '$vbphrase[username]') this.value = '';" /></td>
<td class="smallfont" colspan="2" nowrap="nowrap"><label for="cb_cookieuser_navbar"><input type="checkbox" name="cookieuser" value="1" tabindex="103" id="cb_cookieuser_navbar" accesskey="c" />$vbphrase[remember_me]</label></td>
</tr>
<tr>
<td class="smallfont">$vbphrase[password]</td>
<td><input type="password" class="bginput" style="font-size: 11px" name="vb_login_password" size="10" accesskey="p" tabindex="102" /></td>
<td><input type="submit" class="button" value="$vbphrase[log_in]" tabindex="104" title="$vbphrase[enter_username_to_login_or_register]" accesskey="s" /></td>
</tr>
</table>
<input type="hidden" name="s" value="$session[sessionhash]" />
<input type="hidden" name="do" value="login" />
<input type="hidden" name="vb_login_md5password" />
<input type="hidden" name="vb_login_md5password_utf" />
</form>
<!-- / login form -->

</td>

</if>

</tr>
</table>
<!-- / breadcrumb, login, pm info -->

</td></tr>
<tr><td height="6" class="bg_tbfoot">
<img src="$stylevar[imgdir_misc]/images/spacer.gif" width="100%" height="6" alt="Indevor"></td>
</tr></table>
<!--End Table Border2-->

<br />
<if condition="$show['forumdesc']">
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
<td class="alt1" width="100%"><strong>$foruminfo[title]</strong> <span class="smallfont">$foruminfo[description]</span></td>
</tr>
</table>
<br />
</if>

<if condition="$show['popups']">
<!-- NAVBAR POPUP MENUS -->

<if condition="$show['searchbuttons']">
<!-- header quick search form -->
<div class="vbmenu_popup" id="navbar_search_menu" style="display:none">
<table cellpadding="4" cellspacing="1" border="0">
<tr>
<td class="thead">$vbphrase[search_forums]</td>
</tr>
<tr>
<td class="vbmenu_option" title="nohilite">
<form action="search.php" method="post">
<input type="hidden" name="do" value="process" />
<input type="hidden" name="showposts" value="0" />
<input type="hidden" name="quicksearch" value="1" />
<input type="hidden" name="s" value="$session[sessionhash]" />
<input type="text" class="bginput" name="query" size="20" />$gobutton<br />
</form>
</td>
</tr>
<tr>
<td class="vbmenu_option"><a href="search.php$session[sessionurl_q]" accesskey="4" rel="nofollow">$vbphrase[advanced_search]</a></td>
</tr>
</table>
</div>
<!-- / header quick search form -->
</if>

<if condition="$show['member']">
<!-- user cp tools menu -->
<div class="vbmenu_popup" id="usercptools_menu" style="display:none">
<table cellpadding="4" cellspacing="1" border="0">

<tr><td class="thead">$vbphrase[quick_links]</td></tr>
<if condition="$vboptions['enablesearches']"><tr><td class="vbmenu_option"><a href="search.php?$session[sessionurl]do=getdaily">$vbphrase[todays_posts]</a></td></tr></if>
<tr><td class="vbmenu_option"><a href="forumdisplay.php?$session[sessionurl]do=markread">$vbphrase[mark_forums_read]</a></td></tr>
<tr><td class="vbmenu_option"><a href="#" onclick="window.open('misc.php?$session[sessionurl]do=buddylist&amp;focus=1','buddylist','statusbar=no,me nubar=no,toolbar=no,scrollbars=yes,resizable=yes,w idth=250,height=300'); return false;">$vbphrase[open_buddy_list]</a></td></tr>

<tr><td class="thead"><a href="usercp.php$session[sessionurl_q]">$vbphrase[user_control_panel]</a></td></tr>
<if condition="$show['siglink']"><tr><td class="vbmenu_option"><a href="profile.php?$session[sessionurl]do=editsignature">$vbphrase[edit_signature]</a></td></tr></if>
<!--<if condition="$show['avatarlink']"><tr><td class="vbmenu_option"><a href="profile.php?$session[sessionurl]do=editavatar">$vbphrase[edit_avatar]</a></td></tr></if>-->
<tr><td class="vbmenu_option"><a href="profile.php?$session[sessionurl]do=editprofile">$vbphrase[edit_profile]</a></td></tr>
<tr><td class="vbmenu_option"><a href="profile.php?$session[sessionurl]do=editoptions">$vbphrase[edit_options]</a></td></tr>

<tr><td class="thead">$vbphrase[miscellaneous]</td></tr>
<if condition="$show['pmstats']"><tr><td class="vbmenu_option"><a href="private.php$session[sessionurl_q]">$vbphrase[private_messages]</a></td></tr></if>
<tr><td class="vbmenu_option"><a href="subscription.php$session[sessionurl_q]">$vbphrase[subscribed_threads]</a></td></tr>
<tr><td class="vbmenu_option"><a href="member.php?$session[sessionurl]u=$bbuserinfo[userid]">$vbphrase[my_profile]</a></td></tr>
<if condition="$show['wollink']"><tr><td class="vbmenu_option"><a href="online.php$session[sessionurl_q]">$vbphrase[whos_online]</a></td></tr></if>

</table>
</div>
<!-- / user cp tools menu -->
</if>
<!-- / NAVBAR POPUP MENUS -->

<!-- PAGENAV POPUP -->

<div class="vbmenu_popup" id="pagenav_menu" style="display:none">
<table cellpadding="4" cellspacing="1" border="0">
<tr>
<td class="thead" nowrap="nowrap">$vbphrase[go_to_page]</td>
</tr>
<tr>
<td class="vbmenu_option" title="nohilite">
<form action="$vboptions[forumhome].php" method="get" onsubmit="return this.gotopage()" id="pagenav_form">
<input type="text" class="bginput" id="pagenav_itxt" style="font-size:11px" size="4" />
<input type="button" class="button" id="pagenav_ibtn" value="$vbphrase[go]" />
</form>
</td>
</tr>
</table>
</div>

<!-- / PAGENAV POPUP -->
</if>

[Drix]

Sorry about the big post, but i have tried to put it several places, but it doesn't seem to work. I'm no good at reading code.

[Maagic]

Any word on when a updated version is going out?

[Joe Gronlund]

I get

-----------
you do not have permission to access this page. This could be due to one of several reasons:

Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.
-----------

when trying to access the arcade page on the navbar, does anyone know what could be wrong?

[PsiNyde]

any idea what's causing the user info being pushed to the right?

http://americanboxer.tv/forums/showthread.php?t=63

[Maagic]

I get

-----------
you do not have permission to access this page. This could be due to one of several reasons:

Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.
-----------

when trying to access the arcade page on the navbar, does anyone know what could be wrong?


Check your usergroup permissions in the adminCP and make sure you have it set to view the arcade

[Joe Gronlund]

Check your usergroup permissions in the adminCP and make sure you have it set to view the arcade

Thanks, that was it :)

[Mastar]

Still haven't found any solution to my problem. Can't fint the line

<td class="vbmenu_control"><a href="calendar.php$session[sessionurl_q]">$vbphrase[calendar]</a></td>

in my navbar template, I guess because navbar is already changed by the skin i am using, Indevor.

Is there a way to make it work with this skin, or do i have to remove it to make arcade work?

Try searching for calender or "<a href="calendar.php$session or $vbphrase[calendar] in the navbar.

[Drix]

That's the weird thing, i can't even find the word calendar in my navbar template, but it's in my navbar on the forum.

[Sal Collaziano]

Installation didn't work out for me (I had "arcade" tables in the database from an old installation) and it got really mangled.. In order to uninstall, I needed to add the arcade_games table.. That's all I know how to do. The next step would be to add a "isreverse" column but I don't know how to do that. Here's the error I'm getting:

Database error in vBulletin 3.5.1:

Invalid SQL:
ALTER TABLE arcade_games DROP isreverse;

MySQL Error : Can't DROP 'isreverse'. Check that column/key exists
Error Number : 1091
Date : Sunday, November 27th 2005 @ 10:10:12 AM
Script : http://www.mysite.com/forums/admincp/plugin.php
Referrer : http://www.mysite.com/forums/adminc...tid=v3arcade&s=

I'm guessing that even if I could add that column, there would be other columns.. How can I completely uninstall this system so that I can reinstall it cleanly?

Thank you...

[PsiNyde]

Sorry about the big post, but i have tried to put it several places, but it doesn't seem to work. I'm no good at reading code.

go to Style Manager -> Edit Templates [from drop down]
scroll down to Navigation / Breadcrumb Templates
double click to expand, the double click navbar to edit.

try looking for this in the navbar template:
<td class="vbmenu_control"><a href="login.php?$session[sessionurl]do=logout&amp;u=$bbuserinfo[userid]" onclick="return log_out()">$vbphrase[log_out]</a></td>

and add this above it:
<td class="vbmenu_control"><a href="arcade.php$session[sessionurl_q]">Arcade</a></td>

that will place the link directly to the left of the logout button, but will only appear if the user is logged in...making it available for members only.

[Mastar]

But in this style the navbar is completely changed, as you can se here https://vborg.vbsupport.ru/showthread.php?t=99450

so i don't know where to put it? This is how my navbar template looks now:

<script type="text/javascript">
<!--
function log_out()
{
ht = document.getElementsByTagName("html");
ht[0].style.filter = "progid:DXImageTransform.Microsoft.BasicImage(grays cale=1)";
if (confirm('$vbphrase[sure_you_want_to_log_out]'))
{
return true;
}
else
{
ht[0].style.filter = "";
return false;
}
}
//-->
</script>

<br />
<!--Table Border2-->
<table width="100%" border="0" cellspacing="0" cellpadding="0"><tr>
<td height="6" class="bg_tbfoot">
<img src="$stylevar[imgdir_misc]/images/spacer.gif" width="100%" height="6" alt="Indevor"></td>
</tr><tr><td>

<!-- breadcrumb, login, pm info -->
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
<td class="alt1" width="100%">
<if condition="is_array($navbits)">
<table cellpadding="0" cellspacing="0" border="0">
<tr valign="bottom">
<td><a href="#" onclick="history.back(1); return false;"><img src="$stylevar[imgdir_misc]/navbits_start.gif" alt="$vbphrase[go_back]" border="0" /></a></td>
<td>&nbsp;</td>
<td width="100%"><span class="navbar"><a href="$vboptions[forumhome].php$session[sessionurl_q]" accesskey="1">$vboptions[bbtitle]</a></span> $navbits[breadcrumb]</td>
</tr>
<tr>
<td class="navbar" style="font-size:10pt; padding-top:1px" colspan="3"><a href="$scriptpath"><img class="inlineimg" src="$stylevar[imgdir_misc]/navbits_finallink.gif" alt="$vbphrase[reload_this_page]" border="0" /></a> <strong>$navbits[lastelement]</strong></td>
</tr>
</table>
<else />
<div class="navbar" style="font-size:10pt"><a href="$vboptions[forumhome].php$session[sessionurl_q]" accesskey="1"><img class="inlineimg" src="$stylevar[imgdir_misc]/navbits_start.gif" alt="" border="0" /></a> <strong>$vboptions[bbtitle]</strong></div>
</if>
</td>

<if condition="$bbuserinfo['userid']">

<td class="alt2" valign="top" nowrap="nowrap">
<div class="smallfont">
<strong><phrase 1="$bbuserinfo[username]">$vbphrase[welcome_x]</phrase></strong><br />
<phrase 1="$pmbox[lastvisitdate]" 2="$pmbox[lastvisittime]">$vbphrase[last_visited_x_at_y]</phrase>
<if condition="$show['pmstats']"><br /><phrase 1="$vbphrase[unread_x_nav_compiled]" 2="$vbphrase[total_x_nav_compiled]" 3="$session[sessionurl_q]">$vbphrase[private_messages_nav]</phrase></if>
</div>
</td>

<else />

<td class="alt2" nowrap="nowrap" style="padding:0px">

<!-- login form -->
<form action="login.php" method="post" onsubmit="md5hash(vb_login_password, vb_login_md5password, vb_login_md5password_utf, $show[nopasswordempty])">
<script type="text/javascript" src="clientscript/vbulletin_md5.js"></script>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
<tr>
<td class="smallfont">$vbphrase[username]</td>
<td><input type="text" class="bginput" style="font-size: 11px" name="vb_login_username" id="navbar_username" size="10" accesskey="u" tabindex="101" value="$vbphrase[username]" onfocus="if (this.value == '$vbphrase[username]') this.value = '';" /></td>
<td class="smallfont" colspan="2" nowrap="nowrap"><label for="cb_cookieuser_navbar"><input type="checkbox" name="cookieuser" value="1" tabindex="103" id="cb_cookieuser_navbar" accesskey="c" />$vbphrase[remember_me]</label></td>
</tr>
<tr>
<td class="smallfont">$vbphrase[password]</td>
<td><input type="password" class="bginput" style="font-size: 11px" name="vb_login_password" size="10" accesskey="p" tabindex="102" /></td>
<td><input type="submit" class="button" value="$vbphrase[log_in]" tabindex="104" title="$vbphrase[enter_username_to_login_or_register]" accesskey="s" /></td>
</tr>
</table>
<input type="hidden" name="s" value="$session[sessionhash]" />
<input type="hidden" name="do" value="login" />
<input type="hidden" name="vb_login_md5password" />
<input type="hidden" name="vb_login_md5password_utf" />
</form>
<!-- / login form -->

</td>

</if>

</tr>
</table>
<!-- / breadcrumb, login, pm info -->

</td></tr>
<tr><td height="6" class="bg_tbfoot">
<img src="$stylevar[imgdir_misc]/images/spacer.gif" width="100%" height="6" alt="Indevor"></td>
</tr></table>
<!--End Table Border2-->

<br />
<if condition="$show['forumdesc']">
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
<td class="alt1" width="100%"><strong>$foruminfo[title]</strong> <span class="smallfont">$foruminfo[description]</span></td>
</tr>
</table>
<br />
</if>

<if condition="$show['popups']">
<!-- NAVBAR POPUP MENUS -->

<if condition="$show['searchbuttons']">
<!-- header quick search form -->
<div class="vbmenu_popup" id="navbar_search_menu" style="display:none">
<table cellpadding="4" cellspacing="1" border="0">
<tr>
<td class="thead">$vbphrase[search_forums]</td>
</tr>
<tr>
<td class="vbmenu_option" title="nohilite">
<form action="search.php" method="post">
<input type="hidden" name="do" value="process" />
<input type="hidden" name="showposts" value="0" />
<input type="hidden" name="quicksearch" value="1" />
<input type="hidden" name="s" value="$session[sessionhash]" />
<input type="text" class="bginput" name="query" size="20" />$gobutton<br />
</form>
</td>
</tr>
<tr>
<td class="vbmenu_option"><a href="search.php$session[sessionurl_q]" accesskey="4" rel="nofollow">$vbphrase[advanced_search]</a></td>
</tr>
</table>
</div>
<!-- / header quick search form -->
</if>

<if condition="$show['member']">
<!-- user cp tools menu -->
<div class="vbmenu_popup" id="usercptools_menu" style="display:none">
<table cellpadding="4" cellspacing="1" border="0">

<tr><td class="thead">$vbphrase[quick_links]</td></tr>
<if condition="$vboptions['enablesearches']"><tr><td class="vbmenu_option"><a href="search.php?$session[sessionurl]do=getdaily">$vbphrase[todays_posts]</a></td></tr></if>
<tr><td class="vbmenu_option"><a href="forumdisplay.php?$session[sessionurl]do=markread">$vbphrase[mark_forums_read]</a></td></tr>
<tr><td class="vbmenu_option"><a href="#" onclick="window.open('misc.php?$session[sessionurl]do=buddylist&amp;focus=1','buddylist','statusbar=no,me nubar=no,toolbar=no,scrollbars=yes,resizable=yes,w idth=250,height=300'); return false;">$vbphrase[open_buddy_list]</a></td></tr>

<tr><td class="thead"><a href="usercp.php$session[sessionurl_q]">$vbphrase[user_control_panel]</a></td></tr>
<if condition="$show['siglink']"><tr><td class="vbmenu_option"><a href="profile.php?$session[sessionurl]do=editsignature">$vbphrase[edit_signature]</a></td></tr></if>
<!--<if condition="$show['avatarlink']"><tr><td class="vbmenu_option"><a href="profile.php?$session[sessionurl]do=editavatar">$vbphrase[edit_avatar]</a></td></tr></if>-->
<tr><td class="vbmenu_option"><a href="profile.php?$session[sessionurl]do=editprofile">$vbphrase[edit_profile]</a></td></tr>
<tr><td class="vbmenu_option"><a href="profile.php?$session[sessionurl]do=editoptions">$vbphrase[edit_options]</a></td></tr>

<tr><td class="thead">$vbphrase[miscellaneous]</td></tr>
<if condition="$show['pmstats']"><tr><td class="vbmenu_option"><a href="private.php$session[sessionurl_q]">$vbphrase[private_messages]</a></td></tr></if>
<tr><td class="vbmenu_option"><a href="subscription.php$session[sessionurl_q]">$vbphrase[subscribed_threads]</a></td></tr>
<tr><td class="vbmenu_option"><a href="member.php?$session[sessionurl]u=$bbuserinfo[userid]">$vbphrase[my_profile]</a></td></tr>
<if condition="$show['wollink']"><tr><td class="vbmenu_option"><a href="online.php$session[sessionurl_q]">$vbphrase[whos_online]</a></td></tr></if>

</table>
</div>
<!-- / user cp tools menu -->
</if>
<!-- / NAVBAR POPUP MENUS -->

<!-- PAGENAV POPUP -->

<div class="vbmenu_popup" id="pagenav_menu" style="display:none">
<table cellpadding="4" cellspacing="1" border="0">
<tr>
<td class="thead" nowrap="nowrap">$vbphrase[go_to_page]</td>
</tr>
<tr>
<td class="vbmenu_option" title="nohilite">
<form action="$vboptions[forumhome].php" method="get" onsubmit="return this.gotopage()" id="pagenav_form">
<input type="text" class="bginput" id="pagenav_itxt" style="font-size:11px" size="4" />
<input type="button" class="button" id="pagenav_ibtn" value="$vbphrase[go]" />
</form>
</td>
</tr>
</table>
</div>

<!-- / PAGENAV POPUP -->
</if>

Search for:
<tr><td class="thead"><a href="usercp.php$session[sessionurl_q]">$vbphrase[user_control_panel]</a></td></tr>

and put it after that.

Or search for a work in your navbar, like Member list, New Posts etc. and put the arcade link after the </tr> or </td>.

[Maagic]

That's the weird thing, i can't even find the word calendar in my navbar template, but it's in my navbar on the forum.

It could be in the header.. do a template search for "calendar" and it'll let you know where it is (aside from the calendar template, of course)

[Mastar]

I get

-----------
you do not have permission to access this page. This could be due to one of several reasons:

Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.
-----------

when trying to access the arcade page on the navbar, does anyone know what could be wrong?

Go to the usergroup and edit permissions.

[Mastar]

It could be in the header.. do a template search for "calendar" and it'll let you know where it is (aside from the calendar template, of course)

It's in the navbar, search for another word that you see in your navbar.

[Maagic]

It's in the navbar, search for another word that you see in your navbar.

No, the navbar template is what he/she posted and it's not in there.

[Mastar]

No, the navbar template is what he/she posted and it's not in there.
Oh ok sorry misunderstood.

[PsiNyde]

is anybody else's avatar/user info being pushed to the right once an award is present? i'm getting a wrap from the award on user info

http://americanboxer.tv/forums/showthread.php?t=63

[Enthonia Tech]

Great modification,It's a great module by a great coder and I really love it,It beats all the other arcade mods.

Thanks a lot john!

[jellybaby]

Is there anyway to set this so that only members that have a certain amount of posts, or make a certain amount of posts in a day can use it to stop people joining just to play on the arcade?

Thanks

[Drix]

It was right as you said Maagic, it was in the header.
This is what the code for the calendar button (i think) looks like :

<td>
<!-- Button -->
<table border="0" cellpadding="0" cellspacing="0"><tr>
<td><img src="$stylevar[imgdir_misc]/images/butt_lside.png" width="4" height="16" alt="Indevor"></td>
<td width="60" height="16" colspan="4" bgcolor="#000000" class="bg_link" class="vbmenu_control" nowrap="nowrap">
<a href="calendar.php$session[sessionurl_q]">
<span class="button_txt">$vbphrase[calendar]</span></a></td>
<td><img src="$stylevar[imgdir_misc]/images/butt_rside.png" width="4" height="16" alt="Indevor"></td>
</tr></table>
<!-- End Button --></td>

Should I copy this and fill in the info from the arcade link and paste it under it?

[Maagic]

Is there anyway to set this so that only members that have a certain amount of posts, or make a certain amount of posts in a day can use it to stop people joining just to play on the arcade?

Thanks

http://www.v3arcade.com/forums/showthread.php?t=476

[Drix]

I managed to make a link out of it now, but the link still says Calendar, and I can't seem to change it, but the link leads to the arcade page, so that part works. So now I have two Calendar links, one that goes to the calendar, and one that goes to the arcade.

I'm glad it works, but if you would know how to change it, i'd be happy!

[Drix]

Fixed it! Thanks for all the help!

[Maagic]

I managed to make a link out of it now, but the link still says Calendar, and I can't seem to change it, but the link leads to the arcade page, so that part works. So now I have two Calendar links, one that goes to the calendar, and one that goes to the arcade.

I'm glad it works, but if you would know how to change it, i'd be happy!

change $vbphrase[calendar] to $vbphrase[Arcade]

[trilljester]

i only got the .SWF files... no php or anything with it...

so how do i upload with just the SWF files?

Create a .php file that follows the same format as other IBPro games, and tar up the files that you have, then try importing it.

[Zacarias]

Upgraded from beta with no problems. Thanks alot, man!

[Chris M]

The only thing bad I have to say is that the instructions are very poor for upgrading...

Yes, there is information here, but information should be provided in the "Install Instructions" of how to upgrade...

Other than that no other complaints... As of yet...

Chris

[Sal Collaziano]

The only thing bad I have to say is that the instructions are very poor for upgrading...

Yes, there is information here, but information should be provided in the "Install Instructions" of how to upgrade...

Other than that no other complaints... As of yet...

Chris

Some good uninstall directions may be helpful in this case. Something that describes what to get rid of in the database if you want a clean install.. I've been stuck for awhile now...

https://vborg.vbsupport.ru/showpost.php?p=834558&postcount=513

[vBFreak]

I've a problem with installing that, I've forgotten to remove the field arcadepermissions in my usergroup table, now I've dropped it and re-imported the product, I can't remove it because I get a mysql error and if I try to use the importer I also get a mysql error, if I install it with the option to overwrite the product it seems to be ok, but as I already said, I can't import my old things and I get the no permission error if I call the arcade.php on my forum's home...

The error is "MySQL-Fehler : Table 'db40028079.arcade_games' doesn't exist", could also be a bug or something, because my database name is db40028079, but in that database there is no table called db40028079.arcade_games

Please help :/

[Greebo]

Chris that looks like you uploaded php files in binary mode perhaps?

[Chris M]

Chris that looks like you uploaded php files in binary mode perhaps?

I didn't upload them, but I'll make sure they get uploaded in ASCII mode to be sure :)

That's something I didn't think to check ;)

Chris

[goblues]

is anybody else's avatar/user info being pushed to the right once an award is present? i'm getting a wrap from the award on user info

http://americanboxer.tv/forums/showthread.php?t=63

I don't think you added the code in the postbit or legacy template before:

</table>
</div>
<!-- / post $post[postid] popup menu -->

Make sure it's before that </table> tag

[Greebo]

I hate to repost this so soon, but this is very frustrating and there has been a lot of churn since my first post, so... here goes:

I'm getting this error message 7 times on my forums:
Warning: Call-time pass-by-reference has been deprecated - argument passed by value; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. However, future versions may not support this any longer. in /usr/local/www/low/low_new/forum/arcade.php on line 906.

The line numbers change, but everything else stays the same. That appears at the top of the page.

I also get:
Unable to add cookies, header already sent.
File: /usr/local/www/low/low_new/forum/arcade.php
Line: 108

That appears in the body of the page.

ANY ideas would be appreciated - this is nothing like I've seen before and I have no idea where to begin troubleshooting.

[Maagic]

I hate to repost this so soon, but this is very frustrating and there has been a lot of churn since my first post, so... here goes:

I'm getting this error message 7 times on my forums:
Warning: Call-time pass-by-reference has been deprecated - argument passed by value; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. However, future versions may not support this any longer. in /usr/local/www/low/low_new/forum/arcade.php on line 906.

The line numbers change, but everything else stays the same. That appears at the top of the page.

I also get:
Unable to add cookies, header already sent.
File: /usr/local/www/low/low_new/forum/arcade.php
Line: 108

That appears in the body of the page.

ANY ideas would be appreciated - this is nothing like I've seen before and I have no idea where to begin troubleshooting.


Create a .htaccess file and put it in your forums directory, with this in it:

php_value allow_call_time_pass_reference 1

If it's any consolation, John posted yesterday that this has been fixed in the upcoming release.

[Greebo]

Create a .htaccess file and put it in your forums directory, with this in it:

php_value allow_call_time_pass_reference 1

If it's any consolation, John posted yesterday that this has been fixed in the upcoming release.
Do you think recycling apache will be necessary after adding the .htaccess? Because I just added this and it doesn't seem to be having an effect...

* Greebo dreads trying to get his server operator to restart httpd. ;)

[Greebo]

*sigh*

Server op recycled apache. No dice. Still getting:

Warning: Call-time pass-by-reference has been deprecated - argument passed by value; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. However, future versions may not support this any longer. in /usr/local/www/low/low_new/forum/arcade.php on line 908

But - good news about the upcoming fix - so I'll hang out and wait on it.

[redtailboa]

Is there a way to make every users "Arcade Options" in there profile be set to Allow Challenges?

I searched everywhere trying to figure out why challenges were not showing up and its because everyones profile defaults to this not being turned on.

[Cap'n Steve]

If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file.

I suggest you set that in your php.ini file. If you're on a shared server you're going to have to ask your host.

[gtcave]

HI SUP! Sweet Nice work. INSTALLED.

One Problem may be a bug.......

I downloaded some games in .zip format. unzipped them and uploaded them to admincp/games and then went to admincp/v3arcade/v3 Arcade - Mass Game Import and clicked start and they wont install..........


anyone else got this problem?

also if you go here

admincp/v3arcade/v3 Arcade - Mass Game Import

you will read

Extract and upload the games you want to import into the arcade/games folder

but underneath it says

File Path - admincp/games

[nemanja]

Guys i asked this before as well but no reply.
Iam getting a blank page when i goto arcade ..
i turned on allow_call_time_pass_reference thinkin dat could be the problem but nope nufin.

[2fast4ya]

okay, im getting an error. when i go to the usergroup permissions to give a usergroup access to the arcade... i get this error:

Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /includes/class_core.php on line 635

and the changes aren't made. even i, as superadmin, cannot access the arcade yet. please advise. i signed up to your forum, but never received my confirmation email. and, i was planning on upgrading my account. so your prompt response is well appreciated.

[bozzy]

I am getting this error:
Database error in vBulletin 3.5.0:

Invalid SQL:
SELECT arcade_challenges.*, touser.username AS tousername, fromuser.username AS fromusername, arcade_games.miniimage, arcade_games.title FROM arcade_challenges AS arcade_challenges
LEFT JOIN user AS touser ON (touser.userid=arcade_challenges.touserid)
LEFT JOIN user AS fromuser ON (fromuser.userid=arcade_challenges.fromuserid)
LEFT JOIN arcade_games AS arcade_games ON (arcade_games.gameid=arcade_challenges.gameid)
WHERE status=3 ORDER BY datestamp DESC LIMIT 3;

MySQL Error : Table 'bozzyswo_vb.arcade_games' doesn't exist
Error Number : 1146
Date : Monday, November 28th 2005 @ 03:08:37 PM
Script : http://www.unrulypolitics.com/arcade.php
Referrer : http://www.unrulypolitics.com/
IP Address : 69.243.92.244
Username : Bozzy
Classname : vb_database

[Maagic]

Guys i asked this before as well but no reply.
Iam getting a blank page when i goto arcade ..
i turned on allow_call_time_pass_reference thinkin dat could be the problem but nope nufin.

Try reverting your arcade templates

[bozzy]

It is saying that arcade_games does not exist. How do I add this manually?

[Lottis]

HI SUP! Sweet Nice work. INSTALLED.

One Problem may be a bug.......

I downloaded some games in .zip format. unzipped them and uploaded them to admincp/games and then went to admincp/v3arcade/v3 Arcade - Mass Game Import and clicked start and they wont install..........


anyone else got this problem?

also if you go here

admincp/v3arcade/v3 Arcade - Mass Game Import

you will read



but underneath it says

In the mass import. Games Per Page
The number of games to import at once. Set this to 100 ore higher than how many games you got installed.

[Gizmo5h1t3]

not been thru allthe posts, as it would take me ages..but can i ask...

is there ANY way to have the "challenges" bit activated for all members without having them doing it in their profiles themselves???

[sitka]

Guys i asked this before as well but no reply.
Iam getting a blank page when i goto arcade ..
i turned on allow_call_time_pass_reference thinkin dat could be the problem but nope nufin.


allow_call_time_pass_reference variable in php.ini needs to be set to 1

oh misread your message. you might have a template issue then.

[WNxWakko]

Challanges are messed up. They are off by default in everyones profile.

Also they only include the games that came with this by default. Any games you add using "iB "Pro" Arcade - Mass Game Import" dont show up as challangable.

[RWDF1]

well I updated to 3.5.1 to see if that would solve my mySQL problems, but no luck.

[Zachariah]

Request:
- admincp

When you disable an "active" game have a strike through on the game title. - or something telling me its not in use.

[Xtrato]

Main difference between ibpro and v3?

[dan35]

1. Can we play games in a new window with adjustable size?

2. Can we set group permisions with categories? eg. it may be used with adult games.

[b6gm6n]

Hi John, just upgraded to 1.0 which was fine thankyou... just wanted to know, besides the postbit popups showing a users awards it seems unless a member has 5 or more awards i cannot see a way to challenge a member, it's really difficult to find any link which says "challenge x in the arcade" it does work, but only on a few members...is there a way to make this more accessable? cheers

-b6

[2fast4ya]

okay, im getting an error. when i go to the usergroup permissions to give a usergroup access to the arcade... i get this error:

Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /includes/class_core.php on line 635

and the changes aren't made. even i, as superadmin, cannot access the arcade yet. please advise. i signed up to your forum, but never received my confirmation email. and, i was planning on upgrading my account. so your prompt response is well appreciated.

no response?

[Maagic]

Hi John, just upgraded to 1.0 which was fine thankyou... just wanted to know, besides the postbit popups showing a users awards it seems unless a member has 5 or more awards i cannot see a way to challenge a member, it's really difficult to find any link which says "challenge x in the arcade" it does work, but only on a few members...is there a way to make this more accessable? cheers

-b6

The members you want to challenge have to enable challenges in their UserCPs

[GoTTi]

Request:
- admincp

When you disable an "active" game have a strike through on the game title. - or something telling me its not in use.

like this zach?

https://vborg.vbsupport.ru/showthread.php?s=&threadid=70099

if so hit up rjordan and see if he will convert it to 3.5.x world

[croportal]

check http://www.vbulletingames.com/Database/ or request it from the guy

when i download this games, how can i put on my website

[nexus851]

You can install games manually. The new batch system is handy, but for some reason it installs the games via their appropriate php files but won't copy the associated .gif and .swf files automatically; I have to do that myself.

unfortunetly i have a bunch of .SWF files (with author's permissions), so may you tell me how you manually installed the files into the arcade system by editing the templates?

[nexus851]

How do we default it ON for all new users too, if you please? ;) Also, need to turn on the other notifications so they'll know they got a challenge.

Yeah, anyone know how to TURN ON CHALLENGE for "ALL NEW" users who registers in the future.... let us know... =)

[2fast4ya]

i give up. there is no support for this what so ever. and when you sign up to their forums they dont send you a confirmation email. bad form.. bad form. UNINSTALLED

[Gizmo5h1t3]

i give up. there is no support for this what so ever. and when you sign up to their forums they dont send you a confirmation email. bad form.. bad form. UNINSTALLED

weird that...ive seen nothing but support so far when ppl have a problem, also i signed up yesterday to their forum, and recieved the confirmation e mail straight away......ppfftt.
seems its just NOT your day chum....lmao

dont go puttin things down coz ppl aint jumping when u shout jump......life just aint that way m8.

and wot u whingin bout your confirmation e mail for??...im online at this very second, and you show up as online as well....lmao (on v3arcade)

[dubsbhoy]

Installation in three easy steps:

1. Upload all the files from the "files" directory in this zip into your forum directory.
2. Import product-v3arcade.xml as a new product.
3. Edit templates as instructed below.

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-


In the template: USERCP_SHELL
=============================
FIND:
=============================
<tr>
<td class="$navclass[profile]" nowrap="nowrap"><a class="smallfont" href="profile.php?$session[sessionurl]do=editprofile">$vbphrase[edit_profile]</a></td>
</tr>
=============================
ABOVE THIS, ADD:
=============================
<!-- v3 Arcade -->
<tr>
<td class="$navclass[arcade]" nowrap="nowrap"><a class="smallfont" href="profile.php?$session[sessionurl]do=editarcade">$vbphrase[edit_arcade_options]</a></td>
</tr>
<!-- /v3 Arcade -->
=============================

I've done step one and two now were do i find the user pc shell ??

is there anyone who would just do this for you it hurts my head LOL

[Gizmo5h1t3]

I've done step one and two now were do i find the user pc shell ??

is there anyone who would just do this for you it hurts my head LOL

USERCP_SHELL is a template found in a little bunch, all flocking together undr the "templates" heading in the admin cp m8...lol
i`d have thought In the template: USERCP_SHELL

was a dead giveaway...;)

[dubsbhoy]

USERCP_SHELL is a template found in a little bunch, all flocking together undr the "templates" heading in the admin cp m8...lol
i`d have thought In the template: USERCP_SHELL

was a dead giveaway...;)

go easy on me i'm only at this a week.

the arcade is shown up now but i'm getting

Internal Server Error, this is an error with your script, check your error log for more information.


for the vbookie i'm getting

Warning: main(/home/m/a/marks/public_html/includes/functions_vbookie.php): failed to open stream: No such file or directory in /vbookie.php on line 75

Fatal error: main(): Failed opening required '/home/m/a/marks/public_html/includes/functions_vbookie.php' (include_path='.:/lib/php') in /home/m/a/marks/public_html/vbookie.php on line 75

you don't fancy sorting us out do you, pleeeeeeeeeeease

[rjordan]

John, unless you were speaking of Mousebreaker, I have not received the e-mail from your game author you noted earlier with the list of games to remove. Can you please PM me the information to contact this individual or request that they send me an e-mail with the games that need to be removed? I would like to get this resolved as soon as possible.

[WNxWakko]

Anyone know how to fix the guest problem? Guest posts have all the awards on their posts from every single game.

OMG. IS THERE ANY SUPPORT FOR THIS MOD?

HELP ME WITH THIS ONE PLEASE.

[2fast4ya]

weird that...ive seen nothing but support so far when ppl have a problem, also i signed up yesterday to their forum, and recieved the confirmation e mail straight away......ppfftt.
seems its just NOT your day chum....lmao

dont go puttin things down coz ppl aint jumping when u shout jump......life just aint that way m8.

and wot u whingin bout your confirmation e mail for??...im online at this very second, and you show up as online as well....lmao (on v3arcade)

you - are - so - smart! omg! THANK YOU SO MUCH FOR TELLING ME YOU see me online when i havn't gotten a confirmation email. and me, stupid ol me, thought this whole time that I was on their website, even though i never received their email, and i can't post on their site.... now you've shown me that i can't post on their website because I'm shouting jump and no one is jumping! Oh man... thanks for making that so clear.

</sarcasm>

[thuffner]

What about Texas Hold 'Em Poker? :)

[sim tech]

Anyone know how to fix the guest problem? Guest posts have all the awards on their posts from every single game.

OMG. IS THERE ANY SUPPORT FOR THIS MOD?

HELP ME WITH THIS ONE PLEASE.

The coder just released this yesterday and there's already over 570 posts... there's plenty of support - relax!

I've installed it on both versions 3.5 and versions 3.51 and there are no guest errors like you described. Are you using the default blue style? You may also want to doublecheck the postbit template mods. I have nothing to do with the mod, I'm just offering my 2 cents. :tired:

[WNxWakko]

I am uninstalling this peice of junk. NO SUPPORT. Challanges done work right, guests have all the awards, permissions are in each game and Im not going to edit 600 games to set the permissions.

Ill be using IBP

[ConqSoft]

Have a nice day!

[bold]

anybody know how to make it display the awards in MEMBERINFO?

[Jenta]

3rd attempt...
If I register at v3arcade.com am I required to use the store system if I want to get games? Meaning....are the games in the store available as normal downloads without me having to reveal private forum information?

[WNxWakko]

3rd attempt...
If I register at v3arcade.com am I required to use the store system if I want to get games? Meaning....are the games in the store available as normal downloads without me having to reveal private forum information?

LMAO ya right, there games list. They have 7 games and thats it.

[Qwest]

Ummm.. am I missing something here??

I went to v3arcade and registered so I could see the store and it only has the games I already have installed by default....

So where do I get games? Is there a feature that allows me to grab games from v3arcade.com and install them?

[Maagic]

LMAO ya right, there games list. They have 7 games and thats it.

The arcade's only been out officially for a smidge over one day. Give em time.. geez.

[Qwest]

The arcade's only been out officially for a smidge over one day. Give em time.. geez.
the point is........ it would have been nice to know there are only 7 basic games for the script right now. I would definitely have waited had I known that.

Now I've got hundreds of users playing 7 games and begging for more. It's gonna get violent soon!

[divided_by_fear]

why dont you install games? i mean i had it one day have a 1000 games installed

[Maagic]

why dont you install games? i mean i had it one day have a 1000 games installed

Where'd you get those from?

[divided_by_fear]

i have a zip i grabbed from a link i seen on one of the post on here... it only took me like 10 mins to install them all too... the longest part is the upload... but not only that you can register for this site * Link Removed * and they have a bunch on there too

[divided_by_fear]

lol that is going to take you 3 years to grab games off them slow servers lol i would upload the zip pack i have but i know major people will mass download and kill bandwidth....

[yoyoyoyo]

One thing you should think about when installing games is bandwidth. Each time a player loads up a game it must be downloaded, so look at the size of your games folder and multiply that by the number of people in your forum - when you start adding every game you can find you will find that your bandwidth quickly goes through the roof. It is best to be selective, and try not to load too many larger games. The great thing about having a selection is you can rotate games - keep the top ten and rotate 50 new games or so every month and that will be plenty for most forums, unless you are a gaming community.

[yoyoyoyo]

lol that is going to take you 3 years to grab games off them slow servers lol i would upload the zip pack i have but i know major people will mass download and kill bandwidth....
exactly why it is on rapidshare ;) Each file is 30 to 50 MB's of games - do you really need them ALL at once?? patience is a virtue.

[divided_by_fear]

i dont see that at all... i have used 20 gigs of bandwidth last month... but thats also cause i have movies and other large files for download... i truely dont think it uses much at all

[divided_by_fear]

lol yeah but that 50 megs will take you hours lol... ill upload it for a few people to download... lol and they will download all 250 megs in 2 min at most lol 100 meg ports are nice

[yoyoyoyo]

i dont see that at all... i have used 20 gigs of bandwidth last month... but thats also cause i have movies and other large files for download... i truely dont think it uses much at all
it uses what it uses- if you have 800 MB's of games installed and you have 100 active gamers on your forum, who like to check out each game, then I can guarantee that it will be 800 MB X 100, and even more if people clean out their browser cache often. It's simple math. I am not telling people to installl games, etc.- I am just suggesting that they be aware of the bandwidth considerations- which do exist. anytime you add something like an arcade to your forum.

[yoyoyoyo]

lol yeah but that 50 megs will take you hours lol... ill upload it for a few people to download... lol and they will download all 250 megs in 2 min at most lol 100 meg ports are nice
SO- it will take you a few hours... what's the hurry? Feel free to offer any games any way you feel is fair/easy/cost effective... nobody is stopping you.

[divided_by_fear]

i dont see it happening ... i run and own my server... and i never use alot on games my major bandwidth is used on downloading movies...

[yoyoyoyo]

i dont see it happening ... i run and own my server... and i never use alot on games my major bandwidth is used on downloading movies...
Great- go for it- not everyone is in the same boat.

[divided_by_fear]

yeah i know but the fact is some people maybe... but ill be glad to give people a link once i upload this so they dont have to wait for rapidshare... if you pm me once i have it uploaded ill give you a link but i will change the link as soon as i see the download is finished

[rjordan]

For the record, I limit the bandwidth to 128k right now to prevent what was stated above... mass kill on the bandwidth. As I review bandwidth, I make adjustments. As for the games on my site, they are in no way supported by anyone at v3arcade, ibProArcade, or Jelsoft. Games are being removed right now that have been verified as banned. This includes the game packs for ibProArcade. Banned games were in there so the archive was removed.

Please do not use this thread to discuss vBulletinGames.com. Use it for what it was intended for... v3arcade Q&A.

[Jenta]

My question isn't really about what I can download now. I'm sure they will add games in the future. I want to know if you can download the games in the store manually without going thru the license thing.

[Dutchmang]

Clean install, a pleasure to manage the games (compared to the old version anyway).. Great job John. I admit I was worried that you were rewriting it as a game-selling platform only, but all my old games and the ones from the site-that-can't-be-named work fine.

http://quaboag.net/forums/arcade.php

Like others here, I wish that challenges were on by default without users having to change their User CP settings, and I wish that all names were live for challenges, not just individual posts. Hopefully in future updates....

Thanks John, excellent stuff.

[Vitesse]

Worked sweet :)

Thanks John.

*clicks Install*

[b6gm6n]

Here's some another usefull SQL commands which sets all users to accept challenges plus...
All notification events are on and PM set for method...
UPDATE `user` SET `arcadeoptions` = '505';
(Method = email)
UPDATE `user` SET `arcadeoptions` = '501';
(Method = both)
UPDATE `user` SET `arcadeoptions` = '509';

-b6

[fluentdesigns]

Everytime I try to access the arcade at /arcade.php I keep getting this error.

you do not have permission to access this page. This could be due to one of several reasons:

Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.

[Cap'n Steve]

My question isn't really about what I can download now. I'm sure they will add games in the future. I want to know if you can download the games in the store manually without going thru the license thing.

No, I don't think you can. What are you so paranoid about? The store doesn't require anything I'd call sensitive information.

[The Chief]

Here's some another usefull SQL commands which sets all users to accept challenges plus...
All notification events are on and PM set for method...
UPDATE `user` SET `arcadeoptions` = '505';
(Method = email)
UPDATE `user` SET `arcadeoptions` = '501';
(Method = both)
UPDATE `user` SET `arcadeoptions` = '509';

-b6

That is good, will try it tommorow :D

[Maagic]

Everytime I try to access the arcade at /arcade.php I keep getting this error.

you do not have permission to access this page. This could be due to one of several reasons:

Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.

You need to go into your AdminCP and set the individual usergroups so that they all have permission to view/access the arcade.

Then go to www.v3arcade.com and make sure your license is verified.

[Jenta]

No, I don't think you can. What are you so paranoid about? The store doesn't require anything I'd call sensitive information.
It doesn't matter what you would call sensitive. That's up to each individual. I for one manage a private website and do not which to disclose my renamed admincp or the website.

Oh well. Guess I wont be registering there since I wont be allowed to keep my private information private and still download games. Thanks.

[makaveli420]

anyone else having problems with the games loading? they dont load for me... just plain white

[Cap'n Steve]

Lol, asking for a URL is now a privacy invasion. That's a new one.

[imported_-Sidekick-]

It doesn't matter what you would call sensitive. That's up to each individual. I for one manage a private website and do not which to disclose my renamed admincp or the website.

Oh well. Guess I wont be registering there since I wont be allowed to keep my private information private and still download games. Thanks.

Entering in the AdminCP link is optional, it is not mandatory.

[Jenta]

Lol, asking for a URL is now a privacy invasion. That's a new one.
Lol, not understanding things is even funnier.

[Moparx]

Lol, not understanding things is even funnier.

i guess for some people ignorance is bliss when it comes to security.

i personally also found it to be very odd that they were asking for user's admincp directories so they could 'redirect' people right back to their own admin panels (if an admin cant do this for themselves they shouldnt be an admin)

also while it is considered to be optional they also mention that if you dont give them this information then functionality will be impaired.

[Cap'n Steve]

Not trying to be mean, but someone knowing your admincp directory has nothing to do with security. I can't believe people still think that.

If you don't want to use the store, that's fine. It's cool, but the hack works just peachy without it. There are plenty of other things to complain about.

[nemanja]

Ok guys some1 helped me out earlier but then well i went 2 sleep :D

My problem of getting a BLANK page when i goto arcade.php
Ive installed a fresh database and did the modifications on the default theme of vb
Didnt add anything to it pure clean vb install ...
Still i get the blank screen :( .. Even turned on that wait time option from php.ini.
NOthing happening.. Please kindly Help .. Thankyou
Or maybe its bec this requires a specific version of php or mysql 2 run on huh ?... ( of which i have the latest of 2005 June )

[Moparx]

Not trying to be mean, but someone knowing your admincp directory has nothing to do with security. I can't believe people still think that.
According to vBulletin, you are incorrect.
Here are a few entries out of many:

By default, vBulletin will install the files for the Administrators' Control Panel into a folder called admincp, but you may wish to rename this folder this for security purposes. -- The Official vBulletin Manual (http://www.vbulletin.com/docs/html/main/editconfig)
We have it renamed on our site to avoid bots crawling the internet for vb sites to hack it to get a score. -- Floris (vBulletin Staff) (http://www.vbulletin.nl/showpost.php?&p=76338&postcount=9)
If you're looking to make your board safer, it would make more sense to rename the admincp directory (and set the variable in the config.php file) as well as passwordprotecting the directory with htaccess. -- Colin F (vBulletin Staff) (http://www.vbulletin.com/forum/showpost.php?p=965452&postcount=2)



Thats all i am going to add as I do not wish to further derail this thread

[007]

Still wondering if arcade templates will be grouped together instead of being listed by default? They take up a lot of space. :(

[G-Force 199]

A new Hack of The Month of vBulletin.Org
I think.

[fluentdesigns]

You need to go into your AdminCP and set the individual usergroups so that they all have permission to view/access the arcade.

Then go to www.v3arcade.com and make sure your license is verified.


thanks! Got it!

[Jenta]

Exactly Moparx. Some people just dont understand that's sensitive info. Not even Jelsoft knows my admincp directory since I intentionally disabled the phone home mechanism. Im sure as hell not goint to give it to a 3rd party site.

[Flow Fusion]

HELP I need to uninstallDatabase error in vBulletin 3.5.0:

Invalid SQL:
ALTER TABLE arcade_games DROP isreverse;

MySQL Error : Table 'giftedso_lxp.arcade_games' doesn't exist
Error Number : 1146
Date : Tuesday, November 29th 2005 @ 12:58:24 AM
Script : http://giftedsouls.com/gs/admincp/plugin.php
Referrer : http://giftedsouls.com/gs/admincp/plugin.php?do=productdelete&productid=v3arcade&s=
IP Address :
Username : Flow Fusion
Classname : vb_database

[pauloo]

HELP I need to uninstallDatabase error in vBulletin 3.5.0:

Invalid SQL:
ALTER TABLE arcade_games DROP isreverse;

MySQL Error : Table 'giftedso_lxp.arcade_games' doesn't exist
Error Number : 1146
Date : Tuesday, November 29th 2005 @ 12:58:24 AM
Script : http://giftedsouls.com/gs/admincp/plugin.php
Referrer : http://giftedsouls.com/gs/admincp/plugin.php?do=productdelete&productid=v3arcade&s=
IP Address :
Username : Flow Fusion
Classname : vb_database


Me too !

[andy1074]

i dont no why no permision for play

i active the games than admin cp and submit .
http://www.biyaban.com/forums/arcade.php

[andy1074]

i install this hack succesfully but it is not start
when set the permision in admin cp give this error


Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /includes/class_core.php on line 635

:tired: :tired:

[Flow Fusion]

This might help a few of you

http://yoursite/admincp/index.php?do=buildbitfields

[andy1074]

This might help a few of you

http://yoursite/admincp/index.php?do=buildbitfields

thank you my best firend :mad:
but i dont no why remove the games :tired:

[andy1074]

i have a question
who is the other games (more games) and if can i download it's?

[sickboy6ths]

Hi,

I got this error with certain games that I try to import (IBPro games):
Warning: Invalid argument supplied for foreach() in \admincp\arcadeadmin.php on line 728.

They work in ibpro as a charm.

Vbulletin 3.5.0

Thanks for any help!

[Paul M]

A few additions that would be nice;

Ability to disable categories.
Usergroup settings for minimum posts/reputation etc
Pruning of scores over a certain age (preferably automatic).
Ability to import zipped v3 games (similar to importing tar games).

:)

[johns_ar]

weve installed the v3 product-v3arcade.xml as a new product with no errors. however looking at the database there doesnt seem to be any new tables appended with arcade ... in fact theres no reference to arcade in any of the table names



when i click unistall the product i get :



Database error in vBulletin 3.5.0 Release Candidate 2:



Invalid SQL:

ALTER TABLE arcade_games DROP isreverse;



MySQL Error : Table 'mydatabase.arcade_games' doesn't exist

Error Number : 1146



anyone any ideas ?

[Paul M]

Upgrade to 3.5.1 would probably be the first suggestion - you still seem to be on RC2. :)

[pauloo]

weve installed the v3 product-v3arcade.xml as a new product with no errors. however looking at the database there doesnt seem to be any new tables appended with arcade ... in fact theres no reference to arcade in any of the table names

when i click unistall the product i get :
Database error in vBulletin 3.5.0 Release Candidate 2:
Invalid SQL:

ALTER TABLE arcade_games DROP isreverse;
MySQL Error : Table 'mydatabase.arcade_games' doesn't exist
Error Number : 1146
anyone any ideas ?

I have same problem with VB 3.5.1 :ermm:

[Dutchmang]

This worked great..... Now if all names are made live for challenges -- not just Forum posts but especially names appearing in the arcade, where everyone who shows up is a game player -- my life will be complete. (Ok I have no life :ermm: )

Here's some another usefull SQL commands which sets all users to accept challenges plus...
All notification events are on and PM set for method...
UPDATE `user` SET `arcadeoptions` = '505';
(Method = email)
UPDATE `user` SET `arcadeoptions` = '501';
(Method = both)
UPDATE `user` SET `arcadeoptions` = '509';

-b6

[Maagic]

I have same problem with VB 3.5.1 :ermm:

A lot of us had this problem. The XML doesn't seem to be adding the necessary tables sometimes.

If you have access to phpmyadmin on your server you can add the tables manually

http://www.v3arcade.com/forums/showthread.php?t=578&page=2 for more info.

[PsiNyde]

I don't think you added the code in the postbit or legacy template before:

</table>
</div>
<!-- / post $post[postid] popup menu -->

Make sure it's before that </table> tag


it is:
<!-- v3 Arcade -->
<if condition="$post['arcadeawards']">
<tr><td class="thead"><phrase 1="$post[username]">$vbphrase[xs_arcade_awards]</phrase></a></td></tr>
$post[arcadeawards]
</if>
<if condition="($post['arcadeoptions'] & 1) AND $post['userid']!=$bbuserinfo['userid']">
<tr><td class="thead">$vbphrase[arcade]</a></td></tr>
<tr><td class="vbmenu_option"><a href="arcade.php?do=newchallenge&userid=$post[userid]"><phrase 1="$post[username]">$vbphrase[challenge_x_in_the_arcade]</phrase></td></tr></if>
<!-- /v3 Arcade -->
</table>
</div>
<!-- / post $post[postid] popup menu -->

still funky. and that's my legacy postbit template.





and some of you that are +++++ing about the admincp directory, here is your answer:

it is to ensure that the games being installed ARE LEGAL through John's site to cover his 6. if you don't like it, use IB.

[yoyoyoyo]

Exactly Moparx. Some people just dont understand that's sensitive info. Not even Jelsoft knows my admincp directory since I intentionally disabled the phone home mechanism. Im sure as hell not goint to give it to a 3rd party site.
AGREED!

[PsiNyde]

Not even Jelsoft knows my admincp directory since I intentionally disabled the phone home mechanism. Im sure as hell not goint to give it to a 3rd party site.

again, nobody's holding a gun to your head to use this. John is only covering his 6 so he doesn't go through that legal junk again. I suggest you use IB or write your own if it's that much of an issue with you...

[amykhar]

If I recall correctly, the directory name is just there to tell you where to do things. You can probably give it a bogus directory name and just adapt the instructions yourself.

[John]

Any chance on the new release coming sometime tonight?

I'll be released in a few hours. :)

[John]

How about some template grouping in the next version?

It's already in the next version.

[Snake]

What new release are you talking about here?

[John]

What new release are you talking about here?

The next release (1.0.1) comes with a detailed database structure included in the product XML file. When you upgrade the Arcade it checks to see what the database structure should be looking like, and compares it with what is actually there. It's a failsafe way of making 100% sure that your database structure is exactly how it should be after upgrading.

Nearly all of the errors and bugs that people were experiencing seemed to be because of database errors caused by missing tables and fields. (I have no idea why some people were affected and others didn't have any problems, since everyone has been using the same code.) The next release should fix most of these problems.

[ShadowOne]

I Have No Problems, Everything Is Fine For Me, I Think Diff Skins Get Diff Reactions For Some Odd Reason....

[PsiNyde]

not to mention that some folks hack the crap out of their forums...

[John]

If I recall correctly, the directory name is just there to tell you where to do things. You can probably give it a bogus directory name and just adapt the instructions yourself.

You can indeed. The only reason for the admin CP field is so it can redirect you to the correct place to download the games to your Arcade. If you don't want to enter it, just put in a bogus value and edit the URL when you get a 404 error.

[Maagic]

The next release (1.0.1) comes with a detailed database structure included in the product XML file. When you upgrade the Arcade it checks to see what the database structure should be looking like, and compares it with what is actually there. It's a failsafe way of making 100% sure that your database structure is exactly how it should be after upgrading.

Nearly all of the errors and bugs that people were experiencing seemed to be because of database errors caused by missing tables and fields. (I have no idea why some people were affected and others didn't have any problems, since everyone has been using the same code.) The next release should fix most of these problems.

John if our arcade isn't working exactly right will it have a "repair" option or will we have to uninstall and reinstall the new version?

[john1744]

I will install when the new version is put up. :)

[djlotus]

John if our arcade isn't working exactly right will it have a "repair" option or will we have to uninstall and reinstall the new version?

Excellent question Maagic. I am one of those people having table issues. I can't even uninstal the product. A "fix" would be great.

[twincamfxd]

Works awesome, Thanks!!!!

[legendarybennn]

i installed last night. love it so far.
only problem i ran in to is the arcade button does not work on homepage, only works when i am on my forum page.

[AshokForums.com]

The installation was smooth for me.. No probs at all..

[HC.]

If we have ibproarcade can it be converted to the v3arcade system?

[GoTTi]

If we have ibproarcade can it be converted to the v3arcade system?

yes.

the info says - Supports both v3 Arcade and iB games.

goto www.v3arcade (http://www.v3arcade/) for more info.

[GoTTi]

a request that can maybe be filled here:

allow usergroups to play certain games only. say if you got a premium user group, like users that pay for subscriptions, those users can play certain games.

[theArchitect]

Quick question about upgrading an old 3.0.3 version.

A client has asked me to upgrade their board and arcade. In your instructions you say to remove all fields containing the word "arcade" from the "user" and "usergroup" tables.

I am guessing you mean via php_my_admin? If so I don't have php_admin access to their forum. Which I assume means we can't upgrade until someone with the access can remove these tables?

Or can I just remove the old templates and install over the top?

I am also guessing (as it isn't documented) I need to run the arcadeimport.php file?

[Zachery]

Quick question about upgrading an old 3.0.3 version.

A client has asked me to upgrade their board and arcade. In your instructions you say to remove all fields containing the word "arcade" from the "user" and "usergroup" tables.

I am guessing you mean via php_my_admin? If so I don't have php_admin access to their forum. Which I assume means we can't upgrade until someone with the access can remove these tables?

Or can I just remove the old templates and install over the top?

I am also guessing (as it isn't documented) I need to run the arcadeimport.php file?

Wait for 1.0.1 I'm hoping he's fixed the problems and should be able to do it with the upgrade script alone.

[Robbed]

a request that can maybe be filled here:

allow usergroups to play certain games only. say if you got a premium user group, like users that pay for subscriptions, those users can play certain games.

That would be nice.

[John]

Wait for 1.0.1 I'm hoping he's fixed the problems and should be able to do it with the upgrade script alone.

1.0.1 is available for download now. There's a new "Upgrade Instructions.txt" file that provides step by step instructions for people who are upgrading.

If your Arcade installation is broken or never worked in the first place, don't bother uninstalling - just import the product and it'll check the database to see what state the changes are in.

[theArchitect]

Thanks John. :squareeyed:

[rb290]

DAMN my arcade wont save highscores for iB Pro Arcade games and when I go to edit arcade options in the user cp it says this at the top of the site
"Warning: Invalid argument supplied for foreach() in /profile.php on line 906"
and also my site isnt upgraded to 3.5.1 maybe thats causing some problems

[lanc3lot]

John i think u must have included the addons like leadersboard, as i think we must redo them now, right?

[Lionel]

And how to upgrade from 1.0 to 1.01?

[John]

Thanks John. :squareeyed:

You can ignore the preparation section, I've just removed it and updated the zip.

A couple of other things that have changed:

1. You can use arcadetools.php?do=clean to remove old arcade templates from a 3.0.x installation.
2. Don't worry about the user and usergroup tables containing old arcade fields, the new script takes care of that.

[John]

John i think u must have included the addons like leadersboard, as i think we must redo them now, right?

The Arcade release doesn't contain any addons.

As of 1.0.2 there'll be hooks, so you can install addons and forget about them.

[Oblivion Knight]

Typo with the template caching.. ;)

'arcade_challenge_minibit'.
'arcade_challenge_bit'

[John]

Typo with the template caching.. ;)

'arcade_challenge_minibit'.
'arcade_challenge_bit'

lol... *uploads again*

[Clanshosting]

Hm...where do you get more games? like dnforum.com has? I don't see them on their website.

[john1744]

lol... *uploads again*
Does that affect any files or just the XML?

[lanc3lot]

Where is that oblivion? As i have already upgrade it, do i have to do it again or just the xml?

[John]

Does that affect any files or just the XML?

arcade.php


Just uploaded it again, to fix a minor table prefix bug.

[john1744]

Warning: Invalid argument supplied for foreach() in /includes/class_bitfield_builder.php on line 200

Warning: Invalid argument supplied for foreach() in /includes/class_bitfield_builder.php on line 200

Warning: Invalid argument supplied for foreach() in /includes/class_bitfield_builder.php on line 200

While importing the product.

[John]

Warning: Invalid argument supplied for foreach() in /includes/class_bitfield_builder.php on line 200

Warning: Invalid argument supplied for foreach() in /includes/class_bitfield_builder.php on line 200

Warning: Invalid argument supplied for foreach() in /includes/class_bitfield_builder.php on line 200

While importing the product.

Does it break the installation?

[john1744]

Warning: Invalid argument supplied for foreach() in /includes/class_bitfield_builder.php on line 200

Warning: Invalid argument supplied for foreach() in /includes/class_bitfield_builder.php on line 200

Warning: Invalid argument supplied for foreach() in /includes/class_bitfield_builder.php on line 200

While importing the product.Hmm uploaded the product again overwriting the first one and it worked just fine.

[divided_by_fear]

works perfect john thank you and the addon's work great too thanks

[lanc3lot]

A question: To enable challenges, we have to "enable" it to every single member in his options or can we mass enable it?
The same question, if we can mass enable other options u have in the usercp, like pm report when someone beats the record, etc

[John]

A question: To enable challenges, we have to "enable" it to every single member in his options or can we mass enable it?

Run

UPDATE user SET arcadeoptions=arcadeoptions+1 WHERE !(arcadeoptions & 1)

Mass editing will come shortly.

[lanc3lot]

An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'tech_forumup.user' doesn't exist

:(

[John]

An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'tech_forumup.user' doesn't exist

:(

If you're using a table prefix, you need to edit the query accordingly.

[TsirhCitna]

So I tried to upgrade from 1.0.0 to 1.0.1 and this is what I get when I try to import the new product. I selected overwrite.

Database error in vBulletin 3.5.1:

Invalid SQL:
ALTER TABLE vb3_arcade_categories ADD categoryid int(10) unsigned NOT NULL auto_increment;

MySQL Error : Duplicate column name 'categoryid'
Error Number : 1060
Date : Tuesday, November 29th 2005 @ 06:59:57 PM
Script : http://www.tenstones.net/forums/admincp/plugin.php
Referrer : http://www.tenstones.net/forums/admincp/plugin.php?do=productadd
IP Address : 4.229.225.84
Username : Bob
Classname : vB_Database

[Lionel]

So I tried to upgrade from 1.0.0 to 1.0.1 and this is what I get when I try to import the new product. I selected overwrite.

Database error in vBulletin 3.5.1:

Invalid SQL:
ALTER TABLE vb3_arcade_categories ADD categoryid int(10) unsigned NOT NULL auto_increment;

MySQL Error : Duplicate column name 'categoryid'
Error Number : 1060
Date : Tuesday, November 29th 2005 @ 06:59:57 PM
Script : http://www.tenstones.net/forums/admincp/plugin.php
Referrer : http://www.tenstones.net/forums/admincp/plugin.php?do=productadd
IP Address : 4.229.225.84
Username : Bob
Classname : vB_Database

got the same problem too. From 1.0 to 1.01

Database error in vBulletin 3.5.1:

Invalid SQL:
CREATE TABLE vb3_arcade_categories (categoryid int(10) unsigned NOT NULL auto_increment, catname varchar(250) NOT NULL, displayorder int(10) unsigned NOT NULL, PRIMARY KEY (categoryid));

MySQL Error : Table 'vb3_arcade_categories' already exists
Error Number : 1050

[john1744]

Am I missing something? I do not see anywhere to install games or to turn on games. Shouldn't there be a panel on the left of the ACP for my Arcade? I'm not seeing it.

[lanc3lot]

John there is also another bug.

I tried to change the settings in one of the games and see the outcome:

Database error in vBulletin 3.5.0:

Invalid SQL:
UPDATE vb3new_arcade_games SET
title='Asteroids',
description='Η εποχή των 80s επιστρέφει, με ένα ακόμα παιχνίδι της Retro κατηγορίας του gamers.gr',
width='500',
height='375',
gamepermissions='7',
minpoststotal='1',
minpostsperday='0',
minpoststhisday='0',
minreglength='0',
minrep='0',
categoryid='3',
isreverse='0'
WHERE gameid=7;

MySQL Error : Unknown column 'minpoststhisday' in 'field list'
Error Number : 1054
Date : Wednesday, November 30th 2005 @ 02:16:42 AM
Script : http://www.gamers.gr/forums/admincp/arcadeadmin.php
Referrer : http://www.gamers.gr/forums/admincp/arcadeadmin.php?do=editgame&gameid=7&s=
IP Address : 212.54.217.231
Username : lancelot
Classname : vb_database

[Lionel]

After I got that error, went in admincp to investigate how to uninstall and reinstall from scratch, PRODUCT DISAPPEARED.

[John]

Fixing now.

[divided_by_fear]

anyone have a working module for vbadvanced? seems that the one on v3 dont work??

[bold]

refreshing this thread like theres no tomorrow

[John]

If you've been having problems and you're using table prefixes, download the zip file again and try to install. If you get an error when trying to install, upload arcadetools.php into your admincp directory and run arcadetools.php?do=fixdb.

It should solve any problems you've been having.

[fringehead]

When I click on the arcade I get:

"you do not have permission to access this page. This could be due to one of several reasons:

Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation. "

I don't see any games in the CP either..

Any help appriciated!

THanks,

Sean

[john1744]

Oh wait quick question will this work fine with just 3.5.0?

[b6gm6n]

Upgrade A-OK...cheers

-b6

[lanc3lot]

If you've been having problems and you're using table prefixes, download the zip file again and try to install. If you get an error when trying to install, upload arcadetools.php into your admincp directory and run admincp.php?do=fixdb.

It should solve any problems you've been having.


It will fix if i do the one with the arcadetools.php also the prob i have in the setting of the game?

[Lionel]

If you've been having problems and you're using table prefixes, download the zip file again and try to install. If you get an error when trying to install, upload arcadetools.php into your admincp directory and run admincp.php?do=fixdb.

It should solve any problems you've been having.

none of these solutions work for me. Same errors.

[Lionel]

I wish to uninstall and start from scratch. How can I uninstall?

[John]

And you use table prefixes?

[bold]

workin fine for me

[Lionel]

yes I do use prefixes

[fringehead]

I uploaded the files, then chowned them to the proper website permissions...

Why am I getting no access from the admin? and why do I not see games? Do I need to download games?

[lanc3lot]

If you've been having problems and you're using table prefixes, download the zip file again and try to install. If you get an error when trying to install, upload arcadetools.php into your admincp directory and run admincp.php?do=fixdb.

It should solve any problems you've been having.


It will solve also the prob i have when i alter the settings?

When u say install again, u mean repaste the files u have inside or just upload the new xml? I did upload only the xml and everything went ok, though, when i try alter the settings i have the same error

Also, when u say run admincp.php?do=fixdb, what do u mean? :)

[John]

It will solve also the prob i have when i alter the settings?

When u say install again, u mean repaste the files u have inside or just upload the new xml? I did upload only the xml and everything went ok, though, when i try alter the settings i have the same error

Also, when u say run admincp.php?do=fixdb, what do u mean? :)

It was a big typo. Should be:

If you've been having problems and you're using table prefixes, download the zip file again and try to install. If you get an error when trying to install, upload arcadetools.php into your admincp directory and run arcadetools.php?do=fixdb.

It should solve any problems you've been having.

[Moparx]

So I tried to upgrade from 1.0.0 to 1.0.1 and this is what I get when I try to import the new product. I selected overwrite.

Database error in vBulletin 3.5.1:

Invalid SQL:
ALTER TABLE vb3_arcade_categories ADD categoryid int(10) unsigned NOT NULL auto_increment;

MySQL Error : Duplicate column name 'categoryid'
Error Number : 1060
Date : Tuesday, November 29th 2005 @ 06:59:57 PM
Script : http://www.tenstones.net/forums/admincp/plugin.php
Referrer : http://www.tenstones.net/forums/admincp/plugin.php?do=productadd
IP Address : 4.229.225.84
Username : Bob
Classname : vB_Database

I am also getting this... I originally uninstalled the product earlier today and just tried to reinstall since 1.0.1 supports posts per day now.

I have tried manually dropping the vb3_arcade_* tables to no avail


running arcadetools.php?do=fixdb gives me this:
Database error in vBulletin 3.5.1:

Invalid SQL:

SELECT administrator.*,
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_cpuser AS phrasegroup_cpuser,
language.phrasegroup_arcade AS phrasegroup_arcade,
language.phrasegroup_cpglobal AS phrasegroup_cpglobal,
language.phrasegroup_global AS phrasegroup_global,
language.options AS lang_options,
language.languagecode AS lang_code,
language.charset AS lang_charset,
language.locale AS lang_locale,
language.imagesoverride AS lang_imagesoverride,
language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride,
language.registereddateoverride AS lang_registereddateoverride,
language.calformat1override AS lang_calformat1override,
language.calformat2override AS lang_calformat2override,
language.logdateoverride AS lang_logdateoverride,
language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep

FROM vb3_user AS user
LEFT JOIN vb3_userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN vb3_usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN
vb3_administrator AS administrator ON (administrator.userid = user.userid) INNER JOIN vb3_language AS language ON
(language.languageid = IF(user.languageid = 0, 1, user.languageid))

WHERE user.userid = 1;

MySQL Error : Unknown column 'language.phrasegroup_arcade' in 'field list'
Error Number : 1054
Date : Tuesday, November 29th 2005 @ 08:06:06 PM
Script : http://www.virtualinfusion.net/<admincp>/arcadetools.php?do=fixdb

[Lionel]

I do get errors running that tools also. All phrases disappeared too.

[lanc3lot]

When i do this john (i mean without the typo:P) i have:

Database error in vBulletin 3.5.0:

Invalid SQL:
CREATE TABLE vb3new_arcade_categories (categoryid int(10) unsigned NOT NULL auto_increment, catname varchar(250) NOT NULL, displayorder int(10) unsigned NOT NULL, PRIMARY KEY (categoryid));

MySQL Error : Table 'vb3new_arcade_categories' already exists
Error Number : 1050
Date : Wednesday, November 30th 2005 @ 03:13:32 AM
Script : http://www.gamers.gr/forums/admincp/arcadetools.php?do=fixdb
Referrer :
IP Address : 212.54.217.231
Username : lancelot
Classname : vb_database

[TsirhCitna]

If you've been having problems and you're using table prefixes, download the zip file again and try to install. If you get an error when trying to install, upload arcadetools.php into your admincp directory and run arcadetools.php?do=fixdb.

It should solve any problems you've been having.

Database error in vBulletin 3.5.1:

Invalid SQL:
ALTER TABLE vb3_arcade_categories ADD categoryid int(10) unsigned NOT NULL auto_increment;

MySQL Error : Duplicate column name 'categoryid'
Error Number : 1060
Date : Tuesday, November 29th 2005 @ 08:14:04 PM
Script : http://www.tenstones.net/forums/admincp/arcadetools.php?do=fixdb
Referrer :

[John]

Database error in vBulletin 3.5.1:

Invalid SQL:
ALTER TABLE vb3_arcade_categories ADD categoryid int(10) unsigned NOT NULL auto_increment;

MySQL Error : Duplicate column name 'categoryid'
Error Number : 1060
Date : Tuesday, November 29th 2005 @ 08:14:04 PM
Script : http://www.tenstones.net/forums/admincp/arcadetools.php?do=fixdb
Referrer :

Download the zip again.

If fixdb doesn't help, try uninstalling and reinstalling.

[Lionel]

How do you uninstall? I just redownloaded and still have the same problem

[lanc3lot]

If fixdb doesn't help, try uninstalling and reinstalling.

That reffers to me aswell?:(

It will be a mess to uinstall, i just have the settings problem:(

[Lionel]

In admincp/product, arcade does not show. So how to uninstall?

[Moparx]

updated zip doesnt do anything for me

[John]

That reffers to me aswell?:(

It will be a mess to uinstall, i just have the settings problem:(

I don't know what you're referring to by "the settings problem".

Lionel, you uninstall products in the same place as you install them. Use the drop down menu.

[Lionel]

WOW, settings are gone, I deleted tables, and on reinstall, I get errors again

[jesus likes pie]

Wow the upgrade.txt thing included in 1.0.1 is kind of confusing.....

[TsirhCitna]

I don't know what you're referring to by "the settings problem".

Lionel, you uninstall products in the same place as you install them. Use the drop down menu.It shows the only installed product as vBulletin.

[lanc3lot]

I repost then:)

John there is also another bug.

I tried to change the settings in one of the games and see the outcome:

Database error in vBulletin 3.5.0:

Invalid SQL:
UPDATE vb3new_arcade_games SET
title='Asteroids',
description='Η εποχή των 80s επιστρέφει, με ένα ακόμα παιχνίδι της Retro κατηγορίας του gamers.gr',
width='500',
height='375',
gamepermissions='7',
minpoststotal='1',
minpostsperday='0',
minpoststhisday='0',
minreglength='0',
minrep='0',
categoryid='3',
isreverse='0'
WHERE gameid=7;

MySQL Error : Unknown column 'minpoststhisday' in 'field list'
Error Number : 1054
Date : Wednesday, November 30th 2005 @ 02:16:42 AM
Script : http://www.gamers.gr/forums/admincp/arcadeadmin.php
Referrer : http://www.gamers.gr/forums/admincp/arcadeadmin.php?do=editgame&gameid=7&s=
IP Address : 212.54.217.231
Username : lancelot
Classname : vb_database

[Lionel]

I don't know what you're referring to by "the settings problem".

Lionel, you uninstall products in the same place as you install them. Use the drop down menu.

John, problem is the product disappeared, not to be found in that place, after I upgraded from 1.0 to 1.01. I manually deleted the tables, and since settings were empty in admincp, nothing was necessary.. However on re installing I get the same errors.

[Moparx]

John, can you make arcadetools.php check to see if a table exists before it trys to add/remove/modify it? that would probably clear up alot of issues.

I assume 1.0.0's 'uninstaller' doesnt uninstall correctly.. as i cant reinstall without errors

[Lionel]

Here is the error I get after I drop all tables and try to start from scratch

Database error in vBulletin 3.5.1:
Invalid SQL:
ALTER TABLE vb3_arcade_categories ADD categoryid int(10) unsigned NOT NULL auto_increment;
MySQL Error : Duplicate column name 'categoryid'
Error Number : 1060
Date : Tuesday, November 29th 2005 @ 08:40:53 PM

[Moparx]

Here is the error I get after I drop all tables and try to start from scratch

Database error in vBulletin 3.5.1:
Invalid SQL:
ALTER TABLE vb3_arcade_categories ADD categoryid int(10) unsigned NOT NULL auto_increment;
MySQL Error : Duplicate column name 'categoryid'
Error Number : 1060
Date : Tuesday, November 29th 2005 @ 08:40:53 PM

ya thats the error that is plaguing me

[Cap'n Steve]

Usergroup settings for minimum posts/reputation etc

This is easy to do with Promotions, unless you're talking about setting permissions for individual games.

To everyone who has it installed but can't see the link in their navigation panels, try going to the Plugin Manager, Editing a plugin and saving it without changing anything. For some reason, this fixed it when I was having the same problem with another hack.

[Snoop-It]

SQL query:

ALTER TABLE vb3_arcade_categories ADD categoryid int( 10 ) unsigned NOT NULL AUTO_INCREMENT

MySQL said: Documentation
#1075 - Incorrect table definition; There can only be one auto column and it must be defined as a key

I dont have a clue what im doing, could some 1 guide me the exact code to paste in phpmyadmin

[Lionel]

Oh man, version 1.0 was working perfect. Just don't know what took me to be among the first to upgrade. Now I've got nothing :-(

[Snoop-It]

^^ i hear ya, my whole enitre arcade is wiped off... :/

[John]

Uninstall the product.

Run each of these queries one by one.

ALTER TABLE usergroup DROP arcadepermissions
ALTER TABLE user DROP arcadeoptions
ALTER TABLE arcade_games DROP isreverse
ALTER TABLE user DROP challengecache
DROP TABLE IF EXISTS arcade_challenges
DROP TABLE IF EXISTS arcade_categories
DROP TABLE IF EXISTS arcade_games
DROP TABLE IF EXISTS arcade_news
DROP TABLE IF EXISTS arcade_sessions
DROP TABLE IF EXISTS arcade_ratings

So far, all of the errors I've seen here were solved on my table prefix installation by the latest installation. Because I can't replicate this problem it's very difficult for me to fix it.

[lanc3lot]

Sorry to repeat again, but that includes the setting problem i just posted again 3 posts above?
:(

[John]

Sorry to repeat again, but that includes the setting problem i just posted again 3 posts above?
:(

Anyone having problems.

[Snoop-It]

^^ that hasnt made a difference for my board, its wiped off my champion hack though.. and still seeing this error...

Invalid SQL:
ALTER TABLE vb3_arcade_categories ADD categoryid int(10) unsigned NOT NULL auto_increment;

MySQL Error : Duplicate column name 'categoryid'
Error Number : 1060

what to do...??!?!

[Retell]

Mine seems to be working fine after upgrade, seems exactly the same as before. I did have to do ALOT of SQL editing on my part before, but I have to admit John, you did a great job on 1.0.1 let me know if you need any thing from me :D

[Lionel]

Yes.

Invalid SQL:
ALTER TABLE vb3_arcade_categories ADD categoryid int(10) unsigned NOT NULL auto_increment;
MySQL Error : Duplicate column name 'categoryid'
Error Number : 1060
Date : Tuesday, November 29th 2005 @ 09:05:13 PM

[Moparx]

Yes.

Invalid SQL:
ALTER TABLE vb3_arcade_categories ADD categoryid int(10) unsigned NOT NULL auto_increment;
MySQL Error : Duplicate column name 'categoryid'
Error Number : 1060
Date : Tuesday, November 29th 2005 @ 09:05:13 PM

I am also still getting this when trying to import the product file

[Retell]

^^ that hasnt made a difference for my board, its wiped off my champion hack though.. and still seeing this error...

Invalid SQL:
ALTER TABLE vb3_arcade_categories ADD categoryid int(10) unsigned NOT NULL auto_increment;

MySQL Error : Duplicate column name 'categoryid'
Error Number : 1060


what to do...??!?!

try going into phpmyadmin and deleteing everything that has to do with arcade, all databases and the stuff in usergroup and user. Then go into the product, edit the uninstaller, by deleting all the SQL uninstall steps. Then uninstall V3. Upload the XML again and it should work. Hope That Helps :P

[Snoop-It]

try going into phpmyadmin and deleteing everything that has to do with arcade, all databases and the stuff in usergroup and user. Then go into the product, edit the uninstaller, by deleting all the SQL uninstall steps. Then uninstall V3. Upload the XML again and it should work. Hope That Helps :P

yeh i know that, im trying to avoid all of that as i spent a lot of time adding stuff on the arcade... iv already lost all previous data from 3.0.x then tried members to play games again, comment etc.. and now i think thats wiped off as well.. isn't there 1 code line or something i can add or is this long way the only option i have??

[lanc3lot]

Anyone having problems.


Damn:(

I hoped that as it not a major problem, and only a prob that u maybe can find a fix, it could be solved like this...and not to have uninstall everything, loose the scores and the games:(

Damnnnnnnnnn:(

[TsirhCitna]

Uninstall the product.

Run each of these queries one by one.

ALTER TABLE usergroup DROP arcadepermissions
ALTER TABLE user DROP arcadeoptions
ALTER TABLE arcade_games DROP isreverse
ALTER TABLE user DROP challengecache
DROP TABLE IF EXISTS arcade_challenges
DROP TABLE IF EXISTS arcade_categories
DROP TABLE IF EXISTS arcade_games
DROP TABLE IF EXISTS arcade_news
DROP TABLE IF EXISTS arcade_sessions
DROP TABLE IF EXISTS arcade_ratings

So far, all of the errors I've seen here were solved on my table prefix installation by the latest installation. Because I can't replicate this problem it's very difficult for me to fix it.Isn't that going to drop all of the current scores? To duplicate the problem everyone seems to be having just try to upgrade from 1.0.0 to 1.0.1. That's all I have done.

[Lionel]

I uninstalled many times. But why on a fresh re install every one is having that Duplicate column name 'categoryid'

[Snoop-It]

I uninstalled many times. But why on a fresh re install every one is having that Duplicate column name 'categoryid'
im just upgrading from 1.0.0 to 1.0.1 (overwrite files & product) and got that error. :disappointed:

[John]

The reason this is so damn frustrating is that all the errors you guys are posting here are bugs that I've already fixed, because I was experiencing them on my prefixed test forums.

I've just installed, uninstalled, and reinstalled on my prefix forums about ten times without problems. If you're having problems, email me your class_database_analyse.php file to john {at} eovie.com.

[Snoop-It]

The reason this is so damn frustrating is that all the errors you guys are posting here are bugs that I've already fixed, because I was experiencing them on my prefixed test forums.

I've just installed, uninstalled, and reinstalled on my prefix forums about ten times without problems. If you're having problems, email me your class_database_analyse.php file to john {at} eovie.com.

there wernt no error on my board for the arcade anyway...? anywho.. im emailing you my file then.. the exact one downloaded from here.. its a database error though isn't it? not a file error? :ermm: i dunno :speechless: :nervous:

[Moparx]

Its fixed for me now... I forgot to reupload class_database_analyse.php this last update.
Thanks John

[John]

there wernt no error on my board for the arcade anyway...? anywho.. im emailing you my file then.. the exact one downloaded from here.. its a database error though isn't it? not a file error? :ermm: i dunno :speechless: :nervous:

dholaholic, the file you just sent me is not the latest revision.

[fringehead]

I have posted two time and have seen numerous replied to other posts... No help for me?

[John]

I have posted two time and have seen numerous replied to other posts... No help for me?

This? https://vborg.vbsupport.ru/showpost.php?p=836084&postcount=684

[Snoop-It]

its the one i just downloaded 20mins ago.. unless you updated the pack... iv just downloaded it right now again and sent you the file... let me know if thats the latest 1??

[John]

its the one i just downloaded 20mins ago.. unless you updated the pack... iv just downloaded it right now again and sent you the file... let me know if thats the latest 1??

Yes, that's the correct file.

[TsirhCitna]

The reason this is so damn frustrating is that all the errors you guys are posting here are bugs that I've already fixed, because I was experiencing them on my prefixed test forums.

I've just installed, uninstalled, and reinstalled on my prefix forums about ten times without problems. If you're having problems, email me your class_database_analyse.php file to john {at} eovie.com.I feel kinda dumb here, but I just fixed the problem by uploading all the files again. I'm guessing that everyone did the samething I did when you updated the .zip, they just tried to install the new product or use the dbfix.

[Snoop-It]

ok now the product installs... but my arcade... lost all the games and its onlyshowing >> ALL, RANDOM (what happened to the others??)

[Lionel]

Its fixed for me now... I forgot to reupload class_database_analyse.php this last update.
Thanks John

looks like I had the same mistake too.

[Moparx]

Now that its working for me:
- Had to use v3arcades site to reinstall all the default games as they didnt show up
- The game categories didnt get added this time around

Both are minor issues (for me anyway) and everything else works perfectly

[fringehead]

This? https://vborg.vbsupport.ru/showpost.php?p=836084&postcount=684


yep... any ideas? Thanks!

[Snoop-It]

Now that its working for me:
- Had to use v3arcades site to reinstall all the default games as they didnt show up
- The game categories didnt get added this time around

Both are minor issues (for me anyway) and everything else works perfectly

yeah i know, same here. i got to look and copy the categories of v3arcade... and installgames off their.

Thanks John for fixing this up for me / us. Much Aprriciated :)

[Retell]

Anyones help reqs go un answered?

[Lionel]

I tried to go to v3arcade site and I get It doesn't look like the URL you entered points to the Arcade on your site. If you're sure it's correct, make sure guests can view your Arcade installation and try again.

[Retell]

I tried to go to v3arcade site and I get

well do you have guest permision? I know on my install that wasn't set as default.

[lanc3lot]

My heart is back again:)

I uploaded all the files again and run the arcadetools.php?do=fixdb and now even the game settings are seems to working:)

Thnx john, sorry if i asked many times:)

[Lionel]

I am also missing the navigation that I had before

[John]

yep... any ideas? Thanks!

You probably weren't answered because it has been asked many times before, set your usergroup permissions.