5punk Arcade

Woo Elephant Yeah · Post by **Woo Elephant Yeah** » January 2nd, 2007, 13:51

Righto, it's now updated to 2.1.7 and running amazingly quickly.

You may notice that you cannot see the scores, but this is normal, don't panic, they haven't been lost, you simply need to play the game and submit a score in order for the old scores to reappear again.

So if you could all play your favourite ones and help me out, I would be most grateful. I really really don't want to have to play every single game in the arcade (nearly a 1000) so if you could all give me a hand that would be ace!

There are a couple of games where the score system doesn't work, and I will eventually delete these from the Arcade.

cashy · Post by **cashy** » January 2nd, 2007, 14:52

"This Activity has not been played by an Admin/Mod

So I am unable to save your score yet..!"

ERRORZ

Woo Elephant Yeah · Post by **Woo Elephant Yeah** » January 2nd, 2007, 14:59

Mother fucking mong fisters, I'm gonna have to play a 1000 games in order to get them all working again

Stoat · Post by **Stoat** » January 2nd, 2007, 15:13

Woo Elephant Yeah wrote: Mother fucking mong fisters, I'm gonna have to play a 1000 games in order to get them all working again

Couldn't you assign a section to each mod or something?

edit: Or possibly edit the database- chances are there's a 0 you can change a 1

spoodie · Post by **spoodie** » January 2nd, 2007, 15:39

Stoat wrote:Couldn't you assign a section to each mod or something?

cashy · Post by **cashy** » January 2nd, 2007, 16:15

Just make everybody a mod, job done

mrbobbins · Post by **mrbobbins** » January 2nd, 2007, 16:17

cashy wrote:Just make everybody a mod, job done

In mother Russia communist forum moderates you!

Woo Elephant Yeah · Post by **Woo Elephant Yeah** » January 2nd, 2007, 16:29

cashy wrote:Just make everybody a mod, job done

pfffffttttt yes that would work well

Fred Woogle · Post by **Fred Woogle** » January 2nd, 2007, 21:29

if i have a chance I will go and play games to help

Fred Woogle · Post by **Fred Woogle** » January 2nd, 2007, 22:21

some of the time I'm getting that it needs to play by an admin or a mod, hmmmm

amblin · Post by **amblin** » January 2nd, 2007, 23:28

Woo Elephant Yeah · Post by **Woo Elephant Yeah** » January 3rd, 2007, 8:14

Yeah looks like an admin needs to play the games before people can save their score again

I've checked the database, and what it does is put in the highscore id into the games table once this has been done, but there is no way of working this out manually and going through it in MySQL to save having to play the games.

So basically I'm fucked, and I'm gonna have to play every single game

Post by **ProfHawking** » January 3rd, 2007, 9:42

i cant belive there isnt a way to hax it!
any chance you could post me a section of the table so i can see what it does?
i know an incy bit of mysql. Once we know what it does it should be possible to write a bit of php to do what all for you.

Woo Elephant Yeah · Post by **Woo Elephant Yeah** » January 3rd, 2007, 10:24

I have a phpbb_ina_games table that works as the main table for all fo the games in the Arcade.

The only fields that change after playing the game myself and submitting a score are score_type, highscore_id, at_highscore_id

The value of the score_type seems to change to more than one thing, and I think this is more to do with how each game is setup to save scores, as opposed to a flag that says whether or not members can submit scores.

The thing that does happen though, is that the highscore_id and at_highscore_id are then populated with a number after playing the game, whereas they were blank before.

Here's an SQL export of all the ina_ tables related to the Arcade mod

http://www.5punk.co.uk/uploads/Document ... phpbb1.sql

Post by **ProfHawking** » January 3rd, 2007, 11:37

which games have you played and which ones still do not work?

Woo Elephant Yeah · Post by **Woo Elephant Yeah** » January 3rd, 2007, 12:16

ProfHawking wrote:which games have you played and which ones still do not work?

Blackdot has been played, and the only values that changed were the ones I mentioned above.

An example of one that is not working is "Cone Crazy" but you can take your pick from pretty much any of the older games where pages of them have no highscore next to them in the category view.

If you click on Show All Games, then when you click on say page 47, none of those have been played by myself

Fred Woogle · Post by **Fred Woogle** » January 3rd, 2007, 15:56

Woo Elephant Yeah wrote:you can take your pick from pretty much any of the older games where pages of them have no highscore next to them in the category view.

I was doing this, and it worked some of the time, but sometimes I was getting that it needed to be played by an admin/mod