vB Tetris v2.5 | Leaderboard, Comments and High Score System v2.5 :)

[John]

lol!

/me runs

[John]

And then there was Snake...

http://www.eovie.co.uk/pics/9.gif
http://www.eovie.co.uk/pics/10.gif

[John]

And yes, it has a fully functional leaderboard (all using one page). Want a screenshot?

[Ninth Dimension]

Originally posted by john.eovie
And yes, it has a fully functional leaderboard (all using one page). Want a screenshot? YES PLEASE!!!

[Jashugan]

awww John torture me with non-release

guess all I can say.. your hacks look sweet

[John]

What do you mean "non release" - I am releasing! Just to a select group of people ;)

[Jashugan]

excatly :P

[John]

But I haven't said who that select group of people is yet ;)

[Ryangel]

:dead:
:( :(

[Jashugan]

Originally posted by john.eovie
But I haven't said who that select group of people is yet ;)
true but hidden words are there, I can read that one. XD

[Ryangel]

*Ryangel enables Paypal*

*Ryangel looks at John*

lol.

[John]

*John nods, not so much to be blantently obvious, but just enough to let him know*

;)

[Jashugan]

Umm, look like I m at deadend so how much you need to release "sell" your new hacks?

[John]

Originally posted by Jashugan
Umm, look like I m at deadend so how much you need to release "sell" your new hacks?

Whoa, whoa - let's not use words like "sell" in here!

I don't earn a lot, and if people decide to donate money to me I'm grateful - so grateful in fact that I send them my hacks! ;)

I wasn't planning on releasing it to the public anyway - but a few people got in touch and asked me if they could pay me for it... I wasn't aboutto turn them down!

[Jashugan]

Ok it look like that is only way for me to get your hacks, I ll yak with you thur AIM.. Do you have AIM any chance?

[John]

Check my profile - don't forget this hack isn't finished yet! Still working on it...

[lordofgun]

If I was a policeman, I would shoot john.eovie. :(

[John]

Originally posted by lordofgun
If I was a policeman, I would shoot john.eovie. :(

Erm... thanks.

[Jashugan]

lol... this is no win situation so... :(

[Ryangel]

Originally posted by lordofgun
If I was a policeman, I would shoot john.eovie. :(

Good thing you're not! phew. I need John alive! :alien:

[Ninth Dimension]

Originally posted by lordofgun
If I was a policeman, I would shoot john.eovie. :( everyone in favour of the above action - SHOOT JOHN!!!

(sorry john, i don't mean it realy *G*)

[John]

And at the risk of being unpopular, here's Pacman :)

http://www.eovie.co.uk/pics/11.gif
http://www.eovie.co.uk/pics/12.gif

[Ryangel]

RISK OF BEING UNPOPULAR?
*faints*

You're joooooooking right?

[JJR512]

So you're selling this now? Or rather, selling the good stuff? Like giving away marijuana to get people to come back and buy crack?

What you are you going to do for those of us that don't have (and cannot use) PayPal? Tell us we're screwed?

[John]

JJR512 - if you want it, I've got no problem in giving it to you. (Seeing as I'm planning on installing your brilliant news hack! :))

[JJR512]

Ah, excellent! :D

BTW, which news hack? I've done so many...let's see: Any-forum news hack (post a thread in any forum and have it show as a news blurb on another page); XML Headlines (XML feeds providing headlines linked to full articles); or Forum News (a variation of XML Headlines, it puts the headlines from a specific feed at the top of a forum).

[Erwin]

What about me, John? I did get you started with the original Tetris hack... ;)

[Schorsch]

yeah and what about me ? I didn't release any hack yet :( :bunny:

[Ninth Dimension]

John, I feel really sorry for you right now :)

[Erwin]

LOL! This is what happens when you tease... ;)

[Steve Machol]

Just forund another problem with 2.41, After 'lining out' I was taken to the 'No permission' page. This was the URL used:

tetris.php?action=reg

[John]

Originally posted by smachol
Just forund another problem with 2.41, After 'lining out' I was taken to the 'No permission' page. This was the URL used:

tetris.php?action=reg

Weird - it took me back onto the leaderboard :\

[John]

One thing - you have to make sure that you don't use the back button to play again or it overwrites your record...

[ahbao]

Originally posted by smachol
Just forund another problem with 2.41, After 'lining out' I was taken to the 'No permission' page. This was the URL used:

tetris.php?action=reg

me too .. :dead:

my member was complain to me that I am cheating because their highest score is not recorded and instead they get a no permission error

[John]

Originally posted by ahbao


me too .. :dead:

my member was complain to me that I am cheating because their highest score is not recorded and instead they get a no permission error

I think this must be the session timeout issue coming up again. Change "Cookie timeout" in your vB options to 1800 instead of 900, see if it makes a difference

[ahbao]

oh i saw this

// If the user doesn't belong to certain usergroups, show the no permission page
if (($bbuserinfo[usergroupid] == "1") or ($bbuserinfo[usergroupid] == "3") or ($bbuserinfo[usergroupid] == "4")) {
show_nopermission();
}

so I guess maybe because of this my user get no permission problem

[ahbao]

Originally posted by john.eovie


I think this must be the session timeout issue coming up again. Change "Cookie timeout" in your vB options to 1800 instead of 900, see if it makes a difference

will try .. :) thanks thanks, a nice hack

[Grover]

Supercool this is! I am a total newbie on hacks, but this Tetris thing is way cool!

I've just tried it out on: http://www.fetter-esel.com/vB/tetris.php?action=play&s= on I was wondering if we could set the amount of posters that will get into the TOP list. I mean, you now have to gain soooooooooooo much points to get anywhere near the top 10. Ofcourse, I KNOW this is the whole point of having a TOP 10 in the first place, but I think a lot of my members on my board would find it very very nice to be able to get just their NAME and comment on this Tetris-list. So I was wondering.... could you make an option so that we can set how long the TOP list will be? 10, 30, 40, whatever? When you make a TOP 20 list, you can alsways HIGHLIGHT those TOP 10 members or something, I just think that MORE people will play along if it wasn't to hard to get your name on this list. Just an idea.....

[John]

Easy Grover - all you have to do is open tetris.php and replace

LIMIT 10

with

LIMIT [number in top list]

(It occurs twice)

[Ninth Dimension]

FIND: $leaderboard_q = $DB_site->query("SELECT * FROM arcade WHERE game='tetris' ORDER BY score DESC LIMIT 10");
REPLACE WITH: $leaderboard_q = $DB_site->query("SELECT * FROM arcade WHERE game='tetris' ORDER BY score DESC LIMIT <number>");

This will need to be done twice, and <number> needs to be replaced with whatever number you want on the highscore.

This however produces produces more queries based on the number you are showing in the leader board (one extra for each person). There was another suggestion in this thread about how to reduce this, but I don't know if it works with the latest verson or not.

Hope this helps?

[Kars10]

Originally posted by danielhollands
FIND: $leaderboard_q = $DB_site->query("SELECT * FROM arcade WHERE game='tetris' ORDER BY score DESC LIMIT 10");
REPLACE WITH: $leaderboard_q = $DB_site->query("SELECT * FROM arcade WHERE game='tetris' ORDER BY score DESC LIMIT <number>");

This will need to be done twice, and <number> needs to be replaced with whatever number you want on the highscore.

This however produces produces more queries based on the number you are showing in the leader board (one extra for each person). There was another suggestion in this thread about how to reduce this, but I don't know if it works with the latest verson or not.

Hope this helps?

It works with the new version. Thanx! :rambo:

[John]

thanks to Minifreunde for voting for this on Hack of the Month :) :banana:

*nudge* https://vborg.vbsupport.ru/showthread.php?postid=288215#post288215 *nudge*

[Ninth Dimension]

*WOOF!*
Private joke

[NexDog]

Daniel,

Changing the limits in tetris.php is the easiestoption and doesn't produce any more queries.

[John]

That's exactly what his code does.. :\

[Ninth Dimension]

Originally posted by NexDog
Daniel,

Changing the limits in tetris.php is the easiestoption and doesn't produce any more queries. I could be wrong, but from the code I can see that for each score in the leader board it does another query to get the users username, this line:$user_result = $DB_site->query("SELECT username FROM user WHERE userid='$s_userid'");This will result in a query for each person listed on the leaderboard

[NexDog]

Okay, me baka. :)

[Kars10]

Originally posted by john.eovie
thanks to Minifreunde for voting for this on Hack of the Month :) :banana:

*nudge* https://vborg.vbsupport.ru/showthread.php?postid=288215#post288215 *nudge*

I thank you John for giving us this great hack!!
Like i said you create a Monster!! *lol* :bunny:

[John]

Ok, I think this *should* fix the session timeouts and no permission problems...

Give me feedback :)

[Ninth Dimension]

I've just uploaded the new tetris.php file, and so far as I can see there are no problems, but then I was not getting problems in the first place.

[Zombie]

I just got a "No Permission" error with the new php file

[John]

Originally posted by Zombie
I just got a "No Permission" error with the new php file

Where did this happen?

[John]

Just updated the tetris.php file again -

I need to know who's getting no permission errors, and where - and after how long playing tetris.

[scottct1]

Hmm still not working in netscape.

Before I was Getting eovie.com presents, now I am getting Dynamic Field Presents.

And still no username is passed.

It works fine in IE. Wierd.

[John]

I hate Netscape. :|

[Zombie]

It doesn't happen all the time. Just every so often I get that error

[scottct1]

Me too, a user just alerted me that it does not work with Opera as well. (When will these folks understand that IE rules the world?) :D

[John]

Originally posted by Zombie
It doesn't happen all the time. Just every so often I get that error

|How come you got it so quickly after you installed the new file then?

[John]

Originally posted by scottct1
Me too, a user just alerted me that it does not work with Opera as well. (When will these folks understand that IE rules the world?) :D

I know! IE is obviously a far superior browser, can't people just accept it?

I know someone who refuses to visit a site if it doesn't work with Netscape 4.xx. And nothing works with Netscape 4.xx...

[Zombie]

Originally posted by john.eovie


|How come you got it so quickly after you installed the new file then? I uploaded the file, then the first game I played I got that error (it could have been a cached page, but I'll keep an eye on it)

BTW, I'm using IE6

[e-2]

I'm not bothered about my Netscape using members, or any other OS besides IE :D They don't deserve the privilidge of playing this game if they can't use a decent browser :p

[John]

Originally posted by Zombie
I uploaded the file, then the first game I played I got that error (it could have been a cached page, but I'll keep an eye on it)

BTW, I'm using IE6


Yeah, let it settle down and tell me if it happens again. Does this usually occur on the page after the game?

[John]

Originally posted by e-2
I'm not bothered about my Netscape using members, or any other OS besides IE :D They don't deserve the privilidge of playing this game if they can't use a decent browser :p

:banana: I like your style :D

[Zombie]

Originally posted by john.eovie



Yeah, let it settle down and tell me if it happens again. Does this usually occur on the page after the game? Yes, only happens to me after the game is over and is suppose to go to "tetris.php?action=reg"

I'll keep an eye on it and let ya know if it keeps happening

[John]

I've found the problem, coding a fix now

[Schorsch]

If u don't win Level10, you get the no permission error!
what's wrong ?

cu
Schorsch

[John]

It's nothing to do with level 10, it's my own stupid error in the code - fix coming shortly

[Zombie]

Is there a way you could add the option where we could delete the scores (even the delete feature the shoutbox has would be good, for admins only of course)

(I'd like to delete the scores every week or so so people could get a chance to be top scorer)

[John]

Fixed - check first post

[Schorsch]

Originally posted by john.eovie
Fixed - check first post

John - Thank you very much!! :)

for upgrading just upload tetris.php and tetris.swf ?

Schorsch

[John]

Don't forget the SQL query

[Schorsch]

I already did this in v2.41 :)

[John]

This is a new query for 2.5

[Ron ? DCS]

Okay, I have one modification question...this is the code to keep unregistered (guests) out:


if ($bbuserinfo[username] == "Unregistered") {
show_nopermission();
}


Is there a like-kind code I can keep all but a select few usergroups out? I am thinking of allowing only Supporting Members (usergroup=11 on my board) this perk, as well as other games.

[John]

Originally posted by Ron ? DCS
Okay, I have one modification question...this is the code to keep unregistered (guests) out:


if ($bbuserinfo[username] == "Unregistered") {
show_nopermission();
}


Is there a like-kind code I can keep all but a select few usergroups out? I am thinking of allowing only Supporting Members (usergroup=11 on my board) this perk, as well as other games.

Upgrade! That's old code. It's a lot easier to block out people in the new version, install it!

[portion]

hope Im not asking too much here, but could you tell us what has changed in the last two revisions. I have changed a lot of the html code to integrate to my forums and it would be easier to change just the code you have updated. Instead of overwriting the whole teris.php file.

Thanks
portion

[John]

And with the new version, all you have to do is replace:


if (($bbuserinfo[usergroupid] == "1") or ($bbuserinfo[usergroupid] == "3") or ($bbuserinfo[usergroupid] == "4")) {
show_nopermission();
}


with


if (($bbuserinfo[usergroupid] != "11") && ($bbuserinfo[usergroupid] != "6") && ($bbuserinfo[usergroupid] != "5") && ($bbuserinfo[usergroupid] != "7")) {
show_nopermission();
}


wherever it appears (it might appear up a few times)

[John]

Originally posted by portion
hope Im not asking too much here, but could you tell us what has changed in the last two revisions. I have changed a lot of the html code to integrate to my forums and it would be easier to change just the code you have updated. Instead of overwriting the whole teris.php file.

Thanks
portion

The two files that have changed are tetris.php and tetris.swf
The only template that's changed is "tetris"
There have been two new SQL queries since 2.0

In the tetris template, "&sec_no=$sec_no" was added to the end of the parameter string. It passes a security number over to the Flash file.

tetris.swf has had a few improvements, including the level 10 fix.

tetris.php has undergone a LOT of changes.
1. New security system. Random variables are generated and passed along the system, should this line be broken or the variable be changed, things won't work.
2. No permission bug fixed, with a date system. It deletes records with a score of 0 that are over 60 minutes old.
3. Loads of tiny security fixes

I can't list the code for al of these, because over half of it has changed. When you say you've made changes to the HTML, are you talking about templates? Few changes have been made to the templates, tetris.php is the important file.

[Ninth Dimension]

You have a problem with your above code, by doing that you will lock yourself and mods out of the game, unless they are usergroup 11, which we all know they won't be :)

[John]

Ignore Ziggy's code above, it's wrong - it doesn't pass any variables along to the Flash file.

If you install that it won't work

[Ron ? DCS]

Thanks John!!! :D

One question, tho'...I just downloaded this thing two days ago, and the code is already old? Did I download the wrong files?

[Ninth Dimension]

back then they where the right files, but since then John has been working hard on improving the script and fixing bugs, and now the old files are out of date.

The best thing is to go back to the first post and download the files again to upgrade it.

[ziggy]

EZ background color change, w/variables this time! :D
Just edit the hex codes to whatever you want?

<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000"
codebase="http://active.macromedia.com/flash4/cabs/swflash.cab#version=6,0,29,0"
id="_4ums" width="550" height="380">
<param name="movie" value="tetris.swf?userid=$userid&username=$username&s=$session[sessionhash]&points=$points&cur_high=$cur_high&bbtitle=$bbtitle">
<param name="quality" value="high">
<param name="scale" value="exactfit">
<param name="salign" value="tl">
<param name="wmode" value="transparent">
<param name="bgcolor" value="#999999">
<embed name="_4ums" src="tetris.swf" quality="high" scale="exactfit" salign="tl" wmode="transparent" bgcolor="#999999"
width="550" height="380"
type="application/x-shockwave-flash"
pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash">
</embed>
</object>

Ignore the smiley :D you can leave the classid= the same.

Cheers...ziggy

[Ninth Dimension]

Ziggy, the code you have provided looks good, and so far as i can see has all the correct variables being passed to the flash file, the only problem is that on boards with a light background colour you can't read the text very well :(

[scottct1]

Hmm wierd. I have done the 2.5 update from the 2.4 upgrade and now I am getting a no permission when I get to enter my score on the leaderboard.

I put the old 2.4 PHP file back in and everything is fine again.

Yes I did the SQL query instructions. :)

[ziggy]

Hey dan,
You mean in the Flash file or the header/footer table cells?
You can change the wmode params from "transparent" to "opaque" also, this should let you darken it w/hex so yourtext shows better. Theres alot of combinations you could use there? Just something to play with if you're not happy w/the default colors?

I just popped in for a sec, I'm busy on integrating multiple vBportals into a single VB arrgghhh :D

Cheers...ziggy

[Ninth Dimension]

scottct1, can you try something for me please? delibratly get a low score in game (one that would prevent you from adding a score) and let me know what happens.

[scottct1]

I put it back in again and its working now. Wierd. I tried just getting a low score. and its going fine.

[John]

Phew - you had me worried Scott.

[Ninth Dimension]

Originally posted by scottct1
I put it back in again and its working now. Wierd. I tried just getting a low score. and its going fine. So is it all working now, or just when you get a low score?

[John]

I think it all works now :)

[John]

Originally posted by Ron ? DCS
Thanks John!!! :D

One question, tho'...I just downloaded this thing two days ago, and the code is already old? Did I download the wrong files?

Yeah, it's out of date!

Upgrade :)

[scottct1]

Im not sure, I never get high enough scores. :)

If its broke one of my users will tell me i'm sure.

[John]

Just received this PM from DestyNova:

PM removed

Ok, let's just say that I'm am seriously annoyed now. I will now address any issues which some of you may have.

Re: vB Tetris

1. vB Tetris is not the flash tetris game. It is the hack which allows a scoreboard to be kept of high scores in a GPL game.
2. As a GPL game I can legally distribute it.
3. That's exactly what I'm doing.

Re: The Arcade Hack

1. This, like vB Tetris is a HACK. It's packaged as a hack. All of the games in it are GPL, it is legal for me to distribute them.
2. People who have sent me donatations are not paying for any games. I'm giving them the arcade hack, I AM NOT SELLING FLASH GAMES. Once again, this is legal. If it makes people happy I'll send it as two files - one with the hack in, and one with the games in.
3. I no longer intend to ever release this hack to the public, due to the issues raised here.

[DestyNova]

Since you ahead post it so I guess I should add some bit information. After I email these makers to make sure about GPL, since I m not really fully knowledge with GPL rules anyway I got odd email from one of makers said that they got several complaints about their games "sell" at vb.org. So it force me to email to John about sell issues. But John now clear up about it with me and I email them already that it is not their games that which "sell" but only hack.

Also reason for this email, I dont want to have them sue John for this reason since I dont know who email them several of "complaints" emails, that maker refuse to name whos. I respect John and his works, I want to have him continue his amazing hacks at here so I have to speed up and clear up with these makers.

[Schorsch]

I just hope selling hacks doesn't get practice, because when everybody is doing this it's getting expensive and I'm going back to phpBB2, there it's free of charge :banana:

[Ninth Dimension]

It is true that selling of hacks is viewed as a bit of a no-no, but you have got to remember that John has put a lot of time and hard work into developing the arcade hack, and it's only fair that he gets rewarded for it.

If the author is happy to give away some code for free, for whatever reason (promotion, kindness, whatever) then cool. if not, all you can do is respect their wishes?

After all, when you goto work each day, do you do it for free?

Is vB free?

[John]

Originally posted by Schorsch
I just hope selling hacks doesn't get practice, because when everybody is doing this it's getting expensive and I'm going back to phpBB2, there it's free of charge :banana:

What?! I released the standard version (the Tetris hack), the arcade hack was supposed to be a special feature rich version for myself. But now the original isn't good enough... :p :banana:

[scottct1]

From what I can see no one is selling anything, this has all got blown out of proportion.

I like John's hack, and John has been very good in supporting his hack. I am sure his time is valuable just like everyone elses.

I don't think he is looking for "pay me or else" perhaps the way it should have been said was "if you like my hack please send me a donation for beer money" :)

I hope John continues with his work and the Arcade is released to the public.

[Ninth Dimension]

another thing, John has put a lot of time into the tetris hack, if he wants to sell an advanced verson of it with support for more games, good on him :)

[John]

Originally posted by danielhollands
another thing, John has put a lot of time into the tetris hack, if he wants to sell an advanced verson of it with support for more games, good on him :)

Thanks - it's just a shame that people try to slow things down for everyone :(

[John]

Updated statement - https://vborg.vbsupport.ru/showthread.php?postid=288369#post288369

[DestyNova]

John

Nooooooooo, keep that way, I have NO complaints about "donate" to support your time and your hacks. Yes it will be nice to recieve free but I aint mind to make some donate if necessary to help you somewhat since you spend alots of time on it, yes I did ask you if I can get it for free but I m not quality to get it so I plan to make some donate cuz of your incredible times on this hack. So pls dont stop and keep it going no matter what complaints that makers recieved!! I m sure that some of us will happy to make some donate or more happier if you keep makin new hacks or updates for this site!!!!

[Schorsch]

Originally posted by john.eovie


What?! I released the standard version (the Tetris hack), the arcade hack was supposed to be a special feature rich version for myself. But now the original isn't good enough... :p :banana:

I didn't say that, your standard version is great. I just said I hope that it's not getting practice to sell hacks, because then I would go back to phpBB2.
vBulletin was already expensive enough, and I simply don't have the money to buy the hacks too.

And I say absolute nothing about a volunteer donation for somebody who made a great work and build an incredible hack (like you John), probably I will do this too

[John]

Originally posted by Schorsch

vBulletin was already expensive enough

You're telling me - I'm saving up so I can buy a full licence! (That's where the donations are going.)

My leased is going to expire in a few months :\

[DestyNova]

Reason for post this..

check this https://vborg.vbsupport.ru/showthread.php?postid=288380#post288380 to clear up/add about above John's statements

[DestyNova]

To keep you (John) stay, I m going to make a donation so that you can get the full license whenever leased expire >_<

[John]

vB Tetris Add-on - Front Page Mini Leaderboard
HTML knowledge required

~ Requested by Madhouse

This little add on lets you display a mini leaderboard on the front page. The templates need to be customised with colours and the table needs to be formatted to fit with your layout. Therefore I ask that only users with HTML knowledge attempt this add-on.

Screenshot of it in use in next post. (The number of results shown can be changed by altering the number after "LIMIT" in the code. Default is 3)

[John]

Screenshot

[michealo]

yeah, i sent him a few bucks, but not for the hack alone

i sent it to him for his TIME, and for answering a question via a PM i sent him

call it a "tech support" fee

:)

[John]

Getting there...

http://www.eovie.co.uk/pics/13.gif

[DestyNova]

I m DEFINETLY going to make a donate tonite!!!!!

[amykhar]

The whole hacks must be free mentality annoys me. If you want your board customized and don't want to pay for it a)Learn how to code and b) Figure the stuff out and do it yourself. Do NOT expect somebody else to spend THEIR time making your board better.

I no longer release hacks because idiots who aren't even qualified to run a website much less modify a complicated software package have taken most of the fun out of. I deeply love working with other developers to come up with new features, but it's not our job to listen to your whining and temper tantrums.

If mommy and daddy won't raise your allowance so that you can afford to pay developers to create modifications for you, then get a job or an education.

Amy

[John]

Originally posted by amykhar
Do NOT expect somebody else to spend THEIR time making your board better.


I know that feeling - often people seem to demand I do things a certain way, talk about impolite!

[John]

General Options:

http://www.eovie.co.uk/pics/14.gif

[John]

Options and descriptions for each game. (This is all dynamic of course, when a new game is added a new set of fields appears for that game :))

https://vborg.vbsupport.ru/

[John]

Going to get some sleep now, I'll continue tomorrow morning :)

[Erwin]

I like your cp.css colors. :)

[SemperFidelis]

John
The amount of time and effort you have put into this hack is simply amazing.
You have done an awesome job with it
Thankyou for all the work you have done
:D

[Link14716]

Originally posted by amykhar
The whole hacks must be free mentality annoys me. If you want your board customized and don't want to pay for it a)Learn how to code and b) Figure the stuff out and do it yourself. Do NOT expect somebody else to spend THEIR time making your board better.

I no longer release hacks because idiots who aren't even qualified to run a website much less modify a complicated software package have taken most of the fun out of. I deeply love working with other developers to come up with new features, but it's not our job to listen to your whining and temper tantrums.

If mommy and daddy won't raise your allowance so that you can afford to pay developers to create modifications for you, then get a job or an education.

Amy

I agree 100% with that.

[Link14716]

Originally posted by john.eovie


You're telling me - I'm saving up so I can buy a full licence! (That's where the donations are going.)

My leased is going to expire in a few months :\

I was smart and bought the full license from the begining ;). Now, I can't say I would but this thing, figuring I have absolutley no money, but it would be cool . :)

[Ed FvC]

I'll be happy to donate a few bucks for the cause once a few more games are out. :)

John, you've done some great work. You have a legion of addicts on FordvsChevy.com that love nothing more than to beat the current 133k high score. lol

[Link14716]

I would donate money if I had money. Hey, what's a 14 year old to do for money? *thinks*

[NexDog]

DestaNova, sorry dude, you cause all sorts of sh!t and now you are threatening to pay John? You make me so angry with your jealous crap. Your antics belong in the schoolyard and so does your English. :@

[Ryangel]

:eek: :banana: :banana: :banana:

if(John, releases this hack one way or another)
{
// (unlike a hack i used to know... *cough*)
echo "Seeing these screenshots are great! :drool:";
}
else{
echo "<B><STRONG>you're wasting my time.</STRONG></B> :mad: :D";
}

[DestyNova]

Offtopic, sorry everyone :)

[Schorsch]

I found a bug in the new version 2.5:

when I'm getting in the highscore list with my comment and my points, the system automatic generates a second entry with always 0 score and no comment.

what's wrong ?

cu
Schorsch :ninja:

[Ed FvC]

Did you put in the new MySQL query that was included in the upgrade instructions?

[Schorsch]

Originally posted by Ed FvC
Did you put in the new MySQL query that was included in the upgrade instructions?

sure, without doing this you get a DB error.

cu
Schorsch :rambo:

[eXtremeTim]

I think i will install this soon. Right now theres just to many updates coming for me to keep checking to make sure i got the newest version.

[eXtremeTim]

Whats all this about donations and stuff this post is way to long for me to go thro and read the whole thing. Its 42 pages long. So can somebody fill me in.

Thanks
~Tim

[Schorsch]

Originally posted by eXtremeTim
Whats all this about donations and stuff this post is way to long for me to go thro and read the whole thing. Its 42 pages long. So can somebody fill me in.

Thanks
~Tim

yeah sure, you have to donate some bucks via paypal to john.eovie to get his new arcade hack (not the standard tetris hack, that's free :) )

screenshots to his new hack are posted in post #611 to post #616, it's not released yet.

Have Fun :D

Schorsch :lick:

[Schorsch]

Originally posted by Schorsch
I found a bug in the new version 2.5:

when I'm getting in the highscore list with my comment and my points, the system automatic generates a second entry with always 0 score and no comment.


ok, new perception:

when I play a tetris match, and interrupt in the middle of the game (e.g. close the window, choose another link, etc...), it anyway generates an entry in the highscore list in fact with no comment and zero score.

How can I fix that ?

thanks,
Schorsch

[Ed FvC]

Originally posted by Schorsch


sure, without doing this you get a DB error.

cu
Schorsch :rambo: Oh yeah, duh. I was just taking a stab in the dark. :cool:

[NexDog]

DestaNova,

Don't talk nonsense:

After read several pages of your thread (whew) I have one concern about "sell" or "donate" to get our hands on your new games (seem that it is only way to get yours due to "selective.") I decided to email few of flash game makers about make some money out of their .fla games and give few of these makers my work email to talk over about it. I got two emails from them and they re not happy about it and want it to be free under GPL, also will email me more information later. I ll find out more information tmw cuz my worktime is over so I dont have the access to work email system from my PC.

So I plan to post about it at your thread and decide to against that and PM it over to you to let you know about it.
Who was concerned, who emailed who? This is too funny! Nice backpeddling though. ;)

Oh yea, you said:

As for "cause all sorts of ++++" again, cant you read??? I stated clear that one of makers RECIEVED many complaints from perhaps you and others about "sell" after I email maker about concerning on GPL issues

Yea, received from you, you joker. :)

[DestyNova]

Offtopic sorry everyone :)

[beemer]

Very easy to install hack! Members love it! Thanks guys!

[SemperFidelis]

Nexdog and DestyNova
Cmon guys get a grip
If you want to have a go at each other dont waste everyone elses time with your petty squabbles in this thread - its long enough as it as ! - take it elsewhere.

[DestyNova]

I already did and I m not going to say anything about it. Thanks for remind me

[NexDog]

Yea, sorry. I was just a little dismayed at Desty's attitude in the PM that John posted. He has put such an effort into this, he deserves all our support and doesn't deserve abuse like that.

[DestyNova]

:rolleyes: I already provide the support by donate, congs, and nice words. I m little disappoint from Nexdog's unprofessional behavior. So sorry for everything.

Edit: I will delete my posts to make everything easy to read and unecessary offtopic too. Thanks ;)

[SemperFidelis]

No worries guys
Glad youve got it all sorted
Thanks for that
:)

[Castel]

Originally posted by Schorsch


ok, new perception:

when I play a tetris match, and interrupt in the middle of the game (e.g. close the window, choose another link, etc...), it anyway generates an entry in the highscore list in fact with no comment and zero score.

How can I fix that ?

thanks,
Schorsch

I record gets created BEFORE the flash loads, it's part of the new security John added, when you finish the game it will modify that particular entry. The script performs a clean up of such emty records when new ones are added.
Once you have more then 10 'real' records those empty records won't be a factor anymore on your leader board anyway. But if it really bugs you add 'AND score > 0' in both leaderboard queries.

[Ryangel]

Hmm i have one registered user saying that after he loses he gets a no permission page. I am using v2.5 and trying out another user account works too..... hmmm *confused*

[John]

Originally posted by Castel


I record gets created BEFORE the flash loads, it's part of the new security John added, when you finish the game it will modify that particular entry. The script performs a clean up of such emty records when new ones are added.
Once you have more then 10 'real' records those empty records won't be a factor anymore on your leader board anyway. But if it really bugs you add 'AND score > 0' in both leaderboard queries.

Yeah, that's right - I didn't think it's be much of an issue seeing as most boards have a lot more than 10 high scores anyway - I've already added the 'AND score > 0' SQL as Castel suggested above in the next version.

[John]

Originally posted by Ryangel
Hmm i have one registered user saying that after he loses he gets a no permission page. I am using v2.5 and trying out another user account works too..... hmmm *confused*

NOOO!!!

Overwrite tetris.php, just in case - then I'll start panicking...

[John]

Originally posted by Ryangel
:eek: :banana: :banana: :banana:

if(John, releases this hack one way or another)
....
// (unlike a hack i used to know... *cough*)


Of course I'm going to release this hack, one way or another!

What hack was that?

[xxxsaint]

was anyone able to get the space invaders high score working in that .fla zip I posted on here with the perl script ?

[xxxsaint]

Originally posted by Ryangel
Hmm i have one registered user saying that after he loses he gets a no permission page. I am using v2.5 and trying out another user account works too..... hmmm *confused*

make sure he's not playing it through the regular flashplayer hack , I know that will give that error. Ranked tetris needs to be played with john's tetris.php , not flash.php

[John]

Also, make sure you have a date field in your tetris table (in the database)

[Ryangel]

hmm thing is Mod tried it and it works ok, Admin tried it and it works ok. 2 other normal users tried it and it works ok. Only one user wasnt ok .... when he gave me his password. I logged in using my comp. It Worked. So I'm guessing it has something to do with his IE settings.......

[John]

What version of IE is his using?

[Ryangel]

Originally posted by john.eovie


Of course I'm going to release this hack, one way or another!

What hack was that?

It was a journal hack . With tons of features. I dont know the full details on why it wasnt released (didnt really follow the thread, but i waited) , so I'm not going to say anymore. Besides I'm making a simple Journal hack now. about 50% done. Will release it soon.

[Ryangel]

Originally posted by john.eovie
What version of IE is his using?

hmm beats me. I'll check the next time i speak to him and post it here.

[Kars10]

Hello John!!
I am installed your Tetris-Minileaderboard on Forummain alittle customized.
Now one Qestion: How can i make the Topscorer-Name a Link to Userinfo of the Member.
Please hav a Look at my Attachment.
Thanx! :rambo:

[Ryangel]

Originally posted by Minifreunde
Hello John!!
I am installed your Tetris-Minileaderboard on Forummain alittle customized.
Now one Qestion: How can i make the Topscorer-Name a Link to Userinfo of the Member.
Please hav a Look at my Attachment.
Thanx! :rambo:

tts a high scorer :eek:

[John]

Originally posted by Ryangel


It was a journal hack . With tons of features. I dont know the full details on why it wasnt released (didnt really follow the thread, but i waited) , so I'm not going to say anymore. Besides I'm making a simple Journal hack now. about 50% done. Will release it soon.

I'm also in the process of making a journal hack, combined with afterlab's licence system. But he says I can't release it :(

[Ryangel]

Originally posted by john.eovie


I'm also in the process of making a journal hack, combined with afterlab's licence system. But he says I can't release it :(

Whats this licence system? Remove it? :) hmm 2 journal hacks. No prizes for guessing whos is gonna be better. :cry:

[Kars10]

Originally posted by Ryangel


tts a high scorer :eek:

DarkMoonWolf, is a Tetris-Monster : 162000 is his current score... :nervous:
My best was about 70000

[John]

Th?mas - 249517 :eek:!!

[Ryangel]

Originally posted by john.eovie
Th?mas - 249517 :eek:!!

................ no way.......... what the....

[John]

The make usernames on the front page (with the mini leaderboard) links, in the tetris_front_bit template:

Find:

$s_username


And REPLACE with :

<a href="$bburl/member.php?s=$session[sessionhash]&action=getinfo&userid=$s_userid" target="_blank">$s_username</a>

[Kars10]

Perfect!
Thanx John !! ;)

[John]

Originally posted by Minifreunde
Perfect!
Thanx John !! ;)

No problem :)

[amykhar]

Originally posted by xxxsaint
Originally posted by Ryangel
Hmm i have one registered user saying that after he loses he gets a no permission page. I am using v2.5 and trying out another user account works too..... hmmm *confused*

make sure he's not playing it through the regular flashplayer hack , I know that will give that error. Ranked tetris needs to be played with john's tetris.php , not flash.php

I have two users with the same problem. It only seems to happen in the upper levels. To me, this says that a cookie or a session might be timing out?

Amy

[John]

The new code isn't cookie or session dependent at all though - only the first page works with that :\

[John]

Originally posted by Ryangel


Whats this licence system? Remove it? :) hmm 2 journal hacks. No prizes for guessing whos is gonna be better. :cry:

Not actually his licence system, but something similar (coded by me).

Basically, a licence is a page with loads of info about the user including pictures and bits of text that make journals more interesting :)

[crossova]

i have version 2.2.6 and recently when i tried to install the Store hack i got an error and had to do the entire board over. I installed the flash player with success and i wanted to add on the hack with showing a crown next to the high scorer. however when i followed the directions i got this error message:
Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING in /home/crossova/public_html/talk/admin/functions.php on line 812

Fatal error: Call to undefined function: vbdate() in /home/crossova/public_html/talk/admin/sessions.php on line 358


can some body please explain this to me here or in an email [crossova10@yahoo.com]

[John]

Just a few things to make clear first (you probably already know this, just to make sure:

1. This hack has nothing to do with the Store Hack.
2. This hack has nothing to do with the Flash Player hack
3. To use the crown hack addon, you must have this hack installed (The tetris addon hack)
4. If the problem is with this hack, post it here. If the problem is with the crown hack, post it in it's own thread.

After what stage does your error occur? After you install this hack, or the crown one? If so, can you successfully install this hack?

[crossova]

Originally posted by john.eovie
Just a few things to make clear first (you probably already know this, just to make sure:

1. This hack has nothing to do with the Store Hack.
2. This hack has nothing to do with the Flash Player hack
3. To use the crown hack addon, you must have this hack installed (The tetris addon hack)
4. If the problem is with this hack, post it here. If the problem is with the crown hack, post it in it's own thread.

After what stage does your error occur? After you install this hack, or the crown one? If so, can you successfully install this hack?

I was able to upload the crown image. i then went to the admin/function.php and inserted the required lines and saved it. then i went to the functions.php and inserted the data that was required. i opened up the [forum/admin] and entered the password. IMMEDIATELY after that i got the above error message. and i went back and reversed everything. and now i still cant get in.www.crossova.com/talk (http://www.crossova.com/talk) is the site

[John]

Did you ever even install the "vB Tetris v2.5 | Leaderboard, Comments and High Score System" hack?!

You said in your above posts that you installed "the flash player" - that has nothing to do with this, or the King Tetris hack!

[crossova]

yea. i installed that. wasnt that the initial zip file within this email? i installed that. the flash player was another download that i installed earlier this week.

[John]

Sounds like an incorrect installation.

Nothing is altered in the installation, you can't have reversed it fully.

My bet if that you screwed something unrelated up when you were installing.

[Ninth Dimension]

crossova - first off I just want to say you NEED this hack for the tetris king hack to work (goto the first post to download it).

Now with that said, I think you have made an error when installing the king hack or the "other" tetris hack because if you had installed it correctly (without this hack) then you would be getting a diffrent error.

My advice is to re-download vb, upload the functions.php file again (unedited) and see what happens?

if that works, installed THIS hack, then try to install the king hack again.

Good luck.

[Ninth Dimension]

Originally posted by john.eovie
Sounds like an incorrect installation.

Nothing is altered in the installation, you can't have reversed it fully.

My bet if that you screwed something unrelated up when you were installing. I agree, the error you are getting looks more like a bad instlation than anything else, follow my suggestion in the post above.

[crossova]

possibly. so will i have to do a complete re-installation of vbulletin? or will i just need a fresh copy of the ADMIN/FUNCTIONS.PHP and SHOWTHREAD.PHP

[Ninth Dimension]

provided that admin/functions.php anbd showthread.php don't have any other hacks on them, then you can just upload fresh copies of the files and it *fingers crossed* work again.

[crossova]

i will let you know how it goes. *fingers AND legs crossed*

[John]

72 installations so far :eek:

[crossova]

well thats good and all. i'd like to be #73. if i can get this to work properly

[Schorsch]

Originally posted by crossova
possibly. so will i have to do a complete re-installation of vbulletin? or will i just need a fresh copy of the ADMIN/FUNCTIONS.PHP and SHOWTHREAD.PHP

you should *always* make a backup of the appropriate files before doing any changes...

[John]

Originally posted by crossova
well thats good and all. i'd like to be #73. if i can get this to work properly

It works for everyone else. You didn't install it properly, there's no other explanation.

[Ninth Dimension]

i'd just like to say that from the look of it, out of the 46 pages this thread has generated, only about 5-10 of them are hack related, the rest is just bumph and un-related problems.

don't you just love un-moderated forums??? :)

[John]

Originally posted by Schorsch


you should *always* make a backup of the appropriate files before doing any changes...

:banana: - the man speaks wise words ;)

[Ninth Dimension]

Originally posted by john.eovie
:banana: - the man speaks wise words ;) WOAH!!! a talking banana!!!!!!!

[crossova]

un moderated forums :D
and
talking bananas oh lawd its crazy

[BigJohnson]

Any news on the store version of this awesome hack.

[John]

I'm going to be developing a store version of the arcade hack - but I'll probably leave the tetris hack as it is.

[crossova]

well i left it alone till i get home where i can properly FTP it to the server. but for now i just re-edited the forum home page: you can view it @: www.crossova.com/talk

[Schorsch]

one of my user (using Linux and Opera v6.02) always gets the no permission error after playing, no matter in which level he is or what score he has.

what can I do?

Schorsch :smoke:

[John]

Nothing - the passing of variables to and from Flash never works properly in Opera, let alone Linux!

[John]

Pruning :)
http://www.eovie.co.uk/pics/16.gif

Updated general options
http://www.eovie.co.uk/pics/17.gif

Game Options
http://www.eovie.co.uk/pics/15.gif

What else do I need to include? Anyone?

[futureal]

Just some questions about security:

I rewrote most of the tetris.php file, but without using the security check and whatnot. Right now I have my code just checking the referrer, so (in theory) the only way that somebody could cheat is if they spoofed the referrer, like by doing a manual HTTP request from a web server through telnet or something.

Are there other known ways of cheating that need to be addressed?

I have the permission code set up so that an admin can just choose which groups they want to have access to the games via the admin panel.

[Link14716]

The only good addition I could think of is a daily or weekly leaderboard that pulls info from the last x hours. That'd be cool ;)

[John]

Originally posted by futureal
Just some questions about security:
Are there other known ways of cheating that need to be addressed?


Not that I'm aware of

[John]

Originally posted by Link14716
The only good addition I could think of is a daily or weekly leaderboard that pulls info from the last x hours. That'd be cool ;)

Already added it :D

[Link14716]

Cool :D

[futureal]

Is anybody aware of any other Flash games out there that return a high score?

And on that note, is the .FLA file for the most recent version of vbTetris available? I no longer see it in the archive in the first post in this thread.

Thanks.

[John]

Originally posted by futureal
Is anybody aware of any other Flash games out there that return a high score?

And on that note, is the .FLA file for the most recent version of vbTetris available? I no longer see it in the archive in the first post in this thread.

Thanks.

No, the games have to be changed to work with this hack.

The Fla file is in the first zip.

[futureal]

Ah, I missed the .fla file the first time around. Thanks.

Here's hoping that somebody else out there is developing some more games for this to work with! The users love the whole idea of gaming, of course, but without the high score mechanism it's pretty pointless.

I would try my hand at making a game or two, except I have never done anything at all with Flash :)

[John]

Originally posted by futureal
Ah, I missed the .fla file the first time around. Thanks.

Here's hoping that somebody else out there is developing some more games for this to work with! The users love the whole idea of gaming, of course, but without the high score mechanism it's pretty pointless.

I would try my hand at making a game or two, except I have never done anything at all with Flash :)

I'm learning game dev. in Flash at the moment

[Ian]

Originally posted by john.eovie
What else do I need to include? Anyone?You just need to include the source on these forums. :banana:

[Link14716]

Originally posted by Ian
You just need to include the source on these forums. :banana:

I think that comes AFTER he get's it working 100% with all the features he wants :)

[NexDog]

John, it is looking awesome! So there is a control panel seting that sets up an "archive" so that after the week is out, the high score registers with the member's name and the score board resets?

And can we set it to every 3 days or something?
And can every game, have it's own "crown"? That would be cool. ;)

Pruning is cool, and having it only record the users highest score so one guy can't take over the whole leaderboard. But if a member betters their score, it would be better to just have it edit the member's current high score as the guy can still take over the board.

[John]

Originally posted by NexDog

Pruning is cool, and having it only record the users highest score so one guy can't take over the whole leaderboard. But if a member betters their score, it would be better to just have it edit the member's current high score as the guy can still take over the board.

To do that, you just have to select both record and display highest scores only. :)

[xxxsaint]

vnj john , how much of a donation to get this on my forums ? ( once you're done with it )

[John]

PM me once I've finished it :)

[Martin64]

Good work John, I have upgraded and cleaned my tables and we're now ready to rock! :D

Woah! Someone is at 144k already! :p

[lordofgun]

I can not wait for the store-integrated arcade hack. That will e AWESOME!

[futureal]

Originally posted by Martin64
Woah! Someone is at 144k already! :p

One of my fellow admins hit 1.1 million last night on vbTetris on my site. The users collectively said "we give up, you ruined it!" :D

[John]

Screenshot!!

[Schorsch]

Originally posted by Martin64
Woah! Someone is at 144k already! :p

606500 is the best score from a user on my forums :bunny:

* Schorsch doesn't even get in 10th level :paranoid: :disappointed: *g*

[Heineken77]

Nice job!!! I would love this hack, however I'm stuck on the loading screen. It starts to load..but just sits there. I see some have had this problem as well. Has there been a fix for this?

My version of vb is 2.2.6

The URL is http://nba2k3.net/forum/tetris.php

Thanks! :)
Heineken

[Castel]

Originally posted by futureal


One of my fellow admins hit 1.1 million last night on vbTetris on my site. The users collectively said "we give up, you ruined it!" :D

You must be running the new version of the tetris.swf file, with a 1000 lines at level 10. That was my gripe in a previous post after John update. I know he is trying to please as many people as possible, bless his soul, but at level 10 you get nearly 1000 points per quick drop and line. You'll eventually see score much higher then that especially since it doesn't speed up.

Maybe one day some1 will be bored enough to make a 1000 lines, that in itself will be 1mil + quick drops. Before my upgrade one of the the players got close to 200k and was about 30k ahead of the 2nd score.

[NexDog]

I think John has replaced that 1000 points a level fla with the old one. :)

[futureal]

Originally posted by john.eovie
Screenshot!!

Here's the link to the leaderboard (which is publicly viewable):
http://www.shadowsofnamek.com/forum/tetris.php?action=leaderboard

That was a real score of over 1,000,000 in vbTetris...

[futureal]

And here's something that could/should be included in the hack.

In online.php, find:


case 'spider':
$userinfo[where] = "Search Engine Spider";
break;


and right above it, add:


case 'tetris':
$userinfo[where] = "Playing <a href='tetris.php?action=play&s=$session[sessionhash]'>Tetris!</a>";
break;


then find:


case '/robots.txt':
$userinfo[activity] = 'spider';
break;


and right above it, add:


case 'tetris.php':
$userinfo[activity] = 'tetris';
break;


Now, when you view the "Who's Online" page, you'll get a nice display of who is playing Tetris.

Here's a screenshot:

[NexDog]

Oh very cool, doing that immediately. :)

[Martin64]

Someone who holds the current 2nd place at my boards with 480k wrote this as his comment:

"Show off..it would be more challenging if there was a level 11"

So does this mean that there is only 10 levels still?

[John]

Originally posted by Martin64
Someone who holds the current 2nd place at my boards with 480k wrote this as his comment:

"Show off..it would be more challenging if there was a level 11"

So does this mean that there is only 10 levels still?

Yes, no-one knows how to add more levels.

[michealo]

how the heck can someone get over a million points in just 10 levels?

i can get in the 130,000's but thats about it

[John]

I'll edit it once I've finished the arcade hack.

[NexDog]

John, how long do ya reckon? Get me on IM......

[John]

Sheesh, patience everyone! ;)

[Ninth Dimension]

all I can say is this, it's looking really good so far. you have done a fantastic job.

[BigJohnson]

Originally posted by john.eovie
I'm going to be developing a store version of the arcade hack - but I'll probably leave the tetris hack as it is.

What do you mean you will leabe the tetris as it is. I am a little lost on what you mean about this. Thank you.

[John]

Originally posted by BigJohnson


What do you mean you will leabe the tetris as it is. I am a little lost on what you mean about this. Thank you.

That I'm going to do a store version of the arcade hack, not a store version of the tetris hack

[xxskullxx]

I just have to say I love your sig, John. :)

[John]

lol, thanks :D

[John]

Ok, there's a problem.

I can't get my head round the whole "display highest scores only" thing (where the member's highest score appears in the leaderboard only.).

I've tried to get help in vBorg, but no-one will help. The people who I have spoken to seem to think it's too difficult. Shall I spend some more time on it, or scrap the idea?

[BigJohnson]

What is wrong with doing a store with the tetris one?

I was waiting for that one. I had my hopes up for that great hack. I would do anything to see that hack.

Why did u change ur mind and deside not to do it?

[Ed FvC]

F it. It's not that important.

[John]

I just thought people would prefer a store add on for the arcade hack, with more games - rather than just the tetris hack.

If there's enough demand, I'll do both.

[John]

Originally posted by Ed FvC
F it. It's not that important.
k :D

If you enable "Record highest scores only" from the start, you essentially get the same thing.

[Lesane]

Originally posted by john.eovie
Ok, there's a problem.

I can't get my head round the whole "display highest scores only" thing (where the member's highest score appears in the leaderboard only.).

I've tried to get help in vBorg, but no-one will help. The people who I have spoken to seem to think it's too difficult. Shall I spend some more time on it, or scrap the idea?

I can look @ it if you want, pm me the problem.

[John]

I'll post the main issue here, so everyone can have a go.

Basically, I need a SQL query that will select the highest score each userid has, and output the records.

So:
1. There's only one record per userid value
2. And the score value that corresponds to the userid is the highest one.

[Lanigironu]

I suppose you could do it the server intensive way by having it go through each member, check if they have a score, and if so get the the highest one. But that might cause problems with bigger boards.

[John]

Already thought of that, it would be VERY server intensive

[Lanigironu]

Then you could just go through the inputted scores, set the score it gets to a variable and just compare it every time it finds another score by that user. If the score it found is bigger than the one in the variable, it replaces it.

I can get you the code for this if you want, but I'll need your table structure.

[Heineken77]

No news on why my screen is stuck on loading...? :(

http://nba2k3.net/forum/tetris.php

[John]

Originally posted by Heineken77
No news on why my screen is stuck on loading...? :(

http://nba2k3.net/forum/tetris.php

Unless you're on a non IE browser, you've probably installed it incorrectly.

[futureal]

Originally posted by john.eovie
I'll post the main issue here, so everyone can have a go.

Basically, I need a SQL query that will select the highest score each userid has, and output the records.

So:
1. There's only one record per userid value
2. And the score value that corresponds to the userid is the highest one.

This only needs a single query. Try this:


$leaderboard_q = $DB_site->query("SELECT game,userid,comment,max(score) as maxscore
FROM arcade
WHERE game='tetris'
GROUP BY userid
ORDER BY maxscore DESC
LIMIT $yourlimit");


That should give you what you need.

I am making a new scoreboard right now that does just this. I'll post a link when it's done.

[John]

I've tried that before, for some reason it returned no records (and yes, there were records in the db) :p

[Lanigironu]

Maybe your syntax was wrong?

[futureal]

That same query works just fine for me. What kind of error is it giving you?

Here it is in action:
http://www.shadowsofnamek.com/forum/tetris.php?action=topscoreboard&s=

I am having way too much fun messing with this leaderboard. I am going to go play a round of frisbee golf, and when I get back I have some more ideas to mess with. :D

[Schorsch]

Originally posted by futureal
That same query works just fine for me. What kind of error is it giving you?

Here it is in action:
http://www.shadowsofnamek.com/forum/tetris.php?action=topscoreboard&s=

I am having way too much fun messing with this leaderboard. I am going to go play a round of frisbee golf, and when I get back I have some more ideas to mess with. :D

I need that urgently!!! how can I do that ?

[John]

Originally posted by futureal
That same query works just fine for me. What kind of error is it giving you?

Here it is in action:
http://www.shadowsofnamek.com/forum/tetris.php?action=topscoreboard&s=

I am having way too much fun messing with this leaderboard. I am going to go play a round of frisbee golf, and when I get back I have some more ideas to mess with. :D

Looking good, given me some ideas for the Arcade hack leaderboards :)

[JJR512]

There are two issues with the actual Flash game (Tetris) I'd like to bring up. One is a suggestion, the other is a possible bug.

1. Suggestion: On the introduction screen (after the Loading), there could be a way to bypass it and go straight to the game. I know it only lasts a few seconds, but when you're on a roll, trying to get the next high score, it's seconds of agony waiting for the game to hurry up and frickin' start. :)

2. Problem: I don't know the level number, but it's the one that starts with a single line going all the way across the screen, closer to the top, with a two-block-wide hole near the middle. If you get a zig-zag-shaped piece right away, and fill in the hole in that line, the line does not disappear right away. The line does not disappear until you drop the next piece. It doesn't matter where you drop the next piece, and obviously, you can't make a solid line with it, but as soon as you drop it, the line you made with the first piece then disappears. I hope you can understand what I'm saying.

[Ninth Dimension]

Re what JJr512 said, I'd noticed this as well, but I think it's designed that way.

[kypdurron]

If Im using Ie6, after playing for awhile, I get a "access denied" error when the game is over...why is that and how can I disable it?