Log in

View Full Version : Major Additions - ibProArcade - professional Arcade System


Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 [30] 31

mystiksven
08-29-2015, 08:35 PM
Hello,
Itried to install the arcade on my 4.2.3 board. The instruction says

In this navbar-Template search for:

vBulletin 4.x

<li><a href="calendar.php{vb:raw session.sessionurl_q}">{vb:rawphrase calendar}</a></li>

Cannot find this in the template and don?t know where i shall add the following line now


Below add:

<li><a href="arcade.php{vb:raw session.sessionurl_q}">Arcade</a></li>

Maybe someone can give me a hint :D

stangger5
08-30-2015, 09:09 AM
Install this: ibProArcade Tab in Navbar vb4.2
https://vborg.vbsupport.ru/attachment.php?attachmentid=138153&d=1335925004

mystiksven
08-30-2015, 10:54 AM
Many Thanks stangger5 - this fixed the problem :p

Have another prob now. It looks weird on the custom skins - see the pic. Logo / Banner aren?t shown too.

Many Thanks :D

stangger5
09-02-2015, 03:05 PM
Try this:
New Template attachment (no longer need to add the contents of the ARCADE.css to Adittional.css
https://vborg.vbsupport.ru/attachment.php?attachmentid=138153&d=1335925004

mystiksven
09-02-2015, 04:00 PM
Hello stangger5,

The link down?t work.

Many Thanks :D

stangger5
09-05-2015, 02:32 PM
Give the link a try now..

mystiksven
09-05-2015, 06:58 PM
Many Thanks - the link works :p

There is still one lill prob left - u see it on the screen shot.

stangger5
09-07-2015, 03:54 PM
Add this to the ARCADE.css

legend{color:#ffffff;}

mystiksven
09-08-2015, 01:23 PM
Many thanks. I did this but it didn?t change it :(

MIWASA
09-15-2015, 06:09 PM
Hey There. Have upgraded vb from 4.2.2 to 4.2.3. Scores used to save previously. However since upgrade whenever game finishes, just takes me back to homepage, any advice appreciated

stangger5
09-16-2015, 04:05 PM
Do the (INFO - vbadvanced or another Portal) edit that comes with the arcade.

Edit your index.php file..

rinkrat
09-17-2015, 01:01 AM
Doing the edit on index.php to get it to save the scores brings these errors:

[Wed Sep 16 19:54:34 2015] [error] [client 71.93.XXX.XXX] PHP Notice: Undefined index: module in /var/www/html/index.php on line 3
[Wed Sep 16 19:54:34 2015] [error] [client 71.93.XXX.XXX] PHP Notice: Use of undefined constant act - assumed 'act' in /var/www/html/index.php on line 42
[Wed Sep 16 19:54:34 2015] [error] [client 71.93.XXX.XXX] PHP Notice: Undefined index: act in /var/www/html/index.php on line 42
[Wed Sep 16 19:54:34 2015] [error] [client 71.93.XXX.XXX] PHP Notice: Use of undefined constant autocom - assumed 'autocom' in /var/www/html/index.php on line 43
[Wed Sep 16 19:54:34 2015] [error] [client 71.93.XXX.XXX] PHP Notice: Undefined index: autocom in /var/www/html/index.php on line 43
[Wed Sep 16 19:54:34 2015] [error] [client 71.93.XXX.XXX] PHP Notice: Use of undefined constant showuser - assumed 'showuser' in /var/www/html/index.php on line 44
[Wed Sep 16 19:54:34 2015] [error] [client 71.93.XXX.XXX] PHP Notice: Undefined index: showuser in /var/www/html/index.php on line 44

Every user gives these errors so it fills up the error log all day. Any way to fix it?

stangger5
09-18-2015, 05:35 PM
Mind if I have a look ?

rinkrat
09-18-2015, 08:55 PM
Not much to see. I did the edit needed to save the scores and it triggers all of these errors. I searched google for it and it appears that a lot of people have the same problem although I can't find a fix. The program still works just gives off errors for every single user on my site.

stangger5
09-19-2015, 11:11 AM
What did you edit the index.php file with ?

I`ve always have used Textpad.

blind-eddie
09-19-2015, 10:33 PM
Doing the edit on index.php to get it to save the scores brings these errors:

[Wed Sep 16 19:54:34 2015] [error] [client 71.93.XXX.XXX] PHP Notice: Undefined index: module in /var/www/html/index.php on line 3
[Wed Sep 16 19:54:34 2015] [error] [client 71.93.XXX.XXX] PHP Notice: Use of undefined constant act - assumed 'act' in /var/www/html/index.php on line 42
[Wed Sep 16 19:54:34 2015] [error] [client 71.93.XXX.XXX] PHP Notice: Undefined index: act in /var/www/html/index.php on line 42
[Wed Sep 16 19:54:34 2015] [error] [client 71.93.XXX.XXX] PHP Notice: Use of undefined constant autocom - assumed 'autocom' in /var/www/html/index.php on line 43
[Wed Sep 16 19:54:34 2015] [error] [client 71.93.XXX.XXX] PHP Notice: Undefined index: autocom in /var/www/html/index.php on line 43
[Wed Sep 16 19:54:34 2015] [error] [client 71.93.XXX.XXX] PHP Notice: Use of undefined constant showuser - assumed 'showuser' in /var/www/html/index.php on line 44
[Wed Sep 16 19:54:34 2015] [error] [client 71.93.XXX.XXX] PHP Notice: Undefined index: showuser in /var/www/html/index.php on line 44



Every user gives these errors so it fills up the error log all day. Any way to fix it?

I have received the same errors from the time the index.php edit was added.

rinkrat
09-20-2015, 12:48 AM
The worst part is that every user to your index.php triggers all these errors, not just the arcade users. Brutal. I had to disable the arcade till I can find a fix.

stangger5
11-17-2015, 04:32 PM
I think,, its your redirect.. It takes out your www.

rinkrat
11-17-2015, 04:43 PM
Thanks. I'll look into that! I use the redirect because VBShout won't load from www. only without it.

Is there something I could do to the redirect or to index.php to fix it?

macfan365
12-01-2015, 05:51 PM
So I'm having some issues with my arcade (http://therecommunity.net/arcade.php).

My templates aren't coming out right. I took a look at my navbar and this is all I have as a template:

<div id="middle_header">
<vb:if condition="$stylevar['titleimage']"><a name="top" href="{vb:link forumhome}" class="logo-image"><img src="{vb:stylevar titleimage}" alt="{vb:rawphrase x_powered_by_vbulletin, {vb:raw vboptions.bbtitle}}" /></a></vb:if>
<div id="navbar" class="navbar">
<ul id="navtabs" class="navtabs floatcontainer<vb:if condition="$show['member'] AND $notifications_total"> notify</vb:if>">
{vb:raw template_hook.navtab_start}
{vb:raw navigation}
{vb:raw template_hook.navtab_end}
</ul>
</div>
</div>
</div>
</div><!-- closing div for above_body -->

<div class="body_wrapper">
<div id="breadcrumb" class="breadcrumb">
<ul class="floatcontainer">
<li class="navbithome"><a href="index.php{vb:raw session.sessionurl_q}" accesskey="1"><img src="{vb:stylevar imgdir_misc}/navbit-home.png" alt="{vb:rawphrase home}" /></a></li>
{vb:raw navbits.breadcrumb}
{vb:raw navbits.lastelement}
</ul>
<hr />
</div>

{vb:raw ad_location.ad_navbar_below}
{vb:raw ad_location.global_below_navbar}

<vb:if condition="$show['notices'] AND THIS_SCRIPT != 'register'">
<form action="profile.php?do=dismissnotice" method="post" id="notices" class="notices">
<input type="hidden" name="do" value="dismissnotice" />
<input type="hidden" name="s" value="{vb:raw session.sessionurl}" />
<input type="hidden" name="securitytoken" value="{vb:raw bbuserinfo.securitytoken}" />
<input type="hidden" id="dismiss_notice_hidden" name="dismiss_noticeid" value="" />
<input type="hidden" name="url" value="{vb:raw return_link}" />
<ol>
{vb:raw notices}
</ol>
</form>
</vb:if>



Anyone can help me with this?

I also installed the navtab plugin and nothing happened.

stangger5
12-02-2015, 11:39 AM
I also installed the navtab plugin and nothing happened.

Did you look to see if its active ?
admincp >> Navigation Manager >> Arcade:
Choose "Edit" from the drop down to the right and click "Go".
Active need to be "YES".

macfan365
12-02-2015, 04:14 PM
Did you look to see if its active ?
admincp >> Navigation Manager >> Arcade:
Choose "Edit" from the drop down to the right and click "Go".
Active need to be "YES".


Still didn't help out with my problem I'm having. Check PM on your site. :)

stangger5
12-03-2015, 11:22 AM
Still didn't help out with my problem I'm having. Check PM on your site. :)

The ibProArcade Tab in Navbar is working fine..

Your problem was in the ARCADE_vB4 template.

Here`s the template edit:
https://vborg.vbsupport.ru/showthread.php?t=320968

IslamicBoard
12-03-2015, 11:29 PM
Is it possible to have your own games? Or are the games preselected?

ArcadeSyndicate
12-04-2015, 12:55 AM
sure you can use your own games. there are several sites you can download them.

karan2175
12-09-2015, 08:36 PM
Hello,
Itried to install the arcade on my 4.2.3 board. The instruction says



<li><a href="calendar.php{vb:raw session.sessionurl_q}">{vb:rawphrase calendar}</a></li>

Cannot find this in the template and don?t know where i shall add the following line now




<li><a href="arcade.php{vb:raw session.sessionurl_q}">Arcade</a></li>

Maybe someone can give me a hint :D

Had same problem, figured it out.. Thanks,

mjw1205
12-29-2015, 07:24 PM
None of the players high scores are saving on mine for some reason. not getting any php errors or anything of that sort. It shows the ammount of times played. Just no scores..http://usafdefender.com/arcade.php

Navi-Mann
12-31-2015, 07:19 AM
Suche die index.php auf deinem Server und f?r Folgendes dr?ber ein und Speicher es wieder auf deinem Server

Find the index.php on a server and for the following over it, and store it back to your server


<?php
// ibProArcade
if($_POST['module'] == "pnFlashGames")
{
require_once('./global.php');

switch($_POST['func'])
{
case "storeScore":
$_GET['act'] = "Arcade";
$_GET['module'] = "arcade";
$_GET['do'] = "pnFStoreScore";
break;

case "saveGame":
$_GET['do'] = "pnFSaveGame";
break;

case "loadGame":
$_GET['do'] = "pnFLoadGame";
break;

case "loadGameScores":
$gid = $vbulletin->input->clean_gpc('p', 'gid', TYPE_INT);
$uid= $vbulletin->userinfo['userid'];
$game = $db->query_first("SELECT * FROM " . TABLE_PREFIX . "games_scores WHERE mid=$uid AND gid = $gid ORDER BY score DESC LIMIT 0,1");
$scores = $game[score];

if($scores != false)
{
//Return true
print "&opSuccess=true&gameScores=$scores&endvar=1"; //send endvar to keep opSuccess separate from all other output from PostNuke
}
else
{
print "&opSuccess=false&error=Error&endvar=1";
}
break;
}
}

$act = $_GET[act];
$autocom = $_GET[autocom];
$showuser= $_GET[showuser];
if($act == "Arcade" || $autocom=="arcade") {
include "arcade.php";
exit();
}
if(!empty($showuser) && $showuser >= 1) {
$u = $showuser;
$_GET[u] = $showuser;
include "member.php";
exit();
}

// end of ibProArcade

Max_69
02-27-2016, 08:39 AM
Hi guys, i have this error when start with a game:

Deprecated: Assigning the return value of new by reference is deprecated in /data/vhosts/gameinvaders.it/httpdocs/forum/arcade.php on line 3191

Deprecated: Assigning the return value of new by reference is deprecated in /data/vhosts/gameinvaders.it/httpdocs/forum/arcade.php on line 4084

PHP Warning: Cannot modify header information - headers already sent by (output started at ..../arcade.php:3191) in ..../arcade.php on line 97

PHP Warning: Cannot modify header information - headers already sent by (output started at ..../arcade.php:3191) in ..../arcade.php on line 2677

PHP Warning: Cannot modify header information - headers already sent by (output started at ..../arcade.php:3191) in ..../arcade.php on line 2678

PHP Warning: Cannot modify header information - headers already sent by (output started at ..../arcade.php:3191) in ..../arcade.php on line 2679

PHP Warning: Cannot modify header information - headers already sent by (output started at ..../arcade.php:3191) in ..../arcade.php on line 2680

In the arcade.php i have this:

Deprecated: Assigning the return value of new by reference is deprecated in /data/vhosts/gameinvaders.it/httpdocs/forum/arcade.php on line 3191

Deprecated: Assigning the return value of new by reference is deprecated in /data/vhosts/gameinvaders.it/httpdocs/forum/arcade.php on line 4084

PHP Warning: Cannot modify header information - headers already sent by (output started at ..../arcade.php:3191) in ..../arcade.php on line 97

How resolve? Thanks

blind-eddie
02-27-2016, 11:40 AM
Hi guys, i have this error when start with a game:



In the arcade.php i have this:



How resolve? Thanks


Save a copy of the arcade.php file before you edit it.

Open arcade.php in your favorite editor.

Find all instances of =& and change it to = save

You may have to repeat these steps in other files. Remember to ALWAYS save a copy of the file before you edit it.

Max_69
02-27-2016, 01:32 PM
Fantastic...thanks so much!!!

DeejayKez
03-09-2016, 03:08 PM
Hello,
Itried to install the arcade on my 4.2.3 board. The instruction says



<li><a href="calendar.php{vb:raw session.sessionurl_q}">{vb:rawphrase calendar}</a></li>

Cannot find this in the template and don?t know where i shall add the following line now




<li><a href="arcade.php{vb:raw session.sessionurl_q}">Arcade</a></li>

Maybe someone can give me a hint :D

Strangely I didn't do this step and it all works fine

ArcadeSyndicate
03-09-2016, 03:13 PM
the install guide is old ;)

DeejayKez
03-09-2016, 04:32 PM
Lol, I guess so :)
Btw can someone explain where I can give moderators perms to run the arcade?

stangger5
03-13-2016, 02:20 PM
Only admin`s can run the arcade right now..

markoroots
03-15-2016, 05:12 PM
the install guide is old ;)
So must we do those modifications in the installation guide?

Because to me the plugin is not visualized good.
Look here: http://www.sigarettaelettronicaforum.com/arcade.php

Please guys what I can do to fix this?

stangger5
03-15-2016, 07:00 PM
Most of the arcade fixes are in this thread:
https://vborg.vbsupport.ru/showthread.php?t=282802

markoroots
03-15-2016, 08:44 PM
Many thanks Stangger. I'm going to make these changes.
Maybe can be good for you to add this link to the first post so you don't have to repeat many times. ;)
Can you please tell me if we must made all modifications shown in this file attached: Installation - vBulletin 3.5.x-3.8.x + 4.x - english.html ??

stangger5
03-16-2016, 03:14 PM
All you really need to do, is:
CHMOD the /arcade directory and all its subfolders to 0777
and
Import the Product-XML-File: ./includes/xml/product-ibproarcade.xml and click IMPORT

You dont have to edit the templates, if you dont want to..

If you have vb4.2, install the ibProArcade Tab in Navbar vb4.2
https://vborg.vbsupport.ru/showthread.php?t=309596

AllenBAN
03-16-2016, 05:55 PM
where would one get more games???

ArcadeSyndicate
03-18-2016, 03:31 PM
take a look at the signatures of other users :D

stangger5
03-21-2016, 09:55 PM
Lol, I guess so :)
Btw can someone explain where I can give moderators perms to run the arcade?

Here you go:
IbProArcade Managers
https://vborg.vbsupport.ru/showthread.php?goto=newpost&t=322184

ThailandTopper
03-22-2016, 02:19 AM
Hi,

I'm getting this error on the "showthread" page: PHP Warning: Illegal string offset 'type' in ..../includes/class_postbit.php(345) : eval()'d code on line 57

The only plugins active are the arcade and iquote. Any ideas?

VB4.2.3 running 2.7.3 of the arcade

PHP 5.5.32

---------------------------------------- I figured it out ------------------------------

Go to the plugin manager and disable crowns showing in the postbit .

stangger5
03-22-2016, 12:25 PM
Hi,

I'm getting this error on the "showthread" page: PHP Warning: Illegal string offset 'type' in ..../includes/class_postbit.php(345) : eval()'d code on line 57



To fix that, read this:
https://vborg.vbsupport.ru/showpost.php?p=2562649&postcount=5

ThailandTopper
03-23-2016, 03:04 AM
Thanks,

Made the change and it works like a dream....

boggseric
06-19-2016, 09:35 PM
To fix that, read this:
https://vborg.vbsupport.ru/showpost.php?p=2562649&postcount=5

I changed the two instances I could find that didn't have the single quotes and I'm still getting the message. Could someone post up their working code so I could compare?

illusioN-tEk
07-29-2016, 06:09 AM
Just installed this on 4.2.3 and everything works! however I need help on how to edit the font colors as I have a dark theme!

plz help!

stangger5
07-29-2016, 02:02 PM
For dark styles:

Change this in the ARCADE.css

.alt1, .alt1Active
{
color: #000000;
}
.alt2, .alt2Active
{
color: #000000;
}

to

.alt1, .alt1Active
{
color: #ffffff;
}
.alt2, .alt2Active
{
color: #ffffff;
}

:)

Dave
09-04-2016, 09:28 PM
If you have problems with this plugin when it comes to saving scores because the game name contains strings such as "delete", "update", etc., try replacing the ibp_cleansql function at the bottom of the arcade.php file with:

function ibp_cleansql($value)
{
global $vbulletin;
return $vbulletin->db->escape_string($value);
}

goxy63
10-11-2016, 01:27 PM
Arcade for vb5 ?
Is anyone having arcade and google adsense working, if so would you share a link with us?

ArcadeSyndicate
10-11-2016, 08:23 PM
try dragonbyte arcade for vb5...

https://vborg.vbsupport.ru/showthread.php?t=299200

stangger5
10-16-2016, 08:42 PM
Arcade for vb5 ?


I dont have vb5 to test with.

goxy63
11-01-2016, 08:47 AM
Guys, we should get together somehow and "force" MrZeropage to upgrade this to VB5 and also to fix some issues with VB4. Small donations and nice word can do miracles. Are we allowed to create separate thread in order to do this, to gather and see who is interested?
Can we talk about ammount of donations and to see how many of us are interested and later on to contact "Zeropage" and see is this possible.
If we are not together we cant do much, but together we can do a lot!

Mark.B
11-01-2016, 09:28 AM
Guys, we should get together somehow and "force" MrZeropage to upgrade this to VB5 and also to fix some issues with VB4. Small donations and nice word can do miracles. Are we allowed to create separate thread in order to do this, to gather and see who is interested?
Can we talk about ammount of donations and to see how many of us are interested and later on to contact "Zeropage" and see is this possible.
If we are not together we cant do much, but together we can do a lot!

Pretty sure you'll run into a blank on that, because of this:
my problem is that I don't have any vB5 license :p

goxy63
11-01-2016, 11:47 AM
Pretty sure you'll run into a blank on that, because of this:
Where would be proper place to ask "vBulletin Solutions, Inc" to simply give free licenses to some coders here?
This would benefit everyone, if only license is a problem but I am afraid there is more to this than just a license.
Only trying to do something, better than doing nothing.

In Omnibus
11-01-2016, 12:46 PM
Where would be proper place to ask "vBulletin Solutions, Inc" to simply give free licenses to some coders here?

In your dreams. It's not happening.

goxy63
11-01-2016, 01:45 PM
In your dreams. It's not happening.

It was an idea, suggestion. You sound like I placed my hand in your pocket :D
Big companies with lots of resources tend to invest in future, and this will be investing in future of VB.


Anyways, I am 99% sure that Ibproarcade will be upgraded to VB5 sooner or later, I bet sooner

Mark.B
11-01-2016, 02:21 PM
Where would be proper place to ask "vBulletin Solutions, Inc" to simply give free licenses to some coders here?
This would benefit everyone, if only license is a problem but I am afraid there is more to this than just a license.
Only trying to do something, better than doing nothing.

This comes up from time to time, and I can categorically state it isn't going to happen.

Mark.B
11-01-2016, 02:24 PM
It was an idea, suggestion. You sound like I placed my hand in your pocket :D
Big companies with lots of resources tend to invest in future, and this will be investing in future of VB.


Anyways, I am 99% sure that Ibproarcade will be upgraded to VB5 sooner or later, I bet sooner

This wouldn't be investing in the future of vB though - it would be investing in the future of people making add-ons and then selling them for profit (which is what would inevitably happen).

goxy63
11-01-2016, 05:58 PM
This wouldn't be investing in the future of vB though - it would be investing in the future of people making add-ons and then selling them for profit (which is what would inevitably happen).

As I can see many of us will not upgrade to VB5 as there is no enough modifications, would say that many of us will not go for VB5 without favorite modifications.
If you look at VB5 modifications that really looks pathetic now, after how many years ?

Things go two ways, no mods less sold licenses, more mods surely few more or much more (I dont know) licenses will be sold...
How it is not investing in VB future?
Its like when real estate companies invest in parks....

I upgraded to VB5 because I was thinking few of my active members would not mind that much when it comes to modifications like Ibproarcade, I was very wrong and now thinking to go back to VB4...

ps
Used VB5 license we can find from 80$, think about it.
And I bought my first VB license because of modifications, if in that time I would see just few modifications I would never purchase it....

Mark.B
11-01-2016, 10:45 PM
Reality is, the vast majority of customers are not interested in modifications. That's always been the case going right back to vB2.

If the company sarted offering free licenses for 'modification authors', how do you police that? Someone says they want one in order to write a modification - how do you make sure they do? And what classes as a 'modification'? Yesterday I wrote a small piece of code to push the vB5 PM chat icon below the username, instead of being on the same line. Is that a modification? Can I have a free license?

You would end up never selling any licenses because every user would become a 'modification author'. And you'd need a team of people to administer and police it - who would pay their wages?

It's all a moot point anyway. There's a reason no software company does this - it isn't remotely viable. And vBulletin won't be doing it, ever.

goxy63
11-01-2016, 11:38 PM
Reality is, the vast majority of customers are not interested in modifications.

If that is true I would agree with you, but how about all that modifications for VB4, I doubt that they were made beacuse "vast majority is not interested" !?

I am not asking for license, not for me or anyone else, just seeing that many coders would not upgrade their mods (simple or complex ones) to VB5 as they dont have VB5.... and saying that by my opinion this would be "win win" thing. I think that creator of "Ibproarcade" does not have VB5, in fact I am sure of that, and if he did this mod would probably be upgraded....

I just dont like seeing what I see here (vbulletin.org/com), this place now looks like it was nuked and here and there someone in hazmat suit walks through...

ps
I do understand that most of VB licenses are sold to people who dont need modifications, nor they will ever look for one, but I also understand that there is significant number of people who are

Mark.B
11-02-2016, 12:00 AM
Whilst the vbulletin.org community has always been very active, its users represent a very tiny percentage of vBulletin users generally. The vast majority of customers do not modify their boards at all, and that has always been the case. People who modify their forums are a significant but small minority.

A basic hook system has recently been added back to vB5. Reality is though, there hasn't been much interest. Repeated requests for input on hook locations get roundly ignored. So it's not really gained much traction.

Look at other platforms and the market for free modifications has contracted considerably. Most coders are now only interested in what they can sell. There are multiple and complicated reasons why that's happened, but it's the way the market is.

MarkFL
01-06-2017, 12:57 PM
I'm curious if anyone running vB 4.2.5 Beta 1 and PHP 7.x has managed to get this arcade running?

MarkFL
01-06-2017, 03:59 PM
I found the issue was that I am now using mysqli instead of mysql, so in the file "arcade.php", locate the line that reads:

$MYSQLI = 0; // set to 1 to use ibProArcade-mySQLi-driver (may cause problems!)

and change that to:

$MYSQLI = 1; // set to 1 to use ibProArcade-mySQLi-driver (may cause problems!)

Next, download the attached .PHP file and overwrite the file located at:

arcade/functions/dbclass_mysqli.php

with the attached file you downloaded. :)

MarkFL
01-06-2017, 04:14 PM
Also, when using mysqli, replace "admincp/arcade.php" with the attached file. :)

blind-eddie
01-11-2017, 09:01 AM
I am having a few members report and confirmed that they are not able to save any games to favorites on my 3.8.8 board and some cannot click their favorites tab in the arcade navbar without getting the following database error. This does not happen to all members nor does it affect only one usergroup.

mySQL query error: SELECT COUNT(gid) AS amount FROM games_list WHERE gid IN () ORDER BY gid

mySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY gid' at line 1
mySQL error code:
Date: Wednesday 11th 2017f January 2017 05:36:02 AM

And what is with the date showing this way?
I have no errors in the server error logs.

Any help from anyone in correcting this issue will be greatly appreciated.

Coder2016
03-20-2017, 10:38 PM
Hi

Maybe someone has a viable version for php 7.x?

On 5.6 it runs but when I switch to php 7.x, I get in the arcade.php error.

Thanks in advance.

MarkFL
03-20-2017, 10:50 PM
Hi

Maybe someone has a viable version for php 7.x?

On 5.6 it runs but when I switch to php 7.x, I get in the arcade.php error.

Thanks in advance.

A couple of posts back I posted fixes for PHP 7.x. :)

Coder2016
03-21-2017, 09:38 AM
Thanks Markfl but the error is still the same.

Have also the admincp / arcade.php exchanged and the dbclass_mysqli.php

My problem is the root arcade.php

This error message comes.

Parse error: syntax error, unexpected 'new' (T_NEW) in /www/xxx/xxxxx/forum/arcade.php on line 3205

Here is my arcade.php file.

Many Thanks

Coder2016
03-22-2017, 09:02 AM
Can not help?

MarkFL
03-22-2017, 02:19 PM
Can not help?

I provided the changes that took care of the errors I got with this product when upgrading to PHP 7.x. I can't really help with issues I can't replicate. :)

Coder2016
03-23-2017, 12:58 PM
@MarkFL

I had added in my last post from my arcade.php as a file attachment.

Did you look at them?

https://vborg.vbsupport.ru/showpost.php?p=2584146&postcount=7320

Coder2016
03-26-2017, 08:27 AM
UP...

Coder2016
04-04-2017, 02:55 PM
Hi,

In all styles the texts are black. Where can I change this please? With a black style one sees the writing not more.

How can I change this?

https://vborg.vbsupport.ru/external/2017/04/19.png

Many Thanks.

MarkFL
04-04-2017, 03:43 PM
Create plugin hooked at "parse_templates" with the following code:

if ((THIS_SCRIPT === 'arcade' OR strpos($_SERVER['REQUEST_URI'], 'arcade')) AND STYLEID == XX)
{
$template_hook['headinclude_css'] .= '<style>.alt1 legend {color: $FFFFFF !important;}</style>';
}

Change "XX" to the styleid of the dark style in which you are wanting to make the changes.

Coder2016
04-04-2017, 04:03 PM
Where exactly in acp do I have to do that?

MarkFL
04-04-2017, 04:12 PM
Follow:

AdminCP -> Plugins & Products -> Add New Plugin

Coder2016
04-04-2017, 04:18 PM
I have made.

https://vborg.vbsupport.ru/external/2017/04/18.png

But I get then a error message

syntax error, unexpected end of file on line 128 in /www/htdocs/xxx/xxx/includes/class_bootstrap.php(433) : eval()'d code
#0 /www/xxx/xxx/power/includes/class_core.php(4392): vB_Bootstrap->process_templates()
#1 /www/htdocs/xxx/xxx/includes/class_core.php(4350): vB_Template->__construct('navbar_link')
#2 /www/htdocs/xxx/xxx/includes/functions.php(3139): vB_Template::create('navbar_link')
#3 /www/htdocs/xxx/xxx/arcade/functions/functions.php(1381): construct_navbits(Array)
#4 /www/htdocs/xxx/xxx/arcade.php(496): display->do_output(Array)
#5 /www/htdocs/xxx/xxx/arcade.php(5542): Arcade->Arcade()
#6 {main}


Fatal User Error: syntax error, unexpected end of file on line 128 in ..../includes/class_bootstrap.php(433) : eval()'d code in ..../vb/vb.php on line 286


#1 : vbstop() called in ..../includes/class_core.php on line 6092
#2 : vbulletin_error_handler() called in on line
#3 : trigger_error() called in ..../vb/vb.php on line 286
#4 : vB::handleException() called in on line

MarkFL
04-04-2017, 04:28 PM
You didn't grab the entire block of code...you are missing the closing bracket for the if statement. :)

Coder2016
04-04-2017, 05:16 PM
Oh yes my mistake Had forgotten the clamps.

Unfortunately no change.

The font has remained the same.

https://vborg.vbsupport.ru/external/2017/04/17.png

MarkFL
04-04-2017, 05:20 PM
Oops...I had a typo in the code...replace "$FFFFFF" with "#FFFFFF"...that should work. :)

Coder2016
04-04-2017, 05:26 PM
Many Thanks . Now it fits everywhere.

Coder2016
04-04-2017, 05:53 PM
Now I have one more question.

How must the code be, if I would like to change this for several styles?

I've tried it so.

If ((THIS_SCRIPT === 'arcade' OR strpos ($ _ SERVER ['REQUEST_URI'], 'arcade')) AND STYLEID == 10,11)
{
$ Template_hook ['headinclude_css']. = '<Style> .old1 legend {color: #FFFFFF! Important;} </ style>';
}

But unfortunately this does not work. Get a error message.

Many Thanks.

MarkFL
04-04-2017, 05:56 PM
Try Using the code:

if ((THIS_SCRIPT === 'arcade' OR strpos($_SERVER['REQUEST_URI'], 'arcade')) AND in_array(STYLEID, array(10, 11)))
{
$template_hook['headinclude_css'] .= '<style>.alt1 legend {color: #FFFFFF !important;}</style>';
}

Coder2016
04-04-2017, 06:02 PM
Many Thanks. Now it works fine. :)

blind-eddie
04-04-2017, 07:03 PM
For those with dark styles, view this post.
https://vborg.vbsupport.ru/showpost.php?p=2534303&postcount=7198

stangger5
04-04-2017, 07:13 PM
For those with dark styles, view this post.
https://vborg.vbsupport.ru/showpost.php?p=2534303&postcount=7198

Thats what I use..;)

Coder2016
04-05-2017, 04:35 PM
Hi

I wanted to install some styles but the style is not right in the Arcade.

The view in the forum itself fits the style. Only when I go into the arcade then does the style no longer.

Give it a fix?

Many thanks for your help.

MarkFL
04-05-2017, 04:46 PM
One thing that needs to be done for any new style added is to edit the template "ARCADE_vB4" and add just above the closing </head> tag the following:

{vb:raw headinclude_bottom}

Coder2016
04-05-2017, 05:19 PM
Super many thanks to MarkFL. Exactly that was my problem. Now it's working.

Coder2016
04-05-2017, 05:43 PM
Have another question.

How can I display more?

https://vborg.vbsupport.ru/external/2017/04/16.png

In the ACP I find nothing.

For me, he always shows only one.

The latest champions and the latest player result


Many Thanks.

blind-eddie
04-05-2017, 05:59 PM
All arcade edits are in the arcade.php and in the arcade/skins/skin_Arcade.php


https://vborg.vbsupport.ru/showthread.php?t=178117

MarkFL
04-05-2017, 06:03 PM
From what I've noticed it will display up to the 5 newest champions (I don't see any way to change that in the settings), and 1 latest arcade score (which makes sense since there can only be one latest. :)

edit: Good find, Tim! :up:

blind-eddie
04-05-2017, 06:30 PM
I have just about every edit you can have in this arcade. lol

Coder2016
04-06-2017, 04:30 AM
I have just about every edit you can have in this arcade. lol


Thanks blind-eddie

What else do you have for the arcade?

blind-eddie
04-06-2017, 11:50 AM
You would need to compare mine to yours Coder2016 ti see the differences.
Follow the link to my arcade in my sig below to see all the custom edits and follow the link to stanggers5 site to see his vb4.2 arcade, he created and installed 99% of all edits within my arcade, he would be the one to speak to regarding your arcade edits.

Coder2016
04-06-2017, 08:49 PM
Hi,

I have php 7 running with the arcade.

Folds so far quite well.

Now I have however made a mistake.

If I want to evaluate a game, then these errors come

PHP Warning: Illegal stringOffset 'css_method' in .... / arcade / functions / functions.php on line 1438

PHP Warning: Illegal stringOffset 'img_dir' in .... / arcade / functions / functions.php on line 1444

PHP Warning: Illegal stringOffset 'css_text' in .... / arcade / functions / functions.php on line 1444

PHP Warning: Illegal stringOffset 'macro_id' in .... / arcade / functions / functions.php on line 1449

PHP Warning: Illegal stringOffset 'img_dir' in .... / arcade / functions / functions.php on line 1459


I hope you can help me there with a FIX.

Thanks in advance.

blind-eddie
04-06-2017, 08:53 PM
I do not know if the arcade is php 7 compatible.

MarkFL
04-06-2017, 09:03 PM
I do not know if the arcade is php 7 compatible.

With a few minor changes it is, which I posted a while back in this thread. :)

Coder2016
04-06-2017, 10:11 PM
Have a few posts back read but unfortunately no changes for the file functions.php found.

Coder2016
04-07-2017, 09:20 AM
With a few minor changes it is, which I posted a while back in this thread. :)

Where exactly are these changes? Unfortunately, nothing found.

MarkFL
04-07-2017, 10:35 AM
Where exactly are these changes? Unfortunately, nothing found.

The changes are in the files I uploaded. :)

DGrey2011
04-11-2017, 05:11 AM
Hello!

I have been using IbProArcade for a while now. However, it suddenly started to work very very slowly, it takes more than 1 minute for the main arcade page to load.

This happened both with version 2.7.2+ on a vBulletin 4.2.2 and it's happening the same on vBulletin 4.2.4. I then upgraded ibPro to 2.7.3+ but the issue is still there. Any suggestions?

Coder2016
04-15-2017, 01:07 AM
Hi,

Where are these links defined in the Arcade?

https://vborg.vbsupport.ru/external/2017/04/5.png

Many thanks.

dan325ci
05-16-2017, 03:57 PM
I just upgraded to vb 4.2.5 and i am getting a blank white page on the arcade.php page. (500 error)

Any ideas what might be causing this?

In Omnibus
05-16-2017, 04:14 PM
I just upgraded to vb 4.2.5 and i am getting a blank white page on the arcade.php page. (500 error)

Any ideas what might be causing this?

500 is a general server error.

If you have the actual error log it would help track down the specific issue.

The error(s) should be sent to the technical e-mail address in the config.php file

dan325ci
05-16-2017, 04:32 PM
500 is a general server error.

If you have the actual error log it would help track down the specific issue.

The error(s) should be sent to the technical e-mail address in the config.php file

Hi

here is the log:

[16-May-2017 18:11:21 UTC] PHP Parse error: syntax error, unexpected 'new' (T_NEW) in /home/username/public_html/forum/arcade.php on line 3191

Line 3191 is this:

$bbcode_parser =& new vB_BbCodeParser($vbulletin, fetch_tag_list());


It appears this only happened because i upgraded to php 7 also yesterday. So either i can go back to 5.6 which i was using before or fix this error

Any way to fix it? I think the "&" symbol is deprecated in PHP 7 but how to fix it?

MarkFL
05-16-2017, 04:55 PM
Yes, go through the file "arcade.php" and do a search/replace on =& to change them all to =. :)

You may also need to change line 35 to:

$MYSQLI = 1; // set to 1 to use ibProArcade-mySQLi-driver (may cause problems!)

dan325ci
05-16-2017, 05:09 PM
Did all those changes but now getting this:

ERROR: Cannot find database myforums_forums

There is a SQL error.
You can contact the board administrator by clicking here

Error Returned

MarkFL
05-16-2017, 05:13 PM
Did all those changes but now getting this:

ERROR: Cannot find database myforums_forums

There is a SQL error.
You can contact the board administrator by clicking here

Error Returned

Yes, I get that error on one PHP 7.x site (but it only happened all of a sudden after the arcade had been working well for months), but not another, and I haven't been able to resolve the issue yet. :(

dan325ci
05-16-2017, 05:17 PM
Yes, I get that error on one PHP 7.x site (but it only happened all of a sudden after the arcade had been working well for months), but not another, and I haven't been able to resolve the issue yet. :(


Furthermore, if i keep set $MYSQLI = 0;

I get this error:


Call to undefined function mysql_connect() on line 41 in /home/username/public_html/forum/arcade/functions/dbclass.php
#0 /home/username/public_html/forum/arcade.php(188): db_driver->connect()
#1 {main}


So, does that mean the only way to get this to work is downgrade to PHP 5.6 again?

Are these issues a result of upgrading to php 7 or 4.2.5??

MarkFL
05-16-2017, 05:27 PM
I believe these are issues related to the PHP/MySQL versions, not the vB version. I don't know how to resolve the other error, although I will admit not putting much time into it because in general, I always seem to have more important issues to deal with. :)

dan325ci
05-16-2017, 07:49 PM
I believe these are issues related to the PHP/MySQL versions, not the vB version. I don't know how to resolve the other error, although I will admit not putting much time into it because in general, I always seem to have more important issues to deal with. :)

well heres hoping you can help to identify it. it could just be a simple code issue. For now our entire arcade is down and i guess i will have to look for alternatives. :(

MarkFL
05-18-2017, 03:37 PM
well heres hoping you can help to identify it. it could just be a simple code issue. For now our entire arcade is down and i guess i will have to look for alternatives. :(

Here's how I was able to resolve the issue:


Rename "dbclass.php" to "dbclass_orig.php".
Rename "dbclass_mysqli.php" to "dbclass.php".

That brought back the arcade for me. :)

edit: I forgot to mention, these files are located in the "arcade/functions" folder.

MarkFL
05-19-2017, 01:45 AM
Another change that needs to be made so that the product settings work within the AdminCP is to edit the file "admincp/arcade.php" to change line 41 to:

$sql_driver = FUNCTIONS_PATH . "dbclass.php";

dan325ci
05-21-2017, 01:17 AM
Another change that needs to be made so that the product settings work within the AdminCP is to edit the file "admincp/arcade.php" to change line 41 to:

$sql_driver = FUNCTIONS_PATH . "dbclass.php";


This file already had the live above as you mentioned.


I also did all the previous changes you mentioned but still getting this error:

ERROR: Cannot find database myforums_forums

There is a SQL error.
You can contact the board administrator by clicking here

Error Returned

mySQL query error: SELECT arcade_access, p_require FROM usergroup WHERE usergroupid = 1

mySQL error:
mySQL error code:
Date: Sunday 21st 2017f May 2017 03:20:39 AM


and in the error logs the following:

[21-May-2017 03:09:31 UTC] PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; info has a deprecated constructor in /home/username/public_html/forum/arcade.php on line 112
[21-May-2017 03:09:31 UTC] PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; Arcade has a deprecated constructor in /home/username/public_html/forum/arcade.php on line 341
[21-May-2017 03:09:31 UTC] PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; FUNC has a deprecated constructor in /home/username/public_html/forum/arcade/functions/functions.php on line 3
[21-May-2017 03:09:31 UTC] PHP Warning: require(./arcade/functions/dbclass_mysqli.php): failed to open stream: No such file or directory in /home/username/public_html/forum/arcade.php on line 161
[21-May-2017 03:09:31 UTC] PHP Fatal error: require(): Failed opening required './arcade/functions/dbclass_mysqli.php' (include_path='.:/opt/cpanel/ea-php70/root/usr/share/pear') in /home/username/public_html/forum/arcade.php on line 161


Any other advice?

MarkFL
05-21-2017, 01:24 AM
What version of vB are you running? On the site where I was having the issue, I coincidentally upgraded to the latest vB 4.2.5 (I was running a Beta before) and then after the upgrade, I looked at the arcade issue again, and it was only then that the "Cannot find database" issue went away, and only then could I proceed with the changes I described in the past few posts. :)

bridge2heyday
05-22-2017, 12:39 AM
I took sometime checking this for a friend
on MYSQLI class I changed the connect function to
function connect()
{
$this->connection_id = mysqli_connect($this->obj['sql_host'], $this->obj['sql_user'], $this->obj['sql_pass'], $this->obj['sql_database']);
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

}
and at line 186
$this->query_id = mysqli_query($the_query, $this->connection_id);
connection should be the first parameter on mysqli_connect fuction not second parameter
$this->query_id = mysqli_query($this->connection_id, $the_query);
it is working fine now

dan325ci
05-23-2017, 11:01 AM
What version of vB are you running? On the site where I was having the issue, I coincidentally upgraded to the latest vB 4.2.5 (I was running a Beta before) and then after the upgrade, I looked at the arcade issue again, and it was only then that the "Cannot find database" issue went away, and only then could I proceed with the changes I described in the past few posts. :)

I upgraded from 4.2.4 to 4.2.5 and it broke. (but at the same time i went from PHP 5.6 to 7.0)

dan325ci
05-23-2017, 11:13 AM
I took sometime checking this for a friend
on MYSQLI class I changed the connect function to
function connect()
{
$this->connection_id = mysqli_connect($this->obj['sql_host'], $this->obj['sql_user'], $this->obj['sql_pass'], $this->obj['sql_database']);
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

}
and at line 186
$this->query_id = mysqli_query($the_query, $this->connection_id);
connection should be the first parameter on mysqli_connect fuction not second parameter
$this->query_id = mysqli_query($this->connection_id, $the_query);
it is working fine now


Tried these changes but not working :(

bridge2heyday
05-24-2017, 12:14 AM
Tried these changes but not working :(

you should use MySQLI
$MYSQLI = 1;
I tried this with PHP 5.6 .. but this problem should be solved for PHP 7 as well .. not aware about other problems

Sicilian
06-03-2017, 04:21 AM
Few weeks ago upgraded to vbulletin 4.2.4, now getting error below.

PHP Warning: Illegal string offset 'type' in ..../includes/class_postbit.php(345) : eval()'d code on line 110

Updated arcade from 2.7.2 to 2.7.3, still have the error. Any ideas anyone please?

This error shows where we have members who've won awards in the thread. Postbit and Postbit legacy have the relevant template edits.

If i disable Arcade error goes away.

Sicilian
06-03-2017, 04:38 AM
Few weeks ago upgraded to vbulletin 4.2.4, now getting error below.

PHP Warning: Illegal string offset 'type' in ..../includes/class_postbit.php(345) : eval()'d code on line 110

Updated arcade from 2.7.2 to 2.7.3, still have the error. Any ideas anyone please?

This error shows where we have members who've won awards in the thread. Postbit and Postbit legacy have the relevant template edits.

If i disable Arcade error goes away.

I've tried this too: https://vborg.vbsupport.ru/showpost.php?p=2562649&postcount=5

At the moment I've disable the hook.

MarkFL
06-05-2017, 12:22 AM
This file already had the live above as you mentioned.


I also did all the previous changes you mentioned but still getting this error:




and in the error logs the following:

[21-May-2017 03:09:31 UTC] PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; info has a deprecated constructor in /home/username/public_html/forum/arcade.php on line 112
[21-May-2017 03:09:31 UTC] PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; Arcade has a deprecated constructor in /home/username/public_html/forum/arcade.php on line 341
[21-May-2017 03:09:31 UTC] PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; FUNC has a deprecated constructor in /home/username/public_html/forum/arcade/functions/functions.php on line 3
[21-May-2017 03:09:31 UTC] PHP Warning: require(./arcade/functions/dbclass_mysqli.php): failed to open stream: No such file or directory in /home/username/public_html/forum/arcade.php on line 161
[21-May-2017 03:09:31 UTC] PHP Fatal error: require(): Failed opening required './arcade/functions/dbclass_mysqli.php' (include_path='.:/opt/cpanel/ea-php70/root/usr/share/pear') in /home/username/public_html/forum/arcade.php on line 161


Any other advice?

To fix the deprecated constructor warnings, download the file "arcade.php" and locate the class constructor beginning on line 112 which reads:

class info {

var $member = array();
var $input = array();
var $session_id = "";
var $base_url = "";
var $vars = "";
var $skin_id = "0";
var $skin_rid = "";
var $lang_id = "en";
var $skin = "";
var $lang = "";
var $server_load = 0;
var $version = "v1.3 Final";
var $lastclick = "";
var $location = "";
var $debug_html = "";
var $perm_id = "";
var $forum_read = array();
var $topic_cache = "";
var $session_type = "";

function info() {
global $sess, $std, $DB, $INFO, $vboptions, $vbulletin, $session;

$this->vars = &$INFO;

$this->vars['board_name'] = $vboptions['bbtitle'];
}
}

And change this to:

class info {

var $member = array();
var $input = array();
var $session_id = "";
var $base_url = "";
var $vars = "";
var $skin_id = "0";
var $skin_rid = "";
var $lang_id = "en";
var $skin = "";
var $lang = "";
var $server_load = 0;
var $version = "v1.3 Final";
var $lastclick = "";
var $location = "";
var $debug_html = "";
var $perm_id = "";
var $forum_read = array();
var $topic_cache = "";
var $session_type = "";

public function __construct() {
global $sess, $std, $DB, $INFO, $vboptions, $vbulletin, $session;

$this->vars = &$INFO;

$this->vars['board_name'] = $vboptions['bbtitle'];
}

function info() {
self::__construct();
}
}

Then look for the class constructor around line 345 that reads:

class Arcade

Scroll down about 12 lines and find:

function Arcade()

Change that to:

public function __construct()

Then after that function, around line 505 insert:

function Arcade()
{
self::__construct();
}

Save and upload that file to your server. Next, download and open the file "arcade/functions/functions.php and locate the constructor at line 3 and replace this code:

class FUNC {

var $time_formats = array();
var $time_options = array();
var $offset = "";
var $offset_set = 0;
var $num_format = "";
var $allow_unicode = 1;
var $get_magic_quotes = 0;

function FUNC() {
global $INFO, $vboptions, $vbulletin;

$this->time_options = array( 'JOINED' => $INFO['clock_joined'],
'SHORT' => $INFO['clock_short'],
'LONG' => $INFO['clock_long']
);

$this->num_format = ($INFO['number_format'] == 'space') ? ' ' : $INFO['number_format'];

$this->get_magic_quotes = get_magic_quotes_gpc();

}

With this:

class FUNC {

var $time_formats = array();
var $time_options = array();
var $offset = "";
var $offset_set = 0;
var $num_format = "";
var $allow_unicode = 1;
var $get_magic_quotes = 0;

public function __construct() {
global $INFO, $vboptions, $vbulletin;

$this->time_options = array( 'JOINED' => $INFO['clock_joined'],
'SHORT' => $INFO['clock_short'],
'LONG' => $INFO['clock_long']
);

$this->num_format = ($INFO['number_format'] == 'space') ? ' ' : $INFO['number_format'];

$this->get_magic_quotes = get_magic_quotes_gpc();

}

function FUNC() {
self::__construct();
}

Save the file and upload it to your server. :)

dan325ci
06-05-2017, 05:50 PM
Hi

I am having no luck fixing this

Here are my new errors with ALL the changes outlined by the two coders helped with above.

[05-Jun-2017 19:46:34 UTC] PHP Warning: mysqli_fetch_array() expects parameter 2 to be integer, string given in /home/username/public_html/forum/arcade/functions/dbclass_mysqli.php on line 276
[05-Jun-2017 19:46:34 UTC] PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; mod_arcade has a deprecated constructor in /home/username/public_html/forum/arcade/modules/mod_arcade.php on line 3
[05-Jun-2017 19:46:34 UTC] PHP Warning: mysqli_fetch_array() expects parameter 2 to be integer, string given in /home/username/public_html/forum/arcade/functions/dbclass_mysqli.php on line 276
[05-Jun-2017 19:46:34 UTC] PHP Warning: mysqli_fetch_array() expects parameter 2 to be integer, string given in /home/username/public_html/forum/arcade/functions/dbclass_mysqli.php on line 276
[05-Jun-2017 19:46:34 UTC] PHP Warning: mysqli_query(): (42000/1064): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 4 in /home/username/public_html/forum/arcade/functions/dbclass_mysqli.php on line 170
[05-Jun-2017 19:46:34 UTC] PHP Warning: mysqli_error() expects exactly 1 parameter, 0 given in /home/username/public_html/forum/arcade/functions/dbclass_mysqli.php on line 489



I moved another arcade over with no issues when upgrading to vb 4.2.5 but the difference is i didnt upgrade to php 7.0 at the same time as i did with this problem one. But this arcade seems to have issues even when reverting back to 5.6

MarkFL
06-05-2017, 06:05 PM
Hi

I am having no luck fixing this

Here are my new errors with ALL the changes outlined by the two coders helped with above.

[05-Jun-2017 19:46:34 UTC] PHP Warning: mysqli_fetch_array() expects parameter 2 to be integer, string given in /home/username/public_html/forum/arcade/functions/dbclass_mysqli.php on line 276
[05-Jun-2017 19:46:34 UTC] PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; mod_arcade has a deprecated constructor in /home/username/public_html/forum/arcade/modules/mod_arcade.php on line 3
[05-Jun-2017 19:46:34 UTC] PHP Warning: mysqli_fetch_array() expects parameter 2 to be integer, string given in /home/username/public_html/forum/arcade/functions/dbclass_mysqli.php on line 276
[05-Jun-2017 19:46:34 UTC] PHP Warning: mysqli_fetch_array() expects parameter 2 to be integer, string given in /home/username/public_html/forum/arcade/functions/dbclass_mysqli.php on line 276
[05-Jun-2017 19:46:34 UTC] PHP Warning: mysqli_query(): (42000/1064): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 4 in /home/username/public_html/forum/arcade/functions/dbclass_mysqli.php on line 170
[05-Jun-2017 19:46:34 UTC] PHP Warning: mysqli_error() expects exactly 1 parameter, 0 given in /home/username/public_html/forum/arcade/functions/dbclass_mysqli.php on line 489



I moved another arcade over with no issues when upgrading to vb 4.2.5 but the difference is i didnt upgrade to php 7.0 at the same time as i did with this problem one. But this arcade seems to have issues even when reverting back to 5.6

I have attached an edited version of "mod_arcade.php" to get rid of the deprecated constructor error. Upload it to the folder "arcade/modules".

MarkFL
06-05-2017, 06:23 PM
I just edited all of the PHP files in the "arcade/modules" folder to fix the class constructors. I have attached a .ZIP file containing them.

dan325ci
06-05-2017, 10:27 PM
I just edited all of the PHP files in the "arcade/modules" folder to fix the class constructors. I have attached a .ZIP file containing them.


Thanks for your efforts on this.

So, do I still need to do all those changes outlined earlier or just uploading these files will be good enough?

I am referring to those earlier changes outlined by yourself and the other coder to the arcade.php, function.php, dbclass.php and dbclass_mysqli.php files?


Getting this error now:

Call to undefined function mysql_connect() on line 41 in /home/username/public_html/forum/arcade/functions/dbclass.php
#0 /home/username/public_html/forum/arcade.php(192): db_driver->connect()
#1 {main}

MarkFL
06-05-2017, 11:09 PM
Thanks for your efforts on this.

So, do I still need to do all those changes outlined earlier or just uploading these files will be good enough?

I am referring to those earlier changes outlined by yourself and the other coder to the arcade.php, function.php, dbclass.php and dbclass_mysqli.php files?

The changes made to those files are in addition to, not instead of, the earlier changes. I just thought I would go ahead and look at all the scripts in the "arcade/modules" folder and rewrite the class constructors in them. :)

Coder2016
06-06-2017, 08:50 AM
Few weeks ago upgraded to vbulletin 4.2.4, now getting error below.

PHP Warning: Illegal string offset 'type' in ..../includes/class_postbit.php(345) : eval()'d code on line 110

Updated arcade from 2.7.2 to 2.7.3, still have the error. Any ideas anyone please?

This error shows where we have members who've won awards in the thread. Postbit and Postbit legacy have the relevant template edits.

If i disable Arcade error goes away.

Hello,

Unfortunately, I have the same error. How can I fix this? Thanks in advance.

dan325ci
06-06-2017, 12:51 PM
The changes made to those files are in addition to, not instead of, the earlier changes. I just thought I would go ahead and look at all the scripts in the "arcade/modules" folder and rewrite the class constructors in them. :)


Mark were those including the changes only referenced by you? or the other ones mentioned after your replies.

MarkFL
06-06-2017, 12:55 PM
It seems we all have differing issues, and the changes I have posted is what has worked for me. :)

BGObsession
06-11-2017, 03:25 PM
MarkFL has been graciously assisting me in getting my Arcade back up after I upgraded from 4.2.1 to 4.2.5 and also took my php from 5.4 to 7.1. With Mark's help we were able to at least get the Arcade to show up and the games work, but as you can see from the attached images, the template/display is ALL jacked up! It appears to me as if the page is trying to access details such as individual game info but can't find it, so it's putting the '%' symbols in as placeholders, but that's just a guess. I'm not a coder, just have some basic knowledge but have no idea how to correct the display. I'm going to continue to take advantage of Mark's generosity but if anyone else has ideas to help us they would be welcomed! And btw, vB.org is an awesome place full of awesome people :cheers:

MarkFL
06-11-2017, 03:44 PM
Try running the following manual SQL query:

SELECT * FROM `games_scores`

Do you see percent signs in the table data?

BGObsession
06-11-2017, 03:59 PM
Do you mean run it from the 'execute SQL query' function in vBulletin admincp? It tells me I don't have permission to do one. I tried to do it from within myphpadmin but got this error message:

Error
SQL query: Documentation

SELECT
*
FROM
'game scores' LIMIT 0, 25
MySQL said: Documentation

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''game scores' LIMIT 0, 25' at line 4

MarkFL
06-11-2017, 04:04 PM
In order to run manual SQL queries from within the AdminCP, you need to edit your "includes/config.php" file to add your userid to the list of users permitted to run such queries.

Look for this section in the file:

/* #### USERS WITH QUERY RUNNING PERMISSIONS ####
The users specified here will be allowed to run queries from the control panel.
See the above entries for more information on the format.
Please note that the ability to run queries is quite powerful. You may wish
to remove all user IDs from this list for security reasons. */
$config['SpecialUsers']['canrunqueries'] = '';

Add your userid to the last line. Suppose your userid is 1, then you would want:

/* #### USERS WITH QUERY RUNNING PERMISSIONS ####
The users specified here will be allowed to run queries from the control panel.
See the above entries for more information on the format.
Please note that the ability to run queries is quite powerful. You may wish
to remove all user IDs from this list for security reasons. */
$config['SpecialUsers']['canrunqueries'] = '1';

BGObsession
06-11-2017, 04:11 PM
I gave myself permissions, but the scores show up normally Mark, no '%' signs :)

MarkFL
06-11-2017, 04:23 PM
Based on the install code, here is the list of all the other tables created by this product:


games_settings
games_savedGames
games_league
games_list
games_settings
games_cats
tournament_players
tournaments
games_champs
badwords
macro
tournament_players_statut
games_session


Check those tables too for percent signs. :)

BGObsession
06-11-2017, 04:39 PM
Didn't see any '%' signs. Only thing of note was that there were zero results for 'games_savedGames' (and a few others like tournament info)

MarkFL
06-11-2017, 04:47 PM
Okay, well, I will be back tonight on your site to continue the investigation into the issue.

At least now I know those percent signs aren't in your database. :)

BGObsession
06-11-2017, 04:53 PM
You da man Mark!

blind-eddie
06-11-2017, 06:59 PM
What arcade php files are you editing?

MarkFL
06-11-2017, 11:59 PM
I have traced the issue to the setting "HTML-Title format"...whatever is the first character in that setting is what shows up all over the place. Why? I have no idea. I jus trtied for over 2 hours to figure that out with no success...and without FTP access, my ability to debug the issue is rather limited. :(

What arcade php files are you editing?

There's a long list of files I've edited to get rid of deprecated class constructor errors, mainly. :)

stangger5
06-12-2017, 05:38 PM
Looks like its not reading the lang file..

BGObsession
06-12-2017, 09:34 PM
Any idea how to fix this stangger5?

dan325ci
06-16-2017, 12:28 AM
MarkFL has been graciously assisting me in getting my Arcade back up after I upgraded from 4.2.1 to 4.2.5 and also took my php from 5.4 to 7.1. With Mark's help we were able to at least get the Arcade to show up and the games work, but as you can see from the attached images, the template/display is ALL jacked up! It appears to me as if the page is trying to access details such as individual game info but can't find it, so it's putting the '%' symbols in as placeholders, but that's just a guess. I'm not a coder, just have some basic knowledge but have no idea how to correct the display. I'm going to continue to take advantage of Mark's generosity but if anyone else has ideas to help us they would be welcomed! And btw, vB.org is an awesome place full of awesome people :cheers:


Oh i let this go for a bit. Took down my arcade but everyone misses it. I would love to get some assistance on the fix also. Is there anyway either one of you can help me if i give you server login credentials?

For the life of me i can't get it to work. I moved another site over and the arcade was ok. The problem here is our move from PHP 5.6 to 7.1 :mad:

MarkFL
06-16-2017, 12:40 AM
Oh i let this go for a bit. Took down my arcade but everyone misses it. I would love to get some assistance on the fix also. Is there anyway either one of you can help me if i give you server login credentials?

For the life of me i can't get it to work. I moved another site over and the arcade was ok. The problem here is our move from PHP 5.6 to 7.1 :mad:

I would be willing to give it a try. PM the FTP access information to me, along with the url of your site and login credentials to a full admin account, and I will see what I can do, but I can't promise anything. :)

Paul M
06-16-2017, 10:13 AM
For the life of me i can't get it to work. I moved another site over and the arcade was ok. The problem here is our move from PHP 5.6 to 7.1 :mad:
PHP 7 breaks a lot of old code (and hence modifications).
Thats why vBulletin 3 and vBulletin 4 themselves had to be updated.

JFYI, I run the V3 Arcade on my site, and that seems perfectly happy on PHP 7.

goxy63
06-18-2017, 10:34 AM
Is there any chance that I use VB4 for arcade and to bridge that with VB5 user profiles?
Some kind of bridge?
I lost most of users when I removed arcade games, now on VB5 my small forums are almost empty. Would like to offer them same games but would like to keep forums on vb5.
I would purchase new domain just for games and will purchase second hand vb4 license....some of users are begging me for months about this....
Ideas?

stangger5
06-30-2017, 06:19 PM
Any idea how to fix this stangger5?

For the life of me i can't get it to work. I moved another site over and the arcade was ok. The problem here is our move from PHP 5.6 to 7.1 :mad:[/QUOTE]

BGObsession arcade is Fixed..


Oh i let this go for a bit. Took down my arcade but everyone misses it. I would love to get some assistance on the fix also. Is there anyway either one of you can help me if i give you server login credentials?


Dan325ci, did you get your arcade working right?

BGObsession
06-30-2017, 07:01 PM
Just for the public record, stangger5 is a genius. He is the Rainman of the arcade. Thanks so much for your help and great job!

Coder2016
07-11-2017, 06:21 AM
Hi,

Has anyone already run his arcade on php 7.1?

I have today from php 7.0 to 7.1 posed. Unfortunately, a lot of errors come in the arcade.

Can someone please fix?

stangger5
07-11-2017, 03:35 PM
Hi,

Has anyone already run his arcade on php 7.1?

I have today from php 7.0 to 7.1 posed. Unfortunately, a lot of errors come in the arcade.

Can someone please fix?

Working with 7.0 and 7.1, Yes.
Mind if I have a look?

Coder2016
07-11-2017, 08:10 PM
Many Thanks stangger5. :)

Coder2016
07-23-2017, 05:23 PM
Hi,

If someone steals me a score, I get this email.

Hello Admin,

Your Highscore in the game monster has been hit by cindy.

Get it back ...

Link to the highscores of the game

Only the email is missing the link to the game.

How can I fix this?

Thank you in advance.

dan325ci
07-26-2017, 11:50 PM
For the life of me i can't get it to work. I moved another site over and the arcade was ok. The problem here is our move from PHP 5.6 to 7.1 :mad:
BGObsession arcade is Fixed..




Dan325ci, did you get your arcade working right?


Hi Stangger5

Sorry for the late reply, just saw this.

No i did not get it working and would love for you to have a look at it.

Thanks

dan325ci
07-26-2017, 11:53 PM
I would be willing to give it a try. PM the FTP access information to me, along with the url of your site and login credentials to a full admin account, and I will see what I can do, but I can't promise anything. :)

PM'd you. Sorry for the delay. Ive also asked Stangger, so whoever is up for it, thats great.

MarkFL
07-27-2017, 12:02 AM
I'd like to wait and see what stangger5 says, as he has more expertise with this product. Also, I am in the middle of several projects at the moment. :)

Coder2016
07-27-2017, 05:51 AM
Hi

what could that be.

If I install a game, then the umlaute like ö, ä, ü do not.

In the php file of the game agree the umlauts. Only when you installed the game, the umlauts no longer match.

Rakehel
09-19-2017, 11:15 AM
Can anyone tell me what the final fix was in regard to the HTTP 500 Error?

I'm still running VB 4.2.3, couldn't get the 4.2.5 install to work. (Still hoping to do that.) I've been wondering if the v4.2.5 install attempt broke the arcade. I hadn't checked on it until a member reported it to me, not many issues with the arcade prior to this.

I've tried the previously mentioned Module changes, including downloading the .zip file, as well as a couple of code changes that were mentioned here.

IB Pro Arcade 2.7.3+
PHP
5.6.31
MySQL
5.6.32

blind-eddie
09-19-2017, 09:55 PM
What 500 server error?

Rakehel
09-23-2017, 09:14 AM
A discussion began, or was ongoing in this post (https://vborg.vbsupport.ru/showpost.php?p=2586601&postcount=7357), fixes and edits were being sorted through. MarkFL had created some updated module files for download. (Did that.)

The error, when launching games:


HTTP 500 error
That’s odd... the website can’t display this page
The site may be under maintenance or could have a programming error.
Try this
Go back to the last page
Try contacting the website’s owner


As mentioned, I wasn't aware of the error until a member reported it. The arcade had been working fine before and after an attempt to upgrade to VB 4.2.5., which wouldn't work. Members had been using it.

I'm trying to determine if I need to get my host to upgrade software or try the v4.2.5 upgrade again. The upgrades and patches have always been successful. I was going to wait for the next VB upgrade.

IB Pro Arcade 2.7.3+
PHP
5.6.31
MySQL
5.6.32

Mark.B
09-24-2017, 08:15 AM
500 errors are server errors....you need to find out what the actual error is behind that. Your hosts can help with that.

If you had attempted an upgrade to 4.2.5, make sure you have put back ALL the old files from the previous version. Also, depending on where the upgrade failed, there may be issues with the database now also.

Note that there will not be a "next vB upgrade" for vBulletin 4. Development on vB4 is now at an end, aside from any security patches needed.

fanfan2017
09-24-2017, 05:51 PM
thank you

RedDevil
09-25-2017, 09:43 AM
Just upgraded to 4.2.5 and php 7.0 just get blank screen instead of arcade, im guessing there are compat issues?

gnrx
10-24-2017, 07:34 AM
Hello.
Recently, I installed this fantastic mod, but I have 3 problems/doubts:

1.-In instructions for installation, indicate this:
edit the Template navbar
search (in vb 4.x)
<li><a href="calendar.php{vb:raw session.sessionurl_q}">{vb:rawphrase calendar}</a></li>
In my case, not appears this code in this template.

2.-In my navbar, not appears the link for Arcade.

3.-My forum its in spanish, I view not have this language, but I view the foder with the languages files. How I can create a spanish file?

Sorry for this 3 doybts, and thanks in advanced!

Best regards!

BGObsession
10-27-2017, 01:25 PM
Just upgraded to 4.2.5 and php 7.0 just get blank screen instead of arcade, im guessing there are compat issues?

I have it up and running on my 4.2.5/7 board. stangger5 was able to fix all my issues - you might message him. Guy is an arcade genius.

blind-eddie
10-27-2017, 02:52 PM
I have it up and running on my 4.2.5/7 board. stangger5 was able to fix all my issues - you might message him. Guy is an arcade genius.

Link to his arcade is in my Sig below.
He is the most trust worthy person that I have ever met on the internet. It may take a day or two or three for me to get back to you because he's busy in life so, have patience.

stangger5
11-01-2017, 06:39 PM
ibProArcade Tab in Navbar vb4.2+
https://vborg.vbsupport.ru/showthread.php?t=309596

:)

gnrx
11-01-2017, 06:56 PM
ibProArcade Tab in Navbar vb4.2+
https://vborg.vbsupport.ru/showthread.php?t=309596

:)

Yes, after some day that I post my last post, I view ibProArcade Tab in Navbar vb4.2+ and install in my site. Works fine!!! :)

Regards!!

ReVenG
11-04-2017, 09:07 PM
Clean install of VB 4.2.5
setup ibproarcade v.2.7.3
php: 7.0.25
arcade directory permissions: 777

Visiting the arcade.php page is just blank. In admin cp, clicking on any links within the arcade tab (Arcade Main Settings, Game lists, Categories, etc) is just blank.

Is anyone else experiencing this or have a solution?

ArcadeSyndicate
11-05-2017, 08:48 PM
see #7418

Stratis
12-10-2017, 07:48 AM
How to change the order of phrase "Play"

Example:
From
Play Double Blast


To
Double Blast Play

156786 156787

In my language, meaning is better when Phrase is front.
Thanks for any help where to search.

Stratis
12-13-2017, 10:48 AM
No one?


Actually with some tests I put this code in skin:

<tr>
<td align="center" class="alt1"><a href="arcade.php?$session[sessionurl]do=playfull&amp;gameid={$entry['gid']}">{$ibforums->lang['gamebox_playpopup']}</a>
</td>
</tr>
but when I hover it I see this:
/arcade.php?do=playfull&gameid=does not fetch the id of the game. playfull&gameid=???

Any help?




EDIT
Found how for any concern
From this {$entry['gid']}
To this {$game['gid']}
and fetching works.

stangger5
12-13-2017, 10:53 PM
Looks like your using the v3 skin.

You need to edit this file:
arcade/modules/mod_arcade.php

Find two places that has
$this->links['click'] .= "<a href='".$ibforums->base_url."act=Arcade&amp;do=play&amp;gameid=".$gid."'>".$ibforums->lang['play_game'].$gname."</a>";

change them to,
$this->links['click'] .= "<a href='".$ibforums->base_url."act=Arcade&amp;do=play&amp;gameid=".$gid."'>".$gname.$ibforums->lang['play_game']."</a>";

:)

gnrx
12-16-2017, 09:05 AM
I have it up and running on my 4.2.5/7 board. stangger5 was able to fix all my issues - you might message him. Guy is an arcade genius.

For others questions, I go to update my php to php 7 (I have vb 4.2.5), I search a post of stangger5 for view if I have the problem with php7 how solved, but I don't view for works in php7.

Regards!

Stratis
12-16-2017, 10:04 AM
Looks like your using the v3 skin.

You need to edit this file:
arcade/modules/mod_arcade.php

Find two places that has
$this->links['click'] .= "<a href='".$ibforums->base_url."act=Arcade&amp;do=play&amp;gameid=".$gid."'>".$ibforums->lang['play_game'].$gname."</a>";change them to,
$this->links['click'] .= "<a href='".$ibforums->base_url."act=Arcade&amp;do=play&amp;gameid=".$gid."'>".$gname.$ibforums->lang['play_game']."</a>";:)

Thank you very much, I will do so.

Stratis
12-29-2017, 02:31 PM
Is there a change that must do to make this to work in php 7 (vb4.2.5)
Blank white pages (error 500)

Thanks in advanced

MarkFL
12-29-2017, 02:49 PM
Is there a change that must do to make this to work in php 7 (vb4.2.5)
Blank white pages (error 500)


Thanks in advanced

Yes, look back in the most recent pages of this discussion and I and others have uploaded files and advice. :)

Stratis
12-29-2017, 06:29 PM
Yes, look back in the most recent pages of this discussion and I and others have uploaded files and advice. :)
I have find all changes for any one is concerned.


vb4.2.5 and PHP 7 (White page at arcade.php(error 500) and white page at admincp arcade.php


1) https://vborg.vbsupport.ru/showpost.php?p=2580441&postcount=7315
2) https://vborg.vbsupport.ru/showpost.php?p=2580443&postcount=73163
3) https://vborg.vbsupport.ru/showpost.php?p=2587286&postcount=7375
4) https://vborg.vbsupport.ru/showpost.php?p=2587302&postcount=7378


P.S. admincp arcade.php is fixed but still have white pages to central arcade.php
I wiil make all changes again tomorrow, thanks Mark, I do not see that will fix it though :)

Stratis
12-30-2017, 03:37 PM
With the arcade.php I get this error 500

mod_fcgid: stderr: PHP Parse error: syntax error, unexpected 'new' (T_NEW) in /var/www/vhosts/TEST FORUM/httpdocs/arcade.php on line 3198, referer: https://www.TEST FORUM/forum.phpIts this in line.
$bbcode_parser =& new vB_BbCodeParser($vbulletin, fetch_tag_list());


I change it to this, as I read some posts back from MarkFL.
$bbcode_parser =. new vB_BbCodeParser($vbulletin, fetch_tag_list());
But now I get this error.
mod_fcgid: stderr: PHP Parse error: syntax error, unexpected '.' in /var/www/vhosts/TEST FORUM/httpdocs/arcade.php on line 3198, referer: https://www.TEST FORUM/forum.phpAny one can give a fix. Thanks :)

MarkFL
12-30-2017, 03:52 PM
I couldn't find the post of mine you're talking about, but you definitely don't want that period in there. :)

Stratis
12-30-2017, 04:56 PM
https://vborg.vbsupport.ru/showpost.php?p=2586603&postcount=7359 :)

MarkFL
12-30-2017, 05:08 PM
https://vborg.vbsupport.ru/showpost.php?p=2586603&postcount=7359 :)

Okay, the period was just the end of the sentence, but it was sloppy on my part...I should have used code blocks like so:

Yes, go through the file "arcade.php" and do a search/replace on

=&

to change them all to

=

Stratis
12-30-2017, 05:29 PM
Yes I did that from your previous post and it works.
So if any one has vb.4.2.5 and PHP 7xxx
- With patient do exactly all changes that are included in post #7431 (https://vborg.vbsupport.ru/showpost.php?p=2591922&postcount=7431) (4 post links) and the post above.
All changes by MarkFL are targeted and makes ibProArcade to work.


Thanks my friend :)

dan325ci
02-09-2018, 09:26 AM
I really have tried all the steps above and still get a blank white page.

BirdOPrey5
02-09-2018, 05:35 PM
I really have tried all the steps above and still get a blank white page.

Blank white screen means you should check your PHP Error log. Look for a file called error_log in your forum directory. It may vary on different servers.

dan325ci
02-10-2018, 12:26 AM
Blank white screen means you should check your PHP Error log. Look for a file called error_log in your forum directory. It may vary on different servers.

Actually i got the arcade to load but inside the admincp under the Arcade section, every option i click such as add game gives me this error:


Call to undefined function mysql_connect() on line 41 in /home/mydirectory/public_html/forum/arcade/functions/dbclass.php
#0 /home/mydirectory/public_html/forum/admincp/arcade.php(188): db_driver->connect()
#1 {main}


Any ideas? :confused:

MarkFL
02-10-2018, 12:32 AM
Try editing the file "arcade.php" in your forum's root folder, and look near the top of the file for the global switches and set $MSQLI to 1.

dan325ci
02-10-2018, 12:38 AM
Try editing the file "arcade.php" in your forum's root folder, and look near the top of the file for the global switches and set $MSQLI to 1.

Yep, that was already set to "1"

dan325ci
02-10-2018, 12:45 AM
I have attached the files i think that are relevant that i am currently using. If anyone has the chance can you have a quick look. Maybe i have missed something.

Stratis
02-10-2018, 06:38 AM
The only difference i have from yours files is "dbclass.php" I do not remember making changes to that file.

Here is mine.
156932


If no luck...
go to your plesk panel and press "Logs" see if you have a warning when you get white page. maybe there is a security rule?

stangger5
02-11-2018, 08:56 PM
You dont need dbclass.php

Did you edit the admincp/arcade.php file?

Change this:
// ##### DATABASE CONNECTION ############
$sql_driver = FUNCTIONS_PATH . "dbclass.php";

to:
// ##### DATABASE CONNECTION ############
$sql_driver = FUNCTIONS_PATH . "dbclass_mysqli.php";

:)

dan325ci
03-03-2018, 03:14 AM
You dont need dbclass.php

Did you edit the admincp/arcade.php file?

Change this:
// ##### DATABASE CONNECTION ############
$sql_driver = FUNCTIONS_PATH . "dbclass.php";

to:
// ##### DATABASE CONNECTION ############
$sql_driver = FUNCTIONS_PATH . "dbclass_mysqli.php";

:)

Thanks that seems to have done the trick. There was actually two parts that needed to be changed from dbclass.php to dbclass_mysqli.php within the arcade.php file.

gnrx
03-13-2018, 08:42 AM
Hi,
Today, I upgrade my server to php 7.1 (I use vbulletin 4.2.5) and now, I have a blank page or http 500 (with chromium http 500 error with firefox blank page).

I made this changes (indicate url for no longer post)
https://vborg.vbsupport.ru/showpost.php?p=2580441&postcount=7315
https://vborg.vbsupport.ru/showpost.php?p=2580443&postcount=73163
https://vborg.vbsupport.ru/showpost.php?p=2587286&postcount=7375
https://vborg.vbsupport.ru/showpost.php?p=2587302&postcount=7378

But continue with the same problem.
In admincp, I can access to arcade fine, but when I go in my forum to arcade.php I have blank page or http 500 error (chromium http 500 error firefox blank page).

Regards!

Edit: Like in my cPanel I can select the php version, I returned to 5.6.34, now, if access to arcade, appears this 2 error lines:
HP Warning: mysql_real_escape_string(): Access denied for user ''@'localhost' (using password: NO) in ..../arcade.php on line 5574

PHP Warning: mysql_real_escape_string(): A link to the server could not be established in ..../arcade.php on line 5574

gnrx
03-13-2018, 10:15 PM
Update my last post...

After read the last 10 or 15 pages of this thread, I can use arcade thanks at some post of MarkFL.

Indicate that I made:

Restore my full backup of Arcade.

Then, in the file "arcade.php" and do a search/replace on =& to change them all to =.
And change in line 35:
$MYSQLI = 1; // set to 1 to use ibProArcade-mySQLi-driver (may cause problems!)

Then, download the file and replace: arcade/functions/dbclass_mysqli.php (of this post (https://vborg.vbsupport.ru/showpost.php?p=2580441&postcount=7315))

Finally, also, when using mysqli, replace "admincp/arcade.php" with the attached filein this post (https://vborg.vbsupport.ru/showpost.php?p=2580443&postcount=73163).

Ok, now, with vb 4.2.5 and PHP 7.1 works Arcade but...I have the same problem that have BGObssesion (https://vborg.vbsupport.ru/showpost.php?p=2587424&postcount=7384)

I read all the post about this, not indicate how solved this, but I have the same problem.

In one post of stannger5 (https://vborg.vbsupport.ru/showpost.php?p=2587965&postcount=7401) indicate works, for not view how solved this...

Can help about this?

Thanks in advanced!

stangger5
03-26-2018, 03:13 PM
Give this a try:

Edit arcade/functions/functions.php

Find:
function load_words($current_lang_array, $area, $lang_type) {

require ROOT_PATH."arcade/lang/".$area.".php";

foreach ($lang as $k => $v)
{
$current_lang_array[$k] = stripslashes($v);
}

unset($lang);

return $current_lang_array;

}

and change it to:
function load_words($current_lang_array, $area, $lang_type) {

require ROOT_PATH."arcade/lang/".$area.".php";

$current_lang_array = array();

foreach ($lang as $k => $v)
{
$current_lang_array[$k] = stripslashes($v);
}

unset($lang);

return $current_lang_array;

}

:)

gnrx
03-26-2018, 03:34 PM
Dear stangger5, really fantastic! I take off my hat in front of you :)

Really fantastic, work perfect, all fine!!

Really, thanks! :)

Judith2
05-16-2018, 07:09 PM
Hello,

I have done everything described here. The admincp works again but the arcade itself has a blank page.

Judith2
05-20-2018, 12:56 PM
Hello?

Judith2
05-28-2018, 07:32 PM
Can no one help me?

gnrx
07-17-2018, 07:51 PM
Hello.
Today, I update my VPS to MySQL 5.7 and view that, I have a problem with ibPoArcade, when click for access appears this error:

There is a SQL error.
You can contact the board administrator by clicking here

Error Returned

mySQL query error: SELECT champ_gid AS GID, champ_mid AS MID, champ_name AS name, COUNT(champ_mid) AS total FROM games_champs GROUP BY MID ORDER BY total DESC LIMIT 3

mySQL error:
mySQL error code:
Date: Tuesday 17th 2018f July 2018 09:48:46 PM

We apologise for any inconvenience

I can't downgrade MySQL to 5.6, only if I restart full backup of my VPS...

Its possible solved this?

Thanks and regards!

BirdOPrey5
07-18-2018, 08:16 AM
I don't see a particular reason why

SELECT champ_gid AS GID, champ_mid AS MID, champ_name AS name, COUNT(champ_mid) AS total FROM games_champs GROUP BY MID ORDER BY total DESC LIMIT 3


Would fail on MySQL 5.7, I wonder if the table was properly upgraded. Try running that exact command from phpmyadmin and see if it works or if an error message comes back. Check you can browse the table games_champs.

gnrx
07-18-2018, 09:28 AM
Hello.
Thank for your reply and help.

I run the exact command from phpmyadmin:
SELECT champ_gid AS GID, champ_mid AS MID, champ_name AS name, COUNT(champ_mid) AS total FROM games_champs GROUP BY MID ORDER BY total DESC LIMIT 3
In phpmyadmin-SQL-Execute queries.
This is the result:

Error
consulta SQL: Documentaci?n

SELECT champ_gid AS GID, champ_mid AS MID, champ_name AS name, COUNT(champ_mid) AS total FROM games_champs GROUP BY MID ORDER BY total DESC LIMIT 3

MySQL ha dicho: Documentaci?n

#1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'MYUSER_MYDB.games_champs.champ_gid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

After this, continue the issue.
And yes, by phpmyadmin, can browse the table games_champs.

Regards!!

BirdOPrey5
07-18-2018, 10:31 PM
I don't know what other ramifications it might have but the logical conclusion from that error message is to disable the sql_mode "only_full_group_by."

Instructions on how to do this: https://stackoverflow.com/questions/23921117/disable-only-full-group-by

Judith2
07-19-2018, 06:25 PM
This error message I get when I open arcade :

"Call to undefined function print_cp_header() on line 1046 in C:\inetpub\vhosts\animalhelpeurope.de\httpdocs\vbf orum\arcade.php
#0 {main}"

gnrx
07-19-2018, 08:19 PM
I don't know what other ramifications it might have but the logical conclusion from that error message is to disable the sql_mode "only_full_group_by."

Instructions on how to do this: https://stackoverflow.com/questions/23921117/disable-only-full-group-by

I made this change in my.cnf, I disable the sql_mode "only_full_group_by", and now, work perfect, again work perfect!

Thanks for you attention and help!! :)

fookaa
08-17-2018, 01:46 PM
removed...........

Judith2
08-17-2018, 06:16 PM
I've done the update, but Admin cp and Arcade are blank.

fookaa
08-18-2018, 01:18 PM
removed..........

alfuzzy
10-13-2018, 04:46 PM
I know this thread is 498 pages long...thus maybe my questions have already been answered...but sort of a marathon to look thru all 498 pages.;)

Questions:

- Is ibProArcade fully compatible with vBulletin 4.2.5?
- What PHP versions is ibProArcade compatible with?

I know the original post says compatible with PHP4 & PHP5. But didn't know if PHP compatibility went further than that.

Thanks

MarkFL
10-13-2018, 05:01 PM
Prior to the latest update of this product, I got it to work with PHP 7.0.x and I know others have been successful in getting it to run as well.

For all I know, the latest update includes support for PHP 7.x but I was never clear about that, and so I opted not to update it.

stangger5
10-14-2018, 02:36 PM
I have it working with php 7.1.22 right now, with the edits in this thread.

The newest update was for one possible security-issue.
It doesnt have the edits for php 7.X

Pocket Aces
10-14-2018, 11:27 PM
this mod still works on versions in my signature, there are bugs though that need manual edit to fix so Ive decided to uninstall this and install a different arcade mod

gnrx
10-16-2018, 04:27 PM
I know this thread is 498 pages long...thus maybe my questions have already been answered...but sort of a marathon to look thru all 498 pages.;)

Questions:

- Is ibProArcade fully compatible with vBulletin 4.2.5?
- What PHP versions is ibProArcade compatible with?

I know the original post says compatible with PHP4 & PHP5. But didn't know if PHP compatibility went further than that.

Thanks

Like indicate MarkFL and stangger5, works with php 7.1 and vb 4.2.5, I work with this versions but with the changes/edits indicates in this thread :)

gnrx
10-17-2018, 08:21 AM
Sorry, today I view that, in 12 Aug 2018 it was updated to 2.7.4+ version, strangger5 indicate this about the update:

"The newest update was for one possible security-issue.
It doesnt have the edits for php 7.X"

Ok, if I updated to this version, we need re made the edits for work with php 7?

Thanks and regards.

stangger5
10-20-2018, 07:26 PM
Ok, if I updated to this version, we need re made the edits for work with php 7?


Yes..

MrZeropage
10-21-2018, 08:07 AM
Hello out there,

I prepared ibProArcade v2.7.5+ right now and tested it on vbulletin 4.2.5 with PHP 7.1
This version will also include some other improvements and changes, but before I release it, I want to ensure it is still compatible with older vB-versions 3.x/4.x

Anybody wants to test the preview of v2.7.5+ on his site with PHP5.x and older vBulletin 3/4 ?
Please contact me... thanks :)

gnrx
10-21-2018, 09:37 PM
Yes..
Ups...Apart from the editions for php7, I had to make other editions for the style, since I appeared with a "strange" style after an update, thanks to you and MarkFL everything was perfect.
If I must do all the edits / changes again ... before the update, I must collect all the information for the changes I made.

Hello out there,

I prepared ibProArcade v2.7.5+ right now and tested it on vbulletin 4.2.5 with PHP 7.1
This version will also include some other improvements and changes, but before I release it, I want to ensure it is still compatible with older vB-versions 3.x/4.x

Anybody wants to test the preview of v2.7.5+ on his site with PHP5.x and older vBulletin 3/4 ?
Please contact me... thanks :)
Ok, then I deduce that, the changes / editions for php 7 are no longer necessary in case of updating.
However, before making the update I will make a full backup, not for the editions for php7, but for the others that I had to do for style and others.

I do not have a version lower than 4.2.5, if I had it, I would do the test you mentioned.

x iJailBreak x
10-23-2018, 04:02 PM
this mod still works on versions in my signature, there are bugs though that need manual edit to fix so Ive decided to uninstall this and install a different arcade mod

What bugs?

MarkFL
10-26-2018, 05:56 PM
I downloaded and installed version 2.7.5 on my local dev site (vB 4.2.5/PHP 7.0.x) and it worked without any issues. So, I figured all was good and I installed on live site (vB 4.2.5/PHP 7.0.x), and get the following error:

Call to undefined function mysql_connect() on line 41 in /home/aspiri9/public_html/arcade/functions/dbclass.php
#0 /home/aspiri9/public_html/arcade.php(192): db_driver->connect()
#1 /home/aspiri9/public_html/dbseo.php(474): require('/home/aspiri9/p...')
#2 {main}

Any suggestions?

stangger5
10-26-2018, 06:29 PM
Do you have $MYSQLI = 1; at the top of the arcade.php file?

MarkFL
10-26-2018, 06:35 PM
Do you have $MYSQLI = 1; at the top of the arcade.php file?

That's the default value in the new version of this file, right? But I checked to make sure, and yes that's what I have.

stangger5
10-26-2018, 06:58 PM
Its should be calling: dbclass_mysqli.php

stangger5
10-26-2018, 07:06 PM
Give this a try:

Line 157, in the arcade.php main.
// $sql_driver = FUNCTIONS_PATH . "dbclass.php";

MarkFL
10-26-2018, 07:11 PM
Its should be calling: dbclass_mysqli.php

I figured out the issue, which was all my fault. I didn't have the database type set as "mysqli" in my config.php file.

All good now, and thanks for helping point me i the right direction. :)

MrZeropage
10-27-2018, 05:12 AM
You set vBulletin now to mysqli (config.php) or changed ibProArcade back to mysql?

I think I should read the config.php and use the value from there, to always fit the right database-driver... hmmmm first feature for v2.7.6 :cool:

stangger5
10-27-2018, 09:50 AM
You set vBulletin now to mysqli (config.php) or changed ibProArcade back to mysql?

I think I should read the config.php and use the value from there, to always fit the right database-driver... hmmmm first feature for v2.7.6 :cool:

I was thinking the same thing..

MrZeropage
10-27-2018, 10:48 AM
Yes, this will be the first feature of v2.7.6+ :)

Beside that, in the past hours I did a new converter for those coming from DBTech vBArcade and want to migrate to ibProArcade v2.7.5+ and convert their games and scores...

snakes1100
10-27-2018, 12:04 PM
@Marcel
Upgraded the 3.8 site i tested this on for ya earlier this week on 7.0 & 7.1, looks good.

hirlas
10-27-2018, 12:31 PM
This error is from my admin panel under Arcade menu.

ERROR: Cannot find database <removed>

There is a SQL error.
You can contact the board administrator by clicking here

mySQL query error: SELECT * FROM ahgames_settings

mySQL error:
mySQL error code:
Date:


I tried editing the arcade.php to reflect the new mysqli statement,

$sql_driver = FUNCTIONS_PATH . "dbclass_mysqli.php";


but still does not connect. Am I missing something obvious?

stangger5
10-27-2018, 01:15 PM
Did you upload and overwrite admincp/arcade.php and the includes folder files with the new one`s from 2.7.5+?

MarkFL
10-27-2018, 02:01 PM
You set vBulletin now to mysqli (config.php) or changed ibProArcade back to mysql?

I think I should read the config.php and use the value from there, to always fit the right database-driver... hmmmm first feature for v2.7.6 :cool:

The best I can tell, that's what you're already doing. It was because I had the config.php file set to "mysql" that the wrong dbclass file was being read. Your product was functioning correctly, it was because I had the wrong value in my config.php file that the problem occurred.

You have the following code in arcade.php:

// support for mysqli by MrZeropage
if ((strtolower($config['Database']['dbtype']) == "mysqli") && ($MYSQLI == 1))
{
$sql_driver = FUNCTIONS_PATH . "dbclass_mysqli.php";
}

That was what led me to check my config.php file, and there I discovered I needed to edit that file to define the db as "mysqli" and once I did everything worked flawlessly.

hirlas
10-27-2018, 04:10 PM
Did you upload and overwrite admincp/arcade.php and the includes folder files with the new one`s from 2.7.5+?

Brand new install using ibProArcade 2.7.5+.zip

vbulletin 4.2.3
php 5.6

MrZeropage
10-27-2018, 05:47 PM
@hirlas:

Cannot find database <removed>This is strange... looks like it does not find the DB itself ?!

Your TABLE_PREFIX seems to be "ah"
Which database-type you defined in /config.php?

For personal support, provide AdminCP-Account and FTP-Access via PM (!) to me, then I take a look and find the problem :)

snakes1100
10-28-2018, 01:05 PM
Just updated a working arcade to the latest version on a 4.2.5 board, this has resulted in the same error as hirlas.

ERROR: Cannot find database xxxxxxx

mySQL query error: SELECT arcade_access, p_require FROM usergroup WHERE usergroupid = 1

mySQL error:
mySQL error code:
Date: Sunday 28th 2018f October 2018 02:06:51 PM

snakes1100
10-28-2018, 01:33 PM
Flipped a few switches, to give some more insite:

PHP Warning: mysqli_connect(): (HY000/2002): Connection refused in ..../arcade/functions/dbclass_mysqli.php on line 44

PHP Warning: mysqli_select_db() expects parameter 1 to be mysqli, boolean given in ..../arcade/functions/dbclass_mysqli.php on line 48
ERROR: Cannot find database xxxxxxxx
PHP Warning: mysqli_query() expects parameter 1 to be mysqli, boolean given in ..../arcade/functions/dbclass_mysqli.php on line 185

PHP Warning: mysqli_error() expects exactly 1 parameter, 0 given in ..../arcade/functions/dbclass_mysqli.php on line 504

DieselMinded
10-28-2018, 01:41 PM
Thanks for the update!

hirlas
10-28-2018, 06:47 PM
@hirlas:

This is strange... looks like it does not find the DB itself ?!

Your TABLE_PREFIX seems to be "ah"
Which database-type you defined in /config.php?

For personal support, provide AdminCP-Account and FTP-Access via PM (!) to me, then I take a look and find the problem :)


$config['Database']['dbtype'] = 'mysqli';

MrZeropage
10-28-2018, 06:47 PM
Flipped a few switches, to give some more insite:

PHP Warning: mysqli_connect(): (HY000/2002): Connection refused in ..../arcade/functions/dbclass_mysqli.php on line 44

PHP Warning: mysqli_select_db() expects parameter 1 to be mysqli, boolean given in ..../arcade/functions/dbclass_mysqli.php on line 48
ERROR: Cannot find database xxxxxxxx
PHP Warning: mysqli_query() expects parameter 1 to be mysqli, boolean given in ..../arcade/functions/dbclass_mysqli.php on line 185

PHP Warning: mysqli_error() expects exactly 1 parameter, 0 given in ..../arcade/functions/dbclass_mysqli.php on line 504
Problem solved :cool:

Was a weird problem, the database-connect was working fine with "localhost" while "localhost:3306" responded "connection refused". No idea why. Fixed by removing the port (setting it to empty).

I will include a setting for this in upcoming v2.7.6+ so that anybody having connection problems can easily switch the behaviour of the database-driver... :)


@snakes1100:
Enjoy ibProArcade :cool: :up:


@hirlas:
Please also try this:

open /arcade.php

search for
require $sql_driver;
$DB = new db_driver;
ABOVE that, add:
// fix for mysqli-connection-problems (by MrZeropage)
$config['MasterServer']['port'] = "";
$port = "";

snakes1100
10-28-2018, 10:43 PM
admincp/arcade.php

Add on line 46:
// local fix for mysqli-connection-problems (by MrZeropage)
$config['MasterServer']['port'] = "";
$port = "";

Thanks for the fix MrZ!

snakes1100
10-28-2018, 11:08 PM
I dont know how i missed is previously when i compared servers, but the server in question had the following in my.cnf:

skip-networking

If i recall thats a default setting from mysql 5.x.x, so now it accepts remote tcp/ip connections as it should, this server is pretty old & has since been upgraded many times & now users mariadb.

I removed the fixes & tested, all working fine now, but id agree with your email MrZ, id leave the fix in there for 2.7.6

MrZeropage
10-29-2018, 06:43 AM
so now it accepts remote tcp/ip connections as it shouldYou should never allow remote connections to the database, as long you don't have a dedicated database-server separated from your webserver... perspective of security nobody external should have the option to connect directly to the database.

Hope you find the problem in your server-settings so I learn about such problem and to help other users in the future :)

snakes1100
10-29-2018, 08:00 AM
I agree, im just letting you know what i found, with skip-networking disabled, your coding for a db connection works, with it enabled, your db connection attempts fail.

I verified this issue on 2 other servers that dont run whm/cpanel, same issue, the arcade breaks with skip-networking enabled.

MrZeropage
10-29-2018, 08:33 AM
Which mySQL-versions are you using that cause the problem?

snakes1100
10-29-2018, 08:46 AM
mariadb 10.2, on all 3 servers i tested with.

Tested another whm/cpanel server with the original test forum for 3.8 that we did before you released 2.7.5, same issue on it with the way you're calling the db connection, also running maraidb 10.2

goxy63
10-30-2018, 07:41 AM
Received email about update, for a second I was very happy thinking that we will have this great mod for VB5 but....

x iJailBreak x
10-30-2018, 12:36 PM
Received email about update, for a second I was very happy thinking that we will have this great mod for VB5 but....

It could likely be ported, if MrZeropage wanted to do so.

MrZeropage
10-30-2018, 02:00 PM
As far as I know, vB5 is not providing such deep integrated Plugin/Hook-System, to be more secure and less adaptable. Right now I don't have vB5, so maybe anyone could tell me details about that (PN please).