Yes, sure!

Will try it tomorrow german local time.

Greetz,

Magic Spark

Pseudomizer: Are you sure it is operating system specific? I have never had any problems with it on any of the systems I've installed it on, which have been all different flavors of linux (my own servers all run RedHat distros).

All of the problems I've encountered with others have been when PHP safe mode is enabled.

I've working on a clean install of my forum, and wondering if there are any eta to next release or beta test for the arcade... of if you need help anything... "don't want to rush ya" just wondering

This hack worked great fr me for months... then all of a sudden today I start getting an error...when score is submitted it goes to www.limpkinw.com/proarcade.php instead of http://www.limpkinw.com/forums/proarcade.php Any Ideas? Nothing on server has been changed...
Thanks.

Make sure to check the language in IE - make sure it is set for english(united states) [eng-us]. That is your problem.

Email me or get me on IRC (irc.devcore.co.uk in #vborg as futureal).

Works great!

Thank you, Pseudomizer.

Anybody know how to clear the high scores on the tables? I had a user who just joined up and played games and not posting. Now i banned him and deleted his ONE thread, i wish to delete him from the arcade score tables too

It will be in the next version, as well as I'm hoping an idea I had for hall of fame ;P I think futureal is close to a release, but I can't speak for him, few posts back he popped his head in for a few days and said he had more time to work on this so we shall see...

currently as for the whipe scores it's bust ;)

this hack rocks; however, i think i got a little problem.
the templates & stuffs work fine, but it take 4ever to load these flash game. (well, i use flash games included in the zip file).
How can I fix this problem or increase loading time of these flash?? Thanks in advance.

neva mind, i got it figured out. work great on my board now. Thanks again futureal!!!!

I am having a problem, the images are not showing up (non of them either in admin cp or the proarcade.php) and also when i click on a name for a game it goes to a page can not be displayed screen.

Any Ideas?

- Kingdom Hearts

edit (I had my URL wrong in my Options for the vB .. silly me)

- KH2

Hi Futureal,

i wouldn't have spent time on this, if this would not be the case. I searched multiple times through this thread and 4 or 5 guys had the same problem and no one could find the problem.

So a friend of mine and myself spent 2 days on this with trying to find the error and comparing settings like PHP and MySQL. There was nothing special but in safe or in non-safe mode everything worked fine EXCEPT the upload of the thumbnails into the database.

So most of the people used the workaround to insert queries direct into the database. But this was only a workaround and so we sat down and tried to fix this.

If you look on the comment of Magic Sparc, my solution worked for him and i would guess, that he did not change any other settings expect to mine, i just gave him.

So this prooves my assumption that there could be some problems between different flavours of unix and windows.

That was the reason why i asked if someone is interested in my investigations because i did this for my server because i wanted to use this functionality if you had this built-in. Feel free to comment or apply changes to this but it works for me now.

Cheers,

Pseudomizer

Thanks for putting the time into it, I will definitely make the change for future versions. I wasn't being critical, just being curious. :)

you say netscape has a problem with this hack but does this hack work with ANY browser other than ie on windows?

Not sure on that one.

Not that I'm aware of. I tried to get it to go with any Mozilla-based browsers but no luck so far. I could only get Flash to send the data via GET, which made it far to easy for people to just plug values into their browser's URL bar as scores.

It's still not completely secure using HTTP POST, but it's a lot better. I will keep trying other stuff...

thanks. and thanks for being so cool. i just came back because to edit my post because i thought it might sound snotty. i ddint mean it that way.

i run a mac forum so most users use mozilla or khtml based browsers. this might sound stupid but you could try asking some mozilla guys (pinkerton) or khtml guys (dave hyatt) to include GET commands. both seem pretty receptive to that kind of stuff.

I have installed to a T, checked and doble checked everything.. but when I goto my admin section it does not show the vbpro games sections as you show in the picture.. Yes, i have installed all the sql entries, and templates, and uploaded all the files in the correct places.. Any suggestions as to why it does not show in my admin?? Thats all I need to get the games running as the score pages show up fine etc... PLEASE HELP

Oh also when I try to run the admin for pro arcade directly i get this error if it helps any

Fatal error: Call to undefined function: dotableheader() in /www/a/adventurers/htdocs/forums/admin/proarcadeadmin.php on line 30

my pro arcade address is
http://host.bh.xgb.net/~circenet/forum/proarcade.php

but when i die in a game and it oes t record the score it goes to

http://host.bh.xgb.net/proarcade.php

i havnt got a clue why ive tried looking but im a noobeh, any help wud be appreciated, ty

can i please get a query to clear all the sql tables that hold anything pertaining to the high scores :)

ty
JAson

Check your functions.php in the admin directory. There is your problem.

Cheers,

Pseudomizer

Your game directory is not set correctly. Check in this thread for directory discussion about "/games/" and "games/" and "/games". This will explain everything.

Cheers,

Pseudomizer

Smile. This is very easy: Open your file proarcadeadmin.php and look in the section "modify". There is the query for the reset. If you do not find it, tell me.

Cheers,

Pseudomizer

The reset is also fixed in the next version, which incorporates a number of bug fixes (including Pseudomizer's fix).

The new version is being packaged and will be test installed over the next day or two and then hopefully finally released.

Hello Futureal,

i have integrated a "Hall of Fame" on my domain. And i have already fixed the reset hi-scores issue. If you want to have a look at the Hall of Fame visit http://www.LoveTalks.de

Unfortunately it's a german site but i have an english Style implemented as soon as you have registered you can choose the english style in the drop down box.

Tell me what you think. I would share my work if you are interested.

Cheers,

Pseudomizer

sorted now, well kind of, scores will record in IE browser but not mozilla

I know that Angelus said he fixed this problem, but he did not say how. All he did was provide a link to his messageboard. Since I do not understand German, it was of no help to me.

I am still having the same problem that many others are having.

if i click on "view user arcade record page" I have this error:
____________
Database error in vBulletin 2.2.8:

Invalid SQL: SELECT * FROM arcadescores WHERE userid=Array AND valid=1 ORDER BY endtime DESC mysql error:
mysql error number: 0
____________
I uninstalled and re-installed several times and it it always the same. I am running vbb v2.31, PHP v4.2.3 & MySQL v3.23.57.

Please help.

Hi,

i am very sorry, but if i read "Database error 2.2.8" and you say that you are running 2.3.1, i would say that your upgrade failed to 2.3.1.

But the way: Your error in the query is the userid. There should be a number and not an array.

Cheers,

Pseudomizer

Ok, now that you have identified the problem, how do i fix it?

Hmm. The source code should be fine. I only could suggest that you try the following:

Replace:
SELECT * FROM arcadescores WHERE userid=$user AND valid=1 ORDER BY endtime DESC

With:
SELECT * FROM arcadescores WHERE userid=$userid AND valid=1 ORDER BY endtime DESC

in the proarcade.php file.

No guarantees. Give it a try.

And i would highly recommend that you check your vbulletin installation. It seems that you are running 2.2.8 and not 2.3.1 as you think. This could also cause many problems.

Cheers,

Pseudomizer

Pseudomizer: Thanks again for figuring out the upload bug in the Admin CP. I worked with it a bit and discovered what the exact problem was.

In some versions of Apache/PHP, variable names are automatically created from forms. So for example, the input file "championicon" would turn into "$championicon_name" and "$championicon_data" automatically when it's passed through the headers into the next page.

So for some combinations of OS/Apache/PHP, this wouldn't happen, and the variables would not get inserted correctly into the database. The key then is to use the $HTTP_POST_FILES array for everything, rather than relying on PHP to do the dirty work.

The vpaupload() function already does this for the data portion, but the name was being mishandled. So the code now looks like this:

This fix (and appropriate credit) is given in Beta 2.1. :)

Hi Futureal,

i am glad that you found the problem. Whenever i can help just tell me.

Did you had time to check my "Hall of Fame" ?

Cheers,

Pseudomizer

Yea, I did have a look at it, it's very nice.

The way I've implemented it so far is a bit different; instead of going strictly by months, it allows the admin(s) to define any sort of period as a separate group or event, and then contains its own high scores for that. So it's more work, in that the admin would have to manually start a new group for each month, but it can also be reset more often if necessary.

I'm still testing it, and it won't be in Beta 2.1, but it will still make a showing in the vB2 version of the hack. :)

Your site did inspire me to start thinking about an optional cron job that could automatically rotate the scores each month/week/whatever.

Smile. That is the next thing i wanted to implement. Right now i reset the scores manually and every time i reset them, the script looks for the actual month ( with some intelligence check behind ) and writes the Hall of Fames file. The next thing will be to insert into the cron job the start of the proarcadeadmin.php with the parameters to reset the scores and everything will happen then automatically. So we are both on the same way of solving this problem.

On unix a cronjob and on windows an AT job ( you can use Auto2000 to have a nice GUI on windows for that ).

If you need someone to test your solution just tell me.

Cheers,

Pseudomizer

when is this thing gunna go full release?????

its in testing, if all goes well, the next beta should be out soon :)

hi. nice hack. but i've got a problem to solve.
When I wanna start out playing a game, the game loads and loads and loads, but noth' happens.
Hope u can help me.
http://www.mangaboard.com/forums/vbproarcade.php

go into the arcade options in your admin panel and double check your filepath to the games folder.

defaulted you will see /games/

I had to change mine to games/

then it worked

All things come in good time.