vB Tetris v2.1 Addon - The Tetris King!

This hack
What's this? Another tetris related hack?!

I'm afraid so! This hack will place a picture of a crown next to the username of the member with the highest score (in every one of their posts). When you pass the cursor over the crown, it says "King of Tetris!"


Compatibility issues
If you have my vB Tetris 2.1 hack installed, this hack will work for you.


Testing and installation version
This hack has been tested on a fresh install of vB 2.2.6 both locally and remotely. Should work on 2.x.x versions.


And finally...
Thanks to...
? DestyNova - for coming up with the idea!
? Chen - for pointing me in the right direction

[NexDog]

Yep, did that and it works. Clicks install for the 4th time today.

[John]

:banana:

[DestyNova]

LOL! thanks JohnW :thumbup: I m going definetly use it! :banana:

[michealo]

JW, with this step

In showthread.php 
2. FIND:
###########################

// words to highlight from the search engine

###########################

AND ABOVE IT ADD:
###########################

$leaderboard = $DB_site->query_first('SELECT userid FROM arcade WHERE game = "tetris" ORDER BY score DESC');
$kingid = $leaderboard['userid'];

###########################

i get this error

Fatal error: Call to a member function on a non-object in /home/sites/home/web/forums/showthread.php on line 6

ONLY when clicking on links that contain the "king tetris" member. everything else seems to be fine

[Kars10]

@ Michealo, the same error i get!!
John is watching my showthread.php...hope it works!!

[xxxsaint]

i think that saying this hack needs to go under the tetris thread would be like saying every store related add on for lesane's store needs to go in that thread.

Thanks for the great hack , and this , the great ADD ON !! :thumbsup:

[John]

michealo and Minifreunde -

Change
#########################

$leaderboard = $DB_site->query_first

#########################

to
#########################
$leaderboard = $DB_site->query
#########################

And tell me if it works

[michealo]

no good im afraid

Fatal error: Call to a member function on a non-object in /home/sites/home/web/forums/showthread.php on line 7"

but now no links work, every thread i click gives that error

[kypdurron]

I did that and still didn't work. I think the problem is that it doesn't know what $DB_Site is, not the query itself.
I am using 2.2.5. Is there an "include" command somewhere on your showthread.php before this query?
here is my first few lines of my showthread.php:

PHP Code:

<?php

error_reporting(7);
if ( isset($goto) and ($goto=='lastpost' or $goto=='newpost')) {
  $noheader=1;
}
//$leaderboard = $DB_site->query("SELECT userid FROM arcade WHERE game = 'tetris
' ORDER BY score DESC");
//$kingid = $leaderboard['userid'];

// words to highlight from the search engine

I commented out your code cause it causes the error right now.

[Lesane]

You need to global the function: "$DB_site".